Skip to content
GraviPointThe Centre of Productivity
  • AI AgentNew
  • Pricing
  • Community
Log inGet started free
TemplatesReal Estate & PropertyProperty InvestmentRental Property Deal Analyzer

SpreadsheetProperty InvestmentFree

Rental Property Deal Analyzer

Cash flow, cap rate, cash-on-cash, DSCR and a 10-year projection for any rental purchase.

Shown with sample data

Colour

Rental Property Deal Analyzer

Cash flow, cap rate, cash-on-cash, DSCR and a 10-year projection for any rental purchase.

Monthly cash flow
$150.21
Cash-on-cash return
2.0%
Cap rate
6.3%
DSCR
1.1
Lenders want 1.2+
Cash needed
$92,000
Cash flow by year
  • 1$1,802
  • 2$2,433
  • 3$3,083
  • 4$3,754
  • 5$4,445
  • 6$5,159
  • 7$5,894
  • 8$6,653
  • 9$7,434
  • 10$8,240
Equity by year
110

Latest: $246,749

How to use it

  1. 1Enter the property, loan, rent and cost assumptions on the Deal sheet.
  2. 2Read the verdict and key ratios on the Analysis sheet.
  3. 3Check the 10-year projection for cash flow, equity and total return.
  4. 4Duplicate the template to compare several properties.

In this workbook

  • About
  • What’s included
  • How to use
  • Questions
  • Related resources

About this template

Decide in minutes whether a rental stacks up, the way lenders and experienced investors check it. Enter price, financing, rent and costs once; the analyzer works out cash needed to close, mortgage payment, net operating income, monthly cash flow, cap rate, cash-on-cash return, debt service coverage (DSCR), the 1% rule, break-even occupancy and a deal verdict, then projects cash flow, loan balance and equity for 10 years.

Who it’s for

  • Screening buy-to-let deals before an offer
  • Showing a lender DSCR and cash flow
  • Comparing properties side by side

What’s included

  • Deal sheet: Everything about the property and the loan. Change any value and every sheet updates.
  • Analysis sheet: The numbers lenders and investors look at, worked out from the Deal sheet.
  • Projection sheet: Ten years of cash flow, loan paydown, appreciation and equity.

How to use it

  1. 1Enter the property, loan, rent and cost assumptions on the Deal sheet.
  2. 2Read the verdict and key ratios on the Analysis sheet.
  3. 3Check the 10-year projection for cash flow, equity and total return.
  4. 4Duplicate the template to compare several properties.

Tips

  • Budget at least 5% each for vacancy, maintenance and capital expenditure even on a new property.
  • Most lenders want a DSCR of 1.2 or more.
  • The 1% rule is a quick screen only; cash flow and cash-on-cash return decide the deal.

Questions

What is a good cash-on-cash return?

Many investors aim for 8% to 12%. It depends on your market, risk and how much appreciation you expect.

What is DSCR?

Debt service coverage ratio: net operating income divided by the mortgage payment. Above 1 means the rent covers the loan; lenders usually want 1.2 or more.

Does this include appreciation and loan paydown?

Yes. The 10-year projection shows property value, loan balance, equity and total return including cash flow.

Related searchesrental property calculatorcap ratecash on cash returnreal estate investingdscrrental property analysisdeal analyzer

Details

Format
Spreadsheet
Category
Property Investment
Sheets
3
Setup
10 min
Level
Intermediate
Price
Free

Download a copy

Downloads need a free account.

SpreadsheetProperty InvestmentFree

Rental Property Deal Analyzer

Cash flow, cap rate, cash-on-cash, DSCR and a 10-year projection for any rental purchase.

A free account keeps your copy safe so you can come back to it. Have one? Log in

Download a copy

Downloads need a free account.

Details

Format
Spreadsheet
Category
Property Investment
Sheets
3
Setup
10 min
Level
Intermediate
Price
Free

Your copy is private to you.

More property investment templates

View all
Fix and Flip Deal Analyzer2 sheets

Deals analysed

4

Meeting the 70% rule

2

Best profit

$69,850

ABCD
1PropertyDeal typePurchase priceRenovation budget
214 Birch LaneFlip$185,000$45,000
372 Canal StreetFlip$240,000$60,000
49 Orchard CloseBRRRR$150,000$35,000
531 Mill RoadFlip$310,000$80,000
Deals
SpreadsheetProperty Investment

Fix and Flip Deal Analyzer

Test a renovation deal: all-in cost, profit, return on investment and the most you should offer.

10 min setupPreview
Renovation Budget2 sheets

Total budget

$35,050

Spent so far

$16,180

Paid

$13,330

Quote by work item
$9,500
$7,800
$4,500
$4,200
$3,750
Cabinets & worktopsFull bathroom refitPainting & decoratingAppliancesContingency (12%)
SpreadsheetProperty Investment

Renovation Budget

Plan renovation costs by room with quotes, actuals, contingency and payment status.

10 min setupPreview
Rental Property Portfolio Tracker2 sheets

Portfolio value

$1,380,000

Total equity

$471,000

Monthly cash flow

$2,440

Monthly cash flow by property
$800
$730
$400
$320
$190
Unit 3, High Street48 Harbor View12 Elm StreetMaple Court 1AMaple Court 1B
SpreadsheetProperty Investment

Rental Property Portfolio Tracker

Value, debt, equity, cash flow, cap rate and cash-on-cash return for every property you own.

10 min setupPreview

Practical guides and new resources, monthly.

One short email with new templates, calculators and how-tos. Unsubscribe any time.

GraviPointThe Centre of Productivity

Find the right resource. Make it work for you. Get things done with spreadsheets, documents, forms and calculators you can use right in your browser.

support@gravipoint.com
  • @gravipoint
  • @GraviPoint
  • GraviPoint
  • 𝕏@gravipoint

Templates

  • All templates
  • Budgets & expenses
  • Invoices & billing
  • Project management
  • HR & people
  • Inventory & stock
  • Sales & CRM
  • Financial calculators

Popular

  • Monthly budget
  • Invoice
  • Employee shift schedule
  • Weekly timesheet
  • Project plan & Gantt chart
  • Inventory tracker
  • Expense report
  • Mortgage calculator

Solutions

  • Individuals & households
  • Freelancers & consultants
  • Founders & startups
  • Small business owners
  • Teams & operations
  • Students & educators

Company

  • About
  • Features
  • Pricing
  • Community
  • Journal
  • Contact
© 2026 GraviPoint. All rights reserved.
  • Privacy
  • Terms
  • Help centre
  • FAQ