memo

unit Create a 300 word memo answering these questions, using this spreadsheet:

- The number of residential mortgages in the portfolio and the range of principal values, interest rates, and maturities

- The residential mortgage portfolio’s WAC and WAM

- A discussion of the WAC of the pass-through MBS the group has created and whether it represents a coupon rate indicative of a high credit quality or a lower credit quality pool of mortgages. Include in the discussion the MBS issue’s spread over the comparable Treasury rate.

- Include in your analysis at least 1 outside source for the Treasury rate.