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)

Cash discount, I am trying to solve this formula: 2/10, net 30. In the bo...

I am trying to solve this formula: 2/10, net 30. In the book I am reading they have 2% x 360 ------- ------ = 2.04% x 18=36.72% 100-2% (30-10) I want to know how the

What are the options available for growth, What are the options available f...

What are the options available for growth Joint venture   A joint venture is when a separate company is formed, in which every member holds an equity st

Show the supposition of mm hypothesis, Q. Show the Supposition of MM Hypoth...

Q. Show the Supposition of MM Hypothesis? Supposition of MM Hypothesis:- (i) There are ideal capital markets. (ii) Investors act rationally. (iii) Information regardin

Location of lifting anchors in precast concrete units, Q. Location of lifti...

Q. Location of lifting anchors in precast concrete units? It is desirable that position of anchors be located symmetrical to the centre of gravity of precast concrete units. Or

Capital investment decisions, what are the key stages in capital investment...

what are the key stages in capital investment decision-making process and the role of investment appraisal in this process?

Income statement and balance sheet, The following are extracts of the Incom...

The following are extracts of the Income Statement and Balance Sheet for Umar plc. Extract Balance Sheet at 30 June 20X2               20X1 £'000  £'000                £

Determine the working capital in the firm, a) Year 2 Current Ratio = 700 / ...

a) Year 2 Current Ratio = 700 / 300 = 2.33 : 1 Year 1 Current Ratio = 500 / 200 = 2.5 : 1 Year 2 Acid Test = (700 - 350) / 300 = 1.17 : 1 Year 1 Acid Test = (500 - 250) / 200 =

Management, . Why do some organizations seem to have a new CEO every year o...

. Why do some organizations seem to have a new CEO every year or two, whereas others have top leaders who stay with the company for many years (e.g., John Chambers at Cisco)? What

Wishart and Associates — Financial Alternatives, 4. In the front of each fo...

4. In the front of each folder were some handwritten notes that Meenda had made on Monday before he left. Give focus on the said notes.

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