and the current bitance on the foen k$208,555,87. 72.285. The out-of pocket costs must te paid in full at the time of refinanche. Guls a spreadihert model to evaluate this oflec, the Excel function - Matrate, nuer, in, N, rope) calculates the poyment for a loan based en constant porments and a constant interes rate. The arguments of this function are as follows. tate - the wherest rate for the ban noper - the total number d payments aV = piesent value the smount borrosed? trpe = paraient trpe co end of pernod, i teginning of the pertad) (1+1)t1x 5