Hello, everyone I am new to SAS programming

Ealyafei — Sat, 29 Jun 2019 23:49:21 GMT

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.

Re: Hello, everyone I am new to SAS programming

PaigeMiller — Sun, 30 Jun 2019 12:24:03 GMT

Can you please state the algorithm that is to be used to do these calculations?

We can't really provide any SAS help until we know the algorithm to be used.

Re: Hello, everyone I am new to SAS programming

echo-mite — Fri, 23 Jul 2021 18:25:21 GMT

Hi @Ealyafei were you ever able to figure this one out?

I have the same problem and seem to be getting stuck on it as well. Hoping you were able to figure it out and can point me in the right direction.

topic Hello, everyone I am new to SAS programming in New SAS User

Hello, everyone I am new to SAS programming

Re: Hello, everyone I am new to SAS programming

Re: Hello, everyone I am new to SAS programming