Hacienda La Conspiración — Plan de Negocios
Proyecciones financieras — 36 meses
Modelo de ramp, crecimiento e inflación aplicados mes a mes
Ingreso mes 1
$26,694
Ingreso mes 12
$62,379
Ingreso mes 36
$69,615
Caja al mes 36
$186,921
Supuestos operativos
Días operativos / mes26
Turnos / día1.25
Ocupación (%)65%
Ticket promedio ($)39
COGS (%)30%
Renta ($)3300
Utilidades ($)3200
Otros gastos ($)4000
Deuda mensual ($)2300
Supuestos de caja
Crecimiento anual (%)5.5%
Inflación anual (%)3.5%
Caja inicial ($)$30,000
Ramp inicio (%)45%
Proyecciones son estimados. Valida con contador CPA antes de presentar a BDE/SBA.
| Mes | Ingresos | COGS | Gastos fijos | Neto | Caja acum. |
|---|---|---|---|---|---|
| 1 | $26,694 | $8,008 | $37,507 | -$18,822 | $11,178 |
| 2 | $37,741 | $11,322 | $37,612 | -$11,193 | -$15 |
| 3 | $48,889 | $14,667 | $37,717 | -$3,495 | -$3,510 |
| 4 | $60,138 | $18,042 | $37,822 | $4,275 | $765 |
| 5 | $60,414 | $18,124 | $37,928 | $4,362 | $5,127 |
| 6 | $60,691 | $18,207 | $38,034 | $4,450 | $9,577 |
| 7 | $60,969 | $18,291 | $38,140 | $4,538 | $14,115 |
| 8 | $61,249 | $18,375 | $38,247 | $4,627 | $18,742 |
| 9 | $61,529 | $18,459 | $38,354 | $4,717 | $23,459 |
| 10 | $61,811 | $18,543 | $38,461 | $4,807 | $28,266 |
| 11 | $62,095 | $18,628 | $38,568 | $4,898 | $33,164 |
| 12 | $62,379 | $18,714 | $38,676 | $4,989 | $38,153 |
| 13 | $62,665 | $18,800 | $38,784 | $5,081 | $43,235 |
| 14 | $62,952 | $18,886 | $38,893 | $5,174 | $48,408 |
| 15 | $63,241 | $18,972 | $39,001 | $5,267 | $53,676 |
| 16 | $63,531 | $19,059 | $39,111 | $5,361 | $59,036 |
| 17 | $63,822 | $19,147 | $39,220 | $5,455 | $64,492 |
| 18 | $64,114 | $19,234 | $39,330 | $5,550 | $70,042 |
| 19 | $64,408 | $19,322 | $39,440 | $5,646 | $75,688 |
| 20 | $64,703 | $19,411 | $39,550 | $5,742 | $81,430 |
| 21 | $65,000 | $19,500 | $39,661 | $5,839 | $87,270 |
| 22 | $65,298 | $19,589 | $39,772 | $5,937 | $93,206 |
| 23 | $65,597 | $19,679 | $39,883 | $6,035 | $99,241 |
| 24 | $65,898 | $19,769 | $39,995 | $6,134 | $105,375 |
| 25 | $66,200 | $19,860 | $40,107 | $6,233 | $111,608 |
| 26 | $66,503 | $19,951 | $40,219 | $6,333 | $117,941 |
| 27 | $66,808 | $20,042 | $40,332 | $6,434 | $124,375 |
| 28 | $67,114 | $20,134 | $40,445 | $6,535 | $130,910 |
| 29 | $67,422 | $20,227 | $40,558 | $6,637 | $137,548 |
| 30 | $67,731 | $20,319 | $40,672 | $6,740 | $144,288 |
| 31 | $68,041 | $20,412 | $40,786 | $6,843 | $151,131 |
| 32 | $68,353 | $20,506 | $40,900 | $6,947 | $158,078 |
| 33 | $68,666 | $20,600 | $41,015 | $7,052 | $165,130 |
| 34 | $68,981 | $20,694 | $41,129 | $7,157 | $172,288 |
| 35 | $69,297 | $20,789 | $41,245 | $7,263 | $179,551 |
| 36 | $69,615 | $20,884 | $41,360 | $7,370 | $186,921 |