{"text_format":"2","workbook":"xlsx","n_sheets":5,"sheets":["Budget","One-Column Budget","Scenario Budget Template","Budget By Program Template","Cashflow"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":2,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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":"Budget","index":0,"n_rows":60,"n_cols":7,"rows_kept":60,"cut":false,"hidden":true,"merged":[]}
["Money Monster Theater Company"]
["2017 Budget"]
[]
[{"$nulls":6},"2017 BUDGET"]
["Income"]
[null,"Contributed Income"]
[null,null,"Corporate Donations",null,null,null,0]
[null,null,"Foundation Contributions",null,null,null,0]
[null,null,"Gov't Contributions",null,null,null,0]
[null,null,"Individual Donations"]
[null,null,null,"Board Giving",null,null,0]
[null,null,null,"Individual Giving",null,null,0]
[null,null,"Total Individual Donations",null,null,null,{"$f":"SUM(G11:G12)","v":0}]
[null,"Total Contributed Income",{"$nulls":4},{"$f":"SUM(G7:G9)+G13","v":0}]
[null,"Earned Income"]
[null,null,"Advertising",null,null,null,0]
[null,null,"Interest",null,null,null,0]
[null,null,"Rentals",null,null,null,0]
[null,null,"Ticket Sales",null,null,null,0]
[null,null,"Workshops",null,null,null,0]
[null,"Total Earned Income",{"$nulls":4},{"$f":"SUM(G16:G20)","v":0}]
["Total Income",{"$nulls":5},{"$f":"G14+G21","v":0}]
[]
["Expenses"]
[null,"Personnel Expenses"]
[null,null,"Salaries & Benefits",null,null,null,0]
[null,null,"Contractors"]
[null,null,null,"Admin Contractors"]
[{"$nulls":4},"Managing Director",null,0]
[{"$nulls":4},"Admin Assistant",null,0]
[null,null,null,"Total Admin Contractors",null,null,{"$f":"SUM(G29:G30)","v":0}]
[null,null,null,"Artistic Contractors"]
[{"$nulls":4},"Actors",null,0]
[{"$nulls":4},"Designers",null,0]
[{"$nulls":4},"Directors",null,0]
[{"$nulls":4},"Playwrights",null,0]
[null,null,null,"Total Artistic Contractors",null,null,{"$f":"SUM(G33:G36)","v":0}]
[null,null,null,"Program Contractors"]
[{"$nulls":4},"Box Office",null,0]
[{"$nulls":4},"Stage Manager",null,0]
[{"$nulls":4},"Tech Director",null,0]
[null,null,null,"Total Program Contractors",null,null,{"$f":"SUM(G39:G41)","v":0}]
[null,null,"Total Contractors",null,null,null,{"$f":"SUM(G31+G37+G42)","v":0}]
[null,"Operating Expenses"]
[null,null,"Advertising & Marketing",null,null,null,0]
[null,null,"Catering & Hospitality",null,null,null,0]
[null,null,"Insurance",null,null,null,0]
[null,null,"Office Supplies",null,null,null,0]
[null,null,"Printing & Copying",null,null,null,0]
[null,null,"Postage & Shipping",null,null,null,0]
[null,null,"Rent & Utilities",null,null,null,0]
[null,null,"Travel",null,null,null,0]
[null,"Total Operating Expenses",{"$nulls":4},{"$f":"SUM(G45:G52)","v":0}]
[null,"Program Expenses"]
[null,null,"Costumes",null,null,null,0]
[null,null,"Program Supplies & Materials",null,null,null,0]
[null,null,"Space & Theatre Rental",null,null,null,0]
[null,"Total Program Expenses",{"$nulls":4},{"$f":"SUM(G55:G57)","v":0}]
["Total Expenses",{"$nulls":5},{"$f":"SUM(G43+G53+G58)","v":0}]
["NET FOR YEAR",{"$nulls":5},{"$f":"G22-G59","v":0}]

{"sheet":"One-Column Budget","index":1,"n_rows":114,"n_cols":6,"rows_kept":114,"cut":false,"hidden":false,"merged":[[1,0,1,4]]}
["Budget Template: One-Column or Operating Budget"]
[]
[{"$nulls":5},"TOTAL BUDGET"]
["Income"]
[null,"Earned Income"]
[null,null,"Advertising Revenue",null,null,0]
[null,null,"Concessions"]
[null,null,null,"Concessions Revenue",null,0]
[null,null,null,"Concessions Expense",null,0]
[null,null,"Total Concessions (Net)",null,null,{"$f":"SUM(F8:F9)","v":0}]
[null,null,"Interest & Dividends",null,null,0]
[null,null,"Merchandise Sales",null,null,0]
[null,null,"Ticket Sales",null,null,0]
[null,null,"Teaching & Education Income",null,null,0]
[null,null,"Other Earned Income",null,null,0]
[null,"Total Earned Income",null,null,null,{"$f":"F6+SUM(F10:F15)","v":0}]
[null,"Contributed Income"]
[null,null,"Corporate Donations",null,null,0]
[null,null,"Foundation Contributions"]
["Optional",null,null,"Foundation Unrestricted",null,0]
["Optional",null,null,"Foundation Released From Restriction",null,0]
[null,null,"Total Foundation Contributions",null,null,{"$f":"SUM(F20:F21)","v":0}]
[null,null,"Gov't Contributions"]
["Optional",null,null,"Local Gov't ",null,0]
["Optional",null,null,"State Gov't",null,0]
["Optional",null,null,"Federal Gov't",null,0]
["Optional",null,null,"Gov't Released From Restriction",null,0]
[null,null,"Total Gov't Contributions",null,null,{"$f":"SUM(F24:F27)","v":0}]
[null,null,"Individual Donations"]
[null,null,null,"Board Giving",null,0]
["Optional",null,null,"Donor-Advised Funds & Workplace Giving",null,0]
[null,null,null,"Individual Giving",null,0]
[null,null,"Total Individual Donations",null,null,{"$f":"SUM(F30:F32)","v":0}]
[null,null,"In-Kind Donations"]
["Optional",null,"Fundraising Events"]
["Optional",null,null,"Gala Donations",null,0]
["Optional",null,null,"Gala Tickets",null,0]
["Optional",null,null,"Gala Expenses",null,0]
["Optional",null,"Total Fundraising Events (Net)",null,null,{"$f":"SUM(F36:F38)","v":0}]
[null,"Total Contributed Income",null,null,null,{"$f":"F18+F22+F28+F33+F34+F39","v":0}]
["Total Income",{"$nulls":4},{"$f":"F40+F16","v":0}]
["Expenses"]
[null,"Personnel Expenses"]
[null,null,"Salaries & Benefits"]
[null,null,null,"Salaries"]
[{"$nulls":4},"Executive Director",0]
[{"$nulls":4},"Artistic Director",0]
[{"$nulls":4},"Other Salaries",0]
[null,null,null,"Total Salaries",null,{"$f":"SUM(F46:F48)","v":0}]
[null,null,null,"Benefits"]
[{"$nulls":4},"Employer Payroll Taxes",0]
[{"$nulls":4},"Workers Comp",0]
[null,null,null,"Total Benefits",null,{"$f":"SUM(F51:F52)","v":0}]
[null,null,"Total Salaries & Benefits",null,null,{"$f":"F49+F53","v":0}]
[null,null,"Contractors"]
[null,null,null,"Admin Contractors"]
[{"$nulls":4},"Bookkeeping & Accounting",0]
[{"$nulls":4},"Grantwriter",0]
[{"$nulls":4},"Legal",0]
[{"$nulls":4},"Professional Development Consultants",0]
[{"$nulls":4},"Other Admin Contractors",0]
[null,null,null,"Total Admin Contractors",null,{"$f":"SUM(F57:F61)","v":0}]
[null,null,null,"Artistic Contractors"]
[{"$nulls":4},"Actors"]
[{"$nulls":4},"Composers",0]
[{"$nulls":4},"Designers",0]
[{"$nulls":4},"Directors",0]
[{"$nulls":4},"Musicians",0]
[{"$nulls":4},"Photo & Video",0]
[{"$nulls":4},"Other Artistic Contractors",0]
[null,null,null,"Total Artistic Contractors",null,{"$f":"SUM(F64:F70)","v":0}]
[null,null,null,"Program Contractors"]
[{"$nulls":4},"Crew",0]
[{"$nulls":4},"Production & Stage Management",0]
[{"$nulls":4},"Tech ",0]
[{"$nulls":4},"Other Program Contractors",0]
[null,null,null,"Total Program Contractors",null,{"$f":"SUM(F73:F76)","v":0}]
[null,null,"Total Contractors",null,null,{"$f":"F62+F71+F77","v":0}]
[null,"Total Personnel Expenses",null,null,null,{"$f":"F54+F78","v":0}]
[null,"Marketing Expenses"]
[null,null,"Advertising Expenses",null,null,0]
[null,null,"Graphic & Web Design",null,null,0]
[null,null,"Marketing Printing & Copying",null,null,0]
[null,null,"Online Marketing & Website",null,null,0]
[null,null,"Publicist & PR",null,null,0]
[null,"Total Marketing Expenses",null,null,null,{"$f":"SUM(F81:F85)","v":0}]
[null,"General & Adminstrative Expenses"]
[null,null,"Catering & Hospitality",null,null,0]
[null,null,"Conferences & Professional Development",null,null,0]
[null,null,"Dues & Memberships",null,null,0]
[null,null,"Insurance",null,null,0]
[null,null,"Licenses, Fees & Taxes",null,null,0]
[null,null,"Occupancy, Rent & Utilities",null,null,0]
[null,null,"Office Supplies & Software",null,null,0]
[null,null,"Payroll Fees",null,null,0]
[null,null,"Postage, Printing & Shipping",null,null,0]
[null,null,"Printing & Copying",null,null,0]
[null,null,"Staff Travel",null,null,0]
[null,null,"Telephone & Internet",null,null,0]
[null,null,"Other Operating Expenses",null,null,0]
[null,"Total General & Adminstrative Expenses",null,null,null,{"$f":"SUM(F88:F100)","v":0}]
[null,"Program Expenses"]
[null,null,"Costumes",null,null,0]
[null,null,"Program Catering & Hospitality",null,null,0]
[null,null,"Program Postage, Printing & Shipping",null,null,0]
[null,null,"Program Printing & Copying",null,null,0]
[null,null,"Program Supplies & Equipment",null,null,0]
[null,null,"Program Travel",null,null,0]
[null,null,"Prop & Set Expenses",null,null,0]
[null,null,"Venue Rental",null,null,0]
[null,null,"Other Program Expenses",null,null,0]
[null,"Total Program Expenses",null,null,null,{"$f":"SUM(F103:F111)","v":0}]
["Total Expenses",{"$nulls":4},{"$f":"SUM(F79+F101+F86+F112)","v":0}]
["NET FOR YEAR",{"$nulls":4},{"$f":"F41-F113","v":0}]

{"sheet":"Scenario Budget Template","index":2,"n_rows":115,"n_cols":8,"rows_kept":115,"cut":false,"hidden":false,"merged":[[1,0,1,4]]}
["Budget Template: \"Three Bears\" or Scenario Budget"]
[]
[{"$nulls":5},"Too Hot","Too Cold","Just Right"]
[{"$nulls":5},"BEST CASE SCENARIO","WORST CASE SCENARIO","PLAUSIBLE SCENARIO"]
["Income"]
[null,"Earned Income"]
[null,null,"Advertising Revenue",null,null,0,0,0]
[null,null,"Concessions"]
[null,null,null,"Concessions Revenue",null,0,0,0]
[null,null,null,"Concessions Expense",null,0,0,0]
[null,null,"Total Concessions (Net)",null,null,{"$f":"SUM(F9:F10)","v":0},{"$f":"SUM(G9:G10)","v":0},{"$f":"SUM(H9:H10)","v":0}]
[null,null,"Interest & Dividends",null,null,0,0,0]
[null,null,"Merchandise Sales",null,null,0,0,0]
[null,null,"Ticket Sales",null,null,0,0,0]
[null,null,"Teaching & Education Income",null,null,0,0,0]
[null,null,"Other Earned Income",null,null,0,0,0]
[null,"Total Earned Income",null,null,null,{"$f":"F7+SUM(F11:F16)","v":0},{"$f":"G7+SUM(G11:G16)","v":0},{"$f":"H7+SUM(H11:H16)","v":0}]
[null,"Contributed Income"]
[null,null,"Corporate Donations",null,null,0,0,0]
[null,null,"Foundation Contributions"]
[null,null,null,"Foundation Unrestricted",null,0,0,0]
[null,null,null,"Foundation Released From Restriction",null,0,0,0]
[null,null,"Total Foundation Contributions",null,null,{"$f":"SUM(F21:F22)","v":0},{"$f":"SUM(G21:G22)","v":0},{"$f":"SUM(H21:H22)","v":0}]
[null,null,"Gov't Contributions"]
[null,null,null,"Local Gov't ",null,0,0,0]
[null,null,null,"State Gov't",null,0,0,0]
[null,null,null,"Federal Gov't",null,0,0,0]
[null,null,null,"Gov't Released From Restriction",null,0,0,0]
[null,null,"Total Gov't Contributions",null,null,{"$f":"SUM(F25:F28)","v":0},{"$f":"SUM(G25:G28)","v":0},{"$f":"SUM(H25:H28)","v":0}]
[null,null,"Individual Donations"]
[null,null,null,"Board Giving",null,0,0,0]
[null,null,null,"Donor-Advised Funds & Workplace Giving",null,0,0,0]
[null,null,null,"Individual Giving",null,0,0,0]
[null,null,"Total Individual Donations",null,null,{"$f":"SUM(F31:F33)","v":0},{"$f":"SUM(G31:G33)","v":0},{"$f":"SUM(H31:H33)","v":0}]
[null,null,"In-Kind Donations"]
[null,null,"Fundraising Events"]
[null,null,null,"Gala Donations",null,0,0,0]
[null,null,null,"Gala Tickets",null,0,0,0]
[null,null,null,"Gala Expenses",null,0,0,0]
[null,null,"Total Fundraising Events (Net)",null,null,{"$f":"SUM(F37:F39)","v":0},{"$f":"SUM(G37:G39)","v":0},{"$f":"SUM(H37:H39)","v":0}]
[null,"Total Contributed Income",null,null,null,{"$f":"F19+F23+F29+F34+F35+F40","v":0},{"$f":"G19+G23+G29+G34+G35+G40","v":0},{"$f":"H19+H23+H29+H34+H35+H40","v":0}]
["Total Income",{"$nulls":4},{"$f":"F41+F17","v":0},{"$f":"G41+G17","v":0},{"$f":"H41+H17","v":0}]
["Expenses"]
[null,"Personnel Expenses"]
[null,null,"Salaries & Benefits"]
[null,null,null,"Salaries"]
[{"$nulls":4},"Executive Director",0,0,0]
[{"$nulls":4},"Artistic Director",0,0,0]
[{"$nulls":4},"Other Salaries",0,0,0]
[null,null,null,"Total Salaries",null,{"$f":"SUM(F47:F49)","v":0},{"$f":"SUM(G47:G49)","v":0},{"$f":"SUM(H47:H49)","v":0}]
[null,null,null,"Benefits"]
[{"$nulls":4},"Employer Payroll Taxes",0,0,0]
[{"$nulls":4},"Workers Comp",0,0,0]
[null,null,null,"Total Benefits",null,{"$f":"SUM(F52:F53)","v":0},{"$f":"SUM(G52:G53)","v":0},{"$f":"SUM(H52:H53)","v":0}]
[null,null,"Total Salaries & Benefits",null,null,{"$f":"F50+F54","v":0},{"$f":"G50+G54","v":0},{"$f":"H50+H54","v":0}]
[null,null,"Contractors"]
[null,null,null,"Admin Contractors"]
[{"$nulls":4},"Bookkeeping & Accounting",0,0,0]
[{"$nulls":4},"Grantwriter",0,0,0]
[{"$nulls":4},"Legal",0,0,0]
[{"$nulls":4},"Professional Development Consultants",0,0,0]
[{"$nulls":4},"Other Admin Contractors",0,0,0]
[null,null,null,"Total Admin Contractors",null,{"$f":"SUM(F58:F62)","v":0},{"$f":"SUM(G58:G62)","v":0},{"$f":"SUM(H58:H62)","v":0}]
[null,null,null,"Artistic Contractors"]
[{"$nulls":4},"Actors"]
[{"$nulls":4},"Composers",0,0,0]
[{"$nulls":4},"Designers",0,0,0]
[{"$nulls":4},"Directors",0,0,0]
[{"$nulls":4},"Musicians",0,0,0]
[{"$nulls":4},"Photo & Video",0,0,0]
[{"$nulls":4},"Other Artistic Contractors",0,0,0]
[null,null,null,"Total Artistic Contractors",null,{"$f":"SUM(F65:F71)","v":0},{"$f":"SUM(G65:G71)","v":0},{"$f":"SUM(H65:H71)","v":0}]
[null,null,null,"Program Contractors"]
[{"$nulls":4},"Crew",0,0,0]
[{"$nulls":4},"Production & Stage Management",0,0,0]
[{"$nulls":4},"Tech ",0,0,0]
[{"$nulls":4},"Other Program Contractors",0,0,0]
[null,null,null,"Total Program Contractors",null,{"$f":"SUM(F74:F77)","v":0},{"$f":"SUM(G74:G77)","v":0},{"$f":"SUM(H74:H77)","v":0}]
[null,null,"Total Contractors",null,null,{"$f":"F63+F72+F78","v":0},{"$f":"G63+G72+G78","v":0},{"$f":"H63+H72+H78","v":0}]
[null,"Total Personnel Expenses",null,null,null,{"$f":"F55+F79","v":0},{"$f":"G55+G79","v":0},{"$f":"H55+H79","v":0}]
[null,"Marketing Expenses"]
[null,null,"Advertising Expenses",null,null,0,0,0]
[null,null,"Graphic & Web Design",null,null,0,0,0]
[null,null,"Marketing Printing & Copying",null,null,0,0,0]
[null,null,"Online Marketing & Website",null,null,0,0,0]
[null,null,"Publicist & PR",null,null,0,0,0]
[null,"Total Marketing Expenses",null,null,null,{"$f":"SUM(F82:F86)","v":0},{"$f":"SUM(G82:G86)","v":0},{"$f":"SUM(H82:H86)","v":0}]
[null,"General & Adminstrative Expenses"]
[null,null,"Catering & Hospitality",null,null,0,0,0]
[null,null,"Conferences & Professional Development",null,null,0,0,0]
[null,null,"Dues & Memberships",null,null,0,0,0]
[null,null,"Insurance",null,null,0,0,0]
[null,null,"Licenses, Fees & Taxes",null,null,0,0,0]
[null,null,"Occupancy, Rent & Utilities",null,null,0,0,0]
[null,null,"Office Supplies & Software",null,null,0,0,0]
[null,null,"Payroll Fees",null,null,0,0,0]
[null,null,"Postage, Printing & Shipping",null,null,0,0,0]
[null,null,"Printing & Copying",null,null,0,0,0]
[null,null,"Staff Travel",null,null,0,0,0]
[null,null,"Telephone & Internet",null,null,0,0,0]
[null,null,"Other Operating Expenses",null,null,0,0,0]
[null,"Total General & Adminstrative Expenses",null,null,null,{"$f":"SUM(F89:F101)","v":0},{"$f":"SUM(G89:G101)","v":0},{"$f":"SUM(H89:H101)","v":0}]
[null,"Program Expenses"]
[null,null,"Costumes",null,null,0,0,0]
[null,null,"Program Catering & Hospitality",null,null,0,0,0]
[null,null,"Program Postage, Printing & Shipping",null,null,0,0,0]
[null,null,"Program Printing & Copying",null,null,0,0,0]
[null,null,"Program Supplies & Equipment",null,null,0,0,0]
[null,null,"Program Travel",null,null,0,0,0]
[null,null,"Prop & Set Expenses",null,null,0,0,0]
[null,null,"Venue Rental",null,null,0,0,0]
[null,null,"Other Program Expenses",null,null,0,0,0]
[null,"Total Program Expenses",null,null,null,{"$f":"SUM(F104:F112)","v":0},{"$f":"SUM(G104:G112)","v":0},{"$f":"SUM(H104:H112)","v":0}]
["Total Expenses",{"$nulls":4},{"$f":"SUM(F80+F102+F87+F113)","v":0},{"$f":"SUM(G80+G102+G87+G113)","v":0},{"$f":"SUM(H80+H102+H87+H113)","v":0}]
["NET FOR YEAR",{"$nulls":4},{"$f":"F42-F114","v":0},{"$f":"G42-G114","v":0},{"$f":"H42-H114","v":0}]

{"sheet":"Budget By Program Template","index":3,"n_rows":114,"n_cols":9,"rows_kept":114,"cut":false,"hidden":false,"merged":[[1,0,1,4]]}
["Budget Template: Budget by Program"]
[]
[{"$nulls":5},"G&A","Fundraising","Program","TOTAL BUDGET"]
["Income"]
[null,"Earned Income"]
[null,null,"Advertising Revenue",null,null,0,0,0,{"$f":"SUM(F6:H6)","v":0}]
[null,null,"Concessions"]
[null,null,null,"Concessions Revenue",null,0,0,0,{"$f":"SUM(F8:H8)","v":0}]
[null,null,null,"Concessions Expense",null,0,0,0,{"$f":"SUM(F9:H9)","v":0}]
[null,null,"Total Concessions (Net)",null,null,{"$f":"SUM(F8:F9)","v":0},{"$f":"SUM(G8:G9)","v":0},{"$f":"SUM(H8:H9)","v":0},{"$f":"SUM(F10:H10)","v":0}]
[null,null,"Interest & Dividends",null,null,0,0,0,{"$f":"SUM(F11:H11)","v":0}]
[null,null,"Merchandise Sales",null,null,0,0,0,{"$f":"SUM(F12:H12)","v":0}]
[null,null,"Ticket Sales",null,null,0,0,0,{"$f":"SUM(F13:H13)","v":0}]
[null,null,"Teaching & Education Income",null,null,0,0,0,{"$f":"SUM(F14:H14)","v":0}]
[null,null,"Other Earned Income",null,null,0,0,0,{"$f":"SUM(F15:H15)","v":0}]
[null,"Total Earned Income",null,null,null,{"$f":"F6+SUM(F10:F15)","v":0},{"$f":"G6+SUM(G10:G15)","v":0},{"$f":"H6+SUM(H10:H15)","v":0},{"$f":"SUM(F16:H16)","v":0}]
[null,"Contributed Income"]
[null,null,"Corporate Donations",null,null,0,0,0,{"$f":"SUM(F18:H18)","v":0}]
[null,null,"Foundation Contributions"]
[null,null,null,"Foundation Unrestricted",null,0,0,0,{"$f":"SUM(F20:H20)","v":0}]
[null,null,null,"Foundation Released From Restriction",null,0,0,0,0]
[null,null,"Total Foundation Contributions",null,null,{"$f":"SUM(F20:F21)","v":0},{"$f":"SUM(G20:G21)","v":0},{"$f":"SUM(H20:H21)","v":0},0]
[null,null,"Gov't Contributions"]
[null,null,null,"Local Gov't ",null,0,0,0,0]
[null,null,null,"State Gov't",null,0,0,0,0]
[null,null,null,"Federal Gov't",null,0,0,0,0]
[null,null,null,"Gov't Released From Restriction",null,0,0,0,0]
[null,null,"Total Gov't Contributions",null,null,{"$f":"SUM(F24:F27)","v":0},{"$f":"SUM(G24:G27)","v":0},{"$f":"SUM(H24:H27)","v":0},0]
[null,null,"Individual Donations"]
[null,null,null,"Board Giving",null,0,0,0,0]
[null,null,null,"Donor-Advised Funds & Workplace Giving",null,0,0,0,0]
[null,null,null,"Individual Giving",null,0,0,0,0]
[null,null,"Total Individual Donations",null,null,{"$f":"SUM(F30:F32)","v":0},{"$f":"SUM(G30:G32)","v":0},{"$f":"SUM(H30:H32)","v":0},0]
[null,null,"In-Kind Donations"]
[null,null,"Fundraising Events"]
[null,null,null,"Gala Donations",null,0,0,0,0]
[null,null,null,"Gala Tickets",null,0,0,0,0]
[null,null,null,"Gala Expenses",null,0,0,0,0]
[null,null,"Total Fundraising Events (Net)",null,null,{"$f":"SUM(F36:F38)","v":0},{"$f":"SUM(G36:G38)","v":0},{"$f":"SUM(H36:H38)","v":0},0]
[null,"Total Contributed Income",null,null,null,{"$f":"F18+F22+F28+F33+F34+F39","v":0},{"$f":"G18+G22+G28+G33+G34+G39","v":0},{"$f":"H18+H22+H28+H33+H34+H39","v":0},0]
["Total Income",{"$nulls":4},{"$f":"F40+F16","v":0},{"$f":"G40+G16","v":0},{"$f":"H40+H16","v":0},0]
["Expenses"]
[null,"Personnel Expenses"]
[null,null,"Salaries & Benefits"]
[null,null,null,"Salaries"]
[{"$nulls":4},"Executive Director",0,0,0,0]
[{"$nulls":4},"Artistic Director",0,0,0,0]
[{"$nulls":4},"Other Salaries",0,0,0,0]
[null,null,null,"Total Salaries",null,{"$f":"SUM(F46:F48)","v":0},{"$f":"SUM(G46:G48)","v":0},{"$f":"SUM(H46:H48)","v":0},0]
[null,null,null,"Benefits"]
[{"$nulls":4},"Employer Payroll Taxes",0,0,0,0]
[{"$nulls":4},"Workers Comp",0,0,0,0]
[null,null,null,"Total Benefits",null,{"$f":"SUM(F51:F52)","v":0},{"$f":"SUM(G51:G52)","v":0},{"$f":"SUM(H51:H52)","v":0},0]
[null,null,"Total Salaries & Benefits",null,null,{"$f":"F49+F53","v":0},{"$f":"G49+G53","v":0},{"$f":"H49+H53","v":0},0]
[null,null,"Contractors"]
[null,null,null,"Admin Contractors"]
[{"$nulls":4},"Bookkeeping & Accounting",0,0,0,0]
[{"$nulls":4},"Grantwriter",0,0,0,0]
[{"$nulls":4},"Legal",0,0,0,0]
[{"$nulls":4},"Professional Development Consultants",0,0,0,0]
[{"$nulls":4},"Other Admin Contractors",0,0,0,0]
[null,null,null,"Total Admin Contractors",null,{"$f":"SUM(F57:F61)","v":0},{"$f":"SUM(G57:G61)","v":0},{"$f":"SUM(H57:H61)","v":0},0]
[null,null,null,"Artistic Contractors"]
[{"$nulls":4},"Actors",null,null,null,0]
[{"$nulls":4},"Composers",0,0,0,0]
[{"$nulls":4},"Designers",0,0,0,0]
[{"$nulls":4},"Directors",0,0,0,0]
[{"$nulls":4},"Musicians",0,0,0,0]
[{"$nulls":4},"Photo & Video",0,0,0,0]
[{"$nulls":4},"Other Artistic Contractors",0,0,0,0]
[null,null,null,"Total Artistic Contractors",null,{"$f":"SUM(F64:F70)","v":0},{"$f":"SUM(G64:G70)","v":0},{"$f":"SUM(H64:H70)","v":0},{"$f":"SUM(F71:H71)","v":0}]
[null,null,null,"Program Contractors"]
[{"$nulls":4},"Crew",0,0,0,0]
[{"$nulls":4},"Production & Stage Management",0,0,0,0]
[{"$nulls":4},"Tech ",0,0,0,0]
[{"$nulls":4},"Other Program Contractors",0,0,0,0]
[null,null,null,"Total Program Contractors",null,{"$f":"SUM(F73:F76)","v":0},{"$f":"SUM(G73:G76)","v":0},{"$f":"SUM(H73:H76)","v":0},0]
[null,null,"Total Contractors",null,null,{"$f":"F62+F71+F77","v":0},{"$f":"G62+G71+G77","v":0},{"$f":"H62+H71+H77","v":0},0]
[null,"Total Personnel Expenses",null,null,null,{"$f":"F54+F78","v":0},{"$f":"G54+G78","v":0},{"$f":"H54+H78","v":0},0]
[null,"Marketing Expenses"]
[null,null,"Advertising Expenses",null,null,0,0,0,0]
[null,null,"Graphic & Web Design",null,null,0,0,0,0]
[null,null,"Marketing Printing & Copying",null,null,0,0,0,0]
[null,null,"Online Marketing & Website",null,null,0,0,0,0]
[null,null,"Publicist & PR",null,null,0,0,0,0]
[null,"Total Marketing Expenses",null,null,null,{"$f":"SUM(F81:F85)","v":0},{"$f":"SUM(G81:G85)","v":0},{"$f":"SUM(H81:H85)","v":0},0]
[null,"General & Adminstrative Expenses"]
[null,null,"Catering & Hospitality",null,null,0,0,0,0]
[null,null,"Conferences & Professional Development",null,null,0,0,0,0]
[null,null,"Dues & Memberships",null,null,0,0,0,0]
[null,null,"Insurance",null,null,0,0,0,0]
[null,null,"Licenses, Fees & Taxes",null,null,0,0,0,0]
[null,null,"Occupancy, Rent & Utilities",null,null,0,0,0,0]
[null,null,"Office Supplies & Software",null,null,0,0,0,0]
[null,null,"Payroll Fees",null,null,0,0,0,0]
[null,null,"Postage, Printing & Shipping",null,null,0,0,0,0]
[null,null,"Printing & Copying",null,null,0,0,0,0]
[null,null,"Staff Travel",null,null,0,0,0,0]
[null,null,"Telephone & Internet",null,null,0,0,0,0]
[null,null,"Other Operating Expenses",null,null,0,0,0,0]
[null,"Total General & Adminstrative Expenses",null,null,null,{"$f":"SUM(F88:F100)","v":0},{"$f":"SUM(G88:G100)","v":0},{"$f":"SUM(H88:H100)","v":0},0]
[null,"Program Expenses"]
[null,null,"Costumes",null,null,0,0,0,0]
[null,null,"Program Catering & Hospitality",null,null,0,0,0,0]
[null,null,"Program Postage, Printing & Shipping",null,null,0,0,0,0]
[null,null,"Program Printing & Copying",null,null,0,0,0,0]
[null,null,"Program Supplies & Equipment",null,null,0,0,0,0]
[null,null,"Program Travel",null,null,0,0,0,0]
[null,null,"Prop & Set Expenses",null,null,0,0,0,0]
[null,null,"Venue Rental",null,null,0,0,0,0]
[null,null,"Other Program Expenses",null,null,0,0,0,0]
[null,"Total Program Expenses",null,null,null,{"$f":"SUM(F103:F111)","v":0},{"$f":"SUM(G103:G111)","v":0},{"$f":"SUM(H103:H111)","v":0},0]
["Total Expenses",{"$nulls":4},{"$f":"SUM(F79+F101+F86+F112)","v":0},{"$f":"SUM(G79+G101+G86+G112)","v":0},{"$f":"SUM(H79+H101+H86+H112)","v":0},0]
["NET FOR YEAR",{"$nulls":4},{"$f":"F41-F113","v":0},{"$f":"G41-G113","v":0},{"$f":"H41-H113","v":0},0]

{"sheet":"Cashflow","index":4,"n_rows":62,"n_cols":11,"rows_kept":62,"cut":false,"hidden":true,"merged":[[3,0,3,5]]}
["Money Monster Theater Company"]
["2017 Sample Cashflow"]
[]
["Cash in Bank Account at 1/1/16: $10,025"]
[{"$nulls":6},"Q1","Q2","Q3","Q4","TOTAL"]
["Income",{"$nulls":4},"Starting Cash",10025,{"$f":"G61","v":9169},{"$f":"H61","v":7088},{"$f":"I61","v":10122}]
[null,"Contributed Income"]
[null,null,"Corporate Donations",null,null,null,0,250,250,0,{"$f":"SUM(G8:J8)","v":500}]
[null,null,"Foundation Contributions",null,null,null,0,5000,0,5000,10000]
[null,null,"Gov't Contributions",null,null,null,2500,0,0,0,2500]
[null,null,"Individual Donations"]
[null,null,null,"Board Giving",null,null,{"$f":"1500/4","v":375},{"$f":"1500/4","v":375},{"$f":"1500/4","v":375},{"$f":"1500/4","v":375},{"$f":"SUM(G12:J12)","v":1500}]
[null,null,null,"Individual Giving",null,null,500,3000,4000,500,8000]
[null,null,"Total Individual Donations",null,null,null,{"$f":"SUM(G12:G13)","v":875},3375,4375,875,9500]
[null,"Total Contributed Income",{"$nulls":4},{"$f":"SUM(G8:G10)+G14","v":3375},8625,4625,5875,22500]
[null,"Earned Income"]
[null,null,"Advertising",null,null,null,0,250,250,0,{"$f":"SUM(G17:J17)","v":500}]
[null,null,"Interest",null,null,null,4,4,4,3,15]
[null,null,"Rentals",null,null,null,700,700,700,700,2800]
[null,null,"Ticket Sales",null,null,null,0,1000,7000,0,8000]
[null,null,"Workshops",null,null,null,1250,1250,1250,1250,5000]
[null,"Total Earned Income",{"$nulls":4},{"$f":"SUM(G17:G21)","v":1954},3204,9204,1953,16315]
["Total Income",{"$nulls":5},{"$f":"G15+G22","v":5329},11829,13829,7828,38815]
[]
["Expenses"]
[null,"Personnel Expenses"]
[null,null,"Salaries & Benefits",null,null,null,0,0,0,0,{"$f":"SUM(G27:J27)","v":0}]
[null,null,"Contractors"]
[null,null,null,"Admin Contractors"]
[{"$nulls":4},"Managing Director",null,{"$f":"6000/4","v":1500},{"$f":"6000/4","v":1500},{"$f":"6000/4","v":1500},{"$f":"6000/4","v":1500},{"$f":"SUM(G30:J30)","v":6000}]
[{"$nulls":4},"Admin Assistant",null,600,600,600,600,2400]
[null,null,null,"Total Admin Contractors",null,null,{"$f":"SUM(G30:G31)","v":2100},2100,2100,2100,8400]
[null,null,null,"Artistic Contractors"]
[{"$nulls":4},"Actors",null,0,1200,1600,0,{"$f":"SUM(G34:J34)","v":2800}]
[{"$nulls":4},"Designers",null,0,200,800,0,1000]
[{"$nulls":4},"Directors",null,0,500,1000,0,1500]
[{"$nulls":4},"Playwrights",null,500,500,0,0,1000]
[null,null,null,"Total Artistic Contractors",null,null,{"$f":"SUM(G34:G37)","v":500},2400,3400,0,6300]
[null,null,null,"Program Contractors"]
[{"$nulls":4},"Box Office",null,0,0,250,0,{"$f":"SUM(G40:J40)","v":250}]
[{"$nulls":4},"Stage Manager",null,0,0,250,0,250]
[{"$nulls":4},"Tech Director",null,0,450,450,0,900]
[null,null,null,"Total Program Contractors",null,null,{"$f":"SUM(G40:G42)","v":0},450,950,0,1400]
[null,null,"Total Contractors",null,null,null,{"$f":"SUM(G32+G38+G43)","v":2600},4950,6450,2100,16100]
[null,"Operating Expenses"]
[null,null,"Advertising & Marketing",null,null,null,500,2000,1000,0,{"$f":"SUM(G46:J46)","v":3500}]
[null,null,"Catering & Hospitality",null,null,null,100,150,200,50,500]
[null,null,"Insurance",null,null,null,300,300,300,300,1200]
[null,null,"Office Supplies",null,null,null,160,160,170,160,650]
[null,null,"Printing & Copying",null,null,null,150,250,450,50,900]
[null,null,"Postage & Shipping",null,null,null,50,150,50,50,300]
[null,null,"Rent & Utilities",null,null,null,1200,1200,1200,1200,4800]
[null,null,"Travel",null,null,null,25,50,75,50,200]
[null,"Total Operating Expenses",{"$nulls":4},{"$f":"SUM(G46:G53)","v":2485},4260,3445,1860,12050]
[null,"Program Expenses"]
[null,null,"Costumes",null,null,null,0,300,400,0,{"$f":"SUM(G56:J56)","v":700}]
[null,null,"Program Supplies & Materials",null,null,null,100,400,500,0,1000]
[null,null,"Space & Theatre Rental",null,null,null,1000,4000,0,0,5000]
[null,"Total Program Expenses",{"$nulls":4},{"$f":"SUM(G56:G58)","v":1100},4700,900,0,6700]
["Total Expenses",{"$nulls":5},{"$f":"SUM(G44+G54+G59)","v":6185},13910,10795,3960,34850]
["Running Balance",{"$nulls":5},{"$f":"G6+G23-G60","v":9169},{"$f":"H6+H23-H60","v":7088},{"$f":"I6+I23-I60","v":10122},{"$f":"J6+J23-J60","v":13990},{"$f":"K6+K23-K60","v":3965}]
[{"$nulls":9},"Ending Cash Balance at 12/31/17"]