Estudio Financiero Concreto Premezclado
description
Transcript of Estudio Financiero Concreto Premezclado
![Page 1: Estudio Financiero Concreto Premezclado](https://reader035.fdocuments.mx/reader035/viewer/2022071705/563dbaf7550346aa9aa91c87/html5/thumbnails/1.jpg)
Valor de planta 6,227,911.02 Silos 450,000.00 Equipo de transporte 2,491,164.41 Instalaciones 934,186.65 Terreno 1,500,000.00
11,603,262.08
Factor de Lang 3.1Costo de la planta 35,970,112.45
Costo fijo 35,970,112.45 Costos directos 25,179,078.72 Costos Indirectos 10,791,033.74 Ingeniería y supervisión 2,589,848.10
Capital fijo 44,962,640.56 Capital de trabajo 8,992,528.11
Costo concreto/m3 1608.04
CIT COSTO DE INVERSIÓN TOTALVE VIDA ECONÓMICA DE LA PLANTA (AÑOS)TASA DE REF TASA MÍNIMA ATRACTIVA DE RETORNOCAM COSTO ANUAL DE MANTENIMIENTOIACM INCREMENTO ANUAL EN EL COSTO DE MANTENIMIENTOCOA COSTO DE OPERACIÓN ANUAL (% DE LA INVERSIÓN)IACO INCREMENTO ANUAL EN EL COSTO DE OPERACIÓNIACMP INCREMENTO ANUAL EN EL COSTO DE LA MATERIA PIMAIAP INCREMENTO ANUAL ENLA PRODUCCIÓNCMP COSTO DE LA MATERIA PRIMACC/M3 COSTO POR M3 DE CONCRETO PRODUCIDOVS VALOR DE SALVAMENTO (% DE LA INVERSIÓN TOTAL)
PRODUCCIÓN (M3) EQUILIBRIODIARIO MENSUAL ANUAL 207.709923769043
1472 36800 441600
1 2 3 4 5
AÑO MANTENIMIENTO OPERACIÓN COSTO ANUAL
A=P(A/P,i,n) 0.03 de CIT 0.05 del COA 2+3+4
COSTO ANUAL DE INVERSIÓN
![Page 2: Estudio Financiero Concreto Premezclado](https://reader035.fdocuments.mx/reader035/viewer/2022071705/563dbaf7550346aa9aa91c87/html5/thumbnails/2.jpg)
1 -$7,258,625.15 -$1,348,879.22 -$2,248,132.03 -$10,855,636.402 -$7,258,625.15 -$1,389,345.59 -$2,360,538.63 -$11,008,509.383 -$7,258,625.15 -$1,431,025.96 -$2,478,565.56 -$11,168,216.684 -$7,258,625.15 -$1,473,956.74 -$2,602,493.84 -$11,335,075.735 -$7,258,625.15 -$1,518,175.44 -$2,732,618.53 -$11,509,419.136 -$7,258,625.15 -$1,563,720.71 -$2,869,249.46 -$11,691,595.327 -$7,258,625.15 -$1,610,632.33 -$3,012,711.93 -$11,881,969.418 -$7,258,625.15 -$1,658,951.30 -$3,163,347.53 -$12,080,923.989 -$7,258,625.15 -$1,708,719.84 -$3,321,514.90 -$12,288,859.89
10 -$7,258,625.15 -$1,759,981.43 -$3,487,590.65 -$12,506,197.2311 -$7,258,625.15 -$1,812,780.87 -$3,661,970.18 -$12,733,376.2112 -$7,258,625.15 -$1,867,164.30 -$3,845,068.69 -$12,970,858.14
1 2 3 4M3 441,600.00 450,432.00 459,440.64 468,629.45
$186,310.83 $186,310.83 $186,310.83 $186,310.83$ $ 710,110,464.00 $ 724,312,673.28 $ 738,798,926.75 $ 753,574,905.28
$710,296,774.83 $724,498,984.11 $738,985,237.57 $753,761,216.11
-$7,258,625.15 -$7,258,625.15 -$7,258,625.15 -$7,258,625.15
-$1,348,879.22 -$1,389,345.59 -$1,431,025.96 -$1,473,956.74OPERACIÓN -$2,248,132.03 -$2,360,538.63 -$2,478,565.56 -$2,602,493.84
ISR 32% -$ 227,235,348.48 -$ 231,780,055.45 -$ 236,415,656.56 -$ 241,143,969.69
-$ 408,669,888.00 -$ 416,843,285.76 -$ 425,180,151.48 -$ 433,683,754.50 -$646,760,872.88 -$659,631,850.59 -$672,764,024.71 -$686,162,799.93
FLUJO $63,535,901.95 $64,867,133.52 $66,221,212.86 $67,598,416.18
VALOR ANUAL DE SALVAMENTO
COSTO ANUAL DE INVERSIÓN
MANTENIMIENTO
COSTO ANUAL DE MATERIA
PRIMA
![Page 3: Estudio Financiero Concreto Premezclado](https://reader035.fdocuments.mx/reader035/viewer/2022071705/563dbaf7550346aa9aa91c87/html5/thumbnails/3.jpg)
44,962,640.56 12
12%3%3%5%5%2%2%
925.431608.04
10%
FACTIBLE TIR>TMAR
6 7 8 9 10
PRODUCCIÓN ANUAL
M3 $ ISR 32%
A=F(A/F,i,n) PA+IAP*0.02 7*CC/m3 32%*8 CMP*7
VALOR ANUAL DE SALVAMENTO
COSTO ANUAL DE MATERIA PRIMA
![Page 4: Estudio Financiero Concreto Premezclado](https://reader035.fdocuments.mx/reader035/viewer/2022071705/563dbaf7550346aa9aa91c87/html5/thumbnails/4.jpg)
$186,310.83 441600.00 $ 710,110,464.00 -$ 227,235,348.48 -$ 408,669,888.00 $186,310.83 450432.00 $ 724,312,673.28 -$ 231,780,055.45 -$ 416,843,285.76 $186,310.83 459440.64 $ 738,798,926.75 -$ 236,415,656.56 -$ 425,180,151.48 $186,310.83 468629.45 $ 753,574,905.28 -$ 241,143,969.69 -$ 433,683,754.50 $186,310.83 478002.04 $ 768,646,403.39 -$ 245,966,849.08 -$ 442,357,429.59 $186,310.83 487562.08 $ 784,019,331.45 -$ 250,886,186.07 -$ 451,204,578.19 $186,310.83 497313.32 $ 799,699,718.08 -$ 255,903,909.79 -$ 460,228,669.75 $186,310.83 507259.59 $ 815,693,712.44 -$ 261,021,987.98 -$ 469,433,243.15 $186,310.83 517404.78 $ 832,007,586.69 -$ 266,242,427.74 -$ 478,821,908.01 $186,310.83 527752.88 $ 848,647,738.43 -$ 271,567,276.30 -$ 488,398,346.17 $186,310.83 538307.94 $ 865,620,693.20 -$ 276,998,621.82 -$ 498,166,313.09 $186,310.83 549074.09 $ 882,933,107.06 -$ 282,538,594.26 -$ 508,129,639.35
TIR
5 6 7 8 9 478,002.04 487,562.08 497,313.32 507,259.59 517,404.78
$186,310.83 $186,310.83 $186,310.83 $186,310.83 $186,310.83 $ 768,646,403.39 $ 784,019,331.45 $ 799,699,718.08 $ 815,693,712.44 $ 832,007,586.69
$768,832,714.21 $784,205,642.28 $799,886,028.91 $815,880,023.27 $832,193,897.52
-$7,258,625.15 -$7,258,625.15 -$7,258,625.15 -$7,258,625.15 -$7,258,625.15
-$1,518,175.44 -$1,563,720.71 -$1,610,632.33 -$1,658,951.30 -$1,708,719.84-$2,732,618.53 -$2,869,249.46 -$3,012,711.93 -$3,163,347.53 -$3,321,514.90
-$ 245,966,849.08 -$ 250,886,186.07 -$ 255,903,909.79 -$ 261,021,987.98 -$ 266,242,427.74
-$ 442,357,429.59 -$ 451,204,578.19 -$ 460,228,669.75 -$ 469,433,243.15 -$ 478,821,908.01 -$699,833,697.81 -$713,782,359.57 -$728,014,548.95 -$742,536,155.10 -$757,353,195.64
$68,999,016.41 $70,423,282.71 $71,871,479.96 $73,343,868.17 $74,840,701.88
![Page 5: Estudio Financiero Concreto Premezclado](https://reader035.fdocuments.mx/reader035/viewer/2022071705/563dbaf7550346aa9aa91c87/html5/thumbnails/5.jpg)
11 12
FLUJO ANUAL FLUJO ACUMULADO
5+6+8+9+10 Σ
![Page 6: Estudio Financiero Concreto Premezclado](https://reader035.fdocuments.mx/reader035/viewer/2022071705/563dbaf7550346aa9aa91c87/html5/thumbnails/6.jpg)
$63,535,901.95 $63,535,901.95$64,867,133.52 $128,403,035.47$66,221,212.86 $194,624,248.34$67,598,416.18 $262,222,664.52$68,999,016.41 $331,221,680.93$70,423,282.71 $401,644,963.64$71,871,479.96 $473,516,443.61$73,343,868.17 $546,860,311.77$74,840,701.88 $621,701,013.65$76,362,229.56 $698,063,243.21$77,908,692.90 $775,971,936.11$79,480,326.13 $855,452,262.25
Err:523 VAN $429,871,429.03
10 11 12 527,752.88 538,307.94 549,074.09
$186,310.83 $186,310.83 $186,310.83 $ 848,647,738.43 $ 865,620,693.20 $ 882,933,107.06
$848,834,049.26 $865,807,004.02 $883,119,417.89
-$7,258,625.15 -$7,258,625.15 -$7,258,625.15
-$1,759,981.43 -$1,812,780.87 -$1,867,164.30-$3,487,590.65 -$3,661,970.18 -$3,845,068.69
-$ 271,567,276.30 -$ 276,998,621.82 -$ 282,538,594.26
-$ 488,398,346.17 -$ 498,166,313.09 -$ 508,129,639.35 -$772,471,819.70 -$787,898,311.12 -$803,639,091.76
$76,362,229.56 $77,908,692.90 $79,480,326.13
![Page 7: Estudio Financiero Concreto Premezclado](https://reader035.fdocuments.mx/reader035/viewer/2022071705/563dbaf7550346aa9aa91c87/html5/thumbnails/7.jpg)
Valor de planta 6,227,911.02 Silos 450,000.00 Equipo de transporte 2,491,164.41 Instalaciones 934,186.65 Terreno 1,500,000.00
11,603,262.08
Factor de Lang 3.1Costo de la planta 35,970,112.45
Costo fijo 35,970,112.45 Costos directos 25,179,078.72 Costos Indirectos 10,791,033.74 Ingeniería y supervisión 2,589,848.10
Capital fijo 44,962,640.56 Capital de trabajo 8,992,528.11
Costo concreto/m3 1608.04
CIT COSTO DE INVERSIÓN TOTALVE VIDA ECONÓMICA DE LA PLANTA (AÑOS)TASA DE REF TASA MÍNIMA ATRACTIVA DE RETORNOCAM COSTO ANUAL DE MANTENIMIENTOIACM INCREMENTO ANUAL EN EL COSTO DE MANTENIMIENTOCOA COSTO DE OPERACIÓN ANUAL (% DE LA INVERSIÓN)IACO INCREMENTO ANUAL EN EL COSTO DE OPERACIÓNIACMP INCREMENTO ANUAL EN EL COSTO DE LA MATERIA PRIMAIAP INCREMENTO ANUAL ENLA PRODUCCIÓNCMP COSTO DE LA MATERIA PRIMACC/M3 COSTO POR M3 DE CONCRETO PRODUCIDOVS VALOR DE SALVAMENTO (% DE LA INVERSIÓN TOTAL)
PRODUCCIÓN (M3) EQUILIBRIODIARIO MENSUAL ANUAL 234.306636023514
1472 36800 441600
1 2 3 4 5
AÑO MANTENIMIENTO OPERACIÓN COSTO ANUAL
A=P(A/P,i,n) 0.03 de CIT 0.05 del COA 2+3+4
COSTO ANUAL DE INVERSIÓN
![Page 8: Estudio Financiero Concreto Premezclado](https://reader035.fdocuments.mx/reader035/viewer/2022071705/563dbaf7550346aa9aa91c87/html5/thumbnails/8.jpg)
1 -$8,651,474.49 -$1,348,879.22 -$2,248,132.03 -$12,248,485.742 -$8,651,474.49 -$1,389,345.59 -$2,360,538.63 -$12,401,358.713 -$8,651,474.49 -$1,431,025.96 -$2,478,565.56 -$12,561,066.014 -$8,651,474.49 -$1,473,956.74 -$2,602,493.84 -$12,727,925.075 -$8,651,474.49 -$1,518,175.44 -$2,732,618.53 -$12,902,268.466 -$8,651,474.49 -$1,563,720.71 -$2,869,249.46 -$13,084,444.657 -$8,651,474.49 -$1,610,632.33 -$3,012,711.93 -$13,274,818.758 -$8,651,474.49 -$1,658,951.30 -$3,163,347.53 -$13,473,773.329 -$8,651,474.49 -$1,708,719.84 -$3,321,514.90 -$13,681,709.23
10 -$8,651,474.49 -$1,759,981.43 -$3,487,590.65 -$13,899,046.5711 -$8,651,474.49 -$1,812,780.87 -$3,661,970.18 -$14,126,225.5512 -$8,651,474.49 -$1,867,164.30 -$3,845,068.69 -$14,363,707.48
1 2 3 4M3 441,600.00 450,432.00 459,440.64 468,629.45
$145,745.20 $145,745.20 $145,745.20 $145,745.20$ $ 710,110,464.00 $ 724,312,673.28 $ 738,798,926.75 $ 753,574,905.28
$710,256,209.20 $724,458,418.48 $738,944,671.95 $753,720,650.48
-$8,651,474.49 -$8,651,474.49 -$8,651,474.49 -$8,651,474.49
-$1,348,879.22 -$1,389,345.59 -$1,431,025.96 -$1,473,956.74OPERACIÓN -$2,248,132.03 -$2,360,538.63 -$2,478,565.56 -$2,602,493.84
ISR 32% -$ 227,235,348.48 -$ 231,780,055.45 -$ 236,415,656.56 -$ 241,143,969.69
-$ 408,669,888.00 -$ 416,843,285.76 -$ 425,180,151.48 -$ 433,683,754.50 -$648,153,722.22 -$661,024,699.92 -$674,156,874.05 -$687,555,649.27
FLUJO $62,102,486.98 $63,433,718.56 $64,787,797.90 $66,165,001.22
VALOR ANUAL DE SALVAMENTO
COSTO ANUAL DE INVERSIÓN
MANTENIMIENTO
COSTO ANUAL DE MATERIA
PRIMA
![Page 9: Estudio Financiero Concreto Premezclado](https://reader035.fdocuments.mx/reader035/viewer/2022071705/563dbaf7550346aa9aa91c87/html5/thumbnails/9.jpg)
44,962,640.56 12
16%3%3%5%5%2%2%
925.431608.04
10%
FACTIBLE TIR>TMAR
6 7 8 9 10
PRODUCCIÓN ANUAL
M3 $ ISR 32%
A=F(A/F,i,n) PA+IAP*0.02 7*CC/m3 32%*8 CMP*7
VALOR ANUAL DE SALVAMENTO
COSTO ANUAL DE MATERIA PRIMA
![Page 10: Estudio Financiero Concreto Premezclado](https://reader035.fdocuments.mx/reader035/viewer/2022071705/563dbaf7550346aa9aa91c87/html5/thumbnails/10.jpg)
$145,745.20 441600.00 $ 710,110,464.00 -$ 227,235,348.48 -$ 408,669,888.00 $145,745.20 450432.00 $ 724,312,673.28 -$ 231,780,055.45 -$ 416,843,285.76 $145,745.20 459440.64 $ 738,798,926.75 -$ 236,415,656.56 -$ 425,180,151.48 $145,745.20 468629.45 $ 753,574,905.28 -$ 241,143,969.69 -$ 433,683,754.50 $145,745.20 478002.04 $ 768,646,403.39 -$ 245,966,849.08 -$ 442,357,429.59 $145,745.20 487562.08 $ 784,019,331.45 -$ 250,886,186.07 -$ 451,204,578.19 $145,745.20 497313.32 $ 799,699,718.08 -$ 255,903,909.79 -$ 460,228,669.75 $145,745.20 507259.59 $ 815,693,712.44 -$ 261,021,987.98 -$ 469,433,243.15 $145,745.20 517404.78 $ 832,007,586.69 -$ 266,242,427.74 -$ 478,821,908.01 $145,745.20 527752.88 $ 848,647,738.43 -$ 271,567,276.30 -$ 488,398,346.17 $145,745.20 538307.94 $ 865,620,693.20 -$ 276,998,621.82 -$ 498,166,313.09 $145,745.20 549074.09 $ 882,933,107.06 -$ 282,538,594.26 -$ 508,129,639.35
TIR
5 6 7 8 9 478,002.04 487,562.08 497,313.32 507,259.59 517,404.78
$145,745.20 $145,745.20 $145,745.20 $145,745.20 $145,745.20 $ 768,646,403.39 $ 784,019,331.45 $ 799,699,718.08 $ 815,693,712.44 $ 832,007,586.69
$768,792,148.59 $784,165,076.65 $799,845,463.28 $815,839,457.64 $832,153,331.89
-$8,651,474.49 -$8,651,474.49 -$8,651,474.49 -$8,651,474.49 -$8,651,474.49
-$1,518,175.44 -$1,563,720.71 -$1,610,632.33 -$1,658,951.30 -$1,708,719.84-$2,732,618.53 -$2,869,249.46 -$3,012,711.93 -$3,163,347.53 -$3,321,514.90
-$ 245,966,849.08 -$ 250,886,186.07 -$ 255,903,909.79 -$ 261,021,987.98 -$ 266,242,427.74
-$ 442,357,429.59 -$ 451,204,578.19 -$ 460,228,669.75 -$ 469,433,243.15 -$ 478,821,908.01 -$701,226,547.14 -$715,175,208.91 -$729,407,398.29 -$743,929,004.44 -$758,746,044.98
$67,565,601.44 $68,989,867.75 $70,438,065.00 $71,910,453.20 $73,407,286.91
![Page 11: Estudio Financiero Concreto Premezclado](https://reader035.fdocuments.mx/reader035/viewer/2022071705/563dbaf7550346aa9aa91c87/html5/thumbnails/11.jpg)
11 12
FLUJO ANUAL FLUJO ACUMULADO
5+6+8+9+10 Σ
![Page 12: Estudio Financiero Concreto Premezclado](https://reader035.fdocuments.mx/reader035/viewer/2022071705/563dbaf7550346aa9aa91c87/html5/thumbnails/12.jpg)
$62,102,486.98 $62,102,486.98$63,433,718.56 $125,536,205.54$64,787,797.90 $190,324,003.44$66,165,001.22 $256,489,004.65$67,565,601.44 $324,054,606.10$68,989,867.75 $393,044,473.84$70,438,065.00 $463,482,538.84$71,910,453.20 $535,392,992.04$73,407,286.91 $608,800,278.96$74,928,814.59 $683,729,093.55$76,475,277.94 $760,204,371.48$78,046,911.17 $838,251,282.65
Err:523 VAN $350,450,524.34
10 11 12 527,752.88 538,307.94 549,074.09
$145,745.20 $145,745.20 $145,745.20 $ 848,647,738.43 $ 865,620,693.20 $ 882,933,107.06
$848,793,483.63 $865,766,438.40 $883,078,852.26
-$8,651,474.49 -$8,651,474.49 -$8,651,474.49
-$1,759,981.43 -$1,812,780.87 -$1,867,164.30-$3,487,590.65 -$3,661,970.18 -$3,845,068.69
-$ 271,567,276.30 -$ 276,998,621.82 -$ 282,538,594.26
-$ 488,398,346.17 -$ 498,166,313.09 -$ 508,129,639.35 -$773,864,669.04 -$789,291,160.46 -$805,031,941.09
$74,928,814.59 $76,475,277.94 $78,046,911.17
![Page 13: Estudio Financiero Concreto Premezclado](https://reader035.fdocuments.mx/reader035/viewer/2022071705/563dbaf7550346aa9aa91c87/html5/thumbnails/13.jpg)
Costo de planta VAN TIR Prod. Diaria $ 6,227,911.02 $350,450,524.34 Err:523 1472 $ 5,000,000.00 #NUM! 100 $ 10,000,000.00 #NUM! 120 $ 15,000,000.00 #NUM! 140 $ 20,000,000.00 #NUM! 160 $ 25,000,000.00 #NUM! 180 $ 30,000,000.00 #NUM! 200 $ 35,000,000.00 #NUM! 220 $ 40,000,000.00 #NUM! 240 $ 45,000,000.00 260 $ 50,000,000.00 #NUM! 280 $ 55,000,000.00 #NUM! 300 $ 60,000,000.00 #NUM! 320
340360
![Page 14: Estudio Financiero Concreto Premezclado](https://reader035.fdocuments.mx/reader035/viewer/2022071705/563dbaf7550346aa9aa91c87/html5/thumbnails/14.jpg)
VAN TIR Costo materia p. 925.43$350,450,524.34 Err:523 Precio de venta 1608.04
#NUM!#NUM! Costo materia p.#NUM! $350,450,524.34 500 600#NUM!
Prec
io d
e ve
nta
1000#NUM! 1100#NUM! 1200#NUM! 1300
1400#NUM! 1500#NUM! 1600#NUM! 1700#NUM! 1800#NUM! 1900#NUM!
![Page 15: Estudio Financiero Concreto Premezclado](https://reader035.fdocuments.mx/reader035/viewer/2022071705/563dbaf7550346aa9aa91c87/html5/thumbnails/15.jpg)
Costo materia p.700 800 900 1000 1100
![Page 16: Estudio Financiero Concreto Premezclado](https://reader035.fdocuments.mx/reader035/viewer/2022071705/563dbaf7550346aa9aa91c87/html5/thumbnails/16.jpg)
Costo materia p.1200