Mining Project Finance Model (Debt and DCF Valuation)
Originally published: 07/08/2020 08:55
Last version published: 23/06/2021 15:38
Publication number: ELQ-14183-6
View all versions & Certificate

Mining Project Finance Model (Debt and DCF Valuation)

Mining Project finance model based on tried and tested investment banking methodologies.

This is a project finance model based on a copper mining business. It is best suited for analyzing debt capacity, and performing a discounted cash flow valuation.

The mine is open cast, and has a plant with a refinery and smelter to produce LME standard copper for export. This can be expanded and customized to one's individual mining business very easily.

The capital expenditure profile and resultant mining plans can easily be modified, as well as the production plant's productivity rate per hour.

The model also includes basic stress-testing functionality on grades, operating costs and commodity prices.
The model includes a capital expenditure input to model any expansion plans in future.

Senior debt and mezzanine facilities have been modeled, where the mezzanine facility has a built-in cash sweep mechanism.

CAPM and WACC calculations are included, as well as a valuation sheet to determine the enterprise and equity value of the business for various growth-rate assumptions.

Accounting statements (income statement and balance sheet) are also included, as well as a tax and working capital sheet which can be adjusted for country-specific tax rates, and business-specific creditors/debtors days.

The model also includes standard project finance debt covenant ratios such as loan-life cover ratios and debt-service cover ratios.

This Best Practice includes
1 Excel Model

Acquire business license for $199.00

Add to cart

Add to bookmarks


Further information

A customizable financial model useful for valuing a mining business,
Useful for calculating debt capacity and structuring mezzanine and senior debt,
Useful for business strength and weakness deep-dives and credit analysis, cost breakdowns and year-on-year financial comparisons

Mining businesses, particularly involving metal exports and beneficiation
Debt funding via investment banks and private equity
Company valuation

Non-mining or non-manufacturing businesses (e.g. service industries, fast-moving consumer goods, property etc.)


  • Rate this Downloadable Best Practice

    Write a review

  • Amir Ganic(last updated: 07/08/2020 20:43)


Discussion feed for Mining Project Finance Model (Debt And DCF Valuation)

The user community and author are here to help. Go ahead!

  • Perry Fisher
    Dear Fellow Modeller

    Please don't forget to leave me a rating or feedback. This is highly appreciated.

    Also, this model is used as part of my online training offering, where I teach financial modelling and mining finance. As a user of my model I would like to offer you an exclusive discount coupon for my online courses:

    - Investment Banking - Mining finance: Learn how to structure corporate and project financing deals with particular emphasis on credit risk mitigation, senior debt, mezzanine debt, streaming and royalty funding, legal structuring, and financial covenant considerations;

    - Financial Modelling for Mining Companies: Learn how to construct a mining financial model from scratch, if given a feasibility study or detailed technical and engineering data, learn how to value a mining company using a DCF approach, learn how to calculate the debt capacity of a mining venture, and learn how to structure the optimal funding structure of a mine.

    See for more information


    arrow_drop_uparrow_drop_downReply reply

    5.0 / 5 (1 votes)

    please wait...