Spreadsheet: ce0def69-69d0-42ae-a04c-a61b67355da0
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12
 | [NAME] Calculator
 | Notes:
 | 1. This calculator can be used to calculate the interest and capital repayments on a loan of up to ten years repayable in equal monthly instalments
 | 2. Interest rates may be quoted by the lender annually or monthly - ensure that the correct rate is inserted.
 | 3. Use interest rates and not APR rates
 | 4. Only entries in the Loan details box can be altered
 | Loan details |  |  |  |  |  | Total Annual Repayments |  |  |  | Year end position
 |  |  |  |  |  |  | Capital | Interest | Total |  | Loan balance | Interest paid
 | Lender |  | optional |  |  | Year 1 | -6274.539488251145 | -9298.516107155345 | -15573.05559540649 |  | 93725.46051174885 | -9298.516107155345
 | Loan reference |  | optional |  |  | Year 2 | -6901.993437076262 | -8671.062158330227 | -15573.05559540649 |  | 86823.46707467259 | -8671.062158330227
 | Date of quote |  | optional |  | 0.007974140428903764 | Year 3 | -7592.192780783889 | -7980.8628146226 | -15573.05559540649 |  | 79231.2742938887 | -7980.8628146226
 | Purpose of loan |  | optional |  |  | Year 4 | -8351.41205886228 | -7221.643536544208 | -15573.05559540649 |  | 70879.86223502642 | -7221.643536544208
 | Amount |  | 100000 |  |  | Year 5 | -9186.553264748512 | -6386.502330657977 | -15573.05559540649 |  | 61693.30897027791 | -6386.502330657977
 | Interest rate: select one |  |  |  |  | Year 6 | -10105.20859122337 | -5467.847004183123 | -15573.05559540649 |  | 51588.10037905454 | -5467.847004183123
 | 1. If quoted annually, or |  | 0.1 |  |  | Year 7 | -11115.72945034571 | -4457.326145060782 | -15573.05559540649 |  | 40472.37092870883 | -4457.326145060782
 | 2. if quoted monthly |  |  |  |  | Year 8 | -12227.30239538028 | -3345.753200026208 | -15573.05559540649 |  | 28245.06853332855 | -3345.753200026208
 | Number of months |  | 120 |  |  | Year 9 | -13450.03263491832 | -2123.022960488174 | -15573.05559540649 |  | 14795.03589841023 | -2123.022960488174
 |  |  |  |  |  | Year 10 | -14795.03589841015 | -778.0196969963374 | -15573.05559540649 |  | 8.36735125631094e-11 | -778.0196969963374
 | Results
 | Monthly repayment |  | -1297.754632950541 |  |  | Capital |  | Total |  |  | Total
 | Annual repayment |  | -15573.05559540649 |  |  | Repayment | -99999.99999999991 | Payments | -155730.5559540649 |  | Interest paid | -55730.55595406498
 |  |  |  |  |  | 1 |  | -797.4140428903764 | -797.4140428903764
 |  |  |  |  |  | 2 |  | -793.4242567629561 | -1590.838299653333
 |  |  |  |  |  | 3 |  | -789.4026555206744 | -2380.240955174007
 |  |  |  |  |  | 4 |  | -785.3489854653378 | -3165.589940639345
 |  |  |  |  |  | 5 |  | -781.2629908757275 | -3946.852931515072
 |  |  |  |  |  | 6 |  | -777.1444139914677 | -4723.99734550654
 |  |  |  |  |  | 7 |  | -772.9929949967658 | -5496.990340503306
 |  |  |  |  |  | 8 |  | -768.808472004021 | -6265.798812507326
 |  |  |  |  |  | 9 |  | -764.5905810373037 | -7030.389393544629
 |  |  |  |  |  | 10 |  | -760.3390560157042 | -7790.728449560334
 |  |  |  |  |  | 11 |  | -756.0536287365454 | -8546.78207829688
 |  |  |  |  |  | 12 |  | -751.734028858465 | -9298.516107155345 |  | -9298.516107155345
 |  |  |  |  |  | 13 |  | -747.3799838843598 | -747.3799838843598
 |  |  |  |  |  | 14 |  | -742.9912191441974 | -1490.371203028557
 |  |  |  |  |  | 15 |  | -738.5674577776877 | -2228.938660806245
 |  |  |  |  |  | 16 |  | -734.1084207168174 | -2963.047081523062
 |  |  |  |  |  | 17 |  | -729.6138266682459 | -3692.660908191308
 |  |  |  |  |  | 18 |  | -725.0833920955603 | -4417.744300286869
 |  |  |  |  |  | 19 |  | -720.516831201388 | -5138.261131488256
 |  |  |  |  |  | 20 |  | -715.9138559093686 | -5854.174987397625
 |  |  |  |  |  | 21 |  | -711.2741758459798 | -6565.449163243605
 |  |  |  |  |  | 22 |  | -706.5974983222202 | -7272.046661565825
 |  |  |  |  |  | 23 |  | -701.8835283151458 | -7973.930189880971
 |  |  |  |  |  | 24 |  | -697.1319684492572 | -8671.062158330227 |  | -8671.062158330227
 |  |  |  |  |  | 25 |  | -692.3425189777414 | -692.3425189777414
 |  |  |  |  |  | 26 |  | -687.5148777635628 | -1379.857396741304
 |  |  |  |  |  | 27 |  | -682.6487402604021 | -2062.506137001707
 |  |  |  |  |  | 28 |  | -677.743799493445 | -2740.249936495151
 |  |  |  |  |  | 29 |  | -672.7997460400162 | -3413.049682535167
 |  |  |  |  |  | 30 |  | -667.816268010062 | -4080.86595054523
 |  |  |  |  |  | 31 |  | -662.7930510264728 | -4743.659001571703
 |  |  |  |  |  | 32 |  | -657.7297782052514 | -5401.388779776954
 |  |  |  |  |  | 33 |  | -652.6261301355235 | -6054.014909912477
 |  |  |  |  |  | 34 |  | -647.481784859388 | -6701.496694771866
 |  |  |  |  |  | 35 |  | -642.296417851606 | -7343.793112623472
 |  |  |  |  |  | 36 |  | -637.0697019991285 | -7980.8628146226 |  | -7980.8628146226
 |  |  |  |  |  | 37 |  | -631.8013075804613 | -631.8013075804613
 |  |  |  |  |  | 38 |  | -626.490902244865 | -1258.292209825326
 |  |  |  |  |  | 39 |  | -621.138150991388 | -1879.430360816714
 |  |  |  |  |  | 40 |  | -615.742716147735 | -2495.173076964449
 |  |  |  |  |  | 41 |  | -610.3042573489636 | -3105.477334313413
 |  |  |  |  |  | 42 |  | -604.8224315160139 | -3710.299765829427
 |  |  |  |  |  | 43 |  | -599.2968928340654 | -4309.596658663492
 |  |  |  |  |  | 44 |  | -593.7272927307222 | -4903.323951394214
 |  |  |  |  |  | 45 |  | -588.1132798540215 | -5491.437231248236
 |  |  |  |  |  | 46 |  | -582.4545000502727 | -6073.891731298509
 |  |  |  |  |  | 47 |  | -576.7505963417125 | -6650.642327640221
 |  |  |  |  |  | 48 |  | -571.0012089039872 | -7221.643536544208 |  | -7221.643536544208
 |  |  |  |  |  | 49 |  | -565.2059750434533 | -565.2059750434533
 |  |  |  |  |  | 50 |  | -559.364529174297 | -1124.57050421775
 |  |  |  |  |  | 51 |  | -553.4765027954726 | -1678.047007013223
 |  |  |  |  |  | 52 |  | -547.541524467454 | -2225.588531480677
 |  |  |  |  |  | 53 |  | -541.5592197888055 | -2767.147751269482
 |  |  |  |  |  | 54 |  | -535.5292113725609 | -3302.676962642043
 |  |  |  |  |  | 55 |  | -529.4511188224178 | -3832.128081464461
 |  |  |  |  |  | 56 |  | -523.3245587087398 | -4355.452640173201
 |  |  |  |  |  | 57 |  | -517.1491445443693 | -4872.60178471757
 |  |  |  |  |  | 58 |  | -510.9244867602457 | -5383.526271477815
 |  |  |  |  |  | 59 |  | -504.6501926808292 | -5888.176464158645
 |  |  |  |  |  | 60 |  | -498.3258664993316 | -6386.502330657977 |  | -6386.502330657977
 |  |  |  |  |  | 61 |  | -491.9511092527443 | -491.9511092527443
 |  |  |  |  |  | 62 |  | -485.5255187966725 | -977.4766280494168
 |  |  |  |  |  | 63 |  | -479.0486897799654 | -1456.525317829382
 |  |  |  |  |  | 64 |  | -472.5202136191455 | -1929.045531448528
 |  |  |  |  |  | 65 |  | -465.9396784726317 | -2394.985209921159
 |  |  |  |  |  | 66 |  | -459.3066692147628 | -2854.291879135922
 |  |  |  |  |  | 67 |  | -452.6207674096053 | -3306.912646545527
 |  |  |  |  |  | 68 |  | -445.8815512845595 | -3752.794197830087
 |  |  |  |  |  | 69 |  | -439.0885957037519 | -4191.882793533839
 |  |  |  |  |  | 70 |  | -432.2414721412156 | -4624.124265675055
 |  |  |  |  |  | 71 |  | -425.3397486538579 | -5049.464014328913
 |  |  |  |  |  | 72 |  | -418.3829898542105 | -5467.847004183123 |  | -5467.847004183123
 |  |  |  |  |  | 73 |  | -411.3707568829641 | -411.3707568829641
 |  |  |  |  |  | 74 |  | -404.3026073812853 | -815.6733642642495
 |  |  |  |  |  | 75 |  | -397.1780954629075 | -1212.851459727157
 |  |  |  |  |  | 76 |  | -389.9967716860054 | -1602.848231413162
 |  |  |  |  |  | 77 |  | -382.7581830248406 | -1985.606414438003
 |  |  |  |  |  | 78 |  | -375.4618728411846 | -2361.068287279188
 |  |  |  |  |  | 79 |  | -368.1073808555116 | -2729.175668134699
 |  |  |  |  |  | 80 |  | -360.6942431179612 | -3089.869911252661
 |  |  |  |  |  | 81 |  | -353.2219919790725 | -3443.091903231733
 |  |  |  |  |  | 82 |  | -345.6901560602827 | -3788.782059292016
 |  |  |  |  |  | 83 |  | -338.0982602241889 | -4126.880319516205
 |  |  |  |  |  | 84 |  | -330.4458255445769 | -4457.326145060782 |  | -4457.326145060782
 |  |  |  |  |  | 85 |  | -322.7323692762063 | -322.7323692762063
 |  |  |  |  |  | 86 |  | -314.9574048243594 | -637.6897741005657
 |  |  |  |  |  | 87 |  | -307.1204417141441 | -944.8102158147099
 |  |  |  |  |  | 88 |  | -299.2209855595515 | -1244.031201374261
 |  |  |  |  |  | 89 |  | -291.2585380322702 | -1535.289739406532
 |  |  |  |  |  | 90 |  | -283.2325968302487 | -1818.52233623678
 |  |  |  |  |  | 91 |  | -275.1426556460077 | -2093.664991882788
 |  |  |  |  |  | 92 |  | -266.9882041347028 | -2360.653196017491
 |  |  |  |  |  | 93 |  | -258.7687278819256 | -2619.421923899416
 |  |  |  |  |  | 94 |  | -250.4837083712567 | -2869.905632270673
 |  |  |  |  |  | 95 |  | -242.1326229515539 | -3112.038255222227
 |  |  |  |  |  | 96 |  | -233.7149448039805 | -3345.753200026208 |  | -3345.753200026208
 |  |  |  |  |  | 97 |  | -225.2301429087724 | -225.2301429087724
 |  |  |  |  |  | 98 |  | -216.6776820117409 | -441.9078249205133
 |  |  |  |  |  | 99 |  | -208.0570225905036 | -649.964847511017
 |  |  |  |  |  | 100 |  | -199.367620820452 | -849.3324683314689
 |  |  |  |  |  | 101 |  | -190.6089285404424 | -1039.941396871911
 |  |  |  |  |  | 102 |  | -181.780393218219 | -1221.72179009013
 |  |  |  |  |  | 103 |  | -172.8814579155544 | -1394.603248005685
 |  |  |  |  |  | 104 |  | -163.9115612531187 | -1558.514809258803
 |  |  |  |  |  | 105 |  | -154.8701373750638 | -1713.384946633867
 |  |  |  |  |  | 106 |  | -145.7566159133282 | -1859.141562547195
 |  |  |  |  |  | 107 |  | -136.5704219516546 | -1995.71198449885
 |  |  |  |  |  | 108 |  | -127.310975989324 | -2123.022960488174 |  | -2123.022960488174
 |  |  |  |  |  | 109 |  | -117.977693904595 | -117.977693904595
 |  |  |  |  |  | 110 |  | -108.5699869178605 | -226.5476808224555
 |  |  |  |  |  | 111 |  | -99.08726155450009 | -325.6349423769556
 |  |  |  |  |  | 112 |  | -89.52891960744294 | -415.1638619843986
 |  |  |  |  |  | 113 |  | -79.89435809943242 | -495.058220083831
 |  |  |  |  |  | 114 |  | -70.18296924498627 | -565.2411893288172
 |  |  |  |  |  | 115 |  | -60.39414041205523 | -625.6353297408724
 |  |  |  |  |  | 116 |  | -50.52725408337581 | -676.1625838242483
 |  |  |  |  |  | 117 |  | -40.58168781751576 | -716.744271641764
 |  |  |  |  |  | 118 |  | -30.55681420960597 | -747.30108585137
 |  |  |  |  |  | 119 |  | -20.45200085176564 | -767.7530867031356
 |  |  |  |  |  | 120 |  | -10.26661029320176 | -778.0196969963374 |  | -778.0196969963374