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)

Estimate the cost of equity capital, You are required to choose a company f...

You are required to choose a company for analysis.  This company should be quoted on one of the principal international exchanges.  It may be your own company.  You should then do

Traditional approach to valuation, Under this approach of Valuation, ...

Under this approach of Valuation, all cash flows are discounted using single interest rate (discount rate).  For example: Consider the 5-year (7.00 percent) Treas

Uses of index numbers, Uses of Index Numbers 1. Establishes trends ...

Uses of Index Numbers 1. Establishes trends Index numbers when analyzed reveal a general trend of the phenomenon under study. The available figures for inflation based

The visitors perceive to justify the renovation, Lincoln Park Zoo in Chicag...

Lincoln Park Zoo in Chicago is considering a renovation that will improve some physical facilities at a cost of $1,800,000. Addition of new species will cost another $310,000. Addi

Explain rate of the stock turnover, Q. Explain Rate of the stock turnover? ...

Q. Explain Rate of the stock turnover? Rate of the stock turnover: this is high degree of the inverse co relation between the quantum of the working capital requirement and the

Explain hedging transaction exposure, Discuss and compare hedging transacti...

Discuss and compare hedging transaction exposure by using the forward contract vs. money market instruments. While do the alternative hedging approaches generate similar result?

Relationship between bond price and time, Relationship between Bond Price a...

Relationship between Bond Price and Time   (If Interest Rates are Constant) The bond price changes as the bond moves closer to its maturity. If the bond is quoted

On-the-run treasury issues and selected off-the-run treasury, The wid...

The wide gap between maturities poses problems in using the on-the-run issues, especially after five years. Some dealers and vendors use selected off-the-run Trea

Audit systems, Enron did not manages its trade account receivable in signif...

Enron did not manages its trade account receivable in significant manner that made huge financial loss for the organizations. Hence, the management faced biggest fraud due to the f

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