I am taking a graduate course in SAS but I didn't take SAS in undergrad! I have the following project but the obstacle I have is that I don't know where to start from !!! I have excel file attached too! Securitizations are tools providing alternative investment opportunities to investors. Mortgage-back securitization (MBS) is one of the most popular instruments. It allows investors to invest in mortgage loans that are traditionally available to banks and financial institutions only. In this assignment, you will use SAS to model cash inflows/outflows of a simple MBS. The model is to project the future cash collection from mortgage loans based on different default risk assumptions and then allocates cash available to MBS certificate holders. The model will allow you to estimate riskreturn to investors under different default scenario. Suppose a MBS invests in a pool of mortgage loans that has the following characteristics: Aggregate beginning balance of the mortgage loans $50 million Weighted average of coupon rate 6% per annum Weighted average maturity 360 months The MBS issues three classes of certificates with the following balance and coupon rate. Certificate Beginning Balance Annual Fixed Coupon Rate A $25 million 5% B $20 million 7% C $ 4 million 9% For simplicity, we assume that a. The mortgage loan pool may default at a 3% annual rate, on average. For loans that default, MBS does not receive any cash (100% severity rate) and the mortgage loan pool will immediately be written down by the default amount (before any calculation). b. Monthly coupons paid to certificate holders are fixed and do not change over the life of the loans. c. However, the actual amounts paid to certificate holders depend on whether there is enough cash to distribute to the certificate holder. If the cash collected from the mortgage pool outweighs the cash payouts to certificate holders, the excess cash will be kept in reserve account. On the other hand, if the cash collection (plus any reserve available) is less than the required cash payouts to certificate holders, the junior certificate holders may not receive any payment. Certificate C is more junior than B and B is more junior than A. d. Any portion of payment that cannot be made due to insufficient fund will be recorded as unrecoverable losses.
... View more