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:
- The names of the time grid attribute, sheet, and row to calculate
the IRR for.
- The start date and end date, either as references
to attributes containing start and end dates, or in the format "YYYY-MM-DD".
If you do not specify a start or stop date, the entire row is used.
Procedure
- Create a float attribute.
- 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")
- 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.