The Real Estate Model Template contains the following sheets and sections:
- Monthly Cash Flow Monthly Model with Debt: The Template splits the forecast of Revenues and Costs into Rental and Sales sections. It also links the Capital Expenditure to the build progression.
- Debt Model: The spreadsheet calculates debt financing and repayments based on an assumed term and interest rates. The model sets the amount as a percentage of the build cost.
- Balance Sheet and Profit & Loss Summary: The Template breaks down the Net Income, Assets and Liabilities by Rental and Sales Properties. It also includes monthly depreciation calculations.
- Return on Investment and Sensitivity Analysis: The spreadsheet analyses the Return on Investment based on the rental yield assumptions. It also uses Excel’s data table to test the impact of the main inputs on the model’s output.
Click on product images for screenshots of the template.