I have tried to complete the following question for practice questions but am unable to figure it out

Tam Inc is oonsidering an opportunity to produce and sell a revolutionary new smoke detector for homes. To determine whether this would be a protable 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 $160,000 and be usable for 5 years. Aer 5 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 $46,000 to nance accounts receivable. inventories. and day-to-day cash needs. This working capital would be released for use elsewhere after 5 years. c. An extensive marketing study projects sales in units over the next 5 years as follows: Soles in Iaaztu) hitn 1 4,500 2 7,500 3 10,500 45 12,500 d. The smoke detectors would sell for $55 each; variable costs for production, administration. and sales would be $35 per unit. e. To gain entry into the market. the company would have to advertise heavily in the early years of sales. The advertising program follows: amount of rents} advertising 1-; $75,000 3 55,000 45 45,000 f- [Depreciation is based on cost less salvage value.] 9. The company's required rate of return is 1096. {Ignore income taxes.) Required: 1. Compute the net cash inow [cash receipts less yearly cash operating expenses] anticipated from sale ofthe smoke detectors for each year over the next 5 years. {Enter any cash outflows with a minus sign. Round your Intermediate and nal answers to the nearest dollar amount.) The net cash inow from sales of the device for each year would be: (4 marks) Year 1 Year 2 Year 3 Year 4-5 Sales in units 4,500 7,500 10,500 12,500 Sales in dollars Less variable expenses Contribution margin 0 0 0 0 Less fixed expenses: Advertising Other fixed expenses Total fixed expenses 0 0 0 0 Net cash inflow (outflow) 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. (Negative amount should be indicated by a minus sign. Do not round intermediate calculations and round your final answer to nearest whole dollar amount.) Show your calculations to determine the NPV in the mandatory Excel spreadsheet, which is called "Final Exam Tam Inc Question mandatory template" and upload the Excel spreadsheet into the Final Exam Upload Folder (6 marks). Entering the NPV without showing your work is worth zero. Net present value