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)

Operating cycle, what is the applicability of the operating cycle in a vege...

what is the applicability of the operating cycle in a vegetaion farm in Uganda

Cash flow& funds flow statement , Explain cash flow and funds flow analysis...

Explain cash flow and funds flow analysis with suitable example from an existing corporate entity for at least three years i.e. 2008, 2009.2010.

Kim, Blossom Lawn expects to have total sales next year totaling $15,000,00...

Blossom Lawn expects to have total sales next year totaling $15,000,000 and the firm pays taxes at 35% and will owe $300,000 in interest expenses.

Explain significance of the additional funds needed (afn), Explain the sign...

Explain the significance of the term additional funds needed. While the pro forma balance sheet is completed, total assets and total liabilities and equity will hardly match.

Integration of economic, a) Globalisation refers to the interdependence and...

a) Globalisation refers to the interdependence and integration of economic, social and politic issues (services, goods, people and capital), across the world. For example, consumer

Illustrate the term structure of interest rates, Illustrate the term struct...

Illustrate the term structure of interest rates? The term structure of interest rates: The term to maturity affects the interest rate. Bonds along with identical risk may

Balance sheets, Balance Sheets   Peony Ltd. ...

Balance Sheets   Peony Ltd. Aster Ltd. Assets:     Cash $     62,500 $

Distinguish between a promissory note and a bill of exchange, QUESTION ...

QUESTION (a) "A promissory note is an instrument in writing (not being a blank or a currency note) containing an unconditional undertaking, signed by the maker, to pay a certai

Yield, Yield Yield represents the actual return on the investments. Dif...

Yield Yield represents the actual return on the investments. Different types of yield are discussed below: Coupon Yield: The fixed interest rate on a government security or

Eps, a. Calculate expected earnings per share (EPS) if the firm is perfectl...

a. Calculate expected earnings per share (EPS) if the firm is perfectly hedged. EPS $

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