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)

Valuing a callable bond using binomial model, The process of va...

The process of valuing a callable bond is similar to that of an option-free bond, except for one thing - when the call option may be exercised b

zero salvage value, Big Joe's is changing a piece of equipment.  The equip...

Big Joe's is changing a piece of equipment.  The equipment will cost $5,000 and has a 5 year life.  The equipment can be leased for annual payment of $1,295 paid at the starting of

Borrowing funds via repurchase agreements, Repurchase agreement is a ...

Repurchase agreement is a contract wherein the seller of a security agrees to buy back the same security from the purchaser at a specified price and time. It is also

Security offered - influence the rate of interest, Q. Security offered -  ...

Q. Security offered -  influence the rate of interest ? The rate of interest charged on the loan will be lesser if the debt is secured against an asset or assets of the company

Treasury auction process, All treasury securities are issued on the b...

All treasury securities are issued on the basis of auction. The auction process is computerized and hence qualified broker-dealers can access it electronically. T

What is an audit?, Question 1 What is Depreciation? Question 2 What a...

Question 1 What is Depreciation? Question 2 What are the elements of an accounting system? Question 3 How do you prepare Flexible Budget? Question 4 Briefly explain

Just-in-time inventory management, Q. Just-in-time inventory management? ...

Q. Just-in-time inventory management? It considerably improves the short-term liquidity of the business with a maximum financing requirement of $138533 rather than $155640. The

Why do analysts calculate financial ratios, Why do analysts calculate finan...

Why do analysts calculate financial ratios? The comparative measures are known as Ratios. Since the ratios show relative value, they permit financial analysts to compare inform

How to calculate correlation co-efficient, Q. How to calculate correlation ...

Q. How to calculate correlation co-efficient? The correlation co-efficient measures the nature and the extent of relationship between the stock market index return and the stoc

Explain the adjusting journal entry, Q. Explain the Adjusting Journal Entry...

Q. Explain the Adjusting Journal Entry? Adjusting Journal Entry - An accounting entry made into a subsidiary ledger known as the Generaljournal to account for a periods changes

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