FIN 550 - Module 5 HW

docx

School

Southern New Hampshire University *

*We aren’t endorsed by this school

Course

550

Subject

Finance

Date

Jan 9, 2024

Type

docx

Pages

3

Uploaded by SargentSandpiperMaster672

Report
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 a) Use the Homework Student Workbook to calculate each project’s (NPV), (IRR), (MIRR), and (PI). b) Which project or projects should be accepted if they are independent? “The net present value (NPV) is defined as the present value of a project’s expected cash flows (including its initial cost) discounted at the appropriate risk-adjusted rate. The NPV measures how much wealth the project contributes to shareholders” (Ehrhardt & Brigham,2019). If the projects are independent, and the NPV is greater than zero, both projects should be accepted. Both of our projects have positive NPVs. Project X has a higher NPV compared to project Y. Project X Project Y NPV $ 966 $ 631 IRR 18 % 15 % MIRR 14.52 % 13.68 % PI 1.10 1.06
“The IRR is an estimate of the rate of return the company would earn if it invested in the project. If this return exceeds the opportunity cost of the funds used to finance the project, then the difference benefits the firm’s stockholders. On the other hand, if the IRR is less than the cost of capital, stockholders suffer a loss in value.” (Ehrhardt & Brigham,2019) “The modified IRR (MIRR) is similar to the regular IRR, except it is based on the assumption that cash flows are reinvested at the WACC”. (Ehrhardt & Brigham,2019) The IRR and the MIRR for both projects are positive, if the projects were independent, they should both be accepted, because both projects will return a greater rate of return than the cost of capital. “The profitability index (PI) measures how much value a project creates for each dollar of the project’s cost.” (Ehrhardt & Brigham,2019) A project should be accepted if the PI is greater than 1.0. Projects with higher PIs should be chosen above the projects with lower PIs. In conclusion, if project X and project Y were independent, they should both be chosen because they both independently provide a higher rate of return compared to the cost of capital when analyzed using NPV, IRR, MIRR and PI. c) Which project or projects should be accepted if they are mutually exclusive? If Project X and Project Y are mutually exclusive, the financial analyst should choose Project X. The reason for that is because project X has a greater NPV than project Y, it also has a greater IRR and MIRR percentage that project Y, and the PI index is higher for project X when compared to project Y. Project X will return a higher value to the shareholders than project Y will.
References: Ehrhardt, M. C., & Brigham, E. F. (2019). Corporate Finance: A Focused Approach (7th ed.). Cengage Learning US.  https://mbsdirect.vitalsource.com/books/9781337910231
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help