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)

Explain the significance of the term additional funds needed, Explain the s...

Explain the significance of the term additional funds needed . When the pro forma balance sheet is finished, total liabilities and total assets and equity will rarely match.

Federal funds rate, Federal Funds Rate The interest rate that Amer...

Federal Funds Rate The interest rate that American banks that have funds in excess of the needs dictated by the Federal Reserve use to make overnight loans to banks whose

Delivery and credit risk, When a borrower uses repo market for fund f...

When a borrower uses repo market for fund financing, he has to deliver the securities to the lender. One way to do this is to deliver the collateral to the lender

Average of relatives method, Average of Relatives Method We have seen ...

Average of Relatives Method We have seen the construction of an index number using the aggregates method. In this section, we shall see the construction of an index using the

Securities and exchange commission of usa, SECURITIES AND EXCHANGE COMMISSI...

SECURITIES AND EXCHANGE COMMISSION OF USA In the United States, securities industry is regulated by the United States Securities and Exchange Commission (SEC). It is the govern

Explain dividend policy decision, Q. Explain Dividend Policy Decision? ...

Q. Explain Dividend Policy Decision? Dividend Policy Decision: - The financial management has to make a decision as which portion of the profits is to be distributed as dividen

Explain cross hedging, Explain cross-hedging and discuss the factors determ...

Explain cross-hedging and discuss the factors determining its effectiveness. Answer: Cross-hedging includes hedging a position in one asset by taking a position in another asse

What are the measures of growth, What are the Measures of growth Sa...

What are the Measures of growth Sales or market share Number of products or markets Employees Profit Number of retail stores

Difference between mortgage bond and a debenture, Difference between mortga...

Difference between mortgage bond and a debenture? A mortgage bond is a secured bond whereas a debenture is an unsecured bond.

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