List of Functions


Price, Yield, Duration and WAL -- fixed rate mortgages
mbsai accrued interest
mbscf generates table of payment components and factors
mbsdur modified duration
mbseconv effective convexity
mbsedur effective duration
mbsfact remaining balance (factor) for remaining term n
mbsint coupon interest component of nth monthly payment
mbsisp implied speed
mbspr price given yield, speed and speed type
mbspre prepayment component of nth monthly payment
mbssp implied CPR, PSA or FHA speed given price and yield
mbssprin scheduled principal component of nth monthly payment
mbstpay total monthly payment size
mbstprin total principal component, scheduled amortization plus prepayment of nth monthly payment
mbswal weighted average life
mbsyld cash flow yield given price, speed and speed type
mbszpr* price given Z-spread
mbszspread* Z-spread
*in beta test


Adjustable Rate Mortgage Functions
setarm Specify an ARM
armai accrued interest
armcf amortization table
armdm discount margin
armdur modified duration
armfact factor at the end of the nth flow
armint interest component of the nth flow
armpr price given yield
armpre prepayment component of the nth flow
armsprin anticipated scheduled principal component of the nth flow
armtpay nth total flow
armtprin anticipated total principal component of the nth flow
armwal weighted average life
armyld mortgage (cash flow) yield


The following prepayment types are supported:
  • constant prepayment rate (CPR)
  • Public Securities Association (PSA)
  • custom prepayment curve
  • FHA experience
  • n month
  • absolute prepayment rate

Prepayment Rate Conversion Functions
mbscpr constant prepayment rate from SMM
mbssmm single monthly mortality rate from CPR


MBS @nalyst also comes with TechHackers' date, business date, and conversion functions.