Ultimate Template - Excel & Google Sheets

Ultimate Rental Property Cashflow Spreadsheet Template for Google Sheets & Excel

Up to five properties, each with its own column of assumptions, listed with rent, cashflow, NOI, cap rate and cash-on-cash, and a portfolio cap rate alongside each property's own. The Ultimate Rental Property Cashflow spreadsheet template works the mortgage payment out from the loan, rate and term, counts total cash invested including closing costs and refurbishment, and adds ROI and sensitivity sheets. Google Sheets and Excel, one file. No macros, no VBA.

See Preview

Rental Property Cashflow Spreadsheet Template - Ultimate version for Google Sheets and Excel

What's Included

Up to five properties, each with its own column of assumptions
A portfolio cap rate alongside each property's own
Every property listed with its rent, cashflow, NOI, cap rate and cash-on-cash
The mortgage payment worked out from the loan, rate and term
Total cash invested including closing costs and refurbishment
Gross rent multiplier, for comparing properties before the detail is in
The rent actually received, by property, across the twelve months
A sensitivity grid moving rent against vacancy for monthly cashflow
A second grid moving rent against property value for cap rate
Works in Microsoft Excel and Google Sheets with no macros required

The FinancialAha Ultimate Rental Property Cashflow Spreadsheet Template for Google Sheets and Excel is a six-sheet workbook carrying up to five properties, with a How to Use guide on a seventh tab. It ships as an Ultimate Rental Property Cashflow Excel template and an Ultimate Rental Property Cashflow Google Sheets template in one file. This Ultimate Rental Property Cashflow spreadsheet template reports each property and the portfolio together, works out returns from what a purchase actually cost, and puts sensitivity grids behind the answer. No macros, no VBA.

Inside the workbook

What's inside the FinancialAha Ultimate Rental Property Cashflow spreadsheet template

The FinancialAha Ultimate Rental Property Cashflow Spreadsheet Template runs on six working sheets - three you fill in, three that report back - plus the guide. It works in both Microsoft Excel and Google Sheets and here is what the Ultimate Rental Property Cashflow spreadsheet holds.

01 of 06

Dashboard

The portfolio in six figures: monthly cashflow, annual net operating income, total income, the portfolio cap rate, cash-on-cash return and total annual expenses. Beneath it every property is listed with its own rent, cashflow, net operating income, cap rate and cash-on-cash. A portfolio figure alongside the individual ones is the useful arrangement, because one strong property can carry a weak one for a long time before anyone notices which is which. Two charts sit alongside.
02 of 06

Property Setup

Up to five properties, each a column of its own: what it cost, the deposit, the loan and its rate and term, what it is worth now, the rent and the vacancy rate. The monthly mortgage payment is worked out from the loan rather than typed. Expense assumptions sit beneath - tax, insurance, association dues, maintenance and management as percentages, utilities and anything else.
03 of 06

Income & Expenses

Monthly income and expenses per property with a portfolio total down the side. Laying the properties out as columns rather than stacking them is what makes them directly comparable line for line - one property's insurance against another's, rather than two separate sheets to flick between.
04 of 06

Monthly Cash Flow

The rent actually received, by property, across the twelve months. Projections assume a rent arrives every month; this is where the ones that did not show up, and a property that quietly underperforms across a year becomes visible.
05 of 06

ROI Calculator

What each property really cost to get into - price, deposit, closing costs and any refurbishment - and what that total has earned. Cap rate and cash-on-cash appear here alongside the gross rent multiplier, which is the quick comparison figure used when two properties are being weighed against each other before the detail is available.
06 of 06

Sensitivity Analysis

Two grids rather than a single answer. The first moves rent against vacancy and shows what monthly cashflow does across the whole range; the second moves rent against property value and shows the cap rate. A model gives one number for one set of assumptions, and a grid shows how much of the answer depends on assumptions that were only ever estimates - which is where the point of no cashflow actually sits.
Included guide

How to Use

A step-by-step guide on its own tab, covering setup, how each metric is built, and how to read the two sensitivity grids. Because it ships inside the file, the instructions travel with the template wherever it is opened.

Works in both Google Sheets and Excel

Ultimate Rental Property Cashflow Spreadsheet template for Google Sheets

Upload the Ultimate Rental Property Cashflow Spreadsheet Template to Drive, right-click it, and choose "Open with Google Sheets". This Ultimate Rental Property Cashflow Google Sheets template needs no conversion step and both charts survive the trip intact. The cross-sheet references that build the dashboard and the return figures rely on the existing tab names, so those are worth leaving alone.

Ultimate Rental Property Cashflow Google Sheets template setup

A shared copy of the Ultimate Rental Property Cashflow Google Sheets template suits properties held between partners, or a portfolio reviewed with an accountant, since every assumption behind every return figure is visible rather than buried in a formula. Sheets version history covers a rate typed over.

Sharing the Ultimate Rental Property Cashflow Google Sheet

The Ultimate Rental Property Cashflow Google Sheet is built for two rhythms: rent recorded month by month as it arrives, and longer sittings with the ROI and sensitivity sheets when a property is being bought, sold or refinanced.

Ultimate Rental Property Cashflow Spreadsheet template for Excel

The Ultimate Rental Property Cashflow spreadsheet Excel download is a plain .xlsx. Excel opens this Ultimate Rental Property Cashflow Excel template directly, with no import step and no compatibility prompt, and both charts are native Excel charts that redraw as the inputs change. There are no macros and no VBA in the file, so it opens without a security warning.

Ultimate Rental Property Cashflow Excel template setup

The same Ultimate Rental Property Cashflow Excel template opens in Excel on Windows, Excel on Mac, and Excel for the web. It is also the identical file you would upload to Drive, so there is no separate Ultimate Rental Property Cashflow spreadsheet download to choose between.

Ultimate Rental Property Cashflow spreadsheet Excel notes

The Ultimate Rental Property Cashflow spreadsheet Excel file carries no macros and no VBA, so Excel opens it without a trust prompt. The same Ultimate Rental Property Cashflow spreadsheet Excel download also opens in Excel for the web, which matters when a portfolio is being reviewed away from a desk.

Opening the Ultimate Rental Property Cashflow spreadsheet Excel file

Nothing in the Ultimate Rental Property Cashflow Excel template is version-specific, so this Ultimate Rental Property Cashflow spreadsheet Excel workbook behaves identically in Excel on Windows, Excel on Mac, and older builds.

Spreadsheet template highlights

What the Ultimate Rental Property Cashflow spreadsheet template tracks

Each property is a column, and three reporting sheets read from them. These are the figures the Ultimate Rental Property Cashflow Spreadsheet Template works from and reports back:

Property: a label per property, carried across every sheet
Field: the setup rows: what it cost, the deposit, the loan, its rate and term, and what it is worth now
Monthly Rent: the gross rent charged
Monthly CF auto: derived, cashflow after every expense including the mortgage
Annual NOI auto: derived, income less operating expenses, before financing
Cap Rate auto: derived, per property and across the portfolio
Cash-on-Cash auto: derived, what the cash actually put in has earned
Annual CF auto: derived, the year's cashflow for that property

Compare builds

FinancialAha Rental Property Cashflow spreadsheet template: Free, Essentials, and Ultimate compared

Feature	Free View Spreadsheet Template	Essentials View Spreadsheet Template	Ultimate This page
Working sheets	1	2	6
Properties	One	One	Up to five
Budget against actual	Per line	12-month tracking	Actual income by month
Vacancy and reserves	Entered as lines	Set as percentages	Set as percentages
Cap rate	–	Yes	Per property and portfolio
Cash-on-cash return	–	Yes	Yes
NOI	–	Yes	Per property
Gross rent multiplier	–	–	Yes
Sensitivity grids	–	–	Rent x vacancy, rent x value
Charts	–	2	2

The FinancialAha Ultimate Rental Property Cashflow Spreadsheet Template covers six working sheets and up to five properties. The Free Rental Property Cashflow Spreadsheet Template lists eleven flat amounts for one property and totals them to net cashflow. The Essentials Rental Property Cashflow Spreadsheet Template for Google Sheets and Excel models one property with rates rather than amounts and reports cap rate, net operating income and cash-on-cash return. This build reports each property and the portfolio together, works the returns from what a purchase actually cost including closing and refurbishment, adds the gross rent multiplier, records the rent that really arrived month by month, and puts two sensitivity grids behind the answer so the assumptions are visible rather than buried.

Compare the other builds: Free Rental Property Cashflow spreadsheet template or the Essentials Rental Property Cashflow spreadsheet template .

Good to know

Notes on working in the Ultimate Rental Property Cashflow spreadsheet template

A portfolio figure beside the individual ones is the useful arrangement - one strong property can carry a weak one for a long time before anyone notices which is which.
Total cash invested includes closing costs and refurbishment, which is the difference between a return figure that is true and one that flatters.
Gross rent multiplier is the rough comparison figure used before the detail is available on either property.
A model gives one number for one set of assumptions; a grid shows how much of the answer depends on estimates, and where the point of no cashflow actually sits.
The currency dropdown sits on the Dashboard and relabels money fields across the whole Ultimate Rental Property Cashflow spreadsheet. It changes the label only and does not convert the numbers.

How to Use This Template

Set up each property

Price, deposit, loan, rate, term, current value, rent and vacancy - one column per property.

Set the expense assumptions

Tax, insurance, dues, plus maintenance and management as percentages.

Record the rent received

Month by month per property, so the year that happened is on record.

Read the returns and the grids

The ROI Calculator sheet carries cap rate, cash-on-cash and gross rent multiplier; the grids show what the assumptions are worth.

Customer Reviews

What Our Customers Say

"If I get half as good at handling my finances as you are at customer service, this'll be the best $26 I've spent lately."

J Jenny Verified Buyer

"Great tool! Simplifies financial planning without the hassle of complex spreadsheets."

F Fazia Search Marketing Manager

"I recently purchased your super convenient spreadsheet, it really helps me!"

J John Verified Buyer

"They're great and super intuitive. Thank you!"

M Mira Verified Buyer

Built by Claude AI. Perfected by us.

We use Claude AI to draft each template, after a deep research. Then our team steps in. We refine the layout, stress-test every formula, fix edge cases, and polish the design until it feels like something we would actually use ourselves. The AI gets us 80% there. The last 20% is all human judgment.

One-time purchase. No subscription. Works in Excel & Google Sheets.

Frequently Asked Questions

Is the FinancialAha Ultimate Rental Property Cashflow Spreadsheet Template a Google Sheets template?

Yes. Upload the file to Drive and choose "Open with Google Sheets". The Ultimate Rental Property Cashflow Google Sheets template needs no conversion step and both charts survive the trip intact. The cross-sheet references rely on the existing tab names, so those are worth leaving alone.

Is the FinancialAha Ultimate Rental Property Cashflow Spreadsheet Template an Excel template?

Yes. The download is a plain .xlsx, so the Ultimate Rental Property Cashflow Excel template opens directly in Excel with no import step. Both charts are native Excel charts, and there are no macros or VBA.

Will the FinancialAha Ultimate Rental Property Cashflow spreadsheet Excel file open in older versions of Excel?

Yes. The Ultimate Rental Property Cashflow spreadsheet Excel workbook ships as a plain .xlsx, so it opens identically in current Excel and in builds that predate dynamic arrays.

How many properties does the Ultimate Rental Property Cashflow spreadsheet hold?

Up to five, each with its own column of assumptions, reported individually and as a portfolio. That pairing matters, because one strong property can carry a weak one for a long time before anyone notices which is which.

What do the sensitivity grids in the Ultimate Rental Property Cashflow spreadsheet show?

One moves rent against vacancy and reports monthly cashflow across the whole range; the other moves rent against property value and reports cap rate. A model gives one number for one set of assumptions - a grid shows how much of the answer depended on estimates, and where cashflow actually turns.

What is the gross rent multiplier in the Ultimate Rental Property Cashflow Excel template for?

A quick comparison between two properties before the full detail on either is available. It is rough by design, which is why it sits beside cap rate and cash-on-cash rather than replacing them.

Why does total cash invested in the Ultimate Rental Property Cashflow spreadsheet include closing costs and refurbishment?

Because leaving them out flatters the return. Cash-on-cash is only true if the denominator is everything it actually took to get into the property.

What does the monthly cashflow sheet add to the Ultimate Rental Property Cashflow spreadsheet template?

The rent that really arrived, by property, across the year. Projections assume a rent every month, and this is where the ones that did not turn up show themselves.

What do I get after buying the Ultimate Rental Property Cashflow spreadsheet template?

You receive the Ultimate Rental Property Cashflow spreadsheet template as an Excel file (.xlsx) that works in Microsoft Excel and Google Sheets. Download it immediately after purchase - no signup or account required.

Is there a free Ultimate Rental Property Cashflow spreadsheet template?

Yes. A free version of the Ultimate Rental Property Cashflow spreadsheet template is available with basic features. The Ultimate version adds advanced analysis, more capacity, and additional sheets.

What if the Ultimate Rental Property Cashflow spreadsheet template does not work for me?

Contact us and we will help troubleshoot. The Ultimate Rental Property Cashflow spreadsheet template works in Microsoft Excel and Google Sheets with no macros required.

Ultimate

Preview

See Real Estate Ultimate Pack 10 templates included • Save $141

Highlights:

Instant download after purchase

No macros or VBA required

All formulas auto-calculate

No subscription required

Works in

Excel Google Sheets

Looking for more Ultimate templates?

We offer Ultimate versions of our most popular spreadsheet templates with advanced features, more capacity, and deeper analysis.

Browse All Ultimate Templates Browse Free Templates

Private & secure

Your financial data stays on your device. We never see it.

Learn more →

Need help?

Check our guides or reach out with questions.

View FAQ →