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.