My PG Stock

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

Tarikh

Berat
13 okt
100g
28-Sep 50g
100g

Harga beli Kos pengangkutan


14965
60
7518
40
14962
60

37605
15025
7558
15022

5-Sep

Fill in every Friday


Tarikh
Harga semasa
Untung/Rugi
100g
50g
100 g
50g
100g
JUMLAH
18-Oct
14506
7248
-519
-310
-829
5-Nov
14828
7410
-197
-148
-194
-539
3-Dec
15158
7574
133
16
136
285
3-Jan
15182
7586
157
28
160
345
24-Mar
15156
7573
131
15
134
280
31-Mar
15037
7514
12
-44
15
-17
6-Apr
15251
7621
226
63
229
518
29-May
15873
7931
848
373
851
2072
14-Aug
17395
8692
2370
1134
2373
5877
5-Sep
18825
9407
3800
1849
3803
9452
-15025
-7558
-15022
-37605
-15025
-7558
-15022
-37605
-15025
-7558
-15022
-37605
-15025
-7558
-15022
-37605
-15025
-7558
-15022
-37605
-15025
-7558
-15022
-37605
-15025
-7558
-15022
-37605
-15025
-7558
-15022
-37605

29116 Tarikh
Amount Harga semasa Kos Simpan Kos Transport Bayaran Target
8520 24-Sep-10 3 Kg
2795
45 30x3
8520 modal
1K
3K
5K
10K
11476
28-Sep 4kg
2824
60 30x4
11476 modal
1k
3k
5k
10k
9120
8-Oct 3 kg
2989
45 30x3
9120 modal
1k
3k
5k
10k

Harga (buy)
2840
3173
3840
4506
6173
2864
3119
3619
4119
5619
3040
3370
4040
4706
6373

Jual

Dicheck every Friday


Tarikh
Buy rate
Buy A
Buy B
Buy C
Keuntungan
1-Oct
2481
-1077
-1552
-2629
8-Oct
2532
-924
-1348
-1524
-3796
15-Oct
2762
-234
-428
-834
-1496
22-Oct
2611
-687
-1032
-1287
-3006
29-Oct
2692
-444
-708
-1044
-2196
5-Nov
3001
483
528
-117
894
12-Nov
3058
654
756
54
1464
19-Nov
3091
753
888
153
1794
26-Nov
3108
804
956
204
1964
3-Dec
3267
1281
1592
681
3554
10-Dec
3239
1197
1480
597
3274
17-Dec
3298
1374
1716
774
3864
25-Dec
3300
1380
1724
780
3884
3-Jan
3480
1920
2444
1320
5684
15-Jan
3199
1077
1320
477
2874
14-Mar
4029
3567
4640
2967
11174
31-Mar
4183
4029
5256
3429
12714
6-Apr
4359
4557
5960
3957
14474
17-Apr
4749
5727
7520
5127
18374
21-Apr
5041
6603
8688
6003
21294
30-Apr
5234
7182
9460
6582
23224
29-May
4137
3891
5072
3291
12254
14-Aug
4077
3711
4832
3111
11654
5-Sep
4461
4863
6368
4263
15494
-8520
-11476
-9120
-29116

Pajakan pada 29 OKT 2010 - 100g dan 50 g


Rate Agrobank/gram
999.9
RM159.10

Berat Emas
(gram)

No
1
2
3
4
5

TOTAL

100.00
50.00
-

150.00

Nilai
Marhum
15,910.00
7,955.00
23,865.00

Peratus
Pinjaman (%)
0.70
0.70
0.70
0.50
0.60

Cash in Hand

Jumlah
Pinjaman
11,137.00
5,568.50
16,705.50

1
12
12
2
1

Stock In Hand

Rate Emas Berat Emas 999.9


148.5
20
136.2
50
100
1000

RHB
CIMB
Maybank
PBE

2945
8939
670
555

TOTAL

13109

Balance EPP
Balance 1
Tebus 20g
3 x 1 Dinar
Balance 3

Upah
Simpan
(Tempoh
Bulan)

7684
5425
2225
1833
392

Upah Simpan
1
2
3
4
5
6
7
8
9
10
11
12

29,831.25

2684

Jumlah
Upah
Simlan
111.37
668.22
779.59
Unit

Berat Emas 916


4.25
21.25
42.5
20
50
100
0

20.00
50.00
4.25
TOTAL

6
1
5

50 g

TOTAL TEBUS
baki belian
BALIK EMAS
11,248.37
6,236.72
-

17,485.09
Current Price

Jumlah Peratus Pinjaman


50%
60%
70%
40%
30%
20%

18000
7600
1800
27400

1,457.09

Tarikh
29/10

belian baru
Cash Rahnu Item
Jumlah
16700 Dinar x 6
3794

Baki ditangan
12906

Pajakan Pada .. Untuk Bullion Gold 100g


Rate Agrobank/gram
999.9
RM159.10

Berat Emas
(gram)

No
1
2
3
4
5

TOTAL

100.00
-

100.00

Nilai Marhum
15,910.00
15,910.00

Peratus
Pinjaman
(%)

Jumlah
Pinjaman

0.70
0.70
0.70
0.50
0.60

Cash in Hand

11,137.00
11,137.00

1
12
12
2
1

Stock In Hand

Rate Emas Berat Emas 999.9


148.5
20
136.2
50
100
1000

RHB
CIMB
Maybank
PBE

2945
8939
670
555

TOTAL

13109

Balance EPP
Balance 1
Tebus 20g
3 x 1 Dinar
Balance 3

Upah
Simpan
(Tempoh
Bulan)

7684
5425
2225
1833
392

Upah Simpan
1
2
3
4
5
6
7
8
9
10
11
12

#######

2684

Jumlah
Upah
Simlan
111.37
111.37
Unit

Berat Emas 916


4.25
21.25
42.5
20
50
100
0

20.00
50.00
4.25
TOTAL

6
1
5

100g

TOTAL
TEBUS
BALIK EMAS
11,248.37
-

11,248.37
Current Price

Jumlah Peratus Pinjaman


50%
60%
70%
40%
30%
20%

18000
7600
1800
27400

937.36

Oktober 201
STOK YANG ADA DI TANGAN
No
No
1
2
3
4
5
6
7
8
9
10
11
12
13
14

Date
6/1/2010
6/1/2010
6/1/2010
6/1/2010
6/1/2010
6/1/2010

Item
Public Gold Bullion Bar 100g
Public Gold Syilling Bar 50g
Public Gold Bullion Bar 100g
Public Gold Bullion Bar 20g
Public Gold 1 Dinar 4.25g
Public Gold 1 Dinar 4.25g

Jumlah
1
1
1
1
1
5

No Item

3
4
3

RM8,520
RM11,476
RM9,120

TOTAL

RM73,445

Duit 70k dah guna 66k

Harga beli Commision


RM14,965
RM224
RM7,518
RM113
RM14,962
RM224
RM3,090
RM46
RM624
RM9
RM3,170
RM48

RM665

Oktober 2010

Today Price
RM600
RM600
RM600
RM600
RM600
RM600

RM3,600

Date Bought

Buyer

Item

Price Sell

No
6/5/2010
6/1/2010
6/1/2010
6/1/2010
6/1/2010
6/1/2010

Date
Ibrahim
Ibrahim
Ibrahim
Hafeezul
Naim

Item
Public Gold 1 Dinar 4.25g
Public Gold Bullion Bar 20g
Public Gold Bullion Bar 100g
Public Gold 1 Dinar 4.25g
Public Gold 1 Dinar 4.25g
No Item

Buyer
RM624

TOTAL

RM1,902
RM634

RM3,160

Jumlah
1
2
1
3
1

Komisyen
1.5%
Today Price
RM9
RM0
RM0
RM29
RM10
RM0

RM47
368

Remarks

Nov-10
STOK YANG ADA DI TANGAN
No
No
1
2
3
4
5
6
7
8
9
10
11
12
13
14

Date
13/10/10
13/11/10
13/11/10
6/1/2010
6/1/2010
6/1/2010

Item
Public Gold Syilling Bar 50g
Public Gold Bullion Bar 20g
Public Gold 1 Dinar 4.25g
Public Gold Bullion Bar 20g
Public Gold 1 Dinar 4.25g
Public Gold 1 Dinar 4.25g

Jumlah
1
1
10

Harga beli Commision


RM3,136
RM47
RM7,084
RM106
RM6,480
RM97
RM0
RM0
RM0

TOTAL

RM16,700

No Item

RM251

Nov-10

Today Price

RM0

Date Bought

Buyer

No
1/11/2010
10/11/2010
10/11/2010
10/11/2010
13/11/10

Date
Naim
Ismail
Ismail
Ismail
Hasmida

Item

Item
Buyer
Public Gold 1 Dinar 4.25g
RM636
Public Gold Bullion Bar 20g RM3,160
Public Gold Bullion Bar 100g RM15,652
Public Gold 1 Dinar 4.25g
RM653
Public Gold Bullion Bar 20g RM3,136

TOTAL

Komisyen
1.5%

Price Sell

RM23,237

Jumlah
1
1
1
2
1

RM10
RM47
RM235
RM10
RM47
RM0

RM349

Remarks

653

Nov-10
STOK YANG ADA DI TANGAN
No
No
1
2
3
4
5
6
7
8
9
10
11
12
13
14

Date

10/12/2010
11/12/2010

Item
Public Gold Syilling Bar 50g
Public Gold Bullion Bar 20g
Public Gold 1 Dinar 4.25g
Public Gold Bullion Bar 20g
Public Gold 1 Dinar 4.25g
Public Gold 1 Dinar 4.25g

Jumlah

7
6
1

Harga beli Commision


RM0
RM0
RM4,606
RM69
RM0
RM3,906
RM59
RM984
RM15

No Item

TOTAL

RM9,496

RM142

Nov-10

Today Price

Date Bought

Buyer

Item

Price Sell

No

Date
Naim

Item
Public Gold 1 Dinar 4.25g
Public Gold Bullion Bar 20g
Public Gold Bullion Bar 100g
Public Gold 1 Dinar 4.25g
Public Gold Bullion Bar 20g

Buyer

Atiq

Komisyen
1.5%
Jumlah
2

silver

RM0

TOTAL

RM0

RM0

Remarks
654(stok)

654(stol)

No.
1
2
3
4
5
6

Nama
Ibrahim Muhammad Jufri
Hafeezul Masri
Abdul Mun'aim
Abdullah husaini
Muhammad Akid
Mohd Ismail

Handphone/Tel

Email
[email protected]
[email protected]
mambi86@
[email protected]
[email protected]

Facebook

Pembelian
Tarikh
Stok
Bullion
Dinar
26 okt
100 g+50g
1 Dinar
30 okt
1dinarx3
30-31okt
1dinarx2
3-Nov 20g
1PDx2
15-Nov
1PDx3

Catitan
Dealer status, balik ke ampang, selangor
Fist yr unimas - kiv beli lagi
KIV monthly 1 dinar.
wakil mesir
got from abdullah
Dealer status, ipoh/trg

You might also like