Blog · Territory, capacity and quota planning · Construction
Build a development workbook that separates approved budget, incurred costs, remaining work and future payments. Follow a project cost reconciliation and monthly loan-draw schedule, then test the cash effect of a delayed draw.
A real estate development financial model connects project costs to the dates contractors, lenders and equity providers move cash. Build a cost-to-complete schedule first, then a monthly payment and funding schedule. A project can remain within its borrowing limit and still run short of cash before the next draw arrives.
Use the approved development budget, job-cost export, accounts payable aging, subcontract commitments, change-order register and draw records. Add the signed financing schedule and the team's current construction timing assumptions. Keep a common project identifier, cost code and reporting cutoff across every file.
Assign an owner to each assumption. The project manager supplies remaining work and schedule changes. Accounts payable confirms unpaid invoices and retainage. Treasury confirms expected funding dates and finance owns the reconciliation. Do not replace an approved budget with the latest forecast; the variance between them is useful information.
This page focuses on a development company's cost and funding work. The broader real estate financial modeling guide covers neighboring planning questions. Property sale values and investment-return recommendations are outside this worked example.
Consider a US commercial development reporting at September 30, 2026. The project team supplies the following budget, incurred cost and remaining-cost estimates. The contingency line is an unallocated future allowance, not an expense already incurred.
| Cost category | Approved budget (USD) | Incurred cost (USD) | Remaining forecast (USD) | Forecast completion cost (USD) | Budget less forecast (USD) |
|---|---|---|---|---|---|
| Land | 1,200,000 | 1,200,000 | 0 | 1,200,000 | 0 |
| Hard construction costs | 3,600,000 | 1,800,000 | 2,100,000 | 3,900,000 | -300,000 |
| Soft costs | 500,000 | 300,000 | 230,000 | 530,000 | -30,000 |
| Financing costs | 300,000 | 100,000 | 220,000 | 320,000 | -20,000 |
| Unallocated contingency | 400,000 | 0 | 250,000 | 250,000 | 150,000 |
| Total | 6,000,000 | 3,400,000 | 2,800,000 | 6,200,000 | -200,000 |
Place those columns in A:F, with land on row 2. Use these formulas and fill down through row 6:
E2 = C2+D2
F2 = B2-E2
E7 = SUM(E2:E6)
F7 = SUM(F2:F6)
The project forecasts $6,200,000 at completion, $200,000 above the approved budget. The identity is 3,400,000 + 2,800,000 = 6,200,000. Negative variances are unfavorable under this table's sign convention.
Remaining forecast includes unpaid future work under existing contracts, expected uncommitted work and the unused contingency allowance. Existing commitments are evidence for that estimate, not another amount to add on top. When a risk becomes a priced change order, transfer its allowance to the relevant cost category before reassessing contingency.
Keep land visible even when construction reports exclude it. The Census construction definitions exclude land acquisition from construction activity and describe construction put in place as work installed during a period. Those definitions help explain why a construction-progress total is not the full development budget.
The cost report says $3,400,000 has been incurred. Assume $3,200,000 has been paid and $200,000 remains in opening payables. There are no prepayments or separately scheduled retainage balances in this example.
| Remaining-payment bridge | Amount (USD) |
|---|---|
| Incurred costs | 3,400,000 |
| Cash paid through September | 3,200,000 |
| Unpaid incurred costs | 200,000 |
| Future costs and contingency allowance | 2,800,000 |
| Remaining planned payments | 3,000,000 |
The remaining cash requirement is 200,000 + 2,800,000 = $3,000,000, not just the future-cost estimate. The allowance is scheduled conservatively as a payment requirement; it becomes an actual cost only if used.
Cost reporting also differs from expense recognition. IRS Publication 551 explains that costs of constructed business property are capitalized into basis, with applicable rules and exceptions. Keep the operational project ledger tied to the accounting team's capitalization policy; do not call every development payment a current operating expense. The real estate financial reporting guide addresses the separate reporting task.
The supplied payment schedule places the remaining $3,000,000 in October through December. Opening project cash is $100,000. Outstanding debt starts at $2,000,000, and the agreed facility limit is $4,000,000. The example assumes no project receipts or debt repayments during these months; financing costs are included in payments above.
| Month | Opening cash (USD) | Debt draws (USD) | Equity received (USD) | Project payments (USD) | Closing cash (USD) | Closing debt (USD) |
|---|---|---|---|---|---|---|
| October | 100,000 | 500,000 | 300,000 | 800,000 | 100,000 | 2,500,000 |
| November | 100,000 | 600,000 | 400,000 | 900,000 | 200,000 | 3,100,000 |
| December | 200,000 | 700,000 | 400,000 | 1,300,000 | 0 | 3,800,000 |
| Total flows | 1,800,000 | 1,100,000 | 3,000,000 |
With the columns in A:G and October on row 2:
F2 = B2+C2+D2-E2
G2 = 2000000+C2
B3 = F2
F3 = B3+C3+D3-E3
G3 = G2+C3
Carry the formulas forward. The whole-period check is 100,000 + 1,800,000 + 1,100,000 - 3,000,000 = zero ending cash. Closing debt leaves $200,000 of facility headroom, but zero ending cash leaves no operating cushion. Any minimum-cash requirement needs its own funding line.
Move November's $600,000 draw into December, leaving every cost and equity payment unchanged. November closing cash becomes 100,000 + 0 + 400,000 - 900,000 = negative $400,000. December receives $1,300,000 of draws and finishes at zero, but the project still needs $400,000 of temporary funding in November.
An unchanged completion-cost total therefore does not prove adequate liquidity. The distinction between cash flow and profit matters here, as does the difference between a loan commitment and a funded draw.
Keep these reconciliations alongside the broader construction financial model, rather than replacing job-level cost detail with one company total.
Bring a sample of your own development budget, job-cost export, payables and supplied draw schedule to Covirage. Covirage maps the columns, and its tools compute and check cost variances, remaining-payment bridges and monthly cash balances; the external AI model explains the results with every figure traced to its rows. Create a free Covirage account, set up your business and bring your project files.
See project cost control in Covirage for the supporting workflow.
Include land, hard construction costs, professional and permitting costs, financing costs and an explicit contingency allowance. Separate costs already incurred from remaining work. A purchase order or subcontract commitment belongs within the remaining estimate when it has not yet been incurred, rather than being added twice.
No. Work can be incurred before an invoice is paid, while a deposit can be paid before work is incurred. Bridge incurred costs to payments using payables, retainage and prepayments, then schedule the actual expected payment dates.
No. Draw availability depends on the financing agreement and the timing of approved requests. A project can have unused loan capacity and still face a temporary cash gap if contractor payments precede lender funding. Test the cash schedule month by month.