The Internal Rate of Return (IRR)
is a financial metric that indicates the rate of return used in capital
budgeting to measure and compare the profitability of investments.
You can use the TimeGridIRR business rule to calculate the IRR 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)
Compare
the IRRs of different projects in a portfolio.