** Please see the attached file for the data **
Calculate payback, internal rate of return (IRR), modified internal rate of return (MIRR), and net present value (NPV), and make a recommendation whether the company should open the mine based on your calculations.© BrainMass Inc. brainmass.com June 4, 2020, 2:03 am ad1c9bdddf
Please see the attached excel document.
Learning about Important concepts
Capital budgeting involves making decision about the long term mix of the composition of assets of the business. As per Zen Wealth, "Capital Budgeting is the process by which the firm decides which long-term investments to make. Capital Budgeting projects, i.e., potential long-term investments, are expected to generate cash flows over several years. The decision to accept or reject a Capital Budgeting project depends on an analysis of the cash ...
This solution helps in calculating IRR, MIRR, and Discounted Cashflow.