{"text_format":"3","workbook":"xls","n_sheets":2,"sheets":["Biweekly Payment Amortization","Variables"],"not_rendered":{"external_links":1,"defined_names":13},"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"Biweekly Payment Amortization","index":0,"n_rows":214,"n_cols":32,"rows_kept":214,"merged":[[2,1,2,3],[2,4,2,6],[3,1,3,2],[3,4,3,5],[4,1,4,2],[4,4,4,5],[5,4,5,5],[6,1,6,2],[6,4,6,5],[7,1,7,2],[8,1,8,2],[11,1,12,1],[11,2,12,2],[11,3,12,3],[11,4,12,4],[11,5,12,5],[11,6,12,6],[11,7,12,7],[11,8,12,8],[11,9,12,9],[41,1,42,1],[41,2,42,2],[41,3,42,3],[41,4,42,4],[41,5,42,5],[41,6,42,6]],"flags":["formulas_cached_only"]}
[null,"Biweekly Mortgage Payment Amortization"]
[]
[null,"Inputs",null,null,"Key Figures"]
[null,"Loan principal amount",null,{"v":654645,"d":"$654,645"},"Annual loan payments",null,{"v":54221.44,"d":"$54,221.44"}]
[null,"Annual interest rate",null,{"v":0.03,"d":"3.000%"},"Biweekly payments",null,{"v":2085.44,"d":"$2,085.44"}]
[null,"Loan period in years (30 max.)",null,15,"Interest over term of loan",null,{"v":158676.6000000001,"d":"$158,676.60"}]
[null,"Base year",null,2005,"Sum of all payments",null,{"v":813321.6000000001,"d":"$813,321.60"}]
[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",{"v":654645,"d":"$654,645.00"},{"v":2085.44,"d":"$2,085.44"},{"v":1330.08,"d":"$1,330.08"},{"v":755.36,"d":"$755.36"},{"v":1330.08,"d":"$1,330.08"},{"v":755.36,"d":"$755.36"},{"v":653314.92,"d":"$653,314.92"}]
[null,2,"1905-07-21",{"v":653314.92,"d":"653,314.92"},{"v":2085.44,"d":"2,085.44"},{"v":1331.62,"d":"1,331.62"},753.82,{"v":2661.7,"d":"2,661.70"},{"v":1509.18,"d":"1,509.18"},{"v":651983.3,"d":"651,983.30"}]
[null,3,"1905-08-04",{"v":651983.3,"d":"651,983.30"},{"v":2085.44,"d":"2,085.44"},{"v":1333.15,"d":"1,333.15"},752.29,{"v":3994.85,"d":"3,994.85"},{"v":2261.4700000000003,"d":"2,261.47"},{"v":650650.15,"d":"650,650.15"}]
[null,4,"1905-08-18",{"v":650650.15,"d":"650,650.15"},{"v":2085.44,"d":"2,085.44"},{"v":1334.69,"d":"1,334.69"},750.75,{"v":5329.54,"d":"5,329.54"},{"v":3012.2200000000003,"d":"3,012.22"},{"v":649315.4600000001,"d":"649,315.46"}]
[null,5,"1905-09-01",{"v":649315.4600000001,"d":"649,315.46"},{"v":2085.44,"d":"2,085.44"},{"v":1336.23,"d":"1,336.23"},749.21,{"v":6665.77,"d":"6,665.77"},{"v":3761.4300000000003,"d":"3,761.43"},{"v":647979.2300000001,"d":"647,979.23"}]
[null,6,"1905-09-15",{"v":647979.2300000001,"d":"647,979.23"},{"v":2085.44,"d":"2,085.44"},{"v":1337.77,"d":"1,337.77"},747.67,{"v":8003.540000000001,"d":"8,003.54"},{"v":4509.1,"d":"4,509.10"},{"v":646641.4600000001,"d":"646,641.46"}]
[null,7,"1905-09-29",{"v":646641.4600000001,"d":"646,641.46"},{"v":2085.44,"d":"2,085.44"},{"v":1339.3200000000002,"d":"1,339.32"},746.12,{"v":9342.86,"d":"9,342.86"},{"v":5255.22,"d":"5,255.22"},{"v":645302.1400000001,"d":"645,302.14"}]
[null,8,"1905-10-13",{"v":645302.1400000001,"d":"645,302.14"},{"v":2085.44,"d":"2,085.44"},{"v":1340.8600000000001,"d":"1,340.86"},744.58,{"v":10683.720000000001,"d":"10,683.72"},{"v":5999.8,"d":"5,999.80"},{"v":643961.2800000001,"d":"643,961.28"}]
[null,9,"1905-10-27",{"v":643961.2800000001,"d":"643,961.28"},{"v":2085.44,"d":"2,085.44"},{"v":1342.41,"d":"1,342.41"},743.03,{"v":12026.130000000001,"d":"12,026.13"},{"v":6742.83,"d":"6,742.83"},{"v":642618.8700000001,"d":"642,618.87"}]
[null,10,"1905-11-10",{"v":642618.8700000001,"d":"642,618.87"},{"v":2085.44,"d":"2,085.44"},{"v":1343.96,"d":"1,343.96"},741.48,{"v":13370.09,"d":"13,370.09"},{"v":7484.3099999999995,"d":"7,484.31"},{"v":641274.9100000001,"d":"641,274.91"}]
[null,11,"1905-11-24",{"v":641274.9100000001,"d":"641,274.91"},{"v":2085.44,"d":"2,085.44"},{"v":1345.5100000000002,"d":"1,345.51"},739.93,{"v":14715.6,"d":"14,715.60"},{"v":8224.24,"d":"8,224.24"},{"v":639929.4000000001,"d":"639,929.40"}]
[null,12,"1905-12-08",{"v":639929.4000000001,"d":"639,929.40"},{"v":2085.44,"d":"2,085.44"},{"v":1347.06,"d":"1,347.06"},738.38,{"v":16062.66,"d":"16,062.66"},{"v":8962.619999999999,"d":"8,962.62"},{"v":638582.3400000001,"d":"638,582.34"}]
[null,13,"1905-12-22",{"v":638582.3400000001,"d":"638,582.34"},{"v":2085.44,"d":"2,085.44"},{"v":1348.6100000000001,"d":"1,348.61"},736.83,{"v":17411.27,"d":"17,411.27"},{"v":9699.449999999999,"d":"9,699.45"},{"v":637233.7300000001,"d":"637,233.73"}]
[null,14,"1906-01-05",{"v":637233.7300000001,"d":"637,233.73"},{"v":2085.44,"d":"2,085.44"},{"v":1350.17,"d":"1,350.17"},735.27,{"v":18761.440000000002,"d":"18,761.44"},{"v":10434.72,"d":"10,434.72"},{"v":635883.56,"d":"635,883.56"}]
[null,15,"1906-01-19",{"v":635883.56,"d":"635,883.56"},{"v":2085.44,"d":"2,085.44"},{"v":1351.73,"d":"1,351.73"},733.71,{"v":20113.170000000002,"d":"20,113.17"},{"v":11168.43,"d":"11,168.43"},{"v":634531.8300000001,"d":"634,531.83"}]
[null,16,"1906-02-02",{"v":634531.8300000001,"d":"634,531.83"},{"v":2085.44,"d":"2,085.44"},{"v":1353.29,"d":"1,353.29"},732.15,{"v":21466.460000000003,"d":"21,466.46"},{"v":11900.58,"d":"11,900.58"},{"v":633178.54,"d":"633,178.54"}]
[null,17,"1906-02-16",{"v":633178.54,"d":"633,178.54"},{"v":2085.44,"d":"2,085.44"},{"v":1354.85,"d":"1,354.85"},730.59,{"v":22821.31,"d":"22,821.31"},{"v":12631.17,"d":"12,631.17"},{"v":631823.6900000001,"d":"631,823.69"}]
[null,18,"1906-03-02",{"v":631823.6900000001,"d":"631,823.69"},{"v":2085.44,"d":"2,085.44"},{"v":1356.41,"d":"1,356.41"},729.03,{"v":24177.72,"d":"24,177.72"},{"v":13360.2,"d":"13,360.20"},{"v":630467.28,"d":"630,467.28"}]
[null,19,"1906-03-16",{"v":630467.28,"d":"630,467.28"},{"v":2085.44,"d":"2,085.44"},{"v":1357.98,"d":"1,357.98"},727.46,{"v":25535.7,"d":"25,535.70"},{"v":14087.66,"d":"14,087.66"},{"v":629109.3,"d":"629,109.30"}]
[null,20,"1906-03-30",{"v":629109.3,"d":"629,109.30"},{"v":2085.44,"d":"2,085.44"},{"v":1359.54,"d":"1,359.54"},{"v":725.9,"d":"725.90"},{"v":26895.24,"d":"26,895.24"},{"v":14813.56,"d":"14,813.56"},{"v":627749.76,"d":"627,749.76"}]
[null,21,"1906-04-13",{"v":627749.76,"d":"627,749.76"},{"v":2085.44,"d":"2,085.44"},{"v":1361.1100000000001,"d":"1,361.11"},724.33,{"v":28256.350000000002,"d":"28,256.35"},{"v":15537.89,"d":"15,537.89"},{"v":626388.65,"d":"626,388.65"}]
[null,22,"1906-04-27",{"v":626388.65,"d":"626,388.65"},{"v":2085.44,"d":"2,085.44"},{"v":1362.68,"d":"1,362.68"},722.76,{"v":29619.030000000002,"d":"29,619.03"},{"v":16260.65,"d":"16,260.65"},{"v":625025.97,"d":"625,025.97"}]
[null,23,"1906-05-11",{"v":625025.97,"d":"625,025.97"},{"v":2085.44,"d":"2,085.44"},{"v":1364.2600000000002,"d":"1,364.26"},721.18,{"v":30983.29,"d":"30,983.29"},{"v":16981.829999999998,"d":"16,981.83"},{"v":623661.71,"d":"623,661.71"}]
[null,24,"1906-05-25",{"v":623661.71,"d":"623,661.71"},{"v":2085.44,"d":"2,085.44"},{"v":1365.83,"d":"1,365.83"},719.61,{"v":32349.120000000003,"d":"32,349.12"},{"v":17701.44,"d":"17,701.44"},{"v":622295.88,"d":"622,295.88"}]
[null,25,"1906-06-08",{"v":622295.88,"d":"622,295.88"},{"v":2085.44,"d":"2,085.44"},{"v":1367.41,"d":"1,367.41"},718.03,{"v":33716.530000000006,"d":"33,716.53"},{"v":18419.469999999998,"d":"18,419.47"},{"v":620928.47,"d":"620,928.47"}]
[null,26,"1906-06-22",{"v":620928.47,"d":"620,928.47"},{"v":2085.44,"d":"2,085.44"},{"v":1368.98,"d":"1,368.98"},716.46,{"v":35085.51000000001,"d":"35,085.51"},{"v":19135.929999999997,"d":"19,135.93"},{"v":619559.49,"d":"619,559.49"}]
[]
[null,"Payments for Calendar Years after Year 1"]
[null,"Year","Beginning Balance","Payment","Principal ","Interest ","Ending Balance"]
[]
[null,2006,{"v":637233.7300000001,"d":"$637,233.73"},{"v":54221.44,"d":"$54,221.44"},{"v":35615.320000000065,"d":"$35,615.32"},{"v":18606.119999999937,"d":"$18,606.12"},{"v":601618.41,"d":"$601,618.41"}]
[null,2007,{"v":601618.41,"d":"601,618.41"},{"v":54221.44,"d":"54,221.44"},{"v":36699.46000000008,"d":"36,699.46"},{"v":17521.979999999923,"d":"17,521.98"},{"v":564918.95,"d":"564,918.95"}]
[null,2008,{"v":564918.95,"d":"564,918.95"},{"v":54221.44,"d":"54,221.44"},{"v":37816.46999999997,"d":"37,816.47"},{"v":16404.97000000003,"d":"16,404.97"},{"v":527102.48,"d":"527,102.48"}]
[null,2009,{"v":527102.48,"d":"527,102.48"},{"v":54221.44,"d":"54,221.44"},{"v":38967.47999999998,"d":"38,967.48"},{"v":15253.960000000021,"d":"15,253.96"},{"v":488135,"d":"488,135.00"}]
[null,2010,{"v":488135,"d":"488,135.00"},{"v":54221.44,"d":"54,221.44"},{"v":40153.52000000002,"d":"40,153.52"},{"v":14067.919999999984,"d":"14,067.92"},{"v":447981.48,"d":"447,981.48"}]
[null,2011,{"v":447981.48,"d":"447,981.48"},{"v":54221.44,"d":"54,221.44"},{"v":41375.659999999974,"d":"41,375.66"},{"v":12845.780000000028,"d":"12,845.78"},{"v":406605.82,"d":"406,605.82"}]
[null,2012,{"v":406605.82,"d":"406,605.82"},{"v":54221.44,"d":"54,221.44"},{"v":42635,"d":"42,635.00"},{"v":11586.440000000002,"d":"11,586.44"},{"v":363970.82,"d":"363,970.82"}]
[null,2013,{"v":363970.82,"d":"363,970.82"},{"v":54221.44,"d":"54,221.44"},{"v":43932.67999999999,"d":"43,932.68"},{"v":10288.76000000001,"d":"10,288.76"},{"v":320038.14,"d":"320,038.14"}]
[null,2014,{"v":320038.14,"d":"320,038.14"},{"v":54221.44,"d":"54,221.44"},{"v":45269.830000000016,"d":"45,269.83"},{"v":8951.609999999986,"d":"8,951.61"},{"v":274768.31,"d":"274,768.31"}]
[null,2015,{"v":274768.31,"d":"274,768.31"},{"v":54221.44,"d":"54,221.44"},{"v":46647.70999999999,"d":"46,647.71"},{"v":7573.7300000000105,"d":"7,573.73"},{"v":228120.6,"d":"228,120.60"}]
[null,2016,{"v":228120.6,"d":"228,120.60"},{"v":54221.44,"d":"54,221.44"},{"v":48067.5,"d":"48,067.50"},{"v":6153.940000000002,"d":"6,153.94"},{"v":180053.1,"d":"180,053.10"}]
[null,2017,{"v":180053.1,"d":"180,053.10"},{"v":54221.44,"d":"54,221.44"},{"v":49530.53,"d":"49,530.53"},{"v":4690.9100000000035,"d":"4,690.91"},{"v":130522.57,"d":"130,522.57"}]
[null,2018,{"v":130522.57,"d":"130,522.57"},{"v":54221.44,"d":"54,221.44"},{"v":51038.06000000001,"d":"51,038.06"},{"v":3183.37999999999,"d":"3,183.38"},{"v":79484.51,"d":"79,484.51"}]
[null,2019,{"v":79484.51,"d":"79,484.51"},{"v":54221.44,"d":"54,221.44"},{"v":52591.5,"d":"52,591.50"},{"v":1629.9400000000023,"d":"1,629.94"},{"v":26893.01,"d":"26,893.01"}]
[null,2020,{"v":26893.01,"d":"26,893.01"},{"v":27110.72,"d":"27,110.72"},{"v":26893.01,"d":"26,893.01"},{"v":217.71000000000276,"d":"217.71"},0]
[null,"","","","","",""]
[null,"","","","","",""]
[null,"","","","","",""]
[null,"","","","","",""]
[null,"","","","","",""]
[null,"","","","","",""]
[null,"","","","","",""]
[null,"","","","","",""]
[null,"","","","","",""]
[null,"","","","","",""]
[null,"","","","","",""]
[null,"","","","","",""]
[null,"","","","","",""]
[null,"","","","","",""]
[null,"","","","","",""]
{"$rows_empty":76}
[{"$nulls":29},"Do Not Delete "]
[]
[{"$nulls":28},"Year"]
[{"$nulls":28},{"v":1905,"d":"1905.00"}]
[]
[{"$nulls":28},2015,1]
[{"$nulls":28},2029,2]
[{"$nulls":28},2043,3]
[{"$nulls":28},2057,4]
[{"$nulls":28},2071,5]
[{"$nulls":28},2085,6]
[{"$nulls":28},2099,7]
[{"$nulls":28},2113,8]
[{"$nulls":28},2127,9]
[{"$nulls":28},2141,10]
[{"$nulls":28},2155,11]
[{"$nulls":28},2169,12]
[{"$nulls":28},2183,13]
[{"$nulls":28},0,14]
[{"$nulls":28},0,15]
[{"$nulls":28},0,16]
[{"$nulls":28},0,17]
[{"$nulls":28},0,18]
[{"$nulls":28},0,19]
[{"$nulls":28},0,20]
[{"$nulls":28},0,21]
[{"$nulls":28},0,22]
[{"$nulls":28},0,23]
[{"$nulls":28},0,24]
[{"$nulls":28},0,25]
[{"$nulls":28},0,26]
[{"$nulls":28},"1905-12-22"]
[]
[{"$nulls":28},"Periods in first year calendar year",null,13]
[{"$nulls":29},1,377,786210.88]
[{"$nulls":29},2,351,731989.4400000001]
[{"$nulls":29},3,325,677768]
[{"$nulls":29},4,299,623546.56]
[{"$nulls":29},5,273,569325.12]
[{"$nulls":29},6,247,515103.68]
[{"$nulls":29},7,221,460882.24]
[{"$nulls":29},8,195,406660.8]
[{"$nulls":29},9,169,352439.36]
[{"$nulls":29},10,143,298217.92]
[{"$nulls":29},11,117,243996.48]
[{"$nulls":29},12,91,189775.04]
[{"$nulls":29},13,65,135553.6]
[{"$nulls":29},14,39,81332.16]
[{"$nulls":29},15,13,27110.72]
[{"$nulls":29},16,0,0]
[{"$nulls":29},17,0,0]
[{"$nulls":29},18,0,0]
[{"$nulls":29},19,0,0]
[{"$nulls":29},20,0,0]
[{"$nulls":29},21,0,0]
[{"$nulls":29},22,0,0]
[{"$nulls":29},23,0,0]
[{"$nulls":29},24,0,0]
[{"$nulls":29},25,0,0]
[{"$nulls":29},26,0,0]
[{"$nulls":29},27,0,0]
[{"$nulls":29},28,0,0]
[{"$nulls":29},29,0,0]
[{"$nulls":29},30,0,0]
[{"$nulls":30},0]

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