Real Estate Investment Trust - 20 Year Financial Excel Model
Originally published: 09/05/2018 14:27
Last version published: 25/06/2018 13:29
Publication number: ELQ-85435-3
View all versions & Certificate

Real Estate Investment Trust - 20 Year Financial Excel Model

A 20-Year model with easy plug-in assumptions to test various scenarios.

This is an annual model that runs for 20 years. It is based on capital deployment in a 4-year span. You then have an auto-filled net operating income that ties to the total capital deployed for each year. That will then grow at a defined % rate moving forward.

Debt can be structured as a bond or loan and there can be up to 5 loans.

The model starts off at net operating income and flows down through to debt service, dividends, and retained earnings. It will show a cumulative effect of the cash flows and an IRR/NPV of the case.

Other metrics include net asset value (NAV) over time as well as loan to value (LTV).

This Best Practice includes
1 Excel template

Acquire business license for $35.00

Add to cart

Add to bookmarks


Further information

Planning out possible scenarios for a REIT.

A REIT only.

Anything that is not a REIT.


  • Rate this Downloadable Best Practice

    Write a review

  • Mamoun Abusaad(last updated: 02/02/2020 11:41)


More Best Practices from Jason Varner

See all

Any questions on Real Estate Investment Trust - 20 Year Financial Excel Model?

The user community and author are here to help. Go ahead!

5.0 / 5 (1 votes)

please wait...