Assumptions: Rent Roll Tenant Name Und Type OS % Total LA Lone Start Lose End Type Per PSF 7500 100% 10/01/03 09/30/23 Mod Gross $16.00 1.500 120% 08/01/07 05/31/22 Mod Gross' $24.00 1,000 B0% 03/01/17 02/28/22 Mod Gross $24.00 1,500 120% 08/01/10 07/31/20 Mod Gross $22.40 1,000 B0% 05/01/18 04/30/21 Mod Gross $24.00 12.500 100.0% $19.01 Sherwin Williams Keller Williams Domino's Nail Salon Total coupled Avg Total Current Remaining Monthly Amu Monthly Amul Amal Lange Renewal Rent Pert CAM CAM Pero TermYra) Opions $10,000 $120,000 $1,000 $12,000 $132.000 20 3-5yr $3,000 $38.000 $350 84200 $40.200 15 1-5 y $2.000 $24.000 $300 $3,000 $27,600 5 $2.000 $33.600 $350 $4,200 $37,800 10 2-5 yr $2.000 $94.000 $300 $3,600 $27.600 3 23 y 519,800 $237,600 $2,300 $27.000 $265.200 25 5% market vacancy 40% Expense Ratio 6.50085721177% mortgage constant (4.25% interest rate, and 25 year amortization) 5.50% Investor's ROE Questions: 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. Assumptions: Rent Roll Tenant Name Und Type OS % Total LA Lone Start Lose End Type Per PSF 7500 100% 10/01/03 09/30/23 Mod Gross $16.00 1.500 120% 08/01/07 05/31/22 Mod Gross' $24.00 1,000 B0% 03/01/17 02/28/22 Mod Gross $24.00 1,500 120% 08/01/10 07/31/20 Mod Gross $22.40 1,000 B0% 05/01/18 04/30/21 Mod Gross $24.00 12.500 100.0% $19.01 Sherwin Williams Keller Williams Domino's Nail Salon Total coupled Avg Total Current Remaining Monthly Amu Monthly Amul Amal Lange Renewal Rent Pert CAM CAM Pero TermYra) Opions $10,000 $120,000 $1,000 $12,000 $132.000 20 3-5yr $3,000 $38.000 $350 84200 $40.200 15 1-5 y $2.000 $24.000 $300 $3,000 $27,600 5 $2.000 $33.600 $350 $4,200 $37,800 10 2-5 yr $2.000 $94.000 $300 $3,600 $27.600 3 23 y 519,800 $237,600 $2,300 $27.000 $265.200 25 5% market vacancy 40% Expense Ratio 6.50085721177% mortgage constant (4.25% interest rate, and 25 year amortization) 5.50% Investor's ROE Questions: 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
