{"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":"NPER(H5/12,-H6,H4)","v":11.717862958303339}]
[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":"E5*$H$5/12","v":24.050833333333333},{"$f":"H4-C5","v":1519},null,"Interest Rate (Yearly)",0.19]
[null,2,{"$f":"$H$6","v":180},{"$f":"E6*$H$5/12","v":21.581638194444441},{"$f":"E5+D5-C6","v":1363.0508333333332},null,"Monthly Payment",180]
[null,3,180,19.073347465856479,{"$f":"E6+D6-C7","v":1204.6324715277776},null,"No of Payments",{"$f":"NPER(H5/12,-H6,H4)","v":10.304154619857041}]
[null,4,180,16.52534213406587,1043.705818993634]
[null,5,180,13.936993384521914,880.23116112769981]
[null,6,180,11.30766244644351,714.16815451222169]
[null,7,180,8.6367004351788648,545.47581695866518]
[null,8,180,5.9234481920691984,374.11251739384409]
[null,9,180,3.1672361217769605,200.03596558591329]
[null,10,180,0.36738402703842904,23.203201707690255]
[null,null,180,-2.476799059200129,-156.4294142652713]
[null,null,180,-5.366015044304131,-338.90621332447142]
[null,null,180,-8.3009769491722807,-524.27222836877559]
[null,null,180,-11.282409084200841,-712.5732053179479]
[null,null,180,-14.31104722803402,-903.85561440214872]
[null,null,180,-17.387638809144558,-1098.1666616301827]
[null,null,180,-20.512943090289351,-1295.5543004393273]
[null,null,180,-23.6877313558856,-1496.0672435296167]
[null,null,180,-26.912787102353786,-1699.7549748855022]
[null,null,180,-30.188906231474387,-1906.667761987856]
[null,null,{"$f":"$H$6","v":180},{"$f":"E25*$H$5","v":-396.46687477769262},{"$f":"E24-C25","v":-2086.667761987856}]
[null,null,180,-430.66687477769267,-2266.667761987856]
[null,null,180,-464.86687477769266,-2446.667761987856]
[null,null,180,-499.06687477769265,-2626.667761987856]
[null,null,180,-533.26687477769269,{"$f":"E28-C29","v":-2806.667761987856}]
[null,null,180,-567.46687477769262,-2986.667761987856]
[null,null,180,-601.66687477769267,-3166.667761987856]
[null,null,180,-635.8668747776926,-3346.667761987856]
[null,null,180,-670.06687477769265,-3526.667761987856]
[null,null,180,-704.26687477769269,-3706.667761987856]
[null,null,180,-738.46687477769262,-3886.667761987856]
[null,null,180,-772.66687477769267,-4066.667761987856]
[null,null,180,-806.8668747776926,-4246.6677619878556]
[null,null,180,-841.06687477769253,-4426.6677619878556]
[null,null,180,-875.26687477769258,-4606.6677619878556]
[null,null,180,-909.46687477769251,-4786.6677619878556]
[null,null,180,-943.66687477769256,-4966.6677619878556]
[null,null,180,-977.8668747776926,-5146.6677619878556]
[null,null,180,-1012.0668747776925,-5326.6677619878556]
[null,null,180,-1046.2668747776925,-5506.6677619878556]
[null,null,180,-1080.4668747776925,-5686.6677619878556]
[null,null,180,-1114.6668747776926,-5866.6677619878556]
[null,null,180,-1148.8668747776926,-6046.6677619878556]
[null,null,180,-1183.0668747776926,-6226.6677619878556]
[null,null,180,-1217.2668747776925,-6406.6677619878556]
[null,null,180,-1251.4668747776925,-6586.6677619878556]
[null,null,180,-1285.6668747776926,-6766.6677619878556]
[null,null,180,-1319.8668747776926,-6946.6677619878556]
[null,null,180,-1354.0668747776926,-7126.6677619878556]

{"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",10000,null,"Months to payoff (Minimum)",null,null,{"$f":"IFERROR((ROUNDUP(NPER(C6/12,-C8,C5,0),0)),\"N/A\")","v":40}]
[null,"Interest Rate",0.1,null,"Months to payoff (Proposed)",null,null,{"$f":"IFERROR(ROUNDUP(NPER(C6/12,-C9,C5,0),0),\"N/A\")","v":22}]
[]
[null,"Minimum Monthly Payment",300,null,"Total interest (Minimum)",null,null,{"$f":"IFERROR(((NPER(C6/12,-C8,C5,0)*C8)-C5),\"N/A\")","v":1763.9522603810219}]
[null,"Proposed Monthly Payment",500,null,"Total interest (Proposed)",null,null,{"$f":"IFERROR(((NPER(C6/12,-C9,C5,0)*C9)-C5),\"N/A\")","v":984.81075313113797}]
[]
[null,"Months to Payoff",null,null,null,null,"Total Interest"]