{"text_format":"2","workbook":"xlsx","n_sheets":3,"sheets":["Sheet1","Sheet2","Sheet3"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"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"}

{"sheet":"Sheet1","index":0,"n_rows":85,"n_cols":16,"rows_kept":85,"cut":false,"hidden":false,"merged":[[0,2,0,5],[0,7,0,11],[4,0,4,2],[9,0,9,2],[13,0,13,2],[15,0,15,2],[17,1,17,2],[21,1,21,2],[28,0,28,2],[29,1,29,2],[37,1,37,2],[44,1,44,2],[52,1,52,2]]}
[null,null,"FAMILY BUDGET PLANNER",{"$nulls":4},"By: www.ExcelTemplateSource.com"]
[]
[null,null,"BALANCE",0,{"$f":"+D3+D8","v":1543.49},{"$f":"+E3+E8","v":3086.98},{"$f":"+F3+F8","v":4630.47},{"$f":"+G3+G8","v":6173.96},{"$f":"+H3+H8","v":7717.45},{"$f":"+I3+I8","v":9260.94},{"$f":"+J3+J8","v":10804.43},{"$f":"+K3+K8","v":12347.92},{"$f":"+L3+L8","v":13891.41},{"$f":"+M3+M8","v":15434.9},{"$f":"+N3+N8","v":16978.39}]
[]
["SUMMARY"]
[null,null,"Total Income",{"$f":"sum(D14)","v":10085.74},{"$f":"sum(E14)","v":10085.74},{"$f":"sum(F14)","v":10085.74},{"$f":"sum(G14)","v":10085.74},{"$f":"sum(H14)","v":10085.74},{"$f":"sum(I14)","v":10085.74},{"$f":"sum(J14)","v":10085.74},{"$f":"sum(K14)","v":10085.74},{"$f":"sum(L14)","v":10085.74},{"$f":"sum(M14)","v":10085.74},{"$f":"sum(N14)","v":10085.74},{"$f":"sum(O14)","v":10085.74},{"$f":"SUM(D6:O6)","v":121028.88}]
[null,null,"Total Expenditures",{"$f":"D59","v":8542.25},{"$f":"E59","v":8542.25},{"$f":"F59","v":8542.25},{"$f":"G59","v":8542.25},{"$f":"H59","v":8542.25},{"$f":"I59","v":8542.25},{"$f":"J59","v":8542.25},{"$f":"K59","v":8542.25},{"$f":"L59","v":8542.25},{"$f":"M59","v":8542.25},{"$f":"N59","v":8542.25},{"$f":"O59","v":8542.25},{"$f":"SUM(D7:O7)","v":102507}]
[null,null,"Income -  Expenditures",{"$f":"D6-D7","v":1543.49},{"$f":"E6-E7","v":1543.49},{"$f":"F6-F7","v":1543.49},{"$f":"G6-G7","v":1543.49},{"$f":"H6-H7","v":1543.49},{"$f":"I6-I7","v":1543.49},{"$f":"J6-J7","v":1543.49},{"$f":"K6-K7","v":1543.49},{"$f":"L6-L7","v":1543.49},{"$f":"M6-M7","v":1543.49},{"$f":"N6-N7","v":1543.49},{"$f":"O6-O7","v":1543.49},{"$f":"SUM(D8:O8)","v":18521.88}]
[null,null,null,"JAN","FEB","MAR","APR","MAY","JUN","JUL","AUG","SEP","OCT","NOV","DEC","TOTALS"]
["INCOME"]
[null,null,"Take-home pay (Hers)",{"$nulls":12},{"$f":"SUM(D11:O11)","v":0}]
[null,null,"Take-home pay (His)",{"$f":"4442.87*2","v":8885.74},{"$f":"4442.87*2","v":8885.74},{"$f":"4442.87*2","v":8885.74},{"$f":"4442.87*2","v":8885.74},{"$f":"4442.87*2","v":8885.74},{"$f":"4442.87*2","v":8885.74},{"$f":"4442.87*2","v":8885.74},{"$f":"4442.87*2","v":8885.74},{"$f":"4442.87*2","v":8885.74},{"$f":"4442.87*2","v":8885.74},{"$f":"4442.87*2","v":8885.74},{"$f":"4442.87*2","v":8885.74},{"$f":"SUM(D12:O12)","v":106628.88}]
[null,null,"Other Income",1200,1200,1200,1200,1200,1200,1200,1200,1200,1200,1200,1200,{"$f":"SUM(D13:O13)","v":14400}]
["TOTAL INCOME",null,null,{"$f":"SUM(D11:D13)","v":10085.74},{"$f":"SUM(E11:E13)","v":10085.74},{"$f":"SUM(F11:F13)","v":10085.74},{"$f":"SUM(G11:G13)","v":10085.74},{"$f":"SUM(H11:H13)","v":10085.74},{"$f":"SUM(I11:I13)","v":10085.74},{"$f":"SUM(J11:J13)","v":10085.74},{"$f":"SUM(K11:K13)","v":10085.74},{"$f":"SUM(L11:L13)","v":10085.74},{"$f":"SUM(M11:M13)","v":10085.74},{"$f":"SUM(N11:N13)","v":10085.74},{"$f":"SUM(O11:O13)","v":10085.74},{"$f":"SUM(D14:O14)","v":121028.88}]
[]
["EXPENDITURES"]
[null,null,"Mortgage",2600,2600,2600,2600,2600,2600,2600,2600,2600,2600,2600,2600,{"$f":"SUM(D17:O17)","v":31200}]
[null,"Insurance Premiums"]
[null,null,"Auto",65,65,65,65,65,65,65,65,65,65,65,65,{"$f":"SUM(D19:O19)","v":780}]
[null,null,"Life",45,45,45,45,45,45,45,45,45,45,45,45,{"$f":"sum(D20:O20)","v":540}]
[]
[null,"Misc Variable"]
[null,null,"Food",1600,1600,1600,1600,1600,1600,1600,1600,1600,1600,1600,1600,{"$f":"SUM(D23:O23)","v":19200}]
[null,null,"Gasoline",450,450,450,450,450,450,450,450,450,450,450,450,{"$f":"SUM(D24:O24)","v":5400}]
[null,null,"Car Service/Maint",75,75,75,75,75,75,75,75,75,75,75,75,{"$f":"SUM(D25:O25)","v":900}]
[null,null,"Home Running Expensis",{"$nulls":12},{"$f":"SUM(D26:O26)","v":0}]
[null,null,"Dinning Out",250,250,250,250,250,250,250,250,250,250,250,250,{"$f":"SUM(D27:O27)","v":3000}]
[null,null,"Medical",100,100,100,100,100,100,100,100,100,100,100,100,{"$f":"SUM(D28:O28)","v":1200}]
["Variable Expenditures"]
[null,"Fuel and utilities"]
[null,null,"Electric + Water",210,210,210,210,210,210,210,210,210,210,210,210,{"$f":"SUM(D31:O31)","v":2520}]
[null,null,"Internet",80,80,80,80,80,80,80,80,80,80,80,80,{"$f":"SUM(D32:O32)","v":960}]
[null,null,"Home Phone",3.75,3.75,3.75,3.75,3.75,3.75,3.75,3.75,3.75,3.75,3.75,3.75,{"$f":"SUM(D33:O33)","v":45}]
[null,null,"Trash Pickup",21,21,21,21,21,21,21,21,21,21,21,21,{"$f":"SUM(D34:O34)","v":252}]
[null,null,"Satellite/Cable",16,16,16,16,16,16,16,16,16,16,16,16,{"$f":"SUM(D35:O35)","v":192}]
[null,null,"Cell Phones",210,210,210,210,210,210,210,210,210,210,210,210,{"$f":"SUM(D36:O36)","v":2520}]
[null,null,"Propane",150,150,150,150,150,150,150,150,150,150,150,150,{"$f":"SUM(D37:O37)","v":1800}]
[null,"Investments"]
[null,null,"His Roth IRA/401K",75,75,75,75,75,75,75,75,75,75,75,75,{"$f":"SUM(D39:O39)","v":900}]
[null,null,"Her Roth IRA/401K",75,75,75,75,75,75,75,75,75,75,75,75,{"$f":"SUM(D40:O40)","v":900}]
[null,null,"Child 1 - 529 Account",75,75,75,75,75,75,75,75,75,75,75,75,{"$f":"SUM(D41:O41)","v":900}]
[null,null,"Child 2 - 529 Account",75,75,75,75,75,75,75,75,75,75,75,75,{"$f":"SUM(D42:O42)","v":900}]
[null,null,"Child 3 - 529 Account",75,75,75,75,75,75,75,75,75,75,75,75,{"$f":"SUM(D43:O43)","v":900}]
[{"$nulls":15},{"$f":"SUM(D44:O44)","v":0}]
[null,"Pocket Money"]
[null,null,"Matt Lunches",130,130,130,130,130,130,130,130,130,130,130,130,{"$f":"SUM(D46:O46)","v":1560}]
[null,null,"Jocelyn Lunches",65,65,65,65,65,65,65,65,65,65,65,65,{"$f":"SUM(D47:O47)","v":780}]
[null,null,"Matt Spending",300,300,300,300,300,300,300,300,300,300,300,300,{"$f":"SUM(D48:O48)","v":3600}]
[null,null,"Babysitting",120,120,120,120,120,120,120,120,120,120,120,120,{"$f":"SUM(D49:O49)","v":1440}]
[{"$nulls":15},{"$f":"SUM(D50:O50)","v":0}]
[null,null,"Hers",300,300,300,300,300,300,300,300,300,300,300,300,{"$f":"SUM(D51:O51)","v":3600}]
[null,null,"Child Allowance",{"$nulls":12},{"$f":"SUM(D52:O52)","v":0}]
[null,"Misc Expensis"]
[null,null,"Rental Property Payment",1200,1200,1200,1200,1200,1200,1200,1200,1200,1200,1200,1200,{"$f":"SUM(D54:O54)","v":14400}]
[null,null,"Rental Prop Warranty",40,40,40,40,40,40,40,40,40,40,40,40,{"$f":"SUM(D55:O55)","v":480}]
[null,null,"Rental Prop Homeowners Assoc",36.5,36.5,36.5,36.5,36.5,36.5,36.5,36.5,36.5,36.5,36.5,36.5,{"$f":"SUM(D56:O56)","v":438}]
[null,null,"Other Expensis",100,100,100,100,100,100,100,100,100,100,100,100,{"$f":"SUM(D57:O57)","v":1200}]
[{"$nulls":15},{"$f":"SUM(D58:O58)","v":0}]
["TOTAL EXPENDITURES",null,null,{"$f":"SUM(D17:D58)","v":8542.25},{"$f":"SUM(E17:E58)","v":8542.25},{"$f":"SUM(F17:F58)","v":8542.25},{"$f":"SUM(G17:G58)","v":8542.25},{"$f":"SUM(H17:H58)","v":8542.25},{"$f":"SUM(I17:I58)","v":8542.25},{"$f":"SUM(J17:J58)","v":8542.25},{"$f":"SUM(K17:K58)","v":8542.25},{"$f":"SUM(L17:L58)","v":8542.25},{"$f":"SUM(M17:M58)","v":8542.25},{"$f":"SUM(N17:N58)","v":8542.25},{"$f":"SUM(O17:O58)","v":8542.25},{"$f":"SUM(D59:O59)","v":102507}]
{"$rows_empty":17}
[null,null," "]
[null,null," "]
[null,null," "]
[]
[]
[null,null," "]
[]
[null,null," "]
[null,null," "]

{"sheet":"Sheet2","index":1,"n_rows":50,"n_cols":16,"rows_kept":50,"cut":false,"hidden":false,"merged":[]}
[null,"Rental Property Budget Planner",{"$nulls":5},"By: www.ExcelTemplateSource.com"]
[]
["BALANCE",null,null,0,{"$f":"+D3+D8","v":231.5},{"$f":"+E3+E8","v":464.33},{"$f":"+F3+F8","v":698.49},{"$f":"+G3+G8","v":933.98},{"$f":"+H3+H8","v":1170.8},{"$f":"+I3+I8","v":1408.95},{"$f":"+J3+J8","v":1648.43},{"$f":"+K3+K8","v":1889.24},{"$f":"+L3+L8","v":2131.38},{"$f":"+M3+M8","v":2374.85},{"$f":"+N3+N8","v":2619.65}]
[]
["SUMMARY"]
[null,null,"Total Income",{"$f":"D12","v":1200},{"$f":"E12","v":1200},{"$f":"F12","v":1200},{"$f":"G12","v":1200},{"$f":"H12","v":1200},{"$f":"I12","v":1200},{"$f":"J12","v":1200},{"$f":"K12","v":1200},{"$f":"L12","v":1200},{"$f":"M12","v":1200},{"$f":"N12","v":1200},{"$f":"O12","v":1200},{"$f":"SUM(D6:O6)","v":14400}]
[null,null,"Total Expenditures",{"$f":"D24","v":968.5},{"$f":"E24","v":967.17},{"$f":"F24","v":965.84},{"$f":"G24","v":964.51},{"$f":"H24","v":963.18},{"$f":"I24","v":961.85},{"$f":"J24","v":960.52},{"$f":"K24","v":959.19},{"$f":"L24","v":957.86},{"$f":"M24","v":956.53},{"$f":"N24","v":955.2},{"$f":"O24","v":953.87},{"$f":"SUM(D7:O7)","v":11534.22}]
[null,null,"Income -  Expenditures",{"$f":"D6-D7","v":231.5},{"$f":"E6-E7","v":232.83},{"$f":"F6-F7","v":234.16},{"$f":"G6-G7","v":235.49},{"$f":"H6-H7","v":236.82},{"$f":"I6-I7","v":238.15},{"$f":"J6-J7","v":239.48},{"$f":"K6-K7","v":240.81},{"$f":"L6-L7","v":242.14},{"$f":"M6-M7","v":243.47},{"$f":"N6-N7","v":244.8},{"$f":"O6-O7","v":246.13},{"$f":"SUM(D8:O8)","v":2865.78}]
[null,null,null,"JAN","FEB","MAR","APR","MAY","JUN","JUL","AUG","SEP","OCT","NOV","DEC","TOTALS"]
["INCOME"]
[null,null,"Rental Income",1200,1200,1200,1200,1200,1200,1200,1200,1200,1200,1200,1200,{"$f":"SUM(D11:O11)","v":14400}]
["TOTAL INCOME",null,null,{"$f":"SUM(D11:D11)","v":1200},{"$f":"SUM(E11:E11)","v":1200},{"$f":"SUM(F11:F11)","v":1200},{"$f":"SUM(G11:G11)","v":1200},{"$f":"SUM(H11:H11)","v":1200},{"$f":"SUM(I11:I11)","v":1200},{"$f":"SUM(J11:J11)","v":1200},{"$f":"SUM(K11:K11)","v":1200},{"$f":"SUM(L11:L11)","v":1200},{"$f":"SUM(M11:M11)","v":1200},{"$f":"SUM(N11:N11)","v":1200},{"$f":"SUM(O11:O11)","v":1200},{"$f":"SUM(D12:O12)","v":14400}]
[]
["EXPENDITURES"]
[null,"Expendetures"]
[null,null,"Home Owners Insurance",67,67,67,67,67,67,67,67,67,67,67,67,{"$f":"SUM(D16:O16)","v":804}]
[null,null,"AHS",37.5,37.5,37.5,37.5,37.5,37.5,37.5,37.5,37.5,37.5,37.5,37.5,{"$f":"SUM(D17:O17)","v":450}]
[null,null,"Home Owners Assoc",31,31,31,31,31,31,31,31,31,31,31,31,{"$f":"SUM(D18:O18)","v":372}]
[null,null,"Repairs",150,150,150,150,150,150,150,150,150,150,150,150,{"$f":"SUM(D19:O19)","v":1800}]
[null,null,"Upgrades/Refirbish",50,50,50,50,50,50,50,50,50,50,50,50,{"$f":"SUM(D20:O20)","v":600}]
[null,null,"Property Taxes",208,208,208,208,208,208,208,208,208,208,208,208,{"$f":"SUM(D21:O21)","v":2496}]
[null,null,"Interest",425,423.67,422.34,421.01,419.68,418.35,417.02,415.69,414.36,413.03,411.7,410.37]
[null,null,"Miscellaneous",{"$nulls":12},{"$f":"SUM(D23:O23)","v":0}]
["TOTAL EXPENDITURES",null,null,{"$f":"SUM(D15:D23)","v":968.5},{"$f":"SUM(E15:E23)","v":967.17},{"$f":"SUM(F15:F23)","v":965.84},{"$f":"SUM(G15:G23)","v":964.51},{"$f":"SUM(H15:H23)","v":963.18},{"$f":"SUM(I15:I23)","v":961.85},{"$f":"SUM(J15:J23)","v":960.52},{"$f":"SUM(K15:K23)","v":959.19},{"$f":"SUM(L15:L23)","v":957.86},{"$f":"SUM(M15:M23)","v":956.53},{"$f":"SUM(N15:N23)","v":955.2},{"$f":"SUM(O15:O23)","v":953.87},{"$f":"SUM(D24:O24)","v":11534.22}]
{"$rows_empty":17}
[null,null," "]
[null,null," "]
[null,null," "]
[]
[]
[null,null," "]
[]
[null,null," "]
[null,null," "]

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