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)

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

What happens when a bank charges discount interest on a loan, What happens ...

What happens when a bank charges discount interest on a loan? When a bank charges reduction in interest on a loan the required interest payment is subtracted from the loan proc

Financial information, A)  What are the statements of financial information...

A)  What are the statements of financial information? Talk about two items from each. B)   Describe statement of changes in financial positions, with an example.

Shareholders'' wealth maximization, Shareholders' wealth maximization S...

Shareholders' wealth maximization Shareholders' wealth maximization refers to maximization of the net present value of every decision made in the firm. Total present value is e

Analyse consumer behaviour, Eatmore & Green Pty. Ltd (Australia) is a succe...

Eatmore & Green Pty. Ltd (Australia) is a successful medium sized marketing consultancy for Australian agricultural products and Australian sourced organic, natural beauty/cosmetic

Define trustworthy collateral from the lenders perspective, What is trustwo...

What is trustworthy collateral from the lenders' perspective?  Explain whether accounts receivable and inventory are trustworthy collateral. Assets which are readily marketable

Deficit financing, It is the most useful method of promoting economic devel...

It is the most useful method of promoting economic development. It may be used for the development of economic and social overheads such as construction of roads, railways, power p

''a'' priori probability, 'A' Priori Probability This is a probability ...

'A' Priori Probability This is a probability computed by rationally examining existing information. A priori probability can most simply be explained as making a conclusion on

What is the bonds value, Third Inc. wishes to issue a perpetual callable bo...

Third Inc. wishes to issue a perpetual callable bond. The current interest rate is 6%. Next year, there is a 30% chance that the interest rate will be 4.5% and a 70% chance that th

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