Maine Company is considering Projects S and L, whose cash flows are shown below
There are two cases in this assignment. Case 1 tests Chapter 10 and Case 2 covers Chapter 11.
You can work on these cases in Excel, but please make sure to copy the excel functions in your submitted file, or explain in words your step-by-step work detail.
Case 1:
Maine Company is considering Projects S and L, whose cash flows are shown below. These projects are mutually exclusive, equally risky, and are not repeatable.
WACC: 7.75%
Year 0 1 2 3 4
CFS −$2,000 $1,500 $1,200
CFL −$2,000 $800 $800 $800 $800
Answer the following questions:
1) Calculate NPV, IRR, and MIRR for Project S and L. (Please copy and paste your excel function in here as your work detail).
2) If the decision is made by choosing the project with the higher IRR, how much value will be forgone?
3) Explain the underlying cause of ranking conflicts between NPV and IRR.
Case 2:
Bangor Moving Company is thinking of opening a new warehouse, and the key data are shown below. The company owns the building that would be used, and it could sell it for $100,000 after taxes if it decides not to open the new warehouse. The equipment for the project would be depreciated by the straight-line method over the project's 3-year life, after which it would be worth nothing and thus it would have a zero salvage value. No new working capital would be required, and revenues and other operating costs would be constant over the project's 3-year life. What is the project's NPV? (Hint: Cash flows are constant in Years 1-3.)
You can work on this case in excel and copy your step-by-step answer here.
|
Project cost of capital (r) |
10.0% |
|
Opportunity cost |
$100,000 |
|
Net equipment cost (depreciable basis) |
$65,000 |
|
Straight-line deprec. rate for equipment |
33.333% |
|
Sales revenues, each year |
$123,000 |
|
Operating costs (excl. deprec.), each year |
$25,000 |
|
Tax rate |
25% |
Collepals.com Plagiarism Free Papers
Are you looking for custom essay writing service or even dissertation writing services? Just request for our write my paper service, and we'll match you with the best essay writer in your subject! With an exceptional team of professional academic experts in a wide range of subjects, we can guarantee you an unrivaled quality of custom-written papers.
Get ZERO PLAGIARISM, HUMAN WRITTEN ESSAYS
Why Hire Collepals.com writers to do your paper?
Quality- We are experienced and have access to ample research materials.
We write plagiarism Free Content
Confidential- We never share or sell your personal information to third parties.
Support-Chat with us today! We are always waiting to answer all your questions.
