Please show work in excel i.e. the formulas

The below excel doc are the actual questions and the excel doc where the information is entered. thanks.

Read the following to answer the questions in excel

https://www.espn.com/mlb/story/_/id/16650867/why-mets-pay-bobby-bonilla-119-million-today-every-july-1-2035

A. Use July 1, 2011, to calculate the future value of the $5.9 million owed on July 1, 2000.

B. Use July 1, 2011, to calculate the present value of the 25 yearly payments of $1, 193,248. 20

C If you were his investment advisor, what would you have advised him when the Mets made the offer?