CASE #3: VALUING OFFICE BUILDING You will be valuing an office building located at 815 Second...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
CASE #3: VALUING OFFICE BUILDING You will be valuing an office building located at 815 Second Avenue in New York City. The operating details of the building are as follows: • The building has a capacity of 540,581 square feet of rentable space. While 95% of this space is rented out for the next year, the occupancy rate is expected to climb 0.5% a year for the following four years to reach 97% of capacity in year 5. This is expected to be the occupancy rate in steady state. • The average rent per square foot¹ was $28.07 in the most recent year and is expected to grow 3% a year in perpetuity. Historically, there has been a credit loss, associated with tenants failing to make payments, of 2.5% of rental revenues. • The building has a garage that generated $800,000 in income for the most recent year. This income is also expected to grow 3% a year in perpetuity. • Real estate taxes were $5.24 a square foot in the most recent year and are expected to grow 4% a year for the next 5 years and 3% a year thereafter. • The land under the building is rented under a long-term lease and the ground rent in the most recent year was $1.5 million. This rent is expected to remain unchanged for the next 5 years and grow 3% a year thereafter. • Other expenses, including insurance, maintenance and utilities, amounted to $6.50 a square foot in the most recent year and are expected grow 3% a year in perpetuity. Approximately 10% of these expenses will be reimbursed by tenants each year (and thus will become a part of the revenues). • The management fee for the most recent year was $300,000 and is expected to grow 3% a year in perpetuity. • The depreciation in the building is expected to be $2 million a year for the next 5 years. The capital maintenance and upgrade expenditures (including leasehold improvements for new tenants) last year amounted to $1.5 million and are expected to grow 3% a year for the next 5 years. Beyond year 5, depreciation is expected to increase 3% a year in perpetuity and capital maintenance expenditures will offset depreciation. The potential buyer of the building is a corporation that faces a marginal tax rate of 38% and expects to finance the building with a mix of 60% debt and 40% equity. Debt will take the form of a long-term balloon payment loan with an interest rate of 6.50%. The unlevered beta is 0.62 for equity real estate investment trusts with office properties. A levered beta can be estimated using the following equation: ¹ The rents vary depending upon location in the building, with lower rents in the basement and lower floors and higher rents on the top floors. Debt Levered Beta Unlevered Beta(1 + (1 - tax rate) | Equity) To estimate the cost of equity, a risk-free rate of 5.4% and a market risk premium of 4% can be used. There are eight other office buildings in that part of New York City with roughly the same characteristics as the building being appraised that had sold recently. The following table summarizes the details of these properties and the prices that they were sold for. Property 900 2nd Avenue 767 2nd Avenue 350 Madison Avenue 888 7th Avenue 622 3rd Avenue 150 East 58th Street 881 3rd Avenue 810 7th Avenue Average Size 560,000 456,007 310,000 838,680 874,434 507,178 580,000 646,000 Table Comparable Properties Occupancy | Price for Rate (%) sale (million $) 182 95 70.06 99 95 97 96 97 95 95 95 96.13 154.5 172 118 59 141 Price per square foot ($) 325.00 208.33 226.00 184.22 196.70 232.66 101.72 218.27 211.61 NOI/Square Price/NOI foot 26.98 ΝΑ 17.6 ΝΑ ΝΑ 16.52 ΝΑ 15.17 12.05 12.84 14.08 14.39 13.34 CASE #3: VALUING OFFICE BUILDING You will be valuing an office building located at 815 Second Avenue in New York City. The operating details of the building are as follows: • The building has a capacity of 540,581 square feet of rentable space. While 95% of this space is rented out for the next year, the occupancy rate is expected to climb 0.5% a year for the following four years to reach 97% of capacity in year 5. This is expected to be the occupancy rate in steady state. • The average rent per square foot¹ was $28.07 in the most recent year and is expected to grow 3% a year in perpetuity. Historically, there has been a credit loss, associated with tenants failing to make payments, of 2.5% of rental revenues. • The building has a garage that generated $800,000 in income for the most recent year. This income is also expected to grow 3% a year in perpetuity. • Real estate taxes were $5.24 a square foot in the most recent year and are expected to grow 4% a year for the next 5 years and 3% a year thereafter. • The land under the building is rented under a long-term lease and the ground rent in the most recent year was $1.5 million. This rent is expected to remain unchanged for the next 5 years and grow 3% a year thereafter. • Other expenses, including insurance, maintenance and utilities, amounted to $6.50 a square foot in the most recent year and are expected grow 3% a year in perpetuity. Approximately 10% of these expenses will be reimbursed by tenants each year (and thus will become a part of the revenues). • The management fee for the most recent year was $300,000 and is expected to grow 3% a year in perpetuity. • The depreciation in the building is expected to be $2 million a year for the next 5 years. The capital maintenance and upgrade expenditures (including leasehold improvements for new tenants) last year amounted to $1.5 million and are expected to grow 3% a year for the next 5 years. Beyond year 5, depreciation is expected to increase 3% a year in perpetuity and capital maintenance expenditures will offset depreciation. The potential buyer of the building is a corporation that faces a marginal tax rate of 38% and expects to finance the building with a mix of 60% debt and 40% equity. Debt will take the form of a long-term balloon payment loan with an interest rate of 6.50%. The unlevered beta is 0.62 for equity real estate investment trusts with office properties. A levered beta can be estimated using the following equation: ¹ The rents vary depending upon location in the building, with lower rents in the basement and lower floors and higher rents on the top floors. Debt Levered Beta Unlevered Beta(1 + (1 - tax rate) | Equity) To estimate the cost of equity, a risk-free rate of 5.4% and a market risk premium of 4% can be used. There are eight other office buildings in that part of New York City with roughly the same characteristics as the building being appraised that had sold recently. The following table summarizes the details of these properties and the prices that they were sold for. Property 900 2nd Avenue 767 2nd Avenue 350 Madison Avenue 888 7th Avenue 622 3rd Avenue 150 East 58th Street 881 3rd Avenue 810 7th Avenue Average Size 560,000 456,007 310,000 838,680 874,434 507,178 580,000 646,000 Table Comparable Properties Occupancy | Price for Rate (%) sale (million $) 182 95 70.06 99 95 97 96 97 95 95 95 96.13 154.5 172 118 59 141 Price per square foot ($) 325.00 208.33 226.00 184.22 196.70 232.66 101.72 218.27 211.61 NOI/Square Price/NOI foot 26.98 ΝΑ 17.6 ΝΑ ΝΑ 16.52 ΝΑ 15.17 12.05 12.84 14.08 14.39 13.34
Expert Answer:
Related Book For
Posted Date:
Students also viewed these economics questions
-
A chilled orange juice ware-housing operation in New York City was experiencing too many out-of-stock situations with its 96-ounce containers. To better understand current and future demand for this...
-
The financial statements of Sprinto Ltd. are as follows for the year ended Analyse the performance of Sprinto Ltd. as far as the above information permits. Year ended Year ended Income statement for...
-
The Publishers Information Bureau in New York City released magazine advertising expenditure data compiled by leading national advertisers. The data were organized by product type over several years....
-
Q2. The figure below shows a three stage space-division switch with N =400, n-10 and 8 cross bars at the middle stage. Carefully analyze this multistage network and answer the following questions:...
-
Locate and read the article listed below and answer the following questions. Alleyne, P., N. Persaud, P. Alleyne, D. Greenidge, and P. Sealy. 2010. Perceived effectiveness of fraud detection audit...
-
Why is management philosophy an important internal control issue?
-
In 1951, DuPont began using the chemical perfluorooctanoic acid to manufacture Teflon. Due to the dangerous nature of the chemical, DuPont was given special instructions by its supplier to dispose of...
-
Johnson Graphics Company was organized on January 1, 2017, by Cameron Johnson. At the end of the first 6 months of operations, the trial balance contained the accounts shown. Analysis reveals the...
-
How Safe Are You? Assume one of your favorite activities is mountain climbing. When you go mountain climbing, you have several safety devices to keep you from falling. You notice that attached to one...
-
5 10 points Match the virtual lab procedure with the correct lung volume. 6 7 Ask the subject to inspire a normal inspiration, and breathe out a normal expiration, then exhale as forcibly as possible...
-
Which of the following statements is FALSE with respect to the accounting for a change in the functional currency? a When there is a change in an entitys functional currency, exchange differences...
-
Indicate whether each of the following statements is true or false by writing T or F in the answer c olumn. Discrimination in employment is covered in Title III of the Civil Rights Act of 1964.
-
Which project would the IRR method select if the firm has a 10% cost of capital and the projects are (a) independent or (b) mutually exclusive?
-
Timothy R. McVeigh (no relation to the Oklahoma City bomber) was a highly decorated, 17-year veteran of the U.S. Navy. McVeigh was a gay male who, while using an alias, sent an e-mail message to a...
-
If the cost of capital were 10%, should the project be accepted or rejected?
-
Express \(f_{i}^{\prime \prime}\) in terms of \(f_{i}, f_{i-1}, f_{i-2}\) in a nonuniform grid.
-
How does tomato juice make skunk smell go away?
-
In Problems 718, write the augmented matrix of the given system of equations. f0.01x0.03y = 0.06 [0.13x + 0.10y = 0.20
-
Isabelle Abiassi operates a popular summer camp for elementary school children. Projections for the current year are as follows: Sales revenue ......$8,000,000 Operating income.... $700,000 Average...
-
Mitchell Manufacturing's single finished goods warehouse is located across the street from its manufacturing facility. A recent study of product sales showed that most product lines are sold...
-
Mighty Bright Window Cleaners monthly income statement at several levels of activity is as follows: Required a. Identify each expense as fixed, variable, or mixed. b. Prepare a contribution margin...
-
A joint arrangement whereby the parties that have joint control of the arrangement have rights to the assets, and obligations for the liabilities, relating to the arrangement is known as: a. Joint...
-
To classify a joint arrangement as either a joint operation or a joint venture, the Islamic bank should consider: a. Structure and legal form of any separate vehicle b. Expenses, including its share...
-
To ensure that sufficient cash is available at any point in time to fund the withdrawal of cash by its clients, banks use: a. Current account b. Restricted investment account c. Unrestricted...
Study smarter with the SolutionInn App