Sales Forecast 2026 (template).xlsx

	A	B	C	D	E	H	I	J
1	Object	Explicación
2	won from '25	son deals que ya tengo firmados pero que el revenue es para 2026				PASO 2: Definir el objetivo 2026
3	upselling	Nuevas oportunidades de revenue con clientes que ya tengo				Venta 2025	$2,000,000
4	pipeline	Deals que tengo en mi pipeline hoy en día y que puedo cerrar en 2026				Growth %	50%
5	% Win prob	Para los won es 100% y para Pipeline, el % que corresponda dependiendo cuan avanzado este				Target Venta 2026	$3,000,000
6	Adj Revenue	Valor del deal ajustado por el %win prob. Es el valor esperado real
7	Gap to 2025 target	Revenue Goal - (Bottom Up)
8						Paso 3: Yearly New Biz Goals and TOFU
9	TODO lo que sea de esto color no se toca. Son fórmulas					Gap to 2026 target	$422,635
10	TODO lo que sea de este color hay que llenarlo con data real de tu empresa					Avg Annual ticket x cliente	$100,000	Monthly
11						# New clients	4	0.4
12	PASO 1: BOTTOM UP		$3,140,904		$2,577,365	% Proposals to new clients	25%
13	Cliente	Type	USD Amount	%Win Prob	Adj Revenue	# Proposals needed	17	1.4
14	A	pipeline	$67,972	100%	$67,972	% New client meeting to proposal	50%
15	B	won from '25	$75,257	100%	$75,257	# New Discovery calls needed	34	2.8
16	C	won from '25	$708,402	100%	$708,402
17	D	won from '25	$556,030	100%	$556,030
18	E	won from '25	$855,078	100%	$855,078
19	A	upselling	$366,193	50%	$183,097	Mix Revenue 2026	$2,932,028	100%
20	B	upselling	$64,762	60%	$38,857	won from '25	$2,194,767	75%
21	F	pipeline	$166,009	10%	$16,601	upselling	$221,954	8%
22	G	pipeline	$82,886	20%	$16,577	pipeline	$92,673	3%
23	H	pipeline	$198,315	30%	$59,495	New biz	$422,635	14%
24
25
26
27
28
29
30
31
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