{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Loan Calculator","Dolphin Show","Scenario Summary","Dolphin Show 2"],"not_rendered":{"charts":0,"images":0,"macros":1,"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":"Loan Calculator","index":0,"n_rows":8,"n_cols":5,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
["CoMo Zoo Park"]
["New Construction Loan Calculator"]
[]
["Park Zone","Qualifying Loan Amount","Loan Length (months)","Annual Interest Rate","Payment Amount (monthly)"]
["Zone 1",387941.70563348953,60,0.06,{"$f":"PMT(D5/12,C5,B5)","v":-7500}]
["Zone 2",200000,48,3.8231489717831683E-2,{"$f":"PMT(D6/12,C6,B6)","v":-4500.0005107131901}]
["Zone 3",1,60,0.06,{"$f":"PMT(D7/12,C7,B7)","v":-1.9332801529427915E-2}]
["Zone 4",1,60,0.06,{"$f":"PMT(D8/12,C8,B8)","v":-1.9332801529427915E-2}]

{"sheet":"Dolphin Show","index":1,"n_rows":13,"n_cols":6,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
["CoMo Zoo Park"]
["Dolphin Show Profit Projections"]
[]
["Ticket price Increase:",0]
[]
[null,"Winter","Spring","Summer","Fall","Total"]
["Exhibit maintenance",-4000,-4000,-5000,-4000,{"$f":"SUM(B7:E7)","v":-17000}]
["Food",-1000,-1000,-1000,-1000,-4000]
["Marketing",-650,-1050,-650,-1050,-3400]
["Staff",-24000,-32000,-53000,-32000,-141000]
["Funding sources",1000,1000,1000,1000,4000]
["Ticket sales",{"$f":"23000+(23000*$B$4)","v":23000},{"$f":"73000+(73000*$B$4)","v":73000},{"$f":"126500+(1265000*$B$4)","v":126500},{"$f":"66000+(66000*$B$4)","v":66000},288500]
["Profit",{"$f":"SUM(B7:B12)","v":-5650},{"$f":"SUM(C7:C12)","v":35950},{"$f":"SUM(D7:D12)","v":67850},{"$f":"SUM(E7:E12)","v":28950},{"$f":"SUM(F7:F12)","v":127100}]

{"sheet":"Scenario Summary","index":2,"n_rows":15,"n_cols":8,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Scenario Summary"]
[null,null,null,"Current Values:","Origianal Project","Increase ticket prices","Current Projections","Reduce marketing funds"]
[null,null,null,null,"Origianl projection with no increase in ticket prices.","Increase dolphin show ticket prices.","Projections based on average costs/profits from previous year.","Reduce monthly marketing budgets."]
[null,"Changing Cells:"]
[null,null,"$B$4",0.1,0,0.1,0.1,0.1]
[null,null,"$B$9",-650,-650,-650,-1650,-650]
[null,null,"$C$9",-1050,-1050,-1050,-1650,-1050]
[null,null,"$D$9",-650,-650,-650,-1650,-650]
[null,null,"$E$9",-1050,-1050,-1050,-1650,-1050]
[null,"Result Cells:"]
[null,null,"$F$13",269800,127100,269800,266600,269800]
[null,"Notes:  Current Values column represents values of changing cells at"]
[null,"time Scenario Summary Report was created.  Changing cells for each"]
[null,"scenario are highlighted in gray."]

{"sheet":"Dolphin Show 2","index":3,"n_rows":13,"n_cols":6,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
["CoMo Zoo Park"]
["Dolphin Show Profit Projections"]
[]
["Ticket price Increase:",0.1]
[]
[null,"Winter","Spring","Summer","Fall","Total"]
["Exhibit maintenance",-4000,-4000,-5000,-4000,{"$f":"SUM(B7:E7)","v":-17000}]
["Food",-1000,-1000,-1000,-1000,-4000]
["Marketing",-650,-1050,-650,-1050,-3400]
["Staff",-24000,-32000,-53000,-32000,-141000]
["Funding sources",1000,1000,1000,1000,4000]
["Ticket sales",{"$f":"23000+(23000*$B$4)","v":25300},{"$f":"73000+(73000*$B$4)","v":80300},{"$f":"126500+(1265000*$B$4)","v":253000},{"$f":"66000+(66000*$B$4)","v":72600},431200]
["Profit",{"$f":"SUM(B7:B12)","v":-3350},{"$f":"SUM(C7:C12)","v":43250},{"$f":"SUM(D7:D12)","v":194350},{"$f":"SUM(E7:E12)","v":35550},{"$f":"SUM(F7:F12)","v":269800}]