An office building has three floors of rentable space with a single tenant on each floor....
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
An office building has three floors of rentable space with a single tenant on each floor. The first floor has 20,000 square feet of rentable space and is currently renting for $15 per square foot. Three years remain on the lease. The lease has an expense stop at $4 per square foot. The second floor has 15,000 square feet of rentable space and is leasing for $15.50 per square foot and has four years remaining on the lease. This lease has an expense stop at $4.50 per square foot. The third floor has 15,000 square feet of leasable space and a lease just signed for the next five years at a rental rate of $17 per square foot, which is the current market rate. The expense stop is at $5 per square foot, which is what expenses per square foot are estimated to be during the next year (excluding management). Management expenses are expected to be 5 percent of effective gross income and are not included in the expense stop. Each lease also has a CPI adjustment that provides for the base rent to increase at half the increase in the CPI. The CPI ispage 383 projected to increase 3 percent per year. Estimated operating expenses for the next year include the following: Property taxes Insurance Utilities Janitorial Maintenance Total $100,000 10,000 75,000 25,000 40,000 $250,000 All expenses are projected to increase 3 percent per year. The market rental rate at which leases are expected to be renewed is also projected to increase 3 percent per year. When a lease is renewed, it will have an expense stop equal to operating expenses per square foot during the first year of the lease. To account for any time that may be necessary to find new tenants after current leases expire and new leases are made, vacancy is estimated to be 10 percent of EGI for the last two years (years 4 and 5). a. Develop a profoma and cash flow spreadsheet for the next five years from the information provided. b. Project the effective gross income (EG/) for the next five years. c. Project the expense reimbursements for the next five years. d. Project the net operating income (NOI) for the next five years. e. How much does the NOI increase (average compound rate) over the five years? f. What is the Break even point? g. Assuming the property is purchased for $5 million, what is the overall capitalization rate (goingin rate)? h. What is the NPV and IRR? An office building has three floors of rentable space with a single tenant on each floor. The first floor has 20,000 square feet of rentable space and is currently renting for $15 per square foot. Three years remain on the lease. The lease has an expense stop at $4 per square foot. The second floor has 15,000 square feet of rentable space and is leasing for $15.50 per square foot and has four years remaining on the lease. This lease has an expense stop at $4.50 per square foot. The third floor has 15,000 square feet of leasable space and a lease just signed for the next five years at a rental rate of $17 per square foot, which is the current market rate. The expense stop is at $5 per square foot, which is what expenses per square foot are estimated to be during the next year (excluding management). Management expenses are expected to be 5 percent of effective gross income and are not included in the expense stop. Each lease also has a CPI adjustment that provides for the base rent to increase at half the increase in the CPI. The CPI ispage 383 projected to increase 3 percent per year. Estimated operating expenses for the next year include the following: Property taxes Insurance Utilities Janitorial Maintenance Total $100,000 10,000 75,000 25,000 40,000 $250,000 All expenses are projected to increase 3 percent per year. The market rental rate at which leases are expected to be renewed is also projected to increase 3 percent per year. When a lease is renewed, it will have an expense stop equal to operating expenses per square foot during the first year of the lease. To account for any time that may be necessary to find new tenants after current leases expire and new leases are made, vacancy is estimated to be 10 percent of EGI for the last two years (years 4 and 5). a. Develop a profoma and cash flow spreadsheet for the next five years from the information provided. b. Project the effective gross income (EG/) for the next five years. c. Project the expense reimbursements for the next five years. d. Project the net operating income (NOI) for the next five years. e. How much does the NOI increase (average compound rate) over the five years? f. What is the Break even point? g. Assuming the property is purchased for $5 million, what is the overall capitalization rate (goingin rate)? h. What is the NPV and IRR?
Expert Answer:
Answer rating: 100% (QA)
Answer b Projected Effective Gross Income EGI for the n... View the full answer
Related Book For
Real Estate Finance and Investments
ISBN: 978-0073377339
14th edition
Authors: William Brueggeman, Jeffrey Fisher
Posted Date:
Students also viewed these finance questions
-
An office building has three floors of rentable space with a single tenant on each floor. The first floor has 20,360 square feet of rentable space and is currently renting for $15 per square foot....
-
An office building has three floors of rentable space with a single tenant on each floor. The first floor has 20,000 square feet of rentable space and is currently renting for $15 per square foot....
-
Make a Marketing Plan for business during the Covid 19 Pandemic as it is today. Position yourself as an entrepreneur looking to open a new business or expand your existing business. Use assumptions...
-
Consider the following table in which 500 respondents have been classified based on product use and income. a.Does this table indicate concomitant variation between product use and income? b.Describe...
-
An AC generator puts out a voltage of V=93.0V sin((317rad/s)t) where t is measured in seconds. The AC generator is connected in series with a 43.0 resistor, 252 mH inductor, and 105 F capacitor....
-
For a random sample of n = 60, find the probability of a sample mean being greater than 132 when = 130 and = 16.1. The population mean and standard deviation are given. Find the indicated...
-
Marcia Saxton worked for Jerry Richardson, a supervisor at AT&Ts International Division. Richardson made advances to Saxton on two occasions over a three-week period. Each time Saxton told him she...
-
1. A car is traveling at 60 mph and needs to come to a stop in 100 feet. What acceleration is required if the brakes are applied after a 0.5-second delay? 2. A ball is rolled around a circular track...
-
How else can we engage in group facilitation development in our everyday lives?
-
How do neoliberal economic policies contribute to social conflict by prioritizing market interests over the welfare of marginalized groups, thereby exacerbating socioeconomic inequalities ?
-
What role does hegemony play in perpetuating social conflict, particularly within marginalized communities ? Explain
-
What impact does structural violence, as conceptualized by peace researchers, have on the perpetuation of social conflict within disenfranchised communities ?
-
Globalization tends to provide net benefits to those nations that become active participants in the global economy. Why have several nations, such as Kenya, Brazil, India, and Zimbabwe, experienced...
-
How does globalization contribute to the spread of cultural and ideological hegemony, and what are the implications for the preservation of indigenous knowledge and non-Western value systems ?
-
Search the Internet for item upon which the U.S. Government has imposed a tariff. Write a paper describing how each tariff has impacted trade.
-
For the given transfer function: Vo(s) / Vi(s) = (s^2C^2R^2 + 1) / (s^2C^2R^2 + 4sCR + 1) Assumiing that 1/(CR) = 120 PI so write the matlab code to find the magnitude plot
-
The hospital where you are completing your internship is located in an inner city neighborhood with a multi-lingual, diverse population. Recently, the local newspaper has been running a series about...
-
Over the past month, every member of the Intravenous (IV) Therapy Team has complained to you about the IV Team supervisor. Her direct reports, all RNs, agree that she is technically superb. However,...
-
What are the benefits of implementing programs to address cultural competence within a health care organization? What are the costs of not implementing such programs?
Study smarter with the SolutionInn App