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
Would exchange rate changes all time increase the risk of foreign investment? Discuss the condition within which exchange rate changes may actually decrease the risk of foreign inv

Putable bonds can be redeemed prior to maturity at the initiative of the bondholder. These bonds are more advantageous to the investors as they get an opportunity to re

Accounting System: The accounting systems are the primary financial systems that any business should have in place to ensure accurate and usable financial information. The b

What is Financial index & commodity index? Method of index uses in calculation? Weighted average method? How to calculate index?

Question 1 State the key functions of the financial market. Question 2 Define "Bill of exchange". What are its features? Give different types of cheques. Question 3

Under what circumstance would the U.S. dollar and the Canadian dollar be said to have achieved purchasing power parity? The U.S. dollar and the Canadian dollar possible conside

Financial Analysis Project: At the beginning of 2009, CanGo purchased the online gaming company. This purchase was for cash, paid for through the proceeds of the

what are the assumptions of MM(Modigliani Miller) approach

Q. Just-in-time inventory management? It considerably improves the short-term liquidity of the business with a maximum financing requirement of $138533 rather than $155640. The

GENERAL FUNCTIONS Several functions of financial management currently range from planning of funds to distribution of earnings and also are extend beyond.  Some of the well-kn