Waiting for answer This question has not been answered yet. You can hire a professional tutor to get the answer.
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.