Configuring a time grid for financial analysis

To use a time grid with investment analysis, you must have a time grid that is configured with separate sheets to store the low, likely, and high estimates to use for the financial analysis. All of these sheets must share the same time interval, start date, and end date.

About this task

The rows of the time grid store the estimates for the costs and benefits of the model. You must determine the costs and benefits that your model requires and add a row to the time grid for each cost or benefit.

Procedure

  1. Select a time grid attribute.
  2. Add the sheets to store the high, likely, low, and actual value estimates.
    1. To add each sheet, click Add Sheet.
    2. For each sheet, set the appropriate scenario type: High, Likely, Low, or Actual.
  3. Click Add Row and add a row for each cost or benefit in your model.
  4. Indicate if a row represents a cost or benefit by selecting the Cost or Benefit flags.
  5. Select Allow graphical editing.
  6. Click OK.

Feedback