QUOTE(Phoeni_142 @ Mar 26 2009, 01:01 AM)
Hi, you got the principle right - but the rates wrong. Basically - the 12% is a flat rate. Yes, you have to convert it into an effective rate for an apple-to-apple comparison with credit card rates.
there's too much to type - and it's been a long day. Basically - pls google up "Rule of 78". That's how personal loan interest is callculated. Interest is already predefined every month - and is NOT reducing balance.
Using your example of 12% - the equivalent effective interest rates is as follows:
Year 1: 22.4%
Year 2: 20.2%
Year 3: 18.3%
Year 4: 16.8%
Year 5: 15.5%
If you noticed - Rule of 78 allocates a much higher disproportionate amount of interest in the earlier part of the loan tenure. The effective interest rate over the 5 years is 20.3% - based on the 12% flat rate.
If I've managed to confuse you - pls google up Rule of 78. It'll be clearer then. Hopefully, awareness of this issue will be spread to the unsuspecting public.
er, i dont think my tables represent the same thing as what you are trying to convey, my tables represent what the credit card interest has to be in order for the last month of the tenure loan duration to be equals to zero while yours is the profit interest charged by the bank. ok a bit confusing let me put some examples from excel.there's too much to type - and it's been a long day. Basically - pls google up "Rule of 78". That's how personal loan interest is callculated. Interest is already predefined every month - and is NOT reducing balance.
Using your example of 12% - the equivalent effective interest rates is as follows:
Year 1: 22.4%
Year 2: 20.2%
Year 3: 18.3%
Year 4: 16.8%
Year 5: 15.5%
If you noticed - Rule of 78 allocates a much higher disproportionate amount of interest in the earlier part of the loan tenure. The effective interest rate over the 5 years is 20.3% - based on the 12% flat rate.
If I've managed to confuse you - pls google up Rule of 78. It'll be clearer then. Hopefully, awareness of this issue will be spread to the unsuspecting public.
for a 1 year 10k 12% personal loan
monthly payment 933.33
int on remaining principle
interest
21.4571843
1st column:month
2nd column:principle+interest
3rd column:2nd column-monthly payment
1 10,179 9,245
2 9,411 8,477
3 8,629 7,696
4 7,833 6,900
5 7,023 6,090
6 6,199 5,266
7 5,360 4,426
8 4,506 3,572
9 3,636 2,703
10 2,751 1,818
11 1,850 917
12 933 0
for a 5 years 10k 12% personal loan
monthly payment 266.66
int on remaining principle
interest
20.30999876
1st column:month
2nd column:principle+interest
3rd column:2nd column-monthly payment
year1
1 10,169 9,903
2 10,070 9,804
3 9,969 9,703
4 9,867 9,600
5 9,763 9,496
6 9,657 9,390
7 9,549 9,282
8 9,440 9,173
9 9,328 9,061
10 9,215 8,948
11 9,100 8,833
12 8,982 8,716
year2
1 8,863 8,597
2 8,742 8,475
3 8,619 8,352
4 8,494 8,227
5 8,366 8,100
6 8,237 7,970
7 8,105 7,838
8 7,971 7,704
9 7,835 7,568
10 7,696 7,429
11 7,555 7,288
12 7,412 7,145
year3
1 7,266 6,999
2 7,118 6,851
3 6,967 6,700
4 6,814 6,547
5 6,658 6,391
6 6,499 6,233
7 6,338 6,072
8 6,174 5,908
9 6,008 5,741
10 5,838 5,572
11 5,666 5,399
12 5,491 5,224
year4
1 5,312 5,046
2 5,131 4,864
3 4,947 4,680
4 4,759 4,493
5 4,569 4,302
6 4,375 4,108
7 4,178 3,911
8 3,977 3,710
9 3,773 3,507
10 3,566 3,299
11 3,355 3,088
12 3,141 2,874
year5
1 2,923 2,656
2 2,701 2,434
3 2,476 2,209
4 2,246 1,980
5 2,013 1,746
6 1,776 1,509
7 1,535 1,268
8 1,290 1,023
9 1,040 774
10 787 520
11 529 262
12 267 0
for me to compare the credit card interest rate which they charge monthly, i also have to use a monthly rest way to calculate the equivalent interest rate to have a more direct picture. if my tables are wrong please tell me.
for the rule 78 ive googled for some reference
This is what i get for using the 78 rule for 5 years
loan 10000
total month 1830
int charged 6000
interest 12%
1st colum:inverse month
2nd column:month
3rd column:int charged
4th column:rm
60 1 0.03279 196.72
59 2 0.03224 193.44
58 3 0.03169 190.16
57 4 0.03115 186.89
56 5 0.03060 183.61
55 6 0.03005 180.33
54 7 0.02951 177.05
53 8 0.02896 173.77
52 9 0.02842 170.49
51 10 0.02787 167.21 sum 1 to 12 mnth
50 11 0.02732 163.93 int rm
49 12 0.02678 160.66 0.35738 2144.26
48 13 0.02623 157.38
47 14 0.02568 154.10
46 15 0.02514 150.82
45 16 0.02459 147.54
44 17 0.02404 144.26
43 18 0.02350 140.98
42 19 0.02295 137.70
41 20 0.02240 134.43
40 21 0.02186 131.15
39 22 0.02131 127.87 sum 13 to 24 mnth
38 23 0.02077 124.59 int rm
37 24 0.02022 121.31 0.27869 1672.13
36 25 0.01967 118.03
35 26 0.01913 114.75
34 27 0.01858 111.48
33 28 0.01803 108.20
32 29 0.01749 104.92
31 30 0.01694 101.64
30 31 0.01639 98.36
29 32 0.01585 95.08
28 33 0.01530 91.80
27 34 0.01475 88.52 sum 25 to 36 mnth
26 35 0.01421 85.25 int rm
25 36 0.01366 81.97 0.20000 1200.00
24 37 0.01311 78.69
23 38 0.01257 75.41
22 39 0.01202 72.13
21 40 0.01148 68.85
20 41 0.01093 65.57
19 42 0.01038 62.30
18 43 0.00984 59.02
17 44 0.00929 55.74
16 45 0.00874 52.46
15 46 0.00820 49.18 sum 37 to 48 mnth
14 47 0.00765 45.90 int rm
13 48 0.00710 42.62 0.12131 727.87
12 49 0.00656 39.34
11 50 0.00601 36.07
10 51 0.00546 32.79
9 52 0.00492 29.51
8 53 0.00437 26.23
7 54 0.00383 22.95
6 55 0.00328 19.67
5 56 0.00273 16.39
4 57 0.00219 13.11
3 58 0.00164 9.84 sum 49 to 60 mnth
2 59 0.00109 6.56 int rm
1 60 0.00055 3.28 0.04262 255.74
total 1.00000 6000
did i get it correct? so the table for respective year interest charged for a 5 year loan is
yr1 35.7%
yr2 27.9%
yr3 20.0%
yr4 12.1%
yr5 4.3%
my table seems different from yours, enlighten me please?
the tables somehow does not display correctly, let me try and edit...
this is so not table display friendly! hope that the readers can see what the tables mean.
2 cents
This post has been edited by mouldybread: Mar 26 2009, 10:47 AM
Mar 26 2009, 10:31 AM

Quote
0.0196sec
0.47
6 queries
GZIP Disabled