Condo, Townhome & HOA Document Review Worksheet for Homebuyers | Budget, Dues, Reserves, Rules & a 3-Property Scorecard (Excel, Google Sheets + Printables)
A buyer worksheet for reading the condo, townhome, or HOA documents you were given — budget and dues, reserves and special assessments, insurance and rules, plus a side-by-side scorecard for up to three properties. You fill in figures from the documents. The sheet adds what you type. It does not invent dues and it does not calculate a loan payment.
The spreadsheet (Excel and Google Sheets, no macros)
Start Here and Settings: your name, an as-of date, and the names of up to three properties. There is no interest-rate field and no loan-payment field.
Document Checklist: mark Yes or No for what you actually received.
Budget & Dues: regular dues, what they include, last change, and income vs. expenses as the budget states. Surplus or shortfall is the two numbers you typed, subtracted.
Reserves & Assessments: reserve balance, a percent-funded figure only if the study itself states one, and any special-assessment history in the package.
Rules & Insurance: notes from the documents and the insurance certificate — not a premium quote.
Scorecard and Dashboard: score 1 (weak) to 5 (strong). The sheet adds the totals. A high score is not a recommendation to buy and is not an approval.
The printable PDF (8 US Letter pages)
How to use the worksheet, the document-request checklist, budget and reserves pages, insurance / rentals / pets / rules notes, red-flag questions, and a decision summary.
Yellow cells are where you type. Formula cells are locked (no password).
Works in Excel 2016 or newer and Google Sheets (upload, then File > Save as Google Sheets). An example file with a made-up buyer comparing two properties in March 2027 is included. The numbers in it are illustrations, not a quote.
Educational only. Not a loan offer, a pre-approval, a commitment to lend, or a rate quote. Not legal, tax or insurance advice, and not an inspection of the association. Only a loan officer working from your actual application can tell you what you may qualify for.
Aaron Clark NMLS #1770738 | Responsive Mortgage - A Division of PRMG NMLS #75243 | Equal Housing Opportunity
Instant digital download. Nothing ships.