{"text_format":"1","workbook":"xls","n_sheets":2,"sheets":["Biweekly Payment Amortization","Variables"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":1,"defined_names":13,"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","formulas":"cached_only"}

{"sheet":"Biweekly Payment Amortization","index":0,"n_rows":214,"n_cols":32,"rows_kept":214,"cut":false,"hidden":false,"merged":[[41,5,42,5],[2,4,2,6],[3,1,3,2],[4,1,4,2],[6,1,6,2],[2,1,2,3],[3,4,3,5],[4,4,4,5],[5,4,5,5],[6,4,6,5],[11,6,12,6],[11,5,12,5],[11,9,12,9],[11,8,12,8],[11,7,12,7],[41,1,42,1],[41,2,42,2],[41,6,42,6],[41,4,42,4],[41,3,42,3],[7,1,7,2],[8,1,8,2],[11,1,12,1],[11,4,12,4],[11,3,12,3],[11,2,12,2]],"flags":["formulas_cached_only"]}
[null,"Mortgage Payment Amortization"]
[]
[null,"Inputs",null,null,"Key Figures"]
[null,"Loan principal amount",null,654645,"Annual loan payments",null,54221.44]
[null,"Annual interest rate",null,0.03,"Biweekly payments",null,2085.44]
[null,"Loan period in years (30 max.)",null,15,"Interest over term of loan",null,158676.6000000001]
[null,"Base year",null,2005,"Sum of all payments",null,813321.6000000001]
[null,"Loan start date",null,"1905-06-23"]
[null,"Date of first payment",null,"1905-07-07"]
[]
[null,"First 26 Payments"]
[null,"Payment #","Payment Date","Beginning Balance","Payment","Principal ","Interest ","Cumulative Principal","Cumulative Interest ","Ending Balance"]
[]
[null,1,"1905-07-07",654645,2085.44,1330.08,755.36,1330.08,755.36,653314.92]
[null,2,"1905-07-21",653314.92,2085.44,1331.62,753.82,2661.7,1509.18,651983.3]
[null,3,"1905-08-04",651983.3,2085.44,1333.15,752.29,3994.85,2261.4700000000003,650650.15]
[null,4,"1905-08-18",650650.15,2085.44,1334.69,750.75,5329.54,3012.2200000000003,649315.4600000001]
[null,5,"1905-09-01",649315.4600000001,2085.44,1336.23,749.21,6665.77,3761.4300000000003,647979.2300000001]
[null,6,"1905-09-15",647979.2300000001,2085.44,1337.77,747.67,8003.540000000001,4509.1,646641.4600000001]
[null,7,"1905-09-29",646641.4600000001,2085.44,1339.3200000000002,746.12,9342.86,5255.22,645302.1400000001]
[null,8,"1905-10-13",645302.1400000001,2085.44,1340.8600000000001,744.58,10683.720000000001,5999.8,643961.2800000001]
[null,9,"1905-10-27",643961.2800000001,2085.44,1342.41,743.03,12026.130000000001,6742.83,642618.8700000001]
[null,10,"1905-11-10",642618.8700000001,2085.44,1343.96,741.48,13370.09,7484.3099999999995,641274.9100000001]
[null,11,"1905-11-24",641274.9100000001,2085.44,1345.5100000000002,739.93,14715.6,8224.24,639929.4000000001]
[null,12,"1905-12-08",639929.4000000001,2085.44,1347.06,738.38,16062.66,8962.619999999999,638582.3400000001]
[null,13,"1905-12-22",638582.3400000001,2085.44,1348.6100000000001,736.83,17411.27,9699.449999999999,637233.7300000001]
[null,14,"1906-01-05",637233.7300000001,2085.44,1350.17,735.27,18761.440000000002,10434.72,635883.56]
[null,15,"1906-01-19",635883.56,2085.44,1351.73,733.71,20113.170000000002,11168.43,634531.8300000001]
[null,16,"1906-02-02",634531.8300000001,2085.44,1353.29,732.15,21466.460000000003,11900.58,633178.54]
[null,17,"1906-02-16",633178.54,2085.44,1354.85,730.59,22821.31,12631.17,631823.6900000001]
[null,18,"1906-03-02",631823.6900000001,2085.44,1356.41,729.03,24177.72,13360.2,630467.28]
[null,19,"1906-03-16",630467.28,2085.44,1357.98,727.46,25535.7,14087.66,629109.3]
[null,20,"1906-03-30",629109.3,2085.44,1359.54,725.9,26895.24,14813.56,627749.76]
[null,21,"1906-04-13",627749.76,2085.44,1361.1100000000001,724.33,28256.350000000002,15537.89,626388.65]
[null,22,"1906-04-27",626388.65,2085.44,1362.68,722.76,29619.030000000002,16260.65,625025.97]
[null,23,"1906-05-11",625025.97,2085.44,1364.2600000000002,721.18,30983.29,16981.829999999998,623661.71]
[null,24,"1906-05-25",623661.71,2085.44,1365.83,719.61,32349.120000000003,17701.44,622295.88]
[null,25,"1906-06-08",622295.88,2085.44,1367.41,718.03,33716.530000000006,18419.469999999998,620928.47]
[null,26,"1906-06-22",620928.47,2085.44,1368.98,716.46,35085.51000000001,19135.929999999997,619559.49]
[]
[null,"Payments for Calendar Years after Year 1"]
[null,"Year","Beginning Balance","Payment","Principal ","Interest ","Ending Balance"]
[]
[null,2006,637233.7300000001,54221.44,35615.320000000065,18606.119999999937,601618.41]
[null,2007,601618.41,54221.44,36699.46000000008,17521.979999999923,564918.95]
[null,2008,564918.95,54221.44,37816.46999999997,16404.97000000003,527102.48]
[null,2009,527102.48,54221.44,38967.47999999998,15253.960000000021,488135]
[null,2010,488135,54221.44,40153.52000000002,14067.919999999984,447981.48]
[null,2011,447981.48,54221.44,41375.659999999974,12845.780000000028,406605.82]
[null,2012,406605.82,54221.44,42635,11586.440000000002,363970.82]
[null,2013,363970.82,54221.44,43932.67999999999,10288.76000000001,320038.14]
[null,2014,320038.14,54221.44,45269.830000000016,8951.609999999986,274768.31]
[null,2015,274768.31,54221.44,46647.70999999999,7573.7300000000105,228120.6]
[null,2016,228120.6,54221.44,48067.5,6153.940000000002,180053.1]
[null,2017,180053.1,54221.44,49530.53,4690.9100000000035,130522.57]
[null,2018,130522.57,54221.44,51038.06000000001,3183.37999999999,79484.51]
[null,2019,79484.51,54221.44,52591.5,1629.9400000000023,26893.01]
[null,2020,26893.01,27110.72,26893.01,217.71000000000276,0]
[null,"","","","","",""]
[null,"","","","","",""]
[null,"","","","","",""]
[null,"","","","","",""]
[null,"","","","","",""]
[null,"","","","","",""]
[null,"","","","","",""]
[null,"","","","","",""]
[null,"","","","","",""]
[null,"","","","","",""]
[null,"","","","","",""]
[null,"","","","","",""]
[null,"","","","","",""]
[null,"","","","","",""]
[null,"","","","","",""]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Do Not Delete "]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Year"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1905]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2015,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2029,2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2043,3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2057,4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2071,5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2085,6]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2099,7]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2113,8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2127,9]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2141,10]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2155,11]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2169,12]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2183,13]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,14]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,15]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,16]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,17]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,18]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,19]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,20]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,21]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,22]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,23]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,24]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,25]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,26]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1905-12-22"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Periods in first year calendar year",null,13]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,377,786210.88]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,351,731989.4400000001]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,325,677768]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,299,623546.56]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,273,569325.12]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,247,515103.68]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,221,460882.24]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,195,406660.8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,169,352439.36]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,143,298217.92]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,11,117,243996.48]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,12,91,189775.04]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,13,65,135553.6]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,14,39,81332.16]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15,13,27110.72]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,16,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,17,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,19,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,20,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,21,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,22,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,23,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,24,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,25,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,26,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,27,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,28,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,29,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,30,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]

{"sheet":"Variables","index":1,"n_rows":4,"n_cols":2,"rows_kept":4,"cut":false,"hidden":true,"merged":[],"flags":["formulas_cached_only"]}
["_Example",false]
["_Shading",false]
["_Series","OfficeReady 3.0"]
["_Look",1]