🏗

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 budget forecast (matching the P&L and Cash Flow tables).

📅 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 ($)

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%.

Stage	Month On-Site	% of Contract Value

Total Claims: 100.0%

⏳ Lead Time & Project Timeline

Lead Time: Budget / Baseline (months)

Lead Time: Rolling Forecast (months)

💼 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 ($)

💰 Dividend Payment

Annual dividend paid to shareholders. Paid as a single lump in June each year in the Cash Flow. Does not affect P&L.

Year 1 Dividend ($)

Year 2 Dividend ($)

Year 3 Dividend ($)

Year 4 Dividend ($)

Year 5 Dividend ($)

⚖️ 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.

🪣 Job Deposit Funnel

When ON, "signed contracts" are DERIVED from a deposit funnel and REPLACE the flat pipeline above: clients pay a fixed deposit fee, some fall off, the rest sign after a lead time paying a % deposit, then progress claims follow. The "Contracts Signed" column below then edits monthly deposits. OFF = the flat pipeline is unchanged.

Enable job deposit funnel (replaces the flat contract pipeline)

Deposits / month

Deposit fee ($/job)

Fall-off (%)

Sign lead (months)

Contracted deposit (%)

📊 Monthly Contract Pipeline — 60 Months

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

📈 Pipeline by Year

Opening Jobs = jobs already in hand. Pick a Stage per row and enter the relevant month, job count and per-job value. Deposited = fall-off & sign-lead still ahead (deposit recognised at signing); Contract = already signed (deposit received, month = signing month); On-site = already building (month = on-site month, bills immediately). Each claim stage is recognised at exactly the % you typed in the Claim Schedule.

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 Cash Balance ($)

Opening Debtors ($)

Opening Creditors ($)

Opening GST Debt ($)

🏗️ Opening Jobs on Hand

Stage	Month	Jobs	Contract value each ($)

Import CSV / Excel

📥

Drop CSV or Excel file here, or click to browse

Template columns: Stage (Deposited / Contract / On-site), Month (0 = first budget month), 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	End Month	Monthly Cost (est.)
TOTAL		$0	0 positions		$0

Import from Xero (Excel / CSV) Xero → Reports → Employee Remuneration → Export. Reads Employee, Classification, Annual Salary, Start Date. Replaces the current list.

Import CSV / Excel Import from Xero P&L (Excel) As-of month 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.
Cash Receipts is derived automatically from your actual Revenue using the model's Invoice → Cash Collection lag — the same collection rhythm as the forecast — so you don't need to type it. The Cash Receipts column here is only a fallback for months where no actual revenue was entered.

View:

📉 Profit & Loss Statement

View:

💵 Cash Flow Forecast

Share this budget