Quantitative Problem: Sunshine Smoothies Company $($SSC$)$ manufactures and distributes smoothies. SSC is considering the development of a new line of high$-$protein energy smoothies.

SSC$\text{'}$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 $$4\mathrm{.}9$ million today $(t=0)$ to purchase additional equipment. For tax purposes the equipment will be depreciated on a straight$-$line basis

over $5$ years. Thus, the firm's annual depreciation expense is $$4,900,\frac{000}{5}=$$$980,000.$ 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 $$2,300,000$ before taxes.

The project will require an increase in net operating working capital of $$650,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,400,000$

$2,7,850,000$

$3,3,500,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\mathrm{.}0\%.$

What is the project's expected NPV and IRR? Do not round intermediate calculations. Round the monetary value to the nearest cent and percentage value to two decimal places.

NPV $

IRR

$\%$

Should the firm accept the project?

The firm should accept the project. Please use excel for your calculation and show the formula used. Thank you