Companies DCF Spreadsheet

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O
1
2
3
4				2020	2021	2022	2023	2024	2025	2026	2027	2028	2029	2030	2031
5			Cars Sold	500,000	650000	975000	1462500	2193750	3290625	4935937.5	7403906.25	11105859.38	16658789.06	4997636.719	28153353.52
6			Price Per Car	42500	42500	42500	42500	35000	35000	35000	35000	35000	35000	35000	35000
7			Margin	0.23	0.23	0.23	0.23	0.23	0.23	0.23	0.23	0.23	0.23	0.23	0.23
8			EBITDA	4887500000	6353750000	9530625000	14295937500	17659687500	26489531250	39734296875	59601445313	89402167969	134103251953	40230975586	226634495801
9			Taxes (40%)	1955000000	2541500000	3812250000	5718375000	7063875000	10595812500	15893718750	23840578125	35760867188	53641300781	16092390234	90653798320
10			FCF	2932500000	3812250000	5718375000	8577562500	10595812500	15893718750	23840578125	35760867188	53641300781	80461951172	24138585352	135980697480
11			Discount Rate	1	1.08	1.1664	1.259712	1.36048896	1.469328077	1.586874323	1.713824269	1.85093021	1.999004627	2.158924997	2.331638997
12			Present day FCF	2932500000	3529861111	4902584877	6809145662	7788238502	10816997920	15023608222	20866122530	28980725736	40251007967	11180835546	58319790350
13
14
15
16
17
18
19
20	Growth Rate	0.3
21	Discount Rate	0.08
22	Terminal Growth Rate	0.02
23	Terminal Value (at 2031) in present day	2311671857168
24	Present Day FCF equivalent	153081628073
25	Market Cap equivalent based on DCF present day	2464753485241
26	Present day share price based on DCF	2948.269719
27
28
29	Current Market Cap	362000000000
30	Shares Outstanding	836,000,000
31	Price Per Share	433.0143541
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100