{"text_format":"3","workbook":"xls","n_sheets":1,"sheets":["Personal Budget"],"not_rendered":{"external_links":1},"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"Personal Budget","index":0,"n_rows":41,"n_cols":5,"rows_kept":41,"merged":[[0,0,0,5],[2,1,3,4],[5,1,5,2],[6,1,6,2],[7,1,7,2],[8,1,8,2],[9,1,9,2],[10,1,10,2],[12,1,12,2],[13,1,13,2],[14,1,14,2],[15,1,15,2],[16,1,16,2],[17,1,17,2],[18,1,18,2],[19,1,19,2],[20,1,20,2],[21,1,21,2],[22,1,22,2],[23,1,23,2],[25,1,25,2],[26,1,26,2],[27,1,27,2],[28,1,28,2],[29,1,29,2],[30,1,30,2],[31,1,31,2],[32,1,32,2],[33,1,33,2],[35,1,35,4],[36,1,36,3],[37,1,37,3],[38,1,38,3],[40,1,43,4]],"flags":["formulas_cached_only"]}
["Personal Budget "]
[null,"Date:","2000-04-27T15:38:02"]
[null,"This worksheet can help you analyze your personal budget. Enter values into the yellow boxes, replacing sample data. Results will be shown in the green boxes."]
[]
[]
[null,"Income",null," Monthly Amount"," Percent"]
[null," Net pay",null,{"v":3750,"d":"$3,750"},{"v":0.9488866396761133,"d":"94.89%"}]
[null," Investments",null,{"v":150,"d":"$150"},{"v":0.03795546558704453,"d":"3.80%"}]
[null," Interest",null,{"v":52,"d":"$52"},{"v":0.013157894736842105,"d":"1.32%"}]
[null," Other",null,{"v":0,"d":"$0"},""]
[null," Total income",null,{"v":3952,"d":"$3,952"},{"v":1,"d":"100.00%"}]
[]
[null,"Fixed Expenses",null," Monthly Amount"," Percent"]
[null," Rent or mortgage",null,{"v":1200,"d":"$1,200"},{"v":0.42105263157894735,"d":"42.11%"}]
[null," Car payments",null,{"v":275,"d":"$275"},{"v":0.09649122807017543,"d":"9.65%"}]
[null," Credit card payments",null,{"v":50,"d":"$50"},{"v":0.017543859649122806,"d":"1.75%"}]
[null," Telephone",null,{"v":50,"d":"$50"},{"v":0.017543859649122806,"d":"1.75%"}]
[null," Utilities",null,{"v":75,"d":"$75"},{"v":0.02631578947368421,"d":"2.63%"}]
[null," Taxes",null,{"v":1050,"d":"$1,050"},{"v":0.3684210526315789,"d":"36.84%"}]
[null," Child care",null,{"v":0,"d":"$0"},""]
[null," Cable TV",null,{"v":25,"d":"$25"},{"v":0.008771929824561403,"d":"0.88%"}]
[null," Insurance (personal and property)",null,{"v":125,"d":"$125"},{"v":0.043859649122807015,"d":"4.39%"}]
[null," Other",null,{"v":0,"d":"$0"},""]
[null," Total fixed expenses",null,{"v":2850,"d":"$2,850"},{"v":0.9999999999999999,"d":"100.00%"}]
[]
[null,"Variable Expenses",null," Monthly Amount"," Percent"]
[null," Food",null,{"v":250,"d":"$250"},{"v":0.5555555555555556,"d":"55.56%"}]
[null," Clothing",null,{"v":50,"d":"$50"},{"v":0.1111111111111111,"d":"11.11%"}]
[null," Transportation (including car and taxis)",null,{"v":50,"d":"$50"},{"v":0.1111111111111111,"d":"11.11%"}]
[null," Vacation",null,{"v":100,"d":"$100"},{"v":0.2222222222222222,"d":"22.22%"}]
[null," Tuition and schooling",null,{"v":0,"d":"$0"},""]
[null," Babysitting",null,{"v":0,"d":"$0"},""]
[null," Other",null,{"v":0,"d":"$0"},""]
[null," Total variable expenses",null,{"v":450,"d":"$450"},{"v":1,"d":"100.00%"}]
[]
[null,"Summary"]
[null," Total Income",null,null,{"v":3952,"d":"$3,952"}]
[null," Total fixed and variable expenses",null,null,{"v":3300,"d":"$3,300"}]
[null," Difference between income and expenses",null,null,{"v":652,"d":"$652"}]
[]
[null,"This worksheet is locked to preserve the formulas that calculate your results. To unlock the worksheet, go to the Tools menu, select Protection, then choose Unprotect Sheet. This sheet does not use a password."]