Quantitative Problem: Sunshine Smoothies Company (SSC) manufactures and distributes smoothies. SSC is considering the development of a...

Free

90.2K

Verified Solution

Question

Finance

Quantitative Problem: Sunshine SmoothiesCompany (SSC) manufactures and distributes smoothies. SSC isconsidering the development of a new line of high-protein energysmoothies. SSC's CFO has collected the following informationregarding the proposed project, which is expected to last 3years:

  • 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 milliontoday (t = 0) to purchase additional equipment. For tax purposesthe equipment will be depreciated on a straight-line basis over 5years. Thus, the firm's annual depreciation expense is $3,800,000/5= $760,000. The company plans to use the equipment for all 3 yearsof the project. At t = 3 (which is the project's last year ofoperation), the equipment is expected to be sold for $1,450,000before taxes.
  • The project will require an increase in net operating workingcapital of $730,000 at t = 0. The cost of the working capital willbe fully recovered at t = 3 (which is the project's last year ofoperation).
  • Expected high-protein energy smoothie sales are as follows:
    YearSales
    1$2,600,000
    27,400,000
    33,800,000
  • The project's annual operating costs (excluding depreciation)are expected to be 60% of sales.
  • The company's tax rate is 40%.
  • The company is extremely profitable; so if any losses areincurred from the high-protein energy smoothie project they can beused to partially offset taxes paid on the company's otherprojects. (That is, assume that if there are any tax creditsrelated to this project they can be used in the year theyoccur.)
  • The project has a WACC = 10.0%.

What is the project's expected NPV and IRR? Round your answersto 2 decimal places. Do not round your intermediatecalculations.

NPV$
IRR%

Answer & Explanation Solved by verified expert
3.8 Ratings (522 Votes)

Time line 0 1 2 3
Cost of new machine -3800000
Initial working capital -730000
=Initial Investment outlay -4530000
100.00%
Sales 2600000 7400000 3800000
Profits Sales-variable cost 1040000 2960000 1520000
-Depreciation Cost of equipment/no. of years -760000 -760000 -760000 1520000
=Pretax cash flows 280000 2200000 760000
-taxes =(Pretax cash flows)*(1-tax) 168000 1320000 456000
+Depreciation 760000 760000 760000
=after tax operating cash flow 928000 2080000 1216000
reversal of working capital 730000
+Proceeds from sale of equipment after tax =selling price* ( 1 -tax rate) 870000
+Tax shield on salvage book value =Salvage value * tax rate 608000
=Terminal year after tax cash flows 2208000
Total Cash flow for the period -4530000 928000 2080000 3424000
Discount factor= (1+discount rate)^corresponding period 1 1.1 1.21 1.331
Discounted CF= Cashflow/discount factor -4530000 843636.4 1719008 2572501.9
NPV= Sum of discounted CF= 605146.51
Total Cash flow for the period -4530000 928000 2080000 3424000
Discount factor= (1+discount rate)^corresponding period 1 1.161042 1.348018 1.5651055
Discounted CF= Cashflow/discount factor -4530000 799282.1 1543006 2187712
NPV= Sum of discounted CF= 0.000509266
IRR is discount rate at which NPV = 0 = 16.10%

Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Transcribed Image Text

Quantitative Problem: Sunshine SmoothiesCompany (SSC) manufactures and distributes smoothies. SSC isconsidering the development of a new line of high-protein energysmoothies. SSC's CFO has collected the following informationregarding the proposed project, which is expected to last 3years: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 milliontoday (t = 0) to purchase additional equipment. For tax purposesthe equipment will be depreciated on a straight-line basis over 5years. Thus, the firm's annual depreciation expense is $3,800,000/5= $760,000. The company plans to use the equipment for all 3 yearsof the project. At t = 3 (which is the project's last year ofoperation), the equipment is expected to be sold for $1,450,000before taxes.The project will require an increase in net operating workingcapital of $730,000 at t = 0. The cost of the working capital willbe fully recovered at t = 3 (which is the project's last year ofoperation).Expected high-protein energy smoothie sales are as follows:YearSales1$2,600,00027,400,00033,800,000The project's annual operating costs (excluding depreciation)are expected to be 60% of sales.The company's tax rate is 40%.The company is extremely profitable; so if any losses areincurred from the high-protein energy smoothie project they can beused to partially offset taxes paid on the company's otherprojects. (That is, assume that if there are any tax creditsrelated to this project they can be used in the year theyoccur.)The project has a WACC = 10.0%.What is the project's expected NPV and IRR? Round your answersto 2 decimal places. Do not round your intermediatecalculations.NPV$IRR%

Other questions asked by students