{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Loan","Sudoku Base","Sudoku 1","Sheet1"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":2,"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":"Loan","index":0,"n_rows":26,"n_cols":9,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
["Loan:",25000,"Compounded quarterly at:",null,null,2.5000000000000001E-2]
[null,null,null,null,"Late",null,null,"Next","Blended"]
["Due","Actual","Payment","Interest","Fee","Principal","Amount","Interest","Payment"]
["Date","Date",null,null,"(1.5%)","Reduction","Owed","Payment","Eff 11/1/10"]
[null,"2008-08-01",{"$f":"-B1","v":-25000},null,null,null,{"$f":"B1","v":25000},{"$f":"ROUND($F$1*G5,2)","v":625},{"$f":"ROUND(G5/((1-(1+$F$1)^-8)/$F$1),2)","v":3486.68}]
["2008-11-01","2008-11-28",1000,{"$f":"H5","v":625},{"$f":"ROUND(D6*0.015,2)","v":9.3800000000000008},{"$f":"C6-(D6+E6)","v":365.62},{"$f":"G5-F6","v":24634.38},{"$f":"ROUND($F$1*G6,2)","v":615.86},{"$f":"ROUND(I$5*G6/G$5,2)","v":3435.69}]
["2009-02-01","2009-04-10",1000,615.86,0,384.14,24250.240000000002,606.26,3382.11]
["2009-05-01","2009-06-01",1500,606.26,0,893.74,23356.5,583.91,3257.47]
["2009-08-01","2009-08-24",1000,583.91,0,416.09000000000003,22940.41,573.51,3199.43]
["2009-11-01","2009-11-10",1000,573.51,0,426.49,22513.919999999998,562.85,3139.95]
["2010-02-01","2009-02-16",4000,562.85,0,3437.15,19076.769999999997,476.92,2660.58]
["2010-05-01","2010-06-04",1500,{"$f":"H11","v":476.92},0,{"$f":"C12-(D12+E12)","v":1023.0799999999999},{"$f":"G11-F12","v":18053.689999999995},451.34,2517.9]
["2010-08-01","2010-07-21",4000,{"$f":"H12","v":451.34},0,{"$f":"C13-(D13+E13)","v":3548.66},{"$f":"G12-F13","v":14505.029999999995},{"$f":"ROUND($F$1*G13,2)","v":362.63},2022.98]
["2010-11-01","2010-11-01",2022.98,{"$f":"H13","v":362.63},0,{"$f":"C14-(D14+E14)","v":1660.35},{"$f":"G13-F14","v":12844.679999999995},321.12,{"$f":"ROUND(G14/((1-(1+$F$1)^-7)/$F$1),2)","v":2022.98}]
["2011-02-01","2011-01-31",2022.98,{"$f":"H14","v":321.12},0,1701.8600000000001,{"$f":"G14-F15","v":11142.819999999994},278.57,{"$f":"ROUND(G15/((1-(1+$F$1)^-6)/$F$1),2)","v":2022.98}]
["2011-05-01","2011-05-03",2022.98,{"$f":"H15","v":278.57},0,1744.41,9398.4099999999944,234.96,{"$f":"ROUND(G16/((1-(1+$F$1)^-5)/$F$1),2)","v":2022.98}]
["2011-08-01","2011-08-08",2022.98,234.96,0,{"$f":"C17-(D17+E17)","v":1788.02},{"$f":"G16-F17","v":7610.389999999994},190.26,{"$f":"ROUND(G17/((1-(1+$F$1)^-4)/$F$1),2)","v":2022.98}]
["2011-11-01",null,2022.98,190.26,0,1832.72,5777.6699999999937,{"$f":"ROUND($F$1*G18,2)","v":144.44},{"$f":"ROUND(G18/((1-(1+$F$1)^-3)/$F$1),2)","v":2022.98}]
["2012-02-01",null,2022.98,144.44,0,{"$f":"C19-(D19+E19)","v":1878.54},{"$f":"G18-F19","v":3899.1299999999937},97.48,{"$f":"ROUND(G19/((1-(1+$F$1)^-2)/$F$1),2)","v":2022.97}]
["2012-05-01",null,2022.98,97.48,0,1925.5,1973.6299999999937,49.34,{"$f":"ROUND(G20/((1-(1+$F$1)^-1)/$F$1),2)","v":2022.97}]
["2012-08-01",null,2022.97,49.34,0,1973.63,-6.3664629124104977E-12,0,{"$f":"ROUND(G21/((1-(1+$F$1)^-4)/$F$1),2)","v":0}]
[]
[]
["Above dotted line: minimum payments are outstanding interest"]
["Below dotted line: minimum payment is blended payment (principal + interest) over 8 quarters"]
["Coloured background indicates projected payments"]

{"sheet":"Sudoku Base","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Sudoku 1","index":2,"n_rows":19,"n_cols":10,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,7,null,null,null,8,null,null,null,6]
[]
[null,null,null,null,7,null,5,null,1]
[]
[null,null,null,1,null,4,null,8,9,7]
[]
[null,2,1,5,null,3]
[]
[]
[]
[null,null,null,null,8,null,null,7,6,2]
[]
[null,null,3,null,null,2,null,6]
[]
[null,null,8,null,9,null,7]
[]
[null,null,null,null,null,3,null,null,null,5]

{"sheet":"Sheet1","index":3,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}