Number of residential mortgages in the portfolio

Reference no: EM13747954

As an assistant vice president at a regional bank, your boss has tasked you and the other AVPs to work in a group 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 the group assign group members to find (meaning create some hypothetical) a group of diverse mortgages (meaning each with a different interest rate, principal amount, and maturity) and then as a group, aggregate each member's mortgages into a pool to calculate the portfolio WAC and WAM. Your group's task is to provide your boss with a summary spreadsheet that shows the individual mortgages and the portfolio's WAC and WAM calculations, along with a memo of at least 300 words that explains the following:

The number of residential mortgages in the portfolio and the range of principal values, interest rates, and maturities
The residential mortgage portfolio's WAC and WAM
A discussion of the WAC of the pass-through MBS the group has created and whether it represents a coupon rate indicative of a high credit quality or a lower credit quality pool of mortgages. Include in the discussion the MBS issue's spread over the comparable Treasury rate.
Include in your analysis at least 1 outside source for the Treasury rate.

Reference no: EM13747954

Questions Cloud

Implement a database based on the provided er diagram : Analyse and comprehend a provided ER diagram and Database Schema - To implement a database based on the provided ER diagram and Database Schema.

Find out the taxable income : Tom and Linda are married taxpayers who file a joint return. They have itemized deductions of $12,250 and four exemptions. Assuming an adjusted gross income of $40,000, what is their taxable income for 2012?

What is the prognosis on genetic diseases : What is the prognosis on genetic diseases in the future? Do you believe that microsurgery to "fix" chromosomal aberrations will someday prevent the diseases that are listed in the List of Genetically Mediated Diseases in Humans

Compare and contrast the risk assessment methodologies : Compare and contrast the following risk assessment methodologies: (a) the Delphi technique, (b) sensitivity analysis, and (c) Monte Carlo simulation. Provide a rationale for your response.

Number of residential mortgages in the portfolio : The number of residential mortgages in the portfolio and the range of principal values, interest rates, and maturities

Explain the impact of the pitfall on the organization : Describe the situation, focusing on how the leader committed the pitfall. Explain the impact of the pitfall on the organization and on the team.

Advantages of a roth ira : What are the advantages of a Roth IRA?

Write research paper report on distribution of taster gene : Write Research Paper Report on Distribution of Taster Gene

The six elements of organization design : Write clearly and logically, as you will be graded on content, analysis, and your adherence to the tenets of good academic writing. You should be succinct, where possible, while also exploring the topics appropriately. Remember that you can always..

User Account

All Pages