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)

Describe the basic career stages, Q. Describe the basic Career stages? ...

Q. Describe the basic Career stages? The proper way to analyze and discuss career is to look at them as made up of stages. We can identify five career stages that people most p

Analysis of the capacity to pay, In addition to management quality, a...

In addition to management quality, an assessment of the financial capacity of a company should also include an evaluation of trends, regulatory environment, basic

CASE, How would you judge the potential profit of Bajaj Electronics on the ...

How would you judge the potential profit of Bajaj Electronics on the first year of sales to Booth Plastics and give your views to increase the profit.

Define compensating balances, What are compensating balances and why do ban...

What are compensating balances and why do banks require them from some customers?  Under what circumstances would banks be most likely to impose compensating balances? Compensati

Yield curve risk, The graphical representation of the relationship between ...

The graphical representation of the relationship between yield and maturity is known as yield curve. Yield curve risk is the risk of experiencing an adverse

What theoretical share price share for share exchange, What theoretical sha...

What theoretical share price share for share exchange Establish what theoretical share price may be after the merger in a share for share exchange incorporating the effects of

De-leveraged floaters, A floater where the coupon rate is computed as...

A floater where the coupon rate is computed as a fraction of the reference rate plus a quoted margin, are known as a de-leveraged floater. The general formula for this

Modified duration versus effective duration, Modified duration is use...

Modified duration is used to determine the percentage change in the bond's prices for a 100 basis point (1%) change in the yield. The underlying assumption is tha

Review of career plans, Review of career plans: career plans, emerging out ...

Review of career plans: career plans, emerging out of career planning exercise, have long term orientation. A career plan is developed based on assumptions about how the environmen

Weighted average cost of capital, Q. Weighted Average cost of Capital? ...

Q. Weighted Average cost of Capital? When the company capital structure is made from equity share capital , debenture and Preference share capital , then we calculated the comb

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