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)

Explain about centralised treasury function, Q. Explain about Centralised t...

Q. Explain about Centralised treasury function? Treasury departments are usually a feature of larger companies than Frantic although it is perhaps beneficial to consider the be

hazard or risk , For this assessment, you are required to choose one workp...

For this assessment, you are required to choose one workplace hazard or risk to safety in the financial services industry that interests you. Prepare a report on the area you have

Baumol sales max theory, critically appraise baumol max. theory as an alter...

critically appraise baumol max. theory as an alternative objective of the firm

Bond-equivalent yield, Normally, the cash flows from mortgage backed ...

Normally, the cash flows from mortgage backed and assets-backed securities are obtained on monthly basis. Therefore, the yield calculated would be on a monthly ba

Benefits of issue of securities, Benefits of Issue of Securities Initial...

Benefits of Issue of Securities Initial Public Offering (IPO) of securities gives instant recognition and visibility to the firm, helps to attract and retain skilled personnel,

Free cash flow, Free Cash Flow Free cash flow presents the amount of ca...

Free Cash Flow Free cash flow presents the amount of cash generated by the existing operations of a corporation and that is not needed for reinvestment in new projects in the f

Differentiate global and american depository receipts, What is Global Depos...

What is Global Depository Receipts American / Global Depository Receipts (ADRs/ GDRs) Equity shares which are offered in international markets to international investors a

Define decision to not permit price to ration goods, What reasons do govern...

What reasons do governments frequently give to justify the decision to not permit price to ration goods? (a) Price gouging is bad. (b) Income is unfairly distributed. (c) Some

Explain the npv criterion, Consider that you are deciding whether to undert...

Consider that you are deciding whether to undertake one of two projects. Project A involves buying expensive machinery which will produce a better product at a lower cost. The mach

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