Financial Modelling for Mining Companies - Novice to Expert

Discover how financial models forecast outcomes, map cost and revenue drivers, and link ore extraction to export. Learn essential Excel hotkeys and color-coding for rapid, accurate modeling.

Identify internal and external profitability drivers, set macroeconomic assumptions (copper and gold prices, US dollar/rand exchange, inflation, interest), and use scenario toggles to model profits.

Explore the internal profitability drivers of a copper open-pit operation, modeling labor, fuel, and consumables costs per ton moved, plus plant throughputs, recovery, and process flow from mine to export.

Build a mining model from scratch by mapping an open pit process, calculating waste rock and ore tonnes, truck trips, and key costs such as diesel and explosives with inflation.

Link internal profitability drivers from mining and processing, connect direct costs, stockpile, and general and administrative costs, and forecast revenue through the full production and logistics chain.

Compute tax from earnings before interest, tax, depreciation and amortization by deducting interest and tax-deductible depreciation, then apply tax credits earned from losses against profits, illustrating a 10-year mining model.

Calculate and decompose fixed and variable costs to estimate working capital needs. Analyze accounts payable, accounts receivable, and inventory to determine net working capital and its year-to-year change.

Model the debt profile of an amortizing five-year facility by tracking opening balance, draws, interest charges, capitalization of interest, capital repayments, and the tax treatment of interest incurred.

Use accrual accounting to recognize revenue when earned, exclude working capital, and model cash flow, balance sheet items: capital expenditure and depreciation, for debt capacity and collateral.

Build a cash flow model linking capex, maintenance capex, working capital, taxes, and senior debt service to assess debt capacity and opening cash balance.

Asset-based financing uses ring-fenced arrangements for movable assets like mining fleets and office equipment, and includes finance leases and operating leases with distinct ownership and maintenance features.

Graph capital expenditure, copper production, and abda margins on a multi-variable combo chart to reveal project costs, ramp-up, and margin dynamics over time.

Analyze how variable costs per ton and copper price shape operational profit, explaining Abbadon margins' decline and the role of negative and positive jaws in profitability.

Use a pie chart to break down fixed, variable, and general and admin costs, and apply a waterfall graph to compare 2028 and 2029, highlighting EBITA drivers.

Learn to use essential excel functions—sum if, average if, count if, offset, and concatenate—to summarize large mining data, compute ZAR values, yen prices, USD transactions, and create unique transaction codes.

Apply data tables and what-if analysis to model debt, cash flow, and loan tenor, using Excel to compare semiannual installments and all-in rates.

Learn to use goal seek to determine break-even points and assess robustness of copper price and other drivers in mining finance, including hedging strategies to protect cash flow.

advance your financial modelling in the advanced section by focusing on risk analysis, stress testing, and project appraisal to make informed investment decisions and add value from day one.

Adjust the summary sheet, a model dashboard, to visualize real-time impacts of macroeconomic assumptions, debt sizing, and inflation on cash flows for client presentations.

Use the Excel choose function to toggle between mining scenarios (upgraded plant vs no upgrade) and quickly compare cash flow and mine plan outcomes, highlighting time value and NPV implications.

Explore building stress testing capabilities by applying grade sensitivity to copper and gold, propagating through the model to assess changes in ebit across years.

Learn to consolidate monthly data into annual totals with the sum if function and build a two-axis combo chart to visualize mine profiles across pits.

Define and apply payment flags to automate debt service calculations in mining models, using grace periods and debt service periods with mezzanine facilities; apply conditional formatting to highlight inactive periods.

Master cash flow waterfalls and cash sweeps to prioritize senior debt before mezzanine facilities. Model drawdowns, capitalized interest, and period moratoriums to reflect project ramp-up and determine debt repayment timing.

Explore how financial covenants regulate borrower behavior by tracking debt service ratio (DSC), debt service coverage ratio (DCR), and loan life cover ratio (LLCR) to guide draws and defaults.

Explore debt service coverage ratio and loan life cover ratio to size and sculpt debt repayment profiles, using cash flow available for debt service and contractual interest and capital payments.

Compute a mining company’s debt capacity using the debt service cover ratio, considering grace periods, loan tenor, discounting cash flows at Libor plus margin, and present-value analysis.

Calculate the peak funding limit and year-by-year drawdowns during a three-year grace period to derive the debt capacity, then allocate interest and capital to sustain a 1.5x DSCR.

Derive the loan life cover ratio as the present value of cash flow available for debt service divided by debt outstanding, showing its equivalence to a constant debt service ratio.

Learn how the project life cover ratio extends loan life cover by valuing cash flow available for debt service across the project life and comparing it to debt outstanding.

Learn how the reserve tail ratio assesses financing risk by comparing remaining ground reserves after debt repayment to initial reserves, with 33% signaling a robust project.

Explore how drawdown covenants are set before funds are advanced and how default covenants operate. Examine forward-looking loan life cover ratio thresholds and six-month reporting for borrower leeway and protection.

Compare senior and mezzanine debt covenants, determine when mezzanine debt qualifies as equity, and adjust debt service coverage ratio and other metrics accordingly.

Align lenders' interests by ensuring pro-rata participation across multiple debt facilities, harmonizing revolving credit facilities and amortizing facilities to support the client through downturns and preserve long-term returns.

Differentiate covenants for project financing from corporate facilities, emphasizing amortization-based covenants like debt service coverage and reserve tail ratio, versus abida and debt-to-equity covenants in corporate lending.

Explore corporate covenants for mining finance by calculating net debt to EBITDA and net debt to interest, to assess gearing and debt service risk for corporate bonds and revolving facilities.

Evaluate the gearing ratio (debt divided by debt plus equity) using either book or market value, and prioritize debt service coverage and loan life cover in covenant negotiations.

Explore how prepayment facilities, royalties, and streaming arrangements provide funding for mining projects, comparing upfront payments, delivery obligations, and cost structures like net smelter revenue and net profit royalties.

Calculate mining debt capacity by determining the funding gap, modeling senior debt, mezzanine, and equity; tailor debt service coverage and loan life cover ratios for a robust financing structure.

Explore senior debt and mezzanine debt profiles using cash flow available for debt service and a 1.5x debt service cover ratio to map capital structure and sources and uses.

Explore the ABC mining model, sizing senior and mezzanine debt from cash flow available for debt service using a 1.5x debt service coverage ratio, with automatic and manual debt options.

Compute a debt repayment profile with a 24-month grace period and semiannual payments; size senior and mezzanine debt using DSCR targets and loan life cover ratio in Excel.

Apply mezzanine debt logic with a cash sweep, set an annual five-year repayment, adjust the debt service cover ratio to 1.5x, and finalize by reducing the mezzanine loan to zero.

Stress-test copper prices year by year to determine the break-even point where the debt service cover ratio is met, using manual calculations and base-case assumptions.

Apply the small function with countif to ignore zeros and identify the minimum debt service coverage ratio across a range.

Explore long-term breakevens for copper price to ensure debt repayment using loan life cover ratio and debt service coverage ratio across the repayment tenor.

Explain hedging copper with forward contracts at 25% of production to fix price and improve debt service coverage, compare hedged vs unhedged, and note cash sweeps as a de-risking tool.

Review how the summary sheet tests mining metrics in real time, stress testing grade and costs, to reveal debt and profitability impacts.

Calculate the weighted average cost of capital for a mining company by weighting senior debt, mezzanine, and equity with the risk-free rate, market risk premium, and beta.

Learn to perform a discounted cash flow valuation for a mining company, including cash flow available for debt service, net debt, terminal value, and enterprise and equity value.

Create a data table summarizing the company's equity value under varying terminal growth rate assumptions for negotiation insights.

Learn to assess a mining company's equity value and debt capacity using metrics such as loan life cover ratio and debt service coverage ratio, supporting investment and credit decisions.

This bonus lesson outlines three valuation approaches for mining companies—income (dcf), market (comps), and cost—applied from early exploration to decommissioning, referencing South Africa mining codes and per unit of metal.