In: Accounting
Case 13-32 Net Present Value Analysis of a New Product [LO13-2]
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 | $ | 128,000 | |
3 | $ | 67,000 | |
4–6 | $ | 57,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?
Solution 1:
Annual depreciation = (Cost - Salvage value) / Useful life = ($258,000 - $24,000) / 6 = $39,000 |
Computation of net cash inflow from sale of device | ||||
Particulars | Year 1 | Year 2 | Year 3 | Year 4-6 |
Sales in units | 15000 | 20000 | 22000 | 24000 |
Sales in dollar | $675,000.00 | $900,000.00 | $990,000.00 | $1,080,000.00 |
Variable expenses | $450,000.00 | $600,000.00 | $660,000.00 | $720,000.00 |
Contribution margin | $225,000.00 | $300,000.00 | $330,000.00 | $360,000.00 |
Fixed Expenses: | ||||
Salaries and other (Excluding depreciation) | $113,000.00 | $113,000.00 | $113,000.00 | $113,000.00 |
Advertising | $128,000.00 | $128,000.00 | $67,000.00 | $57,000.00 |
Total fixed expenses | $241,000.00 | $241,000.00 | $180,000.00 | $170,000.00 |
Net cash inflow (Outflow) | -$16,000.00 | $59,000.00 | $150,000.00 | $190,000.00 |
Solution 2a: | |||||||
Computation of Net Present Value - Matheson Electronics | |||||||
Particulars | Now | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | Year 6 |
Cost of equipment | -$258,000 | ||||||
Working capital | -$58,000 | ||||||
Yearly net cash flows | -$16,000 | $59,000 | $150,000 | $190,000 | $190,000 | $190,000 | |
Release of working capital | $58,000 | ||||||
Salavage value of equipment | $24,000 | ||||||
Total cash flows | -$316,000 | -$16,000 | $59,000 | $150,000 | $190,000 | $190,000 | $272,000 |
PV Factor | 1.000 | 0.862 | 0.742 | 0.641 | 0.552 | 0.476 | 0.410 |
Present Value | -$316,000 | -$13,792 | $43,778 | $96,150 | $104,880 | $90,440 | $111,520 |
Net present value | $116,976 |
Solution 2b: As NPV is positive, therefore Matheson should accept the device as a new product. |