Calculating IRR for a time grid row

You can use the TimeGridIRR business rule to calculate the internal rate of return 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 IRR is automatically updated.

Before you begin

To use the TimeGridIRR business rule, you need the following information:

Procedure

  1. Create a float attribute.
  2. In the float attribute, enter your business rule in the following format:
    =TimeGridIRR('Time Grid Attribute Name',"Time Grid Attribute Name", "Sheet Name", "Row Name")
  3. Click Save.

Results

The IRR of the time grid row is calculated and displayed as a decimal number in the float attribute.

Example

From the Financial time grid attribute, you can calculate the IRR for the period 2010-01-01 to 2011-12-31 of the Net Cash Flow row in the Budget sheet, starting in cell A13. To do so, use the following expression:
=TimeGridIRR('Financials', "Financials", "Budget", "Net Cash Flow", "2010-01-01", "2011-12-31")
Tip: To display the IRR with a smaller number of decimals than the default for a float attribute, you can use the round operator. For example, to display 0.25 rather than 0.25345678:
=round(100* (TimeGridIRR('Financials',"Financials","Budget","Net Cash Flow")/100)

What to do next

Compare the IRRs of different projects in a portfolio.

Feedback