🏗

Construction Co

5-Year Forecast · FY2026–FY2030 · South Australia

PREPARED BY

JSA ACCOUNTING PTY LTD

EXPORT:

Live Model

Last change: —

Client Name Appears in header, reports & exports

CONSTRUCTION BUDGET MODEL

Client: — | 5-Year Forecast

STATIC BASELINE LOCKED LIVE ROLLING FORECAST ACTIVE Updates when actuals or pipeline overrides differ from baseline

📊 Budget vs Actual — Year to Date (Year 1)

🤝 Contracts Signed — Target vs Actual

⏱ Contract Lifecycle — Lead Time Visualiser

Contracts signed today won't generate revenue until Month 8 (after 7 months of pre-construction). Claims are issued per your installment schedule — watch the Cash Flow tab for the timing impact.

Two-Track Model: The Static Baseline (Budget) uses Budget Contracts/Month and Budget Lead Time — these are locked and never change once set. The Live Rolling Forecast uses Rolling Forecast Contracts/Month, the live Lead Time slider, and any pipeline overrides you enter in the Pipeline tab. The Dashboard Budget vs Actual panel always compares actuals against the locked baseline.

📅 Modelling Period

Model Start Month

Model Start Year

Model Duration

📈 Annual Growth (Indexation)

Revenue Growth (%/yr)

Fixed Overhead Growth (%/yr)

📋 Contract & Revenue

Contracts Target / Month (Budget)

Contracts Rolling Forecast / Month

Average Contract Value ($)

Contract Deposit per Contract ($)

Invoice → Cash Collection (days)

Supplier Payment Cycle (days)

📊 Claim Installment Schedule

Define when progress claims are invoiced during the on-site phase. Percentages represent % of total contract value claimed each month on site. Total should equal 100%.

Month On-Site	Claim % of Contract Value

Total Claims: 100.0%

⏳ Lead Time & Project Timeline

Lead Time: Budget / Baseline (months)

Lead Time: Rolling Forecast (months)

Opening Cash Balance ($)

💼 Sales Commission

Commission is payable at the first month on-site. Choose between % of total contract value or a fixed dollar amount per contract.

Commission Type

Commission Rate (% of Contract Value)

Fixed Commission per Contract ($)

💰 Cost of Sales (% of Revenue)

Subcontractor Costs (%)

Materials & Supplies (%)

Plant & Equipment (%)

Site Overheads (%)

Other Direct Costs (%)

Total COS (auto-calculated)

Custom Cost Items (% of Revenue)

🏢 Monthly Fixed Overheads

Overhead Items ($/mo)

Total Monthly Overhead (auto)

👷 Payroll Settings

Superannuation Rate (%)

Annual Wage Inflation (%)

Pay Frequency

🛡 WorkCover & Payroll Tax

WorkCover: Applied to total wages & super each month. SA construction industry rate is typically 1.5–2.5%.
SA Payroll Tax: 4.95% on annual wages above the SA threshold ($1.5M). Paid monthly on estimated basis.

WorkCover Rate (% of Wages & Super)

Payroll Tax Rate (%)

Payroll Tax Threshold (Annual $)

🏗 Capital Spending

Annual capital expenditure (plant, equipment, vehicles, leasehold improvements). Spread evenly across each year's 12 months in the Cash Flow. Does not affect P&L.

Year 1 Capex ($)

Year 2 Capex ($)

Year 3 Capex ($)

Year 4 Capex ($)

Year 5 Capex ($)

⚖️ Tax & Other

Company Tax Rate (%)

GST Rate (%)

GST basis

GST lodgement cycle

Monthly Override: Leave blank to use default assumptions. Revenue for contracts signed in Month 1 starts flowing in Month 8 (after 7 months lead time) per your claim installment schedule.

📊 Monthly Contract Pipeline — 60 Months

Month	Contracts Signed	Avg Value ($)	Contract Value ($)	Deposit Received ($)	Lead Time (mths)	Onsite Month	1st Claim ($)

📈 Pipeline by Year

Opening Jobs = jobs already on hand. Enter how many go on-site each month and the per-job value; these bill immediately (no lead time).

Deposit already received on these jobs (exclude deposit from cash flow)

Commission already recognised on these jobs (exclude sales commission)

Opening Balances = carried-in receivables/payables/GST position at the budget start. Debtors and creditors show up as one-off cash movements in the FIRST budget month (debtors in, creditors out); GST debt shows up as a cash outflow at the first lodgement settlement month (negative = refund, an inflow).

💰 Opening Balances

Opening Debtors ($)

Opening Creditors ($)

Opening GST Debt ($)

🏗️ Opening Jobs on Hand

Start month (0 = first budget month; negatives = started before)	Jobs	Contract value each ($)

👥 Staff Positions & Payroll

Super: Rate set in Assumptions (currently 12%) added on top of base salary. Annual wage inflation applied year-over-year. WorkCover & Payroll Tax are calculated automatically from totals.

Role / Name	Department	Annual Salary ($)	Start Month	Monthly Cost (est.)
TOTAL		$0	0 positions	$0

Import CSV / Excel No actuals loaded

📥

Drop CSV or Excel file here, or click to browse

Template columns: Month, Contracts Signed (#), Revenue, Cost of Sales, Payroll & Super, WorkCover, Payroll Tax, Commission, one column per overhead item, Cash Receipts, Total Cash Paid, Closing Cash Balance. Download the template to see the exact overhead columns.

📊 Actual Figures — Monthly Entry

After entering actuals, switch to the P&L or Cash Flow tab and select Actual or Variance (A−B) to compare against the forecast.
Variance = Actual minus Budget. Green = favourable · Red = unfavourable.

View:

📉 Profit & Loss Statement

View:

💵 Cash Flow Forecast

Payroll timing: Wages paid fortnightly (26 runs/yr). Super: Paid quarterly (Oct/Jan/Apr/Jul). Supplier payments: COS paid per supplier payment cycle. Commission: Paid at first month on-site per contract. Deposits: Received at contract signing.

Share this budget