Leveraged IRR Calculation

A leveraged IRR calculation (or levered IRR) is required when evaluating a real estate investment in which the investor intends to borrow a percentage of the money required to acquire the property under consideration. The IRR or internal rate of return is a central concept in Real Estate Investment Mathematics!

Real Estate Investment Mathematics!
ALL THE FORMULAS YOU NEED! Download it Now!

If the investor has determined, for whatever reason that the use of debt (borrowed money) is out of question, there is no need for calculating a leveraged IRR. A leveraged IRR is the internal rate of return (IRR) of the investment, taking into account the effect of borrowed funds on the investment’s cash flow.

Search Our Over 150-Page Website!

Custom Search

The internal rate of return is defined as the discount rate that renders the present value of all cash flows expected to be received over the holding period of the investment equal to the equity contributed by the investor at the time of the purchase. A leveraged IRR calculation, therefore uses the discounted cash flow model (DCF) and takes into account, in addition to the cost and revenue items taken into account in an unleveraged IRR analysis, the debt service payments to service the loan over the holding period, as well as the repayment of the remaining loan balance upon the sale of the property. Furthermore, it takes into account any taxable income deductions that the owner may be entitled due to interest payments for the loan.

One of the significant unknowns in the calculation of the leveraged IRR (and the unleveraged IRR) is the resale price of the property under consideration at the end of the holding period. The most commonly used technique for the estimation of this resale value is the forecast of an exit cap rate which is applied to the net operating income (NOI) of the last year of the holding period. The exact formula applied is:

Terminal Value = NOI/Exit Cap Rate

Property Investing for Double-Digit Returns !!
Download it Now RISK-FREE!

Usually the assumed exit cap rate is higher than the entry cap rate in order to reflect the uncertainty of future cash flows. The entry cap rate is calculated as the ratio of acquisition price over the property’s actual NOI at the time it is purchased.

Property Investing for Double-Digit Returns!

IRR, MIRR, FMRR, ROE, and many more!
Get them all in 30-page E-book

Problems of Leveraged IRR Calculation

One of the potentially problematic assumptions of the leveraged IRR calculation is the reinvestment assumption. In other words, the formula for the calculation of the IRR incorporates the assumption that all positive cash flows in any period are reinvested at the same rate as the calculated IRR. For example, an estimated IRR of 150% implies the expectation that all positive cash flows received at any period will be re-invested immediately at a rate of return of 150%. However, this assumption maybe very unrealistic if the investor does not have immediately available investment vehicles that will be providing a 150% return upon investment of the money.

Modified IRR Calculation

If the investor feels that he/she cannot reinvest all positive cash flows immediately as they are received at an immediately accruing rate of return equal to the esimated IRR then the leveraged IRR calculation needs to use the so called «modified IRR» (MIRR) formula, which takes into account that all positive cash flows are reinvested at a different rate than the IRR of the investment analyzed. The MIRR allows you to enter a different reinvestment rate that is applied to the property's annual cash flow. The rate used is generally a savings rate or a government bond rate. Using the MIRR more closely reflects reality as it is rarely possible to reinvest the cash flow from a particular project at the same exact rate of return as determined by the IRR formula.

The MIRR calculation involves the following three steps:

1. Find the present value of negative cash flows incurred in any year during the course of the investment, discounting them at the annual interest rate that you would pay to cover any negative cash flows incurred during the life of the investment (finance rate)

2. Calculate the future value of positive cash flows incurred in any year during the holding period of the investment, by growing them at the interest rate expected to be earned on cash generated by the investment (Reinvestment Rate). This re-investment rate can be the government bond rate, or another rate depending on each investor’s availability of immediately available investment opportunities

3. Calculate the average interest rate that grows the adjusted investment as calculated in step 1 into the adjusted amount as calculated in step 2

The MIRR calculation process, is explained in more detail, including the specific formulas that are used in each of the three steps and a numerical example, in the e-book "Real Estate Investment Mathematics" by Petros Sivitanides, Ph.D. In addition to the MIRR, the e-book discusses and presents formulas and examples for several other return measures that can be used for the assessment of real estate investment performance.

Related Posts
Capitalization Rate Estimation Techniques
Capitalization Rates and Interest Rates
Capitalization Rate Data Sources
Capitalization Rate Influences

Search Our Over 150-Page Website!

Custom Search

Return from Leveraged IRR Calculation to Mortgage

footer for leveraged IRR calculation page

LEVERAGED IRR CALCULATION

Problems of Leveraged IRR Calculation

Modified IRR Calculation