Property Investment Cash Flow & IRR (10 Years) – Excel Template

Model a buy-to-let over 10 years: rent, costs, mortgage and sale, with yearly cash flow, total profit and IRR.

• Automatic summary: Cash invested upfront, Loan amount, Monthly mortgage payment, Total profit over 10 years, IRR, Year-1 cash-on-cash return
• Calculated for you: Year, Net rent, Mortgage payments, Sale proceeds (net of loan), Net cash flow, Cumulative cash
• Colour-coded status and progress highlights
• Built-in chart that updates as you type
• Example rows and a step-by-step "How to Use" sheet

Instant download (.xlsx). Works in Excel 2010+, Excel online, Google Sheets, Numbers and LibreOffice. Works with any currency.