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
At the end of 1922, your great grandfather (g.g.f.) established a trust fund to be used in order to help a later generation of the family obtain a university education. The ultimat

Normal 0 false false false EN-IN X-NONE X-NONE MicrosoftInternetExplorer4

What is the decision rule for accepting or rejecting proposed projects while using internal rate of return? While the internal rate of return is greater or equal as compare to

Discuss the advantages and disadvantages of closed-end country funds or CECFs relative to the American Depository Receipts or ADRs as a means of international diversification. An

Ashok is to receive an amount of Rs. 15,00,000 from his relative after 3 years. He wants to buy a house for which he wants the money to be paid now. His relative had al

1. Analyse the company's capital structure and critically assess different types of financing options available to the company. Calculate the cost of these different types of finan

In US, savings and loan associations constitute the major originating group of the traditional loans. What types of properties can be mortgaged?

Hedge funds are short two types of funding options. Describe in detail what these options are. Describe why these options become more valuable during a financial crisis. During

Federal Open Market Committee The principle document making body of the Federal Reserve, the FOMC consists of 7 governors of the Federal Reserve System and 12 Federal Reserve D

What do you mean by pension funds? Pension funds: Pension funds give retirement income (as the form of annuities) to workers covered through a pension plan. They get cont