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)

Put, Put This is an agreement which is allowing a holder of privacies t...

Put This is an agreement which is allowing a holder of privacies to sell them back to the issuer at a specified amount during a specified time interval. This technique protects

., Identify and explain the key stages in the capital investment decision-m...

Identify and explain the key stages in the capital investment decision-making process and the role of investment appraisal in this process.

Find out the price of the swap from corporation's viewpoint, A company ente...

A company enters into a five-year interest rate swap along with a swap bank where it  agrees to pay the swap bank a fixed-rate of 9.75 percent yearly on a notional amount of DM15,0

How is present value affected by a change in discount rate, How is present ...

How is present value influenced by a change in the discount rate? Present value is oppositely related to the discount rate.  Alternatively, present value moves in the reverse dire

Define double-entry bookkeeping, Q. Define Double-Entry Bookkeeping? Do...

Q. Define Double-Entry Bookkeeping? Double-Entry Bookkeeping - Method of recording financial transactions in that every transaction is entered in two or more accounts and inclu

Explain the term- authorised and paid-up share capital, Explain the term- A...

Explain the term- Authorised and Paid-up Share Capital Number of shares of stock provided for in Articles of Association of a company is the authorized share capital. This figu

The time value of money , Calculate the present value and determine the npv...

Calculate the present value and determine the npv, Financial Management. Assume today is 3 December 2009. Helen is 30 years old and has a Bachelor of Business. She is currently em

Operating cycle, application of the operating cycle to a vegetable company

application of the operating cycle to a vegetable company

Explain the post-acquisition integration plan, Explain the Post-acquisition...

Explain the Post-acquisition integration plan Post-acquisition integration plan Keep  all  channels  of communications open,  by  includin

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