Mortgage
Modelling
Repayment estimates for interest-only and capital & interest loans.
Property Investment Forecaster
Model mortgages. Forecast cash flow. Evaluate investments. Across countries.
An Excel-based modelling tool for property investors and homebuyers. Analyse mortgages, rental income, costs, cash flow and returns with country-specific rules and assumptions.
Mortgage
Rental Income
Analysis
Model rental income, vacancy, fees and ongoing costs.
Cash Flow
Forecasting
Monthly and annual cash flow projections and summaries.
Investment
Metrics
Yields, returns and performance indicators at a glance.
Multi-Country
Support
Country-specific taxes, fees, costs and rules built in.
Input-Led
Model
Simple blue-cell inputs. Clear, structured outputs.
How To Use
Enter Property Details
Add purchase price, deposit, loan amount, term, rate and rental income assumptions.
Enter Mortgage Assumptions
Set interest rate, term, repayment type, frequency and any fees or charges.
Enter Rental Assumptions
Add rent, vacancy, management fees, maintenance, insurance and other costs.
Enter Country Rules
Review and complete country-specific taxes, fees, costs and local assumptions.
Review The Summary
Check mortgage payments, cash flow, yields and investment performance metrics.
Only complete the blue input cells. Results are estimates only and are not financial, tax, legal or investment advice.
Resources & Links
Readme
Overview, features and how to use the calculator.
User Instructions
Step-by-step guide for using the workbook correctly.
Disclaimer
Important information, limitations and warnings.
License
Custom non-commercial licence terms.
Contributing
How to contribute, report issues and suggest improvements.
Support
Get help, ask questions or raise an issue.
Security Policy
Security, privacy and safe use information.
Release Notes
Details of the latest release and changes included.
Download Workbook
Property Investment Calculator v1.0.0 Excel workbook.
View the project on GitHub
Source code, documentation and all project resources are available in the repository.
View On GitHub