Open Pit Mine Financial Model

Video Tutorial:

*Updated to have better logic for IRR and ROI calculations, added a DCF analysis, and updated instructions for ore value per tonne calculations. Also updated dynamic referencing for cost inputs.

This financial model takes into account all the general capital costs, employee wages, and supplies required to operate an open-pit mine and sets them against possible revenue so you can see what annual cash flow/break even scenarios look like.

One of the more unique features implemented was allowing the user to enter a % breakdown of what they expect their tonne makeup to look like by ore. For example, you can enter that 40% is expected to be gravel, 40% clay, and 20% rock salt. All of the different ore types have been priced out at a value per tonne and dynamically represent themselves in annual revenue based on your assumptions. Those values can then be updated as-needed.

Return Metrics:
– IRR
– Total/Net Cash Return (% and $)
– Break Even Year

You will also see visuals to let you get a more clear picture of where the costs are coming from and how the cash flow balance changes over time based on the pro-forma cash flows.

This is a great way to get a clear picture of the costs it takes to implement an open-pit mine and from there it will be useful to see what kind of revenue you need to get in order to turn a profit. All costs are dynamic and you can adjust them based on what you find in your specific scenario.

Financing option is now available. This will let the user put a % of the total startup costs financed by a loan and see how that debt service effects the cash flows/returns/IRR. You can also set all the loan paramters.

Notes and sources will be given on the full version only.

 

 

 

 

Users who purchased Open Pit Mine Financial Model, also purchased:
Goodwill Valuation and Impairment Test Model Template
Add to wish list
Purchase Excluding 7.7% tax
Interest Rate Swap Valuation and Payment Schedule
Add to wish list
Purchase Excluding 7.7% tax
Gold Mine Investment Model
Add to wish list
Purchase Excluding 7.7% tax
Industry ,
Summary Allow a potential miner to see visually and numerically (annual basis) what their possible financial position would look like when starting up an open-pit mining operation.
Screenshots / Pictures



Use Cases , , , , , , ,

Write a Review

Get these templates too for a discount!

Price: $79.95

This is a collection of financial model templates in Excel for businesses in the Manufacturing industry and its related sectors.

Add to wish list
Add to cart Excluding 7.7% tax

Price: $140.00

This is a bundle of financial model templates related to the Fitness and Sports Industry. To help you save money from having to buy the models separately, we collected some of our existing models that…

Add to wish list
Add to cart Excluding 7.7% tax

Starting at: $99.00

I have added all the industry specific financial models all into one bundled package. Included Models: 1. Mining Operation 2. Apple Orchard 3. Hospital 4. E-Commerce (Amazon specific) 5. Real Estate (with Join Venture capability)

Add to wish list
Add to cart Excluding 7.7% tax