Guide

Spec home pro forma vs actual: comparing margin at sale

How to line up the deal you underwrote with the house you closed, bucket by bucket, so the next lot is priced on real numbers.

Short answer: To compare a spec home's pro forma to actual, put both on the same buckets: lot, hard costs, soft costs, financing, selling costs and sale price. Pull actuals from the house's inventory account and the seller side of the settlement statement, then explain the margin gap line by line. Do it at every closing, not once a year.

Why the comparison matters

Every spec home starts with a pro forma: a one-page projection of what the lot, the build, the loan and the sale will cost and what is left when the house closes. Building Optimal describes it as the answer to one question, how much money is left when it sells. The pro forma decides whether you buy the lot. The comparison after closing tells you whether the pro forma was right, and that is what makes the next one better.

Most builders know the total profit on a spec house within a few weeks of closing. Fewer know why it was different from the deal they underwrote. Was it the sale price, a framing overrun, two extra months of interest, or a concession at closing? Without the bridge, the same miss happens on the next lot.

Use the same buckets on both sides

The comparison only works if the pro forma and the books are organized the same way. A common layout, and the one Building Optimal uses, has these buckets:

  • Land: lot price, closing costs on the purchase, survey and title.
  • Hard costs: site work, utilities, every trade and landscaping, by cost code.
  • Soft costs: plans, engineering, permits and impact fees, builder's risk insurance and property taxes during the build.
  • Financing: loan fees and interest while the house is built and on the market.
  • Selling costs: commissions, seller closing costs, staging and concessions.
  • Contingency: the line for what you did not know yet.

NAHB's Cost of Constructing a Home survey splits the sale price of a new home in a similar way, into finished lot cost, construction cost, financing, overhead and general expenses, marketing, sales commission and profit. If your pro forma carries a line for company overhead, decide up front whether the comparison is before or after that allocation, and keep it the same every time. See overhead allocation.

Want pro forma vs actual reported on every spec house? Request a Relationship Assessment.

Where the actual numbers come from

  • Lot, hard and soft costs, and capitalized carrying costs: the house's inventory account and its job cost report by cost code. Our spec home accounting guide covers how those build up by house.
  • Interest and property taxes: whether these sit in the house's cost or were expensed depends on your CPA's policy. Pull them from wherever they were booked so the financing bucket is complete. See spec home carrying costs and interest reserves.
  • Sale price and selling costs: the seller side of the settlement statement, not the wire. See recording a spec home sale.

A SAMPLE comparison (made-up numbers)

SAMPLE only. One spec house, pro forma vs actual at closing:

  • Sale price: pro forma $780,000, actual $765,000. Variance: $15,000 less.
  • Land: $140,000 vs $140,000. No variance.
  • Hard costs: $430,000 vs $446,000. Variance: $16,000 over (framing and a drainage fix).
  • Soft costs: $38,000 vs $41,000. Variance: $3,000 over (impact fee change).
  • Financing: $24,000 vs $31,000. Variance: $7,000 over (house sat two months longer).
  • Selling costs: $42,000 vs $49,000. Variance: $7,000 over (a seller concession).
  • Contingency: $15,000 budgeted, $0 left as its own line, because the overruns used it.

Pro forma profit was $780,000 minus $689,000, or $91,000. Actual profit was $765,000 minus $707,000, or $58,000. The $33,000 gap breaks down as $15,000 price, $16,000 hard costs, $3,000 soft costs, $7,000 financing and $7,000 selling costs, partly offset by $15,000 of contingency that was in the pro forma but not spent as a separate line. Each number has a one-line reason. That is the margin bridge.

Turn the bridge into the next pro forma

  1. Time drives cost. If financing ran over, check the build schedule and days on market you assumed. A month of carry is a real line, not a rounding error.
  2. Look for repeat overruns by cost code. If the same trade runs over on three houses, the estimate is wrong, not the house. See how to read a job cost report.
  3. Price concessions as a selling cost. Concessions are real money off the sale, so put a line for them in the pro forma.
  4. Keep the original pro forma frozen. Save the version you used to buy the lot. Update a separate forecast monthly while the house is built, so you can see both the original miss and the in-process trend.
  5. Review by house, then by subdivision or plan. One house tells a story. Five houses on the same plan tell you what to change.

Common mistakes

  • Comparing to the wire amount instead of the gross sale price and itemized selling costs.
  • Leaving interest out of the actuals because it was expensed, which makes the house look better than the deal really was.
  • Updating the pro forma during the build and losing the original numbers.
  • Mixing costs between houses in the same subdivision, so one house looks great and the next looks bad.

How we help

Our team tracks each spec home in its own inventory and job cost detail, records the closing from the settlement statement and prepares a pro forma vs actual comparison for every house that closes. 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, fractional controller, pricing or request a Relationship Assessment.

Sources

Common questions

What is a spec home pro forma?

A projection of a spec house's sale price and costs (lot, hard costs, soft costs, financing, selling costs and contingency) that shows the expected profit before you buy the lot.

When should we compare pro forma to actual?

At every closing, while the details are fresh, and again across houses on the same plan or in the same subdivision.

Where do the actual numbers come from?

The house's inventory account and job cost report for lot and construction costs, wherever interest and taxes were booked for financing, and the seller side of the settlement statement for the sale price and selling costs.

Should interest be part of the comparison?

Yes. Even if your CPA's policy expenses some interest, include it in the financing bucket so the comparison shows the full cost of the deal.

Should we update the pro forma during the build?

Keep the original frozen and keep a separate monthly forecast. You need both to see the original miss and the trend.

Can you prepare this comparison for each house?

Yes. Our team prepares a pro forma vs actual comparison and margin bridge for every spec house that closes.

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.