🏗

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

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

📋 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)

🏢 Monthly Fixed Overheads

Office Rent & Utilities ($/mo)

Marketing & Biz Dev ($/mo)

Insurance — Office/PI/PL ($/mo)

IT & Software ($/mo)

Professional Fees ($/mo)

Vehicle & Travel ($/mo)

Depreciation — Office ($/mo)

Other Overheads ($/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 (%)

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

👥 Staff Positions & Payroll — 5 Years

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 ($)	HC Yr1	HC Yr2	HC Yr3	HC Yr4	HC Yr5	Mo Cost Yr1 ($)	Mo Cost Yr2 ($)	Mo Cost Yr3 ($)	Mo Cost Yr4 ($)	Mo Cost Yr5 ($)
TOTAL			0	0	0	0	0	$0	$0	$0	$0	$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, Fixed Overheads, Cash Receipts, Total Cash Paid, Closing Cash Balance

📊 Actual Figures — Monthly Entry

Month	Contracts (#)	Revenue ($)	COS ($)	Payroll & Super ($)	WorkCover ($)	Payroll Tax ($)	Commission ($)	Overheads ($)	Cash Receipts ($)	Total Cash Paid ($)	Closing Cash ($)

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