Mining financial model: output, costs and capital

A mining financial model connects saleable output, realized selling prices, operating costs and capital commitments to the operation's cash needs. Build it from approved business assumptions and reconciled financial exports, then change price or volume to see what moves. This workflow covers operating finance; operations supplies the production assumptions.

Set the scope and gather the files

Use a consistent site, reporting period, quantity unit and currency. The example is an illustrative US industrial-mineral operation for one year, with quantities in short tons and amounts in USD. Its prices and costs are assumptions, not market benchmarks.

Bring these source records:

Map each cost once. In this example, the variable rate includes the operation's volume-linked cash charges, and the fixed-cost line includes site cash overhead. Capital spending and scheduled closure payments sit separately. If your accounts classify a cost differently, document the mapping before comparing actuals with plan.

The broader financial modeling guide explains how assumptions connect to financial statements. Here, keep the workbook focused on site margin and the cash effects of supplied operating scenarios.

Reconcile quantities before multiplying by price

Use saleable quantities accepted by operations, then reconcile shipments to inventory. The base case assumes no change in finished saleable inventory and that the shipments shown qualify as sales in the period.

The check is 10,000 + 100,000 - 100,000 = 10,000 short tons. If production differs from shipments, carry the inventory change into the cost and working-capital schedules rather than pretending every ton produced was sold.

Calculate realized price from the company's net sales and shipped quantities. Keep customer deductions and freight treatment consistent between price assumptions and actual sales. If each shipment row has tons in column B and net price per ton in C, revenue can be checked with:

=SUMPRODUCT(Shipments!B2:B1000,Shipments!C2:C1000)

Microsoft's SUMPRODUCT documentation explains that the function multiplies corresponding values and adds the products. Extend the range to cover the export and exclude summary rows. Covirage is not affiliated with Microsoft.

Build a cash-focused scenario workbook

Put the following labels in column A of a sheet named Scenario and base-case inputs in column B. All amounts are exact whole dollars. Operating costs are positive inputs that formulas subtract.

This is a pre-income-tax cash schedule before debt-principal repayments, new funding and owner distributions. It does not calculate an accounting closure liability or a project valuation. Add the excluded cash schedules before using the workbook to approve funding or discretionary spending.

Place revenue through closing cash in rows 11 through 15:

B11 =B2*B3
B12 =B2*B4
B13 =B11-B12-B5
B14 =B13-B6-B7-B8-B9
B15 =B10+B14

Each label before = identifies the destination cell. Row 13 is cash operating surplus before capital, working capital, interest and closure payments. Row 14 is the change in cash within the stated scope, and row 15 is the resulting cash balance before the excluded items.

Revenue is not the same as cash collected. The IRS accounting-method guidance distinguishes reporting under cash and accrual methods; the operating workbook must likewise keep recorded sales separate from collection timing. The working-capital adjustment here captures the assumed cash absorbed by operating balances. See cash flow versus profit for the wider distinction.

Work the base case and change one input

Copy column B into C for a lower-price case and into D for a lower-volume case, keeping the formulas relative. In C, change only realized price to $74 per short ton. In D, change only shipped and sold volume to 90,000 short tons; operations also assumes matching production, so saleable inventory stays unchanged.

The price case reduces operating surplus by $800,000: 100,000 × ($82 - $74). Variable operating costs do not change under the stated assumptions. The volume case reduces surplus by $360,000: (100,000 - 90,000) × ($82 - $46), because lower volume removes both revenue and the associated variable cost.

Working capital and capital spending deliberately remain unchanged in these isolated tests. A fuller downside case should revisit their timing and operating assumptions after the individual effects are understood.

Prove the cash bridge and assign the decision

For the base case, sources and uses must agree:

Opening cash + operating surplus = capital spending + working-capital increase + interest + closure payments + closing cash.

500,000 + 2,200,000 = 1,000,000 + 300,000 + 150,000 + 200,000 + 1,050,000.

Both sides equal $2,700,000. In the sheet, this control must return zero:

=B10+B13-B6-B7-B8-B9-B15

Repeat it for each scenario. Separately tie actual revenue to the invoice register, costs to the ledger and opening cash to the treasury balance. A balanced scenario can still contain an unsupported volume assumption, so keep approval and source references beside each input.

FP&A maintains the calculations, operations approves volumes and cost behavior, accounting checks financial classifications, and treasury owns the cash schedule. Use FP&A analysis to frame the resulting business questions. For the spreadsheet-specific layout, see the neighboring mining financial model in Excel guide.

Where mining cash scenarios go wrong

• Treating production as a sale. Unsold output changes inventory; it does not automatically generate revenue or collections.
• Mixing quantity units. Keep the same ton definition in volume, realized price and unit cost. Confirm conversions before comparing sites.
• Scaling every cost with volume. Fixed costs and committed capital do not disappear automatically when shipments fall.
• Double counting commitments. Keep closure payments and capital separate from operating-cost assumptions when they are deducted separately in the bridge.
• Treating partial closing cash as spendable cash. Add income taxes, principal repayments, distributions and minimum operating cash requirements before approving a decision.

Compare your own mining workbook in Covirage

Bring your scenario workbook and actual shipment, cost and capital exports in a file or Google Sheet. Covirage maps the columns; its tools compute and check the comparisons, and the external AI model explains the results with every figure traced to its rows. Create a free Covirage account, which takes about a minute, then set up your business and bring a sample of your own data.

See how this supports FP&A reporting.