{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Instructions","Calculator","Table"],"not_rendered":{"charts":1,"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":"Instructions","index":0,"n_rows":13,"n_cols":2,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[null,"Instructions"]
[null,"This calculator is designed to help you create a paydown plan on your credit card debt. "]
[null,"Blue text indicates places to put in your personal credit card figures."]
[null,"In Column C, you are able to input your credit card balance and APR% (annual percentage rate)."]
[null,"This will generate a minimum payment that must be maintained in order so that you will not accrue higher balances due to interest charged."]
[null,"Next you will see a Monthly Payment line. Input the amount you wish to pay each month. "]
[null,"Be careful to put in at or above the minimum payment amount due."]
[null,"This will calculate your payment schedule in months / years to pay off the balance."]
[null,"Additionally, you can input a payoff goal to calculate payments based on number of payments (in months)."]

{"sheet":"Calculator","index":1,"n_rows":28,"n_cols":6,"rows_kept":28,"cut":false,"hidden":false,"merged":[[21,5,27,9]]}
[]
[]
[]
[]
[null,"Credit Card"]
[null,"Card Balance",5000]
[null,"APR %",0.12]
[]
[]
[null,"Payment Schedule"]
[null,"Min. Payment (interest only) ",{"$f":"(C7*C6)/12","v":50}]
[]
[null,"Monthly Payment",120]
[null,null,"Monthly payment should be higher than min payment*"]
[null,"Months to pay off",{"$f":"IFERROR(NPER(C7/12,C13,-C6),\"ERROR\")","v":54.168701391579908}]
[null,null,{"$f":"\"(\"&ROUND(C15/12,2)&\" yrs)\"","v":"(4.51 yrs)"}]
[]
[null,"Total Interest",{"$f":"+C19-C6","v":1500.2441669895888}]
[null,"Total Payments",{"$f":"+C15*C13","v":6500.2441669895888}]
[]
[]
[null,"Calculate Your Goal",null,null,null,"*The Payment Schedule shows what your principal and interest payments would look like at various payoff months. \n\nExample:\nCard balance $10,000, APR 16% paid off in 18 months would be $23,655 (18 payments of $629 principal and $1,314 interest)"]
[null,"Payoff Goal (months)",24]
[null,null,{"$f":"\"(\"&ROUND(C23/12,2)&\" years)\"","v":"(2 years)"}]
[]
[null,"Monthly Payment",{"$f":"IF(C23=0,\" - \",PMT(C7/12,C23,-C6))","v":235.36736111632354}]
[null,"Total Interest",{"$f":"IF(C23=0,\" - \",C26*C23-C6)","v":648.81666679176487}]
[null,"Total Payments",{"$f":"+C26*C23","v":5648.8166667917649}]

{"sheet":"Table","index":2,"n_rows":13,"n_cols":6,"rows_kept":13,"cut":false,"hidden":true,"merged":[]}
[]
[]
[null,null,null,"Principal","Interest","Total Interest"]
[null,null,6,{"$f":"PMT(Calculator!$C$7/12,C4,-Calculator!$C$6)","v":862.74183355440709},{"$f":"(C4*D4)-Calculator!$C$6","v":176.45100132644257},{"$f":"+E4*C4","v":1058.7060079586554}]
[null,null,12,{"$f":"PMT(Calculator!$C$7/12,C5,-Calculator!$C$6)","v":444.24394339170846},{"$f":"(C5*D5)-Calculator!$C$6","v":330.9273207005017},{"$f":"+E5*C5","v":3971.1278484060203}]
[null,null,18,{"$f":"PMT(Calculator!$C$7/12,C6,-Calculator!$C$6)","v":304.9102394765066},{"$f":"(C6*D6)-Calculator!$C$6","v":488.38431057711932},8790.9175903881478]
[null,null,24,{"$f":"PMT(Calculator!$C$7/12,C7,-Calculator!$C$6)","v":235.36736111632354},{"$f":"(C7*D7)-Calculator!$C$6","v":648.81666679176487},15571.600003002357]
[null,null,30,{"$f":"PMT(Calculator!$C$7/12,C8,-Calculator!$C$6)","v":193.74056607923572},{"$f":"(C8*D8)-Calculator!$C$6","v":812.21698237707187},24366.509471312158]
[null,null,36,{"$f":"PMT(Calculator!$C$7/12,C9,-Calculator!$C$6)","v":166.07154906425598},{"$f":"(C9*D9)-Calculator!$C$6","v":978.57576631321535},35228.727587275753]
[null,null,42,{"$f":"PMT(Calculator!$C$7/12,C10,-Calculator!$C$6)","v":146.37813017799354},{"$f":"(C10*D10)-Calculator!$C$6","v":1147.8814674757286},48211.021633980607]
[null,null,48,{"$f":"PMT(Calculator!$C$7/12,C11,-Calculator!$C$6)","v":131.66917715963882},{"$f":"(C11*D11)-Calculator!$C$6","v":1320.1205036626634},63365.784175807843]
[null,null,54,{"$f":"PMT(Calculator!$C$7/12,C12,-Calculator!$C$6)","v":120.28291288071637},{"$f":"(C12*D12)-Calculator!$C$6","v":1495.2772955586843},80744.973960168951]
[null,null,60,{"$f":"PMT(Calculator!$C$7/12,C13,-Calculator!$C$6)","v":111.22223842450887},{"$f":"(C13*D13)-Calculator!$C$6","v":1673.3343054705329},100400.05832823197]