Pt. Bhumi Saprolite Indonesia Summary Financial Projection Pabrik Nickel
Pt. Bhumi Saprolite Indonesia Summary Financial Projection Pabrik Nickel
Pt. Bhumi Saprolite Indonesia Summary Financial Projection Pabrik Nickel
Pra Operation
No. Description
Pre-Op M1 Pre-Op M2 Pre-Op M3 Pre-Op M4 Pre-Op M5 Pre-Op M6 Pre-Op M7
BALANCE SHEET
I Assets:
A Current Assets:
1 Kas dan bank 6,488,800 6,631,828 5,107,366 3,582,903 2,058,441 533,979 3,395,090
2 Piutang dagang - - - - - - -
3 Persediaan Nickel Plan - high grade - - - - - - -
4 Persediaan Nickel Plan - medium grade - - - - - - -
5 Persediaan Nickel Plan - low grade - - - - - - -
Sub Total Aktiva Lancar 6,488,800 6,631,828 5,107,366 3,582,903 2,058,441 533,979 3,395,090
B Fixed Assets:
1 Site Supporting Facilities & Equipments 18,800 22,560 26,320 30,080 33,840 37,600 37,600
2 Accumulated depreciation - - - - - - -
3 Accomodation & Comm. Facilities 161,700 194,040 226,380 258,720 291,060 323,400 323,400
4 Accumulated depreciation - - - - - - -
5 Nickel Plan& Supporting Equipments 24,456,533 29,347,840 34,239,147 39,130,453 44,021,760 48,913,067 49,579,733
6 Accumulated depreciation - - - - - - -
7 Vehicles - - - - - - -
8 Accumulated depreciation - - - - - - -
9 Office equipment - - - - - - -
10 Accumulated depreciation - - - - - - -
11 Furniture - - - - - - -
12 Accumulated depreciation - - - - - - -
Sub Total Fixed Assets 24,637,033 29,564,440 34,491,847 39,419,253 44,346,660 49,274,067 49,940,733
C Other Assets:
1 Perolehan dan perijinan pabrik 624,167 749,000 873,833 998,667 1,123,500 1,248,333 1,248,333
2 Biaya pra operasi - Nickel Plan 0 0 0 0 0 0 0
3 Bunga masa konstruksi - - - - - - -
Sub Total Other Assets 624,167 749,000 873,833 998,667 1,123,500 1,248,333 1,248,333
Total Assets 31,750,000 36,945,268 40,473,046 44,000,823 47,528,601 51,056,379 54,584,157
II Liabilities:
A Current Liabilities:
1 Account payable - - - - - - -
2 Tax payable - PPh ps 29 - - - - - - -
3 Reserve for reclamation - - - - - - -
Sub Total Current Liabilities - - - - - - -
B Long Term Liabilities:
1 Working capital loan - - - - - - -
2 Investment loan - 1,684,333 1,684,333 1,684,333 1,684,333 1,684,333 1,684,333
Sub Total Long Term Liabilities - 1,684,333 1,684,333 1,684,333 1,684,333 1,684,333 1,684,333
III Equity:
1 Capital 31,750,000 35,277,778 38,805,556 42,333,333 45,861,111 49,388,889 52,916,667
2 Retained earnings - - - - - - -
3 Current earnings - (16,843) (16,843) (16,843) (16,843) (16,843) (16,843)
Sub Total Equity 31,750,000 35,260,934 38,788,712 42,316,490 45,844,268 49,372,046 52,899,823
Total Liabilitues & Equity 31,750,000 36,945,268 40,473,046 44,000,823 47,528,601 51,056,379 54,584,157
check point - - - - - - -
RATIO ANALYSIS
1 Current Ratio
2 Leverage
PT. BHUMI SAPROLITE INDONESIA
SUMMARY FINANCIAL PROJECTION
PABRIK NICKEL
- - - - - - - - -
- - - 37,159,904 37,931,802 46,761,027 51,435,489 50,620,217 50,620,217
- - - 1,944 1,944 1,944 1,944 1,944 1,944
- - - 37,161,849 37,933,747 46,762,972 51,437,433 50,622,161 50,622,161
Pra Operation
No. Description
Pre-Op M1 Pre-Op M2 Pre-Op M3 Pre-Op M4 Pre-Op M5 Pre-Op M6 Pre-Op M7
INCOME STATEMENT
I Sales:
1 Nickel Plan - High grade - - - - - - -
2 Nickel Plan - Medium grade - - - - - - -
3 Nickel Plan - Low grade - - - - - - -
4 Nickel Plan - - - - - - -
Total Sales - - - - - - -
II Cost of Good Sold:
1 Nickel Plan - High grade - - - - - - -
2 Nickel Plan - Medium grade - - - - - - -
3 Nickel Plan - Low grade - - - - - - -
4 Nickel Plan - - - - - - -
Total Cost of Good Sold - - - - - - -
III Gross Profit: - - - - - - -
IV General & Adm. Expenses:
1 Royalty - - - - - - -
2 Community Development - - - - - - -
3 Human resources - - - - - - -
4 Transportation - - - - - - -
5 Communication & Internet - - - - - - -
6 Adminstration - - - - - - -
7 Maintenance - - - - - - -
9 Reclamation - - - - - - -
10 Depreciation - - - - - - -
11 Amortization - - - - - - -
Total General & Adm. Expenses - - - - - - -
V Operating Profit - - - - - - -
VI Other Income/(Expenses)
1 Loan provision - (16,843) - - - - -
2 Interest expense - - - - - - -
3 Bank charges 0.5% - - - - - - -
Total Other Income/(Expenses) - (16,843) - - - - -
VII Profit Berfore Tax - (16,843) - - - - -
VIII Corporate Tax - - - - - - -
IX Net Profit - (16,843) - - - - -
check point - - - - - - -
RATIO ANALYSIS
1 Gross Profit Margin #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
2 Operating Profit Margin #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
3 Net Profit Margin #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
PT. BHUMI SAPROLITE INDONESIA
SUMMARY FINANCIAL PROJECTION
PABRIK NICKEL
- - - - - - - - -
- - - 245,000,000 262,659,313 287,298,569 307,188,930 308,330,879 1,410,477,691
- - - - - - - - -
- - - - - - - - -
- - - 245,000,000 262,659,313 287,298,569 307,188,930 308,330,879 1,410,477,691
- - - - - - - - -
- - - 103,282,342 110,724,239 115,506,017 120,528,209 125,803,483 575,844,290
- - - - - - - - -
- - - - - - - - -
- - - 103,282,342 110,724,239 115,506,017 120,528,209 125,803,483 575,844,290
- - - 141,717,658 151,935,074 171,792,551 186,660,721 182,527,396 834,633,401
- - (502,314) - - - - - (519,157)
- - (313,946) (7,032,784) (5,469,943) (3,907,102) (2,344,261) (781,420) (19,849,456)
- - - (367,500) (393,989) (430,948) (460,783) (462,496) (2,115,717)
- - (816,260) (7,400,284) (5,863,932) (4,338,050) (2,805,045) (1,243,917) (22,484,330)
- - (816,260) 124,699,451 135,470,723 155,870,091 171,451,628 168,734,055 755,392,845
- - - 37,159,904 37,931,802 46,761,027 51,435,489 50,620,217 223,908,439
- - (816,260) 87,539,547 97,538,921 109,109,064 120,016,140 118,113,839 531,484,406
- - - - - - - - -
RATIO ANALYSIS
#DIV/0! #DIV/0! #DIV/0! 57.84% 57.84% 59.80% 60.76% 59.20% 59.17%
#DIV/0! #DIV/0! #DIV/0! 53.92% 53.81% 55.76% 56.73% 55.13% 55.15%
#DIV/0! #DIV/0! #DIV/0! 35.73% 37.14% 37.98% 39.07% 38.31% 37.68%
PT. BHUMI SAPROLITE INDONESIA
SUMMARY FINANCIAL PROJECTION
PABRIK NICKEL
Pra Operation
No. Description
Pre-Op M1 Pre-Op M2 Pre-Op M3 Pre-Op M4 Pre-Op M5 Pre-Op M6 Pre-Op M7
CASH FLOW
I Cash In Flows:
1 Capital 31,750,000 3,527,778 3,527,778 3,527,778 3,527,778 3,527,778 3,527,778
2 Shareholder's loan - - - - - - -
3 Bank loan - 1,684,333 - - - - -
4 Sales - - - - - - -
5 Interest income - - - - - - -
Total Cash In Flows 31,750,000 5,212,111 3,527,778 3,527,778 3,527,778 3,527,778 3,527,778
II Cash Out Flows:
1 Preliminary Expenses:
- Land acquisition 333,333 66,667 66,667 66,667 66,667 66,667 -
- Exploration & Modelling Consultant 250,000 50,000 50,000 50,000 50,000 50,000 -
- Permits 40,833 8,167 8,167 8,167 8,167 8,167 -
- Site Supporting Facilities 18,800 3,760 3,760 3,760 3,760 3,760 -
- Accomodation & Comm. Facilities 161,700 32,340 32,340 32,340 32,340 32,340 -
- Nickel Plan& Supporting Equipments 24,456,533 4,891,307 4,891,307 4,891,307 4,891,307 4,891,307 666,667
- Vehicles - - - - - - -
- Office Equipments - - - - - - -
- Furnitures - - - - - - -
2 Nickel Plan Cost:
- Nickel Plancontractors - - - - - - -
- Human resources 0 0 0 0 0 0 0
- Solar Fuel - - - - - - -
- Lubricants - - - - - - -
- Maintenance - - - - - - -
3 General & Administrative Expenses:
- Royalty - - - - - - -
- Community Development - - - - - - -
- Human resources 0 0 0 0 0 0 0
- Transportation - - - - - - -
- Communication & internet - - - - - - -
- Administration - - - - - - -
- Maintenance - - - - - - -
- Reclamation - - - - - - -
4 Insurance - - - - - - -
5 Repayment working capital loan - - - - - - -
6 Repayment investment loan - - - - - - -
7 Provision working capital loan - - - - - - -
8 Provision investment loan - 16,843 - - - - -
9 Interest working capital loan - - - - - - -
10 Interest Investment loan - - - - - - -
11 Bank charges - - - - - - -
12 Corporate tax - - - - - - -
Total Cash Out Flows 25,261,200 5,069,083 5,052,240 5,052,240 5,052,240 5,052,240 666,667
III Cash Generated 6,488,800 143,028 (1,524,462) (1,524,462) (1,524,462) (1,524,462) 2,861,111
IV Beginning Balance - 6,488,800 6,631,828 5,107,366 3,582,903 2,058,441 533,979
V Ending Balance 6,488,800 6,631,828 5,107,366 3,582,903 2,058,441 533,979 3,395,090
check point -
RATIO ANALYSIS
1 Hurdle Rate
2 EBITDA - - - - - - -
3 Net Present Value
4 Internal Rate of Return
5 Payback Period (month)
6 ROI
check point - ebitda
PT. BHUMI SAPROLITE INDONESIA
SUMMARY FINANCIAL PROJECTION
PABRIK NICKEL
- - - - - - - - 666,667
- - - - - - - - 500,000
- - - - - - - - 81,667
- - - - - - - - 37,600
- - - - - - - - 323,400
666,667 30,000 30,000 - - - - - 50,306,400
- - - - - - - - -
- - - - - - - - -
- - - - - - - - -
-
- - - 93,180,000 97,585,500 102,204,938 107,048,851 112,128,302 512,147,590
0 0 123,264 1,479,168 1,627,085 1,789,793 1,968,773 2,165,650 9,153,733
- - 62,400 920,565 982,931 988,772 994,612 1,000,453 4,949,733
- - 2,016 24,281 24,428 24,573 24,718 24,863 124,879
- - - 21,660 21,660 21,660 21,660 21,660 108,300
-
- - - 8,700,045 9,598,048 10,494,021 11,217,307 11,258,832 51,268,252
- - - 116,667 120,000 120,000 120,000 120,000 596,667
0 0 59,421 713,048 784,353 862,788 949,067 1,043,974 4,412,650
- - 2,000 25,600 30,976 35,138 38,652 42,517 174,884
- - 833 10,667 12,907 15,617 18,897 21,436 80,356
- - 833 10,667 12,907 15,617 18,897 21,436 80,356
- - - - - - - - -
- - - 21,389 23,333 23,333 23,333 23,333 114,722
- - - - - - - - -
- - - 10,046,280 10,046,280 10,046,280 10,046,280 10,046,280 50,231,400
- - - 372,659 372,659 372,659 372,659 372,659 1,863,294
- - 502,314 - - - - - 502,314
- - - - - - - - 16,843
- - 313,946 6,781,239 5,274,297 3,767,355 2,260,413 753,471 19,150,721
- - - 251,545 195,646 139,747 83,848 27,949 698,735
- - - 367,500 393,989 430,948 460,783 462,496 2,115,717
- - - - 37,159,904 37,931,802 46,761,027 51,435,489 173,288,223
666,667 30,000 1,097,028 123,042,979 164,266,902 169,285,041 182,429,777 190,970,800 882,995,103
2,861,111 3,497,778 52,662,150 121,957,021 98,392,412 118,013,528 124,759,153 117,360,079 642,898,321
3,395,090 6,256,201 9,753,979 62,416,129 184,373,150 282,765,562 400,779,090 525,538,243 -
6,256,201 9,753,979 62,416,129 184,373,150 282,765,562 400,779,090 525,538,243 642,898,321 642,898,321
- - - - - - - - -
RATIO ANALYSIS
12.00%
- - - 129,357,305 141,416,248 160,283,380 174,325,225 170,039,484 775,421,642
23,672,924
16.50%
1
1012%
-
PT. BHUMI SAPROLITE INDONESIA
SUMMARY FINANCIAL PROJECTION
PABRIK NICKEL