CASHFLOW_OPSI2

PT KHATULISTIWA MAKMUR PERSADA

Uraian Total Bulan 0 Bulan 1 Bulan 2 Bulan 3 Bulan 4 Bulan 5 Bulan 6 Bulan 35 Bulan 36
Cash In 286,808,585,938 - 8,361,806 4,682,272,743 7,689,200,868 6,630,871,181 8,833,832,118 8,861,085,243 8,688,482,118 5,976,796,181
Cash In (Accumulation) 286,808,585,938 - 8,361,806 4,690,634,549 12,379,835,417 19,010,706,597 27,844,538,715 36,705,623,958 280,831,789,757 286,808,585,938
Own Capital Equity Fund -
Loan Capital Equity Fund -
Depresiasi 301,025,000 8,361,806 8,361,806 8,361,806 8,361,806 8,361,806 8,361,806 8,361,806 8,361,806
Sales 286,507,560,938 - - 4,673,910,938 7,680,839,063 6,622,509,375 8,825,470,313 8,852,723,438 8,680,120,313 5,968,434,375
Cash Out 247,774,092,203 200,000,000 2,706,928,114 4,654,266,258 6,521,967,102 5,831,692,939 7,365,108,375 7,385,231,139 7,339,904,194 5,455,333,558
Cash Out (Accumulation) 247,774,092,203 200,000,000 2,906,928,114 7,561,194,372 14,083,161,474 19,914,854,413 27,279,962,788 34,665,193,927 242,318,758,645 247,774,092,203
Equipment Cost 51,521,614,625 1,103,000,000 1,289,500,000 1,313,289,500 1,214,000,000 1,449,118,438 1,452,592,813 1,495,588,438 1,274,000,000
Rent 51,215,114,625 887,000,000 1,214,000,000 1,313,289,500 1,214,000,000 1,449,118,438 1,452,592,813 1,490,588,438 1,274,000,000
Mobilization 306,500,000 216,000,000 75,500,000 - - - - 5,000,000 -
Fuel Cost 37,242,669,276 578,430,460 608,671,788 979,826,466 844,640,726 1,120,636,863 1,123,989,491 1,125,954,677 785,900,642
Fuel 37,242,669,276 578,430,460 608,671,788 979,826,466 844,640,726 1,120,636,863 1,123,989,491 1,125,954,677 785,900,642
Overhead Cost 19,033,694,809 1,025,497,654 475,871,556 481,662,654 542,182,428 489,742,654 489,742,654 483,661,381 483,661,381
Human Resources 10,749,659,809 279,212,654 277,421,556 279,212,654 355,732,428 287,292,654 287,292,654 281,211,381 281,211,381
Infrastructure 720,000,000 240,000,000 - - - - - - -
Light Vehicle 3,240,000,000 90,000,000 90,000,000 90,000,000 90,000,000 90,000,000 90,000,000 90,000,000 90,000,000
Office Equipment 7,000,000 7,000,000 - - - - - - -
Office Furniture 50,515,000 50,515,000 - - - - - - -
Camp Equipment 2,000,000 2,000,000 - - - - - - -
Camp Furniture 123,510,000 123,510,000 - - - - - - -
Computer & Accecories 46,000,000 46,000,000 - - - - - - -
Communication 72,000,000 72,000,000 - - - - - - -
Safety Equipment 22,410,000 22,410,000 - - - - - - -
Survey Equipment - - - - - - - - -
Office Supplies 16,200,000 450,000 450,000 450,000 450,000 450,000 450,000 450,000 450,000
Meal Drink Laundry 3,984,400,000 92,400,000 108,000,000 112,000,000 96,000,000 112,000,000 112,000,000 112,000,000 112,000,000
Additional Cost 139,976,113,493 200,000,000 - 2,280,222,915 3,747,188,483 3,230,869,786 4,305,610,421 4,318,906,181 4,234,699,699 2,911,771,535
Fee IUP KMP 99,322,621,125 1,620,289,125 2,662,690,875 2,295,803,250 3,059,496,375 3,068,944,125 3,009,108,375 2,069,057,250
Explorasi Pemboran 200,000,000 200,000,000
Eksplorasi Geofisika Logging - - - - - - - - -
Coal Hauling - - - - - - - - -
PNBP 40,453,492,368 - 659,933,790 1,084,497,608 935,066,536 1,246,114,046 1,249,962,056 1,225,591,324 842,714,285
Gross Cashflow 39,034,493,735 - 200,000,000 - 2,698,566,308 28,006,485 1,167,233,766 799,178,242 1,468,723,743 1,475,854,104 1,348,577,924 521,462,623
Gross Cashflow (Accumulation) 39,034,493,735 - 200,000,000 - 2,898,566,308 - 2,870,559,823 - 1,703,326,057 - 904,147,816 564,575,927 2,040,430,031 38,513,031,112 39,034,493,735
1% 15% 12% 17% 17% 16% 9%
Tax - 5,552,619,854 - - 93,645,455 - 153,784,017 - 132,617,424 - 176,676,642 - 177,221,705 - 173,769,642 - 119,535,924
Net Cashflow 33,481,873,880 - 200,000,000 - 2,698,566,308 - 65,638,970 1,013,449,748 666,560,818 1,292,047,101 1,298,632,399 1,174,808,281 401,926,699
Net Cashflow (Accumulation) 33,481,873,880 - 200,000,000 - 2,898,566,308 - 2,964,205,278 - 1,950,755,530 - 1,284,194,712 7,852,389 1,306,484,788 33,079,947,181 33,481,873,880

CAPITAL EQUITY FUND 2,898,566,308 -200000000 -2698566308 0 0 0 0 0 0 0

IRR 28%
NPV 27,197,216,684.399
PBP 5 bulan
Note: Deposit ke KMP -