Financial Model, Manufacturing, Mining Industry, Open Pit, Underground Mines

10-year Financial Projections, Cap Table, Cash Flow Analysis, Cash Flow Projections, DCF Model, Excel, Financial Analysis, Financial Feasibility, Financial Model, Financial Modeling, Financial modelling, Financial Planning, Financial Projections, Financial Reporting, Financial Statements, Financing, Forecast, Forecasting, Income Statement, KPIs (Key Performance Indicators), Mine Life, NPV (Net Present Value), Revenue Projections, Scenario Analysis, Startup Financial Models, WACC (Weighted Average Cost of Capital)

Income Statement

The Income Statement measures the company’s profitability over each reporting period.

Revenue

Revenue is calculated separately for each commodity produced in up to 10 Mines.

For each commodity:

• Production volume (tonnes)
• Payable metal percentage
• Realized commodity price
• Exchange rate (if commodity is priced in USD)
• Sales adjustments
• Smelting/refining deductions
• Freight recoveries
• Royalties deducted from revenue (where applicable)

Revenue calculation:

Revenue = Payable Production × Realized Commodity Price

Revenue should be split by commodity:

• Manganese
• Copper
• Iron Ore
• Nickel
• Aluminium
• Phosphorus
• Titanium

The model should also calculate:

• Total Mining Revenue
• By-product Revenue

Cost of Sales

Operating costs should be broken into detailed mining categories.

Mining Costs

• Drilling
• Blasting
• Loading
• Hauling
• Mine supervision
• Contractor costs
• Fuel
• Tyres
• Equipment maintenance
• Mine consumables

Cash Flow Statement

The Cash Flow Statement tracks actual cash movements.

Operating Cash Flow

Start with:

• Net Income

Add back:

• Depreciation
• Depletion
• Amortization
• Share-based payments
• Deferred tax
• Impairments
• Asset write-offs

Working Capital Adjustments

• Accounts Receivable
• Inventory
• Ore stockpiles
• Concentrate inventory
• Supplies inventory
• Accounts Payable
• Accrued expenses
• Royalties payable
• Taxes payable
• Rehabilitation provisions

Investing Cash Flow

Capital expenditure should be separated.

Sustaining Capital

• Replacement equipment
• Plant maintenance
• Infrastructure renewal
• Tailings expansion
• Environmental upgrades

Balance Sheet

The Balance Sheet presents the company’s financial position.

Assets

Current Assets

• Cash
• Restricted cash
• Accounts receivable
• VAT receivable
• Inventories
• Ore stockpiles
• Finished goods
• Consumables
• Prepayments
• Other current assets

Non-Current Assets

• Mining properties
• Mineral rights
• Exploration assets
• Development assets
• Property, Plant & Equipment
• Mining fleet
• Processing plant
• Buildings
• Power infrastructure
• Water infrastructure
• Tailings facilities
• Rail infrastructure
• Port infrastructure
• Land
• Intangible assets
• Software
• Deferred tax assets
• Long-term investments
• Environmental deposits
• Rehabilitation trust funds

Equity

• Issued share capital
• Additional paid-in capital
• Retained earnings
• Accumulated Other Comprehensive Income
• Share option reserve
• Foreign currency translation reserve
• Minority interests (if applicable)
• Total Equity

Commodity Price Forecasting Tabs

Commodity forecasting is a key driver of revenue and project valuation. The model should allow users to input or generate price forecasts by commodity, supporting base, upside, and downside scenarios over the life of the mine.

Forecast Inputs

For each commodity, the forecast should include:

• Historical prices
• Spot price
• Consensus analyst forecast
• Long-term incentive price
• Management forecast
• Inflation assumptions
• Exchange rate assumptions
• Supply-demand adjustments
• Scenario selection (Base, Bull, Bear)

Discounted Cash Flow (DCF) for Mining
In mining, the DCF is less about going-concern value and more about the depletion of a finite asset. The model projects the mine’s life-of-mine (LOM) physical plan—20 years—converting ore tonnes and recoveries into annual Unlevered Free Cash Flow (UFCF). Unlike a manufacturing business, mining DCFs strictly end at mine closure, incorporating a negative terminal cash flow for decommissioning and site rehabilitation. The “terminal value” is often excluded or heavily discounted, as the resource is not perpetual; instead, the bulk of the valuation comes from the explicit forecast period, making the accuracy of the production schedule and cost curve absolutely critical to the final Net Asset Value (NAV).

Weighted Average Cost of Capital (WACC)
WACC for a miner is heavily weighted toward equity due to the industry’s cyclical nature, often resulting in a high cost of capital (typically 8%–12% in USD terms). The Cost of Equity is elevated because mining stocks have high Beta—they amplify broader market swings, especially during commodity crashes, and carry significant geological execution risk. The Cost of Debt is influenced by project-specific factors like the ore reserve category (Proved vs. Probable) and jurisdictional risk; a mine in a stable country like Australia might secure debt at SOFR + 3%, while a project in a higher-risk region demands a substantial premium. Furthermore, WACC must be calculated in nominal terms to match the commodity price deck, and the gearing ratio is capped conservatively (usually 40%–50%) because lenders require robust covenant headroom for commodity price volatility.

Sensitivity Analysis as a Risk Compass
Given that the DCF output is highly unstable—a 10% drop in copper price can erase 25% of NAV—sensitivity analysis is the miner’s primary risk-management tool. The standard approach uses a tornado chart to rank variables by impact, where Commodity Price and Foreign Exchange (USD vs. local operating currency) almost always rank first and second, often outweighing changes in ore grade or fuel costs. In practice, this analysis feeds into scenario planning, running “Base,” “Upside,” and “Downside” cases simultaneously; the Downside case tests debt covenants by stressing price, throughput, and inflation together. For investors, the key takeaway is the “haircut”—the percentage drop in commodity price that would push the project to a negative NPV—which determines whether the project has a sufficient margin of safety to weather the industry’s inevitable cycles.