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)

Finance manangement, What is the maximum price that you would be willing to...

What is the maximum price that you would be willing to pay for a constant growth stock that has the following characteristics: (a) Dividend (Has Paid): $3.25, (b) Growth: 7%, and (

Briefly explain what is trem card, Q. Briefly explain What is TREM Card? ...

Q. Briefly explain What is TREM Card? 1. As per National and international regulations, the drivers of vehicles carrying hazardous goods should have the documentation outlining

Timing of financial reports, Timing of Financial Reports: Just as the a...

Timing of Financial Reports: Just as the actual report requirements differ depending on the requirements of the stakeholder that will be using them, so too will the timing of t

91-day t-bills, 91-Day T-Bills Starting from July, 1965, 91-day T-bills...

91-Day T-Bills Starting from July, 1965, 91-day T-bills were issued at a discount rate ranging from 2.5-4.6 percent per annum. Till July, 1974, the discount rate was 4.6 percen

Evaluation of money-market hedge, Evaluation of money-market hedge Expe...

Evaluation of money-market hedge Expected receipt after 3 months = $300000 Dollar interest rate over three months = 5.4/ 4 = 1.35% Dollars to borrow now to have $300000 l

Risk return relationship, RISK RETURN RELATIONSHIP A business operates...

RISK RETURN RELATIONSHIP A business operates in a market environment, which is not within its control. It is exposed to several dangers from the internal with external sources

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

Traditional mortgages, In US, savings and loan associations con...

In US, savings and loan associations constitute the major originating group of the traditional loans. What types of properties can be mortgaged?

Computation of working capital, Will you please define the working capital ...

Will you please define the working capital and Calculation of working capital? I need urgent help in my assignment. help me!

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