Portfolio and the range of principal values

Assignment Help Finance Basics
Reference no: EM13819895

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: EM13819895

Questions Cloud

Reviewing websites and reading the journal articles : After reviewing websites and reading the journal articles, and in light of what you discovered in preparing to write your answer to the discussion question, consider, analyze, and explain why general education courses should be a significant part ..
Case study on public key infrastructure : Public Key Infrastructure
Determine two most essential mean of protection for citizens : In reviewing all of the consumer protections identified, determine the two most essential means of protection for citizens. Explain your rationale.
Develop a marketing strategy for the organization : you will identify an organization that is a social enterprise business or an organization that helps these types of businesses. A better understanding of socail enterprises will add to your array of marketing ideas and tools. Once you have made yo..
Portfolio and the range of principal values : The number of residential mortgages in the portfolio and the range of principal values, interest rates, and maturities
Was the japanese attack on pearl harbor a good strategy : Was the Japanese attack on Pearl Harbor, Hawaii on 7 December 1941 a good strategy badly executed or simply a bad strategy?
What is a mission statement : What is a mission statement? What is Starbucks’ Mission Statement ? Find your company or school mission statement. Re-write that mission statement to include the importance that the organization places on its human resources
Write a review paper about the us national security strategy : Write a review of the U.S. national security strategy and defense policy that proposes a way forward for the nation i.e., a new national security strategy and defense policy in an era of fiscal austerity and persistent conflict.
Satisfy these requirements for continuity of business : Business disruption has become a serious concern of the company president who wants to see a detailed plan before the work begins. She explains that current work must be completed in the old hangar and all new work is to being in the new hangar. As t..

Reviews

Write a Review

Finance Basics Questions & Answers

  How sensitive is the acquisition value to these estimates

A major concern in any DCF valuation is the accuracy of both the terminal (long-term) growth rate and discount rate estimates. How sensitive is the acquisition value to these estimates?

  How do companies generate ideas for capital projects give

the capital budgeting process. letrsquos start by answering these questions1.discuss differences between cash flow and

  What is the expected return on this investment

If Marlene's expectation are correct, what will the proce pf this bond be in 2 year? 3. What is the expected return on this investment? 4. Should this investment be made? Why?

  Q how to set up spreadsheet for questions given below i do

q. how to set up spreadsheet for questions given below. i do not know how it must be set up even.suppose that the

  Would you invest in the stock market today

Given the present economic turmoil and relatively low interest rates, and given your individual risk profile/aversion, would you invest in the stock market today? Why or why not?

  What is the length of the firm operating cycle

Kurt's Enterprises has a receivables turnover rate of 11.8, a payables turnover rate of 12.4, and an inventory turnover rate of 15.6. What is the length of the firm's operating cycle?

  You are analyzing a project and have developed the

you are analyzing a project and have developed the following estimates unit sales 1320 price per unit 79 variable

  What should the stock sell for today

Dividends are expected to grow at a constant rate of 4% for the next two years, at which point the stock is expected to sell for $56.00. If investors require a rate of return on Modem's common stock of 18%, what should the stock sell for today?

  Describe the capm and the apt

Describe the CAPM and the APT and identify the factor(s) that determines returns in each?

  Scribe agency conflict and the measures

scribe agency conflict and the measures that can reduce the possibility of such a conflict in a corporation.

  What would franklins monthly mortgage payment be

Franklins bank has offered him a standard 30 year old mortgage with a 5.7% nominal interest rate. what would Franklins monthly mortgage payment be?

  Cost of common equity-dcf

Summerdahl Resorts common stock is currently trading at $36 a share. The stock is expected to pay a dividend of $3.00 a share at the end of the year (D1=$3.00, and the dividend is expected to grow at a constant rate of 5% a year. What is the cost ..

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