INPUT DATA (enter data from TC dashboard in brown cells) CALCULATED DATA
Bid amount £6,000 Interest rate per month 0.89972%
Repayment period (in months) 60 (max 150) Standard monthly repayment £129.84
Interest rate 10.75%
Loan repayment type interest+capital
Drawdown date 12/20/2013
First repayment date 1/12/2014

The table below splits the loan repayment each month into interest and capital

Notes:

  1. The calculated repayments apply to loans parts purchased by lenders on the Primary Market.
  2. The first repayment is adjusted for the length of time between drawdown and the first payment date.
  3.  The final capital repayment is adjusted to give a zero Closing Balance.
TOTALS: £7,783.56 £1,783.56 £6,000.00
Month Payment Date Monthly Repayment Interest Repayment Capital Repayment Closing Balance Total Interest Repaid Total Capital Repaid
1 1/12/2014 £109.19 £41.38 £67.81 £5,932.19 £41.38 £67.81
2 2/12/2014 £129.84 £53.37 £76.47 £5,855.72 £94.75 £144.28
3 3/12/2014 £129.84 £52.68 £77.16 £5,778.56 £147.43 £221.44
4 4/12/2014 £129.84 £51.99 £77.85 £5,700.71 £199.42 £299.29
5 5/12/2014 £129.84 £51.29 £78.55 £5,622.16 £250.71 £377.84
6 6/12/2014 £129.84 £50.58 £79.26 £5,542.90 £301.29 £457.10
7 7/12/2014 £129.84 £49.87 £79.97 £5,462.93 £351.16 £537.07
8 8/12/2014 £129.84 £49.15 £80.69 £5,382.24 £400.31 £617.76
9 9/12/2014 £129.84 £48.42 £81.42 £5,300.82 £448.73 £699.18
10 10/12/2014 £129.84 £47.69 £82.15 £5,218.67 £496.42 £781.33
11 11/12/2014 £129.84 £46.95 £82.89 £5,135.78 £543.37 £864.22
12 12/12/2014 £129.84 £46.20 £83.64 £5,052.14 £589.57 £947.86
13 1/12/2015 £129.84 £45.45 £84.39 £4,967.75 £635.02 £1,032.25
14 2/12/2015 £129.84 £44.69 £85.15 £4,882.60 £679.71 £1,117.40
15 3/12/2015 £129.84 £43.92 £85.92 £4,796.68 £723.63 £1,203.32
16 4/12/2015 £129.84 £43.15 £86.69 £4,709.99 £766.78 £1,290.01
17 5/12/2015 £129.84 £42.37 £87.47 £4,622.52 £809.15 £1,377.48
18 6/12/2015 £129.84 £41.58 £88.26 £4,534.26 £850.73 £1,465.74
19 7/12/2015 £129.84 £40.79 £89.05 £4,445.21 £891.52 £1,554.79
20 8/12/2015 £129.84 £39.99 £89.85 £4,355.36 £931.51 £1,644.64
21 9/12/2015 £129.84 £39.18 £90.66 £4,264.70 £970.69 £1,735.30
22 10/12/2015 £129.84 £38.37 £91.47 £4,173.23 £1,009.06 £1,826.77
23 11/12/2015 £129.84 £37.54 £92.30 £4,080.93 £1,046.60 £1,919.07
24 12/12/2015 £129.84 £36.71 £93.13 £3,987.80 £1,083.31 £2,012.20
25 1/12/2016 £129.84 £35.87 £93.97 £3,893.83 £1,119.18 £2,106.17
26 2/12/2016 £129.84 £35.03 £94.81 £3,799.02 £1,154.21 £2,200.98
27 3/12/2016 £129.84 £34.18 £95.66 £3,703.36 £1,188.39 £2,296.64
28 4/12/2016 £129.84 £33.31 £96.53 £3,606.83 £1,221.70 £2,393.17
29 5/12/2016 £129.84 £32.45 £97.39 £3,509.44 £1,254.15 £2,490.56
30 6/12/2016 £129.84 £31.57 £98.27 £3,411.17 £1,285.72 £2,588.83
31 7/12/2016 £129.84 £30.69 £99.15 £3,312.02 £1,316.41 £2,687.98
32 8/12/2016 £129.84 £29.79 £100.05 £3,211.97 £1,346.20 £2,788.03
33 9/12/2016 £129.84 £28.89 £100.95 £3,111.02 £1,375.09 £2,888.98
34 10/12/2016 £129.84 £27.99 £101.85 £3,009.17 £1,403.08 £2,990.83
35 11/12/2016 £129.84 £27.07 £102.77 £2,906.40 £1,430.15 £3,093.60
36 12/12/2016 £129.84 £26.14 £103.70 £2,802.70 £1,456.29 £3,197.30
37 1/12/2017 £129.84 £25.21 £104.63 £2,698.07 £1,481.50 £3,301.93
38 2/12/2017 £129.84 £24.27 £105.57 £2,592.50 £1,505.77 £3,407.50
39 3/12/2017 £129.84 £23.32 £106.52 £2,485.98 £1,529.09 £3,514.02
40 4/12/2017 £129.84 £22.36 £107.48 £2,378.50 £1,551.45 £3,621.50
41 5/12/2017 £129.84 £21.39 £108.45 £2,270.05 £1,572.84 £3,729.95
42 6/12/2017 £129.84 £20.42 £109.42 £2,160.63 £1,593.26 £3,839.37
43 7/12/2017 £129.84 £19.43 £110.41 £2,050.22 £1,612.69 £3,949.78
44 8/12/2017 £129.84 £18.44 £111.40 £1,938.82 £1,631.13 £4,061.18
45 9/12/2017 £129.84 £17.44 £112.40 £1,826.42 £1,648.57 £4,173.58
46 10/12/2017 £129.84 £16.43 £113.41 £1,713.01 £1,665.00 £4,286.99
47 11/12/2017 £129.84 £15.41 £114.43 £1,598.58 £1,680.41 £4,401.42
48 12/12/2017 £129.84 £14.38 £115.46 £1,483.12 £1,694.79 £4,516.88
49 1/12/2018 £129.84 £13.34 £116.50 £1,366.62 £1,708.13 £4,633.38
50 2/12/2018 £129.84 £12.29 £117.55 £1,249.07 £1,720.42 £4,750.93
51 3/12/2018 £129.84 £11.23 £118.61 £1,130.46 £1,731.65 £4,869.54
52 4/12/2018 £129.84 £10.17 £119.67 £1,010.79 £1,741.82 £4,989.21
53 5/12/2018 £129.84 £9.09 £120.75 £890.04 £1,750.91 £5,109.96
54 6/12/2018 £129.84 £8.00 £121.84 £768.20 £1,758.91 £5,231.80
55 7/12/2018 £129.84 £6.91 £122.93 £645.27 £1,765.82 £5,354.73
56 8/12/2018 £129.84 £5.80 £124.04 £521.23 £1,771.62 £5,478.77
57 9/12/2018 £129.84 £4.68 £125.16 £396.07 £1,776.30 £5,603.93
58 10/12/2018 £129.84 £3.56 £126.28 £269.79 £1,779.86 £5,730.21
59 11/12/2018 £129.84 £2.42 £127.42 £142.37 £1,782.28 £5,857.63
60 12/12/2018 £143.65 £1.28 £142.37 £0.00 £1,783.56 £6,000.00