As an assistant vice president at a regional bank, your boss has tasked you to acquire $100 million of residential mortgages to be securitized in a pass-through MBS. There must be between 250-300 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 to find (meaning create some hypothetical) a group of diverse mortgages (meaning each with a different interest rate, principal amount, and maturity) and then, aggregate each mortgage into a pool to calculate the portfolio WAC and WAM. Your must provide your boss with a summary spreadsheet that shows the individual mortgages and the portfolio's WAC and WAM calculations.© BrainMass Inc. brainmass.com October 10, 2019, 5:40 am ad1c9bdddf
This solution helps with a problem involving asset securitization structures for residential mortgages. The tutorial is given as a summary spreadsheet showing the individual mortgages and the portfolio's WAV and WAM calculations in an Excel spreadsheet.