Pls help. Theres two questions

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 9% return from its investments. Pool Spa Initial investment Net cash flows in: $ (161,000) $ (106,000) Year 1 40,100 32,100 Year 2 56,100 50,100 Year 3 4 80,395 66,100 Year 4 90,500 72,100 Year 5 65,100 24,100 Compute the internal rate of return for each of the projects using excel functions. (Round your answers to 2 decimal places.) IRR Pool % Spa Problem 24-6A (Algo) Net present value of alternate investments LO P3 Interstate Manufacturing is considering either overhauling an old machine or replacing it with a new machine. Information about the two alternatives follows. Management requires a 8% rate of return on its investments. (PV of $1. FV of $1. PVA of $1, and FVA of $1) (Use appropriate factor(s) from the tables provided.) Alternative 1: Keep the old machine and have it overhauled. This requires an initial investment of $156,000 and results in $44,000 of net cash flows in each of the next five years. After five years, it can be sold for a $16,000 salvage value. Alternative 2: Sell the old machine for $40,000 and buy a new one. The new machine requires an initial investment of $292,000 and can be sold for a $14,000 salvage value in five years. It would yield cost savings and higher sales, resulting in net cash flows of $47,000 in each of the next five years. Required: 1. Determine the net present value of alternative 1. 2. Determine the net present value of alternative 2. 3. Which alternative should management select based on net present value? Complete this question by entering your answers in the tabs below. Required 1 Required 2 Required 3 the net present value of alternative 2. 3. Which alternative should management select based on net present value? Complete this question by entering your answers in the tabs below. Required 1 Required 2 Required 3 Determine the net present value of alternative 1. (Do not round intermediate calculations. Round your present value factor to 4 decimals and final answers to the nearest whole dollar.) Net Cash Flows Present Value Factors at 8% Present Value of Cash Flows Year 1-5 Salvage value (year 5) Totals Initial investment Net present value Check my present value? Complete this question by entering your answers in the tabs below. Required 1 Required 2 Required 3 Determine the net present value of alternative 2. (Negative net present values should be indicated with a minus sign. Do not round Intermediate calculations. Round your present value factor to 4 decimals and final answers to the nearest whole dollar) Net Cash Flows Present Value Factors at 8% Present Value of Cash Flows Year 1-5 Salvage value-new machine Salvage value-old machine 1.0000 Totals Initial investment Net present value 7 of 13 Next > sed k t nces 2. Determine the net present value of alternative 2. 3. Which alternative should management select based on net present value? Complete this question by entering your answers in the tabs below. Required 1 Required 2 Lequired 3 Which alternative should management select based on net present value? Management should select 7 of 13 # Next >