mbscpr(wac;wam;factor1;factor2;months)
Returns the conditional prepayment rate (CPR).
Syntax
mbscpr(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 CPR for the period.
The
mbscpr(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
monthsis 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.