Borrower info: Income (annual) Income (monthly) Green text represent inputs IMaximum PMT given FE DTI limit Monthly debt (average) Purple text represent IMaximum PMT given both FE \& BE DTI limits Monthly Taxes + Insurance outputs Maximum loan given FE \& BE DTI limits Down Payment Maximum loan given LTV limit and down-payment Maximum loan given income & collateral tests Loan terms: Maximum payment given income \& collateral tests Annual Interest Rate How much house can Ann afford? Periodic Interest Rate Total Mortgage Costs maximum FE monthly DTI maximum BE monthly DTI maximum LTV maximum loan/DP Mortgage Closing Costs Mortgage Buydown Points 1.75% Term (years) Payments per year Total Number of Payments Balloon \begin{tabular}{r} 30 \\ 12 \\ \hline 360 \\ 0 \end{tabular}