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)

Capital gain or loss, An Investor can receive income from this ...

An Investor can receive income from this source when the bonds purchased at discount are held up to maturity or when he sells the bond before ma

Evaluate financial report and analysis, Project Specifications Complete...

Project Specifications Complete an individual Financial Report and Analysis. You will select a company that you would like to analyze based on the parameters provided by the

Preferred stock, Preferred Stock This is a category of capital stock th...

Preferred Stock This is a category of capital stock that will gives its holders preference  over common stockholders in the distribution  of earnings  or rights to the assets o

Bank loans for a company seeking short-term financing, What are the pros an...

What are the pros and cons of commercial paper relative to bank loans for a company seeking short-term financing? Commercial paper is generally a cheaper source of short-term f

Pre-requisites for effective budgetary control system, ORGANISATION FOR BUD...

ORGANISATION FOR BUDGETARY CONTROL (or) PRE-REQUISITES FOR THE INTRODUCTION OF AN EFFECTIVE BUDGETARY CONTROL SYSTEM 1.   BUDGET CENTRE:  It is a section of the organization

What is the optimal amount of risky assets, Consider a world with two asset...

Consider a world with two assets: a riskless asset paying a zero interest rate, and a risky asset whose return r can take values +10% or -8% with equal probability. An individual h

Report on liquidity and financing, Extent of Financing Required It is ...

Extent of Financing Required It is clear that sales are unsure with low, high and medium estimates of demand. This of itself gives a few uncertainty but the reliability and pr

Public corporations ought to tender audited financial statem, What are some...

What are some of the government requirements imposed on a public corporation that are not imposed on a private, closely held corporation? Public corporations ought to tender au

Estimate sales price of gas, A proposal to extend the ABC Gas Company Ltd's...

A proposal to extend the ABC Gas Company Ltd's gas distribution network to the NOIDA industrial cluster, about 40 km east of Delhi, at distance of about 20 kms from the ABC's exist

Define the concept of a real option, Define the concept of a real option. D...

Define the concept of a real option. Discuss some real options a firm can be confronted with when investing in real projects. A positive APV project is accepted under the supposi

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