Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

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

Investing In Mortgage Backed And Asset Backed Securities

Authors: Glenn M. Schultz, Frank J. Fabozzi

1st Edition

1118944003, 978-1118944004

More Books

Students also viewed these Finance questions

Question

8. Explain the relationship between communication and context.

Answered: 1 week ago

Question

d. How were you expected to contribute to family life?

Answered: 1 week ago