Free tool

Spec home pro forma calculator

Enter the lot, build cost, loan, months held and selling costs. See profit, margin, breakeven price and what each extra month on the market costs.

Short answer: A spec home pro forma adds land, hard costs, soft costs, contingency, financing, carrying costs and selling costs, and subtracts the total from the expected sale price. This calculator does that arithmetic in your browser. It also shows the breakeven sale price and what each extra month on the market costs in interest and carrying costs. It uses your numbers only and sends nothing.

The deal

Average outstanding over the hold, not the commitment. Draws rise over the build.

Result

Illustrative arithmetic only. Nothing you enter leaves your browser. Taxes, lender terms and local costs vary. This is not tax or investment advice.

The formulas

  • Contingency = hard costs x contingency percent.
  • Interest = average loan balance x annual rate x months held / 12.
  • Carrying costs = monthly carrying cost x months held.
  • Selling costs = sale price x (commission percent + seller closing and concession percent).
  • Total cost = land + hard + soft + contingency + interest + carrying + selling.
  • Profit = sale price - total cost. Margin = profit / sale price. Return on cost = profit / total cost.
  • Breakeven price = (all costs except selling costs) / (1 - selling cost percent).

An illustrative deal

With a $1,250,000 sale price, $220,000 of land, $700,000 of hard costs, $45,000 of soft costs, 3 percent contingency, a $600,000 average loan at 9 percent for 10 months, $2,500 a month of other carry and 6.5 percent selling costs, profit is $112,750, a margin of 9.0 percent and a return on cost of 9.9 percent. The breakeven price is about $1,129,412. Each extra month on the market costs about $7,000 in interest and carry, so a four-month delay would cost roughly $28,000 before any price reduction.

What the pro forma leaves out

This is one deal at a time. It does not model income taxes, equity returns timing, partner splits or cost overruns beyond the contingency line. Real draws rise over the build, so the average balance is an estimate. After closing, compare actual results line by line with the pro forma. See spec home pro forma vs actual, spec home carrying costs and spec home inventory and capitalized costs.

Want actuals tracked against the pro forma?

Our team tracks each spec house's actual costs against the pro forma and shows the margin bridge at closing. Our founder reviews every close. We quote a flat monthly price for each builder, starting at $1,500 a month, with typical engagements between $2,500 and $8,500 a month. Start with a $1,500 Margin Review for written findings. See job costing, construction bookkeeping, pricing or request a Relationship Assessment.

Sources

Common questions

What goes into a spec home pro forma?

Land, hard costs, soft costs, contingency, financing and carrying costs, and selling costs, subtracted from the expected sale price.

How do I calculate the breakeven price of a spec home?

Add all costs except selling costs, then divide by one minus the selling cost percentage of the sale price.

How much does each extra month cost on a spec home?

Interest on the average loan balance for a month plus the monthly taxes, insurance and utilities. The calculator shows it.

Does the calculator save my numbers?

No. It runs in your browser and sends nothing.

Can you track actuals against my pro forma?

Yes. Our team compares actual costs to the pro forma for each spec house.

Related

By John Mos, Founder. Updated . We do not give tax or legal advice. Please ask your CPA or attorney.

See where your margin goes, house by house.

Tell us about your homes and your books. If we are a fit, we start with a $1,500 Margin Review: written findings and a fixed quote in 10 business days, credited to your onboarding fee if you sign up.