Real Estate Investment Trust - 20 Year Financial Excel Model
  • Real Estate Investment Trust - 20 Year Financial Excel Model
  • Real Estate Investment Trust - 20 Year Financial Excel Model
  • Real Estate Investment Trust - 20 Year Financial Excel Model
  • Real Estate Investment Trust - 20 Year Financial Excel Model
  • Real Estate Investment Trust - 20 Year Financial Excel Model
  • Real Estate Investment Trust - 20 Year Financial Excel Model
  • Real Estate Investment Trust - 20 Year Financial Excel Model
  • 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
certified

Real Estate Investment Trust - 20 Year Financial Excel Model

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

cap ratefinancial modelnet operating incomereal estate investment trustreal estate modelreit

Description
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 business tool includes
1 Excel template

Acquire business license for $35.00

Add to cart

Add to bookmarks

Discuss

Further information

Planning out possible scenarios for a REIT.

A REIT only.

Anything that is not a REIT.

Reviews

  • No review yet!

keyboard_arrow_leftkeyboard_arrow_right

More tools from Jason Varner

See all
keyboard_arrow_leftkeyboard_arrow_right

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

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

please wait...