Construction budget tracker: $84,026 over the line budgets at month 12

A development analyst asks Compound for a month-end cost control ledger on an illustrative 120-home build-to-rent community in Birmingham, Alabama: budget set from a public homebuilder's filings, 14 change orders sized from BLS price series, contingency, the draw pipeline and two roll-ups.

Compound Research · Updated Nov 15, 2026 · 13 min read

Short answer

A construction budget tracker compares each cost line's budget with what is committed, spent and forecast, every month. In Compound's illustrative tracker for 120 build-to-rent homes in Birmingham, Alabama, month 12 of 20 shows a forecast $84,026 over the line budgets, against $821,527 of contingency remaining.

Try it now
On this page (10)
  1. 1. Where does the construction budget come from?
  2. 2. How does the ledger keep budget, committed and spent apart?
  3. 3. What do 14 change orders do to the budget?
  4. 4. Is the contingency being used faster than the work is being built?
  5. 5. What is in the draw pipeline, and how does the lender see it?
  6. 6. Where does the investor report show the risk?
  7. 7. Which lines are forecast to finish over budget?
  8. 8. What would your own contracts, invoices and draw requests add?
  9. 9. Our view
  10. 10. Frequently asked questions

At the month-end of October 31, 2026, month 12 of a 20-month build, 10 of the 37 cost lines in this construction budget tracker are forecast to finish over budget. The overruns net to $84,026 after savings on other lines, against $821,527 of contingency remaining. One line, framing labor, is already committed $31,078 above its current budget.

You are the development or construction manager at a real estate investor, and every month you report what has been bought, what has been paid, what is left, and whether the contingency will last. We asked Compound to build the ledger that answers them for a build-to-rent community of 120 single-family rental homes. The project is illustrative, with no real community behind it. The budget is set from a public homebuilder’s reported cost per home, the change orders are sized from published price and wage series, and the committed and spent entries are analyst assumptions marked as such in the workbook. Compound ran on November 15, 2026 and returned one Excel workbook.

What the workbook shows:

  • The original budget is $31,588,844, or $263,240 per home. Approved change orders funded by the owner raise the current budget to $31,798,844.
  • $27,000,429 is committed and $21,158,433 is spent. The difference, $5,841,997, is the draw pipeline: work under contract that the lender has not yet funded.
  • Fourteen change orders total $577,463. Ten drew $329,515 from contingency, two moved $37,948 between lines, and two added $210,000 of owner-funded scope.
  • Contingency used is 28.6% with construction 56.2% complete. The contingency started at $1,151,042 and stands at $821,527.
  • Forecast cost at completion is $31,061,343 before contingency, against a budget of $30,977,317 on the same basis. After the $84,026 overrun, $737,501 of contingency would remain.
  • All 16 workbook checks pass. They tie the ledger to the draws, the roll-ups to the ledger and every change order to a funding source.

The budget basis comes from LGI Homes’ 10-Q for the quarter ended September 30, 2026, its 10-K for fiscal 2025 (SEC EDGAR) and its fourth-quarter 2025 earnings call. The escalation series are four producer price indexes and one wage series from the Bureau of Labor Statistics. The metro was chosen with Zillow’s home value and rent indexes and the Census Bureau’s Building Permits Survey. Everything else is an analyst assumption, and the Assumptions sheet says so line by line.

Prompt to try

“I am the development analyst on a build-to-rent community of single-family homes and want a construction budget tracker that compares spend with the underwritten budget every month, anchored on public facts. Set the project as 120 rental homes in a metro you pick from the data: one where Census building permits show steady single-family volume and Zillow ZHVI home values and ZORI rents are both rising. Set the budget from a public homebuilder active in that region: take its average construction cost per home, land cost per home and average home size from its latest 10-K, 10-Q and earnings call, and break the cost into about 30 line items (site work, foundation, framing lumber, roofing, mechanical, electrical, plumbing, finishes, soft costs, financing costs, contingency), with the split as an analyst assumption. Date the budget 12 months ago and place the project at month 12 of 20. Build the cost ledger with one row per line: original budget, approved revisions, current budget, committed (signed contracts, purchase orders and approved change orders), spent (funded draws, each tied to a lender draw number), contingency remaining, and draw pipeline as committed minus spent. Fill committed and spent to date as illustrative entries marked analyst assumption. Build a change-order log of 10 to 15 dated entries, each naming its line, amount, reason and funding source (contingency, owner-funded or reallocation); size the material-driven ones from the actual change in the matching BLS PPI series for lumber, concrete, steel and gypsum over those 12 months, and the labor-driven ones from the BLS construction wage series. For lines not yet bought, forecast cost at completion with the same series. Build month-end roll-ups in two layouts: investor-report categories and lender draw-package categories. Report contingency remaining, the draw pipeline, month-end variance by line, cumulative change orders against remaining contingency, and forecast cost at completion against budget. Keep the original budget visible after a revision, and add a check that every change order names a funding source. Flag any line committed above budget, contingency used faster than percent complete, and a forecast over budget. Use the stored public data wherever it has the figure, and web search only for what it lacks. Put every input on an Assumptions sheet with one column that says where it came from: a cited source, or "analyst assumption" for a figure I would set myself, with the reason for the value you chose. Every output must be a live formula that traces back to the Assumptions sheet. Add a Sources sheet listing each data source, what it gave and its date. Deliver one Excel workbook and a short summary of the result, the flags, and what I would need from the seller to firm it up. Cite every sourced figure.”

Try this prompt free →

That is the request as we sent it, without its closing line, which asks that no name or email be put in the workbook.

Where does the construction budget come from?

The budget is $191,840 of construction cost per home plus $70,000 of land per home, both taken from one public homebuilder’s filings and earnings call. The split of that cost into 37 lines is an analyst assumption.

A tracker measures spend against a budget, so the first check is the budget itself. On a live project the budget comes from the development underwriting; our real estate development pro forma page shows a model that sets one. Here the request asked Compound to anchor the budget on a public homebuilder active in the chosen region.

Compound chose the Birmingham-Hoover, Alabama metro. The request asked for a metro where home values and rents are both rising and single-family permit volume is steady. Zillow’s home value index for the metro rose from $254,485 in September 2025 to $260,710 in September 2026, a 2.4% change, and its rent index rose from $1,363 to $1,404, a 3.0% change. Single-family permits were 3,167 in 2024 and 3,127 in 2025, a 1.3% decline, and 2,352 in the first nine months of 2026 against 2,464 in the same months of 2025, a 4.5% decline. The workbook labels both permit comparisons “Steady (within 10%)”. The homebuilder is LGI Homes, whose Southeast segment includes Alabama according to its filings. Its 10-Q reports $229.6 million of Southeast cost of sales on 877 home closings in the nine months ended September 30, 2026. Compound divides one by the other to get $261,840 of all-in cost per home, subtracts the finished lot cost of about $70,000 that the company gave on its fourth-quarter 2025 earnings call, and treats the remaining $191,840 as construction cost per home.

BTR_Birmingham_Construction_Budget_Tracker.xlsx
C33fx=C26*1000/C27
BCDN
25HOMEBUILDER BENCHMARK: LGI HOMES, SOUTHEAST SEGMENT (INCLUDES ALABAMA)Source / basis
26Southeast cost of sales, 9M 2026229,634$000LGI Homes 10-Q for Q3 2026, segment cost of sales, nine months
27Southeast home closings, 9M 2026877homesLGI Homes 10-Q for Q3 2026, segment home closings, nine months
28Capitalized interest in cost of sales, 9M 2026 (company)41,171$000LGI Homes 10-Q for Q3 2026, adjusted gross margin reconciliation
29Home closings, 9M 2026 (company)3,435homesLGI Homes 10-Q for Q3 2026, operating data
30Average finished lot cost per home$70,000$LGI Homes Q4 2025 earnings call, CFO: average finished lot cost about $70,000
33Builder all-in cost per home$261,840$Calculated: Southeast cost of sales / Southeast closings
34Capitalized interest per home$11,986$Calculated: reference for the financing split
35Land cost per home$70,000$LGI finished lot cost (row 30)
36Construction cost per home$191,840$Calculated: all-in cost less lot cost; includes builder indirects and capitalized interest, which the split allocates to soft-cost and financing lines
37Construction cost per sq ft$106.58$/sq ftCalculated
38Construction cost pool, project$23,020,844$Calculated: construction cost per home x homes
39Land cost, project$8,400,000$Calculated: lot cost per home x homes
SummaryAssumptionsLedgerChange OrdersDrawsRollupsChecksSources
The homebuilder benchmark block of the Assumptions sheet, columns B, C, D and N. Rows 31 and 32, the home size range, are left out. Cells are as Compound wrote them.

Three things in this block are assumptions you should replace. The average home is assumed at 1,800 square feet, inside the range of 900 to 4,000 square feet that the 10-K gives for the company’s homes, which puts construction cost at $106.58 per square foot. A builder’s cost of sales includes its indirect costs and capitalized interest, and the note on that row says the line split allocates those to the soft-cost and financing lines. And the split itself, 35 construction lines sharing a pool of $23,020,844, is illustrative. Land is $8,400,000 for 120 finished lots plus 2.0% for closing, title and due diligence.

Original budget by investor-report category

Illustrative 120-home project; $31,588,844 in total

Land & Acquisition$8,568,000Site Work$2,417,189Foundation$1,703,542Framing$3,798,439Exterior & Roofing$2,302,084Mechanical, Electrical & Plumbing$2,670,418Interior Finishes$4,373,960Soft Costs$3,107,814Financing$1,496,355Contingency$1,151,042

BTR_Birmingham_Construction_Budget_Tracker.xlsx, Rollups sheet, cells C7 to C16. The land figure is sourced from the homebuilder's earnings call; the split of construction cost across categories is an analyst assumption.

The contingency line is 5% of the construction cost pool, $1,151,042. Measured against the site and vertical hard-cost budget alone it is 6.7% (our arithmetic, Ledger F43 divided by the sum of Rollups C22 and C23), because the pool it is taken from also holds soft costs and financing.

How does the ledger keep budget, committed and spent apart?

Each of the 37 lines carries its original budget, approved revisions, current budget, committed amount and spent amount on one row, and every other column is a formula on those five. Committed is $27,000,429 of a $31,798,844 current budget, and spent is $21,158,433.

Budget is what you planned to pay. Committed is what you have agreed to pay: signed contracts, purchase orders and approved change orders. Spent is what the lender has funded through a draw.

BTR_Birmingham_Construction_Budget_Tracker.xlsx
I20fx=IF(D20="Contingency",0,F20*Assumptions!I65*Assumptions!J65+SUMIFS('Change Orders'!$N$7:$N$20,'Change Orders'!$D$7:$D$20,C20))
BCFGHIJKLMN
5Line itemCodeOriginal budgetApproved revisionsCurrent budgetCommittedSpent (funded draws)Last draw #Contingency remainingDraw pipelineUncommitted budget
7Land / finished lots (120 lots)L018,400,000-8,400,0008,400,0008,400,0001---
12Driveways, walks & flatworkL06460,417-460,417276,250110,50011-165,750184,167
18Framing lumber packageL121,726,56377,6831,804,2461,804,2461,659,90711-144,340-
20Framing laborL141,035,93819,6301,055,5681,086,646923,64911-162,997(31,078)
25HVAC (mechanical)L19920,83454,566975,400975,400487,70011-487,700-
29DrywallL23805,7301,924807,654485,36272,80411-412,557322,292
32FlooringL26575,521132,000707,521132,000---132,000575,521
41Construction loan interestL351,197,084-1,197,0841,197,084478,83411-718,250-
43Hard-cost contingencyL371,151,042(329,515)821,527---821,527-821,527
44Total project ($)31,588,844210,00031,798,84427,000,42921,158,433821,5275,841,9974,798,414
SummaryAssumptionsLedgerChange OrdersDrawsRollupsChecksSources
Ten of the 37 Ledger rows and the total row, columns B, C and F to N. The category, plan and forecast columns are left out here. Committed and spent are illustrative analyst assumptions. Cells are as Compound wrote them.

Read the framing labor row, L14. Its original budget is 1,035,938, a change order added 19,630, and the current budget is 1,055,568. The committed amount is 1,086,646, because the Assumptions sheet records the framing contract as signed 3% above budget. The uncommitted column therefore shows (31,078), and the ledger raises a flag. The money for a signed contract above budget has to come from contingency, from another line, or from the owner.

The columns on the right of the excerpt are the ones a cost manager reads each month:

  • Draw pipeline is committed minus spent, $5,841,997 in total. HVAC alone has 487,700 committed and not yet funded.
  • Uncommitted budget is current budget minus committed. Excluding contingency it is $3,976,887, and it is the part of the project still exposed to price changes.
  • Last draw # ties each line’s spend to a lender draw. Land funded in draw 1, and most active lines last funded in draw 11.
  • Contingency remaining sits on its own row, L37, so that it is never mixed into a trade line.

The spent column reads the Draws sheet, where each line’s funded amount is laid out by month and by draw number.

What do 14 change orders do to the budget?

The log holds 14 approved change orders totaling $577,463, and each one names the line it changes and where the money comes from. Only the two owner-funded entries, $210,000 together, raise the total budget.

Every change order has to say who pays, and the workbook allows three answers. A contingency-funded change order raises the trade line and lowers the contingency line by the same amount. A reallocation raises one line and lowers another. An owner-funded change order raises the line and the total budget, and the owner brings new money.

BTR_Birmingham_Construction_Budget_Tracker.xlsx
N7fx=IF(F7="Scope",Assumptions!I93*Assumptions!$C$6,ROUND(M7*K7*J7*L7,0))
BCEFGHJKLNO
5CO #DateLine itemSizing driverFunding sourceReallocated fromIndex changeLine index exposureRepriced shareAmountCumulative
7CO-01Dec 16, 2025Framing lumber packageLumberContingency10.6%85.0%50.0%77,68377,683
8CO-02Jan 13, 2026Roof trusses & sheathingLumberContingency10.6%80.0%40.0%27,296104,979
9CO-03Jan 27, 2026Slab-on-grade foundation concreteConcreteContingency2.4%65.0%60.0%11,417116,396
10CO-04Feb 10, 2026Rebar & post-tension steelSteelContingency32.9%80.0%70.0%63,660180,056
11CO-05Mar 17, 2026Framing laborLaborContingency4.2%90.0%50.0%19,630199,686
12CO-06Apr 14, 2026Structural steel, connectors & hardwareSteelReallocationL0332.9%80.0%50.0%30,314230,000
13CO-07May 12, 2026RoofingLaborReallocationL294.2%45.0%50.0%7,634237,634
14CO-08Jun 9, 2026ElectricalLaborContingency4.2%55.0%50.0%10,130247,764
15CO-09Jun 23, 2026PlumbingLaborContingency4.2%50.0%50.0%9,209256,973
16CO-10Jul 14, 2026HVAC (mechanical)SteelContingency32.9%30.0%60.0%54,566311,539
17CO-11Aug 4, 2026Water/sewer taps & utility tie-insScopeContingency0.0%0.0%0.0%54,000365,539
18CO-12Sep 1, 2026DrywallGypsumContingency0.9%45.0%60.0%1,924367,463
19CO-13Sep 22, 2026FlooringScopeOwner-funded0.0%40.0%0.0%132,000499,463
20CO-14Oct 13, 2026Appliances, fixtures & hardwareScopeOwner-funded0.0%0.0%0.0%78,000577,463
21Total approved change orders ($)577,463
SummaryAssumptionsLedgerChange OrdersDrawsRollupsChecksSources
The Change Orders log, rows 5 to 21, columns B, C, E to H, J to L, N and O. The line code, budget and reason columns are left out. All 14 entries are illustrative. Cells are as Compound wrote them.

Eleven of the entries are price-driven, and Compound sized them from published series instead of choosing amounts. The formula in the amount column multiplies the line’s original budget by the share of the line exposed to the index, the 12-month change in the index, and the share of the line that was repriced. The first entry, on December 16, 2025, adds 77,683 to the framing lumber package. Every price-driven entry uses the full 12-month change in its series, whatever its date. An entry dated December 2025 is therefore sized with price data published after it, and on a live project the amount comes from the contractor’s request. The other three entries are scope changes priced per home: $450 per home for utility tie-ins, $1,100 per home for a flooring upgrade and $650 per home for appliances.

12-month change in the cost series behind the change orders

BLS producer price indexes, October 2025 to October 2026 (preliminary), and average hourly earnings, September 2025 to September 2026

Softwood lumber (PPI WPU0811)10.6%Ready-mix concrete (PPI WPU1333)2.4%Steel mill products (PPI WPU1017)32.9%Gypsum products (PPI WPU137)0.9%Specialty trade wages (CES2023800003)4.2%

BTR_Birmingham_Construction_Budget_Tracker.xlsx, Assumptions sheet, cells H43 to H47, from the Bureau of Labor Statistics series named in each label.

Steel is the series that moved. The producer price index for steel mill products rose 32.9% over the 12 months, against 10.6% for softwood lumber, 4.2% for specialty trade contractor wages, 2.4% for ready-mix concrete and 0.9% for gypsum products. The three steel-driven change orders, on rebar, structural connectors and HVAC, total $148,540 (our arithmetic, Change Orders N10, N12 and N16). All 11 price-driven entries total $313,463 and the three scope entries total $264,000 (our arithmetic on the same column).

The two reallocations show the mechanism you want in any tracker. Site clearing was bought 6% under budget, and CO-06 moves 30,314 of that saving to structural steel. Architecture and engineering was bought 8% under budget, and CO-07 moves 7,634 to roofing. The receiving line rises and the giving line falls, so the total does not change.

Is the contingency being used faster than the work is being built?

No. Contingency used is 28.6% while construction is 56.2% complete by cost, so the workbook’s test returns OK.

The contingency started at $1,151,042. Ten contingency-funded change orders have drawn $329,515, leaving $821,527. The Summary sheet compares the rate of use with the rate of progress in one formula and prints OK or FLAG. Percent complete here is measured by cost, spent over current budget with land and contingency excluded from both, and the schedule is 60.0% elapsed. The cost figure runs through draw 11 and the schedule figure through month 12, so the two are a month apart.

Contingency remaining at each month-end

Illustrative project, months 1 to 12 of 20; original contingency $1,151,042

Month 1: Nov 2025$1,151,042Month 2: Dec 2025$1,073,359Month 3: Jan 2026$1,034,646Month 4: Feb 2026$970,986Month 5: Mar 2026$951,356Month 6: Apr 2026$951,356Month 7: May 2026$951,356Month 8: Jun 2026$932,017Month 9: Jul 2026$877,451Month 10: Aug 2026$823,451Month 11: Sep 2026$821,527Month 12: Oct 2026$821,527

BTR_Birmingham_Construction_Budget_Tracker.xlsx, Rollups sheet, cells D63 to O63, with month-ends from row 32.

The month-end series shows when the contingency was spent. It fell to 951,356 by month 5 as the lumber, concrete, steel and framing labor change orders landed, held there for three months while the two reallocations were funded from buyout savings, and then fell to 821,527 by month 11.

The second ratio the request asked for is cumulative change orders against remaining contingency. It stood at 0.07x in month 2, 0.44x in month 10 and 0.70x at month 12. The ratio counts all approved change orders, including the owner-funded ones that never touch contingency, so it rises faster than contingency falls.

A third comparison is ours. The $821,527 of contingency remaining is 20.7% of the $3,976,887 of budget that is still uncommitted (our arithmetic, Summary C34 divided by C28). The unbought scope would have to cost about a fifth more than budgeted before contingency ran out.

What is in the draw pipeline, and how does the lender see it?

The lender has funded $21,158,433 through draw 11, which is 66.5% of the scheduled value, and $5,841,997 more is committed and not yet funded. The lender layout regroups the same 37 lines into seven draw categories.

The Assumptions sheet gives every line an investor-report category and a lender draw category, and the Rollups sheet sums the ledger by each.

BTR_Birmingham_Construction_Budget_Tracker.xlsx
E22fx=SUMPRODUCT((Draws!$E$7:$E$43=$B22)*(Draws!$F$3:$Y$3<Assumptions!$C$10)*Draws!$F$7:$Y$43)
BCDEFGHIJ
20CategoryOriginal budgetScheduled value (current budget)Funded prior drawsFunded this drawTotal funded to date% fundedBalance to finishCommitted not yet funded
21Land Acquisition8,568,0008,568,0008,568,000-8,568,000100.0%--
22Site Improvements2,417,1892,440,8751,367,06735,1591,402,22657.4%1,038,649274,744
23Vertical Hard Costs14,848,44415,371,9077,011,1501,186,4198,197,56953.3%7,174,3383,981,347
24Soft Costs2,417,1892,409,5551,760,257106,9631,867,22177.5%542,334522,343
25Developer Fee690,625690,625313,92131,392345,31350.0%345,313345,313
26Interest & Financing1,496,3551,496,355734,57443,530778,10552.0%718,250718,250
27Contingency1,151,042821,527----821,527-
28Total ($)31,588,84431,798,84419,754,9691,403,46421,158,43366.5%10,640,4115,841,997
SummaryAssumptionsLedgerChange OrdersDrawsRollupsChecksSources
The lender draw-package block of the Rollups sheet, rows 20 to 28, columns B to J. Funded amounts are illustrative analyst assumptions. Cells are as Compound wrote them.

The layout follows a draw request: scheduled value, funded in prior draws, funded this draw, total funded, percent funded and balance to finish. Draw 11 funded 1,403,464, of which 1,186,419 was vertical hard costs. Vertical hard costs are 53.3% funded, with 7,174,338 still to fund and 3,981,347 of that already under contract. Land is fully funded. The contingency category shows a scheduled value of 821,527 and nothing funded, because contingency is released to a trade line by change order and funded there.

The pipeline number tells you about the next few draws. Among the investor categories, interior finishes carries the largest pipeline at 1,344,261, with only 145,320 spent, and mechanical, electrical and plumbing is next at 1,283,715. If you finance the project with a loan that converts at completion, the construction-to-permanent loan model tests whether the permanent loan repays the construction balance. The funded total here includes land and cost paid with equity, so the loan balance is smaller than it.

Against the baseline plan, funded draws through month 11 are $289,824 ahead. The plan spreads the original budget, excluding contingency, across each line’s start and end months, and the Rollups sheet tracks the cumulative difference month by month.

Where does the investor report show the risk?

Interior finishes is the category to watch: $3,096,303 of its $4,585,884 current budget is uncommitted, and it carries $56,974 of the forecast overrun. Foundation and framing are 99.6% and 90.1% spent, so their numbers are nearly final.

BTR_Birmingham_Construction_Budget_Tracker.xlsx
K8fx=SUMIFS(Ledger!$Q$7:$Q$43,Ledger!$D$7:$D$43,$B8)
BCDEFGHIJKLM
6CategoryOriginal budgetApproved revisionsCurrent budgetCommittedSpentDraw pipelineUncommittedContingency remainingForecast at completionVariance to budgetSpent % of current
7Land & Acquisition8,568,000-8,568,0008,568,0008,568,000---8,568,000-100.0%
8Site Work2,417,18923,6862,440,8751,676,9691,402,226274,744763,905-2,461,202(20,327)57.4%
9Foundation1,703,54275,0771,778,6191,771,7131,771,713-6,906-1,771,7136,90699.6%
10Framing3,798,439154,9233,953,3623,984,4403,562,538421,902(31,078)-3,984,440(31,078)90.1%
11Exterior & Roofing2,302,0847,6342,309,7182,188,8591,257,390931,469120,859-2,312,263(2,545)54.4%
12Mechanical, Electrical & Plumbing2,670,41873,9052,744,3232,744,3231,460,6081,283,715--2,744,323-53.2%
13Interior Finishes4,373,960211,9244,585,8841,489,581145,3201,344,2613,096,303-4,642,858(56,974)3.2%
14Soft Costs3,107,814(7,634)3,100,1803,080,1892,212,533867,65619,991-3,080,18919,99171.4%
15Financing1,496,355-1,496,3551,496,355778,105718,250--1,496,355-52.0%
16Contingency1,151,042(329,515)821,527---821,527821,527-821,527-
17Total ($)31,588,844210,00031,798,84427,000,42921,158,4335,841,9974,798,414821,52731,061,343737,50166.5%
SummaryAssumptionsLedgerChange OrdersDrawsRollupsChecksSources
The investor-report block of the Rollups sheet, rows 6 to 17, columns B to M. Committed and spent are illustrative analyst assumptions. Cells are as Compound wrote them.

Categories that are finished or nearly finished have small uncommitted balances and variances that are known: foundation finished 6,906 under budget, and framing is 31,078 over because of the labor contract. Categories in progress, exterior and the mechanical trades, are mostly committed and about half spent. Interior finishes is 3.2% spent and about a third committed, so most of its cost is still a forecast.

At month 12 of 20 the risk has moved out of the early trades, where contracts are signed, and into the late ones. The total variance of $737,501 under the current budget is the contingency, $821,527, less the $84,026 of forecast overruns.

Which lines are forecast to finish over budget?

Ten lines are forecast over their current budgets by a combined $115,141, and three lines bought under budget give back $31,115 (our arithmetic on Ledger column R). The net is the $84,026 overrun on the Summary sheet.

The forecast for each line is what is committed plus the cost of what is not yet bought. For the unbought share, the workbook starts from the original budget and escalates it by the same Bureau of Labor Statistics series used for the change orders, scaled by the line’s exposure to that series. A fully bought line is forecast at its committed amount.

BTR_Birmingham_Construction_Budget_Tracker.xlsx
Q12fx=IF(D12="Contingency",0,I12+F12*(1-Assumptions!I57)*(1+Assumptions!H57*INDEX(Assumptions!$H$43:$H$48,MATCH(Assumptions!G57,Assumptions!$B$43:$B$48,0))))
BCHINQRST
5Line itemCodeCurrent budgetCommittedUncommitted budgetForecast at completionVariance to budgetCommitted > budgetForecast > budget
9Site clearing & mass gradingL03545,207540,9904,217540,9904,217
12Driveways, walks & flatworkL06460,417276,250184,167463,068(2,651)FLAG
13Landscaping & irrigationL07345,313-345,313352,583(7,270)FLAG
14FencingL08230,208-230,208244,831(14,623)FLAG
17Termite treatment & waterproofingL11138,125131,2196,906131,2196,906
20Framing laborL141,055,5681,086,646(31,078)1,086,646(31,078)FLAGFLAG
24Siding, soffit & exterior trimL18805,730684,870120,859808,274(2,545)FLAG
28InsulationL22345,313241,719103,594347,276(1,963)FLAG
29DrywallL23807,654485,362322,292808,936(1,283)FLAG
30Interior trim & doorsL24575,521-575,521605,985(30,464)FLAG
32FlooringL26707,521132,000575,521717,215(9,694)FLAG
33Interior & exterior paintL27460,417-460,417473,988(13,571)FLAG
35Architecture & engineeringL29337,679317,68819,991317,68819,991
43Hard-cost contingencyL37821,527-821,527-821,527
44Total project ($)31,798,84427,000,4294,798,41431,061,343737,501110
SummaryAssumptionsLedgerChange OrdersDrawsRollupsChecksSources
The Ledger rows whose forecast differs from budget, with the contingency and total rows, columns B, C, H, I, N and Q to T. Forecasts rest on illustrative buyout assumptions and on the BLS series. Cells are as Compound wrote them.

Forecast overrun by cost line

Forecast at completion above current budget, illustrative project at month 12 of 20

L14 Framing labor$31,078L24 Interior trim & doors$30,464L08 Fencing$14,623L27 Interior & exterior paint$13,571L26 Flooring$9,694L07 Landscaping & irrigation$7,270L06 Driveways, walks & flatwork$2,651L18 Siding, soffit & exterior trim$2,545L22 Insulation$1,963L23 Drywall$1,283

BTR_Birmingham_Construction_Budget_Tracker.xlsx, Ledger sheet, column R for the 10 lines flagged in column T, shown as positive amounts. Framing labor is the one line also flagged as committed above budget.

The two largest overruns have different causes, and the tracker keeps them apart with two flags. Framing labor is 31,078 over because of a signed contract; it appears in both the committed flag and the forecast flag. Interior trim and doors is forecast 30,464 over and nothing on that line has been bought; the overrun is the escalation the workbook applies to the unbought budget. Fencing at 14,623, paint at 13,571, flooring at 9,694 and landscaping at 7,270 are the same kind: unbought lines carried at an escalated price.

The escalation rule is an analyst assumption. It applies the last 12 months’ change in each index to work that will be bought in the next eight months. If lumber and steel prices flatten, the forecast overruns on the unbought lines shrink. The Summary sheet gathers the result into six flags. Two are raised: one line committed above budget and 10 lines forecast above budget. Four are clear: contingency is being used more slowly than the work is being completed, the forecast is inside the total current budget, every change order names a valid funding source, and all 16 checks pass.

What would your own contracts, invoices and draw requests add?

Public data can set a plausible budget and tell you how prices moved, and it cannot tell you what you signed or what you paid. On a live project every illustrative column in this workbook is replaced by a document you already hold.

There is no seller on a ground-up build. The information that firms up the tracker sits in your own project files and with your lender. In the order the ledger uses them:

  • The underwritten budget by line and the home plans. The 37-line split and the 1,800 square foot average home are assumptions. Your budget replaces the original budget column, and the plans replace the cost per square foot.
  • Executed subcontracts, purchase orders and the buyout log. These replace the committed column. The escalation clauses in each contract decide whether a price index change becomes a change order at all, which the index-sized entries here assume it does.
  • The approved change-order log with backup. Dates, amounts, reasons and the funding decision for each entry replace the 14 illustrative ones.
  • Lender draw packages and the pending draw. Draws 1 to 11, with the inspector’s reports and the amounts funded, replace the spent column. Draw requests also show retainage held on each contract, which a live ledger carries as a separate column between billed and funded.
  • The loan agreement and the land closing statement. These replace the interest and fee lines and the land lines, and they set the rules for moving budget between lender categories.
  • The current schedule, the inspector’s percent complete and lien waivers. Percent complete by cost is a proxy. The inspector’s figure is the one the lender funds against.

The public benchmark has its own limits. A homebuilder’s cost of sales per home reflects its scale, its plans and its land position, and its segment figure averages several states. The benchmark is also later than the budget it sets: the build starts in November 2025, and the 10-Q covers the nine months ended September 30, 2026. The price indexes are national, and the October 2026 figures are preliminary.

Our view

The structure of this tracker is right for a monthly cost report, and the single most useful feature is that every change order must name its funding source. The dollar results are illustrative and should be read as a worked example.

Two other choices are worth copying. Contingency is its own line that only a logged change order can reduce. The forecast separates a signed overrun from a projected one, which tells you whether to negotiate, reallocate or wait.

On the numbers as modeled, the project is in ordinary condition for month 12: a forecast overrun of $84,026 is about a tenth of the remaining contingency, and contingency is being used more slowly than the work is being built. The exposure is the $3,096,303 of interior finishes not yet bought.

What would change that reading: buying out the interior trades at or under budget would remove most of the forecast overrun, and a second signed contract above budget would matter more than any index, because it cannot be bought back. This page describes a method. It does not forecast any real project and it is not advice.

If you are earlier in the process and still setting the budget, start with the real estate pro forma page.

Build-to-rent construction budget tracker (Excel)Compound’s workbook from this run: a one-page Summary, every input with its source on Assumptions, the 37-line cost Ledger, the Change Orders log, monthly Draws, the investor and lender Rollups, 16 Checks and the Sources list. The project and its entries are illustrative.Download · Free

Frequently asked questions

What is a construction budget tracker?

It is a ledger with one row per cost line that compares the budget with what has been committed, what has been spent and what the line is forecast to cost at completion, updated every month. The workbook on this page has 37 lines for an illustrative 120-home project and shows a current budget of $31,798,844, $27,000,429 committed and $21,158,433 spent at month 12 of 20.

What is the difference between committed and spent in a construction budget?

Committed is what you have agreed to pay under signed contracts, purchase orders and approved change orders. Spent is what has been paid, which on a financed project means funded through a lender draw. The gap between them is the draw pipeline. In this workbook the pipeline is $5,841,997.

How do you track change orders against contingency?

Log every change order with its date, line, amount, reason and funding source, and let the ledger reduce the contingency line only for the entries funded from contingency. In this workbook 14 change orders total $577,463, of which $329,515 came from contingency, $37,948 was reallocated between lines and $210,000 was owner-funded. The ratio of cumulative change orders to remaining contingency is 0.70x.

How much contingency should a construction budget carry?

It depends on the project, the contracts and the lender. This workbook sets contingency at 5% of the construction cost pool as an analyst assumption, which is $1,151,042 on the illustrative project. The more useful monthly test is whether contingency is being used faster than the work is being completed: here 28.6% is used with construction 56.2% complete.

How do you forecast cost at completion?

Add what is committed to an estimate for what is not yet bought. The workbook escalates the unbought share of each line’s original budget by the 12-month change in a matching Bureau of Labor Statistics price or wage series, and it forecasts a fully bought line at its committed amount. The result is $31,061,343 before contingency, $84,026 above the budget on the same basis.

Can one tracker serve both the investor report and the lender draw request?

Yes, if every cost line carries two category labels. The workbook maps each of its 37 lines to an investor-report category and a lender draw category and sums the same ledger both ways. Both roll-ups show $21,158,433 funded to date, and two checks confirm that each ties to the ledger.

CoatueCentri ConsultingAvra783 Capital PartnersOctahedron CapitalArix ResearchCoatueCentri ConsultingAvra783 Capital PartnersOctahedron CapitalArix ResearchCoatueCentri ConsultingAvra783 Capital PartnersOctahedron CapitalArix Research

See this workflow on your own deal

Try it now