Rental Property Budget Template for Landlords (Excel)

Track income, expenses, and cash flow for your rental property — automatically.

Built for independent landlords who are tired of guessing whether a property is actually making money. Log each transaction once, and this workbook rolls it up into a monthly budget, an annual dashboard, and the three numbers investors and lenders actually ask about: Cap Rate, Cash-on-Cash Return, and Debt Service Coverage Ratio.

What's inside

• How to Use — a plain-English setup walkthrough, no experience required
• Property & Assumptions — enter your purchase price, financing, and rent once; your mortgage payment, cash invested, and financing figures calculate automatically
• Income & Expense Log — one place to record every transaction, with a built-in category dropdown
• Monthly Budget — income and expenses totaled by month automatically, with net cash flow front and center — zero manual math
• Annual Dashboard — full-year totals plus Cap Rate, Cash-on-Cash Return, and Debt Service Coverage Ratio, with monthly cash flow and income-vs-expense charts
• Prefilled with a realistic sample year so you can see exactly how it works before you clear it and enter your own numbers

Who it's for

Landlords and small-portfolio investors who want a clear, honest picture of a

single rental property's performance — without building a spreadsheet from

scratch or paying for property management software.

Format

• Microsoft Excel (.xlsx) — fully editable, formula-driven, works in Excel or Google Sheets
• Step-by-step README included

No macros, no subscriptions, no login required. Download and start entering your numbers today.