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)

Illustrate in brokered markets in trade intermediation, Illustrate the in b...

Illustrate the in brokered markets according to trade intermediation. In brokered markets: In brokered markets, brokers execute an active search function to match buyers and

State the concept of overtrading, State the concept of Overtrading Over...

State the concept of Overtrading Overtrading can result in insolvency which means companies have severe cash flow problems. This means that a thriving company, which may look v

Approaches to financial management, mention the advantages and disadvantage...

mention the advantages and disadvantages of the traditional approach

Accounting to budget, Accounting to Budget: Accounting to budget is a c...

Accounting to Budget: Accounting to budget is a commonly used term to describe how an organisation controls its accounting process. Typically, an organisation divides its re

Liabilities, compare and contract the potential liabilities of owners of pr...

compare and contract the potential liabilities of owners of proprietorship,partnership and corporation

Accrued dividend, It is an accounting term which refers to the balance shee...

It is an accounting term which refers to the balance sheet item that accounts for dividends that have been confirmed but not yet given to shareholders. Accrued dividends are taken

Dividend yield plus growth in dividend process, Q. Dividend Yield plus Grow...

Q. Dividend Yield plus Growth in Dividend process? Dividend Yield plus Growth in Dividend process: - This process is used to compute the cost of equity capital when the dividen

Operational cycle, discuss the applicability of the operational cycle in ve...

discuss the applicability of the operational cycle in vegetable growing business in uganda

Write a market outlook for bond markets, The requirement of this assignment...

The requirement of this assignment that you write a Market Outlook for Bond Markets in a report form, in which you present your assessment of  the investment potential of global so

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