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)

What are the types of major types of finance companies, What are the types ...

What are the types of major types of finance companies? There are three main types of finance companies: a. Sales finance institutions which make loans to customers of a cer

Effective annual rate, You are interested in saving money for your first ho...

You are interested in saving money for your first house. Your plan is to make regular deposits into brokerage account which will earn 14%. Your first deposit of $5,000 will be made

Evaluate return on capital employed, a) Gross profit = $500,000 and Expense...

a) Gross profit = $500,000 and Expenses = $100,000 for Year 2. b) Year 2 GPM = $500k / $1,000k = 50.0% Year 1 GPM = $400k / $850k = 47.05% Year 2 NPM = $400k / $1,000k =

Role of investment banking in investment intermediaries, What is the role o...

What is the role of investment banking in investment intermediaries? Investment banks: These banks assist corporations or governments into the issue of new debt or equity

Characteristics of hedge funds, Characteristics of Hedge Funds Hedge Fu...

Characteristics of Hedge Funds Hedge Funds are commonly referred to as "absolute return strategies", which means that many are designed to seek positive returns in most market

Determine the valuing equity securities, Determine the Valuing Equity Secur...

Determine the Valuing Equity Securities Unlike debt and money market instruments, equity instruments represent ownership interest in the company. As owners should put in their

Regional banks, Regional Banks Large banks like First Norwest, Chicago,...

Regional Banks Large banks like First Norwest, Chicago, Mellon and Crocker function regionally at the national level in a fashion same to money center banks. Regional banks ser

What are the types of theft threats, What are the types of theft threats?  ...

What are the types of theft threats?  Describe the methods to access and overcome theft threats. Types of theft threats - Mass theft, Pilferage theft. Steps to assess threats

Agency problem, Discuss how a business might limit agency problem between m...

Discuss how a business might limit agency problem between management and creditors

Explain the mechanism that restores the balance of payments, Explain the me...

Explain the mechanism which restores the balance of payments equilibrium when it is disturbed under the gold standard. Answer:  The adjustment mechanism within the gold standar

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