A detailed, user-friendly gold mining financial model with three integrated financial statements, DCF and comparable company valuation, built entirely in Excel.

Gold mining is a price-taker’s business. You do not set the gold price — the market does — so the value of a gold miner turns almost entirely on how much you can produce, at what cost per ounce, and for how long the reserve lasts. Those are the variables that decide the outcome, and they are exactly what a generic revenue-growth model cannot express. Value a gold miner without modelling grade, production and cost per unit, and the number you get is meaningless.

This model builds revenue from capacity, production, sales volume and unit price, so the gold price and your production profile drive the forecast directly. Operating cost and distribution are kept separate — the all-in cost of getting an ounce to market is what separates a profitable mine from a marginal one, and the model lets you flex it cleanly.

The model covers 3 years of historical data plus a 5-year forecast period. Valuation uses both discounted cash flow methodology and Comparable Company Analysis, so you can triangulate intrinsic value against how the market prices gold mining peers.

Built for a Commodity Price-Taker

Because unit price sits at the top of the revenue build, the gold price is a lever rather than a buried assumption. You can run the model at spot, at a conservative long-term price, or across a range — and watch cash flow, valuation and coverage ratios respond. For a business whose fortunes swing with a single traded commodity, that sensitivity is the whole point.

Pairing DCF with comparable company analysis matters especially here. Gold miners often trade at premiums or discounts to their intrinsic value depending on sentiment toward the metal. Seeing both numbers together tells you whether the market is pricing the business, the gold price, or both.

Assumptions You Control

A single assumption sheet drives the entire model. Change an input and every statement, ratio and valuation output updates automatically. The inputs cover:

What the Model Produces

Comprehensive calculations run off your inputs to generate a complete set of outputs:

• Income Statement — historical and forecast profit and loss
• Balance Sheet — historical and forecast, fully linked and balancing
• Cash Flow Statement — historical and forecast cash flows
• DCF & Relative Valuation — discounted cash flow plus comparable company analysis
• Ratio Analysis — a detailed analytical pack, set out below

Financial Analysis Included

The analysis sheet goes considerably beyond a standard ratio summary, giving you the metrics an analyst would expect in a full valuation pack:

Who This Is For

• Gold mining and metals companies building business plans, project cases or board materials
• Investment bankers and equity researchers covering gold, precious metals and mining
• Private equity and resource investors running diligence on gold mining assets
• Corporate finance and strategy teams in mining running forecasting and price-sensitivity work
• Finance professionals who need a commodity-price-driven DCF with a relative valuation cross-check

Why This Model

Need a model built to your own specification? See our financial advisory services, or browse the full range of DCF valuation templates.