Underwriting and structuring[real estate]

A small office building 20,000 SF rents for $22.50 pSF annually with the landlord paying only base RE taxes ($1.50 p/SF) and structural repairs ($.0.50 p/SF). Assume a vacancy and rent loss factor of 5%.

Use a 7% return, a 10% terminal cap rte to develop the value.  

What is the value of the property using a 5 year holding period? What is the value of the property using a 10 year holding period? 

Please show all work in EXCEL