23 Aug 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% |
Our website has a team of professional writers who can help you write any of your homework. They will write your papers from scratch. We also have a team of editors just to make sure all papers are of HIGH QUALITY & PLAGIARISM FREE. To make an Order you only need to click Ask A Question and we will direct you to our Order Page at WriteDemy. Then fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.
Fill in all the assignment paper details that are required in the order form with the standard information being the page count, deadline, academic level and type of paper. It is advisable to have this information at hand so that you can quickly fill in the necessary information needed in the form for the essay writer to be immediately assigned to your writing project. Make payment for the custom essay order to enable us to assign a suitable writer to your order. Payments are made through Paypal on a secured billing page. Finally, sit back and relax.
About Wridemy
We are a professional paper writing website. If you have searched a question and bumped into our website just know you are in the right place to get help in your coursework. We offer HIGH QUALITY & PLAGIARISM FREE Papers.
How It Works
To make an Order you only need to click on “Order Now” and we will direct you to our Order Page. Fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.
Are there Discounts?
All new clients are eligible for 20% off in their first Order. Our payment method is safe and secure.