Financial Model Xyz
This document was uploaded by user and they confirmed that they have the permission to share it. If you are author or own the copyright of this book, please report to us by using this DMCA report form. Report DMCA
Overview
Download & View Financial Model Xyz as PDF for free.
More details
- Words: 1,210
- Pages: 12
Plan Operativo Reservas (kt) Capacidad de trat. (t/d)
140,000 365
Disponibilidad de la planta
96%
Días de trabajo año
350
Vida de la mina (años)
%Pb
% Zn
0.67
1.72
2.820
25,000
Días de trabajo al año
Tratamiento anual (kt/a)
%Cu
8,760 16
BALANCE METALÚRGICO
OBJETIVO Producto Alimentación Concentrado de Cu Concentrado de Pb Concentrado de Zn Relave 100% Concentrado Bulk
GRADOS TMS 8,760,000 115,020 180,500 265,400 8,199,080 8,760,000 560,920 8,199,080
Valorización del concentrado ($/t) Valor del Concentrado de Cu Valor del Concentrado de Pb Valor del Concentrado de Zn
VPN TIR
10.00% 972,425 37.60%
%Cu 0.670 32.15 2.36 2.31 0.14 36.96
% Pb 1.72 2.35 58.16 3.95 0.40 64.86
% Zn 2.82 3.120 4.560 61.02 0.894 69.59
Oz-Ag
1.20
2.45
0.95
1.10
12.10
CONTENIDOS FINOS Oz- Ag. 1.20 35.00 27.20 2.10 0.12 64.42
tmf-Cu 58,692 36,979 4,260 6,131 11,323 58,692
$/tm 2,160 1,547 1,479
tmf -Pb 150,672 2,703 104,979 10,483 32,507 150,672
tmf -Zn 247,032 3,589 8,231 161,947 73,265 247,032
DISTRIBUCIÓN Oz-Ag 10,512,000 4,025,700 4,909,600 557,340 1,019,360 10,512,000
%Cu
% Pb
100% 63% 7% 10% 19% 100%
100% 2% 70% 7% 22% 100%
Cu 5,400 DISTRIBUCIÓN
Pb 2,094
Zn 2,425
Ag 12.10
VALORIZACIÓN
% Zn
Oz- Ag.
100% 1% 3% 66% 30% 100%
100% 38% 47% 5% 10% 100%
USD -Cu
USD -Pb
USD -Zn
199,693,322
USD -Ag 48,710,970 59,406,160
219,820,568 392,653,003
VM
USD
248,404,292 279,226,728 392,653,003 920,284,024 105.06 35 306,600,000
MODELO FINANCIERO PROYECTO MINERO XYZ
PERIODOS (AÑOS) PROGRAMA DE INVERSIONES (000)
Mina Planta Infraestructura Deposito de relaves Otros TOTAL Alimentación - Planta de Sulfuros Ley de Cu Ley de Pb Ley de Zn Ley de Ag Contenido Metálico Cu Pb Zn Ag Produccion de concentrados Concentrado de Cu Concentrado de Pb oncentrado de Zn Total Producción de concentrados (000) Valor del concentrado de Cu (000) Valor del concentrado de Pb (000) Valor del concentrado de Zn (000) INGRESO POR VENTAS Costos Directos Exploraciones Minería Beneficio Energía Servicios Generales Total Cash Cost Costos Indirectos Administración y ventas Transporte de concentrados al puerto (Km) Desde la mina hasta el puerto Royalties Total Costo Indirectos UTILIDAD OPERATIVA (EBITDA) Depreciación Pérdidas de traslado UAI ( Earning before tax) Participación de los trabajadores Impuesto a la renta Utilidad Neta (Net Profit)
8,760,000 0.67 1.72 2.82 1.20
115,020 180,500 265,400 560,920 2,160 1,547 1,479
4.05 23.94 7.12 2.36 6.51 43.98 4.27 350 0.27 1.85%
0.12 8% 30%
94.50
Depreciación y amortización Costos de cierre de mina Sostaining Capital Cost (Capex) Cash Flow % 19.66% 20.31% 42.81% 17.21% 100.00%
3.10%
CAPEX Equipos de Mina Planta Infraestructura Licencia social TOTAL
Sostaining Capital
Evaluación económica TEA VAN TIR Pay Back
Dep (años) 3 7 10
12%
12.10% 972,425 37.60% 5.0 219,065
Investment 81,378 84,059 177,200 71,250 413,887
años
-2
-1
0
USD USD
42,800 42,620 21,670 25,600 14,860 147,550
52,600 58,720 45,630 27,800 28,560 213,310
52,560 43,590 33,870 22,630 27,830 180,480 605,018
2
3
8,760,000 0.67 1.72 2.82 1.20
8,760,000 0.67 1.72 2.82 1.20
8,760,000 0.67 1.72 2.82 1.20
tmf/a tmf/a tmf/a Oz/a
58,692 150,672 247,032 10,512,000
58,692 150,672 247,032 10,512,000
58,692 150,672 247,032 10,512,000
tm/a tm/a tm/a tm/a USD
115,020 180,500 265,400 295,520 248,404 279,227 392,653 920,284
115,020 180,500 265,400 295,520 248,404 279,227 392,653 920,284
115,020 180,500 265,400 295,520 248,404 279,227 392,653 920,284
35,478 209,714 62,371 20,674 57,028 385,265
35,478 209,714 62,371 20,674 57,028 385,265
35,478 209,714 62,371 20,674 57,028 385,265
37,405
37,405
37,405
27,927 17,025 82,357 452,662 56,854 0 395,808 31,665 118,742 245,401
27,927 17,025 82,357 452,662 56,854 0 395,808 31,665 118,742 245,401
27,927 17,025 82,357 452,662 56,854 0 395,808 31,665 118,742 245,401
USD USD 429,488 tm/a % % % Oz/t
USD
USD USD USD USD USD USD
1 147,960 144,930 101,170 76,030 71,250 541,340
467,622 USD USD USD USD USD USD USD USD USD
18%
USD USD USD USD Err:509 USD USD USD USD USD USD
-605,018
56,854 28,529 41,116 232,610
56,854 28,529 41,116 232,610
56,854 28,529 41,116 232,610
Depretiation 27,126 12,008 17,720
27,126 12,008 17,720
27,126 12,008 17,720
56,854 41,116
56,854 41,116
56,854 41,116
4
5
6
7
8
9
10
8,760,000 0.67 1.72 2.82 1.20
8,760,000 0.67 1.72 2.82 1.20
8,760,000 0.67 1.72 2.82 1.20
8,760,000 0.67 1.72 2.82 1.20
8,760,000 0.67 1.72 2.82 1.20
8,760,000 0.67 1.72 2.82 1.20
8,760,000 0.67 1.72 2.82 1.20
58,692 150,672 247,032 10,512,000
58,692 150,672 247,032 10,512,000
58,692 150,672 247,032 10,512,000
58,692 150,672 247,032 10,512,000
58,692 150,672 247,032 10,512,000
58,692 150,672 247,032 10,512,000
58,692 150,672 247,032 10,512,000
115,020 180,500 265,400 295,520 248,404 279,227 392,653 920,284
115,020 180,500 265,400 295,520 248,404 279,227 392,653 920,284
115,020 180,500 265,400 295,520 248,404 279,227 392,653 920,284
115,020 180,500 265,400 295,520 248,404 279,227 392,653 920,284
115,020 180,500 265,400 295,520 248,404 279,227 392,653 920,284
115,020 180,500 265,400 295,520 248,404 279,227 392,653 920,284
115,020 180,500 265,400 295,520 248,404 279,227 392,653 920,284
35,478 209,714 62,371 20,674 57,028 385,265
35,478 209,714 62,371 20,674 57,028 385,265
35,478 209,714 62,371 20,674 57,028 385,265
35,478 209,714 62,371 20,674 57,028 385,265
35,478 209,714 62,371 20,674 57,028 385,265
35,478 209,714 62,371 20,674 57,028 385,265
35,478 209,714 62,371 20,674 57,028 385,265
37,405
37,405
37,405
37,405
37,405
37,405
37,405
27,927 17,025 82,357 452,662 29,728 0 422,934 33,835 126,880 262,219
27,927 17,025 82,357 452,662 29,728 0 422,934 33,835 126,880 262,219
27,927 17,025 82,357 452,662 29,728 0 422,934 33,835 126,880 262,219
27,927 17,025 82,357 452,662 29,728 0 422,934 33,835 126,880 262,219
27,927 17,025 82,357 452,662 29,728 0 422,934 33,835 126,880 262,219
27,927 17,025 82,357 452,662 29,728 0 422,934 33,835 126,880 262,219
27,927 17,025 82,357 452,662 29,728 0 422,934 33,835 126,880 262,219
29,728 28,529 41,116 222,302
29,728 28,529 41,116 222,302
29,728 28,529 41,116 222,302
29,728 28,529 41,116 222,302
29,728 28,529 41,116 222,302
29,728 28,529 41,116 222,302
29,728 28,529 41,116 222,302
12,008 17,720
12,008 17,720
12,008 17,720
12,008 17,720
12,008 17,720
12,008 17,720
12,008 17,720
29,728 41,116
29,728 41,116
29,728 41,116
29,728 41,116
29,728 41,116
29,728 41,116
29,728 41,116
11
12
13
14
15
16
8,760,000 0.67 1.72 2.82 1.20
8,760,000 0.67 1.72 2.82 1.20
8,760,000 0.67 1.72 2.82 1.20
8,760,000 0.67 1.72 2.82 1.20
8,760,000 0.67 1.72 2.82 1.20
8,760,000 0.67 1.72 2.82 1.20
58,692 150,672 247,032 10,512,000
58,692 150,672 247,032 10,512,000
58,692 150,672 247,032 10,512,000
58,692 150,672 247,032 10,512,000
58,692 150,672 247,032 10,512,000
58,692 150,672 247,032 10,512,000
115,020 180,500 265,400 295,520 248,404 279,227 392,653 920,284
115,020 180,500 265,400 295,520 248,404 279,227 392,653 920,284
115,020 180,500 265,400 295,520 248,404 279,227 392,653 920,284
115,020 180,500 265,400 295,520 248,404 279,227 392,653 920,284
115,020 180,500 265,400 295,520 248,404 279,227 392,653 920,284
115,020 180,500 265,400 295,520 248,404 279,227 392,653 920,284
35,478 209,714 62,371 20,674 57,028 385,265
35,478 209,714 62,371 20,674 57,028 385,265
209,714 62,371 20,674 57,028 349,787
209,714 62,371 20,674 57,028 349,787
209,714 62,371 20,674 57,028 349,787
209,714 62,371 20,674 57,028 349,787
37,405
37,405
37,405
37,405
37,405
37,405
27,927 17,025 82,357 452,662 17,720 0 434,942 34,795 130,483 269,664
27,927 17,025 82,357 452,662 17,720 0 434,942 34,795 130,483 269,664
27,927 17,025 82,357 488,140 17,720 0 470,420 37,634 141,126 291,660
27,927 17,025 82,357 488,140 17,720 0 470,420 37,634 141,126 291,660
27,927 17,025 82,357 488,140 17,720 0 470,420 37,634 141,126 291,660
27,927 17,025 82,357 488,140 17,720 0 470,420 37,634 141,126 291,660
17,720 28,529 41,116 217,739
17,720 28,529 41,116 217,739
17,720 28,529 41,116 239,735
17,720 28,529 41,116 239,735
17,720 28,529 41,116 239,735
17,720 28,529 41,116 239,735
17,720
17,720
17,720
17,720
17,720
17,720
17,720 41,116
17,720 41,116
17,720 41,116
17,720 41,116
17,720 41,116
17,720 41,116
140,000 365
Disponibilidad de la planta
96%
Días de trabajo año
350
Vida de la mina (años)
%Pb
% Zn
0.67
1.72
2.820
25,000
Días de trabajo al año
Tratamiento anual (kt/a)
%Cu
8,760 16
BALANCE METALÚRGICO
OBJETIVO Producto Alimentación Concentrado de Cu Concentrado de Pb Concentrado de Zn Relave 100% Concentrado Bulk
GRADOS TMS 8,760,000 115,020 180,500 265,400 8,199,080 8,760,000 560,920 8,199,080
Valorización del concentrado ($/t) Valor del Concentrado de Cu Valor del Concentrado de Pb Valor del Concentrado de Zn
VPN TIR
10.00% 972,425 37.60%
%Cu 0.670 32.15 2.36 2.31 0.14 36.96
% Pb 1.72 2.35 58.16 3.95 0.40 64.86
% Zn 2.82 3.120 4.560 61.02 0.894 69.59
Oz-Ag
1.20
2.45
0.95
1.10
12.10
CONTENIDOS FINOS Oz- Ag. 1.20 35.00 27.20 2.10 0.12 64.42
tmf-Cu 58,692 36,979 4,260 6,131 11,323 58,692
$/tm 2,160 1,547 1,479
tmf -Pb 150,672 2,703 104,979 10,483 32,507 150,672
tmf -Zn 247,032 3,589 8,231 161,947 73,265 247,032
DISTRIBUCIÓN Oz-Ag 10,512,000 4,025,700 4,909,600 557,340 1,019,360 10,512,000
%Cu
% Pb
100% 63% 7% 10% 19% 100%
100% 2% 70% 7% 22% 100%
Cu 5,400 DISTRIBUCIÓN
Pb 2,094
Zn 2,425
Ag 12.10
VALORIZACIÓN
% Zn
Oz- Ag.
100% 1% 3% 66% 30% 100%
100% 38% 47% 5% 10% 100%
USD -Cu
USD -Pb
USD -Zn
199,693,322
USD -Ag 48,710,970 59,406,160
219,820,568 392,653,003
VM
USD
248,404,292 279,226,728 392,653,003 920,284,024 105.06 35 306,600,000
MODELO FINANCIERO PROYECTO MINERO XYZ
PERIODOS (AÑOS) PROGRAMA DE INVERSIONES (000)
Mina Planta Infraestructura Deposito de relaves Otros TOTAL Alimentación - Planta de Sulfuros Ley de Cu Ley de Pb Ley de Zn Ley de Ag Contenido Metálico Cu Pb Zn Ag Produccion de concentrados Concentrado de Cu Concentrado de Pb oncentrado de Zn Total Producción de concentrados (000) Valor del concentrado de Cu (000) Valor del concentrado de Pb (000) Valor del concentrado de Zn (000) INGRESO POR VENTAS Costos Directos Exploraciones Minería Beneficio Energía Servicios Generales Total Cash Cost Costos Indirectos Administración y ventas Transporte de concentrados al puerto (Km) Desde la mina hasta el puerto Royalties Total Costo Indirectos UTILIDAD OPERATIVA (EBITDA) Depreciación Pérdidas de traslado UAI ( Earning before tax) Participación de los trabajadores Impuesto a la renta Utilidad Neta (Net Profit)
8,760,000 0.67 1.72 2.82 1.20
115,020 180,500 265,400 560,920 2,160 1,547 1,479
4.05 23.94 7.12 2.36 6.51 43.98 4.27 350 0.27 1.85%
0.12 8% 30%
94.50
Depreciación y amortización Costos de cierre de mina Sostaining Capital Cost (Capex) Cash Flow % 19.66% 20.31% 42.81% 17.21% 100.00%
3.10%
CAPEX Equipos de Mina Planta Infraestructura Licencia social TOTAL
Sostaining Capital
Evaluación económica TEA VAN TIR Pay Back
Dep (años) 3 7 10
12%
12.10% 972,425 37.60% 5.0 219,065
Investment 81,378 84,059 177,200 71,250 413,887
años
-2
-1
0
USD USD
42,800 42,620 21,670 25,600 14,860 147,550
52,600 58,720 45,630 27,800 28,560 213,310
52,560 43,590 33,870 22,630 27,830 180,480 605,018
2
3
8,760,000 0.67 1.72 2.82 1.20
8,760,000 0.67 1.72 2.82 1.20
8,760,000 0.67 1.72 2.82 1.20
tmf/a tmf/a tmf/a Oz/a
58,692 150,672 247,032 10,512,000
58,692 150,672 247,032 10,512,000
58,692 150,672 247,032 10,512,000
tm/a tm/a tm/a tm/a USD
115,020 180,500 265,400 295,520 248,404 279,227 392,653 920,284
115,020 180,500 265,400 295,520 248,404 279,227 392,653 920,284
115,020 180,500 265,400 295,520 248,404 279,227 392,653 920,284
35,478 209,714 62,371 20,674 57,028 385,265
35,478 209,714 62,371 20,674 57,028 385,265
35,478 209,714 62,371 20,674 57,028 385,265
37,405
37,405
37,405
27,927 17,025 82,357 452,662 56,854 0 395,808 31,665 118,742 245,401
27,927 17,025 82,357 452,662 56,854 0 395,808 31,665 118,742 245,401
27,927 17,025 82,357 452,662 56,854 0 395,808 31,665 118,742 245,401
USD USD 429,488 tm/a % % % Oz/t
USD
USD USD USD USD USD USD
1 147,960 144,930 101,170 76,030 71,250 541,340
467,622 USD USD USD USD USD USD USD USD USD
18%
USD USD USD USD Err:509 USD USD USD USD USD USD
-605,018
56,854 28,529 41,116 232,610
56,854 28,529 41,116 232,610
56,854 28,529 41,116 232,610
Depretiation 27,126 12,008 17,720
27,126 12,008 17,720
27,126 12,008 17,720
56,854 41,116
56,854 41,116
56,854 41,116
4
5
6
7
8
9
10
8,760,000 0.67 1.72 2.82 1.20
8,760,000 0.67 1.72 2.82 1.20
8,760,000 0.67 1.72 2.82 1.20
8,760,000 0.67 1.72 2.82 1.20
8,760,000 0.67 1.72 2.82 1.20
8,760,000 0.67 1.72 2.82 1.20
8,760,000 0.67 1.72 2.82 1.20
58,692 150,672 247,032 10,512,000
58,692 150,672 247,032 10,512,000
58,692 150,672 247,032 10,512,000
58,692 150,672 247,032 10,512,000
58,692 150,672 247,032 10,512,000
58,692 150,672 247,032 10,512,000
58,692 150,672 247,032 10,512,000
115,020 180,500 265,400 295,520 248,404 279,227 392,653 920,284
115,020 180,500 265,400 295,520 248,404 279,227 392,653 920,284
115,020 180,500 265,400 295,520 248,404 279,227 392,653 920,284
115,020 180,500 265,400 295,520 248,404 279,227 392,653 920,284
115,020 180,500 265,400 295,520 248,404 279,227 392,653 920,284
115,020 180,500 265,400 295,520 248,404 279,227 392,653 920,284
115,020 180,500 265,400 295,520 248,404 279,227 392,653 920,284
35,478 209,714 62,371 20,674 57,028 385,265
35,478 209,714 62,371 20,674 57,028 385,265
35,478 209,714 62,371 20,674 57,028 385,265
35,478 209,714 62,371 20,674 57,028 385,265
35,478 209,714 62,371 20,674 57,028 385,265
35,478 209,714 62,371 20,674 57,028 385,265
35,478 209,714 62,371 20,674 57,028 385,265
37,405
37,405
37,405
37,405
37,405
37,405
37,405
27,927 17,025 82,357 452,662 29,728 0 422,934 33,835 126,880 262,219
27,927 17,025 82,357 452,662 29,728 0 422,934 33,835 126,880 262,219
27,927 17,025 82,357 452,662 29,728 0 422,934 33,835 126,880 262,219
27,927 17,025 82,357 452,662 29,728 0 422,934 33,835 126,880 262,219
27,927 17,025 82,357 452,662 29,728 0 422,934 33,835 126,880 262,219
27,927 17,025 82,357 452,662 29,728 0 422,934 33,835 126,880 262,219
27,927 17,025 82,357 452,662 29,728 0 422,934 33,835 126,880 262,219
29,728 28,529 41,116 222,302
29,728 28,529 41,116 222,302
29,728 28,529 41,116 222,302
29,728 28,529 41,116 222,302
29,728 28,529 41,116 222,302
29,728 28,529 41,116 222,302
29,728 28,529 41,116 222,302
12,008 17,720
12,008 17,720
12,008 17,720
12,008 17,720
12,008 17,720
12,008 17,720
12,008 17,720
29,728 41,116
29,728 41,116
29,728 41,116
29,728 41,116
29,728 41,116
29,728 41,116
29,728 41,116
11
12
13
14
15
16
8,760,000 0.67 1.72 2.82 1.20
8,760,000 0.67 1.72 2.82 1.20
8,760,000 0.67 1.72 2.82 1.20
8,760,000 0.67 1.72 2.82 1.20
8,760,000 0.67 1.72 2.82 1.20
8,760,000 0.67 1.72 2.82 1.20
58,692 150,672 247,032 10,512,000
58,692 150,672 247,032 10,512,000
58,692 150,672 247,032 10,512,000
58,692 150,672 247,032 10,512,000
58,692 150,672 247,032 10,512,000
58,692 150,672 247,032 10,512,000
115,020 180,500 265,400 295,520 248,404 279,227 392,653 920,284
115,020 180,500 265,400 295,520 248,404 279,227 392,653 920,284
115,020 180,500 265,400 295,520 248,404 279,227 392,653 920,284
115,020 180,500 265,400 295,520 248,404 279,227 392,653 920,284
115,020 180,500 265,400 295,520 248,404 279,227 392,653 920,284
115,020 180,500 265,400 295,520 248,404 279,227 392,653 920,284
35,478 209,714 62,371 20,674 57,028 385,265
35,478 209,714 62,371 20,674 57,028 385,265
209,714 62,371 20,674 57,028 349,787
209,714 62,371 20,674 57,028 349,787
209,714 62,371 20,674 57,028 349,787
209,714 62,371 20,674 57,028 349,787
37,405
37,405
37,405
37,405
37,405
37,405
27,927 17,025 82,357 452,662 17,720 0 434,942 34,795 130,483 269,664
27,927 17,025 82,357 452,662 17,720 0 434,942 34,795 130,483 269,664
27,927 17,025 82,357 488,140 17,720 0 470,420 37,634 141,126 291,660
27,927 17,025 82,357 488,140 17,720 0 470,420 37,634 141,126 291,660
27,927 17,025 82,357 488,140 17,720 0 470,420 37,634 141,126 291,660
27,927 17,025 82,357 488,140 17,720 0 470,420 37,634 141,126 291,660
17,720 28,529 41,116 217,739
17,720 28,529 41,116 217,739
17,720 28,529 41,116 239,735
17,720 28,529 41,116 239,735
17,720 28,529 41,116 239,735
17,720 28,529 41,116 239,735
17,720
17,720
17,720
17,720
17,720
17,720
17,720 41,116
17,720 41,116
17,720 41,116
17,720 41,116
17,720 41,116
17,720 41,116
Related Documents
Financial Model Xyz
October 2019 20
Xyz
June 2020 7
Financial Model
November 2019 12
Xyz
June 2020 6
Financial Model
November 2019 13
Case Study On Xyz Forgings Financial Proj.
November 2019 10More Documents from ""
Trabajo2 - Ventsim.docx
October 2019 13
Venti-3er Trabajo.docx
October 2019 10
Financial Model Xyz
October 2019 20
6to Informe Mma.docx
October 2019 13
1er Informe Mma.docx
October 2019 21