Set up an annual proforma and derive an appraisal valution of the property below. Submit one excel file , showing all work (use formulae in excel cells and show formulae explicitly if you use a word document). You must show work or risk losing points. Quote your answer to the nearest $1,000.

You are appraising an office property that consists of a total of 38,000 sqft of rentable space, split equally accross two floors.Assume a holding period of 5 years, and that the property will sell at a cap rate of 9% at the end of year 5, with selling expenses of 4% of the gross price.

Rent comparables indicate that an appropriate price per sqft is $1.51. For subsequent years 2, 3,..., you expect market rents to rise by inflation, 3% per year.

Typical comprable office space in your market runs at a vacancy and collection loss rate of 15% of PGI. You are renting cell tower space on the roof for $6,000/yr, with a one-time jump of 15% in year 3, and growing at inflation each year thereafter (4, 5, ...).

Fixed expenses and reserves will grow 4% per year. For year 1, these expenses are: RE taxes: $70,000; insurance: $20,000; CapEx: $15,000.

Variable expenses are a fraction of effective gross income: 4% for maintenance, 1.2% for janitorial, 4% for utilities, 9% for management, 1.5% for leasing commissions, and 2% for TI.

Comprarable properties sell at a 13% discount rate.