Builders Risk Insurance Cost Calculator: What a Vacant Flip Actually Needs

A builders risk insurance cost calculator for a vacant property is not a premium quote tool. It is a coverage-days ledger. The premium is the small number in this decision. The big numbers are the days you hold the house with no coverage at all, and the claim haircut you take when the policy limit was built on the wrong value.

Here is the deal this article models throughout. A 1968 ranch, 1,540 square feet, Midwest metro. Purchased for $182,000, closed March 9. Rehab budget $68,000. Replacement cost of the existing structure, which is the number the carrier cares about and it is neither the purchase price nor the ARV, is $214,000. Target sale price $319,000.

The insurance line in that deal's budget said $600. The correct number was $1,724. That gap is not the point. The point is what the $1,124 was buying: it removes a $71,337 coinsurance haircut, 47 days of zero coverage on a $214,000 structure, and $16,400 of cabinets and HVAC sitting in the garage outside the theft sublimit.

Why the Seller's Policy and Your Homeowners Policy Both Fail on a Flip

The common version of this warning is that a homeowners policy voids after 60 days of vacancy. That is roughly true and mostly beside the point, and the flippers who rely on it get a surprise at the claim anyway.

Three separate failures, in the order they actually happen:

The seller's policy does not transfer. It terminates at the sale. Between the recording of your deed and the inception of your own policy, whatever the seller had is gone. This is the gap nobody budgets, and on a purchase where the underwriter wants a photo set on a 1968 structure before binding, it runs three to five business days.

An HO-3 requires you to live there. The named insured has to occupy the residence premises. A house you bought to renovate and sell has never been your residence. This is not a vacancy problem, it is a misrepresentation problem, and the remedy is rescission rather than a reduced payment. The policy is treated as though it never existed and the premium comes back to you.

The vacancy exclusion is narrower than people quote and worse than they expect. Under the standard HO-3 form, vandalism and malicious mischief are excluded once the dwelling has been vacant more than 60 consecutive days. There is a carve-out stating that a dwelling being constructed is not considered vacant. Flippers hear that carve-out and relax. Do not. It contemplates new construction. Whether a cosmetic rehab qualifies is an argument, and it is an argument you have after the fire, with the burden on you, while the lender is asking when the loan gets repaid.

What a flip actually needs is a builders risk policy sized to the whole building, and a vacant dwelling policy or endorsement covering the window between "done" and "sold." Those are two different products with two different termination triggers, and the handoff between them is where the money leaks.

What Builders Risk Costs on a Renovation, and Why the Cheap Quote Is the Expensive One

Builders risk on a renovation of an older structure prices in the range of $3.50 to $5.50 per $1,000 of insured value for a twelve month term, non-coastal. Most admitted carriers also carry a minimum premium around $425, which matters more than the rate on small projects.

Everything depends on what number you put in front of the rate. On a renovation you have a choice the carrier will let you make and will not warn you about: insure the work only, or insure the work plus the existing structure.

The first quote comes back at $425 because the rated premium of $286 falls under the carrier's floor. It looks like a bargain. It is the single most expensive decision in the file, because builders risk forms carry the equivalent of a 100 percent coinsurance clause. If the limit you carry is short of the value you should have carried, every claim is reduced by that same ratio, whether it is a total loss or a $3,000 water event.

Run the fire. A June kitchen fire spreads into the adjacent wall and the attic above it. Restoration bid: $94,000.

The shortfall is $71,337. The premium difference that would have prevented it is $759. That is a 94 to 1 return on the most boring line in the budget, and it is the reason the calculator below starts with valuation and not with rate shopping.

The deductible is two numbers, not one

Builders risk deductibles are usually written as a flat amount for most perils and a percentage for wind and hail. A $2,500 flat deductible with a 2 percent named-storm deductible on $282,000 of insured value means your hail claim carries a $5,640 retention, not $2,500. Model both. If you flip in a hail corridor, the percentage deductible is the one that shows up.

Building the Coverage Calculator in Excel

One sheet, three blocks: valuation, premium, timeline. The timeline block is the one that earns its keep and the one no carrier quote page gives you.

Valuation and premium inputs, column A labels and column B values:

Required insurable value in B7 is the sum of the existing structure and the work, not the purchase price:

=B5+B6

Premium in B11 applies the rate and then respects the carrier floor:

=MAX(B10,B8/1000*B9)

The coinsurance ratio in B14 is the number that decides what a claim is worth. Cap it at 1 so an over-insured file does not show a phantom bonus:

=MIN(1,B8/B7)

Put a flag next to it in B15 so the file argues with you before the adjuster does:

=IF(B14<1,"UNDERINSURED: claims cut to "&TEXT(B14,"0.0%"),"OK")

Then model a loss. Put the restoration estimate in B16 and the net check in B17:

=MAX(0,B16*B14-B12)

Two things about that formula. It multiplies the loss by the coinsurance ratio before subtracting the deductible, which is the order carriers apply it, and it floors at zero so a small loss under the deductible does not display as a negative recovery you might mistake for a number you owe.

The materials block

Builders risk covers materials once they are permanently installed. Materials sitting in the garage waiting on a subcontractor are covered under a separate, much smaller sublimit, and copper, cabinets, and condensing units are the exact categories that walk off a job site.

Track peak exposure in B20 and the sublimit in B21, then show the gap in B22 with =MAX(0,B20-B21). Raising that sublimit from $5,000 to $25,000 costs roughly $140 at binding. Nobody asks for it, because the delivery date and the install date are on the schedule and the two weeks between them are not.

The 90 Day Cliff That Ends Your Policy While You Still Own the House

This is the part of the coverage that flippers do not know exists, and it is written into the standard builders risk form.

Coverage ends at the earliest of several triggers, not at the policy expiration date. On the ISO builders risk coverage form, those triggers are: the policy expires or is cancelled, the property is accepted by the purchaser, your interest in the property ceases, construction is abandoned, 90 days after construction is complete, or 60 days after the building is occupied in whole or in part.

Read that again with a flip in mind. You buy a twelve month policy. You finish the rehab in month three. Ninety days later your coverage terminates by its own terms while you are still on title, still on the hard money note, and the house is empty and staged and getting showings. The premium is fully earned, so there is no refund for the months you paid for and did not receive.

Worse, "construction is complete" is not a date you declare. It is a date an adjuster reconstructs after the loss, from your permit final, your contractor's final invoice, and your MLS listing date. Your own file establishes the day your coverage ended.

Here is the timeline block. Dates in column B, day counts calculated:

The post-completion cutoff in B30 is the trigger the form imposes on you:

=B29+90

Effective coverage end in B33 is the earliest live trigger:

=MIN(B28,B30,B32)

Now the four numbers that make this a decision tool instead of a quote. Days of coverage purchased in B34, days actually received in B35, the front gap in B36, and the back gap in B37:

Cost per covered day in B40 divides the fully earned premium by the days you actually received, not by the days you bought:

=B11/B35

That is $6.54 per covered day. The number the flipper believes he is paying, premium divided by days held, is $5.10. And the premium spent on days that were never delivered, in B41:

=B11/B34*(B34-B35)

That is $597 of a $1,184 policy. Half the premium bought nothing, and 51 of the 232 days on title, 22 percent of the hold, had no coverage on a $214,000 structure.

Closing the back gap costs $325 if you ask at the right time

There are two ways to cover the window between completion and sale, and they are not close in price.

The endorsement is $704 cheaper and has no handoff date to fumble. The catch is entirely about timing. On day 0 you are asking an underwriter to extend coverage on a project he is already writing. On day 85 you are asking him to write a completed, empty, listed house, which is a different risk class that gets surcharged or declined. Same request, same house, two very different answers, separated only by when you made the call.

If you already blew past day 90 and need the vacant policy now, buy it anyway. The 3 month minimum premium of $1,029 works out to $21.89 per day for the 47 days you actually need, which reads as expensive until you set it against $214,000 of structure and the fact that a copper strip on an empty staged house runs $6,800 before anyone touches drywall.

Six Month or Twelve Month Term: The Argument That Does Not Matter

This is where most builders risk advice spends its energy, and it is worth about $131.

Term pricing is not linear. A six month term typically runs 65 to 75 percent of the twelve month premium, because the fixed cost of underwriting the file does not shrink with the term. On this deal at 70 percent, six months costs $829 against $1,184 for twelve.

Expected cost on the six month path assumes a 60 percent chance of running past six months, which is what this operator's last five projects actually did. Compute it in B44 as =B42+B43*0.6 and set the probability from your own closed files, not from your plan.

The six month path wins by $131. Take the twelve month term anyway, and not for the reason people usually give.

An extension request is a re-underwriting event. The underwriter looking at your file in month six is looking at a project that ran long, on a vacant structure, possibly with an open claim. Extensions on stalled projects get surcharged and sometimes get declined. Paying $131 to remove a decision point where somebody else gets a vote on whether you stay insured is the cheapest option in this entire article. It is the same logic as locking a longer rate lock on a rehab loan: you are not buying a lower price, you are buying the removal of a renewal conversation at the worst possible moment.

The Three Line Fix and What It Buys

Everything above collapses into three changes you make at binding, before the policy is issued, when they are cheap.

The insurance line goes from $500 to $1,724. On a deal underwritten to $38,000 of net profit, that is 3.2 percent of the profit, and it is the last 3.2 percent anyone should be shaving. Every one of these three is priced at binding and unavailable later. The endorsement gets declined at day 85. The sublimit increase is not retroactive to the cabinets that already walked. And the coinsurance ratio is fixed the moment the policy is issued, so the first person who tells you the limit was low will be the adjuster.

Front gap checklist for the next closing

• Request the builders risk quote when the purchase contract is signed, not when the deed records. Underwriting a 1968 structure takes three to five business days and the seller's policy dies at the closing table.
• Give the agent the replacement cost of the existing structure, not the purchase price and not the ARV. A $182,000 purchase on a $214,000 replacement cost is normal, and the gap is where the coinsurance penalty lives.
• Ask for the post-completion cutoff endorsement in the same email as the quote request.
• Name the hard money lender as mortgagee on the binder before your funding deadline, because the lender's forced-place policy protects the lender's balance, not your equity.
• Photograph the structure the day you take title. The vacancy and condition argument is won or lost with dated photos.

Where This Sits in the Deal

Insurance is a holding cost, and holding costs are the line flippers under-model most consistently. A $1,724 policy across a 232 day hold is $7.43 per day, which sits alongside the interest, the utilities, the taxes, and the lawn service in your holding cost calculator. It is not a separate category and it should not live on a separate spreadsheet.

The number that connects this article to the rest of the deal is the 47 day back gap. Those are days on market, and days on market is the variable that decides both your carrying cost and your price reduction decision. A project that sells in 20 days never hits the 90 day cliff. A project that sits 96 days hits it with 47 days to spare on the wrong side. You do not know which one you have when you bind the policy, which is precisely why you buy the endorsement instead of betting on a fast sale.

Build the coverage-days ledger once and it takes four minutes per deal after that: five dates, two values, one rate. What you get back is a premium line you can defend, a coinsurance flag that fires before the adjuster does, and an uncovered-days count that turns an abstract policy exclusion into a number you can put in the deal.

If you would rather not build the timeline logic and the coinsurance flag from scratch, the Flip and BRRRR Calculator already carries the holding cost engine this plugs into: monthly carry by category, day-count driven, with the hold period feeding straight through to net profit and cash-on-cash. Add the insurable value, the bind date, and the completion date as three inputs, wire the coinsurance ratio to the flag, and your insurance line stops being a $600 placeholder and starts being the only line in the budget with a 94 to 1 return.