Please use Excel to shower answers so it's easy to follow. Thanks!

Required information (The following information applies to the questions displayed below.) Most Company has an opportunity to invest in one of two new projects. Project Y requires a $310,000 investment for new machinery with a four-year life and no salvage value. Project Z requires a $310,000 investment for new machinery with a three-year life and no salvage value. The two projects yield the following predicted annual results. The company uses straight-line depreciation, and cash flows occur evenly throughout each year. (PV of $1, FV of $1, PVA of $1, and FVA of $1) (Use appropriate factor(s) from the tables provided.) Project Y Project z $395,000 $316,000 55,300 79,000 39,500 47,400 142,200 142,200 Sales Expenses Direct materials Direct labor Overhead including depreciation Selling and administrative expenses Total expenses Pretax income Income taxes (34%) Net income 28,000 28,000 304,500 90,500 30,770 $ 59,730 257,100 58,900 20,026 $ 38,874 2. Determine each project's payback period. Choose Numerator: Payback Period / Choose Denominator: / = Payback Period Payback period 0 Project Y Project Z 0 2. Determine each project's payback period. = Choose Numerator: Annual net cash flow 11 Project Y Project 2 Payback Period Choose Denominator: Payback Period Payback period 0 Annual net cash flow 0 Average accounts receivable, net Average total assets Cost of goods sold Cost of investment Current accote 2. Determine each project's payback period. Payback Period / Choose Denominator: II Choose Numerator: Annual net cash flow II Payback Period Payback period 0 0 Project Y Project Z Current assets Current liabilities Income before interest and inc tax Net income Net sales