The Eagle Performance IRR is designed to:
Set known calculation limits that return null results if violated
Support periods greater than one month
Support both cumulative and annual IRR calculations
Enable you to verify all IRR results in Microsoft Excel
Bisection is used as the sole IRR calculation method. A null is returned for IRRs outside of the range 1,000,000,000 percent and 100 percent. Using an upper limit that is not a function of the number of days in the period and periods greater than a month is supported. An additional option in the IRR calculation supports annual IRRs. All returns calculated using IRR can be tied out in Excel by using Goal Seek, Solver, and XIRR.
IRR Formula
The formula for the basic IRR calculation is:
MVE = MVB x ( 1 + IRR ) + CF1 x ( 1 + IRR ) W1 … + CFn x ( 1+ IRR ) Wn
where:
MVE – Market value ending
MVB – Market value beginning
IRR – Cumulative Internal Rate of Return
CF – Cash flow amount
W – Weight = ( Number of Days Cash Flow is Present ) / ( Num of Days in Period )
As always, the time-of-day assumption is factored into the number of days present.
Input Validation
Some cases cannot be solved using IRR and as a result, return null values. A check of calculation inputs returns a null value in the following scenarios:
No data found
BMV and EMV are null and there is not at least one positive and one negative cash flow
Positive BMV, positive cash flows, and negative EMV
Negative BMV, negative cash flows, and positive EMV
Positive BMV, no cash flows, and negative EMV
Negative BMV, no cash flows, and positive EMV
No BMV, positive cash flows, and no EMV
No BMV, negative cash flows, and no EMV
An input validation in the IRR calculation avoids solving for a zero return. If the beginning market value plus sum of cash flows is equal to the ending market value, the Bisection algorithm is bypassed and a return of zero is returned.
0 Comments