Exclusive to our readers, you can instantly view & download our latest range of investment spreadsheets and landlord templates by clicking on the links below.
Buy-to-Let Investment Spreadsheets
A very useful spreadsheet for those interested in buy-to-let or commercial property as an investment. Estimate the return on capital for almost any scenario. Determine when it pays to borrow and use gearing to enhance your return. Also includes two sheets with after tax figures for each year of ten.
A dynamic example of how to build up a portfolio of 16 commercial properties over twenty years using mortgages and re-invested rental income and, given accurate assumptions, immediately calculate the estimated overall outcome. *PLEASE NOTE CURRENT MARKET RATES MAY DIFFER FROM THOSE ILLUSTRATED.
Mortgage & Loan Calculators
Choose first whether to buy or rent a house by entering your own ideas for the future. An immediate graph indicates when the optimum break even point occurs in terms of how long you stay in the property.
A simple spreadsheet to illustrate the use of formulae in basic loan calculations using terms in months.
Use this to accurately compare any two mortgage or loan products using the IRR (Internal Rate of Return) method. Calculates APR as well and supports up to two interest rate changes, illustrating the monthly payments. Probably the most useful spreadsheet of all for serious mortgage seekers. Also calculates ‘cash now’ equivalent to compare the best buy.
A simple spreadsheet to illustrate the use of formulae in basic mortgage calculations using terms in years.
A simple spreadsheet to calculate the mortgage advance to match what you can afford each month and an indication of the income you need.
Understand how this very flexible mortgage operates. Choose any monthly payment, credit or debit and graph the full results.
Enter your own mortgage payment schedule and future interest rates: see some examples of how to use a flexible mortgage.
List and graph any monthly mortgage payment schedule against property equity with any interest rate or growth rate in each year: ideal for calculating new payments when changing from interest-only to capital repayment after a period.
Other Useful Tools
A general-purpose Annual Percentage Rate Calculator, illustrating the use of ‘goal seek’ with two tabs, it is designed for both long term mortgages and shorter term loans where there may be an interest rate change every year, and some regular one-off monthly or annual fees or charges. The Macro Button automates the process for the mortgage calculations – Macros must be enabled – not required for the loan calculations.
Take any project with monthly cashflows and calculate the IRR
Landlord Templates
Available to print out and use, this Tenancy Agreement form in PDF format is a law abiding production for landlords and tenants to fill out upon agreement of letting a residential dwelling.
Available to print out and use, this Section 8 notice of possession form in pdf format is a law abiding production for landlords/licensors seeking possession of a property let on an Assured Tenancy or Assured Agricultural Occupancy.
Available to print out and use, this Section 21 notice of tenancy termination (fixed term) is a law abiding production for landlords to fill out and send to tenants giving at least 60 days notice of requiring possession of the property/dwelling in question.
Available to print out and use, this Section 21 notice of tenancy termination (periodic) is a law abiding production for landlords to fill out and send to tenants giving at least 60 days notice of requiring possession of the property/dwelling in question.