In: Accounting
Matheson Electronics has just developed a new electronic device that it believes will have broad market appeal. The company has performed marketing and cost studies that revealed the following information:
| Year | Sales in Units |
| 1 | 15,000 |
| 2 | 20,000 |
| 3 | 22,000 |
| 4–6 | 24,000 |
| Year | Amount of Yearly Advertising |
||
| 1–2 | $ | 218,000 | |
| 3 | $ | 70,000 | |
| 4–6 | $ | 60,000 | |
Click here to view Exhibit 13B-1 and Exhibit 13B-2, to determine the appropriate discount factor(s) using tables.
Required:
1. Compute the net cash inflow (incremental contribution margin minus incremental fixed expenses) anticipated from sale of the device for each year over the next six years.
2-a. Using the data computed in (1) above and other data provided in the problem, determine the net present value of the proposed investment.
2-b. Would you recommend that Matheson accept the device as a new product?
| 1 | Statement of net cash inflow each year | |||||||
| year 1 ($) | year 2 ($) | year 3 ($) | year 4-6 ($) | |||||
| Sales in unit | 15000 | 20000 | 22000 | 24000 | ||||
| Sales in dollars (A) | 900000 | 1200000 | 1320000 | 1440000 | ||||
| Variable expense (B) | 675000 | 900000 | 990000 | 1080000 | ||||
| Contribution margin (A-B)=C | 225000 | 300000 | 330000 | 360000 | ||||
| Fixed Expense | ||||||||
| salaries and others (D) | 77000 | 77000 | 77000 | 77000 | ||||
| Advertising € | 218000 | 218000 | 70000 | 60000 | ||||
| Total fixed expense (D+E)=F | 295000 | 295000 | 147000 | 137000 | ||||
| Net cash Inflow (C-F) | -70000 | 5000 | 183000 | 223000 | ||||
| Note: | ||||||||
| salaries and others (A) | 155000 | 155000 | 155000 | 155000 | ||||
| Depreciation (B) (480000-12000)/6 | 78000 | 78000 | 78000 | 78000 | ||||
| (A-B) | 77000 | 77000 | 77000 | 77000 | ||||
| 2 (a) | Statement of net present value | |||||||
| year 0 ($) | year 1 ($) | year 2 ($) | year 3 ($) | year 4 ($) | year 5 ($) | Year 6 ($) | ||
| Cost of equipment | -480000 | |||||||
| Working capital | -61000 | |||||||
| Yearly net cash flows | -70000 | 5000 | 183000 | 223000 | 223000 | 223000 | ||
| Release working capital | 61000 | |||||||
| salvage value | 12000 | |||||||
| Total cash flows | -541000 | -70000 | 5000 | 183000 | 223000 | 223000 | 296000 | |
| Discount factor | 1 | 0.8696 | 0.7561 | 0.6575 | 0.5718 | 0.4972 | 0.4323 | |
| Present value | -541000 | -60869.57 | 3780.72 | 120325.47 | 127500.97 | 110870.41 | 127968.97 | |
| Net present value | -111423.0 | |||||||
| 2(b) | No, because NPV of the device is negative | |||||||