Asset Securitization Structures (Excel help), Financial Management

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)

Historical weights, Can some one tell me the defination of Historical weigh...

Can some one tell me the defination of Historical weights and how we calculate the historical weight?? And given the diffrence between Historical weight Vs Marginal weights??

Zero-coupon bonds, All the bonds are not making periodic coupon payments. ...

All the bonds are not making periodic coupon payments. Zero-coupon bonds are those bonds where the bondholder realizes interest by buying it at a deep discount to its face

Determine the example of rate of return of a bond, Determine the example of...

Determine the example of Rate of return of a Bond A bond is paying 10 % interest per annum and is going to mature in next two years At maturity it would pay its principal amoun

How are financing costs capital budgeting analysis process, How are financi...

How are financing costs generally incorporated into the capital budgeting analysis process? Financing costs are typically captured in the discount or hurdle rate when doing IRR

Operation and productio management measure and compare, what that mean?

what that mean?

Operating cycle, discuss the applicability of operating cycle and any other...

discuss the applicability of operating cycle and any other financial knowledge to poultry business in uganda

State the concept of icq, ICQ's designed to: Identify possible area...

ICQ's designed to: Identify possible areas of weakness. Discover existence of internal controls. Questions are framed to highlight situations where: NO su

Dividend yield method, Dividend yield method As per this method, the co...

Dividend yield method As per this method, the cost of Equity capital is the discount rate that equates the present value of expected future dividends per share with the net pro

long-term supermarket projects, Here is currently making investment apprai...

Here is currently making investment appraisals of two potential long-term supermarket projects, A and B. Both projects needs the similar initial investment of £20m. The following r

Factors considered in assigning a credit rating, Credit rating agenci...

Credit rating agencies carry out credit rating. Companies appoint these agencies to assign credit rating for their corporate issues. The rating agencies may condu

Write Your Message!

Name

Email id

Message

Verfication Code

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!

Submit Assignment

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd