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)

Determine the calculation of materiality, Determine the calculation of mate...

Determine the calculation of materiality For example: Turnover 1% -1.5% Net assets 1% -2% Net profit 2% -6% Whatever numbers are selected they would be based on r

What is coupon rate, What is Coupon Rate Coupon rate is the stipulated ...

What is Coupon Rate Coupon rate is the stipulated interest rate to be paid on the face value of a bond.  It represents a fixed dollar amount which is paid periodically as long

Hedged and unhedged returns on equity and bond portfolios, Question 1: ...

Question 1: i) Discuss the benefits of international diversification and the issue of home country's bias in equity and bonds markets? ii) Explain carefully the currency he

Define the main objectives of the bretton woods system, What were the main ...

What were the main objectives of the Bretton Woods system? Answer: The major objectives of the Bretton Woods system are to acquire exchange rate stability and promote internation

Defien the term ension funds, Pension funds Pension funds offers retire...

Pension funds Pension funds offers retirement income in the form of annuities to employees covered by a pension plan. They obtain contributions from employers or employees and

Explain significance of the additional funds needed (afn), Explain the sign...

Explain the significance of the term additional funds needed. While the pro forma balance sheet is completed, total assets and total liabilities and equity will hardly match.

Operating cycle, what is the applicability of the operating cycle in a vege...

what is the applicability of the operating cycle in a vegetaion farm in Uganda

Define a tax create a deadweight loss, Why does a tax create a deadweight l...

Why does a tax create a deadweight loss?  What determines the size of this loss? A tax makes deadweight loss by artificially increasing price above the free market level, so de

Determine have mergers affected competition, Have mergers affected competit...

Have mergers affected competition? A: Federal Reserve data depict that measured on the local level, where competition occurs; markets have in fact experienced more banking comp

What is over capitalization, Accounting and Financial Management 1. Wha...

Accounting and Financial Management 1. What is over capitalization? How do we know over capitalization has occurred? 2. Explain permanent and temporary working capital. 3

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