Asset Securitization Structures (Excel help), Financial Management

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)

Interference of central bank in markets, Interference of Central bank in Ma...

Interference of Central bank in Markets: Some dilemmas exist in the issue of central bank intervention in the market to correct the volatilities in the prices. In some countrie

Calculate the capital charge for the bank, A bank comprises a $500 million ...

A bank comprises a $500 million portfolio of investments and bank credits. The everyday standard deviation of return on this portfolio is .666 %. Capital adequacy standards need th

Constructing the binomial interest rate tree, How to calculate the up anh d...

How to calculate the up anh down factor in the binomial interets rate tree

Advantages and disadvantages of accounting rate of return, Advantages of AR...

Advantages of ARR: It is simple to calculate and easy to catch. With the help of this technique, direct comparisons among proposed projected of varying lives with no bu

Return on investment , Return on Investment (ROI) In accounting it is a...

Return on Investment (ROI) In accounting it is a measure of the earning power of an industries asset. A high return on investments is desirable. ROI is widely described as net

prepare a cash budget, You are presented with the budgeted data shown belo...

You are presented with the budgeted data shown below for the period November 20X1 to June 20X2 by your firm. It has been extracted from the other functional budgets that have been

Explain the features of new public management, Question 1: "The governa...

Question 1: "The governance of modern states demands that a relentless struggle be waged against the scourge of corruption." Discuss. Question 2: Explain clearly how th

Optimal portfolio selection, Optimal Portfolio Selection: The next step...

Optimal Portfolio Selection: The next step involves selecting the optimal portfolio. The strategic asset allocation will have overriding importance in pension fund management.

Cash discount, I am trying to solve this formula: 2/10, net 30. In the bo...

I am trying to solve this formula: 2/10, net 30. In the book I am reading they have 2% x 360 ------- ------ = 2.04% x 18=36.72% 100-2% (30-10) I want to know how the

Calculate the annual interest , Reston, Inc., has asked your corporation, P...

Reston, Inc., has asked your corporation, Pruro, Inc., for financial assistance. As a long-time customer of Reston, your firm has decided to give that assistance. The question you

Write Your Message!

Name

Email id

Message

Verfication Code

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!

Submit Assignment

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd