Question
The topic is continuous, it is difficult to ask questions separately, you can take it as I asked 9 questions, the first two questions I
The topic is continuous, it is difficult to ask questions separately, you can take it as I asked 9 questions, the first two questions I finished, the back will not do, I put my answer also po up
Corporate Finance
Assignment Aims
The assignment aims to enable you to apply some of what you will learn from Topics 1 & 2 - in particular, return and risk, and the future value of a lump sum investment. However, the assignment also aims to get you to think ahead about some of the things that you will learn from Topics 5 & 6 - in particular, portfolio investment.
Assignment Setup
Imagine that you are back at the end of the fourth quarter of 1999 (Q4 1999). You are 45 years of age and have a good job but no children to think about. You have just been gifted 10,000 and will invest all of the money for the next 20 years. You have the following five portfolios in mind:
UK large market capitalisation stocks (from various industries);
UK small market capitalisation stocks (from various industries);
UK 3 months Government bills;
UK 10+ years Government bonds; and
UK 10+ years investment grade corporate bonds (from various industries).
You can only invest in one of the five portfolios, and once invested the money will need to remain in your chosen portfolio for the next 20 years. In other words, you cannot spread the 10,000 across multiple portfolios, nor move between portfolios during the investment period.
Assignment Tasks
1. without the need any computations, rank the five portfolios from likely greatest to likely least risk. Explain your reasoning behind this ranking.
UK small market capitalisation stocks(from various industries)UK large market capitalisation stocks(from various industries)UK 10+ years investment grade corporate bonds (from various industries)UK 10+ years Government bondsUK 3 months Government bills
Equity claims on limited liability firms represent the share or stock value of a stake in a firm. Value is returned to the investor by the payment of dividends and by capital appreciation driven by future dividends, both of which are uncertain, therefore equity returns are risky. Compared with large companies, small companies have a smaller capital volume, so they have weaker risk tolerance but stronger growth and therefore higher risks.
Bonds/long-term fixed rate investment accounts are all long lived investments which despite having a known long-term rate of interest, can fluctuate in value due to shorter term changes in interest rates. With regards to corporate bonds, government bonds are backed by the government's credibility which means expected repayment is more reliable and punctual so it is less risky.
Short-term bills whose rate of return is known at the beginning of the investment, as long as the issuer does not default, the rates of return can be perceived as risk free for the period of investment. Thus, UK3 months Government bills involve the least risk.
2. Which of the five portfolios will you choose to invest in? Explain your reasoning for selecting this portfolio.
I would choose the UK small market capitalisation stocks to invest.
UK smaller company stocks have returned six times the amount of large companies and yet may still be good value for investors.
Because of their size, "small caps" have the potential to grow more quickly.The quicker a company can grow its earnings in a sustainable way the more attractive it is to investors.
Once a small cap company starts to deliver you could potentially get a double whammy effect of growth and rerating. A small cap stock might go from a P/E of 10 to 20 times once it starts to grow and get discovered.That is much more difficult to achieve with larger companies.
I am 45 years old and have a good job but no children, which means I have a sustainable income but no household expenditures and considerations. Since the 10,000 came at no cost, I would take it to bet a higher return in the next 20 years.
The accompanying Excel file under Assignments on the module's Canvas site contains three sheets of data.
The first sheet (Large stocks) contains information and quarterly data for the UK large market capitalisation stocks. The portfolio constituents are listed first, together with each stock's industry. Return index data for each stock (which accounts for the reinvestment of all dividends) is then provided for Q4 1999-Q2 2020, followed by market capitalisation data for each stock (in million) for the same period.
The second sheet (Small stocks) contains information and quarterly data for the UK small market capitalisation stocks. The portfolio constituents are listed first, together with each stock's industry. Return index data for each stock (which accounts for the reinvestment of all dividends) is then provided for Q4 1999-Q2 2020, followed by market capitalisation data for each stock (in million) for the same period.
The third sheet (Bills, bonds, and inflation) contains quarterly data for the UK 3 months Government bills, 10+ years Government bonds, and UK 10+ years investment grade corporate bonds. Return index data for each portfolio (which accounts for the reinvestment of all interest) is provided for Q4 1999-Q2 2020. This sheet also contains quarterly data for the UK consumer price (inflation) index for the same period.
Note: While the bills and the bonds are provided in portfolio (combined) form this is not the case for the large stocks and the small stocks. It will therefore be necessary for you to do what is required below by constructing the portfolio containing all of the large stocks and the portfolio containing all of the small stocks. Both of these portfolios should be market capitalization weighted. Also, the data that you are provided with for each of the five portfolios is in quarterly return index form and not therefore in quarterly return form.
Required:
3. You invest the gift money at the end of Q4 1999. Based on the portfolio that you have chosen in part 2, what is the future value of your 10,000 lump sum investment by the end of Q2 2020? (Show all of your workings.)
4. Were you to have instead chosen to invest in one of the other (four) portfolios, what would the future value of your 10,000 lump sum investment have been by the end of Q2 2020 for each of these portfolios? (Show all of your workings.)
5. Graph the quarterly movements in the future values for each of the five portfolios over the entire investment period. Do you regret having chosen the portfolio that you did in part 2? Explain.
6. Construct and chart a quarterly return frequency distribution for each of the five portfolios over the entire investment period. Do these distributions resemble a normal distribution? Explain.
7. Compute the arithmetic mean and the standard deviation of the quarterly returns for each of the five portfolios over the entire investment period. (Show all of your workings.) Tabulate and graph your results. How do these results compare to your ranking based on risk in part 1? What do you conclude about return and risk?
8. Graph the quarterly returns for each of the five portfolios over the entire investment period. What do you conclude about risk? Using Library online databases and/or the World Wide Web, identify and reference some macroeconomic news that likely accounts for the three largest peaks/troughs in the quarterly returns history for the large stocks portfolio only.
9. You have so far not taken inflation into consideration. Using the data provided for the consumer price index, compute the average quarterly inflation rate over the entire investment period. (Show all of your workings.) Based on the arithmetic means of the nominal quarterly returns that you have computed in part 7, did all five of the portfolios earn on average a real quarterly return that exceeded inflation? What do you conclude?
10. Assuming that the least risky of the five portfolios, based on what you have found in part 7, can for all intents and purposes be regarded as a risk-free investment, and ignoring inflation, compute and tabulate the arithmetic mean of the quarterly risk premium (return in excess of the risk-free return) for each of the other (four) portfolios. (Show all of your workings.) What do these results tell you?
11. Perhaps by utilising some of what you have found from the above historical and quarterly analysis, and again ignoring inflation, provide an estimate of the expected and annualised risk premium from the end of Q2 2020 until the end of Q2 2021 for each of the five portfolios. (Show all of your workings, and state all of the assumptions that you make.)
. i' ST ST MAN S... 11 wa - .. . POWSTAWI . M. I.... LSI & . AS98 ENJA UK bill, bond, and inflation indices Index 3 MONTHS GOVERNMENT BILLS (ECUKP 10+ YEARS GOVERNMENT BONDS (AUKG 10+ YEARS INVESTMENT GRADE CORPORATE BONDS (SPL CONSUMER PRICES (INFLATIC Q4 1995 364.25 119.77 72.46 Q1 2000 360.91 118.69 72.14 Q2 2000 370.83 118.26 72.74 Q3 2006 369.55 11829 72.71 Q4 2000 385.73 128.63 Q1 2001 73.15 389.31 129.49 72.77 Q2 2001 370.81 128.13 03 2001 388.00 136.50 73.62 Q4 2001 1.151.74 101.86 14213 73.50 Q1 2002 1.496.08 389.00 140.46 73.59 Q2 2002 1,511.97 382.74 139.20 74.53 Q3 2002 1,527.14 420.89 148.76 74.58 Q4 2002 1,512.16 413.19 146.23 75.06 Q1 2003 1,557.10 437.57 15366 74.99 Q2 2003 1,571.08 440.34 159.B 75.48 Q3 2003 1,584.83 427.91 157.99 75.61 Q4 2003 1,599.82 42046 157.32 76.02 Q1 2004 1,615.98 435.59 161.05 75.94 Q2 2004 1,633.63 427.21 157.54 76.53 Q3 2004 1.653.77 141.93 161.13 76.56 Q4 2004 1,673.88 462.49 172.31 77.11 Q1 2005 1,693.13 460.69 174.94 77.26 Q2 2005 1,714.81 488.15 180.93 78.00 Q3 2004 1.734.34 500.88 187.35 78.40 Q4 2005 1,754, 50831 189.25 Q1 200 /H.76 1,774.48 525.64 194.38 78.75 Q2 200 1,795.11 501.24 187.68 Q3 200 79.79 1,816.75 51671 192.03 Q4 200 80.30 1,839.93 527.61 196.65 $ Q1 2007 80.19 1,864.63 515.89 194.20 81.00 Q2 2007 1,891.18 492.91 187.56 81.53 Q3 2007 1,921.00 507,45 18660 81.74 Q4 2002 1,951.76 524.04 189.CB 82.59 Q1 200 1,980.36 534.67 183.08 82.92 Q2 2008 2009,51 516.68 181.77 84.60 Q3 2008 2,031.90) 541.73 187.45 $15.66 Q4 200 2,067.02 569.79 169.90 85.76 01 2005 570.71 173.11 89.12 Q2 2009 561.79 173.55 96.36 Q3 2005 605.64 202.31 86.93 Q4 2005 607.28 87.56 Q1 2010 576.53 20692 88.21 Q2 2010 612 15 21432 $19.95 $ 03 2010 2,106.96 656.24 232.30 89.61 Q4 2016 2.111.17 626.01 220.95 90.52 Q1 2012 2.115.45 624.03 224.21 91.85 Q2 2011 2,120.04 66002 234.54 Q3 2011 2,124.38 702.56 234.31 93.63 Q4 2011 2,129.62 780.36 238.64 Q1 2012 94.72 2,135,32 777.22 252.46 95.06 Q2 2012 2,140.73 843.90 260.72 95.63 Q3 2012 2,145.41 840.43 277.95 96.00 Q4 2012 2.148,57 828.25 285.15 97.25 Q1 2012 2,151.28 $115.42 285,50 97.69 Q2 2013 2,154.22 806.57 293.08 98.40 Q3 2013 2.156.68 770.56 281.88 98.70 Q4 2013 2.159,67 774.23 287.68 99.30 Q1 2014 2,162.48 202.43 296.94 99.39 Q2 2014 2,165.44 812.85 303.41 100.00 Q3 2014 2.168.78 876.37 318.98 100.13 Q4 2014 2.172.10 930). 18 32873 100.23 Q1 2015 2,175.41 958.21 344.53 99.49 Q2 2015 2,179.01 957.41 340.23 100.07 Q3 2015 2.182.78 962.83 33061 100.14 Q4 2015 2,106.14 985.64 100.29 Q1 2016 2,191.28 1,023,42 332.13 99.84 Q2 2016 2,195.38 1.051.59 100 43 Q3 2016 2.190.47 1.230.85 100.87 Q4 2016 2,201.26 1.074.73 101.51 Q1 2017 2,208.82 1.131.07 101.98 Q2 2017 1.153.26 Q3 2017 103.18 1.159.55 103.11 Q4 2017 1.149.03 104.58 Q1 2018 1,131.01 101.75 Q2 2018 1.164.37 106.67 Q3 2012 1.166.11 106.32 Q4 2018 1.132.36 106.96 Q1 2014 2.233.27 1171.70 106.71 Q2 2019 2.233.14 1.253.41 Q3 2013 2,242.58 107.84 1.376.99 108.27 Q4 2018 2.247.16 1,308.75 108.46 Q1 2020 1.387.46 108.49 Q2 2020 2.254.46 1.461.19 108.50 2.251.61 . i' ST ST MAN S... 11 wa - .. . POWSTAWI . M. I.... LSI & . AS98 ENJA UK bill, bond, and inflation indices Index 3 MONTHS GOVERNMENT BILLS (ECUKP 10+ YEARS GOVERNMENT BONDS (AUKG 10+ YEARS INVESTMENT GRADE CORPORATE BONDS (SPL CONSUMER PRICES (INFLATIC Q4 1995 364.25 119.77 72.46 Q1 2000 360.91 118.69 72.14 Q2 2000 370.83 118.26 72.74 Q3 2006 369.55 11829 72.71 Q4 2000 385.73 128.63 Q1 2001 73.15 389.31 129.49 72.77 Q2 2001 370.81 128.13 03 2001 388.00 136.50 73.62 Q4 2001 1.151.74 101.86 14213 73.50 Q1 2002 1.496.08 389.00 140.46 73.59 Q2 2002 1,511.97 382.74 139.20 74.53 Q3 2002 1,527.14 420.89 148.76 74.58 Q4 2002 1,512.16 413.19 146.23 75.06 Q1 2003 1,557.10 437.57 15366 74.99 Q2 2003 1,571.08 440.34 159.B 75.48 Q3 2003 1,584.83 427.91 157.99 75.61 Q4 2003 1,599.82 42046 157.32 76.02 Q1 2004 1,615.98 435.59 161.05 75.94 Q2 2004 1,633.63 427.21 157.54 76.53 Q3 2004 1.653.77 141.93 161.13 76.56 Q4 2004 1,673.88 462.49 172.31 77.11 Q1 2005 1,693.13 460.69 174.94 77.26 Q2 2005 1,714.81 488.15 180.93 78.00 Q3 2004 1.734.34 500.88 187.35 78.40 Q4 2005 1,754, 50831 189.25 Q1 200 /H.76 1,774.48 525.64 194.38 78.75 Q2 200 1,795.11 501.24 187.68 Q3 200 79.79 1,816.75 51671 192.03 Q4 200 80.30 1,839.93 527.61 196.65 $ Q1 2007 80.19 1,864.63 515.89 194.20 81.00 Q2 2007 1,891.18 492.91 187.56 81.53 Q3 2007 1,921.00 507,45 18660 81.74 Q4 2002 1,951.76 524.04 189.CB 82.59 Q1 200 1,980.36 534.67 183.08 82.92 Q2 2008 2009,51 516.68 181.77 84.60 Q3 2008 2,031.90) 541.73 187.45 $15.66 Q4 200 2,067.02 569.79 169.90 85.76 01 2005 570.71 173.11 89.12 Q2 2009 561.79 173.55 96.36 Q3 2005 605.64 202.31 86.93 Q4 2005 607.28 87.56 Q1 2010 576.53 20692 88.21 Q2 2010 612 15 21432 $19.95 $ 03 2010 2,106.96 656.24 232.30 89.61 Q4 2016 2.111.17 626.01 220.95 90.52 Q1 2012 2.115.45 624.03 224.21 91.85 Q2 2011 2,120.04 66002 234.54 Q3 2011 2,124.38 702.56 234.31 93.63 Q4 2011 2,129.62 780.36 238.64 Q1 2012 94.72 2,135,32 777.22 252.46 95.06 Q2 2012 2,140.73 843.90 260.72 95.63 Q3 2012 2,145.41 840.43 277.95 96.00 Q4 2012 2.148,57 828.25 285.15 97.25 Q1 2012 2,151.28 $115.42 285,50 97.69 Q2 2013 2,154.22 806.57 293.08 98.40 Q3 2013 2.156.68 770.56 281.88 98.70 Q4 2013 2.159,67 774.23 287.68 99.30 Q1 2014 2,162.48 202.43 296.94 99.39 Q2 2014 2,165.44 812.85 303.41 100.00 Q3 2014 2.168.78 876.37 318.98 100.13 Q4 2014 2.172.10 930). 18 32873 100.23 Q1 2015 2,175.41 958.21 344.53 99.49 Q2 2015 2,179.01 957.41 340.23 100.07 Q3 2015 2.182.78 962.83 33061 100.14 Q4 2015 2,106.14 985.64 100.29 Q1 2016 2,191.28 1,023,42 332.13 99.84 Q2 2016 2,195.38 1.051.59 100 43 Q3 2016 2.190.47 1.230.85 100.87 Q4 2016 2,201.26 1.074.73 101.51 Q1 2017 2,208.82 1.131.07 101.98 Q2 2017 1.153.26 Q3 2017 103.18 1.159.55 103.11 Q4 2017 1.149.03 104.58 Q1 2018 1,131.01 101.75 Q2 2018 1.164.37 106.67 Q3 2012 1.166.11 106.32 Q4 2018 1.132.36 106.96 Q1 2014 2.233.27 1171.70 106.71 Q2 2019 2.233.14 1.253.41 Q3 2013 2,242.58 107.84 1.376.99 108.27 Q4 2018 2.247.16 1,308.75 108.46 Q1 2020 1.387.46 108.49 Q2 2020 2.254.46 1.461.19 108.50 2.251.61
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started