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)

Hurdles in implementation of securitization, The following are considered t...

The following are considered the major stumbling blocks: The process becomes expensive because of the stamp duty payable. It also

Define the meaning of overtrading, Define the meaning of Overtrading Wh...

Define the meaning of Overtrading When  a  company  is  trading  at  a  very  fast  pace,  it  would be  generating  sales  on  credit  with  speed, so have a large volume of t

Types of equity securities , Types of equaty Securities Equity securiti...

Types of equaty Securities Equity securities, traditionally, are classified into two types when they are issued. They are: Common Stock, and Preferred Stock.     Common Stoc

Steps, how control the steps

how control the steps

Limitation of profit maximisation -quality of benefits, Limitation of pro...

Limitation of profit maximisation -Quality of Benefits Probably the most vital technical limitation of profit maximisation as an operational objective, is that it ignores qua

., Identify and explain the key stages in the capital investment decision-m...

Identify and explain the key stages in the capital investment decision-making process and the role of investment appraisal in this process.

Disclosures of primary and derivative financial instruments, Assignment Ins...

Assignment Instructions You are to survey the annual reports of five listed companies in the extractive industry sector from ASX or other sources for the most recent year possib

Control ratios, Control ratios: Three important ratios are usually used by...

Control ratios: Three important ratios are usually used by the management to find out whether the variations from budgeted results are unfavorable or favorable.  These ratios are

Define relationship between bond''s market price and its ytm, What is the r...

What is the relationship between a bond's market price and its promised yield to maturity?  Explain. A bond's market price relies on its yield to maturity abbreviated as YTM.  Wh

Treasury notes or t-notes, Treasury Notes or T-notes are the securiti...

Treasury Notes or T-notes are the securities issued with maturities of more than one year and but not more than 10 years. All these securities are coupon securiti

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