9

pdf

School

Liberty University *

*We aren’t endorsed by this school

Course

530

Subject

Finance

Date

Feb 20, 2024

Type

pdf

Pages

3

Uploaded by ProfOkapiPerson648

Report
9. Award: 0 out of 1.00 point 0 out of 1.00 point Score: Score: 11.79/15 Points 78.60 % 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 $695,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.80 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 11%. Use the MACRS depreciation schedule . Year: 0 1 2 3 4 5 6 Thereafter Sales (millions of traps) 0 0.6 0.8 0.9 0.9 0.5 0.2 0 a. What is project NPV? Note: Negative amount should be indicated by a minus sign. Do not round intermediate calculations. Enter your answer in millions rounded to 4 decimal places. b. By how much would NPV increase if the firm depreciated its investment using the 5-year MACRS schedule? Note: Do not round intermediate calculations. Enter your answer in whole dollars not in millions. rev: 10_05_2023_QC_HETS-15608 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 $695,000. The firm believes that working capital at each date must be maintained at a level of 10% of NPV million The NPV increases by
next year’s forecast sales. The firm estimates production costs equal to $1.80 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 11%. Use the MACRS depreciation schedule . Year: 0 1 2 3 4 5 6 Thereafter Sales (millions of traps) 0 0.6 0.8 0.9 0.9 0.5 0.2 0 a. What is project NPV? Note: Negative amount should be indicated by a minus sign. Do not round intermediate calculations. Enter your answer in millions rounded to 4 decimal places. b. By how much would NPV increase if the firm depreciated its investment using the 5-year MACRS schedule? Note: Do not round intermediate calculations. Enter your answer in whole dollars not in millions. rev: 10_05_2023_QC_HETS-15608 Explanation: Some values below may show as rounded for display purposes, though unrounded numbers should be used for actual calculations. All cash flows are in millions of dollars. Sales price of machinery in year 6 is shown on an after-tax basis as a positive cash flow on the capital investment line. Year 0 1 2 3 4 5 6 Sales units 0.60 0.80 0.90 0.90 0.50 0.20 Revenue 0.00 4.20 5.60 6.30 6.30 3.50 1.40 NWC 0.42 0.56 0.63 0.63 0.35 0.14 0.00 Cash flow NWC 0.42 0.14 0.07 0.00 0.28 0.21 0.14 a. Straightline Depreciation Year 0 1 2 3 4 5 6 Revenue 4.2000 5.6000 6.3000 6.3000 3.5000 1.4000 Expenses 1.0800 1.4400 1.6200 1.6200 0.9000 0.3600 Depreciation 1.0500 1.0500 1.0500 1.0500 1.0500 1.0500 Pretax profit 2.0700 3.1100 3.6300 3.6300 1.5500 0.0100 Tax 0.7245 1.0885 1.2705 1.2705 0.5425 0.0035 Net income 1.3455 2.0215 2.3595 2.3595 1.0075 0.0065 OCF 2.3955 3.0715 3.4095 3.4095 2.0575 1.0435 Cash flow investment 6.3000 0.4518 Cash flow NWC 0.4200 0.1400 0.0700 0.0000 0.2800 0.2100 0.1400 OCF 0.0000 2.3955 3.0715 3.4095 3.4095 2.0575 1.0435 Total cash flow 6.7200 2.2555 3.0015 3.4095 3.6895 2.2675 1.6353 PV of cash flow 6.7200 2.0320 2.4361 2.4930 2.4304 1.3457 0.8743 NPV 4.8914 +/- 1% $ NPV 4.8914 million +/- 0 . 1% $ The NPV increases by 110,791
b. MACRS depreciation Year 0 1 2 3 4 5 6 Revenue 4.2000 5.6000 6.3000 6.3000 3.5000 1.4000 Expenses 1.0800 1.5000 1.6200 1.6200 0.9000 0.3600 Depreciation 1.2600 2.0160 1.2096 0.7258 0.7258 0.3629 Pretax profit 1.8600 2.1440 3.4704 3.9542 1.8742 0.6771 Tax 0.6510 0.7504 1.2146 1.3840 0.6560 0.2370 Net income 1.2090 1.3936 2.2558 2.5703 1.2183 0.4401 OCF 2.4690 3.4096 3.4654 3.2960 1.9440 0.8030 Cash flow investment 6.3000 0.4518 Cash flow NWC 0.4200 0.1400 0.0700 0.0000 0.2800 0.2100 0.1400 OCF 0.0000 2.4690 3.4096 3.4654 3.2960 1.9440 0.8030 Total cash flow 6.7200 2.3290 3.3396 3.4654 3.5760 2.1540 1.3948 PV of cash flow 6.7200 2.0982 2.7105 2.5338 2.3556 1.2783 0.7457 NPV 5.0022 Change in NPV = $110,791
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help