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)

Calculations and graphing cumulative returns, Monthly Returns: You now nee...

Monthly Returns: You now need to calculate the monthly "periodic" returns for all three stocks and the S&P index.  Adapting the holding period return formula (End - Beg) / Beg for

Budget, what are the advantages and disadvantages of incremental budgeting?...

what are the advantages and disadvantages of incremental budgeting?

The mechanism of a swap in risk management, QUESTION i) Discuss the ris...

QUESTION i) Discuss the risk associated with changes in exchange rates. ii) How can these risks be managed internally? iii) Explain how a manager can use a forward contra

What are the merits of budgets?, Question 1 Describe the process involved ...

Question 1 Describe the process involved in accounting. What are the objectives of accounting? Question 2 Briefly explain the role of management accounting. Also expalin the

Calculate the new interest rate and excel function pv, I want to see the so...

I want to see the solution that was provided in Feb 2013 for Calculate the new interest rate and excel function pv, Financial Accounting

Budget setting styles, Advantages and disadvantage of pacipatory style of b...

Advantages and disadvantage of pacipatory style of budgeting

What is simply offensive and what is humour, a) Ethics can be a rather prej...

a) Ethics can be a rather prejudiced matter; whether it is ethical to market products directly at children depends on several factors: The age of the children being targeted

Yield spread measures for floating-rate securities, In a floating rat...

In a floating rate security, the coupon rate changes periodically as per the reference rate. The yield to maturity of floating rate securities cannot be calculated as

Historical inflation and stock value experience, Historical Inflation and S...

Historical Inflation and Stock Value Experience The experimental evidence denies the status of stocks as a good hedge against inflation. A study conducted by Ibbotson and Brins

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