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)

Factors affecting investment decisions, I have a question for my homework, ...

I have a question for my homework, which is: Explain, using relevant instances, how investment decisions are affected by different factors. Help please?

Agency relationship, Solutions to shareholders and government agency proble...

Solutions to shareholders and government agency problemquestion #Minimum 100 words accepted#

Calculate the maximum price of machine, Silvana Zhang of Sajjad Jafri & Geo...

Silvana Zhang of Sajjad Jafri & Geopeng Li Limited is considering purchasing a new widget making machine. She would like to know the maximum price she should pay for the new machin

Capital market, Capital market: The term capital market is used to deno...

Capital market: The term capital market is used to denote all the activities of the primary and secondary markets. It can also refer to the market for equity and debt instrumen

Reinvestment risk, Reinvestment risk is the risk involved in reinvesting th...

Reinvestment risk is the risk involved in reinvesting the proceeds received from the issuer against callable bonds. During falling interest rate periods, investor canno

Who owns a credit union, Who owns a credit union? Explain. The term Cre...

Who owns a credit union? Explain. The term Credit unions are owned by their members. While credit union members put money in their credit union, they are not exactly "depositin

Define a sunk cost, What is a sunk cost?  Is it relevant while evaluating a...

What is a sunk cost?  Is it relevant while evaluating a proposed capital budgeting project?  Explain. A sunk cost is a cash flow which has previously occurred, or that will take

Debentures, A 16% debenture of R5 000 is redeemable at a premium of 10% aft...

A 16% debenture of R5 000 is redeemable at a premium of 10% after 5 years. The fair rate of return on similar debentures is 14% before tax. Calculate the present value of the capit

Foreign exchange markets, At current interest rates and exchange rates...

At current interest rates and exchange rates, the US might have a $400 billion net financial (capital) account inflow from the rest of the world during 2010, and the

Calculate the variance of the dollar value of your property, Assume that yo...

Assume that you hold a piece of land in the City of London that you may wish to sell in one year. Like a U.S. resident, we are concerned along with the dollar value of the land. Su

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