Question
Building One properties is a limited partnership formed with the express purpose of investing in commercial real estate. The firm is currently considering the acquisition
Building One properties is a limited partnership formed with the express purpose of investing in commercial real estate. The firm is currently considering the acquisition of an office building that we refer to simply as Building B. Building B is very similar to Building A, which recently sold for $36,960,000. BuildingOne has gathered general information about the two buildings, including valuation information for building A:
Per Square Foot | Total Square Footage | |||
A | B | A | B | |
Building size (sq ft) | 80,000 | 90,000 | ||
Rent | $100/sq ft | $120/sq ft | $8,000,000 | $10,800,000 |
Maintenance (fixed cost) | $(23)/sq ft | $(30)/sq ft | $(1,840,000) | $(2,700,000) |
Net operating income | $77/sq ft | $90/sq ft | $6,160,000 | $8,100,000 |
Buildings A and B are similar in size (80,000 and 90,000 square feet, respectively.) However, the two buildings differ both in maintenance costs ($23 and $30 per square foot), and rentals rates ($100 versus $120 per square foot). At this point we do not know why these differences exist. Nonetheless, the differences is real and should somehow be "accounted for" in the analysis of the value of Building B using data based on the sale of Building A. Building A sold for $462 per square foot, or $36,960,000. This reflects a sales multiple of six times the building's net operating income (NOI) of $6,160,000 per year and a capitalization rate of 16.67%.
A. Using the multiple of operating income, determine what value BuildingOne should place on Building B. B. If the risk-free rate of interest is 5.5% and the building maintenance costs are known with a high degree of certainty, what value should BuildingOne place on Building B's maintenance costs? How much value should BuildingOne place on Building B's revenues and, consequently, on the firm?
PROBLEM 8-2 | ||||||||||||
Given | Solution Legend | |||||||||||
Per Square Foot | Total Square Footage | = Value given in problem | ||||||||||
A | B | A | B | = Formula/Calculation/Analysis required | ||||||||
Building size (Sq. ft.) | 80,000 | 90,000 | = Qualitative analysis or Short answer required | |||||||||
Rent | $100 | $120 | $8,000,000 | $10,800,000 | = Goal Seek or Solver cell | |||||||
Maintenance (fixed cost) | (23) | (30) | (1,840,000) | (2,700,000) | = Crystal Ball Input | |||||||
Net Operating Income | $77 | $90 | $6,160,000 | $8,100,000 | = Crystal Ball Output | |||||||
% Change in NOI | ||||||||||||
Selling Price Information | A | B | A | B | ||||||||
Sales multiple for NOI/sq. ft. | 6 | ? | 6 | ? | ||||||||
Capitalization rate (1/Sales multiple) | 16.67% | ? | 16.67% | ? | ||||||||
Estimated property value | $462 | ? | $36,960,000 | ? | ||||||||
Solution | ||||||||||||
a. | ||||||||||||
b. | ||||||||||||
Per Square Foot | Total Square Footage | |||||||||||
Alternative Valuation Procedure | A | B | A | B | | |||||||
Risk free rate | 5% | 5% | 5% | 5% | ||||||||
Implied value of maintenance costs | ||||||||||||
Implied revenue value | ||||||||||||
Implied revenue multiple | ||||||||||||
Implied revenue cap rate | ||||||||||||
Property value/sq. ft. | ||||||||||||
Implied multiple | ||||||||||||
Implied cap rate | ||||||||||||
Building A | Building B | |||||||||||
% Change in Revenues | -20% | 0% | 20% | -20% | 0% | 20% | ||||||
Revenues | ||||||||||||
Maintenance (fixed cost) | (1,840,000) | (1,840,000) | (1,840,000) | (2,700,000) | (2,700,000) | (2,700,000) | ||||||
Net Operating Income | ||||||||||||
% Change in Revenues | -20.00% | 0.00% | 20.00% | -20.00% | 0.00% | 20.00% | ||||||
% Change in NOI |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started