Asset Securitization Structures (Excel help), Financial Management

Assignment Help:
#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..

Related Discussions:- Asset Securitization Structures (Excel help)

Calculate the thai bhat and risk systematic, 1) Is foreign exchange risk sy...

1) Is foreign exchange risk systematic? What are the implications of your answer regarding corporate hedging policy with respect to foreign exchange risk? In your answers make sure

Determine principal balance at the end of the term, 1. CompuSystems was sup...

1. CompuSystems was supposed to pay a manufacturer $19,000 four month ago and another $14,000 two months from now.  CompuSystems is proposing to pay $10,000 today and the balance i

Remaining differences with us gaap, Remaining differences with US GAAP ...

Remaining differences with US GAAP IFRS 8 comprise intangible assets as part of the non-current assets. SFAS 131 only refers to tangible assets. IFRS 8 requires method

Mathematical property of median, Mathematical Property The sum of the d...

Mathematical Property The sum of the deviations of the items from median, ignoring signs, is the least. For example, the median of 6, 10, 14, 18 and 22 is 14. The deviations fr

Global sector indixes, Global Sector Indixes Morgan Stanley Capital Int...

Global Sector Indixes Morgan Stanley Capital International (MSCI) measures the International and National performance. It launched All Country Sectors on January 30, 2001. MSCI

Prepare a statement of financial position, Brown has been in business for s...

Brown has been in business for some years and has kept her drawings slightly below the level of profits each year. You are her accountant, and she has passed you the following list

Inflation rate is likely after year 1, a) Suppose that the real risk-free r...

a) Suppose that the real risk-free rate, r*, is 3% and that inflation is assumed to be 7% in Year 1, 5% in Year 2, and 4% after that. Suppose also that all Treasury securities are

Multicollinearity, Multicollinearity As the degree of correlation betwe...

Multicollinearity As the degree of correlation between the independent variables increases, the regression coefficients become less reliable. That is, although the independent

Explain the methods used to treat the obsolete stock, Explain the methods u...

Explain the methods used to treat the obsolete stock Review Inventory for obsolete items Make materials review board Include an obsolescence review in the closing p

Project budgets and reporting systems, Project Budgets and Reporting System...

Project Budgets and Reporting Systems: In many cases, where a project is initiated and a budget allocated, a separate account is created to ensure costs attributable to that pr

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd