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.
| Column | What goes in it |
|---|---|
| Component | One 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
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
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
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
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
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.