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)

Define how do mergers affect small businesses, How do mergers affect small ...

How do mergers affect small businesses? A: As per to a recent study by Federal Reserve and Wharton Financial Institutions Center economists, not a big deal. Their analysis reve

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

Financial projections, A total of $426,000 seed-funding would be ideal to s...

A total of $426,000 seed-funding would be ideal to start the project on a local basis. The cost analysis done above is for the material required to perform the work, and as the wor

Define condition for fixed-for-floating interest rate swap, What is the ess...

What is the essential condition for a fixed-for-floating interest rate swap to be possible? For a fixed-for-floating interest rate swap to be feasible it is essential for a quali

Margin trading, Margin Trading: Suppose an investor wants to buy 100 Re...

Margin Trading: Suppose an investor wants to buy 100 Reliance Energy shares, whose market price is Rs.500. This transaction requires Rs.50,000 but the investor has only Rs.30,0

Marshall-edgeworth method, Marshall-Edgeworth Method Marshall-Edgeworth...

Marshall-Edgeworth Method Marshall-Edgeworth method uses both the current year as well as the base year prices and quantities. Marshall-Edgeworth Index can be computed using th

Financial issues of divestitures, FINANCIAL ISSUES OF DIVESTITURES Many...

FINANCIAL ISSUES OF DIVESTITURES Many corporations review the business portfolio to determine the operations that fit their core strategies. The firm's desire to achieve more f

Structure and organization of treasury , I am looking for assignment help o...

I am looking for assignment help on the topic Structure and Organization of Treasury. It would be great if anyone help me.

Historical look at the treasury yield curve, The minimum interest rate ...

The minimum interest rate which investors demand for non-treasury securities is represented by the yield offered on the treasury securities. This is why market particip

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