Cash Flow
Cash Flow
Cash Flow
(* US$) ### 10000 10000 10000 10000 10000 10000 10000 10000 10000 10000 10000 10000 10000 10000 10000 10000 10000 10000 10000 10000 10000 10000 10000 10000
Machine Designation D 375 A D 155 A D 85 Ess D 65 P Type 1250 PC.400 PC.200 WA 320 777C 793 CWB520 ldn Bomag GD 705 A Wt Truck Low Boy P Ranger Mtc Truck Crane Crane 40T Fork Clift GS-1250KV P245M Lihgting 15 T Truck Bus Per
Estimated Ownership Period(years) 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6
Estimated Usage (hours/year) 4,800 4,800 4,800 4,800 4,800 4,800 4,800 4,800 4,800 4,800 4,800 4,800 4,800 4,800 4,800 4,800 4,800 4,800 4,800 4,800 4,800 4,800 4,800 4,800 4,800
Ownership usage (total hours) 28,800 28,800 28,800 28,800 28,800 28,800 28,800 28,800 28,800 28,800 28,800 28,800 28,800 28,800 28,800 28,800 28,800 28,800 28,800 28,800 28,800 28,800 28,800 28,800 28,800
Owning Cost
1.a.Delivered Price(incl.Attachment) 495,000 346,500 160,600 160,600 290,000 143,000 91,300 123,000 156,000 275,000 62,400 66,000 265,000 55,000 150,000 22,000 120,000 75,000 50,000 55,000 0 25,000 6,000 20,000 30,000
b. Less Tire replacement cost if desired
c.Delivered Price less tire 495,000 346,500 160,600 160,600 290,000 143,000 91,300 123,000 156,000 275,000 62,400 66,000 265,000 55,000 150,000 22,000 120,000 75,000 50,000 55,000 0 25,000 6,000 20,000 30,000
3. a.Value to be recovered through work 495,000 346,500 160,600 160,600 290,000 143,000 91,300 123,000 156,000 275,000 62,400 66,000 265,000 55,000 150,000 22,000 120,000 75,000 50,000 55,000 0 25,000 6,000 20,000 30,000
Period of Recovered (month) 36.00 36.00 36.00 36.00 36 36.00 36.00 36.00 36.00 36.00 36.00 36.00 36.00 36.00 36.00 36.00 36.00 36.00 36.00 36.00 36.00 36.00 36.00 36.00 36.00
Monthly Interest 0.0142 0.0142 0.0142 0.0142 0.0142 0.0142 0.0142 0.0142 0.0142 0.0142 0.0142 0.0142 0.0142 0.0142 0.0142 0.0142 0.0142 0.0142 0.0142 0.0142 0.0142 0.0142 0.0142 0.0142 0.0142
Insurance Monthly 0.0010 0.0010 0.0010 0.0010 0.0010 0.0010 0.0010 0.0010 0.0010 0.0010 0.0010 0.0010 0.0010 0.0010 0.0010 0.0010 0.0010 0.0010 0.0010 0.0010 0.0010 0.0010 0.0010 0.0010 0.0010
Property Tax Monthly 0.0017 0.0017 0.0017 0.0017 0.0017 0.0017 0.0017 0.0017 0.0017 0.0017 0.0017 0.0017 0.0017 0.0017 0.0017 0.0017 0.0017 0.0017 0.0017 0.0017 0.0017 0.0017 0.0017 0.0017 0.0017
Interest,Insurance and Tax Rate 0.0169 0.0169 0.0169 0.0169 0.0169 0.0169 0.0169 0.0169 0.0169 0.0169 0.0169 0.0169 0.0169 0.0169 0.0169 0.0169 0.0169 0.0169 0.0169 0.0169 0.0169 0.0169 0.0169 0.0169 0.0169
Factor 1 0.0308 0.0308 0.0308 0.0308 0.0308 0.0308 0.0308 0.0308 0.0308 0.0308 0.0308 0.0308 0.0308 0.0308 0.0308 0.0308 0.0308 0.0308 0.0308 0.0308 0.0308 0.0308 0.0308 0.0308 0.0308
Factor 2 0.8266 0.8266 0.8266 0.8266 0.8266 0.8266 0.8266 0.8266 0.8266 0.8266 0.8266 0.8266 0.8266 0.8266 0.8266 0.8266 0.8266 0.8266 0.8266 0.8266 0.8266 0.8266 0.8266 0.8266 0.8266
Capital Recovery Factor 1 0.0373 0.0373 0.0373 0.0373 0.0373 0.0373 0.0373 0.0373 0.0373 0.0373 0.0373 0.0373 0.0373 0.0373 0.0373 0.0373 0.0373 0.0373 0.0373 0.0373 0.0373 0.0373 0.0373 0.0373 0.0373
Period of Recovered (month) alt 2 60 60 60 60 60 60 60 60 60 60 60 60 60 60 60 60 60 60 60 60 60 60 60 60 60
Factor 0.0461 0.0461 0.0461 0.0461 0.0461 0.0461 0.0461 0.0461 0.0461 0.0461 0.0461 0.0461 0.0461 0.0461 0.0461 0.0461 0.0461 0.0461 0.0461 0.0461 0.0461 0.0461 0.0461 0.0461 0.0461
Factor 1.7293 1.7293 1.7293 1.7293 1.7293 1.7293 1.7293 1.7293 1.7293 1.7293 1.7293 1.7293 1.7293 1.7293 1.7293 1.7293 1.7293 1.7293 1.7293 1.7293 1.7293 1.7293 1.7293 1.7293 1.7293
Capital Recovery Factor 2 0.0266 0.0266 0.0266 0.0266 0.0266 0.0266 0.0266 0.0266 0.0266 0.0266 0.0266 0.0266 0.0266 0.0266 0.0266 0.0266 0.0266 0.0266 0.0266 0.0266 0.0266 0.0266 0.0266 0.0266 0.0266
Installment 80% of Investment 396,000 277,200 128,480 128,480 232,000 114,400 73,040 98,400 124,800 220,000 49,920 52,800 212,000 44,000 120,000 17,600 96,000 60,000 40,000 44,000 0 20,000 4,800 16,000 24,000
Installment Monthly Bases 14,767 10,337 4,791 4,791 8,652 4,266 2,724 3,669 4,654 8,204 1,862 1,969 7,906 1,641 4,475 656 3,580 2,237 1,492 1,641 0 746 179 597 895
Instalment 20% of Investment 99,000 69,300 32,120 32,120 58,000 28,600 18,260 24,600 31,200 55,000 12,480 13,200 53,000 11,000 30,000 4,400 24,000 15,000 10,000 11,000 0 5,000 1,200 4,000 6,000
Mothly Installment 2,637 1,846 855 855 1,545 762 486 655 831 1,465 332 352 1,412 293 799 117 639 399 266 293 0 133 32 107 160
Monthly Instalment( for 36 Month perio 17,404 12,183 5,647 5,647 10,196 5,028 3,210 4,325 5,485 9,669 2,194 2,321 9,317 1,934 5,274 774 4,219 2,637 1,758 1,934 0 879 211 703 1,055
Operating Cost D 375 A D 155 A D 85 Ess D 65 P Type 1250 PC.400 PC.200 WA 320 CWB520 ldn CWB520 ldn CWB520 ldn GD 705 GD 705 A Wt Truck Low Boy P Ranger Mtc Truck Crane Crane 40T Fork Clift GS-1250KV P245M Lihgting 15 T Truck Bus Per
1. Fuel
Unit Price/litre 0.246 0.246 0.246 0.246 0.246 0.246 0.246 0.246 0.246 0.246 0.246 0.246 0.246 0.246 0.246 0.246 0.246 0.246 0.246 0.246 0.246 0.246 0.246 0.246 0.246
Fuel Consumed(Us$) 86 45 35 35 55 30 20 20 15 15 15 20 24 15 15 3 15 5 10 5 335 66.2 1 10 10
Fuel Cost($) 21.16 11.07 8.61 8.61 13.53 7.38 4.92 4.92 3.69 3.69 3.69 4.92 5.90 3.69 3.69 0.74 3.69 1.23 2.46 1.23 82.41 16.29 0.25 2.46 2.46
2. Lube,Oil,Filter and Grease
Engine Consumed/hour 0.21 0.08 0.08 0.08 0.11 0.15 0.05 0.12 0.09 0.09 0.09 0.09 0.16 0.09 0.09 0.08 0.09 0.09 0.15 0.09 0.09 0.09 0.005 0.09 0.09
Unit Price/litre 2.50 2.50 2.50 2.50 2.50 2.50 2.50 2.50 2.50 2.50 2.50 2.50 2.50 2.50 2.50 2.50 2.50 2.50 2.50 2.50 2.50 2.50 2.50 2.50 2.50
Cost per hour 0.53 0.20 0.20 0.20 0.28 0.38 0.13 0.30 0.23 0.23 0.23 0.23 0.40 0.23 0.23 0.20 0.23 0.23 0.38 0.23 0.23 0.23 0.01 0.23 0.23
Transmission Consumed /hour 0.15 0.06 0.05 0.05 0.05 0.12 0.01 0.04 0.01 0.01 0.01 0.01 0.04 0.01 0.01 0.06 0.01 0.01 0.12 0.01 0.01 0.01 0.01 0.01 0.01
Unit Price/litre 2.50 2.50 2.50 2.50 2.50 2.50 2.50 2.50 2.50 2.50 2.50 2.50 2.50 2.50 2.50 2.50 2.50 2.50 2.50 2.50 2.50 2.50 2.50 2.50 2.50
Cost per hour 0.38 0.15 0.13 0.13 0.13 0.30 0.02 0.10 0.02 0.02 0.02 0.02 0.10 0.02 0.02 0.15 0.02 0.02 0.30 0.02 0.02 0.02 0.01 0.02 0.02
Final Drive Consumed 0.07 0.12 0.06 0.01 0.02 0.08 0.01 0.03 0.09 0.09 0.09 0.09 0.13 0.09 0.09 0.12 0.09 0.09 0.08 0.09 0.09 0.09 0.00 0.09 0.09
Unit Price/litre 2.50 2.50 2.50 2.50 2.50 2.50 2.50 2.50 2.50 2.50 2.50 2.50 2.50 2.50 2.50 2.50 2.50 2.50 2.50 2.50 2.50 2.50 2.50 2.50 2.50
Cost per hour 0.18 0.30 0.15 0.18 0.06 0.20 0.01 0.08 0.21 0.21 0.21 0.21 0.33 0.21 0.21 0.30 0.21 0.21 0.20 0.21 0.21 0.21 0.00 0.21 0.21
Hydraulic Consumend/hour 0.06 0.05 0.03 0.06 0.14 0.09 0.03 0.06 0.04 0.04 0.04 0.04 0.08 0.04 0.04 0.05 0.04 0.04 0.09 0.04 0.04 0.04 0.00 0.04 0.04
Unit Price/litre 2.50 2.50 2.50 2.50 2.50 2.50 2.50 2.50 2.50 2.50 2.50 2.50 2.50 2.50 2.50 2.50 2.50 2.50 2.50 2.50 2.50 2.50 2.50 2.50 2.50
Cost per hour 0.15 0.13 0.08 0.09 0.35 0.23 0.08 0.15 0.10 0.10 0.10 0.10 0.20 0.10 0.10 0.13 0.10 0.10 0.23 0.10 0.10 0.10 0.00 0.10 0.10
Grease consumed(kg) 0.20 0.03 0.02 0.12 0.18 0.02 0.07 0.01 0.01 0.01 0.01 0.01 0.04 0.01 0.01 0.03 0.01 0.01 0.02 0.01 0.01 0.01 0.20 0.01 0.01
Price/Kg 3.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00
Cost per hour 0.60 0.09 0.06 0.07 0.54 0.06 0.21 0.03 0.03 0.03 0.03 0.03 0.12 0.03 0.03 0.09 0.03 0.03 0.06 0.03 0.03 0.03 0.60 0.03 0.03
Filter Cost 0.91 0.43 0.31 0.33 0.67 0.58 0.22 0.33 0.29 0.29 0.29 0.29 0.57 0.29 0.29 0.43 0.29 0.29 0.58 0.29 0.29 0.29 0.31 0.29 0.29
Lube,Oil,Grease and Filter Cost 2.74 1.30 0.92 1.00 2.02 1.74 0.66 0.98 0.88 0.88 0.88 0.88 1.72 0.88 0.88 1.30 0.88 0.88 1.74 0.88 0.88 0.88 0.94 0.88 0.88
Total Owning +Operating Cost 35,417.52 21,371.38 11,476.06 14,593.04 25,033.24 11,927.48 8,851.02 8,964.62 8,203.77 12,387.75 4,912.84 3,358.53 14,528.47 2,972.27 6,127.43 1,026.59 5,442.64 2,959.96 2,246.39 2,418.27 60,775.20 14,044.33 614.76 2,041.19 1,946.79
AKM
Acre to be finished(ha) 220.00 Caracters Factor 5,000
Dense 1480 trees/ha 2 70,000,000
medium 990 - 1480 trees/ha 1
Light 990 trees/ha 0.7
Present heavy Fine(A) 2
Very Heavy Fine 3
Treesw per ha ground level
diameter
<30cm
31-60 cm
61-90 cm
91-120 cm
121- 180 cm
180cm <
Truck Productivity
Truck Type Euclid EH1000
Truck Capacity tones 56.90 56.90 56.90
Distance km 1.50 1.50 1.50
lift m
Load Time min 5.00 5.00 5.00
Travel Load velocity km/hour 20.00 20.00 20.00
Travel Time min 4.50 4.50 4.50
Dumping Time min 0.10 0.10 0.10
Return Empty velocity km/hour 30.00 30.00 30.00
Return Time minute 3.00 3.00 3.00
Spotting and delay time min 0.15 0.15 0.15
Truck Cycle time 12.75 12.75 12.75
Trips Per hour theory 4.71 4.71 4.71
Max Truck Production Bcm/hour 121.82 121.82 121.82
Presentation factor % 0.90 0.90 0.90
Efficiency min/hour 53.00 53.00 53.00
Efficiency % 0.88 0.88 0.88
Material digging index 1.00 1.00 1.00
Actual Truck Production 96.84 96.84 96.84
Annual Production 484,215.13 484,215.13 484,215.13
Running Equipment 2.53 2.53 2.53
Truck Productivity
Truck Type 777C
Truck Capacity tones 86.20 86.20 86.20 ###
Distance km 1.50 1.50 2.00 ###
lift m
Load Time min 4.50 4.50 4.50 ###
Travel Load velocity km/hour 20.00 20.00 20.00 ###
Travel Time min 4.50 4.50 6.00 ###
Dumping Time min 0.10 0.10 0.10 ###
Return Empty velocity km/hour 30.00 30.00 30.00 ###
Return Time minute 3.00 3.00 3.00 ###
Spotting and delay time min 0.15 0.15 0.15 ###
Truck Cycle time 12.25 12.25 13.75 ###
Trips Per hour theory 4.90 4.90 4.36 ###
Max Truck Production Bcm/hour 176.94 176.94 157.64 ###
Presentation factor % 0.90 0.90 0.90 ###
Efficiency min/hour 53.00 53.00 53.00 ###
Efficiency % 0.88 0.88 0.88 ###
Material digging index 1.00 1.00 1.00 ###
Actual Truck Production 140.67 140.67 125.32 ###
Annual Production 703,337.79 703,337.79 626,610.03 ###
Running Equipment 2.70 2.70 3.03 8.43
Equipment Require at MA 90% 3.00 3.00 3.37 9.37
Round Eq.require/Loader 3.00 3.00 4.00 10.00
Fleet Number EX 1500 2 1 1 4.00
777C 6 4 3 13.00
SECTION:
Coal Mining Equipment TOTAL
AKM KJM KJC
Overburden removal
Excavator 2 1 1 4
OB Haul Pit to Disposal
Rigid Truck 85 tones pay load 6 4 3 13
Dumping Disposal
Bulldozer 2 1 1 4
Truck Productivity
Truck TYpe CW520LDN 793
Truck Capacity tones 20 20 20 218
Distance km 3 7 4 80
lift m
Load Time min 7.50 7.50 7.50 17.25
Travel Load velocity km/hour 25.00 25.00 25.00 30.00
Travel Time min 7.20 16.80 9.60 160.00
Dumping Time min 0.10 0.10 0.10 0.10
Return Empty velocity km/hour 40.00 40.00 40.00 40.00
Return Time min 4.50 10.50 6.00 120.00
Spoting and delay time min 0.15 0.15 0.15 0.15
Truck Cicle time min 19.45 35.05 23.35 297.50
Trips Per hour theory 3.08 1.71 2.57 0.20
Max Truck Production Bcm/hour 57.47 31.89 47.87 43.21
Presentation factor % 0.90 0.90 0.90 0.90
Efficiency min/hour 53.00 53.00 53.00 53.00
Efficiency % 0.88 0.88 0.88 0.88
Material digging index 1.00 1.00 1.00 1.00
Actual Truck Production 45.69 25.35 38.06 34.35
Annual Production 182,755.99 101,415.24 152,231.43 137,404.86
Running Equipment 2.44 4.39 2.93 16.21
Overall Utilisation 0.90 0.85 0.85 0.90
Equipment Require 2.71 5.17 3.44 18.01
Round Eq.require/Loader 3.00 5.00 3.00 18.00
Fleet Number PC-400 / 992G 4 3 2 2.00
TRUCK 12 15 6 36
SECTION
Coal Mining Equipment
AKM-ROM KJM-ROM KJC-ROM ROM-CP
Coal Extraction
Excavator PC 400 4 3 2 -
Hauling Pit to ROM
Dump Truck CW520LDN 12 15 6 -
Hauling ROM to Crushing Plant
Wheel Loader Cat 992G - - - 2
Coal Hauler / Dump Truck Cat-793 - - - 36
Coal Cleaning
Excavator PC 200 2 2 2 -
559085299.xls;CoalEx&WinDH;11/23/2021
KEMBANG JANGGUT COAL AREA
Preliminary Feasibility Study
Coal Extraction and Winning Operation 3.000.000 TPA
Truck Productivity
Truck TYpe CWA CWA CWA
Truck Capacity tones 20 20 20
Distance km 3 7 4
lift m
Load Time min 7.50 7.50 7.50
Travel Load velocity km/hour 25.00 25.00 25.00
Travel Time min 7.20 16.80 9.60
Dumping Time min 0.10 0.10 0.10
Return Empty velocity km/hour 40.00 40.00 40.00
Return Time minute 4.50 10.50 6.00
Spoting and delay time min 0.15 0.15 0.15
Truck Cicle time 19.45 35.05 23.35
Trips Per hour theory 3.08 1.71 2.57
Max Truck Production Bcm/hour 57.47 31.89 47.87
Presentation factor % 0.90 0.90 0.90
Efficiency min/hour 53.00 53.00 53.00
Efficiency % 0.88 0.88 0.88
Material digging index 1.00 1.00 1.00
Actual Truck Production 45.69 25.35 38.06
Annual Production 182,755.99 101,415.24 152,231.43
Running Equipment 2.44 4.39 2.93
Overall Utilisation 0.90 0.90 0.90
Equipment Require 2.71 4.88 3.25
Round Eq.require/Loader 3.00 5.00 3.00
Fleet Number PC-400-7 4 3 2
CW520LDN 12 15 6
ROM
Coal Mining Equipment
AKM KJM KJC
Coal Extraction
Excavator 4 3 2
Coal Haul Pit to ROM
Rigid Truck 22 tones pay load 12 15 6
Coal Cleaning
Excavator PC.200 2 2 1
KEMBANG JANGGUT COAL AREA
Preliminary Feasibility Study
Coal Extraction and Winning Operation 3.000.000 TPA
Dipper Capacity cu.m SAE 2.3 2.3 2.3 2.3 2.3 2.3
Insitu Density t/cu.m 1.3 1.3 1.3 1.3 1.3 1.3
Loose density t/lcm 0.9 0.9 0.9 0.9 0.9 0.9
Swell Factor % 69% 69% 69% 69% 69% 69%
Fill Factor % 90% 90% 90% 90% 90% 90%
Dipper load perpass tonnes 1.863 1.863 1.863 1.863 1.863 1.863
Rated Truck Capacity tonnes 18 18 18 18 18 18
Number of Pass ( Teori ) 9.66 9.66 9.66 9.66 9.66 9.66
Number of Pass(actual) 10 10 10 10 10 10
Actual Truck Pay load tonnes 18.63 18.63 18.63 18.63 18.63 18.63
Actual Truck Pay load lcm SAE 20.70 20.70 20.70 20.70 20.70 20.70
Load Time per pass Sec 45.00 45.00 45.00 45.00 45.00 45.00
Total Load Time minute min 7.50 7.50 7.50 7.50 7.50 7.50
Trips per 60 min hour 8.00 8.00 8.00 8.00 8.00 8.00
Production per 60 min hour lcm SAE 165.60 165.60 165.60 165.60 165.60 165.60
Truck Presentation % 0.90 0.90 0.90 0.90 0.90 0.90
Work Efficiency min/hour(%) 0.83 0.83 0.83 0.83 0.83 0.83
Material Digging Index 1.00 1.00 1.00 1.00 1.00 1.00
Average Production Tones per hour 111.33 111.33 111.33 111.33 111.33 111.33
Yearly Working Hours hr 4,000.00 4,000.00 4,000.00 4,000.00 4,000.00 4,000.00
Annual Productivity per Loader 445,331.52 445,331.52 445,331.52 445,331.52 445,331.52 445,331.52
Running Equipment need toachieve 3.54 3.54 2.36 2.36 1.18 1.18
Mechanical Availability % 0.90 0.90 0.85 0.90 0.85 0.90
Operating Utilization % 1.00 1.00 1.00 1.00 1.00 1.00
Utilization by mine % 1.00 1.00 1.00 1.00 1.00 1.00
Overal Utilisation % 0.90 0.90 0.85 0.90 0.85 0.90
Equipment Need 3.93 3.93 2.77 2.62 1.39 1.31
Eq Need Round 4 4 3 3 2 2
Truck Productivity
Truck TYpe CWA CWA CWA
Truck Capacity tones 20 20 20 20 20 20
Distance km 35 10 40 15 30 15
lift m
Load Time min 7.50 7.50 7.00 7.50 7.50 7.50
Travel Load velocity km/hour 25.00 25.00 25.00 25.00 25.00 25.00
Travel Time min 84.00 24.00 96.00 36.00 72.00 36.00
Dumping Time min 0.10 0.10 0.10 0.10 0.10 0.10
Return Empty velocity km/hour 40.00 40.00 40.00 40.00 40.00 40.00
Return Time minute 52.50 15.00 60.00 22.50 45.00 22.50
Spoting and delay time min 0.15 0.15 0.15 0.15 0.15 0.15
Truck Cicle time 144.25 46.75 163.25 66.25 124.75 66.25
Trips Per hour theory 0.42 1.28 0.37 0.91 0.48 0.91
Max Truck Production Bcm/hour 7.75 23.91 6.85 16.87 8.96 16.87
Presentation factor % 0.90 0.90 0.90 0.90 0.90 0.90
Efficiency min/hour 53.00 53.00 53.00 53.00 53.00 53.00
Efficiency % 0.88 0.88 0.88 0.88 0.88 0.88
Material digging index 1.00 1.00 1.00 1.00 1.00 1.00
Actual Truck Production 6.16 19.01 5.44 13.41 7.12 13.41
Annual Production 24,641.97 76,034.31 21,773.99 53,654.40 28,493.82 53,654.40
Running Equipment 18.07 5.86 20.45 8.30 15.63 8.30
Overall Utilisation 0.90 0.90 0.85 0.90 0.85 0.90
Equipment Require 20.08 6.51 24.06 9.22 18.39 9.22
Round Eq.require/Loader 20.00 7.00 24.00 9.00 18.00 9.00
Fleet Number PC-400-7 4 4 3 3 2 2
CW520LDN 80 28 72 27 36 18
Mining Operation
1US to Rupiah 9300
Top Soil and Overburden Removal Unit Require Quantity OP.Require Basic Salary
Pit and Dump D155A/D85Ess 7.00 16 161.29
Coal Clean/Pit Sk200 2 3 107.53
Dump Area Pc.300/Pc.200 1 2 134.41
Dump Area/Rod Bomag BW 211D-3 3 5 134.41
Road Maintenance Water Truck 12000 litre 2 5 161.29
Road Maintenance SK200 4 3 161.29
Mine Support Nissan CWB 520 3 7 107.53
Mine op. Support Power Ranger 7 8 119.05
Road Maintenance Water Truck 10000 2 3 134.41
Fuel Truck Cap 15000 lt TZA 2 3 107.53
Road Maintenance GD 705 2 6 161.29
Sum of Supp MOP Cost
Workshop
Truck 15 ton Nissan/Renault 1 2 119.05
Forklift 3-5 tons 2 3 119.05
Crane truck Capcatity 30 tons 1 2 119.05
Crane for Logistics in Port IHI crane 40 tones 1 2 119.05
Truck Maintenance TZA 3 9 178.57
Workshop supporting Ranger 3 6 119.05
Heavy Eq Trans Low Boy 1 2 119.05
Sum of Work Shop investment
Engineering Mine Plan
Transport Power Ranger 2 3 119.05
Warehouse
Jakarta Office
Driver Vehicle Kijang 2 2 119.05
Logistic Transport Taft 1 1 119.05
Sum Of Cost
39,242.70
Rupiah 364,957,149.74
Yearly 4,379,485,796.86
KEMBANG JANGGUT COAL AREA
Preliminary Feasibility Study
Management and Supevising Salary Scale
Tax, Health
Posisi Orang Gaji Pokok Tunjangan Asuransi
& Safety
Benefits
Bonus Tahunan Bonus Harian Total
Management Direktur Utama 1 ### ### ### ### ### ### Rp 12,500,000.00 Rp 340,000,000.00
Direktur Operasi 1 ### ### ### ### ### ### Rp 12,500,000.00 Rp 340,000,000.00
## Monthly Salary and Wages Real Plan at 1.000.000 MTA Company Strategy Cost
Monthlly Rupiah
Yearly Rp 30,175,420,000.00
Meals Cost
Management Position Num Of Pers Meals unit Price (IDR) Duration Company Cost Monthly
President Director 1
Operation Director 1
Traveling Expenses
Management Position Num Of Pers Travel Expenses Duration/Month Company Cost /Month
President Director 1 Rp 10,000,000.00 1 Rp 10,000,000.00
Operation Director 1 Rp 10,000,000.00 2 Rp 20,000,000.00
Owning Cost
1.a.Delivered Price(incl.Attachment) 660,000 450,000 441,000 735,000 360,000 300,000
b. Less Tire replacement cost if desired
c.Delivered Price less tire 660,000 450,000 441,000 735,000 360,000 300,000
3. a.Value to be recovered through work 660,000 450,000 441,000 735,000 360,000 300,000
Period Of Recovered (month) 36 36 36 36 36 36
Monthly Interest 0.0167 0.0167 0.0167 0.0167 0.0167 0.0167
Insurance Monthly 0.0010 0.0010 0.0010 0.0010 0.0010 0.0010
Property Tax Monthly 0.0017 0.0017 0.0017 0.0017 0.0017 0.0017
Interest,Insurance and Tax Rate 0.0194 0.0194 0.0194 0.0194 0.0194 0.0194
Factor 1 0.0387 0.0387 0.0387 0.0387 0.0387 0.0387
Factor 2 0.9954 0.9954 0.9954 0.9954 0.9954 0.9954
Capital Recovery Factor 1 0.0388 0.0388 0.0388 0.0388 0.0388 0.0388
Repair Reserve
Extended life Multiplier 1 1 1 1 1 1
Basic Repair Factor 17.5 12.5 10 14 10 8.5
Repair Cost per hour 17.5 12.5 10 14 10 8.5
O&O Cost per month 39,946.902 28,426.26 28,784.95 45,351.80 22,518.80 18,545.52
Sum of Equipment in Operation 3 1 14 8 2
KEMBANG JANGGUT COAL AREA
Preliminary Feasibility Study
Owning And Operating Cost Heavy Equipment
1US$ to Rp(sell) 9300 9300 9300 9300 9300 9300 9300 9300 9300
Machine Designation D 375 A D 155 A D 85 Ess D 65 P EX 1250 PC.400 PC.200 WA 320 CWB 520 ldn
Estimated Ownership Period(years) 6 6 6 6 6 6 6 6 6
Estimated Usage (hours/year) 4800 4800 4800 4800 4,800 4800 4800 4800 4800
Ownership usage (total hours) 28800 28800 28800 28800 28,800 28800 28800 28800 28800
Owning Cost
1.a.Delivered Price(incl.Attachment) 495,000 346,500 160,600 160,600 660,000 143,000 91,300 123,000 67096.774194
b. Less Tire replacement cost if desired
c.Delivered Price less tire 495,000 346,500 160,600 160,600 660,000 143,000 91,300 123,000 67096.774194
3. a.Value to be recovered through work 495,000 346,500 160,600 160,600 660,000 143,000 91,300 123,000 67096.774194
Period Of Recovered (month) 36.00 36.00 36.00 36.00 36 36.00 36.00 36.00 36.00
Monthly Interest 0.0142 0.0142 0.0142 0.0142 0.0142 0.0142 0.0142 0.0142 0.0141666667
Insurance Monthly 0.0010 0.0010 0.0010 0.0010 0.0010 0.0010 0.0010 0.0010 0.0010416667
Property Tax Monthly 0.0017 0.0017 0.0017 0.0017 0.0017 0.0017 0.0017 0.0017 0.0016666667
Interest,Insurance and Tax Rate 0.0169 0.0169 0.0169 0.0169 0.0169 0.0169 0.0169 0.0169 0.016875
Factor 1 0.0308 0.0308 0.0308 0.0308 0.0308 0.0308 0.0308 0.0308 0.0308230997
Factor 2 0.8266 0.8266 0.8266 0.8266 0.8266 0.8266 0.8266 0.8266 0.8265540587
Capital Recovery Factor 1 0.0373 0.0373 0.0373 0.0373 0.0373 0.0373 0.0373 0.0373 0.0372910875
Period Of Recovered (month) alt 2 60 60 60 60 60 60 60 60 60
Factor 0.0461 0.0461 0.0461 0.0461 0.0461 0.0461 0.0461 0.0461 0.0461
Factor 1.7293 1.7293 1.7293 1.7293 1.7293 1.7293 1.7293 1.7293 1.7293
Capital Recovery Factor 2 0.0266 0.0266 0.0266 0.0266 0.0266 0.0266 0.0266 0.0266 0.0266
Installment 80% of Investment ### ### ### ### 528,000.000 ### ### ### 53,677.419
Installment Monthly Bases 14,767.271 10,337.089 4,791.159 4,791.159 19,689.694 4,266.100 2,723.741 3,669.443 2,001.689
Instalment 20% of Investment 99,000.000 69,300.000 ### 32,120.000 132,000.000 ### ### ### 13,419.355
Mothly Installment 2,636.68 1,845.68 855.46 855.46 3,515.580 761.71 486.32 655.18 357.40
Monthly Instalment( for 36 Month period) 17,403.96 12,182.77 5,646.62 5,646.62 23,205.274 5,027.81 3,210.06 4,324.62 2,359.09
Operating Cost D 375 A D 155 A D 85 Ess D 65 P 0 PC.400 PC.200 WA 320 CWB 520 ldn
1. Fuel
Unit Price/litre 0.246 0.246 0.246 0.246 0.246 0.246 0.246 0.246 0.246
Fuel Consumed(Us$) 86 45 35 35 55 30 20 20 15
Fuel Cost($) 21.16 11.07 8.61 8.61 13.53 7.38 4.92 4.92 3.69
2. Lube,Oil,Filter and Grease
Engine Consumed/hour 0.21 0.08 0.08 0.08 0.11 0.15 0.05 0.12 0.09
Unit Price/litre 2.69 2.69 2.69 2.69 2.69 2.69 2.69 2.69 2.69
Cost per hour 0.56 0.22 0.22 0.22 0.30 0.40 0.13 0.32 0.24
Transmission Consumed /hour 0.15 0.06 0.05 0.05 0.05 0.12 0.01 0.04 0.01
Unit Price/litre 2.69 2.69 2.69 2.69 2.69 2.69 2.69 2.69 2.69
Cost per hour 0.40 0.16 0.13 0.13 0.13 0.32 0.02 0.11 0.02
Final Drive Consumed 0.07 0.12 0.06 0.01 0.02 0.08 0.01 0.03 0.09
Unit Price/litre 2.69 2.69 2.69 2.69 2.69 2.69 2.69 2.69 2.69
Cost per hour 0.19 0.32 0.16 0.18 0.06 0.22 0.01 0.08 0.23
Hydraulic Consumend/hour 0.06 0.05 0.03 0.06 0.14 0.09 0.03 0.06 0.04
Unit Price/litre 2.69 2.69 2.69 2.69 2.69 2.69 2.69 2.69 2.69
Cost per hour 0.16 0.13 0.08 0.09 0.38 0.24 0.08 0.16 0.11
Grease consumed(kg) 0.20 0.03 0.02 0.12 0.18 0.02 0.07 0.01 0.01
Price/Kg 3.23 3.23 3.23 3.23 3.23 3.23 3.23 3.23 3.23
Cost per hour 0.65 0.10 0.06 0.07 0.58 0.06 0.23 0.03 0.03
Filter Cost 0.98 0.47 0.33 0.34 0.72 0.62 0.24 0.35 0.32
Lube,Oil,Grease and Filter Cost 2.94 1.40 0.98 1.03 2.17 1.87 0.71 1.06 0.95
Repair Reserve
Extended life Multiplier 1.1 1.1 1.1 1.1 1 1 1.1 1 1
Basic Repair Factor 12.5 10 5 7 17.5 7 6 7 2
Repair Cost per hour 13.75 11.00 5.50 7.70 17.5 7.00 6.60 7.00 2.00
Bucket Teeth
Bucket Teeth Price 250 250 250 250 250.00 0 0 0 0
Life 4,000 4,000 4,000 4,000 4,000.00 4000 4,000 4000 4000
Cost perhour 0.063 0.063 0.063 0.063 0.06 0 0.000 0 0
Excavator Stick repair
Excavator Stick repair Price 6,000 0 0 0 6,000.00 0 0 0 0
Life 12,000 12,000 12,000 8,000 15,000.00 12,000 12,000 12000 12000
Excavator Stick Repair Cost 0.500 0.000 0.000 0.000 0.40 0.000 0.000 0.000 0.000
Spacial Wear Item Cost 0.896 0.396 0.396 0.396 0.80 0.000 0.000 0.000 0.000
Operating Cost 43.302 27.566 17.506 21.506 35.666 19.713 13.560 13.920 8.157
Mothly Working Hours 416 333 333 416 416 350 416 333 333
Monthly Operating Cost 18,013.56 9,188.61 5,829.44 8,946.43 14,836.99 6,899.67 5,640.96 4,640.00 2,718.89
Total Owning +Operating Cost 35,417.52 21,371.38 11,476.06 14,593.04 38,042.261 11,927.48 8,851.02 8,964.62 5,077.98
2 3
KEMBANG JANGGUT COAL AREA
Preliminary Feasibility Study
Rate per unit Item at KJC (500,000 MTA)
(* IDR)
Monthly Cost Operator Meals Leaving
No: Mining Operation Unit Req. Qty All Cost
per Unit per Item Wages Cost Cost
Rp 30,000.00
A Clearing and Grubbing Rp 260,000.00
1 Clear and Grubbing D 155 A 1 Rp 277,827,938.73 ### Rp4,927,621.36 ### ### ###
2 Chain Saw for Three Cutting Yanmar 2 Rp 21,632,000.00 ### ### ### ### ###
Cost Of Clear and Grub ###
Cost Per Ha of Clear and Grub Rp 9,354,251.43
Cost Factor Clear and Graubbing 935.425142836599
D Coal Hauling CWB 520 LDN 4 Rp 106,649,033.50 Rp 426,596,134.00 ### ### ### Rp 654,570,574.62
Management and SPV Cost Rp 10,730,260.99
Supporting Cost Rp 4,974.82
Total Cost of Coal Hauling Rp 665,305,810.43
Cost Per Tonne of Coal Haul 15967.3394502957
E Coal Rehandling
Coal Loading 992G 0.3 Rp 116,540,049.92 Rp 38,846,683.31 ### ### ### Rp 235,101,123.92
Coal Hauling 793 6.0 Rp 106,649,033.50 Rp 639,894,201.01 ### ### ### Rp 905,082,697.70
Total Cost Rehandling Rp 1,140,183,821.62
Cost Pertonne of Rehandling 27364.4117188623
Rp 13,000.00
B Overburden Ex,Load,haul
Overburden Excavation+loading EX 1250 1 Rp 325,432,163.87
Overburden Hauling 777C 4 Rp 106,649,033.50
Dump Area Cosnst D 155 A 1 Rp 277,827,938.73
Pit Services PC200 1 Rp 115,063,297.54
Lighting Ls6000 4 Rp 7,991,841.46
Dump Leveling Bomag 1 Rp 43,660,856.05
Operating Supporting Vehicle Power Ranger 1 Rp 13,345,732.97
Overburden and Top Soil Grader GD 705 0.5 Rp 188,870,097.79
Management and Supervision
Supporting Cost
Non Blast O.B Removal Cost
Cost OB Removal / BCM
E Coal Rehandling
Coal Loading 992G 0.7 Rp 116,540,049.92
Coal Hauling 793 12.0 Rp 106,649,033.50
Total Cost Rehandling
Cost Pertonne of Rehandling
Rp 166,666.67
Rp 211,569,644.48 ### ### ### ###
Rp 426,596,134.00 ### ### ### ###
Rp 277,827,938.73 Rp 9,855,242.71 ### ### ###
Rp 115,063,297.54 ### ### ### ###
Rp 31,967,365.84 Rp 31,967,365.84
Rp 43,660,856.05 ### ### ### Rp 78,916,354.01
Rp 13,345,732.97 Rp - ### Rp - Rp 15,685,732.97
Rp 94,435,048.90 ### ### ### ###
Rp 21,460,521.99
Rp 9,949.64
###
Rp 9,757.35
Rp 83,333.33
Rp 465,171,564.35 ### ### ### ###
Rp 138,913,969.36 ### ### ### ###
Rp 94,435,048.90 ### ### ### ###
Rp 21,460,521.99
Rp 9,949.64
###
Rp 9,556.34
Rp 13,000.00
Rp 629,372,700.80
Cost Pertonne Rupiah Barge ###
Transhipme 3 21,250.00
Total Cost ###
B Overburden Ex,Load,haul
Overburden Excavation+loading EX 1250 2 Rp 325,432,163.87
Overburden Hauling 777C 6 Rp 106,649,033.50
Dump Area Cosnst D 155 A 2 Rp 277,827,938.73
Pit Services PC200 2 Rp 115,063,297.54
Lighting Ls6000 4 Rp 7,991,841.46
Dump Leveling Bomag 1 Rp 43,660,856.05
Operating Supporting Vehicle Power Ranger 1 Rp 13,345,732.97
Overburden and Top Soil Grader GD 705 0.5 Rp 188,870,097.79
Management and Supervision
Supporting Cost
Non Blast O.B Removal Cost
Cost OB Removal / BCM
E Coal Rehandling
Coal Loading 992G 1.0 Rp 116,540,049.92
Coal Hauling 793 18.0 Rp 106,649,033.50
Total Cost Rehandling
Cost Pertonne of Rehandling
Rp 10,000.00
Rp 637,128,978.74
(IDR)
All Cost
Rp 30,000.00
Rp 20.00
Rp 165,514,436.70
Rp 76,338,319.51
Rp 241,852,756.21
Rp 12,092,637.81
Rp 604.63
Rp 250,000.00
Rp 696,589,386.90
Rp 803,752,916.07
Rp 593,266,120.17
Rp 298,646,182.07
Rp 31,967,365.84
Rp 78,916,354.01
Rp 15,685,732.97
Rp 131,413,758.57
Rp 32,190,782.98
Rp 14,924.46
Rp 2,682,443,524.03
Rp 10,729.77
Rp 125,000.00
Rp 642,916,651.86
Rp 165,137,330.36
Rp 121,894,403.73
Rp 32,190,782.98
Rp 14,924.46
Rp 962,154,093.39
Rp 7,697.23
Rp 1,507,762,842.62
Rp 32,190,782.98
Rp 14,924.46
Rp 1,539,968,550.06
Rp 12,319.75
Rp 312,794,490.53
Rp 2,184,871,099.71
Rp 2,497,665,590.24
Rp 19,981.32
Rp 97,954,296.50
Rp 250,000.00
Rp 32,190,782.98
Rp 14,924.46
Rp 130,410,003.94
Rp 1,043.28
10,000.00
###
###
KEMBANG JANGGUT COAL AREA
Preliminary Feasibility Study
Rate per unit Item at AKM (1,500,000 MTA)
(* US$)
Monthly Cost Operator Meals Leaving
No: Mining Operation Unit Req. Qty All Cost
per Unit per Item Wages Cost Cost
30000
A Clearing and Grubbing 20
1 Clear and Grubbing D 155 A 1 21,371.38 11,062.83 379.05 540 750 12,731.88
2 Chain Saw for Three Cutting Yanmar 2 1,664.00 3,328.00 964.18 1080 500 5,872.18
Cost Of Clear and Grub 18,604.06
Cost Per Ha of Clear and Grub 930.203
Cost Factor Clear and Graubbing 0.052
D Coal Hauling CWB 520 LD 10 4,912.84 49,128.42 12,961.50 2,700.00 1,875.00 66,664.92
Management and SPV Cost ###
Supporting Cost ###
Total Cost of Coal Hauling ###
Cost Per Tonne of Coal Haul 2,917.686
1 US$ = Rp9,300
D Coal Hauling CWB 520 LD 15 4,912.84 73,692.63 12,961.50 2,700.00 1,875.00 91,229.13
Management and SPV Cost ###
Supporting Cost 5,520,360.69
Total Cost of Coal Hauling ###
Cost Per Tonne of Coal Haul 4,239.135
1 US$ = Rp13,500
B Consumable
1 Work Shop Consumed 2,500.00
2 Base Camp 2,500.00
3 Stationary and Office Tools 2,500.00
4 Others 1,000.00
C Coal Rehandling
Coal Dozing and Handling D 85ESS-2 Single Ripper 1 ### ###
Coal Loading PC 200 1 650,000,000 650,000,000
Coal Hauling Isuzu Giga FVR 34 L 240 PS 16 T 1 566,000,000 566,000,000
Total Investment of Coal Rehandling ###
No Item Equipment Eq Req Fuel Consumed Working hours Est Fuel Consumed Monthly
1 Clear and Grab D 155 A 1 45.00 200 9000
2 Chain Saw Coats Hire 4 2.00 200.00 1,600.00
3 Top Soil Removal Daewo S330LC 1 30.00 416.00 12,480.00
4 Ripping/Dozing Op D155A 1 45.00 350.00 15,750.00
5 Drill Equipment Pantera 800 1 40.00 400.00 16,000.00
6 Overburden Removal EX.1250 1 55.00 416.00 22,880.00
7 O & K R30F 1 45.00 416.00 18,720.00
8 HD 465 3 55.00 416.00 68,640.00
9 Volvo BM A35 2 28.00 416.00 23,296.00
10 Coal Extraction/Cleaning SK.200 1 20.00 300.00 6,000.00
11 Coal Loading WA 500 1 36.00 300.00 10,800.00
12 Coal Hauling 8*4 Truck 3 20.00 300.00 18,000.00
Anfo Truck Dina 15 ton 1 15.00 150.00 2,250.00
13 Grading GD 705 1 24.00 200.00 4,800.00
14 Lighting P130M 2 41.50 720.00 59,760.00
Total Fuel Consumed 289,976.00
Fuel Consumed For Others Purposes 5,400.00
Total Fuel Consumed 295,376.00
Fuel Price 0.60
Monthly Fuel Cost 177,225.60
Preliminary Feasibility Study
No Item Equipment Eq Req Operator Require Salary + Benefits Salary + Wages Meals Cost Travel R & D Cost
1 Clear and Grab D 155 A 1 2 348.46 696.91 270.00 250.00
2 Chain Saw Coats Hire 2 2 348.46 696.91 270.00 250.00
3 Top Soil Removal Daewo S330LC 1 3 348.46 1,045.37 405.00 375.00
4 Ripping/Dozing Op D155A 1 3 348.46 1,045.37 405.00 375.00
5 Drill Equipment Pantera 800 1 3 348.46 1,045.37 405.00 375.00
6 Overburden Removal PC.1250 2 5 348.46 1,742.28 675.00 625.00
7 O & K R30F 0 0 348.46 0.00 0.00 0.00
8 HD 465 6 14 348.46 4,878.39 1,890.00 1,750.00
9 Volvo BM A35 0 6 348.46 2,090.74 810.00 750.00
10 Coal Extraction/Cleaning SK.200 1 3 348.46 1,045.37 405.00 375.00
11 Coal Loading PC.300 (Sbomm) 1 3 348.46 1,045.37 405.00 375.00
12 Coal Hauling CWB 520 LDN 20 45 348.46 15,680.53 6,075.00 5,625.00
13 Anfo Truck Dina 15 ton 5 14 348.46 4,878.39 1,890.00 1,750.00
14 Grading GD 705 2 3 348.46 1,045.37 405.00 375.00
15 Direct Cost of The Operator 14,310.00 13,250.00
Total Cost of Operator 43 106 348.46 36,936.36 64,496.36
Cash Balance 0.00 ### ### -2,843,312.04 ### ### -3,710,914,498.61 ### ### ### ### ### -4,899,017,736.77 ### ### ### ### -6,094,394,486.77 ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ###
Interest of Loan -547,945,920.92 -581,167,073.56 -616,167,134.36 ### ### -755,242,543.62 ### ### -918,493,696.89 ### ### ### ### -301,646,447.20 ### ### ### ### ### ### ### ### -294,952,929.85 ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ###
Cumulative Cash Position ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ###
Month Progress 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60
Break Event Position(month) 20
Interest Floating US $ 14%
Exchange Rate Rp/1US $ 8,500 NPV,IRR AND BEP ANALISYS
1st Year 2nd Year 3rd Year 4th Year 5th Year
Tax Rate 30% 30% 30% 30% 30%
EBT ### ### ### ### -32528777599
*** Coal Price Free On Barge Tax ### ### ### ### ###
EAT ### ### ### ### ###
Cash Flow ### ### ### ### ### ###
NPV ###
IRR Err:523
BEP(Year) 1.67
Preliminary Feasibility Study
Funding Flow During The Project
1st YEAR
DESCRIPTION
Jan Feb Mar Apr May Jun Jul Aug Sept Oct Nov Dec Jan
Production (Ton ROM) 0 0 0 0 0 0 0 0 20,000 20,000 20,000 20,000 40,000
Cash In Flow
Price per unit FOB Barge 22.00 22.00 22.00 22.00 22.00 22.00 22.00 22.00 22.00 22.00 22.00 22.00 22.00
Revenue From Mine Opera 0 0 0 0 0 0 0 0 440,090 440,090 440,090 440,090 880,180
Injection Of share Holder 14,126,750 4,681,250 3,161,250 1,551,250
Total Cash Inflow 14,126,750 4,681,250 3,161,250 1,551,250 0 0 0 0 440,090 440,090 440,090 440,090 880,180
Cumulative Cash Inflow ### 21,969,250 ### 23,520,500 23,520,500 23,520,500 23,520,500 23,960,590 ### 24,840,770 25,280,860 26,161,040
Cash Balance 0 -82,406 -109,713 -128,154 -137,203 -137,203 -162,203 -162,203 -595,836 -147,212 -62,212 -62,212 322,063
Interest of Loan -61,900 -63,544 -64,071 -64,387 -64,703
Cumulative Cash Position -14,126,750 ### ### ### ### ### ### ### ### ### ### ### ###
Month Progress 1 2 3 4 5 6 7 8 9 10 11 12 13
2nd YEAR
DESCRIPTION
Feb Mar Apr May Jun Jul Aug Sept Oct Nov Dec Jan Feb Mar
Production (Ton ROM) 40,000 40,000 80,000 80,000 80,000 100,000 100,000 100,000 100,000 100,000 100,000 150,000 150,000 150,000
Cash In Flow
Price per unit FOB Barge 22.00 22.00 22.00 22.00 22.00 22.00 22.00 22.00 22.00 22.00 22.00 22.00 22.00 22.00
Revenue From Mine Opera 880,180 880,180 1,760,360 1,760,360 1,760,360 2,200,450 2,200,450 2,200,450 2,200,450 2,200,450 2,200,450 3,300,675 3,300,675 3,300,675
Injection Of share Holder
Total Cash Inflow 880,180 880,180 1,760,360 1,760,360 1,760,360 2,200,450 2,200,450 2,200,450 2,200,450 2,200,450 2,200,450 3,300,675 3,300,675 3,300,675
Cumulative Cash Inflow ### 27,921,400 29,681,760 31,442,120 33,202,480 35,402,930 37,603,380 39,803,830 42,004,280 44,204,730 ### 49,705,855 53,006,530 56,307,205
Cash Balance 322,063 322,063 855,537 940,537 940,537 1,282,414 1,282,414 748,790 1,197,414 1,282,414 1,282,414 2,194,483 2,194,483 2,194,483
Interest of Loan -64,060 -63,415 -62,768 -60,786 -58,587 -56,382 -53,317 -50,244 -48,498 -45,625 -42,533 -39,434 -34,046 -28,645
Cumulative Cash Position ### ### ### ### ### ### ### ### ### ### ### ### ### -9,292,160
Month Progress 14 15 16 17 18 19 20 21 22 23 24 25 26 27
Cash Balance 2,109,483 2,194,483 2,194,483 3,023,718 3,023,718 2,490,094 2,938,718 3,023,718 3,023,718 3,852,954 3,852,954 3,852,954 3,767,954 3,852,954
Interest of Loan -23,230 -18,015 -12,574 -7,119 423 7,983 14,228 21,611 29,224 36,856 46,581 56,330 66,103 75,688
Cumulative Cash Position -7,205,908 -5,029,440 -2,847,530 169,069 3,193,210 5,691,287 8,644,234 ### ### ### 22,531,851 26,441,134 30,275,191 34,203,833
Month Progress 28 29 30 31 32 33 34 35 36 37 38 39 40 41
Cash Balance 3,852,954 3,852,954 4,008,975 3,475,350 3,923,975 4,008,975 4,008,975 4,008,975 4,008,975 4,008,975 3,923,975 4,008,975 4,008,975
Interest of Loan 85,510 95,356 105,227 115,512 124,489 134,610 144,969 155,354 165,765 176,202 186,665 196,941 207,456
Cumulative Cash Position 38,142,297 42,090,607 46,204,808 49,795,670 53,844,135 57,987,720 62,141,664 66,305,993 70,480,733 74,665,910 78,776,549 82,982,466 87,198,897
Month Progress 42 43 44 45 46 47 48 49 50 51 52 53 54
NPV
IRR
BEP(Year)
5th YEAR
DESCRIPTION
Jul Aug Sept Oct Nov Dec
Production (Ton ROM) 250,000 250,000 250,000 250,000 250,000 250,000
Cash In Flow
Price per unit FOB Barge 22.00 22.00 22.00 22.00 22.00 22.00
Revenue From Mine Opera 5,501,125 5,501,125 5,501,125 5,501,125 5,501,125 5,501,125
Injection Of share Holder
Total Cash Inflow 5,501,125 5,501,125 5,501,125 5,501,125 5,501,125 5,501,125
Cumulative Cash Inflow ### ### ### ### ### ###
28,704,341
40.39%
3.67
1st YEAR
DESCRIPTION
Jan Feb Mar Apr May Jun Jul Aug Sept Oct Nov Dec Jan
Production (Ton ROM) 0 0 0 0 0 0 0 0 20,000 20,000 20,000 20,000 40,000
Cash In Flow
Price per unit FOB Barge 17.00 17.00 17.00 17.00 17.00 17.00 17.00 17.00 17.00 17.00 17.00 17.00 17.00
Revenue From Mine Operation 0 0 0 0 0 0 0 0 340,000 340,000 340,000 340,000 680,000
Injection Of share Holder 33,549,500,000 15,825,750,000 4,713,562,500 459,390,625
Total Cash Inflow 33,549,500,000 15,825,750,000 4,713,562,500 459,390,625 0 0 0 0 340,000 340,000 340,000 340,000 680,000
Cumulative Cash Inflow 49,375,250,000 54,088,812,500 54,548,203,125 54,548,203,125 54,548,203,125 54,548,203,125 54,548,203,125 54,548,543,125 54,548,883,125 54,549,223,125 54,549,563,125 54,550,243,125
2nd YEAR
DESCRIPTION
Feb Mar Apr May Jun Jul Aug Sept Oct Nov Dec Jan Feb Mar
Production (Ton ROM) 40,000 40,000 80,000 80,000 80,000 100,000 100,000 100,000 100,000 100,000 100,000 150,000 150,000 150,000
Cash In Flow
Price per unit FOB Barge 17.00 17.00 17.00 17.00 17.00 17.00 17.00 17.00 17.00 17.00 17.00 17.00 17.00 17.00
Revenue From Mine Operation 680,000 680,000 1,360,000 1,360,000 1,360,000 1,700,000 1,700,000 1,700,000 1,700,000 1,700,000 1,700,000 2,550,000 2,550,000 2,550,000
Injection Of share Holder
Total Cash Inflow 680,000 680,000 1,360,000 1,360,000 1,360,000 1,700,000 1,700,000 1,700,000 1,700,000 1,700,000 1,700,000 2,550,000 2,550,000 2,550,000
Cumulative Cash Inflow 54,550,923,125 54,551,603,125 54,552,963,125 54,554,323,125 54,555,683,125 54,557,383,125 54,559,083,125 54,560,783,125 54,562,483,125 54,564,183,125 54,565,883,125 54,568,433,125 54,570,983,125 54,573,533,125
Cash Balance -3,007,936,899 -3,007,936,899 -5,498,269,242 -5,498,184,242 -5,498,184,242 -6,725,957,854 -6,725,957,854 -7,921,309,604 -6,726,042,854 -6,725,957,854 -6,725,957,854 -10,018,772,317 -10,018,772,317 ###
Interest of Loan -176,509,706 -184,470,823 -192,451,842 -206,678,645 -220,940,802 -235,238,615 -252,641,606 -270,088,104 -290,566,599 -308,108,122 -325,693,287 -343,322,415 -369,227,652 -395,197,652
Cumulative Cash Position ### -76,980,736,822 -82,671,457,906 -88,376,320,793 -94,095,445,837 ### ### ### ### ### ### ### ### ###
Month Progress 14 15 16 17 18 19 20 21 22 23 24 25 26 27
Cummulative Prod.:
☻Coal Price Free on Barge Basis: 17.00 US$ per Ton
Cash Balance ### ### ### -13,203,442,211 ### ### ### ### ### ### ### ### ### ###
Interest of Loan -421,232,577 -447,332,802 -473,498,064 -499,728,740 -533,986,668 -568,330,240 -605,748,050 -640,271,238 -674,880,522 -709,576,329 -752,320,550 -795,171,632 -838,129,841 -881,195,658
Cumulative Cash Position ### ### ### ### ### ### ### ### ### ### ### ### ### ###
Month Progress 28 29 30 31 32 33 34 35 36 37 38 39 40 41
Cash Balance -16,388,112,104 -16,388,112,104 -16,241,547,320 ### -16,241,632,320 -16,241,547,320 -16,241,547,320 -16,241,547,320 -16,241,547,320 -16,241,547,320 -16,241,632,320 -16,241,547,320 -16,241,547,320 -16,241,547,320
Interest of Loan -924,368,928 -967,650,130 -1,011,039,536 -1,054,171,003 -1,100,398,678 -1,143,753,756 -1,187,217,008 -1,230,788,919 -1,274,469,760 -1,318,259,803 -1,362,159,320 -1,406,168,799 -1,450,288,090 -1,494,517,678
Cumulative Cash Position ### ### ### ### ### ### ### ### ### ### ### ### ### ###
Month Progress 42 43 44 45 46 47 48 49 50 51 52 53 54 55
NP
0th Year
Tax Rate
EBT
Tax
EAT
Cash Flow -76,980,736,822
NPV ###
IRR Err:523
BEP(Year) 3.50
5th YEAR
DESCRIPTION
Aug Sept Oct Nov Dec
Production (Ton ROM) 250,000 250,000 250,000 250,000 250,000
Cash In Flow
Price per unit FOB Barge 17.00 17.00 17.00 17.00 17.00
Revenue From Mine Operation 4,250,000 4,250,000 4,250,000 4,250,000 4,250,000
Injection Of share Holder
Total Cash Inflow 4,250,000 4,250,000 4,250,000 4,250,000 4,250,000
Cumulative Cash Inflow 54,686,583,125 54,690,833,125 54,695,083,125 54,699,333,125 54,703,583,125
1,571,287
14.84
1st YEAR
DESCRIPTION
Jan Feb Mar Apr May Jun Jul Aug Sept Oct Nov Dec Jan Feb
Production (Ton ROM) 0 0 0 0 0 0 0 0 20,000 20,000 20,000 20,000 40,000 40,000
Cash In Flow
Price per unit FOB Barge 18.00 18.00 18.00 18.00 18.00 18.00 18.00 18.00 18.00 18.00 18.00 18.00 18.00 18.00
Revenue From Mine Operation 0 0 0 0 0 0 0 0 360,000 360,000 360,000 360,000 720,000 720,000
Injection Of share Holder 33,549,500,000 15,825,750,000 4,713,562,500 459,390,625
Total Cash Inflow 33,549,500,000 15,825,750,000 4,713,562,500 459,390,625 0 0 0 0 360,000 360,000 360,000 360,000 720,000 720,000
Cumulative Cash Inflow 49,375,250,000 54,088,812,500 54,548,203,125 54,548,203,125 54,548,203,125 54,548,203,125 54,548,203,125 54,548,563,125 54,548,923,125 54,549,283,125 54,549,643,125 54,550,363,125 54,551,083,125
Cash Balance 0 -195,705,417 -288,022,292 -315,518,073 -318,197,852 -318,197,852 -318,222,852 -318,222,852 -3,244,400,958 -2,049,134,208 -2,049,049,208 -2,049,049,208 -3,007,896,899 -3,007,896,899
Interest of Loan -143,548,840 -152,018,715 -157,521,597 -163,038,024 -168,568,242 -176,509,405
Cumulative Cash Position -33,549,500,000 ### -55,056,267,917 ### -56,464,892,539 -56,783,090,391 -57,101,313,242 -57,419,536,094 -60,807,485,892 ### -65,215,209,620 -67,427,296,852 -70,603,761,994 ###
Month Progress 1 2 3 4 5 6 7 8 9 10 11 12 13 14
2nd YEAR
DESCRIPTION
Mar Apr May Jun Jul Aug Sept Oct Nov Dec Jan Feb Mar Apr
Production (Ton ROM) 40,000 80,000 80,000 80,000 100,000 100,000 100,000 100,000 100,000 100,000 150,000 150,000 150,000 150,000
Cash In Flow
Price per unit FOB Barge 18.00 18.00 18.00 18.00 18.00 18.00 18.00 18.00 18.00 18.00 18.00 18.00 18.00 18.00
Revenue From Mine Operation 720,000 1,440,000 1,440,000 1,440,000 1,800,000 1,800,000 1,800,000 1,800,000 1,800,000 1,800,000 2,700,000 2,700,000 2,700,000 2,700,000
Injection Of share Holder
Total Cash Inflow 720,000 1,440,000 1,440,000 1,440,000 1,800,000 1,800,000 1,800,000 1,800,000 1,800,000 1,800,000 2,700,000 2,700,000 2,700,000 2,700,000
Cumulative Cash Inflow 54,551,803,125 54,553,243,125 54,554,683,125 54,556,123,125 54,557,923,125 54,559,723,125 54,561,523,125 54,563,323,125 54,565,123,125 54,566,923,125 54,569,623,125 54,572,323,125 54,575,023,125 54,577,723,125
Cash Balance -3,007,896,899 -5,498,189,242 -5,498,104,242 -5,498,104,242 -6,725,857,854 -6,725,857,854 -7,921,209,604 -6,725,942,854 -6,725,857,854 -6,725,857,854 -10,018,622,317 -10,018,622,317 -10,018,622,317 -10,018,707,317
Interest of Loan -184,470,421 -192,451,339 -206,677,940 -220,939,896 -235,237,506 -252,640,245 -270,086,490 -290,564,730 -308,105,999 -325,690,909 -343,319,781 -369,224,636 -395,194,253 -421,228,795
Cumulative Cash Position -76,980,535,618 -82,671,176,199 -88,375,958,381 -94,095,002,519 ### ### ### -123,242,399,655 ### ### ### ### ### ###
Month Progress 15 16 17 18 19 20 21 22 23 24 25 26 27 28
Cash Balance -10,018,622,317 -10,018,622,317 ### -13,203,242,211 ### -13,203,327,211 ### ### ### ### ### ### -16,387,862,104 -16,387,862,104
Interest of Loan -447,328,635 -473,493,512 -499,723,802 -533,981,217 -568,324,276 -605,741,571 -640,264,243 -674,873,009 -709,568,297 -752,311,873 -795,162,308 -838,119,869 -881,185,037 -924,357,655
Cumulative Cash Position ### ### ### ### ### ### ### ### ### ### ### ### -369,743,061,821 ###
Month Progress 29 30 31 32 33 34 35 36 37 38 39 40 41 42
☻Coal Price Free on Barge Basis: 18.00 US$ per Ton ☻Coal Price Free on Barge Bas
Cash Balance -16,387,862,104 -16,241,297,320 ### -16,241,382,320 -16,241,297,320 -16,241,297,320 -16,241,297,320 -16,241,297,320 -16,241,297,320 -16,241,382,320 -16,241,297,320 -16,241,297,320 -16,241,297,320 -16,241,297,320
Interest of Loan -967,638,204 -1,011,026,955 -1,054,157,765 -1,100,384,782 -1,143,739,200 -1,187,201,792 -1,230,773,039 -1,274,453,215 -1,318,242,592 -1,362,141,441 -1,406,150,251 -1,450,268,870 -1,494,497,785 -1,538,837,273
Cumulative Cash Position ### ### ### ### ### ### ### ### ### ### ### ### ### ###
Month Progress 43 44 45 46 47 48 49 50 51 52 53 54 55 56
NPV ###
IRR Err:523
BEP(Year) 3.33
5th YEAR
DESCRIPTION
Sept Oct Nov Dec
Production (Ton ROM) 250,000 250,000 250,000 250,000
Cash In Flow
Price per unit FOB Barge 18.00 18.00 18.00 18.00
Revenue From Mine Operation 4,500,000 4,500,000 4,500,000 4,500,000
Injection Of share Holder
Total Cash Inflow 4,500,000 4,500,000 4,500,000 4,500,000
Cumulative Cash Inflow 54,699,223,125 54,703,723,125 54,708,223,125 54,712,723,125
1st YEAR
DESCRIPTION
Jan Feb Mar Apr May Jun Jul Aug Sept Oct Nov Dec Jan Feb
Production (Ton ROM) 0 0 0 0 0 0 0 0 20,000 20,000 20,000 20,000 40,000 40,000
Cash In Flow
Price per unit FOB Barge 19.00 19.00 19.00 19.00 19.00 19.00 19.00 19.00 19.00 19.00 19.00 19.00 19.00 19.00
Revenue From Mine Operation 0 0 0 0 0 0 0 0 380,000 380,000 380,000 380,000 760,000 760,000
Injection Of share Holder 33,549,500,000 15,825,750,000 4,713,562,500 459,390,625
Total Cash Inflow 33,549,500,000 15,825,750,000 4,713,562,500 459,390,625 0 0 0 0 380,000 380,000 380,000 380,000 760,000 760,000
Cumulative Cash Inflow 49,375,250,000 54,088,812,500 54,548,203,125 54,548,203,125 54,548,203,125 54,548,203,125 54,548,203,125 54,548,583,125 54,548,963,125 54,549,343,125 54,549,723,125 54,550,483,125 54,551,243,125
Cash Balance 0 -195,705,417 -288,022,292 -315,518,073 -318,197,852 -318,197,852 -318,222,852 -318,222,852 -3,244,380,958 -2,049,114,208 -2,049,029,208 -2,049,029,208 -3,007,856,899 -3,007,856,899
Interest of Loan -143,548,840 -152,018,665 -157,521,497 -163,037,874 -168,568,041 -176,509,104
Cumulative Cash Position -33,549,500,000 ### -55,056,267,917 ### -56,464,892,539 -56,783,090,391 -57,101,313,242 -57,419,536,094 -60,807,465,892 ### -65,215,149,470 -67,427,216,552 -70,603,641,492 ###
Month Progress 1 2 3 4 5 6 7 8 9 10 11 12 13 14
2nd YEAR 3
DESCRIPTION
Mar Apr May Jun Jul Aug Sept Oct Nov Dec Jan Feb Mar Apr
Production (Ton ROM) 40,000 80,000 80,000 80,000 100,000 100,000 100,000 100,000 100,000 100,000 150,000 150,000 150,000 150,000
Cash In Flow
Price per unit FOB Barge 19.00 19.00 19.00 19.00 19.00 19.00 19.00 19.00 19.00 19.00 19.00 19.00 19.00 19.00
Revenue From Mine Operation 760,000 1,520,000 1,520,000 1,520,000 1,900,000 1,900,000 1,900,000 1,900,000 1,900,000 1,900,000 2,850,000 2,850,000 2,850,000 2,850,000
Injection Of share Holder
Total Cash Inflow 760,000 1,520,000 1,520,000 1,520,000 1,900,000 1,900,000 1,900,000 1,900,000 1,900,000 1,900,000 2,850,000 2,850,000 2,850,000 2,850,000
Cumulative Cash Inflow 54,552,003,125 54,553,523,125 54,555,043,125 54,556,563,125 54,558,463,125 54,560,363,125 54,562,263,125 54,564,163,125 54,566,063,125 54,567,963,125 54,570,813,125 54,573,663,125 54,576,513,125 54,579,363,125
Cash Balance -3,007,856,899 -5,498,109,242 -5,498,024,242 -5,498,024,242 -6,725,757,854 -6,725,757,854 -7,921,109,604 -6,725,842,854 -6,725,757,854 -6,725,757,854 -10,018,472,317 -10,018,472,317 -10,018,472,317 -10,018,557,317
Interest of Loan -184,470,019 -192,450,836 -206,677,236 -220,938,990 -235,236,398 -252,638,884 -270,084,875 -290,562,862 -308,103,876 -325,688,530 -343,317,146 -369,221,620 -395,190,855 -421,225,013
Cumulative Cash Position -76,980,334,413 -82,670,894,491 -88,375,595,970 -94,094,559,202 ### ### ### -123,241,550,385 ### ### ### ### ### ###
Month Progress 15 16 17 18 19 20 21 22 23 24 25 26 27 28
Cash Balance -10,018,472,317 -10,018,472,317 ### -13,203,042,211 ### -13,203,127,211 ### ### ### ### ### ### -16,387,612,104 -16,387,612,104
Interest of Loan -447,324,468 -473,488,960 -499,718,864 -533,975,766 -568,318,311 -605,735,092 -640,257,248 -674,865,496 -709,560,266 -752,303,197 -795,152,985 -838,109,898 -881,174,415 -924,346,381
Cumulative Cash Position ### ### ### ### ### ### ### ### ### ### ### ### -369,738,552,534 ###
Month Progress 29 30 31 32 33 34 35 36 37 38 39 40 41 42
☻Coal Price Free on Barge Basis: 19.00 US$ per Ton ☻Coal Price Free on Barge Basis
Cash Balance -16,387,612,104 -16,241,047,320 ### -16,241,132,320 -16,241,047,320 -16,241,047,320 -16,241,047,320 -16,241,047,320 -16,241,047,320 -16,241,132,320 -16,241,047,320 -16,241,047,320 -16,241,047,320 -16,241,047,320
Interest of Loan -967,626,278 -1,011,014,374 -1,054,144,528 -1,100,370,887 -1,143,724,645 -1,187,186,575 -1,230,757,159 -1,274,436,671 -1,318,225,381 -1,362,123,562 -1,406,131,702 -1,450,249,650 -1,494,477,892 -1,538,816,705
Cumulative Cash Position ### ### ### ### ### ### ### ### ### ### ### ### ### ###
Month Progress 43 44 45 46 47 48 49 50 51 52 53 54 55 56
NPV ###
IRR Err:523
BEP(Year) 3.17
5th YEAR
DESCRIPTION
Sept Oct Nov Dec
Production (Ton ROM) 250,000 250,000 250,000 250,000
Cash In Flow
Price per unit FOB Barge 19.00 19.00 19.00 19.00
Revenue From Mine Operation 4,750,000 4,750,000 4,750,000 4,750,000
Injection Of share Holder
Total Cash Inflow 4,750,000 4,750,000 4,750,000 4,750,000
Cumulative Cash Inflow 54,707,613,125 54,712,363,125 54,717,113,125 54,721,863,125
1st YEAR
DESCRIPTION
Jan Feb Mar Apr May Jun Jul Aug Sept Oct Nov Dec Jan Feb
Production (Ton ROM) 0 0 0 0 0 0 0 0 20,000 20,000 20,000 20,000 40,000 40,000
Cash In Flow
Price per unit FOB Barge 20.00 20.00 20.00 20.00 20.00 20.00 20.00 20.00 20.00 20.00 20.00 20.00 20.00 20.00
Revenue From Mine Operation 0 0 0 0 0 0 0 0 400,000 400,000 400,000 400,000 800,000 800,000
Injection Of share Holder 33,549,500,000 15,825,750,000 4,713,562,500 459,390,625
Total Cash Inflow 33,549,500,000 15,825,750,000 4,713,562,500 459,390,625 0 0 0 0 400,000 400,000 400,000 400,000 800,000 800,000
Cumulative Cash Inflow 49,375,250,000 54,088,812,500 54,548,203,125 54,548,203,125 54,548,203,125 54,548,203,125 54,548,203,125 54,548,603,125 54,549,003,125 54,549,403,125 54,549,803,125 54,550,603,125 54,551,403,125
Cash Balance 0 -195,705,417 -288,022,292 -315,518,073 -318,197,852 -318,197,852 -318,222,852 -318,222,852 -3,244,360,958 -2,049,094,208 -2,049,009,208 -2,049,009,208 -3,007,816,899 -3,007,816,899
Interest of Loan -143,548,840 -152,018,615 -157,521,397 -163,037,723 -168,567,841 -176,508,802
Cumulative Cash Position -33,549,500,000 ### -55,056,267,917 ### -56,464,892,539 -56,783,090,391 -57,101,313,242 -57,419,536,094 -60,807,445,892 ### -65,215,089,320 -67,427,136,251 -70,603,520,991 ###
Month Progress 1 2 3 4 5 6 7 8 9 10 11 12 13 14
2nd YEAR
DESCRIPTION
Mar Apr May Jun Jul Aug Sept Oct Nov Dec Jan Feb Mar Apr
Production (Ton ROM) 40,000 80,000 80,000 80,000 100,000 100,000 100,000 100,000 100,000 100,000 150,000 150,000 150,000 150,000
Cash In Flow
Price per unit FOB Barge 20.00 20.00 20.00 20.00 20.00 20.00 20.00 20.00 20.00 20.00 20.00 20.00 20.00 20.00
Revenue From Mine Operation 800,000 1,600,000 1,600,000 1,600,000 2,000,000 2,000,000 2,000,000 2,000,000 2,000,000 2,000,000 3,000,000 3,000,000 3,000,000 3,000,000
Injection Of share Holder
Total Cash Inflow 800,000 1,600,000 1,600,000 1,600,000 2,000,000 2,000,000 2,000,000 2,000,000 2,000,000 2,000,000 3,000,000 3,000,000 3,000,000 3,000,000
Cumulative Cash Inflow 54,552,203,125 54,553,803,125 54,555,403,125 54,557,003,125 54,559,003,125 54,561,003,125 54,563,003,125 54,565,003,125 54,567,003,125 54,569,003,125 54,572,003,125 54,575,003,125 54,578,003,125 54,581,003,125
Cash Balance -3,007,816,899 -5,498,029,242 -5,497,944,242 -5,497,944,242 -6,725,657,854 -6,725,657,854 -7,921,009,604 -6,725,742,854 -6,725,657,854 -6,725,657,854 -10,018,322,317 -10,018,322,317 -10,018,322,317 -10,018,407,317
Interest of Loan -184,469,617 -192,450,333 -206,676,532 -220,938,084 -235,235,290 -252,637,523 -270,083,261 -290,560,993 -308,101,753 -325,686,152 -343,314,512 -369,218,604 -395,187,456 -421,221,231
Cumulative Cash Position -76,980,133,208 -82,670,612,784 -88,375,233,558 -94,094,115,884 ### ### ### -123,240,701,115 ### ### ### ### ### ###
Month Progress 15 16 17 18 19 20 21 22 23 24 25 26 27 28
Cash Balance -10,018,322,317 -10,018,322,317 ### -13,202,842,211 ### -13,202,927,211 ### ### ### ### ### -16,387,447,104 -16,387,362,104 -16,387,362,104
Interest of Loan -447,320,302 -473,484,409 -499,713,925 -533,970,316 -568,312,347 -605,728,613 -640,250,252 -674,857,983 -709,552,234 -752,294,520 -795,143,661 -838,099,926 -881,163,793 -924,335,108
Cumulative Cash Position ### ### ### ### ### ### ### ### ### ### ### ### -369,734,043,247 ###
Month Progress 29 30 31 32 33 34 35 36 37 38 39 40 41 42
☻Coal Price Free on Barge Basis: 20.00 US$ per Ton ☻Coal Price Free on Barge B
Cash Balance -16,387,362,104 -16,240,797,320 ### -16,240,882,320 -16,240,797,320 -16,240,797,320 -16,240,797,320 -16,240,797,320 -16,240,797,320 -16,240,882,320 -16,240,797,320 -16,240,797,320 -16,240,797,320 -16,240,797,320
Interest of Loan -967,614,351 -1,011,001,792 -1,054,131,290 -1,100,356,991 -1,143,710,089 -1,187,171,358 -1,230,741,279 -1,274,420,126 -1,318,208,170 -1,362,105,683 -1,406,113,153 -1,450,230,429 -1,494,457,999 -1,538,796,137
Cumulative Cash Position ### ### ### ### ### ### ### ### ### ### ### ### ### ###
Month Progress 43 44 45 46 47 48 49 50 51 52 53 54 55 56
NPV ###
IRR Err:523
BEP(Year) 3.08
5th YEAR
DESCRIPTION
Sept Oct Nov Dec
Production (Ton ROM) 250,000 250,000 250,000 250,000
Cash In Flow
Price per unit FOB Barge 20.00 20.00 20.00 20.00
Revenue From Mine Operation 5,000,000 5,000,000 5,000,000 5,000,000
Injection Of share Holder
Total Cash Inflow 5,000,000 5,000,000 5,000,000 5,000,000
Cumulative Cash Inflow 54,716,003,125 54,721,003,125 54,726,003,125 54,731,003,125