Rental Property Calculator Spreadsheet – Yield, Cash Flow, Mortgage Amortisation & Stress Test + Guide

Analyse a rental deal: yields, cash flow, cash-on-cash, DSCR, a mortgage amortisation table, a 5-year projection, a stress test and 3-deal comparison.

Instant digital download.

Instant download: by buying, you ask for the file to be delivered straight away and agree that you lose your 14-day right of withdrawal once the download is made available. Faulty files are still fixed, replaced or refunded.

Personal use: print for your own home. Please do not resell or share the file.

Created with AI assistance. Tax rates quoted are as of October 2026 (Portal das Finanças, gov.uk); rates and rules change, so check current official rules before relying on them.

Educational only. Not financial, investment, mortgage, tax or legal advice, and not a recommendation to buy any property. No income, yield, growth or return is guaranteed; the examples are illustrative and calculator results are estimates only. Consult a qualified, regulated adviser before you commit.

Fernbrook Guides is not affiliated with or endorsed by the Portuguese Tax Authority (AT), HMRC, GOV.UK, Microsoft (Excel), Google (Sheets) or LibreOffice; names are used for information only.

Price includes VAT where applicable.

Refunds: if you're not happy for any reason, ask for a full refund within 14 days of purchase. If a file is faulty, we fix it, replace it or refund you. Your legal rights are not affected.

Support: teamaijjgroup@gmail.com

Tax examples cover mainland Portugal and England & Northern Ireland only. Other regions and countries use your own figures.