Editing Johnson & Johnson
The edit can be undone. Please check the comparison below to verify that this is what you want to do, and then publish the changes below to finish undoing the edit.
Latest revision | Your text | ||
Line 1,656: | Line 1,656: | ||
!Input value | !Input value | ||
!Additional information | !Additional information | ||
! | |||
|- | |- | ||
|Risk-free rate (%) | |Risk-free rate (%) | ||
|4.297% | |4.297% | ||
|Here, the risk free rate is the US 30 year treasury bond, and is calculated as at 3rd September 2023 | |Here, the risk free rate is the US 30 year treasury bond, and is calculated as at 3rd September 2023. Research suggests that for the risk-free rate, it's best to use one that has the same or similar maturity to the estimated remaining lifespan of the company. Here, we have assumed that the estimated lifespan of the company is 50 years, so we have used the longest maturity, which is 30 years. | ||
| | |||
|- | |- | ||
|Beta | |Beta | ||
|0.7116 | |0.7116 | ||
|Here, to estimate the adjusted beta, we used the iShares MSCI World ETF to represent the market portfolio; and in terms of the time period and frequency of observations, we used five years of monthly data (i.e. 60 observations in total), which is supported by a study and is the most common choice. The beta value in a future period has been found to be on average closer to the mean value of 1.0, and because valuation is forward-looking, it is logical to adjust the raw beta so it more/most accurately predicts a future beta. | |Here, to estimate the adjusted beta, we used the iShares MSCI World ETF to represent the market portfolio; and in terms of the time period and frequency of observations, we used five years of monthly data (i.e. 60 observations in total), which is supported by a study and is the most common choice. The beta value in a future period has been found to be on average closer to the mean value of 1.0, and because valuation is forward-looking, it is logical to adjust the raw beta so it more/most accurately predicts a future beta. | ||
| | |||
|- | |- | ||
|Equity risk premium (%) | |Equity risk premium (%) | ||
|7.98% | |7.98% | ||
|Research suggests that for the region of equity risk premium, it's best to use one that is the same or similar to the region of the beta market portfolio. Here, the region of the beta market portfolio is the world/global, so we have used the world/global region for the equity risk premium, and is calculated as at 5th January 2023. | |Research suggests that for the region of equity risk premium, it's best to use one that is the same or similar to the region of the beta market portfolio. Here, the region of the beta market portfolio is the world/global, so we have used the world/global region for the equity risk premium, and is calculated as at 5th January 2023. | ||
| | |||
|- | |- | ||
|Cost of equity (%) | |Cost of equity (%) | ||
|9.98% | |9.98% | ||
|Cost of equity = Risk-free rate + Beta x Equity risk premium. | |Cost of equity = Risk-free rate + Beta x Equity risk premium. | ||
| | |||
|} | |} | ||
Line 1,818: | Line 1,823: | ||
|01/10/2018 | |01/10/2018 | ||
|85.25 | |85.25 | ||
| | |16.24 | ||
| | | | ||
| | | | ||
Line 1,824: | Line 1,829: | ||
|01/11/2018 | |01/11/2018 | ||
|86.21 | |86.21 | ||
| | |17.1 | ||
|1% | |1% | ||
|5% | |5% | ||
Line 1,830: | Line 1,835: | ||
|01/12/2018 | |01/12/2018 | ||
|78.87 | |78.87 | ||
| | |16 | ||
| -9% | | -9% | ||
| - | | -6% | ||
|- | |- | ||
|01/01/2019 | |01/01/2019 | ||
|84.96 | |84.96 | ||
| | |23.375 | ||
|8% | |8% | ||
| | |46% | ||
|- | |- | ||
|01/02/2019 | |01/02/2019 | ||
|87.49 | |87.49 | ||
| | |24.75 | ||
|3% | |3% | ||
|6% | |||
|- | |- | ||
|01/03/2019 | |01/03/2019 | ||
|88.79 | |88.79 | ||
| | |28.6 | ||
|1% | |1% | ||
| | |16% | ||
|- | |- | ||
|01/04/2019 | |01/04/2019 | ||
|92.09 | |92.09 | ||
| | |21.425 | ||
|4% | |4% | ||
| | | -25% | ||
|- | |- | ||
|01/05/2019 | |01/05/2019 | ||
|86.76 | |86.76 | ||
| | |21.25 | ||
| -6% | | -6% | ||
| - | | -1% | ||
|- | |- | ||
|01/06/2019 | |01/06/2019 | ||
|91.02 | |91.02 | ||
| | |21.25 | ||
|5% | |5% | ||
| | |0% | ||
|- | |- | ||
|01/07/2019 | |01/07/2019 | ||
|91.86 | |91.86 | ||
| | |18.68 | ||
|1% | |1% | ||
| - | | -12% | ||
|- | |- | ||
|01/08/2019 | |01/08/2019 | ||
|89.84 | |89.84 | ||
| | |17.9 | ||
| -2% | | -2% | ||
| - | | -4% | ||
|- | |- | ||
|01/09/2019 | |01/09/2019 | ||
|91.78 | |91.78 | ||
| | |16.03 | ||
|2% | |2% | ||
| | | -10% | ||
|- | |- | ||
|01/10/2019 | |01/10/2019 | ||
|94.12 | |94.12 | ||
| | |16.25 | ||
|3% | |3% | ||
| | |1% | ||
|- | |- | ||
|01/11/2019 | |01/11/2019 | ||
|96.76 | |96.76 | ||
| | |16.5 | ||
|3% | |3% | ||
| | |2% | ||
|- | |- | ||
|01/12/2019 | |01/12/2019 | ||
|98.78 | |98.78 | ||
| | |16.5 | ||
|2% | |2% | ||
| | |0% | ||
|- | |- | ||
|01/01/2020 | |01/01/2020 | ||
|97.73 | |97.73 | ||
| | |16.5 | ||
| -1% | | -1% | ||
| | |0% | ||
|- | |- | ||
|01/02/2020 | |01/02/2020 | ||
|89.67 | |89.67 | ||
| | |11.95 | ||
| -8% | | -8% | ||
| - | | -28% | ||
|- | |- | ||
|01/03/2020 | |01/03/2020 | ||
|77.93 | |77.93 | ||
| | |13 | ||
| -13% | | -13% | ||
| | |9% | ||
|- | |- | ||
|01/04/2020 | |01/04/2020 | ||
|86.36 | |86.36 | ||
| | |13.75 | ||
|11% | |11% | ||
| | |6% | ||
|- | |- | ||
|01/05/2020 | |01/05/2020 | ||
|90.7 | |90.7 | ||
| | |15.95 | ||
|5% | |5% | ||
| | |16% | ||
|- | |- | ||
|01/06/2020 | |01/06/2020 | ||
|92.14 | |92.14 | ||
| | |13.775 | ||
|2% | |2% | ||
| - | | -14% | ||
|- | |- | ||
|01/07/2020 | |01/07/2020 | ||
|96.65 | |96.65 | ||
| | |21.15 | ||
|5% | |5% | ||
| | |54% | ||
|- | |- | ||
|01/08/2020 | |01/08/2020 | ||
|102.96 | |102.96 | ||
| | |22.35 | ||
|7% | |7% | ||
| | |6% | ||
|- | |- | ||
|01/09/2020 | |01/09/2020 | ||
|99.52 | |99.52 | ||
| | |37.2 | ||
| -3% | | -3% | ||
|66% | |||
|- | |- | ||
|01/10/2020 | |01/10/2020 | ||
|96.53 | |96.53 | ||
| | |31 | ||
| -3% | | -3% | ||
| - | | -17% | ||
|- | |- | ||
|01/11/2020 | |01/11/2020 | ||
|108.94 | |108.94 | ||
| | |37.4 | ||
|13% | |13% | ||
| | |21% | ||
|- | |- | ||
|01/12/2020 | |01/12/2020 | ||
|112.41 | |112.41 | ||
| | |43.5 | ||
|3% | |3% | ||
| | |16% | ||
|- | |- | ||
|01/01/2021 | |01/01/2021 | ||
|111.49 | |111.49 | ||
| | |36.3 | ||
| -1% | | -1% | ||
| | | -17% | ||
|- | |- | ||
|01/02/2021 | |01/02/2021 | ||
|114.27 | |114.27 | ||
| | |39.1 | ||
|2% | |2% | ||
| | |8% | ||
|- | |- | ||
|01/03/2021 | |01/03/2021 | ||
|118.49 | |118.49 | ||
| | |35.7 | ||
|4% | |4% | ||
| | | -9% | ||
|- | |- | ||
|01/04/2021 | |01/04/2021 | ||
|123.61 | |123.61 | ||
| | |34.25 | ||
|4% | |4% | ||
| - | | -4% | ||
|- | |- | ||
|01/05/2021 | |01/05/2021 | ||
|125.6 | |125.6 | ||
| | |29.4 | ||
|2% | |2% | ||
| | | -14% | ||
|- | |- | ||
|01/06/2021 | |01/06/2021 | ||
|126.57 | |126.57 | ||
| | |41.25 | ||
|1% | |1% | ||
| | |40% | ||
|- | |- | ||
|01/07/2021 | |01/07/2021 | ||
|128.83 | |128.83 | ||
| | |55.3 | ||
|2% | |2% | ||
| | |34% | ||
|- | |- | ||
|01/08/2021 | |01/08/2021 | ||
|132.02 | |132.02 | ||
| | |59.7 | ||
|2% | |2% | ||
| | |8% | ||
|- | |- | ||
|01/09/2021 | |01/09/2021 | ||
|126.46 | |126.46 | ||
| | |71.6 | ||
| -4% | | -4% | ||
| | |20% | ||
|- | |- | ||
|01/10/2021 | |01/10/2021 | ||
|133.84 | |133.84 | ||
| | |77.6 | ||
|6% | |6% | ||
| | |8% | ||
|- | |- | ||
|01/11/2021 | |01/11/2021 | ||
|131.1 | |131.1 | ||
| | |69.6 | ||
| -2% | | -2% | ||
| - | | -10% | ||
|- | |- | ||
|01/12/2021 | |01/12/2021 | ||
|135.32 | |135.32 | ||
| | |77.3 | ||
|3% | |3% | ||
| | |11% | ||
|- | |- | ||
|01/01/2022 | |01/01/2022 | ||
|128.32 | |128.32 | ||
| | |79.6 | ||
| -5% | | -5% | ||
| | |3% | ||
|- | |- | ||
|01/02/2022 | |01/02/2022 | ||
|124.58 | |124.58 | ||
| | |142 | ||
| -3% | | -3% | ||
| | |78% | ||
|- | |- | ||
|01/03/2022 | |01/03/2022 | ||
|128.16 | |128.16 | ||
| | |117.6 | ||
|3% | |3% | ||
| | | -17% | ||
|- | |- | ||
|01/04/2022 | |01/04/2022 | ||
|117.42 | |117.42 | ||
| | |123.2 | ||
| -8% | | -8% | ||
| | |5% | ||
|- | |- | ||
|01/05/2022 | |01/05/2022 | ||
|117.94 | |117.94 | ||
| | |100.6 | ||
|0% | |0% | ||
| - | | -18% | ||
|- | |- | ||
|01/06/2022 | |01/06/2022 | ||
|106.88 | |106.88 | ||
| | |89.4 | ||
| -9% | | -9% | ||
| - | | -11% | ||
|- | |- | ||
|01/07/2022 | |01/07/2022 | ||
|115.57 | |115.57 | ||
| | |117 | ||
|8% | |8% | ||
| | |31% | ||
|- | |- | ||
|01/08/2022 | |01/08/2022 | ||
|110.28 | |110.28 | ||
| | |133.7 | ||
| -5% | | -5% | ||
| | |14% | ||
|- | |- | ||
|01/09/2022 | |01/09/2022 | ||
|99.95 | |99.95 | ||
| | |104.1 | ||
| -9% | | -9% | ||
| | | -22% | ||
|- | |- | ||
|01/10/2022 | |01/10/2022 | ||
|107.42 | |107.42 | ||
| | |100.1 | ||
|7% | |7% | ||
| | | -4% | ||
|- | |- | ||
|01/11/2022 | |01/11/2022 | ||
|115.44 | |115.44 | ||
| | |72.95 | ||
|7% | |7% | ||
| | | -27% | ||
|- | |- | ||
|01/12/2022 | |01/12/2022 | ||
|109.25 | |109.25 | ||
| | |42.52 | ||
| -5% | | -5% | ||
| - | | -42% | ||
|- | |- | ||
|01/01/2023 | |01/01/2023 | ||
|117.01 | |117.01 | ||
| | |50.15 | ||
|7% | |7% | ||
| | |18% | ||
|- | |- | ||
|01/02/2023 | |01/02/2023 | ||
|113.98 | |113.98 | ||
| | |57.1 | ||
| -3% | | -3% | ||
| | |14% | ||
|- | |- | ||
|01/03/2023 | |01/03/2023 | ||
|117.67 | |117.67 | ||
| | |23.64 | ||
|3% | |3% | ||
| | | -59% | ||
|- | |- | ||
|01/04/2023 | |01/04/2023 | ||
|119.79 | |119.79 | ||
| | |18.67 | ||
|2% | |2% | ||
| | | -21% | ||
|- | |- | ||
|01/05/2023 | |01/05/2023 | ||
|118.6 | |118.6 | ||
| | |15.74 | ||
| -1% | | -1% | ||
| - | | -16% | ||
|- | |- | ||
|01/06/2023 | |01/06/2023 | ||
|124.52 | |124.52 | ||
| | |12.71 | ||
|5% | |5% | ||
| | | -19% | ||
|- | |- | ||
|01/07/2023 | |01/07/2023 | ||
|128.54 | |128.54 | ||
| | |10.8 | ||
|3% | |3% | ||
| | | -15% | ||
|- | |- | ||
|01/08/2023 | |01/08/2023 | ||
|125.7 | |125.7 | ||
| | |25 | ||
| -2% | | -2% | ||
| | |131% | ||
|- | |- | ||
|01/09/2023 | |01/09/2023 | ||
|125.91 | |125.91 | ||
| | |22.42 | ||
|0% | |0% | ||
| - | | -10% | ||
|} | |} | ||
{| class="wikitable" | {| class="wikitable" |