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)

Prepare general journal entries, On 1 July 2006, Goela Ltd was registered a...

On 1 July 2006, Goela Ltd was registered and offered 1 000 000 ordinary shares to the public at an issue price of $1.70, payable as follows: 50c on application (due 31 August)

Explain the financial accounting techniques, Question 1: (a) Explain f...

Question 1: (a) Explain fully the following financial accounting techniques: i. Cash accounting ii. Accrual accounting iii. Fund accounting iv. B

Forecasting yield volatility, There are several methods available to ...

There are several methods available to forecast yield volatility. But before that, let us look into the calculation of forecasted standard deviation. Assume th

Clearly explain speculation, QUESTION 1 Assuming perfect capital mobili...

QUESTION 1 Assuming perfect capital mobility under Mundell-Fleming Model, clearly explain the effectiveness of- i) an expansionary fiscal policy under a fixed exchange rate

Estimate financing types and requirements, This case provides the opportuni...

This case provides the opportunity to match financing alternatives with the needs of different companies. It allows the reader to demonstrate a familiarity with different types

Define the matching principle of working capital financing, What is the mat...

What is the matching principle of working capital financing?  What are the advantages of following this principle? The matching principle is while short-term financing is employe

Bond and Stock valuation, 2. Suppose a 12% coupon bond sells at par today; ...

2. Suppose a 12% coupon bond sells at par today; and three years from today, the required rate on the same bond is 8%. What is the coupon rate on the bond today and what will it be

Calculate the net premium retrospective reserve value, Question: On 1st...

Question: On 1st October 2001 a man then aged 34 took out an endowment assurance policy with a sum assured of $100,000 payable on survival to age 50 or at the end of the year o

par value, The face value of the debt security can be thought of as ...

The face value of the debt security can be thought of as the principal amount on which interest is paid by the issuer. It is the amount the issuer is willing to r

Regarding the assigment below, a-ii, should i calculate the co-variance of ...

a-ii, should i calculate the co-variance of the 30 securities?

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