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


a choice is to be made between the two completing proposal which require an equal investment of Rs.50000.00 and we are expected t gererate net cash flow as under. Year Project A

Q. Explain Net Present Value Method? Net Present Value (NPV) Method: - This process measures the Present value of returns per rupee invested. In this method present value of

What is the Debt Ratio? Describe please.

Q. Consequence of the cash operating cycle? The cash operating cycle is the length of time among paying trade payables and receiving cash from receivables. It is able to be cal

To begin this topic, the case of China Sky describes the appointment of a special auditor  in the organization that is also a rule in the procedures of Singapore Exchange (SGX). Th

Q. Explain about Discount Rate? Discount Rate - Rate at which INTEREST is deducted in advance of the issuance, selling, purchasing or lending of a financial instrument. Also, t

Define the term- Cash purchases     Shareholders of the target company are bought out completely and have no further stake in business. This is good if predator shareholders want

Q. Changes in exchange rates? The law of one price proposed that identical goods selling in different countries should sell at the same price and that exchange rates relate the