Video Tutorial:
Recent update was added to account for price changes in the ores over time.
Includes a full set of financial statement reports (Income Statement, Balance Sheet, Cash Flow Statement) and a capex schedule with depreciation logic, a cap table, and better global control assumptions.
Functional for many types and combinations of metals / gems / materials.
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.
The 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 parameters.
Notes and sources will be given on the full version only.
Similar Products
Other customers were also interested in...
Gold Mining Company DCF Valuation Model Template
This is a detailed and user-friend financial model with the three financial statements, i.e., Income... Read more
Discounted Cash Flow DCF Valuation Model Template ...
This is a detailed and user-friendly financial model with the three financial statements i.e. Income... Read more
Gold Mining Investment Project – 10 year Fin...
Financial Model providing forecast and valuation analysis of a Gold Mining Project. The... Read more
Industry Based Financial Models (Variety Bundle)
There are currently 52 unique financial models included in this bundle. Nearly all of that include a... Read more
Economic Model for Oil and Gas Extraction Feasibil...
This model runs for 20 years and makes it easy to create a financial plan and feasibility study for ... Read more
Upstream Oil & Gas Project Analysis
The Upstream Oil & Gas Project Financial Model Template in Excel empowers you to project and dissect... Read more
Oil & Gas Financial Model – Dynamic 10 Y...
Financial Model providing forecast and valuation analysis of an upstream Oil & Gas Project. T... Read more
Oil & Gas Marketing and Distribution DCF Valu...
A detailed and user friend financial model that captures 5 years of Historical + 1 Year of Budget + ... Read more
Private Equity Oil and Gas Financial Model
The Private Equity Oil and Gas Financial Model evaluates the financial feasibility and investor retu... Read more
Oil & Gas Financial Model – DCF and NAV Valu...
The Oil and Gas financial model with DCF (Discounted Cash Flow) and NAV (Net Asset Value) Valuation ... Read more
Reviews
I find the model useful in my analysis of copper mining project. The only issue am asking is out of ore extracted from the ground, we plan to sell only copper at the moment although the tested sample shows the existence of some gold, aluminum, and traces of other minerals, therefore the Mine&Ore sheet will not add up to 100%, will this affect my Proforma?! I look forward to your DCF model for a financial institution, if available!!
In summary, the Open Pit mining model meets my expectations!!
Thank you for your feedback.
426 of 877 people found this review helpful.
-
Thank you for giving a review of this product. As for your question, what you would need to have is the following: Just populate column C with a % if it is to be sold, so in your case, just populate the copper row with a % and leave the rest blank. It is ok if it doesn't add up to 100%.
446 of 891 people found this review helpful.
Help other customers find the most helpful reviews
Did you find this review helpful?
You must log in to submit a review.