90.2K

Verified Solution

Link Copied!

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

Answer & Explanation Solved by verified expert

See Answer