solve with given data

6 9 10 11 12 13 14 15 16 60.0.0.000000000000000000 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 39 40 41 42 43 44 46 47 49 50 35223888886 51 54 55 57 59 61 Date SPY Prices Coke Price RM 1/1/17 207.5985 34.799255 2/1/17 215.7553 35.125736 0.03929 0.00938 3/1/17 215.0893 35.527557 -0.00309 0.01144 4/1/17 218.1693 36.440731 0.01432 0.0257 5/1/17 221.2483 38.400005 0.01411 0.05377 6/1/17 221.5782 37.876404 0.00149 0.01364 7/1/17 227.2353 39.031055 0.02553 0.03048 8/1/17 227.8984 38.784138 0.00292 -0.00633 9/1/17 231.3423 38.324348 0.01511 0.01186 10/1/17 237.9688 39.461773 0.02864 0.02968 11/1/17 245.2425 39.281544 0.03057 -0.00457 12/1/17 246.9545 39.698784 0.00698 0.01062 1/1/18 262.2061 41.178398 0.06176 0.03727 2/1/18 252.6722 37-397148 0.03636 3/1/18 244.7659 37.578869 -0.03129 4/1/18 0.09183 0.00486 0.00125 0.02 247,0164 37.718536 0.00919 0.00372 5/1/18 253.0211 37.535244 0.02431 -0.00486 6/1/18 253.3386 38.285934 7/1/18 263.9037 41.066425 0.0417 0.07262 8/1/18 272.3275 39.252201 0.03192 -0.04418 9/1/18 272.712 40.678913 0.00141 0.03635 10/1/18 255.0157 42.525948 -0.06489 0.04541 11/1/18 259.7461 44.764164 0.01855 0.05263 12/1/18 235.5005 42.387772 -0.09334 -0.05309 1/1/19 255.8414 43.086037 0.08637 0.01647 2/1/19 264.1347 40.588421 0.03242 -0.05797 3/1/19 267.7364 41.94912 0.01364 0.03352 4/1/19 279.9015 44.301971 0.04544 0.05609 5/1/19 262.0519 44.365181 -0.06377 0.00143 6/1/19 278.9305 45.981579 0.06441 0.03643 7/1/19 284.5249 47.89674 0.02006 0.04165 8/1/19 279.7611 50.089996 -0.01674 0.04579 9/1/19 283.8936 49.543949 0.01477 -0.0109 10/1/19 291.5089 49.897022 0.02682 0.00713 11/1/19 302.061 48.952801 0.0362 -0.01892 0.02402 0.04426 1/1/20 310.7121 53.936302 0.00451 0.0551 2/1/20 286.1143 49.401592 -0.07917 -0.08408 3/1/20 248.9231 40.867825 0.12999 -0.17274 4/1/20 282.1819 42.754169 0.13361 0.04616 5/1/20 295.6264 43.490192 0.04765 0.01722 6/1/20 299.5511 41.626858 0.01328 -0.04284 7/1/20 318.588 44.41177 0.06355 0.0669 8/1/20 340.8245 46.564659 0.0698 0.04848 12/1/19 309.3168 51.119415 4/1/21 5/1/21 RE 9/1/20 326.7548 46.414246 -0.04128 -0.00323 10/1/20 319.883 45.54842 -0.02103 -0.01865 11/1/20 354.6788 48.903416 0.10878 0.07366 12/1/20 366.2579 52.381618 0.03265 0.07112 1/1/21 364.0709 45.99152 -0.00597 -0.12199 2/1/21 374.1941 46.793865 0.02781 0.01745 3/1/21 389.9052 50.347103 0.04199 0.07593 411.8799 51.98933 0.05636 0.03262 414.5843 53.251019 0.00657 0.02427 6/1/21 7/1/21 8/1/21 9/1/21 10/1/21 11/1/21 12/1/21 422.5001 52.114536 0.01909 -0.02134 434.2304 55.340725 0.02776 0.06191 447.153 54.642052 0.02976 -0.01262 424.9518 50.915798 0.04965 -0.06819 456.2249 55.113106 0.07359 0.08244 452.5592 51.28051 -0.00803 -0.06954 471.8314 Beta Cov(Re.Rm) Var (Rm) Cost Of Equity CAPM 28.5142 0.00143 0.00208 8% #NAME? Assume that your company has the cost of equity of 8% (for the purpose of preventing error carried forward. Go back to your Excel or your solutions to just change the cost of equity to 8%, instead of what you got from the previous part.) What is the stock valuation assuming zero-growth dividends? Type your answer... Assume that your company has the cost of equity of 8% (for the purpose of preventing error carried forward. Go back to your Excel or your solutions to just change the cost of equity to 8%, instead of what you got from the previous part.) What is the stock valuation assuming 4% constant growth rate of dividends? Type your answer... Assume that your company has the cost of equity of 8% (for the purpose of preventing error carried forward. Go back to your Excel or your solutions to just change the cost of equity to 8%, instead of what you got from the previous part.) What is the stock valuation assuming 2% second-stage growth rate? Type your answer... 6 9 10 11 12 13 14 15 16 60.0.0.000000000000000000 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 39 40 41 42 43 44 46 47 49 50 35223888886 51 54 55 57 59 61 Date SPY Prices Coke Price RM 1/1/17 207.5985 34.799255 2/1/17 215.7553 35.125736 0.03929 0.00938 3/1/17 215.0893 35.527557 -0.00309 0.01144 4/1/17 218.1693 36.440731 0.01432 0.0257 5/1/17 221.2483 38.400005 0.01411 0.05377 6/1/17 221.5782 37.876404 0.00149 0.01364 7/1/17 227.2353 39.031055 0.02553 0.03048 8/1/17 227.8984 38.784138 0.00292 -0.00633 9/1/17 231.3423 38.324348 0.01511 0.01186 10/1/17 237.9688 39.461773 0.02864 0.02968 11/1/17 245.2425 39.281544 0.03057 -0.00457 12/1/17 246.9545 39.698784 0.00698 0.01062 1/1/18 262.2061 41.178398 0.06176 0.03727 2/1/18 252.6722 37-397148 0.03636 3/1/18 244.7659 37.578869 -0.03129 4/1/18 0.09183 0.00486 0.00125 0.02 247,0164 37.718536 0.00919 0.00372 5/1/18 253.0211 37.535244 0.02431 -0.00486 6/1/18 253.3386 38.285934 7/1/18 263.9037 41.066425 0.0417 0.07262 8/1/18 272.3275 39.252201 0.03192 -0.04418 9/1/18 272.712 40.678913 0.00141 0.03635 10/1/18 255.0157 42.525948 -0.06489 0.04541 11/1/18 259.7461 44.764164 0.01855 0.05263 12/1/18 235.5005 42.387772 -0.09334 -0.05309 1/1/19 255.8414 43.086037 0.08637 0.01647 2/1/19 264.1347 40.588421 0.03242 -0.05797 3/1/19 267.7364 41.94912 0.01364 0.03352 4/1/19 279.9015 44.301971 0.04544 0.05609 5/1/19 262.0519 44.365181 -0.06377 0.00143 6/1/19 278.9305 45.981579 0.06441 0.03643 7/1/19 284.5249 47.89674 0.02006 0.04165 8/1/19 279.7611 50.089996 -0.01674 0.04579 9/1/19 283.8936 49.543949 0.01477 -0.0109 10/1/19 291.5089 49.897022 0.02682 0.00713 11/1/19 302.061 48.952801 0.0362 -0.01892 0.02402 0.04426 1/1/20 310.7121 53.936302 0.00451 0.0551 2/1/20 286.1143 49.401592 -0.07917 -0.08408 3/1/20 248.9231 40.867825 0.12999 -0.17274 4/1/20 282.1819 42.754169 0.13361 0.04616 5/1/20 295.6264 43.490192 0.04765 0.01722 6/1/20 299.5511 41.626858 0.01328 -0.04284 7/1/20 318.588 44.41177 0.06355 0.0669 8/1/20 340.8245 46.564659 0.0698 0.04848 12/1/19 309.3168 51.119415 4/1/21 5/1/21 RE 9/1/20 326.7548 46.414246 -0.04128 -0.00323 10/1/20 319.883 45.54842 -0.02103 -0.01865 11/1/20 354.6788 48.903416 0.10878 0.07366 12/1/20 366.2579 52.381618 0.03265 0.07112 1/1/21 364.0709 45.99152 -0.00597 -0.12199 2/1/21 374.1941 46.793865 0.02781 0.01745 3/1/21 389.9052 50.347103 0.04199 0.07593 411.8799 51.98933 0.05636 0.03262 414.5843 53.251019 0.00657 0.02427 6/1/21 7/1/21 8/1/21 9/1/21 10/1/21 11/1/21 12/1/21 422.5001 52.114536 0.01909 -0.02134 434.2304 55.340725 0.02776 0.06191 447.153 54.642052 0.02976 -0.01262 424.9518 50.915798 0.04965 -0.06819 456.2249 55.113106 0.07359 0.08244 452.5592 51.28051 -0.00803 -0.06954 471.8314 Beta Cov(Re.Rm) Var (Rm) Cost Of Equity CAPM 28.5142 0.00143 0.00208 8% #NAME? Assume that your company has the cost of equity of 8% (for the purpose of preventing error carried forward. Go back to your Excel or your solutions to just change the cost of equity to 8%, instead of what you got from the previous part.) What is the stock valuation assuming zero-growth dividends? Type your answer... Assume that your company has the cost of equity of 8% (for the purpose of preventing error carried forward. Go back to your Excel or your solutions to just change the cost of equity to 8%, instead of what you got from the previous part.) What is the stock valuation assuming 4% constant growth rate of dividends? Type your answer... Assume that your company has the cost of equity of 8% (for the purpose of preventing error carried forward. Go back to your Excel or your solutions to just change the cost of equity to 8%, instead of what you got from the previous part.) What is the stock valuation assuming 2% second-stage growth rate? Type your