Question

Sunshine Smoothies Company (SSC) manufactures and distributes smoothies. SSC is considering the development of a new line of high-protein energy smoothies. SSC's CFO has collected the following information regarding the proposed project, which is expected to last 3 years: The project can be operated at the company's Charleston plant, which is currently vacant. The project will require that the company spend $3.8 million today (t = 0) to purchase additional equipment. This equipment is eligible for 100% bonus depreciation, so the equipment is fully depreciated at the time of its purchase. The company plans to use the equipment for all 3 years of the project. At t = 3 (which is the project's last year of operation), the equipment is expected to be sold for $1,450,000 before taxes. The project will require an increase in net operating working capital of $730,000 at t = 0. The cost of the working capital will be fully recovered at t = 3 (which is the project's last year of operation). Expected high-protein energy smoothie sales are as follows: Year Sales 1 $2,600,000 2 7,400,000 3 3,800,000 The project's annual operating costs (excluding depreciation) are expected to be 60% of sales. The company's tax rate is 25%. The company is extremely profitable; so if any losses are incurred from the high-protein energy smoothie project they can be used to partially offset taxes paid on the company's other projects. (That is, assume that if there are any tax credits related to this project they can be used in the year they occur.) The project has a WACC = 10.0%.

What is the project's expected NPV and IRR? Round your answers to 2 decimal places. Do not round your intermediate calculations. NPV $ IRR %

Answer 1

Answer:

NPV IRR $1,185,815.18 24.67%

Working:

Year Equipment Cost Net working capital ($3,800,000) ($ 730,000) $0 Sales Operating costs Depreciation (Bonus depreciation) | EBIT Tax at 25% EAT Add back depreciation Operating cash flows $2,600,000 $7,400,000 $3,800,000 ($1,560,000) ($4,440,000) ($2,280,000) ($3,800,000) $0 $0 ($3,800,000)| $1,040,000 $2,960,000 $1,520,000 $950,000 $260,000) ($740,000) ($380,000) ($2,850,000) $780,000 $2,220,000 $1,140,000 $3,800,000 $950,000 $780,000 $2,220,000 $1,140,000 $0 $0 $0 Salvage value net of tax Recovery of net working capital $1,087,500 $730,000 $780,000 $2,220,000 $2,957,500 Cash flows NPV ($3,580,000)| $1,185,815.18 24.67% IRR

Above excel with 'show formula' is as follows:

1 Year 2 Equipment Cost -3800000 3 Net working capital -730000 4 5 Sales 6 Operating costs 7 Depreciation (Bonus depreciation) =B2 8 EBIT =B5+B6+B7 9 Tax at 25% =B8*-25% 10 EAT =B8+B9 11 Add back depreciation --B7 12 Operating cash flows =B10+B11 13 14 Salvage value net of tax 15 Recovery of net working capital 16 17 Cash flows =B2+B3+B12 18 NPV =NPV(10%,C17:E17)+B17 19 IRR =IRR(B17:E17) 2600000 7400000 3800000 =C5*-60% =D5*-60% 1=E5*-60% 0 0 =C5+C6+C7 =D5+D6+D7 =E5+E6+E7 =C8*-25% =D8*-25% =E8*-25% =C8+C9 =D8+D9 =E8+E9 --D7 --E7 =C10+C11 =D10+D11 =E10+E11 --C7 =1450000*(1-25%) --B3 =C12 =D12 =E12+E14+E15 20