INPUT DATA (enter data from TC dashboard in brown cells)CALCULATED DATA
Bid amount£6,000Interest rate per month0.89972%
Repayment period (in months)60(max 150)Standard monthly repayment£129.84
Interest rate10.75%
Loan repayment typeinterest+capital
Drawdown date12/20/2013
First repayment date1/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
MonthPayment DateMonthly RepaymentInterest RepaymentCapital RepaymentClosing BalanceTotal Interest RepaidTotal Capital Repaid
11/12/2014£109.19£41.38£67.81£5,932.19£41.38£67.81
22/12/2014£129.84£53.37£76.47£5,855.72£94.75£144.28
33/12/2014£129.84£52.68£77.16£5,778.56£147.43£221.44
44/12/2014£129.84£51.99£77.85£5,700.71£199.42£299.29
55/12/2014£129.84£51.29£78.55£5,622.16£250.71£377.84
66/12/2014£129.84£50.58£79.26£5,542.90£301.29£457.10
77/12/2014£129.84£49.87£79.97£5,462.93£351.16£537.07
88/12/2014£129.84£49.15£80.69£5,382.24£400.31£617.76
99/12/2014£129.84£48.42£81.42£5,300.82£448.73£699.18
1010/12/2014£129.84£47.69£82.15£5,218.67£496.42£781.33
1111/12/2014£129.84£46.95£82.89£5,135.78£543.37£864.22
1212/12/2014£129.84£46.20£83.64£5,052.14£589.57£947.86
131/12/2015£129.84£45.45£84.39£4,967.75£635.02£1,032.25
142/12/2015£129.84£44.69£85.15£4,882.60£679.71£1,117.40
153/12/2015£129.84£43.92£85.92£4,796.68£723.63£1,203.32
164/12/2015£129.84£43.15£86.69£4,709.99£766.78£1,290.01
175/12/2015£129.84£42.37£87.47£4,622.52£809.15£1,377.48
186/12/2015£129.84£41.58£88.26£4,534.26£850.73£1,465.74
197/12/2015£129.84£40.79£89.05£4,445.21£891.52£1,554.79
208/12/2015£129.84£39.99£89.85£4,355.36£931.51£1,644.64
219/12/2015£129.84£39.18£90.66£4,264.70£970.69£1,735.30
2210/12/2015£129.84£38.37£91.47£4,173.23£1,009.06£1,826.77
2311/12/2015£129.84£37.54£92.30£4,080.93£1,046.60£1,919.07
2412/12/2015£129.84£36.71£93.13£3,987.80£1,083.31£2,012.20
251/12/2016£129.84£35.87£93.97£3,893.83£1,119.18£2,106.17
262/12/2016£129.84£35.03£94.81£3,799.02£1,154.21£2,200.98
273/12/2016£129.84£34.18£95.66£3,703.36£1,188.39£2,296.64
284/12/2016£129.84£33.31£96.53£3,606.83£1,221.70£2,393.17
295/12/2016£129.84£32.45£97.39£3,509.44£1,254.15£2,490.56
306/12/2016£129.84£31.57£98.27£3,411.17£1,285.72£2,588.83
317/12/2016£129.84£30.69£99.15£3,312.02£1,316.41£2,687.98
328/12/2016£129.84£29.79£100.05£3,211.97£1,346.20£2,788.03
339/12/2016£129.84£28.89£100.95£3,111.02£1,375.09£2,888.98
3410/12/2016£129.84£27.99£101.85£3,009.17£1,403.08£2,990.83
3511/12/2016£129.84£27.07£102.77£2,906.40£1,430.15£3,093.60
3612/12/2016£129.84£26.14£103.70£2,802.70£1,456.29£3,197.30
371/12/2017£129.84£25.21£104.63£2,698.07£1,481.50£3,301.93
382/12/2017£129.84£24.27£105.57£2,592.50£1,505.77£3,407.50
393/12/2017£129.84£23.32£106.52£2,485.98£1,529.09£3,514.02
404/12/2017£129.84£22.36£107.48£2,378.50£1,551.45£3,621.50
415/12/2017£129.84£21.39£108.45£2,270.05£1,572.84£3,729.95
426/12/2017£129.84£20.42£109.42£2,160.63£1,593.26£3,839.37
437/12/2017£129.84£19.43£110.41£2,050.22£1,612.69£3,949.78
448/12/2017£129.84£18.44£111.40£1,938.82£1,631.13£4,061.18
459/12/2017£129.84£17.44£112.40£1,826.42£1,648.57£4,173.58
4610/12/2017£129.84£16.43£113.41£1,713.01£1,665.00£4,286.99
4711/12/2017£129.84£15.41£114.43£1,598.58£1,680.41£4,401.42
4812/12/2017£129.84£14.38£115.46£1,483.12£1,694.79£4,516.88
491/12/2018£129.84£13.34£116.50£1,366.62£1,708.13£4,633.38
502/12/2018£129.84£12.29£117.55£1,249.07£1,720.42£4,750.93
513/12/2018£129.84£11.23£118.61£1,130.46£1,731.65£4,869.54
524/12/2018£129.84£10.17£119.67£1,010.79£1,741.82£4,989.21
535/12/2018£129.84£9.09£120.75£890.04£1,750.91£5,109.96
546/12/2018£129.84£8.00£121.84£768.20£1,758.91£5,231.80
557/12/2018£129.84£6.91£122.93£645.27£1,765.82£5,354.73
568/12/2018£129.84£5.80£124.04£521.23£1,771.62£5,478.77
579/12/2018£129.84£4.68£125.16£396.07£1,776.30£5,603.93
5810/12/2018£129.84£3.56£126.28£269.79£1,779.86£5,730.21
5911/12/2018£129.84£2.42£127.42£142.37£1,782.28£5,857.63
6012/12/2018£143.65£1.28£142.37£0.00£1,783.56£6,000.00