INFORMATION: TOTAL OPERATING EXPENSES:

NOI=10,347,756. Market Value 164,247,009. LTV=80%. DCR (debt service coverage ratio)= 1.20. company may approve up tp $40 million of equity from teh cash reserves to acquire this property. the rest will be from an external loan. 30 years (montly payments) at an annual interest rate of 5.6% calculate the followng using excel formulas only:

LTV Method:

LTV ??

Value ??

Maximum Loan using LTV method= ??

now, use the DCR method:

NOI?

DCR?

Maximum allowed debt service ??

Maximum allowed montly payment?

now, for the mortgage loan:

pmt?

N?

I= 5.6%/12=??

PV=max loan using DCR method=??

FV=0

amount to be approved=??

annual debt service:

monthly mortage payment=??

ADS=??