{"text_format":"2","workbook":"xlsx","n_sheets":12,"sheets":["SUMMARY","F.P.YEAR 1","F.P.YEAR 2","F.P.YEAR 3","F.P.YEAR 4","F.P.YEAR 5","payroll.tax Y1","payroll.tax Y2","payroll.tax Y3","payroll.tax Y4","payroll.tax Y5","Fed.NYS.Tax-UI-BASE"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":12,"comments":10,"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":"SUMMARY","index":0,"n_rows":53,"n_cols":7,"rows_kept":53,"cut":false,"hidden":false,"merged":[[0,0,0,3],[14,0,48,0],[50,0,52,0],[2,0,6,0],[7,0,9,0],[11,0,13,0]]}
["[3.85 M Loan Base]-5 YEARS - PROFIT & LOSS STATEMENT",{"$nulls":4},"Sharon Springs Inc."]
[null,null,"Year 1","Year 2","Year 3","Year 4","Year 5"]
["Revenues","Lodging (SPA RESORT 10ROOMS)",{"$f":"'F.P.YEAR 1'!S10","v":406714.28571428568},{"$f":"'F.P.YEAR 2'!S11","v":406714.28571428568},{"$f":"'F.P.YEAR 3'!S11","v":406714.28571428568},{"$f":"'F.P.YEAR 4'!S10","v":406714.28571428568},{"$f":"'F.P.YEAR 5'!S10","v":406714.28571428568}]
[null,"Spa Service & Program",{"$f":"'F.P.YEAR 1'!S14+'F.P.YEAR 1'!S18+'F.P.YEAR 1'!S22","v":4185982.1428571427},{"$f":"'F.P.YEAR 2'!S15+'F.P.YEAR 2'!S19+'F.P.YEAR 2'!S23","v":6209464.2857142864},{"$f":"'F.P.YEAR 3'!S15+'F.P.YEAR 3'!S19+'F.P.YEAR 3'!S23","v":6830410.7142857146},{"$f":"'F.P.YEAR 4'!S15+'F.P.YEAR 4'!S23","v":7513451.7857142873},{"$f":"'F.P.YEAR 5'!S15+'F.P.YEAR 5'!S23","v":8264796.9642857164}]
[null,"Food & Beverage",{"$f":"'F.P.YEAR 1'!S30+'F.P.YEAR 1'!S34","v":508050},{"$f":"'F.P.YEAR 2'!S31+'F.P.YEAR 2'!S35","v":702675},{"$f":"'F.P.YEAR 3'!S31+'F.P.YEAR 3'!S35","v":761062.5},{"$f":"'F.P.YEAR 4'!S31","v":706488.75},{"$f":"'F.P.YEAR 5'!S31","v":777137.62500000023}]
[null,"Gift",{"$f":"'F.P.YEAR 1'!S38","v":0},{"$f":"'F.P.YEAR 2'!S39","v":0},{"$f":"'F.P.YEAR 3'!S39","v":0},{"$f":"'F.P.YEAR 3'!T39","v":0},{"$f":"'F.P.YEAR 3'!U39","v":0}]
[null,"Gross Revenues",{"$f":"SUM(C3:C6)","v":5100746.4285714282},{"$f":"SUM(D3:D6)","v":7318853.5714285718},{"$f":"SUM(E3:E6)","v":7998187.5},{"$f":"SUM(F3:F6)","v":8626654.8214285728},9448648.8750000019]
["Cost of Goods Sold","F & B Cost",{"$f":"'F.P.YEAR 1'!S45","v":77849.999999999985},{"$f":"'F.P.YEAR 2'!S46","v":116774.99999999999},{"$f":"'F.P.YEAR 3'!S46","v":128452.49999999999},{"$f":"'F.P.YEAR 4'!S46","v":141297.75},{"$f":"'F.P.YEAR 5'!S46","v":155427.52499999999}]
[null,"Gift Supply",{"$f":"'F.P.YEAR 1'!S46","v":0},{"$f":"'F.P.YEAR 2'!S47","v":0},{"$f":"'F.P.YEAR 3'!S47","v":0},{"$f":"'F.P.YEAR 3'!T47","v":0},{"$f":"'F.P.YEAR 3'!U47","v":0}]
[null,"Total COGS",{"$f":"SUM(C8:C9)","v":77849.999999999985},{"$f":"SUM(D8:D9)","v":116774.99999999999},{"$f":"SUM(E8:E9)","v":128452.49999999999},{"$f":"SUM(F8:F9)","v":141297.75},155427.52499999999]
[null,"Admission & Spa Service %",1,1,1,1,1]
["Gross Profit","F & B  Profit %",0.8,0.8,0.8,0.8,0.8]
[null,"Gift Supply Profit %",{"$f":"1-C9/C6","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"1-F9/F6","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[null,"Total Gross Profit",{"$f":"C7-C10","v":5022896.4285714282},{"$f":"D7-D10","v":7202078.5714285718},{"$f":"E7-E10","v":7869735},{"$f":"F7-F10","v":8485357.0714285728},{"$f":"G7-G10","v":9293221.3500000015}]
["Expenses","Payroll"]
[null,"Payroll",{"$f":"'F.P.YEAR 1'!S52","v":2027400},{"$f":"'F.P.YEAR 2'!S53","v":2128770},{"$f":"'F.P.YEAR 3'!S53","v":2235208.5},{"$f":"'F.P.YEAR 4'!S53","v":2346968.9249999998},{"$f":"'F.P.YEAR 5'!S53","v":2464317.3712500003}]
[null,"Payroll Tax",{"$f":"'F.P.YEAR 1'!S53","v":152896},{"$f":"'F.P.YEAR 2'!S54","v":153533.38500000001},{"$f":"'F.P.YEAR 3'!S54","v":159017.65424999993},{"$f":"'F.P.YEAR 4'!S54","v":166968.53696250005},{"$f":"'F.P.YEAR 5'!S54","v":175316.96381062499}]
[null,"Total Payroll Expense",{"$f":"SUM(C16:C17)","v":2180296},{"$f":"SUM(D16:D17)","v":2282303.3849999998},{"$f":"SUM(E16:E17)","v":2394226.1542500001},{"$f":"SUM(F16:F17)","v":2513937.4619624997},2639634.3350606253]
[null,"Utilites"]
[null,"Electric",{"$f":"'F.P.YEAR 1'!S56","v":63461.52},{"$f":"'F.P.YEAR 2'!S57","v":63461.52},{"$f":"'F.P.YEAR 3'!S57","v":63461.52},{"$f":"'F.P.YEAR 4'!S57","v":63461.52},{"$f":"'F.P.YEAR 5'!S57","v":63461.52}]
[null,"Gas",{"$f":"'F.P.YEAR 1'!S55","v":52315.450000000012},{"$f":"'F.P.YEAR 2'!S56","v":52315.450000000012},{"$f":"'F.P.YEAR 3'!S56","v":52315.450000000012},{"$f":"'F.P.YEAR 4'!S56","v":52315.450000000012},{"$f":"'F.P.YEAR 5'!S56","v":52315.450000000012}]
[null,"Water",{"$f":"'F.P.YEAR 1'!S57","v":29353.237449400007},{"$f":"'F.P.YEAR 2'!S58","v":32681.996174100004},{"$f":"'F.P.YEAR 3'!S58","v":33680.623791510006},{"$f":"'F.P.YEAR 4'!S58","v":34779.114170661},{"$f":"'F.P.YEAR 5'!S58","v":35987.453587727105}]
[null,"Phone, Internet,Cable",{"$f":"'F.P.YEAR 1'!S58","v":18000},{"$f":"'F.P.YEAR 2'!S59","v":18000},{"$f":"'F.P.YEAR 3'!S59","v":18000},{"$f":"'F.P.YEAR 4'!S59","v":18000},{"$f":"'F.P.YEAR 5'!S59","v":18000}]
[null,"Total Utility Expense",{"$f":"SUM(C20:C23)","v":163130.20744940001},{"$f":"SUM(D20:D23)","v":166458.9661741},{"$f":"SUM(E20:E23)","v":167457.59379151001},{"$f":"SUM(F20:F23)","v":168556.08417066099},169764.4235877271]
[null,"Other Expenses"]
[null,"Property Tax",{"$f":"'F.P.YEAR 1'!S51","v":48547.000000000007},{"$f":"'F.P.YEAR 2'!S52","v":60684},{"$f":"'F.P.YEAR 3'!S52","v":66751.999999999985},{"$f":"'F.P.YEAR 4'!S52","v":66751.999999999985},{"$f":"'F.P.YEAR 5'!S52","v":66751.999999999985}]
[null,"Sales Tax",{"$f":"'F.P.YEAR 1'!S54","v":408059.71428571432},{"$f":"'F.P.YEAR 2'!S55","v":585508.28571428568},{"$f":"'F.P.YEAR 3'!S55","v":639855},{"$f":"'F.P.YEAR 4'!S55","v":699636.38571428566},{"$f":"'F.P.YEAR 5'!S55","v":765395.91000000015}]
[null,"Bank Charge & Credit Card Fee",{"$f":"'F.P.YEAR 1'!S50","v":102014.92857142858},{"$f":"'F.P.YEAR 2'!S51","v":146377.07142857145},{"$f":"'F.P.YEAR 3'!S51","v":159963.75},{"$f":"'F.P.YEAR 4'!S51","v":174909.09642857147},{"$f":"'F.P.YEAR 5'!S51","v":191348.97750000004}]
[null,"Insurance (Property, Liability, Auto, Worker's comp)",{"$f":"'F.P.YEAR 1'!S63","v":94848},{"$f":"'F.P.YEAR 2'!S64","v":94848},{"$f":"D29","v":94848},{"$f":"E29","v":94848},94848]
[null,"Advertising & Promotion",{"$f":"'F.P.YEAR 1'!S62","v":300000},{"$f":"'F.P.YEAR 2'!S63","v":144000},{"$f":"D30","v":144000},{"$f":"E30","v":144000},144000]
[null,"Professional Fees",{"$f":"'F.P.YEAR 1'!S66","v":48000},{"$f":"'F.P.YEAR 2'!S67","v":48000},{"$f":"D31","v":48000},{"$f":"E31","v":48000},48000]
[null,"Bath House Supply",{"$f":"'F.P.YEAR 1'!S60","v":21625},{"$f":"'F.P.YEAR 2'!S61","v":32437.5},{"$f":"'F.P.YEAR 3'!S61","v":35681.25},{"$f":"'F.P.YEAR 4'!S61","v":39249.375},{"$f":"'F.P.YEAR 5'!S61","v":43174.312500000015}]
[null,"Laundry & Sanitation",{"$f":"'F.P.YEAR 1'!S59","v":48471.799999999988},{"$f":"'F.P.YEAR 2'!S60","v":60771.78},{"$f":"'F.P.YEAR 3'!S60","v":64192.133999999991},{"$f":"'F.P.YEAR 4'!S60","v":67954.523400000005},{"$f":"'F.P.YEAR 5'!S60","v":72093.151740000016}]
[null,"Printing (brouchure,sign)",{"$f":"'F.P.YEAR 1'!S70","v":24000},{"$f":"'F.P.YEAR 2'!S71","v":24000},{"$f":"D34","v":24000},{"$f":"E34","v":24000},24000]
[]
[null,"Total Other Expenses",{"$f":"SUM(C26:C33)","v":1071566.442857143},{"$f":"SUM(D26:D33)","v":1172626.6371428573},{"$f":"SUM(E26:E33)","v":1253292.1340000001},{"$f":"SUM(F26:F33)","v":1335349.3805428573},1425612.3517400003]
[null,"Miscellaneous"]
[null,"Dues & Subscription",{"$f":"'F.P.YEAR 1'!S74","v":2499.6000000000004},{"$f":"'F.P.YEAR 2'!S75","v":2499.6000000000004},{"$f":"D38","v":2499.6000000000004},{"$f":"E38","v":2499.6000000000004},2499.6000000000004]
[null,"License & Permit",{"$f":"'F.P.YEAR 1'!S68","v":9996},{"$f":"'F.P.YEAR 2'!S69","v":9996},{"$f":"D39","v":9996},{"$f":"E39","v":9996},9996]
[null,"Postage & Delivery",{"$f":"'F.P.YEAR 1'!S69","v":8004},{"$f":"'F.P.YEAR 2'!S70","v":8004},{"$f":"D40","v":8004},{"$f":"E40","v":8004},8004]
[null,"Pest Control",{"$f":"'F.P.YEAR 1'!S67","v":24996},{"$f":"'F.P.YEAR 2'!S68","v":24996},{"$f":"D41","v":24996},{"$f":"E41","v":24996},24996]
[null,"Total Miscellaneous",{"$f":"SUM(C38:C76)","v":268079.28214376396},{"$f":"SUM(D38:D76)","v":268079.28214376396},{"$f":"SUM(E38:E76)","v":268079.28214376396},{"$f":"SUM(F38:F76)","v":268079.28214376396},268079.28214376396]
[]
[null,"Depreciation Expenses",{"$f":"'F.P.YEAR 1'!S64","v":60000},{"$f":"'F.P.YEAR 2'!S65","v":60000},{"$f":"'F.P.YEAR 3'!S65","v":60000},{"$f":"'F.P.YEAR 4'!S65","v":60000},{"$f":"'F.P.YEAR 5'!S65","v":60000}]
[null,"Amortization & Interest Expense (Loan P&I)",{"$f":"'F.P.YEAR 1'!S65","v":372014.87999999995},{"$f":"'F.P.YEAR 2'!S66","v":372014.87999999995},{"$f":"'F.P.YEAR 3'!S66","v":372014.87999999995},{"$f":"'F.P.YEAR 4'!S66","v":372014.87999999995},{"$f":"'F.P.YEAR 5'!S66","v":372014.87999999995}]
[]
[null,"Sub Total Expenses",{"$f":"SUM(C16:C17,C20:C23,C26:C35,C38:C41,C44,C45,)*105%","v":4112328.2868218701},{"$f":"SUM(D16:D17,D20:D23,D26:D35,D38:D41,D44,D45,)*103%","v":4246586.4523664657},{"$f":"SUM(E16:E17,E20:E23,E26:E35,E38:E41,E44,E45,)*103%","v":4445980.9529027557},{"$f":"SUM(F16:F17,F20:F23,F26:F35,F38:F41,F44,F45,)*103%","v":4654934.0088762986},4878617.2381000025]
[null,"Contingency",{"$f":"C47*10%","v":411232.82868218701},{"$f":"D47*10%","v":424658.64523664658},{"$f":"E47*10%","v":444598.09529027558},{"$f":"F47*10%","v":465493.40088762989},487861.72381000029]
[null,"Grand Total Expense",{"$f":"C47+C48","v":4523561.1155040571},{"$f":"D47+D48","v":4671245.0976031125},{"$f":"E47+E48","v":4890579.048193031},{"$f":"F47+F48","v":5120427.4097639285},5366478.9619100029]
[]
["Net Income","Net Income",{"$f":"C14-C49","v":499335.31306737103},{"$f":"D14-D49","v":2530833.4738254594},{"$f":"E14-E49","v":2979155.951806969},{"$f":"F14-F49","v":3364929.6616646443},3926742.3880899986]
[null,"Income Tax",{"$f":"-(C51*0.28)","v":-139813.88765886391},{"$f":"-(D51*0.28)","v":-708633.37267112872},{"$f":"-(E51*0.28)","v":-834163.66650595143},{"$f":"-(F51*0.28)","v":-942180.30526610045},-1099487.8686651997]
[null,"Final Net Income after Tax",{"$f":"C51+C52","v":359521.42540850712},{"$f":"D51+D52","v":1822200.1011543307},{"$f":"E51+E52","v":2144992.2853010176},{"$f":"F51+F52","v":2422749.3563985438},2827254.5194247989]

{"sheet":"F.P.YEAR 1","index":1,"n_rows":82,"n_cols":20,"rows_kept":82,"cut":false,"hidden":false,"merged":[[16,1,17,1],[16,3,17,3],[20,1,21,1],[20,3,21,3],[24,1,25,1],[24,3,25,3],[28,1,29,1],[28,3,29,3],[76,3,76,4],[78,3,78,4],[32,1,33,1],[32,3,33,3],[36,1,37,1],[36,3,37,3],[74,3,74,4],[75,3,75,4]]}
[" Year 1 Profit & Loss ",{"$nulls":8},"Initial guests ",": From 1st to 5th month",null,"Peak :",null,"Nov.Dec.Jan.Feb & Jun ",null,"High Peak :","Jul, Aug"]
[]
[null,"Business",null,null," ",null,"Jan.","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec","Year Total"]
[{"$nulls":4},"days ","for Month",31,28,31,30,31,30,31,31,30,31,30,31,{"$f":"SUM(G4,H4,I4,J4,K4,L4,M4,N4,O4,P4,Q4,R4)","v":365}]
["Year 1","First Year ","rooms","Price/unit",null,"Daily Vistors",100,100,110,120,100,100,150,170,150,120,100,100," "]
[null,null," ","occpancy",0.65,"Monthly visitors",{"$f":"G4*G5","v":3100},2800,3410,3600,3100,3000,4650,5270,4500,3720,3000,3100,{"$f":"SUM(G6,H6,I6,J6,K6,L6,M6,N6,O6,P6,Q6,R6)","v":43250}," "]
["Lodging ","Room w/attached outdoor Bath (Sulfur Soaking), weekday $250/2pax+weekend $350 / 2pax, Breakfast ,Admission fee included",0,{"$f":"((250*4)+(350*3))/7","v":292.85714285714283},{"$f":"C7*$E$6","v":0},null,{"$f":"$D$7*$E$7*G4","v":0},0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(G7:R7)","v":0}]
[" ","Standard room, weekday $200/2pax+weekend $250 /2pax,Breakfast included",0,{"$f":"((200*4)+(250*3))/7","v":221.42857142857142},{"$f":"C8*$E$6","v":0},null,{"$f":"$D$8*$E$8*G4","v":0},0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(G8:R8)","v":0}]
["Doctor house 10 rooms","Hotel, weekday/N $150/2pax+weekend/N, $200 /2pax,Breakfast.",10,{"$f":"((150*4)+(200*3))/7","v":171.42857142857142},{"$f":"C9*$E$6","v":6.5},"monthly sales",{"$f":"$D$9*$E$9*G4","v":34542.857142857138},{"$f":"$D$9*$E$9*H4","v":31200},34542.857142857138,33428.571428571428,34542.857142857138,33428.571428571428,34542.857142857138,34542.857142857138,33428.571428571428,34542.857142857138,33428.571428571428,34542.857142857138,{"$f":"SUM(G9:R9)","v":406714.28571428568}]
[{"$nulls":5},"Sales Sub TTL",{"$f":"G7+G8+G9","v":34542.857142857138},{"$f":"H7+H8+H9","v":31200},34542.857142857138,33428.571428571428,34542.857142857138,33428.571428571428,34542.857142857138,34542.857142857138,33428.571428571428,34542.857142857138,33428.571428571428,34542.857142857138,{"$f":"SUM(G10:R10)","v":406714.28571428568}]
[" ",{"$nulls":4},"Profit Rate",1,1,1,1,1,1,1,1,1,1,1,1,1]
[{"$nulls":5},"Profit ",{"$f":"G10*G11","v":34542.857142857138},31200,34542.857142857138,33428.571428571428,34542.857142857138,33428.571428571428,{"$f":"M10*M11","v":34542.857142857138},34542.857142857138,33428.571428571428,34542.857142857138,33428.571428571428,34542.857142857138,406714.28571428568]
["Spa Service & Program","Main Package[Admission w/ Public Outdoor bath+ indoor private  Bath (Sulfur Soaking)+ 60 Min massage","Ave.",{"$f":"((D15*4)+(D16*3))/7","v":132.85714285714286},0.5,"Monthly Pax",{"$f":"G5*G4*$E$13","v":1550},{"$f":"H5*H4*$E$13","v":1400},1705,1800,1550,1500,2325,2635,2250,1860,1500,1550,{"$f":"SUM(G13:R13)","v":21625}]
[null," "," ",null," ","Sales",{"$f":"$D$13*G13","v":205928.57142857145},{"$f":"$D$13*H13","v":186000},226521.42857142858,239142.85714285716,205928.57142857145,199285.71428571429,308892.85714285716,350078.57142857142,298928.57142857142,247114.28571428571,199285.71428571429,205928.57142857145,{"$f":"SUM(G14:R14)","v":2873035.7142857141}]
[null,null,"week",120,null,"Profit Rate",1,1,1,1,1,1,1,1,1,1,1,1,1]
[null,null,"weekend",150,null,"Profit ",{"$f":"G14*G15","v":205928.57142857145},186000,226521.42857142858,239142.85714285716,205928.57142857145,199285.71428571429,{"$f":"M14*M15","v":308892.85714285716},{"$f":"N14*N15","v":350078.57142857142},298928.57142857142,247114.28571428571,199285.71428571429,205928.57142857145,{"$f":"S14*S15","v":2873035.7142857141}]
[]
[]
[]
[]
["Spa Service & Program","Budget Package[ Addmission+public outdoorbath",null,{"$f":"((D23*4)+(D24*3))/7","v":60.714285714285715},{"$f":"1-E13","v":0.5},"Monthly Pax",{"$f":"G4*G5*$E$21","v":1550},{"$f":"H4*H5*$E$21","v":1400},1705,1800,1550,1500,2325,2635,2250,1860,1500,1550,{"$f":"SUM(G21:R21)","v":21625}]
[{"$nulls":4}," ","Sales",{"$f":"$D$21*G21","v":94107.142857142855},85000,103517.85714285714,109285.71428571429,94107.142857142855,91071.42857142858,141160.71428571429,159982.14285714287,136607.14285714287,112928.57142857143,91071.42857142858,94107.142857142855,{"$f":"SUM(G22:R22)","v":1312946.4285714286}]
[null,null,"week",50,null,"Profit Rate",1,1,1,1,1,1,1,1,1,1,1,1,1]
[null,null,"weekend",75,null,"Profit ",{"$f":"G22*G23","v":94107.142857142855},85000,103517.85714285714,109285.71428571429,94107.142857142855,91071.42857142858,{"$f":"M22*M23","v":141160.71428571429},{"$f":"N22*N23","v":159982.14285714287},136607.14285714287,112928.57142857143,91071.42857142858,94107.142857142855,{"$f":"S22*S23","v":1312946.4285714286}]
["Spa Service & Program","Nail/Foot",null,null,null,"Monthly Pax",0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(G25:R25)","v":0}]
[{"$nulls":5},"Sales",{"$f":"$D$25*G25","v":0},0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(G26:R26)","v":0}]
[{"$nulls":5},"Profit Rate",0.95,0.95,0.95,0.95,0.95,0.95,0.95,0.95,0.95,0.95,0.95,0.95,0.95]
[{"$nulls":5},"Profit ",{"$f":"G26*G27","v":0},0,0,0,0,0,{"$f":"M26*M27","v":0},{"$f":"N26*N27","v":0},0,0,0,0,0]
["Food & Beverage","Café",null,15,0.6,"Monthly Pax",{"$f":"G4*G5*$E$29","v":1860},{"$f":"H4*H5*$E$29","v":1680},2046,2160,1860,1800,2790,3162,2700,2232,1800,1860,{"$f":"SUM(G29:R29)","v":25950}]
[{"$nulls":4}," ","Sales",{"$f":"$D$29*G29","v":27900},25200,30690,32400,27900,27000,41850,47430,40500,33480,27000,27900,{"$f":"SUM(G30:R30)","v":389250}]
[{"$nulls":5},"Profit Rate",0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8]
[{"$nulls":5},"Profit ",{"$f":"G30*G31","v":22320},20160,24552,25920,22320,21600,{"$f":"M30*M31","v":33480},{"$f":"N30*N31","v":37944},32400,26784,21600,22320,311400]
["Food & Beverage","Restaurant rent income",null,9900,null,"Monthly Pax",1,1,1,1,1,1,1,1,1,1,1,1,12]
[{"$nulls":4}," ","Sales",9900,9900,9900,9900,9900,9900,9900,9900,9900,9900,9900,9900,{"$f":"9900*12","v":118800}]
[{"$nulls":5},"Profit Rate",1,1,1,1,1,1,1,1,1,1,1,1,1]
[{"$nulls":5},"Profit ",{"$f":"G34*G35","v":9900},9900,9900,9900,9900,9900,{"$f":"M34*M35","v":9900},{"$f":"N34*N35","v":9900},9900,9900,9900,9900,118800]
[]
[]
[]
[]
[]
[null,"Total Sales Revenue",{"$nulls":4},{"$f":"G10+G14+G18+G22+G26+G30+G34+G38","v":372378.57142857142},{"$f":"H10+H14+H30+H18+H22+H26+H34+H38","v":337300},405172.14285714284,424157.14285714284,372378.57142857142,360685.71428571432,536346.42857142864,601933.57142857148,519364.28571428568,437965.71428571426,360685.71428571432,372378.57142857142,{"$f":"S10+S14+S30+S18+S22+S26+S34+S38","v":5100746.4285714291}]
[null,"COGS",{"$nulls":16},{"$f":"SUM(G42:R42)","v":5100746.4285714291}]
[]
["Cost of Good Sold","Food &Beberage COGS",{"$nulls":4},{"$f":"(G10*(1-G11))+(G14*(1-G15))+(G18*(1-G19))+(G22*(1-G23))+(G30*(1-G31))+(G34*(1-G35))","v":5579.9999999999991},{"$f":"(H10*(1-H11))+(H14*(1-H15))+(H18*(1-H19))+(H22*(1-H23))+(H30*(1-H31))+(H34*(1-H35))","v":5039.9999999999991},6137.9999999999991,6479.9999999999982,5579.9999999999991,5399.9999999999991,8369.9999999999982,9485.9999999999982,8099.9999999999982,6695.9999999999982,5399.9999999999991,5579.9999999999991,{"$f":"(S10*(1-S11))+(S14*(1-S15))+(S18*(1-S19))+(S22*(1-S23))+(S30*(1-S31))+(S34*(1-S35))","v":77849.999999999985}]
[null,"Gift supply  COGS",{"$nulls":4},{"$f":"G38*(1-G39)","v":0},{"$f":"H38*(1-H39)","v":0},0,0,0,0,0,0,0,0,0,0,0]
[]
["Total Gross Profit","Total Gross Profit ",{"$nulls":4},{"$f":"G42-G45-G46","v":366798.57142857142},{"$f":"H42-H45-H46","v":332260},399034.14285714284,417677.14285714284,366798.57142857142,355285.71428571432,527976.42857142864,592447.57142857148,511264.28571428568,431269.71428571426,355285.71428571432,366798.57142857142,5022896.4285714291]
[null,"Expense"]
["Credit Card Fee/Bank/Other/Misc.","Credit Card Fee/Bank/Other/Misc.",{"$nulls":4},{"$f":"G42*0.02","v":7447.5714285714284},{"$f":"H42*0.02","v":6746},8103.4428571428571,8483.1428571428569,7447.5714285714284,7213.7142857142862,10726.928571428572,12038.67142857143,10387.285714285714,8759.3142857142848,7213.7142857142862,7447.5714285714284,102014.92857142858]
["Property Tax - Under Pilot Program","Property Tax - Under Pilot Program",{"$nulls":4},{"$f":"48547/12","v":4045.5833333333335},{"$f":"48547/12","v":4045.5833333333335},4045.5833333333335,4045.5833333333335,4045.5833333333335,4045.5833333333335,4045.5833333333335,4045.5833333333335,4045.5833333333335,4045.5833333333335,4045.5833333333335,4045.5833333333335,{"$f":"SUM(G51:R51)","v":48547.000000000007}]
["Payroll","Payroll",{"$nulls":4},{"$f":"'payroll.tax Y1'!I37","v":168950},{"$f":"$G$52","v":168950},{"$f":"$G$52","v":168950},168950,168950,168950,168950,168950,168950,168950,168950,168950,2027400]
["Payroll Tax","Payroll Tax",{"$nulls":4},{"$f":"'payroll.tax Y1'!L37","v":12741.333333333334},{"$f":"G53","v":12741.333333333334},{"$f":"H53","v":12741.333333333334},12741.333333333334,12741.333333333334,12741.333333333334,12741.333333333334,12741.333333333334,12741.333333333334,12741.333333333334,12741.333333333334,12741.333333333334,152896]
["Sales Tax","Sales Tax",{"$nulls":4},{"$f":"G42*0.08","v":29790.285714285714},{"$f":"H42*0.08","v":26984},{"$f":"I42*0.08","v":32413.771428571428},{"$f":"J42*0.08","v":33932.571428571428},29790.285714285714,28854.857142857145,42907.71428571429,48154.685714285719,41549.142857142855,35037.257142857139,28854.857142857145,29790.285714285714,{"$f":"SUM(G54:R54)","v":408059.71428571432}]
["Gas","Gas",{"$nulls":4},{"$f":"143.33*G4","v":4443.2300000000005},{"$f":"143.33*H4","v":4013.2400000000002},4443.2300000000005,4299.9000000000005,4443.2300000000005,4299.9000000000005,4443.2300000000005,4443.2300000000005,4299.9000000000005,4443.2300000000005,4299.9000000000005,4443.2300000000005,{"$f":"SUM(G55:R55)","v":52315.450000000012}]
["Electricity ","Electricity ",{"$nulls":4},{"$f":"15000*0.352564","v":5288.46},{"$f":"15000*0.352564","v":5288.46},5288.46,5288.46,5288.46,5288.46,5288.46,5288.46,5288.46,5288.46,5288.46,5288.46,{"$f":"SUM(G56:R56)","v":63461.52}]
["Water & Sewer","Water & Sewer",{"$nulls":4},{"$f":"(($G$4*G5)*6.6043*0.0229)+($G$4*61.01)","v":2360.149257},{"$f":"(($G$4*H5)*6.6043*0.0229)+($G$4*61.01)","v":2360.149257},2407.0331827,2453.9171084,2360.149257,2360.149257,2594.5688854999999,2688.3367368999998,2594.5688854999999,2453.9171084,2360.149257,2360.149257,{"$f":"SUM(G57:R57)","v":29353.237449400007}]
["Phone,Internet,Cable","Phone,Internet,Cable",{"$nulls":4},1500,1500,1500,1500,1500,1500,1500,1500,1500,1500,1500,1500,{"$f":"SUM(G58:R58)","v":18000}]
["Laundry & Sanitation","Laundry & Sanitation",{"$nulls":4},{"$f":"($G$4*G5*1.4*0.37)+(71.42*$G$4)","v":3819.8199999999997},{"$f":"(H4*H5*1.4*0.37)+(71.42*H4)","v":3450.16},3980.3999999999996,4007.3999999999996,3819.8199999999997,3696.6,4622.7199999999993,4943.8799999999992,4473.6000000000004,4140.9799999999996,3696.6,3819.8199999999997,48471.799999999988]
["Bath house Supplies","Bath house Supplies",{"$nulls":4},{"$f":"G4*G5*0.5","v":1550},{"$f":"H4*H5*0.5","v":1400},1705,1800,1550,1500,2325,2635,2250,1860,1500,1550,21625]
[]
["Advertising(Media/ SN/Internet)","Advertising(Media/ SN/Internet)",{"$nulls":4},25000,{"$f":"G62","v":25000},{"$f":"H62","v":25000},25000,25000,25000,25000,25000,25000,25000,25000,25000,300000]
["Litigation,Insurance&Workers Comp","Litigation,Insurance&Workers Comp",{"$nulls":4},7904,7904,7904,7904,7904,7904,7904,7904,7904,7904,7904,7904,94848]
["Depreciation for properties","Depreciation for properties",{"$nulls":4},5000,5000,5000,5000,5000,5000,5000,5000,5000,5000,5000,5000,60000]
["Loan Principal&Interests","Loan Principal&Interests",{"$nulls":4},31001.24,31001.24,31001.24,31001.24,31001.24,31001.24,31001.24,31001.24,31001.24,31001.24,31001.24,31001.24,372014.87999999995]
["Professional Fee","Professional Fee",{"$nulls":4},4000,4000,4000,4000,4000,4000,4000,4000,4000,4000,4000,4000,48000]
["Pest Control","Pest Control",{"$nulls":4},2083,2083,2083,2083,2083,2083,2083,2083,2083,2083,2083,2083,{"$f":"SUM(G67:R67)","v":24996}]
["Licenses and permits","Licenses and permits",{"$nulls":4},833,833,833,833,833,833,833,833,833,833,833,833,9996]
["Postage and delivery","Postage and delivery",{"$nulls":4},667,667,667,667,667,667,667,667,667,667,667,667,8004]
["Printing (brouchure,sign)","Printing (brouchure,sign)",{"$nulls":4},2000,2000,2000,2000,2000,2000,2000,2000,2000,2000,2000,2000,24000]
["Shuttle service(2 buses)","Bus insurance",{"$nulls":4},8400,8400,8400,8400,8400,8400,8400,8400,8400,8400,8400,8400,100800]
["Shuttle service(2 buses)","Bus maintenance",{"$nulls":4},11700,11700,11700,11700,11700,11700,11700,11700,11700,11700,11700,11700,140400]
["Shuttle service(2 buses)","Bus finance",{"$nulls":4},21183.279999999999,21430,21430,21430,21430,21430,21430,21430,21430,21430,21430,21430,256913.28]
["Dues & Subscription","Dues & Subscription",{"$nulls":4},208.3,208.3,208.3,208.3,208.3,208.3,208.3,208.3,208.3,208.3,208.3,208.3,2499.6000000000004]
["Sub-Total Expense","Sub-Total Expense",{"$nulls":4},{"$f":"SUM(G50:G74)","v":361916.25306652387},{"$f":"SUM(H50:H74)","v":357705.46592366666},365804.79413508094,367728.8480607809,362162.97306652385,360677.13735223812,380372.0784093095,387655.72054642381,378306.41412359523,369446.6152036381,360677.13735223812,362162.97306652385,4414616.4103065422]
["Contingency","Contingency",{"$nulls":4},{"$f":"G75*0.03","v":10857.487591995716},{"$f":"H75*0.03","v":10731.163977709999},10974.143824052428,11031.865441823427,10864.889191995715,10820.314120567144,11411.162352279285,11629.671616392714,11349.192423707857,11083.398456109142,10820.314120567144,10864.889191995715,{"$f":"SUM(G76:R76)","v":132438.4923091963}]
["Total Expense","Total Expense",{"$nulls":4},{"$f":"G75+G76","v":372773.74065851961},{"$f":"H75+H76","v":368436.62990137667},376778.93795913336,378760.71350260434,373027.86225851957,371497.45147280529,391783.24076158879,399285.39216281654,389655.60654730309,380530.01365974726,371497.45147280529,373027.86225851957,{"$f":"SUM(G77:R77)","v":4547054.90261574}]
[]
["Total Final Net Profit","Total Final Net Profit",{"$nulls":4},{"$f":"G48-G77","v":-5975.1692299481947},{"$f":"H48-H77","v":-36176.629901376669},22255.204898009484,38916.429354538501,-6229.2908299481496,-16211.73718709097,136193.18780983984,193162.17926575494,121608.67916698259,50739.700625967002,-16211.73718709097,-6229.2908299481496,475841.52595568914]
[]
[{"$nulls":4},"Profit","total by month",{"$f":"G79","v":-5975.1692299481947},{"$f":"SUM($G$79:H79)","v":-42151.799131324864},{"$f":"SUM($G$79:I79)","v":-19896.59423331538},{"$f":"SUM($G$79:J79)","v":19019.835121223121},{"$f":"SUM($G$79:K79)","v":12790.544291274971},{"$f":"SUM($G$79:L79)","v":-3421.1928958159988},{"$f":"SUM($G$79:M79)","v":132771.99491402385},{"$f":"SUM($G$79:N79)","v":325934.17417977878},{"$f":"SUM($G$79:O79)","v":447542.85334676137},{"$f":"SUM($G$79:P79)","v":498282.55397272838},{"$f":"SUM($G$79:Q79)","v":482070.81678563741},{"$f":"SUM($G$79:R79)","v":475841.52595568926}]
[{"$nulls":4},"(accmulated from the 1st month)"]

{"sheet":"F.P.YEAR 2","index":2,"n_rows":83,"n_cols":19,"rows_kept":83,"cut":false,"hidden":false,"merged":[[29,1,30,1],[29,3,30,3],[77,3,77,4],[79,3,79,4],[33,1,34,1],[33,3,34,3],[37,1,38,1],[37,3,38,3],[75,3,75,4],[76,3,76,4],[17,1,18,1],[17,3,18,3],[21,1,22,1],[21,3,22,3],[25,1,26,1],[25,3,26,3]]}
[" Year 2 Profit & Loss ",{"$nulls":8},"Peak :",null,"Nov.Dec.Jan.Feb & Jun",null,null,"High Peak :","Jul, Aug"]
[]
[null,"Business",{"$nulls":4},"Jan.","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec","Year Total"]
[{"$nulls":4},"days ","for Month",31,28,31,30,31,30,31,31,30,31,30,31,{"$f":"SUM(G4,H4,I4,J4,K4,L4,M4,N4,O4,P4,Q4,R4)","v":365}]
[null,"1st yr",null,null,"Daily","Vistors",{"$f":"'F.P.YEAR 1'!G5","v":100},{"$f":"'F.P.YEAR 1'!H5","v":100},{"$f":"'F.P.YEAR 1'!I5","v":110},{"$f":"'F.P.YEAR 1'!J5","v":120},{"$f":"'F.P.YEAR 1'!K5","v":100},{"$f":"'F.P.YEAR 1'!L5","v":100},{"$f":"'F.P.YEAR 1'!M5","v":150},{"$f":"'F.P.YEAR 1'!N5","v":170},{"$f":"'F.P.YEAR 1'!O5","v":150},{"$f":"'F.P.YEAR 1'!P5","v":120},{"$f":"'F.P.YEAR 1'!Q5","v":100},{"$f":"'F.P.YEAR 1'!R5","v":100},{"$f":"'F.P.YEAR 1'!S6","v":43250}]
["Year 2","2nd Yr","rooms","Price/unit",null,"(+50%)",{"$f":"G5*1.5","v":150},{"$f":"H5*1.5","v":150},165,180,150,150,225,255,225,180,150,150," "]
[null,null," ","occpancy",0.65,"Momthly",{"$f":"G4*G6","v":4650},{"$f":"H4*H6","v":4200},5115,5400,4650,4500,6975,7905,6750,5580,4500,4650,{"$f":"SUM(G7:R7)","v":64875}]
["Lodging ","Room w/attached outdoor Bath (Sulfur Soaking), weekday $250/2pax+weekend $350 / 2pax, Breakfast ,Admission fee included",0,{"$f":"((250*4)+(350*3))/7","v":292.85714285714283},{"$f":"C8*$E$6","v":0},"monthly sales",{"$f":"$D$8*$E$8*G4","v":0},{"$f":"$D$8*$E$8*H4","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(G8:R8)","v":0}]
[" ","Standard room, weekday $200/2pax+weekend $250 /2pax,Breakfast included",0,{"$f":"((200*4)+(250*3))/7","v":221.42857142857142},{"$f":"C9*$E$6","v":0},"monthly sales",{"$f":"$D$9*$E$9*G4","v":0},{"$f":"$D$9*$E$9*H4","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(G9:R9)","v":0}]
["Guest House ","Hotel, weekday/N $150/2pax+weekend/N, $200 /2pax,Breakfast.",10,{"$f":"((150*4)+(200*3))/7","v":171.42857142857142},{"$f":"C10*$E$7","v":6.5},"monthly sales",{"$f":"$D$10*$E$10*G4","v":34542.857142857138},{"$f":"$D$10*$E$10*H4","v":31200},34542.857142857138,33428.571428571428,34542.857142857138,33428.571428571428,34542.857142857138,34542.857142857138,33428.571428571428,34542.857142857138,33428.571428571428,34542.857142857138,{"$f":"SUM(G10:R10)","v":406714.28571428568}]
[{"$nulls":5},"Sales Sub TTL",{"$f":"G8+G9+G10","v":34542.857142857138},{"$f":"H8+H9+H10","v":31200},34542.857142857138,33428.571428571428,34542.857142857138,33428.571428571428,34542.857142857138,34542.857142857138,33428.571428571428,34542.857142857138,33428.571428571428,34542.857142857138,{"$f":"SUM(G11:R11)","v":406714.28571428568}]
[" ",{"$nulls":4},"Profit Rate",1,1,1,1,1,1,1,1,1,1,1,1,1]
[{"$nulls":5},"Profit ",{"$f":"G11","v":34542.857142857138},{"$f":"H11","v":31200},34542.857142857138,33428.571428571428,34542.857142857138,33428.571428571428,34542.857142857138,34542.857142857138,33428.571428571428,34542.857142857138,33428.571428571428,34542.857142857138,{"$f":"SUM(G13:R13)","v":406714.28571428568}]
["Spa Service & Program","Main Package[Admission w/ Public Outdoor bath+ indoor private  Bath (Sulfur Soaking)+ 60 Min massage","Ave.",{"$f":"((D16*4)+(D17*3))/7","v":132.85714285714286},0.5,"Monthly Pax",{"$f":"G6*G4*$E$14","v":2325},{"$f":"H6*H4*$E$14","v":2100},2557.5,2700,2325,2250,3487.5,3952.5,3375,2790,2250,2325,{"$f":"SUM(G14:R14)","v":32437.5}]
[null," "," ",null," ","Sales",{"$f":"$D$14*G14","v":308892.85714285716},{"$f":"$D$14*H14","v":279000},339782.14285714284,358714.28571428574,308892.85714285716,298928.57142857142,463339.28571428574,525117.85714285716,448392.85714285716,370671.42857142858,298928.57142857142,308892.85714285716,{"$f":"SUM(G15:R15)","v":4309553.5714285718}]
[null,null,"week",120,null,"Profit Rate",1,1,1,1,1,1,1,1,1,1,1,1,1]
[null,null,"weekend",150,null,"Profit ",{"$f":"G15*G16","v":308892.85714285716},279000,339782.14285714284,358714.28571428574,308892.85714285716,298928.57142857142,{"$f":"M15*M16","v":463339.28571428574},{"$f":"N15*N16","v":525117.85714285716},448392.85714285716,370671.42857142858,298928.57142857142,308892.85714285716,4309553.5714285718]
[]
[]
[]
[]
["Spa Service & Program","Budget Package[ Addmission+public outdoorbath",null,{"$f":"((D24*4)+(D25*3))/7","v":58.571428571428569},{"$f":"1-E14","v":0.5},"Monthly Pax",{"$f":"G4*G6*$E$22","v":2325},2100,2557.5,2700,2325,2250,3487.5,3952.5,3375,2790,2250,2325,{"$f":"SUM(G22:R22)","v":32437.5}]
[{"$nulls":4}," ","Sales",{"$f":"$D$22*G22","v":136178.57142857142},123000,149796.42857142858,158142.85714285713,136178.57142857142,131785.71428571429,204267.85714285713,231503.57142857142,197678.57142857142,163414.28571428571,131785.71428571429,136178.57142857142,{"$f":"SUM(G23:R23)","v":1899910.7142857143}]
[null,null,"week",50,null,"Profit Rate",1,1,1,1,1,1,1,1,1,1,1,1,1]
[null,null,"weekend",70,null,"Profit ",{"$f":"G23*G24","v":136178.57142857142},123000,149796.42857142858,158142.85714285713,136178.57142857142,131785.71428571429,{"$f":"M23*M24","v":204267.85714285713},{"$f":"N23*N24","v":231503.57142857142},197678.57142857142,163414.28571428571,131785.71428571429,136178.57142857142,1899910.7142857143]
["Spa Service & Program","Nail/Foot",null,null,null,"Monthly Pax",0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(G26:R26)","v":0}]
[{"$nulls":5},"Sales",{"$f":"$D$26*G26","v":0},0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(G27:R27)","v":0}]
[{"$nulls":5},"Profit Rate",0.95,0.95,0.95,0.95,0.95,0.95,0.95,0.95,0.95,0.95,0.95,0.95,0.95]
[{"$nulls":5},"Profit ",{"$f":"G27*G28","v":0},0,0,0,0,0,{"$f":"M27*M28","v":0},{"$f":"N27*N28","v":0},0,0,0,0,0]
["Food & Beverage","Café",null,15,0.6,"Monthly Pax",{"$f":"G4*G6*$E$30","v":2790},2520,3069,3240,2790,2700,4185,4743,4050,3348,2700,2790,{"$f":"SUM(G30:R30)","v":38925}]
[{"$nulls":4}," ","Sales",{"$f":"$D$30*G30","v":41850},37800,46035,48600,41850,40500,62775,71145,60750,50220,40500,41850,{"$f":"SUM(G31:R31)","v":583875}]
[{"$nulls":5},"Profit Rate",0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8]
[{"$nulls":5},"Profit ",{"$f":"G31*G32","v":33480},30240,36828,38880,33480,32400,{"$f":"M31*M32","v":50220},{"$f":"N31*N32","v":56916},48600,40176,32400,33480,467100]
["Food & Beverage","Restaurant rent income",null,9900,null,"Monthly Pax",1,1,1,1,1,1,1,1,1,1,1,1,12]
[{"$nulls":4}," ","Sales",9900,9900,9900,9900,9900,9900,9900,9900,9900,9900,9900,9900,{"$f":"9900*12","v":118800}]
[{"$nulls":5},"Profit Rate",1,1,1,1,1,1,1,1,1,1,1,1,1]
[{"$nulls":5},"Profit ",{"$f":"G35*G36","v":9900},9900,9900,9900,9900,9900,{"$f":"M35*M36","v":9900},{"$f":"N35*N36","v":9900},9900,9900,9900,9900,118800]
[]
[]
[]
[]
[]
[null,"Total Sales Revenue",{"$nulls":4},{"$f":"G11+G15+G19+G23+G27+G31+G35+G39","v":531364.28571428568},{"$f":"H11+H15+H19+H23+H27+H31+H35+H39","v":480900},580056.42857142864,608785.71428571432,531364.28571428568,514542.85714285716,774825,872209.28571428568,750150,628748.57142857148,514542.85714285716,531364.28571428568,{"$f":"SUM(G43:R43)","v":7318853.5714285718}]
[{"$nulls":18},{"$f":"SUM(G43:R43)","v":7318853.5714285718}]
[null,"COGS"]
["Cost of Good Sold","Food &Beberage COGS",{"$nulls":4},{"$f":"(G11*(1-G12))+(G15*(1-G16))+(G19*(1-G20))+(G23*(1-G24))+(G31*(1-G32))+(G35*(1-G36))","v":8369.9999999999982},{"$f":"(H11*(1-H12))+(H15*(1-H16))+(H19*(1-H20))+(H23*(1-H24))+(H31*(1-H32))+(H35*(1-H36))","v":7559.9999999999982},9206.9999999999982,9719.9999999999982,8369.9999999999982,8099.9999999999982,12554.999999999996,14228.999999999996,12149.999999999998,10043.999999999998,8099.9999999999982,8369.9999999999982,{"$f":"SUM(G46:R46)","v":116774.99999999999}]
[null,"Gift supply  COGS",{"$nulls":4},{"$f":"G39*(1-G40)","v":0},{"$f":"H39*(1-H40)","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(G47:R47)","v":0}]
[]
["Total Gross Profit","Total Gross Profit ",{"$nulls":4},{"$f":"G43-G46-G47","v":522994.28571428568},{"$f":"H43-H46-H47","v":473340},570849.42857142864,599065.71428571432,522994.28571428568,506442.85714285716,762270,857980.28571428568,738000,618704.57142857148,506442.85714285716,522994.28571428568,7202078.5714285718]
[null,"Expense"]
["Credit Card Fee/Bank/Other/Misc.","Credit Card Fee/Bank/Other/Misc.",{"$nulls":4},{"$f":"G43*0.02","v":10627.285714285714},9618,11601.128571428573,12175.714285714286,10627.285714285714,10290.857142857143,15496.5,17444.185714285715,15003,12574.971428571429,10290.857142857143,10627.285714285714,146377.07142857145]
["Property Tax - Under Pilot Program","Property Tax - Under Pilot Program",{"$nulls":4},{"$f":"60684/12","v":5057},{"$f":"60684/12","v":5057},5057,5057,5057,5057,5057,5057,5057,5057,5057,5057,{"$f":"SUM(G52:R52)","v":60684}]
["Payroll","Payroll",{"$nulls":4},{"$f":"'payroll.tax Y2'!J37","v":177397.5},{"$f":"$G$53","v":177397.5},{"$f":"$G$53","v":177397.5},177397.5,177397.5,177397.5,177397.5,177397.5,177397.5,177397.5,177397.5,177397.5,2128770]
["Payroll Tax","Payroll Tax",{"$nulls":4},{"$f":"'payroll.tax Y2'!M37","v":12794.448750000001},{"$f":"G54","v":12794.448750000001},{"$f":"H54","v":12794.448750000001},12794.448750000001,12794.448750000001,12794.448750000001,12794.448750000001,12794.448750000001,12794.448750000001,12794.448750000001,12794.448750000001,12794.448750000001,153533.38500000001]
["Sales Tax","Sales Tax",{"$nulls":4},{"$f":"G43*0.08","v":42509.142857142855},38472,46404.514285714293,48702.857142857145,42509.142857142855,41163.428571428572,61986,69776.742857142861,60012,50299.885714285716,41163.428571428572,42509.142857142855,{"$f":"SUM(G55:R55)","v":585508.28571428568}]
["Gas","Gas",{"$nulls":4},{"$f":"143.33*G4","v":4443.2300000000005},{"$f":"143.33*H4","v":4013.2400000000002},4443.2300000000005,4299.9000000000005,4443.2300000000005,4299.9000000000005,4443.2300000000005,4443.2300000000005,4299.9000000000005,4443.2300000000005,4299.9000000000005,4443.2300000000005,52315.450000000012]
["Electricity ","Electricity ",{"$nulls":4},{"$f":"15000*0.352564","v":5288.46},{"$f":"15000*0.352564","v":5288.46},5288.46,5288.46,5288.46,5288.46,5288.46,5288.46,5288.46,5288.46,5288.46,5288.46,63461.52]
["Water & Sewer","Water & Sewer",{"$nulls":4},{"$f":"(($G$4*G6)*6.6043*0.0229)+($G$4*61.01)","v":2594.5688854999999},2594.5688854999999,2664.8947740499998,2735.2206625999997,2594.5688854999999,2594.5688854999999,2946.19832825,3086.8501053500004,2946.19832825,2735.2206625999997,2594.5688854999999,2594.5688854999999,32681.996174100004]
["Phone,Internet,Cable","Phone,Internet,Cable",{"$nulls":4},1500,1500,1500,1500,1500,1500,1500,1500,1500,1500,1500,1500,18000]
["Laundry & Sanitation","Laundry & Sanitation",{"$nulls":4},{"$f":"($G$4*G6*1.4*0.37)+(71.42*$G$4)","v":4622.7199999999993},{"$f":"($G$4*H6*1.4*0.37)+(71.42*$G$4)","v":4622.7199999999993},4863.59,5104.4599999999991,4622.7199999999993,4622.7199999999993,5827.07,6308.8099999999995,5827.07,5104.4599999999991,4622.7199999999993,4622.7199999999993,60771.78]
["Bath house Supplies","Bath house Supplies",{"$nulls":4},{"$f":"G4*G6*0.5","v":2325},2100,2557.5,2700,2325,2250,3487.5,3952.5,3375,2790,2250,2325,32437.5]
[]
["Advertising(Media/ SN/Internet)","Advertising(Media/ SN/Internet)",{"$nulls":4},12000,{"$f":"G63","v":12000},{"$f":"H63","v":12000},12000,12000,12000,12000,12000,12000,12000,12000,12000,144000]
["Litigation,Insurance&Workers Comp","Litigation,Insurance&Workers Comp",{"$nulls":4},7904,7904,7904,7904,7904,7904,7904,7904,7904,7904,7904,7904,94848]
["Depreciation for properties","Depreciation ",{"$nulls":4},5000,5000,5000,5000,5000,5000,5000,5000,5000,5000,5000,5000,60000]
["Loan Principal&Interests","Loan Principal&Interests",{"$nulls":4},31001.24,31001.24,31001.24,31001.24,31001.24,31001.24,31001.24,31001.24,31001.24,31001.24,31001.24,31001.24,372014.87999999995]
["Professional Fee","Professional Fee",{"$nulls":4},4000,4000,4000,4000,4000,4000,4000,4000,4000,4000,4000,4000,48000]
["Pest Control","Pest Control",{"$nulls":4},2083,2083,2083,2083,2083,2083,2083,2083,2083,2083,2083,2083,{"$f":"SUM(G68:R68)","v":24996}]
["Licenses and permits","Licenses and permits",{"$nulls":4},833,833,833,833,833,833,833,833,833,833,833,833,9996]
["Postage and delivery","Postage and delivery",{"$nulls":4},667,667,667,667,667,667,667,667,667,667,667,667,8004]
["Printing (brouchure,sign)","Printing (brouchure,sign)",{"$nulls":4},2000,2000,2000,2000,2000,2000,2000,2000,2000,2000,2000,2000,24000]
["Shuttle service(2 buses)","Bus insurance",{"$nulls":4},8400,8400,8400,8400,8400,8400,8400,8400,8400,8400,8400,8400,100800]
["Shuttle service(2 buses)","Bus maintenance",{"$nulls":4},11700,11700,11700,11700,11700,11700,11700,11700,11700,11700,11700,11700,140400]
["Shuttle service(2 buses)","Bus finance",{"$nulls":4},21183.279999999999,21430,21430,21430,21430,21430,21430,21430,21430,21430,21430,21430,256913.28]
["Dues & Subscription","Dues & Subscription",{"$nulls":4},208.3,208.3,208.3,208.3,208.3,208.3,208.3,208.3,208.3,208.3,208.3,208.3,2499.6000000000004]
["Sub-Total Expense","Sub-Total Expense",{"$nulls":4},{"$f":"SUM(G51:G75)","v":376139.1762069285},{"$f":"SUM(H51:H75)","v":370684.47763549996},381798.80638119287,384982.10084117146,376385.89620692848,374485.42334978568,403450.44707824994,414276.26742677856,400727.11707824998,387211.71655545721,374485.42334978568,376385.89620692848,4621012.7483169567]
["Contingency","Contingency",{"$nulls":4},{"$f":"G76*0.03","v":11284.175286207854},{"$f":"H76*0.03","v":11120.534329064998},11453.964191435785,11549.463025235144,11291.576886207853,11234.56270049357,12103.513412347498,12428.288022803357,12021.813512347499,11616.351496663716,11234.56270049357,11291.576886207853,{"$f":"SUM(G77:R77)","v":138630.3824495087}]
["Total Expense","Total Expense",{"$nulls":4},{"$f":"G76+G77","v":387423.35149313638},{"$f":"H76+H77","v":381805.01196456497},393252.77057262865,396531.56386640662,387677.47309313633,385719.98605027923,415553.96049059741,426704.55544958194,412748.93059059751,398828.06805212091,385719.98605027923,387677.47309313633,{"$f":"SUM(G78:R78)","v":4759643.1307664653}]
[]
["Total Final Net Profit","Total Final Profit",{"$nulls":4},{"$f":"G49-G78","v":135570.93422114931},{"$f":"H49-H78","v":91534.988035435032},177596.65799879999,202534.1504193077,135316.81262114935,120722.87109257793,346716.03950940259,431275.73026470374,325251.06940940249,219876.50337645056,120722.87109257793,135316.81262114935,2442435.4406621065]
[{"$nulls":18},{"$f":"S80/S83","v":5.1328757736237351}]
[{"$nulls":17},"Growth ",{"$f":"(S80/S83)-1","v":4.1328757736237351}]
[{"$nulls":17},"1st Y",{"$f":"'F.P.YEAR 1'!S79","v":475841.52595568914}]

{"sheet":"F.P.YEAR 3","index":3,"n_rows":83,"n_cols":20,"rows_kept":83,"cut":false,"hidden":false,"merged":[[29,1,30,1],[29,3,30,3],[77,3,77,4],[79,3,79,4],[33,1,34,1],[33,3,34,3],[37,1,38,1],[37,3,38,3],[75,3,75,4],[76,3,76,4],[17,1,18,1],[17,3,18,3],[21,1,22,1],[21,3,22,3],[25,1,26,1],[25,3,26,3]]}
[" Year 3 Profit & Loss ",{"$nulls":8},"Peak :",null,"Dec.Jan.Feb & Jun ",null,null,"High Peak :","Jul, Aug"]
[]
[null,"Business",{"$nulls":4},"Jan.","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec","Year Total"]
[{"$nulls":4},"days ","for Month",31,28,31,30,31,30,31,31,30,31,30,31,{"$f":"SUM(G4,H4,I4,J4,K4,L4,M4,N4,O4,P4,Q4,R4)","v":365},"yearly"]
[null,"2nd yr",null,null,"Daily","Vistors",{"$f":"'F.P.YEAR 2'!G6","v":150},{"$f":"'F.P.YEAR 2'!H6","v":150},{"$f":"'F.P.YEAR 2'!I6","v":165},{"$f":"'F.P.YEAR 2'!J6","v":180},{"$f":"'F.P.YEAR 2'!K6","v":150},{"$f":"'F.P.YEAR 2'!L6","v":150},{"$f":"'F.P.YEAR 2'!M6","v":225},{"$f":"'F.P.YEAR 2'!N6","v":255},{"$f":"'F.P.YEAR 2'!O6","v":225},{"$f":"'F.P.YEAR 2'!P6","v":180},{"$f":"'F.P.YEAR 2'!Q6","v":150},{"$f":"'F.P.YEAR 2'!R6","v":150},{"$f":"'F.P.YEAR 2'!S7","v":64875},"yearly"]
["Year 3","3rd yr","rooms","Price/unit",null,"(+10%)",{"$f":"G5*1.1","v":165},{"$f":"H5*1.1","v":165},181.50000000000003,198.00000000000003,165,165,247.50000000000003,280.5,247.50000000000003,198.00000000000003,165,165,null," "]
[null,null," ","occpancy",0.65,"Monthly",{"$f":"G4*G6","v":5115},{"$f":"H4*H6","v":4620},5626.5000000000009,5940.0000000000009,5115,4950,7672.5000000000009,8695.5,7425.0000000000009,6138.0000000000009,4950,5115,{"$f":"SUM(G7:R7)","v":71362.5},"yearly"]
["Lodging ","Room w/attached outdoor Bath (Sulfur Soaking), weekday $250/2pax+weekend $350 / 2pax, Breakfast ,Admission fee included",0,{"$f":"((250*4)+(350*3))/7","v":292.85714285714283},{"$f":"C8*$E$6","v":0},null,{"$f":"$D$8*$E$8*G4","v":0},{"$f":"$D$8*$E$8*H4","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(G8:R8)","v":0}]
[" ","Standard room, weekday $200/2pax+weekend $250 /2pax,Breakfast included",0,{"$f":"((200*4)+(250*3))/7","v":221.42857142857142},{"$f":"C9*$E$6","v":0},null,{"$f":"$D$9*$E$9*G4","v":0},{"$f":"$D$9*$E$9*H4","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(G9:R9)","v":0}]
["Guest House ","Hotel, weekday/N $150/2pax+weekend/N, $200 /2pax,Breakfast.",10,{"$f":"((150*4)+(200*3))/7","v":171.42857142857142},{"$f":"C10*$E$7","v":6.5},"monthly sales",{"$f":"$D$10*$E$10*G4","v":34542.857142857138},{"$f":"$D$10*$E$10*H4","v":31200},34542.857142857138,33428.571428571428,34542.857142857138,33428.571428571428,34542.857142857138,34542.857142857138,33428.571428571428,34542.857142857138,33428.571428571428,34542.857142857138,{"$f":"SUM(G10:R10)","v":406714.28571428568}]
[{"$nulls":5},"Sales Sub TTL",{"$f":"G8+G9+G10","v":34542.857142857138},{"$f":"H8+H9+H10","v":31200},34542.857142857138,33428.571428571428,34542.857142857138,33428.571428571428,34542.857142857138,34542.857142857138,33428.571428571428,34542.857142857138,33428.571428571428,34542.857142857138,{"$f":"SUM(G11:R11)","v":406714.28571428568}]
[" ",{"$nulls":4},"Profit Rate",1,1,1,1,1,1,1,1,1,1,1,1,0.85]
[{"$nulls":5},"Profit ",{"$f":"G11*G12","v":34542.857142857138},{"$f":"H11*H12","v":31200},34542.857142857138,33428.571428571428,34542.857142857138,33428.571428571428,34542.857142857138,34542.857142857138,33428.571428571428,34542.857142857138,33428.571428571428,34542.857142857138,345707.14285714284]
["Spa Service & Program","Main Package[Admission w/ Public Outdoor bath+ indoor private  Bath (Sulfur Soaking)+ 60 Min massage","Ave.",{"$f":"((D16*4)+(D17*3))/7","v":132.85714285714286},0.5,"Monthly Pax",{"$f":"G6*G4*$E$14","v":2557.5},{"$f":"H6*H4*$E$14","v":2310},2813.2500000000005,2970.0000000000005,2557.5,2475,3836.2500000000005,4347.75,3712.5000000000005,3069.0000000000005,2475,2557.5,{"$f":"SUM(G14:R14)","v":35681.25}]
[null," "," ",null," ","Sales",{"$f":"$D$14*G14","v":339782.14285714284},{"$f":"$D$14*H14","v":306900},373760.35714285722,394585.71428571438,339782.14285714284,328821.42857142858,509673.21428571438,577629.64285714284,493232.14285714296,407738.57142857148,328821.42857142858,339782.14285714284,{"$f":"SUM(G15:R15)","v":4740508.9285714291}]
[null,null,"week",120,null,"Profit Rate",1,{"$f":"G16","v":1},{"$f":"H16","v":1},1,1,1,1,1,1,1,1,1,1]
[null,null,"weekend",150,null,"Profit ",{"$f":"G15*G16","v":339782.14285714284},{"$f":"H15*H16","v":306900},373760.35714285722,394585.71428571438,339782.14285714284,328821.42857142858,509673.21428571438,577629.64285714284,493232.14285714296,407738.57142857148,328821.42857142858,339782.14285714284,4740508.9285714291]
[]
[]
[]
[]
["Spa Service & Program","Budget Package[ Addmission+public outdoorbath",null,{"$f":"((D24*4)+(D25*3))/7","v":58.571428571428569},{"$f":"1-E14","v":0.5},"Monthly Pax",{"$f":"G4*G6*$E$22","v":2557.5},2310,2813.2500000000005,2970.0000000000005,2557.5,2475,3836.2500000000005,4347.75,3712.5000000000005,3069.0000000000005,2475,2557.5,{"$f":"SUM(G22:R22)","v":35681.25}]
[{"$nulls":4}," ","Sales",{"$f":"$D$22*G22","v":149796.42857142858},135300,164776.07142857145,173957.14285714287,149796.42857142858,144964.28571428571,224694.64285714287,254653.92857142855,217446.42857142858,179755.71428571432,144964.28571428571,149796.42857142858,{"$f":"SUM(G23:R23)","v":2089901.7857142859}]
[null,null,"week",50,null,"Profit Rate",1,1,1,1,1,1,1,1,1,1,1,1,1]
[null,null,"weekend",70,null,"Profit ",{"$f":"G23*G24","v":149796.42857142858},135300,164776.07142857145,173957.14285714287,149796.42857142858,144964.28571428571,{"$f":"M23*M24","v":224694.64285714287},{"$f":"N23*N24","v":254653.92857142855},217446.42857142858,179755.71428571432,144964.28571428571,149796.42857142858,2089901.7857142859]
["Spa Service & Program","Nail/Foot",null,null,null,"Monthly Pax",0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(G26:R26)","v":0}]
[{"$nulls":5},"Sales",{"$f":"$D$26*G26","v":0},0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(G27:R27)","v":0}]
[{"$nulls":5},"Profit Rate",0.95,0.95,0.95,0.95,0.95,0.95,0.95,0.95,0.95,0.95,0.95,0.95,0.95]
[{"$nulls":5},"Profit ",{"$f":"G27*G28","v":0},0,0,0,0,0,{"$f":"M27*M28","v":0},{"$f":"N27*N28","v":0},0,0,0,0,0]
["Food & Beverage","Café",null,15,0.6,"Monthly Pax",{"$f":"G4*G6*$E$30","v":3069},2772,3375.9000000000005,3564.0000000000005,3069,2970,4603.5,5217.3,4455,3682.8000000000006,2970,3069,{"$f":"SUM(G30:R30)","v":42817.5}]
[{"$nulls":4}," ","Sales",{"$f":"$D$30*G30","v":46035},41580,50638.500000000007,53460.000000000007,46035,44550,69052.5,78259.5,66825,55242.000000000007,44550,46035,{"$f":"SUM(G31:R31)","v":642262.5}]
[{"$nulls":5},"Profit Rate",0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8]
[{"$nulls":5},"Profit ",{"$f":"G31*G32","v":36828},33264,40510.80000000001,42768.000000000007,36828,35640,{"$f":"M31*M32","v":55242},{"$f":"N31*N32","v":62607.600000000006},53460,44193.600000000006,35640,36828,513810]
["Food & Beverage","Restaurant rent income",null,9900,null,"Monthly Pax",1,1,1,1,1,1,1,1,1,1,1,1,12]
[{"$nulls":4}," ","Sales",9900,9900,9900,9900,9900,9900,9900,9900,9900,9900,9900,9900,{"$f":"9900*12","v":118800}]
[{"$nulls":5},"Profit Rate",1,1,1,1,1,1,1,1,1,1,1,1,1]
[{"$nulls":5},"Profit ",{"$f":"G35*G36","v":9900},9900,9900,9900,9900,9900,{"$f":"M35*M36","v":9900},{"$f":"N35*N36","v":9900},9900,9900,9900,9900,118800]
[]
[]
[]
[]
[]
[null,"Total Sales Revenue",{"$nulls":4},{"$f":"G11+G15+G19+G23+G27+G31+G35+G39","v":580056.42857142864},{"$f":"H11+H15+H19+H23+H27+H31+H35+H39","v":524880},633617.7857142858,665331.42857142864,580056.42857142864,561664.28571428568,847863.21428571432,954985.92857142852,820832.14285714296,687179.14285714296,561664.28571428568,580056.42857142864,{"$f":"SUM(G43:R43)","v":7998187.5}]
[{"$nulls":18},{"$f":"SUM(G43:R43)","v":7998187.5}]
[null,"COGS"]
["Cost of Good Sold","Food &Beberage COGS",{"$nulls":4},{"$f":"(G11*(1-G12))+(G15*(1-G16))+(G19*(1-G20))+(G23*(1-G24))+(G31*(1-G32))+(G35*(1-G36))","v":9206.9999999999982},{"$f":"(H11*(1-H12))+(H15*(1-H16))+(H19*(1-H20))+(H23*(1-H24))+(H31*(1-H32))+(H35*(1-H36))","v":8315.9999999999982},10127.699999999999,10691.999999999998,9206.9999999999982,8909.9999999999982,13810.499999999996,15651.899999999996,13364.999999999996,11048.4,8909.9999999999982,9206.9999999999982,{"$f":"SUM(G46:R46)","v":128452.49999999999}]
[null,"Gift supply  COGS",{"$nulls":4},{"$f":"G39*(1-G40)","v":0},{"$f":"H39*(1-H40)","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(G47:R47)","v":0}]
[]
["Total Gross Profit","Total Gross Profit ",{"$nulls":4},{"$f":"G43-G46-G47","v":570849.42857142864},{"$f":"H43-H46-H47","v":516564},623490.08571428584,654639.42857142864,570849.42857142864,552754.28571428568,834052.71428571432,939334.0285714285,807467.14285714296,676130.74285714293,552754.28571428568,570849.42857142864,7869735]
[null,"Expense"]
["Credit Card Fee/Bank/Other/Misc.","Credit Card Fee/Bank/Other/Misc.",{"$nulls":4},{"$f":"G43*0.02","v":11601.128571428573},10497.6,12672.355714285717,13306.628571428573,11601.128571428573,11233.285714285714,16957.264285714286,19099.71857142857,16416.642857142859,13743.582857142859,11233.285714285714,11601.128571428573,159963.75]
["Property Tax - Under Pilot Program","Property Tax - Under Pilot Program",{"$nulls":4},{"$f":"66752/12","v":5562.666666666667},{"$f":"66752/12","v":5562.666666666667},5562.666666666667,5562.666666666667,5562.666666666667,5562.666666666667,5562.666666666667,5562.666666666667,5562.666666666667,5562.666666666667,5562.666666666667,5562.666666666667,{"$f":"SUM(G52:R52)","v":66751.999999999985}]
["Payroll","Payroll",{"$nulls":4},{"$f":"'payroll.tax Y3'!J37","v":186267.375},{"$f":"$G$53","v":186267.375},{"$f":"$G$53","v":186267.375},186267.375,186267.375,186267.375,186267.375,186267.375,186267.375,186267.375,186267.375,186267.375,2235208.5]
["Payroll Tax","Payroll Tax",{"$nulls":4},{"$f":"'payroll.tax Y3'!M37","v":13251.471187499999},{"$f":"G54","v":13251.471187499999},{"$f":"H54","v":13251.471187499999},13251.471187499999,13251.471187499999,13251.471187499999,13251.471187499999,13251.471187499999,13251.471187499999,13251.471187499999,13251.471187499999,13251.471187499999,159017.65424999993]
["Sales Tax","Sales Tax",{"$nulls":4},{"$f":"G43*0.08","v":46404.514285714293},41990.400000000001,50689.422857142868,53226.514285714293,46404.514285714293,44933.142857142855,67829.057142857142,76398.874285714279,65666.571428571435,54974.331428571437,44933.142857142855,46404.514285714293,{"$f":"SUM(G55:R55)","v":639855}]
["Gas","Gas",{"$nulls":4},{"$f":"143.33*G4","v":4443.2300000000005},{"$f":"143.33*H4","v":4013.2400000000002},4443.2300000000005,4299.9000000000005,4443.2300000000005,4299.9000000000005,4443.2300000000005,4443.2300000000005,4299.9000000000005,4443.2300000000005,4299.9000000000005,4443.2300000000005,52315.450000000012]
["Electricity ","Electricity ",{"$nulls":4},{"$f":"15000*0.352564","v":5288.46},{"$f":"15000*0.352564","v":5288.46},5288.46,5288.46,5288.46,5288.46,5288.46,5288.46,5288.46,5288.46,5288.46,5288.46,63461.52]
["Water & Sewer","Water & Sewer",{"$nulls":4},{"$f":"(($G$4*G6)*6.6043*0.0229)+($G$4*61.01)","v":2664.8947740499998},2664.8947740499998,2742.2532514550003,2819.6117288600003,2664.8947740499998,2664.8947740499998,3051.6871610750004,3206.404115885,3051.6871610750004,2819.6117288600003,2664.8947740499998,2664.8947740499998,33680.623791510006]
["Phone,Internet,Cable","Phone,Internet,Cable",{"$nulls":4},1500,1500,1500,1500,1500,1500,1500,1500,1500,1500,1500,1500,18000]
["Laundry & Sanitation","Laundry & Sanitation",{"$nulls":4},{"$f":"($G$4*G6*1.4*0.37)+(71.42*$G$4)","v":4863.59},{"$f":"($G$4*H6*1.4*0.37)+(71.42*$G$4)","v":4863.59},5128.5470000000005,5393.5040000000008,4863.59,4863.59,6188.375,6718.2889999999989,6188.375,5393.5040000000008,4863.59,4863.59,64192.133999999991]
["Bath house Supplies","Bath house Supplies",{"$nulls":4},{"$f":"G4*G6*0.5","v":2557.5},2310,2813.2500000000005,2970.0000000000005,2557.5,2475,3836.2500000000005,4347.75,3712.5000000000005,3069.0000000000005,2475,2557.5,35681.25]
[]
["Advertising(Media/ SN/Internet)","Advertising(Media/ SN/Internet)",{"$nulls":4},12000,{"$f":"G63","v":12000},{"$f":"H63","v":12000},12000,12000,12000,12000,12000,12000,12000,12000,12000,144000]
["Litigation,Insurance&Workers Comp","Litigation,Insurance&Workers Comp",{"$nulls":4},7904,7904,7904,7904,7904,7904,7904,7904,7904,7904,7904,7904,94848]
["Depreciation for properties","Depreciation ",{"$nulls":4},5000,5000,5000,5000,5000,5000,5000,5000,5000,5000,5000,5000,60000]
["Loan Principal&Interests","Loan Principal&Interests",{"$nulls":4},31001.24,31001.24,31001.24,31001.24,31001.24,31001.24,31001.24,31001.24,31001.24,31001.24,31001.24,31001.24,372014.87999999995]
["Professional Fee","Professional Fee",{"$nulls":4},4000,4000,4000,4000,4000,4000,4000,4000,4000,4000,4000,4000,48000]
["Pest Control","Pest Control",{"$nulls":4},2083,2083,2083,2083,2083,2083,2083,2083,2083,2083,2083,2083,{"$f":"SUM(G68:R68)","v":24996}]
["Licenses and permits","Licenses and permits",{"$nulls":4},833,833,833,833,833,833,833,833,833,833,833,833,9996]
["Postage and delivery","Postage and delivery",{"$nulls":4},667,667,667,667,667,667,667,667,667,667,667,667,8004]
["Printing (brouchure,sign)","Printing (brouchure,sign)",{"$nulls":4},2000,2000,2000,2000,2000,2000,2000,2000,2000,2000,2000,2000,24000]
["Shuttle service(2 buses)","Bus insurance",{"$nulls":4},8400,8400,8400,8400,8400,8400,8400,8400,8400,8400,8400,8400,100800]
["Shuttle service(2 buses)","Bus maintenance",{"$nulls":4},11700,11700,11700,11700,11700,11700,11700,11700,11700,11700,11700,11700,140400]
["Shuttle service(2 buses)","Bus finance",{"$nulls":4},21183.279999999999,21430,21430,21430,21430,21430,21430,21430,21430,21430,21430,21430,256913.28]
["Dues & Subscription","Dues & Subscription",{"$nulls":4},208.3,208.3,208.3,208.3,208.3,208.3,208.3,208.3,208.3,208.3,208.3,208.3,2499.6000000000004]
["Sub-Total Expense","Sub-Total Expense",{"$nulls":4},{"$f":"SUM(G51:G75)","v":391384.65048535954},{"$f":"SUM(H51:H75)","v":385436.23762821662},397585.57167705026,401112.67144016956,391631.37048535951,389566.32619964523,421402.37644381309,433310.77882719447,418432.18930095597,403539.77286874095,389566.32619964523,391631.37048535951,4814599.6420415109]
["Contingency","Contingency",{"$nulls":4},{"$f":"G76*0.03","v":11741.539514560785},{"$f":"H76*0.03","v":11563.087128846499},11927.567150311508,12033.380143205086,11748.941114560785,11686.989785989357,12642.071293314391,12999.323364815833,12552.965679028679,12106.193186062228,11686.989785989357,11748.941114560785,{"$f":"SUM(G77:R77)","v":144437.9892612453}]
["Total Expense","Total Expense",{"$nulls":4},{"$f":"G76+G77","v":403126.18999992032},{"$f":"H76+H77","v":396999.32475706312},409513.13882736175,413146.05158337468,403380.31159992027,401253.31598563457,434044.44773712748,446310.10219201032,430985.15497998463,415645.96605480317,401253.31598563457,403380.31159992027,{"$f":"SUM(G78:R78)","v":4959037.6313027553}]
[]
["Total Final Net Profit","Total Final Profit",{"$nulls":4},{"$f":"G49-G78","v":167723.23857150832},{"$f":"H49-H78","v":119564.67524293688},213976.9468869241,241493.37698805396,167469.11697150837,151500.96972865111,400008.26654858683,493023.92637941818,376481.98787715833,260484.77680233977,151500.96972865111,167469.11697150837,2910697.3686972447]
[{"$nulls":18},{"$f":"S80/S83","v":1.1917192652216837}]
[{"$nulls":17},"Growth ",{"$f":"(S80/S83)-1","v":0.1917192652216837},"yearly"]
[{"$nulls":17},"2nd Y",{"$f":"'F.P.YEAR 2'!S80","v":2442435.4406621065}]

{"sheet":"F.P.YEAR 4","index":4,"n_rows":83,"n_cols":20,"rows_kept":83,"cut":false,"hidden":false,"merged":[[75,3,75,4],[76,3,76,4],[77,3,77,4],[79,3,79,4],[29,1,30,1],[29,3,30,3],[33,1,34,1],[33,3,34,3],[37,1,38,1],[37,3,38,3],[17,1,18,1],[17,3,18,3],[21,1,22,1],[21,3,22,3],[25,1,26,1],[25,3,26,3]]}
[" Year 3 Profit & Loss ",{"$nulls":8},"Peak :",null,"Dec.Jan.Feb & Jun ",null,null,"High Peak :","Jul, Aug"]
[]
[null,"Business",{"$nulls":4},"Jan.","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec","Year Total"]
[{"$nulls":4},"days ","for Month",31,28,31,30,31,30,31,31,30,31,30,31,{"$f":"SUM(G4,H4,I4,J4,K4,L4,M4,N4,O4,P4,Q4,R4)","v":365},"yearly"]
[null,"2nd yr",null,null,"Daily","Vistors",{"$f":"'F.P.YEAR 3'!G6","v":165},{"$f":"'F.P.YEAR 3'!H6","v":165},{"$f":"'F.P.YEAR 3'!I6","v":181.50000000000003},{"$f":"'F.P.YEAR 3'!J6","v":198.00000000000003},{"$f":"'F.P.YEAR 3'!K6","v":165},{"$f":"'F.P.YEAR 3'!L6","v":165},{"$f":"'F.P.YEAR 3'!M6","v":247.50000000000003},{"$f":"'F.P.YEAR 3'!N6","v":280.5},{"$f":"'F.P.YEAR 3'!O6","v":247.50000000000003},{"$f":"'F.P.YEAR 3'!P6","v":198.00000000000003},{"$f":"'F.P.YEAR 3'!Q6","v":165},{"$f":"'F.P.YEAR 3'!R6","v":165},{"$f":"'F.P.YEAR 3'!S7","v":71362.5},"yearly"]
["Year 3","3rd yr","rooms","Price/unit",null,"(+10%)",{"$f":"G5*1.1","v":181.50000000000003},{"$f":"H5*1.1","v":181.50000000000003},199.65000000000003,217.80000000000004,181.50000000000003,181.50000000000003,272.25000000000006,308.55,272.25000000000006,217.80000000000004,181.50000000000003,181.50000000000003," "," "]
[null,null," ","occpancy",0.65,"Monthly",{"$f":"G4*G6","v":5626.5000000000009},{"$f":"H4*H6","v":5082.0000000000009},6189.1500000000015,6534.0000000000009,5626.5000000000009,5445.0000000000009,8439.7500000000018,9565.0500000000011,8167.5000000000018,6751.8000000000011,5445.0000000000009,5626.5000000000009,{"$f":"SUM(G7:R7)","v":78498.75},"yearly"]
["Lodging ","Room w/attached outdoor Bath (Sulfur Soaking), weekday $250/2pax+weekend $350 / 2pax, Breakfast ,Admission fee included",0,{"$f":"((250*4)+(350*3))/7","v":292.85714285714283},{"$f":"C8*$E$6","v":0},null,{"$f":"$D$8*$E$8*G4","v":0},{"$f":"$D$8*$E$8*H4","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(G8:R8)","v":0}]
[" ","Standard room, weekday $200/2pax+weekend $250 /2pax,Breakfast included",0,{"$f":"((200*4)+(250*3))/7","v":221.42857142857142},{"$f":"C9*$E$6","v":0},null,{"$f":"$D$9*$E$9*G4","v":0},{"$f":"$D$9*$E$9*H4","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(G9:R9)","v":0}]
["Guest House ","Hotel, weekday/N $150/2pax+weekend/N, $200 /2pax,Breakfast.",10,{"$f":"((150*4)+(200*3))/7","v":171.42857142857142},{"$f":"C10*$E$7","v":6.5},"monthly sales",{"$f":"$D$10*$E$10*G4","v":34542.857142857138},{"$f":"$D$10*$E$10*H4","v":31200},34542.857142857138,33428.571428571428,34542.857142857138,33428.571428571428,34542.857142857138,34542.857142857138,33428.571428571428,34542.857142857138,33428.571428571428,34542.857142857138,{"$f":"SUM(G10:R10)","v":406714.28571428568}]
[{"$nulls":5},"Sales Sub TTL",{"$f":"G8+G9+G10","v":34542.857142857138},{"$f":"H8+H9+H10","v":31200},34542.857142857138,33428.571428571428,34542.857142857138,33428.571428571428,34542.857142857138,34542.857142857138,33428.571428571428,34542.857142857138,33428.571428571428,34542.857142857138,{"$f":"SUM(G11:R11)","v":406714.28571428568}]
[" ",{"$nulls":4},"Profit Rate",1,1,1,1,1,1,1,1,1,1,1,1,0.85]
[{"$nulls":5},"Profit ",{"$f":"G11*G12","v":34542.857142857138},{"$f":"H11*H12","v":31200},34542.857142857138,33428.571428571428,34542.857142857138,33428.571428571428,34542.857142857138,34542.857142857138,33428.571428571428,34542.857142857138,33428.571428571428,34542.857142857138,345707.14285714284]
["Spa Service & Program","Main Package[Admission w/ Public Outdoor bath+ indoor private  Bath (Sulfur Soaking)+ 60 Min massage","Ave.",{"$f":"((D16*4)+(D17*3))/7","v":132.85714285714286},0.5,"Monthly Pax",{"$f":"G6*G4*$E$14","v":2813.2500000000005},{"$f":"H6*H4*$E$14","v":2541.0000000000005},3094.5750000000007,3267.0000000000005,2813.2500000000005,2722.5000000000005,4219.8750000000009,4782.5250000000005,4083.7500000000009,3375.9000000000005,2722.5000000000005,2813.2500000000005,{"$f":"SUM(G14:R14)","v":39249.375}]
[null," "," ",null," ","Sales",{"$f":"$D$14*G14","v":373760.35714285722},{"$f":"$D$14*H14","v":337590.00000000006},411136.39285714296,434044.2857142858,373760.35714285722,361703.57142857148,560640.5357142858,635392.60714285728,542555.35714285728,448512.42857142864,361703.57142857148,373760.35714285722,{"$f":"SUM(G15:R15)","v":5214559.8214285728}]
[null,null,"week",120,null,"Profit Rate",1,{"$f":"G16","v":1},{"$f":"H16","v":1},1,1,1,1,1,1,1,1,1,1]
[null,null,"weekend",150,null,"Profit ",{"$f":"G15*G16","v":373760.35714285722},{"$f":"H15*H16","v":337590.00000000006},411136.39285714296,434044.2857142858,373760.35714285722,361703.57142857148,560640.5357142858,635392.60714285728,542555.35714285728,448512.42857142864,361703.57142857148,373760.35714285722,5214559.8214285728]
[]
[]
[]
[]
["Spa Service & Program","Budget Package[ Addmission+public outdoorbath",null,{"$f":"((D24*4)+(D25*3))/7","v":58.571428571428569},{"$f":"1-E14","v":0.5},"Monthly Pax",{"$f":"G4*G6*$E$22","v":2813.2500000000005},2541.0000000000005,3094.5750000000007,3267.0000000000005,2813.2500000000005,2722.5000000000005,4219.8750000000009,4782.5250000000005,4083.7500000000009,3375.9000000000005,2722.5000000000005,2813.2500000000005,{"$f":"SUM(G22:R22)","v":39249.375}]
[{"$nulls":4}," ","Sales",{"$f":"$D$22*G22","v":164776.07142857145},148830.00000000003,181253.67857142861,191352.85714285716,164776.07142857145,159460.71428571432,247164.10714285719,280119.32142857148,239191.07142857148,197731.28571428574,159460.71428571432,164776.07142857145,{"$f":"SUM(G23:R23)","v":2298891.9642857146}]
[null,null,"week",50,null,"Profit Rate",1,1,1,1,1,1,1,1,1,1,1,1,1]
[null,null,"weekend",70,null,"Profit ",{"$f":"G23*G24","v":164776.07142857145},148830.00000000003,181253.67857142861,191352.85714285716,164776.07142857145,159460.71428571432,{"$f":"M23*M24","v":247164.10714285719},{"$f":"N23*N24","v":280119.32142857148},239191.07142857148,197731.28571428574,159460.71428571432,164776.07142857145,2298891.9642857146]
["Spa Service & Program","Nail/Foot",null,null,null,"Monthly Pax",0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(G26:R26)","v":0}]
[{"$nulls":5},"Sales",{"$f":"$D$26*G26","v":0},0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(G27:R27)","v":0}]
[{"$nulls":5},"Profit Rate",0.95,0.95,0.95,0.95,0.95,0.95,0.95,0.95,0.95,0.95,0.95,0.95,0.95]
[{"$nulls":5},"Profit ",{"$f":"G27*G28","v":0},0,0,0,0,0,{"$f":"M27*M28","v":0},{"$f":"N27*N28","v":0},0,0,0,0,0]
["Food & Beverage","Café",null,15,0.6,"Monthly Pax",{"$f":"G4*G6*$E$30","v":3375.9000000000005},3049.2000000000003,3713.4900000000007,3920.4000000000005,3375.9000000000005,3267.0000000000005,5063.8500000000013,5739.0300000000007,4900.5000000000009,4051.0800000000004,3267.0000000000005,3375.9000000000005,{"$f":"SUM(G30:R30)","v":47099.250000000007}]
[{"$nulls":4}," ","Sales",{"$f":"$D$30*G30","v":50638.500000000007},45738.000000000007,55702.350000000013,58806.000000000007,50638.500000000007,49005.000000000007,75957.750000000015,86085.450000000012,73507.500000000015,60766.200000000004,49005.000000000007,50638.500000000007,{"$f":"SUM(G31:R31)","v":706488.75}]
[{"$nulls":5},"Profit Rate",0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8]
[{"$nulls":5},"Profit ",{"$f":"G31*G32","v":40510.80000000001},36590.400000000009,44561.880000000012,47044.80000000001,40510.80000000001,39204.000000000007,{"$f":"M31*M32","v":60766.200000000012},{"$f":"N31*N32","v":68868.360000000015},58806.000000000015,48612.960000000006,39204.000000000007,40510.80000000001,565191]
["Food & Beverage","Restaurant rent income",null,9900,null,"Monthly Pax",1,1,1,1,1,1,1,1,1,1,1,1,12]
[{"$nulls":4}," ","Sales",9900,9900,9900,9900,9900,9900,9900,9900,9900,9900,9900,9900,{"$f":"9900*12","v":118800}]
[{"$nulls":5},"Profit Rate",1,1,1,1,1,1,1,1,1,1,1,1,1]
[{"$nulls":5},"Profit ",{"$f":"G35*G36","v":9900},9900,9900,9900,9900,9900,{"$f":"M35*M36","v":9900},{"$f":"N35*N36","v":9900},9900,9900,9900,9900,118800]
[]
[]
[]
[]
[]
[null,"Total Sales Revenue",{"$nulls":4},{"$f":"G11+G15+G19+G23+G27+G31+G35+G39","v":633617.7857142858},{"$f":"H11+H15+H19+H23+H27+H31+H35+H39","v":573258.00000000012},692535.27857142873,727531.71428571432,633617.7857142858,613497.85714285728,928205.25000000012,1046040.2357142859,898582.50000000023,751452.77142857155,613497.85714285728,633617.7857142858,{"$f":"SUM(G43:R43)","v":8745454.8214285728}]
[{"$nulls":18},{"$f":"SUM(G43:R43)","v":8745454.8214285728}]
[null,"COGS"]
["Cost of Good Sold","Food &Beberage COGS",{"$nulls":4},{"$f":"(G11*(1-G12))+(G15*(1-G16))+(G19*(1-G20))+(G23*(1-G24))+(G31*(1-G32))+(G35*(1-G36))","v":10127.699999999999},{"$f":"(H11*(1-H12))+(H15*(1-H16))+(H19*(1-H20))+(H23*(1-H24))+(H31*(1-H32))+(H35*(1-H36))","v":9147.5999999999985},11140.47,11761.199999999999,10127.699999999999,9801,15191.55,17217.09,14701.5,12153.239999999998,9801,10127.699999999999,{"$f":"SUM(G46:R46)","v":141297.75}]
[null,"Gift supply  COGS",{"$nulls":4},{"$f":"G39*(1-G40)","v":0},{"$f":"H39*(1-H40)","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(G47:R47)","v":0}]
[]
["Total Gross Profit","Total Gross Profit ",{"$nulls":4},{"$f":"G43-G46-G47","v":623490.08571428584},{"$f":"H43-H46-H47","v":564110.40000000014},681394.80857142876,715770.51428571437,623490.08571428584,603696.85714285728,913013.70000000007,1028823.1457142859,883881.00000000023,739299.53142857156,603696.85714285728,623490.08571428584,8604157.0714285728]
[null,"Expense"]
["Credit Card Fee/Bank/Other/Misc.","Credit Card Fee/Bank/Other/Misc.",{"$nulls":4},{"$f":"G43*0.02","v":12672.355714285717},11465.160000000002,13850.705571428574,14550.634285714286,12672.355714285717,12269.957142857145,18564.105000000003,20920.804714285718,17971.650000000005,15029.055428571432,12269.957142857145,12672.355714285717,174909.09642857147]
["Property Tax - Under Pilot Program","Property Tax - Under Pilot Program",{"$nulls":4},{"$f":"66752/12","v":5562.666666666667},{"$f":"66752/12","v":5562.666666666667},5562.666666666667,5562.666666666667,5562.666666666667,5562.666666666667,5562.666666666667,5562.666666666667,5562.666666666667,5562.666666666667,5562.666666666667,5562.666666666667,{"$f":"SUM(G52:R52)","v":66751.999999999985}]
["Payroll","Payroll",{"$nulls":4},{"$f":"'payroll.tax Y4'!J37","v":195580.74375000002},{"$f":"$G$53","v":195580.74375000002},{"$f":"$G$53","v":195580.74375000002},195580.74375000002,195580.74375000002,195580.74375000002,195580.74375000002,195580.74375000002,195580.74375000002,195580.74375000002,195580.74375000002,195580.74375000002,2346968.9249999998]
["Payroll Tax","Payroll Tax",{"$nulls":4},{"$f":"'payroll.tax Y4'!M37","v":13914.044746874999},{"$f":"G54","v":13914.044746874999},{"$f":"H54","v":13914.044746874999},13914.044746874999,13914.044746874999,13914.044746874999,13914.044746874999,13914.044746874999,13914.044746874999,13914.044746874999,13914.044746874999,13914.044746874999,166968.53696250005]
["Sales Tax","Sales Tax",{"$nulls":4},{"$f":"G43*0.08","v":50689.422857142868},45860.640000000007,55402.822285714297,58202.537142857145,50689.422857142868,49079.828571428581,74256.420000000013,83683.218857142871,71886.60000000002,60116.221714285726,49079.828571428581,50689.422857142868,699636.38571428566]
["Gas","Gas",{"$nulls":4},{"$f":"143.33*G4","v":4443.2300000000005},{"$f":"143.33*H4","v":4013.2400000000002},4443.2300000000005,4299.9000000000005,4443.2300000000005,4299.9000000000005,4443.2300000000005,4443.2300000000005,4299.9000000000005,4443.2300000000005,4299.9000000000005,4443.2300000000005,52315.450000000012]
["Electricity ","Electricity ",{"$nulls":4},{"$f":"15000*0.352564","v":5288.46},{"$f":"15000*0.352564","v":5288.46},5288.46,5288.46,5288.46,5288.46,5288.46,5288.46,5288.46,5288.46,5288.46,5288.46,63461.52]
["Water & Sewer","Water & Sewer",{"$nulls":4},{"$f":"(($G$4*G6)*6.6043*0.0229)+($G$4*61.01)","v":2742.2532514550003},2742.2532514550003,2827.3475766005004,2912.441901746,2742.2532514550003,2742.2532514550003,3167.7248771825002,3337.9135274734999,3167.7248771825002,2912.441901746,2742.2532514550003,2742.2532514550003,34779.114170661]
["Phone,Internet,Cable","Phone,Internet,Cable",{"$nulls":4},1500,1500,1500,1500,1500,1500,1500,1500,1500,1500,1500,1500,18000]
["Laundry & Sanitation","Laundry & Sanitation",{"$nulls":4},{"$f":"($G$4*G6*1.4*0.37)+(71.42*$G$4)","v":5128.5470000000005},{"$f":"($G$4*H6*1.4*0.37)+(71.42*$G$4)","v":5128.5470000000005},5419.9997000000003,5711.4524000000001,5128.5470000000005,5128.5470000000005,6585.8104999999996,7168.7159000000011,6585.8104999999996,5711.4524000000001,5128.5470000000005,5128.5470000000005,67954.523400000005]
["Bath house Supplies","Bath house Supplies",{"$nulls":4},{"$f":"G4*G6*0.5","v":2813.2500000000005},2541.0000000000005,3094.5750000000007,3267.0000000000005,2813.2500000000005,2722.5000000000005,4219.8750000000009,4782.5250000000005,4083.7500000000009,3375.9000000000005,2722.5000000000005,2813.2500000000005,39249.375]
[]
["Advertising(Media/ SN/Internet)","Advertising(Media/ SN/Internet)",{"$nulls":4},12000,{"$f":"G63","v":12000},{"$f":"H63","v":12000},12000,12000,12000,12000,12000,12000,12000,12000,12000,144000]
["Litigation,Insurance&Workers Comp","Litigation,Insurance&Workers Comp",{"$nulls":4},7904,7904,7904,7904,7904,7904,7904,7904,7904,7904,7904,7904,94848]
["Depreciation for properties","Depreciation ",{"$nulls":4},5000,5000,5000,5000,5000,5000,5000,5000,5000,5000,5000,5000,60000]
["Loan Principal&Interests","Loan Principal&Interests",{"$nulls":4},31001.24,31001.24,31001.24,31001.24,31001.24,31001.24,31001.24,31001.24,31001.24,31001.24,31001.24,31001.24,372014.87999999995]
["Professional Fee","Professional Fee",{"$nulls":4},4000,4000,4000,4000,4000,4000,4000,4000,4000,4000,4000,4000,48000]
["Pest Control","Pest Control",{"$nulls":4},2083,2083,2083,2083,2083,2083,2083,2083,2083,2083,2083,2083,{"$f":"SUM(G68:R68)","v":24996}]
["Licenses and permits","Licenses and permits",{"$nulls":4},833,833,833,833,833,833,833,833,833,833,833,833,9996]
["Postage and delivery","Postage and delivery",{"$nulls":4},667,667,667,667,667,667,667,667,667,667,667,667,8004]
["Printing (brouchure,sign)","Printing (brouchure,sign)",{"$nulls":4},2000,2000,2000,2000,2000,2000,2000,2000,2000,2000,2000,2000,24000]
["Shuttle service(2 buses)","Bus insurance",{"$nulls":4},8400,8400,8400,8400,8400,8400,8400,8400,8400,8400,8400,8400,100800]
["Shuttle service(2 buses)","Bus maintenance",{"$nulls":4},11700,11700,11700,11700,11700,11700,11700,11700,11700,11700,11700,11700,140400]
["Shuttle service(2 buses)","Bus finance",{"$nulls":4},21183.279999999999,21430,21430,21430,21430,21430,21430,21430,21430,21430,21430,21430,256913.28]
["Dues & Subscription","Dues & Subscription",{"$nulls":4},208.3,208.3,208.3,208.3,208.3,208.3,208.3,208.3,208.3,208.3,208.3,208.3,2499.6000000000004]
["Sub-Total Expense","Sub-Total Expense",{"$nulls":4},{"$f":"SUM(G51:G75)","v":407314.79398642533},{"$f":"SUM(H51:H75)","v":400823.29541499674},414111.13529728504,418016.42089385912,407561.5139864253,405315.44112928252,440309.62054072425,453408.86316244386,437067.89054072427,420660.75660814485,405315.44112928252,407561.5139864253,5017466.6866760179]
["Contingency","Contingency",{"$nulls":4},{"$f":"G76*0.03","v":12219.44381959276},{"$f":"H76*0.03","v":12024.698862449903},12423.33405891855,12540.492626815772,12226.845419592759,12159.463233878476,13209.288616221727,13602.265894873315,13112.036716221728,12619.822698244345,12159.463233878476,12226.845419592759,{"$f":"SUM(G77:R77)","v":150524.00060028056}]
["Total Expense","Total Expense",{"$nulls":4},{"$f":"G76+G77","v":419534.23780601809},{"$f":"H76+H77","v":412847.99427744665},426534.46935620357,430556.91352067492,419788.35940601805,417474.90436316101,453518.909156946,467011.12905731716,450179.92725694599,433280.57930638921,417474.90436316101,419788.35940601805,{"$f":"SUM(G78:R78)","v":5167990.6872762991}]
[]
["Total Final Net Profit","Total Final Profit",{"$nulls":4},{"$f":"G49-G78","v":203955.84790826775},{"$f":"H49-H78","v":151262.40572255349},254860.33921522519,285213.60076503945,203701.7263082678,186221.95277969626,459494.79084305407,561812.01665696874,433701.07274305425,306018.95212218235,186221.95277969626,203701.7263082678,3436166.3841522736]
[{"$nulls":18},{"$f":"S80/S83","v":1.1805302815421912}]
[{"$nulls":17},"Growth ",{"$f":"(S80/S83)-1","v":0.1805302815421912},"yearly"]
[{"$nulls":17},"3rd Y",{"$f":"'F.P.YEAR 3'!S80","v":2910697.3686972447}]

{"sheet":"F.P.YEAR 5","index":5,"n_rows":83,"n_cols":20,"rows_kept":83,"cut":false,"hidden":false,"merged":[[75,3,75,4],[76,3,76,4],[77,3,77,4],[79,3,79,4],[29,1,30,1],[29,3,30,3],[33,1,34,1],[33,3,34,3],[37,1,38,1],[37,3,38,3],[17,1,18,1],[17,3,18,3],[21,1,22,1],[21,3,22,3],[25,1,26,1],[25,3,26,3]]}
[" Year 3 Profit & Loss ",{"$nulls":8},"Peak :",null,"Dec.Jan.Feb & Jun ",null,null,"High Peak :","Jul, Aug"]
[]
[null,"Business",{"$nulls":4},"Jan.","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec","Year Total"]
[{"$nulls":4},"days ","for Month",31,28,31,30,31,30,31,31,30,31,30,31,{"$f":"SUM(G4,H4,I4,J4,K4,L4,M4,N4,O4,P4,Q4,R4)","v":365},"yearly"]
[null,"2nd yr",null,null,"Daily","Vistors",{"$f":"'F.P.YEAR 4'!G6","v":181.50000000000003},{"$f":"'F.P.YEAR 4'!H6","v":181.50000000000003},{"$f":"'F.P.YEAR 4'!I6","v":199.65000000000003},{"$f":"'F.P.YEAR 4'!J6","v":217.80000000000004},{"$f":"'F.P.YEAR 4'!K6","v":181.50000000000003},{"$f":"'F.P.YEAR 4'!L6","v":181.50000000000003},{"$f":"'F.P.YEAR 4'!M6","v":272.25000000000006},{"$f":"'F.P.YEAR 4'!N6","v":308.55},{"$f":"'F.P.YEAR 4'!O6","v":272.25000000000006},{"$f":"'F.P.YEAR 4'!P6","v":217.80000000000004},{"$f":"'F.P.YEAR 4'!Q6","v":181.50000000000003},{"$f":"'F.P.YEAR 4'!R6","v":181.50000000000003},{"$f":"'F.P.YEAR 4'!S7","v":78498.75},"yearly"]
["Year 3","3rd yr","rooms","Price/unit",null,"(+10%)",{"$f":"G5*1.1","v":199.65000000000003},{"$f":"H5*1.1","v":199.65000000000003},219.61500000000007,239.58000000000007,199.65000000000003,199.65000000000003,299.47500000000008,339.40500000000003,299.47500000000008,239.58000000000007,199.65000000000003,199.65000000000003," "," "]
[null,null," ","occpancy",0.65,"Monthly",{"$f":"G4*G6","v":6189.1500000000015},{"$f":"H4*H6","v":5590.2000000000007},6808.0650000000023,7187.4000000000024,6189.1500000000015,5989.5000000000009,9283.7250000000022,10521.555,8984.2500000000018,7426.9800000000023,5989.5000000000009,6189.1500000000015,{"$f":"SUM(G7:R7)","v":86348.625000000029},"yearly"]
["Lodging ","Room w/attached outdoor Bath (Sulfur Soaking), weekday $250/2pax+weekend $350 / 2pax, Breakfast ,Admission fee included",0,{"$f":"((250*4)+(350*3))/7","v":292.85714285714283},{"$f":"C8*$E$6","v":0},null,{"$f":"$D$8*$E$8*G4","v":0},{"$f":"$D$8*$E$8*H4","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(G8:R8)","v":0}]
[" ","Standard room, weekday $200/2pax+weekend $250 /2pax,Breakfast included",0,{"$f":"((200*4)+(250*3))/7","v":221.42857142857142},{"$f":"C9*$E$6","v":0},null,{"$f":"$D$9*$E$9*G4","v":0},{"$f":"$D$9*$E$9*H4","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(G9:R9)","v":0}]
["Guest House ","Hotel, weekday/N $150/2pax+weekend/N, $200 /2pax,Breakfast.",10,{"$f":"((150*4)+(200*3))/7","v":171.42857142857142},{"$f":"C10*$E$7","v":6.5},"monthly sales",{"$f":"$D$10*$E$10*G4","v":34542.857142857138},{"$f":"$D$10*$E$10*H4","v":31200},34542.857142857138,33428.571428571428,34542.857142857138,33428.571428571428,34542.857142857138,34542.857142857138,33428.571428571428,34542.857142857138,33428.571428571428,34542.857142857138,{"$f":"SUM(G10:R10)","v":406714.28571428568}]
[{"$nulls":5},"Sales Sub TTL",{"$f":"G8+G9+G10","v":34542.857142857138},{"$f":"H8+H9+H10","v":31200},34542.857142857138,33428.571428571428,34542.857142857138,33428.571428571428,34542.857142857138,34542.857142857138,33428.571428571428,34542.857142857138,33428.571428571428,34542.857142857138,{"$f":"SUM(G11:R11)","v":406714.28571428568}]
[" ",{"$nulls":4},"Profit Rate",1,1,1,1,1,1,1,1,1,1,1,1,0.85]
[{"$nulls":5},"Profit ",{"$f":"G11*G12","v":34542.857142857138},{"$f":"H11*H12","v":31200},34542.857142857138,33428.571428571428,34542.857142857138,33428.571428571428,34542.857142857138,34542.857142857138,33428.571428571428,34542.857142857138,33428.571428571428,34542.857142857138,345707.14285714284]
["Spa Service & Program","Main Package[Admission w/ Public Outdoor bath+ indoor private  Bath (Sulfur Soaking)+ 60 Min massage","Ave.",{"$f":"((D16*4)+(D17*3))/7","v":132.85714285714286},0.5,"Monthly Pax",{"$f":"G6*G4*$E$14","v":3094.5750000000007},{"$f":"H6*H4*$E$14","v":2795.1000000000004},3404.0325000000012,3593.7000000000012,3094.5750000000007,2994.7500000000005,4641.8625000000011,5260.7775000000001,4492.1250000000009,3713.4900000000011,2994.7500000000005,3094.5750000000007,{"$f":"SUM(G14:R14)","v":43174.312500000015}]
[null," "," ",null," ","Sales",{"$f":"$D$14*G14","v":411136.39285714296},{"$f":"$D$14*H14","v":371349.00000000006},452250.03214285732,477448.71428571444,411136.39285714296,397873.92857142864,616704.58928571444,698931.86785714293,596810.89285714296,493363.67142857157,397873.92857142864,411136.39285714296,{"$f":"SUM(G15:R15)","v":5736015.80357143}]
[null,null,"week",120,null,"Profit Rate",1,{"$f":"G16","v":1},{"$f":"H16","v":1},1,1,1,1,1,1,1,1,1,1]
[null,null,"weekend",150,null,"Profit ",{"$f":"G15*G16","v":411136.39285714296},{"$f":"H15*H16","v":371349.00000000006},452250.03214285732,477448.71428571444,411136.39285714296,397873.92857142864,616704.58928571444,698931.86785714293,596810.89285714296,493363.67142857157,397873.92857142864,411136.39285714296,5736015.80357143]
[]
[]
[]
[]
["Spa Service & Program","Budget Package[ Addmission+public outdoorbath",null,{"$f":"((D24*4)+(D25*3))/7","v":58.571428571428569},{"$f":"1-E14","v":0.5},"Monthly Pax",{"$f":"G4*G6*$E$22","v":3094.5750000000007},2795.1000000000004,3404.0325000000012,3593.7000000000012,3094.5750000000007,2994.7500000000005,4641.8625000000011,5260.7775000000001,4492.1250000000009,3713.4900000000011,2994.7500000000005,3094.5750000000007,{"$f":"SUM(G22:R22)","v":43174.312500000015}]
[{"$nulls":4}," ","Sales",{"$f":"$D$22*G22","v":181253.67857142861},163713.00000000003,199379.04642857148,210488.14285714293,181253.67857142861,175406.78571428574,271880.5178571429,308131.25357142859,263110.17857142864,217504.41428571436,175406.78571428574,181253.67857142861,{"$f":"SUM(G23:R23)","v":2528781.1607142864}]
[null,null,"week",50,null,"Profit Rate",1,1,1,1,1,1,1,1,1,1,1,1,1]
[null,null,"weekend",70,null,"Profit ",{"$f":"G23*G24","v":181253.67857142861},163713.00000000003,199379.04642857148,210488.14285714293,181253.67857142861,175406.78571428574,{"$f":"M23*M24","v":271880.5178571429},{"$f":"N23*N24","v":308131.25357142859},263110.17857142864,217504.41428571436,175406.78571428574,181253.67857142861,2528781.1607142864]
["Spa Service & Program","Nail/Foot",null,null,null,"Monthly Pax",0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(G26:R26)","v":0}]
[{"$nulls":5},"Sales",{"$f":"$D$26*G26","v":0},0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(G27:R27)","v":0}]
[{"$nulls":5},"Profit Rate",0.95,0.95,0.95,0.95,0.95,0.95,0.95,0.95,0.95,0.95,0.95,0.95,0.95]
[{"$nulls":5},"Profit ",{"$f":"G27*G28","v":0},0,0,0,0,0,{"$f":"M27*M28","v":0},{"$f":"N27*N28","v":0},0,0,0,0,0]
["Food & Beverage","Café",null,15,0.6,"Monthly Pax",{"$f":"G4*G6*$E$30","v":3713.4900000000007},3354.1200000000003,4084.8390000000013,4312.4400000000014,3713.4900000000007,3593.7000000000003,5570.2350000000015,6312.933,5390.5500000000011,4456.188000000001,3593.7000000000003,3713.4900000000007,{"$f":"SUM(G30:R30)","v":51809.175000000003}]
[{"$nulls":4}," ","Sales",{"$f":"$D$30*G30","v":55702.350000000013},50311.8,61272.585000000021,64686.60000000002,55702.350000000013,53905.500000000007,83553.525000000023,94693.994999999995,80858.250000000015,66842.820000000022,53905.500000000007,55702.350000000013,{"$f":"SUM(G31:R31)","v":777137.62500000023}]
[{"$nulls":5},"Profit Rate",0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8]
[{"$nulls":5},"Profit ",{"$f":"G31*G32","v":44561.880000000012},40249.440000000002,49018.068000000021,51749.280000000021,44561.880000000012,43124.400000000009,{"$f":"M31*M32","v":66842.820000000022},{"$f":"N31*N32","v":75755.195999999996},64686.600000000013,53474.256000000023,43124.400000000009,44561.880000000012,621710.10000000021]
["Food & Beverage","Restaurant rent income",null,9900,null,"Monthly Pax",1,1,1,1,1,1,1,1,1,1,1,1,12]
[{"$nulls":4}," ","Sales",9900,9900,9900,9900,9900,9900,9900,9900,9900,9900,9900,9900,{"$f":"9900*12","v":118800}]
[{"$nulls":5},"Profit Rate",1,1,1,1,1,1,1,1,1,1,1,1,1]
[{"$nulls":5},"Profit ",{"$f":"G35*G36","v":9900},9900,9900,9900,9900,9900,{"$f":"M35*M36","v":9900},{"$f":"N35*N36","v":9900},9900,9900,9900,9900,118800]
[]
[]
[]
[]
[]
[null,"Total Sales Revenue",{"$nulls":4},{"$f":"G11+G15+G19+G23+G27+G31+G35+G39","v":692535.27857142873},{"$f":"H11+H15+H19+H23+H27+H31+H35+H39","v":626473.80000000016},757344.52071428602,795952.02857142873,692535.27857142873,670514.7857142858,1016581.4892857146,1146199.9735714286,984107.89285714307,822153.76285714319,670514.7857142858,692535.27857142873,{"$f":"SUM(G43:R43)","v":9567448.8750000019}]
[{"$nulls":18},{"$f":"SUM(G43:R43)","v":9567448.8750000019}]
[null,"COGS"]
["Cost of Good Sold","Food &Beberage COGS",{"$nulls":4},{"$f":"(G11*(1-G12))+(G15*(1-G16))+(G19*(1-G20))+(G23*(1-G24))+(G31*(1-G32))+(G35*(1-G36))","v":11140.47},{"$f":"(H11*(1-H12))+(H15*(1-H16))+(H19*(1-H20))+(H23*(1-H24))+(H31*(1-H32))+(H35*(1-H36))","v":10062.359999999999},12254.517000000002,12937.320000000002,11140.47,10781.099999999999,16710.705000000002,18938.798999999995,16171.65,13368.564000000002,10781.099999999999,{"$f":"(R11*(1-R12))+(R15*(1-R16))+(R19*(1-R20))+(R23*(1-R24))+(R31*(1-R32))+(R35*(1-R36))","v":11140.47},{"$f":"SUM(G46:R46)","v":155427.52499999999}]
[null,"Gift supply  COGS",{"$nulls":4},{"$f":"G39*(1-G40)","v":0},{"$f":"H39*(1-H40)","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(G47:R47)","v":0}]
[]
["Total Gross Profit","Total Gross Profit ",{"$nulls":4},{"$f":"G43-G46-G47","v":681394.80857142876},{"$f":"H43-H46-H47","v":616411.44000000018},745090.00371428602,783014.70857142878,681394.80857142876,659733.68571428582,999870.78428571462,1127261.1745714287,967936.24285714305,808785.19885714317,659733.68571428582,681394.80857142876,9412021.3500000015]
[null,"Expense"]
["Credit Card Fee/Bank/Other/Misc.","Credit Card Fee/Bank/Other/Misc.",{"$nulls":4},{"$f":"G43*0.02","v":13850.705571428574},12529.476000000004,15146.890414285721,15919.040571428575,13850.705571428574,13410.295714285716,20331.629785714293,22923.999471428571,19682.157857142862,16443.075257142864,13410.295714285716,13850.705571428574,191348.97750000004]
["Property Tax - Under Pilot Program","Property Tax - Under Pilot Program",{"$nulls":4},{"$f":"66752/12","v":5562.666666666667},{"$f":"66752/12","v":5562.666666666667},5562.666666666667,5562.666666666667,5562.666666666667,5562.666666666667,5562.666666666667,5562.666666666667,5562.666666666667,5562.666666666667,5562.666666666667,5562.666666666667,{"$f":"SUM(G52:R52)","v":66751.999999999985}]
["Payroll","Payroll",{"$nulls":4},{"$f":"'payroll.tax Y5'!J37","v":205359.78093750004},{"$f":"$G$53","v":205359.78093750004},{"$f":"$G$53","v":205359.78093750004},205359.78093750004,205359.78093750004,205359.78093750004,205359.78093750004,205359.78093750004,205359.78093750004,205359.78093750004,205359.78093750004,205359.78093750004,2464317.3712500003]
["Payroll Tax","Payroll Tax",{"$nulls":4},{"$f":"'payroll.tax Y5'!M37","v":14609.746984218751},{"$f":"G54","v":14609.746984218751},{"$f":"H54","v":14609.746984218751},14609.746984218751,14609.746984218751,14609.746984218751,14609.746984218751,14609.746984218751,14609.746984218751,14609.746984218751,14609.746984218751,14609.746984218751,175316.96381062499]
["Sales Tax","Sales Tax",{"$nulls":4},{"$f":"G43*0.08","v":55402.822285714297},50117.904000000017,60587.561657142884,63676.162285714301,55402.822285714297,53641.182857142863,81326.519142857171,91695.997885714285,78728.631428571447,65772.301028571455,53641.182857142863,55402.822285714297,765395.91000000015]
["Gas","Gas",{"$nulls":4},{"$f":"143.33*G4","v":4443.2300000000005},{"$f":"143.33*H4","v":4013.2400000000002},4443.2300000000005,4299.9000000000005,4443.2300000000005,4299.9000000000005,4443.2300000000005,4443.2300000000005,4299.9000000000005,4443.2300000000005,4299.9000000000005,4443.2300000000005,52315.450000000012]
["Electricity ","Electricity ",{"$nulls":4},{"$f":"15000*0.352564","v":5288.46},{"$f":"15000*0.352564","v":5288.46},5288.46,5288.46,5288.46,5288.46,5288.46,5288.46,5288.46,5288.46,5288.46,5288.46,63461.52]
["Water & Sewer","Water & Sewer",{"$nulls":4},{"$f":"(($G$4*G6)*6.6043*0.0229)+($G$4*61.01)","v":2827.3475766005004},2827.3475766005004,2920.9513342605505,3014.5550919206007,2827.3475766005004,2827.3475766005004,3295.3663649007503,3482.5738802208502,3295.3663649007503,3014.5550919206007,2827.3475766005004,2827.3475766005004,35987.453587727105]
["Phone,Internet,Cable","Phone,Internet,Cable",{"$nulls":4},1500,1500,1500,1500,1500,1500,1500,1500,1500,1500,1500,1500,18000]
["Laundry & Sanitation","Laundry & Sanitation",{"$nulls":4},{"$f":"($G$4*G6*1.4*0.37)+(71.42*$G$4)","v":5419.9997000000003},{"$f":"($G$4*H6*1.4*0.37)+(71.42*$G$4)","v":5419.9997000000003},5740.597670000001,6061.1956400000008,5419.9997000000003,5419.9997000000003,7022.9895500000002,7664.1854899999998,7022.9895500000002,6061.1956400000008,5419.9997000000003,5419.9997000000003,72093.151740000016]
["Bath house Supplies","Bath house Supplies",{"$nulls":4},{"$f":"G4*G6*0.5","v":3094.5750000000007},2795.1000000000004,3404.0325000000012,3593.7000000000012,3094.5750000000007,2994.7500000000005,4641.8625000000011,5260.7775000000001,4492.1250000000009,3713.4900000000011,2994.7500000000005,3094.5750000000007,43174.312500000015]
[]
["Advertising(Media/ SN/Internet)","Advertising(Media/ SN/Internet)",{"$nulls":4},12000,{"$f":"G63","v":12000},{"$f":"H63","v":12000},12000,12000,12000,12000,12000,12000,12000,12000,12000,144000]
["Litigation,Insurance&Workers Comp","Litigation,Insurance&Workers Comp",{"$nulls":4},7904,7904,7904,7904,7904,7904,7904,7904,7904,7904,7904,7904,94848]
["Depreciation for properties","Depreciation ",{"$nulls":4},5000,5000,5000,5000,5000,5000,5000,5000,5000,5000,5000,5000,60000]
["Loan Principal&Interests","Loan Principal&Interests",{"$nulls":4},31001.24,31001.24,31001.24,31001.24,31001.24,31001.24,31001.24,31001.24,31001.24,31001.24,31001.24,31001.24,372014.87999999995]
["Professional Fee","Professional Fee",{"$nulls":4},4000,4000,4000,4000,4000,4000,4000,4000,4000,4000,4000,4000,48000]
["Pest Control","Pest Control",{"$nulls":4},2083,2083,2083,2083,2083,2083,2083,2083,2083,2083,2083,2083,{"$f":"SUM(G68:R68)","v":24996}]
["Licenses and permits","Licenses and permits",{"$nulls":4},833,833,833,833,833,833,833,833,833,833,833,833,9996]
["Postage and delivery","Postage and delivery",{"$nulls":4},667,667,667,667,667,667,667,667,667,667,667,667,8004]
["Printing (brouchure,sign)","Printing (brouchure,sign)",{"$nulls":4},2000,2000,2000,2000,2000,2000,2000,2000,2000,2000,2000,2000,24000]
["Shuttle service(2 buses)","Bus insurance",{"$nulls":4},8400,8400,8400,8400,8400,8400,8400,8400,8400,8400,8400,8400,100800]
["Shuttle service(2 buses)","Bus maintenance",{"$nulls":4},11700,11700,11700,11700,11700,11700,11700,11700,11700,11700,11700,11700,140400]
["Shuttle service(2 buses)","Bus finance",{"$nulls":4},21183.279999999999,21430,21430,21430,21430,21430,21430,21430,21430,21430,21430,21430,256913.28]
["Dues & Subscription","Dues & Subscription",{"$nulls":4},208.3,208.3,208.3,208.3,208.3,208.3,208.3,208.3,208.3,208.3,208.3,208.3,2499.6000000000004]
["Sub-Total Expense","Sub-Total Expense",{"$nulls":4},{"$f":"SUM(G51:G75)","v":424339.15472212882},{"$f":"SUM(H51:H75)","v":417250.26186498592},431790.45816407463,436111.74817744893,424585.87472212879,422140.67043641454,460608.79193185765,475017.95881574909,457068.3647890006,438995.04160602036,422140.67043641454,424585.87472212879,5234634.8703883532]
["Contingency","Contingency",{"$nulls":4},{"$f":"G76*0.03","v":12730.174641663863},{"$f":"H76*0.03","v":12517.507855949578},12953.713744922239,13083.352445323468,12737.576241663863,12664.220113092435,13818.263757955729,14250.538764472472,13712.050943670018,13169.85124818061,12664.220113092435,12737.576241663863,{"$f":"SUM(G77:R77)","v":157039.04611165056}]
["Total Expense","Total Expense",{"$nulls":4},{"$f":"G76+G77","v":437069.32936379267},{"$f":"H76+H77","v":429767.7697209355},444744.17190899688,449195.10062277241,437323.45096379268,434804.89054950699,474427.05568981339,489268.49758022156,470780.41573267063,452164.89285420097,434804.89054950699,437323.45096379268,{"$f":"SUM(G78:R78)","v":5391673.9165000031}]
[]
["Total Final Net Profit","Total Final Profit",{"$nulls":4},{"$f":"G49-G78","v":244325.47920763609},{"$f":"H49-H78","v":186643.67027906468},300345.83180528914,333819.60794865637,244071.35760763608,224928.79516477883,525443.72859590128,637992.67699120706,497155.82712447242,356620.3060029422,224928.79516477883,244071.35760763608,4020347.4334999984]
[{"$nulls":18},{"$f":"S80/S83","v":1.1700095350568556}]
[{"$nulls":17},"Growth ",{"$f":"(S80/S83)-1","v":0.17000953505685557},"yearly"]
[{"$nulls":17},"4th Y",{"$f":"'F.P.YEAR 4'!S80","v":3436166.3841522736}]

{"sheet":"payroll.tax Y1","index":6,"n_rows":38,"n_cols":14,"rows_kept":38,"cut":false,"hidden":false,"merged":[[1,1,1,13],[35,10,35,13]]}
[]
[null,"Payroll & Payroll Tax  (Year 1)"]
[{"$nulls":6},"Min.Pay",15,null,null,"Fed. Tax",null,"State UI Base",11600]
[{"$nulls":6},"Year 1"," ",null,null,6.2E-2,1.4500000000000001E-2,{"$f":"'Fed.NYS.Tax-UI-BASE'!H11","v":2.5750000000000002E-2}]
[{"$nulls":4},"Year 1 Rate","Hour","Day 365","Persons","Yearly Wage","Wage Per Person","SS Tax","Med tax","UI N.Employer","NYS U.I"]
[null,"General Manager",null,"General Manager",180000,null,null,1,{"$f":"E6*H6","v":180000},{"$f":"I6/H6","v":180000},{"$f":"I6*K4","v":11160},{"$f":"I6*L$4","v":2610},{"$f":"$N$3*H6*M$4","v":298.70000000000005},{"$f":"11400*H6*N$4","v":0}]
[{"$nulls":8},{"$f":"E7*F7*G7*H7","v":0},null,{"$f":"I7*K$4","v":0},0,{"$f":"$N$3*H7*M$4","v":0},{"$f":"11400*H7*N$4","v":0}]
[null,"Accounting",null,"Senior Accountant",80000,null,null,1,{"$f":"E8*H8","v":80000},{"$f":"I8/H8","v":80000},4960,1160,298.70000000000005,{"$f":"11400*H8*N$4","v":0}]
[null,null,null,"Assistant accountants",35000,null,null,1,{"$f":"E9*H9","v":35000},35000,2170,507.5,298.70000000000005,{"$f":"11400*H9*N$4","v":0}]
[null,"Customer Satisfaction",null,"Customer Service Manager",80000,null,null,1,{"$f":"E10*H10","v":80000},80000,4960,1160,298.70000000000005,{"$f":"11400*H10*N$4","v":0}]
[null,null,null,"Reception_Entrance Room",20,8,365,4,{"$f":"E11*F11*G11*H11","v":233600},58400,14483.2,3387.2000000000003,1194.8000000000002,0]
[null,null,null,"Reception_Gift Shop",20,8,365,0,0,{"$error":"#DIV/0!"},0,0,0,0]
[null,null,null,"Reception_Customer Service",20,8,365,0,0,{"$error":"#DIV/0!"},0,0,0,0]
[{"$nulls":8},0,null,null,null,0,0]
[null,"Management",null,"Maintenance Manager",120000,null,null,1,{"$f":"E15*H15","v":120000},{"$f":"I15/H15","v":120000},{"$f":"I15*K$4","v":7440},{"$f":"I15*L$4","v":1740},298.70000000000005,0]
[null,null,null,"Building & Pool Maintenance",20,12,365,3,262800,{"$f":"I16/H16","v":87600},16293.6,{"$f":"I16*L$4","v":3810.6000000000004},896.1,0]
[null,null,null,"House Keeper(Service Personal)",20,8,365,2,{"$f":"E17*F17*G17*H17","v":116800},{"$f":"I17/H17","v":58400},7241.6,{"$f":"I17*L$4","v":1693.6000000000001},597.40000000000009,{"$f":"11400*H17*N$4","v":0}]
[null,null,null,"Security Manager",20,8,365,0,0,{"$f":"I18/H18","v":{"$error":"#DIV/0!"}},0,{"$f":"I18*L$4","v":0},0,0]
[{"$nulls":4},20,null,null,null,0,null,0,0,0,0]
[null,null,null,"IT  ",80000,null,null,1,{"$f":"E20*H20","v":80000},{"$f":"I20/H20","v":80000},4960,1160,298.70000000000005,0]
[]
[]
[null,"Food","Restaurant & Café","Food & Beverage",20,8,365,3,175200,null,null,2540.4,896.1,0]
[null,null,null,"Restaurant Cook",0,null,null,0,{"$f":"E24*H24","v":0},{"$f":"I24/H24","v":{"$error":"#DIV/0!"}},{"$f":"I24*K$4","v":0},0,0,{"$f":"11400*H24*N$4","v":0}]
[null,null,null,"Restaurant serve",0,0,0,0,0,{"$f":"I25/H25","v":{"$error":"#DIV/0!"}},{"$f":"I25*K$4","v":0},0,0,0]
[null,null,null,"Restaurant Cashier",0,0,0,0,0,{"$f":"I26/H26","v":{"$error":"#DIV/0!"}},{"$f":"I26*K$4","v":0},0,0,0]
[{"$nulls":8},0,null,null,0,0,0]
[null,"Shuttle bus",null,"Driver",80000,0,0,0,{"$f":"E28*H28","v":0},null,null,{"$f":"I28*L$4","v":0},{"$f":"$N$3*H28*M$4","v":0},{"$f":"11400*H28*N$4","v":0}]
[]
[]
[{"$nulls":8},0,null,null,0,0,0]
[null,"Spa",null,"Spa Service Manager",80000,null,null,1,{"$f":"E32*H32","v":80000},{"$f":"I32/H32","v":80000},{"$f":"I32*K$4","v":4960},1160,298.70000000000005,0]
[null,"Massage Program  ",null,"Spa Employees",20,8,365,10,584000,{"$f":"I33/H33","v":58400},{"$f":"I33*K$4","v":36208},8468,2987.0000000000005,0]
[{"$nulls":9},"Sub Tax",{"$f":"SUM(K6:K33)","v":114836.4},{"$f":"SUM(L6:L33)","v":29397.300000000003},{"$f":"SUM(M6:M33)","v":8662.3000000000011},{"$f":"SUM(N6:N33)","v":0}]
[]
[null,"Total",{"$nulls":5},{"$f":"SUM(H6:H33)","v":29},{"$f":"SUM(I6:I33)","v":2027400},"Total Tax",{"$f":"K34+L34+M34+N34","v":152896}]
[{"$nulls":6},"AVG","MONTHLY PAYMENT",{"$f":"I36/12","v":168950},null,"MONTHLY PAYROLL-TAX",{"$f":"K36/12","v":12741.333333333334}]
[{"$nulls":6},"AVG","Year/Person",{"$f":"I36/H36","v":69910.344827586203}]

{"sheet":"payroll.tax Y2","index":7,"n_rows":38,"n_cols":15,"rows_kept":38,"cut":false,"hidden":false,"merged":[[1,1,1,14],[35,11,35,14]]}
[]
[null,"Payroll & Payroll Tax  (Year 2)"]
[{"$nulls":11},"Fed. Tax",null,"State UI Base",{"$f":"'Fed.NYS.Tax-UI-BASE'!B13","v":12000}]
[{"$nulls":5},"+5%",{"$nulls":5},6.2E-2,1.4500000000000001E-2,null,{"$f":"'Fed.NYS.Tax-UI-BASE'!H12","v":6.0000000000000001E-3}]
[{"$nulls":4},"Year 1 Rate","Year 2 Rate","Hour","Day 365","Persons","Yearly Wage","Wage Per Person","SS Tax","Med tax","UI N.Employer","NYS U.I"]
[null,"General Manager",null,"General Manager",{"$f":"'payroll.tax Y1'!E6","v":180000},{"$f":"E6*(1+$F$4)","v":189000},null,null,{"$f":"'payroll.tax Y1'!H6","v":1},{"$f":"F6*I6","v":189000},{"$f":"J6/I6","v":189000},{"$f":"J6*L4","v":11718},{"$f":"J6*M$4","v":2740.5},{"$f":"11400*I6*N$4","v":0},{"$f":"$O$3*I6*O$4","v":72}]
[{"$nulls":4},{"$f":"'payroll.tax Y1'!E7","v":0},{"$f":"E7*(1+$F$4)","v":0},null,null,{"$f":"'payroll.tax Y1'!H7","v":0},{"$f":"F7*G7*H7*I7","v":0},null,{"$f":"J7*L$4","v":0},0,0,{"$f":"$O$3*I7*O$4","v":0}]
[null,"Accounting",null,"CFO",{"$f":"'payroll.tax Y1'!E8","v":80000},84000,null,null,{"$f":"'payroll.tax Y1'!H8","v":1},{"$f":"F8*I8","v":84000},{"$f":"J8/I8","v":84000},5208,1218,0,72]
[null,null,null,"Assistant accountants",{"$f":"'payroll.tax Y1'!E9","v":35000},36750,null,null,{"$f":"'payroll.tax Y1'!H9","v":1},{"$f":"F9*I9","v":36750},{"$f":"J9/I9","v":36750},2278.5,532.875,0,72]
[null,"Customer Satisfaction",null,"Customer Service Manager",{"$f":"'payroll.tax Y1'!E10","v":80000},84000,null,null,{"$f":"'payroll.tax Y1'!H10","v":1},{"$f":"F10*I10","v":84000},{"$f":"J10/I10","v":84000},5208,1218,0,72]
[null,null,null,"Reception_Entrance Room",{"$f":"'payroll.tax Y1'!E11","v":20},21,8,365,{"$f":"'payroll.tax Y1'!H11","v":4},{"$f":"F11*G11*H11*I11","v":245280},{"$f":"J11/I11","v":61320},15207.36,3556.5600000000004,0,288]
[null,null,null,"Reception_Gift Shop",{"$f":"'payroll.tax Y1'!E12","v":20},21,8,365,{"$f":"'payroll.tax Y1'!H12","v":0},0,{"$error":"#DIV/0!"},0,0,{"$f":"11400*I12*N$4","v":0},0]
[null,null,null,"Reception_Customer Service",{"$f":"'payroll.tax Y1'!E13","v":20},21,8,365,{"$f":"'payroll.tax Y1'!H13","v":0},0,{"$error":"#DIV/0!"},0,0,0,0]
[{"$nulls":4},{"$f":"'payroll.tax Y1'!E14","v":0},0,null,null,{"$f":"'payroll.tax Y1'!H14","v":0},0,null,null,null,0,0]
[null,"Management",null,"Maintenance Manager",{"$f":"'payroll.tax Y1'!E15","v":120000},126000,null,null,{"$f":"'payroll.tax Y1'!H15","v":1},{"$f":"F15*I15","v":126000},126000,{"$f":"J15*L$4","v":7812},{"$f":"J15*M$4","v":1827},0,72]
[null,null,null,"Building & Pool Maintenance",{"$f":"'payroll.tax Y1'!E16","v":20},21,12,365,{"$f":"'payroll.tax Y1'!H16","v":3},275940,91980,17108.28,4001.13,0,216]
[null,null,null,"House Keeper(Service Personal)",{"$f":"'payroll.tax Y1'!E17","v":20},21,8,365,{"$f":"'payroll.tax Y1'!H17","v":2},122640,61320,7603.68,1778.2800000000002,0,144]
[null,null,null,"Security Manager",{"$f":"'payroll.tax Y1'!E18","v":20},21,8,365,{"$f":"'payroll.tax Y1'!H18","v":0},0,{"$error":"#DIV/0!"},0,0,0,0]
[{"$nulls":4},{"$f":"'payroll.tax Y1'!E19","v":20},21,null,null,{"$f":"'payroll.tax Y1'!H19","v":0},null,null,0,0,0,0]
[null,null,null,"IT  ",{"$f":"'payroll.tax Y1'!E20","v":80000},84000,null,null,{"$f":"'payroll.tax Y1'!H20","v":1},{"$f":"F20*I20","v":84000},{"$f":"J20/I20","v":84000},5208,{"$f":"J20*M$4","v":1218},{"$f":"11400*I20*N$4","v":0},72]
[{"$nulls":4},{"$f":"'payroll.tax Y1'!E21","v":0},0,null,null,{"$f":"'payroll.tax Y1'!H21","v":0},null,null,0,{"$f":"J21*M$4","v":0},{"$f":"11400*I21*N$4","v":0},0]
[{"$nulls":4},{"$f":"'payroll.tax Y1'!E22","v":0},0,null,null,{"$f":"'payroll.tax Y1'!H22","v":0},null,null,0,{"$f":"J22*M$4","v":0},{"$f":"11400*I22*N$4","v":0},0]
[null,"Food","Restaurant & Café","Food & Beverage",{"$f":"'payroll.tax Y1'!E23","v":20},21,8,365,{"$f":"'payroll.tax Y1'!H23","v":3},183960,null,null,2667.42,0,216]
[null,null,null,"Restaurant Cook",{"$f":"'payroll.tax Y1'!E24","v":0},0,0,0,{"$f":"'payroll.tax Y1'!H24","v":0},{"$f":"F24*I24","v":0},{"$error":"#DIV/0!"},{"$f":"J24*L$4","v":0},0,0,0]
[null,null,null,"Restaurant Cook Assistant ",{"$f":"'payroll.tax Y1'!E25","v":0},0,0,0,{"$f":"'payroll.tax Y1'!H25","v":0},0,{"$error":"#DIV/0!"},{"$f":"J25*L$4","v":0},0,0,0]
[null,null,null,"Restaurant Cashier",{"$f":"'payroll.tax Y1'!E26","v":0},0,0,0,{"$f":"'payroll.tax Y1'!H26","v":0},0,{"$error":"#DIV/0!"},{"$f":"J26*L$4","v":0},0,0,0]
[{"$nulls":4},{"$f":"'payroll.tax Y1'!E27","v":0},0,null,null,{"$f":"'payroll.tax Y1'!H27","v":0},0,null,null,0,0,0]
[null,"Shuttle bus",null,"Driver",{"$f":"'payroll.tax Y1'!E28","v":80000},84000,null,0,{"$f":"'payroll.tax Y1'!H28","v":0},{"$f":"F28*I28","v":0},null,null,0,0,0]
[{"$nulls":4},{"$f":"'payroll.tax Y1'!E29","v":0},0,null,null,{"$f":"'payroll.tax Y1'!H29","v":0},null,null,null,0,0,0]
[{"$nulls":4},{"$f":"'payroll.tax Y1'!E30","v":0},0,null,null,{"$f":"'payroll.tax Y1'!H30","v":0},null,null,null,0,0,0]
[{"$nulls":4},{"$f":"'payroll.tax Y1'!E31","v":0},0,null,null,{"$f":"'payroll.tax Y1'!H31","v":0},0,null,null,0,0,0]
[null,"Spa",null,"Spa Service Manager",{"$f":"'payroll.tax Y1'!E32","v":80000},84000,null,null,{"$f":"'payroll.tax Y1'!H32","v":1},{"$f":"F32*I32","v":84000},{"$f":"J32/I32","v":84000},{"$f":"J32*L$4","v":5208},1218,0,72]
[null,"Massage Program (with Body Scrub)",null,"Spa Employees",{"$f":"'payroll.tax Y1'!E33","v":20},21,8,365,{"$f":"'payroll.tax Y1'!H33","v":10},613200,61320,{"$f":"J33*L$4","v":38018.400000000001},8891.4,0,720]
[{"$nulls":10},"Sub Tax",{"$f":"SUM(L6:L33)","v":120578.22},{"$f":"SUM(M6:M33)","v":30867.165000000001},{"$f":"SUM(N6:N33)","v":0},{"$f":"SUM(O6:O33)","v":2088}]
[]
[null,"Total",{"$nulls":6},{"$f":"SUM(I6:I33)","v":29},{"$f":"SUM(J6:J33)","v":2128770},"Total Tax",{"$f":"L34+M34+N34+O34","v":153533.38500000001}]
[{"$nulls":7},"AVG","MONTHLY PAYMENT",{"$f":"J36/12","v":177397.5},null,"MONTHLY PAYROLL-TAX",{"$f":"L36/12","v":12794.448750000001}]
[{"$nulls":7},"AVG","Year/Person",{"$f":"J36/I36","v":73405.862068965522}]

{"sheet":"payroll.tax Y3","index":8,"n_rows":38,"n_cols":15,"rows_kept":38,"cut":false,"hidden":false,"merged":[[1,1,1,14],[35,11,35,14]]}
[]
[null,"Payroll & Payroll Tax  (Year 3)"]
[{"$nulls":11},"Fed. Tax",null,"State UI Base",{"$f":"'Fed.NYS.Tax-UI-BASE'!B14","v":0}]
[{"$nulls":5},"+5%",{"$nulls":5},6.2E-2,1.4500000000000001E-2,null,{"$f":"'Fed.NYS.Tax-UI-BASE'!H13","v":6.0000000000000001E-3}]
[{"$nulls":4},"Year 2 Rate","Year 3 Rate","Hour","Day 365","Persons","Yearly Wage","Wage Per Person","SS Tax","Med tax","UI N.Employer","NYS U.I"]
[null,"General Manager",null,"General Manager",{"$f":"'payroll.tax Y2'!F6","v":189000},{"$f":"E6*(1+$F$4)","v":198450},null,null,{"$f":"'payroll.tax Y2'!I6","v":1},{"$f":"F6*I6","v":198450},{"$f":"J6/I6","v":198450},{"$f":"J6*L4","v":12303.9},{"$f":"J6*M$4","v":2877.5250000000001},{"$f":"11400*I6*N$4","v":0},{"$f":"$O$3*I6*O$4","v":0}]
[{"$nulls":4},{"$f":"'payroll.tax Y2'!F7","v":0},{"$f":"E7*(1+$F$4)","v":0},null,null,{"$f":"'payroll.tax Y2'!I7","v":0},{"$f":"F7*G7*H7*I7","v":0},null,{"$f":"J7*L$4","v":0},0,0,{"$f":"$O$3*I7*O$4","v":0}]
[null,"Accounting",null,"CFO",{"$f":"'payroll.tax Y2'!F8","v":84000},88200,null,null,{"$f":"'payroll.tax Y2'!I8","v":1},{"$f":"F8*I8","v":88200},{"$f":"J8/I8","v":88200},5468.4,1278.9000000000001,0,0]
[null,null,null,"Assistant accountants",{"$f":"'payroll.tax Y2'!F9","v":36750},38587.5,null,null,{"$f":"'payroll.tax Y2'!I9","v":1},{"$f":"F9*I9","v":38587.5},{"$f":"J9/I9","v":38587.5},2392.4250000000002,559.51875000000007,0,0]
[null,"Customer Satisfaction",null,"Customer Service Manager",{"$f":"'payroll.tax Y2'!F10","v":84000},88200,null,null,{"$f":"'payroll.tax Y2'!I10","v":1},{"$f":"F10*I10","v":88200},{"$f":"J10/I10","v":88200},5468.4,1278.9000000000001,0,0]
[null,null,null,"Reception_Entrance Room",{"$f":"'payroll.tax Y2'!F11","v":21},22.05,8,365,{"$f":"'payroll.tax Y2'!I11","v":4},{"$f":"F11*G11*H11*I11","v":257544},{"$f":"J11/I11","v":64386},15967.727999999999,3734.3880000000004,0,0]
[null,null,null,"Reception_Gift Shop",{"$f":"'payroll.tax Y2'!F12","v":21},22.05,8,365,{"$f":"'payroll.tax Y2'!I12","v":0},0,{"$error":"#DIV/0!"},0,0,{"$f":"11400*I12*N$4","v":0},0]
[null,null,null,"Reception_Customer Service",{"$f":"'payroll.tax Y2'!F13","v":21},22.05,8,365,{"$f":"'payroll.tax Y2'!I13","v":0},0,{"$error":"#DIV/0!"},0,0,0,0]
[{"$nulls":4},{"$f":"'payroll.tax Y2'!F14","v":0},0,null,null,{"$f":"'payroll.tax Y2'!I14","v":0},0,null,null,null,0,0]
[null,"Management",null,"Maintenance Manager",{"$f":"'payroll.tax Y2'!F15","v":126000},132300,null,null,{"$f":"'payroll.tax Y2'!I15","v":1},{"$f":"F15*I15","v":132300},132300,{"$f":"J15*L$4","v":8202.6},{"$f":"J15*M$4","v":1918.3500000000001},0,0]
[null,null,null,"Building & Pool Maintenance",{"$f":"'payroll.tax Y2'!F16","v":21},22.05,12,365,{"$f":"'payroll.tax Y2'!I16","v":3},289737.00000000006,96579.000000000015,17963.694000000003,4201.1865000000007,0,0]
[null,null,null,"House Keeper(Service Personal)",{"$f":"'payroll.tax Y2'!F17","v":21},22.05,8,365,{"$f":"'payroll.tax Y2'!I17","v":2},128772,64386,7983.8639999999996,1867.1940000000002,0,0]
[null,null,null,"Security Manager",{"$f":"'payroll.tax Y2'!F18","v":21},22.05,8,365,{"$f":"'payroll.tax Y2'!I18","v":0},0,{"$error":"#DIV/0!"},0,0,0,0]
[{"$nulls":4},{"$f":"'payroll.tax Y2'!F19","v":21},22.05,null,null,{"$f":"'payroll.tax Y2'!I19","v":0}]
[null,null,null,"IT  ",{"$f":"'payroll.tax Y2'!F20","v":84000},88200,null,null,{"$f":"'payroll.tax Y2'!I20","v":1},{"$f":"F20*I20","v":88200},{"$f":"J20/I20","v":88200},5468.4,{"$f":"J20*M$4","v":1278.9000000000001},{"$f":"11400*I20*N$4","v":0},0]
[{"$nulls":4},{"$f":"'payroll.tax Y2'!F21","v":0},0,null,null,{"$f":"'payroll.tax Y2'!I21","v":0}]
[{"$nulls":4},{"$f":"'payroll.tax Y2'!F22","v":0},0,null,null,{"$f":"'payroll.tax Y2'!I22","v":0}]
[null,"Food","Restaurant & Café","Food & Beverage",{"$f":"'payroll.tax Y2'!F23","v":21},22.05,8,365,{"$f":"'payroll.tax Y2'!I23","v":3},193158,null,null,2800.7910000000002,0,0]
[null,null,null,"Restaurant Cook",{"$f":"'payroll.tax Y2'!F24","v":0},0,null,null,{"$f":"'payroll.tax Y2'!I24","v":0},{"$f":"F24*I24","v":0},{"$error":"#DIV/0!"},{"$f":"J24*L$4","v":0},0,0,0]
[null,null,null,"Restaurant Cook Assistant ",{"$f":"'payroll.tax Y2'!F25","v":0},0,8,365,{"$f":"'payroll.tax Y2'!I25","v":0},0,{"$error":"#DIV/0!"},{"$f":"J25*L$4","v":0},0,0,0]
[null,null,null,"Restaurant Cashier",{"$f":"'payroll.tax Y2'!F26","v":0},0,8,365,{"$f":"'payroll.tax Y2'!I26","v":0},0,{"$error":"#DIV/0!"},{"$f":"J26*L$4","v":0},0,0,0]
[{"$nulls":4},{"$f":"'payroll.tax Y2'!F27","v":0},0,null,null,{"$f":"'payroll.tax Y2'!I27","v":0},0,null,null,0,0,0]
[null,"Shuttle bus",null,"Driver",{"$f":"'payroll.tax Y2'!F28","v":84000},88200,null,null,{"$f":"'payroll.tax Y2'!I28","v":0},{"$f":"F28*I28","v":0},null,null,0,0,0]
[{"$nulls":4},{"$f":"'payroll.tax Y2'!F29","v":0},0,null,null,{"$f":"'payroll.tax Y2'!I29","v":0}]
[{"$nulls":4},{"$f":"'payroll.tax Y2'!F30","v":0},0,null,null,{"$f":"'payroll.tax Y2'!I30","v":0}]
[{"$nulls":4},{"$f":"'payroll.tax Y2'!F31","v":0},0,null,null,{"$f":"'payroll.tax Y2'!I31","v":0},0,null,null,0,0,0]
[null,"Spa",null,"Spa Service Manager",{"$f":"'payroll.tax Y2'!F32","v":84000},88200,null,null,{"$f":"'payroll.tax Y2'!I32","v":1},{"$f":"F32*I32","v":88200},{"$f":"J32/I32","v":88200},{"$f":"J32*L$4","v":5468.4},1278.9000000000001,0,0]
[null,"Massage Program (with Body Scrub)",null,"Spa Employees",{"$f":"'payroll.tax Y2'!F33","v":21},22.05,8,365,{"$f":"'payroll.tax Y2'!I33","v":10},643860,64386,{"$f":"J33*L$4","v":39919.32},9335.9700000000012,0,0]
[{"$nulls":10},"Sub Tax",{"$f":"SUM(L6:L33)","v":126607.13099999999},{"$f":"SUM(M6:M33)","v":32410.523250000006},{"$f":"SUM(N6:N33)","v":0},{"$f":"SUM(O6:O33)","v":0}]
[]
[null,"Total",{"$nulls":6},{"$f":"SUM(I6:I33)","v":29},{"$f":"SUM(J6:J33)","v":2235208.5},"Total Tax",{"$f":"L34+M34+N34+O34","v":159017.65424999999}]
[{"$nulls":7},"AVG","MONTHLY PAYMENT",{"$f":"J36/12","v":186267.375},null,"MONTHLY PAYROLL-TAX",{"$f":"L36/12","v":13251.471187499999}]
[{"$nulls":7},"AVG","Year/Person",{"$f":"J36/I36","v":77076.155172413797}]

{"sheet":"payroll.tax Y4","index":9,"n_rows":38,"n_cols":15,"rows_kept":38,"cut":false,"hidden":false,"merged":[[1,1,1,14],[35,11,35,14]]}
[]
[null,"Payroll & Payroll Tax  (Year 4)"]
[{"$nulls":11},"Fed. Tax",null,"State UI Base",{"$f":"'Fed.NYS.Tax-UI-BASE'!B14","v":0}]
[{"$nulls":5},"+5%",{"$nulls":5},6.2E-2,1.4500000000000001E-2,null,{"$f":"'Fed.NYS.Tax-UI-BASE'!H13","v":6.0000000000000001E-3}]
[{"$nulls":4},"Year 3 Rate","Year 4 Rate","Hour","Day 365","Persons","Yearly Wage","Wage Per Person","SS Tax","Med tax","UI N.Employer","NYS U.I"]
[null,"General Manager",null,"General Manager",{"$f":"'payroll.tax Y3'!F6","v":198450},{"$f":"E6*(1+$F$4)","v":208372.5},null,{"$f":"'payroll.tax Y3'!I6","v":1},{"$f":"'payroll.tax Y3'!I6","v":1},{"$f":"F6*I6","v":208372.5},{"$f":"J6/I6","v":208372.5},{"$f":"J6*L4","v":12919.094999999999},{"$f":"J6*M$4","v":3021.4012500000003},{"$f":"11400*I6*N$4","v":0},{"$f":"$O$3*I6*O$4","v":0}]
[{"$nulls":4},{"$f":"'payroll.tax Y3'!F7","v":0},{"$f":"E7*(1+$F$4)","v":0},null,null,{"$f":"'payroll.tax Y3'!I7","v":0},{"$f":"F7*G7*H7*I7","v":0},null,{"$f":"J7*L$4","v":0},0,0,{"$f":"$O$3*I7*O$4","v":0}]
[null,"Accounting",null,"CFO",{"$f":"'payroll.tax Y3'!F8","v":88200},92610,null,null,{"$f":"'payroll.tax Y3'!I8","v":1},{"$f":"F8*I8","v":92610},{"$f":"J8/I8","v":92610},5741.82,1342.845,0,0]
[null,null,null,"Assistant accountants",{"$f":"'payroll.tax Y3'!F9","v":38587.5},40516.875,null,null,{"$f":"'payroll.tax Y3'!I9","v":1},{"$f":"F9*I9","v":40516.875},{"$f":"J9/I9","v":40516.875},2512.0462499999999,587.49468750000005,0,0]
[null,"Customer Satisfaction",null,"Customer Service Manager",{"$f":"'payroll.tax Y3'!F10","v":88200},92610,null,null,{"$f":"'payroll.tax Y3'!I10","v":1},{"$f":"F10*I10","v":92610},{"$f":"J10/I10","v":92610},5741.82,1342.845,0,0]
[null,null,null,"Reception_Entrance Room",{"$f":"'payroll.tax Y3'!F11","v":22.05},23.152500000000003,8,365,{"$f":"'payroll.tax Y3'!I11","v":4},{"$f":"F11*G11*H11*I11","v":270421.2},{"$f":"J11/I11","v":67605.3},16766.114400000002,3921.1074000000003,0,0]
[null,null,null,"Reception_Gift Shop",{"$f":"'payroll.tax Y3'!F12","v":22.05},23.152500000000003,8,365,{"$f":"'payroll.tax Y3'!I12","v":0},0,{"$error":"#DIV/0!"},0,0,0,0]
[null,null,null,"Reception_Customer Service",{"$f":"'payroll.tax Y3'!F13","v":22.05},23.152500000000003,8,365,{"$f":"'payroll.tax Y3'!I13","v":0},0,{"$error":"#DIV/0!"},0,0,0,0]
[{"$nulls":4},{"$f":"'payroll.tax Y3'!F14","v":0},0,null,null,{"$f":"'payroll.tax Y3'!I14","v":0},0,null,null,null,0,0]
[null,"Management",null,"Maintenance Manager",{"$f":"'payroll.tax Y3'!F15","v":132300},138915,null,null,{"$f":"'payroll.tax Y3'!I15","v":1},{"$f":"F15*I15","v":138915},138915,{"$f":"J15*L$4","v":8612.73},{"$f":"J15*M$4","v":2014.2675000000002},0,0]
[null,null,null,"Building & Pool Maintenance",{"$f":"'payroll.tax Y3'!F16","v":22.05},23.152500000000003,12,365,{"$f":"'payroll.tax Y3'!I16","v":3},304223.85000000003,101407.95000000001,18861.878700000001,4411.2458250000009,0,0]
[null,null,null,"House Keeper(Service Personal)",{"$f":"'payroll.tax Y3'!F17","v":22.05},23.152500000000003,8,365,{"$f":"'payroll.tax Y3'!I17","v":2},135210.6,67605.3,8383.0572000000011,1960.5537000000002,0,0]
[null,null,null,"Security Manager",{"$f":"'payroll.tax Y3'!F18","v":22.05},23.152500000000003,8,365,{"$f":"'payroll.tax Y3'!I18","v":0},0,{"$error":"#DIV/0!"},0,0,0,0]
[{"$nulls":4},{"$f":"'payroll.tax Y3'!F19","v":22.05},23.152500000000003,null,null,{"$f":"'payroll.tax Y3'!I19","v":0}]
[null,null,null,"IT  ",{"$f":"'payroll.tax Y3'!F20","v":88200},92610,null,null,{"$f":"'payroll.tax Y3'!I20","v":1},{"$f":"F20*I20","v":92610},{"$f":"J20/I20","v":92610},5741.82,{"$f":"J20*M$4","v":1342.845},{"$f":"11400*I20*N$4","v":0},0]
[{"$nulls":4},{"$f":"'payroll.tax Y3'!F21","v":0},0,null,null,{"$f":"'payroll.tax Y3'!I21","v":0}]
[{"$nulls":4},{"$f":"'payroll.tax Y3'!F22","v":0},0,null,null,{"$f":"'payroll.tax Y3'!I22","v":0}]
[null,"Food","Restaurant & Café","Food & Beverage",{"$f":"'payroll.tax Y3'!F23","v":22.05},23.152500000000003,8,365,{"$f":"'payroll.tax Y3'!I23","v":3},202815.90000000002,null,null,2940.8305500000006,0,0]
[null,null,null,"Restaurant Cook",{"$f":"'payroll.tax Y3'!F24","v":0},0,null,null,{"$f":"'payroll.tax Y3'!I24","v":0},{"$f":"F24*I24","v":0},{"$error":"#DIV/0!"},{"$f":"J24*L$4","v":0},0,0,0]
[null,null,null,"Restaurant Cook Assistant ",{"$f":"'payroll.tax Y3'!F25","v":0},0,8,365,{"$f":"'payroll.tax Y3'!I25","v":0},0,{"$error":"#DIV/0!"},{"$f":"J25*L$4","v":0},0,0,0]
[null,null,null,"Restaurant Cashier",{"$f":"'payroll.tax Y3'!F26","v":0},0,8,365,{"$f":"'payroll.tax Y3'!I26","v":0},0,{"$error":"#DIV/0!"},{"$f":"J26*L$4","v":0},0,0,0]
[{"$nulls":4},{"$f":"'payroll.tax Y3'!F27","v":0},0,null,null,{"$f":"'payroll.tax Y3'!I27","v":0},0,null,null,0,0,0]
[null,"Shuttle bus",null,"Driver",{"$f":"'payroll.tax Y3'!F28","v":88200},92610,null,null,{"$f":"'payroll.tax Y3'!I28","v":0},{"$f":"F28*I28","v":0},null,null,0,0,0]
[{"$nulls":4},{"$f":"'payroll.tax Y3'!F29","v":0},0,null,null,{"$f":"'payroll.tax Y3'!I29","v":0}]
[{"$nulls":4},{"$f":"'payroll.tax Y3'!F30","v":0},0,null,null,{"$f":"'payroll.tax Y3'!I30","v":0}]
[{"$nulls":4},{"$f":"'payroll.tax Y3'!F31","v":0},0,null,null,{"$f":"'payroll.tax Y3'!I31","v":0},0,null,null,0,0,0]
[null,"Spa",null,"Spa Service Manager",{"$f":"'payroll.tax Y3'!F32","v":88200},92610,null,null,{"$f":"'payroll.tax Y3'!I32","v":1},{"$f":"F32*I32","v":92610},{"$f":"J32/I32","v":92610},{"$f":"J32*L$4","v":5741.82},1342.845,0,0]
[null,"Massage Program (with Body Scrub)",null,"Spa Employees",{"$f":"'payroll.tax Y3'!F33","v":22.05},23.152500000000003,8,365,{"$f":"'payroll.tax Y3'!I33","v":10},676053,67605.3,{"$f":"J33*L$4","v":41915.286},9802.7685000000001,0,0]
[{"$nulls":10},"Sub Tax",{"$f":"SUM(L6:L33)","v":132937.48754999999},{"$f":"SUM(M6:M33)","v":34031.049412500004},{"$f":"SUM(N6:N33)","v":0},{"$f":"SUM(O6:O33)","v":0}]
[]
[null,"Total",{"$nulls":6},{"$f":"SUM(I6:I33)","v":29},{"$f":"SUM(J6:J33)","v":2346968.9250000003},"Total Tax",{"$f":"L34+M34+N34+O34","v":166968.53696249999}]
[{"$nulls":7},"AVG","MONTHLY PAYMENT",{"$f":"J36/12","v":195580.74375000002},null,"MONTHLY PAYROLL-TAX",{"$f":"L36/12","v":13914.044746874999}]
[{"$nulls":7},"AVG","Year/Person",{"$f":"J36/I36","v":80929.96293103449}]

{"sheet":"payroll.tax Y5","index":10,"n_rows":38,"n_cols":15,"rows_kept":38,"cut":false,"hidden":false,"merged":[[1,1,1,14],[35,11,35,14]]}
[]
[null,"Payroll & Payroll Tax  (Year 5)"]
[{"$nulls":11},"Fed. Tax",null,"State UI Base",{"$f":"'Fed.NYS.Tax-UI-BASE'!B14","v":0}]
[{"$nulls":5},"+5%",{"$nulls":5},6.2E-2,1.4500000000000001E-2,null,{"$f":"'Fed.NYS.Tax-UI-BASE'!H13","v":6.0000000000000001E-3}]
[{"$nulls":4},"Year 4 Rate","Year 5 Rate","Hour","Day 365","Persons","Yearly Wage","Wage Per Person","SS Tax","Med tax","UI N.Employer","NYS U.I"]
[null,"General Manager",null,"General Manager",{"$f":"'payroll.tax Y4'!F6","v":208372.5},{"$f":"E6*(1+$F$4)","v":218791.125},null,null,{"$f":"'payroll.tax Y4'!I6","v":1},{"$f":"F6*I6","v":218791.125},{"$f":"J6/I6","v":218791.125},{"$f":"J6*L4","v":13565.04975},{"$f":"J6*M$4","v":3172.4713125000003},{"$f":"11400*I6*N$4","v":0},{"$f":"$O$3*I6*O$4","v":0}]
[{"$nulls":4},{"$f":"'payroll.tax Y4'!F7","v":0},{"$f":"E7*(1+$F$4)","v":0},null,null,{"$f":"'payroll.tax Y4'!I7","v":0},{"$f":"F7*G7*H7*I7","v":0},null,{"$f":"J7*L$4","v":0},0,0,{"$f":"$O$3*I7*O$4","v":0}]
[null,"Accounting",null,"CFO",{"$f":"'payroll.tax Y4'!F8","v":92610},97240.5,null,null,{"$f":"'payroll.tax Y4'!I8","v":1},{"$f":"F8*I8","v":97240.5},{"$f":"J8/I8","v":97240.5},6028.9110000000001,1409.9872500000001,0,0]
[null,null,null,"Assistant accountants",{"$f":"'payroll.tax Y4'!F9","v":40516.875},42542.71875,null,null,{"$f":"'payroll.tax Y4'!I9","v":1},{"$f":"F9*I9","v":42542.71875},{"$f":"J9/I9","v":42542.71875},2637.6485625,616.86942187500006,0,0]
[null,"Customer Satisfaction",null,"Customer Service Manager",{"$f":"'payroll.tax Y4'!F10","v":92610},97240.5,null,null,{"$f":"'payroll.tax Y4'!I10","v":1},{"$f":"F10*I10","v":97240.5},{"$f":"J10/I10","v":97240.5},6028.9110000000001,1409.9872500000001,0,0]
[null,null,null,"Reception_Entrance Room",{"$f":"'payroll.tax Y4'!F11","v":23.152500000000003},24.310125000000003,8,365,{"$f":"'payroll.tax Y4'!I11","v":4},{"$f":"F11*G11*H11*I11","v":283942.26},{"$f":"J11/I11","v":70985.565000000002},17604.420119999999,4117.1627699999999,0,0]
[null,null,null,"Reception_Gift Shop",{"$f":"'payroll.tax Y4'!F12","v":23.152500000000003},24.310125000000003,8,365,{"$f":"'payroll.tax Y4'!I12","v":0},0,{"$error":"#DIV/0!"},0,0,0,0]
[null,null,null,"Reception_Customer Service",{"$f":"'payroll.tax Y4'!F13","v":23.152500000000003},24.310125000000003,8,365,{"$f":"'payroll.tax Y4'!I13","v":0},0,{"$error":"#DIV/0!"},0,0,0,0]
[{"$nulls":4},{"$f":"'payroll.tax Y4'!F14","v":0},0,null,null,{"$f":"'payroll.tax Y4'!I14","v":0},0,null,null,null,0,0]
[null,"Management",null,"Maintenance Manager",{"$f":"'payroll.tax Y4'!F15","v":138915},145860.75,null,null,{"$f":"'payroll.tax Y4'!I15","v":1},{"$f":"F15*I15","v":145860.75},145860.75,{"$f":"J15*L$4","v":9043.3665000000001},{"$f":"J15*M$4","v":2114.9808750000002},0,0]
[null,null,null,"Building & Pool Maintenance",{"$f":"'payroll.tax Y4'!F16","v":23.152500000000003},24.310125000000003,12,365,{"$f":"'payroll.tax Y4'!I16","v":3},319435.04250000004,106478.34750000002,19804.972635000002,4631.8081162500011,0,0]
[null,null,null,"House Keeper(Service Personal)",{"$f":"'payroll.tax Y4'!F17","v":23.152500000000003},24.310125000000003,8,365,{"$f":"'payroll.tax Y4'!I17","v":2},141971.13,70985.565000000002,8802.2100599999994,2058.581385,0,0]
[null,null,null,"Security Manager",{"$f":"'payroll.tax Y4'!F18","v":23.152500000000003},24.310125000000003,8,365,{"$f":"'payroll.tax Y4'!I18","v":0},0,{"$error":"#DIV/0!"},0,0,0,0]
[{"$nulls":4},{"$f":"'payroll.tax Y4'!F19","v":23.152500000000003},24.310125000000003,null,null,{"$f":"'payroll.tax Y4'!I19","v":0}]
[null,null,null,"IT  ",{"$f":"'payroll.tax Y4'!F20","v":92610},97240.5,null,null,{"$f":"'payroll.tax Y4'!I20","v":1},{"$f":"F20*I20","v":97240.5},{"$f":"J20/I20","v":97240.5},6028.9110000000001,{"$f":"J20*M$4","v":1409.9872500000001},{"$f":"11400*I20*N$4","v":0},0]
[{"$nulls":4},{"$f":"'payroll.tax Y4'!F21","v":0},0,null,null,{"$f":"'payroll.tax Y4'!I21","v":0}]
[{"$nulls":4},{"$f":"'payroll.tax Y4'!F22","v":0},0,null,null,{"$f":"'payroll.tax Y4'!I22","v":0}]
[null,"Food","Restaurant & Café","Food & Beverage",{"$f":"'payroll.tax Y4'!F23","v":23.152500000000003},24.310125000000003,8,365,{"$f":"'payroll.tax Y4'!I23","v":3},212956.69500000001,null,null,3087.8720775000002,0,0]
[null,null,null,"Restaurant Cook",{"$f":"'payroll.tax Y4'!F24","v":0},0,null,null,{"$f":"'payroll.tax Y4'!I24","v":0},{"$f":"F24*I24","v":0},{"$error":"#DIV/0!"},{"$f":"J24*L$4","v":0},0,0,0]
[null,null,null,"Restaurant Cook Assistant ",{"$f":"'payroll.tax Y4'!F25","v":0},0,8,365,{"$f":"'payroll.tax Y4'!I25","v":0},0,{"$error":"#DIV/0!"},{"$f":"J25*L$4","v":0},0,0,0]
[null,null,null,"Restaurant Cashier",{"$f":"'payroll.tax Y4'!F26","v":0},0,8,365,{"$f":"'payroll.tax Y4'!I26","v":0},0,{"$error":"#DIV/0!"},{"$f":"J26*L$4","v":0},0,0,0]
[{"$nulls":4},{"$f":"'payroll.tax Y4'!F27","v":0},0,null,null,{"$f":"'payroll.tax Y4'!I27","v":0},0,null,null,0,0,0]
[null,"Shuttle bus",null,"Driver",{"$f":"'payroll.tax Y4'!F28","v":92610},97240.5,null,null,{"$f":"'payroll.tax Y4'!I28","v":0},{"$f":"F28*I28","v":0},null,null,0,0,0]
[{"$nulls":4},{"$f":"'payroll.tax Y4'!F29","v":0},0,null,null,{"$f":"'payroll.tax Y4'!I29","v":0}]
[{"$nulls":4},{"$f":"'payroll.tax Y4'!F30","v":0},0,null,null,{"$f":"'payroll.tax Y4'!I30","v":0}]
[{"$nulls":4},{"$f":"'payroll.tax Y4'!F31","v":0},0,null,null,{"$f":"'payroll.tax Y4'!I31","v":0},0,null,null,0,0,0]
[null,"Spa",null,"Spa Service Manager",{"$f":"'payroll.tax Y4'!F32","v":92610},97240.5,null,null,{"$f":"'payroll.tax Y4'!I32","v":1},{"$f":"F32*I32","v":97240.5},{"$f":"J32/I32","v":97240.5},{"$f":"J32*L$4","v":6028.9110000000001},1409.9872500000001,0,0]
[null,"Massage Program (with Body Scrub)",null,"Spa Employees",{"$f":"'payroll.tax Y4'!F33","v":23.152500000000003},24.310125000000003,8,365,{"$f":"'payroll.tax Y4'!I33","v":10},709855.65,70985.565000000002,{"$f":"J33*L$4","v":44011.050300000003},10292.906925000001,0,0]
[{"$nulls":10},"Sub Tax",{"$f":"SUM(L6:L33)","v":139584.36192749999},{"$f":"SUM(M6:M33)","v":35732.601883125011},{"$f":"SUM(N6:N33)","v":0},{"$f":"SUM(O6:O33)","v":0}]
[]
[null,"Total",{"$nulls":6},{"$f":"SUM(I6:I33)","v":29},{"$f":"SUM(J6:J33)","v":2464317.3712500003},"Total Tax",{"$f":"L34+M34+N34+O34","v":175316.96381062502}]
[{"$nulls":7},"AVG","MONTHLY PAYMENT",{"$f":"J36/12","v":205359.78093750004},null,"MONTHLY PAYROLL-TAX",{"$f":"L36/12","v":14609.746984218751}]
[{"$nulls":7},"AVG","Year/Person",{"$f":"J36/I36","v":84976.461077586224}]

{"sheet":"Fed.NYS.Tax-UI-BASE","index":11,"n_rows":19,"n_cols":13,"rows_kept":19,"cut":false,"hidden":false,"merged":[[2,2,2,4],[2,6,2,8],[18,1,18,8]]}
[]
["Estimated number of Employees",44]
[null,null,"FED FICA",null,null,null,"State UI (rate x UI Wage Base)"]
[null,"Average Wage","SS (6.2%)","MC (1.45%)","Subtotal",null,"UI (vary)*","Re-employment(0.075%)","Subtotal",null,"Total/person","Total per year"]
[" Year 1",{"$f":"'payroll.tax Y1'!I38","v":69910.344827586203},{"$f":"+B5*6.2%","v":4334.4413793103449},{"$f":"+B5*1.45%","v":1013.6999999999998},{"$f":"+D5+C5","v":5348.1413793103447},null,{"$f":"B11*2.5%","v":290},{"$f":"B11*0.075%","v":8.7000000000000011},{"$f":"G5+H5","v":298.7},null,{"$f":"+I5+E5","v":5646.8413793103446},{"$f":"+K5*$B$2","v":248461.02068965515}]
["Year 2",{"$f":"'payroll.tax Y2'!J38","v":73405.862068965522},{"$f":"+B6*6.2%","v":4551.1634482758627},{"$f":"+B6*1.45%","v":1064.385},{"$f":"+D6+C6","v":5615.5484482758629},null,{"$f":"B12*L15","v":61.95},{"$f":"B12*0.075%","v":8.85},{"$f":"G6+H6","v":70.8},null,{"$f":"+I6+E6","v":5686.3484482758631},{"$f":"+K6*$B$2","v":250199.33172413797}]
["Year 3",{"$f":"'payroll.tax Y3'!J38","v":77076.155172413797},{"$f":"+B7*6.2%","v":4778.7216206896555},{"$f":"+B7*1.45%","v":1117.6042500000001},{"$f":"+D7+C7","v":5896.3258706896559},null,{"$f":"B13*0.525%","v":63.000000000000007},{"$f":"B13*0.075%","v":9},{"$f":"G7+H7","v":72},null,{"$f":"+I7+E7","v":5968.3258706896559},{"$f":"+K7*$B$2","v":262606.33831034484}]
[]
[]
[null,"UI Wage Base (Estimated after 2023)",null,null,"UI Rate",null,"Re-employ","UI Final Rate"]
[" Year 1",11600,null,null,2.5000000000000001E-2,null,7.5000000000000002E-4,{"$f":"E11+0.075%","v":2.5750000000000002E-2},null,null,null,5.2500000000000003E-3,"4Q"]
["Year 2",11800,null,null,{"$f":"L15","v":5.2500000000000003E-3},null,7.5000000000000002E-4,{"$f":"E12+0.075%","v":6.0000000000000001E-3},null,null,null,5.2500000000000003E-3,"3Q"]
["Year 3",12000,null,null,5.2500000000000003E-3,null,7.5000000000000002E-4,{"$f":"E13+0.075%","v":6.0000000000000001E-3},null,null,null,5.2500000000000003E-3,"2Q"]
[]
[{"$nulls":11},{"$f":"AVERAGE(L11:L14)","v":5.2500000000000003E-3},"Average"]
[]
[null,"* UI Contribution rate is for New Employer"]
[]
[null,"Newly Liable Employers Newly liable employers (who, with any previous owners of the business, are liable for fewer than five completed calendar quarters as of December 31, 2018) are assigned the normal contribution rate from the positive “2.5% but less than 3.0%” bracket on the Normal Contribution Rate Table for this year’s Size-ofFund Index (This rate cannot exceed 3.4%). The New Employer normal contribution rate for 2019 is 2.5%."]