{"text_format":"3","workbook":"xls","n_sheets":4,"sheets":["Inputs & Assumptions","Business Unit Expense Analysis","Annual Operating Budget","Trend Chart"],"not_rendered":{"charts":1,"external_links":1,"defined_names":1},"unopened":[{"sheet":"Trend Chart","index":3,"reason":"not_a_worksheet"}],"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"Inputs & Assumptions","index":0,"n_rows":31,"n_cols":3,"rows_kept":31,"merged":[[11,1,19,4]],"flags":["formulas_cached_only"]}
[null,"[Company Name]"]
[null,"Annual Operating Budget—Services"]
[null,"Model Inputs and General Information"]
[]
[null,"Model key"]
[null,"Bold numbers in white cells are entered by user."]
[null,"Italicized numbers in gray cells are calculations that generally should not be altered."]
[null,"Black numbers in gray cells are calculations that can be overwritten."]
[]
[]
[null,"General notes and assumptions"]
[null,"Document key financial planning assumptions here."]
{"$rows_empty":9}
[null,"Key model inputs"]
[null,"Use this area to capture key general assumptions that carry throughout the model."]
[]
[null,"1. Fringe rate for labor",{"v":0.25,"d":"25%"}]
[]
[null,"2. Number of years for straight-line\n       depreciation",5]
[]
[null,"3. Tax rate",{"v":0.3,"d":"30%"}]
[]
[null,"4.  Annual targeted revenue\n        per employee",{"v":270000,"d":"$270,000"}]

{"sheet":"Business Unit Expense Analysis","index":1,"n_rows":132,"n_cols":9,"rows_kept":132,"merged":[[17,3,17,6],[48,3,48,6],[89,3,89,6],[123,3,123,6]],"flags":["formulas_cached_only"]}
[null,"[Company Name]"]
[null,"Annual Operating Budget—Services"]
[null,"[Date]"]
[]
[]
[]
[]
[null,"Business Unit Budgets—Service Operations, Sales and Marketing, and General and Administrative"]
[null,"A. Service operations"]
[null,"Service operations expenses",null,"Q1","Q2","Q3","Q4","Annual total ","Notes"]
[null,"Salaries",null,{"v":491250,"d":"$491,250"},{"v":543750,"d":"$543,750"},{"v":562500,"d":"$562,500"},{"v":592500,"d":"$592,500"},{"v":2190000,"d":"$2,190,000"},"Total labor expense pulled from Row 35"]
[null,"Benefits (such as health care, training, 401(k))",null,{"v":122810,"d":"122,810"},{"v":135940,"d":"135,940"},{"v":140630,"d":"140,630"},{"v":148130,"d":"148,130"},{"v":547510,"d":"547,510"},"Rounded calculation based on input sheet rate"]
[null,"Net travel and entertainment",null,{"v":50000,"d":"50,000"},{"v":50000,"d":"50,000"},{"v":50000,"d":"50,000"},{"v":50000,"d":"50,000"},{"v":200000,"d":"200,000"}]
[null,"Supplies",null,{"v":25000,"d":"25,000"},{"v":25000,"d":"25,000"},{"v":25000,"d":"25,000"},{"v":25000,"d":"25,000"},{"v":100000,"d":"100,000"},"Annual total should equal financial plan target"]
[null,"General and miscellaneous",null,{"v":25000,"d":"25,000"},{"v":25000,"d":"25,000"},{"v":25000,"d":"25,000"},{"v":25000,"d":"25,000"},{"v":100000,"d":"100,000"},"Annual total should equal financial plan target"]
[null,"Total service operations expenses",null,{"v":714060,"d":"$714,060"},{"v":779690,"d":"$779,690"},{"v":803130,"d":"$803,130"},{"v":840630,"d":"$840,630"},{"v":3137510,"d":"$3,137,510"}]
[]
[null,"Service operations headcount analysis by role",null,"Number of full-time employees (FTEs)",{"$nulls":4},"Notes"]
[null,"Vice president",null,{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":4,"d":"4.00"}]
[null,"Director",null,{"v":2,"d":"2.00"},{"v":3,"d":"3.00"},{"v":3,"d":"3.00"},{"v":4,"d":"4.00"},{"v":12,"d":"12.00"}]
[null,"Manager",null,{"v":5,"d":"5.00"},{"v":6,"d":"6.00"},{"v":6,"d":"6.00"},{"v":6,"d":"6.00"},{"v":23,"d":"23.00"}]
[null,"Analyst",null,{"v":15,"d":"15.00"},{"v":15,"d":"15.00"},{"v":16,"d":"16.00"},{"v":16,"d":"16.00"},{"v":62,"d":"62.00"}]
[null,"TBD",null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[null,"TBD",null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[null,"Total service operations headcount",null,{"v":23,"d":"23.00"},{"v":25,"d":"25.00"},{"v":26,"d":"26.00"},{"v":27,"d":"27.00"},{"v":101,"d":"101.00"}]
[]
[null,"Service operations labor expense breakdown by role",null,"Q1","Q2","Q3","Q4",null,"Notes"]
[null,null,"Annual cost"]
[null,"Vice president",{"v":150000,"d":"$150,000"},{"v":37500,"d":"$37,500"},{"v":37500,"d":"$37,500"},{"v":37500,"d":"$37,500"},{"v":37500,"d":"$37,500"},{"v":150000,"d":"$150,000"}]
[null,"Director",{"v":120000,"d":"120,000"},{"v":60000,"d":"60,000"},{"v":90000,"d":"90,000"},{"v":90000,"d":"90,000"},{"v":120000,"d":"120,000"},{"v":360000,"d":"360,000"}]
[null,"Manager",{"v":90000,"d":"90,000"},{"v":112500,"d":"112,500"},{"v":135000,"d":"135,000"},{"v":135000,"d":"135,000"},{"v":135000,"d":"135,000"},{"v":517500,"d":"517,500"}]
[null,"Analyst",{"v":75000,"d":"75,000"},{"v":281250,"d":"281,250"},{"v":281250,"d":"281,250"},{"v":300000,"d":"300,000"},{"v":300000,"d":"300,000"},{"v":1162500,"d":"1,162,500"}]
[null,"TBD",0,0,0,0,0,0]
[null,"TBD",0,0,0,0,0,0]
[null,"Service total operations labor expense",null,{"v":491250,"d":"$491,250"},{"v":543750,"d":"$543,750"},{"v":562500,"d":"$562,500"},{"v":592500,"d":"$592,500"},{"v":2190000,"d":"$2,190,000"}]
[]
[]
[null,"B. Sales and marketing"]
[null,"Sales and marketing expenses",null,"Q1","Q2","Q3","Q4","Annual total ","Notes"]
[null,"Salaries",null,{"v":441250,"d":"$441,250"},{"v":441250,"d":"$441,250"},{"v":520000,"d":"$520,000"},{"v":550000,"d":"$550,000"},{"v":1952500,"d":"$1,952,500"}]
[null,"Benefits (such as health care, training, 401(k))",null,{"v":110310,"d":"110,310"},{"v":110310,"d":"110,310"},{"v":130000,"d":"130,000"},{"v":137500,"d":"137,500"},{"v":488120,"d":"488,120"},"Rounded calculation based on input sheet rate"]
[null,"Marketing programs",null,{"v":75000,"d":"75,000"},{"v":50000,"d":"50,000"},{"v":65000,"d":"65,000"},{"v":70000,"d":"70,000"},{"v":260000,"d":"260,000"}]
[null,"Public relations",null,{"v":15000,"d":"15,000"},{"v":15000,"d":"15,000"},{"v":15000,"d":"15,000"},{"v":15000,"d":"15,000"},{"v":60000,"d":"60,000"}]
[null,"Travel and entertainment",null,{"v":150000,"d":"150,000"},{"v":150000,"d":"150,000"},{"v":150000,"d":"150,000"},{"v":160000,"d":"160,000"},{"v":610000,"d":"610,000"}]
[null,"Supplies",null,{"v":25000,"d":"25,000"},{"v":25000,"d":"25,000"},{"v":25000,"d":"25,000"},{"v":25000,"d":"25,000"},{"v":100000,"d":"100,000"}]
[null,"General and miscellaneous",null,{"v":25000,"d":"25,000"},{"v":25000,"d":"25,000"},{"v":25000,"d":"25,000"},{"v":25000,"d":"25,000"},{"v":100000,"d":"100,000"}]
[null,"Total sales and marketing expenses",null,{"v":841560,"d":"$841,560"},{"v":816560,"d":"$816,560"},{"v":930000,"d":"$930,000"},{"v":982500,"d":"$982,500"},{"v":3570620,"d":"$3,570,620"}]
[]
[null,"Sales and marketing headcount analysis by role",null,"Number of full-time employees (FTEs)",{"$nulls":4},"Notes"]
[null,"Vice president",null,{"v":2,"d":"2.00"},{"v":2,"d":"2.00"},{"v":2,"d":"2.00"},{"v":2,"d":"2.00"},{"v":8,"d":"8.00"}]
[null,"Director",null,{"v":2,"d":"2.00"},{"v":2,"d":"2.00"},{"v":2,"d":"2.00"},{"v":3,"d":"3.00"},{"v":9,"d":"9.00"}]
[null,"Marketing managers",null,{"v":3,"d":"3.00"},{"v":3,"d":"3.00"},{"v":4,"d":"4.00"},{"v":4,"d":"4.00"},{"v":14,"d":"14.00"}]
[null,"Marketing analysts",null,{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":4,"d":"4.00"}]
[null,"Business development managers",null,{"v":4,"d":"4.00"},{"v":4,"d":"4.00"},{"v":5,"d":"5.00"},{"v":5,"d":"5.00"},{"v":18,"d":"18.00"}]
[null,"Customer service",null,{"v":4,"d":"4.00"},{"v":4,"d":"4.00"},{"v":5,"d":"5.00"},{"v":5,"d":"5.00"},{"v":18,"d":"18.00"}]
[null,"TBD",null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[null,"Total sales and marketing headcount",null,{"v":16,"d":"16.00"},{"v":16,"d":"16.00"},{"v":19,"d":"19.00"},{"v":20,"d":"20.00"},{"v":71,"d":"71.00"}]
[]
[null,"Sales and marketing labor expense breakdown by role",null,"Q1","Q2","Q3","Q4",null,"Notes"]
[null,null,"Annual cost"]
[null,"Vice president",{"v":150000,"d":"$150,000"},{"v":75000,"d":"$75,000"},{"v":75000,"d":"$75,000"},{"v":75000,"d":"$75,000"},{"v":75000,"d":"$75,000"},{"v":300000,"d":"$300,000"}]
[null,"Director",{"v":120000,"d":"120,000"},{"v":60000,"d":"60,000"},{"v":60000,"d":"60,000"},{"v":60000,"d":"60,000"},{"v":90000,"d":"90,000"},{"v":270000,"d":"270,000"}]
[null,"Marketing managers",{"v":110000,"d":"110,000"},{"v":82500,"d":"82,500"},{"v":82500,"d":"82,500"},{"v":110000,"d":"110,000"},{"v":110000,"d":"110,000"},{"v":385000,"d":"385,000"}]
[null,"Marketing analysts",{"v":75000,"d":"75,000"},{"v":18750,"d":"18,750"},{"v":18750,"d":"18,750"},{"v":18750,"d":"18,750"},{"v":18750,"d":"18,750"},{"v":75000,"d":"75,000"}]
[null,"Business development managers",{"v":130000,"d":"130,000"},{"v":130000,"d":"130,000"},{"v":130000,"d":"130,000"},{"v":162500,"d":"162,500"},{"v":162500,"d":"162,500"},{"v":585000,"d":"585,000"}]
[null,"Customer service",{"v":75000,"d":"75,000"},{"v":75000,"d":"75,000"},{"v":75000,"d":"75,000"},{"v":93750,"d":"93,750"},{"v":93750,"d":"93,750"},{"v":337500,"d":"337,500"}]
[null,"TBD",0,0,0,0,0,0]
[null,"Total sales and marketing labor expense",null,{"v":441250,"d":"$441,250"},{"v":441250,"d":"$441,250"},{"v":520000,"d":"$520,000"},{"v":550000,"d":"$550,000"},{"v":1952500,"d":"$1,952,500"}]
[]
[]
[null,"C. General and administrative"]
[null,"General and administrative expenses",null,"Q1","Q2","Q3","Q4","Annual total ","Notes"]
[null,"Salaries",null,{"v":581250,"d":"$581,250"},{"v":581250,"d":"$581,250"},{"v":581250,"d":"$581,250"},{"v":598750,"d":"$598,750"},{"v":2342500,"d":"$2,342,500"}]
[null,"Benefits (such as health care, training, 401(k))",null,{"v":145310,"d":"145,310"},{"v":145310,"d":"145,310"},{"v":145310,"d":"145,310"},{"v":149690,"d":"149,690"},{"v":585620,"d":"585,620"},"Rounded calculation based on input sheet rate"]
[null,"Depreciation",null,{"v":32600,"d":"32,600"},{"v":33050,"d":"33,050"},{"v":33650,"d":"33,650"},{"v":34250,"d":"34,250"},{"v":133550,"d":"133,550"}]
[null,"Rent",null,0,0,0,0,0]
[null,"Insurance",null,{"v":12000,"d":"12,000"},{"v":12000,"d":"12,000"},{"v":12000,"d":"12,000"},{"v":12000,"d":"12,000"},{"v":48000,"d":"48,000"}]
[null,"Professional services (not including subcontractors)",null,{"v":10000,"d":"10,000"},{"v":20000,"d":"20,000"},{"v":10000,"d":"10,000"},{"v":10000,"d":"10,000"},{"v":50000,"d":"50,000"}]
[null,"Dues and subscriptions",null,{"v":5000,"d":"5,000"},{"v":5000,"d":"5,000"},{"v":5000,"d":"5,000"},{"v":5000,"d":"5,000"},{"v":20000,"d":"20,000"}]
[null,"Bank charges",null,{"v":2000,"d":"2,000"},{"v":2000,"d":"2,000"},{"v":2000,"d":"2,000"},{"v":2000,"d":"2,000"},{"v":8000,"d":"8,000"}]
[null,"Telephone",null,{"v":25000,"d":"25,000"},{"v":25000,"d":"25,000"},{"v":25000,"d":"25,000"},{"v":25000,"d":"25,000"},{"v":100000,"d":"100,000"}]
[null,"Recruiting",null,{"v":20000,"d":"20,000"},{"v":20000,"d":"20,000"},{"v":20000,"d":"20,000"},{"v":20000,"d":"20,000"},{"v":80000,"d":"80,000"}]
[null,"Postage",null,{"v":10000,"d":"10,000"},{"v":10000,"d":"10,000"},{"v":10000,"d":"10,000"},{"v":10000,"d":"10,000"},{"v":40000,"d":"40,000"}]
[null,"Interest expense",null,{"v":10000,"d":"10,000"},{"v":10000,"d":"10,000"},{"v":10000,"d":"10,000"},{"v":10000,"d":"10,000"},{"v":40000,"d":"40,000"}]
[null,"Nonbillable travel and entertainment",null,{"v":15000,"d":"15,000"},{"v":15000,"d":"15,000"},{"v":15000,"d":"15,000"},{"v":15000,"d":"15,000"},{"v":60000,"d":"60,000"}]
[null,"Other supplies",null,{"v":25000,"d":"25,000"},{"v":25000,"d":"25,000"},{"v":25000,"d":"25,000"},{"v":25000,"d":"25,000"},{"v":100000,"d":"100,000"}]
[null,"Miscellaneous",null,{"v":2000,"d":"2,000"},{"v":3000,"d":"3,000"},{"v":4000,"d":"4,000"},{"v":5000,"d":"5,000"},{"v":14000,"d":"14,000"}]
[null,"Total general and administrative expenses",null,{"v":895160,"d":"$895,160"},{"v":906610,"d":"$906,610"},{"v":898210,"d":"$898,210"},{"v":921690,"d":"$921,690"},{"v":3621670,"d":"$3,621,670"}]
[]
[null,"General and administrative headcount analysis by role",null,"Number of full-time employees (FTEs)",{"$nulls":4},"Notes"]
[null,"Chief executive officer",null,{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":4,"d":"4.00"}]
[null,"Chief financial officer",null,{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":4,"d":"4.00"}]
[null,"Chief information officer",null,{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":4,"d":"4.00"}]
[null,"Vice president of human resources",null,{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":4,"d":"4.00"}]
[null,"Administrative staff",null,{"v":6,"d":"6.00"},{"v":6,"d":"6.00"},{"v":6,"d":"6.00"},{"v":6,"d":"6.00"},{"v":24,"d":"24.00"}]
[null,"Human resources director",null,{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":4,"d":"4.00"}]
[null,"Human resources staff",null,{"v":3,"d":"3.00"},{"v":3,"d":"3.00"},{"v":3,"d":"3.00"},{"v":3,"d":"3.00"},{"v":12,"d":"12.00"}]
[null,"Information technology director",null,{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":4,"d":"4.00"}]
[null,"Information technology manager",null,{"v":2,"d":"2.00"},{"v":2,"d":"2.00"},{"v":2,"d":"2.00"},{"v":2,"d":"2.00"},{"v":8,"d":"8.00"}]
[null,"Information technology analyst",null,{"v":3,"d":"3.00"},{"v":3,"d":"3.00"},{"v":3,"d":"3.00"},{"v":4,"d":"4.00"},{"v":13,"d":"13.00"}]
[null,"Finance director or controller",null,{"v":2,"d":"2.00"},{"v":2,"d":"2.00"},{"v":2,"d":"2.00"},{"v":2,"d":"2.00"},{"v":8,"d":"8.00"}]
[null,"Finance and accounting",null,{"v":2,"d":"2.00"},{"v":2,"d":"2.00"},{"v":2,"d":"2.00"},{"v":2,"d":"2.00"},{"v":8,"d":"8.00"}]
[null,"TBD",null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[null,"Total general and administrative headcount",null,{"v":24,"d":"24.00"},{"v":24,"d":"24.00"},{"v":24,"d":"24.00"},{"v":25,"d":"25.00"},{"v":97,"d":"97.00"}]
[]
[null,"General and administrative labor expense breakdown by role",null,"Q1","Q2","Q3","Q4",null,"Notes"]
[null,null,"Annual cost"]
[null,"Chief executive officer",{"v":300000,"d":"$300,000"},{"v":75000,"d":"$75,000"},{"v":75000,"d":"$75,000"},{"v":75000,"d":"$75,000"},{"v":75000,"d":"$75,000"},{"v":300000,"d":"$300,000"}]
[null,"Chief financial officer",{"v":225000,"d":"225,000"},{"v":56250,"d":"56,250"},{"v":56250,"d":"56,250"},{"v":56250,"d":"56,250"},{"v":56250,"d":"56,250"},{"v":225000,"d":"225,000"}]
[null,"Chief information officer",{"v":200000,"d":"200,000"},{"v":50000,"d":"50,000"},{"v":50000,"d":"50,000"},{"v":50000,"d":"50,000"},{"v":50000,"d":"50,000"},{"v":200000,"d":"200,000"}]
[null,"Vice president of human resources",{"v":160000,"d":"160,000"},{"v":40000,"d":"40,000"},{"v":40000,"d":"40,000"},{"v":40000,"d":"40,000"},{"v":40000,"d":"40,000"},{"v":160000,"d":"160,000"}]
[null,"Administrative staff",{"v":50000,"d":"50,000"},{"v":75000,"d":"75,000"},{"v":75000,"d":"75,000"},{"v":75000,"d":"75,000"},{"v":75000,"d":"75,000"},{"v":300000,"d":"300,000"}]
[null,"Human resources director",{"v":90000,"d":"90,000"},{"v":22500,"d":"22,500"},{"v":22500,"d":"22,500"},{"v":22500,"d":"22,500"},{"v":22500,"d":"22,500"},{"v":90000,"d":"90,000"}]
[null,"Human resources staff",{"v":60000,"d":"60,000"},{"v":45000,"d":"45,000"},{"v":45000,"d":"45,000"},{"v":45000,"d":"45,000"},{"v":45000,"d":"45,000"},{"v":180000,"d":"180,000"}]
[null,"Information technology director",{"v":100000,"d":"100,000"},{"v":25000,"d":"25,000"},{"v":25000,"d":"25,000"},{"v":25000,"d":"25,000"},{"v":25000,"d":"25,000"},{"v":100000,"d":"100,000"}]
[null,"Information technology manager",{"v":90000,"d":"90,000"},{"v":45000,"d":"45,000"},{"v":45000,"d":"45,000"},{"v":45000,"d":"45,000"},{"v":45000,"d":"45,000"},{"v":180000,"d":"180,000"}]
[null,"Information technology analyst",{"v":70000,"d":"70,000"},{"v":52500,"d":"52,500"},{"v":52500,"d":"52,500"},{"v":52500,"d":"52,500"},{"v":70000,"d":"70,000"},{"v":227500,"d":"227,500"}]
[null,"Finance director or controller",{"v":120000,"d":"120,000"},{"v":60000,"d":"60,000"},{"v":60000,"d":"60,000"},{"v":60000,"d":"60,000"},{"v":60000,"d":"60,000"},{"v":240000,"d":"240,000"}]
[null,"Finance and accounting",{"v":70000,"d":"70,000"},{"v":35000,"d":"35,000"},{"v":35000,"d":"35,000"},{"v":35000,"d":"35,000"},{"v":35000,"d":"35,000"},{"v":140000,"d":"140,000"}]
[null,"TBD",0,0,0,0,0,0]
[null,"Total general and administrative labor expense",null,{"v":581250,"d":"$581,250"},{"v":581250,"d":"$581,250"},{"v":581250,"d":"$581,250"},{"v":598750,"d":"$598,750"},{"v":2342500,"d":"$2,342,500"}]
[]
[null,"Depreciable assets",null,"Q1","Q2","Q3","Q4","Annual total ","Notes"]
[null,null,"Beginning balance","Additional purchases"]
[null,"Buildings",{"v":600000,"d":"$600,000"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":600000,"d":"$600,000"}]
[null,"Equipment",{"v":20000,"d":"20,000"},{"v":2000,"d":"2,000"},0,{"v":4000,"d":"4,000"},{"v":4000,"d":"4,000"},{"v":30000,"d":"30,000"}]
[null,"IT infrastructure",{"v":25000,"d":"25,000"},{"v":5000,"d":"5,000"},{"v":4000,"d":"4,000"},{"v":3000,"d":"3,000"},{"v":8000,"d":"8,000"},{"v":45000,"d":"45,000"}]
[null,"Other",0,0,{"v":5000,"d":"5,000"},0,0,{"v":5000,"d":"5,000"}]
[null,"Other",0,0,0,{"v":5000,"d":"5,000"},0,{"v":5000,"d":"5,000"}]
[null,"Total depreciable assets",{"v":645000,"d":"$645,000"},{"v":7000,"d":"$7,000"},{"v":9000,"d":"$9,000"},{"v":12000,"d":"$12,000"},{"v":12000,"d":"$12,000"},{"v":685000,"d":"$685,000"}]
[]
[null,"Depreciation base",{"v":645000,"d":"$645,000"},{"v":652000,"d":"$652,000"},{"v":661000,"d":"$661,000"},{"v":673000,"d":"$673,000"},{"v":685000,"d":"$685,000"},{"v":685000,"d":"$685,000"}]

{"sheet":"Annual Operating Budget","index":2,"n_rows":116,"n_cols":10,"rows_kept":116,"flags":["formulas_cached_only"]}
[null,"[Company Name]"]
[null,"Annual Operating Budget—Services"]
[null,"[Date]"]
[]
[]
[]
[null,"Pro Forma Financial Statements—Income Statement, Balance Sheet, and Cash Flow Summary"]
[null,"Pro forma annual income statement"]
[null,"Headcount summary",null,"Q1","Q2","Q3","Q4",null,"Notes"]
[null,"Service operations",null,{"v":23,"d":"23.00"},{"v":25,"d":"25.00"},{"v":26,"d":"26.00"},{"v":27,"d":"27.00"},{"v":27,"d":"27.00"}]
[null,"Sales and marketing",null,{"v":16,"d":"16.00"},{"v":16,"d":"16.00"},{"v":19,"d":"19.00"},{"v":20,"d":"20.00"},{"v":20,"d":"20.00"}]
[null,"General and administrative",null,{"v":24,"d":"24.00"},{"v":24,"d":"24.00"},{"v":24,"d":"24.00"},{"v":25,"d":"25.00"},{"v":25,"d":"25.00"}]
[null,"Total headcount",null,{"v":63,"d":"63.00"},{"v":65,"d":"65.00"},{"v":69,"d":"69.00"},{"v":72,"d":"72.00"},{"v":72,"d":"72.00"}]
[]
[null,"Revenues",null,{"v":4500000,"d":"$4,500,000"},{"v":5000000,"d":"$5,000,000"},{"v":5200000,"d":"$5,200,000"},{"v":5500000,"d":"$5,500,000"},{"v":20200000,"d":"$20,200,000"},"Taken from 3-year financial plan"]
[null,"Cost of sales",null,{"v":1000000,"d":"1,000,000"},{"v":1100000,"d":"1,100,000"},{"v":1200000,"d":"1,200,000"},{"v":1300000,"d":"1,300,000"},{"v":4600000,"d":"4,600,000"},"Taken from 3-year financial plan"]
[null,"Gross margin",null,{"v":3500000,"d":"$3,500,000"},{"v":3900000,"d":"$3,900,000"},{"v":4000000,"d":"$4,000,000"},{"v":4200000,"d":"$4,200,000"},{"v":15600000,"d":"$15,600,000"}]
[null,"Margin contribution %",null,{"v":0.78,"d":"78%"},{"v":0.78,"d":"78%"},{"v":0.77,"d":"77%"},{"v":0.76,"d":"76%"},{"v":0.77,"d":"77%"}]
[]
[null,"Checkpoint:  Revenue per employee from this budget",{"$nulls":5},{"v":280555.55555555556,"d":"$280,556"},"Compare to financial plan"]
["  Financial Plan Revenue per Employee","Targeted revenue per employee",{"$nulls":5},{"v":270000,"d":"$270,000"},"From Input sheet"]
[]
[null,"Expenses",null,"Q1","Q2","Q3","Q4",null,"Notes"," "]
[null,"Service operations",null,{"v":714060,"d":"$714,060"},{"v":779690,"d":"$779,690"},{"v":803130,"d":"$803,130"},{"v":840630,"d":"$840,630"},{"v":3137510,"d":"$3,137,510"},"Taken from operations section"]
[null,"Sales and marketing",null,{"v":841560,"d":"841,560"},{"v":816560,"d":"816,560"},{"v":930000,"d":"930,000"},{"v":982500,"d":"982,500"},{"v":3570620,"d":"3,570,620"},"Taken from sales and marketing section"]
[null,"General and administrative",null,{"v":895160,"d":"895,160"},{"v":906610,"d":"906,610"},{"v":898210,"d":"898,210"},{"v":921690,"d":"921,690"},{"v":3621670,"d":"3,621,670"},"Taken from general and administrative section"]
[null,"Total expenses",null,{"v":2450780,"d":"$2,450,780"},{"v":2502860,"d":"$2,502,860"},{"v":2631340,"d":"$2,631,340"},{"v":2744820,"d":"$2,744,820"},{"v":10329800,"d":"$10,329,800"}]
[]
[null,"Operating profit",null,{"v":1049220,"d":"$1,049,220"},{"v":1397140,"d":"$1,397,140"},{"v":1368660,"d":"$1,368,660"},{"v":1455180,"d":"$1,455,180"},{"v":5270200,"d":"$5,270,200"}]
[]
[null,"Other gains (losses)",null,0,{"v":21000,"d":"21,000"},{"v":20000,"d":"20,000"},{"v":35000,"d":"35,000"},{"v":76000,"d":"76,000"}]
[null,"Other income",null,{"v":5000,"d":"5,000"},{"v":5000,"d":"5,000"},{"v":5000,"d":"5,000"},{"v":5000,"d":"5,000"},{"v":20000,"d":"20,000"}]
[]
[null,"Total income",null,{"v":1054220,"d":"1,054,220"},{"v":1423140,"d":"1,423,140"},{"v":1393660,"d":"1,393,660"},{"v":1495180,"d":"1,495,180"},{"v":5366200,"d":"5,366,200"}]
[]
[null,"Taxes",{"v":0.3,"d":"30.0%"},{"v":316270,"d":"316,270"},{"v":426940,"d":"426,940"},{"v":418100,"d":"418,100"},{"v":448550,"d":"448,550"},{"v":1609860,"d":"1,609,860"},"Rounded calculation based on input sheet rate"]
[]
[null,"Net income",null,{"v":737950,"d":"737,950"},{"v":996200,"d":"996,200"},{"v":975560,"d":"975,560"},{"v":1046630,"d":"1,046,630"},{"v":3756340,"d":"3,756,340"}]
[]
[]
[]
[null,"Pro forma annual balance sheet"]
[null,"Assets",null,"Q1","Q2","Q3","Q4","Annual total","Notes"]
[null,null,"Beginning balance"]
[null,"Cash",{"v":50000,"d":"50,000"},{"v":808550,"d":"808,550"},{"v":1823800,"d":"1,823,800"},{"v":2816010,"d":"2,816,010"},{"v":3879890,"d":"3,879,890"},{"v":3879890,"d":"3,879,890"}]
[null,"Accounts receivable",{"v":40000,"d":"40,000"},{"v":40000,"d":"40,000"},{"v":40000,"d":"40,000"},{"v":40000,"d":"40,000"},{"v":40000,"d":"40,000"},{"v":40000,"d":"40,000"}]
[null,"Other current assets",{"v":20000,"d":"20,000"},{"v":20000,"d":"20,000"},{"v":20000,"d":"20,000"},{"v":20000,"d":"20,000"},{"v":20000,"d":"20,000"},{"v":20000,"d":"20,000"}]
[null,"Total current assets",{"v":110000,"d":"110,000"},{"v":868550,"d":"868,550"},{"v":1883800,"d":"1,883,800"},{"v":2876010,"d":"2,876,010"},{"v":3939890,"d":"3,939,890"},{"v":3939890,"d":"3,939,890"}]
[]
[null,"Depreciable assets",{"v":645000,"d":"645,000"},{"v":652000,"d":"652,000"},{"v":661000,"d":"661,000"},{"v":673000,"d":"673,000"},{"v":685000,"d":"685,000"},{"v":685000,"d":"685,000"}]
[null,"Accumulated depreciation",0,{"v":32600,"d":"32,600"},{"v":65650,"d":"65,650"},{"v":99300,"d":"99,300"},{"v":133550,"d":"133,550"},{"v":133550,"d":"133,550"}]
[null,"Land",{"v":640000,"d":"640,000"},{"v":640000,"d":"640,000"},{"v":640000,"d":"640,000"},{"v":640000,"d":"640,000"},{"v":640000,"d":"640,000"},{"v":640000,"d":"640,000"}]
[null,"Net property, plant, and equipment",{"v":1285000,"d":"1,285,000"},{"v":1259400,"d":"1,259,400"},{"v":1235350,"d":"1,235,350"},{"v":1213700,"d":"1,213,700"},{"v":1191450,"d":"1,191,450"},{"v":1191450,"d":"1,191,450"}]
[]
[null,"Other assets",{"v":100000,"d":"100,000"},{"v":100000,"d":"100,000"},{"v":100000,"d":"100,000"},{"v":100000,"d":"100,000"},{"v":100000,"d":"100,000"},{"v":100000,"d":"100,000"}]
[]
[null,"Total assets",{"v":1495000,"d":"$1,495,000"},{"v":2227950,"d":"$2,227,950"},{"v":3219150,"d":"$3,219,150"},{"v":4189710,"d":"$4,189,710"},{"v":5231340,"d":"$5,231,340"},{"v":5231340,"d":"$5,231,340"}]
[]
[null,"Liabilities and equity",{"$nulls":6},"Notes"]
[null,"Accounts payable",{"v":20000,"d":"$20,000"},{"v":20000,"d":"$20,000"},{"v":20000,"d":"$20,000"},{"v":20000,"d":"$20,000"},{"v":20000,"d":"$20,000"},{"v":20000,"d":"$20,000"}]
[null,"Accrued liabilities",{"v":10000,"d":"10,000 "},{"v":10000,"d":"10,000 "},{"v":10000,"d":"10,000 "},{"v":10000,"d":"10,000 "},{"v":10000,"d":"10,000 "},{"v":10000,"d":"10,000 "}]
[null,"Other current liabilities",{"v":10000,"d":"10,000 "},{"v":10000,"d":"10,000 "},{"v":10000,"d":"10,000 "},{"v":10000,"d":"10,000 "},{"v":10000,"d":"10,000 "},{"v":10000,"d":"10,000 "}]
[null,"Total current liabilities",{"v":40000,"d":"$40,000"},{"v":40000,"d":"$40,000"},{"v":40000,"d":"$40,000"},{"v":40000,"d":"$40,000"},{"v":40000,"d":"$40,000"},{"v":40000,"d":"$40,000"}]
[]
[null,"Long-term debt",{"v":150000,"d":"$150,000"},{"v":145000,"d":"$145,000"},{"v":140000,"d":"$140,000"},{"v":135000,"d":"$135,000"},{"v":130000,"d":"$130,000"},{"v":130000,"d":"$130,000"}]
[null,"Notes payable",{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[null,"Other long-term liabilities",{"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 "}]
[null,"Total long-term liabilities",{"v":155000,"d":"$155,000"},{"v":150000,"d":"$150,000"},{"v":145000,"d":"$145,000"},{"v":140000,"d":"$140,000"},{"v":135000,"d":"$135,000"},{"v":135000,"d":"$135,000"}]
[]
[null,"Total liabilities",{"v":195000,"d":"$195,000"},{"v":190000,"d":"$190,000"},{"v":185000,"d":"$185,000"},{"v":180000,"d":"$180,000"},{"v":175000,"d":"$175,000"},{"v":175000,"d":"$175,000"}]
[]
[null,"Common stock",{"v":1000000,"d":"$1,000,000"},{"v":1000000,"d":"$1,000,000"},{"v":1000000,"d":"$1,000,000"},{"v":1000000,"d":"$1,000,000"},{"v":1000000,"d":"$1,000,000"},{"v":1000000,"d":"$1,000,000"}]
[null,"Retained earnings",{"v":300000,"d":"300,000"},{"v":300000,"d":"300,000"},{"v":300000,"d":"300,000"},{"v":300000,"d":"300,000"},{"v":300000,"d":"300,000"},{"v":300000,"d":"300,000"}]
[null,"Cumulative net income",0,{"v":737950,"d":"737,950"},{"v":1734150,"d":"1,734,150"},{"v":2709710,"d":"2,709,710"},{"v":3756340,"d":"3,756,340"},{"v":3756340,"d":"3,756,340"}]
[null,"Net equity",{"v":1300000,"d":"$1,300,000"},{"v":2037950,"d":"$2,037,950"},{"v":3034150,"d":"$3,034,150"},{"v":4009710,"d":"$4,009,710"},{"v":5056340,"d":"$5,056,340"},{"v":5056340,"d":"$5,056,340"}]
[]
[null,"Total liabilities and equity",{"v":1495000,"d":"$1,495,000"},{"v":2227950,"d":"$2,227,950"},{"v":3219150,"d":"$3,219,150"},{"v":4189710,"d":"$4,189,710"},{"v":5231340,"d":"$5,231,340"},{"v":5231340,"d":"$5,231,340"}]
[]
[]
[]
[null,"Pro forma annual cash flow summary"]
[null,"Sources of funds",null,"Q1","Q2","Q3","Q4"," "]
[null,"From operations",null,{"v":732950,"d":"$732,950"},{"v":970200,"d":"$970,200"},{"v":950560,"d":"$950,560"},{"v":1006630,"d":"$1,006,630"}]
[null,"Add depreciation",null,{"v":32600,"d":"32,600"},{"v":33050,"d":"33,050"},{"v":33650,"d":"33,650"},{"v":34250,"d":"34,250"}]
[]
[null,"Net changes in balance sheet accounts"]
[null,"Current assets",null,0,0,0,0]
[null,"Current liabilities",null,0,0,0,0]
[]
[null,"Other sources of funds"]
[null,"Other gains (losses)",null,0,{"v":21000,"d":"21,000"},{"v":20000,"d":"20,000"},{"v":35000,"d":"35,000"}]
[null,"Other",null,{"v":5000,"d":"5,000"},{"v":5000,"d":"5,000"},{"v":5000,"d":"5,000"},{"v":5000,"d":"5,000"}]
[null,"Total sources  ",null,{"v":770550,"d":"$770,550"},{"v":1029250,"d":"$1,029,250"},{"v":1009210,"d":"$1,009,210"},{"v":1080880,"d":"$1,080,880"}]
[]
[null,"Uses of funds"]
[null,"Repurchase of stock",null,0,0,0,0]
[null,"Debt retirement",null,{"v":-5000,"d":"-5,000"},{"v":-5000,"d":"-5,000"},{"v":-5000,"d":"-5,000"},{"v":-5000,"d":"-5,000"}]
[null,"Purchase of equipment and assets",null,{"v":-7000,"d":"-7,000"},{"v":-9000,"d":"-9,000"},{"v":-12000,"d":"-12,000"},{"v":-12000,"d":"-12,000"}]
[null,"Other uses",null,0,0,0,0]
[null,"Total uses",null,{"v":-12000,"d":"-$12,000"},{"v":-14000,"d":"-$14,000"},{"v":-17000,"d":"-$17,000"},{"v":-17000,"d":"-$17,000"}]
[]
[null,"Net change in cash",null,{"v":758550,"d":"758,550"},{"v":1015250,"d":"1,015,250"},{"v":992210,"d":"992,210"},{"v":1063880,"d":"1,063,880"}]
[]
[null,"Cumulative cash",null,{"v":758550,"d":"758,550"},{"v":1773800,"d":"1,773,800"},{"v":2766010,"d":"2,766,010"},{"v":3829890,"d":"3,829,890"}]
[]
[null,"Beginning balance",null,{"v":50000,"d":"$50,000"},{"v":808550,"d":"$808,550"},{"v":1823800,"d":"$1,823,800"},{"v":2816010,"d":"$2,816,010"}]
[null,"Ending balance",null,{"v":808550,"d":"$808,550"},{"v":1823800,"d":"$1,823,800"},{"v":2816010,"d":"$2,816,010"},{"v":3879890,"d":"$3,879,890"}]
[]
[]
[]
[null,"Summary trend data for chart",null,"Q1","Q2","Q3","Q4"]
[null,"Quarterly revenue",null,{"v":4500000,"d":"4,500,000"},{"v":5000000,"d":"5,000,000"},{"v":5200000,"d":"5,200,000"},{"v":5500000,"d":"5,500,000"}]
[null,"Quarterly margin",null,{"v":3500000,"d":"3,500,000"},{"v":3900000,"d":"3,900,000"},{"v":4000000,"d":"4,000,000"},{"v":4200000,"d":"4,200,000"}]
[null,"Quarterly net income (loss)",null,{"v":737950,"d":"737,950"},{"v":996200,"d":"996,200"},{"v":975560,"d":"975,560"},{"v":1046630,"d":"1,046,630"}]
[null,"Quarterly cash flow",null,{"v":758550,"d":"758,550"},{"v":1015250,"d":"1,015,250"},{"v":992210,"d":"992,210"},{"v":1063880,"d":"1,063,880"}]
[null,"Quarterly total assets",null,{"v":2227950,"d":"2,227,950"},{"v":3219150,"d":"3,219,150"},{"v":4189710,"d":"4,189,710"},{"v":5231340,"d":"5,231,340"}]