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)

Marshall-edgeworth method, Marshall-Edgeworth Method Marshall-Edgeworth...

Marshall-Edgeworth Method Marshall-Edgeworth method uses both the current year as well as the base year prices and quantities. Marshall-Edgeworth Index can be computed using th

Features of government securities, Features of government securities: ...

Features of government securities: Issuers The government securities are issued by the central government, state governments, and semi-government authorities like municipa

Public financial statements of a company, Public Financial Statements of a ...

Public Financial Statements of a Company The final exercise is the valuation of a publicly held company's equity. You must base your valuation on the company's public financia

Explain about baumol model, Q. Explain about Baumol Model? Baumol Model...

Q. Explain about Baumol Model? Baumol Model: - Baumol model is a mechanism of cash management which is used to determine optimum cash balance. Optimum cash balance is resolute

How compound values can be calculated on anannual basis, How Compound value...

How Compound values can be calculated on anannual basis Compound values can be calculated on anannual basis, or on a half-yearly basis or on a monthly basis or on continuous ba

Define the term- future cost and historical cost, Define the term- Future C...

Define the term- Future Cost and Historical Cost Future cost of capital refers to expected cost of funds to be raised to finance a project. In contrast, historical cost signifi

Lockbox system, how do we compute for benefits can derrive out of using loc...

how do we compute for benefits can derrive out of using lockbox system?

What is logistics, What is logistics? Explain the important activities in l...

What is logistics? Explain the important activities in logistics systems. Logistics - meaning . Working of logistics systems - three important activities - Order processing, I

What are the requirements of ifrs 8, What are the requirements of IFRS 8 ...

What are the requirements of IFRS 8 IFRS 8 requires an organisation to adopt management approach to reporting on financial performance of its operating segments. General idea

Break even sales, given just the sales and profit values, how is the break-...

given just the sales and profit values, how is the break-even sales calculated?

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