FIll in the highlighted areas in excel

Where it says $$Income Test$,$ compute the biggest mortgage payment Ann can make given her NOI in

$2015$ computed above.

Recall from slides $12$: NOI

PMT $>=1\mathrm{.}20,$ which implies the maximum PMT$=$ NOI$/1\mathrm{.}20$

$1\mathrm{.}20.$

$(2.$a$)$ What is the biggest mortgage payment the bank will allow Ann to make given her expected NOI in

$2015?$

Using the maximum payment, compute the maximum loan Ann can get.

Recall for an IO loan: PMT $=($Interest rate$)*($loan balance$)$

The interest rate is given in the spreadsheet. Use the PMT computed in $(2.$a$)$

$(2.$b$)$ What is the maximum loan amount corresponding to a DSCR of $1\mathrm{.}2?$

$(2.$c$)$ What is the biggest loan Ann can get with a $$1,400,000$ down payment and $95\%$ maximum LTV$?$

NOTE: you may use the formula Maximum Loan $=(($LTV$)/(1-$LTV$))*$Down payment.

$(2.$d$)$ Assume for the rest of the question that Ann will make a $$1,400,000$ down payment. How much

will Ann need to borrow?

$(2.$e$)$ What will Ann$$s annual debt service payment be$?$