On January $1,$ you win $$40,250,000$ in the state lottery. The $$40,250,000$ prize will be paid in equal installments of $$5,750,000$ over seven years. The payments will be made on December $31$ of each year, beginning on December $31$ of this year. The current interest rate is $6\mathrm{.}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.Open spreadsheet