1.

2.

I need the excel formulas.

eYe Using a Spreadsheet to Calculate Mortgage Payments: What is the monthly payment on a $150,000, 15-year mortgage if the mortgage rate is 5.75 percent? 6.25 percent? 7.5 percent? 9 percent? (LG 7-4) Periods Interest 1512 5.75%/12 1512 6.25%/12 1512 7.50%/12 1512 9.00%/12 The Payment Present Value Will Be $150,000 150,000 150.000 150,000 $1,245.62 1,286.13 1,390.52 1,521.40