Trading Comp- Amazon and Apple Inc. .xlsx

	A	B	C	D
1	1	Company Ticker		AMZN
2	2	Company	Apple	Amazon

3	3
4	4	Current Date	24-Dec-22	24-Dec-22
5	5	Latest Quarter	24-Sep-22	30-Sep-22
6	6	LFY Date (Latest Financial Year)	24-Sep-22	31-Dec-22
7	7	Currency	USD	USD
8	8
9	9	Share Price - Class A	131.9	85.3
10	10	Shares Outstanding	15908.12	10,202
11	11
47	42	Diluted Equity Value	2,097,644.4	903,731
48	43
49	44	Cash & cash equivalents	48,304.0	58,662.0
50	45	Total debt	98,959.0	128,251.0
51	46	Pref. equity	0.0	0.0
52	47	Non controlling interest	0.0	0.0
53	48	Enterprise value	2,148,299.4	973,320
54	49
55	50	Revenue
56	51	LFY	394,328	469,822
57	52	+ Current Stub (Current Quarter)		364,779
58	53	- Prior Stub (Previous Quarter)		332,410
59	54	LTM	394,328	502,191
60	55
61	56	EV / LFY Sales	5.45x	2.07x
62	57	EV / LTM Sales	5.45x	1.94x
63	58
64	59	EBIT
65	60	LFY	119,437	24,879
66	61	+ Current Stub		9,511
67	62	- Prior Stub (Previous Quarter)		21,419
68	63	LTM	119,437	12,971
69	64
70	65	EV / LFY EBIT	18.0x	39.1x
71	66	EV / LTM EBIT	18.0x	75.0x
72	67
73	68	EBITDA
74	69	LFY	130,541	59,175
75	70	+ Current Stub		38,287
76	71	- Prior Stub (Previous Quarter)		34,005
77	72	LTM	130,541	63,457
78	73
79	74	EV / LFY EBITDA	16.5x	16.4x
80	75	EV / LTM EBITDA	16.5x	15.3x
81	76
82	77	Net income
83	78	LFY	99,803	33,364
84	79	+ Current Stub		(3,000)
85	80	- Prior Stub (Previous Quarter)		19,041
86	81	LTM	99,803	11,323
87	82
88	83	M cap / LFY Net income	21.0x	27.1x
89	84	M cap / LTM Net income = Price / EPS = P/E	21.0x	79.8x
90	85
91	86	EPS
92	87	LFY	6.27	3.15
93	88	LTM	6.27	1.07
94	89
95	90	Price / LFY EPS	21.0x	27.1x
96	91	Price / LTM EPS	21.0x	79.8x
97	92
98	93
99	94
100	95
101	96
102	97
103	98
104	99
105	100
106	101
107	102
108	103
109	104
110	105
111	106
112	107
113	108
114	109
115	110
116	111
117	112
118	113
119	114
120	115
121	116
122	117
123	118
124	119
125	120
126	121
127	122
128	123
129	124
130	125
131	126
132	127
133	128
134	129
135	130