Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

real estate apprasial, person who completes this will recive $50 via P a y p a l Max Verstappen owns 3515 West Service Road, a

real estate apprasial, person who completes this will recive $50 via P a y p a l
image text in transcribed
image text in transcribed
image text in transcribed
Max Verstappen owns 3515 West Service Road, a Class A suburban office building in Burlington, Ontario. Situated on 3.9 acres of land, 3515 West Service Road is a four-story multi tenant building constructed in 1997, and substantially renovated in 2015. The building contains a net rentable area of 86,030 square feet a and is well-leased at 90.3% occupancy. The property has an aluminum framed curtain wall system incorporating a blue glass exterior with international tenants, signage, and interior office space with floor- to-ceiling windows. The asset has a floorplate size of 23,000 square feet and there are 342 surface parking stalls available (4.0 per 1000 SF). TO $ $ 14.40 69 Tenancy Summary Contractual Rent Rent Step Area Tenant (SF) PSF Annual Additional Rent On HSBC 28,374 $17.50 $ 496,545 14.50 Oct-22 $ 18.50 McDonalds 8,917 $ 17.00 $ 151,589 $ 14.30 Oct-23 $ 19.00 Bayer Canada 7.502 $ 17.75 $ 133,161 $ 14.30 Marcus & Millichap 5.463 $ 16.25 $ 88,774 14.50 Oct-24 $ 17.50 EllisDon Corporation 4,800 $ 16.50 $ 79,200 $ 14.75 Top 5 Total 55,056 $ 17.24 $ 949,268 $ 14.46 Other (9) 22.614 $ 17.60 $ 398,006 $ Occupied Total (14) 77.670 17.35 $ 1.347.275$ 14.44 Vacant 8,360 Building Total (16) 86,030 $ 17.35 $1,347,275 As per the above overview, the tenants in the building pay on average $17.35 per square foot in rent and an expense reimbursements of $14.44 per square foot. The current leases in the building are all long term, and lease expiries do not affect the projection period. Rent steps are negotiated in some of the leases of the major tenants in the building, all other rental income will increase 2% annually. Operating expenses and real estate taxes for the building are $7.00 and $3.00 per square foot, respectively. Market information indicates that operating expenses will increase 3% annually (as will their reimbursement), that the Management Fee for this type of asset is 3% of EGI, and that an appropriate replacement reserve is $1.50 per square foot. The vacancy rate in the market is 7%, and the current market rent for similar space is $17.75 per square foot. Reimbursement income for vacant space should be assumed to be equal to the current average rate in the building at $14.44 per square foot. The building was purchased for $18,000,000 in September 2013, and the purchase was financed at that time with a mortgage of $12,000,000 amortized over 25 years at a rate of 4% compounded semi-annually. At the time of purchase, approximately 30% of the fair market value was associated with the land, and the land value has remained the same since that time. Because of the renovation completed on the building the effective age is estimated to be 6 years, and the average life for this type of property is assumed to be 75 years. The only deferred maintenance is a $450,000 roof repair. However, given the age of the property, the I.T. capacity is not competitive with newer buildings. The cost to upgrade the technology capabilities is $175,000. The average cost to building this space new is $225/SF. Transaction summaries for six comparable properties located within the subject's market are included on the next page. The office market has continued to remain resilient and demonstrates strong, stable growth. On average, prices have been increasing with 0.5% a month over the past 24 months. Market analysis indicates that the adjustments for additional space are $200 per square foot of building space and $1,200,000 per acre of land. Each additional year of age is estimated to decrease value by 1%. Assume it is October 1, 2021, and Mr. Verstappen has requested an appraisal of the current market value of the building. Using the provided information, complete the following: 1. Complete an Income Approach to value, using both Direct Capitalization and DCF techniques. a. Assume a five-year holding period for your analysis, and a 1.75% cost of sales. b. Determine an appropriate capitalization rate from the comparables provided. Make sure to substantiate your capitalization rate selection process. Assume a 0.5% risk increase in your discount rate, and a further 0.5% increase in your terminal cap rate over your going-in cap rate. 2. Complete a Cost Approach to value. 3. Complete a Sales Comparison Approach to value, utilizing comparable sales data provided. Compare the properties on a Sales Price/SF basis. Assume all comparable properties are located within the subject's immediate market. a. Select three comparables upon which to base your analysis and defend why those comparables were selected (or why the others were discarded). 4. Based on your analyses, reconcile the approaches to value and provide an estimate of the October 1, 2021 market value. Municipality Price Size (sq.ft.) PSF Cap rate Year built Tenancy Estate type Notes Land (acres) 3.7 Markham $13,050.000 57,971 $225 6.00% 1985 Multi Fee Simple Oakville $25,750,000 86,463 $298 6.50% 2018 Multi Fee Simple 4.3 $22.000.000 91,788 $240 5.75% 1991 Single Fee Simple Date Transaction name 2021-07-01 131 McNabb Street 2021-07-01 1415 Joshuas Creek Drive 2021-06-01 5255 Satellite Drive 2019-12-01 Enterprise Centre 2019-12-01 5965 Coopers Avenue 2019-12-01 2425 Matheson Boulevard East Mississauga Mississauga $14,975,000 4.1 Owner occupiei 3.9 93.628 $160 5.50% 1988 Multi Fee Simple Mississauga $15,150,000 51.000 $297 5.25% 1988 Single Fee Simple 3.8 Mississauga $54,350,000 187,837 $289 6.00% 2000 Multi Fee Simple 4.8 Part of portfolio Max Verstappen owns 3515 West Service Road, a Class A suburban office building in Burlington, Ontario. Situated on 3.9 acres of land, 3515 West Service Road is a four-story multi tenant building constructed in 1997, and substantially renovated in 2015. The building contains a net rentable area of 86,030 square feet a and is well-leased at 90.3% occupancy. The property has an aluminum framed curtain wall system incorporating a blue glass exterior with international tenants, signage, and interior office space with floor- to-ceiling windows. The asset has a floorplate size of 23,000 square feet and there are 342 surface parking stalls available (4.0 per 1000 SF). TO $ $ 14.40 69 Tenancy Summary Contractual Rent Rent Step Area Tenant (SF) PSF Annual Additional Rent On HSBC 28,374 $17.50 $ 496,545 14.50 Oct-22 $ 18.50 McDonalds 8,917 $ 17.00 $ 151,589 $ 14.30 Oct-23 $ 19.00 Bayer Canada 7.502 $ 17.75 $ 133,161 $ 14.30 Marcus & Millichap 5.463 $ 16.25 $ 88,774 14.50 Oct-24 $ 17.50 EllisDon Corporation 4,800 $ 16.50 $ 79,200 $ 14.75 Top 5 Total 55,056 $ 17.24 $ 949,268 $ 14.46 Other (9) 22.614 $ 17.60 $ 398,006 $ Occupied Total (14) 77.670 17.35 $ 1.347.275$ 14.44 Vacant 8,360 Building Total (16) 86,030 $ 17.35 $1,347,275 As per the above overview, the tenants in the building pay on average $17.35 per square foot in rent and an expense reimbursements of $14.44 per square foot. The current leases in the building are all long term, and lease expiries do not affect the projection period. Rent steps are negotiated in some of the leases of the major tenants in the building, all other rental income will increase 2% annually. Operating expenses and real estate taxes for the building are $7.00 and $3.00 per square foot, respectively. Market information indicates that operating expenses will increase 3% annually (as will their reimbursement), that the Management Fee for this type of asset is 3% of EGI, and that an appropriate replacement reserve is $1.50 per square foot. The vacancy rate in the market is 7%, and the current market rent for similar space is $17.75 per square foot. Reimbursement income for vacant space should be assumed to be equal to the current average rate in the building at $14.44 per square foot. The building was purchased for $18,000,000 in September 2013, and the purchase was financed at that time with a mortgage of $12,000,000 amortized over 25 years at a rate of 4% compounded semi-annually. At the time of purchase, approximately 30% of the fair market value was associated with the land, and the land value has remained the same since that time. Because of the renovation completed on the building the effective age is estimated to be 6 years, and the average life for this type of property is assumed to be 75 years. The only deferred maintenance is a $450,000 roof repair. However, given the age of the property, the I.T. capacity is not competitive with newer buildings. The cost to upgrade the technology capabilities is $175,000. The average cost to building this space new is $225/SF. Transaction summaries for six comparable properties located within the subject's market are included on the next page. The office market has continued to remain resilient and demonstrates strong, stable growth. On average, prices have been increasing with 0.5% a month over the past 24 months. Market analysis indicates that the adjustments for additional space are $200 per square foot of building space and $1,200,000 per acre of land. Each additional year of age is estimated to decrease value by 1%. Assume it is October 1, 2021, and Mr. Verstappen has requested an appraisal of the current market value of the building. Using the provided information, complete the following: 1. Complete an Income Approach to value, using both Direct Capitalization and DCF techniques. a. Assume a five-year holding period for your analysis, and a 1.75% cost of sales. b. Determine an appropriate capitalization rate from the comparables provided. Make sure to substantiate your capitalization rate selection process. Assume a 0.5% risk increase in your discount rate, and a further 0.5% increase in your terminal cap rate over your going-in cap rate. 2. Complete a Cost Approach to value. 3. Complete a Sales Comparison Approach to value, utilizing comparable sales data provided. Compare the properties on a Sales Price/SF basis. Assume all comparable properties are located within the subject's immediate market. a. Select three comparables upon which to base your analysis and defend why those comparables were selected (or why the others were discarded). 4. Based on your analyses, reconcile the approaches to value and provide an estimate of the October 1, 2021 market value. Municipality Price Size (sq.ft.) PSF Cap rate Year built Tenancy Estate type Notes Land (acres) 3.7 Markham $13,050.000 57,971 $225 6.00% 1985 Multi Fee Simple Oakville $25,750,000 86,463 $298 6.50% 2018 Multi Fee Simple 4.3 $22.000.000 91,788 $240 5.75% 1991 Single Fee Simple Date Transaction name 2021-07-01 131 McNabb Street 2021-07-01 1415 Joshuas Creek Drive 2021-06-01 5255 Satellite Drive 2019-12-01 Enterprise Centre 2019-12-01 5965 Coopers Avenue 2019-12-01 2425 Matheson Boulevard East Mississauga Mississauga $14,975,000 4.1 Owner occupiei 3.9 93.628 $160 5.50% 1988 Multi Fee Simple Mississauga $15,150,000 51.000 $297 5.25% 1988 Single Fee Simple 3.8 Mississauga $54,350,000 187,837 $289 6.00% 2000 Multi Fee Simple 4.8 Part of portfolio

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Financial And Managerial Accounting Information For Decisions

Authors: John Wild, Ken Shaw, Barbara Chiappetta

7th Edition

1259726703, 9781259726705

More Books

Students also viewed these Accounting questions