What does the rental property spreadsheet calculate?

Mortgage payment, effective income after vacancy, operating expenses, net operating income, monthly and yearly cash flow, cap rate, cash-on-cash return, rent-to-price ratio, debt service coverage ratio and break-even occupancy.

How is the cap rate worked out?

Yearly net operating income divided by the purchase price. NOI is income after vacancy minus operating expenses, before the mortgage.

Does it handle cash purchases and 0% loans?

Yes. Set the down payment to 100% for an all-cash purchase (the mortgage becomes 0), and a 0% rate divides the loan evenly over the term.

Does it work in Google Sheets?

Yes. Upload the .xlsx file to Google Drive and open it with Google Sheets. It uses no macros or add-ons.

Can I track more than one property?

Make one copy of the file per property, or download it again with a different property name.

Rental Property Spreadsheet - Cash Flow & Cap Rate Calculator

Rental property spreadsheet for cash flow, cap rate and returns

Type the purchase price, loan terms, rent and running costs of a property. The spreadsheet works out the mortgage payment, net operating income, monthly cash flow, cap rate and cash-on-cash return straight away.

Once you own it, log rent and bills in the ledger and the monthly summary shows income, expenses and net for each month of the year. Excel and Google Sheets, real formulas, no macros.

Rental property analysis before you buy

Compare deals on the same terms. The analysis tab shows the down payment, loan amount, total cash invested, principal and interest payment, effective income after vacancy, operating expenses, NOI, cash flow, cap rate, cash-on-cash return, the rent-to-price ratio behind the "1% rule", the debt service coverage ratio and break-even occupancy.

Mortgage payment from rate and term
NOI and monthly cash flow
Cap rate and cash-on-cash return
DSCR and break-even occupancy

Rental income and expense tracker for landlords

The ledger takes a date, a category such as rent, repairs or property tax, whether it is income or an expense, and the amount. The monthly summary adds them up by month for the year you choose, ready for your bookkeeping or your tax preparer.

Rental property calculator in Excel or Google Sheets

Every result is a visible formula, so you can check how it is worked out. Change the vacancy, maintenance or management percentage to stress-test a deal. The numbers are estimates from what you type, not financial or tax advice.

How it works

Pick a design and open it in the editor.
Change the text and colors. The preview is free and shows a watermark.
Pay once with a card through Stripe and download the clean file right away.

Ready when you are

Try it free, pay only for the clean file.

Start editing free