Operating schedules · in 1 model

Mine plan: from ore reserve to payable metal

Ore and waste, head grade, recovery, smelter payables.

By Surojit Chakraverti, founder of L3VLUP and an investor running a long-short healthcare and technology equities strategy.

On this subject: mine plan: from ore reserve to payable metal.Updated 11 November 2026

Part of project finance and infrastructure models, with the models, labs and guides around it.

What it does

The base of a mining forecast. The reserve is a tonnage at a grade; each year the mine mills the lesser of what the plant can process and what is left, so the reserve sets the mine life. Waste is ore times the strip ratio, and the two together are the material the fleet has to move. Head grade, the grade of the ore fed to the mill, usually starts above the reserve average and declines, and the plan has to reconcile: ore milled at its head grades cannot hold more metal than the reserve. Recovery takes the metal that reaches the concentrate, and the smelter pays for a share of that, which is the payable metal revenue is built on.

Where it lives

The same schedule in each model that carries it, with the rows to open. Open a model in the browser, go to the sheet, and click the lines.

Mining model: copper-gold mine NAV
  • Assumptions, rows 21–30: Ore reserves, FY0, Reserve grade, copper, Reserve grade, gold, Mill throughput…
  • Mine Plan, rows 6–14: Opening ore reserves, Ore mined and milled, Closing ore reserves, Waste mined…
  • Mine Plan, rows 17–23: Grade profile, first year = 1, Ore milled x grade profile, Copper head grade, plan, Gold head grade, plan…
  • Mine Plan, rows 26–35: Copper recovery, selected scenario, Gold recovery, selected scenario, Copper in ore milled, Copper recovered to concentrate…

What a reviewer looks for

  • Ore milled above the reserve left, so the mine never ends.
  • Head grades that add up to more metal than the reserve holds.
  • Contained metal treated as payable, with no recovery loss or smelter deduction.

Learn it, then build it

Vocabulary: Strip Ratio.

Other operating schedules

Working capital scheduleCapex and depreciation (PP&E roll-forward)Airline capacity and traffic: ASK, RPK and load factorAirline unit revenue and unit cost: RASK and CASKAirline fuel cost and hedgingType curves and production declineOil and gas reserves roll-forwardRealised prices and the field netbackUnits-of-production DD&AContainer fleet: owned, chartered, newbuilds and scrappingC1 cash cost and all-in sustaining costMine closure and rehabilitation provisionLiftings and freight rate: a liner’s revenueSystem sales and royalties: a franchisor’s units and volumesRestaurant unit economics: restaurant margin and new-unit returnsBunker fuel and the bunker adjustment factorRate base roll-forwardAllowed revenue: the building blocksRegulatory lag: earned against allowed returnHeadcount pyramid: hiring, attrition and promotionMobile subscriber roll-forward: gross adds, churn, net addsFibre build: homes passed, penetration and connectionsSpectrum licences: auction payments and amortisationTower site roll-forward: build-to-suit and decommissioningTenancy roll-forward: anchor, colocation and the tenancy ratioTower unit economics: yield on cost by tenantGround lease schedule: rent, escalators and buy-outsUtilisation and realisation: hours to fee revenueProfit per partner: pay, bonus pools and partnership profitStore estate roll-forward and cohortsRetail sales: density, like-for-like and onlineFour-wall EBITDA and new-store paybackStore leases under IFRS 16Driver-based budget: volume, price, heads and cost per headRolling forecast: actuals, reforecast and the outturnPrice-volume-mix: revenue and margin varianceCost variances: rate, volume, heads and cost per headEBITDA bridge: plan to actual and forecastCapacity cohorts: MW, GPUs, utilisation and revenueBacklog roll-forward: contracts to revenue to cashCapital roll-forwardRisk budgetTrading cost baseSponsorship revenue