You can use the TimeGridNPV business rule to
calculate the net present value of a time grid row. You might use
this information to represent the net costs and benefits over time
in a project. The result is displayed in the business rule container
attribute. If the values in the row change, the NPV is automatically
updated.
Before you begin
To use the TimeGridNPV business rule, you need the following
information:
- The names of the time grid attribute, sheet, and row to calculate
the NPV for.
- The rate, either as a reference to an attribute where the rate
is stored, or as a number, "0.05" or "5%".
- The start date and end date, either as references
to attributes containing start and end dates, or on the format "YYYY-MM-DD".
If you do not specify a start or stop date, the entire row is used.
Procedure
- Create an integer attribute.
- Enter your business rule in the following format:
=TimeGridNPV('Time Grid Attribute Name',"Time Grid Attribute Name", "Sheet Name", "Row Name", 'Rate Reference')
- Click Save.
Results
The NPV of the time grid row is calculated and displayed in
the integer attribute.
Note: NPV is calculated as a decimal. To display
the NPV as a decimal, enter the business rule in a float attribute
instead.
Example
From the Financial time grid attribute, you can calculate
the NPV of the Net Cash Flow row in the Budget sheet. In this example,
the calculation starts in cell A13. The calculation is based on the
internal rate that is specified in the Internal Rate attribute in
the Rate element in the Project module:
=TimeGridNPV('Financials', "Financials", "Budget", "Net Cash Flow", 'Project!Rate!Internal Rate')
What to do next
Compare the NPVs of different projects in a portfolio.