Question
As an assistant vice president at a regional bank, your boss has tasked you and the other AVPs to work in a group to acquire
As an assistant vice president at a regional bank, your boss has tasked you and the other AVPs to work in a group to acquire $100 million of residential mortgages to be securitized in a pass-through MBS. There must be between 250300 mortgages in the portfolio, none of them with a maturity below 200 months or greater than 360 months. In the interest of time, your boss suggests that the group assign group members to find (meaning create some hypothetical) a group of diverse mortgages (meaning each with a different interest rate, principal amount, and maturity) and then as a group, aggregate each members mortgages into a pool to calculate the portfolio WAC and WAM. Your groups task is to provide your boss with a summary spreadsheet that shows the individual mortgages and the portfolios WAC and WAM calculations, along with a memo of at least 300 words that explains the following:
- The number of residential mortgages in the portfolio and the range of principal values, interest rates, and maturities
- The residential mortgage portfolios 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 issues spread over the comparable Treasury rate.
- Includeinyouranalysisatleast1outsidesourcefortheTreasuryrate.
- Deliverable length: Spreadsheet,300words
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started