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.

SOLUTION This solution is FREE courtesy of BrainMass!

Please see the attached excel document.

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!