Please help!

ork Problems A few years back, Dave and Jana bought a new home. They borrowed $230,415 at an annual fixed rate of 5.49% (15-year term) with monthly payments of $1,881.46. They just made their twenty-fifth payment and the current balance on the loan is $208,555.87 Build a spreadsheet model to evaluate this offer. The Excel function: -PMT (rate, nper, pv, fv, type) nper the total number of payments Note that since payments are made monthly, the annual interest rate must be expressed as a monthly rate. Also, for payment payment is made at the end of the month. pay off the loan In 13 years ork Problems A few years back, Dave and Jana bought a new home. They borrowed $230,415 at an annual fixed rate of 5.49% (15-year term) with monthly payments of $1,881.46. They just made their twenty-fifth payment and the current balance on the loan is $208,555.87 Build a spreadsheet model to evaluate this offer. The Excel function: -PMT (rate, nper, pv, fv, type) nper the total number of payments Note that since payments are made monthly, the annual interest rate must be expressed as a monthly rate. Also, for payment payment is made at the end of the month. pay off the loan In 13 years