0% found this document useful (0 votes)
150 views16 pages

Car Loan EMI Breakdown

The document is a car loan EMI calculator that shows the breakdown of payments for a Rs. 6,00,000 loan over 12 months at 8% interest. It displays the EMI amount, principal paid, interest for each period and the outstanding principal. The equivalent simple interest rate for the loan is calculated to be 3.69%.

Uploaded by

jiguparmar1516
Copyright
© Attribution Non-Commercial (BY-NC)
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLS, PDF, TXT or read online on Scribd
0% found this document useful (0 votes)
150 views16 pages

Car Loan EMI Breakdown

The document is a car loan EMI calculator that shows the breakdown of payments for a Rs. 6,00,000 loan over 12 months at 8% interest. It displays the EMI amount, principal paid, interest for each period and the outstanding principal. The equivalent simple interest rate for the loan is calculated to be 3.69%.

Uploaded by

jiguparmar1516
Copyright
© Attribution Non-Commercial (BY-NC)
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLS, PDF, TXT or read online on Scribd
You are on page 1/ 16

:CAR LOAN EMI CALCULATOR:

Loan Amount 600000.00


Loan Duration 1 Year 1 (Select 1 to 6 Years)
Interest Rate 8.00%
Advance EMI Yes Yes (Select Yes/No)

Total: 622168.90 600000.00 22168.90

EMI No. EMI Amount Principal Interest


1 51847.41 51847.41 0.00
2 51847.41 48193.06 3654.35
3 51847.41 48514.34 3333.06
4 51847.41 48837.77 3009.63
5 51847.41 49163.36 2684.05
6 51847.41 49491.11 2356.29
7 51847.41 49821.06 2026.35
8 51847.41 50153.20 1694.21
9 51847.41 50487.55 1359.86
10 51847.41 50824.13 1023.27
11 51847.41 51162.96 684.45
12 51847.41 51504.05 343.36
0 0.00 0.00 0.00
0 0.00 0.00 0.00
0 0.00 0.00 0.00
0 0.00 0.00 0.00
0 0.00 0.00 0.00
0 0.00 0.00 0.00
0 0.00 0.00 0.00
0 0.00 0.00 0.00
0 0.00 0.00 0.00
0 0.00 0.00 0.00
0 0.00 0.00 0.00
0 0.00 0.00 0.00
0 0.00 0.00 0.00
0 0.00 0.00 0.00
0 0.00 0.00 0.00
0 0.00 0.00 0.00
0 0.00 0.00 0.00
0 0.00 0.00 0.00
0 0.00 0.00 0.00
0 0.00 0.00 0.00
0 0.00 0.00 0.00
0 0.00 0.00 0.00
0 0.00 0.00 0.00
0 0.00 0.00 0.00
0 0.00 0.00 0.00
0 0.00 0.00 0.00
0 0.00 0.00 0.00
0 0.00 0.00 0.00
0 0.00 0.00 0.00
0 0.00 0.00 0.00
0 0.00 0.00 0.00
0 0.00 0.00 0.00
0 0.00 0.00 0.00
0 0.00 0.00 0.00
0 0.00 0.00 0.00
0 0.00 0.00 0.00
0 0.00 0.00 0.00
0 0.00 0.00 0.00
0 0.00 0.00 0.00
0 0.00 0.00 0.00
0 0.00 0.00 0.00
0 0.00 0.00 0.00
0 0.00 0.00 0.00
0 0.00 0.00 0.00
0 0.00 0.00 0.00
0 0.00 0.00 0.00
0 0.00 0.00 0.00
0 0.00 0.00 0.00
0 0.00 0.00 0.00
0 0.00 0.00 0.00
0 0.00 0.00 0.00
0 0.00 0.00 0.00
0 0.00 0.00 0.00
0 0.00 0.00 0.00
0 0.00 0.00 0.00
0 0.00 0.00 0.00
0 0.00 0.00 0.00
0 0.00 0.00 0.00
0 0.00 0.00 0.00
0 0.00 0.00 0.00
JIGNESH.PARMAR
JIGNESH.PARMAR
www.jiguparmar.wordpress.com
www.jiguparmar.wordpress.com
jiguparmar@yahoo.com

Equivalent simple interest rate 3.69 %

Outstanding Principal
548152.59
499959.53
451445.19
402607.42
353444.06
303952.94
254131.89
203978.69
153491.14
102667.01
51504.05
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
Loan Amount 600,000.00
Loan Duration 12
Interest Rate 8.00%
Advance EMI Yes

EMI No. EMI Amount Principal Interest Outstanding Principal


1 51,847.41 51,847.41 0.00 548,152.59
2 51,847.41 48,193.06 3,654.35 499,959.53
3 51,847.41 48,514.34 3,333.06 451,445.19
4 51,847.41 48,837.77 3,009.63 402,607.42
5 51,847.41 49,163.36 2,684.05 353,444.06
6 51,847.41 49,491.11 2,356.29 303,952.94
7 51,847.41 49,821.06 2,026.35 254,131.89
8 51,847.41 50,153.20 1,694.21 203,978.69
9 51,847.41 50,487.55 1,359.86 153,491.14
10 51,847.41 50,824.13 1,023.27 102,667.01
11 51,847.41 51,162.96 684.45 51,504.05
12 51,847.41 51,504.05 343.36 0.00
Totals 622,168.90 600,000.00 22,168.90

Equivalent simple interest rate 3.69 %


Loan Amount 600,000.00
Loan Duration 24
Interest Rate 8.00%
Advance EMI Yes

EMI No. EMI Amount Principal Interest Outstanding Principal


1 26,956.66 26,956.66 0.00 573,043.34
2 26,956.66 23,136.37 3,820.29 549,906.96
3 26,956.66 23,290.62 3,666.05 526,616.34
4 26,956.66 23,445.89 3,510.78 503,170.46
5 26,956.66 23,602.19 3,354.47 479,568.26
6 26,956.66 23,759.54 3,197.12 455,808.72
7 26,956.66 23,917.94 3,038.72 431,890.78
8 26,956.66 24,077.39 2,879.27 407,813.39
9 26,956.66 24,237.91 2,718.76 383,575.48
10 26,956.66 24,399.49 2,557.17 359,175.99
11 26,956.66 24,562.16 2,394.51 334,613.83
12 26,956.66 24,725.90 2,230.76 309,887.92
13 26,956.66 24,890.74 2,065.92 284,997.18
14 26,956.66 25,056.68 1,899.98 259,940.50
15 26,956.66 25,223.73 1,732.94 234,716.77
16 26,956.66 25,391.89 1,564.78 209,324.89
17 26,956.66 25,561.16 1,395.50 183,763.72
18 26,956.66 25,731.57 1,225.09 158,032.15
19 26,956.66 25,903.12 1,053.55 132,129.03
20 26,956.66 26,075.80 880.86 106,053.23
21 26,956.66 26,249.64 707.02 79,803.59
22 26,956.66 26,424.64 532.02 53,378.95
23 26,956.66 26,600.80 355.86 26,778.14
24 26,956.66 26,778.14 178.52 0.00
Totals 646,959.93 600,000.00 46,959.93

Equivalent simple interest rate 3.91 %


Loan Amount 600,000.00
Loan Duration 36
Interest Rate 8.00%
Advance EMI Yes

EMI No. EMI Amount Principal Interest Outstanding Principal


1 18,677.30 18,677.30 0.00 581,322.70
2 18,677.30 14,801.82 3,875.48 566,520.88
3 18,677.30 14,900.50 3,776.81 551,620.38
4 18,677.30 14,999.83 3,677.47 536,620.54
5 18,677.30 15,099.83 3,577.47 521,520.71
6 18,677.30 15,200.50 3,476.80 506,320.21
7 18,677.30 15,301.84 3,375.47 491,018.38
8 18,677.30 15,403.85 3,273.46 475,614.53
9 18,677.30 15,506.54 3,170.76 460,107.99
10 18,677.30 15,609.92 3,067.39 444,498.07
11 18,677.30 15,713.98 2,963.32 428,784.09
12 18,677.30 15,818.74 2,858.56 412,965.34
13 18,677.30 15,924.20 2,753.10 397,041.14
14 18,677.30 16,030.36 2,646.94 381,010.78
15 18,677.30 16,137.23 2,540.07 364,873.55
16 18,677.30 16,244.81 2,432.49 348,628.73
17 18,677.30 16,353.11 2,324.19 332,275.62
18 18,677.30 16,462.13 2,215.17 315,813.49
19 18,677.30 16,571.88 2,105.42 299,241.61
20 18,677.30 16,682.36 1,994.94 282,559.25
21 18,677.30 16,793.58 1,883.73 265,765.67
22 18,677.30 16,905.53 1,771.77 248,860.14
23 18,677.30 17,018.24 1,659.07 231,841.90
24 18,677.30 17,131.69 1,545.61 214,710.21
25 18,677.30 17,245.90 1,431.40 197,464.31
26 18,677.30 17,360.88 1,316.43 180,103.43
27 18,677.30 17,476.61 1,200.69 162,626.82
28 18,677.30 17,593.13 1,084.18 145,033.69
29 18,677.30 17,710.41 966.89 127,323.28
30 18,677.30 17,828.48 848.82 109,494.80
31 18,677.30 17,947.34 729.97 91,547.46
32 18,677.30 18,066.99 610.32 73,480.47
33 18,677.30 18,187.43 489.87 55,293.04
34 18,677.30 18,308.68 368.62 36,984.35
35 18,677.30 18,430.74 246.56 18,553.61
36 18,677.30 18,553.61 123.69 0.00
Totals 672,382.94 600,000.00 72,382.94

Equivalent simple interest rate 4.02 %


Loan Amount 600,000.00
Loan Duration 48
Interest Rate 8.00%
Advance EMI Yes

EMI No. EMI Amount Principal Interest Outstanding Principal


1 14,550.75 14,550.75 0.00 585,449.25
2 14,550.75 10,647.75 3,903.00 574,801.50
3 14,550.75 10,718.74 3,832.01 564,082.76
4 14,550.75 10,790.20 3,760.55 553,292.56
5 14,550.75 10,862.13 3,688.62 542,430.43
6 14,550.75 10,934.55 3,616.20 531,495.89
7 14,550.75 11,007.44 3,543.31 520,488.44
8 14,550.75 11,080.83 3,469.92 509,407.62
9 14,550.75 11,154.70 3,396.05 498,252.92
10 14,550.75 11,229.06 3,321.69 487,023.86
11 14,550.75 11,303.92 3,246.83 475,719.94
12 14,550.75 11,379.28 3,171.47 464,340.65
13 14,550.75 11,455.14 3,095.60 452,885.51
14 14,550.75 11,531.51 3,019.24 441,354.00
15 14,550.75 11,608.39 2,942.36 429,745.61
16 14,550.75 11,685.78 2,864.97 418,059.83
17 14,550.75 11,763.68 2,787.07 406,296.15
18 14,550.75 11,842.11 2,708.64 394,454.04
19 14,550.75 11,921.05 2,629.69 382,532.99
20 14,550.75 12,000.53 2,550.22 370,532.46
21 14,550.75 12,080.53 2,470.22 358,451.93
22 14,550.75 12,161.07 2,389.68 346,290.86
23 14,550.75 12,242.14 2,308.61 334,048.71
24 14,550.75 12,323.76 2,226.99 321,724.96
25 14,550.75 12,405.92 2,144.83 309,319.04
26 14,550.75 12,488.62 2,062.13 296,830.42
27 14,550.75 12,571.88 1,978.87 284,258.54
28 14,550.75 12,655.69 1,895.06 271,602.85
29 14,550.75 12,740.06 1,810.69 258,862.79
30 14,550.75 12,825.00 1,725.75 246,037.79
31 14,550.75 12,910.50 1,640.25 233,127.29
32 14,550.75 12,996.57 1,554.18 220,130.73
33 14,550.75 13,083.21 1,467.54 207,047.52
34 14,550.75 13,170.43 1,380.32 193,877.09
35 14,550.75 13,258.23 1,292.51 180,618.85
36 14,550.75 13,346.62 1,204.13 167,272.23
37 14,550.75 13,435.60 1,115.15 153,836.63
38 14,550.75 13,525.17 1,025.58 140,311.46
39 14,550.75 13,615.34 935.41 126,696.12
40 14,550.75 13,706.11 844.64 112,990.01
41 14,550.75 13,797.48 753.27 99,192.53
42 14,550.75 13,889.46 661.28 85,303.06
43 14,550.75 13,982.06 568.69 71,321.00
44 14,550.75 14,075.28 475.47 57,245.73
45 14,550.75 14,169.11 381.64 43,076.62
46 14,550.75 14,263.57 287.18 28,813.05
47 14,550.75 14,358.66 192.09 14,454.39
48 14,550.75 14,454.39 96.36 0.00

Totals 698,435.92 600,000.00 98,435.92

Equivalent simple interest rate 4.10 %


Loan Amount 600,000.00
Loan Duration 60
Interest Rate 8.00%
Advance EMI Yes

EMI No. EMI Amount Principal Interest Outstanding Principal


1 12,085.27 12,085.27 0.00 587,914.73
2 12,085.27 8,165.84 3,919.43 579,748.90
3 12,085.27 8,220.28 3,864.99 571,528.62
4 12,085.27 8,275.08 3,810.19 563,253.54
5 12,085.27 8,330.24 3,755.02 554,923.30
6 12,085.27 8,385.78 3,699.49 546,537.52
7 12,085.27 8,441.68 3,643.58 538,095.83
8 12,085.27 8,497.96 3,587.31 529,597.87
9 12,085.27 8,554.62 3,530.65 521,043.26
10 12,085.27 8,611.65 3,473.62 512,431.61
11 12,085.27 8,669.06 3,416.21 503,762.55
12 12,085.27 8,726.85 3,358.42 495,035.70
13 12,085.27 8,785.03 3,300.24 486,250.67
14 12,085.27 8,843.60 3,241.67 477,407.07
15 12,085.27 8,902.55 3,182.71 468,504.52
16 12,085.27 8,961.90 3,123.36 459,542.61
17 12,085.27 9,021.65 3,063.62 450,520.96
18 12,085.27 9,081.80 3,003.47 441,439.17
19 12,085.27 9,142.34 2,942.93 432,296.83
20 12,085.27 9,203.29 2,881.98 423,093.54
21 12,085.27 9,264.64 2,820.62 413,828.89
22 12,085.27 9,326.41 2,758.86 404,502.49
23 12,085.27 9,388.58 2,696.68 395,113.90
24 12,085.27 9,451.18 2,634.09 385,662.73
25 12,085.27 9,514.18 2,571.08 376,148.54
26 12,085.27 9,577.61 2,507.66 366,570.93
27 12,085.27 9,641.46 2,443.81 356,929.47
28 12,085.27 9,705.74 2,379.53 347,223.73
29 12,085.27 9,770.44 2,314.82 337,453.29
30 12,085.27 9,835.58 2,249.69 327,617.71
31 12,085.27 9,901.15 2,184.12 317,716.56
32 12,085.27 9,967.16 2,118.11 307,749.40
33 12,085.27 10,033.61 2,051.66 297,715.80
34 12,085.27 10,100.50 1,984.77 287,615.30
35 12,085.27 10,167.83 1,917.44 277,447.47
36 12,085.27 10,235.62 1,849.65 267,211.85
37 12,085.27 10,303.86 1,781.41 256,907.99
38 12,085.27 10,372.55 1,712.72 246,535.44
39 12,085.27 10,441.70 1,643.57 236,093.75
40 12,085.27 10,511.31 1,573.96 225,582.44
41 12,085.27 10,581.39 1,503.88 215,001.05
42 12,085.27 10,651.93 1,433.34 204,349.12
43 12,085.27 10,722.94 1,362.33 193,626.18
44 12,085.27 10,794.43 1,290.84 182,831.75
45 12,085.27 10,866.39 1,218.88 171,965.37
46 12,085.27 10,938.83 1,146.44 161,026.53
47 12,085.27 11,011.76 1,073.51 150,014.77
48 12,085.27 11,085.17 1,000.10 138,929.61
49 12,085.27 11,159.07 926.20 127,770.53
50 12,085.27 11,233.46 851.80 116,537.07
51 12,085.27 11,308.35 776.91 105,228.72
52 12,085.27 11,383.74 701.52 93,844.97
53 12,085.27 11,459.63 625.63 82,385.34
54 12,085.27 11,536.03 549.24 70,849.30
55 12,085.27 11,612.94 472.33 59,236.37
56 12,085.27 11,690.36 394.91 47,546.01
57 12,085.27 11,768.29 316.97 35,777.71
58 12,085.27 11,846.75 238.52 23,930.96
59 12,085.27 11,925.73 159.54 12,005.23
60 12,085.27 12,005.23 80.03 0.00

Totals 725,116.09 600,000.00 125,116.09

Equivalent simple interest rate 4.17 %


Loan Amount 600,000.00
Loan Duration 72
Interest Rate 8.00%
Advance EMI Yes

EMI No. EMI Amount Principal Interest Outstanding Principal


1 10,450.28 10,450.28 0.00 589,549.72
2 10,450.28 6,519.94 3,930.33 583,029.78
3 10,450.28 6,563.41 3,886.87 576,466.37
4 10,450.28 6,607.17 3,843.11 569,859.20
5 10,450.28 6,651.21 3,799.06 563,207.99
6 10,450.28 6,695.56 3,754.72 556,512.43
7 10,450.28 6,740.19 3,710.08 549,772.24
8 10,450.28 6,785.13 3,665.15 542,987.11
9 10,450.28 6,830.36 3,619.91 536,156.75
10 10,450.28 6,875.90 3,574.38 529,280.85
11 10,450.28 6,921.74 3,528.54 522,359.12
12 10,450.28 6,967.88 3,482.39 515,391.23
13 10,450.28 7,014.33 3,435.94 508,376.90
14 10,450.28 7,061.10 3,389.18 501,315.80
15 10,450.28 7,108.17 3,342.11 494,207.63
16 10,450.28 7,155.56 3,294.72 487,052.07
17 10,450.28 7,203.26 3,247.01 479,848.81
18 10,450.28 7,251.28 3,198.99 472,597.53
19 10,450.28 7,299.63 3,150.65 465,297.90
20 10,450.28 7,348.29 3,101.99 457,949.61
21 10,450.28 7,397.28 3,053.00 450,552.33
22 10,450.28 7,446.59 3,003.68 443,105.74
23 10,450.28 7,496.24 2,954.04 435,609.50
24 10,450.28 7,546.21 2,904.06 428,063.29
25 10,450.28 7,596.52 2,853.76 420,466.77
26 10,450.28 7,647.16 2,803.11 412,819.61
27 10,450.28 7,698.15 2,752.13 405,121.46
28 10,450.28 7,749.47 2,700.81 397,371.99
29 10,450.28 7,801.13 2,649.15 389,570.87
30 10,450.28 7,853.14 2,597.14 381,717.73
31 10,450.28 7,905.49 2,544.78 373,812.24
32 10,450.28 7,958.19 2,492.08 365,854.04
33 10,450.28 8,011.25 2,439.03 357,842.79
34 10,450.28 8,064.66 2,385.62 349,778.14
35 10,450.28 8,118.42 2,331.85 341,659.72
36 10,450.28 8,172.54 2,277.73 333,487.17
37 10,450.28 8,227.03 2,223.25 325,260.14
38 10,450.28 8,281.87 2,168.40 316,978.27
39 10,450.28 8,337.09 2,113.19 308,641.18
40 10,450.28 8,392.67 2,057.61 300,248.51
41 10,450.28 8,448.62 2,001.66 291,799.89
42 10,450.28 8,504.94 1,945.33 283,294.95
43 10,450.28 8,561.64 1,888.63 274,733.31
44 10,450.28 8,618.72 1,831.56 266,114.59
45 10,450.28 8,676.18 1,774.10 257,438.41
46 10,450.28 8,734.02 1,716.26 248,704.39
47 10,450.28 8,792.25 1,658.03 239,912.14
48 10,450.28 8,850.86 1,599.41 231,061.28
49 10,450.28 8,909.87 1,540.41 222,151.41
50 10,450.28 8,969.27 1,481.01 213,182.15
51 10,450.28 9,029.06 1,421.21 204,153.08
52 10,450.28 9,089.26 1,361.02 195,063.83
53 10,450.28 9,149.85 1,300.43 185,913.98
54 10,450.28 9,210.85 1,239.43 176,703.13
55 10,450.28 9,272.25 1,178.02 167,430.87
56 10,450.28 9,334.07 1,116.21 158,096.80
57 10,450.28 9,396.30 1,053.98 148,700.51
58 10,450.28 9,458.94 991.34 139,241.57
59 10,450.28 9,522.00 928.28 129,719.57
60 10,450.28 9,585.48 864.80 120,134.09
61 10,450.28 9,649.38 800.89 110,484.71
62 10,450.28 9,713.71 736.56 100,771.00
63 10,450.28 9,778.47 671.81 90,992.53
64 10,450.28 9,843.66 606.62 81,148.87
65 10,450.28 9,909.28 540.99 71,239.59
66 10,450.28 9,975.35 474.93 61,264.24
67 10,450.28 10,041.85 408.43 51,222.39
68 10,450.28 10,108.79 341.48 41,113.60
69 10,450.28 10,176.19 274.09 30,937.42
70 10,450.28 10,244.03 206.25 20,693.39
71 10,450.28 10,312.32 137.96 10,381.07
72 10,450.28 10,381.07 69.21 0.00

Totals 752,419.86 600,000.00 152,419.86

Equivalent simple interest rate 4.23 %

You might also like