Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

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

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Essential Mathematics For Economic Analysis

Authors: Knut Sydsaeter, Peter Hammond

3rd Edition

0273713248, 9780273713241

More Books

Students also viewed these Finance questions