corporate finance

DellandHPEquityTracking.xlsx

Home >Business & Finance homework help >corporate finance

Week 1

Week 1 Data - Close of Market on Friday after 4 pm EST
Day 1								NOTE: If changing stocks that are being tracked
Technology Development Firms		Date:	8/25/20					just change name and stock symbol in week 3
Company Name	Ticker Symbol	Stock Price	Beta	EPS	P/E	Dividend	Market Capitalization	and the rest of spreadsheets will autopopulate
Dell Technologies Inc	DELL	60.64	N/A	5.840	10.390	N/A	44.923B
Index		Closing Price		NOTE: No other stats needed
S&P 500	^GSPC	3,443.62
Technology Development Firms		Date:	8/25/20
Company Name	Ticker Symbol	Stock Price	Beta	EPS	P/E	Dividend	Market Capitalization
Hewlett Packard Enterprise Company	HPE	9.33	1.290	-0.030	N/A	0.48(5.14%)	44.923B
Index		Closing Price		NOTE: No other stats needed
S&P 500	^GSPC	3,443.62
Day 2
Technology Development Firms		Date:	8/26/20
Company Name	Ticker Symbol	Stock Price	Beta	EPS	P/E	Dividend	Market Capitalization
Dell Technologies Inc	DELL	62.13	N/A	5.840	10.650	N/A	46.027B
Index		Closing Price		NOTE: No other stats needed
S&P 500	^GSPC	3,478.73
Technology Development Firms		Date:	8/26/20
Company Name	Ticker Symbol	Stock Price	Beta	EPS	P/E	Dividend	Market Capitalization
Hewlett Packard Enterprise Company	HPE	9.67	N/A	0.000	9670.000	0.48(4.99%)	12.424B
Index		Closing Price		NOTE: No other stats needed
S&P 500	^GSPC	3,478.73
Day 3
Technology Development Firms		Date:	8/27/20
Company Name	Ticker Symbol	Stock Price	Beta	EPS	P/E	Dividend	Market Capitalization
Dell Technologies Inc	DELL	62.43	N/A	5.840	10.700	N/A	46.249B
Index		Closing Price		Dells quaterly results beat estimates on remote work boost
S&P 500	^GSPC	3,484.55
Technology Development Firms		Date:	8/25/20
Company Name	Ticker Symbol	Stock Price	Beta	EPS	P/E	Dividend	Market Capitalization
Hewlett Packard Enterprise Company	HPE	9.57	1.290	0.000	9570.000	0.48(5.14%)	12.307B
Index		Closing Price		NOTE: No other stats needed
S&P 500	^GSPC	3,484.55
Day 4
Technology Development Firms		Date:	8/28/20
Company Name	Ticker Symbol	Stock Price	Beta	EPS	P/E	Dividend	Market Capitalization
Dell Technologies Inc	DELL	66.21	N/A	2.760	23.950	N/A	49.049B
Index		Closing Price
S&P 500	^GSPC	3,508.01
Internet Services and Retailing		Date:	8/25/20
Company Name	Ticker Symbol	Stock Price	Beta	EPS	P/E	Dividend	Market Capitalization
Hewlett Packard Enterprise Company	HPE	9.83	1.290	0.000	9830.000	0.48(4.96%)	12.641B
Index		Closing Price		NOTE: No other stats needed
S&P 500	^GSPC	3,508.01

Week 2

Week 2 Day 1
Technology Development Firms		Date:	8/31/20
Company Name	Ticker Symbol	Stock Price	Beta	EPS	P/E	Dividend	Market Capitalization
Dell Technologies Inc	DELL	66.08	N/A	2.760	23.910	N/A	48.953B
Index		Closing Price
S&P 500	^GSPC	3,515.87
Internet Services and Retailing		Date:	8/31/20
Company Name	Ticker Symbol	Stock Price	Beta	EPS	P/E	Dividend	Market Capitalization
Hewlett Packard Enterprise Company	HPE	9.67	1.290	0.000	9670.000	0.48(5.02%)	12.436B
Index		Closing Price		NOTE: No other stats needed
S&P 500	^GSPC	3,515.87
Week 2 Day 2
Technology Development Firms		Date:	9/1/20
Company Name	Ticker Symbol	Stock Price	Beta	EPS	P/E	Dividend	Market Capitalization
Dell Technologies Inc	DELL	66.37	N/A	2.760	24.010	N/A	49.168B
Index		Closing Price
S&P 500	^GSPC	3,526.65
Internet Services and Retailing		Date:	9/1/20
Company Name	Ticker Symbol	Stock Price	Beta	EPS	P/E	Dividend	Market Capitalization
Hewlett Packard Enterprise Company	HPE	9.47	1.290	0.000	9470.000	0.48(4.88%)	12.178B
Index		Closing Price		NOTE: No other stats needed
S&P 500	^GSPC	3,526.65
Week 2 Day 3
Technology Development Firms		Date:	9/2/20
Company Name	Ticker Symbol	Stock Price	Beta	EPS	P/E	Dividend	Market Capitalization
Dell Technologies Inc	DELL	68.47	N/A	2.760	24.770	N/A	50.724B
Index		Closing Price
S&P 500	^GSPC	3,580.84
Internet Services and Retailing		Date:	9/2/20
Company Name	Ticker Symbol	Stock Price	Beta	EPS	P/E	Dividend	Market Capitalization
Hewlett Packard Enterprise Company	HPE	9.83	1.290	0.000	9830.000	0.48(4.96%)	12.641B
Index		Closing Price		NOTE: No other stats needed
S&P 500	^GSPC	3,580.84
Week 2 Day 4
Technology Development Firms		Date:	9/3/20
Company Name	Ticker Symbol	Stock Price	Beta	EPS	P/E	Dividend	Market Capitalization
Dell Technologies Inc	DELL	65.54	N/A	2.760	23.710	N/A	48.553B
Index		Closing Price
S&P 500	^GSPC	3,455.06
Internet Services and Retailing		Date:	9/3/20
Company Name	Ticker Symbol	Stock Price	Beta	EPS	P/E	Dividend	Market Capitalization
Hewlett Packard Enterprise Company	HPE	9.52	1.230	0.000	9520.000	0.48(5.07%)	12.243B
Index		Closing Price		NOTE: No other stats needed
S&P 500	^GSPC	3,455.06
Day 5
Technology Development Firms		Date:	9/4/20
Company Name	Ticker Symbol	Stock Price	Beta	EPS	P/E	Dividend	Market Capitalization
Dell Technologies Inc	DELL	64.65	N/A	2.760	23.390	N/A	47.894B
Index		Closing Price
S&P 500	^GSPC	3,426.96
Internet Services and Retailing		Date:	9/4/20
Company Name	Ticker Symbol	Stock Price	Beta	EPS	P/E	Dividend	Market Capitalization
Hewlett Packard Enterprise Company	HPE	9.59	1.230	0.000	9590.000	0.48(5.07%)	12.333B
Index		Closing Price		NOTE: No other stats needed
S&P 500	^GSPC	3,426.96

Week 3

Week 3 Day 1
Technology Development Firms		Date:	9/7/20
Company Name	Ticker Symbol	Stock Price	Beta	EPS	P/E	Dividend	Market Capitalization
Dell Technologies Inc	DELL	64.65	N/A	2.760	23.390	N/A	47.894B
Index		Closing Price
S&P 500	^GSPC	3,430.50
Internet Services and Retailing		Date:	9/7/20
Company Name	Ticker Symbol	Stock Price	Beta	EPS	P/E	Dividend	Market Capitalization
Hewlett Packard Enterprise Company	HPE	9.59	1.230	0.000	9590.000	0.48(5.04%)	12.336B
Index		Closing Price		NOTE: No other stats needed
S&P 500	^GSPC	3,430.50
Week 3 Day 2
Technology Development Firms		Date:	9/8/20
Company Name	Ticker Symbol	Stock Price	Beta	EPS	P/E	Dividend	Market Capitalization
Dell Technologies Inc	DELL	64.15	N/A	2.760	23.210	N/A	47.523B
Index		Closing Price
S&P 500	^GSPC	3,331.84
Internet Services and Retailing		Date:	9/8/20
Company Name	Ticker Symbol	Stock Price	Beta	EPS	P/E	Dividend	Market Capitalization
Hewlett Packard Enterprise Company	HPE	9.43	1.230	0.000	9430.000	0.48(5.04%)	12.131
Index		Closing Price		NOTE: No other stats needed
S&P 500	^GSPC	3,331.84
Week 3 Day 3
Technology Development Firms		Date:	9/9/20
Company Name	Ticker Symbol	Stock Price	Beta	EPS	P/E	Dividend	Market Capitalization
Dell Technologies Inc	DELL	66.84	N/A	2.760	24.180	N/A	49.911
Index		Closing Price
S&P 500	^GSPC	3,398.96
Internet Services and Retailing		Date:	9/9/20
Company Name	Ticker Symbol	Stock Price	Beta	EPS	P/E	Dividend	Market Capitalization
Hewlett Packard Enterprise Company	HPE	9.46	1.230	0.000	9460.000	0.48(5.01%)	12.169
Index		Closing Price		NOTE: No other stats needed
S&P 500	^GSPC	3,398.96
Week 3 Day 4
Technology Development Firms		Date:	9/10/20
Company Name	Ticker Symbol	Stock Price	Beta	EPS	P/E	Dividend	Market Capitalization
Dell Technologies Inc	DELL	65.44	N/A	2.760	23.680	N/A	48.865
Index		Closing Price
S&P 500	^GSPC	3,355.25
Internet Services and Retailing		Date:	9/10/20
Company Name	Ticker Symbol	Stock Price	Beta	EPS	P/E	Dividend	Market Capitalization
Hewlett Packard Enterprise Company	HPE	9.22	1.230	0.000	9220.000	0.48(5.09%)	11.86
Index		Closing Price		NOTE: No other stats needed
S&P 500	^GSPC	3,355.24
Week 3 Day 5
Technology Development Firms		Date:	9/11/20
Company Name	Ticker Symbol	Stock Price	Beta	EPS	P/E	Dividend	Market Capitalization
Dell Technologies Inc	DELL	66.39	N/A	2.760	24.020	N/A	49.575
Index		Closing Price
S&P 500	^GSPC	3,340.97
Internet Services and Retailing		Date:	9/11/20
Company Name	Ticker Symbol	Stock Price	Beta	EPS	P/E	Dividend	Market Capitalization
Hewlett Packard Enterprise Company	HPE	9.24	1.230	0.000	9240.000	0.48(5.07%)	11.886
Index		Closing Price		NOTE: No other stats needed
S&P 500	^GSPC	3,340.97

Week 4

Week 6 Data - Close of Market on Friday at 4 pm EST
Technology Development Firms		Date:	9/14/20
Company Name	Ticker Symbol	Stock Price	Beta	EPS	P/E	Dividend	Market Capitalization
Dell Technologies Inc	DELL	$ 66.85	N/A	2.76	24.19	N/A	49.918
Index		Closing Price		NOTE: No other stats needed
S&P 500	^GSPC	$ 3,383.54
Technology Development Firms		Date:	9/14/20
Company Name	Ticker Symbol	Stock Price	Beta	EPS	P/E	Dividend	Market Capitalization
Hewlett Packard Enterprise Company	HPE	9.37	1.230	0.000	9370.000	0.48(5.21%)	12.053
Index		Closing Price		NOTE: No other stats needed
S&P 500	^GSPC	3,383.54
Day 2
S&P 500		Date:	9/15/20
Company Name	Ticker Symbol	Stock Price	Beta	EPS	P/E	Dividend	Market Capitalization
Dell Technologies	DELL	$ 67.10	N/A	2.76	24.28	N/A	50.105
Index		Closing Price		NOTE: No other stats needed
S&P 500		$ 3,401.20
Technology Development Firms		Date:	9/15/20
Company Name	Ticker Symbol	Stock Price	Beta	EPS	P/E	Dividend	Market Capitalization
Hewlett Packard Enterprise Company	HPE	9.28	1.230	0.000	9280.000	0.48(5.19%)	11.938
Index		Closing Price		NOTE: No other stats needed
S&P 500	^GSPC	3,401.20
Day 3
Technology Development Firms		Date:	9/16/20
Company Name	Ticker Symbol	Stock Price	Beta	EPS	P/E	Dividend	Market Capitalization
Dell Technologies	DELL	$ 67.37	N/A	2.76	24.37	N/A	50.306
Index		Closing Price		NOTE: No other stats needed
S&P 500	^GSPC	$ 3,385.49
Technology Development Firms		Date:	9/16/20
Company Name	Ticker Symbol	Stock Price	Beta	EPS	P/E	Dividend	Market Capitalization
Hewlett Packard Enterprise Company	HPE	9.47	1.230	0.000	9470.000	0.48(5.12%)	12.182
Index		Closing Price		NOTE: No other stats needed
S&P 500	^GSPC	3,385.49
Day 4
S&P 500		Date:	9/17/20
Company Name	Ticker Symbol	Stock Price	Beta	EPS	P/E	Dividend	Market Capitalization
Dell Technologies	DELL	$ 66.56	N/A	2.76	24.08	N/A	49.701
Index		Closing Price		NOTE: No other stats needed
S&P 500	Ticker Symbol	$ 3,357.01
Technology Development Firms		Date:	9/17/20
Company Name	Ticker Symbol	Stock Price	Beta	EPS	P/E	Dividend	Market Capitalization
Hewlett Packard Enterprise Company	HPE	9.63	1.230	0.000	9630.000	0.48(5.17%)	12.388
Index		Closing Price		NOTE: No other stats needed
S&P 500	^GSPC	3,357.01
Day 5
Dell Technologies Inc		Date:	9/18/20
Company Name	Ticker Symbol	Stock Price	Beta	EPS	P/E	Dividend	Market Capitalization
Dell Technologies	DELL	$ 66.37	N/A	2.76	24.01	N/A	49.56
Index		Closing Price		NOTE: No other stats needed
S&P 500		$ 3,319.47
Technology Development Firms		Date:	9/18/20
Company Name	Ticker Symbol	Stock Price	Beta	EPS	P/E	Dividend	Market Capitalization
Hewlett Packard Enterprise Company	HPE	9.50	1.230	0.000	9500.000	0.48(5.07%)	12.221
Index		Closing Price		NOTE: No other stats needed
S&P 500	^GSPC	3,319.47

Week 5

Week 5 Data - Close of Market on Friday at 4pm EST
Company Name		Date:	9/21/20
Company Name	Ticker Symbol	Stock Price	Beta	EPS	P/E	Dividend	Market Capitalization
Dell Technologies Inc	DELL	$ 65.50	N/A	2.76	23.7	N/A	49.05
Index		Closing Price		NOTE: No other stats needed
S&P 500		$ 3,281.06
Technology Development Firms		Date:	9/21/20
Company Name	Ticker Symbol	Stock Price	Beta	EPS	P/E	Dividend	Market Capitalization
Hewlett Packard Enterprise Company	HPE	9.23	1.230	0.000	9230.000	0.48(4.98%)	12.036
Index		Closing Price		NOTE: No other stats needed
S&P 500	^GSPC	3,281.06
S&P 500		Date:	9/22/20
Company Name	Ticker Symbol	Stock Price	Beta	EPS	P/E	Dividend	Market Capitalization
Dell Technologies	DELL	$ 66.31	N/A	2.76	23.99	N/A	49.51
Index		Closing Price		NOTE: No other stats needed
S&P 500		$ 3,301.50
Technology Development Firms		Date:	9/22/20
Company Name	Ticker Symbol	Stock Price	Beta	EPS	P/E	Dividend	Market Capitalization
Hewlett Packard Enterprise Company	HPE	9.31	1.230	0.000	9310.000	0.48(5.05%)	11.976
Index		Closing Price		NOTE: No other stats needed
S&P 500	^GSPC	3,301.50
		Date:	9/23/20
Company Name	Ticker Symbol	Stock Price	Beta	EPS	P/E	Dividend	Market Capitalization
Dell Technologies	DELL	$ 65.61	N/A	2.76	23.74	N/A	48.992
Index		Closing Price		NOTE: No other stats needed
S&P 500		$ 3,236.92
Technology Development Firms		Date:	9/23/20
Company Name	Ticker Symbol	Stock Price	Beta	EPS	P/E	Dividend	Market Capitalization
Hewlett Packard Enterprise Company	HPE	9.07	1.230	0.000	9070.000	0.48(5.20%)	11.667
Index		Closing Price		NOTE: No other stats needed
S&P 500	^GSPC	3,236.92

Week 8

Week 8 Data - Close of Market at 4pm EST
Technology Development Firms		Date:
Company Name	Ticker Symbol	Stock Price	Beta	EPS	P/E	Dividend	Market Capitalization
Dell Technologies Inc	DELL
Index		Closing Price		NOTE: No other stats needed
S&P 500

Week 9

Week 9 Data - Close of Market on Friday at 4pm EST
Technology Development Firms		Date:
Company Name	Ticker Symbol	Stock Price	Beta	EPS	P/E	Dividend	Market Capitalization
Dell Technologies Inc	DELL
Index		Closing Price		NOTE: No other stats needed
S&P 500	^GSPC

Week 10

Week 8 Data - Close of Market at 4pm EST
Technology Development Firms		Date:
Company Name	Ticker Symbol	Stock Price	Beta	EPS	P/E	Dividend	Market Capitalization
Dell Technologies Inc	DELL
Index		Closing Price		NOTE: No other stats needed
S&P 500

Week 11

Week 9 Data - Close of Market on Friday at 4pm EST
Technology Development Firms		Date:
Company Name	Ticker Symbol	Stock Price	Beta	EPS	P/E	Dividend	Market Capitalization
Dell Technologies Inc	DELL
Index		Closing Price		NOTE: No other stats needed
S&P 500	^GSPC

Week 12

Week 8 Data - Close of Market at 4pm EST
Technology Development Firms		Date:
Company Name	Ticker Symbol	Stock Price	Beta	EPS	P/E	Dividend	Market Capitalization
Dell Technologies Inc	DELL
Index		Closing Price		NOTE: No other stats needed
S&P 500

No Week 13

No Week 13 Data being Collected

Stock Price Analysis

			Stock Price Analysis				Source:	Data will autofill from your weekly data entry
Market Sectors
and Stock
	Symbol	Week 3	Week 4	Week 5	Week 6	Week 7	Week 8	Week 9	Week 10	Week 11	Week 12
Tech Companies
Dell Technologies Inc	DELL	$ 60.64	#REF!		$ 66.85	Stock Price
Index
S &P 500	^GSPC	$ 3,443.62	#REF!		$ 3,383.54	Closing Price

Dell Technologies Inc

S & P 500

Market Capitalization

			Market Capitalization							Source:	Autofilled based on the data you entered in spreadsheets
Market Sectors
and Stock
	Symbol	Week 3	Week 4	Week 5	Week 6	Week 7	Week 8	Week 9	Week 10	Week 11	Week 12
Dell Technologies Inc	DELL	44.923B	#REF!		$ 49.92	Market Capitalization

Beta Analysis

		Beta Analysis				Source:	Autofilled from your weekly data input
Market Sectors
and Stock
	Symbol	Week 3	Week 4	Week 5	Week 6	Week 7	Week 8	Week 9	Week 10	Week 11	Week 12
Dell Technologies Inc	DELL	N/A	#REF!		N/A	Beta

Earnings Per Share

		Earnings Per Share Analysis (EPS)						Source:		Autofilled from your weekly data input
Market Sectors
and Stock
	Symbol	Week 3	Week 4	Week 5	Week 6	Week 7	Week 8	Week 9	Week 10	Week 11	Week 12
Dell Technologies Inc	DELL	$ 5.84	#REF!		$ 2.76	EPS

Dividends Per Share

			Dividends Per Share				Source:	Autofilled based on the data you entered in spreadsheets
Market Sectors
and Stock
	Symbol	Week 3	Week 4	Week 5	Week 6	Week 7	Week 8	Week 9	Week 10	Week 11	Week 12
Dell Technologies Inc	DELL	N/A	#REF!		N/A	Dividend