flujo de cajau
DESCRIPTION
detalles de libroTRANSCRIPT
FLUJO DE CAJA
DETALLEINSTALACIÓN OPERACIÓN
0 1 2 3 41.- INGRESOS
Alquiler de ambientes 2640000 3020000 3276000 3528000
TOTAL INGRESOS 2,640,000.00 3,020,000.00 3,276,000.00 3,528,000.00
2.- EGRESOS
Inversiones FijasInfraestructura 11,886,124.52
Inversiones DiferidasPre-Inversión 1155129.40Supervición 770086.26
Capital de Trabajo 1232138.02
Costos de OperaciónCostos Fijos 118800 118,800.00 118,800.00 118,800.00 118,800.00Costos Variables 23,400.00 23,400.00 24,570.00 25,798.00 27,087.00
Depreciación (-)Infraestructura 594,306.23 594,306.23 594,306.23 594,306.23
TOTAL EGRESOS 12,028,324.52 736,506.23 737,676.23 738,904.23 740,193.23
3.- UTILIDAD BRUTA -12,028,324.52 1,903,493.77 2,282,323.77 2,537,095.77 2,787,806.77
4.- IMPUESTOS
IVA, IT 16% 0.00 304,559.00 365,171.80 405,935.32 446,049.08
5.- UTILIDAD NETA -12,028,324.52 1,598,934.77 1,917,151.97 2,131,160.45 2,341,757.69
6.- DEPRECIACIÓN (+)
Infraestructura 125,894.82 125,894.82 125,894.82 125,894.82
FLUJO NETO -12,028,324.52 1,724,829.59 2,043,046.79 2,257,055.27 2,467,652.51
FLUJO DE CAJAOPERACIÓN
5 6 7 8 9 10
3780000 4032000 4284000 4536000 4788000 5040000
3,780,000.00 4,032,000.00 4,284,000.00 4,536,000.00 4,788,000.00 5,040,000.00
118,800.00 118,800.00 118,800.00 118,800.00 118,800.00 118,800.0028,441.00 29,863.00 31,356.00 32,923.00 34,569.00 36,297.00
594,306.23 594,306.23 594,306.23 594,306.23 594,306.23 594,306.23
741,547.23 742,969.23 744,462.23 746,029.23 747,675.23 749,403.23
3,038,452.77 3,289,030.77 3,539,537.77 3,789,970.77 4,040,324.77 4,290,596.77
486,152.44 526,244.92 566,326.04 606,395.32 646,451.96 686,495.48
2,552,300.33 2,762,785.85 2,973,211.73 3,183,575.45 3,393,872.81 3,604,101.29
125,894.82 125,894.82 125,894.82 125,894.82 125,894.82 125,894.82
2,678,195.15 2,888,680.67 3,099,106.55 3,309,470.27 3,519,767.63 3,729,996.11
AÑO
012345678910
VAN
FLUJO DE CAJA AÑO FLUJO DE CAJA AÑO
-12,028,324.52 0 -12,028,324.52 01,724,829.59 1 1,724,829.59 12,043,046.79 2 2,043,046.79 22,257,055.27 3 2,257,055.27 32,467,652.51 4 2,467,652.51 42,678,195.15 5 2,678,195.15 52,888,680.67 6 2,888,680.67 63,099,106.55 7 3,099,106.55 73,309,470.27 8 3,309,470.27 83,519,767.63 9 3,519,767.63 93,729,996.11 10 3,729,996.11 10
8,702,585.53 TIR 16% VP
R B/C
5%
BENEFICIO COSTO
0.00 12,028,324.522,640,000.00 915,170.413,020,000.00 976,953.213,276,000.00 1,018,944.733,528,000.00 1,060,347.493,780,000.00 1,101,804.854,032,000.00 1,143,319.334,284,000.00 1,184,893.454,536,000.00 1,226,529.734,788,000.00 1,268,232.375,040,000.00 1,310,003.89
29,251,622.88 20,549,037.36
1.42