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)

Aims of financial services authority, Aims of FSA The aim of FSA is to ...

Aims of FSA The aim of FSA is to promote efficient, orderly and fair markets, and to help retail consumers to get a fair deal. In fact, FSA has set out its aims under three bro

Why firms need funds at certain episodic events, Why firms need funds at ce...

Why firms need funds at certain episodic events A related aspect was that firms need funds at certain episodic events like merger, reorganization, liquidation and soon. A detai

Determine the purchasing in leaminger plc, b) Each $1 of outlay prior to 3...

b) Each $1 of outlay prior to 31 December 2003 would mean a loss in NPV on the alternative project of $0·20. There is so an opportunity cost of using funds in 2002. Purchasing

Show social and regulatory factors, Q. Show Social and Regulatory Factors? ...

Q. Show Social and Regulatory Factors? Regulatory climate and legislation against the environmental degradation may impair the profitability of the industry. Price control, vol

Considerations before a mbo, Considerations before a MBO An MBO is just...

Considerations before a MBO An MBO is just like any other take over and same consideration must be applied. (i)  Potential of the business. Is it worth buying? What does the

Find out the value of firm according to the mm approach, Example: - Two fir...

Example: - Two firm U as well as L is identical in every respect except that U is unlevered and L is levered. L has Rs. 20Lakh of 8% debt outstanding. The net operating income of b

Types of floating-rate securities, Floating rate securities can be br...

Floating rate securities can be broadly divided into following two parts: Floating-rate securities that have constant quoted margin. Floating-rate sec

Case study on labour standars, describe the impact of different types of st...

describe the impact of different types of standards on motivation, and specifically , the likely effects on motivation of adopting the labor standards recommended for geeta & compa

Calculate the changes in the margin account, Suppose today's settlement pri...

Suppose today's settlement price on a CME DM futures contract is $0.6080/DM. You comprise a short position in one contract. Your margin account at present has a balance of $1,700.

Determine the analytical procedures of auditors, Analytical procedures of a...

Analytical procedures of auditors Auditors must apply analytical procedures at the planning and overall review stage of audit. Analytical procedures include the considerati

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