eMBS Home Securities Analytics Portfolios
About eMBS Site Map Customize Your Profile News Frequently Asked Questions  


|Products|Contact Us|Who We Are|Demo|

Back to Previous Page   Demonstration Tour  Next Page

Portfolio Mortgage Roll

While viewing your portfolio, you have the convenience of calculating a Mortgage Roll. The Mortgage Roll calculator pre-populates with some information from your portfolio. You can add to and alter this information before getting results.



Mortgage Roll Analysis



Roll Amount Product FHLG15
Coupon % Service Fee WAM

Roll In Date CPR %
Roll Out Date   Or


Effective Annual Rate 6.51 %    Days 30
Cash In $ 1,011,666.67 Cash Out $ 1,002,916.67
Spread $ 8,750.00 Total Financing Cost $ 5,489.01

Contribution to
Financing Cost
Foregone Income
PaymentGain
Interest(3,333.33)3,333.33
Scheduled Principal38.523,851.8238.52
Prepayment Principal33.833,382.9733.83
Price Spread8,750.00
Total Financing Cost5,489.01

Effective Annual Rates
Prepayment Rate
Drop0.002.004.006.008.00
26.0005.73 5.75 5.77 5.79 5.81
27.0006.10 6.12 6.14 6.16 6.18
28.0006.47 6.49 6.51 6.53 6.55
29.0006.84 6.86 6.88 6.90 6.92
30.0007.21 7.23 7.25 7.27 7.29

Matrix Settings
Prepay Increment % Number
Drop Increment /32 Number
OR Eff Rate Increment BP Number


Back to Previous Page   Demonstration Tour  Next Page