{"text_format":"2","workbook":"xlsx","n_sheets":4,"sheets":["Budget"," Project Budget","Budget Possibilities","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":" Project Budget","index":1,"n_rows":52,"n_cols":6,"rows_kept":52,"cut":false,"hidden":false,"merged":[[1,0,1,4]]}
["Budget Template: Final Project Budget"]
[]
[]
[{"$nulls":5},"Total Budget"]
["Income"]
[null,"Earned Income"]
[null,null,"Concessions",null,null,0]
[null,null,"Merchandise Sales",null,null,0]
[null,null,"Sponsorships",null,null,0]
[null,null,"Ticket Sales",null,null,0]
[null,null,"Other Earned Income",null,null,0]
[null,"Total Earned Income",null,null,null,{"$f":"SUM(F7:F11)","v":0}]
[null,"Contributed Income"]
[null,null,"Corporate Donations",null,null,0]
[null,null,"Foundation Contributions",null,null,0]
[null,null,"Gov't Contributions",null,null,0]
[null,null,"Individual Donations",null,null,0]
[null,null,"In-Kind Donations",null,null,0]
[null,"Total Contributed Income",null,null,null,{"$f":"SUM(F14:F18)","v":0}]
["Total Income",{"$nulls":4},{"$f":"F19+F12","v":0}]
["Expenses"]
[null,"Personnel Expenses"]
[null,null,"Actors"]
[null,null,"Designers"]
[null,null,"Directors",null,null,0]
[null,null,"Graphic Design",null,null,0]
[null,null,"Production Manager",null,null,0]
[null,null,"Photographers & Videographers",null,null,0]
[null,null,"Stage Manager",null,null,0]
[null,null,"Other Contractors",null,null,{"$f":"SUM(F25:F29)","v":0}]
[null,null,"Total Contractors",null,null,{"$f":"SUM(F23:F30)","v":0}]
[null,"Total Personnel Expenses",null,null,null,{"$f":"F31","v":0}]
[null,"Admin Expenses"]
[null,null,"Insurance",null,null,0]
[null,null,"Office Rent",null,null,0]
[null,null,"Office Supplies & Software",null,null,0]
[null,null,"Printing & Copying",null,null,0]
[null,null,"Telephone & Internet",null,null,0]
[null,null,"Other Admin Expenses",null,null,0]
[null,"Total Admin Expenses",null,null,null,{"$f":"SUM(F34:F39)","v":0}]
[null,"Program Expenses"]
[null,null,"Advertising & Marketing",null,null,0]
[null,null,"Costumes",null,null,0]
[null,null,"Catering & Meals",null,null,0]
[null,null,"Productions Supplies & Equipment",null,null,0]
[null,null,"Production 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(F42:F49)","v":0}]
["Total Expenses",{"$nulls":4},{"$f":"F32+F40+F50","v":0}]
["NET ",{"$nulls":4},{"$f":"F20-F51","v":0}]

{"sheet":"Budget Possibilities","index":2,"n_rows":52,"n_cols":8,"rows_kept":52,"cut":false,"hidden":false,"merged":[[1,0,1,4]]}
["Budget Template: Different Possibilities"]
[]
[]
[{"$nulls":5},"POSSIBILITY 1","POSSIBILITY 2","POSSIBILITY 3"]
["Income"]
[null,"Earned Income"]
[null,null,"Concessions",null,null,0,0,0]
[null,null,"Merchandise Sales",null,null,0,0,0]
[null,null,"Sponsorships",null,null,0,0,0]
[null,null,"Ticket Sales",null,null,0,0,0]
[null,null,"Other Earned Income",null,null,0,0,0]
[null,"Total Earned Income",null,null,null,{"$f":"SUM(F7:F11)","v":0},{"$f":"SUM(G7:G11)","v":0},0]
[null,"Contributed Income"]
[null,null,"Corporate Donations",null,null,0,0,0]
[null,null,"Foundation Contributions",null,null,0,0,0]
[null,null,"Gov't Contributions",null,null,0,0,0]
[null,null,"Individual Donations",null,null,0,0,0]
[null,null,"In-Kind Donations",null,null,0,0,0]
[null,"Total Contributed Income",null,null,null,{"$f":"SUM(F14:F18)","v":0},{"$f":"SUM(G14:G18)","v":0},{"$f":"SUM(H14:H18)","v":0}]
["Total Income",{"$nulls":4},{"$f":"F19+F12","v":0},{"$f":"G19+G12","v":0},{"$f":"H19+H12","v":0}]
["Expenses"]
[null,"Personnel Expenses"]
[null,null,"Actors"]
[null,null,"Designers"]
[null,null,"Directors",null,null,0,0,0]
[null,null,"Graphic Design",null,null,0,0,0]
[null,null,"Production Manager",null,null,0,0,0]
[null,null,"Photographers & Videographers",null,null,0,0,0]
[null,null,"Stage Manager",null,null,0,0,0]
[null,null,"Other Contractors",null,null,{"$f":"SUM(F25:F29)","v":0},{"$f":"SUM(G25:G29)","v":0},{"$f":"SUM(H25:H29)","v":0}]
[null,null,"Total Contractors",null,null,{"$f":"SUM(F23:F30)","v":0},{"$f":"SUM(G23:G30)","v":0},{"$f":"SUM(H23:H30)","v":0}]
[null,"Total Personnel Expenses",null,null,null,{"$f":"F31","v":0},{"$f":"G31","v":0},{"$f":"H31","v":0}]
[null,"Admin Expenses"]
[null,null,"Insurance",null,null,0,0,0]
[null,null,"Office Rent",null,null,0,0,0]
[null,null,"Office Supplies & Software",null,null,0,0,0]
[null,null,"Printing & Copying",null,null,0,0,0]
[null,null,"Telephone & Internet",null,null,0,0,0]
[null,null,"Other Admin Expenses",null,null,0,0,0]
[null,"Total Admin Expenses",null,null,null,{"$f":"SUM(F34:F39)","v":0},{"$f":"SUM(G34:G39)","v":0},{"$f":"SUM(H34:H39)","v":0}]
[null,"Program Expenses"]
[null,null,"Advertising & Marketing",null,null,0,0,0]
[null,null,"Costumes",null,null,0,0,0]
[null,null,"Catering & Meals",null,null,0,0,0]
[null,null,"Productions Supplies & Equipment",null,null,0,0,0]
[null,null,"Production 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(F42:F49)","v":0},{"$f":"SUM(G42:G49)","v":0},{"$f":"SUM(H42:H49)","v":0}]
["Total Expenses",{"$nulls":4},{"$f":"F32+F40+F50","v":0},{"$f":"G32+G40+G50","v":0},{"$f":"H32+H40+H50","v":0}]
["NET ",{"$nulls":4},{"$f":"F20-F51","v":0},{"$f":"G20-G51","v":0},{"$f":"H20-H51","v":0}]

{"sheet":"Cashflow","index":3,"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"]