Question

In: Finance

Better Mousetraps has developed a new trap. It can go into production for an initial investment...

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 $682,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.30 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 8%. Year: 0 1 2 3 4 5 6 Thereafter Sales (millions of traps) 0 0.5 0.7 0.8 0.8 0.7 0.5 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= ?? million

Solutions

Expert Solution

All cash flows are in millions of dollars
Initial Investment 5.4 million
salvage value after tax          443,300
(682000 x (1-0.35))
Year 0 1 2 3 4 5 6 Thereafter
Sales units(in milions) 0 0.5 0.7 0.8 0.8 0.7 0.5 0
x sales price per unit $5 $5 $5 $5 $5 $5 $5
Sales Revenue $2.5000 $3.5000 $4.0000 $4.0000 $3.5000 $2.5000 $0.0000
Working capital -10% 0.2500 0.3500 0.4000 0.4000 0.3500 0.2500 0.0000
Change in NWC -0.2500 -0.1000 -0.0500 0.0000 0.0500 0.1000 0.2500
Production cost
Year 0 1 2 3 4 5 6 Thereafter
Sales units(in milions) 0 0.5 0.7 0.8 0.8 0.7 0.5 0
x cost per unit $1.30 $1.30 $1.30 $1.30 $1.30 $1.30 $1.30
Production cost $0.6500 $0.9100 $1.0400 $1.0400 $0.9100 $0.6500 $0.0000
Revenues $2.5000 $3.5000 $4.0000 $4.0000 $3.5000 $2.5000 $0.0000
Expense $0.6500 $0.9100 $1.0400 $1.0400 $0.9100 $0.6500 $0.0000
Depreciation 0.9000 0.9000 0.9000 0.9000 0.9000 0.9000
Pretax profit $0.9500 $1.6900 $2.0600 $2.0600 $1.6900 $0.9500
Tax at 35% 0.3325 0.5915 0.7210 0.7210 0.5915 0.3325
After-tax profit 0.6175 1.0985 1.3390 1.3390 1.0985 0.6175
Cash Flow from operations 1.5175 1.9985 2.2390 2.2390 1.9985 1.5175
Cash Flow: capital invest. -5.4 0.4433
Cash Flow from WC -0.2500 -0.1000 -0.0500 0.0000 0.0500 0.1000 0.2500
Cash Flow from operations 1.5175 1.9985 2.2390 2.2390 1.9985 1.5175
Total Cash Flow -5.6500 1.4175 1.9485 2.2390 2.2890 2.0985 2.2108
PVF at 8% 1 0.925926 0.857339 0.793832 0.73503 0.680583 0.63017
Present Value -5.65 1.3125 1.670525 1.77739 1.682483 1.428204 1.393179
NPV $        3.6143
Change in NWC requirement
Year 0 1 2 3 4 5 6 Thereafter
Sales units(in milions) 0 0.5 0.7 0.8 0.8 0.7 0.5 0
x sales price per unit $5 $5 $5 $5 $5 $5 $5
Sales Revenue $2.5000 $3.5000 $4.0000 $4.0000 $3.5000 $2.5000 $0.0000
Working capital -10% 0.1250 0.1750 0.2000 0.2000 0.1750 0.1250 0.0000
Change in NWC -0.1250 -0.0500 -0.0250 0.0000 0.0250 0.0500 0.1250
Cash Flow: capital invest. -5.4 0.4433
Cash Flow from WC -0.1250 -0.0500 -0.0250 0.0000 0.0250 0.0500 0.1250
Cash Flow from operations 1.5175 1.9985 2.2390 2.2390 1.9985 1.5175
Total Cash Flow -5.5250 1.4675 1.9735 2.2390 2.2640 2.0485 2.0858
PVF at 8% 1 0.925926 0.857339 0.793832 0.73503 0.680583 0.63017
Present Value -5.525 1.358796 1.691958 1.77739 1.664108 1.394175 1.314408
NPV $        3.6758
change in npv $0.0616 final answer
(3.6758 - 3.6143)

Related Solutions

Better Mousetraps has developed a new trap. It can go into production for an initial investment...
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 $694,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 $2.00 per trap...
Better Mousetraps has developed a new trap. It can go into production for an initial investment...
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, but, in fact, it can be sold after 6 years for $668,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.60 per trap and believes that the traps can...
Better Mousetraps has developed a new trap. It can go into production for an initial investment...
Better Mousetraps has developed a new trap. It can go into production for an initial investment in equipment of $5.7 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 $518,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.50 per trap...
Better Mousetraps has developed a new trap. It can go into production for an initial investment...
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...
Better Mousetraps has developed a new trap. It can go into production for an initial investment...
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 $584,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.30 per trap...
Better Mousetraps has developed a new trap. It can go into production for an initial investment...
Better Mousetraps has developed a new trap. It can go into production for an initial investment in equipment of $6.6 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 $643,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...
Better Mousetraps has developed a new trap. It can go into production for an initial investment...
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 $549,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.60 per...
Better Mousetraps has developed a new trap. It can go into production for an initial investment...
Better Mousetraps has developed a new trap. It can go into production for an initial investment in equipment of $6 million. The equipment will be depreciated straight-line over 6 years but in fact, it can be sold after 6 years for $500,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.50 per trap and believes that the traps can...
Better Mousetraps has developed a new trap. It can go into production for an initial investment...
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, but, in fact, it can be sold after 6 years for $606,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.70 per trap and believes that the traps can...
Better Mousetraps has developed a new trap. It can go into production for an initial investment...
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 $694,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 $2.00 per trap...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT