Answered step by step
Verified Expert Solution
Link Copied!

Question

00
1 Approved Answer

Where can I find the answer on column D6 beta on the instruction says to find it on the CoE spreadsheet, but I don't know

image text in transcribed

Where can I find the answer on column D6 beta

on the instruction says to find it on the CoE spreadsheet, but I don't know which one to use

CoE sheet is below

image text in transcribed

D a. $ 447.35 441,823,811.00 $ 197,649,881,850.85 c. e. 0.020000 0.035000 A B C 1 Do not change the formats of cells 2 Table 1 (in US$): 3 stock price on September 2021 4 b. shares outstanding on September 2021 5 market capitalization 6 d. beta 7 risk free rate 8 f. market premium 9 8 cost of equity 10 h. total MV debts 11 i. cost of debt (based on Market Value) 12 j. Total capial 13 k. w_equity 14 1. w_debt 15 tax rate 16 cost of capital (WACC) 17 Avg. of GeoMean growth rate over past 4 years 18 p. Avg. of GeoMean growth rate over past 7 years m. n. 0. 0.031000 0.015000 B D E G . T F COSTS_PI COST SP500 aP SP500 r SP500_r_Pr COST_aP 220.67 0.008207 -0.069403 222.88 216.95 -0.028473 N N 0000 219.46 193.76 204.15 208.06 0.010015 -0.026606 0.011569 -0.117106 0.053623 0.019153 0.109968 0.013986 -0.024256 0.106000 0.009594 -0.119106 0.051598 0.017111 0.107943 0.017859 -0.091777 0.078684 0.029729 0.017924 0.039313 -0.071212 0.015993 -0.093752 0.076684 0.027704 0.015883 230.94 1MTB_T 0.001700 0.001808 0.001867 0.001975 0.002000 0.002025 0.002042 0.002025 0.002000 0.001850 0.001792 0.001725 0.001658 0.001442 0.001317 0.001292 0.001275 0.001317 0.000308 234.17 228.49 252.71 263.59 281.88 0.011986 -0.026106 0.104209 0.041328 0.067730 -0.065778 0.068930 0.013128 -0.018092 0.017181 0.043053 0.037288 -0.067778 0.067080 0.011337 -0.019817 0.015523 0.018990 0.032730 0.027298 -0.002903 -0.021840 0.029937 0.009981 -0.020930 0.020432 0.034047 0.028590 -0.001628 -0.084110 1 MTB (%) 2.04 2.17 2.24 2.37 2.40 2.43 2.45 2.43 2.40 2.22 2.15 2.07 1.99 1.73 1.58 1.55 153 1.58 0.37 0.11 0.10 0.13 0.11 0.08 0.09 0.09 0.09 0.08 0.08 0.04 0.02 0.02 0.01 0.03 0.05 0.04 0.03 -0.125119 276.13 284.76 287.97 282.31 293.45 270.04 274.45 291.65 297.59 292.51 314.05 336.12 2,913.98 2,711.74 2,760.17 2,506.85 2,704.10 2,784.49 2,834.40 2,945.83 2,752.06 2,941.76 2,980.38 2,926.46 2,976.74 3,037.56 3,140.98 3,230.78 3,225.52 2,954.22 2,584.59 2,912.43 3,044.31 3,100.29 3,271.12 3,500.31 3,363.00 3,269.96 3,621.63 3,756.07 3,714.24 3,811.15 3,972.89 4,181.17 4,204.11 4,297.50 4,395.26 4,522.68 4,307.54 -0.085427 -0.125428 0.126752 F9 0.038144 -0.080083 0.016239 0.062587 0.020259 0.000092 0.000083 A 1 Date Sep-2018 3 Oct-2018) Nov-2018 5 Dec-2018 Jan-2019 7 Feb-2019 8 Mar-2019 9 Apr-2019 10 May-2019 11. Jun-2019 12 Jul-2019 13 Aug-2019 14 Sep-2019 75 Oct-2019 16 Nov-2019 17 Dec-2019) 18 Jan-2020 19 Feb-2020 20 Mar-2020 21 Apr-2020 22 May-2020 23 Jun-2020 24 Jul-2020 25 Aug-2020 26 Sep-2020 27 Oct-2020 28 Nov-2020 29 Dec-2020 30 Jan-2021 31 Feb-2021 32 Mar-2021 33 Apr-2021 34 May-2021 35 Jun-2021 36 Jul-2021 37 Aug-2021 38 Sep-2021 39 Average 40 Variance 41 Standard Deviation 42 Covariance 43 Beta with risk premium 44 Required rate of return 45 46 risk free rate of return 47 market risk premium 0.069388 -0.020399 0.031253 0.011273 -0.019655 0.039460 -0.079775 0.016331 0.062671 0.020367 -0.017070 0.073639 0.070275 0.021094 0.007401 0.097585 -0.038262 -0.040113 0.126844 0.045282 0.000108 0.045198 0.018280 0.055010 -0.017162 0.073572 0.070200 343.21 0.021019 0.007326 0.097518 0.069998 -0.039303 -0.027741 0.107471 0.037055 -0.011203 0.026058 0.042422 0.052409 345.75 379.49 364.97 350.33 329.02 351.07 370.60 377.56) 394.93 -0.038329 -0.040146 -0.060845 0.000092 0.000067 0.000075 0.000075 0.000075 0.000067 0.000067 0.000033 0.000017 0.000017 0.000008 0.000025 0.000042 0.000033 0.000025 0.000853 0.000001 0.000865 -0.000004 -0.001503 0.021590 -0.060828 0.005478 0.022189 0.018388 0.055101 0.070065 -0.039228 -0.027666 0.107546 0.037121 -0.011137 0.026091 0.042439 0.052425 0.005487 0.022214 0.022748 0.028990 -0.047569 0.012363 0.002948 0.054292 -0.041437 -0.002960 0.000000 0.022706 0.028957 0.067017 0.055630 0.018780 0.046006 0.086066 0.061946 0.021652 0.002714 0.052095 0.000122 0.041333 0.021590 428.92 455.49 0.067001 0.055622 0.018755 0.045964 0.086033 0.061921 0.020799 0.002721 0.052166 0.000135 0.045416 0.000000 -0.047594 0.011509 0.002966 0.054461 -0.077066 -3.541171 0.000000 0.02 0.035 D a. $ 447.35 441,823,811.00 $ 197,649,881,850.85 c. e. 0.020000 0.035000 A B C 1 Do not change the formats of cells 2 Table 1 (in US$): 3 stock price on September 2021 4 b. shares outstanding on September 2021 5 market capitalization 6 d. beta 7 risk free rate 8 f. market premium 9 8 cost of equity 10 h. total MV debts 11 i. cost of debt (based on Market Value) 12 j. Total capial 13 k. w_equity 14 1. w_debt 15 tax rate 16 cost of capital (WACC) 17 Avg. of GeoMean growth rate over past 4 years 18 p. Avg. of GeoMean growth rate over past 7 years m. n. 0. 0.031000 0.015000 B D E G . T F COSTS_PI COST SP500 aP SP500 r SP500_r_Pr COST_aP 220.67 0.008207 -0.069403 222.88 216.95 -0.028473 N N 0000 219.46 193.76 204.15 208.06 0.010015 -0.026606 0.011569 -0.117106 0.053623 0.019153 0.109968 0.013986 -0.024256 0.106000 0.009594 -0.119106 0.051598 0.017111 0.107943 0.017859 -0.091777 0.078684 0.029729 0.017924 0.039313 -0.071212 0.015993 -0.093752 0.076684 0.027704 0.015883 230.94 1MTB_T 0.001700 0.001808 0.001867 0.001975 0.002000 0.002025 0.002042 0.002025 0.002000 0.001850 0.001792 0.001725 0.001658 0.001442 0.001317 0.001292 0.001275 0.001317 0.000308 234.17 228.49 252.71 263.59 281.88 0.011986 -0.026106 0.104209 0.041328 0.067730 -0.065778 0.068930 0.013128 -0.018092 0.017181 0.043053 0.037288 -0.067778 0.067080 0.011337 -0.019817 0.015523 0.018990 0.032730 0.027298 -0.002903 -0.021840 0.029937 0.009981 -0.020930 0.020432 0.034047 0.028590 -0.001628 -0.084110 1 MTB (%) 2.04 2.17 2.24 2.37 2.40 2.43 2.45 2.43 2.40 2.22 2.15 2.07 1.99 1.73 1.58 1.55 153 1.58 0.37 0.11 0.10 0.13 0.11 0.08 0.09 0.09 0.09 0.08 0.08 0.04 0.02 0.02 0.01 0.03 0.05 0.04 0.03 -0.125119 276.13 284.76 287.97 282.31 293.45 270.04 274.45 291.65 297.59 292.51 314.05 336.12 2,913.98 2,711.74 2,760.17 2,506.85 2,704.10 2,784.49 2,834.40 2,945.83 2,752.06 2,941.76 2,980.38 2,926.46 2,976.74 3,037.56 3,140.98 3,230.78 3,225.52 2,954.22 2,584.59 2,912.43 3,044.31 3,100.29 3,271.12 3,500.31 3,363.00 3,269.96 3,621.63 3,756.07 3,714.24 3,811.15 3,972.89 4,181.17 4,204.11 4,297.50 4,395.26 4,522.68 4,307.54 -0.085427 -0.125428 0.126752 F9 0.038144 -0.080083 0.016239 0.062587 0.020259 0.000092 0.000083 A 1 Date Sep-2018 3 Oct-2018) Nov-2018 5 Dec-2018 Jan-2019 7 Feb-2019 8 Mar-2019 9 Apr-2019 10 May-2019 11. Jun-2019 12 Jul-2019 13 Aug-2019 14 Sep-2019 75 Oct-2019 16 Nov-2019 17 Dec-2019) 18 Jan-2020 19 Feb-2020 20 Mar-2020 21 Apr-2020 22 May-2020 23 Jun-2020 24 Jul-2020 25 Aug-2020 26 Sep-2020 27 Oct-2020 28 Nov-2020 29 Dec-2020 30 Jan-2021 31 Feb-2021 32 Mar-2021 33 Apr-2021 34 May-2021 35 Jun-2021 36 Jul-2021 37 Aug-2021 38 Sep-2021 39 Average 40 Variance 41 Standard Deviation 42 Covariance 43 Beta with risk premium 44 Required rate of return 45 46 risk free rate of return 47 market risk premium 0.069388 -0.020399 0.031253 0.011273 -0.019655 0.039460 -0.079775 0.016331 0.062671 0.020367 -0.017070 0.073639 0.070275 0.021094 0.007401 0.097585 -0.038262 -0.040113 0.126844 0.045282 0.000108 0.045198 0.018280 0.055010 -0.017162 0.073572 0.070200 343.21 0.021019 0.007326 0.097518 0.069998 -0.039303 -0.027741 0.107471 0.037055 -0.011203 0.026058 0.042422 0.052409 345.75 379.49 364.97 350.33 329.02 351.07 370.60 377.56) 394.93 -0.038329 -0.040146 -0.060845 0.000092 0.000067 0.000075 0.000075 0.000075 0.000067 0.000067 0.000033 0.000017 0.000017 0.000008 0.000025 0.000042 0.000033 0.000025 0.000853 0.000001 0.000865 -0.000004 -0.001503 0.021590 -0.060828 0.005478 0.022189 0.018388 0.055101 0.070065 -0.039228 -0.027666 0.107546 0.037121 -0.011137 0.026091 0.042439 0.052425 0.005487 0.022214 0.022748 0.028990 -0.047569 0.012363 0.002948 0.054292 -0.041437 -0.002960 0.000000 0.022706 0.028957 0.067017 0.055630 0.018780 0.046006 0.086066 0.061946 0.021652 0.002714 0.052095 0.000122 0.041333 0.021590 428.92 455.49 0.067001 0.055622 0.018755 0.045964 0.086033 0.061921 0.020799 0.002721 0.052166 0.000135 0.045416 0.000000 -0.047594 0.011509 0.002966 0.054461 -0.077066 -3.541171 0.000000 0.02 0.035

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered 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

Students also viewed these Finance questions

Question

1. Let a, b R, a Answered: 1 week ago

Answered: 1 week ago