{"text_format":"2","workbook":"xls","n_sheets":7,"sheets":["Year 1-6","Year 7-12","Year 13-18","Year 19-24","Year 25-30","Sheet2","Sheet3"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":1,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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","formulas":"cached_only"}

{"sheet":"Year 1-6","index":0,"n_rows":57,"n_cols":11,"rows_kept":57,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
[null,null,null,"Loan",21393.36]
[null,null,null,"Rate",0.06]
[null,null,null,"Months",360]
[null,null,null,"Years",30]
[null,null,null,"Payment",-128.26]
[]
[]
[1999,null,null,"Total","Loan",{"$nulls":4},"Total","Loan"]
["Year 1","Principle","Interest","Payment","Balance",null,"Year 4","Principle","Interest","Payment","Balance"]
["Payment 1",21.29,106.97,128.26,21372.07,null,"Payment 1",42.3,85.96,128.26,17148.809999999994]
["Payment 2",21.4,106.86,128.26,21350.67,null,"Payment 2",42.52,85.74,128.26,17106.289999999994]
["Payment 3",21.51,106.75,128.26,21329.16,null,"Payment 3",42.73,85.53,128.26,17063.559999999994]
["Payment 4",21.61,106.65,128.26,21307.55,null,"Payment 4",42.94,85.32,128.26,17020.619999999995]
["Payment 5",21.72,106.54,128.26,21285.829999999998,null,"Payment 5",43.16,85.1,128.26,16977.459999999995]
["Payment 6",21.83,106.43,128.26,21263.999999999996,null,"Payment 6",43.37,84.89,128.26,16934.089999999997]
["Payment 7",21.94,106.32,128.26,21242.059999999998,null,"Payment 7",43.59,84.67,128.26,16890.499999999996]
["Payment 8",22.05,106.21,128.26,21220.01,null,"Payment 8",43.81,84.45,128.26,16846.689999999995]
["Payment 9",22.16,106.1,128.26,21197.85,null,"Payment 9",44.03,84.23,128.26,16802.659999999996]
["Payment 10",22.27,105.99,128.26,21175.579999999998,null,"Payment 10",44.25,84.01,128.26,16758.409999999996]
["Payment 11",22.38,105.88,128.26,21153.199999999997,null,"Payment 11",44.47,83.79,128.26,16713.939999999995]
["Payment 12",22.49,105.77,128.26,21130.709999999995,null,"Payment 12",44.69,83.57,128.26,16669.249999999996]
["     Gift",3000,null,3000,18130.709999999995,null,"     Gift",0,null,0,16669.249999999996]
["Total Year 1",262.65000000000003,1276.4699999999998,1539.12,null,null,"Total Year 4",521.8600000000001,1017.26,1539.12]
[]
[2000,null,null,"Total","Loan",{"$nulls":4},"Total","Loan"]
["Year 2","Principle","Interest","Payment","Balance",null,"Year 5","Principle","Interest","Payment","Balance"]
["Payment 1",22.61,105.65,128.26,18108.099999999995,null,"Payment 1",44.91,83.35,128.26,16624.339999999997]
["Payment 2",37.72,90.54,128.26,18070.379999999994,null,"Payment 2",45.14,83.12,128.26,16579.199999999997]
["Payment 3",37.91,90.35,128.26,18032.469999999994,null,"Payment 3",45.36,82.9,128.26,16533.839999999997]
["Payment 4",38.1,90.16,128.26,17994.369999999995,null,"Payment 4",45.59,82.67,128.26,16488.249999999996]
["Payment 5",38.29,89.97,128.26,17956.079999999994,null,"Payment 5",45.82,82.44,128.26,16442.429999999997]
["Payment 6",38.48,89.78,128.26,17917.599999999995,null,"Payment 6",46.05,82.21,128.26,16396.379999999997]
["Payment 7",38.67,89.59,128.26,17878.929999999997,null,"Payment 7",46.28,81.98,128.26,16350.099999999997]
["Payment 8",38.87,89.39,128.26,17840.059999999998,null,"Payment 8",46.51,81.75,128.26,16303.589999999997]
["Payment 9",39.06,89.2,128.26,17800.999999999996,null,"Payment 9",46.74,81.52,128.26,16256.849999999997]
["Payment 10",39.25,89.01,128.26,17761.749999999996,null,"Payment 10",46.98,81.28,128.26,16209.869999999997]
["Payment 11",39.45,88.81,128.26,17722.299999999996,null,"Payment 11",47.21,81.05,128.26,16162.659999999998]
["Payment 12",39.65,88.61,128.26,17682.649999999994,null,"Payment 12",47.45,80.81,128.26,16115.209999999997]
["     Gift",0,null,0,17682.649999999994]
["Total Year 2",448.05999999999995,1091.06,1539.12,null,null,"Total Year 5",554.04,985.0799999999999,1539.12]
[]
[null,null,null,"Total","Loan",{"$nulls":4},"Total","Loan"]
["Year 3","Principle","Interest","Payment","Balance",null,"Year 6","Principle","Interest","Payment","Balance"]
["Payment 1",39.85,88.41,128.26,17642.799999999996,null,"Payment 1",47.68,80.58,128.26,16067.529999999997]
["Payment 2",40.05,88.21,128.26,17602.749999999996,null,"Payment 2",47.92,80.34,128.26,16019.609999999997]
["Payment 3",40.25,88.01,128.26,17562.499999999996,null,"Payment 3",48.16,80.1,128.26,15971.449999999997]
["Payment 4",40.45,87.81,128.26,17522.049999999996,null,"Payment 4",48.4,79.86,128.26,15923.049999999997]
["Payment 5",40.65,87.61,128.26,17481.399999999994,null,"Payment 5",48.64,79.62,128.26,15874.409999999998]
["Payment 6",40.85,87.41,128.26,17440.549999999996,null,"Payment 6",48.89,79.37,128.26,15825.519999999999]
["Payment 7",41.06,87.2,128.26,17399.489999999994,null,"Payment 7",49.13,79.13,128.26,15776.39]
["Payment 8",41.26,87,128.26,17358.229999999996,null,"Payment 8",49.38,78.88,128.26,15727.01]
["Payment 9",41.47,86.79,128.26,17316.759999999995,null,"Payment 9",49.62,78.64,128.26,15677.39]
["Payment 10",41.68,86.58,128.26,17275.079999999994,null,"Payment 10",49.87,78.39,128.26,15627.519999999999]
["Payment 11",41.88,86.38,128.26,17233.199999999993,null,"Payment 11",50.12,78.14,128.26,15577.399999999998]
["Payment 12",42.09,86.17,128.26,17191.109999999993,null,"Payment 12",50.37,77.89,128.26,15527.029999999997]
["     Gift",0,null,0,17191.109999999993]
["Total Year 3",491.53999999999996,1047.5800000000002,1539.12,null,null,"Total Year 6",588.18,950.9399999999999,1539.12]

{"sheet":"Year 7-12","index":1,"n_rows":54,"n_cols":11,"rows_kept":54,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
[null,null,null,"Loan",21393.36]
[null,null,null,"Rate",0.06]
[null,null,null,"Months",360]
[null,null,null,"Years",30]
[null,null,null,"Payment",-128.26]
[]
[]
[null,null,null,"Total","Loan",{"$nulls":4},"Total","Loan"]
["Year 7","Principle","Interest","Payment","Balance",null,"Year 10","Principle","Interest","Payment","Balance"]
["Payment 1",50.62,77.64,128.26,15476.409999999996,null,"Payment 1",60.58,67.68,128.26,13475.070000000002]
["Payment 2",50.88,77.38,128.26,15425.529999999997,null,"Payment 2",60.88,67.38,128.26,13414.190000000002]
["Payment 3",51.13,77.13,128.26,15374.399999999998,null,"Payment 3",61.19,67.07,128.26,13353.000000000002]
["Payment 4",51.39,76.87,128.26,15323.009999999998,null,"Payment 4",61.49,66.77,128.26,13291.510000000002]
["Payment 5",51.64,76.62,128.26,15271.369999999999,null,"Payment 5",61.8,66.46,128.26,13229.710000000003]
["Payment 6",51.9,76.36,128.26,15219.47,null,"Payment 6",62.11,66.15,128.26,13167.600000000002]
["Payment 7",52.16,76.1,128.26,15167.31,null,"Payment 7",62.42,65.84,128.26,13105.180000000002]
["Payment 8",52.42,75.84,128.26,15114.89,null,"Payment 8",62.73,65.53,128.26,13042.450000000003]
["Payment 9",52.69,75.57,128.26,15062.199999999999,null,"Payment 9",63.05,65.21,128.26,12979.400000000003]
["Payment 10",52.95,75.31,128.26,15009.249999999998,null,"Payment 10",63.36,64.9,128.26,12916.040000000003]
["Payment 11",53.21,75.05,128.26,14956.039999999999,null,"Payment 11",63.68,64.58,128.26,12852.360000000002]
["Payment 12",53.48,74.78,128.26,14902.56,null,"Payment 12",64,64.26,128.26,12788.360000000002]
["Total Year 7",624.47,914.6499999999999,1539.12,null,null,"Total Year 10",747.29,791.83,1539.12]
[]
[null,null,null,"Total","Loan",{"$nulls":4},"Total","Loan"]
["Year 8","Principle","Interest","Payment","Balance",null,"Year 11","Principle","Interest","Payment","Balance"]
["Payment 1",53.75,74.51,128.26,14848.81,null,"Payment 1",64.32,63.94,128.26,12724.040000000003]
["Payment 2",54.02,74.24,128.26,14794.789999999999,null,"Payment 2",64.64,63.62,128.26,12659.400000000003]
["Payment 3",54.29,73.97,128.26,14740.499999999998,null,"Payment 3",64.96,63.3,128.26,12594.440000000004]
["Payment 4",54.56,73.7,128.26,14685.939999999999,null,"Payment 4",65.29,62.97,128.26,12529.150000000003]
["Payment 5",54.83,73.43,128.26,14631.109999999999,null,"Payment 5",65.61,62.65,128.26,12463.540000000003]
["Payment 6",55.1,73.16,128.26,14576.009999999998,null,"Payment 6",65.94,62.32,128.26,12397.600000000002]
["Payment 7",55.38,72.88,128.26,14520.63,null,"Payment 7",66.27,61.99,128.26,12331.330000000002]
["Payment 8",55.66,72.6,128.26,14464.97,null,"Payment 8",66.6,61.66,128.26,12264.730000000001]
["Payment 9",55.94,72.32,128.26,14409.029999999999,null,"Payment 9",66.94,61.32,128.26,12197.79]
["Payment 10",56.21,72.05,128.26,14352.82,null,"Payment 10",67.27,60.99,128.26,12130.52]
["Payment 11",56.5,71.76,128.26,14296.32,null,"Payment 11",67.61,60.65,128.26,12062.91]
["Payment 12",56.78,71.48,128.26,14239.539999999999,null,"Payment 12",67.95,60.31,128.26,11994.96]
["Total Year 8",663.02,876.0999999999999,1539.12,null,null,"Total Year 11",793.4,745.72,1539.12]
[]
[null,null,null,"Total","Loan",{"$nulls":4},"Total","Loan"]
["Year 9","Principle","Interest","Payment","Balance",null,"Year 12","Principle","Interest","Payment","Balance"]
["Payment 1",57.06,71.2,128.26,14182.48,null,"Payment 1",68.29,59.97,128.26,11926.669999999998]
["Payment 2",57.35,70.91,128.26,14125.13,null,"Payment 2",68.63,59.63,128.26,11858.039999999999]
["Payment 3",57.63,70.63,128.26,14067.5,null,"Payment 3",68.97,59.29,128.26,11789.07]
["Payment 4",57.92,70.34,128.26,14009.58,null,"Payment 4",69.31,58.95,128.26,11719.76]
["Payment 5",58.21,70.05,128.26,13951.37,null,"Payment 5",69.66,58.6,128.26,11650.1]
["Payment 6",58.5,69.76,128.26,13892.87,null,"Payment 6",70.01,58.25,128.26,11580.09]
["Payment 7",58.8,69.46,128.26,13834.070000000002,null,"Payment 7",70.36,57.9,128.26,11509.73]
["Payment 8",59.09,69.17,128.26,13774.980000000001,null,"Payment 8",70.71,57.55,128.26,11439.02]
["Payment 9",59.39,68.87,128.26,13715.590000000002,null,"Payment 9",71.06,57.2,128.26,11367.960000000001]
["Payment 10",59.68,68.58,128.26,13655.910000000002,null,"Payment 10",71.42,56.84,128.26,11296.54]
["Payment 11",59.98,68.28,128.26,13595.930000000002,null,"Payment 11",71.78,56.48,128.26,11224.76]
["Payment 12",60.28,67.98,128.26,13535.650000000001,null,"Payment 12",72.14,56.12,128.26,11152.62]
["Total Year 9",703.8899999999999,835.23,1539.12,null,null,"Total Year 12",842.3399999999999,696.7800000000001,1539.12]

{"sheet":"Year 13-18","index":2,"n_rows":54,"n_cols":11,"rows_kept":54,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
[null,null,null,"Loan",21393.36]
[null,null,null,"Rate",0.06]
[null,null,null,"Months",360]
[null,null,null,"Years",30]
[null,null,null,"Payment",-128.26]
[]
[]
[null,null,null,"Total","Loan",{"$nulls":4},"Total","Loan"]
["Year 13","Principle","Interest","Payment","Balance",null,"Year 16","Principle","Interest","Payment","Balance"]
["Payment 1",72.5,55.76,128.26,11080.12,null,"Payment 1",86.76,41.5,128.26,8214.119999999997]
["Payment 2",72.86,55.4,128.26,11007.26,null,"Payment 2",87.19,41.07,128.26,8126.929999999998]
["Payment 3",73.22,55.04,128.26,10934.04,null,"Payment 3",87.63,40.63,128.26,8039.299999999997]
["Payment 4",73.59,54.67,128.26,10860.45,null,"Payment 4",88.06,40.2,128.26,7951.239999999997]
["Payment 5",73.96,54.3,128.26,10786.490000000002,null,"Payment 5",88.5,39.76,128.26,7862.739999999997]
["Payment 6",74.33,53.93,128.26,10712.160000000002,null,"Payment 6",88.95,39.31,128.26,7773.789999999997]
["Payment 7",74.7,53.56,128.26,10637.460000000001,null,"Payment 7",89.39,38.87,128.26,7684.399999999997]
["Payment 8",75.07,53.19,128.26,10562.390000000001,null,"Payment 8",89.84,38.42,128.26,7594.559999999997]
["Payment 9",75.45,52.81,128.26,10486.94,null,"Payment 9",90.29,37.97,128.26,7504.269999999997]
["Payment 10",75.83,52.43,128.26,10411.11,null,"Payment 10",90.74,37.52,128.26,7413.529999999997]
["Payment 11",76.2,52.06,128.26,10334.91,null,"Payment 11",91.19,37.07,128.26,7322.339999999997]
["Payment 12",76.59,51.67,128.26,10258.32,null,"Payment 12",91.65,36.61,128.26,7230.689999999998]
["Total Year 13",894.3000000000002,644.82,1539.12,null,null,"Total Year 16",1070.19,468.93,1539.12]
[]
[null,null,null,"Total","Loan",{"$nulls":4},"Total","Loan"]
["Year 14","Principle","Interest","Payment","Balance",null,"Year 17","Principle","Interest","Payment","Balance"]
["Payment 1",76.97,51.29,128.26,10181.35,null,"Payment 1",92.11,36.15,128.26,7138.579999999998]
["Payment 2",77.35,50.91,128.26,10104,null,"Payment 2",92.57,35.69,128.26,7046.009999999998]
["Payment 3",77.74,50.52,128.26,10026.26,null,"Payment 3",93.03,35.23,128.26,6952.979999999999]
["Payment 4",78.13,50.13,128.26,9948.130000000001,null,"Payment 4",93.5,34.76,128.26,6859.479999999999]
["Payment 5",78.52,49.74,128.26,9869.61,null,"Payment 5",93.96,34.3,128.26,6765.519999999999]
["Payment 6",78.91,49.35,128.26,9790.7,null,"Payment 6",94.43,33.83,128.26,6671.089999999998]
["Payment 7",79.31,48.95,128.26,9711.390000000001,null,"Payment 7",94.9,33.36,128.26,6576.189999999999]
["Payment 8",79.7,48.56,128.26,9631.69,null,"Payment 8",95.38,32.88,128.26,6480.809999999999]
["Payment 9",80.1,48.16,128.26,9551.59,null,"Payment 9",95.86,32.4,128.26,6384.949999999999]
["Payment 10",80.5,47.76,128.26,9471.09,null,"Payment 10",96.34,31.92,128.26,6288.609999999999]
["Payment 11",80.9,47.36,128.26,9390.19,null,"Payment 11",96.82,31.44,128.26,6191.789999999999]
["Payment 12",81.31,46.95,128.26,9308.880000000001,null,"Payment 12",97.3,30.96,128.26,6094.489999999999]
["Total Year 14",949.44,589.6800000000001,1539.12,null,null,"Total Year 17",1136.2,402.91999999999996,1539.12]
[]
[null,null,null,"Total","Loan",{"$nulls":4},"Total","Loan"]
["Year 15","Principle","Interest","Payment","Balance",null,"Year 18","Principle","Interest","Payment","Balance"]
["Payment 1",81.72,46.54,128.26,9227.160000000002,null,"Payment 1",97.79,30.47,128.26,5996.699999999999]
["Payment 2",82.12,46.14,128.26,9145.04,null,"Payment 2",98.28,29.98,128.26,5898.419999999999]
["Payment 3",82.53,45.73,128.26,9062.51,null,"Payment 3",98.77,29.49,128.26,5799.649999999999]
["Payment 4",82.95,45.31,128.26,8979.56,null,"Payment 4",99.26,29,128.26,5700.3899999999985]
["Payment 5",83.36,44.9,128.26,8896.199999999999,null,"Payment 5",99.76,28.5,128.26,5600.629999999998]
["Payment 6",83.78,44.48,128.26,8812.419999999998,null,"Payment 6",100.26,28,128.26,5500.369999999998]
["Payment 7",84.2,44.06,128.26,8728.219999999998,null,"Payment 7",100.76,27.5,128.26,5399.609999999998]
["Payment 8",84.62,43.64,128.26,8643.599999999997,null,"Payment 8",101.26,27,128.26,5298.349999999998]
["Payment 9",85.04,43.22,128.26,8558.559999999996,null,"Payment 9",101.77,26.49,128.26,5196.579999999997]
["Payment 10",85.47,42.79,128.26,8473.089999999997,null,"Payment 10",102.28,25.98,128.26,5094.299999999997]
["Payment 11",85.89,42.37,128.26,8387.199999999997,null,"Payment 11",102.79,25.47,128.26,4991.5099999999975]
["Payment 12",86.32,41.94,128.26,8300.879999999997,null,"Payment 12",103.3,24.96,128.26,4888.209999999997]
["Total Year 15",1008,531.12,1539.12,null,null,"Total Year 18",1206.28,332.84,1539.12]

{"sheet":"Year 19-24","index":3,"n_rows":54,"n_cols":11,"rows_kept":54,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
[null,null,null,"Loan",21393.36]
[null,null,null,"Rate",0.06]
[null,null,null,"Months",360]
[null,null,null,"Years",30]
[null,null,null,"Payment",-128.26]
[]
[]
[null,null,null,"Total","Loan",{"$nulls":4},"Total","Loan"]
["Year 19","Principle","Interest","Payment","Balance",null,"Year 22","Principle","Interest","Payment","Balance"]
["Payment 1",103.82,24.44,128.26,4784.389999999998,null,"Payment 1",124.24,4.02,128.26,680.1299999999966]
["Payment 2",104.34,23.92,128.26,4680.049999999997,null,"Payment 2",124.86,3.4,128.26,555.2699999999966]
["Payment 3",104.86,23.4,128.26,4575.189999999998,null,"Payment 3",125.48,2.78,128.26,429.78999999999655]
["Payment 4",105.38,22.88,128.26,4469.809999999998,null,"Payment 4",126.11,2.15,128.26,303.67999999999654]
["Payment 5",105.91,22.35,128.26,4363.899999999998,null,"Payment 5",126.74,1.52,128.26,176.93999999999653]
["Payment 6",106.44,21.82,128.26,4257.459999999998,null,"Payment 6",127.38,0.88,128.26,49.559999999996535]
["Payment 7",106.97,21.29,128.26,4150.489999999998,null,"Payment 7",128.01,0.25,128.26,-78.45000000000346]
["Payment 8",107.51,20.75,128.26,4042.9799999999977,null,"Payment 8",128.65,-0.39,128.26000000000002,-207.10000000000346]
["Payment 9",108.05,20.21,128.26,3934.9299999999976,null,"Payment 9",129.3,-1.04,128.26000000000002,-336.4000000000035]
["Payment 10",108.59,19.67,128.26,3826.3399999999974,null,"Payment 10",129.94,-1.68,128.26,-466.3400000000035]
["Payment 11",109.13,19.13,128.26,3717.2099999999973,null,"Payment 11",130.59,-2.33,128.26,-596.9300000000035]
["Payment 12",109.67,18.59,128.26,3607.5399999999972,null,"Payment 12",131.24,-2.98,128.26000000000002,-728.1700000000035]
["Total Year 19",1280.67,258.44999999999993,1539.12,null,null,"Total Year 22",1532.54,6.58,1539.12]
[]
[null,null,null,"Total","Loan",{"$nulls":4},"Total","Loan"]
["Year 20","Principle","Interest","Payment","Balance",null,"Year 23","Principle","Interest","Payment","Balance"]
["Payment 1",110.22,18.04,128.26,3497.3199999999974,null,"Payment 1",131.9,-3.64,128.26000000000002,-860.0700000000035]
["Payment 2",110.77,17.49,128.26,3386.5499999999975,null,"Payment 2",132.56,-4.3,128.26,-992.6300000000035]
["Payment 3",111.33,16.93,128.26,3275.2199999999975,null,"Payment 3",133.22,-4.96,128.26,-1125.8500000000035]
["Payment 4",111.88,16.38,128.26,3163.3399999999974,null,"Payment 4",133.89,-5.63,128.26,-1259.7400000000034]
["Payment 5",112.44,15.82,128.26,3050.8999999999974,null,"Payment 5",134.56,-6.3,128.26,-1394.3000000000034]
["Payment 6",113.01,15.25,128.26,2937.889999999997,null,"Payment 6",135.23,-6.97,128.26,-1529.5300000000034]
["Payment 7",113.57,14.69,128.26,2824.319999999997,null,"Payment 7",135.91,-7.65,128.26,-1665.4400000000035]
["Payment 8",114.14,14.12,128.26,2710.179999999997,null,"Payment 8",136.59,-8.33,128.26,-1802.0300000000034]
["Payment 9",114.71,13.55,128.26,2595.469999999997,null,"Payment 9",137.27,-9.01,128.26000000000002,-1939.3000000000034]
["Payment 10",115.28,12.98,128.26,2480.189999999997,null,"Payment 10",137.96,-9.7,128.26000000000002,-2077.2600000000034]
["Payment 11",115.86,12.4,128.26,2364.3299999999967,null,"Payment 11",138.65,-10.39,128.26,-2215.9100000000035]
["Payment 12",116.44,11.82,128.26,2247.8899999999967,null,"Payment 12",139.34,-11.08,128.26,-2355.2500000000036]
["Total Year 20",1359.65,179.47,1539.12,null,null,"Total Year 23",1627.0800000000002,-87.96,1539.12]
[]
[null,null,null,"Total","Loan",{"$nulls":4},"Total","Loan"]
["Year 21","Principle","Interest","Payment","Balance",null,"Year 24","Principle","Interest","Payment","Balance"]
["Payment 1",117.02,11.24,128.26,2130.8699999999967,null,"Payment 1",140.04,-11.78,128.26,-2495.2900000000036]
["Payment 2",117.61,10.65,128.26,2013.2599999999968,null,"Payment 2",140.74,-12.48,128.26000000000002,-2636.0300000000034]
["Payment 3",118.19,10.07,128.26,1895.0699999999968,null,"Payment 3",141.44,-13.18,128.26,-2777.4700000000034]
["Payment 4",118.78,9.48,128.26,1776.2899999999968,null,"Payment 4",142.15,-13.89,128.26,-2919.6200000000035]
["Payment 5",119.38,8.88,128.26,1656.9099999999967,null,"Payment 5",142.86,-14.6,128.26000000000002,-3062.4800000000037]
["Payment 6",119.98,8.28,128.26,1536.9299999999967,null,"Payment 6",143.57,-15.31,128.26,-3206.050000000004]
["Payment 7",120.58,7.68,128.26,1416.3499999999967,null,"Payment 7",144.29,-16.03,128.26,-3350.340000000004]
["Payment 8",121.18,7.08,128.26000000000002,1295.1699999999967,null,"Payment 8",145.01,-16.75,128.26,-3495.350000000004]
["Payment 9",121.78,6.48,128.26,1173.3899999999967,null,"Payment 9",145.74,-17.48,128.26000000000002,-3641.090000000004]
["Payment 10",122.39,5.87,128.26,1050.9999999999966,null,"Payment 10",146.47,-18.21,128.26,-3787.5600000000036]
["Payment 11",123.01,5.25,128.26,927.9899999999966,null,"Payment 11",147.2,-18.94,128.26,-3934.7600000000034]
["Payment 12",123.62,4.64,128.26,804.3699999999966,null,"Payment 12",147.93,-19.67,128.26,-4082.6900000000032]
["Total Year 21",1443.52,95.60000000000001,1539.12,null,null,"Total Year 24",1727.44,-188.32,1539.12]

{"sheet":"Year 25-30","index":4,"n_rows":54,"n_cols":11,"rows_kept":54,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
[null,null,null,"Loan",21393.36]
[null,null,null,"Rate",0.06]
[null,null,null,"Months",360]
[null,null,null,"Years",30]
[null,null,null,"Payment",-128.26]
[]
[]
[null,null,null,"Total","Loan",{"$nulls":4},"Total","Loan"]
["Year 25","Principle","Interest","Payment","Balance",null,"Year 28","Principle","Interest","Payment","Balance"]
["Payment 1",148.67,-20.41,128.26,-4231.360000000003,null,"Payment 1",177.91,-49.65,128.26,-10108.860000000004]
["Payment 2",149.42,-21.16,128.26,-4380.780000000003,null,"Payment 2",178.8,-50.54,128.26000000000002,-10287.660000000003]
["Payment 3",150.16,-21.9,128.26,-4530.940000000003,null,"Payment 3",179.7,-51.44,128.26,-10467.360000000004]
["Payment 4",150.91,-22.65,128.26,-4681.850000000003,null,"Payment 4",180.6,-52.34,128.26,-10647.960000000005]
["Payment 5",151.67,-23.41,128.26,-4833.520000000003,null,"Payment 5",181.5,-53.24,128.26,-10829.460000000005]
["Payment 6",152.43,-24.17,128.26,-4985.9500000000035,null,"Payment 6",182.41,-54.15,128.26,-11011.870000000004]
["Payment 7",153.19,-24.93,128.26,-5139.140000000003,null,"Payment 7",183.32,-55.06,128.26,-11195.190000000004]
["Payment 8",153.96,-25.7,128.26000000000002,-5293.100000000003,null,"Payment 8",184.24,-55.98,128.26000000000002,-11379.430000000004]
["Payment 9",154.73,-26.47,128.26,-5447.830000000003,null,"Payment 9",185.16,-56.9,128.26,-11564.590000000004]
["Payment 10",155.5,-27.24,128.26,-5603.330000000003,null,"Payment 10",186.08,-57.82,128.26000000000002,-11750.670000000004]
["Payment 11",156.28,-28.02,128.26,-5759.610000000002,null,"Payment 11",187.01,-58.75,128.26,-11937.680000000004]
["Payment 12",157.06,-28.8,128.26,-5916.670000000003,null,"Payment 12",187.95,-59.69,128.26,-12125.630000000005]
["Total Year 25",1833.98,-294.86,1539.12,null,null,"Total Year 28",2194.68,-655.56,1539.12]
[]
[null,null,null,"Total","Loan",{"$nulls":4},"Total","Loan"]
["Year 26","Principle","Interest","Payment","Balance",null,"Year 29","Principle","Interest","Payment","Balance"]
["Payment 1",157.84,-29.58,128.26,-6074.510000000003,null,"Payment 1",188.89,-60.63,128.26,-12314.520000000004]
["Payment 2",158.63,-30.37,128.26,-6233.140000000003,null,"Payment 2",189.83,-61.57,128.26000000000002,-12504.350000000004]
["Payment 3",159.43,-31.17,128.26,-6392.570000000003,null,"Payment 3",190.78,-62.52,128.26,-12695.130000000005]
["Payment 4",160.22,-31.96,128.26,-6552.790000000004,null,"Payment 4",191.74,-63.48,128.26000000000002,-12886.870000000004]
["Payment 5",161.02,-32.76,128.26000000000002,-6713.810000000004,null,"Payment 5",192.69,-64.43,128.26,-13079.560000000005]
["Payment 6",161.83,-33.57,128.26000000000002,-6875.640000000004,null,"Payment 6",193.66,-65.4,128.26,-13273.220000000005]
["Payment 7",162.64,-34.38,128.26,-7038.280000000004,null,"Payment 7",194.63,-66.37,128.26,-13467.850000000004]
["Payment 8",163.45,-35.19,128.26,-7201.730000000004,null,"Payment 8",195.6,-67.34,128.26,-13663.450000000004]
["Payment 9",164.27,-36.01,128.26000000000002,-7366.000000000005,null,"Payment 9",196.58,-68.32,128.26000000000002,-13860.030000000004]
["Payment 10",165.09,-36.83,128.26,-7531.090000000005,null,"Payment 10",197.56,-69.3,128.26,-14057.590000000004]
["Payment 11",165.92,-37.66,128.26,-7697.010000000005,null,"Payment 11",198.55,-70.29,128.26,-14256.140000000003]
["Payment 12",166.75,-38.49,128.26,-7863.760000000005,null,"Payment 12",199.54,-71.28,128.26,-14455.680000000004]
["Total Year 26",1947.0900000000001,-407.97,1539.12,null,null,"Total Year 29",2330.05,-790.9299999999998,1539.12]
[]
[null,null,null,"Total","Loan",{"$nulls":4},"Total","Loan"]
["Year 27","Principle","Interest","Payment","Balance",null,"Year 30","Principle","Interest","Payment","Balance"]
["Payment 1",167.58,-39.32,128.26000000000002,-8031.340000000005,null,"Payment 1",200.54,-72.28,128.26,-14656.220000000005]
["Payment 2",168.42,-40.16,128.26,-8199.760000000004,null,"Payment 2",201.54,-73.28,128.26,-14857.760000000006]
["Payment 3",169.26,-41,128.26,-8369.020000000004,null,"Payment 3",202.55,-74.29,128.26,-15060.310000000005]
["Payment 4",170.11,-41.85,128.26000000000002,-8539.130000000005,null,"Payment 4",203.56,-75.3,128.26,-15263.870000000004]
["Payment 5",170.96,-42.7,128.26,-8710.090000000004,null,"Payment 5",204.58,-76.32,128.26000000000002,-15468.450000000004]
["Payment 6",171.81,-43.55,128.26,-8881.900000000003,null,"Payment 6",205.6,-77.34,128.26,-15674.050000000005]
["Payment 7",172.67,-44.41,128.26,-9054.570000000003,null,"Payment 7",206.63,-78.37,128.26,-15880.680000000004]
["Payment 8",173.53,-45.27,128.26,-9228.100000000004,null,"Payment 8",207.66,-79.4,128.26,-16088.340000000004]
["Payment 9",174.4,-46.14,128.26,-9402.500000000004,null,"Payment 9",208.7,-80.44,128.26,-16297.040000000005]
["Payment 10",175.27,-47.01,128.26000000000002,-9577.770000000004,null,"Payment 10",209.75,-81.49,128.26,-16506.790000000005]
["Payment 11",176.15,-47.89,128.26,-9753.920000000004,null,"Payment 11",210.79,-82.53,128.26,-16717.580000000005]
["Payment 12",177.03,-48.77,128.26,-9930.950000000004,null,"Payment 12",211.85,-83.59,128.26,-16929.430000000004]
["Total Year 27",2067.1900000000005,-528.0699999999999,1539.12,null,null,"Total Year 30",2473.75,-934.63,1539.12]

{"sheet":"Sheet2","index":5,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}

{"sheet":"Sheet3","index":6,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}