In: Finance
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's CFO has collected the following information regarding the proposed project, which is expected to last 3 years:
Year | Sales |
1 | $2,600,000 |
2 | 7,400,000 |
3 | 3,800,000 |
What is the project's expected NPV and IRR? Round your answers to 2 decimal places. Do not round your intermediate calculations.
NPV | $ |
IRR | % |
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% |