Car Loan Calculator
This document was uploaded by user and they confirmed that they have the permission to share it. If you are author or own the copyright of this book, please report to us by using this DMCA report form. Report DMCA
Overview
Download & View Car Loan Calculator as PDF for free.
More details
- Words: 647
- Pages: 1
Car loan calculator
Year 3
Duration 1st month 2nd month 3rd month 4th month 5th month 6th month 7th month 8th month 9th month 10th month 11th month 12th month
469.64 939.29 1408.93 1878.57 2348.21 2817.86 3287.50 3757.14 4226.79 4696.43 5166.07 5635.71
Balance 38980.36 38510.71 38041.07 37571.43 37101.79 36632.14 36162.50 35692.86 35223.21 34753.57 34283.93 33814.29
Monthly Acc Balance pay 469.64 6105.36 33344.64 469.64 6575.00 32875.00 469.64 7044.64 32405.36 469.64 7514.29 31935.71 469.64 7983.93 31466.07 469.64 8453.57 30996.43 469.64 8923.21 30526.79 469.64 9392.86 30057.14 469.64 9862.50 29587.50 469.64 10332.14 29117.86 469.64 10801.79 28648.21 469.64 11271.43 28178.57 Monthly pay 469.64 469.64 469.64 469.64 469.64 469.64 469.64 469.64 469.64 469.64 469.64 469.64
Acc
Balance
11741.07 12210.71 12680.36 13150.00 13619.64 14089.29 14558.93 15028.57 15498.21 15967.86 16437.50 16907.14
27708.93 27239.29 26769.64 26300.00 25830.36 25360.71 24891.07 24421.43 23951.79 23482.14 23012.50 22542.86
Duration 1st month 2nd month 3rd month 4th month 5th month 6th month 7th month 8th month 9th month 10th month 11th month 12th month Duration 1st month 2nd month 3rd month 4th month 5th month 6th month 7th month 8th month 9th month 10th month 11th month 12th month Duration 1st month 2nd month 3rd month 4th month 5th month 6th month 7th month 8th month 9th month 10th month 11th month 12th month
Monthly pay 469.64 469.64 469.64 469.64 469.64 469.64 469.64 469.64 469.64 469.64 469.64 469.64 Monthly pay 469.64 469.64 469.64 469.64 469.64 469.64 469.64 469.64 469.64 469.64 469.64 469.64 Monthly pay 469.64 469.64 469.64 469.64 469.64 469.64 469.64 469.64 469.64 469.64 469.64 469.64
Acc
Balance
17376.79 17846.43 18316.07 18785.71 19255.36 19725.00 20194.64 20664.29 21133.93 21603.57 22073.21 22542.86
22073.21 21603.57 21133.93 20664.29 20194.64 19725.00 19255.36 18785.71 18316.07 17846.43 17376.79 16907.14
Acc
Balance
23012.50 23482.14 23951.79 24421.43 24891.07 25360.71 25830.36 26300.00 26769.64 27239.29 27708.93 28178.57
16437.50 15967.86 15498.21 15028.57 14558.93 14089.29 13619.64 13150.00 12680.36 12210.71 11741.07 11271.43
Acc
Balance
28648.21 10801.79 29117.86 10332.14 29587.50 9862.50 30057.14 9392.86 30526.79 8923.21 30996.43 8453.57 31466.07 7983.93 31935.71 7514.29 32405.36 7044.64 32875.00 6575.00 33344.64 6105.36 33814.29 5635.71
RM RM RM RM
-5000 9450 39450 469.64
Duration
Year 7
Acc
Year 4
Monthly pay 469.64 469.64 469.64 469.64 469.64 469.64 469.64 469.64 469.64 469.64 469.64 469.64
25000 30000 4.50% 7
1st month 2nd month 3rd month 4th month 5th month 6th month 7th month 8th month 9th month 10th month 11th month 12th month Duration
Year 8
1st month 2nd month 3rd month 4th month 5th month 6th month 7th month 8th month 9th month 10th month 11th month 12th month
D/payment Total interest Total payable Monthly pay
RM RM % Years
1st month 2nd month 3rd month 4th month 5th month 6th month 7th month 8th month 9th month 10th month 11th month 12th month Duration
Year 9
Year 2
Duration
Car prize Loan Interest / year Year loan
Year 5
1st month 2nd month 3rd month 4th month 5th month 6th month 7th month 8th month 9th month 10th month 11th month 12th month
Result is below:
Year 6
Year 1
Duration
Fill in the coloum below (yellow row)
1st month 2nd month 3rd month 4th month 5th month 6th month 7th month 8th month 9th month 10th month 11th month 12th month
Monthly pay 469.64 469.64 469.64 469.64 469.64 469.64 469.64 469.64 469.64 469.64 469.64 469.64
34283.93 34753.57 35223.21 35692.86 36162.50 36632.14 37101.79 37571.43 38041.07 38510.71 38980.36 39450.00
Monthly pay 469.64 469.64 469.64 469.64 469.64 469.64 469.64 469.64 469.64 469.64 469.64 469.64
39919.64 40389.29 40858.93 41328.57 41798.21 42267.86 42737.50 43207.14 43676.79 44146.43 44616.07 45085.71
Monthly pay 469.64 469.64 469.64 469.64 469.64 469.64 469.64 469.64 469.64 469.64 469.64 469.64
Acc
Acc
Acc
Balance 5166.07 4696.43 4226.79 3757.14 3287.50 2817.86 2348.21 1878.57 1408.93 939.29 469.64 0.00 Balance -469.64 -939.29 -1408.93 -1878.57 -2348.21 -2817.86 -3287.50 -3757.14 -4226.79 -4696.43 -5166.07 -5635.71 Balance
45555.36 -6105.36 46025.00 -6575.00 46494.64 -7044.64 46964.29 -7514.29 47433.93 -7983.93 47903.57 -8453.57 48373.21 -8923.21 48842.86 -9392.86 49312.50 -9862.50 49782.14 -10332.14 50251.79 -10801.79 50721.43 -11271.43
Year 3
Duration 1st month 2nd month 3rd month 4th month 5th month 6th month 7th month 8th month 9th month 10th month 11th month 12th month
469.64 939.29 1408.93 1878.57 2348.21 2817.86 3287.50 3757.14 4226.79 4696.43 5166.07 5635.71
Balance 38980.36 38510.71 38041.07 37571.43 37101.79 36632.14 36162.50 35692.86 35223.21 34753.57 34283.93 33814.29
Monthly Acc Balance pay 469.64 6105.36 33344.64 469.64 6575.00 32875.00 469.64 7044.64 32405.36 469.64 7514.29 31935.71 469.64 7983.93 31466.07 469.64 8453.57 30996.43 469.64 8923.21 30526.79 469.64 9392.86 30057.14 469.64 9862.50 29587.50 469.64 10332.14 29117.86 469.64 10801.79 28648.21 469.64 11271.43 28178.57 Monthly pay 469.64 469.64 469.64 469.64 469.64 469.64 469.64 469.64 469.64 469.64 469.64 469.64
Acc
Balance
11741.07 12210.71 12680.36 13150.00 13619.64 14089.29 14558.93 15028.57 15498.21 15967.86 16437.50 16907.14
27708.93 27239.29 26769.64 26300.00 25830.36 25360.71 24891.07 24421.43 23951.79 23482.14 23012.50 22542.86
Duration 1st month 2nd month 3rd month 4th month 5th month 6th month 7th month 8th month 9th month 10th month 11th month 12th month Duration 1st month 2nd month 3rd month 4th month 5th month 6th month 7th month 8th month 9th month 10th month 11th month 12th month Duration 1st month 2nd month 3rd month 4th month 5th month 6th month 7th month 8th month 9th month 10th month 11th month 12th month
Monthly pay 469.64 469.64 469.64 469.64 469.64 469.64 469.64 469.64 469.64 469.64 469.64 469.64 Monthly pay 469.64 469.64 469.64 469.64 469.64 469.64 469.64 469.64 469.64 469.64 469.64 469.64 Monthly pay 469.64 469.64 469.64 469.64 469.64 469.64 469.64 469.64 469.64 469.64 469.64 469.64
Acc
Balance
17376.79 17846.43 18316.07 18785.71 19255.36 19725.00 20194.64 20664.29 21133.93 21603.57 22073.21 22542.86
22073.21 21603.57 21133.93 20664.29 20194.64 19725.00 19255.36 18785.71 18316.07 17846.43 17376.79 16907.14
Acc
Balance
23012.50 23482.14 23951.79 24421.43 24891.07 25360.71 25830.36 26300.00 26769.64 27239.29 27708.93 28178.57
16437.50 15967.86 15498.21 15028.57 14558.93 14089.29 13619.64 13150.00 12680.36 12210.71 11741.07 11271.43
Acc
Balance
28648.21 10801.79 29117.86 10332.14 29587.50 9862.50 30057.14 9392.86 30526.79 8923.21 30996.43 8453.57 31466.07 7983.93 31935.71 7514.29 32405.36 7044.64 32875.00 6575.00 33344.64 6105.36 33814.29 5635.71
RM RM RM RM
-5000 9450 39450 469.64
Duration
Year 7
Acc
Year 4
Monthly pay 469.64 469.64 469.64 469.64 469.64 469.64 469.64 469.64 469.64 469.64 469.64 469.64
25000 30000 4.50% 7
1st month 2nd month 3rd month 4th month 5th month 6th month 7th month 8th month 9th month 10th month 11th month 12th month Duration
Year 8
1st month 2nd month 3rd month 4th month 5th month 6th month 7th month 8th month 9th month 10th month 11th month 12th month
D/payment Total interest Total payable Monthly pay
RM RM % Years
1st month 2nd month 3rd month 4th month 5th month 6th month 7th month 8th month 9th month 10th month 11th month 12th month Duration
Year 9
Year 2
Duration
Car prize Loan Interest / year Year loan
Year 5
1st month 2nd month 3rd month 4th month 5th month 6th month 7th month 8th month 9th month 10th month 11th month 12th month
Result is below:
Year 6
Year 1
Duration
Fill in the coloum below (yellow row)
1st month 2nd month 3rd month 4th month 5th month 6th month 7th month 8th month 9th month 10th month 11th month 12th month
Monthly pay 469.64 469.64 469.64 469.64 469.64 469.64 469.64 469.64 469.64 469.64 469.64 469.64
34283.93 34753.57 35223.21 35692.86 36162.50 36632.14 37101.79 37571.43 38041.07 38510.71 38980.36 39450.00
Monthly pay 469.64 469.64 469.64 469.64 469.64 469.64 469.64 469.64 469.64 469.64 469.64 469.64
39919.64 40389.29 40858.93 41328.57 41798.21 42267.86 42737.50 43207.14 43676.79 44146.43 44616.07 45085.71
Monthly pay 469.64 469.64 469.64 469.64 469.64 469.64 469.64 469.64 469.64 469.64 469.64 469.64
Acc
Acc
Acc
Balance 5166.07 4696.43 4226.79 3757.14 3287.50 2817.86 2348.21 1878.57 1408.93 939.29 469.64 0.00 Balance -469.64 -939.29 -1408.93 -1878.57 -2348.21 -2817.86 -3287.50 -3757.14 -4226.79 -4696.43 -5166.07 -5635.71 Balance
45555.36 -6105.36 46025.00 -6575.00 46494.64 -7044.64 46964.29 -7514.29 47433.93 -7983.93 47903.57 -8453.57 48373.21 -8923.21 48842.86 -9392.86 49312.50 -9862.50 49782.14 -10332.14 50251.79 -10801.79 50721.43 -11271.43
Related Documents
Car Loan Calculator
May 2020 16
Loan Calculator
May 2020 14
Personal Loan Emi Calculator
April 2020 13
Car Loan Cash
June 2020 4