Real Estate Build to Rent (BTR) Development Model

Description
This template is a real example of a Build To Rent Development scheme which has been modeled with the objective of providing a complete understanding of the entire lifecycle of a BTR development, from acquisition to full-exit, using real assumptions and easy formulas for a better functionality.




The Model Contains:


Worksheet 1: 
- Key Assumptions (areas,unit mix,land&construction costs, planning, BTR operating assumptions, debt structure, Taxes)
- Key Metris (financial returns, debt ratios, yield ratios)
- Sensitivity analysis


Worksheet 2: Annual CF

- Development structure
- BTR operating structure
- Unlevered CF
- Debt structure
- Levered CF


Worksheet 3: Monthly CF
- Development structure
- BTR operating structure
- Unlevered CF
- Debt structure
- Levered CF


The model has the philoshopy of "less is more" to make it simple to manage, however, all the key metrics any investment firm may look for are included.