You have been assigned to value a local office building. This building contains 15,000 SF of...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
You have been assigned to value a local office building. This building contains 15,000 SF of rentable area. Based on the information below, determine what this building could sell for if the investor has a 5-year hold period. We will assume your hold period begins on January 1, 2022 and will run through December 31, 2026. Once you have found the building's NOI for each of the 5 years, you will need to use the NOI of year 6 to calculate the Discounted Cash Flow. A cap rate of 8.4% has been historical in this market and is what the investors would like you to use. Estimate the Net Operating Income of the following building based on the following information: (Be sure to include PGI of each property, as well as the EGI and NOI for the entire property) The building is currently at a 100% occupancy level with the following information on the lease: Suite 100: 4.400 SF space, $25/SF with 3% increases each year. No additional reimbursements. Suites 200: 3.300SF, $22.50/SF fixed and responsible for Percentage Rent. They will pay 12% for any sales they have over $1,500,000 each year. Assume their sales for the first year are $2,000,000 and increase by 15% each subsequent year. Responsible for reimbursing their net share of Utilities. Suite 300: 4,000 SF, Year 1 begins @ $17/SF and will increase based on the CPI-U for Year 2. Please use this information on the CPI-U to find the average change in 2021 to apply as the increase for 2022 and assume a 2% year over year increase for the remaining hold period. Reimbursements of their net share of utilities, taxes, insurance, maintenance, and garbage (to find not share, determine the percent of the building this tenant occupies and multiple the expense by that amount Consumer Price Index Historical Tables for U.S. City Average CONSUMER PRICE INDEX FOR ALL URBAN CONSUMERS (CPI-U) (not seasonally adjusted) Percent change from 12 months ago 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021 1.6 2.9 1.6 1.6 -0.1 1.4 2.5 2.1 1.6 2.5 1.4 2.1 2.9 2.0 1.1 0.0 1.0 27 2.2 1.5 2.3 1.7 2.7 2.7 1.5 1.5 -0.1 0.9 2.4 2.4 1.9 1.5 2.6 3.2 2.3 1.1 2.0 -0.2 1.1 2.5 2.0 0.3 4.2 3.6 97 1.7 13 1.4 2.1 0.0 90 1.0 1.9 2.8 1.8 0.1 5.0 1.7 1.8 21 0.1 1.0 1.6 2.9 1.6 0.6 5.4 3.6 1.4 2.0 2.0 0.2 0.8 1.7 2.9 1.8 1.0 5.4 3.8 1.7 1.5 1.7 0.2 1.1 1.9 2.7 1.7 1.3 5.3 232382238 3.9 2.0 1.2 1.7 0.0 1.5 1.7 14 5.2 3.5 SEEEEEEEEEE 2.2 1.0 1.7 0.2 1.6 2.0 2.5 1.8 1.2 5.0 3.4 331332333 1.8 0.5 1.7 2.2 2.2 1.2 4.8 3.0 1.7 1.5 0.8 0.7 2.1 1.9 2.3 1.4 4.6 Suite 400: 3,300 SF; Tenant pays monthly rent of $4,000/month with subsequent annual increases of 3.25% per year for the entire lease period. This is a NNN lease so be sure to include the reimbursements for those expenses based on their net share. Additional Information (based on historical data): Assume a vacancy rate/collection loss of 7% for the entire building Miscellaneous Income: Vending machines in the building generate $200/month with estimated 2% increases each year. Expenses (apply an estimated 2% increase on all Operating Expenses) Utilities- $4/SF/year Garbage collection-$150/month Real estate Taxes- $65,000/year Insurance-$18,000/year Maintenance- $3/SF/year Management-5% of EGI (Non-recoverable expense) New Roof expenditure- $65,000 in year 3 Parking Lot re-pavement-$30,000 in year I Be sure to account for any reimbursements made by the tenants. Suite 100 2021 2022 2023 2024 2025 2026 Total PGI: Suite 200 Total Sales Natural Breakeven Sales over Breakeven Additional % Rent Paid 2021 2022 2023 2024 2025 2026 Total Suite 300 Change in CPI-U 2021 2022 2023 2024 2025 2026 Total PGI: Suite 400 2021 2022 2023 2024 2025 2026 Total PGI: PGI Suite 100 Suite 200 Suite 300 Suite 400 Total PGI Vacancy/Collection Loss Miscellaneous Income EGI A Operating Expenses Fixed Variable Total Operating Expenses Capital Expenditures Total Capital Expenditures ΝΟΙ Direct Capitalization Value B 2021 C 2022 E 2023 GO H 2024 2025 2026 M You have been assigned to value a local office building. This building contains 15,000 SF of rentable area. Based on the information below, determine what this building could sell for if the investor has a 5-year hold period. We will assume your hold period begins on January 1, 2022 and will run through December 31, 2026. Once you have found the building's NOI for each of the 5 years, you will need to use the NOI of year 6 to calculate the Discounted Cash Flow. A cap rate of 8.4% has been historical in this market and is what the investors would like you to use. Estimate the Net Operating Income of the following building based on the following information: (Be sure to include PGI of each property, as well as the EGI and NOI for the entire property) The building is currently at a 100% occupancy level with the following information on the lease: Suite 100: 4.400 SF space, $25/SF with 3% increases each year. No additional reimbursements. Suites 200: 3.300SF, $22.50/SF fixed and responsible for Percentage Rent. They will pay 12% for any sales they have over $1,500,000 each year. Assume their sales for the first year are $2,000,000 and increase by 15% each subsequent year. Responsible for reimbursing their net share of Utilities. Suite 300: 4,000 SF, Year 1 begins @ $17/SF and will increase based on the CPI-U for Year 2. Please use this information on the CPI-U to find the average change in 2021 to apply as the increase for 2022 and assume a 2% year over year increase for the remaining hold period. Reimbursements of their net share of utilities, taxes, insurance, maintenance, and garbage (to find not share, determine the percent of the building this tenant occupies and multiple the expense by that amount Consumer Price Index Historical Tables for U.S. City Average CONSUMER PRICE INDEX FOR ALL URBAN CONSUMERS (CPI-U) (not seasonally adjusted) Percent change from 12 months ago 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021 1.6 2.9 1.6 1.6 -0.1 1.4 2.5 2.1 1.6 2.5 1.4 2.1 2.9 2.0 1.1 0.0 1.0 27 2.2 1.5 2.3 1.7 2.7 2.7 1.5 1.5 -0.1 0.9 2.4 2.4 1.9 1.5 2.6 3.2 2.3 1.1 2.0 -0.2 1.1 2.5 2.0 0.3 4.2 3.6 97 1.7 13 1.4 2.1 0.0 90 1.0 1.9 2.8 1.8 0.1 5.0 1.7 1.8 21 0.1 1.0 1.6 2.9 1.6 0.6 5.4 3.6 1.4 2.0 2.0 0.2 0.8 1.7 2.9 1.8 1.0 5.4 3.8 1.7 1.5 1.7 0.2 1.1 1.9 2.7 1.7 1.3 5.3 232382238 3.9 2.0 1.2 1.7 0.0 1.5 1.7 14 5.2 3.5 SEEEEEEEEEE 2.2 1.0 1.7 0.2 1.6 2.0 2.5 1.8 1.2 5.0 3.4 331332333 1.8 0.5 1.7 2.2 2.2 1.2 4.8 3.0 1.7 1.5 0.8 0.7 2.1 1.9 2.3 1.4 4.6 Suite 400: 3,300 SF; Tenant pays monthly rent of $4,000/month with subsequent annual increases of 3.25% per year for the entire lease period. This is a NNN lease so be sure to include the reimbursements for those expenses based on their net share. Additional Information (based on historical data): Assume a vacancy rate/collection loss of 7% for the entire building Miscellaneous Income: Vending machines in the building generate $200/month with estimated 2% increases each year. Expenses (apply an estimated 2% increase on all Operating Expenses) Utilities- $4/SF/year Garbage collection-$150/month Real estate Taxes- $65,000/year Insurance-$18,000/year Maintenance- $3/SF/year Management-5% of EGI (Non-recoverable expense) New Roof expenditure- $65,000 in year 3 Parking Lot re-pavement-$30,000 in year I Be sure to account for any reimbursements made by the tenants. Suite 100 2021 2022 2023 2024 2025 2026 Total PGI: Suite 200 Total Sales Natural Breakeven Sales over Breakeven Additional % Rent Paid 2021 2022 2023 2024 2025 2026 Total Suite 300 Change in CPI-U 2021 2022 2023 2024 2025 2026 Total PGI: Suite 400 2021 2022 2023 2024 2025 2026 Total PGI: PGI Suite 100 Suite 200 Suite 300 Suite 400 Total PGI Vacancy/Collection Loss Miscellaneous Income EGI A Operating Expenses Fixed Variable Total Operating Expenses Capital Expenditures Total Capital Expenditures ΝΟΙ Direct Capitalization Value B 2021 C 2022 E 2023 GO H 2024 2025 2026 M
Expert Answer:
Answer rating: 100% (QA)
To determine the Net Operating Income NOI for each year and calculate the Discounted Cash Flow DCF value well need to gather and analyze the provided ... View the full answer
Related Book For
Auditing An International Approach
ISBN: 978-0071051415
6th edition
Authors: Wally J. Smieliauskas, Kathryn Bewley
Posted Date:
Students also viewed these accounting questions
-
You have been assigned to a strategic leadership committee that has been charged by the CEO with developing and implementing a comprehensive management accounting and control system. At the first...
-
You have been assigned to select an MUS sample from Whitney Company's detailed inventory records as of September 30. Whitney's controller gave you a list of the 23 different inventory items and their...
-
As an internal auditor, you have been assigned to evaluate the controls and operation of acomputer payroll system. To test the computer systems and programs, you submit independentlycreated test...
-
You have $300,000 saved for retirement. Your account earns 6% interest. How much will you be able to pull out each month, if you want to be able to take withdrawals for 20 years? $ Get help: Video
-
On January 1, 2011, Kidman Enterprises issues bonds that have a $1,700,000 par value, mature in 20 years, and pay 9% interest semiannually on June 30 and December 31. The bonds are sold at par. 1....
-
In Figure 2-28, there are four stations that can transmit. Suppose four more stations are added. Provide the chip sequences of these stations. Figure 2-28 A = (-1-1 -1 +1 +1 -1 +1 +1) B = (-1 -1 +1-1...
-
Data 2.7 on page 95 introduces the dataset HollywoodMovies, which contains information on more than 900 movies that came out of Hollywood between 2007 and 2013. We will consider this the population...
-
Suppose two batteries, with unequal emfs of 2.00 V and 3.00 V, are connected as shown in Fig. 19-51. If each internal resistance is r = 0.100 , and R = 4.00, what is the voltage across the resistor...
-
Remarks: Describe a convention for a hub to find out about its nearby neighbors. You ought to indicate the arrangement of your messages and the size of any message fields. [4 marks] Using the...
-
Palisade Creek Co. is a merchandising business. The account balances for Palisade Creek Co. as of May 1, 2014 (unless otherwise indicated), are as follows: During May, the last month of the fiscal...
-
Write commands to build a linux module,to deploy a linux module and to remove a linux module. Whats the difference between Linux module and C Programming Language Code. Explain How Flask Handles...
-
Kazibwe, a businessman does not maintain a complete set of books for his business transactions. The following is a summary of his cash transactions for the year ended December 31, 2015. Receipts Kshs...
-
Malimali Fish Products Ltd, A Malindi-based firm dealing in fish products, conducts training programmes for all its line managers. The managers ar expected to master, in particular, procedures in...
-
Question 2 Abantu Ltd, a textile manufacturing company in Bungoma, recently introduced a compensation programme for its employees. As a human resource specialist, explain what prompted the firm to...
-
1. An unpolarized light beam is incident on the polarizes of a polarization experiment and the intensity of light beam emerging from the analyzer is measured as 100 Lumens. Now, if the analyzer is...
-
5. Identify the type of each of the following reactions stating reason for your answers: (a) Fe2O3 + 2Al 6. Al2O3 + 2Fe + heat (b) Pb(NO3)2 + 2KI PbI2 + 2KNO heat (c) ZnCOg ZnO + CO2 In the...
-
If the expected dividend on a share of stock is $1 next year, the dividends are expected to grow at a 5% rate per annum indefinitely and the stock is currently selling for $14.29, what is the...
-
(a) What is the focal length of a magnifying glass that gives an angular magnification of 8.0 when the image is at infinity? (b) How far must the object be from the lens?
-
Describe the procedures and documentation of a controlled count of clients investment securities.
-
Define the term contingency fee, explaining how such fees apply to PAs. Do you feel a change is necessary to rules for contingency fees in Canada?
-
Describe the four main types of modified opinions and the reasons each would be used in an audit report.
-
Which of the following provides evidence for evolution? (a) changes in the coloration of peppered moth populations over time (b) the presence of vestigial eyes in cave salamanders (c) the fact that...
-
Which of these adaptations is the result of sexual selection? (a) the spines on cactus plants (b) parental care in male poison dart frogs (c) the songs of male birds (d) dark wings in peppered moths
-
If you put a heavy load in a wheelbarrow, the force you apply to the handles is much less than the weight of the load and the wheelbarrow. To lift with the least force, you put the load toward the...
Study smarter with the SolutionInn App