{"text_format":"3","workbook":"xls","n_sheets":5,"sheets":["Planned Expenses","Actual Expenses","Expense Variances","Expense Analysis","Total Expenses"],"not_rendered":{"charts":2,"images":5,"external_links":1},"unopened":[{"sheet":"Total Expenses","index":4,"reason":"not_a_worksheet"}],"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"Planned Expenses","index":0,"n_rows":27,"n_cols":14,"rows_kept":27,"flags":["formulas_cached_only"]}
["<Company Name>"]
["Streamlined Expense Estimates"]
[]
[]
["Planned Expenses","Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec","YEAR"]
["Employee Costs"]
["Employee wages",{"v":85000,"d":"$85,000"},{"v":85000,"d":"$85,000"},{"v":85000,"d":"$85,000"},{"v":87500,"d":"$87,500"},{"v":87500,"d":"$87,500"},{"v":87500,"d":"$87,500"},{"v":87500,"d":"$87,500"},{"v":92400,"d":"$92,400"},{"v":92400,"d":"$92,400"},{"v":92400,"d":"$92,400"},{"v":92400,"d":"$92,400"},{"v":92400,"d":"$92,400"},{"v":1067000,"d":"$1,067,000"}]
["Employee benefits",{"v":22950,"d":"22,950 "},{"v":22950,"d":"22,950 "},{"v":22950,"d":"22,950 "},{"v":23625,"d":"23,625 "},{"v":23625,"d":"23,625 "},{"v":23625,"d":"23,625 "},{"v":23625,"d":"23,625 "},{"v":24948,"d":"24,948 "},{"v":24948,"d":"24,948 "},{"v":24948,"d":"24,948 "},{"v":24948,"d":"24,948 "},{"v":24948,"d":"24,948 "},{"v":288090,"d":"288,090 "}]
["Employee training",{"v":4000,"d":"4,000 "},{"v":4000,"d":"4,000 "},{"v":4000,"d":"4,000 "},{"v":4000,"d":"4,000 "},{"v":4000,"d":"4,000 "},{"v":4000,"d":"4,000 "},{"v":4000,"d":"4,000 "},{"v":4000,"d":"4,000 "},{"v":4000,"d":"4,000 "},{"v":4000,"d":"4,000 "},{"v":4000,"d":"4,000 "},{"v":4000,"d":"4,000 "},{"v":48000,"d":"48,000 "}]
["Subtotal",{"v":107950,"d":"$107,950"},{"v":107950,"d":"$107,950"},{"v":107950,"d":"$107,950"},{"v":111125,"d":"$111,125"},{"v":111125,"d":"$111,125"},{"v":111125,"d":"$111,125"},{"v":111125,"d":"$111,125"},{"v":117348,"d":"$117,348"},{"v":117348,"d":"$117,348"},{"v":117348,"d":"$117,348"},{"v":117348,"d":"$117,348"},{"v":117348,"d":"$117,348"},{"v":1355090,"d":"$1,355,090"}]
[]
["Office Costs"]
["Office lease",{"v":12000,"d":"$12,000"},{"v":12000,"d":"$12,000"},{"v":12000,"d":"$12,000"},{"v":12000,"d":"$12,000"},{"v":12000,"d":"$12,000"},{"v":12000,"d":"$12,000"},{"v":12000,"d":"$12,000"},{"v":12000,"d":"$12,000"},{"v":12000,"d":"$12,000"},{"v":12000,"d":"$12,000"},{"v":12000,"d":"$12,000"},{"v":12000,"d":"$12,000"},{"v":144000,"d":"$144,000"}]
["Office utilities",{"v":2000,"d":"2,000 "},{"v":2000,"d":"2,000 "},{"v":2000,"d":"2,000 "},{"v":2000,"d":"2,000 "},{"v":2000,"d":"2,000 "},{"v":2000,"d":"2,000 "},{"v":2000,"d":"2,000 "},{"v":2000,"d":"2,000 "},{"v":2000,"d":"2,000 "},{"v":2000,"d":"2,000 "},{"v":2000,"d":"2,000 "},{"v":2000,"d":"2,000 "},{"v":24000,"d":"24,000 "}]
["Office supplies",{"v":250,"d":"250 "},{"v":250,"d":"250 "},{"v":250,"d":"250 "},{"v":250,"d":"250 "},{"v":250,"d":"250 "},{"v":250,"d":"250 "},{"v":250,"d":"250 "},{"v":250,"d":"250 "},{"v":250,"d":"250 "},{"v":250,"d":"250 "},{"v":250,"d":"250 "},{"v":250,"d":"250 "},{"v":3000,"d":"3,000 "}]
["Subtotal",{"v":14250,"d":"$14,250"},{"v":14250,"d":"$14,250"},{"v":14250,"d":"$14,250"},{"v":14250,"d":"$14,250"},{"v":14250,"d":"$14,250"},{"v":14250,"d":"$14,250"},{"v":14250,"d":"$14,250"},{"v":14250,"d":"$14,250"},{"v":14250,"d":"$14,250"},{"v":14250,"d":"$14,250"},{"v":14250,"d":"$14,250"},{"v":14250,"d":"$14,250"},{"v":171000,"d":"$171,000"}]
[]
["Marketing Costs"]
["Web site costs",{"v":2000,"d":"$2,000"},{"v":2000,"d":"$2,000"},{"v":2000,"d":"$2,000"},{"v":2000,"d":"$2,000"},{"v":2000,"d":"$2,000"},{"v":2000,"d":"$2,000"},{"v":2000,"d":"$2,000"},{"v":2000,"d":"$2,000"},{"v":2000,"d":"$2,000"},{"v":2000,"d":"$2,000"},{"v":2000,"d":"$2,000"},{"v":2000,"d":"$2,000"},{"v":24000,"d":"$24,000"}]
["Collateral costs",{"v":500,"d":"500 "},{"v":500,"d":"500 "},{"v":500,"d":"500 "},{"v":500,"d":"500 "},{"v":500,"d":"500 "},{"v":500,"d":"500 "},{"v":500,"d":"500 "},{"v":500,"d":"500 "},{"v":500,"d":"500 "},{"v":500,"d":"500 "},{"v":500,"d":"500 "},{"v":500,"d":"500 "},{"v":6000,"d":"6,000 "}]
["Marketing events",{"v":5000,"d":"5,000 "},{"v":5000,"d":"5,000 "},{"v":5000,"d":"5,000 "},{"v":5000,"d":"5,000 "},{"v":5000,"d":"5,000 "},{"v":5000,"d":"5,000 "},{"v":5000,"d":"5,000 "},{"v":5000,"d":"5,000 "},{"v":5000,"d":"5,000 "},{"v":5000,"d":"5,000 "},{"v":5000,"d":"5,000 "},{"v":5000,"d":"5,000 "},{"v":60000,"d":"60,000 "}]
["Subtotal",{"v":7500,"d":"$7,500"},{"v":7500,"d":"$7,500"},{"v":7500,"d":"$7,500"},{"v":7500,"d":"$7,500"},{"v":7500,"d":"$7,500"},{"v":7500,"d":"$7,500"},{"v":7500,"d":"$7,500"},{"v":7500,"d":"$7,500"},{"v":7500,"d":"$7,500"},{"v":7500,"d":"$7,500"},{"v":7500,"d":"$7,500"},{"v":7500,"d":"$7,500"},{"v":90000,"d":"$90,000"}]
[]
[]
["TOTALS"]
["Monthly Planned Expenses",{"v":129700,"d":"$129,700"},{"v":129700,"d":"$129,700"},{"v":129700,"d":"$129,700"},{"v":132875,"d":"$132,875"},{"v":132875,"d":"$132,875"},{"v":132875,"d":"$132,875"},{"v":132875,"d":"$132,875"},{"v":139098,"d":"$139,098"},{"v":139098,"d":"$139,098"},{"v":139098,"d":"$139,098"},{"v":139098,"d":"$139,098"},{"v":139098,"d":"$139,098"},{"v":1616090,"d":"$1,616,090"}]
["TOTAL Planned Expenses",{"v":129700,"d":"$129,700"},{"v":259400,"d":"$259,400"},{"v":389100,"d":"$389,100"},{"v":521975,"d":"$521,975"},{"v":654850,"d":"$654,850"},{"v":787725,"d":"$787,725"},{"v":920600,"d":"$920,600"},{"v":1059698,"d":"$1,059,698"},{"v":1198796,"d":"$1,198,796"},{"v":1337894,"d":"$1,337,894"},{"v":1476992,"d":"$1,476,992"},{"v":1616090,"d":"$1,616,090"}]

{"sheet":"Actual Expenses","index":1,"n_rows":27,"n_cols":14,"rows_kept":27,"flags":["formulas_cached_only"]}
["<Company Name>"]
["Streamlined Expense Estimates"]
[]
[]
["Actual Expenses","Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec","YEAR"]
["Employee Costs"]
["Employee wages",{"v":85000,"d":"$85,000"},{"v":85000,"d":"$85,000"},{"v":85000,"d":"$85,000"},{"v":89000,"d":"$89,000"},{"v":89000,"d":"$89,000"},{"v":89000,"d":"$89,000"},{"v":87500,"d":"$87,500"},{"v":92400,"d":"$92,400"},{"v":92400,"d":"$92,400"},{"v":92400,"d":"$92,400"},{"v":92400,"d":"$92,400"},{"v":92400,"d":"$92,400"},{"v":1071500,"d":"$1,071,500"}]
["Employee benefits",{"v":22950,"d":"22,950 "},{"v":22950,"d":"22,950 "},{"v":22950,"d":"22,950 "},{"v":24030,"d":"24,030 "},{"v":24030,"d":"24,030 "},{"v":24030,"d":"24,030 "},{"v":23625,"d":"23,625 "},{"v":24948,"d":"24,948 "},{"v":24948,"d":"24,948 "},{"v":24948,"d":"24,948 "},{"v":24948,"d":"24,948 "},{"v":24948,"d":"24,948 "},{"v":289305,"d":"289,305 "}]
["Employee training",{"v":4000,"d":"4,000 "},{"v":4000,"d":"4,000 "},{"v":4000,"d":"4,000 "},{"v":4000,"d":"4,000 "},{"v":4000,"d":"4,000 "},{"v":4000,"d":"4,000 "},{"v":4000,"d":"4,000 "},{"v":4000,"d":"4,000 "},{"v":4000,"d":"4,000 "},{"v":4000,"d":"4,000 "},{"v":4000,"d":"4,000 "},{"v":4000,"d":"4,000 "},{"v":48000,"d":"48,000 "}]
["Subtotal",{"v":107950,"d":"$107,950"},{"v":107950,"d":"$107,950"},{"v":107950,"d":"$107,950"},{"v":113030,"d":"$113,030"},{"v":113030,"d":"$113,030"},{"v":113030,"d":"$113,030"},{"v":111125,"d":"$111,125"},{"v":117348,"d":"$117,348"},{"v":117348,"d":"$117,348"},{"v":117348,"d":"$117,348"},{"v":117348,"d":"$117,348"},{"v":117348,"d":"$117,348"},{"v":1360805,"d":"$1,360,805"}]
[]
["Office Costs"]
["Office lease",{"v":12000,"d":"$12,000"},{"v":12000,"d":"$12,000"},{"v":12000,"d":"$12,000"},{"v":12000,"d":"$12,000"},{"v":12000,"d":"$12,000"},{"v":12000,"d":"$12,000"},{"v":12000,"d":"$12,000"},{"v":12000,"d":"$12,000"},{"v":12000,"d":"$12,000"},{"v":12000,"d":"$12,000"},{"v":12000,"d":"$12,000"},{"v":12000,"d":"$12,000"},{"v":144000,"d":"$144,000"}]
["Office utilities",{"v":2250,"d":"2,250 "},{"v":2300,"d":"2,300 "},{"v":2400,"d":"2,400 "},{"v":1800,"d":"1,800 "},{"v":1640,"d":"1,640 "},{"v":1650,"d":"1,650 "},{"v":1550,"d":"1,550 "},{"v":1760,"d":"1,760 "},{"v":1900,"d":"1,900 "},{"v":2100,"d":"2,100 "},{"v":2300,"d":"2,300 "},{"v":2350,"d":"2,350 "},{"v":24000,"d":"24,000 "}]
["Office supplies",{"v":255,"d":"255 "},{"v":245,"d":"245 "},{"v":220,"d":"220 "},{"v":215,"d":"215 "},{"v":220,"d":"220 "},{"v":234,"d":"234 "},{"v":310,"d":"310 "},{"v":185,"d":"185 "},{"v":190,"d":"190 "},{"v":245,"d":"245 "},{"v":220,"d":"220 "},{"v":204,"d":"204 "},{"v":2743,"d":"2,743 "}]
["Subtotal",{"v":14505,"d":"$14,505"},{"v":14545,"d":"$14,545"},{"v":14620,"d":"$14,620"},{"v":14015,"d":"$14,015"},{"v":13860,"d":"$13,860"},{"v":13884,"d":"$13,884"},{"v":13860,"d":"$13,860"},{"v":13945,"d":"$13,945"},{"v":14090,"d":"$14,090"},{"v":14345,"d":"$14,345"},{"v":14520,"d":"$14,520"},{"v":14554,"d":"$14,554"},{"v":170743,"d":"$170,743"}]
[]
["Marketing Costs"]
["Web site costs",{"v":2150,"d":"$2,150"},{"v":1890,"d":"$1,890"},{"v":2190,"d":"$2,190"},{"v":2050,"d":"$2,050"},{"v":1950,"d":"$1,950"},{"v":2200,"d":"$2,200"},{"v":2000,"d":"$2,000"},{"v":2300,"d":"$2,300"},{"v":2045,"d":"$2,045"},{"v":2100,"d":"$2,100"},{"v":2150,"d":"$2,150"},{"v":2250,"d":"$2,250"},{"v":25275,"d":"$25,275"}]
["Collateral costs",{"v":600,"d":"600 "},{"v":650,"d":"650 "},{"v":400,"d":"400 "},{"v":550,"d":"550 "},{"v":495,"d":"495 "},{"v":700,"d":"700 "},{"v":300,"d":"300 "},{"v":450,"d":"450 "},{"v":450,"d":"450 "},{"v":420,"d":"420 "},{"v":800,"d":"800 "},{"v":400,"d":"400 "},{"v":6215,"d":"6,215 "}]
["Marketing events",{"v":2500,"d":"2,500 "},{"v":6000,"d":"6,000 "},{"v":8500,"d":"8,500 "},{"v":2300,"d":"2,300 "},{"v":4300,"d":"4,300 "},{"v":5600,"d":"5,600 "},{"v":4550,"d":"4,550 "},{"v":5050,"d":"5,050 "},{"v":6025,"d":"6,025 "},{"v":7500,"d":"7,500 "},{"v":3200,"d":"3,200 "},{"v":4900,"d":"4,900 "},{"v":60425,"d":"60,425 "}]
["Subtotal",{"v":5250,"d":"$5,250"},{"v":8540,"d":"$8,540"},{"v":11090,"d":"$11,090"},{"v":4900,"d":"$4,900"},{"v":6745,"d":"$6,745"},{"v":8500,"d":"$8,500"},{"v":6850,"d":"$6,850"},{"v":7800,"d":"$7,800"},{"v":8520,"d":"$8,520"},{"v":10020,"d":"$10,020"},{"v":6150,"d":"$6,150"},{"v":7550,"d":"$7,550"},{"v":91915,"d":"$91,915"}]
[]
[]
["TOTALS"]
["Monthly Actual Expenses",{"v":127705,"d":"$127,705"},{"v":131035,"d":"$131,035"},{"v":133660,"d":"$133,660"},{"v":131945,"d":"$131,945"},{"v":133635,"d":"$133,635"},{"v":135414,"d":"$135,414"},{"v":131835,"d":"$131,835"},{"v":139093,"d":"$139,093"},{"v":139958,"d":"$139,958"},{"v":141713,"d":"$141,713"},{"v":138018,"d":"$138,018"},{"v":139452,"d":"$139,452"},{"v":1623463,"d":"$1,623,463"}]
["TOTAL Actual Expenses",{"v":127705,"d":"$127,705"},{"v":258740,"d":"$258,740"},{"v":392400,"d":"$392,400"},{"v":524345,"d":"$524,345"},{"v":657980,"d":"$657,980"},{"v":793394,"d":"$793,394"},{"v":925229,"d":"$925,229"},{"v":1064322,"d":"$1,064,322"},{"v":1204280,"d":"$1,204,280"},{"v":1345993,"d":"$1,345,993"},{"v":1484011,"d":"$1,484,011"},{"v":1623463,"d":"$1,623,463"}]

{"sheet":"Expense Variances","index":2,"n_rows":27,"n_cols":14,"rows_kept":27,"flags":["formulas_cached_only"]}
["<Company Name>"]
["Streamlined Expense Estimates"]
[]
[]
["Expense Variances","Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec","YEAR"]
["Employee Costs"]
["Employee wages",0,0,0,{"v":-1500,"d":"$(1,500)"},{"v":-1500,"d":"$(1,500)"},{"v":-1500,"d":"$(1,500)"},0,0,0,0,0,0,{"v":-4500,"d":"$(4,500)"}]
["Employee benefits",0,0,0,{"v":-405,"d":"$(405)"},{"v":-405,"d":"$(405)"},{"v":-405,"d":"$(405)"},0,0,0,0,0,0,{"v":-1215,"d":"$(1,215)"}]
["Employee training",0,0,0,0,0,0,0,0,0,0,0,0,0]
["Subtotal",0,0,0,{"v":-1905,"d":"$(1,905)"},{"v":-1905,"d":"$(1,905)"},{"v":-1905,"d":"$(1,905)"},0,0,0,0,0,0,{"v":-5715,"d":"$(5,715)"}]
[]
["Office Costs"]
["Office lease",0,0,0,0,0,0,0,0,0,0,0,0,0]
["Office utilities",{"v":-250,"d":"$(250)"},{"v":-300,"d":"$(300)"},{"v":-400,"d":"$(400)"},{"v":200,"d":"$200"},{"v":360,"d":"$360"},{"v":350,"d":"$350"},{"v":450,"d":"$450"},{"v":240,"d":"$240"},{"v":100,"d":"$100"},{"v":-100,"d":"$(100)"},{"v":-300,"d":"$(300)"},{"v":-350,"d":"$(350)"},0]
["Office supplies",{"v":-5,"d":"$(5)"},{"v":5,"d":"$5"},{"v":30,"d":"$30"},{"v":35,"d":"$35"},{"v":30,"d":"$30"},{"v":16,"d":"$16"},{"v":-60,"d":"$(60)"},{"v":65,"d":"$65"},{"v":60,"d":"$60"},{"v":5,"d":"$5"},{"v":30,"d":"$30"},{"v":46,"d":"$46"},{"v":257,"d":"$257"}]
["Subtotal",{"v":-255,"d":"$(255)"},{"v":-295,"d":"$(295)"},{"v":-370,"d":"$(370)"},{"v":235,"d":"$235"},{"v":390,"d":"$390"},{"v":366,"d":"$366"},{"v":390,"d":"$390"},{"v":305,"d":"$305"},{"v":160,"d":"$160"},{"v":-95,"d":"$(95)"},{"v":-270,"d":"$(270)"},{"v":-304,"d":"$(304)"},{"v":257,"d":"$257"}]
[]
["Marketing Costs"]
["Web site costs",{"v":-150,"d":"$(150)"},{"v":110,"d":"$110"},{"v":-190,"d":"$(190)"},{"v":-50,"d":"$(50)"},{"v":50,"d":"$50"},{"v":-200,"d":"$(200)"},0,{"v":-300,"d":"$(300)"},{"v":-45,"d":"$(45)"},{"v":-100,"d":"$(100)"},{"v":-150,"d":"$(150)"},{"v":-250,"d":"$(250)"},{"v":-1275,"d":"$(1,275)"}]
["Collateral costs",{"v":-100,"d":"$(100)"},{"v":-150,"d":"$(150)"},{"v":100,"d":"$100"},{"v":-50,"d":"$(50)"},{"v":5,"d":"$5"},{"v":-200,"d":"$(200)"},{"v":200,"d":"$200"},{"v":50,"d":"$50"},{"v":50,"d":"$50"},{"v":80,"d":"$80"},{"v":-300,"d":"$(300)"},{"v":100,"d":"$100"},{"v":-215,"d":"$(215)"}]
["Marketing events",{"v":2500,"d":"$2,500"},{"v":-1000,"d":"$(1,000)"},{"v":-3500,"d":"$(3,500)"},{"v":2700,"d":"$2,700"},{"v":700,"d":"$700"},{"v":-600,"d":"$(600)"},{"v":450,"d":"$450"},{"v":-50,"d":"$(50)"},{"v":-1025,"d":"$(1,025)"},{"v":-2500,"d":"$(2,500)"},{"v":1800,"d":"$1,800"},{"v":100,"d":"$100"},{"v":-425,"d":"$(425)"}]
["Subtotal",{"v":2250,"d":"$2,250"},{"v":-1040,"d":"$(1,040)"},{"v":-3590,"d":"$(3,590)"},{"v":2600,"d":"$2,600"},{"v":755,"d":"$755"},{"v":-1000,"d":"$(1,000)"},{"v":650,"d":"$650"},{"v":-300,"d":"$(300)"},{"v":-1020,"d":"$(1,020)"},{"v":-2520,"d":"$(2,520)"},{"v":1350,"d":"$1,350"},{"v":-50,"d":"$(50)"},{"v":-1915,"d":"$(1,915)"}]
[]
[]
["TOTALS"]
["Monthly Expense Variances",{"v":1995,"d":"$1,995"},{"v":-1335,"d":"$(1,335)"},{"v":-3960,"d":"$(3,960)"},{"v":930,"d":"$930"},{"v":-760,"d":"$(760)"},{"v":-2539,"d":"$(2,539)"},{"v":1040,"d":"$1,040"},{"v":5,"d":"$5"},{"v":-860,"d":"$(860)"},{"v":-2615,"d":"$(2,615)"},{"v":1080,"d":"$1,080"},{"v":-354,"d":"$(354)"},{"v":-7373,"d":"$(7,373)"}]
["TOTAL Expense Variances",{"v":1995,"d":"$1,995"},{"v":660,"d":"$660"},{"v":-3300,"d":"$(3,300)"},{"v":-2370,"d":"$(2,370)"},{"v":-3130,"d":"$(3,130)"},{"v":-5669,"d":"$(5,669)"},{"v":-4629,"d":"$(4,629)"},{"v":-4624,"d":"$(4,624)"},{"v":-5484,"d":"$(5,484)"},{"v":-8099,"d":"$(8,099)"},{"v":-7019,"d":"$(7,019)"},{"v":-7373,"d":"$(7,373)"}]

{"sheet":"Expense Analysis","index":3,"n_rows":9,"n_cols":2,"rows_kept":9,"flags":["formulas_cached_only"]}
["<Company Name>"]
["Streamlined Expense Estimates"]
[]
[]
["Expense Category","Actual Expenses"]
["Employee Costs",{"v":1360805,"d":"$1,360,805"}]
["Office Costs",{"v":170743,"d":"170,743 "}]
["Marketing Costs",{"v":91915,"d":"91,915 "}]
["TOTALS",{"v":1623463,"d":"$1,623,463"}]