Present value of an annuity On January 1, you win $37,500,000 in the state lottery. The $37,500,000 prize will be paid in equal installments of $6,250,000 over six years. The payments will be made on December 31 of each year, beginning on December 31 of this year. The current Interest rate is 5%. This information has been collected in the Microsoft Excel Online file. Open the spreadsheet, perform the required analysis, and input your answers in the question below. X Open spreadshest Determine the present value of your winnings. Round your answer to the nearest dollar. Present value of an annuity DATA Sum of prize $37,500,000 Annual payment $6,250,000 Number of years 6 Interest rate 5.0% Date of win January 1 Date of payments December 31 of each year 0 Using formulas and cell references, perform the required analysis, and input your answer into the Amount column. Transfer the numeric result for the green entry cell 1 (B14) into the appropriate field in CNOWv2 for grading.. 12 13 14 PV of annual payments 15 16 Amount Formula