Part One Directions Complete pro forma for NOI Commercial Complex Tenant Bank Retailer Office Office Utilities...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Part One Directions Complete pro forma for NOI Commercial Complex Tenant Bank Retailer Office Office Utilities Lease Type Taxes NNN OP EX Category Percentage 4 tenants Size Outparcel 3,125 9,600 4,375 Cost $3.25 per sq ft $11,627 per year Property will be held for 5 years Current Lease Rate $85,250/yr $4.50/ sq ft Plus 4.55% revenue $21.00/sq ft $22.50/ sq ft Rent Growth CAM 2.15% Tenant revenue is expected to grow at 2.5% per year Year 1 Revenues are $310,000 CPI CPI Growth Rate 2.85% per year 2.75% per year Limited to $2.75 per sq foot Pro rata on sq feet None Limited to $5.25 per sq foot Pro rata on sq feet Utilities Taxes Insurance Maintenance CPI Years 1-3 Years 4-7 Years 8-10 Going In Cap Rate Terminal Cap Rate Loan Interest Rate $3.25 per sq ft Max loan to value for debt $11,627 per year $2.75 per sq ft $3.15 per sq ft Part Two Questions: 1. Calculate The Max Debt for this property. 2. Calculate the amount of equity needed for this property. 3. Calculation the Net Sale Proceeds to Owner. Rate Required Debt Service Coverage 1.75% 2.25% 3.25% 6.25% 5.75% 3.35% 60% 1.42 2.85% per year 2.75% per year 2.0% per year 3.15% per year Going In Cap Rate Terminal Cap Rate Loan Interest Rate Max loan to value for debt Required Debt Service Coverage Discount Rate Loan Amortization Period Loan Term Loan Fees Cost of Sale 6.25% 5.75% 3.35% 60% 1.42 12% 20 years 7 years 2.0% 3% Make sure to show your work in the uploaded Excel file (be sure to show cash flows through BTCF). Part One Directions Complete pro forma for NOI Commercial Complex Tenant Bank Retailer Office Office Utilities Lease Type Taxes NNN OP EX Category Percentage 4 tenants Size Outparcel 3,125 9,600 4,375 Cost $3.25 per sq ft $11,627 per year Property will be held for 5 years Current Lease Rate $85,250/yr $4.50/ sq ft Plus 4.55% revenue $21.00/sq ft $22.50/ sq ft Rent Growth CAM 2.15% Tenant revenue is expected to grow at 2.5% per year Year 1 Revenues are $310,000 CPI CPI Growth Rate 2.85% per year 2.75% per year Limited to $2.75 per sq foot Pro rata on sq feet None Limited to $5.25 per sq foot Pro rata on sq feet Utilities Taxes Insurance Maintenance CPI Years 1-3 Years 4-7 Years 8-10 Going In Cap Rate Terminal Cap Rate Loan Interest Rate $3.25 per sq ft Max loan to value for debt $11,627 per year $2.75 per sq ft $3.15 per sq ft Part Two Questions: 1. Calculate The Max Debt for this property. 2. Calculate the amount of equity needed for this property. 3. Calculation the Net Sale Proceeds to Owner. Rate Required Debt Service Coverage 1.75% 2.25% 3.25% 6.25% 5.75% 3.35% 60% 1.42 2.85% per year 2.75% per year 2.0% per year 3.15% per year Going In Cap Rate Terminal Cap Rate Loan Interest Rate Max loan to value for debt Required Debt Service Coverage Discount Rate Loan Amortization Period Loan Term Loan Fees Cost of Sale 6.25% 5.75% 3.35% 60% 1.42 12% 20 years 7 years 2.0% 3% Make sure to show your work in the uploaded Excel file (be sure to show cash flows through BTCF).
Expert Answer:
Answer rating: 100% (QA)
SOLUTION Part One Pro Forma for NOI To calculate the net operating income NOI for the commercial complex we need to estimate the revenues and expenses for each tenant as well as the operating expenses ... View the full answer
Posted Date:
Students also viewed these accounting questions
-
Wheels, Inc. manufactures bicycles sold through retail bicycle shops in the southeastern United States. The company has two salespeople that do more than just sell the products - they manage...
-
Current Assets 2000 2001 Cash 200 1 000 Accounts receivable 1 600 1 000 Inventory 2 200 2 600 TOTAL CURRENT ASSETS 4 000 4 600 Gross Fixed Assets 12 000 12 400 Less Accum Depreciation 6 000
-
Use the Second Order Runge-Kutta Method to solve for x and y from t = 0 to t=0.5s with step At = 0.1s: (x'= 13.1x 13.94x y' = 1.71x With x(0) = 0.03 and y(0) = 0.
-
After dating for over a year, Jack asked Jill to move in with him and gave her a key to his apartment. Shortly after Jill moved in, Jack and Jill got into an argument, and Jill moved out. Jack,...
-
The 2013 income statement and other information for Mallard Corporation, which is about to purchase a new machine at a cost of $500 and a new computer system at a cost of $300, follows. Sales...
-
Explain the problems associated with questionable executive compensation schemes.
-
Explain how corporate performance is affected by employee motivation and goal congruence.
-
Consider a sample comprised of firms that were targets of tender offers during the period 1978-1985. Conduct an analysis where the response variable represents the number of bids (Bids) received...
-
ANOTHER Students in a representative sample of 69 second-year students selected from a large university in England participated in a study of academic procrastination. Each student in the sample...
-
On January 1, 2019, Mocha Company purchased a machinery at a cost of P1,000,000. It is being depreciated using straight-line method over its estimated useful life of 10 years. At December 31, 2020,...
-
draw the graph of given f function under the given w complex equation Exercises W = (2+3) 2-2i W= 2 w=ez tv) X = } w= 2+2 1-2 w=e W=cosz w=siniz (O W = 2 w=e= 2 v) xy=d, w= Z vi) x+2x+y-6x=0 w=1/12/2...
-
3. Calculate the the fluid velocity in the smaller conduit (A - 20 in') for the fluid system shown. Clearly indicate the stagnation point in the sketch. (33 points) A = 20 in.2 Oil SG=0.86 N A = 50...
-
7. In fig. both ends of the mano meter open to the atmosphere. Estimate the -specific gravity of fluid X, if the specific gravity of the oil is 0.8.
-
2 . 3 9 6 0 2 . 3 9 6 0 A closed cylindrical tank filled with water has a hemispherical dome and is connected to an inverted piping system as shown in Fig. P 2 . 3 9 . 2 . 3 9 . The liquid in the top...
-
The 90 kN, 1-m-wide rectangular gate shown in figure below is hinged at A and leans against top edge at B making an angle of 45. The gate used to hold water from entering the tunnel. Determine...
-
9. The 200 kg, 5 m wide rectangular gate shown in figure is hind hinged at B and leans an angle of 45 against the floor making to the horizontal. The gate is to be from its lower edge by applying...
-
Absorption and Variable Casting Income Statements for Two Months and Analysis During the first month of operations ended July 31, Head Gear Inc. manufactured 6,400 hats, of which 5,200 were sold....
-
If the joint cost function for two products is C(x, y) = xy2 + 1 dollars (a) Find the marginal cost (function) with respect to x. (b) Find the marginal cost with respect to y.
-
What is the value of a call option if the underlying stock price is $20, the strike price is $22, the underlying stock volatility is 50 percent, and the risk-free rate is 4 percent? Assume the option...
-
Assume Polands currency (the zloty) is worth $.17 and the Japanese yen is worth $.008. What is the cross rate of the zloty with respect to yen? That is, how many yen equal a zloty?
-
Utah Banks bid price for Canadian dollars is $.7938 and its ask price is $.81. What is the bid/ask percentage spread?
Study smarter with the SolutionInn App