{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Monthly Inputs","Budget Comparison","Fixed Vs Variable Expenses"],"not_rendered":{"charts":2,"images":1,"macros":0,"external_links":0,"defined_names":3,"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"}

{"sheet":"Monthly Inputs","index":0,"n_rows":43,"n_cols":7,"rows_kept":43,"cut":false,"hidden":false,"merged":[[1,0,1,7],[5,1,5,2],[7,1,7,2],[5,5,5,6],[7,5,7,6],[3,1,3,2],[5,3,5,4],[7,3,7,4],[9,0,9,1],[10,0,10,1],[11,0,11,1],[12,0,12,1],[13,0,13,1],[9,4,9,5],[10,4,10,5],[11,4,11,5],[12,4,12,5],[13,4,13,5],[20,6,20,7],[10,6,10,7],[11,6,11,7],[12,6,12,7],[13,6,13,7],[19,0,19,1],[18,0,18,1],[16,0,16,1],[14,4,14,5],[14,6,14,7],[17,4,17,5],[18,4,18,5],[18,6,18,7],[17,6,17,7],[16,4,16,5],[19,6,19,7],[19,4,19,5],[15,0,15,1],[14,0,14,1],[22,4,22,5],[21,4,21,5],[20,4,20,5],[21,0,21,1],[20,0,20,1],[23,6,23,7],[22,6,22,7],[21,6,21,7],[32,0,32,1],[31,0,31,1],[30,0,30,1],[29,0,29,1],[32,6,32,7],[25,4,25,5],[25,6,25,7],[26,0,26,1],[27,0,27,1],[28,0,28,1],[31,6,31,7],[22,0,22,1],[23,0,23,1],[24,6,24,7],[24,0,24,1],[29,6,29,7],[27,4,27,5],[34,4,34,5],[30,4,30,5],[29,4,29,5],[32,4,32,5],[31,4,31,5],[30,6,30,7],[33,6,33,7],[33,0,33,1],[24,4,24,5],[33,4,33,5],[23,4,23,5],[40,0,40,1],[41,0,41,1],[42,0,42,1],[40,4,40,5],[38,4,38,5],[35,4,35,5],[39,4,39,5],[39,6,39,7],[40,6,40,7],[41,4,41,5],[41,6,41,7],[0,0,0,7],[38,0,38,1],[37,0,37,1],[36,0,36,1],[35,0,35,1],[34,0,34,1],[28,4,28,5],[28,6,28,7],[34,6,34,7],[35,6,35,7],[36,6,36,7],[36,4,36,5]]}
["Step 1: On this sheet fill out the date and any applicable names. After, fill out any applicable cells based off of sources of income and where you spend that money each month."]
["Building A Budget That Works For You"]
[]
["Date:"]
[]
["First Name:",null,null,"Last Name:"]
[]
["First Name:",null,null,"Last Name:"]
[]
["Monthly Income",null,null,null,"Monthly Savings"]
[{"$f":"IF(B6<>\"\",+B6&\"'s Income\",\"Enter First Name Above\")","v":"Enter First Name Above"},null,null,null,"Deposition to Bank Account"]
[{"$f":"IF(B8<>\"\",+B8&\"'s Income\",\"Enter First Name Above\")","v":"Enter First Name Above"},null,null,null,"Deposition to Investments"]
["Rental Property Income",null,null,null,"Rainy Day Fund"]
["Government Benefits",null,null,null,"Other"]
["Spousal/Child Support",null,null,null,"Total Monthly Saving",null,{"$f":"IF(SUM(G11:H14)<>0,SUM(G11:H14),0)","v":0}]
["Other"]
["Total Monthly Income",null,{"$f":"IF(SUM(C11:C16)<>0,SUM(C11:C16),0)","v":0},null,"Monthly Transportation"]
[null,null,null,null,"Car Insurance"]
["Monthly Housing",null,null,null,"Car Payments"]
["Property Tax",null,null,null,"Registration/Licence Renewal"]
["Mortgage/Rent/Condo Fees",null,null,null,"Gas/Travel"]
["Home Insurance",null,null,null,"Vehicle Maintenance"]
["Utilities",null,null,null,"Public Transportation"]
["Reno/Maintenance",null,null,null,"Taxi/Uber"]
["Total Housing Costs",null,{"$f":"IF(SUM(C20:C24)<>0,SUM(C20:C24),0)","v":0},null,"Parking"]
[null,null,null,null,"Total Transportation Costs",null,{"$f":"IF(SUM(G18:H25)<>0,SUM(G18:H25),0)","v":0}]
["Monthly Life Expenses"]
["Phone Bills",null,null,null,"Monthly Leisure Costs"]
["Cable Bill",null,null,null,"Allowances"]
["Internet",null,null,null,"Entertainment"]
["Childcare",null,null,null,"Restaurant"]
["Life Insurance",null,null,null,"Clothing"]
["Medical/Dental",null,null,null,"Gifts/Charity"]
["Groceries/Personal Care",null,null,null,"Hobbies"]
["Pets",null,null,null,"Clubs/Subscriptions"]
["Bank/Financial Fees",null,null,null,"Vacation"]
["Sports Teams",null,null,null,"Total Leisure Costs",null,{"$f":"IF(SUM(G29:H36)<>0,SUM(G29:H36),0)","v":0}]
["Other"]
["Total Life Expenses",null,{"$f":"IF(SUM(C28:C38)<>0,SUM(C28:C38),0)","v":0},null,"Monthly Debt Costs"]
[null,null,null,null,"Taxes"]
["Total Income",null,{"$f":"IF(C17<>0,C17,\"\")","v":""},null,"Debt Repayment"]
["Total Expenses",null,{"$f":"IF(OR(C17<>0,C25<>0,C39<>0,G15<>0,G26<>0,G37<>0,G42<>0),(C25+C39+G15+G26+G37+G42),\"\")","v":""},null,"Total Debt Costs",null,{"$f":"IF(SUM(G40:H41)<>0,SUM(G40:H41),0)","v":0}]
["Remaining Funds",null,{"$f":"IF(OR(C17<>0,C25<>0,C39<>0,G15<>0,G26<>0,G37<>0,G42<>0),C17-(C25+C39+G15+G26+G37+G42),0)","v":0}]

{"sheet":"Budget Comparison","index":1,"n_rows":34,"n_cols":6,"rows_kept":34,"cut":false,"hidden":false,"merged":[[23,5,23,7],[24,5,24,7],[23,1,23,2],[24,1,24,2],[19,3,19,4],[20,3,20,4],[21,3,21,4],[22,3,22,4],[23,3,23,4],[24,3,24,4],[20,1,20,2],[21,1,21,2],[22,1,22,2],[19,5,19,7],[20,5,20,7],[21,5,21,7],[22,5,22,7],[12,5,12,7],[13,5,13,7],[14,5,14,7],[17,1,18,7],[19,1,19,2],[12,1,12,2],[13,1,13,2],[14,1,14,2],[12,3,12,4],[13,3,13,4],[14,3,14,4],[1,1,4,7],[7,1,8,7],[9,1,9,2],[10,1,10,2],[11,1,11,2],[9,5,9,7],[10,5,10,7],[11,5,11,7],[9,3,9,4],[10,3,10,4],[11,3,11,4]]}
[]
[null,"Step 2: This sheet allows you to see where your spending habits should be, where they currenty are, and how far out of line they are. If a value is red that means that you are overspending by that amount in that category. If it is green then you are within the target range and could even stand to allocate more funds to that category. *These numbers are only a guideline based off of those filling out values in all categories. If you don't have a mortgage, or if you are still living at home results will vary*"]
[]
[]
[]
[]
[]
[null,"Where Your Monthly Income Should Be Allocated"]
[]
[null,"Housing",null,0.35,null,{"$f":"IF('Monthly Inputs'!$C$42<>\"\",'Monthly Inputs'!$C$42*0.35,\"\")","v":""}]
[null,"Saving",null,0.1,null,{"$f":"IF('Monthly Inputs'!$C$42<>\"\",'Monthly Inputs'!$C$42*0.1,\"\")","v":""}]
[null,"Transportation",null,0.15,null,{"$f":"IF('Monthly Inputs'!$C$42<>\"\",'Monthly Inputs'!$C$42*0.15,\"\")","v":""}]
[null,"Leisure/Life",null,0.25,null,{"$f":"IF('Monthly Inputs'!$C$42<>\"\",'Monthly Inputs'!$C$42*0.25,\"\")","v":""}]
[null,"Debt",null,0.15,null,{"$f":"IF('Monthly Inputs'!$C$42<>\"\",'Monthly Inputs'!$C$42*0.15,\"\")","v":""}]
[null,"Total Expenses",null,1,null,{"$f":"IF('Monthly Inputs'!C42<>\"\",'Monthly Inputs'!C42,\"\")","v":""}]
[]
[]
[null,"Where Your Monthly Income Is Currently Allocated"]
[]
[null,"Housing",null,{"$f":"IF(AND('Monthly Inputs'!C25<>0,'Monthly Inputs'!C42<>0),'Monthly Inputs'!C25/'Monthly Inputs'!C42,\"\")","v":""},null,{"$f":"IF('Monthly Inputs'!C25<>0,'Monthly Inputs'!C25,\"\")","v":""}]
[null,"Saving",null,{"$f":"IF(AND('Monthly Inputs'!C42<>0,'Monthly Inputs'!G15<>0),'Monthly Inputs'!G15/'Monthly Inputs'!C42,\"\")","v":""},null,{"$f":"IF('Monthly Inputs'!G15<>0,'Monthly Inputs'!G15,\"\")","v":""}]
[null,"Transportation",null,{"$f":"IF(AND('Monthly Inputs'!C42<>0,'Monthly Inputs'!G26<>0),'Monthly Inputs'!G26/'Monthly Inputs'!C42,\"\")","v":""},null,{"$f":"IF('Monthly Inputs'!G26<>0,'Monthly Inputs'!G26,\"\")","v":""}]
[null,"Leisure/Life",null,{"$f":"IF(AND('Monthly Inputs'!G37<>0,'Monthly Inputs'!C39<>0,'Monthly Inputs'!C42<>\"\"),('Monthly Inputs'!G37+'Monthly Inputs'!C39)/'Monthly Inputs'!C42,\"\")","v":""},null,{"$f":"IF(AND('Monthly Inputs'!C39<>0,'Monthly Inputs'!G37<>0),'Monthly Inputs'!C39+'Monthly Inputs'!G37,\"\")","v":""}]
[null,"Debt",null,{"$f":"IF(AND('Monthly Inputs'!G42<>0,'Monthly Inputs'!C42<>0),'Monthly Inputs'!G42/'Monthly Inputs'!C42,\"\")","v":""},null,{"$f":"IF('Monthly Inputs'!G42<>0,'Monthly Inputs'!G42,\"\")","v":""}]
[null,"Total Expenses",null,{"$f":"IF(SUM(D20:D24)<>0,SUM(D20:D24),\"\")","v":""},null,{"$f":"IF(SUM(F20:F24)<>0,SUM(F20:F24),\"\")","v":""}]
[]
[]
[]
[]
[null,null,null,"Housing",{"$f":"IF(D20<>\"\",D20,\"\")","v":""}]
[null,null,null,"Saving",{"$f":"IF(D21<>\"\",D21,\"\")","v":""}]
[null,null,null,"Transportation",{"$f":"IF(D22<>\"\",D22,\"\")","v":""}]
[null,null,null,"Leisure/Life",{"$f":"IF(D23<>\"\",D23,\"\")","v":""}]
[null,null,null,"Debt",{"$f":"IF(D24<>\"\",D24,\"\")","v":""}]

{"sheet":"Fixed Vs Variable Expenses","index":2,"n_rows":51,"n_cols":7,"rows_kept":51,"cut":false,"hidden":false,"merged":[[7,1,7,2],[8,1,8,2],[9,1,9,2],[10,1,10,2],[17,1,17,2],[18,1,18,2],[19,1,19,2],[11,1,11,2],[12,1,12,2],[13,1,13,2],[14,1,14,2],[15,1,15,2],[16,1,16,2],[20,1,20,2],[23,1,23,2],[26,1,26,2],[27,1,27,2],[28,1,28,2],[21,1,21,2],[22,1,22,2],[37,1,37,2],[29,1,29,2],[30,1,30,2],[31,1,31,2],[32,1,32,2],[33,1,33,2],[34,1,34,2],[50,1,50,2],[1,1,5,7],[47,1,47,2],[48,1,48,2],[49,1,49,2],[44,1,44,2],[45,1,45,2],[46,1,46,2],[41,1,41,2],[42,1,42,2],[43,1,43,2],[38,1,38,2],[39,1,39,2],[40,1,40,2],[35,1,35,2],[36,1,36,2]]}
[]
[null,"Step 3: This sheet allows you to see your Fixed and Variable expenses. The point is so that in the case of being over or under budget you are able to see where funds need to be trimmed back or where you could stand to spend a little more if you so choose. Remeber, Variable expenses are goping to be easier to change where as a fixed expense may recquire a lot more time and effort with a smaller benefit."]
[]
[]
[]
[]
[]
[null,"Fixed Expenses"]
[null,"Property Tax",null,{"$f":"IF('Monthly Inputs'!C20<>\"\",'Monthly Inputs'!C20,\"\")","v":""}]
[null,"Mortgage/Rent/Condo Fees",null,{"$f":"IF('Monthly Inputs'!C21<>\"\",'Monthly Inputs'!C21,\"\")","v":""}]
[null,"Home Insurance",null,{"$f":"IF('Monthly Inputs'!C22<>\"\",'Monthly Inputs'!C22,\"\")","v":""}]
[null,"Phone Bills",null,{"$f":"IF('Monthly Inputs'!C28<>\"\",'Monthly Inputs'!C28,\"\")","v":""}]
[null,"Cable Bill",null,{"$f":"IF('Monthly Inputs'!C29<>\"\",'Monthly Inputs'!C29,\"\")","v":""}]
[null,"Internet",null,{"$f":"IF('Monthly Inputs'!C30<>\"\",'Monthly Inputs'!C30,\"\")","v":""},null,"Total Fixed Expenses",{"$f":"+SUM(D9:D23)","v":0}]
[null,"Childcare",null,{"$f":"IF('Monthly Inputs'!C31<>\"\",'Monthly Inputs'!C31,\"\")","v":""},null,"Total Variable Expenses",{"$f":"+SUM(D28:D50)","v":0}]
[null,"Life Insurance",null,{"$f":"IF('Monthly Inputs'!C32<>\"\",'Monthly Inputs'!C32,\"\")","v":""}]
[null,"Medical/Dental",null,{"$f":"IF('Monthly Inputs'!C33<>\"\",'Monthly Inputs'!C33,\"\")","v":""}]
[null,"Car Insurance",null,{"$f":"IF('Monthly Inputs'!G18<>\"\",'Monthly Inputs'!G18,\"\")","v":""}]
[null,"Car Payments",null,{"$f":"IF('Monthly Inputs'!G19<>\"\",'Monthly Inputs'!G19,\"\")","v":""}]
[null,"Registration/Licence Renewal",null,{"$f":"IF('Monthly Inputs'!G20<>\"\",'Monthly Inputs'!G20,\"\")","v":""}]
[null,"Vehicle Maintenance",null,{"$f":"IF('Monthly Inputs'!G22<>\"\",'Monthly Inputs'!G22,\"\")","v":""}]
[null,"Taxes",null,{"$f":"IF('Monthly Inputs'!G40<>\"\",'Monthly Inputs'!G40,\"\")","v":""}]
[null,"Debt Repayment",null,{"$f":"IF('Monthly Inputs'!G41<>\"\",'Monthly Inputs'!G41,\"\")","v":""}]
[null,"Total Fixed Expenses",null,{"$f":"IF(SUM(D9:D23)<>0,SUM(D9:D23),0)","v":0}]
[]
[]
[null,"Variable Expenses"]
[null,"Utilities",null,{"$f":"IF('Monthly Inputs'!C23<>\"\",'Monthly Inputs'!C23,\"\")","v":""}]
[null,"Reno/Maintenance",null,{"$f":"IF('Monthly Inputs'!C24<>\"\",'Monthly Inputs'!C24,\"\")","v":""}]
[null,"Groceries/Personal Care",null,{"$f":"IF('Monthly Inputs'!C34<>\"\",'Monthly Inputs'!C34,\"\")","v":""}]
[null,"Pets",null,{"$f":"IF('Monthly Inputs'!C35<>\"\",'Monthly Inputs'!C35,\"\")","v":""}]
[null,"Bank/Financial Fees",null,{"$f":"IF('Monthly Inputs'!C36<>\"\",'Monthly Inputs'!C36,\"\")","v":""}]
[null,"Sports Teams",null,{"$f":"IF('Monthly Inputs'!C37<>\"\",'Monthly Inputs'!C37,\"\")","v":""}]
[null,"Other",null,{"$f":"IF('Monthly Inputs'!C38<>\"\",'Monthly Inputs'!C38,\"\")","v":""}]
[null,"Deposition to Bank Account",null,{"$f":"IF('Monthly Inputs'!G11<>\"\",'Monthly Inputs'!G11,\"\")","v":""}]
[null,"Deposition to Investments",null,{"$f":"IF('Monthly Inputs'!G12<>\"\",'Monthly Inputs'!G12,\"\")","v":""}]
[null,"Rainy Day Fund",null,{"$f":"IF('Monthly Inputs'!G13<>\"\",'Monthly Inputs'!G13,\"\")","v":""}]
[null,"Other",null,{"$f":"IF('Monthly Inputs'!G14<>\"\",'Monthly Inputs'!G14,\"\")","v":""}]
[null,"Gas/Travel",null,{"$f":"IF('Monthly Inputs'!G21<>\"\",'Monthly Inputs'!G21,\"\")","v":""}]
[null,"Public Transportation",null,{"$f":"IF('Monthly Inputs'!G23<>\"\",'Monthly Inputs'!G23,\"\")","v":""}]
[null,"Taxi/Uber",null,{"$f":"IF('Monthly Inputs'!G24<>\"\",'Monthly Inputs'!G24,\"\")","v":""}]
[null,"Parking",null,{"$f":"IF('Monthly Inputs'!G25<>\"\",'Monthly Inputs'!G25,\"\")","v":""}]
[null,"Allowances",null,{"$f":"IF('Monthly Inputs'!G29<>\"\",'Monthly Inputs'!G29,\"\")","v":""}]
[null,"Entertainment",null,{"$f":"IF('Monthly Inputs'!G30<>\"\",'Monthly Inputs'!G30,\"\")","v":""}]
[null,"Restaurant",null,{"$f":"IF('Monthly Inputs'!G31<>\"\",'Monthly Inputs'!G31,\"\")","v":""}]
[null,"Clothing",null,{"$f":"IF('Monthly Inputs'!G32<>\"\",'Monthly Inputs'!G32,\"\")","v":""}]
[null,"Gifts/Charity",null,{"$f":"IF('Monthly Inputs'!G33<>\"\",'Monthly Inputs'!G33,\"\")","v":""}]
[null,"Hobbies",null,{"$f":"IF('Monthly Inputs'!G34<>\"\",'Monthly Inputs'!G34,\"\")","v":""}]
[null,"Clubs/Subscriptions",null,{"$f":"IF('Monthly Inputs'!G35<>\"\",'Monthly Inputs'!G35,\"\")","v":""}]
[null,"Vacation",null,{"$f":"IF('Monthly Inputs'!G36<>\"\",'Monthly Inputs'!G36,\"\")","v":""}]
[null,"Total Variable Expenses",null,{"$f":"IF(SUM(D28:D50)<>0,SUM(D28:D50),0)","v":0}]