Question: Please provide formulas I can use to get the answers that are in bold at the bottom of this question. *Do not need to provide
Please provide formulas I can use to get the answers that are in bold at the bottom of this question. *Do not need to provide formulas for SUM. Thank you
| This Price Weighted index consists of 3 stocks initially with stocks MSFT, XPO, and BAC | ||||
| After Day 1, stock BAC was replaced by CSCO | ||||
| Please Construct Price Weighted Index Day 1, Day 2, and Day 3 | ||||
| Stocks | Day 1 | Day 2 | Day 3 | |
| MSFT | $50 | $52 | $53 | |
| XPO | $100 | $99 | $102 | |
| BAC | $30 | |||
| CSCO | $42 | $43 | $46 | |
| SUM | ||||
| Divisor | ||||
| Index Value | ||||
| New Divisor After Day 1 | ||||
| Stocks | Day 1 | Day 2 | Day 3 | |
| MSFT | $ 50 | $ 52 | $ 53 | |
| XPO | $ 100 | $ 99 | $ 102 | |
| BAC | $ 30 | |||
| CSCO | $ 42 | $ 43 | $ 46 | |
| SUM | $ 180 | $ 194 | $ 201 | |
| Divisor | 3 | 3.2 | 3.2 | |
| Index Value | 60.0000 | 60.6250 | 62.8125 | |
| New Divisor After Day 1 | 3.2000 | |||
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock