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)

Show repayment of principal, Your company is preparing to borrow $1,750,000...

Your company is preparing to borrow $1,750,000 on a 3-year, 10%, annual payment, fully amortized term loan. What fraction of the payment made at the end of the second year will sho

Objective of wealth maximization, Q. The main rationale for the objective o...

Q. The main rationale for the objective of wealth maximization is that it shows the most efficient use of the society's economic resources and therefore leads to a maximization of

Risk-bearing economies of scale, a) Product portfolio refers to the diversi...

a) Product portfolio refers to the diversity of the different product lines produced by a business. In this case, Mattel's product portfolio includes: board games, toy cars, cuddly

Market capitalization, Market Capitalization : Often referred to as marke...

Market Capitalization : Often referred to as market cap, it refers to the value of a company, that is, the market worth of its outstanding shares. A common misconception is that

Working capital, W orking Capital Working capital is measured as th...

W orking Capital Working capital is measured as the difference among organization present assets and its current liabilities. Therefore, it is interpreted by some as a meas

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

London stock exchange, London Stock Exchange (LSE) The origin of the Lo...

London Stock Exchange (LSE) The origin of the London Stock Exchange goes back to the coffee houses of 17th century. London, where people willing to invest or raise money, bough

Interpretations of long term solvency or liquidity ratio''s, Long Term Solv...

Long Term Solvency or Liquidity Ratio's   DE:          The Debt Equity ratio exhibits the relation that exists between debt and proprietor's fund and is considered a very im

Implementing systems effectively, Implementing Systems Effectively: Muc...

Implementing Systems Effectively: Much of the accounting process has been taken over by office automation systems. Whereas once the vast majority of bookkeeping and reporting t

Income statement, Income Statement A formal statement of the parts...

Income Statement A formal statement of the parts used in determining an organization net income that is called profit and loss statement. The several categories reported

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