":PREC","2"," "," "
":FTAB","FinFuncs"," "," "
" ","100000 ","100000","Enter current mortgage balance"
"SPV"," ","100000"," "
" "," ","========"," "
" ","246 ","246","Enter remaining months to pay"
"SN"," ","246"," "
" "," ","========"," "
" ","7.5%","0.075","Enter current mortgage int rate"
"/","12 ","0.00625"," "
"SIN"," ","0.00625"," "
"FPM"," ","-797.14","Result: your current monthly payment (P&I only)"
" "," ","========"," "
" ","30","30","Enter number of years in new mortgage"
"*","12 ","360"," "
"SN"," ","360"," "
" "," ","========"," "
" ","6.75%","0.0675","Enter interest rate for new mortgage"
"/","12 ","0.005625"," "
"SIN"," ","0.005625"," "
"FPM"," ","-648.6","Result: monthly P&I for new mortgage"
" "," ","========"," "
" ","-797.14 [B10]","-797.14"," "
"-","-648.6 [B19]","-148.54"," "
"*","-1","148.54","Result: monthly improvement in cash flow"
" "," ","========"," "
" ","1500 ","1500","Enter estimated closing costs for new mortgage"
"/","148.54 [B23]","10.1","Result: # months to offset closing costs"