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