Please use Excel so answers are 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 3. Compute each project's accounting rate of return. Accounting Rate of Return Choose Numerator: / Choose Denominator: Accounting Rate of Return 1 Accounting rate of return Project Y Project 2 Accounts receivable Annual after-tax net income Annual average investment Annual pre-tax income Average total assets 3. Compute each project's accounting rate of return. Accounting Rate of Return 1 Choose Denominator: 1 Choose Numerator: Accounts receivable = Accounting Rate of Return Accounting rate of return 11 Project Y Project Z Cost of goods sold Current assets Current liabilities Net sales Total assets 3. Compute each project's accounting rate of return. Accounting Rate of Return Choose Numerator: Choose Denominator: Accounting Rate of Return Accounting rate of return Accounts receivable 1 Current assets = Project Y Project 2