kiraan gaji

37
PISANG KEMBOR Jumlah (RM) Modal 13200 Modal CB 0 CB Bulan 9 0 Bulan 10 1500 11 1500 12 26300 Total 29300 Net Profit 16100 Modal 13200 ROI 13200 11400 Total Jumlah 37800 ROI % ETA5 Loaded 8 C1 Jumlah (RM) Harga 100g 12700 Modal 2700 CB 10000 Bulan 9 0 10 2000 11 2000

Upload: akmal-aizuddin-al-banjari

Post on 20-Nov-2015

84 views

Category:

Documents


2 download

DESCRIPTION

perbelanjaan

TRANSCRIPT

Sheet1PISANG KEMBOR PISANG MANISETA 14

Jumlah (RM)Jumlah (RM)Jumlah (RM)Modal13200Modal13200Modal11400CB0CB11000CB0Bulan90Bulan90Bulan9010150010250010360011150011250011360012263001225001236001250013600Total293002250023600Net Profit16100Total23500Total18000Net Profit10300Net Profit6600ProfitGajiHutangBakiModal13200ROI29300901320023500107600300010003600114001800011760030001000360012324003000100028400Total7080016100300010002100Jumlah3780026100300010002100ROI %187.3015873016Total5980039800ETA5 Loaded 8 C1ETA5 Loaded 8 C2ETA5 Loaded 8 C2

Jumlah (RM)Jumlah (RM)Jumlah (RM)Harga 100g12700Modal2700Harga 100g (CB+2700)12700Modal2700Harga 100g (CB+2700)12700Modal2700CB10000CB10000CB10000Bulan90Bulan90Bulan90102000100100112000112000110122000122000122000120001200012000220002200022000320003200042000Total20000Total20000Total20000Net Profit7300Net Profit7300Net Profit7300ProfitGajiGaji MamaHutangBaki910200080030040050011400016006004001400126000240090040023001600024009004002300260002400900400230034000160060040014004200080030040050010700Kontra 1

Jumlah (RM)Modal4500CB0Kontra 2Bulan90102000Kontra 3112000122000Modal450012000CB02200022000Modal45003200032000CB042000420005200052000total1400062000620007200072000Net Profit95008200082000.92000Gaji1000Total14000102000112000Net Profit9500Total14000Net Profit9500ProfitGajiHutangBakiModal9200010008092046001020001000809201120001000809201220001000809201200010008092022000100080920460032000100080920420001000809205200010008092062000100080920720001000809208200010008092092000100080920102000100080920112000100080920Total Baki13800Total Modal PusingPT2

Modal15000Jumlah (RM)PT211400Harga 100g (CB+2700)11400ModalKontra4500(Kena Topup 900)CB11000Baki3600Bulan9010340011340012340013400234003040Total28000Net Profit16600Modal PusinganProfitPT2KontraPisang mkontra 2Pisang m2Pisang m3kontra 3Gaji KasarBaki dalam bankZakatHutangGaji BersihMamaRHB103400200022003200100g bulan1553002001645113400200022003200553002001645123400200022003200553002001645134002000220032001280012800553002001645234002000250030004900Masuk Kontra Bulan 24500753002002425320002500200030003500753002002425420002500200030003500100g Bulan 412800752002725525002000250035003500100g Bulan 51280087.52003212.56250020002500250035006000kontra Bulan 7450087.52003212.5720002500250040003000100g bulan 812800100200370082000250025002000250060005500kontra Bulan 945001502005650920002500250020002500200060007500100g bulan 101280015020056501025002000250020002500400075001002003700112000250020002500400050001002003700122000250020002500400050001002003700120002000250040002500100200370022000200025004000250010020037002000Total Gaji54080Total7270047400Baki modal25300Overall Total Income135500HUTANGMAMARHBModal 15000Modal 3000Bayar10Bayar10801113000(Buat ETA 30 Bila dah dapat CB)1112300130023003300ETA5 Loaded 8 C1Kontra ETA5 Loaded 8 C1

Jumlah (RM)Jumlah (RM)Jumlah (RM)Harga 100g13000ModalHarga 100g4500ModalHarga 100g8800ModalCB10000CB0CB10000Bulan90Bulan90Bulan90102000102000100112000112000112000122000122000122000120001200012000220002200022000320003200042000Total200005Total18000Net Profit7000Net Profit9200Bulan 12 cb akan jadi 100g pulang balikTotal14000Net Profit9500TotalProfitLoaded8KontraLoadedModal PusinganGaji KasarBaki dalam bankCatatanJumlahZakatHutangGaji Bersih10200020004000152024803810013821120002000200060002280372057100212312200020002000600022803720Beli 100g ETA 30 bulan 1299205710021231200020002000600022803720571002123220002000200060002280372057100212332000200040001520248038100138242000200076012401910064156

Sheet2Jumlah kena topup untuk next cycle1800900Loaded 8PT2Cikgu PowerPT3Trading ETA 14

Jumlah (RM)Jumlah (RM)Jumlah (RM)Jumlah (RM)Jumlah (RM)Harga 100g12800ModalHarga 100g11800ModalHarga 100g11900ModalHarga 100g12000ModalHarga 100g11900ModalCB10000CB11000CB10500CB11000CB0Bulan90Bulan90Bulan90Bulan90Bulan9010200010CB dapat balik10010010011200011340011CB dapat balik110110122000123400122000120CB dapat balik1201200013400120001340014000220002340022000234002400033340032000334003400044200043400440005Total280005340054000Net Profit16200Total20500664000Net Profit86007400084000Total2000094000Net Profit7200ProfitTotalCadanganBulanLoaded8PT2CikguPT3Trading ETAModal PusinganGaji KasarGaji MamaBaki dalam bankCatatanJumlahZakatHutangGaji Bersih90000100-1001020002000760124019100641112000340054002052334851.31001900.712200034002000740028124588Beli 100g ETA 30 bulan 12917670.31002641.712000340020003400400014800562420007176140.61005383.422000340020003400400014800562420007176Beli 100g ETA 1414352140.61005383.43340020003400400012800486420005936Kontra5936121.61004642.442000340040009400357220003828Kontra382889.31003382.7534004000740028122000258870.31002641.764000400015202000480381001382740004000152020004803810013828400040001520200048038100138294000400015202000480381001382

Sheet3Skill ETA 30

ProfitTotalCadanganBulanEGT-F1PT2KJO4Trading ETATrading ETATrading ETAModal PusinganGaji KasarGaji MamaBaki dalam bankCatatanJumlahbaki beli eta 30ZakatHutangGaji Bersih90000100-100104004001522483.810048.2112000340054001080030007800751002825122000340054001080030007800Beli 100g ETA 30 bulan 1215848834875100282512000340054002900137003000135093507198751002825220003400540029002900166003000135012250Beli 100g ETA 14216008948751002825334005400290029002900175003000135013150Kontra131501098751002825429002900290029002900145003000135010150Kontra1015074875100282552900290029002900290029001740045001890110101258112.51004287.5629002900290029002900290029002030045001890139104668112.51004287.5729002900290029002900290029002900232004500189016810478112.51004287.5829002900290029002900290029002900290029002900045001890226102088112.51004287.5929002900290029002900290029002900290029002900290034800450018902841019998112.51004287.51029002900290029002900290029002900290029002900290029003770045001890313109308112.51004287.51129002900290029002900290029002900290029002900290029002900290029002900493004500189042910112.51004287.51229002900290029002900290029002900290029002900290029002900290029002900493004500189042910112.51004287.58348Target 20151.7Target 20165.33.1176470588Target 201717.33.2641509434Target 201865.33.774566474Jutawan Yang diberkati dan diredhai.target 2019185.32.8376722818target 2020785.34.2379924447