looking for help with question 1 on the picture, filling in the table. All important info is provided on the pictures as well!

1. Look at your answer to requirement 2-b on connect: DO THIS ONLY IF YOU ANSWERED NO on connect. If you answered yes, skip this. If your answer to 2-b on CONNECT was "no", complete this requirement, it means your NPV was negative and Matheson should not accept the device as a new product. Let's assume a new marketing study was performed and indicates if Matheson increases advertising costs by 20% in the years 1 and 2 only, the sales will double their original projections for year 1, 75% higher than the projections for the second year and 50% higher than projections for year three. (Remember that increasing sales will also increase COGS). Projections for sales in years 4 through 6, as well as the cost assumptions would remain unchanged. What would the new Net Present Value be with these adjustments to advertising expense and sales? Should Matheson Electronics accept the device now? Show your work by include the Cash Flows for the appropriate years and the discount factors used in the table below Y2 Y3 Y4 Y5 Y6 Use these table for (a) or (b) (10 points): Now Y1 Cost of equipment -114,000 Working capital -51,000 Yearly net cash flow Release of working capital Salvage value of equipment Total cash flows (a) Discount Factor (b) Present Value (a)x(b) Net Present Value 1 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: led a. New equipment would have to be acquired to produce the device. The equipment would cost $114,000 and have a six-year useful life. After six years, it would have a salvage value of about $6,000. b. Sales in units over the next six years are projected to be as follows: Year 1 Sales in Units 8,000 13,000 15,000 17,000 2 3 4-6 ht ences c. Production and sales of the device would require working capital of $51,000 to finance accounts receivable, inventories, and day-to-day cash needs. This working capital would be released at the end of the project's life. d. The devices would sell for $45 each; variable costs for production, administration, and sales would be $30 per unit e. Fixed costs for salaries, maintenance, property taxes, insurance, and straight-line depreciation on the equipment would total $177,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: ac Taw Year 1-2 Amount of Yearly Advertising $32,000 $60,000 $50,000 3 4-6 g. The company's required rate of return is 6%. Click here to view Exhibit 12B-1 and Exhibit 12B-2, to determine the appropriate discount factor(s) using tables. Note: Use the File button on the left of the window and download the fild HW6.1011 Tables. Use these tables to assist in your calculations of requirements 1 and 2a. 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? Complete this question by entering your answers in the tabs below. Compute the net cash Intl (incremental contr on margin minus incremental fixed exper inticipated 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 th present value of the proposed investment. 2-b. Would you recommend that Matheson accept the device as a new product? Complete this question by entering your answers in the tabs below. Reg 1 Reg 2A Reg 2B Using the data computed in (1) above and other data provided in the problem, determine the net present value of the proposed investment. (Negative amounts should be indicated by a minus sign. Round your final answer to the nearest whole dollar amount.) Net present value $ (79,944) s 2-a. Using the data computed in (1) above and other data provided in the problem, determ present value of the proposed investment. 2-b. Would you recommend that Matheson accept the device as a new product? Complete this question by entering your answers in the tabs below. Req 1 Reg 2A Reg 2B Would you recommend that Matheson accept the device as a new product? No Ores