Question

Better Mousetraps has developed a new trap. It can go into production for an initial investment in equipment of $6.3 million. The equipment will be depreciated straight line over 6 years to a value of zero, but in fact it can be sold after 6 years for $530,000. The firm believes that working capital at each date must be maintained at a level of 15% of next year’s forecast sales. The firm estimates production costs equal to $1.90 per trap and believes that the traps can be sold for $7 each. Sales forecasts are given in the following table. The project will come to an end in 6 years., when the trap becomes technologically obsolete. The firm’s tax bracket is 35%, and the required rate of return on the project is 9%. Use the MACRS depreciation schedule.

Year: 0 1 2 3 4 5 6 Thereafter Sales (millions of traps) 0 .4 .5 .6 .6 .8 .4 0

a. What is project NPV? (Do not round intermediate calculations. Enter your answer in millions rounded to 4 decimal places.) NPV $ million

b. By how much would NPV increase if the firm depreciated its investment using the 5-year MACRS schedule? (Do not round intermediate calculations. Enter your answer in whole dollars not in millions.) The NPV increases by $ .

Better Mousetraps has developed a new trap. It can go into production for an initial investment in equipment of $5.4 million. The equipment will be depreciated straight line over 6 years to a value of zero, but in fact it can be sold after 6 years for $527,000. The firm believes that working capital at each date must be maintained at a level of 10% of next year’s forecast sales. The firm estimates production costs equal to $1.10 per trap and believes that the traps can be sold for $5 each. Sales forecasts are given in the following table. The project will come to an end in 6 years., when the trap becomes technologically obsolete. The firm’s tax bracket is 35%, and the required rate of return on the project is 9%.

                                               Year: 0 1 2 3 4 5 6   Thereafter

Thereafter Sales (millions of traps) 0 .5 .7 .9 .9 .6 .4   0

Suppose the firm can cut its requirements for working capital in half by using better inventory control systems. By how much will this increase project NPV? (enter your answer in millions rounded to 4 decimal places.

Change in NPV

Answer 1

1)

- ( 7-1.9) / 1000000 D3 A C D E F G H J K L M Depreci Operating Net working cash flows Contributio Deprecia al Year Sale units Total cash flows PVIF@9% | Present value Таx@35% capital n per unit tion РВT PAT ation Investment 1 (6.30) S 1.000 S 2 -6.72 (6.7200) -0.42 $ 1.05 $(1.05) (0.37) $(0.68) 1.05 $ $ 1.05 $(1.05) $(0.37) $(0.68) $1.05 $ 0.0 1.05 $(1.05) (0.37) $(0.68) 1.05 $ 1.05 $(1.05)$ (0.37) $(0.68) $ 1.05 $ (0.37) $(0.68) $ 1.05 $ 0.0 S 1.05 $(1.05) (0.37)(0.68) $ 1.05$ 0.37 $ 0.37 $ 0.917 $ 0.842 $ 3 1 0.4 0.0 0.26 0.2408 -0.11 4 S 2 0.5 0.0 0.11 0.26 0.2209 0.37 $ 0.772 S 5 S S 0.6 0.37 0.2838 6 0.0 S 0.37 $ 0.37 $ 0.708 0.650 $ 0.596 $ S 4 0.6 -0.21 0.16 0.1116 0.0 $ 1.05 $(1.05) 7 S S 0.8 0.42 0.79 0.5118 0.42 S 8 6 S $ 0.4 0.37 0.34 1.13 0.6750 - 0.53 ( 1-35 % ) 9 $ (4.6761) Net present value 10 Depreci Operating Net working cash flows Contributio Deprecia Tax@35% Total cash flows PVIF@9% Present value capital 12 bYear Sale units n per unit tion PBT PAT ation Investment 1.000 $ 0.917 $ 0.842 $ (6.30) $ 13 -6.72 (6.7200) 0 -0.42 1.26 $(1.26)$ (0.44) $(0.82) 1.26 $ $(2.02) $(0.71) $(1.31) $ 2.02 $ $(1.21) S (0.42) $(0.79) $1.21 $ (0.25) (0.47) 0.73 $ 0.73 $(0.73)(0.25) $(0.47) $0.73 $ 0.36 $(0.36) (0.13) $(0.24) 0.36 $ 0.44 S 14 S 0.0 S S 1 0.4 -0.11 0.34 0.3083 0.0 2.02 0.71 $ 0.42 $ 15 S 0.5 -0.11 0.60 0.5055 0.772 $ 0.708 $ 16 0.0 $ S 0.6 1.21 0.42 0.3269 0.0 0.73 $(0.73) 17 0.25 S S S 0.6 -0.21 0.04 0.0312 0.8 S 0.25 S 0.650 S 0.596 $ 18 5 0.0 0.42 0.67 0.4381 0.34 $ 19 S 0.13 0.89 0.5316 6 0.4 0.0 0.42 = 0.53* (1-35%) 20 (4.5785) 21 Net present value -$4.6761 23 a) NPV $ 24 b) The NPV increases by 97,588