Discounted Cash Flow Valuation.xlsx

	B	C	D	E	F	G	H	I	J	K	L	M
2	DISCOUNTED CASH FLOW VALUATION TEMPLATE

3	EXAMPLE
4	COMPANY NAME					DATE OF VALUATION
5						Friday, January 03, 2025
6
7	OPERATING INPUT DATA	$ Million		RATE INPUT DATA			%			TOTAL COMPANY VALUE (in $ Million)
8	Revenue	80.00		Tax Rate			20.00%			93.04
9	EBITDA	3.00		Short Term Revenue Growth Rate			5.50%			93.04
10	Depreciation & Amortization	2.00		Long Term Revenue Growth Rate			2.50%
11	Capital Expenditures	2.75		Weighted Average Cost of Capital (WACC)			10.00%
12	Working Capital	0.20		WACC Sensitivity			1.00%
13				Change in Working Capital			0.85%
14
15	FREE CASH FLOW TO FIRM (FCFF) PROJECTION
16		01/03/25	01/03/26	01/03/27	01/03/28	01/03/29	01/03/30	01/03/31	01/03/32	01/03/33	01/03/34	01/03/35
17	Revenue %		5.50%	5.17%	4.83%	4.50%	4.17%	3.83%	3.50%	3.17%	2.83%	2.50%
18	Revenue (in $ Million)	80.00	84.40	88.76	93.05	97.24	101.29	105.17	108.85	112.30	115.48	118.37
19	EBITDA	3.00	3.17	3.33	3.49	3.65	3.80	3.94	4.08	4.21	4.33	4.44
20	Depreciation & Amortization	2.00	33.76	35.50	37.22	38.90	40.52	42.07	43.54	44.92	46.19	47.35
21	EBIT	1.00	-30.60	-32.18	-33.73	-35.25	-36.72	-38.12	-39.46	-40.71	-41.86	-42.91
22	Income Tax	0.20	-6.12	-6.44	-6.75	-7.05	-7.34	-7.62	-7.89	-8.14	-8.37	-8.58
23	Net Operating Profit After Tax (NOPAT)	0.80	-24.48	-25.74	-26.98	-28.20	-29.37	-30.50	-31.57	-32.57	-33.49	-34.33
24	Capital Expenditure	2.75	2.90	3.05	3.20	3.34	3.48	3.62	3.74	3.86	3.97	4.07
25	Change in Working Capital		-0.04	-0.04	-0.04	-0.04	-0.03	-0.03	-0.03	-0.03	-0.03	-0.02
26	Free Cash Flow for Firm (FCFF)	0.05	6.35	6.68	7.00	7.32	7.63	7.92	8.20	8.46	8.71	8.93
27
28	DCF VALUATION
29		01/03/25	01/03/26	01/03/27	01/03/28	01/03/29	01/03/30	01/03/31	01/03/32	01/03/33	01/03/34	01/03/35
30	Years from Date of Valuation		1	2	3	4	5	6	7	8	9	10
31	Monthly Discount FCF @ rate	9.00%	5.82	5.62	5.41	5.18	4.95	4.72	4.49	4.25	4.01	3.77
32	Monthly Discount FCF @ rate	10.00%	5.77	5.52	5.26	5.00	4.73	4.47	4.21	3.95	3.69	3.44
33	Monthly Discount FCF @ rate	11.00%	5.72	5.42	5.12	4.82	4.52	4.23	3.95	3.67	3.40	3.14
34
35		DISCOUNTED CASH FLOW SUMMARY (in $ Million)
36		Rate	FCF over Projection Period	Terminal Value @ Rate	Terminal Cash Flow	Company Value	Percent Value in Projection Period	Percent Value in Terminal
37		9.00%	48.21	140.77	59.44	107.65	44.79%	55.21%
38		10.00%	46.03	122.00	47.01	93.04	49.47%	50.53%
39		11.00%	43.99	107.65	37.89	81.88	53.73%	46.27%
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
101