The following office building is 100,000 gross sq.ft. The rental space is 96,000 sq.ft Chase Bank...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
The following office building is 100,000 gross sq.ft. The rental space is 96,000 sq.ft Chase Bank Occuples 70,000 sq.ft. Shapley Law Firm 10,000, sq.ft. and Securities Broker 16,000 sq. ft Lease term & remaining lease expenses.per sg. ft. are listed belaw. Determine the Net Operating Income. Lease Calculations: Given Lease Data, Solve for NOI Spreadsheet Assumption: Elve year holding.perlod. Vacancy does not take effect until the beginning of year 4. Input Data: $15.00 100,000 s.t. 96,000 s.f. Current Market Rent Giross square feet of building Net rentable square feet of building Management costs Estimated increase in CPI Vacancy rate starting year 4 Selling expenses 5.00% of EGI 4.00% per year 5.00% per year 5% 3 $16.00 Year Market Rent Projection $15.00 $15.50 $16.75 $17.50 $18.00 Increase In rent on lease renewal Chase Bank Shapely Law firm Securities Broker $2.75 $3.00 $3.00 SUMMARY LEASE INFORMATION Current Sq. t. Remaining term (yrs) Tenant Rent Current per s.f Rent Shapely Law firm Securities Broker $3.00 SUMMARY LEASE INFORMATION Current Sq. ft. Rent per s.f. Current Remaining term (yrs) Tenant Rent $14.00 $0 Chase Bank Shapely Law Firm Securities Broker $14.50 4. Q. $15.00 Total Summary of Expense Information Dollars persf. $1.55 0.15 2.00% per year 4.00% per year 5.00% per year 3.00% per year $148,800 increase Property tax Insurance Utilities Janitorial Maintenance Subtotal (before mgt) 14,400 increase 1.25 increase 120,000 76,800 0.80 increase 0.70 increase 3.00% per year 67.200. 427,200 4.45 (before management expenses) Management $0. 0.00 5.00% of EGI Total $427,200 $4.45 Summary of Expense Information Dollars per s.f. $1.55 Property tax Insurance Utilities Janitorial Maintenance Subtotal (before mgt) $148,800 2.00% per year 4.00% per year 5.00% per year 3.00% per year 3.00% per year increase 14,400 0.15 increase 120,000 1.25 increase 76,800 0.80 increase 67.200 427,200 0.70 increase 4.45 (before management expenses) Management $0. 0.00 5.00% of EGI Total $427,200 $4.45 PROJECTED BASE INCOME Year 3. 6. Bank Law firm 0. 0. Broker 0. Potential Gross Income Vacancy Effective Gross Income 0. 0. 0. 2. The following office building is 100,000 gross sq.ft. The rental space is 96,000 sq.ft Chase Bank Occuples 70,000 sq.ft. Shapley Law Firm 10,000, sq.ft. and Securities Broker 16,000 sq. ft Lease term & remaining lease expenses.per sg. ft. are listed belaw. Determine the Net Operating Income. Lease Calculations: Given Lease Data, Solve for NOI Spreadsheet Assumption: Elve year holding.perlod. Vacancy does not take effect until the beginning of year 4. Input Data: $15.00 100,000 s.t. 96,000 s.f. Current Market Rent Giross square feet of building Net rentable square feet of building Management costs Estimated increase in CPI Vacancy rate starting year 4 Selling expenses 5.00% of EGI 4.00% per year 5.00% per year 5% 3 $16.00 Year Market Rent Projection $15.00 $15.50 $16.75 $17.50 $18.00 Increase In rent on lease renewal Chase Bank Shapely Law firm Securities Broker $2.75 $3.00 $3.00 SUMMARY LEASE INFORMATION Current Sq. t. Remaining term (yrs) Tenant Rent Current per s.f Rent Shapely Law firm Securities Broker $3.00 SUMMARY LEASE INFORMATION Current Sq. ft. Rent per s.f. Current Remaining term (yrs) Tenant Rent $14.00 $0 Chase Bank Shapely Law Firm Securities Broker $14.50 4. Q. $15.00 Total Summary of Expense Information Dollars persf. $1.55 0.15 2.00% per year 4.00% per year 5.00% per year 3.00% per year $148,800 increase Property tax Insurance Utilities Janitorial Maintenance Subtotal (before mgt) 14,400 increase 1.25 increase 120,000 76,800 0.80 increase 0.70 increase 3.00% per year 67.200. 427,200 4.45 (before management expenses) Management $0. 0.00 5.00% of EGI Total $427,200 $4.45 Summary of Expense Information Dollars per s.f. $1.55 Property tax Insurance Utilities Janitorial Maintenance Subtotal (before mgt) $148,800 2.00% per year 4.00% per year 5.00% per year 3.00% per year 3.00% per year increase 14,400 0.15 increase 120,000 1.25 increase 76,800 0.80 increase 67.200 427,200 0.70 increase 4.45 (before management expenses) Management $0. 0.00 5.00% of EGI Total $427,200 $4.45 PROJECTED BASE INCOME Year 3. 6. Bank Law firm 0. 0. Broker 0. Potential Gross Income Vacancy Effective Gross Income 0. 0. 0. 2.
Expert Answer:
Answer rating: 100% (QA)
Net Rentable Area Sqft 96000 Chase Bank 70000 Shapely Law Firm 10000 Securities Broker 16000 Project... View the full answer
Related Book For
Managerial accounting
ISBN: 9780073526706
12th Edition
Authors: Ray H. Garrison, Eric W. Noreen, Peter C. Brewer
Posted Date:
Students also viewed these accounting questions
-
Firm S plans to sell an office building via an English auction. The firm expects two buyers to bid, each with a value uniformly distributed between $300,000 and $360,000. In addition, firm S knows it...
-
Does a "follow-up reminder" increase the renewal rate on a magazine subscription? A magazine sent out 760 subscription renewal notices (without a reminder) and got 703 renewals. As an experiment,...
-
The data relating the square feet of living space and the selling price of 12 residential properties given in Example 3.5 are reproduced here. First, find the best-fitting line that describes these...
-
Explain why the economic order quantity is the intersection of the ordering-cost curve and the carrying-cost curve.
-
Vanderbilt Clothing Company placed a clothing order with a company located in Taiwan. The order was placed on November 1, 2008, for delivery on May 1, 2009. Vanderbilt agreed to pay for the goods on...
-
Combine the terms into a single fraction, but do not rationalize the denominators. 2x +
-
Assuming that the necessary assumptions are met, construct a 95\% confidence interval for \(ho\) when (a) \(r=0.78\) and \(n=15\); (b) \(r=-0.62\) and \(n=32\); (c) \(r=0.17\) and \(n=35\).
-
On January 1, 2015, Eddy Corporation had retained earnings of $650,000. During the year, Eddy had the following selected transactions. 1. Declared cash dividends $120,000. 2. Corrected overstatement...
-
Data for Hermann Corporation are shown below: Selling price Variable expenses Contribution margin Per Unit Percent of Sales $ 110 77 100% 70 $ 33 30% Fixed expenses are $82,000 per month and the...
-
1. Using the spreadsheet model from Case 2.1 as a starting point, use Solver to find the optimal set of projects to approve. The solution should maximize the total NPV from the approved projects, and...
-
A company books $100 million in revenue for fiscal year 2015, the most it has ever earned. However, the company earns a far lower profit than it did the previous year. What could explain this...
-
How is bond insurance priced?
-
How would the values of voting and nonvoting stock differ?
-
Are there any conflicts that might arise between the issuer and the investment banker when setting the offering price on a stock issue?
-
Describe the net present social value model of capital budgeting.
-
Identify the differences in the approach to shareholder value of Unilever and 3G Capital, a Brazilian-led private equity firm. Why do you think these differences may have led to the failed takeover...
-
AGL Electronics Inc. AGL Electronics Inc. (AGL) manufactures DX drones for niche clients in the entertainment industry. The drones it currently builds have basic features with a few add-ons. They...
-
The figure shows a bolted lap joint that uses SAE grade 8 bolts. The members are made of cold-drawn AISI 1040 steel. Find the safe tensile shear load F that can be applied to this connection if the...
-
Data concerning a recent periods activity in the Mixing Department, the first processing department in a company that uses process costing, appear below: A total of 8,000 units were completed and...
-
How are service department costs allocated to other departments under the step-down method?
-
What is meant by the term management by exception?
-
An article in the Wall Street Journal stated that Chinas treatment of American know-how has been a central issue to U.S.-China trade tensions over the past five years. a. What does the article mean...
-
Indonesia produces about 60 percent of the worlds palm oil. Palm oil is used in the production of shampoo, ice cream, and chocolate. Assume that Switzerland does not produce palm oil but companies in...
-
An opinion column in the Wall Street Journal argued that Americans enjoy comparative advantages in [service] sectors such as construction and engineering, but global trade in services is weighed down...
Study smarter with the SolutionInn App