{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Personal Cash Flow Example","Personal Cash Flow Template"],"not_rendered":{"charts":4,"images":2,"macros":0,"external_links":0,"defined_names":0,"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":"Personal Cash Flow Example","index":0,"n_rows":99,"n_cols":19,"rows_kept":99,"cut":false,"hidden":false,"merged":[[98,1,98,17],[7,5,8,6],[7,7,8,8],[17,2,17,13],[2,5,2,8],[3,5,3,6],[3,7,3,8],[4,5,4,6],[4,7,4,8],[5,5,5,6],[5,7,5,8]]}
[null,"PERSONAL CASH FLOW TEMPLATE"]
[]
[null,null,null,null,null,"SUMMARY"]
[null,null,null,null,null,"I N C O M E",null,{"$f":"'Personal Cash Flow Example'!O30","v":7257}]
[null,null,null,null,null,"S A V I N G S",null,{"$f":"'Personal Cash Flow Example'!O41","v":1655}]
[null,null,null,null,null,"E X P E N S E S",null,{"$f":"'Personal Cash Flow Example'!O97","v":5359}]
[]
[null,null,null,null,null,"C A S H    F L O W ",null,{"$f":"H4-H5-H6","v":243}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Enter Income, Savings, and Expense Data below. Overview information above and totals will generate automatically. "]
[null,null,"JAN","FEB","MAR","APR","MAY","JUN","JUL","AUG","SEPT","OCT","NOV","DEC","YEARLY TOTALS",null,"MONTHLY AVG",null,"DAILY AVG"]
[null,"INCOME"]
[]
[null,"Salary/Wages",5987,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(C22:N22)","v":5987},null,{"$f":"O22/12","v":498.91666666666669},null,{"$f":"O22/365","v":16.402739726027399}]
[null,"Interest Income",200,null,null,null,null,null,null,null,null,null,null,null,200,null,{"$f":"O23/12","v":16.666666666666668},null,{"$f":"O23/365","v":0.54794520547945202}]
[null,"Dividends",100,null,null,null,null,null,null,null,null,null,null,null,100,null,8.3333333333333339,null,0.27397260273972601]
[null,"Refunds/Reimbursements",55,null,null,null,null,null,null,null,null,null,null,null,55,null,4.583333333333333,null,0.15068493150684931]
[null,"Business",500,null,null,null,null,null,null,null,null,null,null,null,500,null,41.666666666666664,null,1.3698630136986301]
[null,"Pension",300,null,null,null,null,null,null,null,null,null,null,null,300,null,25,null,0.82191780821917804]
[null,"Misc.",115,null,null,null,null,null,null,null,null,null,null,null,115,null,9.5833333333333339,null,0.31506849315068491]
[]
[null,"TOTAL",{"$f":"SUM(C22:C28)","v":7257},0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(C30:N30)","v":7257},null,{"$f":"SUM(Q22:Q28)","v":604.75000000000011},null,{"$f":"SUM(S22:S28)","v":19.88219178082192}]
[]
[null,"SAVINGS"]
[]
[null,"Emergency Fund",500,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(C34:N34)","v":500},null,{"$f":"O34/12","v":41.666666666666664},null,{"$f":"O34/365","v":1.3698630136986301}]
[null,"Transfer to Savings",200,0,0,0,0,0,0,0,0,0,0,0,200,null,{"$f":"O35/12","v":16.666666666666668},null,{"$f":"O35/365","v":0.54794520547945202}]
[null,"Retirement(401K, IRA)",100,0,0,0,0,0,0,0,0,0,0,0,100,null,8.3333333333333339,null,0.27397260273972601]
[null,"Investments",55,0,0,0,0,0,0,0,0,0,0,0,55,null,4.583333333333333,null,0.15068493150684931]
[null,"Education",500,0,0,0,0,0,0,0,0,0,0,0,500,null,41.666666666666664,null,1.3698630136986301]
[null,"Other",300,0,0,0,0,0,0,0,0,0,0,0,300,null,25,null,0.82191780821917804]
[]
[null,"TOTAL",{"$f":"SUM(C34:C39)","v":1655},0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(C41:N41)","v":1655},null,{"$f":"SUM(Q34:Q39)","v":137.91666666666666},null,{"$f":"SUM(S34:S39)","v":4.5342465753424657}]
[]
[null,"EXPENSES"]
[null,"HOME"]
[null,"Mortgage/rent",2250,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(C45:N45)","v":2250},null,{"$f":"O45/12","v":187.5},null,{"$f":"O45/365","v":6.1643835616438354}]
[null,"Home/Rental Insurance",25,0,0,0,0,0,0,0,0,0,0,0,25,null,{"$f":"O46/12","v":2.0833333333333335},null,{"$f":"O46/365","v":6.8493150684931503E-2}]
[null,"Electricity",40,0,0,0,0,0,0,0,0,0,0,0,40,null,3.3333333333333335,null,0.1095890410958904]
[null,"Gas/Oil",44,0,0,0,0,0,0,0,0,0,0,0,44,null,3.6666666666666665,null,0.12054794520547946]
[null,"Water/Sewer/Trash",20,0,0,0,0,0,0,0,0,0,0,0,20,null,1.6666666666666667,null,5.4794520547945202E-2]
[null,"Phone",15,0,0,0,0,0,0,0,0,0,0,0,15,null,1.25,null,4.1095890410958902E-2]
[null,"Cable/Satellite",0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,null,0]
[null,"Internet",29,0,0,0,0,0,0,0,0,0,0,0,29,null,2.4166666666666665,null,7.9452054794520555E-2]
[null,"Furnishing/Appliances",0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,null,0]
[null,"Lawn/Garden",0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,null,0]
[null,"Maintenance/Improvements",0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,null,0]
[null,"Other",0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,null,0]
[null,null,{"$f":"SUM(C45:C56)","v":2423},0,0,0,0,0,0,0,0,0,0,0,2423,null,{"$f":"SUM(Q45:Q56)","v":201.91666666666666},null,6.6383561643835609]
[null,"TRANSPORTATION"]
[null,"Car payments",250,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(C59:N59)","v":250},null,{"$f":"O59/12","v":20.833333333333332},null,{"$f":"O59/365","v":0.68493150684931503}]
[null,"Auto Insurance",100,0,0,0,0,0,0,0,0,0,0,0,100,null,{"$f":"O60/12","v":8.3333333333333339},null,{"$f":"O60/365","v":0.27397260273972601}]
[null,"Fuel",100,0,0,0,0,0,0,0,0,0,0,0,100,null,8.3333333333333339,null,0.27397260273972601]
[null,"Public Transportation",0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,null,0]
[null,"Repairs/Maintenance",0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,null,0]
[null,"Registration/License",100,0,0,0,0,0,0,0,0,0,0,0,100,null,8.3333333333333339,null,0.27397260273972601]
[null,null,{"$f":"SUM(C59:C64)","v":550},0,0,0,0,0,0,0,0,0,0,0,550,null,{"$f":"SUM(Q59:Q64)","v":45.833333333333336},null,{"$f":"SUM(S59:S64)","v":1.5068493150684932}]
[null,"DAILY LIVING"]
[null,"Groceries",250,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(C67:N67)","v":250},null,{"$f":"O67/12","v":20.833333333333332},null,{"$f":"O67/365","v":0.68493150684931503}]
[null,"Child care",100,0,0,0,0,0,0,0,0,0,0,0,100,null,{"$f":"O68/12","v":8.3333333333333339},null,{"$f":"O68/365","v":0.27397260273972601}]
[null,"Dining out",100,0,0,0,0,0,0,0,0,0,0,0,100,null,8.3333333333333339,null,0.27397260273972601]
[null,"Clothing",0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,null,0]
[null,"Cleaning",0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,null,0]
[null,"Salon/Barber",100,0,0,0,0,0,0,0,0,0,0,0,100,null,8.3333333333333339,null,0.27397260273972601]
[null,"Pet Supplies",101,0,0,0,0,0,0,0,0,0,0,0,101,null,8.4166666666666661,null,0.27671232876712326]
[null,null,{"$f":"SUM(C67:C73)","v":651},0,0,0,0,0,0,0,0,0,0,0,651,null,54.25,null,1.7835616438356166]
[null,"ENTERTAINMENT"]
[null,"Video/DVD/Movies",250,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(C76:N76)","v":250},null,{"$f":"O76/12","v":20.833333333333332},null,{"$f":"O76/365","v":0.68493150684931503}]
[null,"Concerts/Plays",100,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(C77:N77)","v":100},null,{"$f":"O77/12","v":8.3333333333333339},null,{"$f":"O77/365","v":0.27397260273972601}]
[null,"Sports",100,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(C78:N78)","v":100},null,8.3333333333333339,null,0.27397260273972601]
[null,"Outdoor Recreation",0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(C79:N79)","v":0},null,0,null,0]
[null,null,{"$f":"SUM(C76:C79)","v":450},0,0,0,0,0,0,0,0,0,0,0,450,null,37.5,null,1.2328767123287672]
[null,"HEALTH"]
[null,"Health Insurance",65,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(C82:N82)","v":65},null,{"$f":"O82/12","v":5.416666666666667},null,{"$f":"O82/365","v":0.17808219178082191}]
[null,"Gym membership",20,0,0,0,0,0,0,0,0,0,0,0,20,null,{"$f":"O83/12","v":1.6666666666666667},null,{"$f":"O83/365","v":5.4794520547945202E-2}]
[null,"Doctors/Dentist visits",0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,null,0]
[null,"Medicine/Prescriptions",0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,null,0]
[null,"Veterinarian",0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,null,0]
[null,"Life Insurance",0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,null,0]
[null,null,{"$f":"SUM(C82:C87)","v":85},0,0,0,0,0,0,0,0,0,0,0,85,null,7.0833333333333339,null,0.23287671232876711]
[null,"VACATION/HOLIDAY"]
[null,"Airfare",450,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(C90:N90)","v":450},null,{"$f":"O90/12","v":37.5},null,{"$f":"O90/365","v":1.2328767123287672}]
[null,"Accommodations",250,0,0,0,0,0,0,0,0,0,0,0,250,null,{"$f":"O91/12","v":20.833333333333332},null,{"$f":"O91/365","v":0.68493150684931503}]
[null,"Food",200,0,0,0,0,0,0,0,0,0,0,0,200,null,16.666666666666668,null,0.54794520547945202]
[null,"Souvenirs",50,0,0,0,0,0,0,0,0,0,0,0,50,null,4.166666666666667,null,0.13698630136986301]
[null,"Pet Boarding",100,0,0,0,0,0,0,0,0,0,0,0,100,null,8.3333333333333339,null,0.27397260273972601]
[null,"Rental car",150,0,0,0,0,0,0,0,0,0,0,0,150,null,12.5,null,0.41095890410958902]
[null,null,{"$f":"SUM(C90:C95)","v":1200},0,0,0,0,0,0,0,0,0,0,0,1200,null,100,null,3.2876712328767121]
[null,"TOTAL",{"$f":"C96+C88+C80+C74+C65+C57","v":5359},0,0,0,0,0,0,0,0,0,0,0,5359,null,{"$f":"Q96+Q88+Q80+Q74+Q65+Q57","v":446.58333333333331},null,14.682191780821917]
[]
[null,"CLICK HERE TO CREATE PERSONAL CASH FLOW TEMPLATES IN SMARTSHEET"]

{"sheet":"Personal Cash Flow Template","index":1,"n_rows":103,"n_cols":19,"rows_kept":103,"cut":false,"hidden":false,"merged":[[2,5,2,8],[7,5,8,6],[7,7,8,8],[3,7,3,8],[4,7,4,8],[5,7,5,8],[102,3,102,12],[17,2,17,13],[3,5,3,6],[4,5,4,6],[5,5,5,6]]}
[null,"PERSONAL CASH FLOW TEMPLATE"]
[]
[null,null,null,null,null,"SUMMARY"]
[null,null,null,null,null,"I N C O M E",null,{"$f":"'Personal Cash Flow Template'!O30","v":0}]
[null,null,null,null,null,"S A V I N G S",null,{"$f":"'Personal Cash Flow Template'!O41","v":0}]
[null,null,null,null,null,"E X P E N S E S",null,{"$f":"'Personal Cash Flow Template'!O97","v":0}]
[]
[null,null,null,null,null,"C A S H    F L O W ",null,{"$f":"H4-H5-H6","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Enter Income, Savings, and Expense Data below. Overview information above and totals will generate automatically. "]
[null,null,"JAN","FEB","MAR","APR","MAY","JUN","JUL","AUG","SEPT","OCT","NOV","DEC","YEARLY TOTALS",null,"MONTHLY AVG",null,"DAILY AVG"]
[null,"INCOME"]
[]
[null,"Salary/Wages",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(C22:N22)","v":0},null,{"$f":"O22/12","v":0},null,{"$f":"O22/365","v":0}]
[null,"Interest Income",null,null,null,null,null,null,null,null,null,null,null,null,0,null,{"$f":"O23/12","v":0},null,{"$f":"O23/365","v":0}]
[null,"Dividends",null,null,null,null,null,null,null,null,null,null,null,null,0,null,0,null,0]
[null,"Refunds/Reimbursements",null,null,null,null,null,null,null,null,null,null,null,null,0,null,0,null,0]
[null,"Business",null,null,null,null,null,null,null,null,null,null,null,null,0,null,0,null,0]
[null,"Pension",null,null,null,null,null,null,null,null,null,null,null,null,0,null,0,null,0]
[null,"Misc.",null,null,null,null,null,null,null,null,null,null,null,null,0,null,0,null,0]
[]
[null,"TOTAL",{"$f":"SUM(C22:C28)","v":0},0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(C30:N30)","v":0},null,{"$f":"SUM(Q22:Q28)","v":0},null,{"$f":"SUM(S22:S28)","v":0}]
[]
[null,"SAVINGS"]
[]
[null,"Emergency Fund",0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(C34:N34)","v":0},null,{"$f":"O34/12","v":0},null,{"$f":"O34/365","v":0}]
[null,"Transfer to Savings",0,0,0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"O35/12","v":0},null,{"$f":"O35/365","v":0}]
[null,"Retirement(401K, IRA)",0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,null,0]
[null,"Investments",0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,null,0]
[null,"Education",0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,null,0]
[null,"Other",0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,null,0]
[]
[null,"TOTAL",{"$f":"SUM(C34:C39)","v":0},0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(C41:N41)","v":0},null,{"$f":"SUM(Q34:Q39)","v":0},null,{"$f":"SUM(S34:S39)","v":0}]
[]
[null,"EXPENSES"]
[null,"HOME"]
[null,"Mortgage/rent",0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(C45:N45)","v":0},null,{"$f":"O45/12","v":0},null,{"$f":"O45/365","v":0}]
[null,"Home/Rental Insurance",0,0,0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"O46/12","v":0},null,{"$f":"O46/365","v":0}]
[null,"Electricity",0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,null,0]
[null,"Gas/Oil",0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,null,0]
[null,"Water/Sewer/Trash",0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,null,0]
[null,"Phone",0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,null,0]
[null,"Cable/Satellite",0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,null,0]
[null,"Internet",0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,null,0]
[null,"Furnishing/Appliances",0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,null,0]
[null,"Lawn/Garden",0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,null,0]
[null,"Maintenance/Improvements",0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,null,0]
[null,"Other",0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,null,0]
[null,null,{"$f":"SUM(C45:C56)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"SUM(Q45:Q56)","v":0},null,0]
[null,"TRANSPORTATION"]
[null,"Car payments",0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(C59:N59)","v":0},null,{"$f":"O59/12","v":0},null,{"$f":"O59/365","v":0}]
[null,"Auto Insurance",0,0,0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"O60/12","v":0},null,{"$f":"O60/365","v":0}]
[null,"Fuel",0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,null,0]
[null,"Public Transportation",0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,null,0]
[null,"Repairs/Maintenance",0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,null,0]
[null,"Registration/License",0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,null,0]
[null,null,{"$f":"SUM(C59:C64)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"SUM(Q59:Q64)","v":0},null,{"$f":"SUM(S59:S64)","v":0}]
[null,"DAILY LIVING"]
[null,"Groceries",0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(C67:N67)","v":0},null,{"$f":"O67/12","v":0},null,{"$f":"O67/365","v":0}]
[null,"Child care",0,0,0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"O68/12","v":0},null,{"$f":"O68/365","v":0}]
[null,"Dining out",0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,null,0]
[null,"Clothing",0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,null,0]
[null,"Cleaning",0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,null,0]
[null,"Salon/Barber",0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,null,0]
[null,"Pet Supplies",0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,null,0]
[null,null,{"$f":"SUM(C67:C73)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,null,0,null,0]
[null,"ENTERTAINMENT"]
[null,"Video/DVD/Movies",0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(C76:N76)","v":0},null,{"$f":"O76/12","v":0},null,{"$f":"O76/365","v":0}]
[null,"Concerts/Plays",0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(C77:N77)","v":0},null,{"$f":"O77/12","v":0},null,{"$f":"O77/365","v":0}]
[null,"Sports",0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(C78:N78)","v":0},null,0,null,0]
[null,"Outdoor Recreation",0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(C79:N79)","v":0},null,0,null,0]
[null,null,{"$f":"SUM(C76:C79)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,null,0,null,0]
[null,"HEALTH"]
[null,"Health Insurance",0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(C82:N82)","v":0},null,{"$f":"O82/12","v":0},null,{"$f":"O82/365","v":0}]
[null,"Gym membership",0,0,0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"O83/12","v":0},null,{"$f":"O83/365","v":0}]
[null,"Doctors/Dentist visits",0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,null,0]
[null,"Medicine/Prescriptions",0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,null,0]
[null,"Veterinarian",0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,null,0]
[null,"Life Insurance",0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,null,0]
[null,null,{"$f":"SUM(C82:C87)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,null,0,null,0]
[null,"VACATION/HOLIDAY"]
[null,"Airfare",0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(C90:N90)","v":0},null,{"$f":"O90/12","v":0},null,{"$f":"O90/365","v":0}]
[null,"Accommodations",0,0,0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"O91/12","v":0},null,{"$f":"O91/365","v":0}]
[null,"Food",0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,null,0]
[null,"Souvenirs",0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,null,0]
[null,"Pet Boarding",0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,null,0]
[null,"Rental car",0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,null,0]
[null,null,{"$f":"SUM(C90:C95)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,null,0,null,0]
[null,"TOTAL",{"$f":"C96+C88+C80+C74+C65+C57","v":0},0,0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"Q96+Q88+Q80+Q74+Q65+Q57","v":0},null,0]
[]
[]
[]
[]
[]
[null,null,null,"CLICK HERE TO CREATE BUDGET TEMPLATES IN SMARTSHEET"]