Hello, please help me calculate the Annual Return and the Value-Weighted portfolio return using excel formulas.

Thanks!

I B D E F G C Shares 1 Ticker Price 01/02 Price HP Return Annual Return 2 DAL 5,509 31.30 58.93 -46.89% 3 HON 1,455 149.11 177.50 - 15.99% 4 XOM 2,948 48.20 70.24 -31.38% 5 STX 4,281 51.68 59.81 -13.59% 6 JWN Company Name Delta Air Lines Honeywell International Exxon Mobil Corporation Seagate Technology Nordstrom, Inc MasTec, Inc Kohl's Corporation Alibaba Group Holding Limited Visa Inc. JPMorgan Chase & Co. 5,242 19.50 41.08 -52.53% 7 MTZ 2,805 45.01 64.62 -30.35% KSS 500 24.82 51.22 -51.54% 2.78% 9 BABA 25 222.62 216.60 10 V 2 192.88 189.00 2.05% 11 JPM 2 102.06 139.79 -26.99% 12 13 14 Value-Weighted Portfolio Return 15 16