Explore BrainMass

Explore BrainMass

    IRR, MIRR, and Discounted Cashflow

    Not what you're looking for? Search our solutions OR ask your own Custom question.

    This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

    ** 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 December 24, 2021, 10:02 pm ad1c9bdddf
    https://brainmass.com/business/modified-internal-rate-of-return/irr-mirr-discounted-cashflow-435808

    Attachments

    SOLUTION This solution is FREE courtesy of BrainMass!

    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 flows generated by the project and its cost.

    The following Capital Budgeting decision rules will be presented:
    - Payback Period
    - Net Present Value (NPV)
    - Internal Rate of Return (IRR)
    - MIRR
    - Profitability Index

    Payback period
    It is the period in which initial investments are recovered. Payback helps in knowing about the recovery period of the investments put into the project. Lower payback period is desirable.

    NPV
    Net Present value gives the value addition by the project. It is calculated by:
    NPV= Present value of Future cash flows- Initial investments

    IRR
    Internal rate of return refers to the return earned from the project. At IRR, NPV= zero.

    MIRR
    It takes care of opportunity costs at the WACC

    Profitability index
    = Present value of inflows/Outflows

    As per zenwealth, "A Capital Budgeting decision rule should satisfy the following criteria:

    - Must consider all of the project's cash flows.
    - Must consider the Time Value of Money
    - Must always lead to the correct decision when choosing among Mutually Exclusive Projects."

    Hence as per the above criteria, NPV will be the best method of selection of the project.

    Analysis of Our Case study

    1st Project

    One can accept the project as NPV is $9,95,20,048 which is indicating positive value addition by the project.
    Its IRR is more than WACC and PI is also positive.

    2nd Project

    One can accept the project as NPV is $3,86,92,769 which is indicating positive value addition by the project.

    Its IRR is more than WACC and PI is also positive.

    This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

    © BrainMass Inc. brainmass.com December 24, 2021, 10:02 pm ad1c9bdddf>
    https://brainmass.com/business/modified-internal-rate-of-return/irr-mirr-discounted-cashflow-435808

    Attachments

    ADVERTISEMENT