{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["main","Manual","Microsoft Template"],"not_rendered":{"charts":2,"images":1,"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":16,"n_cols":8,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,7]]}
[]
[null,"Creating a Credit Card Payoff Spreadsheet"]
[]
[null,"Month","Payment","Interest","Balance",null,"Product Price",1699]
[null,{"$f":"_xlfn.SEQUENCE(ROUND(H7,0))","v":1},{"$f":"$H$6","v":160},{"$f":"E5*$H$5","v":292.41000000000003},{"$f":"H4-C5","v":1539},null,"Interest Rate (Yearly)",0.19]
[null,2,{"$f":"$H$6","v":160},{"$f":"E6*$H$5","v":317.56790000000001},{"$f":"E5+D5-C6","v":1671.41},null,"Monthly Payment",160]
[null,3,160,287.16790000000003,{"$f":"E6-C7","v":1511.41},null,"No of Payments",{"$f":"ROUNDUP(NPER(H5/12,-H6,H4),0)","v":12}]
[null,4,160,256.7679,1351.41]
[null,5,160,226.36790000000002,1191.4100000000001]
[null,6,160,195.96790000000001,1031.4100000000001]
[null,7,160,165.56790000000001,871.41000000000008]
[null,8,160,135.1679,711.41000000000008]
[null,9,160,104.76790000000001,551.41000000000008]
[null,10,160,74.36790000000002,391.41000000000008]
[null,11,160,43.967900000000014,231.41000000000008]
[null,12,160,13.567900000000016,71.410000000000082]

{"sheet":"Manual","index":1,"n_rows":53,"n_cols":8,"rows_kept":53,"cut":false,"hidden":false,"merged":[[1,1,1,7]]}
[]
[null,"Manually Creating a Credit Card Payoff Spreadsheet"]
[]
[null,"Month","Payment","Interest","Balance",null,"Product Price",1699]
[null,{"$f":"_xlfn.SEQUENCE(ROUND(H7,0))","v":1},{"$f":"$H$6","v":180},{"$f":"ROUND((E5+C5)*$H$5/12,0)","v":27},{"$f":"H4-C5","v":1519},null,"Interest Rate (Yearly)",0.19]
[null,2,{"$f":"$H$6","v":180},{"$f":"ROUND((E6+C6)*$H$5/12,0)","v":24},{"$f":"E5+D5-C6","v":1366},null,"Monthly Payment",180]
[null,3,180,22,{"$f":"E6+D6-C7","v":1210},null,"No of Payments",{"$f":"ROUNDUP(NPER(H5/12,-H6,H4),0)","v":11}]
[null,4,180,20,1052]
[null,5,180,17,892]
[null,6,180,14,729]
[null,7,180,12,563]
[null,8,180,9,395]
[null,9,180,6,224]
[null,10,180,4,50]
[null,11,180,1,-126]
[null,null,180,-2,-305]
[null,null,180,-5,-487]
[null,null,180,-8,-672]
[null,null,180,-11,-860]
[null,null,180,-14,{"$f":"E19+D19-C20","v":-1051}]
[null,null,180,-17,-1245]
[null,null,180,-20,-1442]
[null,null,180,-23,-1642]
[null,null,180,-26,-1845]
[null,null,{"$f":"$H$6","v":180},-29,{"$f":"E24-C25","v":-2025}]
[null,null,180,-32,-2205]
[null,null,180,-35,-2385]
[null,null,180,-38,-2565]
[null,null,180,-41,{"$f":"E28-C29","v":-2745}]
[null,null,180,-43,-2925]
[null,null,180,-46,-3105]
[null,null,180,-49,-3285]
[null,null,180,-52,-3465]
[null,null,180,-55,-3645]
[null,null,180,-58,-3825]
[null,null,180,-61,-4005]
[null,null,180,-63,-4185]
[null,null,180,-66,-4365]
[null,null,180,-69,-4545]
[null,null,180,-72,-4725]
[null,null,180,-75,-4905]
[null,null,180,-78,-5085]
[null,null,180,-81,-5265]
[null,null,180,-83,-5445]
[null,null,180,-86,-5625]
[null,null,180,-89,-5805]
[null,null,180,-92,-5985]
[null,null,180,-95,-6165]
[null,null,180,-98,-6345]
[null,null,180,-100,-6525]
[null,null,180,-103,-6705]
[null,null,180,-106,-6885]
[null,null,180,-109,-7065]

{"sheet":"Microsoft Template","index":2,"n_rows":11,"n_cols":9,"rows_kept":11,"cut":false,"hidden":false,"merged":[[4,4,4,6],[5,4,5,6],[8,4,8,6],[7,4,7,6]]}
[null,null,null,null,null,null,null,null," "]
[null,"Credit Card"]
[null,"Payoff Calculator"]
[]
[null,"Balance Owed",1699,null,"Months to payoff (Minimum)",null,null,{"$f":"IFERROR((ROUNDUP(NPER(C6/12,-C8,C5,0),0)),\"N/A\")","v":11}]
[null,"Interest Rate",0.19,null,"Months to payoff (Proposed)",null,null,{"$f":"IFERROR(ROUNDUP(NPER(C6/12,-C9,C5,0),0),\"N/A\")","v":11}]
[]
[null,"Minimum Monthly Payment",180,null,"Total interest (Minimum)",null,null,{"$f":"IFERROR(((NPER(C6/12,-C8,C5,0)*C8)-C5),\"N/A\")","v":155.74783157426737}]
[null,"Proposed Monthly Payment",180,null,"Total interest (Proposed)",null,null,{"$f":"IFERROR(((NPER(C6/12,-C9,C5,0)*C9)-C5),\"N/A\")","v":155.74783157426737}]
[]
[null,"Months to Payoff",null,null,null,null,"Total Interest"]