Cash Flow ZED Minerals

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

EXECUTIVE SUMMARY, COPPER MINING AND EXPORT

ZED MINERALS PVT LTD


Basic Assumptions
Year One Year Two
USD Dollar to PKR Price 300 USD Dollar to PKR Price 350
LME Price Copper /MTON 8,200 LME Price Copper 8500

Financial data
Year Revenue Expenses Profit
One $11,930,297.14 $10,052,416.42 $1,877,880.72
Two $46,815,166.67 $33,955,907.74 $12,859,258.93
Three $81,529,074.00 $54,782,573.65 $ 26,746,500.35
Four $123,553,705.00 $79,856,339.43 $ 43,697,365.58
Five $166,768,976.00 $97,011,847.33 $ 69,757,128.67

For Three Years


Revenue $140,274,537.81
Expenses $98,790,897.81
Profit $41,483,640.00
ROI Percetage, 3 Years 29.57317888918

For Five Years


Revenue 430,597,219
Expenses $275,659,084.57
Profit $154,938,134.24
ROI Percetage, 5 Years 35.98
MMARY, COPPER MINING AND EXPORT
ZED MINERALS PVT LTD Reve
$180,000,000.00
Year Three Year Four Year Five
$160,000,000.00
USD Dollar to PKR Price 400 USD Dollar t 500 USD Dollar t 600
$140,000,000.00
LME Price Copper 8300 LME Price C 8500 LME Price C 8800
$120,000,000.00
$100,000,000.00
ROI Percentage $80,000,000.00
15.7404354755223 $60,000,000.00
27.4681472782784
$40,000,000.00
32.8060887211843
$20,000,000.00
35.3671025688789
41.8286004626344 $0.00
1

45
ROI
40
32.80608
35
27.4681472782784
30
25
15.7404354755223
20
15
10
5
0
One Two Thr
Revenue Vs Profit
$180,000,000.00
$160,000,000.00
$140,000,000.00
$120,000,000.00
$100,000,000.00
$80,000,000.00
$60,000,000.00
$40,000,000.00
$20,000,000.00
$0.00
1 2 3 4 5

Revenue Profit

41.8286004626344
45
ROI Percentage
40 35.3671025688789
32.8060887211843
35
27.4681472782784
30
25
15.7404354755223
20
15
10
5
0
One Two Three Four Five
ZED MINERALS
COPPER EXPORT YEAR ONE
ASSUMPTIONS/NOTES: 1
10 percent average
Formula LME * percentage * 45 percent factoring 10% Copper Ore 10% Copper Ore10% Copper Ore 10% Copper Ore10% Copper Ore10% Copper Ore 10% Copper Ore 10% Copper Ore 10% Copper Ore 10% Copper Ore 10% Copper Ore 10% Copper Ore

LME Price Copper 8,200 Reveue per Ton 369 369 369 369 369 369 369 369 369 369 369 369

Cost per Ton 322.26 294.26 290.26 290.26 275.51 275.51 273.93 273.93 274.64 274.64 275.19 263.42
Profit per Ton 46.74 74.74 78.74 78.74 93.49 93.49 95.07 95.07 94.36 94.36 93.81 105.58

PROJECTIONS FOR YEAR O N E (1) OF OPERATIONS


VALUE of
YEAR -1 YEAR -1 YEAR -1 YEAR -1 YEAR -1 YEAR -1 YEAR -1 YEAR -1 Month- YEAR -1 YEAR -1 YEAR -1
YEAR -1 Month-9 TOTAL YEAR -1 ENDING
Month-1 Month-2 Month-3 Month-4 Month-5 Month-6 Month-7 8 Month-10 Month-11 Month-12
INVENTORY

PRODUCTION IN M. TONS. 300 500 1,000 1,000 2,000 2,000 3,000 3,000 4,000 4,000 6,000 10,000 36,800
Nett. (of wastage) PRODUCTION IN M. TONS. 300 500 1,000 1,000 2,000 2,000 3,000 3,000 4,000 4,000 6,000 10,000 36,800

SALES Revenue 110,700 184,500 369,000 369,000 738,000 738,000 1,107,000 1,107,000 1,476,000 1,476,000 2,214,000 3,690,000 13,579,200
Revenue from Mine Wastage 7,907 13,179 26,357 26,357 52,714 52,714 79,071 79,071 105,429 105,429 158,143 263,571 969,943
Sales Tax -21,349 -35,582 -71,164 -71,164 -142,329 -142,329 -213,493 -213,493 -284,657 -284,657 -426,986 -711,643 -2,561,914
Net Revenue 97,258 162,096 324,193 324,193 648,386 648,386 972,579 972,579 1,296,771 1,296,771 1,945,157 3,241,929 11,930,297

EXPENSES -

Salaries & Wages 10,000 10,000 15,000 15,000 18,000 18,000 20,000 20,000 30,000 30,000 50,000 50,000 286,000
Fuel & Maintainance 35,000 58,333 116,667 116,667 233,333 233,333 350,000 350,000 466,667 466,667 700,000 1,166,667 4,293,333
Travel Expenses 3,000 3,000 3,000 3,000 5,000 5,000 8,000 8,000 9,000 9,000 10,000 10,000 76,000
Equipment Rentals 5,000 5,000 10,000 10,000 20,000 20,000 30,000 30,000 50,000 50,000 80,000 80,000 390,000
Transportation of Ore 10,000 16,667 33,333 33,333 66,667 66,667 100,000 100,000 133,333 133,333 200,000 333,333 1,226,667
Extraction Costs 20,000 33,333 66,667 66,667 133,333 133,333 200,000 200,000 266,667 266,667 400,000 666,667 2,453,333
Grinding 2,000 3,333 6,667 6,667 13,333 13,333 20,000 20,000 26,667 26,667 40,000 66,667 245,333
Pakcking 2,500 4,167 8,333 8,333 16,667 16,667 25,000 25,000 33,333 33,333 50,000 83,333 306,667
Research & Development 3,000 3,000 10,000 10,000 10,000 10,000 20,000 20,000 20,000 20,000 30,000 30,000 186,000
Public Relations 1,945 3,242 6,484 6,484 6,484 6,484 6,484 6,484 6,484 6,484 6,484 6,484 70,026
CSR 2,431 4,052 8,105 8,105 16,210 16,210 24,314 24,314 32,419 32,419 48,629 81,048 298,257
Insurance 600 1,000 2,000 2,000 4,000 4,000 6,000 6,000 8,000 8,000 12,000 20,000 73,600
Emergency Support 1,200 2,000 4,000 4,000 8,000 8,000 12,000 12,000 16,000 16,000 24,000 40,000 147,200
-
TOTAL EXPENSES 96,677 147,128 290,255 290,255 551,027 551,027 821,798 821,798 1,098,570 1,098,570 1,651,113 2,634,199 10,052,416

CONTRIBUTION MARGIN 581 14,969 33,938 33,938 97,359 97,359 150,780 150,780 198,202 198,202 294,044 607,730 1,877,881

CAPEX/DOWNPAYMENTS/ADVANCES

NET CASH FLOW USD 581 14,969 33,938 33,938 97,359 97,359 150,780 150,780 198,202 198,202 294,044 607,730

USD to PKR 300


Grinding costs per ton PKR 2000
Cost of Packing, per ton 2500
Trasport per ton PKR 10000
Extraction Costs TON PKR 20000
Fuel and maint Costs per ton pkr 35000
ZED MINERALS
COPPER EXPORT YEAR TWO
ASSUMPTIONS/NOTES: 1
10 percent average
Formula LME * percentage * 50 percent factoring 10% Copper Ore 10% Copper Ore10% Copper Ore 10% Copper Ore10% Copper Ore10% Copper Ore 10% Copper Ore 10% Copper Ore 10% Copper Ore 10% Copper Ore 10% Copper Ore 10% Copper Ore

LME Price Copper 8,500 Reveue per Ton 425 425 425 425 425 425 425 425 425 425 425 425

Cost per Ton 274.28 274.28 274.28 274.28 274.28 274.28 274.28 274.28 274.28 274.28 272.02 272.02
Profit per Ton 150.72 150.72 150.72 150.72 150.72 150.72 150.72 150.72 150.72 150.72 152.98 152.98

PROJECTIONS FOR YEAR T W O (2) OF OPERATIONS


VALUE of
YEAR -2 YEAR -2 YEAR -2 YEAR -2 YEAR -2 YEAR -2 YEAR -2 YEAR -2 Month- YEAR -2 YEAR -2 YEAR -2
YEAR -2 Month-9 TOTAL YEAR -2 ENDING
Month-1 Month-2 Month-3 Month-4 Month-5 Month-6 Month-7 8 Month-10 Month-11 Month-12
INVENTORY

PRODUCTION IN M. TONS. 10,000 10,000 10,000 10,000 10,000 10,000 10,000 10,000 10,000 10,000 12,000 12,000 124,000
Nett. (of wastage) PRODUCTION IN M. TONS. 10,000 10,000 10,000 10,000 10,000 10,000 10,000 10,000 10,000 10,000 12,000 12,000 124,000

SALES Revenue 4,250,000 4,250,000 4,250,000 4,250,000 4,250,000 4,250,000 4,250,000 4,250,000 4,250,000 4,250,000 5,100,000 5,100,000 52,700,000
Revenue from Mine Wastage 354,167 354,167 354,167 354,167 354,167 354,167 354,167 354,167 354,167 354,167 425,000 425,000 4,391,667
Sales Tax -828,750 -828,750 -828,750 -828,750 -828,750 -828,750 -828,750 -828,750 -828,750 -828,750 -994,500 -994,500 -8,619,000
Net Revenue 3,775,417 3,775,417 3,775,417 3,775,417 3,775,417 3,775,417 3,775,417 3,775,417 3,775,417 3,775,417 4,530,500 4,530,500 46,815,167

EXPENSES -

Salaries & Wages 50,000 50,000 50,000 50,000 50,000 50,000 50,000 50,000 50,000 50,000 60,000 60,000 620,000
Fuel & Maintainance 1,142,857 1,142,857 1,142,857 1,142,857 1,142,857 1,142,857 1,142,857 1,142,857 1,142,857 1,142,857 1,371,429 1,371,429 14,171,429
Travel Expenses 10,000 10,000 10,000 10,000 10,000 10,000 10,000 10,000 10,000 10,000 12,000 12,000 124,000
Equipment Rentals 80,000 80,000 80,000 80,000 80,000 80,000 80,000 80,000 80,000 80,000 90,000 90,000 980,000
Transportation of Ore 342,857 342,857 342,857 342,857 342,857 342,857 342,857 342,857 342,857 342,857 411,429 411,429 4,251,429
Extraction Costs 714,286 714,286 714,286 714,286 714,286 714,286 714,286 714,286 714,286 714,286 857,143 857,143 8,857,143
Grinding 57,143 57,143 57,143 57,143 57,143 57,143 57,143 57,143 57,143 57,143 68,571 68,571 708,571
Pakcking 85,714 85,714 85,714 85,714 85,714 85,714 85,714 85,714 85,714 85,714 102,857 102,857 1,062,857
Research & Development 30,000 30,000 30,000 30,000 30,000 30,000 30,000 30,000 30,000 30,000 30,000 30,000 360,000
Public Relations 75,508 75,508 75,508 75,508 75,508 75,508 75,508 75,508 75,508 75,508 75,508 75,508 906,100
CSR 94,385 94,385 94,385 94,385 94,385 94,385 94,385 94,385 94,385 94,385 113,263 113,263 1,170,379
Insurance 20,000 20,000 20,000 20,000 20,000 20,000 20,000 20,000 20,000 20,000 24,000 24,000 248,000
Emergency Support 40,000 40,000 40,000 40,000 40,000 40,000 40,000 40,000 40,000 40,000 48,000 48,000 496,000
-
TOTAL EXPENSES 2,742,751 2,742,751 2,742,751 2,742,751 2,742,751 2,742,751 2,742,751 2,742,751 2,742,751 2,742,751 3,264,199 3,264,199 33,955,908

CONTRIBUTION MARGIN 1,032,666 1,032,666 1,032,666 1,032,666 1,032,666 1,032,666 1,032,666 1,032,666 1,032,666 1,032,666 1,266,301 1,266,301 12,859,259

CAPEX/DOWNPAYMENTS/ADVANCES

NET CASH FLOW USD 1,032,666 1,032,666 1,032,666 1,032,666 1,032,666 1,032,666 1,032,666 1,032,666 1,032,666 1,032,666 1,266,301 1,266,301

USD to PKR 350


Grinding costs per ton PKR 2000
Cost of Packing, per ton 3000
Trasport per ton PKR 12000
Extraction Costs TON PKR 25000
Fuel and maint Costs per ton pkr 40000
ZED MINERALS
COPPER EXPORT YEAR THREE
ASSUMPTIONS/NOTES: 1
10 percent average
Formula LME * percentage * 55 percent factoring 10% Copper Ore 10% Copper Ore10% Copper Ore 10% Copper Ore10% Copper Ore10% Copper Ore 10% Copper Ore 10% Copper Ore 10% Copper Ore 10% Copper Ore 10% Copper Ore 10% Copper Ore

LME Price Copper 8,300 Reveue per Ton 457 457 457 457 457 457 457 457 457 457 457 457

Cost per Ton 280.92 280.92 277.03 277.03 277.03 277.03 275.66 275.66 275.66 275.47 275.72 275.47
Profit per Ton 175.58 175.58 179.47 179.47 179.47 179.47 180.84 180.84 180.84 181.03 180.78 181.03

PROJECTIONS FOR YEAR T H R E E (3) OF OPERATIONS


VALUE of
YEAR -3 YEAR -3 YEAR -3 YEAR -3 YEAR -3 YEAR -3 YEAR -3 YEAR -3 Month- YEAR -3 YEAR -3 YEAR -3
YEAR -3 Month-9 TOTAL YEAR -3 ENDING
Month-1 Month-2 Month-3 Month-4 Month-5 Month-6 Month-7 8 Month-10 Month-11 Month-12
INVENTORY

PRODUCTION IN M. TONS. 12,000 12,000 15,000 15,000 15,000 15,000 18,000 18,000 18,000 20,000 20,000 20,000 198,000
Nett. (of wastage) PRODUCTION IN M. TONS. 12,000 12,000 15,000 15,000 15,000 15,000 18,000 18,000 18,000 20,000 20,000 20,000 198,000

SALES Revenue 5,478,000 5,478,000 6,847,500 6,847,500 6,847,500 6,847,500 8,217,000 8,217,000 8,217,000 9,130,000 9,130,000 9,130,000 90,387,000
Revenue from Mine Wastage 547,800 547,800 684,750 684,750 684,750 684,750 821,700 821,700 821,700 913,000 913,000 913,000 9,038,700
Sales Tax -1,084,644 -1,084,644 -1,355,805 -1,355,805 -1,355,805 -1,355,805 -1,626,966 -1,626,966 -1,626,966 -1,807,740 -1,807,740 -1,807,740 -15,727,338
Net Revenue 4,941,156 4,941,156 6,176,445 6,176,445 6,176,445 6,176,445 7,411,734 7,411,734 7,411,734 8,235,260 8,235,260 8,235,260 81,529,074

EXPENSES -

Salaries & Wages 60,000 60,000 70,000 70,000 70,000 70,000 80,000 80,000 80,000 90,000 90,000 90,000 910,000
Fuel & Maintainance 1,350,000 1,350,000 1,687,500 1,687,500 1,687,500 1,687,500 2,025,000 2,025,000 2,025,000 2,250,000 2,250,000 2,250,000 22,275,000
Travel Expenses 12,000 12,000 15,000 15,000 15,000 15,000 20,000 20,000 20,000 20,000 25,000 20,000 209,000
Equipment Rentals 90,000 90,000 100,000 100,000 100,000 100,000 120,000 120,000 120,000 140,000 140,000 140,000 1,360,000
Transportation of Ore 420,000 420,000 525,000 525,000 525,000 525,000 630,000 630,000 630,000 700,000 700,000 700,000 6,930,000
Extraction Costs 900,000 900,000 1,125,000 1,125,000 1,125,000 1,125,000 1,350,000 1,350,000 1,350,000 1,500,000 1,500,000 1,500,000 14,850,000
Grinding 75,000 75,000 93,750 93,750 93,750 93,750 112,500 112,500 112,500 125,000 125,000 125,000 1,237,500
Pakcking 105,000 105,000 131,250 131,250 131,250 131,250 157,500 157,500 157,500 175,000 175,000 175,000 1,732,500
Research & Development 40,000 40,000 40,000 40,000 40,000 40,000 50,000 50,000 50,000 60,000 60,000 60,000 570,000
Public Relations 123,529 123,529 123,529 123,529 123,529 123,529 123,529 123,529 123,529 123,529 123,529 123,529 1,482,347
CSR 123,529 123,529 154,411 154,411 154,411 154,411 185,293 185,293 185,293 205,882 205,882 205,882 2,038,227
Insurance 24,000 24,000 30,000 30,000 30,000 30,000 36,000 36,000 36,000 40,000 40,000 40,000 396,000
Emergency Support 48,000 48,000 60,000 60,000 60,000 60,000 72,000 72,000 72,000 80,000 80,000 80,000 792,000
-
TOTAL EXPENSES 3,371,058 3,371,058 4,155,440 4,155,440 4,155,440 4,155,440 4,961,822 4,961,822 4,961,822 5,509,410 5,514,410 5,509,410 54,782,574

CONTRIBUTION MARGIN 1,570,098 1,570,098 2,021,005 2,021,005 2,021,005 2,021,005 2,449,912 2,449,912 2,449,912 2,725,850 2,720,850 2,725,850 26,746,500

CAPEX/DOWNPAYMENTS/ADVANCES

NET CASH FLOW USD 1,570,098 1,570,098 2,021,005 2,021,005 2,021,005 2,021,005 2,449,912 2,449,912 2,449,912 2,725,850 2,720,850 2,725,850

USD to PKR 400


Grinding costs per ton PKR 2500
Cost of Packing, per ton 3500
Trasport per ton PKR 14000
Extraction Costs TON PKR 30000
Fuel and maint Costs per ton pkr 45000
ZED MINERALS
COPPER EXPORT YEAR FOUR
ASSUMPTIONS/NOTES: 1
10 percent average
Formula LME * percentage * 55 percent factoring 10% Copper Ore 10% Copper Ore10% Copper Ore 10% Copper Ore10% Copper Ore10% Copper Ore 10% Copper Ore 10% Copper Ore 10% Copper Ore 10% Copper Ore 10% Copper Ore 10% Copper Ore

LME Price Copper 8,500 Reveue per Ton 468 468 468 468 468 468 468 468 468 468 468 468

Cost per Ton 273.92 273.92 273.20 273.20 270.96 270.96 272.76 272.76 272.76 272.24 272.42 272.24
Profit per Ton 193.58 193.58 194.30 194.30 196.54 196.54 194.74 194.74 194.74 195.26 195.08 195.26

PROJECTIONS FOR YEAR T H R E E (3) OF OPERATIONS


VALUE of
YEAR -3 YEAR -3 YEAR -3 YEAR -3 YEAR -3 YEAR -3 YEAR -3 YEAR -3 Month- YEAR -3 YEAR -3 YEAR -3
YEAR -3 Month-9 TOTAL YEAR -3 ENDING
Month-1 Month-2 Month-3 Month-4 Month-5 Month-6 Month-7 8 Month-10 Month-11 Month-12
INVENTORY

PRODUCTION IN M. TONS. 20,000 20,000 22,000 22,000 25,000 25,000 25,000 25,000 25,000 28,000 28,000 28,000 293,000
Nett. (of wastage) PRODUCTION IN M. TONS. 20,000 20,000 22,000 22,000 25,000 25,000 25,000 25,000 25,000 28,000 28,000 28,000 293,000

SALES Revenue 9,350,000 9,350,000 10,285,000 10,285,000 11,687,500 11,687,500 11,687,500 11,687,500 11,687,500 13,090,000 13,090,000 13,090,000 136,977,500
Revenue from Mine Wastage 935,000 935,000 1,028,500 1,028,500 1,168,750 1,168,750 1,168,750 1,168,750 1,168,750 1,309,000 1,309,000 1,309,000 13,697,750
Sales Tax -1,851,300 -1,851,300 -2,036,430 -2,036,430 -2,314,125 -2,314,125 -2,314,125 -2,314,125 -2,314,125 -2,591,820 -2,591,820 -2,591,820 -23,418,945
Net Revenue 8,433,700 8,433,700 9,277,070 9,277,070 10,542,125 10,542,125 10,542,125 10,542,125 10,542,125 11,807,180 11,807,180 11,807,180 123,553,705

EXPENSES -

Salaries & Wages 60,000 60,000 70,000 70,000 70,000 70,000 80,000 80,000 80,000 90,000 90,000 90,000 910,000
Fuel & Maintainance 2,200,000 2,200,000 2,420,000 2,420,000 2,750,000 2,750,000 2,750,000 2,750,000 2,750,000 3,080,000 3,080,000 3,080,000 32,230,000
Travel Expenses 12,000 12,000 15,000 15,000 15,000 15,000 20,000 20,000 20,000 20,000 25,000 20,000 209,000
Equipment Rentals 90,000 90,000 100,000 100,000 100,000 100,000 120,000 120,000 120,000 140,000 140,000 140,000 1,360,000
Transportation of Ore 640,000 640,000 704,000 704,000 800,000 800,000 800,000 800,000 800,000 896,000 896,000 896,000 9,376,000
Extraction Costs 1,600,000 1,600,000 1,760,000 1,760,000 2,000,000 2,000,000 2,000,000 2,000,000 2,000,000 2,240,000 2,240,000 2,240,000 23,440,000
Grinding 120,000 120,000 132,000 132,000 150,000 150,000 150,000 150,000 150,000 168,000 168,000 168,000 1,758,000
Pakcking 200,000 200,000 220,000 220,000 250,000 250,000 250,000 250,000 250,000 280,000 280,000 280,000 2,930,000
Research & Development 40,000 40,000 40,000 40,000 40,000 40,000 50,000 50,000 50,000 60,000 60,000 60,000 570,000
Public Relations 185,541 185,541 185,541 185,541 185,541 185,541 185,541 185,541 185,541 185,541 185,541 185,541 2,226,497
CSR 210,843 210,843 231,927 231,927 263,553 263,553 263,553 263,553 263,553 295,180 295,180 295,180 3,088,843
Insurance 40,000 40,000 44,000 44,000 50,000 50,000 50,000 50,000 50,000 56,000 56,000 56,000 586,000
Emergency Support 80,000 80,000 88,000 88,000 100,000 100,000 100,000 100,000 100,000 112,000 112,000 112,000 1,172,000
-
TOTAL EXPENSES 5,478,384 5,478,384 6,010,468 6,010,468 6,774,095 6,774,095 6,819,095 6,819,095 6,819,095 7,622,721 7,627,721 7,622,721 79,856,339

CONTRIBUTION MARGIN 2,955,316 2,955,316 3,266,602 3,266,602 3,768,030 3,768,030 3,723,030 3,723,030 3,723,030 4,184,459 4,179,459 4,184,459 43,697,366

CAPEX/DOWNPAYMENTS/ADVANCES

NET CASH FLOW USD 2,955,316 2,955,316 3,266,602 3,266,602 3,768,030 3,768,030 3,723,030 3,723,030 3,723,030 4,184,459 4,179,459 4,184,459

USD to PKR 500


Grinding costs per ton PKR 3000
Cost of Packing, per ton 5000
Trasport per ton PKR 16000
Extraction Costs TON PKR 40000
Fuel and maint Costs per ton pkr 55000
ZED MINERALS
COPPER EXPORT YEAR THREE
ASSUMPTIONS/NOTES: 1
10 percent average
Formula LME * percentage * 55 percent factoring 10% Copper Ore 10% Copper Ore10% Copper Ore 10% Copper Ore10% Copper Ore10% Copper Ore 10% Copper Ore 10% Copper Ore 10% Copper Ore 10% Copper Ore 10% Copper Ore 10% Copper Ore

LME Price Copper 8,800 Reveue per Ton 484 484 484 484 484 484 484 484 484 484 484 484

Cost per Ton 254.32 254.32 253.98 253.98 253.98 252.96 254.37 254.37 252.95 254.09 254.23 254.09
Profit per Ton 229.68 229.68 230.02 230.02 230.02 231.04 229.63 229.63 231.05 229.91 229.77 229.91

PROJECTIONS FOR YEAR T H R E E (3) OF OPERATIONS


VALUE of
YEAR -3 YEAR -3 YEAR -3 YEAR -3 YEAR -3 YEAR -3 YEAR -3 YEAR -3 Month- YEAR -3 YEAR -3 YEAR -3
YEAR -3 Month-9 TOTAL YEAR -3 ENDING
Month-1 Month-2 Month-3 Month-4 Month-5 Month-6 Month-7 8 Month-10 Month-11 Month-12
INVENTORY

PRODUCTION IN M. TONS. 28,000 28,000 30,000 30,000 30,000 32,000 32,000 32,000 35,000 35,000 35,000 35,000 382,000
Nett. (of wastage) PRODUCTION IN M. TONS. 28,000 28,000 30,000 30,000 30,000 32,000 32,000 32,000 35,000 35,000 35,000 35,000 382,000

SALES Revenue 13,552,000 13,552,000 14,520,000 14,520,000 14,520,000 15,488,000 15,488,000 15,488,000 16,940,000 16,940,000 16,940,000 16,940,000 184,888,000
Revenue from Mine Wastage 1,355,200 1,355,200 1,452,000 1,452,000 1,452,000 1,548,800 1,548,800 1,548,800 1,694,000 1,694,000 1,694,000 1,694,000 18,488,800
Sales Tax -2,683,296 -2,683,296 -2,874,960 -2,874,960 -2,874,960 -3,066,624 -3,066,624 -3,066,624 -3,354,120 -3,354,120 -3,354,120 -3,354,120 -31,241,232
Net Revenue 12,223,904 12,223,904 13,097,040 13,097,040 13,097,040 13,970,176 13,970,176 13,970,176 15,279,880 15,279,880 15,279,880 15,279,880 166,768,976

EXPENSES -

Salaries & Wages 60,000 60,000 70,000 70,000 70,000 70,000 80,000 80,000 80,000 90,000 90,000 90,000 910,000
Fuel & Maintainance 2,800,000 2,800,000 3,000,000 3,000,000 3,000,000 3,200,000 3,200,000 3,200,000 3,500,000 3,500,000 3,500,000 3,500,000 38,200,000
Travel Expenses 12,000 12,000 15,000 15,000 15,000 15,000 20,000 20,000 20,000 20,000 25,000 20,000 209,000
Equipment Rentals 90,000 90,000 100,000 100,000 100,000 100,000 120,000 120,000 120,000 140,000 140,000 140,000 1,360,000
Transportation of Ore 840,000 840,000 900,000 900,000 900,000 960,000 960,000 960,000 1,050,000 1,050,000 1,050,000 1,050,000 11,460,000
Extraction Costs 2,100,000 2,100,000 2,250,000 2,250,000 2,250,000 2,400,000 2,400,000 2,400,000 2,625,000 2,625,000 2,625,000 2,625,000 28,650,000
Grinding 163,333 163,333 175,000 175,000 175,000 186,667 186,667 186,667 204,167 204,167 204,167 204,167 2,228,333
Pakcking 280,000 280,000 300,000 300,000 300,000 320,000 320,000 320,000 350,000 350,000 350,000 350,000 3,820,000
Research & Development 40,000 40,000 40,000 40,000 40,000 40,000 50,000 50,000 50,000 60,000 60,000 60,000 570,000
Public Relations 261,941 261,941 261,941 261,941 261,941 261,941 261,941 261,941 261,941 261,941 261,941 261,941 3,143,290
CSR 305,598 305,598 327,426 327,426 327,426 349,254 349,254 349,254 381,997 381,997 381,997 381,997 4,169,224
Insurance 56,000 56,000 60,000 60,000 60,000 64,000 64,000 64,000 70,000 70,000 70,000 70,000 764,000
Emergency Support 112,000 112,000 120,000 120,000 120,000 128,000 128,000 128,000 140,000 140,000 140,000 140,000 1,528,000
-
TOTAL EXPENSES 7,120,872 7,120,872 7,619,367 7,619,367 7,619,367 8,094,862 8,139,862 8,139,862 8,853,104 8,893,104 8,898,104 8,893,104 97,011,847

CONTRIBUTION MARGIN 5,103,032 5,103,032 5,477,673 5,477,673 5,477,673 5,875,314 5,830,314 5,830,314 6,426,776 6,386,776 6,381,776 6,386,776 69,757,129

CAPEX/DOWNPAYMENTS/ADVANCES

NET CASH FLOW USD 5,103,032 5,103,032 5,477,673 5,477,673 5,477,673 5,875,314 5,830,314 5,830,314 6,426,776 6,386,776 6,381,776 6,386,776

USD to PKR 600


Grinding costs per ton PKR 3500
Cost of Packing, per ton 6000
Trasport per ton PKR 18000
Extraction Costs TON PKR 45000
Fuel and maint Costs per ton pkr 60000

You might also like