THE FOLLOWING QUESTION REQUIRES TO USE EXEL

AutoSave OFF OFF A SU BUS37352021FINAL-makeup-richards-2 - Compatibility Mode - Saved to my Mac Home Insert Draw Design Layout References Mailings Review View Tell me Share Comments y n Psstc X [G Palatino Lin... 10 A A Aa B ! | x 4 x x A A ver 21 === Aalde Aa BbCcDc AabhccDdE AaBbCcDc AaBaDee Nammal Headina Heading 2 Title Subtit DA Emas Dictate Sensitivity Sty es Pere Office Update To keep up-to-date with security updates, fixes, and improvements, choose Check for Updates. Check for Updates Q 23) Gavin and Alex, baseball consultants, are in need of a microcomputer network for their staff. They have received three proposals, with related facts as follows: Proposal A $90,000 Proposal B $90,000 Proposal $90,000 90,000 Initial investment in equipment Annual cash increase in operations: Year 1 Year 2 Year 3 Salvage value Estimated life 0 80,000 10,000 45,000 0 3 yrs 45,000 45,000 45,000 0 3 yrs 0 0 1 yr The company uses straight-line depreciation for all capital assets. Required: a. Compute the payback period, net present value, and accrual accounting rate of return with initial investment, for each proposal. Use a required rate of return of 14%. b. Rank cach proposal 1, 2, and 3 using cach method separately. Which proposal is best? 7 Pagn 7 of 9 126 of 1598 words E English (United States) Focus + 194%