The table below gets filled in with excel function for sum, divisor, index value, and new divisor after day 1. Please help! Thank you

Index Example, Value Weighted Index Stocks Day 1 Day 2 Day 3 MSFT XPO # of Shares outstanding $50 $100 $30 $42 1000 500 # of Shares outstanding $52 1000 $99 5001 $27 800 $43 # of Shares outstanding $53 $102 $25 1000i 500i 8001 800 BAC CSCO 900 9001 $46 900; This Value Weighted index consists of 3 stocks initially with stocks MSFT, XPO, and BAC After Day 1, stock BAC was replaced by CSCO Please Construct Value Weighted Index Dany 1, Day 2, and Day 3 Use 1000 as a first day index value Initial Index (Day 1) 1000 Day 1 Day 2 Day 3 Stocks MSFT XPO BAC CSCO SUM Divisor Index Value New Divsor After Day 1 Index Example, Value Weighted Index Stocks Day 1 Day 2 Day 3 MSFT XPO # of Shares outstanding $50 $100 $30 $42 1000 500 # of Shares outstanding $52 1000 $99 5001 $27 800 $43 # of Shares outstanding $53 $102 $25 1000i 500i 8001 800 BAC CSCO 900 9001 $46 900; This Value Weighted index consists of 3 stocks initially with stocks MSFT, XPO, and BAC After Day 1, stock BAC was replaced by CSCO Please Construct Value Weighted Index Dany 1, Day 2, and Day 3 Use 1000 as a first day index value Initial Index (Day 1) 1000 Day 1 Day 2 Day 3 Stocks MSFT XPO BAC CSCO SUM Divisor Index Value New Divsor After Day 1