Reference no: EM13858608
As 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 you create a hypothetical group of diverse mortgages (meaning each with a different interest rate, principal amount, and maturity) then aggregate the mortgages into a pool to calculate the portfolio WAC and WAM. Your 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.
MUST INCLUDED SPREADSHEET WITH LIST OF MORTGAGES IN PORTFOLIO
MUST INCLUDED WORD DOC. SHOWING ANSWERS FROM ABOVE QUESTIONS ABOUT PORTFOLIO
|
Calculate the axial forces in members bd and cd
: Determine whether or not the truss structure is statically determinate, giving your reasoning. Identify which members in the truss are in tension and which are in compression. Calculate the axial forces in members BD and CD, stating clearly whether ..
|
|
Types of calories
: 1. How many and what types of Calories are reported to be in one gram of Cheeto?
|
|
Is the pursuit of self interest the same as greed
: Do you think that Adam Smith would approve of Gekko's philosophy? Is "the pursuit of self interest" the same as "greed"? Why/Why not? Is greed, in all its forms, good
|
|
Diamagnetic electronic structure
: Problem 1: Molecular orbitals and Valence Bond Theory: Why is O2 a paramagnetic species even though by VBT is should adopt a diamagnetic electronic structure? Use orbital diagrams or drawings to explain your answer.
|
|
Summary spreadsheet that shows the individual mortgages
: 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
|
|
Explain how you plan to involve maria parents in meeting
: In 250-300-words, summarize and explain how you plan to involve Maria's parents in meeting her goals. Include a specific at-home activity to help in her continued success
|
|
Was aquinas the end of this transition
: Describe how Aurelius Augustine was a bridge between, that is, he set in motion the transition from, the classical (Greek) world of philosophy and the medieval world (Aquinas). Was Aquinas the end of this transition, or the beginning of something ..
|
|
Analysis with a discussion regarding implications
: Please reference online information sources appropriately using endnotes. Please end the analysis with a discussion regarding implications. In other words, after gathering the data, so what? What does it mean
|
|
Explain why the cpab recommended that the auditors
: Explain why the CPAB recommended that the auditors needed to apply a heightened sense of professional skepticism to the audit or management estimates.
|