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

SpreadsheetProperty InvestmentFree

Fix and Flip Deal Analyzer

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

Shown with sample data

Colour

Fix and Flip Deal Analyzer

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

Deals analysed
4
Meeting the 70% rule
2
Best profit
$69,850
Best return on cost
32%
Profit by deal
  • 14 Birch Lane$69,850
  • 9 Orchard Close$64,200
  • 72 Canal Street$45,000
  • 31 Mill Road$21,500

How to use it

  1. 1Estimate the after-repair value from recent comparable sales.
  2. 2Get the renovation budget from a contractor, then add a contingency.
  3. 3Enter monthly holding costs: finance, taxes, insurance, utilities.
  4. 4Walk away from anything priced above the maximum offer.

In this workbook

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

About this template

The profit in a flip is made when you buy. Enter purchase price, renovation budget, holding time and the after-repair value; the sheet adds buying, holding and selling costs, shows profit and return, and applies the 70% rule to give the maximum offer for each property.

Who it’s for

  • Comparing several deals quickly
  • Setting a maximum bid before an auction or offer
  • Showing a lender or partner the numbers

What’s included

  • Deals sheet: One row per deal you are considering.
  • Summary by Deal type sheet: Profit and the number of entries for each deal type, calculated from the Deals sheet.

How to use it

  1. 1Estimate the after-repair value from recent comparable sales.
  2. 2Get the renovation budget from a contractor, then add a contingency.
  3. 3Enter monthly holding costs: finance, taxes, insurance, utilities.
  4. 4Walk away from anything priced above the maximum offer.

Questions

What is the 70% rule?

Pay no more than 70% of the after-repair value minus the repair cost. The remaining 30% covers buying, holding and selling costs and your profit.

Related searchesfix and flip calculatorhouse flipping spreadsheet70 percent rulerehab deal analysisbrrrr calculator

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

Fix and Flip Deal Analyzer

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

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
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