Asset Securitization Structures (Excel help), Financial Management

#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..
Posted Date: 11/17/2012 3:15:10 PM | Location : United States







Related Discussions:- Asset Securitization Structures (Excel help), Assignment Help, Ask Question on Asset Securitization Structures (Excel help), Get Answer, Expert's Help, Asset Securitization Structures (Excel help) Discussions

Write discussion on Asset Securitization Structures (Excel help)
Your posts are moderated
Related Questions
Explain the purchasing power parity, both of the absolute and relative versions. What causes the deviations from the purchasing power parity? Answer:  The absolute version of p

1. Analyse the company's capital structure and critically assess different types of financing options available to the company. Calculate the cost of these different types of finan

Name two patterns of cash flows for a share of common stock. How does the market define the value of the most common cash flow pattern for common stock? Cash flows for a share

List and explain the three financial factors that influence the value of a business. The three factors that influence the value of a firm's stock price are timing , cash flow

An Investor can receive income from this source when the bonds purchased at discount are held up to maturity or when he sells the bond before ma

What creates the APV capital budgeting framework useful for analyzing foreign capital expenditures? The APV framework is a value - additivity method. Since international projects

Q. Evaluate Cost of Preference Share Capital? Cost of Preference Share Capital: - A fixed rate of dividend is to be paid on preference shares. However unlike debt the dividend

Imagine you have been allocated $100,000 which is to be invested in 8 companies listed on the Australian Stock Exchange (ASX). You are required to have a balanced portfolio betwee

Effective Duration and Convexity The modified duration is a measure of the sensitivity of a bond's price to interest rate changes; the assumption made here is that the expected

Q. Illustrate dividend valuation model? The business is being acquired as a going concern and earnings valuations rather than asset valuations are recommended. Even these are b