calculator asb
DESCRIPTION
kaedah mengira ASBTRANSCRIPT
ASB Simple CalculatorNote: Hanya Isi Maklumat Berkenaan Di Petak
Putih Sahajaa. cell B9 Tahun mula melabur b. cell C9 hingga
N33Jumlah pelaburan mengikut bulan dan tahunc. cell P9 hingga
P33Anggaran/Sebenar % Dividen mengikut tahund. cell Q9hingga
Q33Anggaran/Sebenar % Bonus mengikut tahune. cell C42 hingga
N66Jumlah pengeluaran mengikut bulan dan tahunJadual 1 -
Pelaburan
Shahrol Faizal Abdullah: Shahrol Faizal
Abdullah:TahunJanFebMarAprMayJunJulAugSepOctNovDisJumlah Pelaburan%
Dividen (Anggaran/ Sebenar)% Bonus (Anggaran/ Sebenar) Dividen
(RM)Jumlah Bonus (RM)Jumlah Div & Bonus Tahunan (RM)Jumlah
Pelaburan Terkumpul
(RM)2013200,000200,0007.701.002,566.6733.332,600.002,600.002014-
07.701.00200.2035.93236.132,836.132015-
07.701.00218.3838.77257.153,093.292016-
07.701.00238.1841.86280.053,373.332017-
07.701.00259.7545.24304.983,678.312018-
07.701.00283.2348.91332.144,010.462019-
07.701.00308.8152.92361.734,372.192020-
07.701.00336.6657.30393.964,766.142021-
07.701.00366.9962.06429.065,195.202022-
07.701.00400.0367.26467.295,662.492023-
07.701.00436.0172.92508.936,171.422024-
07.701.00475.2045.76520.966,692.382025-
07.701.00515.3149.85565.167,257.542026-
07.701.00558.8354.27613.107,870.652027-
07.701.00606.0459.05665.098,535.742028-
07.701.00657.2564.21721.469,257.202029-
07.701.00712.8069.79782.6010,039.802030-
07.701.00773.0675.82848.8910,888.682031-
07.701.00838.4382.34920.7711,809.452032-
07.701.00909.3389.38998.7112,808.162033-
07.701.00986.2396.991,083.2213,891.382034-
07.701.001,069.64105.221,174.8615,066.242035-
07.701.001,160.10114.121,274.2216,340.452036-
07.701.001,258.21123.771,381.9817,722.432037-
07.701.001,364.63134.231,498.8619,221.29Jumlah
Pelaburan:-200,000.00 Pelaburan Asal 200,000.00 Div &
Bonus19,221.29 Pengeluaran200,000.00Jumlah19,221.29
Jadual 2 - PengeluaranTahunJanFebMarAprMayJunJulAugSepOctNovDisJumlah Pelaburan2013200,000200,000.00Laporan2014- 01Jumlah Pelaburan dikeluarkan sepanjang 25 tahun 200,000.002015- 02Jumlah Pengeluaran dibelanjakan sepanjang 25 tahun200,000.002016- 02Jumlah Dividen diperolehi sepanjang 25 tahun 17,499.972017- 03Jumlah Bonus diperolehi sepanjang 25 tahun 1,721.322018- 04Jumlah Dividen dan Bonus diperolehi (25 tahun)19,221.292019- 05Jumlah Pelaburan dan Dapatan terkumpul (25 tahun)19,221.292020- 0 2021- 02022- 02023- 02024- 02025- 02026- 02027- 02028- 02029- 02030- 02031- 02032- 02033- 02034- 02035- 02036- 02037- 0Jumlah Pengeluaran:-200,000.00
ASBJadual Baki Minimum Setiap Bulan
Jadual Baki Minimum Setiap BulanDiv ASBBonus ASBDiv ASBBonus ASBTotal ASB & BonusValue of InvesmentTahunJanFebMarAprMayJunJulAugSepOctNovDec1-200,000200,000---------7.71.02,566.6733.332,600.002,600.0022,6002,6002,6002,6002,6002,6002,6002,6002,6002,6002,6002,6007.71.0200.2035.93236.132,836.1332,8362,8362,8362,8362,8362,8362,8362,8362,8362,8362,8362,8367.71.0218.3838.77257.153,093.2943,0933,0933,0933,0933,0933,0933,0933,0933,0933,0933,0933,0937.71.0238.1841.86280.053,373.3353,3733,3733,3733,3733,3733,3733,3733,3733,3733,3733,3733,3737.71.0259.7545.24304.983,678.3163,6783,6783,6783,6783,6783,6783,6783,6783,6783,6783,6783,6787.71.0283.2348.91332.144,010.4674,0104,0104,0104,0104,0104,0104,0104,0104,0104,0104,0104,0107.71.0308.8152.92361.734,372.1984,3724,3724,3724,3724,3724,3724,3724,3724,3724,3724,3724,3727.71.0336.6657.30393.964,766.1494,7664,7664,7664,7664,7664,7664,7664,7664,7664,7664,7664,7667.71.0366.9962.06429.065,195.20105,1955,1955,1955,1955,1955,1955,1955,1955,1955,1955,1955,1957.71.0400.0367.26467.295,662.49115,6625,6625,6625,6625,6625,6625,6625,6625,6625,6625,6625,6627.71.0436.0172.92508.936,171.42 126,1716,1716,1716,1716,1716,1716,1716,1716,1716,1716,1716,1717.71.0475.2045.76520.966,692.38136,6926,6926,6926,6926,6926,6926,6926,6926,6926,6926,6926,6927.71.0515.3149.85565.167,257.54147,2587,2587,2587,2587,2587,2587,2587,2587,2587,2587,2587,2587.71.0558.8354.27613.107,870.65157,8717,8717,8717,8717,8717,8717,8717,8717,8717,8717,8717,8717.71.0606.0459.05665.098,535.74168,5368,5368,5368,5368,5368,5368,5368,5368,5368,5368,5368,5367.71.0657.2564.21721.469,257.20179,2579,2579,2579,2579,2579,2579,2579,2579,2579,2579,2579,2577.71.0712.8069.79782.6010,039.801810,04010,04010,04010,04010,04010,04010,04010,04010,04010,04010,04010,0407.71.0773.0675.82848.8910,888.681910,88910,88910,88910,88910,88910,88910,88910,88910,88910,88910,88910,8897.71.0838.4382.34920.7711,809.452011,80911,80911,80911,80911,80911,80911,80911,80911,80911,80911,80911,8097.71.0909.3389.38998.7112,808.162112,80812,80812,80812,80812,80812,80812,80812,80812,80812,80812,80812,8087.71.0986.2396.991,083.2213,891.382213,89113,89113,89113,89113,89113,89113,89113,89113,89113,89113,89113,8917.71.01,069.64105.221,174.8615,066.242315,06615,06615,06615,06615,06615,06615,06615,06615,06615,06615,06615,0667.71.01,160.10114.121,274.2216,340.452416,34016,34016,34016,34016,34016,34016,34016,34016,34016,34016,34016,3407.71.01,258.21123.771,381.9817,722.432517,72217,72217,72217,72217,72217,72217,72217,72217,72217,72217,72217,7227.71.01,364.63134.231,498.8619,221.29 Pelaburan 200,000.00Div & Bonus19,221.29NoteJumlah219,221.29
Pastkan tiada simbol negatif - (pengeluaran melebihi simpanan)