See every HOA repair coming and what to collect for it
List your components (roofs, paving, painting, pool, elevators) with quantity, unit cost, useful life and remaining life. Reservewren projects every replacement for 30 years with inflation, runs the reserve cash flow with contributions and interest, and shows percent funded today and each year. It then solves the smallest year-1 contribution that never lets the balance go below zero (baseline) or below your chosen minimum (threshold), per unit per month. In the example, a made-up 48-unit condominium is 40.9% funded and would hit -$588,442 in 2044 on its current $84,000 contribution; $117,803 a year (about $204.52 per unit a month) keeps it above $100,000.
Example file: a made-up 48-unit condominium, 30 components, underfunded on purpose
| Measure | Example result |
|---|---|
| Percent funded today | 40.9% (Fair) |
| Lowest balance, current plan | -$588,442 in 2044 |
| Current year-1 contribution | $84,000 |
| Threshold plan (never below $100k) | $117,803 |
| Threshold plan per unit / month | $204.52 |
Source: The made-up 48-unit condominium in the Reservewren example file, Dashboard (built by products/reservewren/src/workbook.py; rows in products/reservewren/store/listing.json).
Reservewren vs the alternatives
Published prices, each checked on the date shown; prices change, so confirm on each site.
| Product | Price | Free | Checked |
|---|---|---|---|
| Reservewren HOA Reserve Study Spreadsheet | $39 once | free preview PDF | live |
| 30 Year Reserve Study Spreadsheet (Gumroad; also sold via cheapreservestudy.com) | $79.99 | 2026-10-10 | |
| 10 Year Reserve Study Spreadsheet (Gumroad; also sold via cheapreservestudy.com) | $59.99 | 2026-10-10 |
Why teams pick Reservewren
- 30 years and 150 components for $39; the 30-year Gumroad spreadsheet is $79.99.
- Funding plans are solved by formula: change a cost or a remaining life and the contribution you need updates instantly.
- Percent funded uses the standard method: reserve balance / fully funded balance (current cost x effective age / useful life).
- Works offline in Excel, Google Sheets and LibreOffice, in a file the board owns.
- Honest limit: it does not replace a credentialed reserve study with a site visit where your state or lender requires one.
How it works
- Enter Settings: starting balance, current contribution and its yearly increase, inflation, interest, units and your minimum balance.
- Enter components from your last reserve study, invoices or bids (up to 150).
- Read the Dashboard: compare your current contribution with the baseline and threshold plans before the budget meeting.
FAQ
Does this replace a professional reserve study?
No. Many states and lenders require a credentialed study with a site visit. Reservewren is for planning, budgets and the years between professional updates; it also gives your study firm a clean component list.
Why not the $79.99 Gumroad reserve spreadsheet?
It is a 30-year template you fill in. Reservewren is $39, covers 150 components over 30 years and solves the baseline and threshold contributions for you.
How is percent funded calculated?
Reserve balance / fully funded balance, where each component's fully funded amount is its current cost x effective age / useful life.
Does it work in Google Sheets?
Yes: upload the .xlsx to Google Drive and open it with Google Sheets.