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)

Duration and convexity of mortgage backed security, Duration an...

Duration and Convexity of MBS A graph decpicting the price of the security under study and the interest rates helps in assessing the duratio

Can a corporation have too much working capital, Can a corporation have too...

Can a corporation have too much working capital?  Explain. A firm can have in excess of working capital if it is losing the opportunity to invest in high returning fixed assets

Money market mutual funds (mmmfs), Since the operations in the money ...

Since the operations in the money market are dominated by institutional players, the retail investor's participation in the market seems to be limited. To overcom

Explain what happen when government imposes a minimum price, Explain what w...

Explain what will happen while the government imposes a minimum price that is below the market equilibrium price. Why is this true? The minimum price will comprise no impact on t

Eurobond, Eurobond A corporate bond denominated in U.S. dollars or oth...

Eurobond A corporate bond denominated in U.S. dollars or other hard currencies and sold to investors outside the country whose currency is used. Eurobonds have become an impor

Question, You deposit $500 today in a savings account that pays 3.5% intere...

You deposit $500 today in a savings account that pays 3.5% interest, compounded annually. How much will your account be worth at the end of 25 years?

Average Return, How do I calculate the average return for T over a five yea...

How do I calculate the average return for T over a five year period?

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 =

Weighted average cost of capital, Q. Weighted Average cost of Capital? ...

Q. Weighted Average cost of Capital? When the company capital structure is made from equity share capital , debenture and Preference share capital , then we calculated the comb

Determine the purchasing in leaminger plc, b) Each $1 of outlay prior to 3...

b) Each $1 of outlay prior to 31 December 2003 would mean a loss in NPV on the alternative project of $0·20. There is so an opportunity cost of using funds in 2002. Purchasing

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