Transcribed Image Text
Amount financed = 240,000 - 91,088 = $148,912. This is Pv. Nper= 15 years*12 = 180 and rate = 4.5%/12 Amount paid each month =PMT(4.5%/12, 180, -148912) = 1139.07 find payment number 10-100.Payment no. Loan balance at the start of the month Amount ofpayment Interest Principal paid Loan balance at the end of themonth.6 145,986.41 1,139.17 547.45 591.72 145,394.697 145,394.69 1,139.17 545.23 593.94 144,800.758 144,800.75 1,139.17 543.00 596.16 144,204.599 144,204.59 1,139.17 540.77 598.40 143,606.1910 143,606.19 1,139.17 538.52 600.64 143,005.54