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
Explain the Sovereign Risk Sovereign risk denotes a country imposing exchange restrictions on a currency included in a swap making it expensive, or not possible, for a counterp

Meaning merits nd demerits of modern approch of financial management

Question: In each case below and having regard to your knowledge of Accounting Concepts, comment on and assess the validity of the accounting implications/practices to be adop

who are the participants in the hedge funds industries

Repurchase agreement is a contract wherein the seller of a security agrees to buy back the same security from the purchaser at a specified price and time. It is also

Question: On 1st October 2001 a man then aged 34 took out an endowment assurance policy with a sum assured of $100,000 payable on survival to age 50 or at the end of the year o

This is the part of after-tax personal income that is not spent.

Breaks in Specific Cost of Capital: The specific costs of capital may also be affected by the amount of finance the firm wants to raise. As the amount of financing increases, the

How can we calculate ration analysis in financial management?? Determine the ration analysis? Need assignemt help on this topic

State the factors of Tests of controls Tests of controls may include ยท Enquiries and observations corroborating internal control functions. Inspection of docu