mbssmm(wac;wam;factor1;factor2;months)

Returns the single monthly mortality (SMM). This is the MBS prepayment rate.

Syntax

mbssmm(wac;wam;factor1;factor2;months)

Input

Argument Type Description
wac integer or decimal The weighted average coupon (WAC) of the underlying mortgages, expressed as a percentage

A scalar value or the name of a column

wam integer the weighted average remaining term (in months) of the underlying mortgages

A scalar value or the name of a column

factor1 integer or decimal The earlier factor

A scalar value or the name of a column

factor2 integer or decimal The later factor

A scalar value or the name of a column

months integer The number of months between the two factors.

A scalar value or the name of a column

Note: One of the arguments must reference a column.

Return Value

Returns the average SMM for the period.

The mbssmm(wac;wam;factor1;factor2;months) function handles N/A values as follows:
  • If any argument is N/A, the result is N/A.
  • The result is also N/A if months is greater than or equal to the remaining term (wam).
Note: 1010data has not audited these computations and takes no responsibility for their accuracy or precision. Please do not use the result of this function to trade securities without independently verifying the result.