In addition, a well-formatted memo (1-2 pages) to management is required to support your experience with the case study. I need assistance writing the memo
In addition, a well-formatted memo (1-2 pages) to management is required to support your experience with the case study.
I need assistance writing the memo to management regarding whether they should go with the new product and why, thank you!
In addition, a well-formatted memo (1-2 pages) to management is required to support your experience with the case study.
CASE 14-32 Net Present Value Analysis of a New Product L014-2 Matheson Electronics has just developed a new electronic device it believes will have broad market appeal. The company has performed marketing and cost studies that revealed the following information: a. New equipment would have to be acquired to produce the device. The equipment would cost $315,000 and have a six-year useful life. After six years, it would have a salvage value of about $15,000. b. Sales in units over the next six years are projected to be as follows: Year Sales in Units 1 9,000 2. 15,000 3 18,000 4-6 22,000 c. Production and sales of the device would require working capital of $60,000 to finance accounts receivable, inventories, and day-to-day cash needs. This working Page 681 capital would be released at the end of the project's life. d. The devices would sell for $35 each; variable costs for production, administration, and sales would be $15 per unit. c. Fixed costs for salaries, maintenance, property taxes, insurance, and straight-line depreciation on the equipment would total $135,000 per year. (Depreciation is based on cost less salvage value.) f. To gain rapid entry into the market, the company would have to advertise heavily. The advertising costs would be: Amount of Yearly Advertising Year 1-2 $180,000 3 $150,000 4-6 $120,000 g. The company's required rate of return is 14%. 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. Using the data computed in (1) above and other data provided in the problem, determine the net present value of the proposed investment. Would you recommend that Matheson accept the device as a new product? 1 Question 1: 2 3 4 Year 5 Sales units 6 Selling price per unit 7 Variable expenses per unit 8 Contriubtion margin per unit 9 Total contribution margin 10 Advertising expense 11 Other Fixed expense 12 Depreciation Expense 13 Other Fixed cost less depreciation 14 Total cash fixed costs 15 Net cash inflow $ $ $ $ $ $ $ $ $ $ Matheson Electronics Computation of Net Cash Inflow 1 2 3 4 5 6 9,000 $ 15,000 $ 18,000 $ 22,000 $ 22,000 $ 22,000 35 $ 35 $ 35 $ 35 $ 35 $ 35 15 $ 15 $ 15 $ 15 $ 15 $ 15 20 $ 20 $ 20 $ 20 $ 20 $ 20 180,000 $ 300,000 $ 360,000 $ 440,000 $ 440,000 $ 440,000 180,000 $ 180,000 $ 150,000 $ 120,000 $ 120,000 $ 120,000 135,000 $ 135,000 $ 135,000 $ 135,000 $ 135,000 $ 135,000 50,000 $ 50,000 $ 50,000 $ 50,000 $50,000 $ 50,000 85,000 $ 85,000 $ 85,000 $ 85,000 $ 85,000 $ 85,000 265,000 $ 265,000 $ 235,000 $ 205,000 $ 205,000 $ 205,000 (85,000) $ 35,000 $ 125,000 $ 235,000 $ 235,000 $ 235,000 16 17 18 Question 2: 19 Year 0 20 21 22 23 24 25 26 27 1 2 3 4 5 Matheson Electronics Computation of Net Present Value Net Cashflow PVIF $ (375,000) 1.0000 $ (85,000) 0.8772 $ 35,000 0.7695 125,000 0.6750 235,000 0.5921 $ 235,000 0.5194 $ 310,000 0.4556 PV of Cashflow $ (375,000.00) $ (74,561.40) $ 26,931.36 $ 84,371.44 $ 139,138.87 $ 122,051.64 $ 141,231.83 $ 64,163.73 28 6 29 Net cash inflow CASE 14-32 Net Present Value Analysis of a New Product L014-2 Matheson Electronics has just developed a new electronic device it believes will have broad market appeal. The company has performed marketing and cost studies that revealed the following information: a. New equipment would have to be acquired to produce the device. The equipment would cost $315,000 and have a six-year useful life. After six years, it would have a salvage value of about $15,000. b. Sales in units over the next six years are projected to be as follows: Year Sales in Units 1 9,000 2. 15,000 3 18,000 4-6 22,000 c. Production and sales of the device would require working capital of $60,000 to finance accounts receivable, inventories, and day-to-day cash needs. This working Page 681 capital would be released at the end of the project's life. d. The devices would sell for $35 each; variable costs for production, administration, and sales would be $15 per unit. c. Fixed costs for salaries, maintenance, property taxes, insurance, and straight-line depreciation on the equipment would total $135,000 per year. (Depreciation is based on cost less salvage value.) f. To gain rapid entry into the market, the company would have to advertise heavily. The advertising costs would be: Amount of Yearly Advertising Year 1-2 $180,000 3 $150,000 4-6 $120,000 g. The company's required rate of return is 14%. 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. Using the data computed in (1) above and other data provided in the problem, determine the net present value of the proposed investment. Would you recommend that Matheson accept the device as a new product? 1 Question 1: 2 3 4 Year 5 Sales units 6 Selling price per unit 7 Variable expenses per unit 8 Contriubtion margin per unit 9 Total contribution margin 10 Advertising expense 11 Other Fixed expense 12 Depreciation Expense 13 Other Fixed cost less depreciation 14 Total cash fixed costs 15 Net cash inflow $ $ $ $ $ $ $ $ $ $ Matheson Electronics Computation of Net Cash Inflow 1 2 3 4 5 6 9,000 $ 15,000 $ 18,000 $ 22,000 $ 22,000 $ 22,000 35 $ 35 $ 35 $ 35 $ 35 $ 35 15 $ 15 $ 15 $ 15 $ 15 $ 15 20 $ 20 $ 20 $ 20 $ 20 $ 20 180,000 $ 300,000 $ 360,000 $ 440,000 $ 440,000 $ 440,000 180,000 $ 180,000 $ 150,000 $ 120,000 $ 120,000 $ 120,000 135,000 $ 135,000 $ 135,000 $ 135,000 $ 135,000 $ 135,000 50,000 $ 50,000 $ 50,000 $ 50,000 $50,000 $ 50,000 85,000 $ 85,000 $ 85,000 $ 85,000 $ 85,000 $ 85,000 265,000 $ 265,000 $ 235,000 $ 205,000 $ 205,000 $ 205,000 (85,000) $ 35,000 $ 125,000 $ 235,000 $ 235,000 $ 235,000 16 17 18 Question 2: 19 Year 0 20 21 22 23 24 25 26 27 1 2 3 4 5 Matheson Electronics Computation of Net Present Value Net Cashflow PVIF $ (375,000) 1.0000 $ (85,000) 0.8772 $ 35,000 0.7695 125,000 0.6750 235,000 0.5921 $ 235,000 0.5194 $ 310,000 0.4556 PV of Cashflow $ (375,000.00) $ (74,561.40) $ 26,931.36 $ 84,371.44 $ 139,138.87 $ 122,051.64 $ 141,231.83 $ 64,163.73 28 6 29 Net cash inflow
