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)

State the example to calculate the present value, State the Example to calc...

State the Example to calculate the present value 2, 00,000 $ is the amount which you require after 20 years for your retirement. How much must you invest now at 5% per annum co

Explain the competitive benchmarking, Explain the Competitive Benchmarking ...

Explain the Competitive Benchmarking Healthcare services or Hospital are compared to rival 'competition 'in the same industry for instance methods of patient care and levels o

Mortgages, A mortgage may be defined as a pledge of property ...

A mortgage may be defined as a pledge of property to secure a debt payment; in this context, we will use the term property to mean real estate. If the

Explain calculation firm risk of a capital budgeting project, Explain how t...

Explain how to measure the firm risk of a capital budgeting project. The firm risk of a capital budgeting project calculates the impact of adding a new project to the existing pr

Nature of current liabilities, Current Liabilities: A liability is an ...

Current Liabilities: A liability is an obligation to convey assets or do services at some future date. For purposes of balance sheet analysis, it is important to create a dist

Irregular variation in time series analysis, Irregular Variation As the...

Irregular Variation As the name suggests, the movement of the variable is random in nature without consistency and therefore, highly unpredictable. Since this type of irregular

Project on investment banking house, The Project to be Addressed by the Pap...

The Project to be Addressed by the Paper: You have just graduated from CCI's MBA program and have secured a position as a fund manager for a well known investment banking house

Objectives of financial services authority, Objectives of financial service...

Objectives of financial services authority FSMA provides four statutory objectives to FSA. They are: Market Confidence: Maintaining confidence in the financial system;

Explain in detail about the cost of capital, Explain in detail about the Co...

Explain in detail about the Cost of Capital Every type of capital used by the firm (preference shares, debt and equity) must be incorporated into the cost of capital, with rela

Characteristics - nature of financial management, Characteristics - Nature ...

Characteristics - Nature of Financial Management: 1) Financial Planning and Control: Finance is a base for all the business activities. Business Activities should be not on

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