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
Scenario:  ABC Company sells widgets in three varieties (blue, red, and yellow) but has lost money for the past three years.  Competitive intelligence shows the Company's products

Q. Describe the Functions of Controller? (1) Planning and budgeting: - It comprises capital expenditure planning, profit planning, budgeting, inventory control, sales forecasti

Discuss the applicability of the operating cycle to poultry business in Uganda(consider broilers)

Q. Criticism of Wealth Maximization? i) The objective of wealth maximization is not, necessarily, socially desirable. ii) There is some controversy whether the objective of

Q. Long and short dated volatility? 1. If an investor purchase long-dated volatility as well as sells short-dated volatility then the investor is expecting a decrease in the sh

Assessing Impact: As with the assessment of likelihood, a valuable way of assessing impact would be the creation of categories of impact as follows: Level

To what extent does empirical evidence on corporate objectives support the predictions of Baumol’s “Sales Maximisation Hypothesis?”

I am facing some problems in my assignment of Cash Management and Inventory Management. Can anybody suggest me the proper explanation for it?

Illustrate the in brokered markets according to trade intermediation. In brokered markets: In brokered markets, brokers execute an active search function to match buyers and

Define the importance of mutual funds in the investment intermediaries. Mutual funds: Mutual funds pool resources by several companies and individuals and invest these re