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 main elements of working capital management, Question: (a)...

Question: (a) Describe the main elements of Working capital management? (b) Belle Rive Ltd Belle Rive Ltd has an annual turnover of Rs 60 million of which 80% is on cr

Different types of cash flow to bondholder of coupon bonds, What are the di...

What are the different types of cash flow to the bondholder of coupon bonds? Coupon bonds deliver two different kinds of cash flow to the bondholder are as follows: a. Face

What is the rationale of the double-play strategy, Q. What is the rationale...

Q. What is the rationale of the double-play strategy? The hedge funds deploy a double-play strategy in order to engineer steep increases in interest rates and steep declines in

Stripped mortgage-backed securities , These securities aid in unpacki...

These securities aid in unpacking the cash flows from a pass-through. The most uncomplicated stripped mortgage-backed securities are the PO-IO-security. Unlike a

What do you signify by investment decisions, Q. What do you signify by Inve...

Q. What do you signify by Investment Decisions? Investment Decision: - The most significant function of financial management isn't only the procurement of external funds for th

Financial evaluation and decision making, Financial Evaluation and Decision...

Financial Evaluation and Decision Making: The final major element of financial management is the evaluation of the information provided through the accounting and budget proces

Components of a callable bond, A callable bond is the sale of a call ...

A callable bond is the sale of a call option by the investor to the issuer as it allows the issuer to repurchase the bond from the time it becomes callable until

Which ratios is potential long term bond investor, Which ratios would a pot...

Which ratios would a potential long-term bond investor be most interested in? Explain. Potential and Current lenders of long-term funds, like banks and bondholders, are interest

Mrs. Edwards, If invested 2500 in a bank that pays 1% annually. How long wi...

If invested 2500 in a bank that pays 1% annually. How long will it take for the funds to double?

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