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
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
Organization and Management Pattern of UTI UTI has a full-time Chairman with an Executive Trustee reporting to him. The Executive Trustee looks after the Corporate Office, Zona

A vailable bid capacity We saw the criterion that qualifies the bidder. Now we will learn about the bid capacity. There are chances that a bidder might acquire more contrac

Monitoring and Controlling Budgets: The preparation of budgets is only part of the budget cycle.  Once set, an organisation should actively monitor actual revenue and expenditu

Explain the operating cycle of a vegetable growing business

What is the decision rule for accepting or rejecting proposed projects when using net present value? When going with the net present value decision rule any project with a net

Q. What is Debentures? Debentures a debenture is an instrument issued by the company acknowledge its debts to its holders . it is also an important method of raising long terms

At 31 July 2010 this instrument meets the definition of a derivative: Small or no initial investment. Its value is dependent on an underlying economic item; exchange ra

Q. What do you mean by Misappropriation Of Fund? Misappropriation Of Funds allotted for specific works under capital or Revenue demand but the expenditure is incurred for anoth

When an investor invests in fixed income securities, he receives returns from one or more of the following sources: Coupon Interest payment.

On Completion of her introductory finance course, Kieran was so pleased with the amount of useful and interesting knowledge she gained that she convinced her parents, who were weal