Given the following data and rent roll, project the NOI of the building for the years...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Given the following data and rent roll, project the NOI of the building for the years 2021, 2022 and 2023. Please make your calculations to the right of the data and rent roll on this worksheet. Upload your file onto Moodle by the deadline indicated on the course outline. note: It is aniticipated that this lease will not be renewed. The unit will be vacant for 2 months. The new lease will have a free rent period of 1 month and a base rent (gross) of $60/sq ft Projected inflation (CPI) Expenses for 2020 Property taxes Insurance Maintenance & operations Security Snow removal Utilities Depreciation Retail sales for Unit 1 in 2020 2021 2022 2023 1.0 % 2.0% 3.0% 600,000 50,000 300,000 75,000 35,000 350,000 50,000 2,000,000 RENT ROLL Floor 1 Unit number Space vocation Lease start Lease end Lease type Square footage Rent/sq ft Percentage factor Breakpoint Common Area Floor 2 Unit number Space vocation Lease start Lease end Lease type Square footage Rent/sq ft Unit number Space vocation Lease start Lease end- Lease type Square footage Rent/sq ft Common Area Floor 3 Unit number Space vocation Lease start Lease end Lease type Square footage Rent/sq ft Unit 1 Retail 2017-01-01 2026-12-31 Triple Net 23,000 2021 25 5% 500,000 2,000 Unit 2 Office 2017-01-01 2026-12-31 Gross 14,000 2021 50 Unit 3 Office 2017-06-01 2027-06-01 Triple Net 10,000 2021 21 1,000 Unit 4 Office 2015-01-01 2022-12-31 Gross 25,000 2021 50 2022 25 5% 510,000 2022 +CP1 2022 21 2022 50 2023 26 5% 520,000 2023 +CPI 2023 22 2023 NOTE 1 TOTAL LEASABLE TOTAL COMMON TOTAL BUILDING 72,000 3,000 75,000 Given the following data and rent roll, project the NOI of the building for the years 2021, 2022 and 2023. Please make your calculations to the right of the data and rent roll on this worksheet. Upload your file onto Moodle by the deadline indicated on the course outline. note: It is aniticipated that this lease will not be renewed. The unit will be vacant for 2 months. The new lease will have a free rent period of 1 month and a base rent (gross) of $60/sq ft Projected inflation (CPI) Expenses for 2020 Property taxes Insurance Maintenance & operations Security Snow removal Utilities Depreciation Retail sales for Unit 1 in 2020 2021 2022 2023 1.0 % 2.0% 3.0% 600,000 50,000 300,000 75,000 35,000 350,000 50,000 2,000,000 RENT ROLL Floor 1 Unit number Space vocation Lease start Lease end Lease type Square footage Rent/sq ft Percentage factor Breakpoint Common Area Floor 2 Unit number Space vocation Lease start Lease end Lease type Square footage Rent/sq ft Unit number Space vocation Lease start Lease end- Lease type Square footage Rent/sq ft Common Area Floor 3 Unit number Space vocation Lease start Lease end Lease type Square footage Rent/sq ft Unit 1 Retail 2017-01-01 2026-12-31 Triple Net 23,000 2021 25 5% 500,000 2,000 Unit 2 Office 2017-01-01 2026-12-31 Gross 14,000 2021 50 Unit 3 Office 2017-06-01 2027-06-01 Triple Net 10,000 2021 21 1,000 Unit 4 Office 2015-01-01 2022-12-31 Gross 25,000 2021 50 2022 25 5% 510,000 2022 +CP1 2022 21 2022 50 2023 26 5% 520,000 2023 +CPI 2023 22 2023 NOTE 1 TOTAL LEASABLE TOTAL COMMON TOTAL BUILDING 72,000 3,000 75,000
Expert Answer:
Answer rating: 100% (QA)
Question Expenses counted towards NOI 2019 2020 1510000 No CPI increase 1525100 1 CPI 2021 1447431 2 ... View the full answer
Related Book For
Posted Date:
Students also viewed these accounting questions
-
Given the following data set: 2.3, 1.0, 2.1, 6.5, 2.8, 8.8, 1.7, 2.9, 4.4, 5.1, 2.0 a. Find the positions of the lower and upper quartiles. b. Sort the data from smallest to largest and find the...
-
Given the following data for Alberts fabricating production area: Fixed costs for one shift .......= $60,000 Unit variable cost ............= $7 Selling price ....................= $12 Number of...
-
Given the following data set: 8, 7, 1, 4, 6, 6, 4, 5, 7, 6, 3, 0 a. Find the five-number summary and the IQR. b. Calculate and s. c. Calculate the z-score for the smallest and largest observations....
-
Using the adjustment data listed in P3-2 for San Mateo Health Care, indicate the effects of each adjustment on the liquidity metric Quick Assets and profitability metric Net Income - Accrual Basis....
-
Claire Russell is buying a car. Her November monthly interest was $210 at 7 % Interest. What is Claires principal balance (to the nearest dollar) at the beginning of November? Use 360 days. Do not...
-
Which model do you think is best suited to measure supply chain performance--the Balanced Scorecard or the SCOR? Why?
-
The November cash records of Stenback, Inc., follow: Stenbacks Cash account shows the balance of $6,172 on November 30. On November 30, Stenback received the following bank statement: Additional data...
-
At one time, Boeing closed a giant deal to acquire another manufacturer, McDonnell Douglas. Boeing paid for the acquisition by issuing shares of its own stock to the stockholders of McDonnell...
-
Consider f(x) = ln(2 x). Find (5) (0) without calculating the derivatives of . Use a calculator to find a numerical approximation of your final answer to 2 decimal places. For example, if your final...
-
Question A: Stay Safe International manufactures industrial safety equipment at its plant in Evans- ville, Indiana. The company has initiated DRP to coordinate finished goods distribution from the...
-
. If the age is greater and equal to 35, print: "able to do anything" and on next line print: "(How happy!)" Write a class called AgeMessages, which does the following: Ask the user to enter age...
-
1] The following information is available for Blasser Company. In preparation of the Statement of Cash Flows Net Income Depreciation Expense $187,500 $49,500 Loss on sale of equipment $3,000 Increase...
-
Revenue Cost of goods sold Gross margin Guatemala Ltd. Income Statement For the year ended December 31, 2022 Selling and admin expenses Wage expense Depreciation expense Interest expense Income...
-
Kirtland Corporation's accounting records showed the following at December 31: Transactions Beginning inventory, January 1 Units 480 Unit Cost $3.00 380 540 (240) 4.20 4.00 (780) Transactions during...
-
Frank is self - employed. In 2 0 2 3 , he had the following business meal expense: $ 2 , 0 0 0 spent for meals at restaurants with vendors and clients. How much of his meal expense can Frank deduct?...
-
With respect to the Ethernet frame: a . Show the frame format including the name, size ( in decimal ) , and the content ( in Hex ) of each field ( do not convert content to decimal or binary ) . ...
-
3 Why is NAT not needed in IPv6? > The problems that are induced by NAT applications are solved because the IPv6 header improves packet handling by intermediate routers > The end-to-end connectivity...
-
A company pledges their receivables so they may Multiple Choice Charge a factoring fee. Increase sales. Recognize a sale. Collect a pledge fee. Borrow money. Failure by a promissory notes' maker to...
-
Could the borrowing circle concept be easily adapted for use in the United States? a. Why or why not? b. What modifications would you suggest if it were to be adopted? c. Minorities in the United...
-
What are the qualities of the Internet that have put competitive pressures on businesses?
-
In most developing countries, there are long lines of taxis at airports, and these taxis often wait two or three hours. What does this tell you about the price in that market? Demonstrate with supply...
-
Founded in 1998, PAETEC Communications is a broadband telecommunications firm providing local and long-distance voice, data, and Internet services to business customers in over 80 markets in the...
-
In organizations like Merck & Co., the pharmaceuticals giant, and Microsoft Corporation, the leading producer of computer software, research scientists or computer programmers often work together in...
-
In 1994, Jeffrey Bezos, a computer science and electrical engineering graduate from Princeton University, was growing weary of working for a Wall Street investment bank. His computer science...
Study smarter with the SolutionInn App