Mes 0 1 2
Ventas 480,000.00 480,000.00
Contado 336,000.00 336,000.00
30 días 96,000.00
60 días
Compras 192,000.00 192,000.00 201,600.00
CXP 192,000.00
Insumos 24,000.00 24,000.00
SyS 48,000.00 48,000.00
Gastos Adm. 23,000.00 23,000.00
Gastos Com. Fijo 28,000.00 28,000.00
Gastos Com. Var. 33.60 43.20
- 120,000.00 - 120,000.00
Tasa Prestamo 12% 117,899.14
Pagos Trimestrales
Bonos i 8% anual
Dividendos 25% UN
Politica 50000% Media mes
CXC - 67,200.00
Balance General
Año 2021 2022
ACTIVO
Disponibilidades 50,000.00 65,962.80
CXC 530,000.00 1,551,496.77
Inventarios 545,000.00 800,000.00
ACTIVO CIRCULANTE 1,125,000.00 2,417,459.57
Terrenos 125,000.00 125,000.00
Edificaciones e Instalaciones 350,000.00 315,000.00
Depreciación Acumulada 35,000.00 70,000.00
Maquinaria y Equipos 650,000.00 585,000.00
Depreciación Acumulada 65,000.00 130,000.00
Vehiculos 120,000.00 108,000.00
Depreciación Acumulada 12,000.00 24,000.00
ACTIVO FIJO 1,133,000.00 909,000.00
Gastos de Organización 100,000.00 100,000.00
Amortización 75,000.00 100,000.00
ACTIVO DIFERIDO 25,000.00 -
TOTAL ACTIVO 2,283,000.00 3,326,459.57
PASIVO
CxP comerciales 60,000.00 472,802.55
Deudas Bancarias 140,000.00 140,000.00
Deudas Sociales 72,000.00 -
PASIVO CORRIENTE 272,000.00
Deudas Bancarias 200,000.00 82,100.86
Previsiones 109,000.00 109,000.00
Bonos a 10 años 250,000.00 230,000.00
PASIVO A LARGO PLAZO 559,000.00 421,100.86
CAPITAL SOCIAL
Capital en Acciones 800,000.00 800,000.00
Utilidades Retenidas 390,250.00 733,271.74
Utilidades del Periodo 261,750.00 1,372,086.96
Riqueza Neta 1,452,000.00 2,905,358.71
TOTAL PASIVO Y CAPITAL 2,283,000.00 3,326,459.57
ESTADO DE RESULTADOS
Ventas 2,500,000.00 6,751,331.76
Costo de Ventas 1,530,000.00 3,583,749.30
Utilidad Bruta 970,000.00 3,167,582.46
Gastos de Administración 250,000.00 951,133.18
Gastos de Comercialización 320,000.00 336,000.00
U.A.I.I. 400,000.00 1,880,449.29
Gastos Financieros 51,000.00 51,000.00
U.A.I. 349,000.00 1,829,449.29
Impuestos 87,250.00 457,362.32
Utilidad Neta (para distribución) 261,750.00 1,372,086.96
ESTADO DE FLUJO DE EFECTIVO
UN 1,372,086.96
Depreciacion 112,000.00
CXC - 1,021,496.77
CXP 412,802.55
Inventarios - 255,000.00
Deuda bancaria -
CF Operaciones 620,392.75
Activo Fijo -
CF Inversión -
Deuda bancaria - 117,899.14
Previsiones -
Bonos - 20,000.00
CF Financiamiento - 137,899.14
CF Inicial 50,000.00
CF 482,493.61
CF Final 532,493.61
3 4 5 6 7 8
504,000.00 529,200.00 555,660.00 583,443.00 612,615.15 600,362.85
352,800.00 370,440.00 388,962.00 408,410.10 428,830.61 420,253.99
96,000.00 100,800.00 105,840.00 111,132.00 116,688.60 122,523.03
48,000.00 48,000.00 50,400.00 52,920.00 55,566.00 58,344.30
211,680.00 222,264.00 233,377.20 245,046.06 240,145.14 235,342.24
192,000.00 201,600.00 211,680.00 222,264.00 233,377.20 245,046.06
25,200.00 26,460.00 27,783.00 29,172.15 30,630.76 30,018.14
50,400.00 52,920.00 55,566.00 58,344.30 61,261.52 60,036.28
23,000.00 23,000.00 23,000.00 23,000.00 23,000.00 23,000.00
28,000.00 28,000.00 28,000.00 28,000.00 28,000.00 28,000.00
49.68 51.92 54.52 57.25 60.11 60.11
- 126,000.00 - 132,300.00
81,600.00 84,960.00 89,208.00 93,668.40 98,351.82 103,269.41
9 10 11 12 13 14
588,355.59 576,588.48 605,417.90 635,688.80
411,848.91 403,611.93 423,792.53 444,982.16
120,072.57 117,671.12 115,317.70 121,083.58 127,137.76
61,261.52 60,036.28 58,835.56 57,658.85 60,541.79 63,568.88
230,635.39 242,167.16 254,275.52
240,145.14 235,342.24 230,635.39 242,167.16 254,275.52
29,417.78 28,829.42 30,270.90 31,784.44
58,835.56 57,658.85 60,541.79 63,568.88
23,000.00 23,000.00 23,000.00 23,000.00
28,000.00 28,000.00 28,000.00 28,000.00
59.32 58.13 59.79 62.37 18.77 6.36
102,429.25 100,380.67 98,373.05 102,056.16 1,021,496.77
6,751,331.76
2,700,532.71
337,566.59
