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)

Objectives of financial services authority, Objectives of financial service...

Objectives of financial services authority FSMA provides four statutory objectives to FSA. They are: Market Confidence: Maintaining confidence in the financial system;

Define the services that international banks provide, Briefly discuss some ...

Briefly discuss some of the services that international banks provide their customers and the market place. Answer:  International banks can be categorized by the types of servic

Historical differences in equity securities, Public Bourses The origin ...

Public Bourses The origin of this type of bourses can be found in the legislative work of Napoleon. These type of bourses are regulated by the government, brokers are appointed

Define the types of shareholder, Tactics can be used by company to protect...

Tactics can be used by company to protect itself. Before the bid Types of Shareholder Having the right shareholders on board who can be

Show the current liabilities method, Q. Show the Current Liabilities Method...

Q. Show the Current Liabilities Method? Forecasting of Current Assets as well as Current Liabilities Method: - As-per to this method an estimate is made of forthcoming period's

Put provision, An issue with a put provision included in the ag...

An issue with a put provision included in the agreement grants the bondholder the right to sell bonds back to the issuer at a pre-specified rate

Determine the purchasing in leaminger plc, b) Each $1 of outlay prior to 3...

b) Each $1 of outlay prior to 31 December 2003 would mean a loss in NPV on the alternative project of $0·20. There is so an opportunity cost of using funds in 2002. Purchasing

Case study, what are the assumptions of MM(Modigliani Miller) approach

what are the assumptions of MM(Modigliani Miller) approach

Credit standards for formulation of optimum credit policy, Q. Credit Standa...

Q. Credit Standards for Formulation of Optimum Credit Policy? Credit Standards: - Credit standards are the essential criteria set for extension of credit to customers. Decision

Significance of secondary markets, Significance of Secondary Markets: H...

Significance of Secondary Markets: High liquidity and constant demand in the market need a diversified investor base with different preferences of demand, maturity and risk. Ap

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