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)

Prepare a monthly cash budget, Citilink will start a new business line on 1...

Citilink will start a new business line on 1st July, 2011 to make and sell bus souvenirs. The target sales and production volume are 525,000 in next year. The following projected

Rate of the growth of the business, Q. Rate of the growth of the business? ...

Q. Rate of the growth of the business? The working capital requirement of the a concern increase with the growth and expansion of the business activity although it is difficu

Financial ratios, How can we interpret financial ratios??

How can we interpret financial ratios??

Mr.Manikanta, can u tell me the various approaches followed by FMCG Compani...

can u tell me the various approaches followed by FMCG Companies in test markets

Just-in-time inventory management, Q. Just-in-time inventory management? ...

Q. Just-in-time inventory management? It considerably improves the short-term liquidity of the business with a maximum financing requirement of $138533 rather than $155640. The

Show the signs of overtrading, Q. Show the Signs of Overtrading? There ...

Q. Show the Signs of Overtrading? There are a number of usually recognised signs that a company may be overtrading. These are considered mutually with relevant financial data f

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

Introduction to fixed income portfolio management strategies, Investors use...

Investors use two management strategies to manage their fixed income portfolios. They adopt either active management strategy or passive management strategy. A

What is nondiversifiable risk? how is it measured, What is nondiversifiable...

What is nondiversifiable risk? How is it measured? But for the returns of one-half the assets in a portfolio are flawlessly negatively correlated with the other half-which is e

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