Please show how to format it using Excel

Question 21 12 points You are appraising an office property that consists of a total of 24,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 10% at the end of year 5 with selling expenses of 5% of the gross price. You find Srent comparables, top floors renting for $1.43, 51.67, 51.33, 51.50 and 51,56/sqft/month, and bottom floors for $1.78, 51.88, 51.95, $1,80, and $1.86/sql/month. Based on the lease adjustments you had to make to arive at these values, you decide to weight these by 30%, 25%, 20%, 15%, and 10% respectively, for both top and bottom floors. For subsequent years 2, 3.... you expect market rents to rise by inflation, 2% per year. Typical comprable office space in your market runs at a vacancy and collection loss rate of 20% of PGI. You are renting cell tower space on the roof for $5,000/yr, with a one-time jump of 10% in your 3 and growing at inflation each year thereafter (4,5... Fixed expenses and reserves will grow 3% per year. For year, these expenses are: RE taxes: $60,000; insurance $10,000; Copix: $10,000 Variable expenses are a fraction of effective gross income: SM for maintenance, 16 for janitorial 3for utilities, 10% for management, 24 for leasing commissions, and 1% for TL Comprarable properties sell at a 12% discount rate. Set up an annual proforma and derive an appraisal valution of the property. Quote your answer to the nearest 51,000 Attach File Browse to Browse Content Collection Click Submit to complete this assessment Question 21 of 21 Save and Submit Click Submit to complete this assessment. Question 21 Save ANTNE Question 21 12 points You are appraising an office property that consists of a total of 24,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 10% at the end of year 5 with selling expenses of 5% of the gross price. You find 5 rent comparables, top floors renting for $1.43, $1.67, 133, 51.50 and 51.56/sqft/month, and bottom floors for $1.78, $1.88 $1.95, 51.80, and 51.86/sqft/month. Based on the lease adjustments you had to make to arive at these values, you decide to weight these by 30%, 25, 20%, 15% and 10% respectively for both top and bottom floors For subsequent years 2.3.- you expect market rents to rise by inflation, 2% per year Typical comprable office space in your market runs at a vacancy and collection loss rate of 20% of Pt. You are renting cell tower space on the roof for $5.000/y, with a one-time jump of 10% in year 3 and growing at inflation each year thereafter (4,5 Fived expenses and reserves will grow 3% per year. For year 1, these expenses are RE taxes 560,000: insurance $10,000 Cape $10,000. Variable expenses are a fraction et effective gross income: 5% for maintenance, 16 for janitorial. 36 for utilities, 10 for management, 2% for leasing commissions, and 1 for TL Comprarable properties sell at a 12% discount rate set up an annual preform and drive an appraisal valution of the property Quote your answer to the nearest $1,000 Attach File Trowel Content of ds Click Submit to complete this assessment Question 21 of 21 Save and Subme GIV MacBook Air Question 21 12 points You are appraising an office property that consists of a total of 24,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 10% at the end of year 5 with selling expenses of 5% of the gross price. You find Srent comparables, top floors renting for $1.43, 51.67, 51.33, 51.50 and 51,56/sqft/month, and bottom floors for $1.78, 51.88, 51.95, $1,80, and $1.86/sql/month. Based on the lease adjustments you had to make to arive at these values, you decide to weight these by 30%, 25%, 20%, 15%, and 10% respectively, for both top and bottom floors. For subsequent years 2, 3.... you expect market rents to rise by inflation, 2% per year. Typical comprable office space in your market runs at a vacancy and collection loss rate of 20% of PGI. You are renting cell tower space on the roof for $5,000/yr, with a one-time jump of 10% in your 3 and growing at inflation each year thereafter (4,5... Fixed expenses and reserves will grow 3% per year. For year, these expenses are: RE taxes: $60,000; insurance $10,000; Copix: $10,000 Variable expenses are a fraction of effective gross income: SM for maintenance, 16 for janitorial 3for utilities, 10% for management, 24 for leasing commissions, and 1% for TL Comprarable properties sell at a 12% discount rate. Set up an annual proforma and derive an appraisal valution of the property. Quote your answer to the nearest 51,000 Attach File Browse to Browse Content Collection Click Submit to complete this assessment Question 21 of 21 Save and Submit Click Submit to complete this assessment. Question 21 Save ANTNE Question 21 12 points You are appraising an office property that consists of a total of 24,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 10% at the end of year 5 with selling expenses of 5% of the gross price. You find 5 rent comparables, top floors renting for $1.43, $1.67, 133, 51.50 and 51.56/sqft/month, and bottom floors for $1.78, $1.88 $1.95, 51.80, and 51.86/sqft/month. Based on the lease adjustments you had to make to arive at these values, you decide to weight these by 30%, 25, 20%, 15% and 10% respectively for both top and bottom floors For subsequent years 2.3.- you expect market rents to rise by inflation, 2% per year Typical comprable office space in your market runs at a vacancy and collection loss rate of 20% of Pt. You are renting cell tower space on the roof for $5.000/y, with a one-time jump of 10% in year 3 and growing at inflation each year thereafter (4,5 Fived expenses and reserves will grow 3% per year. For year 1, these expenses are RE taxes 560,000: insurance $10,000 Cape $10,000. Variable expenses are a fraction et effective gross income: 5% for maintenance, 16 for janitorial. 36 for utilities, 10 for management, 2% for leasing commissions, and 1 for TL Comprarable properties sell at a 12% discount rate set up an annual preform and drive an appraisal valution of the property Quote your answer to the nearest $1,000 Attach File Trowel Content of ds Click Submit to complete this assessment Question 21 of 21 Save and Subme GIV MacBook Air