Asset Securitization Structures (Excel help), Financial Management

#questAs 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
ion..
Posted Date: 11/17/2012 3:15:10 PM | Location : United States







Related Discussions:- Asset Securitization Structures (Excel help), Assignment Help, Ask Question on Asset Securitization Structures (Excel help), Get Answer, Expert's Help, Asset Securitization Structures (Excel help) Discussions

Write discussion on Asset Securitization Structures (Excel help)
Your posts are moderated
Related Questions
You have been hired as an economic advisor to the Southeastern Conference. As your first assignment they have asked you to identify three microeconomic and three macroeconomic issu

Suppose the market portfolio is equally likely to increase by 30% or decrease by 10%. a.    Calculate the beta of a firm that goes up on average by 43% when the market goes up a

These types of securities have more than one coupon rate and each subsequent coupon rate is higher (or lower) than the previous coupon rate. For

How would you judge the potential profit of Bajaj Electronics on the first year of sales to Booth Plastics and give your views to increase the profit.


Explain about the in-quote-driven according to trade intermediation. In quote-driven dealer markets, a market-maker or dealer is onto one side of each trade. (Remember that dea

Global Scenario The Hedge Fund industry has captured over US $ 2 trillion in assets globally by the end of year 2006. According to an investor survey revealed for the Hedge Fun

How Debt securities is different from term loan Debt securities are different from term loans provided by financial institutions and banks to the company. Term loans are long t

On Completion of her introductory finance course, Kieran was so pleased with the amount of useful and interesting knowledge she gained that she convinced her parents, who were weal

What is the Benefits of divestment ¸ Releases cash tied up to finance more promising opportunities. ¸ Reduces diversification and complexity of a group in case of a demerger