: Exercise 24-22A (Algo) Using Excel to compute IRR LO P4 Following is information on two alternative investments. Beachside Resort is considering building a new pool or spa. The company requires a 10% return from its investments. Pool Spa Initial investment $ (173,000) $ (118,000) Net cash flows in Year 1 41,300 33,300 Ces Year 2 57,300 51,300 Year 3 81,595 67,300 Year 4 91,700 73,300 Year 5 66,300 25,300 Compute the internal rate of return for each of the projects using excel functions. (Round your answers to 2 decimal places.) IRR Pool Spa %