{"text_format":"2","workbook":"xlsx","n_sheets":1,"sheets":["Family Monthly Budget - Table 1"],"not_rendered":{"charts":0,"images":1,"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":"Family Monthly Budget - Table 1","index":0,"n_rows":99,"n_cols":10,"rows_kept":99,"cut":false,"hidden":false,"merged":[[7,2,8,2],[20,7,21,8],[7,1,8,1],[0,0,0,8],[3,5,3,6],[1,0,1,8],[17,7,19,8],[32,6,33,6],[32,7,33,7],[7,3,8,3],[9,5,10,6],[32,8,33,8],[44,5,44,7]]}
[]
[]
[]
[{"$nulls":5},"Projected Monthly Income"]
[{"$nulls":5},"Income 1 (person #1)",0]
[{"$nulls":5},"Income 2 (person #2)",0]
["Monthly CashFlow Tracker",{"$nulls":4},"Income 3",0]
[null,"Projected Cost","Actual Cost","Difference",null,"Extra income",0]
["Housing",{"$nulls":4},"Total monthly income",{"$f":"SUM(G5:G8)","v":0},{"$f":"G9*12","v":0}]
["Mortgage/Rent",0,0,{"$f":"B10-C10","v":0},null,"Actual Monthly Income"]
["Second mortgage or rent",0,0,{"$f":"B11-C11","v":0}]
["Phone",0,0,{"$f":"B12-C12","v":0},null,"Income 1",0]
["cell phone",0,0,{"$f":"B13-C13","v":0},null,"Income 2",0]
["Electricity",0,0,{"$f":"B14-C14","v":0},null,"Income 3",0]
["Gas",0,0,{"$f":"B15-C15","v":0},null,"Extra income",0]
["Water and sewer",0,0,{"$f":"B16-C16","v":0},null,"Total monthly income",{"$f":"SUM(G12:G15)","v":0},{"$f":"H15*12","v":0}]
["Waste removal",0,0,{"$f":"B17-C17","v":0}]
["Maintenance or repairs",0,0,{"$f":"B18-C18","v":0},null,"Projected balance\n(Projected income minus expenses)",{"$f":"G9-B5","v":0}]
["Mandatory HOA",0,0,{"$f":"B19-C19","v":0}]
["Supplies",0,0,{"$f":"B20-C20","v":0}]
["Taxes",0,0,{"$f":"B21-C21","v":0},null,"Actual balance\n(Actual income minus expenses)",{"$f":"G16-C5","v":0}]
["Fire/Haz Insurance ",0,0,{"$f":"B22-C22","v":0}]
["Subtotals",{"$f":"SUM(B10:B22)","v":0},{"$f":"SUM(C10:C22)","v":0},{"$f":"SUM(D10:D22)","v":0},null,"Difference (Actual minus projected)",{"$f":"G21-G18","v":0}]
[null,null,{"$f":"C23*12","v":0}]
["Transportation"]
["Vehicle 1 payment",0,0,{"$f":"B26-C26","v":0}]
["Vehicle 2 payment",0,0,{"$f":"B27-C27","v":0}]
["Bus/taxi fare",0,0,{"$f":"B28-C28","v":0}]
["Auto Insurance (Car #1)",0,0,{"$f":"B29-C29","v":0}]
["Licensing/Registration/SMOG",0,0,{"$f":"B30-C30","v":0}]
["Fuel (Car #1)",0,0,{"$f":"B31-C31","v":0}]
["Fuel (Car #2)",0,0,{"$f":"B32-C32","v":0}]
["Maintenance & Repairs (brakes & Oil changes)",0,0,{"$f":"B33-C33","v":0},null,null,"Projected Cost","Actual Cost","Difference"]
["Car Wash",0,0,{"$f":"B34-C34","v":0},null,"Entertainment"]
["Subtotals",{"$f":"SUM(B26:B34)","v":0},{"$f":"SUM(C26:C34)","v":0},{"$f":"SUM(D26:D34)","v":0},null,"Video/DVD",0,0,{"$f":"G35-H35","v":0}]
[null,null,{"$f":"C35*12","v":0},null,null,"CDs",0,0,{"$f":"G36-H36","v":0}]
["Insurance",{"$nulls":4},"Movies",0,0,{"$f":"G37-H37","v":0}]
["Dental ",0,0,{"$f":"B38-C38","v":0},null,"Camp",0,0,{"$f":"G38-H38","v":0}]
["Life ",0,0,{"$f":"B39-C39","v":0},null,"Internet",0,0,{"$f":"G39-H39","v":0}]
["Health ()",0,0,{"$f":"B40-C40","v":0},null,"Live theater",0,0,{"$f":"G40-H40","v":0}]
["Health ()",0,0,{"$f":"B41-C41","v":0},null,"Other-CABLE/direct TV",0,0,{"$f":"G41-H41","v":0}]
["Subtotals",{"$f":"SUM(B38:B41)","v":0},{"$f":"SUM(C38:C41)","v":0},{"$f":"SUM(D38:D41)","v":0},null,"Subtotals",{"$f":"SUM(G35:G41)","v":0},{"$f":"SUM(H35:H41)","v":0},{"$f":"SUM(I35:I41)","v":0}]
["Annual Total",null,{"$f":"C42*12","v":0}]
[]
["Food",{"$nulls":4},"Loans (auto, student, computer, jewelry, furniture, etc.)",null,null,null,"Balance Owed"]
["Groceries",0,0,{"$f":"B46-C46","v":0},null,"loan #1 - Student",0,0,{"$f":"G46-H46","v":0},0]
["Dining out/Meals at Work",0,0,{"$f":"B47-C47","v":0},null,"loan #2 -",0,0,{"$f":"G47-H47","v":0},0]
["Other",0,0,{"$f":"B48-C48","v":0},null,"loan #3 - ",0,0,{"$f":"G48-H48","v":0},0]
["Subtotals",{"$f":"SUM(B46:B48)","v":0},{"$f":"SUM(C46:C48)","v":0},{"$f":"SUM(D46:D48)","v":0},null,"Credit card ()",0,0,{"$f":"G49-H49","v":0},0]
[null,null,{"$f":"C49*12","v":0},null,null,"Credit card",0,0,0,0]
[{"$nulls":5},"Credit card",0,0,0,0]
[{"$nulls":5},"Credit card",0,0,0,0]
[{"$nulls":5},"Credit card",0,0,{"$f":"G53-H53","v":0},0]
["Miscellaneous",{"$nulls":4},"Other",0,0,{"$f":"G54-H54","v":0},0]
["Medical Co-pays/out-of-pocket (DTMT)",0,0,{"$f":"B55-C55","v":0},null,"Subtotals",{"$f":"SUM(G46:G54)","v":0},{"$f":"SUM(H46:H54)","v":0},{"$f":"SUM(I46:I54)","v":0},{"$f":"SUM(J46:J54)","v":0}]
["Medications/RX",0,0,{"$f":"B56-C56","v":0}]
["Child Support that you pay",0,0,{"$f":"B57-C57","v":0},null,"Taxes"]
["Lunch Money ",0,0,{"$f":"B58-C58","v":0},null,"Federal",0,0,{"$f":"G58-H58","v":0}]
["School Tuition / Supplies",0,0,{"$f":"B59-C59","v":0},null,"State",0,0,{"$f":"G59-H59","v":0}]
["Child Care ",0,0,{"$f":"B60-C60","v":0},null,"Tax Installment ()",0,0,{"$f":"G60-H60","v":0}]
["Bank Fees/OD/NSF charges",0,0,{"$f":"B61-C61","v":0},null,"Delinquent Property Tax-36 month repayment plan",0,0,{"$f":"G61-H61","v":0}]
["Internet",0,0,{"$f":"B62-C62","v":0},null,"Subtotals",{"$f":"SUM(G58:G61)","v":0},{"$f":"SUM(H58:H61)","v":0},{"$f":"SUM(I58:I61)","v":0}]
["Booth Rental",0,0,{"$f":"B63-C63","v":0}]
["Subtotals",{"$f":"SUM(B55:B63)","v":0},{"$f":"SUM(C55:C63)","v":0},{"$f":"SUM(D55:D63)","v":0},null,"Savings or Investments"]
[null,null,{"$f":"C64*12","v":0},null,null,"Reserves account -Goal: 6 x monthly exp",0,0,{"$f":"G65-H65","v":0}]
["Pets",{"$nulls":4},"Emergency/Surprise/\"Oops!\" account",0,0,{"$f":"G66-H66","v":0}]
["Food",0,0,{"$f":"B67-C67","v":0},null,"House",0,0,{"$f":"G67-H67","v":0}]
["Medical",0,0,{"$f":"B68-C68","v":0},null,"College/Other",0,0,{"$f":"G68-H68","v":0}]
["Grooming",0,0,{"$f":"B69-C69","v":0},null,"Subtotals",{"$f":"SUM(G65:G68)","v":0},{"$f":"SUM(H65:H68)","v":0},{"$f":"SUM(I65:I68)","v":0}]
["Toys",0,0,{"$f":"B70-C70","v":0}]
["Other",0,0,{"$f":"B71-C71","v":0},null,"Gifts and Donations"]
["Subtotals",{"$f":"SUM(B67:B71)","v":0},{"$f":"SUM(C67:C71)","v":0},{"$f":"SUM(D67:D71)","v":0},null,"Tithing ()",0,0,{"$f":"G72-H72","v":0}]
[null,null,{"$f":"C72*12","v":0},null,null,"Tithing ()",0,0,{"$f":"G73-H73","v":0}]
["Personal Care",{"$nulls":4},"Gifts (birthdays, holidays)",0,0,{"$f":"G74-H74","v":0}]
["Toiletries",0,0,{"$f":"B75-C75","v":0},null,"Subtotals",{"$f":"SUM(G72:G74)","v":0},{"$f":"SUM(H72:H74)","v":0},{"$f":"SUM(I72:I74)","v":0}]
["Hair/nails/Barber/Cosmetics",0,0,{"$f":"B76-C76","v":0}]
["Clothing/Jewelry",0,0,{"$f":"B77-C77","v":0},null,"Legal"]
["Dry cleaning/Laundry",0,0,{"$f":"B78-C78","v":0},null,"Attorney",0,0,{"$f":"G78-H78","v":0}]
["Health club",0,0,{"$f":"B79-C79","v":0},null,"Alimony",0,0,{"$f":"G79-H79","v":0}]
["Cigarettes/Alcohol",0,0,{"$f":"B80-C80","v":0},null,"Payments on lien or judgment",0,0,{"$f":"G80-H80","v":0}]
["Other",0,0,{"$f":"B81-C81","v":0},null,"Other",null,null,{"$f":"G81-H81","v":0}]
["Subtotals",{"$f":"SUM(B75:B81)","v":0},{"$f":"SUM(C75:C81)","v":0},{"$f":"SUM(D75:D81)","v":0},null,"Subtotals",{"$f":"SUM(G78:G81)","v":0},{"$f":"SUM(H78:H81)","v":0},{"$f":"SUM(I78:I81)","v":0}]
[]
["Mortgage Information","Proposed","Actual","Difference",null,"Assets/Savings","Projected","Actual","Difference"]
["1st mortgage balance",0,0,{"$f":"B85-C85","v":0},null,"(ACCOUNT NAME)",0,0,{"$f":"G85-H85","v":0}]
["2nd mortgage balance",0,0,{"$f":"B86-C86","v":0},null,"(ACCOUNT NAME)",0,0,{"$f":"G86-H86","v":0}]
["Other liens",0,0,{"$f":"B87-C87","v":0},null,"(ACCOUNT NAME)",0,0,{"$f":"G87-H87","v":0}]
["Other liens",0,0,{"$f":"B88-C88","v":0},null,"(ACCOUNT NAME)",0,0,{"$f":"G88-H88","v":0}]
["Other liens",0,0,{"$f":"B89-C89","v":0},null,"(ACCOUNT NAME)",0,0,{"$f":"G89-H89","v":0}]
["Subtotals",{"$f":"SUM(B85:B89)","v":0},{"$f":"SUM(C85:C89)","v":0},{"$f":"SUM(D85:D89)","v":0},null,"(ACCOUNT NAME)",0,0,{"$f":"G90-H90","v":0}]
[null,null,{"$f":"C90*12","v":0},null,null,"Subtotals",{"$f":"SUM(G86:G90)","v":0},{"$f":"SUM(H86:H90)","v":0},{"$f":"SUM(I86:I90)","v":0}]
[]
["Monthly Expenses",{"$f":"C23+C35+C49+C64+C72+C82+C90+H42+H55+H62","v":0},null,null,null,"Balance in 401K ()",0,0,{"$f":"G93-H93","v":0}]
["Annual Expenses",{"$f":"C24+C36+C43+C50+C65+C73+C83+C91","v":0},null,null,null,"IRA ()",0,0,{"$f":"G94-H94","v":0}]
[{"$nulls":5},"Subtotals",{"$f":"SUM(G90:G94)","v":0},{"$f":"SUM(H90:H94)","v":0},{"$f":"G95-H95","v":0}]
["Total Monthly Income",{"$f":"G9","v":0}]
["Total Annual Income",{"$f":"H9","v":0},null,null,null,"Total Checking/Savings",{"$f":"H69+H91","v":0}]
[{"$nulls":5},"Total 401K",{"$f":"H95","v":0}]
["Total Monthly Gap/Surplus",{"$f":"B96-B93","v":0},null,null,null,"Total Retirement Investments",{"$f":"H93","v":0}]