Constraining Factor:The criterion is the stringent one in which the loan amount cannot exceed $$.$Amortization Table $($Years $110)$:Monthly Payment: $$13,180$Interest Rate: $6\%$ annually $(0\mathrm{.}5\%$ monthly$)$Principal Paid in Years : When using SUM, perform the computation of the total principal that has to be paid.Remaining Balance at Year : Perform VLOOKUP to know the balance after months.Loan size is limited by LTV since its allowable amount is lower than those of DSCR and Debt Yield.