REIT (Real Estate Investment Trust) Ramping Model


This model is from the perspective of the Equity investor’s position in a 20 year REIT deal that has multiple equity and debt deployments in the first 5 years and then cash flows following.

This is for ramping, so in the first 5 years you can define various debt and/or equity deployments. The NOI (net operating income) will be determined by total deploymnets each year (per starting cap) and then a defined inflation rate from there on out for each deployment round (up to 5).

You can have more than one building per year, but this top-down style model will assume the NOI is a blanket number based on total capital deployed each year in the first 5 years.
i.e. if you deploy 100mm in year 2 across 3 different properties, the NOI will be an aggregate of all 3 based on the total cost and starting cap defined.

The debt is a defined % of equity per year. You can easily change this by manually entering figures into column Z instead of letting it use the debt to equity % defined in B10.

Debt can be toggled between either everything being a bond with a fixed interest payment and redemption at year 20, or p+I loans where you define the terms of each loan in tabs Loan1-Loan5.

Note, the loans in each tab will define their loan amount based on the total debt that is used in each of the first 5 years. i.e. loan1 starts in year 1, loan2 starts in year2, etc…

The aggregate effect of all 5 loans is accounted for in the ‘Amortization by year’ which tracks principal + interest payments and total outstanding balance. This allows for a proper cash projection at the exit year.

r9 r8 r7 r6 r5 r4 r3 r2 r1

Users who purchased REIT (Real Estate Investment Trust) Ramping Model, also purchased:
Residual Land Value Calculation
Add to wish list
Purchase Excluding 7.7% tax
Restaurant Chain Valuation Model
Restaurant Chain Valuation Model
Add to wish list
Purchase Excluding 7.7% tax
Cleaning and Janitorial Services Business Plan
cleaning business model
Add to wish list
Purchase Excluding 7.7% tax
Industry ,
Summary A top-down based financial model to plug in various assumptions about multiple real estate investments and see the resulting effects over 20 years.
Screenshots / Pictures REIT Ramping Model
Capital Deployment Through Year 5
Ramping Model
Real Estate Investment Trust Ramping Trust
Real Estate Investment Trust
Annual Cash Flow to Accumulated Cash
Retained Earnings
REIT Ramping Model
Use Cases , , , , , , , , , , , , , , , , , , , , , , , ,

Write a Review

Get these templates too for a discount!

Price: $200.00

This is a collection of financial model templates for Real Estate businesses and its related sectors. The models included in this bundle are the following (all Excel models): Joint Venture / WaterFall Real Estate Financial…

Add to wish list
Add to cart Excluding 7.7% tax