Calculate the expense reimbursements for the next five years

Assignment Help Accounting Basics
Reference no: EM133108136

Question - An office building has three floors of rentable space with a single tenant on each floor. The first floor has 20,760 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,760 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,760 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 is projected to increase 3 percent per year. Estimated operating expenses for the next year include the following:

Property taxes $101,900

Insurance 11,900

Utilities 76,900

Janitorial 26,900

Maintenance 41,900

Total $ 259,500

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).

Required -

a. Calculate the effective gross income (EGI) for the next five years.

b. Calculate the expense reimbursements for the next five years.

c. Calculate the net operating income (NOI) for the next five years.

d. How much does the NOI increase (average compound rate) over the five years?

e. Assuming the property is purchased for $5 million, what is the overall capitalization rate (going-in rate)?

Reference no: EM133108136

Questions Cloud

Prepare a risk management register : Prepare a Risk Management Register include all of the HR areas that employers and employees should be aware of when undertaking their roles and responsibilities
Comprehensive sexuality education circularism : What are some facts supporting comprehensive sexuality education circularism in schools and why would it be a good thing for sex education classes for all stude
Explain the different legislative acts : Explain the different legislative acts that apply to the occupational health and safety of the workforce
Review an ethically complex case : Explain how the APA Ethical Principles and Code of Conduct can be used to guide decisions in this ethically complex situation
Calculate the expense reimbursements for the next five years : The market rental rate at which leases are expected to be renewed is also projected to increase 3 percent per year. Calculate the expense reimbursements
About performance and productivity : Select an article about Performance and Productivity. discuss how the article relate to team performance and Threats to Productivity.
How a physician is like a salesman : Using "The Best Place to Work" text state how a physician is like a salesman. Include at least three examples. You will then provide your analysis as to whether
What is the solution for ghcl case analysis : What is the solution for GHCL case analysis: Navigating the pandemic?
Fixing a performance problem : Is it possible some performance problems or concerns are not worth fixing? How would you know?

Reviews

Write a Review

Accounting Basics Questions & Answers

  How much control does fed have over this longer real rate

Hubbard argues that the Fed can control the Fed funds rate, but the interest rate that is important for the economy is a longer-term real rate of interest.   How much control does the Fed have over this longer real rate?

  Coures:- fundamental accounting principles

Coures:- Fundamental Accounting Principles: - Explain the goals and uses of special journals.

  Accounting problems

Accounting problems,  Draw a detailed timeline incorporating the dividends, calculate    the exact Payback Period  b)   the discounted Payback Period. the IRR,  the NPV, the Profitability Index.

  Write a report on internal controls

Write a report on Internal Controls

  Prepare the bank reconciliation for company

Prepare the bank reconciliation for company.

  Cost-benefit analysis

Create a cost-benefit analysis to evaluate the project

  Theory of interest

Theory of Interest: NPV, IRR, Nominal and Real, Amortization, Sinking Fund, TWRR, DWRR

  Liquidity and profitability

Distinguish between liquidity and profitability.

  What is the expected risk premium on the portfolio

Your Corp, Inc. has a corporate tax rate of 35%. Please calculate their after tax cost of debt expressed as a percentage. Your Corp, Inc. has several outstanding bond issues all of which require semiannual interest payments.

  Simple interest and compound interest

Simple Interest, Compound interest, discount rate, force of interest, AV, PV

  Capm and venture capital

CAPM and Venture Capital

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd