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

SpreadsheetProperty InvestmentFree

Rental Property Portfolio Tracker

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

Shown with sample data

Colour

Rental Property Portfolio Tracker

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

Portfolio value
$1,380,000
Total equity
$471,000
Monthly cash flow
$2,440
Portfolio cash-on-cash return
7.8%
Monthly cash flow by property
  • Unit 3, High Street$800
  • 48 Harbor View$730
  • 12 Elm Street$400
  • Maple Court 1A$320
  • Maple Court 1B$190

How to use it

  1. 1Update values once or twice a year from comparable sales.
  2. 2Enter operating costs excluding the mortgage.
  3. 3Include deposit, fees and renovation in cash invested.
  4. 4Compare cash-on-cash return across properties.

In this workbook

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

About this template

See your whole portfolio the way a lender does. For each property enter value, mortgage, rent, costs and the cash you put in; the sheet calculates equity, loan-to-value, net operating income, cap rate, monthly cash flow and cash-on-cash return, and totals the portfolio.

Who it’s for

  • Annual portfolio reviews
  • Refinance and lending conversations
  • Deciding which property to sell or improve

What’s included

  • Portfolio sheet: One row per property.
  • Summary by Property type sheet: Market value and Equity and the number of entries for each property type, calculated from the Portfolio sheet.

How to use it

  1. 1Update values once or twice a year from comparable sales.
  2. 2Enter operating costs excluding the mortgage.
  3. 3Include deposit, fees and renovation in cash invested.
  4. 4Compare cash-on-cash return across properties.
Related searchesproperty portfolio trackerreal estate portfolio spreadsheetcap rate calculatorcash on cash returnrental portfolio

Details

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

Download a copy

Downloads need a free account.

SpreadsheetProperty InvestmentFree

Rental Property Portfolio Tracker

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

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
2
Setup
10 min
Level
Intermediate
Price
Free

Your copy is private to you.

More property investment templates

View all
Rental Property Deal Analyzer3 sheets

Monthly cash flow

$150

Cash-on-cash return

2%

Cap rate

6%

ABC
1AssumptionValueNotes
2Purchase price320,000Offer price
3Closing costs6,400Typically 2% to 4% of the price
4Repairs and renovation5,600Work needed before renting
5After-repair value335,000Value once repairs are done; used for the projection
Deal
SpreadsheetProperty Investment

Rental Property Deal Analyzer

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

10 min setupPreview
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

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