The HOA Insurance Renewal Worksheet: Three Numbers, Fifteen Questions, and What the Increase Does to Dues

Last verified: November 11, 2026 · See updates

A free Excel sheet a treasurer fills in before the broker meeting. It splits your premium increase into the part caused by a higher insured value and the part caused by a higher rate, turns every percentage deductible into dollars, and tests each one against the two Fannie Mae ceilings that decide whether your owners can still sell.

Download the worksheet (.xlsx, 24 KB, free, no email)

The file is HOA_Insurance_Renewal_Worksheet.xlsx. Free and ungated. You may copy it, change it and give it to your board, members or clients; see the reuse terms.

What you get: HOA_Insurance_Renewal_Worksheet.xlsx, Excel, 24 KB, seven tabs. Every white cell is blank and yours to fill in; every gray cell calculates. It opens in Excel, LibreOffice Calc and Google Sheets.

What it does not do: it does not tell you what your premium should be, price your buildings, or name a carrier or broker. It carries no benchmark premium, because no government or regulator source publishes a national average for community associations.

What is in the file

  • Three_Numbers: last year's figures beside this year's quote, and the split that tells a board what happened. Coverage amount, premium, loss settlement basis and every deductible.
  • Deductible_Exposure: every percentage deductible converted to dollars and tested against the Fannie Mae per occurrence and per unit ceilings, with the amount of headroom or the size of the breach, plus what a claim would cost per unit.
  • Budget_Effect: the increase per unit per month, insurance as a share of the operating budget before and after, the surplus or deficit it creates, and what each of the three ways of paying for it costs.
  • Broker_Questions: fifteen questions, the rule behind each, and a column for the written answer and the date it arrived, with a counter so you know what is still outstanding.
  • Renewal_Timeline: enter the renewal date and the 120, 90, 60 and 30 day working dates calculate themselves.
  • Quote_Comparison: up to three quotes side by side, each tested against the lender rules before the premiums are compared.
  • Instructions: the color rule, where every hard-coded figure comes from, and the stated limits.

The one piece of arithmetic that changes a renewal meeting

A premium is an output. Three inputs produce it: the insured replacement cost of the buildings, the loss settlement basis, and the deductibles. Boards are usually told the increase is the market. With four numbers you already have, the sheet tests that claim.

It prices the change in the coverage amount at last year's rate per 1,000 dollars of coverage. It then prices the change in rate against this year's coverage amount. The two parts add to the total change exactly, with no residue, because one is valued at the old rate and the other at the new coverage amount. The sheet says so in a check cell, so you can see the split is complete and not approximate.

The Three_Numbers tab, worked for a fictional 24 unit condominium. Every figure below was produced by the downloadable file, not by arithmetic on this page.
LineLast renewalThis quoteChange
Insured replacement cost (the coverage amount)$5,600,000$6,000,000$400,000
Annual premium, master property and liability$21,000$31,500$10,500
Coverage amount per unit$233,333$250,000$16,667
Rate per $1,000 of coverage$3.75$5.25$1.50
Caused by the higher insured value$1,50014.3% of the increase
Caused by the higher rate$9,00085.7% of the increase
Check: the two parts add to the totalYes, exactly

In that example the market explanation holds: a 40 percent rate rise did most of the work, and only $1,500 of the $10,500 came from the larger building value. Run your own figures and the answer can invert. When the value part is the large one, a new replacement cost estimate drove your quote, and the question for the broker is who produced it and on what basis. When the rate part is the large one, the question is which carriers the account was marketed to, and whether a second broker should quote it.

The two Fannie Mae ceilings, and which one binds at your size

State statutes and mortgage market rules set different floors, and the lender floor is usually the higher one. A master policy can satisfy your state act and still stop a buyer getting a loan. Fannie Mae Selling Guide B7-3-03, read at source on November 11, 2026, sets two maximum deductibles:

  • Per occurrence: the maximum allowable deductible for all required property insurance perils is 5 percent of the master property insurance coverage amount.
  • Per unit: the maximum allowable per unit deductible is $50,000 per unit. Where the policy has one, each owner must also hold an individual policy under B7-3-04.

Where the policy carries separate deductibles for perils such as windstorm or wildfire, each one has to meet the ceiling in its own right. The same section also requires the coverage amount to equal at least 100 percent of estimated replacement cost value, and loss settlement on a replacement cost basis with roofs as the stated exception. Those four figures were unchanged from our September 29, 2026 read.

The two ceilings govern different deductible structures, so neither substitutes for the other. Put both on a per unit basis, though, and a crossing point appears that neither Fannie Mae nor any source we read states: they cross at $1,000,000 of insured replacement cost per unit. Below that, 5 percent of the coverage amount is the smaller number and is the ceiling to watch. Above it, the $50,000 per unit figure is. For a 24 unit condominium insured at $6,000,000, the 5 percent ceiling works out at $12,500 per unit against the $50,000 per unit figure, so the per occurrence test is the one doing the binding, by a factor of four.

Treat that crossing as a sizing guide for which ceiling to read first, not as a claim that one applies in place of the other. Which test your quote has to meet depends on how its deductible is written, and that is question six on the broker list.

The Deductible_Exposure tab, same fictional association: a $25,000 all perils deductible and a 10 percent named storm deductible, coverage $6,000,000 across 24 units.
TestYour figureThe ceilingResult
All perils deductible against 5 percent of coverage$25,000$300,000Within the ceiling, by $275,000
10 percent named storm, on the whole coverage amount$600,000$300,000OVER by $300,000
The same 10 percent, on one $2,000,000 building$200,000$300,000Within the ceiling, by $100,000
Per unit deductible against $50,000 per unitNone on this quote$50,000No per unit deductible

Rows two and three are the same deductible, and only one of them is your exposure. A percentage of the whole coverage amount and a percentage of one building's insured value are very different dollars, and the quote often does not say which applies. That is why the sheet asks, and why it shows both figures until you have the answer in writing. On a per hurricane rather than an annual basis, two storms in one season mean two deductibles, so the $600,000 figure becomes $1,200,000.

If a test reads OVER, the quote as written can stop one of your owners getting a Fannie Mae loan. B7-3-03 records an option boards rarely hear: a deductible buy-back policy bought by the association may be used to meet the maximum deductible requirement, provided it meets the rest of chapter B7-3 including the insurer rating rules. So a failing quote is one to price a buy-back against, alongside a lower deductible and a different carrier, rather than one to reject on the spot.

What the increase does to dues, in your own numbers

The Budget_Effect tab takes your operating budget, your reserve contribution and your current dues, and reports the three figures a board has to see at the same meeting. Worked on the same fictional 24 unit condominium that ships inside the annual budget workbook, with operating expenses of $83,200, total income of $118,480 and a $28,500 reserve contribution:

The Budget_Effect tab after a $10,500 premium increase. Produced by the worksheet from the budget workbook's own figures.
LineBeforeAfter
Insurance subtotal, with directors and officers$23,000$33,500
Total operating expenses$83,200$93,700
Insurance as a share of operating expenses27.6%35.8%
Projected surplus or deficit$6,780 surplus$3,720 deficit
Dues per unit per month to fully fund the budget$378.13$414.58

Three of those figures already appear on our insurance renewal page. There they were produced by editing one cell in the budget workbook and recalculating the file. The worksheet reproduces all three to the cent from the same inputs, which is how we checked its formulas: $378.13, $414.58, and the $36.46 per unit per month that the increase works out at. One input the page does not publish is the $2,800 of income from sources other than dues. The worksheet needs it to work out what dues alone have to raise, and it is the difference between the workbook's $118,480 of total income and the $115,680 its dues schedule produces.

The tab then prices the three ways of closing the gap, because they are not the same kind of choice. Raising dues costs $36.46 per unit per month, which is 9.1 percent on dues of $401.67. Absorbing it leaves the association $3,720 short rather than $6,780 ahead, and works once. Cutting the reserve line to pay for it takes $10,500 out of $28,500, a 36.8 percent cut, and the repair that money was saving for arrives unfunded. Our reserve contribution calculator shows what the third option does to the funding percentage before anyone votes on it.

Comparing quotes before comparing premiums

The Quote_Comparison tab holds three quotes and runs the lender tests on each one before you look at the price. The point of the ordering is that a cheaper quote can fail a test, and a board comparing premiums alone will not see it. Two quotes on the same $6,000,000 coverage amount:

Two quotes through the Quote_Comparison tab. Fictional carriers, coverage $6,000,000, 24 units, dues $401.67 per unit per month.
LineQuote AQuote B
Quoted annual premium$31,500$29,000
Rate per $1,000 of coverage$5.25$4.83
All perils deductible$25,000$120,000
Per unit deductibleNone$60,000
Test: per unit deductible within $50,000No per unit deductibleFAILS by $10,000
Fidelity or crime coverage$25,000$30,000
Test: at least three months of assessments ($28,920)FAILS by $3,920Pass
All in first year cost if one claim hits the deductible$56,500$149,000

Quote B is $2,500 cheaper and prices the coverage more keenly at $4.83 per $1,000 against $5.25. It also carries a per unit deductible $10,000 above the Fannie Mae ceiling, and if a single claim lands it costs the association $149,000 in the first year against $56,500. Both of those appear only once the deductible is in the comparison, which is the argument for filling in the tab instead of reading the two premiums.

The three months of assessments figure is the B7-4-02 test where the association keeps adequate financial controls, and the sheet computes it from your unit count and your dues. Where an association does not keep documented controls, the test is instead the maximum funds in its custody at any time. No sheet can work that out for you. Documented controls can therefore lower the bond you need, which makes the controls you already have a thing to write down. If your project is FHA approved, HUD's Resource Center answer KA-03928 states the bond must cover three months of aggregate assessments plus reserve funds, which is the larger number; that is HUD's own restatement and not the handbook text, so ask your broker to confirm it against the current guide in writing.

The fifteen questions, and when to send them

The question list on the Broker_Questions tab is the fourteen from our insurance renewal page plus one added today: if a deductible sits above the Fannie Mae ceiling, what would a deductible buy-back policy cost. Each question carries the rule behind it, a cell for the written answer and the date it arrived, and a counter that tells you how many of the fifteen are still outstanding when the board meets.

The Renewal_Timeline tab dates the sequence from your renewal date: the documents and loss runs at 120 days, the questions at 90, the quote comparison at 60, and the board decision at 30, so the renewal lands before the budget vote and not after it. That sequence is our suggested practice and not a legal requirement. Check your own declaration and state act for notice periods that bind you, and note that in Florida the deductible decision has its own meeting procedure under Fla. Stat. 718.112(2)(e).

Before you use the file: all the sample figures above are fictional, and the worksheet ships with every input cell blank. It does not read your declaration. Who pays the master policy deductible, and whether the board may raise it, is set by your state act and your governing documents, and the two have to be read together. This is educational information, not insurance, legal or accounting advice. An independent agent or broker who writes community association business, and your association's attorney, are the people to read your policy and your declaration against each other. See our disclaimer.

Where the rules in the file come from

The figures the worksheet hard-codes into its formulas are Fannie Mae's, not ours, and each was read at the Selling Guide itself and not taken from a summary: B7-3-03 for the coverage amount, loss settlement and the two deductible ceilings, B7-4-01 for the $1,000,000 general liability requirement, B7-4-02 for the fidelity test above 20 units, B7-3-06 for flood, and B7-3-04 for the unit owner policy that a per unit deductible triggers. The property insurance figures were re-read at source on November 11, 2026 and were unchanged from our September 29, 2026 read, so nothing published on this site about them moved. Everything else the file reports is calculated from numbers you type into it.

Pairs well with

Questions boards ask

How do I tell whether our HOA insurance increase is the rate or the building value?

Ask the broker for last year's coverage amount and this year's side by side, then put both coverage amounts and both premiums into the Three_Numbers tab. It prices the change in the coverage amount at last year's rate, and the change in rate against this year's coverage amount. Those two parts add up to the total change exactly, with nothing left over, so the sheet tells you which of the two moved your premium. A large value part means a new replacement cost estimate drove the quote, and the question becomes who produced it. A large rate part means the question is which carriers the account was marketed to.

What is the maximum deductible a condo master policy can have?

No state statute we have read caps it. Fannie Mae does, and its ceiling decides whether your owners can get financing. Selling Guide B7-3-03, read at source on November 11, 2026, sets the maximum allowable deductible for all required property insurance perils at 5 percent of the master property insurance coverage amount per occurrence, and the maximum per unit deductible at $50,000 per unit. Where the policy carries separate deductibles for perils such as windstorm or wildfire, each one has to meet the ceiling in its own right. The worksheet tests your figures against both.

Which Fannie Mae deductible ceiling applies to our association?

The two ceilings govern different deductible structures, so neither substitutes for the other: 5 percent of the coverage amount applies to a per occurrence deductible, and $50,000 per unit applies where the policy carries a per unit deductible. Put both on a per unit basis, though, and they cross at $1,000,000 of insured replacement cost per unit. Below that figure, 5 percent of the coverage amount is the smaller number; above it, the $50,000 per unit figure is. The worksheet works out which one is binding at your own coverage amount per unit.

Can an HOA keep a deductible above the Fannie Mae ceiling?

Fannie Mae records one option that boards rarely hear about. Selling Guide B7-3-03 states that a deductible buy-back insurance policy purchased by the HOA or co-op corporation may be used to meet its maximum deductible requirements, provided the policy meets all other property insurance requirements in chapter B7-3, including the insurer rating requirements. So a quote carrying a deductible above the ceiling is a quote to price a buy-back against, not automatically a quote to reject. Ask the broker for that price in writing.

What is the average HOA master policy premium?

There is no published national average for community associations, in dollars or as a percentage, and we could not find one in any government or regulator source. Regulators publish personal lines data. That is why this worksheet contains no benchmark figure to measure yourself against, and why any national average association premium you are quoted should be treated as unsourced until someone shows you the collection behind it.

Text on this page is licensed CC BY 4.0. Suggested citation: CommonKeel, "The HOA Insurance Renewal Worksheet: Three Numbers, Fifteen Questions, and What the Increase Does to Dues", https://commonkeel.com/templates/hoa-insurance-renewal-worksheet/, verified November 11, 2026. Based on Fannie Mae Selling Guide sections and state statutes read at their own sites on the dates shown, and not on hands-on testing of any insurance product. Not insurance, legal or accounting advice. Downloadable files are free to use and share within your association; ask michael@commonkeel.com about redistribution.