GURUF DCF Calculator Template.xlsx

	A	B	C	D	E	F	G	H	I	J	K
1			1. If you do not have Excel Add-in downloaded, please install the Add-in at https://www.gurufocus.com/excel-add-in
2			2. Make sure you login to the Excel Add-in. The username / password is the same as for GuruFocus.com.
3			3. Enter the required inputs in Cells B18-B24. Do not change the formulas in the other cells.
4			4. Enter the desired first-year value in Cell B21. The default value is TTM EPS without NRI.
5			The per-share Data table gives data for the trailing 12 months and the past seven years.
6			Either use one of the values in the table or enter your own first-year value.
7			5. The growth rates consider 10-year periods. The default growth rate is the 10-year EPS growth rate.
8			The growth rate is winsorized between 0.05 and 0.20.
9			6. Enter a 1 in Cell B24 to add tangible book value to fair value or a 0 to exclude tangible book value.
10			7. For more information about the DCF valuation model, please consult:
11			https://www.gurufocus.com/term/iv_dcEarning/NAS:AAPL/Intrinsic-Value:-DCF-(Earnings-Based)/Apple
12			https://www.gurufocus.com/term/iv_dcf/NAS:AAPL/Intrinsic-Value:-DCF-(FCF-Based)/Apple
13
14
15	GuruFocus Fair Value Calculator
16				Per-share Data
17	Inputs:			Fiscal Year	TTM	#NAME?
18	Symbol	GOOGL		Revenue per Share	#NAME?
19	First Year	2022		EPS without NRI	#NAME?	#NAME?
20	First Year Value	#NAME?		Free Cash Flow per Share	#NAME?	#NAME?
21	Growth Stage Rate	#NAME?		Book Value per Share	#NAME?	#NAME?
22	Terminal Growth Rate	0.04		Operating Cash Flow per Share	#NAME?	#NAME?
23	Discount Rate	0.09		EBITDA per Share	#NAME?	#NAME?
24	Add Tangible Book Value	0		Dividends per Share	#NAME?	#NAME?
25				Growth Rates	Reported	Adjusted
26				10-year Revenue Growth Rate (per Share)	#NAME?	#NAME?
27	Output			10-year EPS without NRI Growth Rate	#NAME?	#NAME?
28	Base Year	2022		10-year FCF Growth Rate (per Share)	#NAME?	#NAME?
29	Base Year Value	#NAME?		10-year Book Growth Rate (per Share)	#NAME?	#NAME?
30	X	#NAME?		10-year EBITDA Growth Rate (per Share)	#NAME?	#NAME?
31	Y	0.954128		10-year Dividend Growth Rate (per Share)	#NAME?	#NAME?
32
33	Growth Value	2023	2024	2025	2026	2027	2028	2029	2030	2031	2032
34	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?
35
36	Terminal Value	2033	2034	2035	2036	2037	2038	2039	2040	2041	2042
37	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?
38
39	Tangible Book per Share	#NAME?
40
41	Fair Value	#NAME?
42	Price	#NAME?
43	Margin of Safety	#NAME?
44
45	Predictability	#NAME?
46	#NAME?
47	#NAME?
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