< mobicred installment table – TimeVizion.com

mobicred installment table

Repo 5.75% change when repo changes
Current Max As per NCA 22.65%
 
Actual Installment Calculation: PMT(Interest Rate/12, 12, Cash Price) * -1
 
REFER TABLE BELOW FOR TEST PURPOSES - Columns B (Actual Instalment) and D (Actual CoC)
 
A   B   C   D   E   F
                     
Cash Price   Monthly Instalment
actual 
  Monthly Instalment
rounded-up
  Total Credit Price
actual
  Total Credit Price
rounded (based on D)
  Total Credit Price
rounded (based on C x 12)
                     
R 199.99   R 18.78   R 19.00   R 225.37   R 226.00   R 228.00
R 499.00   R 46.86   R 47.00   R 562.32   R 563.00   R 564.00
R 599.00   R 56.25   R 57.00   R 675.01   R 676.00   R 684.00
R 699.00   R 65.64   R 66.00   R 787.70   R 788.00   R 792.00
R 799.00   R 75.03   R 76.00   R 900.39   R 901.00   R 912.00
R 899.00   R 84.42   R 85.00   R 1,013.07   R 1,014.00   R 1,020.00
R 999.00   R 93.81   R 94.00   R 1,125.76   R 1,126.00   R 1,128.00
R 1,199.00   R 112.60   R 113.00   R 1,351.14   R 1,352.00   R 1,356.00
R 1,299.00   R 121.99   R 122.00   R 1,463.83   R 1,464.00   R 1,464.00
R 1,399.00   R 131.38   R 132.00   R 1,576.52   R 1,577.00   R 1,584.00
R 1,499.00   R 140.77   R 141.00   R 1,689.21   R 1,690.00   R 1,692.00
R 1,599.00   R 150.16   R 151.00   R 1,801.90   R 1,802.00   R 1,812.00
R 1,699.00   R 159.55   R 160.00   R 1,914.59   R 1,915.00   R 1,920.00
R 1,799.00   R 168.94   R 169.00   R 2,027.27   R 2,028.00   R 2,028.00
R 1,899.00   R 178.33   R 179.00   R 2,139.96   R 2,140.00   R 2,148.00
R 1,999.00   R 187.72   R 188.00   R 2,252.65   R 2,253.00   R 2,256.00
R 2,199.00   R 206.50   R 207.00   R 2,478.03   R 2,479.00   R 2,484.00
R 2,299.00   R 215.89   R 216.00   R 2,590.72   R 2,591.00   R 2,592.00
R 2,399.00   R 225.28   R 226.00   R 2,703.41   R 2,704.00   R 2,712.00
R 2,499.00   R 234.67   R 235.00   R 2,816.10   R 2,817.00   R 2,820.00
R 2,599.00   R 244.07   R 245.00   R 2,928.79   R 2,929.00   R 2,940.00
R 2,699.00   R 253.46   R 254.00   R 3,041.48   R 3,042.00   R 3,048.00
R 2,799.00   R 262.85   R 263.00   R 3,154.16   R 3,155.00   R 3,156.00
R 2,899.00   R 272.24   R 273.00   R 3,266.85   R 3,267.00   R 3,276.00
R 2,999.00   R 281.63   R 282.00   R 3,379.54   R 3,380.00   R 3,384.00
R 3,499.00   R 328.58   R 329.00   R 3,942.99   R 3,943.00   R 3,948.00
R 3,999.00   R 375.54   R 376.00   R 4,506.43   R 4,507.00   R 4,512.00
R 4,500.00   R 422.58   R 423.00   R 5,071.00   R 5,072.00  

R 5,076.00

Try your luck Spinner icon