Skip to content
GraviPointThe Centre of Productivity
  • AI AgentNew
  • Pricing
  • Community
Log inGet started free
TemplatesReal Estate & PropertyProperty InvestmentCapital Expenditure Reserve Planner

SpreadsheetProperty InvestmentFree

Capital Expenditure Reserve Planner

Roofs, boilers and appliances wear out on schedule. Work out how much to set aside each month.

Shown with sample data

Colour

Capital Expenditure Reserve Planner

Roofs, boilers and appliances wear out on schedule. Work out how much to set aside each month.

Monthly reserve needed
$413
Due within 5 years
$32,200
Should already be saved
$48,386
Items to replace soon
2
Replacement cost by property
  • 48 Harbor View$54,500
  • 12 Elm Street$30,300
Share of replacement cost by property
  • 48 Harbor View$54,50064%
  • 12 Elm Street$30,30036%

How to use it

  1. 1List major components for each property.
  2. 2Get replacement costs from recent quotes.
  3. 3Enter the age from installation records or inspection.
  4. 4Fund the monthly reserve from rent before counting profit.

In this workbook

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

About this template

Big repairs are not surprises; they are bills with a date. List each major component with its replacement cost, expected life and current age; the sheet shows the years left, the monthly amount to reserve and what falls due in the next five years.

Who it’s for

  • Setting a realistic reserve per property
  • Underwriting a purchase properly
  • Homeowner association reserve planning

What’s included

  • Components sheet: One row per major component.
  • Summary by Property sheet: Replacement cost and Should have saved and the number of entries for each property, calculated from the Components sheet.

How to use it

  1. 1List major components for each property.
  2. 2Get replacement costs from recent quotes.
  3. 3Enter the age from installation records or inspection.
  4. 4Fund the monthly reserve from rent before counting profit.
Related searchescapex reservecapital expenditure plannerreplacement reserveproperty maintenance budgetreserve study

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

Capital Expenditure Reserve Planner

Roofs, boilers and appliances wear out on schedule. Work out how much to set aside each month.

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