ASB Calculator v3.3 Usage Tips


We have received a couple of inquiries from our valued readers on how to use the most recent ASB Calculator V3.3. Here are some tips of using it.

First Step:

img3

Here you can edit the start date of your investment and the amount of your initial investment. Nothing complicated here.

Second Step:

Montly Adjustment

This is the adjustment option if you have any in particular year. For monthly column, the amount will be added every month in that year. This is for standing instruction or money that you put monthly. Yearly column will adjust only once in that year. Both columns can be positive or negative value.

Thirds Optional Step:

img4

If you scroll enough to the right, you’ll see a small calculator for loan calculation. You can use the calculator to see how much you lose to a bank for taking loan. This part doesn’t have effect to the table below.

That’s all. Post a comment if you are still having a problem with the calculator.

  1. #1 by norisa on July 9, 2007 - 12:00 pm

    Dear Irwan,

    I wonder if your ASB calculator can also be used to count EPF dividend and its total of savings throughout the year. I have consult the EPF officer and question them how they calculate the dividend but they dont give a good explanation like if the calculation is confidential…

    TQ

  2. #2 by Irwan on July 9, 2007 - 4:13 pm

    as oppose with ASB, EPF use daily minimum balance instead of monthly.

    So let say this year dividend rate is 7%. The calculation for dividend is:

    0.07 / 365 x sum of balance for each day that year

    However as your balance in each day in a month is supposedly equal, the dividend payment is definitely the same with ASB. Thus you can use our calculator here.

  3. #3 by norisa on July 9, 2007 - 5:11 pm

    Thank you. One more thing, which decision would benefit most in terms of financial benefits. If I want to settle my housing loan, should I withdraw from my EPF savings every once a year or wait until I decided to settle one shot of the loan balance. Eg: If let say I plan to retire in 2017 (10 yrs from now) should I withdraw every each year from 2007-2007 or wait until my Account 2 accumulated till the final year, 2017. TQ

  4. #4 by norisa on July 9, 2007 - 5:13 pm

    sorry typing error “…should i withdraw every each year from 2007-2017 or wait…

  5. #5 by Irwan on July 9, 2007 - 6:38 pm

    Hi again norisa.

    I don’t have enough information to answer your question.

    Basically to answer financial problem like this, just simulate the option that you have.

    1. if you are able to withdraw your EPF once a year, will this reduce the amount that you should paid for the loan (plus interest) because of your timely payments?

    2. if you delay the payment, will the dividend from your EPF exceed the saving that you could have in option 1?

    if you could answer the questions, you know what to do already

  6. #6 by kkchow23 on July 10, 2007 - 1:00 am

    hi norisa,

    If you’ve already having a housing loan, the option is just whether to settle it early or later. When you want to settle your housing loan balance, you should always consider what you can do with the money if it were invested or kept elsewhere instead of shortening the period to reduce the loan rate / BLR.

    If it can grow more in terms of your loan interest rate / BLR, then is it worth to settle it?

    Basically, my opinion quite similar to Irwan’s.

  7. #7 by norisa on July 10, 2007 - 12:01 pm

    thanks for the explanations. based on that I’ve calculated that if I withdraw every each year and compared to one-shot withdrawal, I profit more on one-shot withdrawal in 2017. By using yr ASB calculator, I found that I earn more if I save the money in EPF till 2015 (assuming 5% div). By 2015 I manage to settle the balance of the loan i.e about RM71,085.

    Even though, if I withdraw the loan every year (by year 2013 I could settle everything!), I found that the balance of my EPF remaining in the account is far less if I withdraw every year.

    By eg. compare balance in EPF account in 2015:

    a) Option1 :One-shot withdrawal in 2014
    TOTAL LOAN: RM156,172.00
    BY YEAR 2014 (I.E 7 YRS TIME FROM NOW)
    TOTAL INSTALLMENT $81,753.00
    EPF WITHDRWAL -$71,085.00
    TOTAL PAYMENT $152,838.00

    TOTAL LOAN $156,172.00
    TOP-UP $3,334.00

    EPF BALANCE IN 2015 $191,795.00

    B) OPTION 2: IF WITHDRAW EVERY EACH YEAR
    I manage to settle earlier (end of yr 2012/early 2013)
    but top-up RM4337.84

    however my EPF balance : RM126,266.58

    191,795.00 EPF balance option 1
    -126,266.58 EPF balance option 2
    differences 65,528.42

    My monthly installment is RM973.31. so if I save from year 2013-2015 (2 years) I only get RM973x12x2=RM23,518 (ASSUMING 5% DIV). So still couldnt get equally 65,528.42.

    I decide to take option 1.Your ASB calculator is really helpful. thanks again.

  8. #8 by Mohd Azhar on July 12, 2007 - 10:58 pm

    Can i confirm, that for ASB loan, there is no definite loan tenure in the agreement eg RM20k in 10 yrs, its just a rough estimate made by the bank. Because of the loan interest depends on BLR, when BLR increases the amount deducted from the principles is lower, thus extending the loan tenure as where are only paying a fixed amount each month..

    Am I correct?

  9. #9 by Irwan on July 13, 2007 - 12:06 am

    from what i know, the monthly payment will varied with the changes of BLR, but the duration of the tenure is fix. can someone confirm this?

  10. #10 by kkchow23 on July 13, 2007 - 1:55 pm

    This depend what loan that particular investor apply for. If the investor’s loan is a variable rate loan, and the interest rates rise, total repayment amount will be increased. Meaning that the investor have to pay more each month to settle the loan.

    Also bear in mind that if the fund price fall beyond a certain level, investor may be asked to provide additional amounts on top of normal investment. If fail, units may be sold to settle loan. This won’t be happening to ASB, don’t worry. Just a reminder for those who purchase funds without capital guarantee with loan.

    ——————————————————-
    If anyone wants to know more about Public Mutual and the funds offered, you can contact me:
    kkchow23@hotmail.com
    6016-6202562

  11. #11 by Luna on August 6, 2007 - 12:25 pm

    I wanna ask a simple question, might sound silly. Which gives better return – RM10K in ASB versus RM10K in EPF, assuming no increment of investment/saving. Just that mere RM10K in there. Say for a period of 1 year (Jan 1 – Dec 31) and based on the average return percentage for each one.

    Thanks…

  12. #12 by kkchow23 on August 6, 2007 - 1:00 pm

    If based on last year (2006), putting in EPF only yields 5.15% while ASB is giving 7.30%. It’s obvious that ASB will give better returns compare to EPF. But bear in mind returns are not fixed.

  13. #13 by Irwan on August 6, 2007 - 8:02 pm

    Yes Luna, historically, I can confirm that ASB yields more return than EPF. People are also expecting the same as EPF is a form of forced-investment. So it should be more conservative and thus yield less.

  14. #14 by Mohd Shahirasul on September 2, 2007 - 11:06 am

    Irwan,

    Just nak share info.

    Utk ASB, setiap orang dia capped maximum investment RM200k sahaja. Maknanya bila dah reaches to RM200k, you cannot put money anymore.

    But the interest accrued will be invested again, and only profit jer yg boleh diinvest semula.

    Contohnya, kalau ko dah masukkan RM198,000 ke dalam ASB, tahun hadapanya, ko dapat profit RM19,000 – maka jumlah akan jadi RM217,000 – dah excess RM200k, maka ko tak boleh masukkan duit sendiri lagi. Waktu ni, keuntungan yg dijana sahaja yg boleh membantu menambahkan lagi duit kat dalam ASB tu.

    Hope useful. Thanks for the xls system.

  15. #15 by aqil on November 2, 2007 - 10:11 am

    dear irwan.

    macamana pengiraan Dividen ASB dan Bonus ASB?
    kalau guna table, saving 1200, akan dapat RM 52 (dividen)
    kalu guna kalkulator, 1200 x 8% = RM 96.
    camner ek????tolong…tolonggggggg….tolonggggg
    emel ker saya pengiraannya…TQ

  16. #16 by Irwan on November 2, 2007 - 12:43 pm

    hi aqil,

    klo gune asb calculator kat atas tu, RM1200 at 7%(bonus 2%) akan dpt RM84 utk dividen dan RM2.40 utk bonus.

    just masukkan nilai dlm calculator tu.

    table yg u cakap tu table mane?

  17. #17 by aqil on November 2, 2007 - 8:34 pm

    betul.kalau bulan jan masuk rm1200,( tiada penambahan dalam asb )dalam tahun tersebut,memang dapat dividen seperti diatas.
    contohnya,kalau kita buat simpanan rm100 sebulan dari jan-dec. so,the end of year will get rm1200.dividen dia kira camner?
    kalu letak nilai dalam jadual diatas, akan dapat 45.50 (dividen) dan 1.30 bonus.kenapa tak dapat RM 84 dan 2.40.???

  18. #18 by Irwan on November 2, 2007 - 9:19 pm

    oo.. baru faham soklannye.

    sbb asb ni kire baki terendah stiap bulan. so klo masuk RM100 stiap bulan, skit lah dividen dia berbanding masuk terus RM1200

    dlm post ni ade terang camne nak kire dividen bonus

    http://www.irwan.biz/how-to-calculate-asb-dividend-and-bonus/

  19. #19 by alia on December 12, 2007 - 5:39 am

    Dear Irwan…

    Soalan simple..biasalah malas nk pk. kalau ada 50k kat mana yang terbaik nak invest or nak simpan. lagi satu saya ada amik ASB loan 15k(2003) n 85k(2005) both dalam masa 15 tahun.. tak tahu ok ke tak.. takde masalah nak bayar tapi macam tak untung sgt jer.. tolong advice gak…

  20. #20 by Irwan on December 12, 2007 - 1:54 pm

    dear alia,

    for the 50k, it depends on how much risk you are able to take and the duration of your investment.

    If you can take moderate to high risk, mutual fund is the best to invest. the duration suggested for mutual fund is between 3-5 years.

    if you want for safer investment, you can opt for ASB or islamic fixed deposit.

    for the loan, while I don’t like taking a loan for investment, i do not recommend for termination as it involve large penalty. If you can keep it and comfortable with its payment, I don’t see any problem with it. it’s just you have to take more risk along the way.

  21. #21 by alia on December 13, 2007 - 4:58 am

    Dear Irwan,

    Thanks for 4 ur advice n suggestions.
    Bank mana yang ada Islamic Fixed Deposit?
    Is it advisable tak.. kalau keluarkan sebahagian duit dari Insurance n buat investment?

  22. #22 by Joe on June 20, 2008 - 1:09 am

    Thanks Irwan…..

  23. #23 by apam on July 1, 2008 - 12:06 pm

    hai Irwan,

    nk tanya sket la..kalu kt buat loan asb kat maybank or cimb 2 ada profit ke..ke kt rugi sbb byr interest bank..huh..xphm aku..tolong le..pening ni

  24. #24 by treec00l on July 25, 2008 - 3:20 pm

    Salam En Irwan,

    nak tanya sikit.

    ASB kira dividen die base on nilai terendah setiap bulan. so, bile tarikh akhir ASB kire dividen tu, supaye kite xsalah timing masokkan duit.

    tq byk2 :)

    • #25 by Irwan on July 25, 2008 - 3:29 pm

      sy pun kurang pasti

  25. #26 by linda on September 26, 2008 - 12:09 pm

    salam en irwan,

    Diatas en irwan cakap dividen lebih tinggi jika kita simpan lumpsum.

    nk mintak tlg explaine dalam excel format simpanan untuk 2 akaun selama 2 tahun.satu akaun disimpan RM100 setiap bulan selama 2 tahun. satu lagi akaun disimpan RM1200 pada setiap julai selama 2thn. maka kedua2 akaun = RM2400.

    katakan bonus dan dividen adalah sama untuk kedua2 tahun tersebut iaitu bonus 2% dan dividen 8%.

    kalau sekiranya dapat en irwan email kepada saya..

    thanks a lot.

  26. #27 by mirae on October 16, 2008 - 11:00 pm

    En.irwan,
    i’ve took 25k, 187 p/month for 20 years since middle 2006.

    1) now i m wonder’ either to keep it? or just to terminate it ?since my car loan is not approved bcoz of that asb loan.

    2)now it almost near to end 2008,
    if i want to stop, advice the rite timming to stop..is it worth to stop ?since it just 2++ years paid for the installment?

    3)if i want to stop,how much will i receive the balance from the bank(known as registered ah long)?

    give me worth reccomend,pls…

  27. #28 by MARIA on December 26, 2008 - 11:25 am

    SALAM. CONFUSED la pasal asb ni. sy apply maybank loan-asb. dorg py interest toksah cakap la. yg sy tak faham ni, ttg bouns y kte dpt tiap2 thn dlm asb acc. mcm sy ni every yr mmg dra duit tu utk bayar insurans kete. so, bile dh spi tempoh matang, sy jez dpt jumlah sy loan je ek? ble tak tolong sy yg ari2 konpius…

    trimas

  28. #29 by tim_taz on December 29, 2008 - 4:25 pm

    hi
    i have a question about asb loan
    recently in my saving in asb account is 50K++
    i would like to add more RM in saving account by apply asb loan
    but which bank will provide the loan service better?as far as i known, maybank, cimb and rhb are the only bank that provide this asb loan ( or any bank else had provide this kind of service?)
    but after i reading comment in this blog, i dontknow wheter is worth to make a loan or should i save my own money monthly in asb account. anyone can help me figure this out,

  29. #30 by norzz on December 30, 2008 - 1:25 pm

    saye nk tanye tentang pengiraan loan asb,bulan december saye telah tmatkan account.bagaimana pula pengiraannyer

  30. #31 by zul on August 26, 2009 - 10:08 pm

    BOLEH TOLONG JELASKAN TTG BLR?TERIMA KASIH TAK TERHINGGA

  31. #32 by redhuan on December 24, 2009 - 3:41 pm

    Hai..
    Boleh bg tak soft copy untuk wat calculation ASB.. i really2 need it.. urgent..
    tq

  32. #33 by shahrir on July 14, 2010 - 3:54 pm

    hai, how to key in if i only pump in money on month of dec every year??

  33. #34 by saya budak baru belajar on August 5, 2010 - 6:42 pm

    nak ty pasal colum yearly tu..kalo tak isi tak pe ke..ke mmg kene isi..tak pham..sori kalo ty..harap dpt menjawab…

    saya budak baru belajar

  34. #35 by ash on September 12, 2010 - 1:36 pm

    it’s necessary to put amount in that column yearly..i confusing

  35. #36 by Anonymous on September 13, 2010 - 10:08 am

    If you make a yearly contribution, ie. invest additional 1000 each year,
    then put 1000 on each year column. If not, leave it blank. Hope that
    clarify.

  36. #37 by mat on October 30, 2010 - 4:36 am

    Hi Irwan,
    if one’s asb account have reached RM200k. Can he/she open a new account ? Otherwise how can they make additional investment?

  37. #38 by Ai on November 26, 2010 - 11:54 pm

    hi irwan,

    if i were to take asb loan and use the strategy of only paying monthly for the 1st year and using the yearly asb dividend to pay the loan for the rest of the years, i still can use this calculator right? if i understand it correctly, i just need to put negative amount in the yearly adjustment column, right?

  38. #39 by Ismail on December 16, 2010 - 5:10 pm

    if ur asb 200k invest to AHB min divident is 6% (amanah hartanah bumiputra)

  39. #40 by Arwern on January 7, 2011 - 1:01 am

    It’s very goods.. Thanks.. a lot..

  40. #41 by Sense_less143 on February 2, 2011 - 4:10 pm

    BIG thank you for this, was very helpful. Thanks!

  41. #42 by SaviourV on March 22, 2011 - 4:01 am

    What if you deposit most of the time, say a standard amount every month for 6 months, but during month #7, you take out a large chunk of the money? Can this be illustrated in this calculator, or does this need to be re-programmed to take that into effect?

  42. #43 by Ronnie on May 5, 2011 - 9:57 am

    I never tried this software before. Very helpful site for financial benefits.

  43. #44 by Kay Kastum on May 9, 2011 - 10:30 am

    Awesome Stuff! Thanks.

  44. #45 by Web Hoster on May 29, 2011 - 8:27 pm

    Thanks for the tips. Same ques asked by mat. i think it will make a new account.

  45. #46 by Web Hoster on May 29, 2011 - 8:27 pm

    Thanks for the tips. Same ques asked by mat. i think it will make a new account.

  46. #47 by Marquisx on June 18, 2011 - 1:26 pm

    i don’t think you can create another one for yourself.

Comments are closed.