Use of debt financing is a standard practice in the real estate investing; and is often referred to as leveraging. Debt financing is used by the equity holders to enhance the equity return; however, debt financing can also magnify the severity of capital loss if the property value declines.

Let's look a case study to explore this further; we shall use simpler set of assumptions for the sake of ease.

Consider a property with an acquisition cost of $10,000,000. Property is assumed to yield $700,000 in annual rent throughout the holding duration (no escalation!). Assume the property is sold at the end of fifth year for a price of $14,000,000 i.e. 40% appreciation or capital gain.

Assume that the property acquisition is 100% funded by equity. The project IRR and equity IRR will same in this case; and it will be 13.2%. Cash flow for this case is given below:

Now assume that the property is financed 40% by debt and 60% by equity; the cost of debt is 6%. You can see below that the project IRR remains at 13.2% however the equity IRR shoots up to 15.4%.

Equity return is magnified by introducing debt financing!

Now consider an altogether different scenario. Assume 40% depreciation in the property price at exit. Keep debt at 40% and equity at 60%.

You can see the equity IRR is much lower than project IRR; debt financing has inflated the extent of capital loss as the property value declined.

I must stress here again that debt is a double-edged sword.

I did few simulations with various combination of debt:equity ratios and exit values, the graph is plotted below:

Hope you enjoyed this post, use the comment section below to let me know your thoughts on the use of debt financing in real estate investments.

You might like to refer the impact of cost of debt on the project and equity IRRs.

You can also download the interactive Excel spreadsheet containing this example of debt financing to explore it yourself.

Hi Naiyer,

first i’d like to thank you for this helpful post.

second: when you calculated the equity irr using the 60% equity and 40% debt mix and assuming a capital appreciation of 40% after 5 years you ended up with 15.4% equity irr, while the simulation you undertaken (graph) shows that the equity irr exceeds 40% for the same assumptions!

am i right or there is something that i have not noticed.

thanks again and regards.

hassan

Thanks Hassan for pointing that. There was an error in the graph and the same has been rectified. I’m glad you liked this post.

Hi Naiyer,

first i’d like to thank you for this helpful post.

second: when you calculated the equity irr using the 60% equity and 40% debt mix and assuming a capital appreciation of 40% after 5 years you ended up with 15.4% equity irr, while the simulation you undertaken (graph) shows that the equity irr exceeds 40% for the same assumptions!

am i right or there is something that i have not noticed.

thanks again and regards.

hassan

Thanks Hassan for pointing that. There was an error in the graph and the same has been rectified. I’m glad you liked this post.

Hi Naiyer thank you for the post. how about the scenario where the equity is injected in several chunks e.g.: year 1 40%, year 2 60% – how do I illustrate it in the equity CF and calculate equity IRR?

In addition, if there is a equity payback and dividend payment at year 5, should these be captured to calculate equity IRR as well? Thank you and look forward to hearing from you.

Thanks Sandra for stopping by on my blog. Equity IRR calculation will be same, even if the equity is injected in several tranches.

Yes, any equity payback or dividend payment must be considered in calculating equity IRR.

Hi Naiyer thank you for the post. how about the scenario where the equity is injected in several chunks e.g.: year 1 40%, year 2 60% – how do I illustrate it in the equity CF and calculate equity IRR?

In addition, if there is a equity payback and dividend payment at year 5, should these be captured to calculate equity IRR as well? Thank you and look forward to hearing from you.

Thanks Sandra for stopping by on my blog. Equity IRR calculation will be same, even if the equity is injected in several tranches.

Yes, any equity payback or dividend payment must be considered in calculating equity IRR.

hi

while doing small projects the cash flows overlap in a way each year tends to show a positive net cash flow. How to handle this type of situation.

hi

while doing small projects the cash flows overlap in a way each year tends to show a positive net cash flow. How to handle this type of situation.