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)

Residual income, Residual Income This is used for external reporting pu...

Residual Income This is used for external reporting purposes. This term refers to the net income which is available for distribution to the firm's common stock holders. In mana

How would the market price of a bond be affected, All other things held con...

All other things held constant, how would the market price of a bond be affected if coupon interest payments were made semiannually instead of annually? The majority of bonds i

Introduction to mortgage-backed securities, A mortgage may be defined as a ...

A mortgage may be defined as a pledge of property to secure payment of a debt. Depending upon the terms of mortgage agreed upon between the lender and the borrower, mor

Full valuation approach, When a manager measures the interest ...

When a manager measures the interest rate exposure, he would be interested in analyzing the exposure to a set of changing interest rate. The process of r

Evaluation of credit policy, Q. What is Evaluation of Credit Policy? Ev...

Q. What is Evaluation of Credit Policy? Evaluation of Credit Policy: - A credit policy is prepared to maintain the investment in receivables at optimum level. Receivable Turnov

Calculating investment statistics and graphing output, Step 1) Opportunity ...

Step 1) Opportunity Set Graph:Combine 2 of your stocks (Ignore the other 2 stocksfor this step only).  Construct an investment opportunity set (the curved set) between the two risk

Geographical classification of mutual funds , Geographical Classification o...

Geographical Classification of Mutual Funds : Nations' boundaries provide territorial restrictions on the sale and purchase of mutual fund units or shares as is the case in com

Pension reforms, Pension Reforms On January 1, 2004, Pension Funds have...

Pension Reforms On January 1, 2004, Pension Funds have come into force in India. Government servants will have to subscribe to them. The new pension fund system is primarily dr

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