Question

In: Accounting

Things to research and report on should include, but are not limited to

Solutions

Expert Solution

Stock Valuation

  Tesla Returns  
Date Adj Close Stock Returns(%)
01/05/2016 44.646  
01/06/2016 42.456001 -4.91%
01/07/2016 46.958 10.60%
01/08/2016 42.402 -9.70%
01/09/2016 40.806 -3.76%
01/10/2016 39.546001 -3.09%
01/11/2016 37.880001 -4.21%
01/12/2016 42.737999 12.82%
01/01/2017 50.386002 17.90%
01/02/2017 49.998001 -0.77%
01/03/2017 55.66 11.32%
01/04/2017 62.813999 12.85%
01/05/2017 68.202003 8.58%
01/06/2017 72.321999 6.04%
01/07/2017 64.694 -10.55%
01/08/2017 71.18 10.03%
01/09/2017 68.220001 -4.16%
01/10/2017 66.306 -2.81%
01/11/2017 61.77 -6.84%
01/12/2017 62.27 0.81%
01/01/2018 70.862 13.80%
01/02/2018 68.612 -3.18%
01/03/2018 53.226002 -22.42%
01/04/2018 58.779999 10.43%
01/05/2018 56.945999 -3.12%
01/06/2018 68.589996 20.45%
01/07/2018 59.627998 -13.07%
01/08/2018 60.332001 1.18%
01/09/2018 52.953999 -12.23%
01/10/2018 67.463997 27.40%
01/11/2018 70.096001 3.90%
01/12/2018 66.559998 -5.04%
01/01/2019 61.403999 -7.75%
01/02/2019 63.976002 4.19%
01/03/2019 55.972 -12.51%
01/04/2019 47.737999 -14.71%
01/05/2019 37.032001 -22.43%
01/06/2019 44.692001 20.68%
01/07/2019 48.321999 8.12%
01/08/2019 45.122002 -6.62%
01/09/2019 48.174 6.76%
01/10/2019 62.984001 30.74%
01/11/2019 65.987999 4.77%
01/12/2019 83.666 26.79%
01/01/2020 130.113998 55.52%
01/02/2020 133.598007 2.68%
01/03/2020 104.800003 -21.56%
01/04/2020 156.376007 49.21%
01/05/2020 167 6.79%
01/06/2020 215.962006 29.32%
01/07/2020 286.152008 32.50%
01/08/2020 498.320007 74.15%
01/09/2020 429.01001 -13.91%
01/10/2020 388.040009 -9.55%
01/11/2020 567.599976 46.27%
01/12/2020 705.669983 24.33%
01/01/2021 793.530029 12.45%
01/02/2021 675.5 -14.87%
01/03/2021 667.929993 -1.12%
01/04/2021 661.75 -0.93%
Beta 2.037176102  
Risk free rate 1.62% Long term treasury bond rate
Risk Premium 4.72% Equity risk premium for US securities in 2021
    (http://pages.stern.nyu.edu/~adamodar/New_Home_Page/datafile/ctryprem.html)
CAPM 11.24%  
Stock Returns 6.23%  
     
Thus, the stock is giving lower returns in comparison to returns
calculated by CAPM model for assumption of market risk be investors.
Therefore, the securities are overvalued.
  S and P Returns  
Date Adj Close Returns
01/05/2016 2096.95  
01/06/2016 2098.86 0.09%
01/07/2016 2173.6 3.56%
01/08/2016 2170.95 -0.12%
01/09/2016 2168.27 -0.12%
01/10/2016 2126.15 -1.94%
01/11/2016 2198.81 3.42%
01/12/2016 2238.83 1.82%
01/01/2017 2278.87 1.79%
01/02/2017 2363.64 3.72%
01/03/2017 2362.72 -0.04%
01/04/2017 2384.2 0.91%
01/05/2017 2411.8 1.16%
01/06/2017 2423.41 0.48%
01/07/2017 2470.3 1.93%
01/08/2017 2471.65 0.05%
01/09/2017 2519.36 1.93%
01/10/2017 2575.26 2.22%
01/11/2017 2647.58 2.81%
01/12/2017 2673.61 0.98%
01/01/2018 2823.81 5.62%
01/02/2018 2713.83 -3.89%
01/03/2018 2640.87 -2.69%
01/04/2018 2648.05 0.27%
01/05/2018 2705.27 2.16%
01/06/2018 2718.37 0.48%
01/07/2018 2816.29 3.60%
01/08/2018 2901.52 3.03%
01/09/2018 2913.98 0.43%
01/10/2018 2711.74 -6.94%
01/11/2018 2760.17 1.79%
01/12/2018 2506.85 -9.18%
01/01/2019 2704.1 7.87%
01/02/2019 2784.49 2.97%
01/03/2019 2834.4 1.79%
01/04/2019 2945.83 3.93%
01/05/2019 2752.06 -6.58%
01/06/2019 2941.76 6.89%
01/07/2019 2980.38 1.31%
01/08/2019 2926.46 -1.81%
01/09/2019 2976.74 1.72%
01/10/2019 3037.56 2.04%
01/11/2019 3140.98 3.40%
01/12/2019 3230.78 2.86%
01/01/2020 3225.52 -0.16%
01/02/2020 2954.22 -8.41%
01/03/2020 2584.59 -12.51%
01/04/2020 2912.43 12.68%
01/05/2020 3044.31 4.53%
01/06/2020 3100.29 1.84%
01/07/2020 3271.12 5.51%
01/08/2020 3500.31 7.01%
01/09/2020 3363 -3.92%
01/10/2020 3269.96 -2.77%
01/11/2020 3621.63 10.75%
01/12/2020 3756.07 3.71%
01/01/2021 3714.24 -1.11%
01/02/2021 3811.15 2.61%
01/03/2021 3889.14 2.05%
01/04/2021 3756.07 -3.42%

Bond Valuation

Bond valuation    
     
Coupon Rate 5.30%

 


Coupon Rate 5.30%

Related Solutions

What three things should all annual reports include?
What three things should all annual reports include?
research about Fungal infection common in Oman and its emergence The research report will include the...
research about Fungal infection common in Oman and its emergence The research report will include the following information about Fungal infection a.MOT( mode of transmission) b.CA (causative agent) c.signs and symptoms of infection d.laboratory test e.treatment or antimicrobial therapy f. appropriate measures to prevent or control the infection.
Write a report a bout the buses used in computer. Your report should include the following:...
Write a report a bout the buses used in computer. Your report should include the following: 1- One page about all buses used in computer. and each bus type is in one paragraph. 2- The second page is the differences between ISA bus and PCI bus
Write a brief report on KRACK Attack . The report should include how the attack works...
Write a brief report on KRACK Attack . The report should include how the attack works ? How the devices can be protected against this attack
cloud computing (research paper): The report will contain a more in depth explanation. The report should...
cloud computing (research paper): The report will contain a more in depth explanation. The report should be two pages long in MLA format.
Normative economic analysis tends to include the way someone thinks things should be or ought to...
Normative economic analysis tends to include the way someone thinks things should be or ought to be. generate testable hypotheses. lead to empirical testing of data. involve descriptive statements.
Prepare a research paper on the various methods of depreciation. Your research should include: An analysis...
Prepare a research paper on the various methods of depreciation. Your research should include: An analysis of why depreciation is an allocation process and not valuation process. A description of the following depreciation methods: ACRS MACRS traight-line depreciation. An explanation of the how cost recovery is different for natural resources. An explanation of why there could be a difference between the depreciation amount on a company’s book (book depreciation) and the depreciation amount on a company’s tax return (tax depreciation).
. For the questions, your report should include the formulated hypotheses, steps of calculation and formulas,...
. For the questions, your report should include the formulated hypotheses, steps of calculation and formulas, your answers and conclusions, and the results from Excel. A retail company has started a new advertising campaign in order to increase sales. In the past, the mean spending in both the 18–35 and 35+ age groups was at most $70.00. a. Formulate a hypothesis test to determine if the mean spending has statistically increased to more than $70.00. b. After the new advertising...
Please write formal report on interview a accountant. 4-6 paragraph. The written report should include (introduction,...
Please write formal report on interview a accountant. 4-6 paragraph. The written report should include (introduction, body, conclusions/summary). Cite at least 5 outside sources using in-text citations in APA format (your interviewee counts as one of the sources.
Company: The A2 Milk Company Limited (A2M) Research Based Report – Corporate Governance & Risk Management...
Company: The A2 Milk Company Limited (A2M) Research Based Report – Corporate Governance & Risk Management As a new accounting graduate, you have just joined the financial reporting unit of a company. Your company is listed in Australian Securities Exchange (ASX). The Chief Financial Officer (CFO) approaches you with your first task. In the latest Board meeting, directors of your company expressed concerns about issues related to corporate governance and particularly risk management. New and emerging disruptions to the global...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT