Excel Flujo de Caja de SumaCRM.com: el CRM para pymes y pequeñas empresas
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
View only
 
 
ABCDEFGHIJKLMNOPQRSTUVWXYZAAABACADAEAFAGAHAIAJAKALAMANAOAPAQARASAT
1
>>>
Click para PROBAR SUMACRM Gratis
2015201520152015201520152015201620162016201620162016201620162016201620162016201720172017201720172017201720172017201720172017
2
Las cifras hasta Febrero son reales y después estimadas en base a las métricas reales.
JuneJulioAgostoSeptiembreOctubreNoviembreDiciembreEneroFebreroMarzoAbrilMayoJunioJulioAgostoSeptiembreOctubreNoviembreDiciembreEneroFebreroMarzoAbrilMayoJunioJulioAgostoSeptiembreOctubreNoviembreDiciembre
3
TOTAL VENTAS (sin iva)IncrementoMétricas Reales€ 3,950€ 4,675€ 5,625€ 5,900€ 6,775€ 7,850€ 9,225€ 10,525€ 12,704€ 15,063€ 17,357€ 20,139€ 23,505€ 27,571€ 32,475€ 38,385€ 45,499€ 54,059€ 64,353€ 76,726€ 91,594€ 109,455€ 130,906€ 156,664€ 187,592€ 224,720€ 269,291€ 322,790€ 387,004€ 464,074€ 556,571
4
Número de Visitas Web 20%67057582379076989127105671367016587189342272127265327183926247114565376784481413976951172341406811688172025812430972917173500604200725040866049037258848710611045273
5
% de Visitas a Registros3%3%1532168225328736441950257968281898211781413169620352442293135174220506560777293875110502126021512318147217772613231358
6
Total de Registros a Clientes17%17%23351442486577891011161391672002402883464154985987178611033124014881785214225713085370244425331
7
Churn (caida de clientes)4%5%6%6%6%5%5%5%5%4%4%4%4%4%4%4%4%4%4%4%4%4%4%4%4%4%4%4%4%4%4%4%4%
8
9
Total clientes acumulado15818418721725430736843952260369480694011031299153518202162257430693664437852366267750489891077212912154801856322263
10
if
ARPA (Ticket medio por empresa)
€ 2525 €25 €30 €27 €27 €26 €25 €24 €24 €25 €25 €25 €25 €25 €25 €25 €25 €25 €25 €25 €25 €25 €25 €25 €25 €25 €25 €25 €25 €25 €25 €
11
then
MRR (Facturación recurrente mensual)
3,950 €4,675 €5,625 €5,900 €6,775 €7,850 €9,225 €10,525 €12,704 €15,063 €17,357 €20,139 €23,505 €27,571 €32,475 €38,385 €45,499 €54,059 €64,353 €76,726 €91,594 €109,455 €130,906 €156,664 €187,592 €224,720 €269,291 €322,790 €387,004 €464,074 €556,571 €
12
IVA19%751 €329 €416 €658 €818 €964 €1,073 €1,220 €2,414 €2,862 €3,298 €3,826 €4,466 €5,238 €6,170 €7,293 €8,645 €10,271 €12,227 €14,578 €17,403 €20,796 €24,872 €29,766 €35,642 €42,697 €51,165 €61,330 €73,531 €88,174 €105,749 €
13
TOTAL VENTAS (con iva)4,701 €5,004 €6,041 €6,558 €7,593 €8,814 €10,298 €11,745 €15,118 €17,925 €20,655 €23,966 €27,971 €32,809 €38,645 €45,678 €54,144 €64,331 €76,580 €91,304 €108,997 €130,251 €155,778 €186,430 €223,234 €267,417 €320,456 €384,120 €460,534 €552,248 €662,320 €
14
15
TOTAL GASTOS (sin iva)IncrementoCoste€ 6,405€ 6,620€ 6,540€ 7,689€ 7,654€ 7,843€ 14,223€ 14,289€ 15,237€ 27,098€ 34,115€ 31,548€ 32,566€ 33,677€ 34,899€ 44,951€ 42,715€ 44,418€ 46,346€ 51,594€ 51,963€ 54,467€ 57,431€ 60,946€ 68,171€ 71,385€ 77,296€ 84,340€ 92,743€ 102,775€ 117,545
16
17
Marketing Online1,164 €1,164 €1,224 €2,158 €2,082 €2,158 €2,138 €2,060 €2,375 €2,675 €3,028 €3,444 €3,935 €4,516 €5,205 €6,023 €6,995 €8,152 €9,530 €11,173 €13,132 €15,472 €18,267 €21,607 €25,602 €30,382 €36,102 €42,950 €51,151 €60,974 €72,743 €
18
General20%164 €164 €184 €1,098 €1,022 €1,098 €1,265 €1,148 €1,265 €1,518 €1,822 €2,186 €2,623 €3,148 €3,777 €4,533 €5,439 €6,527 €7,833 €9,399 €11,279 €13,535 €16,242 €19,490 €23,388 €28,065 €33,679 €40,414 €48,497 €58,196 €69,836 €
19
Google Adwords1,000 €500 €500 €500 €500 €500 €500 €
20
Facebook Ads117 €20 €134 €58 €134 €117 €0 €117 €
21
Notas de Prensa164 €164 €164 €164 €164 €164 €164 €164 €164 €164 €
22
wwwhatsnew300 €300 €300 €300 €
23
Doiser484 €484 €484 €
24
Blog5%55 €55 €55 €55 €55 €55 €51 €55 €55 €55 €55 €55 €55 €55 €55 €55 €55 €55 €55 €55 €55 €55 €55 €55 €55 €55 €55 €55 €55 €55 €55 €
25
Acumbmail28 €28 €28 €28 €28 €28 €28 €24 €28 €28 €28 €28 €28 €28 €28 €28 €28 €28 €28 €28 €28 €28 €28 €28 €28 €28 €28 €28 €28 €28 €28 €28 €
26
Optimonster (captador leads)27 €27 €27 €27 €27 €27 €27 €27 €27 €27 €27 €27 €27 €27 €27 €27 €27 €27 €27 €27 €27 €27 €27 €27 €27 €27 €27 €27 €27 €27 €27 €27 €
27
Hosting web5%889 €889 €889 €889 €889 €889 €700 €735 €933 €980 €1,029 €1,081 €1,135 €1,191 €1,251 €1,313 €1,379 €1,448 €1,520 €1,597 €1,676 €1,760 €1,848 €1,941 €2,038 €2,139 €2,246 €2,359 €2,477 €2,601 €2,731 €0 €
28
HOSTING: (aow) produccion514 €514 €622 €622 €622 €622 €622 €622 €622 €653 €686 €720 €756 €794 €834 €875 €919 €965 €1,013 €1,064 €1,117 €1,173 €1,232 €1,293 €1,358 €1,426 €1,497 €1,572 €1,650 €1,733 €1,820 €1,910 €
29
HOSTING: (aow) preproduccion272 €267 €267 €267 €267 €267 €267 €267 €267 €280 €294 €309 €325 €341 €358 €376 €394 €414 €435 €457 €479 €503 €529 €555 €583 €612 €643 €675 €708 €744 €781 €820 €
30
Sales:5%56 €56 €96 €116 €116 €116 €116 €116 €116 €116 €116 €116 €116 €116 €116 €116 €116 €116 €116 €116 €116 €116 €116 €116 €116 €116 €116 €116 €116 €116 €116 €0 €
31
Olark43 €43 €43 €43 €43 €43 €43 €43 €43 €43 €43 €43 €43 €43 €43 €43 €43 €43 €43 €43 €43 €43 €43 €43 €43 €43 €43 €43 €43 €43 €43 €43 €
32
ClickMeeting40 €40 €40 €40 €40 €40 €40 €40 €40 €40 €40 €40 €40 €40 €40 €40 €40 €40 €40 €40 €40 €40 €40 €40 €40 €40 €40 €40 €40 €40 €
33
Groove13 €13 €13 €13 €13 €13 €13 €13 €13 €13 €13 €13 €13 €13 €13 €13 €13 €13 €13 €13 €13 €13 €13 €13 €13 €13 €13 €13 €13 €13 €13 €13 €
34
Skype Creditos (resto llamadas)20 €20 €20 €20 €20 €20 €20 €20 €20 €20 €20 €20 €20 €20 €20 €20 €20 €20 €20 €20 €20 €20 €20 €20 €20 €20 €20 €20 €20 €
35
Netelip (1era llamada)0 €20 €20 €20 €20 €20 €20 €20 €20 €20 €20 €20 €20 €20 €20 €20 €20 €20 €20 €20 €20 €20 €20 €20 €20 €20 €20 €
36
Seo:5%6 €6 €6 €6 €6 €6 €6 €6 €6 €6 €6 €6 €6 €6 €6 €6 €6 €6 €6 €6 €6 €6 €6 €6 €6 €€ 0
37
Wincher (ranking SEO)6 €6 €6 €6 €6 €6 €6 €6 €6 €6 €6 €6 €6 €6 €6 €6 €6 €6 €6 €6 €6 €6 €6 €6 €6 €6 €6 €6 €6 €
38
Servicios Financieros€ 0€ 0€ 0€ 0€ 0€ 00 €0 €0 €0 €0 €0 €0 €0 €0 €0 €0 €0 €0 €0 €0 €0 €0 €0 €0 €0 €0 €0 €0 €0 €0 €
39
Braintree - Variable % of sales2.9%0 €0 €0 €0 €0 €0 €0 €0 €0 €0 €0 €0 €0 €0 €0 €0 €1,319 €1,568 €1,866 €2,225 €2,656 €3,174 €3,796 €4,543 €5,440 €6,517 €7,809 €9,361 €11,223 €13,458 €16,141 €
40
Braintree - Fix fee per transaction0.30 €0 €0 €0 €0 €0 €0 €0 €0 €0 €0 €0 €0 €0 €0 €0 €546 €649 €772 €921 €1,099 €1,313 €1,571 €1,880 €2,251 €2,697 €3,231 €3,873 €4,644 €5,569 €6,679 €
41
42
43
Servicios Offline€ 768€ 889€ 889€ 889€ 889€ 886€ 2,618€ 2,669€ 3,157€ 3,161€ 3,165€ 3,414€ 3,419€ 3,424€ 3,428€ 3,433€ 3,438€ 3,444€ 3,449€ 3,455€ 3,460€ 3,466€ 3,472€ 3,479€ 3,485€ 3,492€ 3,498€ 3,505€ 3,513€ 3,520€ 6,314€ 0
44
ALQUILER: (ceatres)363 €484 €484 €484 €484 €484 €484 €484 €968 €968 €968 €968 €968 €968 €968 €968 €968 €968 €968 €968 €968 €968 €968 €968 €968 €968 €968 €968 €968 €968 €968 €
45
TELEFONIA (tfno fijo y moviles España y movil alfredo)
5%101 €101 €101 €101 €101 €98 €130 €167 €167 €167 €167 €167 €167 €167 €167 €167 €167 €167 €167 €167 €167 €167 €167 €167 €167 €167 €167 €167 €167 €167 €175 €
46
TELEFONIA (voip)60 €70 €70 €70 €70 €70 €70 €70 €70 €70 €70 €70 €70 €70 €70 €70 €70 €70 €70 €70 €70 €70 €70 €70 €70 €
47
GESTORIA (global)3%157 €157 €157 €157 €157 €157 €130 €134 €138 €142 €146 €151 €155 €160 €165 €170 €175 €180 €185 €191 €197 €203 €209 €215 €221 €228 €235 €242 €249 €257 €264 €
48
ENISA1: (intereses y gestion)147 €147 €147 €147 €147 €147 €147 €147 €147 €147 €147 €147 €147 €147 €147 €147 €147 €147 €147 €147 €147 €147 €147 €147 €147 €147 €147 €147 €147 €147 €147 €
49
ENISA1: (devolucion)0 €0 €0 €0 €0 €0 €1,667 €1,667 €1,667 €1,667 €1,667 €1,667 €1,667 €1,667 €1,667 €1,667 €1,667 €1,667 €1,667 €1,667 €1,667 €1,667 €1,667 €1,667 €1,667 €1,667 €1,667 €1,667 €1,667 €1,667 €1,667 €
50
ENISA2: (intereses y gestion)1,210 €245 €245 €245 €245 €245 €245 €245 €245 €245 €245 €245 €245 €245 €245 €245 €245 €245 €245 €245 €245 €
51
ENISA2: (devolucion)2,778 €
52
53
Otros servicios€ 0€ 0€ 0€ 0€ 0€ 0€ 0€ 0€ 0€ 4,500€ 4,500€ 750€ 750€ 750€ 750€ 4,500€ 750€ 750€ 750€ 2,500€ 750€ 750€ 750€ 750€ 2,500€ 750€ 750€ 750€ 750€ 750€ 750
54
Comidas250 €250 €250 €250 €250 €250 €250 €250 €250 €250 €250 €250 €250 €250 €250 €250 €250 €250 €250 €250 €250 €250 €
55
Ordenadores2,000 €4,000 €4,000 €250 €250 €250 €250 €4,000 €250 €250 €250 €2,000 €250 €250 €250 €250 €2,000 €250 €250 €250 €250 €250 €250 €
56
Mobiliario250 €250 €250 €250 €250 €250 €250 €250 €250 €250 €250 €250 €250 €250 €250 €250 €250 €250 €250 €250 €250 €250 €
57
58
PersonalIncremento€ 4,473€ 4,567€ 4,427€ 4,642€ 4,683€ 4,799€ 9,468€ 9,560€ 9,705€ 16,762€ 23,423€ 23,940€ 24,462€ 24,987€ 25,516€ 30,994€ 31,531€ 32,072€ 32,617€ 34,466€ 34,620€ 34,779€ 34,942€ 35,110€ 36,583€ 36,762€ 36,945€ 37,135€ 37,330€ 37,530€ 37,737
59
CEO y Marketing - Tomi100 €2,000 €1,500 €1,500 €1,500 €1,500 €1,500 €1,500 €1,500 €1,500 €1,500 €2,000 €2,100 €2,200 €2,300 €2,400 €2,500 €2,600 €2,700 €2,800 €2,900 €3,000 €3,000 €3,000 €3,000 €3,000 €3,000 €3,000 €3,000 €3,000 €3,000 €3,000 €3,000 €
60
Customer Success- Alfredo100 €2,000 €1,500 €1,500 €1,500 €1,500 €1,500 €1,500 €1,500 €1,500 €1,500 €2,000 €2,100 €2,200 €2,300 €2,400 €2,500 €2,600 €2,700 €2,800 €2,900 €3,000 €3,000 €3,000 €3,000 €3,000 €3,000 €3,000 €3,000 €3,000 €3,000 €3,000 €3,000 €
61
CIO y Developer - Alejandro100 €2,000 €1,500 €1,500 €1,500 €2,000 €2,100 €2,200 €2,300 €2,400 €2,500 €2,600 €2,700 €2,800 €2,900 €3,000 €3,000 €3,000 €3,000 €3,000 €3,000 €3,000 €3,000 €3,000 €3,000 €3,000 €3,000 €
62
CTO y Developer - Henry100 €2,000 €1,500 €1,500 €1,500 €2,000 €2,100 €2,200 €2,300 €2,400 €2,500 €2,600 €2,700 €2,800 €2,900 €3,000 €3,000 €3,000 €3,000 €3,000 €3,000 €3,000 €3,000 €3,000 €3,000 €3,000 €3,000 €
63
Comercial 11,300 €1,473 €1,567 €1,427 €1,642 €1,683 €1,799 €1,878 €1,940 €2,037 €2,098 €2,161 €2,226 €2,292 €2,361 €2,432 €2,505 €2,580 €2,658 €2,737 €2,819 €2,904 €2,991 €3,081 €3,173 €3,269 €3,367 €3,468 €3,572 €3,679 €3,789 €3,903 €
64
Soporte 1 - 1,300 €1,300 €1,300 €1,300 €1,300 €1,300 €1,300 €1,300 €1,300 €1,300 €1,300 €1,300 €1,300 €1,300 €1,300 €1,300 €1,300 €1,300 €1,300 €1,300 €1,300 €1,300 €1,300 €
65
Comercial 21,300 €1,589 €1,620 €1,668 €1,718 €1,770 €1,823 €1,878 €1,934 €1,992 €2,052 €2,113 €2,177 €2,242 €2,309 €2,379 €2,450 €2,524 €2,599 €2,677 €2,758 €2,840 €2,926 €3,013 €3,104 €3,197 €
66
Developer 13,646 €3,646 €3,646 €3,646 €3,646 €3,646 €3,646 €3,646 €3,646 €3,646 €3,646 €3,646 €3,646 €3,646 €3,646 €3,646 €3,646 €3,646 €3,646 €3,646 €3,646 €3,646 €3,646 €
67
Developer 23,646 €3,646 €3,646 €3,646 €3,646 €3,646 €3,646 €3,646 €3,646 €3,646 €3,646 €3,646 €3,646 €3,646 €3,646 €3,646 €3,646 €3,646 €3,646 €3,646 €3,646 €3,646 €
68
Marketing 1 2,500 €2,500 €2,500 €2,500 €2,500 €2,500 €2,500 €2,500 €2,500 €2,500 €2,500 €2,500 €2,500 €2,500 €2,500 €2,500 €2,500 €2,500 €2,500 €2,500 €2,500 €2,500 €
69
Developer 33,646 €3,646 €3,646 €3,646 €3,646 €3,646 €3,646 €3,646 €3,646 €3,646 €3,646 €3,646 €3,646 €3,646 €3,646 €3,646 €3,646 €
70
Administracion 1 - 1,300 €1,300 €1,300 €1,300 €1,300 €1,300 €1,300 €1,300 €1,300 €1,300 €1,300 €1,300 €1,300 €1,300 €1,300 €1,300 €1,300 €
71
Soporte 1 - 1,300 €1,300 €1,300 €1,300 €1,300 €1,300 €1,300 €1,300 €1,300 €1,300 €1,300 €1,300 €1,300 €
72
Soporte 2 - 1,300 €1,300 €1,300 €1,300 €1,300 €1,300 €1,300 €1,300 €
73
74
75
76
Pérdidas / Ganancias-€ 2,455-€ 1,945-€ 915-€ 1,789-€ 879€ 7-€ 4,998-€ 3,764-€ 2,533-€ 12,035-€ 16,758-€ 11,409-€ 9,060-€ 6,106-€ 2,424-€ 6,566€ 2,784€ 9,642€ 18,007€ 25,133€ 39,631€ 54,988€ 73,475€ 95,718€ 119,421€ 153,335€ 191,995€ 238,450€ 294,261€ 361,299€ 439,027
77
Pérdidas / Ganancias acumulado
-83,630 €-€ 2,455-€ 4,400-€ 5,315-€ 7,104-€ 7,983-€ 7,976-€ 12,975-€ 16,738-€ 19,272-€ 31,307-€ 48,065-€ 59,474-€ 68,534-€ 74,640-€ 77,064-€ 83,630-€ 80,846-€ 71,205-€ 53,198-€ 28,065€ 11,567€ 66,555€ 140,029€ 235,747€ 355,168€ 508,503€ 700,498€ 938,948€ 1,233,209€ 1,594,508€ 2,033,535
78
79
Perdidas Ganancias Total€ 45,000€ 43,055€ 42,140€ 40,351€ 39,471€ 39,478€ 34,480€ 30,716€ 139,183€ 127,148€ 110,390€ 98,981€ 89,921€ 83,815€ 81,390€ 74,824€ 77,608€ 87,250€ 105,257€ 130,390€ 170,021€ 225,009€ 298,484€ 394,202€ 513,622€ 666,958€ 858,953€ 1,097,403€ 1,391,663€ 1,752,962€ 2,191,989
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
Loading...
Main menu