I need help for answer 2, all answers in the #1 are good.

Clarion Company is considering an opportunity to produce and sell a revolutionary new smoke detector for homes. To determine whether this would be a profitable venture, the company has gathered the following data on probable costs and market potential: a. New equipment would have to be acquired to produce the smoke detector. The equipment would cost $310,000 and be usable for 15 years. After 15 years, it would have a salvage value equal to 10% of the original cost. b. Production and sales of the smoke detector would require a working capital investment of $61,000 to finance accounts receivable, inventories, and day-to-day cash needs. This working capital would be released for use elsewhere after 15 years. c. An extensive marketing study projects sales in units over the next 15 years as follows: Year(s) Sales in Units 11,000 14,000 19,000 20,000 N 415 d. The smoke detectors would sell for $55 each; variable costs for production, administration, and sales would be $40 per unit. e 1 the market, the company would dortico CONTPally would neve lo advertisen LIE ofca ears O Sales, me davertising program les The adv follows: Amount of Year(s) Advertising 12 $90,000 70,000 415 60,000 3 f. Other fixed costs for salaries, insurance, maintenance, and straight-line depreciation on equipment would total $215,000 per year. (Depreciation is based on cost less salvage value.) g. The company's required rate of return is 11%. (Ignore income taxes.) Required: 1. Compute the net cash inflow (cash receipts less yearly cash operating expenses) anticipated from sale of the smoke detectors for each year over the next 15 years. (Enter any cash outflows with a minus sign. Round your intermediate and final answers to the nearest dollar amount.) The net cash inflow from sales of the device for each year would be: Year 2 14,000 $ 770,000 560,000 210,000 Year 3 19,000 $1,045,000 760,000 285,000 Year 4-15 20,000 $1,100,000 800,000 300,000 Year 1 Sales in units 11,000 Sales in dollars $ 605,000 Less variable expenses 440,000 Contribution margin 165,000 Less fixed expenses: Advertising 90,000/ Other fixed expenses 196,400 Total fixed expenses 286,400 Net cash inflow (outflow)| $(121,400) 90,000 196,400 286,400 $ (76,400)| $ 70,000 196,400 266,400 18,600 60,000 196,400 256,400 43,600 $ 2-a. Using the data computed in requirement (1) above and other data provided in the problem, determine the net present value of the proposed investment. (Hint: Use Microsoft Excel to calculate the discount factor(s).) (Negative amount should be indicated by a minus sign. Do not round intermediate calculations and round your final answer to nearest whole dollar amount.) Net present value