You are evaluating an acquisition opportunity on behalf of your employer, a private real estate investment...

   
 
 

Transcribed Image Text:

You are evaluating an acquisition opportunity on behalf of your employer, a private real estate investment manager. The property in question lies on a prominent site overlooking the prestigious St James's Square in London, UK. The property is being sold by a well-known real estate and asset management firm, who is looking to dispose of the property after investing substantial capital into refurbishments and marketing. The property, which comprises two adjacent buildings consisting entirely of grade A office space, last transacted four years ago for £60 million, but has since been updated significantly. The buildings were recently featured in the press for having achieved some of the highest rents for offices anywhere in London. The listing broker has supplied you with an acquisition brochure, which provides details on the property's condition, location, and most importantly, tenancy schedule. The broker is quoting a price of £157 million for the property. Your job is to evaluate the opportunity. You must determine an appropriate value for the property, incorporate the use of debt and assess the impact of leverage on the investment's return, and suggest whether or not a bid should be made and at what price. As a matter of practice, your employer expects to hold these investments for five years and requires a minimum IRR of 10%. The Property St James's House is a stunning modern office property fronted by two listed Georgian buildings, with superb views directly across the square. Originally built as two separate houses, the property now comprises a net internal area of 81,842 square feet of institutional specification Grade A offices. The property provides today's modern office occupier with all of the necessary functionality of Grade A institutional quality offices, along with the style and grandeur of impressive period meeting rooms, commensurate with the image and positioning that a St James's Square address conveys, being one of the world's finest office locations. The property was comprehensively redesigned and redeveloped just four years ago. The building gives a striking first impression with its imposing Georgian entrance hall complete with an elegant, perfectly preserved central staircase. The polished limestone floors, dramatic staircase and stunning high ceiling period rooms sit at ease with modern features including a back-lit glass reception desk, soaring full-height atrium, spectacular sculptural artwork and exposed brick walls. The impressive central atrium provides a natural division of the classically proportioned Georgian rooms to the front and the open plan floorplate offices to the rear. The atrium provides excellent natural light to the offices and a focal point to the building. Three high-speed elevators serve all floors and allow simple access to both the modern floorplates at the rear and the period offices at the front. The highly specified offices offer a working environment which combines Georgian grandeur with modern efficiency. The period rooms are high, wide and beautifully finished, with great presence and commanding views over the square. These rooms benefit from a Grade A specification similar to those of the modern floorplates behind. The property is held freehold, comprising a site area of approximately 0.52 acres. The vendor is offering sale of shares in a special purpose vehicle (SPV), within which the property is the sole asset; therefore, its cash flow from operations is non-taxable. Accommodation and Tenancy Schedule St James's House's net internal area is described in Table 1. The property is multi-let to two hedge funds, two management consultants and an auction house. The details of the leases are presented in Table 2. Floor Sixth Fifth Fourth Third Second First Ground Ground Ground Lower Ground Lower Ground Lower Ground Total Table 1: Accommodation Use Offices Offices Offices Offices Offices Offices Offices Reception Storage Offices Storage Building Office Square feet 7,289 11.346 11,974 10,673 11,809 9,007 10,885 841 228 6,851 713 226 81,842 All of these leases are triple net (full repairing and insuring), meaning the rent figures given may be treated as net operating income for the property owner. Rent payments are due annually. Property Market The prospects for future rent growth in St James Grade A office rents are excellent. The highly restrictive development pipeline in the area, coupled with low levels of existing supply, has resulted in significant growth in Grade A rents over the current year. The highest rents in the area, outside of St James's House, are now £100 per square foot and rental values for the very best accommodation are forecast to rise to approximately £130 per square foot by the end of 2015. The expected rental growth rates, according to the listing broker, are listed in Table 3. In your experience, rents for space on Ground and Lower Ground floors are approximately half of those in the upper floors. The figures in Table 4 refer to upper floor offices. Tenant Hedge Fund A Hedge Fund A Hedge Fund B Management Consultant A Management Consultant A Vacant Vacant Auction House Hedge Fund A Management Consultant B Floor 6th Floor 5th Floor 4th Floor 3rd Floor 2nd Floor Table 2: Tenancy Schedule Use Area 1st Floor Part Ground Floor Part Ground Floor Offices Offices Offices Offices 10,673 Offices Offices Offices Offices Part Lower Ground Floor Offices Part Lower Ground Floor Offices 7,289 11,346 11,974 11,809 9.007 1,490 9,395 1,491 5,360 2 months to lease expiry 132 132 139 134 134 141 132 141 months to rent review 13 13. 19 14 14 21 13 21 months to break option 79 21 93 Rent passing per sq ft £141.37 £130.30 £125.84 £115.94 £108.77 £67.50 £100.00 £85.00 £57.50 £55.43 Year Year 0 (actual) Year 1 Year 2 Year 3 Year 4 Year 5 Table 3: Rental Growth Forecast Rental growth rate Date 7 months ago 8 months ago 10 months ago 12 months ago 14 months ago 14 months ago 4.6% 5.7% 5.9% 6.0% 4.0% The broker has also supplied you with a few recent transactions concerning similar properties. These are listed in in Table 5. Year-end Rent per square foot Tenure Long Leasehold Freehold Freehold £100.00 £105.00 £111.00 £117.00 £124.00 £130.00 Table 4: Comparable Property Transactions Area (square feet) 5,100,000 39,884 25,063 25,199 35,694 457,188 Location: Mayfair Mayfair Mayfair Mayfair Freehold St James Freehold Knightsbridge Freehold Price (millions) £452.00 £78.00 £65.64 £47.85 £44.50 £587.50 Cap Rate. 4.50% 4.25% 2.96% 3.91% 4.80% 4.00% Net Operating Income Based upon the current tenancy schedule, expected growth in rents over the next five years, your in- terpretation of break clauses and rent reviews incorporated in the current leases, and your expectations regarding leasing the vacant space, you have formed the following opinion of the property's pro forma net operating income: Floor Sixth Fifth Fourth Third Second First Part Ground A Part Ground B Part Lower Ground A Part Lower Ground B. Total Table 5: Net Operating Income Projections Square feet Year 6 1,030,446 Year 1 Year 2 Year 3 Year 4 Year 5 £1,030,446 1,030,446 1,030,446 1,030,446 1,030,446 £1,478,384 1,478,384 1,478,384 1,478,384 1,478,384 1,478,384 1,506,808. 1,506,808 1,506,808 1,506,808 £1,506,808 1,506,808 1,237,428 7,289 11,346 11,974 10,673 11,809 9,007 1,490 9,395 1,237,428 1,237,428 1,237,428 1,310,799 1,310,799 1,310,799 1,310,799 £1,237,428 1,237,428 £1,284,465 1,310,799 £607.973 607,973 £149,000 558,434 558,434 558,434 149,000 184,760 184,760 £798,575 £85,733 £297,105 1,491 607,973 149,000 184,760 1,099,215 1,099,215 1,099,215 1,099,215 85,733 85.733 85,733 313,560 313,560 313,560 85,733 798.575 85,733 297,105 8,502,249, 8,819,345 8.805.566 8,805,566 8,805,566 5,360 313,560 79,834 £8,475,915 Capital Market A bank has agreed to extend a first lien mortgage in conjunction with the purchase of St James's House. The terms are as follows: APR = 4.25%; amortization term = 25 years; maturity = 5 years; a 1.00% upfront fee; and, annual payments in arrears. As the amortization term exceeds the maturity of the loan, there will be a large principal payment due at maturity. The banker has indicated that the maximum loan-to-value ratio is 60%, meaning you may borrow up to 60% of the property's purchase price. 3 Deliverables Answer the following. For simplicity, you should assume cash flows occur at the end of each year. 1. The broker is asking £157 million for the property. What is the cap rate at this price? 2. Construct a DCF model to calculate the property's present value. Assume 7.75% cost of capital and long-term rent growth of 2.5% per year beyond Year-6. What is the value of the property? How much should you bid based on this value assuming purchase costs of 5.80%? 3. What value does your DCF model imply if you increase your long-term growth assumption from 2.50% to 3.50%. Comment on the sensitivity of your model to changes in this parameter. 4. Use the comparable transactions listed in Table 4 to calculate the implied value of the property assuming the average cap rate is applicable. How does this direct capitalization approach compare with your earlier DCF analysis and the broker's quoted price of £157 million? Why might this line of analysis be misleading? 5. What is the unlevered property-level IRR assuming a purchase price of £157 million, purchaser's costs of 5.80%, a sale of the property five years from now at a cap rate of 5.25%, and seller's costs of 1.00%. 6. Continuing the previous scenario, now account for the effect of financial leverage using the first lien mortgage at 60% loan-to-value. What is the IRR for the equity cash flow? Comment on the use of debt in relation to returns on equity. 7. Given your analysis, would you recommend bidding on this property; and, if so, what would you bid? You are evaluating an acquisition opportunity on behalf of your employer, a private real estate investment manager. The property in question lies on a prominent site overlooking the prestigious St James's Square in London, UK. The property is being sold by a well-known real estate and asset management firm, who is looking to dispose of the property after investing substantial capital into refurbishments and marketing. The property, which comprises two adjacent buildings consisting entirely of grade A office space, last transacted four years ago for £60 million, but has since been updated significantly. The buildings were recently featured in the press for having achieved some of the highest rents for offices anywhere in London. The listing broker has supplied you with an acquisition brochure, which provides details on the property's condition, location, and most importantly, tenancy schedule. The broker is quoting a price of £157 million for the property. Your job is to evaluate the opportunity. You must determine an appropriate value for the property, incorporate the use of debt and assess the impact of leverage on the investment's return, and suggest whether or not a bid should be made and at what price. As a matter of practice, your employer expects to hold these investments for five years and requires a minimum IRR of 10%. The Property St James's House is a stunning modern office property fronted by two listed Georgian buildings, with superb views directly across the square. Originally built as two separate houses, the property now comprises a net internal area of 81,842 square feet of institutional specification Grade A offices. The property provides today's modern office occupier with all of the necessary functionality of Grade A institutional quality offices, along with the style and grandeur of impressive period meeting rooms, commensurate with the image and positioning that a St James's Square address conveys, being one of the world's finest office locations. The property was comprehensively redesigned and redeveloped just four years ago. The building gives a striking first impression with its imposing Georgian entrance hall complete with an elegant, perfectly preserved central staircase. The polished limestone floors, dramatic staircase and stunning high ceiling period rooms sit at ease with modern features including a back-lit glass reception desk, soaring full-height atrium, spectacular sculptural artwork and exposed brick walls. The impressive central atrium provides a natural division of the classically proportioned Georgian rooms to the front and the open plan floorplate offices to the rear. The atrium provides excellent natural light to the offices and a focal point to the building. Three high-speed elevators serve all floors and allow simple access to both the modern floorplates at the rear and the period offices at the front. The highly specified offices offer a working environment which combines Georgian grandeur with modern efficiency. The period rooms are high, wide and beautifully finished, with great presence and commanding views over the square. These rooms benefit from a Grade A specification similar to those of the modern floorplates behind. The property is held freehold, comprising a site area of approximately 0.52 acres. The vendor is offering sale of shares in a special purpose vehicle (SPV), within which the property is the sole asset; therefore, its cash flow from operations is non-taxable. Accommodation and Tenancy Schedule St James's House's net internal area is described in Table 1. The property is multi-let to two hedge funds, two management consultants and an auction house. The details of the leases are presented in Table 2. Floor Sixth Fifth Fourth Third Second First Ground Ground Ground Lower Ground Lower Ground Lower Ground Total Table 1: Accommodation Use Offices Offices Offices Offices Offices Offices Offices Reception Storage Offices Storage Building Office Square feet 7,289 11.346 11,974 10,673 11,809 9,007 10,885 841 228 6,851 713 226 81,842 All of these leases are triple net (full repairing and insuring), meaning the rent figures given may be treated as net operating income for the property owner. Rent payments are due annually. Property Market The prospects for future rent growth in St James Grade A office rents are excellent. The highly restrictive development pipeline in the area, coupled with low levels of existing supply, has resulted in significant growth in Grade A rents over the current year. The highest rents in the area, outside of St James's House, are now £100 per square foot and rental values for the very best accommodation are forecast to rise to approximately £130 per square foot by the end of 2015. The expected rental growth rates, according to the listing broker, are listed in Table 3. In your experience, rents for space on Ground and Lower Ground floors are approximately half of those in the upper floors. The figures in Table 4 refer to upper floor offices. Tenant Hedge Fund A Hedge Fund A Hedge Fund B Management Consultant A Management Consultant A Vacant Vacant Auction House Hedge Fund A Management Consultant B Floor 6th Floor 5th Floor 4th Floor 3rd Floor 2nd Floor Table 2: Tenancy Schedule Use Area 1st Floor Part Ground Floor Part Ground Floor Offices Offices Offices Offices 10,673 Offices Offices Offices Offices Part Lower Ground Floor Offices Part Lower Ground Floor Offices 7,289 11,346 11,974 11,809 9.007 1,490 9,395 1,491 5,360 2 months to lease expiry 132 132 139 134 134 141 132 141 months to rent review 13 13. 19 14 14 21 13 21 months to break option 79 21 93 Rent passing per sq ft £141.37 £130.30 £125.84 £115.94 £108.77 £67.50 £100.00 £85.00 £57.50 £55.43 Year Year 0 (actual) Year 1 Year 2 Year 3 Year 4 Year 5 Table 3: Rental Growth Forecast Rental growth rate Date 7 months ago 8 months ago 10 months ago 12 months ago 14 months ago 14 months ago 4.6% 5.7% 5.9% 6.0% 4.0% The broker has also supplied you with a few recent transactions concerning similar properties. These are listed in in Table 5. Year-end Rent per square foot Tenure Long Leasehold Freehold Freehold £100.00 £105.00 £111.00 £117.00 £124.00 £130.00 Table 4: Comparable Property Transactions Area (square feet) 5,100,000 39,884 25,063 25,199 35,694 457,188 Location: Mayfair Mayfair Mayfair Mayfair Freehold St James Freehold Knightsbridge Freehold Price (millions) £452.00 £78.00 £65.64 £47.85 £44.50 £587.50 Cap Rate. 4.50% 4.25% 2.96% 3.91% 4.80% 4.00% Net Operating Income Based upon the current tenancy schedule, expected growth in rents over the next five years, your in- terpretation of break clauses and rent reviews incorporated in the current leases, and your expectations regarding leasing the vacant space, you have formed the following opinion of the property's pro forma net operating income: Floor Sixth Fifth Fourth Third Second First Part Ground A Part Ground B Part Lower Ground A Part Lower Ground B. Total Table 5: Net Operating Income Projections Square feet Year 6 1,030,446 Year 1 Year 2 Year 3 Year 4 Year 5 £1,030,446 1,030,446 1,030,446 1,030,446 1,030,446 £1,478,384 1,478,384 1,478,384 1,478,384 1,478,384 1,478,384 1,506,808. 1,506,808 1,506,808 1,506,808 £1,506,808 1,506,808 1,237,428 7,289 11,346 11,974 10,673 11,809 9,007 1,490 9,395 1,237,428 1,237,428 1,237,428 1,310,799 1,310,799 1,310,799 1,310,799 £1,237,428 1,237,428 £1,284,465 1,310,799 £607.973 607,973 £149,000 558,434 558,434 558,434 149,000 184,760 184,760 £798,575 £85,733 £297,105 1,491 607,973 149,000 184,760 1,099,215 1,099,215 1,099,215 1,099,215 85,733 85.733 85,733 313,560 313,560 313,560 85,733 798.575 85,733 297,105 8,502,249, 8,819,345 8.805.566 8,805,566 8,805,566 5,360 313,560 79,834 £8,475,915 Capital Market A bank has agreed to extend a first lien mortgage in conjunction with the purchase of St James's House. The terms are as follows: APR = 4.25%; amortization term = 25 years; maturity = 5 years; a 1.00% upfront fee; and, annual payments in arrears. As the amortization term exceeds the maturity of the loan, there will be a large principal payment due at maturity. The banker has indicated that the maximum loan-to-value ratio is 60%, meaning you may borrow up to 60% of the property's purchase price. 3 Deliverables Answer the following. For simplicity, you should assume cash flows occur at the end of each year. 1. The broker is asking £157 million for the property. What is the cap rate at this price? 2. Construct a DCF model to calculate the property's present value. Assume 7.75% cost of capital and long-term rent growth of 2.5% per year beyond Year-6. What is the value of the property? How much should you bid based on this value assuming purchase costs of 5.80%? 3. What value does your DCF model imply if you increase your long-term growth assumption from 2.50% to 3.50%. Comment on the sensitivity of your model to changes in this parameter. 4. Use the comparable transactions listed in Table 4 to calculate the implied value of the property assuming the average cap rate is applicable. How does this direct capitalization approach compare with your earlier DCF analysis and the broker's quoted price of £157 million? Why might this line of analysis be misleading? 5. What is the unlevered property-level IRR assuming a purchase price of £157 million, purchaser's costs of 5.80%, a sale of the property five years from now at a cap rate of 5.25%, and seller's costs of 1.00%. 6. Continuing the previous scenario, now account for the effect of financial leverage using the first lien mortgage at 60% loan-to-value. What is the IRR for the equity cash flow? Comment on the use of debt in relation to returns on equity. 7. Given your analysis, would you recommend bidding on this property; and, if so, what would you bid?

Answer rating: 100% (QA)

Here are the stepbystep calculations for each question 1 Cap rate at brokers asking price of 1570000... View the full answer