Managing products and portfolios : Financial planning using time grid attribute : Calculating financial information by using business rules : Calculating IRR for a time grid row
  
Calculating IRR for a time grid row
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
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")
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.
See also
MatrixIRR business rule
Calculating financial information by using business rules