loan is $$208,555\mathrm{.}87.$ must be paid in full at the time of refinancing.

Build a spreadsheet model to evaluate this offer. The Excel function:

$=$PMT$($rate$,$ nper, pv$,$ fv$,$ type$)$

calculates the payment for a loan based on constant payments and a constant interest rate. The arguments of this function are: