Use the TREND formula to forecast the price for the following week after the period of analysis.
Fantastic news! We've Found the answer you've been seeking!
Question:
Use the TREND formula to forecast the price for the following week after the period of analysis.
What is the valuation of the share price? Provide explanation.
Would you recommend buying a portfolio of these shares for the upcoming year? Explain your answer.
Date | Open | High | Low | Close | Adj Close | Volume |
2023-03-06 | 24.10 | 24.57 | 23.60 | 23.85 | 22.19 | 29286073 |
2023-03-13 | 23.74 | 24.03 | 22.68 | 22.81 | 21.23 | 61459796 |
2023-03-20 | 22.59 | 23.21 | 22.39 | 22.52 | 20.96 | 34160854 |
2023-03-27 | 22.79 | 23.07 | 22.39 | 22.93 | 21.34 | 35727391 |
2023-04-03 | 23.05 | 23.52 | 23.05 | 23.19 | 21.58 | 24239924 |
2023-04-10 | 23.19 | 24.00 | 23.19 | 23.98 | 22.32 | 23589516 |
2023-04-17 | 24.24 | 24.59 | 24.03 | 24.33 | 22.64 | 28338730 |
2023-04-24 | 24.50 | 24.50 | 24.04 | 24.35 | 22.66 | 21180380 |
2023-05-01 | 24.50 | 24.63 | 22.88 | 23.80 | 22.15 | 40634309 |
2023-05-08 | 23.94 | 24.57 | 23.53 | 24.50 | 22.80 | 51175459 |
2023-05-15 | 23.72 | 24.03 | 23.18 | 23.97 | 22.31 | 37043191 |
2023-05-22 | 24.05 | 24.12 | 23.32 | 23.47 | 22.59 | 33031878 |
2023-05-29 | 23.82 | 23.86 | 22.58 | 22.77 | 21.91 | 47824351 |
2023-06-05 | 22.95 | 23.28 | 22.61 | 22.85 | 21.99 | 32906369 |
2023-06-12 | 22.85 | 23.29 | 22.70 | 23.28 | 22.41 | 41745455 |
2023-06-19 | 23.30 | 23.88 | 22.71 | 22.82 | 21.96 | 35242804 |
2023-06-26 | 22.86 | 23.94 | 22.64 | 23.71 | 22.82 | 37835434 |
2023-07-03 | 23.80 | 24.20 | 23.14 | 23.28 | 22.41 | 29413377 |
2023-07-10 | 23.43 | 24.50 | 23.22 | 24.44 | 23.52 | 32013737 |
2023-07-17 | 24.43 | 25.65 | 24.38 | 25.16 | 24.21 | 45582877 |
2023-07-24 | 25.17 | 25.88 | 24.90 | 25.76 | 24.79 | 32774006 |
2023-07-31 | 25.85 | 25.93 | 25.03 | 25.45 | 24.49 | 33225796 |
2023-08-07 | 25.31 | 25.63 | 25.15 | 25.35 | 24.40 | 26495341 |
2023-08-14 | 25.29 | 25.31 | 24.40 | 24.49 | 23.57 | 27131235 |
2023-08-21 | 24.45 | 24.67 | 24.07 | 24.34 | 23.43 | 27958508 |
2023-08-28 | 24.37 | 25.33 | 24.32 | 25.17 | 24.22 | 27413702 |
2023-09-04 | 25.26 | 25.38 | 24.65 | 24.93 | 23.99 | 19659639 |
2023-09-11 | 25.12 | 25.90 | 25.00 | 25.70 | 24.73 | 27570549 |
2023-09-18 | 25.62 | 25.80 | 24.50 | 25.03 | 24.09 | 31635637 |
2023-09-25 | 25.02 | 25.78 | 24.72 | 25.66 | 24.70 | 26708002 |
2023-10-02 | 25.55 | 25.59 | 24.83 | 25.32 | 24.37 | 27176636 |
2023-10-09 | 25.33 | 26.08 | 25.26 | 25.71 | 24.74 | 25962562 |
2023-10-16 | 25.59 | 25.97 | 25.15 | 25.27 | 24.32 | 26116263 |
2023-10-23 | 25.12 | 25.45 | 24.57 | 24.85 | 23.92 | 25853310 |
2023-10-30 | 24.63 | 25.75 | 24.34 | 25.60 | 24.64 | 30930053 |
2023-11-06 | 25.65 | 26.00 | 25.32 | 25.47 | 24.51 | 30162394 |
2023-11-13 | 24.75 | 25.11 | 23.90 | 24.07 | 23.17 | 58252944 |
2023-11-20 | 24.12 | 24.47 | 24.10 | 24.40 | 24.40 | 25425235 |
2023-11-27 | 24.30 | 24.49 | 24.11 | 24.43 | 24.43 | 29651210 |
2023-12-04 | 24.54 | 24.75 | 24.23 | 24.61 | 24.61 | 31509487 |
2023-12-11 | 24.55 | 25.73 | 24.55 | 25.54 | 25.54 | 41706587 |
2023-12-18 | 25.38 | 25.90 | 25.36 | 25.80 | 25.80 | 30598340 |
2023-12-25 | 25.80 | 26.05 | 25.80 | 25.92 | 25.92 | 11388204 |
2024-01-01 | 25.92 | 26.08 | 25.42 | 25.62 | 25.62 | 17342482 |
2024-01-08 | 25.65 | 26.09 | 25.57 | 25.90 | 25.90 | 19140268 |
2024-01-15 | 25.94 | 26.13 | 25.42 | 26.13 | 26.13 | 20226636 |
2024-01-22 | 26.25 | 26.78 | 26.20 | 26.67 | 26.67 | 19903885 |
2024-01-29 | 26.75 | 27.26 | 26.68 | 27.26 | 27.26 | 25237660 |
2024-02-05 | 27.12 | 27.81 | 26.90 | 27.68 | 27.68 | 24535491 |
2024-02-12 | 27.65 | 28.47 | 27.51 | 28.42 | 28.42 | 24795382 |
2024-02-19 | 28.31 | 28.52 | 27.39 | 28.29 | 28.29 | 29156258 |
2024-02-26 | 28.30 | 28.75 | 28.21 | 28.75 | 28.75 | 24805919 |
2024-03-04 | 28.80 | 28.91 | 28.63 | 28.73 | 28.73 | 6941083 |
2024-03-06 | 28.80 | 29.00 | 28.75 | 28.83 | 28.83 | 2049377 |
Q1. Use the TREND formula to forecast the price for the following week after the period of analysis.
Q2. Analyse the company you chose.
i. What is the valuation of the share price? Provide explanation.
ii. Would you recommend buying a portfolio of these shares for the upcoming year? Explain your answer.
Related Book For
Fundamentals of Corporate Finance
ISBN: 978-1259024962
6th Canadian edition
Authors: Richard Brealey, Stewart Myers, Alan Marcus, Devashis Mitra, Elizabeth Maynes, William Lim
Posted Date: