{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["main","Template"],"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":40,"n_cols":8,"rows_kept":40,"cut":false,"hidden":false,"merged":[[1,1,1,7],[8,2,8,3],[8,4,8,5],[8,6,8,7],[8,1,9,1],[3,6,3,7]]}
[]
[null,"Credit Card Payoff Calculator Using Snowball Method"]
[]
[null,null,"Debt 1","Debt 2","Debt 3",null,"Additional Payment"]
[null,"Balance",2500,5050,6020,null,"Per Month",450]
[null,"Payment",70,120,250,null,"One Time",1500]
[null,"Interest",0.16,4.4999999999999998E-2,6.8000000000000005E-2]
[]
[null,"Month","Debt 1",null,"Debt 2",null,"Debt 3"]
[null,null,"Payment","Balance","Payment","Balance","Payment","Balance"]
[null,{"$f":"ROW()-10","v":1},{"$f":"IF(H5+H6>=C5,C5,H5+H6+C6)","v":2020},{"$f":"IF(C5-C11<0,0,C5-C11)","v":480},{"$f":"IF(H5+H6>=C5+D5,D5,IF(AND(C11=C5,C11<>0),H5+H6-D5+D6,D6))","v":120},{"$f":"D5-E11","v":4930},{"$f":"IF(H5+H6>=D5+E5+C5,E5,IF(AND(E11=D5, E11<>0),H5+H6-D5-C5+E6,E6))","v":250},{"$f":"E5-G11","v":5770}]
[null,{"$f":"ROW()-10","v":2},{"$f":"IF(D11-$H$5-$C$6<=0,$H$5+D11-$H$5,$H$5+$C$6)","v":480},{"$f":"IF(D11-C12<=0,0,(D11-C12)*(1+($C$7/12)))","v":0},{"$f":"IF(AND(((F11-$H$5+C12-D$6-C$6)<=0),D12=0),F11,IF((F11-$D$6-$H$5)<=0,F11,IF(D12=0,$H$5-C12+D$6+C$6,D$6)))","v":160},{"$f":"IF(F11-E12<0,0,(F11-E12)*(1+($D$7/12)))","v":4787.8874999999998},{"$f":"IF(AND(((H11-$H$5+E12-E$6-D$6-C$6)<=0),F12=0),H11, IF((H11-$E$6-$H$5)<=0,H11,IF(F12=0,$H$5-E12+E$6+D$6+C$6,E$6)))","v":250},{"$f":"IF(H11-G12<0,0,(H11-G12)*(1+($E$7/12)))","v":5551.2800000000007}]
[null,3,0,{"$f":"IF(D12-C13<=0,0,(D12-C13)*(1+($C$7/12)))","v":0},640,{"$f":"IF(F12-E13<0,0,(F12-E13)*(1+($D$7/12)))","v":4163.4420781249992},250,{"$f":"IF(H12-G13<0,0,(H12-G13)*(1+($E$7/12)))","v":5331.3205866666676}]
[null,4,0,0,640,3536.6549859179677,250,5110.1147366577788]
[null,5,0,0,640,2907.5174421151596,250,4887.6553868321735]
[null,6,0,0,640,2276.0206325230911,250,4663.9354340242226]
[null,7,0,{"$f":"IF(D16-C17<=0,0,(D16-C17)*(1+($C$7/12)))","v":0},640,1642.1557098950525,250,4438.9477348170267]
[null,8,0,0,640,1005.9137938071589,250,4212.6851053143237]
[null,9,0,0,640,367.28597053393571,250,3985.1403209111049]
[null,10,0,0,367.28597053393571,0,522.71402946606429,3482.0467070965624]
[null,11,0,0,0,0,890,2606.7349717701095]
[null,12,0,0,0,0,890,1726.4631366101403]
[null,13,0,0,0,{"$f":"IF(F22-E23<0,0,(F22-E23)*(1+($D$7/12)))","v":0},890,841.20309438426443]
[null,14,0,0,0,0,841.20309438426443,0]
[null,15,0,0,0,0,0,0]
[null,16,0,0,0,0,0,0]
[null,17,0,{"$f":"IF(D26-C27<=0,0,(D26-C27)*(1+($C$7/12)))","v":0},0,{"$f":"IF(F26-E27<0,0,(F26-E27)*(1+($D$7/12)))","v":0},0,0]
[null,18,0,0,0,0,0,0]
[null,19,0,0,0,0,0,0]
[null,20,0,0,0,0,0,0]
[null,21,0,0,0,0,0,0]
[null,22,0,0,0,0,0,{"$f":"IF(H31-G32<0,0,(H31-G32)*(1+($E$7/12)))","v":0}]
[null,23,0,0,0,0,0,0]
[null,24,0,0,0,0,0,0]
[null,25,0,0,0,0,0,0]
[null,26,0,0,0,0,0,0]
[null,27,0,0,0,0,0,0]
[null,28,0,0,0,0,0,0]
[null,29,0,0,0,0,0,0]
[null,30,0,0,0,0,0,0]

{"sheet":"Template","index":1,"n_rows":130,"n_cols":8,"rows_kept":130,"cut":false,"hidden":false,"merged":[[1,1,1,7],[3,6,3,7],[8,1,9,1],[8,2,8,3],[8,4,8,5],[8,6,8,7]]}
[]
[null,"Using Snowball Method"]
[]
[null,null,"Debt 1","Debt 2","Debt 3",null,"Additional Payment"]
[null,"Balance",2500,5050,6020,null,"Per Month",450]
[null,"Payment",70,120,250,null,"One Time",1500]
[null,"Interest",0.16,4.4999999999999998E-2,6.8000000000000005E-2]
[]
[null,"Month","Debt 1",null,"Debt 2",null,"Debt 3"]
[null,null,"Payment","Balance","Payment","Balance","Payment","Balance"]
[null,{"$f":"ROW()-10","v":1},{"$f":"IF(H5+H6>=C5,C5,H5+H6+C6)","v":2020},{"$f":"IF(C5-C11<0,0,C5-C11)","v":480},{"$f":"IF(H5+H6>=C5+D5,D5,IF(AND(C11=C5,C11<>0),H5+H6-D5+D6,D6))","v":120},{"$f":"D5-E11","v":4930},{"$f":"IF(H5+H6>=D5+E5+C5,E5,IF(AND(E11=D5, E11<>0),H5+H6-D5-C5+E6,E6))","v":250},{"$f":"E5-G11","v":5770}]
[null,{"$f":"ROW()-10","v":2},{"$f":"IF(D11-$H$5-$C$6<=0,$H$5+D11-$H$5,$H$5+$C$6)","v":480},{"$f":"IF(D11-C12<=0,0,(D11-C12)*(1+($C$7/12)))","v":0},{"$f":"IF(AND(((F11-$H$5+C12-D$6-C$6)<=0),D12=0),F11,IF((F11-$D$6-$H$5)<=0,F11,IF(D12=0,$H$5-C12+D$6+C$6,D$6)))","v":160},{"$f":"IF(F11-E12<0,0,(F11-E12)*(1+($D$7/12)))","v":4787.8874999999998},{"$f":"IF(AND(((H11-$H$5+E12-E$6-D$6-C$6)<=0),F12=0),H11, IF((H11-$E$6-$H$5)<=0,H11,IF(F12=0,$H$5-E12+E$6+D$6+C$6,E$6)))","v":250},{"$f":"IF(H11-G12<0,0,(H11-G12)*(1+($E$7/12)))","v":5551.2800000000007}]
[null,3,0,{"$f":"IF(D12-C13<=0,0,(D12-C13)*(1+($C$7/12)))","v":0},640,{"$f":"IF(F12-E13<0,0,(F12-E13)*(1+($D$7/12)))","v":4163.4420781249992},250,{"$f":"IF(H12-G13<0,0,(H12-G13)*(1+($E$7/12)))","v":5331.3205866666676}]
[null,4,0,0,640,3536.6549859179677,250,5110.1147366577788]
[null,5,0,0,640,2907.5174421151596,250,4887.6553868321735]
[null,6,0,0,640,2276.0206325230911,250,4663.9354340242226]
[null,7,0,0,640,1642.1557098950525,250,4438.9477348170267]
[null,8,0,0,640,1005.9137938071589,250,4212.6851053143237]
[null,9,0,0,640,367.28597053393571,250,3985.1403209111049]
[null,10,0,0,367.28597053393571,0,522.71402946606429,3482.0467070965624]
[null,11,0,0,0,0,890,2606.7349717701095]
[null,12,0,0,0,0,890,1726.4631366101403]
[null,13,0,0,0,0,890,841.20309438426443]
[null,14,0,0,0,0,841.20309438426443,0]
[null,15,0,0,0,0,0,0]
[null,16,0,0,0,0,0,0]
[null,17,0,0,0,0,0,0]
[null,18,0,0,0,0,0,0]
[null,19,0,0,0,0,0,0]
[null,20,0,0,0,0,0,0]
[null,21,0,0,0,0,0,0]
[null,22,0,0,0,0,0,0]
[null,23,0,0,0,0,0,0]
[null,24,0,0,0,0,0,0]
[null,25,0,0,0,0,0,0]
[null,26,0,0,0,0,0,0]
[null,27,0,0,0,0,0,0]
[null,28,0,0,0,0,0,0]
[null,29,0,0,0,0,0,0]
[null,30,0,0,0,0,0,0]
[null,31,{"$f":"IF(D40-$H$5-$C$6<=0,$H$5+D40-$H$5,$H$5+$C$6)","v":0},{"$f":"IF(D40-C41<=0,0,(D40-C41)*(1+($C$7/12)))","v":0},{"$f":"IF(AND(((F40-$H$5+C41-D$6-C$6)<=0),D41=0),F40,IF((F40-$D$6-$H$5)<=0,F40,IF(D41=0,$H$5-C41+D$6+C$6,D$6)))","v":0},{"$f":"IF(F40-E41<0,0,(F40-E41)*(1+($D$7/12)))","v":0},{"$f":"IF(AND(((H40-$H$5+E41-E$6-D$6-C$6)<=0),F41=0),H40, IF((H40-$E$6-$H$5)<=0,H40,IF(F41=0,$H$5-E41+E$6+D$6+C$6,E$6)))","v":0},{"$f":"IF(H40-G41<0,0,(H40-G41)*(1+($E$7/12)))","v":0}]
[null,32,0,0,0,0,0,0]
[null,33,0,0,0,0,0,0]
[null,34,0,0,0,0,0,0]
[null,35,0,0,0,0,0,0]
[null,36,0,0,0,0,0,0]
[null,37,0,0,0,0,0,0]
[null,38,0,0,0,0,0,0]
[null,39,0,0,0,0,0,0]
[null,40,0,0,0,0,0,0]
[null,41,0,0,0,0,0,0]
[null,42,0,0,0,0,0,0]
[null,43,0,0,0,0,0,0]
[null,44,0,0,0,0,0,0]
[null,45,0,0,0,0,0,0]
[null,46,0,0,0,0,0,0]
[null,47,0,0,0,0,0,0]
[null,48,0,0,0,0,0,0]
[null,49,0,0,0,0,0,0]
[null,50,0,0,0,0,0,0]
[null,51,0,0,0,0,0,0]
[null,52,0,0,0,0,0,0]
[null,53,0,0,0,0,0,0]
[null,54,0,0,0,0,0,0]
[null,55,0,0,0,0,0,0]
[null,56,0,0,0,0,0,0]
[null,57,0,0,0,0,0,0]
[null,58,0,0,0,0,0,0]
[null,59,0,0,0,0,0,0]
[null,60,0,0,0,0,0,0]
[null,61,0,0,0,0,0,0]
[null,62,0,0,0,0,0,0]
[null,63,0,0,0,0,0,0]
[null,64,0,0,0,0,0,0]
[null,65,0,0,0,0,0,0]
[null,{"$f":"ROW()-10","v":66},0,0,0,0,0,0]
[null,67,0,0,0,0,0,0]
[null,68,0,0,0,0,0,0]
[null,69,0,0,0,0,0,0]
[null,70,0,0,0,0,0,0]
[null,71,0,0,0,0,0,0]
[null,72,0,0,0,0,0,0]
[null,73,0,0,0,0,0,0]
[null,74,0,0,0,0,0,0]
[null,75,0,0,0,0,0,0]
[null,76,0,0,0,0,0,0]
[null,77,0,0,0,0,0,0]
[null,78,0,0,0,0,0,0]
[null,79,0,0,0,0,0,0]
[null,80,0,0,0,0,0,0]
[null,81,0,0,0,0,0,0]
[null,82,0,0,0,0,0,0]
[null,83,0,0,0,0,0,0]
[null,84,0,0,0,0,0,0]
[null,85,0,0,0,0,0,0]
[null,86,0,0,0,0,0,0]
[null,87,0,0,0,0,0,0]
[null,88,0,0,0,0,0,0]
[null,89,0,0,0,0,0,0]
[null,90,0,0,0,0,0,0]
[null,91,0,0,0,0,0,0]
[null,92,0,0,0,0,0,0]
[null,93,0,0,0,0,0,0]
[null,94,0,0,0,0,0,0]
[null,95,{"$f":"IF(D104-$H$5-$C$6<=0,$H$5+D104-$H$5,$H$5+$C$6)","v":0},{"$f":"IF(D104-C105<=0,0,(D104-C105)*(1+($C$7/12)))","v":0},{"$f":"IF(AND(((F104-$H$5+C105-D$6-C$6)<=0),D105=0),F104,IF((F104-$D$6-$H$5)<=0,F104,IF(D105=0,$H$5-C105+D$6+C$6,D$6)))","v":0},{"$f":"IF(F104-E105<0,0,(F104-E105)*(1+($D$7/12)))","v":0},{"$f":"IF(AND(((H104-$H$5+E105-E$6-D$6-C$6)<=0),F105=0),H104, IF((H104-$E$6-$H$5)<=0,H104,IF(F105=0,$H$5-E105+E$6+D$6+C$6,E$6)))","v":0},{"$f":"IF(H104-G105<0,0,(H104-G105)*(1+($E$7/12)))","v":0}]
[null,96,0,0,0,0,0,0]
[null,97,0,0,0,0,0,0]
[null,98,0,0,0,0,0,0]
[null,99,0,0,0,0,0,0]
[null,100,0,0,0,0,0,0]
[null,101,0,0,0,0,0,0]
[null,102,0,0,0,0,0,0]
[null,103,0,0,0,0,0,0]
[null,104,0,0,0,0,0,0]
[null,105,0,0,0,0,0,0]
[null,106,0,0,0,0,0,0]
[null,107,0,0,0,0,0,0]
[null,108,0,0,0,0,0,0]
[null,109,0,0,0,0,0,0]
[null,110,0,0,0,0,0,0]
[null,111,0,0,0,0,0,0]
[null,112,0,0,0,0,0,0]
[null,113,0,0,0,0,0,0]
[null,114,0,0,0,0,0,0]
[null,115,0,0,0,0,0,0]
[null,116,0,0,0,0,0,0]
[null,117,0,0,0,0,0,0]
[null,118,0,0,0,0,0,0]
[null,119,0,{"$f":"IF(D128-C129<=0,0,(D128-C129)*(1+($C$7/12)))","v":0},{"$f":"IF(AND(((F128-$H$5+C129-D$6-C$6)<=0),D129=0),F128,IF((F128-$D$6-$H$5)<=0,F128,IF(D129=0,$H$5-C129+D$6+C$6,D$6)))","v":0},{"$f":"IF(F128-E129<0,0,(F128-E129)*(1+($D$7/12)))","v":0},{"$f":"IF(AND(((H128-$H$5+E129-E$6-D$6-C$6)<=0),F129=0),H128, IF((H128-$E$6-$H$5)<=0,H128,IF(F129=0,$H$5-E129+E$6+D$6+C$6,E$6)))","v":0},{"$f":"IF(H128-G129<0,0,(H128-G129)*(1+($E$7/12)))","v":0}]
[null,120,0,0,0,0,0,0]