Please use Excel so answers are easy to follow.

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 Required: 1. Compute each project's annual expected net cash flows. Project Y Project 2