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
Cash Books (Cash Payments and Receipts Journals) Cash books are the names given to the Cash Receipts Journal and the Cash Payments Journal. They are used to record the flow of

Explain the terms- Stock and  Share Stock Ownership of a company represented by shares that are a claim on the company's earnings and assets. Share Unit of equity

Let us construct a binomial interest rate tree for a 5.5% option free bond taking Table 3 as the binomial interest rate tree. Table 1 shows the various values in

How can secondary market organised the exchanges and over the counter markets? Exchanges and over-the-counter (OTC) markets: Secondary markets can be organised by exchanges

Question 1 ) A Globalization is a procedure of international integration that arises due to increasing human connectivity as well as the interchange of products, ideas and other ph

How would you explain economic exposure to exchange risk? Answer: Economic exposure can be illustrated as the opportunity that the firm’s cash flows and so its market value may

Define the both cash and share exchange Generally both cash and share exchange are used to make the offer more attractive. Other forms of consideration include: Paper consid

The financial ratios of a firm are given:     Current ratio    =  1.33   Acid-test ratio   =  0.80   Current liabilities  = 40,000   Inventory turnover ratio = 6    What is the

Question: (a) Consider that rate of interest is 10% and you are offered either a discount bond paying you $5,000 in 5 years or a fixed-payment loan paying you $750 per year for

Q. What do you mean by Average Cost and Marginal cost? Average Cost and Marginal cost: the average cost is the combined cost as explain above, but for the difference in the for