Rent Roll Tenant Name/Unit Type CVS Sherwin Williams Keller Williams Domino's Nail Salon Total Occupied/Avg 5%...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Rent Roll Tenant Name/Unit Type CVS Sherwin Williams Keller Williams Domino's Nail Salon Total Occupied/Avg 5% market vacancy 5.50% Investor's ROE SF 7,500 Questions: 1,500 1,000 % Total GLA Lease Start 60.0% 10/01/03 12.0% 06/01/07 8.0% 03/01/17 12.0% 08/01/10 8.0% 05/01/18 1,500 1,000 12,500 100.0% Lease End Type 09/30/23 Mod Gross 05/31/22 Mod Gross 02/28/22 Mod Gross 07/31/20 Mod Gross 04/30/21 Mod Gross 40% Expense Ratio T 6.50085721177% mortgage constant (4.25% interest rate, and 25 year amortization) Renewal Options 3-5yr Total Current Remaining Monthly Annual Monthly Annual Annual Lease Rent PSF Rent Rent CAM CAM Revnue Term (Yrs) $16.00 $10,000 $120,000 $1,000 $12,000 $132,000 20 $24.00 $3,000 $36,000 $350 $4,200 $40,200 15 $24.00 $2,000 $24,000 $300 $3,600 $27,600 5 $22.40 $2,800 $33,600 $350 $4,200 $37,800 10 $24.00 $2,000 $24,000 $300 $3,600 $27,600 3 $19.01 $19,800 $237,600 $2,300 $27,600 $265,200 1-5 yr 2-5yr 2-5 yr 2-3 yr 1. What is the NOI? 2. What is the CAP rate that should be used assuming a 75% LTV? 3. What is the value of the property using the CAP you calculated in #2? 4. What is the maximum loan amount (round it to the nearest hundred thousand) you would propose to maintain a 75% LTV? 5. Using a 4.25% interest rate, 10 year term and 25 year amortization for the loan amount in #4 above; what is the monthly payment? What is the annual payment? 6. What is the DSCR? 7. What is the Debt Yield? 8. What is the value per square foot? 9. What is the break-even occupancy? 10. Please provide 3-5 reasons to either do this loan or not do this loan. Rent Roll Tenant Name/Unit Type CVS Sherwin Williams Keller Williams Domino's Nail Salon Total Occupied/Avg 5% market vacancy 5.50% Investor's ROE SF 7,500 Questions: 1,500 1,000 % Total GLA Lease Start 60.0% 10/01/03 12.0% 06/01/07 8.0% 03/01/17 12.0% 08/01/10 8.0% 05/01/18 1,500 1,000 12,500 100.0% Lease End Type 09/30/23 Mod Gross 05/31/22 Mod Gross 02/28/22 Mod Gross 07/31/20 Mod Gross 04/30/21 Mod Gross 40% Expense Ratio T 6.50085721177% mortgage constant (4.25% interest rate, and 25 year amortization) Renewal Options 3-5yr Total Current Remaining Monthly Annual Monthly Annual Annual Lease Rent PSF Rent Rent CAM CAM Revnue Term (Yrs) $16.00 $10,000 $120,000 $1,000 $12,000 $132,000 20 $24.00 $3,000 $36,000 $350 $4,200 $40,200 15 $24.00 $2,000 $24,000 $300 $3,600 $27,600 5 $22.40 $2,800 $33,600 $350 $4,200 $37,800 10 $24.00 $2,000 $24,000 $300 $3,600 $27,600 3 $19.01 $19,800 $237,600 $2,300 $27,600 $265,200 1-5 yr 2-5yr 2-5 yr 2-3 yr 1. What is the NOI? 2. What is the CAP rate that should be used assuming a 75% LTV? 3. What is the value of the property using the CAP you calculated in #2? 4. What is the maximum loan amount (round it to the nearest hundred thousand) you would propose to maintain a 75% LTV? 5. Using a 4.25% interest rate, 10 year term and 25 year amortization for the loan amount in #4 above; what is the monthly payment? What is the annual payment? 6. What is the DSCR? 7. What is the Debt Yield? 8. What is the value per square foot? 9. What is the break-even occupancy? 10. Please provide 3-5 reasons to either do this loan or not do this loan.
Expert Answer:
Answer rating: 100% (QA)
To answer the questions well first need to calculate some intermediate values based on the provided data 1 Net Operating Income NOI NOI Total Annual Revenue Total Operating Expenses From the provided ... View the full answer
Related Book For
Real Estate Finance and Investments
ISBN: 978-0073377339
14th edition
Authors: William Brueggeman, Jeffrey Fisher
Posted Date:
Students also viewed these finance questions
-
The philanthropic organization in Exercise 21 expects about a 5% success rate when they send fundraising letters to the people on their mailing list. In Exercise 21 you looked at the histograms...
-
The following additional information is available for the Dr. Ivan and Irene Incisor family from Chapters 1-6. On December 12, Irene purchased the building where her store is located. She paid...
-
In a small country near the Baltic Sea, there are only three commodities: potatoes, meatballs, and jam. Prices have been remarkably stable for the last 50 years or so. Potatoes cost 2 crowns per sack...
-
Sinclair Oil & Gas, a large energy conglomerate, jointly processes purchased hydrocarbons to generate three nonsalable intermediate products: ICR8, ING4, and XGE3. These intermediate products are...
-
How are double and triple integrals in rectangular coordinates used to calculate volumes, average values, masses, moments, and centers of mass? Give examples.
-
Explain several implications of IFRS on financial reporting by health care organizations.
-
Baden Corporation entered into a lease agreement for 10 photocopy machines for its corporate headquarters. The lease agreement qualifies as an operating lease in all terms except there is a...
-
2. 2. A 20 kg child climbs to the top of a slide that is 3 m above the ground level. She starts from rest and slides down the incline. a. Define and model the energy of the system with Energy Bar...
-
Carrie D'Lake, Reed A. Green, and Doug A. Divot share a passion for golf and decide to go into the golf club manufacturing business together. On January 2, 2015, D'Lake, Green, and Divot form the...
-
A radar system transmits the pulse p(t) given below. The radar receiver/detector is based on an LTI system with impulse response defined by h(t) = p(T-t). a. Draw h(t) = p(T-t), the impulse response...
-
Identify the opportunities available to the company Obtain all the pertinent information Estimate the cost (based on the information you have) for the annual costs (you may have to do some additional...
-
...... 6.5.....4......3.......2.. Page 1 of 5 W AutoSave Off CS160Project3 (1) Protected View Saved to this PC File Home Insert Draw Design Layout References Mailings O Search (Alt+Q) Review View...
-
7) What is the output of the following snippet of code? myDict = { 'George': 4, 'Jean': 2, 'Paul': 10, 'Andrew': 18, 'Jacob': 8} myDict['Steve'] = 12 to Remove = ['George', 'Paul', 'Jacob'] for elt...
-
A cellular telephone receiver front-end circuit is shown below. The operating frequency is 1805-1880 MHz, and the physical temperature of the system is 300 K. A noise source with N; -95 dBm is...
-
"The concept of working capital is, perhaps, one of the most misunderstood issues in the literature of finance". Critically discuss this statement in respect of what you understand. by working...
-
Choose the correct option 2x dx =4 + (- x - 4 A. 6 In 2 B. -8 In 2 C. 12 In 2 D. -4 In 2
-
Consider the discrete group G of order 8 that has the following Cayley diagram e If we have the sequence of operations: fcagec, which of the options represents the reduction of the sequence to a...
-
An expected inflation premium is said to be part of the interest rate, what does this mean?
-
How does the use of scenarios differ from sensitivity analysis ?
-
A loan with the following terms is being made: Fixed rate, constant monthly payment. Closing date February 9th. 9% interest rate. Prepaid interest due at closing. $70,000 mortgage loan amount. $1,500...
-
Salen Company finances some of its current operations by assigning accounts receivable to a finance company. On July 1, 2015, it assigned, under guarantee, specific accounts amounting to 150,000,000....
-
Bill Jovi is reviewing the cash accounting for Nottleman, Inc., a local mailing service. Jovis review will focus on the petty cash account and the bank reconciliation for the month ended May 31,...
-
On October 1, 2015, Arden Farm Equipment Company sold a pecan-harvesting machine to Valco Brothers Farm, Inc. In lieu of a cash payment Valco Brothers Farm gave Arden a 2-year, $120,000, 8% note (a...
Study smarter with the SolutionInn App