Metal Mining Project Finance Model скачать в хорошем качестве

Metal Mining Project Finance Model

Check the model here: https://www.big4wallstreet.com/produc... Metal Mining Project Finance Model presents the business case of an investment in the construction & development of a metal mine and the sale of the metal mining products derived from it (gold, silver, copper, lead, nickel, zinc) before exiting the project after a set number of years. The model generates the three financial statements as well as the cash flows and calculates the relevant metrics (cash on cash, Internal Rate of Return, payback period, Net Present Value, Debt Service Coverage Ratio, Loan Life Coverage Ratio, Weighted Average Loan Life). The model generates: 1) Three financial statements (profit & loss, balance sheet and cash flow) 2) Valuation using free cash flows 3) Returns and KPIs 4) Breakeven analysis 5) Margins, ratios, and feasibility metrics 6) Three scenarios to stress test the plan in the "Scenarios" tab 7) Executive Summary tab which aggregates the most important metrics of the model. The Construction Tab contains the main investment assumptions such as useful life of the project, depreciation method (the user can choose between straight line and double declining), the salvage value at the exit of the investment, the contingency percentage which will increase the baseline construction costs. Furthermore the user sets in this tab the development fee (which is paid when the debt is drawn), the project management fee as a percentage construction costs (this fee can be paid on an annual or quarterly basis). Next the user sets the project name, the project exit (in years after the construction), and the construction start date. Additionally it is possible for the user to set the capex items on a quarterly items, the needed capex reserve account in terms of quarters and their corresponding useful life. Finally the user can set the timeline of the construction for each task, and their duration in quarters, as well as the cost per task. Moving to the Financing Tab, the user sets the percentage of debt financing, the construction costs initial funding from equity, and the debt split between senior tranches (A and B), and junior tranches. The user selects the repayment method for the senior tranches (amortized or debt sculpting), as well as the repayment frequency (semi annual or quarterly), and the balloon payment if any (up to 100%). The user then selects between fixed and variable interest rates, and adjusts the corresponding rates for each of these calculations methods, and for each tranche separately. The user also sets the debt repayment in years, the grace period, as well as the other financing fees such as commitment fees, upfront fess, agency fees and other financing fees. Finally the user sets the interest rate for the working capital facility. In the Commercial Tab, the user can set ore mined and the strip ratio, the grades for each metal, the recovery rate, and the payability. The pricing for each metal can also be set as USD per Kg, as well as the smelting and refining costs. The remaining items consist of operating project costs per ton. Additionally, the royalties can be set for the net smelter revenue, and the net operating profit. Finally, the working capital assumptions for inventory, receivables and payables days. The Other Tab contains tax assumptions, discount rate assumptions, dividends assumptions, and finally headquarters' labor and sales and general administrative costs. After finalizing your assumptions press the "Calculate Financing" button to update the Outputs tabs. Financial Statement Tabs: everything is aggregated here into the relevant statements: profit and loss, balance sheet and cash flow, both on a quarterly and annual basis. The Valuation is performed both on an annual basis, by using the free cash flows to the firm, free cash flows to equity, dividends discount method. In this tab are calculated the Enterprise Value, Net Present Value, the Cash on Cash Multiple, the Internal Rate of Return, and Payback Period. In the next tab, the Ratio tab, the model calculates the debt service coverage and loan life coverage ratio, as well as the senior debt weighted average life. Graphs Tab: Various graphs present the investment & operating costs as well as the revenue potential. Executive Summary: the summary page is updated with the main output metrics of the model such as Internal Rate of Return, Shareholder Value, Cash on Cash Multiple, Sources and Uses, Metal Production, Debt Service Coverage Ratio, Loan Life Coverage Ratio, and other financing assumptions. The user can also set three different scenarios: Base Case, Downside and Upside. After the user sets the assumptions and selects the scenarios, the user needs to press the "Calculate Financing" button. On the right side of the tab, the user can see the updated major metrics of the model.