Nro. Unidades 350,000 280,000 350,000 420,000 Precio Unitario $ 580 $ 609 $ 639 $ 671 Costo Unitario $ 319 $ 335 $ 352 $ 369

Download as xlsx, pdf, or txt
Download as xlsx, pdf, or txt
You are on page 1of 3

DR.

PEPPER

DETALLE AÑO 0 AÑO 1 AÑO 2 AÑO 3 AÑO 4

Nro. Unidades 350,000 280,000 350,000 420,000


Precio unitario $ 580 $ 609 $ 639 $ 671
Costo unitario $ 319 $ 335 $ 352 $ 369
VENTAS $ 203,000,000 $ 170,520,000 $ 223,807,500 $ 281,997,450
(Costos Directos) -$ 111,650,000 -$ 93,786,000 -$ 123,094,125 -$ 155,098,598
(Gto Franquicia) -$ 10,150,000 -$ 8,526,000 -$ 11,190,375 -$ 11,279,898
(Gtos Administrat) -$ 55,944,000 -$ 59,300,640 -$ 83,018,678 -$ 87,999,799
(GFV) -$ 3,600,000 -$ 3,600,000 -$ 3,600,000 -$ 4,140,000
(GND - Depreciac) -$ 3,350,000 -$ 3,350,000 -$ 3,350,000 -$ 4,250,000
(GND - Amortizac) -$ 8,333,333 -$ 8,333,333 -$ 8,333,333
GND - Vr Desecho
(Interés Crédito)

UAI $ 9,972,667 -$ 6,375,973 -$ 8,779,012 $ 19,229,155


(Impuesto 33%) -$ 3,290,980 $0 $0 -$ 6,345,621

UDI $ 6,681,687 -$ 6,375,973 -$ 8,779,012 $ 12,883,534

GND - Depreciaci $ 3,350,000 $ 3,350,000 $ 3,350,000 $ 4,250,000


GND - Amortizac $ 8,333,333 $ 8,333,333 $ 8,333,333
GND - Vr en Libros
(Inversion AF) -$ 56,000,000 -$ 9,000,000
(PM financiable) -$ 15,000,000
(PM no financiable) -$ 10,000,000
(KT) + RKT -$ 28,532,333 $ 2,417,893 -$ 8,837,694 -$ 6,254,266 -$ 10,418,663
Préstamo
(Abono a la deuda)

FLUJO DE CAJA
Línea control KT -$ 28,532,333 -$ 26,114,440 -$ 34,952,134 -$ 41,206,399 -$ 51,625,062
AÑO 5

546,000
$ 705
$ 388
$ 384,926,519
-$ 211,709,586 Cuadro control AF
-$ 15,397,061
-$ 93,279,787 Activo Vr Adquisici VUC Dep anual Dep acum Vr Libros
-$ 4,761,000
-$ 4,250,000 Edificio $ 35,000,000 20 $ 1,750,000 $ 8,750,000 $ 26,250,000
Terreno $ 5,000,000 N/A N/A N/A $ 5,000,000
-$ 21,200,000 Maquinaria1 $ 16,000,000 10 $ 1,600,000 $ 8,000,000 $ 8,000,000
SUBTOTAL $ 56,000,000 $ 3,350,000

$ 34,329,086 Maquinaria2 $ 9,000,000 10 $ 900,000 $ 1,800,000 $ 7,200,000


-$ 11,328,598 TOTAL $ 9,000,000 $ 4,250,000 $ 46,450,000
Años 4 y 5
$ 23,000,488

$ 4,250,000

$ 46,450,000

$ 51,625,062
Vr Salvamen Vr Desecho

$ 14,000,000 -$ 12,250,000
$ 5,000,000 $0
$ 4,000,000 -$ 4,000,000

$ 2,250,000 -$ 4,950,000
-$ 21,200,000

You might also like