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 the straight fixed-rate bond, Define the Straight fixed-rate bond ...

Define the Straight fixed-rate bond Straight fixed-rate bond issues comprise a designated maturity date at which the principal of the bond issue is guaranteed to be repaid.  Th

Risk and return of portfolio, Portfolios are simply combinations of differe...

Portfolios are simply combinations of different securities. The characteristics of investments do differ when we possess them in combinations or portfolios. As we shall see, an ass

Registered and unregistered bonds, On the basis of transferability, d...

On the basis of transferability, debentures can be classified as registered and unregistered debentures. Unregistered debentures (or bearer debentures) are freely

Example on walters dividend model, Q. Example on Walters dividend model? ...

Q. Example on Walters dividend model? Example: - The following information is obtainable in respect of a firm: Capitalisation Rate (Ke)                     = 10% Earning

Beta value, Beta Value Risk is an important consideration while investi...

Beta Value Risk is an important consideration while investing in any security. It is the possibility that realised returns will be less than the returns expected. The degree, t

Define a sunk cost, What is a sunk cost?  Is it relevant while evaluating a...

What is a sunk cost?  Is it relevant while evaluating a proposed capital budgeting project?  Explain. A sunk cost is a cash flow which has previously occurred, or that will take

What is the rationale of the double-play strategy, Q. What is the rationale...

Q. What is the rationale of the double-play strategy? Hedge Fund enters agreement to sell HK$ in six month's. At expiration the Hedge Fund requires to buy spot HKD and deliver

Explain about deferred payment, Q. Explain about Deferred Payment? supp...

Q. Explain about Deferred Payment? suppose a person take a loan of a specified amount at a given rate of the interest. he wants to repay this loan together with the interest in

Net income, What remains of an organization revenue after all expenses and ...

What remains of an organization revenue after all expenses and taxes have been paid.

Calculate the portfolio weight, Assume Intel''s stock has an expected retur...

Assume Intel''s stock has an expected return of 26% and a volatility of 50%, while Coca-Cola''s has an expected return of 6% and volatility of 25%. If these two stocks were perfect

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