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)

Cost centre, a)   What are the pre-requisites of installation of responsibi...

a)   What are the pre-requisites of installation of responsibility accounting system? b)  Diffrence between 'cost centre' and 'profit centre'.

Describe the money market products, Question 1 Under a hire purchase de...

Question 1 Under a hire purchase deal structured by X Finance Ltd. for Y Corporation, the finance company has offered to finance the purchase of equipment that costs Rs. 200 la

Objectives and functions of asic, Objectives and Functions of ASIC The ...

Objectives and Functions of ASIC The objective of ASIC is to ensure the confident and informed participation of consumers in the financial system. To attain this objective, it

Scenario analysis for a portfolio manager, A portfolio manager would ...

A portfolio manager would never prefer to make investment decision based on just one set of assumptions. Instead, he would evaluate the outcome of the selected st

Example on bills of exchange, Q. Example on Bills of exchange? ARG Co w...

Q. Example on Bills of exchange? ARG Co will be apprehensive to protect the sterling value of its expected dollar receipt. The quoted forward rates demonstrate that the dollar

Secondary market - t-bills, Secondary Market The major participants in ...

Secondary Market The major participants in secondary market are banks, brokerage firms and bond houses. They buy and sell T-bills on behalf of customers and themselves. The cus

Explain about invoice discounting, Q. Explain about Invoice discounting? ...

Q. Explain about Invoice discounting? Invoice discounting is a technique which is able to be used to raise finance against receivables. Invoice discounting works as follows:

Explain closed end country fund trade at premium or discount, Why do you th...

Why do you think closed-end country funds frequently trade at a premium or discount? Answer:  CECFs (closed-end country funds) trade at a premium or discount since capital market

How could we obtain an indisputable discount rate, How could we obtain an i...

How could we obtain an indisputable discount rate? How should we calculate the beta and the risk premium? There is no indisputable discount rate: a discount rate is a subjectiv

Calculate debt or equity ratio, Calculate Debt or Equity Ratio XYZ LI...

Calculate Debt or Equity Ratio XYZ LIMITED Key data related to XYZ for last three years is as follows:   2011/12 2010/12

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