Question
Suppose ABC firm is considering an investment that would extend the life of one of its facilities for 5 years. The project would require upfront
Suppose ABC firm is considering an investment that would extend the life of one of its facilities for 5 years. The project would require upfront costs of $8M plus $(35+C)M investment in equipment. The equipment will be obsolete in (2+A) years and will be depreciated via straight-line over that period (Assume that the equipment can't be sold). During the next 5 years, ABC expects annual sales of (A+B+50)M per year from this facility. Material costs and operating expenses are expected to total (B+40-C-3)M and (B+1+0.8)M, respectively, per year. ABC expects no net working capital requirements for the project, and it pays a tax rate of (30+D)%. ABC has (70+A)% of Equity and the remaining is in Debt. If the Cost of Equity and Debt are (A+8)% and 6% respectively, should they take the project? From the example: Because the ID in this example is 35621215, then A = 1, B = 2, C = 1, and D = 5. Suppose ABC firm is considering an investment that would extend the life of one of its facilities for 5 years. The project would require upfront costs of $8M plus $(35+1)M investment in equipment. The equipment will be obsolete in (2+1) years and will be depreciated via straight-line over that period (Assume that the equipment can't be sold). During the next 5 years, ABC expects annual sales of (1+2+50)M per year from this facility. Material costs and operating expenses are expected to total (2+40-1-3)M and (2+1+0.8)M, respectively, per year. ABC expects no net working capital requirements for the project, and it pays a tax rate of (30+5)%. ABC has (70+1)% of Equity and the remaining is in Debt. If the Cost of Equity and Debt are (1+8)% and 6% respectively, should they take the project? After solving the operations, the problem for this student becomes: Suppose ABC firm is considering an investment that would extend the life of one of its facilities for 5 years. The project would require upfront costs of $8M plus $36M investment in equipment. The equipment will be obsolete in 3 years and will be depreciated via straight-line over that period (Assume that the equipment can't be sold). During the next 5 years, ABC expects annual sales of 53M per year from this facility. Material costs and operating expenses are expected to total 38M and 3.8M, respectively, per year. ABC expects no net working capital requirements for the project, and it pays a tax rate of 35%. ABC has 71% of Equity and the remaining is in Debt. If the Cost of Equity and Debt are 9% and 6% respectively, should they take the project? NOTE: YOU MUST ANSWER THE QUESTIONS IN THE EXCEL DOCUMENT. The answers to be provided are: a) WACC (in percentage, thus 3.8% must be entered as 3.8); b) Incremental FCF at 0; c) Incremental FCF from year 1 to year 5; d) NPV. All dollars answers must be submitted in Millions, thus 4.56M must be entered as 4.56. Round to the second decimal in each case. DO NOT PUT ANY UNITS IN YOUR ANSWERS
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started