Question
Suppose a firm is considering a labor-saving investment. In year 0, the project requires an $11,700 investment in equipment (all figures are in thousands of
Suppose a firm is considering a labor-saving investment. In year 0, the project requires an $11,700 investment in equipment (all figures are in thousands of dollars). This investment is depreciated using the straight-line method over five years and there is salvage value in year 5 of $4,500. With or without the cost-reducing investment, all cash flows start in year 1 and end in year 5. The inflation rate is 2.6% in year 1 and declines to 1.4% in year 5; the real growth rate is 21.3% in year 2 and declines to 9.5% in year 5 (assume both fall in a straight-line fashion). The tax rate is 41.0% in all years. The cost of capital is 15%. Without the cost-reducing investment, the firm's existing investments will generate year 1 revenue, labor costs, other cash expenses, and depreciation of $15,200, $4,100, $5,300, and $3,300, respectively. With the cost-reducing investment, the firm's year 1 labor costs will be $1,600 and revenues and other cash expenses will remain the same. What is the cost-reducing project NPV and IRR? Should the firm undertake the project? Please, it needs to be an excel. Thank you in advance for the support and assistance
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