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
What are the Internal audits Internal audit is seen as independent from management who are devising and implementing internal controls and must be able to provide advice on in

Federal Reserve Board The Federal Reserve Board controls the nation's monetary policy, regulates banks, and searches to keep the financial stability of the United States. Its t

please give us the formula of price of equity shares of walter''s and gordon''s model

three years ago, SSSG Ltd. issued 10 years $1000 bonds with a 7% coupon rate paid semi-annually, at par value. the market currently requires a 9% yield. what was the price of bond

You are considering starting a walk-in-clinic. Your financial projections for the first year of operation are as follows: Revenues (10,000 visits) $400,000 Wages and benefits $220,

Deficiency in Operation - This exists when a properly designed control doesn't operate as designed or when person performing the control doesn't possess the necessary authority or

What is Walter Model? Please provide me report on Estimation of Walter Model. It is about 2000 words count report on topic Walter Model.

Types of Bonds 1. Secured Versus Unsecured Bonds 2.  Senior versus Subordinate Bonds 3.  Registered and Unregistered Bo

The Managing Director of your firm is thinking aloud about an appropriate gearing level for the company: "The consultants I spoke to yesterday explained that some academic th

Free Cash Flow Free cash flow presents the amount of cash generated by the existing operations of a corporation and that is not needed for reinvestment in new projects in the f