Spreadsheet: 885790d1735629272-amortization-table-with-percent-paid-column-amortize-lambda-function
Sheet: Schedule

Loan amount | 49990 |  |  | [freq_mode]:
APR | 0.0199 |  |  | 1 | Monthly (default)
Term | 60 | months |  | 2 | Semi-monthly
[NAME]. mode | Monthly (default) |  |  | 3 | Bi-weekly
Payments |  |  |  | 4 | Weekly
Payment No. | Beginning balance | Payment | Principal | Interest | Cumulative principal | Cumulative interest | Ending balance | % Paid
 | 49990 | -875.9940490025873 | -793.0939656692539 | -82.90008333333336 | 793.0939656692539 | 82.90008333333336 | 49196.90603433074 | 0.01586505232384985
2 | 49196.90603433074 | -875.9940490025873 | -794.4091798289888 | -81.5848691735985 | 1587.503145498243 | 164.4849525069318 | 48402.49685450175 | 0.03175641419280342
3 | 48402.49685450175 | -875.9940490025873 | -795.7265750522051 | -80.26747395038208 | 2383.229720550448 | 244.7524264573139 | 47606.77027944955 | 0.04767412923685633
4 | 47606.77027944955 | -875.9940490025873 | -797.0461549558335 | -78.94789404675383 | 3180.275875506281 | 323.7003205040677 | 46809.72412449372 | 0.0636182411583573
5 | 46809.72412449372 | -875.9940490025873 | -798.3679231628018 | -77.62612583978542 | 3978.643798669083 | 401.3264463438531 | 46011.35620133091 | 0.0795887937321281
6 | 46011.35620133091 | -875.9940490025873 | -799.6918833020468 | -76.30216570054044 | 4778.33568197113 | 477.6286120443936 | 45211.66431802887 | 0.09558583080558371
7 | 45211.66431802887 | -875.9940490025873 | -801.0180390085228 | -74.97600999406454 | 5579.353720979652 | 552.6046220384582 | 44410.64627902035 | 0.1116093962988528
8 | 44410.64627902035 | -875.9940490025873 | -802.3463939232118 | -73.6476550793754 | 6381.700114902864 | 626.2522771178335 | 43608.29988509713 | 0.1276595342048983
9 | 43608.29988509713 | -875.9940490025873 | -803.6769516931345 | -72.31709730945275 | 7185.377066595998 | 698.5693744272862 | 42804.622933404 | 0.1437362885896379
10 | 42804.622933404 | -875.9940490025873 | -805.0097159713589 | -70.9843330312283 | 7990.386782567357 | 769.5537074585145 | 41999.61321743264 | 0.1598397035920656
11 | 41999.61321743264 | -875.9940490025873 | -806.3446904170115 | -69.6493585855758 | 8796.73147298437 | 839.2030660440903 | 41193.26852701563 | 0.1759698234243723
12 | 41193.26852701563 | -875.9940490025873 | -807.6818786952863 | -68.31217030730093 | 9604.413351679656 | 907.5152363513912 | 40385.58664832034 | 0.1921266923720675
13 | 40385.58664832034 | -875.9940490025873 | -809.0212844774561 | -66.97276452513124 | 10413.43463615711 | 974.4880008765224 | 39576.56536384289 | 0.208310354794101
14 | 39576.56536384289 | -875.9940490025873 | -810.3629114408811 | -65.63113756170613 | 11223.79754759799 | 1040.119138438228 | 38766.20245240201 | 0.2245208551229844
15 | 38766.20245240201 | -875.9940490025873 | -811.7067632690206 | -64.28728573356668 | 12035.50431086701 | 1104.406424171795 | 37954.49568913299 | 0.2407582378649133
16 | 37954.49568913299 | -875.9940490025873 | -813.0528436514417 | -62.94120535114553 | 12848.55715451846 | 1167.347629522941 | 37141.44284548154 | 0.2570225475998891
17 | 37141.44284548154 | -875.9940490025873 | -814.4011562838305 | -61.5928927187569 | 13662.95831080229 | 1228.940522241698 | 36327.04168919771 | 0.2733138289818421
18 | 36327.04168919771 | -875.9940490025873 | -815.7517048680011 | -60.2423441345862 | 14478.71001567029 | 1289.182866376284 | 35511.28998432971 | 0.2896321267387535
19 | 35511.28998432971 | -875.9940490025873 | -817.1044931119071 | -58.8895558906801 | 15295.81450878219 | 1348.072422266964 | 34694.18549121781 | 0.3059774856727784
20 | 34694.18549121781 | -875.9940490025873 | -818.4595247296511 | -57.5345242729362 | 16114.27403351185 | 1405.6069465399 | 33875.72596648816 | 0.322349950660369
21 | 33875.72596648816 | -875.9940490025873 | -819.8168034414945 | -56.17724556109287 | 16934.09083695334 | 1461.784192100993 | 33055.90916304666 | 0.3387495666523972
22 | 33055.90916304666 | -875.9940490025873 | -821.1763329738683 | -54.81771602871905 | 17755.26716992721 | 1516.601908129712 | 32234.73283007279 | 0.355176378674279
23 | 32234.73283007279 | -875.9940490025873 | -822.5381170593831 | -53.45593194320405 | 18577.80528698659 | 1570.057840072916 | 31412.19471301341 | 0.371630431826097
24 | 31412.19471301341 | -875.9940490025873 | -823.90215943684 | -52.09188956574723 | 19401.70744642343 | 1622.149729638663 | 30588.29255357657 | 0.3881117712827251
25 | 30588.29255357657 | -875.9940490025873 | -825.2684638512395 | -50.72558515134781 | 20226.97591027467 | 1672.875314790011 | 29763.02408972533 | 0.4046204422939522
26 | 29763.02408972533 | -875.9940490025873 | -826.6370340537927 | -49.35701494879449 | 21053.61294432846 | 1722.232329738805 | 28936.38705567154 | 0.4211564901846062
27 | 28936.38705567154 | -875.9940490025873 | -828.007873801932 | -47.98617520065529 | 21881.6208181304 | 1770.218504939461 | 28108.3791818696 | 0.4377199603546789
28 | 28108.3791818696 | -875.9940490025873 | -829.3809868593202 | -46.61306214326709 | 22711.00180498972 | 1816.831567082728 | 27278.99819501028 | 0.4543108982794502
29 | 27278.99819501028 | -875.9940490025873 | -830.7563769958618 | -45.23767200672538 | 23541.75818198558 | 1862.069239089453 | 26448.24181801442 | 0.4709293495096135
30 | 26448.24181801442 | -875.9940490025873 | -832.1340479877133 | -43.86000101487392 | 24373.89222997329 | 1905.929240104327 | 25616.10777002671 | 0.4875753596714001
31 | 25616.10777002671 | -875.9940490025873 | -833.5140036172929 | -42.4800453852943 | 25207.40623359058 | 1948.409285489621 | 24782.59376640942 | 0.504248974466705
32 | 24782.59376640942 | -875.9940490025873 | -834.8962476732917 | -41.09780132929561 | 26042.30248126388 | 1989.507086818917 | 23947.69751873612 | 0.5209502396732122
33 | 23947.69751873612 | -875.9940490025873 | -836.2807839506833 | -39.71326505190407 | 26878.58326521456 | 2029.220351870821 | 23111.41673478544 | 0.5376792011445201
34 | 23111.41673478544 | -875.9940490025873 | -837.6676162507347 | -38.32643275185251 | 27716.25088146529 | 2067.546784622674 | 22273.74911853471 | 0.5544359048102679
35 | 22273.74911853471 | -875.9940490025873 | -839.0567483810172 | -36.93730062157005 | 28555.30762984631 | 2104.484085244244 | 21434.69237015369 | 0.5712203966762615
36 | 21434.69237015369 | -875.9940490025873 | -840.4481841554158 | -35.54586484717153 | 29395.75581400172 | 2140.029950091416 | 20594.24418599828 | 0.5880327228245994
37 | 20594.24418599828 | -875.9940490025873 | -841.8419273941402 | -34.15212160844713 | 30237.59774139586 | 2174.182071699863 | 19752.40225860414 | 0.6048729294138
38 | 19752.40225860414 | -875.9940490025873 | -843.2379819237354 | -32.75606707885186 | 31080.8357233196 | 2206.938138778714 | 18909.1642766804 | 0.6217410626789278
39 | 18909.1642766804 | -875.9940490025873 | -844.6363515770922 | -31.35769742549499 | 31925.47207489669 | 2238.29583620421 | 18064.52792510331 | 0.6386371689317202
40 | 18064.52792510331 | -875.9940490025873 | -846.0370401934575 | -29.95700880912964 | 32771.50911509015 | 2268.252845013339 | 17218.49088490985 | 0.6555612945607151
41 | 17218.49088490985 | -875.9940490025873 | -847.4400516184452 | -28.55399738414216 | 33618.9491667086 | 2296.806842397481 | 16371.0508332914 | 0.6725134860313782
42 | 16371.0508332914 | -875.9940490025873 | -848.8453897040456 | -27.14865929854157 | 34467.79455641264 | 2323.955501696023 | 15522.20544358736 | 0.6894937898862301
43 | 15522.20544358736 | -875.9940490025873 | -850.2530583086383 | -25.74099069394903 | 35318.04761472128 | 2349.696492389972 | 14671.95238527872 | 0.7065022527449747
44 | 14671.95238527872 | -875.9940490025873 | -851.663061297 | -24.3309877055872 | 36169.71067601828 | 2374.027480095559 | 13820.28932398172 | 0.7235389213046265
45 | 13820.28932398172 | -875.9940490025873 | -853.0754025403177 | -22.91864646226968 | 37022.78607855859 | 2396.946126557829 | 12967.21392144141 | 0.7406038423396398
46 | 12967.21392144141 | -875.9940490025873 | -854.4900859161969 | -21.50396308639031 | 37877.27616447479 | 2418.45008964422 | 12112.72383552521 | 0.7576970627020362
47 | 12112.72383552521 | -875.9940490025873 | -855.9071153086746 | -20.08693369391263 | 38733.18327978346 | 2438.537023338132 | 11256.81672021654 | 0.7748186293215336
48 | 11256.81672021654 | -875.9940490025873 | -857.3264946082282 | -18.66755439435907 | 39590.50977439169 | 2457.204577732492 | 10399.49022560831 | 0.791968589205675
49 | 10399.49022560831 | -875.9940490025873 | -858.7482277117869 | -17.24582129080042 | 40449.25800210348 | 2474.450399023292 | 9540.741997896519 | 0.8091469894399577
50 | 9540.741997896519 | -875.9940490025873 | -860.1723185227423 | -15.82173047984505 | 41309.43032062623 | 2490.272129503137 | 8680.569679373773 | 0.8263538771879622
51 | 8680.569679373773 | -875.9940490025873 | -861.5987709509591 | -14.39527805162816 | 42171.02909157718 | 2504.667407554765 | 7818.970908422816 | 0.843589299691482
52 | 7818.970908422816 | -875.9940490025873 | -863.0275889127861 | -12.96646008980116 | 43034.05668048997 | 2517.633867644567 | 6955.943319510028 | 0.8608533042706535
53 | 6955.943319510028 | -875.9940490025873 | -864.4587763310665 | -11.53527267152079 | 43898.51545682104 | 2529.169140316088 | 6091.484543178958 | 0.8781459383240856
54 | 6091.484543178958 | -875.9940490025873 | -865.8923371351489 | -10.10171186743844 | 44764.40779395619 | 2539.270852183526 | 5225.59220604381 | 0.8954672493289896
55 | 5225.59220604381 | -875.9940490025873 | -867.328275260898 | -8.665773741689312 | 45631.73606921709 | 2547.936625925216 | 4358.263930782909 | 0.9128172848413101
56 | 4358.263930782909 | -875.9940490025873 | -868.7665946507055 | -7.227454351881656 | 46500.5026638678 | 2555.164080277097 | 3489.497336132205 | 0.9301960924958551
57 | 3489.497336132205 | -875.9940490025873 | -870.2072992535013 | -5.786749749085903 | 47370.7099631213 | 2560.950830026183 | 2619.290036878701 | 0.9476037200064272
58 | 2619.290036878701 | -875.9940490025873 | -871.6503930247635 | -4.343655977823846 | 48242.36035614606 | 2565.294486004007 | 1747.639643853938 | 0.9650402151659544
59 | 1747.639643853938 | -875.9940490025873 | -873.0958799265294 | -2.898169076057779 | 49115.45623607259 | 2568.192655080065 | 874.5437639274096 | 0.9825056258466212
60 | 874.5437639274096 | -875.9940490025873 | -874.5437639274077 | -1.450285075179618 | 49990 | 2569.642940155245 | 0 | 1