{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["main"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"main","index":0,"n_rows":130,"n_cols":6,"rows_kept":130,"cut":false,"hidden":false,"merged":[[1,1,1,5],[3,4,3,5]]}
[]
[null,"Credit Card Payoff Calculator with Amortization"]
[]
[null,"Present Balance",1250,null,"Total"]
[null,"Interest Rate",0.16,null,"Principal",{"$f":"C4","v":1250}]
[null,"Each Payment",100,null,"Interest",{"$f":"SUMIF(E11:E100,\">0\")","v":126.62652139637139}]
[null,"Payment Starts","2022-07-01",null,"Amount",{"$f":"SUM(F5:F6)","v":1376.6265213963713}]
[null,"Payment Ends",{"$f":"INDEX(B11:B130,MATCH(TRUE,E11:E130<0,0)-1)","v":"2023-08-01"},null,"Months",{"$f":"COUNTIF(E11:E100,\">0\")","v":14}]
[]
[null,"Date","Payment","Principal","Interest","Balance"]
[null,{"$f":"C7","v":"2022-07-01"},{"$f":"$C$6","v":100},{"$f":"C11-E11","v":83.333333333333329},{"$f":"C4*C5/12","v":16.666666666666668},{"$f":"C4-D11","v":1166.6666666666667}]
[null,{"$f":"DATE(YEAR(B11),MONTH(B11)+1,DAY(B11))","v":"2022-08-01"},100,84.444444444444443,{"$f":"F11*$C$5/12","v":15.555555555555557},{"$f":"F11-D12","v":1082.2222222222224}]
[null,{"$f":"DATE(YEAR(B12),MONTH(B12)+1,DAY(B12))","v":"2022-09-01"},100,85.57037037037037,14.429629629629632,996.65185185185203]
[null,"2022-10-01",100,86.711308641975307,13.288691358024694,909.94054320987675]
[null,"2022-11-01",100,87.867459423868311,12.13254057613169,822.0730837860084]
[null,"2022-12-01",100,89.039025549519891,10.960974450480114,733.03405823648848]
[null,"2023-01-01",100,90.226212556846818,9.7737874431531804,642.80784567964167]
[null,"2023-02-01",100,91.429228724271439,8.5707712757285552,551.37861695537026]
[null,"2023-03-01",100,92.648285107261728,7.3517148927382712,458.73033184810856]
[null,"2023-04-01",100,93.883595575358555,6.1164044246414475,364.84673627275004]
[null,"2023-05-01",100,95.135376849696669,4.8646231503033341,269.71135942305335]
[null,"2023-06-01",100,96.403848541025951,3.5961514589740449,173.3075108820274]
[null,"2023-07-01",100,97.689233188239641,2.3107668117603652,75.618277693787761]
[null,"2023-08-01",100,98.99175629741616,1.0082437025838369,-23.373478603628399]
[null,"2023-09-01",100,100.31164638138171,-0.31164638138171202,-123.68512498501011]
[null,"2023-10-01",100,101.64913499980014,-1.6491349998001346,-225.33425998481025]
[null,"2023-11-01",100,103.00445679979747,-3.0044567997974703,-328.3387167846077]
[null,"2023-12-01",100,104.3778495571281,-4.3778495571281022,-432.71656634173581]
[null,"2024-01-01",100,105.76955421788981,-5.7695542178898114,-538.48612055962565]
[null,"2024-02-01",100,107.17981494079501,-7.1798149407950085,-645.66593550042069]
[null,{"$f":"DATE(YEAR(B30),MONTH(B30)+1,DAY(B30))","v":"2024-03-01"},{"$f":"$C$6","v":100},108.60887914000561,{"$f":"F30*$C$5/12","v":-8.6088791400056088},-754.27481464042626]
[null,"2024-04-01",100,110.05699752853901,-10.056997528539016,-864.33181216896526]
[null,"2024-05-01",100,111.52442416225287,-11.52442416225287,-975.85623633121816]
[null,"2024-06-01",100,113.01141648441624,-13.011416484416243,-1088.8676528156343]
[null,"2024-07-01",100,114.51823537087512,-14.518235370875125,-1203.3858881865094]
[null,"2024-08-01",100,116.04514517582012,-16.045145175820128,-1319.4310333623296]
[null,"2024-09-01",100,117.5924137781644,-17.592413778164396,-1437.023447140494]
[null,"2024-10-01",100,119.16031262853991,-19.16031262853992,-1556.1837597690339]
[null,"2024-11-01",100,120.74911679692045,-20.749116796920454,-1676.9328765659543]
[null,"2024-12-01",100,122.3591050208794,-22.359105020879394,-1799.2919815868338]
[null,"2025-01-01",100,123.99055975449112,-23.990559754491116,-1923.282541341325]
[null,"2025-02-01",100,125.64376721788433,-25.643767217884331,-2048.9263085592092]
[null,"2025-03-01",100,{"$f":"C43-E43","v":127.31901744745612},-27.319017447456122,-2176.2453260066654]
[null,"2025-04-01",100,129.01660434675554,-29.016604346755539,{"$f":"F43-D44","v":-2305.2619303534211}]
[null,"2025-05-01",100,130.73682573804561,-30.736825738045614,-2435.9987560914669]
[null,"2025-06-01",100,132.47998341455289,-32.479983414552898,-2568.4787395060198]
[null,"2025-07-01",100,134.24638319341361,-34.2463831934136,-2702.7251226994335]
[null,"2025-08-01",100,136.03633496932579,-36.036334969325786,-2838.7614576687592]
[null,"2025-09-01",100,137.85015276891679,-37.850152768916793,-2976.6116104376761]
[null,"2025-10-01",100,139.68815480583567,-39.68815480583568,-3116.2997652435115]
[null,"2025-11-01",100,141.55066353658015,-41.550663536580153,-3257.8504287800915]
[null,"2025-12-01",100,143.43800571706788,-43.438005717067888,-3401.2884344971594]
[null,"2026-01-01",100,145.35051245996212,-45.350512459962125,-3546.6389469571213]
[null,"2026-02-01",100,147.28851929276161,-47.288519292761613,-3693.9274662498829]
[null,"2026-03-01",100,149.25236621666511,-49.252366216665109,-3843.1798324665479]
[null,"2026-04-01",100,151.24239776622065,-51.242397766220641,-3994.4222302327685]
[null,"2026-05-01",100,153.25896306977026,-53.258963069770253,-4147.6811933025383]
[null,"2026-06-01",100,155.30241591070052,-55.30241591070051,-4302.9836092132391]
[null,"2026-07-01",100,157.37311478950986,-57.373114789509856,-4460.3567240027487]
[null,"2026-08-01",100,159.47142298670332,-59.471422986703317,-4619.8281469894519]
[null,"2026-09-01",100,161.59770862652601,-61.597708626526021,-4781.4258556159775]
[null,"2026-10-01",100,163.75234474154638,-63.752344741546374,-4945.1782003575236]
[null,"2026-11-01",100,165.93570933810031,-65.935709338100324,-5111.113909695624]
[null,"2026-12-01",100,168.14818546260832,-68.148185462608325,-5279.2620951582321]
[null,"2027-01-01",100,170.39016126877641,-70.390161268776424,-5449.652256427009]
[null,"2027-02-01",100,172.66203008569346,-72.662030085693459,-5622.3142865127029]
[null,"2027-03-01",100,174.96419048683606,-74.964190486836046,-5797.2784769995387]
[null,"2027-04-01",100,177.29704635999383,-77.297046359993843,-5974.5755233595328]
[null,"2027-05-01",100,179.66100697812709,-79.661006978127105,-6154.23653033766]
[null,"2027-06-01",100,182.05648707116882,-82.056487071168803,-6336.2930174088287]
[null,"2027-07-01",100,184.48390689878437,-84.483906898784383,-6520.7769243076127]
[null,"2027-08-01",100,186.94369232410151,-86.943692324101505,-6707.7206166317146]
[null,"2027-09-01",100,189.43627488842287,-89.436274888422872,-6897.1568915201378]
[null,"2027-10-01",100,191.96209188693518,-91.96209188693517,-7089.1189834070728]
[null,"2027-11-01",100,{"$f":"C75-E75","v":194.52158644542766},-94.521586445427644,-7283.6405698525004]
[null,"2027-12-01",100,197.11520759803335,-97.115207598033351,{"$f":"F75-D76","v":-7480.755777450534}]
[null,"2028-01-01",100,199.74341036600714,-99.743410366007126,-7680.4991878165411]
[null,"2028-02-01",100,202.4066558375539,-102.40665583755388,-7882.9058436540945]
[null,"2028-03-01",100,205.10541124872128,-105.10541124872127,-8088.0112549028154]
[null,"2028-04-01",100,207.84015006537089,-107.84015006537088,-8295.8514049681871]
[null,"2028-05-01",100,210.61135206624249,-110.61135206624249,-8506.4627570344292]
[null,"2028-06-01",100,213.41950342712573,-113.41950342712573,-8719.8822604615543]
[null,"2028-07-01",100,216.26509680615408,-116.26509680615406,-8936.1473572677078]
[null,"2028-08-01",100,219.14863143023609,-119.14863143023611,-9155.2959886979443]
[null,"2028-09-01",100,222.07061318263925,-122.07061318263926,-9377.3666018805834]
[null,"2028-10-01",100,225.03155469174112,-125.03155469174112,-9602.3981565723243]
[null,"2028-11-01",100,228.03197542096433,-128.03197542096433,-9830.4301319932893]
[null,"2028-12-01",100,231.07240175991052,-131.07240175991052,-10061.502533753201]
[null,"2029-01-01",100,234.15336711670935,-134.15336711670935,-10295.65590086991]
[null,"2029-02-01",100,237.2754120115988,-137.2754120115988,-10532.931312881508]
[null,"2029-03-01",100,240.43908417175345,-140.43908417175345,-10773.370397053262]
[null,"2029-04-01",100,243.64493862737683,-143.64493862737683,-11017.015335680639]
[null,"2029-05-01",100,246.89353780907518,-146.89353780907518,-11263.908873489714]
[null,"2029-06-01",100,250.18545164652951,-150.18545164652951,-11514.094325136244]
[null,{"$f":"DATE(YEAR(B94),MONTH(B94)+1,DAY(B94))","v":"2029-07-01"},{"$f":"$C$6","v":100},253.52125766848326,{"$f":"F94*$C$5/12","v":-153.52125766848326},-11767.615582804727]
[null,"2029-08-01",100,256.90154110406303,-156.90154110406303,-12024.51712390879]
[null,"2029-09-01",100,260.32689498545051,-160.32689498545054,-12284.84401889424]
[null,"2029-10-01",100,263.79792025192319,-163.79792025192322,-12548.641939146164]
[null,"2029-11-01",100,267.31522585528216,-167.31522585528219,-12815.957165001446]
[null,"2029-12-01",100,270.879428866686,-170.87942886668597,-13086.836593868133]
[null,"2030-01-01",100,274.49115458490849,-174.49115458490846,-13361.327748453041]
[null,"2030-02-01",100,278.15103664604055,-178.15103664604055,-13639.478785099082]
[null,"2030-03-01",100,281.85971713465437,-181.8597171346544,-13921.338502233735]
[null,"2030-04-01",100,285.61784669644976,-185.61784669644979,-14206.956348930185]
[null,"2030-05-01",100,289.42608465240244,-189.42608465240247,-14496.382433582588]
[null,"2030-06-01",100,293.2850991144345,-193.2850991144345,-14789.667532697023]
[null,"2030-07-01",100,{"$f":"C107-E107","v":297.19556710262702},-197.195567102627,-15086.86309979965]
[null,"2030-08-01",100,301.15817466399528,-201.15817466399531,{"$f":"F107-D108","v":-15388.021274463645}]
[null,"2030-09-01",100,305.17361699284857,-205.17361699284859,-15693.194891456493]
[null,"2030-10-01",100,309.24259855275329,-209.24259855275326,-16002.437490009246]
[null,"2030-11-01",100,313.36583320012323,-213.36583320012326,-16315.803323209369]
[null,"2030-12-01",100,317.54404430945829,-217.54404430945826,-16633.347367518829]
[null,"2031-01-01",100,321.77796490025105,-221.77796490025105,-16955.12533241908]
[null,"2031-02-01",100,326.06833776558778,-226.06833776558776,-17281.193670184668]
[null,"2031-03-01",100,330.41591560246229,-230.41591560246226,-17611.60958578713]
[null,"2031-04-01",100,334.8214611438284,-234.8214611438284,-17946.431046930957]
[null,"2031-05-01",100,339.28574729241279,-239.28574729241276,-18285.716794223368]
[null,"2031-06-01",100,343.80955725631156,-243.80955725631156,-18629.526351479679]
[null,"2031-07-01",100,348.39368468639577,-248.39368468639574,-18977.920036166073]
[null,"2031-08-01",100,353.03893381554769,-253.03893381554767,-19330.958969981621]
[null,"2031-09-01",100,357.74611959975493,-257.74611959975493,-19688.705089581377]
[null,"2031-10-01",100,362.51606786108505,-262.51606786108505,-20051.221157442462]
[null,"2031-11-01",100,367.34961543256617,-267.34961543256617,-20418.570772875028]
[null,"2031-12-01",100,372.24761030500036,-272.24761030500036,-20790.818383180027]
[null,"2032-01-01",100,377.21091177573368,-277.21091177573368,-21168.029294955762]
[null,"2032-02-01",100,382.2403905994102,-282.2403905994102,-21550.269685555173]
[null,"2032-03-01",100,387.33692914073566,-287.33692914073566,-21937.606614695909]
[null,"2032-04-01",100,392.50142152927879,-292.50142152927879,-22330.108036225189]
[null,"2032-05-01",100,397.73477381633586,-297.73477381633586,-22727.842810041526]
[null,"2032-06-01",100,403.03790413388703,-303.03790413388703,-23130.880714175411]