Flujo de Caja Proyectado
Flujo de Caja Proyectado
Flujo de Caja Proyectado
Ingresos Extraordinarios
Crédito financiero 40,000,000.00
Total Ingresos Extraordinarios 40,000,000.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Total Ingresos 43,010,000.00 3,070,200.00 3,131,604.00 3,194,236.08 3,258,120.80 3,323,283.22 3,389,748.88 3,457,543.86 3,526,694.74 3,597,228.63 3,669,173.20 3,742,556.67 3,817,407.80
Menos Compras:
Compras 916,580.00 934,911.60 953,609.83 972,682.03 992,135.67 1,011,978.38 1,032,217.95 1,052,862.31 1,073,919.56 1,095,397.95 1,117,305.91 1,139,652.02 1,162,445.06
Flujo de Caja Neto Acumulado 113,809 290,338 530,399 834,815 1,204,432 1,640,107 2,142,718 2,713,159 3,352,342 4,061,198 4,840,675 5,691,742 6,615,386
Extinsur, C. A. -
Ingresos Extraordinarios
Crédito financiero
Total Ingresos Extraordinarios 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Total Ingresos 3,893,755.96 3,971,631.08 4,051,063.70 4,132,084.97 4,214,726.67 4,299,021.21 4,385,001.63 4,472,701.66 4,562,155.70 4,653,398.81 4,746,466.79 4,841,396.12 4,938,224.04 5,036,988.52 5,137,728.29 5,240,482.86
Menos Compras:
Compras 1,185,693.97 1,209,407.84 1,233,596.00 1,258,267.92 1,283,433.28 1,309,101.95 1,335,283.98 1,361,989.66 1,389,229.46 1,417,014.05 1,445,354.33 1,474,261.41 1,503,746.64 1,533,821.58 1,564,498.01 1,595,787.97
Flujo de Caja Neto Acumulado 7,612,614 8,684,452 9,831,950 11,056,176 12,358,220 13,739,193 15,200,230 16,742,488 18,367,147 20,075,410 21,868,504 23,747,683 25,714,224 27,769,428 29,914,626 32,151,172
Extinsur, C. A. -
Ingresos Extraordinarios
Crédito financiero 40,000,000.00
Total Ingresos Extraordinarios 0.00 0.00 0.00 0.00 0.00 0.00 0.00 40,000,000.00
Total Ingresos 5,345,292.52 5,452,198.37 5,561,242.34 5,672,467.18 5,785,916.53 5,901,634.86 6,019,667.55 196,503,045.23
Menos Compras:
Compras 1,627,703.73 1,660,257.80 1,693,462.96 1,727,332.22 1,761,878.86 1,797,116.44 1,833,058.77 47,656,997.08
Flujo de Caja Neto Acumulado 34,480,448 36,903,866 39,422,863 37,096,492 39,811,079 42,237,520 45,153,803 50,484,434
Flujo de Caja Proyectado
(Expresado en bolívares)
1 2 3 4 5 6 7
Ingresos Ordinarios / Período
Ingresos por ventas 3,010,000.00 3,070,200.00 3,131,604.00 3,194,236.08 3,258,120.80 3,323,283.22 3,389,748.88
Total Ingresos Oridnarios 3,010,000.00 3,070,200.00 3,131,604.00 3,194,236.08 3,258,120.80 3,323,283.22 3,389,748.88
Ingresos Extraordinarios
Crédito financiero 40,000,000.00
Total Ingresos Extraordinarios 40,000,000.00 0.00 0.00 0.00 0.00 0.00 0.00
Menos Compras:
Compras 916,580.00 934,911.60 953,609.83 972,682.03 992,135.67 1,011,978.38 1,032,217.95
Flujo de Caja Neto Acumulado 32,847,142 99,068,116 198,663,732 331,634,815 497,982,209 697,706,774 930,809,385
8 9 10 11 12 13 14 15
40,000,000.00
0.00 0.00 0.00 0.00 0.00 40,000,000.00
Ingresos Extraordinarios
Crédito financiero 20,000,000,000.00
Total Ingresos Extraordinarios 20,000,000,000.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Total Ingresos 27,545,037,877.42 7,771,389,013.74 8,004,530,684.15 8,244,666,604.68 8,492,006,602.82 8,746,766,800.90 9,009,169,804.93 9,279,444,899.08 9,557,828,246.05 9,844,563,093.43 10,139,899,986.24 10,444,096,985.82 10,757,419,895.40
Menos Compras:
Compras 6,827,545,695.95 6,964,096,609.87 7,103,378,542.07 7,245,446,112.91 7,390,355,035.17 7,538,162,135.87 7,688,925,378.59 7,842,703,886.16 7,999,557,963.88 8,159,549,123.16 8,322,740,105.62 8,489,194,907.73 8,658,978,805.89
Flujo de Caja Neto Acumulado -493,418,930 -854,375,692 -1,101,031,339 -1,229,448,987 -1,235,543,071 -1,115,074,276 -863,644,299 -476,690,441 50,519,972 722,895,347 1,545,525,777 2,523,689,177 3,662,857,620
Extinsur, C. A. -
Ingresos Extraordinarios
Crédito financiero
Total Ingresos Extraordinarios 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Total Ingresos 11,080,142,492.26 11,412,546,767.03 11,754,923,170.04 12,107,570,865.14 12,470,797,991.09 12,844,921,930.83 13,230,269,588.75 13,627,177,676.41 14,035,993,006.71 14,457,072,796.91 14,890,784,980.82 15,337,508,530.24 15,797,633,786.15 16,271,562,799.73 16,759,709,683.72 17,262,500,974.24
Menos Compras:
Compras 8,832,158,382.01 9,008,801,549.65 9,188,977,580.64 9,372,757,132.25 9,560,212,274.90 9,751,416,520.40 9,946,444,850.80 10,145,373,747.82 10,348,281,222.78 10,555,246,847.23 10,766,351,784.18 10,981,678,819.86 11,201,312,396.26 11,425,338,644.18 11,653,845,417.07 11,886,922,325.41
Flujo de Caja Neto Acumulado 4,968,703,881 6,447,108,187 8,104,165,185 9,946,191,138 11,979,731,347 14,211,567,812 16,648,727,142 19,298,488,716 22,168,393,104 25,266,250,760 28,600,150,991 32,178,471,215 36,009,886,513 40,103,379,482 44,468,250,411 49,114,127,772
Extinsur, C. A. -
Ingresos Extraordinarios
Crédito financiero 20,000,000,000.00
Total Ingresos Extraordinarios 0.00 0.00 0.00 0.00 0.00 0.00 0.00 20,000,000,000.00
Total Ingresos 17,780,376,003.46 18,313,787,283.57 18,863,200,902.07 19,429,096,929.14 20,011,969,837.01 20,612,328,932.12 21,230,698,800.08 497,419,396,222.19
Menos Compras:
Compras 12,124,660,771.92 12,367,153,987.35 12,614,497,067.10 12,866,787,008.44 13,124,122,748.61 13,386,605,203.58 13,654,337,307.66 354,993,917,892.95
Flujo de Caja Neto Acumulado 54,050,979,051 59,289,121,921 64,839,235,771 59,924,116,881 66,131,717,577 71,393,136,762 78,305,587,090 90,386,325,617
TABLA DE AMORTIZACION CREDITO SOFITASA
Ingresos Extraordinarios
Crédito financiero 20,000,000,000.00 916,075,883.68 916,075,883.68 916,075,883.68 916,075,883.68 916,075,883.68 916,075,883.68 916,075,883.68 916,075,883.68 916,075,883.68 916,075,883.68 916,075,883.68 916,075,883.68
Total Ingresos Extraordinarios 20,000,000,000.00 916,075,883.68 916,075,883.68 916,075,883.68 916,075,883.68 916,075,883.68 916,075,883.68 916,075,883.68 916,075,883.68 916,075,883.68 916,075,883.68 916,075,883.68 916,075,883.68
Total Ingresos 27,545,037,877.42 8,687,464,897.43 8,920,606,567.84 9,160,742,488.36 9,408,082,486.50 9,662,842,684.59 9,925,245,688.61 10,195,520,782.76 10,473,904,129.74 10,760,638,977.12 11,055,975,869.92 11,360,172,869.51 11,673,495,779.08
Menos Compras:
Compras 6,827,545,695.95 6,964,096,609.87 7,103,378,542.07 7,245,446,112.91 7,390,355,035.17 7,538,162,135.87 7,688,925,378.59 7,842,703,886.16 7,999,557,963.88 8,159,549,123.16 8,322,740,105.62 8,489,194,907.73 8,658,978,805.89
Flujo de Caja Neto Acumulado -488,063,374 -877,844,249 -1,165,018,641 -1,345,105,337 -1,413,460,625 -1,365,272,861 -1,195,556,861 -899,148,101 -470,696,755 95,338,485 804,696,763 1,663,321,630 2,677,367,823
Extinsur, C. A. -
Ingresos Extraordinarios
Crédito financiero 916,075,883.68 916,075,883.68 916,075,883.68 916,075,883.68 916,075,883.68 916,075,883.68 916,075,883.68 916,075,883.68 916,075,883.68 916,075,883.68 916,075,883.68 916,075,883.68 916,075,883.68 916,075,883.68 916,075,883.68 916,075,883.68
Total Ingresos Extraordinarios 916,075,883.68 916,075,883.68 916,075,883.68 916,075,883.68 916,075,883.68 916,075,883.68 916,075,883.68 916,075,883.68 916,075,883.68 916,075,883.68 916,075,883.68 916,075,883.68 916,075,883.68 916,075,883.68 916,075,883.68 916,075,883.68
Total Ingresos 11,996,218,375.94 12,328,622,650.71 12,670,999,053.72 13,023,646,748.82 13,386,873,874.78 13,760,997,814.51 14,146,345,472.44 14,543,253,560.10 14,952,068,890.39 15,373,148,680.59 15,806,860,864.50 16,253,584,413.92 16,713,709,669.83 17,187,638,683.41 17,675,785,567.41 18,178,576,857.92
Menos Compras:
Compras 8,832,158,382.01 9,008,801,549.65 9,188,977,580.64 9,372,757,132.25 9,560,212,274.90 9,751,416,520.40 9,946,444,850.80 10,145,373,747.82 10,348,281,222.78 10,555,246,847.23 10,766,351,784.18 10,981,678,819.86 11,201,312,396.26 11,425,338,644.18 11,653,845,417.07 11,886,922,325.41
Flujo de Caja Neto Acumulado 3,853,208,253 5,197,441,227 6,716,897,889 8,418,649,903 10,310,017,385 12,398,577,078 14,692,170,793 17,198,914,117 19,927,205,395 22,885,735,000 26,083,494,895 29,529,788,497 33,234,240,858 37,206,809,159 41,457,793,548 45,997,848,309
Extinsur, C. A. -
Ingresos Extraordinarios
Crédito financiero 916,075,883.68 916,075,883.68 916,075,883.68 916,075,883.68 916,075,883.68 916,075,883.68 916,075,883.68 30,076,834,720.51
Total Ingresos Extraordinarios 916,075,883.68 916,075,883.68 916,075,883.68 916,075,883.68 916,075,883.68 916,075,883.68 916,075,883.68 30,076,834,720.51
Total Ingresos 18,696,451,887.15 19,229,863,167.25 19,779,276,785.76 20,345,172,812.82 20,928,045,720.69 21,528,404,815.80 22,146,774,683.77 507,496,230,942.70
Menos Compras:
Compras 12,124,660,771.92 12,367,153,987.35 12,614,497,067.10 12,866,787,008.44 13,124,122,748.61 13,386,605,203.58 13,654,337,307.66 354,993,917,892.95
Flujo de Caja Neto Acumulado 50,837,993,392 55,989,626,300 61,464,534,359 56,648,366,401 62,806,809,684 67,984,082,227 74,878,211,865 86,847,028,157