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)

Define debenture, Debenture Debenture is a document holding an acknowl...

Debenture Debenture is a document holding an acknowledgment of indebtedness on the part of organizations, usually secured by a charge on the company's assets.

Enumerate the securities and investment analysis, Enumerate the Securities ...

Enumerate the Securities and Investment Analysis Purchase of bonds, stocks and othersecurities involve analysis and techniques which are highly specialized. An investorshoul

What do you understand by swap, Question 1 Swap is an agreement among t...

Question 1 Swap is an agreement among two or more parties to exchange sets of cash flows over a period in future and What do you understand by swap? Describe its features, kind

Accrual bond, It is a bond that does not give periodic interest payments. I...

It is a bond that does not give periodic interest payments. In spite of that, interest is added to the principal balance of the bond and is either paid at maturity or, at some poin

PROFIT MAXIMIZATION, what are the arguments in favour of profit maximizat...

what are the arguments in favour of profit maximization?

Gordon''s dividend equalisation model, If the EPS is Rs.5, dividend pay-out...

If the EPS is Rs.5, dividend pay-out ratio is 50%, cost of equity is 20% and growth rate in the ROI is 15%. What is the value of the stock as per Gordon's Dividend Equalisation Mod

Cost control strategies in organisations, 1. List the common elements of a ...

1. List the common elements of a submission for a major resource acquisition (purchase) 2. What is the difference between: A fixed asset and current asset? 3. If you worked i

WACC, The following is the existing capital structure of Company XYZ Ltd. O...

The following is the existing capital structure of Company XYZ Ltd. Ordinary shares at Shs.10 par 1,000,000 Retained 800,000 12% preference shares Shs.10 par 400,000 16% loan Shs.1

Show factors influencing participation, Q. Show Factors influencing partici...

Q. Show Factors influencing participation? Factors influencing participation: several research studies have shown that the intensity of participation depends on four factors.

Rating elements and symbols, Rating Elements A rati...

Rating Elements A rating agency earns its reputation by assessing the client's operational performance, managerial competence, management and organiza

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