Q$7)$ PLEASE SOLVE USING EXCEL IN SAME FORMAT. In $2016,$ Google rented $1000$ acres of a historic California airbase in the San Francisco Bay Area for $$1\mathrm{.}16$ billion via a $60-$year lease.

Annual M&O is expected to be $$6\mathrm{.}3$ million. In addition, Google will refurbish three hangars at a cost of $$2\mathrm{.}6$ million $4$ years from now. It

included the following estimates: $P=$$$1\mathrm{.}16$ billion; $M$&$O=$$$0\mathrm{.}0063$ billion per year; refurbishment cost $=$$$0\mathrm{.}0026$ billion in year $4$;$n=$

$60$ years; and $i=15\%$ per year.

Required:

Note: Use cells A$2$ to C$9$ from the given information to complete this question.

a$.$ You calculated the AW over $60$ years. Now, use spreadsheet functions to display AW$,$ PW$,$ the

capitalized cost $($CC$),$ and the difference between PW and CC$.$

b$.$ Help the CFO of Google perform a capital recovery analysis on the agreement for several retention periods, that is$,n$ values, varying

from $20$ to $60$ years $($in $10-$year increments$)$ and infinity.