Aggregate Plant Financial Model Template

This Aggregate Plant Financial Model is a professional, fully integrated Excel template built for quarry owners, crushing and screening plant operators, investors, lenders and consultants who need a bankable financial projection for an aggregates business. Covering a 10-year operating horizon, with monthly detail for Years 1–5 and annual projections for Years 6–10, it turns operational assumptions into a complete three-statement model: Income Statement, Cash Flow Statement and Balance Sheet. Every figure is driven by live formulas, so the model recalculates instantly when you change production, pricing, costs, capex or financing inputs.

10-Year Financial Model for an Aggregate Plant

Designed specifically for the aggregates and construction materials industry, the model starts where your business starts: in the quarry. It calculates plant capacity from operating days, shifts, hours, maintenance and downtime, then follows tonnes through primary, secondary and tertiary crushing, screening, yield losses and a 15-product sales mix, from manufactured sand and 4mm–50mm aggregates to ballast, road base, subbase and fill. Revenue, operating costs per tonne, staffing, working capital, capital expenditure and depreciation all flow from that tonnage engine, giving you a realistic, defensible picture of plant profitability, EBITDA margin and cost per tonne.

For investment decisions and project finance, the model delivers lender-grade outputs: project and equity IRR, NPV, payback, MOIC, DSCR, net debt to EBITDA, covenant testing, a debt service reserve account and peak funding requirement. Six editable scenarios (Base, Upside, Downside, Severe Downside, Management and Lender) can be switched from a single drop-down, while ten sensitivity grids show how selling price, volume, diesel, capex, interest rates and discount rate affect returns. Change one start date and the entire timeline re-dates automatically, ready for your next feasibility study, bank submission or investor presentation.

What’s Inside: Tab-by-Tab Guide

01. Cover & Model Control

The control centre of the aggregate plant financial model. Select your live scenario, confirm reporting currency and units, and review 21 automated integrity checks that confirm the balance sheet balances, cash reconciles and debt is repaid, before you present results.

  • Scenario selector drop-down (six cases)
  • Model purpose, version, currency and units
  • Key outputs: project IRR, equity IRR, NPV, peak funding, minimum DSCR
  • 21 status checks with an overall PASS / REVIEW flag
  • Colour legend and hyperlinked tab index

02. Assumptions

One place for every global driver of your quarry financial model. Set the model start date, inflation and escalation rates, corporate tax, cost of capital, working capital days and minimum cash. A single date input re-dates every tab, label and escalation index automatically.

  • Master start date driving the whole 10-year timeline
  • Separate escalation rates for prices, opex, diesel, electricity, wages and capex
  • CAPM cost of equity and WACC build-up
  • Working capital days for receivables, payables and seven inventory types
  • Dividend payout, lock-up DSCR and minimum cash settings

Cement Factory Financial Model

Aggregate Plant Financial Model Excel Template

Aggregate Plant Production & revenues

03. Production & Sales

The tonnage engine of the crushing plant model. Operating schedule and plant capacity drive feed tonnes through primary, secondary and tertiary crushers and screening. Yield losses, a 15-product mix, seasonal demand and finished-goods stock then determine saleable production and sales volume.

  • Reserve depletion and reserve life tracking
  • Nameplate vs practical capacity, availability and utilisation
  • Ramp-up curve, production growth and expansion uplift
  • Production by product: manufactured sand, 4mm–50mm, ballast, road base, subbase, fill
  • OEE, production per hour, per employee and per operating day
  • Production and sales targets with variance analysis

04. Pricing & Revenue

Build aggregates revenue from a product-level price deck. Year-1 selling prices per tonne escalate automatically, then premiums, discounts, rebates, returns and quality claims calculate net product revenue. Freight, delivery, loading and packaging charges add ancillary revenue for total sales.

  • Selling price per tonne for 15 aggregate products
  • Domestic vs export and contracted vs spot pricing
  • Weighted average selling price and price realisation
  • Discounts, rebates, returns, quality claims and bad debts
  • Freight, delivery, loading and packaging revenue
  • Revenue budget and variance

05. Operating Costs

A detailed quarry and crushing plant operating cost model with over 70 cost lines. Variable costs use per-tonne drivers; fixed costs use annual budgets. Diesel, electricity and water are calculated from consumption and tariffs, delivering accurate cost per tonne and fixed versus variable splits.

  • Drilling, blasting, excavation, loading and haulage costs
  • Crushing, screening, washing, conveying and reprocessing costs
  • Diesel litres, electricity kWh and water m³ with tariffs
  • Wear parts, liners, screen media, maintenance and tyres
  • Logistics, environmental, royalty and site overhead costs
  • Cost per feed, processed, saleable and sold tonne

06. Staffing & Overheads

Plan your workforce with a position-by-position staffing roster covering management, operations, maintenance and administration. Salaries escalate annually, with overtime, allowances, bonuses, employer on-costs, recruitment, training and welfare costs calculated automatically, plus site and corporate overheads.

  • Roster by department, cost centre, job category and employee type
  • Permanent, contract, temporary and FTE headcount
  • Overtime, shift allowances, bonuses and incentives
  • Pension, social security, payroll tax, insurance and leave provisions
  • Direct labour (to COGS) vs site salaries (to opex)
  • Site administration, corporate, professional and selling overheads

07. Capex & Depreciation

A complete aggregate plant capex and fixed asset model. A 44-line capital expenditure register covers land, quarry development, crushers, screens, conveyors, mobile fleet and project costs. Expansion, sustaining, replacement and rehabilitation capex follow, with straight-line depreciation by asset category.

  • Initial capex register with asset IDs, owners, dates and contingency
  • Useful lives, residual values and depreciation rates for 12 categories
  • Expansion, sustaining, replacement, maintenance and environmental capex
  • Fleet replacement, disposals and gain or loss on sale
  • Fixed asset roll-forward and net book value
  • Rehabilitation and decommissioning provisions
Aggregate Plant Financial Model Excel
Aggregate Plant Financial Model Excel

Aggregate Plant Financial Statements

08. Working Capital

Model the cash tied up in running an aggregates business. Receivables, inventories, payables, accruals, prepayments, customer deposits and tax receivables are calculated from days assumptions, with full opening-to-closing roll-forwards and changes in net working capital feeding the cash flow.

  • Accounts receivable, collections and bad debt write-offs
  • Raw material, WIP, finished goods, spare parts, consumables and fuel inventory
  • Accounts payable, supplier payments and accrued expenses
  • Customer deposits, advances and tax receivables
  • Net working capital and working capital per tonne
  • Working capital budget and variance

09. Debt & Financing

Lender-ready project finance modelling for a quarry or crushing plant. Sources and uses, senior term loan, subordinated debt, shareholder loan, equipment finance, leases and a revolving credit facility are scheduled monthly, with interest, fees, DSCR, covenant tests and a debt service reserve account.

  • Sources and uses of funds with sponsor and third-party equity
  • Six debt facilities with grace periods, tenors and repayment profiles
  • Fixed or floating interest rates, commitment and arrangement fees
  • DSCR, interest cover, net debt to EBITDA and loan-to-value
  • Covenant compliance tests and dividend lock-up
  • DSRA, cash sweep, undrawn facilities and funding headroom

10. Income Statement

A detailed profit and loss statement for your aggregate plant. Net revenue, cost of goods sold with inventory capitalisation, gross profit, operating expenses, EBITDA, EBIT, interest and tax flow through to net profit, with tax losses carried forward and per-tonne KPIs.

  • Revenue, discounts, rebates and net revenue
  • 21 direct cost lines and cost of goods sold
  • Gross profit, EBITDA and EBIT with margins
  • Interest, financing fee amortisation and tax with loss carry-forward
  • EBITDA, COGS and operating cost per tonne sold
  • Budget vs actual revenue, EBITDA and net profit

11. Cash Flow Statement

An indirect-method cash flow statement showing exactly how your aggregates business generates and uses cash. Operating, investing and financing cash flows reconcile to closing cash, with CFADS, free cash flow, peak funding requirement and an automated RCF and dividend waterfall.

  • Operating cash flow with working capital movements
  • Capex payments by asset class and disposal proceeds
  • Equity, debt drawdowns, repayments, fees and dividends
  • Restricted vs unrestricted cash and minimum cash requirement
  • Free cash flow before and after debt service, and CFADS
  • Peak cumulative funding requirement and cash runway

12. Balance Sheet

A fully balancing balance sheet for every month and year. Assets, liabilities and equity link from every supporting schedule, with retained earnings split into brought-forward, current-year profit and dividends, plus a built-in balance check and key financial ratios.

  • Cash, receivables, seven inventory lines and prepayments
  • PP&E by asset class, intangibles and deferred tax assets
  • Current and long-term debt split by facility
  • Rehabilitation and decommissioning provisions
  • Balance sheet check (zero difference every period)
  • Current ratio, quick ratio, ROA, ROE and ROCE
Aggregate Plant Financial Model
Aggregate Plant Financial Model

Key Aggregate Plant Financials & KPIs

13. Valuation & Returns

Investor-grade valuation of the aggregate plant using discounted cash flow. Unlevered and equity cash flows, terminal value, NPV, project and equity IRR, MIRR, payback, MOIC and break-even metrics give a complete view of returns and investment risk.

  • Unlevered free cash flow and equity cash flow
  • Terminal value: growing annuity over remaining life or exit multiple
  • NPV, IRR, MIRR and simple, equity and discounted payback
  • EV/EBITDA, MOIC, cash-on-cash and dividend yield
  • Break-even price, break-even volume and minimum utilisation
  • Maximum supportable debt and maximum affordable capex

14. Sensitivity & Scenarios

Stress-test your quarry investment with six fully editable scenarios and ten sensitivity grids. Over 55 scenario levers flex volumes, prices, costs, capex, delays, financing and valuation, with live results compared against the base case and probability-weighted outcomes.

  • Base, Upside, Downside, Severe Downside, Management and Lender cases
  • 58 editable levers for operations, costs, capex, financing and valuation
  • Live vs base case comparison and scenario ranking by NPV
  • Cash, covenant and funding shortfall breach indicators
  • Price vs volume, price vs diesel, capex vs IRR and discount rate vs NPV grids
  • Key value drivers, downside risks and mitigation actions

15. Dashboard

A one-page executive summary of the aggregate plant financial model. Headline KPIs and charts show revenue, EBITDA, margin, cost per tonne, break-even price, production, free cash flow and DSCR, perfect for board packs, bank presentations and investor meetings.

  • Project IRR, equity IRR, NPV, MOIC and payback
  • Revenue and EBITDA chart with EBITDA margin trend
  • Annual production and sales volume
  • Revenue per tonne vs cost and break-even per tonne
  • Free cash flow and DSCR charts
  • Live model status indicator

Why Buy This Model

Building an aggregate plant financial model from scratch can take weeks of specialist work, and a single broken link can undermine a bank submission or investment decision. This model gives you a complete, industry-specific framework on day one: a tonnage-driven operating engine, a detailed cost and staffing build, project finance debt schedules and a fully balancing three-statement model, all connected by live formulas and verified by 21 automated checks. It follows professional modelling standards, with colour-coded inputs, consistent timelines and clear section headers, so lenders, investors and your own team can follow every number. Replace the illustrative assumptions with your own project data, switch scenarios in one click, and produce credible IRR, NPV, DSCR and cost-per-tonne analysis in hours instead of weeks.

Aggregate Plant Frequently Asked Questions

Is this model suitable for a new (greenfield) quarry or an existing aggregate plant?

It is set up for a greenfield crushing and screening plant, with initial capex spent at financial close and a production ramp-up. It works equally well for an existing operation: enter your current capacity, costs and asset values, and set ramp-up to start at 100%.

Do I need advanced Excel skills to use it?

No. All inputs are clearly marked in blue on yellow cells, and calculations are locked into consistent formulas. If you can change a number in a cell and pick from a drop-down list, you can run the model. Financial knowledge helps when interpreting the outputs.

Which version of Excel do I need?

The model uses standard Excel functions with no macros or add-ins, so it works in modern versions of Microsoft Excel on Windows and Mac. A recent version such as Excel 2016, 2019, 2021 or Microsoft 365 is recommended for the best experience with charts and formatting.

Can I change the start date and currency?

Yes. Change the Model Start Date on the Assumptions tab and every date, month label, year header and escalation index updates automatically across all 15 tabs. The model is in USD by default, and the currency label can be changed to suit your project.

How many products can I model?

Fifteen aggregate products are included: fine aggregate, manufactured sand, 4mm, 6mm, 10mm, 14mm, 20mm, 28mm, 40mm and 50mm aggregates, ballast, road base, subbase, fill material and other aggregates. Each has its own price, mix percentage, production and revenue line.

Does the model include financing and bank covenants?

Yes. It includes a senior term loan, subordinated debt, shareholder loan, equipment finance, lease liabilities and a revolving credit facility. It calculates DSCR, interest cover and net debt to EBITDA, tests covenants annually, and models a debt service reserve account and dividend lock-up.

Will the balance sheet always balance?

Yes. The balance sheet is fully linked to the income statement, cash flow and all supporting schedules, and a built-in check confirms a zero difference in every month and year. The Cover tab summarises this and 20 other integrity checks in a single model status.

How do the scenarios work?

Choose a scenario from the drop-down on the Cover tab and the whole model recalculates. Each of the six scenarios is defined by 58 editable levers, such as price, volume, diesel, capex, delays and interest rates, so you can build your own downside, lender or management cases.

Can I use the model for a bank loan application or investor pitch?

Yes. It is structured to lender and investor expectations, with sources and uses, debt schedules, DSCR, covenant tests, IRR, NPV, payback and a professional dashboard. Replace the illustrative assumptions with your project data and support them with your own quotes and market research.

Are the numbers in the model real project data?

No. The prices, costs, capex and financing terms are illustrative assumptions designed to show how the model works and produce sensible results. You should replace them with figures for your specific site, market and equipment before relying on the outputs.

Can I add more cost lines, staff positions or capex items?

Yes. The model is fully unlocked. Adding rows within existing sections is straightforward, and the consistent layout across tabs makes it easy to extend.

What KPIs does the dashboard show?

Project IRR, equity IRR, NPV, MOIC, payback, peak funding, minimum DSCR and break-even price, plus annual charts for revenue, EBITDA, EBITDA margin, production, revenue versus cost per tonne, free cash flow and DSCR.

Does it handle seasonality in demand?

Yes. Monthly seasonality factors adjust customer demand across the year, while finished-goods inventory absorbs the difference between steady plant production and seasonal sales, which matters for construction-driven aggregate markets.

Can I see annual figures without scrolling through monthly columns?

Yes. Every timeline tab has an FY Total column after each year, and the monthly columns are grouped, so you can collapse them with Excel’s outline buttons to see a clean annual view of all 10 years.

Aggregate Stone Quarry Financial Model Template
Aggregate Stone Quarry Financial Model Template
Aggregate Plant Financial Model Template

Final Notes on the Financial Model

This 10 Year Aggregate Plant Financial Model Excel Template focuses on balancing capital expenditures with steady revenue growth from a diversified product line. By optimizing operational costs, and power efficiency, and maximizing high-margin services, the models ensure sustainable profitability and cash flow stability.

Aggregate Plant Financial Model Template

Download Link On Next page

$120.00