Description Appraised Value Senior Loan Amount Senior Loan Lender Type Senior Loan Rate Senior Loan Term...

Transcribed Image Text:

Description Appraised Value Senior Loan Amount Senior Loan Lender Type Senior Loan Rate Senior Loan Term Senior Loan Amortization Mezzanine Debt Amount Mezzanine Debt Rate Mezzanine Debt Term Mezzanine Debt Amortization Net Operating Income A 300 room full-service *independent urban hotel in primary market $120,000,000 $78,000,000 Insurance Company + Mezzanine limited-service franchised suburban hotel in a secondary market A 60 seat fast-casual restaurant in a strip mall in a suburban market suburban event venue with 15K total sq ft of meeting space including 6K sq ft ballroom 10 $19,000,000 $13,300,000 $1,300,000 $2,200,000 $1,105,000 $1,320,000 Credit Union CMBS SBA Bank Loan + Bridge Loan 5.35% 6.20% 5.26% 5.87% 10 7 12 30 25 25 30 $12,000,000 $330,000 9.90% 8.50% 10 3 30 3 $128,000 $230,000 $7,850,000 $1,380,000 Question 1: Calculate the annual payment of both the senior and mezzanine debt below. Include a breakdown of interest and principal for the first year. Assume that interest is compounded annually. (5 pts) 6 Senior Loan Payment Senior Loan 1st Year Interest Payment Senior Loan 1st Year Principal Payment Mezanine Debt Payment Mezanine Debt 1st Year Interest Payment Mezanine Debt 1st Year Principal Payment 2 Total Debt Payments 3 Total 1st Year Interest Payments 4 Total 1st Year Principal Payment 6 Question 1 0% Correct Investment 1 Investment 2 Investment 3 Investment 4 Description Appraised Value Senior Loan Amount Senior Loan Lender Type Senior Loan Rate Senior Loan Term Senior Loan Amortization Mezzanine Debt Amount Mezzanine Debt Rate Mezzanine Debt Term Mezzanine Debt Amortization Net Operating Income A 300 room full-service *independent urban hotel in primary market $120,000,000 $78,000,000 Insurance Company + Mezzanine limited-service franchised suburban hotel in a secondary market A 60 seat fast-casual restaurant in a strip mall in a suburban market suburban event venue with 15K total sq ft of meeting space including 6K sq ft ballroom 10 $19,000,000 $13,300,000 $1,300,000 $2,200,000 $1,105,000 $1,320,000 Credit Union CMBS SBA Bank Loan + Bridge Loan 5.35% 6.20% 5.26% 5.87% 10 7 12 30 25 25 30 $12,000,000 $330,000 9.90% 8.50% 10 3 30 3 $128,000 $230,000 $7,850,000 $1,380,000 Question 1: Calculate the annual payment of both the senior and mezzanine debt below. Include a breakdown of interest and principal for the first year. Assume that interest is compounded annually. (5 pts) 6 Senior Loan Payment Senior Loan 1st Year Interest Payment Senior Loan 1st Year Principal Payment Mezanine Debt Payment Mezanine Debt 1st Year Interest Payment Mezanine Debt 1st Year Principal Payment 2 Total Debt Payments 3 Total 1st Year Interest Payments 4 Total 1st Year Principal Payment 6 Question 1 0% Correct Investment 1 Investment 2 Investment 3 Investment 4