Purchase Solution

Asset Securitization Structures

Not what you're looking for?

Ask Custom Question

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.

Purchase this Solution

Solution Summary

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.

Purchase this Solution


Free BrainMass Quizzes
Academic Reading and Writing: Critical Thinking

Importance of Critical Thinking

Learning Lean

This quiz will help you understand the basic concepts of Lean.

Understanding the Accounting Equation

These 10 questions help a new student of accounting to understand the basic premise of accounting and how it is applied to the business world.

Basic Social Media Concepts

The quiz will test your knowledge on basic social media concepts.

Managing the Older Worker

This quiz will let you know some of the basics of dealing with older workers. This is increasingly important for managers and human resource workers as many countries are facing an increase in older people in the workforce