Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
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 1Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started