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)

Role of special purpose vehicle, The financial institutions tha...

The financial institutions that originate the loans sell a pool of cashflow-producing assets to a specially created third party that is called a

Design a digital option as a sequence of calls, An individual agent thinks ...

An individual agent thinks that there is a high probability that the Dow Jones will have a payoff (or points) between a=10000 and b=12000 at t=1. Design a digital option (see Fi

Macaulay duration and modified duration, We can also express Modified...

We can also express Modified duration as follows:                                                                                               ...Eq. (3) The

Strategies of hedge funds, Strategies of Hedge Funds: Hedge funds use ...

Strategies of Hedge Funds: Hedge funds use a range of different strategies, and each fund manager can argue that he or she is unique and could not be compared to other manager

Calculate the value of cash flow, a. Consider the time line below that show...

a. Consider the time line below that shows periodic cash flows and interest rates per period. Interest rate/year 0 1 2 3 4 5 6 7 8 9 Time 2,500 -4,000 6,000 -3,700 Cash flows

Estimate the money in dollars have lost or gained, In January 2010 your fir...

In January 2010 your firm bought from an Italian firm goods payable in Euros worth EU2,000,000.  Suppose that at that time the exchange rate of the Euros was 1EU=$1.25.  Because th

Define mergers affect communities, How do mergers affect communities? A: ...

How do mergers affect communities? A: While a locally controlled bank is merged into a bank headquartered somewhere else (an out-of-market merger), a few apprehension about the i

Define multinational corporations (mncs), What are multinational corporatio...

What are multinational corporations (MNCs) and what economic roles do they play? A multinational corporation (MNC) can be described as a business firm incorporated in one count

Show the working capital in a business, Q. Show the Working capital in a bu...

Q. Show the Working capital in a business? Working capital in a business is essential since of operating cycle. However the need for working capital doesn't come to an end afte

Importance of mutual funds in the investment intermediaries, Define the imp...

Define the importance of mutual funds in the investment intermediaries. Mutual funds: Mutual funds pool resources by several companies and individuals and invest these re

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