Sign In
Not register? Register Now!
Pages:
2 pages/≈550 words
Sources:
3 Sources
Style:
APA
Subject:
Accounting, Finance, SPSS
Type:
Essay
Language:
English (U.S.)
Document:
MS Word
Date:
Total cost:
$ 10.53
Topic:

NPV, IRR, MIRR, and PI

Essay Instructions:

You are a financial analyst for the Brittle Company. The director of capital budgeting has asked you to analyze two proposed capital investments: Projects X and Y. Each project has a cost of $10,000, and the cost of capital for each is 12%. The projects' expected net cash flows are shown in the table below.
Expected Net Cash Flows
Year Project X Project Y
0 – $10,000 – $10,000
1 6,500 3,500
2 3,000 3,500
3 3,000 3,500
4 1,000 3,500
Use the Homework Student Workbook to calculate each project's net present value (NPV), internal rate of return (IRR), modified internal rate of return (MIRR), and profitability index (PI).
Which project or projects should be accepted if they are independent?
Which project or projects should be accepted if they are mutually exclusive?
For additional details, please refer to the Homework Guidelines and Rubric PDF document.
Update:
Use the workbook spreadsheet file attached (computations are already done) to answer the remaining questions

Essay Sample Content Preview:

Capital Budgeting
Name
Institution
Course
Instructor
Date
Capital Budgeting
Investment evaluation is a key procedure in determining projects to invest in. The process determines the risk and the expected returns from an investment. The common methods of investment evaluation are; Net Present Value (NPV), Internal Rate of Return (IRR), Modified Internal Rate of Return (MRR), and Profitability Index (PI). All these methods can choose the most suitable projects to invest in.
The NPV appreciates that a dollar today is not equal to a dollar tomorrow. The investment’s cash flows are discounted using an appropriate discount rate to determine their present values. The total value of all cash flows (outflow and inflows) equals NPV. Using NPV projects with a positive NPV should be undertaken, and those with negative NPV should be forgone. The one with the highest positive NPV should be undertaken (Zamfir, Manea, & Ionescu, 2016). Applying this to projects X and Y, both have positive NPVs of $966.01 and $630.72, respectively. Both are financially viable projects and should be undertaken if they are independent. Each project will result in value addition by the end of year four. If both projects are mutually exclusive, Brittle Company should undertake project X as it has a higher NPV.
The IRR estimates the profitability of a project by determining the discount rate, which would result in zero NPV. Projects with IRR above the cost of capital (discounting factor) should be undertaken as they will result in a profit (Arshad, 2012). The higher the IRR, the more attractive a project is. Project X IRR is 18.03%, and that of Y is 14.96%. Both projects have IRRs that are higher than the discounting rate of 12% and should be undertaken if they are independent. If the projects are mutually exclusive, project X should be undertaken since it has a better internal rate of return than Y.
MIRR improves on the IRR by considering that positive cashflows of a project are reinvested at the firm’s cost of capital...
Updated on
Get the Whole Paper!
Not exactly what you need?
Do you need a custom essay? Order right now:

You Might Also Like Other Topics Related to capital punishment:

HIRE A WRITER FROM $11.95 / PAGE
ORDER WITH 15% DISCOUNT!