The table below provides cash flows for two mutually exclusive alternatives for developing a Pay for Recreation facility being considered by a county government in Georgia. If money can be borrowed issuing bonds at the rate of 7% per year, using the RoR analysis, find the attractive alternative between the two given proposals.

Please use excel and show functoins. Thank you.

Alt. B -10M -37M YearAlt. A 1-10 1M 111.5M 11-00 2.5M Answer: Choose the higher cost alternative, Alt B