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.
“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.”
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.
| B | C | D | N | |
|---|---|---|---|---|
| 25 | HOMEBUILDER BENCHMARK: LGI HOMES, SOUTHEAST SEGMENT (INCLUDES ALABAMA) | Source / basis | ||
| 26 | Southeast cost of sales, 9M 2026 | 229,634 | $000 | LGI Homes 10-Q for Q3 2026, segment cost of sales, nine months |
| 27 | Southeast home closings, 9M 2026 | 877 | homes | LGI Homes 10-Q for Q3 2026, segment home closings, nine months |
| 28 | Capitalized interest in cost of sales, 9M 2026 (company) | 41,171 | $000 | LGI Homes 10-Q for Q3 2026, adjusted gross margin reconciliation |
| 29 | Home closings, 9M 2026 (company) | 3,435 | homes | LGI Homes 10-Q for Q3 2026, operating data |
| 30 | Average finished lot cost per home | $70,000 | $ | LGI Homes Q4 2025 earnings call, CFO: average finished lot cost about $70,000 |
| 33 | Builder all-in cost per home | $261,840 | $ | Calculated: Southeast cost of sales / Southeast closings |
| 34 | Capitalized interest per home | $11,986 | $ | Calculated: reference for the financing split |
| 35 | Land cost per home | $70,000 | $ | LGI finished lot cost (row 30) |
| 36 | Construction 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 |
| 37 | Construction cost per sq ft | $106.58 | $/sq ft | Calculated |
| 38 | Construction cost pool, project | $23,020,844 | $ | Calculated: construction cost per home x homes |
| 39 | Land cost, project | $8,400,000 | $ | Calculated: lot cost per home x homes |
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
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.
| B | C | F | G | H | I | J | K | L | M | N | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 5 | Line item | Code | Original budget | Approved revisions | Current budget | Committed | Spent (funded draws) | Last draw # | Contingency remaining | Draw pipeline | Uncommitted budget |
| 7 | Land / finished lots (120 lots) | L01 | 8,400,000 | - | 8,400,000 | 8,400,000 | 8,400,000 | 1 | - | - | - |
| 12 | Driveways, walks & flatwork | L06 | 460,417 | - | 460,417 | 276,250 | 110,500 | 11 | - | 165,750 | 184,167 |
| 18 | Framing lumber package | L12 | 1,726,563 | 77,683 | 1,804,246 | 1,804,246 | 1,659,907 | 11 | - | 144,340 | - |
| 20 | Framing labor | L14 | 1,035,938 | 19,630 | 1,055,568 | 1,086,646 | 923,649 | 11 | - | 162,997 | (31,078) |
| 25 | HVAC (mechanical) | L19 | 920,834 | 54,566 | 975,400 | 975,400 | 487,700 | 11 | - | 487,700 | - |
| 29 | Drywall | L23 | 805,730 | 1,924 | 807,654 | 485,362 | 72,804 | 11 | - | 412,557 | 322,292 |
| 32 | Flooring | L26 | 575,521 | 132,000 | 707,521 | 132,000 | - | - | - | 132,000 | 575,521 |
| 41 | Construction loan interest | L35 | 1,197,084 | - | 1,197,084 | 1,197,084 | 478,834 | 11 | - | 718,250 | - |
| 43 | Hard-cost contingency | L37 | 1,151,042 | (329,515) | 821,527 | - | - | - | 821,527 | - | 821,527 |
| 44 | Total project ($) | 31,588,844 | 210,000 | 31,798,844 | 27,000,429 | 21,158,433 | 821,527 | 5,841,997 | 4,798,414 |
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.
| B | C | E | F | G | H | J | K | L | N | O | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 5 | CO # | Date | Line item | Sizing driver | Funding source | Reallocated from | Index change | Line index exposure | Repriced share | Amount | Cumulative |
| 7 | CO-01 | Dec 16, 2025 | Framing lumber package | Lumber | Contingency | 10.6% | 85.0% | 50.0% | 77,683 | 77,683 | |
| 8 | CO-02 | Jan 13, 2026 | Roof trusses & sheathing | Lumber | Contingency | 10.6% | 80.0% | 40.0% | 27,296 | 104,979 | |
| 9 | CO-03 | Jan 27, 2026 | Slab-on-grade foundation concrete | Concrete | Contingency | 2.4% | 65.0% | 60.0% | 11,417 | 116,396 | |
| 10 | CO-04 | Feb 10, 2026 | Rebar & post-tension steel | Steel | Contingency | 32.9% | 80.0% | 70.0% | 63,660 | 180,056 | |
| 11 | CO-05 | Mar 17, 2026 | Framing labor | Labor | Contingency | 4.2% | 90.0% | 50.0% | 19,630 | 199,686 | |
| 12 | CO-06 | Apr 14, 2026 | Structural steel, connectors & hardware | Steel | Reallocation | L03 | 32.9% | 80.0% | 50.0% | 30,314 | 230,000 |
| 13 | CO-07 | May 12, 2026 | Roofing | Labor | Reallocation | L29 | 4.2% | 45.0% | 50.0% | 7,634 | 237,634 |
| 14 | CO-08 | Jun 9, 2026 | Electrical | Labor | Contingency | 4.2% | 55.0% | 50.0% | 10,130 | 247,764 | |
| 15 | CO-09 | Jun 23, 2026 | Plumbing | Labor | Contingency | 4.2% | 50.0% | 50.0% | 9,209 | 256,973 | |
| 16 | CO-10 | Jul 14, 2026 | HVAC (mechanical) | Steel | Contingency | 32.9% | 30.0% | 60.0% | 54,566 | 311,539 | |
| 17 | CO-11 | Aug 4, 2026 | Water/sewer taps & utility tie-ins | Scope | Contingency | 0.0% | 0.0% | 0.0% | 54,000 | 365,539 | |
| 18 | CO-12 | Sep 1, 2026 | Drywall | Gypsum | Contingency | 0.9% | 45.0% | 60.0% | 1,924 | 367,463 | |
| 19 | CO-13 | Sep 22, 2026 | Flooring | Scope | Owner-funded | 0.0% | 40.0% | 0.0% | 132,000 | 499,463 | |
| 20 | CO-14 | Oct 13, 2026 | Appliances, fixtures & hardware | Scope | Owner-funded | 0.0% | 0.0% | 0.0% | 78,000 | 577,463 | |
| 21 | Total approved change orders ($) | 577,463 |
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
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
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.
| B | C | D | E | F | G | H | I | J | |
|---|---|---|---|---|---|---|---|---|---|
| 20 | Category | Original budget | Scheduled value (current budget) | Funded prior draws | Funded this draw | Total funded to date | % funded | Balance to finish | Committed not yet funded |
| 21 | Land Acquisition | 8,568,000 | 8,568,000 | 8,568,000 | - | 8,568,000 | 100.0% | - | - |
| 22 | Site Improvements | 2,417,189 | 2,440,875 | 1,367,067 | 35,159 | 1,402,226 | 57.4% | 1,038,649 | 274,744 |
| 23 | Vertical Hard Costs | 14,848,444 | 15,371,907 | 7,011,150 | 1,186,419 | 8,197,569 | 53.3% | 7,174,338 | 3,981,347 |
| 24 | Soft Costs | 2,417,189 | 2,409,555 | 1,760,257 | 106,963 | 1,867,221 | 77.5% | 542,334 | 522,343 |
| 25 | Developer Fee | 690,625 | 690,625 | 313,921 | 31,392 | 345,313 | 50.0% | 345,313 | 345,313 |
| 26 | Interest & Financing | 1,496,355 | 1,496,355 | 734,574 | 43,530 | 778,105 | 52.0% | 718,250 | 718,250 |
| 27 | Contingency | 1,151,042 | 821,527 | - | - | - | - | 821,527 | - |
| 28 | Total ($) | 31,588,844 | 31,798,844 | 19,754,969 | 1,403,464 | 21,158,433 | 66.5% | 10,640,411 | 5,841,997 |
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.
| B | C | D | E | F | G | H | I | J | K | L | M | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6 | Category | Original budget | Approved revisions | Current budget | Committed | Spent | Draw pipeline | Uncommitted | Contingency remaining | Forecast at completion | Variance to budget | Spent % of current |
| 7 | Land & Acquisition | 8,568,000 | - | 8,568,000 | 8,568,000 | 8,568,000 | - | - | - | 8,568,000 | - | 100.0% |
| 8 | Site Work | 2,417,189 | 23,686 | 2,440,875 | 1,676,969 | 1,402,226 | 274,744 | 763,905 | - | 2,461,202 | (20,327) | 57.4% |
| 9 | Foundation | 1,703,542 | 75,077 | 1,778,619 | 1,771,713 | 1,771,713 | - | 6,906 | - | 1,771,713 | 6,906 | 99.6% |
| 10 | Framing | 3,798,439 | 154,923 | 3,953,362 | 3,984,440 | 3,562,538 | 421,902 | (31,078) | - | 3,984,440 | (31,078) | 90.1% |
| 11 | Exterior & Roofing | 2,302,084 | 7,634 | 2,309,718 | 2,188,859 | 1,257,390 | 931,469 | 120,859 | - | 2,312,263 | (2,545) | 54.4% |
| 12 | Mechanical, Electrical & Plumbing | 2,670,418 | 73,905 | 2,744,323 | 2,744,323 | 1,460,608 | 1,283,715 | - | - | 2,744,323 | - | 53.2% |
| 13 | Interior Finishes | 4,373,960 | 211,924 | 4,585,884 | 1,489,581 | 145,320 | 1,344,261 | 3,096,303 | - | 4,642,858 | (56,974) | 3.2% |
| 14 | Soft Costs | 3,107,814 | (7,634) | 3,100,180 | 3,080,189 | 2,212,533 | 867,656 | 19,991 | - | 3,080,189 | 19,991 | 71.4% |
| 15 | Financing | 1,496,355 | - | 1,496,355 | 1,496,355 | 778,105 | 718,250 | - | - | 1,496,355 | - | 52.0% |
| 16 | Contingency | 1,151,042 | (329,515) | 821,527 | - | - | - | 821,527 | 821,527 | - | 821,527 | - |
| 17 | Total ($) | 31,588,844 | 210,000 | 31,798,844 | 27,000,429 | 21,158,433 | 5,841,997 | 4,798,414 | 821,527 | 31,061,343 | 737,501 | 66.5% |
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.
| B | C | H | I | N | Q | R | S | T | |
|---|---|---|---|---|---|---|---|---|---|
| 5 | Line item | Code | Current budget | Committed | Uncommitted budget | Forecast at completion | Variance to budget | Committed > budget | Forecast > budget |
| 9 | Site clearing & mass grading | L03 | 545,207 | 540,990 | 4,217 | 540,990 | 4,217 | ||
| 12 | Driveways, walks & flatwork | L06 | 460,417 | 276,250 | 184,167 | 463,068 | (2,651) | FLAG | |
| 13 | Landscaping & irrigation | L07 | 345,313 | - | 345,313 | 352,583 | (7,270) | FLAG | |
| 14 | Fencing | L08 | 230,208 | - | 230,208 | 244,831 | (14,623) | FLAG | |
| 17 | Termite treatment & waterproofing | L11 | 138,125 | 131,219 | 6,906 | 131,219 | 6,906 | ||
| 20 | Framing labor | L14 | 1,055,568 | 1,086,646 | (31,078) | 1,086,646 | (31,078) | FLAG | FLAG |
| 24 | Siding, soffit & exterior trim | L18 | 805,730 | 684,870 | 120,859 | 808,274 | (2,545) | FLAG | |
| 28 | Insulation | L22 | 345,313 | 241,719 | 103,594 | 347,276 | (1,963) | FLAG | |
| 29 | Drywall | L23 | 807,654 | 485,362 | 322,292 | 808,936 | (1,283) | FLAG | |
| 30 | Interior trim & doors | L24 | 575,521 | - | 575,521 | 605,985 | (30,464) | FLAG | |
| 32 | Flooring | L26 | 707,521 | 132,000 | 575,521 | 717,215 | (9,694) | FLAG | |
| 33 | Interior & exterior paint | L27 | 460,417 | - | 460,417 | 473,988 | (13,571) | FLAG | |
| 35 | Architecture & engineering | L29 | 337,679 | 317,688 | 19,991 | 317,688 | 19,991 | ||
| 43 | Hard-cost contingency | L37 | 821,527 | - | 821,527 | - | 821,527 | ||
| 44 | Total project ($) | 31,798,844 | 27,000,429 | 4,798,414 | 31,061,343 | 737,501 | 1 | 10 |
Forecast overrun by cost line
Forecast at completion above current budget, illustrative project at month 12 of 20
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 · FreeFrequently 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.





