Free reserve study template for Excel and Google Sheets

A one-sheet reserve study spreadsheet for HOA and condo boards. It comes with ten example components, formulas that work out each component's funded share and yearly contribution, and a summary that shows your percent funded. Replace the examples with your own components and it recalculates. No signup and no email address.

What is in the spreadsheet

One table with six columns, a totals row, and a three-line summary. The example values are national 2026 midpoints from our component cost library, so the sheet shows believable numbers before you type anything.

ColumnWhat goes in it
ComponentOne row per thing the association must replace one day: the roof, the paving, the pool plaster, the fence. Put the quantity in the name so next year's board knows what the cost covers.
Useful Life (years)How long a new one lasts. Take it from your last reserve study or from the contractor who installed it.
Remaining Life (years)How many years are left before it must be replaced. A 20-year fence installed 12 years ago has 8 left.
Replacement Cost ($)What it would cost to replace today. A current bid is best. Do not add inflation here.
Fully Funded Share ($)A formula: replacement cost times the share of its life already used. This is what the association should have saved for that component by now.
Annual Contribution, Straight-Line ($)A formula: replacement cost divided by useful life. This is the yearly saving that replaces the component on time if you fund each one on its own.

The summary under the table has three lines: your current reserve balance, the fully funded balance (the total of the fully funded column) and percent funded.

How to fill it in

  1. 1

    Download and open it

    The file is a CSV with formulas in it. Excel opens it directly. In Google Sheets, choose File, Import, Upload and keep the option that converts text to numbers and formulas switched on.

  2. 2

    Replace the ten example rows

    The examples are there to show the shape of a filled-in sheet. Overwrite each with one of your own components. If you have more than ten, insert rows above the TOTALS row so the totals keep adding them up.

  3. 3

    Enter your reserve balance

    In the summary block under the table, type what is in the reserve account today. Use the reserve account only, not operating cash.

  4. 4

    Read percent funded

    The summary divides your balance by the fully funded balance. The sheet marks 70% or more as strong, 30% to 69% as fair and below 30% as weak.

  5. 5

    Save a copy as a spreadsheet

    Save as .xlsx in Excel, or keep it as a Google Sheet. A CSV saved again from Excel keeps the numbers but can drop the formulas.

Not sure which components belong on the list? The reserve study component list covers what most communities include and what belongs in the operating budget instead.

The two formulas, in plain words

Fully funded share

Replacement cost multiplied by the share of the component's life that has been used. A $60,000 paint job with a 10-year life and 5 years left is half used, so its fully funded share is $30,000. Add this up for every component and you have the fully funded balance.

Straight-line contribution

Replacement cost divided by useful life. The same paint job needs $6,000 a year. The total of this column is what the association would put into reserves each year if every component were funded separately.

For how the two common funding methods differ, see straight-line and cash-flow funding compared. For what your result means, see percent funded, explained.

What a spreadsheet will not do

  • It does not inspect anything. Remaining life is your estimate. A professional study replaces the estimate with an inspection.
  • It does not project forward. There is no inflation, no interest and no year-by-year balance, so it cannot show the year the fund runs short.
  • It may not meet your state's rule. Requirements differ by state and by the size and type of community. See reserve study requirements by state.

When you need the projection, the reserve fund calculator runs 30 years with both funding methods and needs no signup. Reserve Planner saves the plan so the next board can pick it up; its free tier holds one plan with up to 8 components. When you need the inspection, the reserve study company directory lists firms by state.

Questions boards ask

Keep the reserve plan with the rest of your books

Effortless HOA is $3 per home per month, never more than $249 a month for one community. Try it free for 30 days with no credit card.

Start free trial

30-day free trial · No credit card required · Cancel anytime

See all free templates