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)

Financial management, DEFINITION OF FINANCIAL MANAGEMENT The term finan...

DEFINITION OF FINANCIAL MANAGEMENT The term financial management has been described by management experts in several ways reflecting the duties and responsibilities of a financ

Find NPV of 2 Projects, Woody Construction is considering a new 3-year expa...

Woody Construction is considering a new 3-year expansion project that requires an initial fixed asset investment of $3.186 million. The fixed asset will be depreciated straight-lin

Capital budgeting, Serene Hall ?? Assignment As a consequence of the high l...

Serene Hall ?? Assignment As a consequence of the high levels of stress being recorded in the UK, and a general shift towards a healthier more relaxed lifestyle, as an essential in

Case study on labour standars, describe the impact of different types of st...

describe the impact of different types of standards on motivation, and specifically , the likely effects on motivation of adopting the labor standards recommended for geeta & compa

Type of hedge funds, What are the Types of Hedge Funds? Please provide me r...

What are the Types of Hedge Funds? Please provide me report on Types of Hedge Funds.

Define comparative advantage related to currency swap market, How does the ...

How does the theory of comparative advantage relate to the currency swap market? Answer:  Name recognition is very important in the international bond market. With no it, even a

Explain implications of purchasing power parity, Explain the implications o...

Explain the implications of purchasing power parity for operating exposure. Answer: Determine if the exchange rate changes are matched by the inflation rate differential among

Delivery and credit risk, When a borrower uses repo market for fund f...

When a borrower uses repo market for fund financing, he has to deliver the securities to the lender. One way to do this is to deliver the collateral to the lender

State the economic conditions of cost of capital, State the economic condit...

State the economic conditions of cost of capital General economic conditions These include demand for and supply of capital within the economy and level of expected inflatio

Eurodollar, Eurodollar U.S. currency held on deposit in banks located ...

Eurodollar U.S. currency held on deposit in banks located outside the United States, mainly in Europe. Eurodollars are mostly used for settling international transactions outs

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