New: Drag & Drop HOA Website Builder now live — start your 30-day free trial ›
Free template

HOA Reserve Study Template

List your community’s major components, replacement costs, and remaining life. The spreadsheet calculates your fully funded balance, percent funded, and the reserve contribution you need.

Download ExcelDownload PDF

Excel (.xlsx) + PDF · Free · No sign-up · Preview it below

What is an HOA reserve study?

An HOA reserve study is a long-term plan for repairing and replacing the community’s big-ticket items, like roofs, roads, pools, and fences. It lists each component, what it will cost to replace, and how many years it has left.

From that, the study shows how well funded your reserves are today and how much the association should set aside each year. Communities that follow a reserve study rarely need surprise special assessments.

What to include

  • Every major component the association maintains
  • Current replacement cost for each one
  • Useful life and remaining life in years
  • The fully funded balance for each component
  • The current reserve balance and percent funded
  • The annual and monthly contribution needed

Template preview

Fill in the [highlighted] fields
[Association Name] Reserve Study Worksheet, [Year]
Sample: 12 components with a $85,000 current balance. The Excel version recalculates as you edit.
Current reserve balance$85,000
Annual inflation assumption0.033% = 0.03 (for your own projections)
ComponentNotesReplacement costUseful lifeRemaining lifeFully funded balanceAnnual contribution
Asphalt paving (roads, parking)Full mill & overlay$120,000259$76,800$4,800
Asphalt seal coat & striping$18,00052$10,800$3,600
Clubhouse roofArchitectural shingles$45,0002512$23,400$1,800
Exterior paint (clubhouse, walls)$60,000103$42,000$6,000
Pool resurfacingPlaster$30,000124$20,000$2,500
Pool pumps, heater & equipment$12,000106$4,800$1,200
Perimeter fencing$25,0002011$11,250$1,250
Entry gate & access system$20,000157$10,667$1,333
Playground equipment$35,0002014$10,500$1,750
Clubhouse HVAC$14,000155$9,333$933
Mailbox kiosks$9,0002010$4,500$450
Landscape & street lighting$8,000158$3,733$533
Totals$396,000$227,783$26,150
Percent funded37%Current balance ÷ fully funded balance
Recommended monthly reserve contribution$2,179Straight-line: replacement cost ÷ useful life

Tips for using this template

✓Start with the big items

Roads, roofs, pools, and paint usually make up most of the total. Get those right first.

✓Use real bids

Ask vendors for replacement estimates instead of guessing. Update them every year or two.

✓Update it yearly

Adjust remaining life and costs each year, and plan for a professional study every three to five years.

✓Fund it in the budget

Carry the recommended contribution straight into your annual budget’s reserve line.

Frequently asked questions

What does percent funded mean?

It compares your current reserve balance to the amount you would have if you had saved for every component on schedule. Many advisors consider 70% or higher to be strong.

How often should an HOA do a reserve study?

A professional study every three to five years with yearly updates is common. Some states require a study on a set schedule.

Is this the same as a professional reserve study?

No. This worksheet helps you plan and understand the numbers. A credentialed reserve specialist inspects components and is often required by law or lenders.

More free HOA templates

View all templates →
HOA Budget TemplateAn Excel budget with income, expenses, and reserves that totals itself. HOA Treasurer Report TemplateBalances, budget vs. actual, and delinquencies in one board-ready report. HOA Violation Letter TemplateA clear first-notice letter that cites the rule, sets a deadline, and explains next steps.

Run your HOA without the paperwork

Perfect HOA® handles notices, dues, meetings, and requests for you. Start a free trial or book a demo.

Start free trialBook a demo