Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Run three regressions of the sixty monthly returns on the stock minus the monthly return on the risk-free rate against the market risk premiums (monthly

  1. Run three regressions of the sixty monthly returns on the stock minus the monthly return on the risk-free rate against the market risk premiums (monthly returns on the S&P 500 Index the monthly risk-free rate). Show all the results.
  2. The three Regressions are conducted as follows: (The monthly return on stock i, in period t) (The monthly risk-free rate in month t) = Alpha + Beta[(Monthly returns in period t) on the S&P 500 Index The corresponding risk-free rate in month t] + an error term epsilon (in month t)

The stock is Tesla I am providing all returns on the stock and on the monthly risk- free rate as follows: Monthly returns from August 31, 2018 August 31, 2023

returns on stock

  1. September 2018: -21.27%
  2. October 2018: 8.59%
  3. November 2018: -6.11%
  4. December 2018: -10.57%
  5. January 2019: 3.52%
  6. February 2019: 21.47%
  7. March 2019: -14.69%
  8. April 2019: 1.74%
  9. May 2019: -14.80%
  10. June 2019: -3.87%
  11. July 2019: 7.30%
  12. August 2019: 3.61%
  13. September 2019: -8.73%
  14. October 2019: 4.22%
  15. November 2019: 10.20%
  16. December 2019: 56.68%
  17. January 2020: 145.33%
  18. February 2020: -11.87%
  19. March 2020: -43.33%
  20. April 2020: -21.92%
  21. May 2020: -16.21%
  22. June 2020: -13.87%
  23. July 2020: -24.67%
  24. August 2020: 75.14%
  25. September 2020 (adjusted for the stock split): -66.59%
  26. October 2020: -24.97%
  27. November 2020: 47.74%
  28. December 2020: 47.44%
  29. January 2021: 20.06%
  30. February 2021: -12.13%
  31. March 2021: -6.24%
  32. April 2021: 15.12%
  33. May 2021: -12.29%
  34. June 2021: -2.06%
  35. July 2021: 2.59%
  36. August 2021: 7.07%
  37. September 2021: 5.40%
  38. October 2021: 43.64%
  39. November 2021: 2.77%
  40. December 2021: -7.68%
  41. January 2022: -11.35%
  42. February 2022: -7.08%
  43. March 2022: 23.79%
  44. April 2022: -19.21%
  45. May 2022: -12.92%
  46. June 2022: -11.20%
  47. July 2022: 32.39%
  48. August 2022: -7.24%
  49. September 2022: -3.74%
  50. October 2022: -14.20%
  51. November 2022: -14.42%
  52. December 2022: -36.69%
  53. January 2023: 40.61%
  54. February 2023: 18.74%
  55. March 2023: 0.85%
  56. April 2023: -20.80%
  57. May 2023: 24.12%
  58. June 2023: 28.47%
  59. July 2023: 2.16%
  60. August 2023: -3.50%

Monthly risk-free rates on 30-year T- Bonds

  1. 9/1/2018: 3.197%
  2. 10/1/2018: 3.402%
  3. 11/1/2018: 3.311%
  4. 12/1/2018: 3.02%
  5. 1/1/2019: 3.005%
  6. 2/1/2019: 3.083%
  7. 3/1/2019: 2.822%
  8. 4/1/2019: 2.94%
  9. 5/1/2019: 2.583%
  10. 6/1/2019: 2.528%
  11. 7/1/2019: 2.527%
  12. 8/1/2019: 1.97%
  13. 9/1/2019: 2.121%
  14. 10/1/2019: 2.176%
  15. 11/1/2019: 2.202%
  16. 12/1/2019: 2.389%
  17. 1/1/2020: 2.015%
  18. 2/1/2020: 1.671%
  19. 3/1/2020: 1.351%
  20. 4/1/2020: 1.266%
  21. 5/1/2020: 1.407%
  22. 6/1/2020: 1.409%
  23. 7/1/2020: 1.198%
  24. 8/1/2020: 1.452%
  25. 9/1/2020: 1.451%
  26. 10/1/2020: 1.64%
  27. 11/1/2020: 1.573%
  28. 12/1/2020: 1.646%
  29. 1/1/2021: 1.858%
  30. 2/1/2021: 2.182%
  31. 3/1/2021: 2.425%
  32. 4/1/2021: 2.301%
  33. 5/1/2021: 2.263%
  34. 6/1/2021: 2.065%
  35. 7/1/2021: 1.897%
  36. 8/1/2021: 1.927%
  37. 9/1/2021: 2.092%
  38. 10/1/2021: 1.942%
  39. 11/1/2021: 1.787%
  40. 12/1/2021: 1.905%
  41. 1/1/2022: 2.098%
  42. 2/1/2022: 2.182%
  43. 3/1/2022: 2.448%
  44. 4/1/2022: 2.947%
  45. 5/1/2022: 3.057%
  46. 6/1/2022: 3.119%
  47. 7/1/2022: 2.974%
  48. 8/1/2022: 3.255%
  49. 9/1/2022: 3.765%
  50. 10/1/2022: 4.204%
  51. 11/1/2022: 3.822%
  52. 12/1/2022: 3.975%
  53. 1/1/2023: 3.661%
  54. 2/1/2023: 3.931%
  55. 3/1/2023: 3.689%
  56. 4/1/2023: 3.678%
  57. 5/1/2023: 3.856%
  58. 6/1/2023: 3.855%
  59. 7/1/2023: 4.019%
  60. 8/1/2023: 4.204%

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Financial Literacy And Money Script A Caribbean Perspective

Authors: Christine Sahadeo

1st Edition

3319770748, 978-3319770741

More Books

Students also viewed these Finance questions

Question

What is the most important characteristic of a NOS?

Answered: 1 week ago

Question

Organize and support your main points

Answered: 1 week ago

Question

Move smoothly from point to point

Answered: 1 week ago

Question

Outlining Your Speech?

Answered: 1 week ago