Rehab Budget Template in Excel: Scope, Contingency, and Draw Tracking

Rehab Budget Template in Excel: Scope, Contingency, and Draw Tracking

A rehab budget has two lives. Before the purchase, it is an underwriting input — the number the offer formula subtracts and the deal's returns depend on. After closing, it is a control document — the plan every invoice gets measured against. Most homemade budgets are built for the first life and abandoned in the second, which is how projects that "penciled" end up over budget with nobody able to say when it happened or where.

This guide builds the template that lives both lives: the line-item scope structure, the three-number system (budget, committed, actual) that makes overruns visible in real time, the contingency rules, and the change-order discipline. It is written for the single-property renovator — the BRRRR investor or flipper — with a note at the end on how the same skeleton scales to multifamily unit programs. All figures are illustrative examples, never cost estimates: renovation costs are local, cyclical, and scope-dependent, and any template that ships "typical" prices is shipping someone else's market.

The Structure: Scope First, Dollars Second

The template's rows are the scope of work, organized by category, with the discipline that every dollar traces to a written line:

• Exterior — roof, siding/paint, windows, gutters, landscaping, hardscape
• Systems — electrical, plumbing, HVAC, water heater
• Kitchen — cabinets, counters, appliances, fixtures
• Bathrooms — one block per bath
• Interior surfaces — flooring by room/type, paint, doors and trim, drywall
• Structural/other — foundation, framing, pests, permits and fees
• Soft costs — dumpsters, utilities during construction, plans/engineering where needed

Each line carries: a scope note (what, specifically — "replace 14 windows, vinyl, white" not "windows"), a quantity and unit cost where the work is countable, the line budget, and a source tag for where the number came from (contractor bid, unit-cost estimate, allowance). The source tag is the quiet hero: at decision time it tells you which lines are firm and which are guesses, and a budget that is 70% bids reads very differently from one that is 70% allowances — even at the same total.

The structural rule that pays for itself: build the budget from the scope, never back into it from the deal. A budget reverse-engineered from "what the 70% rule allows" is the offer formula wearing a hard hat — and the screen-versus-model distinction exists precisely because the two numbers must be independent to mean anything when compared.

The Three-Number System: Budget, Committed, Actual

The template's columns are where the control life lives. Every line carries three dollar figures:

1. Budget — the underwriting number, frozen at closing (revisable only through the change-order log below)
2. Committed — signed contracts and issued POs against the line
3. Actual — invoices paid

Plus two computed columns: variance (budget − actual − remaining commitments) and remaining to spend. The three-number system exists because the classic failure mode of budget-versus-actual-only tracking is lag: a project can be fatally over-committed weeks before the first overrun invoice arrives. Committed dollars are the early-warning layer — the moment a signed bid exceeds its line, the variance column says so, while there is still time to re-scope something downstream.

Two totals belong on the dashboard: projected final cost (actuals + open commitments + estimates for un-let lines) against the frozen budget, and contingency remaining — the project's health in two numbers, updated by data entry rather than optimism.

The Timeline Column: the Budget's Fourth Dimension

One more column earns its place in the underwriting life: scheduled weeks per line, with start dependencies where they matter (systems before drywall, drywall before paint). Summed along the critical path, the column produces the project duration — and the duration is not trivia, because it drives the carry: every holding-cost and financing dollar in the deal model is a function of the months this column implies. The connection is the whole point: a scope that grows by a line should lengthen the schedule, the schedule should reprice the carry, and the carry should reprice the deal — automatically, through references, per the workbook's connective-tissue rule. During execution, the same column becomes the schedule tracker (planned versus actual weeks per line), and schedule variance is budget variance's early twin: a project running three weeks behind is over budget in carry before a single trade invoice runs over.

Contingency: Sizing It, Spending It

The contingency line is the budget's confession that demolition reveals things, and it has two rules:

Sizing. Contingency scales with uncertainty, not just size: the property's age (older systems hide more), the scope's depth (opening walls finds things that painting them does not), and the evidence quality (a pre-offer walkthrough versus a full inspection with sewer scope and attic access). Light cosmetic work on a well-inspected recent-vintage house justifies the low end; a gut renovation of an older property with limited access justifies the high end — and the template treats the percentage as an input set per project, computed as its own line (= Contingency% × Scope Subtotal), never smeared invisibly into padded line items where it gets spent without anyone deciding to spend it.

Release discipline. Contingency is spent by decision, not by drift: a draw against it requires a named cause (the discovered subfloor rot, the panel that failed inspection) logged in the change-order register. The register — date, cause, amount, approved by — is four columns that convert "somehow we're $9,000 over" into a legible history, and on any project with a partner, a lender, or a future dispute, it is the difference between an explanation and an argument.

Change orders proper — scope choices rather than discoveries ("upgrade to quartz") — run through the same log but are flagged separately, because the distinction matters at the post-mortem: discoveries inform your next contingency percentage; choices inform your discipline.

Draw Tracking

If the project runs on financed rehab funds — hard money draws, a renovation loan — the template adds the funding layer: a draw schedule mapping budget lines to the lender's draw stages, with requested/inspected/funded dates per draw. Two practical disciplines: reconcile each draw request against the actuals columns (lenders inspect completed work, and a request that outruns the actuals column outruns the inspection too), and track the timing gap — work is typically paid before draws reimburse, and that float is a cash requirement the deal model should know about. The line-item structure above makes draw paperwork an export rather than a scramble, which is a real advantage on the fourth Friday of a project.

Closing the Loop: the Post-Project Audit

The template's last job is feeding the next deal. After completion, one pass down the variance column answers the questions that make the second project cheaper than the first: Which lines ran over, and were they discoveries or estimating misses? Which cost source tags proved reliable? What did the contingency actually get spent on, and was the percentage right? Renovators who run this audit compound an estimating database with every project; renovators who don't re-learn the same overruns annually. The portfolio-level version of this habit — per-deal actuals rolled into a repeat-stage tracker — is exactly the BRRRR workbook's final tab.

Scaling Up: the Multifamily Unit Program

The same skeleton runs a multifamily renovation program with two structural changes: the unit of account becomes the per-unit scope (one standardized budget template, multiplied across the program, with unit-type variants), and the tracking adds a completion dimension — units done, in progress, and scheduled, against the turnover-driven timeline the premium capture depends on. Budget-versus-actual on the first tranche of units then becomes the live test of the whole program's per-unit assumption — the re-underwriting discipline the value-add renovation budgeting guide builds out in full, on the machinery of the Multifamily Underwriting Suite.

Frequently Asked Questions

What should a rehab budget template include? Line-item scope by category with scope notes and cost sources; the three dollar columns (budget, committed, actual) with variance; a computed contingency line; a change-order log; and, if financed, draw tracking mapped to the lender's stages.

How much contingency should a rehab budget have? A percentage set by the project's uncertainty — age, scope depth, inspection quality — not a universal constant. The template treats it as a per-project input, computed as its own visible line, and the post-project audit tells you whether your percentage was right.

How do I estimate rehab costs? From your market: contractor bids for the major trades, local unit costs for countable work, and allowances (flagged as such) only where neither exists yet. Tag every line's source — the budget's reliability is the weighted reliability of its sources.

What's the difference between a rehab budget and a scope of work? The scope is the what (the written work list); the budget prices it. In a good template they are the same rows — which is the point: a dollar with no scope line is a guess, and a scope line with no dollar is a surprise.

Can I use this template for a live-in renovation or a flip? Yes — the structure is exit-agnostic. What changes by strategy is what the total feeds: a flip's offer formula, a BRRRR's all-in cost and refinance analysis, or simply a homeowner's cash plan.

The Template, Wired Into the Deal

A rehab budget earns its keep when it is connected — when the total flows into the all-in cost, the timeline drives the carry, and an overrun reprices the refinance automatically. The BRRRR Calculator ships this template as its budget tab, wired into exactly that chain: scope lines with computed contingency, budget-versus-actual tracking, and the total feeding the full-cycle analysis through the dual-constraint refinance — fully unlocked, formula-transparent, versioned, with a documented methodology PDF.

This article is for educational purposes only and does not constitute investment, legal, or tax advice. All figures are illustrative examples, not cost estimates; renovation costs vary by market, scope, and conditions. Consult qualified professionals before making investment decisions.