Calculating the NPV for a time grid row

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:

Procedure

  1. Create an integer attribute.
  2. Enter your business rule in the following format:
    =TimeGridNPV('Time Grid Attribute Name',"Time Grid Attribute Name", "Sheet Name", "Row Name", 'Rate Reference')
  3. 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.

Feedback