this calculation based on my asb loan at maybank.i take this loan scheme since i was 19 and it's already 3 years now.
i paid 429 every month for 15years for my loan scheme.so for those who doesnt know where the 5148 figure at without(w/o) table this is the calculation=429x12months=5148.but for w/o loan table u must remember to deposit that 5148 amount lump sum at the early month of the year coz asb dividend is calculated based on the deposit date.so if not it will be slightly decreased.hope this table can help u guys make a better judgement.if my calculation was wrong feel free to let me know.
Loan
year initial dividend profit balance
1 50000 8% 4000 54000
2 54000 8% 4320 58320
3 58320 8% 4665.6 62985.6
4 62985.6 8% 5038.85 68024.45
5 68024.45 8% 5441.95 73466.4
6 73466.4 8% 5877.3 79343.7
7 79343.7 8% 6347.5 85691.2
8 85691.2 8% 6855.3 92546.5
9 92546.5 8% 7403.7 99950.2
10 99950.2 8% 7996 107946
11 107946 8% 8635.7 116581.7
12 116581.7 8% 9326.5 125908.2
13 125908.2 8% 10072.65 135980.7
14 135980.7 8% 10878.45 146859.2
15 146859.2 8% 11748.7 158607.9
Paid 77220
Nett Profit 81387.9
Assumption
no dividend withdrawal for 15 years
fix dividend at 8% every year
fix interest rate
Comparison
profit - 81387.7
punctual payment
W/O Loan
year saving initial dividend profit balance
1 5148 5148 8% 411.8 5559.8
2 5148 10707.8 8% 856.6 11564.4
3 5148 16712.4 8% 1337 18049.4
4 5148 23197.4 8% 1855.8 25053.2
5 5148 30201.2 8% 2416.1 32617.3
6 5148 37765.3 8% 3021.2 40786.5
7 5148 45934.5 8% 3674.8 69609.3
8 5148 54757.3 8% 4380.6 59137.9
9 5148 64285.9 8% 5142.9 69428.8
10 5148 74576.8 8% 5966.1 80542.9
11 5148 85690.9 8% 6855.3 92546.2
12 5148 97694.2 8% 7815.5 105509.7
13 5148 110657.9 8% 8852.6 119510.5
14 5148 124658.5 8% 9972.7 134631.2
15 5148 139779.2 8% 11182.3 150961.5
Paid 77220
Nett Profit 73741.5
Assumption
no dividend withdrawal for 15 years
fix dividend at 8% every year
Comparison
profit - 73741.5
must have good discipline to spend for every month
can be withdrawn for emergency
i also do the same calculation using excel.
the nett profit for loan is HIGHER than w/o loan IF the total payable amount is LESS than rm82,500 (which is rm5500/year).
but IF the total payable amount is MORE than rm82,500, the nett profit for loan is LOWER.
CONCLUSION : it's better do w/o loan for yearly payment more than RM5500.