using excel formulas.

Loan Amortization Table House Value % Financed APR (monthly) No of Years 380,000.00 75% 4.75% 30 No of Payments Monthly Interest Rate Payment Amount 360 0.40% $1,486.69 Home Loan Amount 285,000.00 Principal Payment Payment No Begining Balance Scheduled Payment Interest Er 285,000.00 284,641.43 283,154.74 281,668.04 280,181.35 278,694.65 $1,486.69 $1,486.69 $1,486.69 $1,486.69 $1,486.69 $1,486.69 $1,128.13 $1,126.71 $1,120.82 $1,114.94 $1,109.05 $1,103.17 5358.57s 5359.99S 5365.87 S $371.76 s 5377.64 S $383.53 5 2 S 4 ..Scenario 1 BankA Scenario 1 Bank B Scenario 2 Bank A Scenario 2 Bank E