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 what is meant by the incremental cash flows of a capital project. Incremental cash flows are defined by the change in total firm cash inflows and cash outflows which ca

Flying High Inc. plans to raise $5,000,000 external financing through issuing bonds, and is considering two options: regular bonds and zero couple bonds.  The regular bonds will ha

In modern strategic management accounting it is important to use appropriate performance measurements and control concepts, underpinned by theories and models applied in a variety

Question 1 What is Depreciation? Question 2 What are the elements of an accounting system? Question 3 How do you prepare Flexible Budget? Question 4 Briefly explain

1. Consider the following cash flows and reversion: There is an $80,000 cash outflow at time zero. BTCFs for years 1-4, respectively, are $10,000, $20,000, $20,000, and $25,000.

Q. Evaluate Cost of Irredeemable Debt subsequent to tax? Cost of Irredeemable Debt subsequent to tax: - When a company utilizes debt as a source of finance then it saves a cons

An issue with a put provision included in the agreement grants the bondholder the right to sell bonds back to the issuer at a pre-specified rate

It is a bond that does not give periodic interest payments. In spite of that, interest is added to the principal balance of the bond and is either paid at maturity or, at some poin

Factoring Denotes of enhancing a business's cash flow whereby outside organizations pays a firm a certain portion of its trade debts and then gets the full amount of cash from

The payments on GPMs unlike the payments on traditional mortgages are not equal. The payments under GPMs start at a relatively low level and rise for a specified