solve using Excel, NO handwriting please

Solve it using EXCEL please Problem 6,9 described Google's rental agreement for an airbase in California. It included the following es- timates: P = $1.16 billion: M&O = $0.0063 billion per year, refurbishment cost = $0.0026 billion in year 4; n = 60 years; and i = 15% per year. (a) You calculated the AW over 60 years. Now. use spreadsheet functions to display AW. PW. the capitalized cost (CC), and the differ- ence between PW and CC. (b) Help the CFO of Google perform a capital recovery analysis on the agreement for sev. eral retention periods, that is, n values, vary- ing from 20 to 60 years Gin 10-year incre- ments) and infinity. Explain the meaning of the results to the CFO. 6.9) In 2016, Google rented 1000 acres of a historic California airbase in the San Francisco Bay Area for $. 16 billion via a 60 year leaseAnnual M&O is expected to be $6.3 millionln addition Google will refurbish three hangars at a cost of $million 4 years from now . Assuming the $ 1.16 billion represents the present worth of only the lease , what is the equivalent AW of the transaction over the 60 year period at an interest rate of 15 % per year ? Solve it using EXCEL please Problem 6,9 described Google's rental agreement for an airbase in California. It included the following es- timates: P = $1.16 billion: M&O = $0.0063 billion per year, refurbishment cost = $0.0026 billion in year 4; n = 60 years; and i = 15% per year. (a) You calculated the AW over 60 years. Now. use spreadsheet functions to display AW. PW. the capitalized cost (CC), and the differ- ence between PW and CC. (b) Help the CFO of Google perform a capital recovery analysis on the agreement for sev. eral retention periods, that is, n values, vary- ing from 20 to 60 years Gin 10-year incre- ments) and infinity. Explain the meaning of the results to the CFO. 6.9) In 2016, Google rented 1000 acres of a historic California airbase in the San Francisco Bay Area for $. 16 billion via a 60 year leaseAnnual M&O is expected to be $6.3 millionln addition Google will refurbish three hangars at a cost of $million 4 years from now . Assuming the $ 1.16 billion represents the present worth of only the lease , what is the equivalent AW of the transaction over the 60 year period at an interest rate of 15 % per year