Rental Property Excel Model Template

Description
Rental property investment model for assessing potential property investments and understanding the potential return profile.

Model contains the following revenue profile:
Monthly rental incomes - set on an annual basis (can therefore increase rents each year). Also includes the option to add management fees.

Model includes the option to add debt for the property purchase. The debt has the ability to charge interest only or capital and interest repayment. The mortgage can have a fixed initial period at one interest rate and a different rate thereafter. The model contains a macro for these calculations

Outputs include a dashboard of summary results. Additionally, there is a results page that includes both monthly and annual financial statements for the project. Additionally, this contains a variety of useful key performance indicators for property investment.

Other assumptions include (though not an exhaustive list):
- Property purchase assumptions
- The ability to include both historic and forecast assumptions
- Various purchase fees
- Capital growth assumptions
- Property purchase taxes
- Ongoing taxes and sundry costs

The model is simple to use. The user only needs to enter their assumptions into the yellow cells and historic balances into the orange cells. There is no particular need to understand the calculations - however, users are more than free to investigate!