i need to creat a spreadsheet answering questions 1-5

Problem 24-1A Computation of payback period, accounting rate of return, and net present value P1 P2 P3 @ Factor Company is planning to add a new product to its line. To manufacture this product, the company needs to buy a new machine at a 5480,000 cost with an expected four-year life and a $20,000 salvage value. All sales are for cash, and all costs are out of-pocket, except for depreciation on the new machine. Additional information includes the following 51.840.000 Expected annual sales of new product Expected annual costs of new product Direct materials Direct labor Overhead (excluding straight-line depreciation on new machine) Selling and administrative expenses Income taxes 480.00 672.000 336,000 160,000 305 Required Required 1. Compute straight-line depreciation for each year of this new machine's life. (Round depreciation amounts to the nearest dostlar) 2. Determine expected net income and net cash flow for each year of this machine's life (Round answers to the nearest dollar) 3. Compute this machine's payback period, assuming that cash flows occur evenly throughout each year (Round the payback period to two decimals.) 4. Compute this machine's accounting rate of return, assuming that income is carned evenly throughout each year. (Round the percentage return to two decimals) Check (42156 5. Compute the net present value for this machine using a discount rate of 78 and assuming that cash flows occur at each year end. (Mint Salvage value is a cash inflow at the end of the asset's life. Round the net present value to the nearest dollar) (50 107,856