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)

Business organization, what business organization do you preffer ? service ...

what business organization do you preffer ? service concern,trading concern or manufacturing concern

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

Collecting information and forecasting in budget, Collecting Information an...

Collecting Information and Forecasting: All budgets must be based on accurate and reasonable information. A budget derived from information which is irrelevant to the actual or

Define the balance of payments, Define the balance of payments. Answer:  ...

Define the balance of payments. Answer:  The balance of payments that is abbreviated as BOP can be defined as the statistical record of a country’s international transactions ove

Equilibrium of an exchange economy, The economy consists of two consumers, ...

The economy consists of two consumers, A and B. Both consumers are endowed with one unit of good 1 and one unit of good 2. Consumer A is entirely indi?erent between all consumption

Define the term- cost of capital, Define the term- Cost of capital Cost...

Define the term- Cost of capital Cost of capital is the rate of return a firm should earn on its investments for the market value of the firm to remain unchanged. Acceptance of

Which ratios is potential long term bond investor, Which ratios would a pot...

Which ratios would a potential long-term bond investor be most interested in? Explain. Potential and Current lenders of long-term funds, like banks and bondholders, are interest

Symmetric cash matching, We have earlier studied that the investor ma...

We have earlier studied that the investor may have to carry cash for some time because of discrepancies arising between the timing of the bond's cash-flow and the

Planning to achieve budget goals, Planning to Achieve Budget Goals: It ...

Planning to Achieve Budget Goals: It is insufficient for an organisation or a project team to simply set budget goals and expect management and employees to work in the same ma

Differentiate between systematic and unsystematic risk, QUESTION a) Dis...

QUESTION a) Discuss the importance of diversification in the context of stock markets using appropriate numerical illustrations. b) Mimine and Minush are two companies with

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