{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["38D_Overview","IncomeExpenseReport","Section 1","Section 2","Section 3","Section 4","Section 5","Section 6","Section 7","Section 8","SummarySheet"],"not_rendered":{"charts":0,"images":7,"macros":1,"external_links":0,"defined_names":104,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"38D_Overview","index":0,"n_rows":38,"n_cols":6,"rows_kept":38,"cut":false,"hidden":false,"merged":[[0,2,0,4],[0,0,0,1],[0,5,0,10],[30,0,30,10],[6,2,6,10],[20,0,20,10],[1,0,1,10],[2,0,2,10],[5,0,5,10],[21,0,21,10],[25,0,25,10],[3,0,3,10],[4,0,4,10]]}
[null,null,"FY 2018 \nCity of Boston\n38D Property Tax Return\nForm H: Hotel/Motel/Bed & Breakfast",null,null,"Notice Mailing Date: February 8, 2017"]
["Dear Owner/Representative:"]
["The following information is requested pursuant to Massachusetts General Law Chapter 59; Section 38D, as amended, in order to determine market income and expense standards and develop fair and equitable valuations.  Please submit all requested information within sixty (60) days of the notice mailing date, February 8, 2017."]
["Failure to comply within 60 days may bar you from appealing the assessment to the Massachusetts Appellate Tax Board.  Furthermore, failure to comply will result in a two hundred fifty–dollar ($250) penalty being levied.  The penalty will appear on next year’s tax bill. All information submitted is confidential."]
["Completing this workbook provides the City of Boston with the most accurate information to assess your property. In this workbook, all Red Cells must be filled in.  Green cells need to be completed when applicable. Blue cells will automatically calculate and are locked from editing. Please save your file as you go and label it with your Parcel ID_38DHotel (ex. 0123334445_38DHotel), save it somewhere that will be easy to find (such as your Desktop). Once all the required information is filled out in this worksheet, please use the button at the bottom of the page to verify your data to proceed to the Income Expense Report tab. Once you have completed the Income Expense Report tab, please verify the completion of the data with the button at the bottom of the page.  If you need to provide any comments, there is a comments section when you reach the end \"SummarySheet\".  Please submit completed forms along with any supporting data at https://www.boston.gov/38d-form-h. "]
["Please submit the following information:"]
["Building Name (Hotel/Motel/Bed & Breakfast):",null,"*If applicable, please enter additional PIDs in the green boxes below"]
["Parcel ID Number(s)*:"]
["Property Street Address:"]
["City:","Boston"]
["State:","MA"]
["Owner Name:"]
["Owner Company Name:"]
["Owner Street Address:"]
["Owner City:"]
["State:"]
["Zip Code:"]
["Phone Number:"]
["Representative Name:"]
["Email Address:"]
["Affidavit"]
["By providing my name below I hereby declare under oath that the information provided in this workbook and addenda are presented as being true, correct and complete to the best of my knowledge and belief and are submitted under the pains and penalties of perjury. "]
["Name of Owner:",null,"Date:"]
["Phone Number:"]
["Contact Email Address:"]
["By providing my name below I hereby declare under oath that the information provided in this workbook and addenda are presented as being true, correct and complete to the best of my knowledge and belief and are submitted under the pains and penalties of perjury. "]
["Name of Preparer:",null,"Date:"]
["Phone Number:"]
["Contact Email Address:"]
[]
[]
[]
[null,null,null,null,{"$f":"COUNTBLANK(B7:B20)","v":12}]
[null,null,null,null,{"$f":"COUNTBLANK(B23:B25)","v":3}]
[null,null,null,null,{"$f":"COUNTBLANK(B27:B29)","v":3}]
[null,null,null,null,{"$f":"COUNTBLANK(D23)","v":1}]
[null,null,null,null,{"$f":"COUNTBLANK(D27)","v":1}]
[null,null,null,null,{"$f":"SUM(E33:E37)","v":20}]

{"sheet":"IncomeExpenseReport","index":1,"n_rows":75,"n_cols":8,"rows_kept":75,"cut":false,"hidden":true,"merged":[[0,0,0,4],[1,0,1,4],[17,2,17,4],[28,2,28,4],[2,0,2,1],[10,0,10,1],[56,0,56,1],[49,0,49,1],[40,0,40,1],[32,0,32,1],[23,0,23,1],[52,2,52,4],[46,2,46,4],[42,2,42,4],[43,2,43,4],[35,2,35,4],[50,2,50,4]]}
["FY 2018 \nCity of Boston\n38D Property Tax Return\nForm H: Hotel/Motel/Bed & Breakfast"]
["Please fill in all RED cells on this worksheet.  If the category does not apply, please enter 0.  If it is a drop down question, please choose Yes or No.  If the answer is Yes, you need to fill out the section."]
["General Information"]
["Name of Hotel/ Motel/ Bed & Breakfast",{"$f":"'38D_Overview'!B7","v":0}]
["Number of Rooms"]
["Available Room Nights",{"$f":"Number_of_Rooms*365","v":0}]
["Percent Occupancy"]
["Occupied Room Nights",{"$f":"Number_of_Rooms*365*Percent_Occupancy","v":0}]
["Average Daily Rate (ADR)"]
["Revenue Per Available Room (RevPAR)",{"$f":"B9*B7","v":0}]
["Revenue"]
[null,"Total Amount"]
["Rooms"]
["Food"]
["Beverage"]
["Telephone",null,null,null,null,null,null,"Yes"]
["Parking Revenue",null,"Number of Parking Spaces",null,null,{"$f":"IF(AND(Parking_Revenue>0,D17<1), 1,0)","v":0},null,"No"]
["Meeting Rooms",null,"Please answer using the drop down menu:"]
["Hotel Operated Shop Revenue   ",{"$f":"IF(Section1=\"Yes\",'Section 1'!C24,0)","v":0},"Do you earn revenue from hotel operated shops?",null,"Fill out Section 1",{"$f":"IF(OR(Section1=0,(AND(Section1=\"Yes\",Hotel_Operated_Shop_Revenue<1))),1,0)","v":1}]
["Leased Space Revenue",{"$f":"IF(Section2=\"Yes\",'Section 2'!M25,0)","v":0},"Do you earn revenue from leased space?",null,"Fill out Section 2",{"$f":"IF(OR(Section2=0,AND(Section2=\"Yes\",Leased_Space_Revenue<1)),1,0)","v":1}]
["Food & Beverage Other Income",{"$f":"IF(Section3=\"Yes\",'Section 3'!C24,0)","v":0},"Do you earn revenue from other food and beverage income?",null,"Fill out Section 3",{"$f":"IF(OR(Section3=0,AND(Section3=\"Yes\",Food___Beverage_Other_Income<1)),1,0)","v":1}]
["Other Revenue",{"$f":"IF(Section4=\"Yes\",'Section 4'!C24,0)","v":0},"Do you earn revenue from other sources?",null,"Fill out Section 4",{"$f":"IF(OR(Section4=0,AND(Section4=\"Yes\",Other_Revenue<1)),1,0)","v":1}]
["Total Revenue",{"$f":"SUM(B13:B22)","v":0}]
["Expenses"]
[null,"Total Amount"]
["Rooms"]
["Cost of Food"]
["Cost of Beverage"]
["Telephone",null,"Please answer using the drop down menu:"]
["Departmental Other Expenses",{"$f":"IF(Section5=\"Yes\",'Section 5'!C24,0)","v":0},"Do you have other departmental expenses? ",null,"Fill out Section 5",{"$f":"IF(OR(Section5=0,AND(Section5=\"Yes\",Departmental_Other_Expenses<1)),1,0)","v":1}]
["Miscellaneous Other Expenses",{"$f":"IF(Section6=\"Yes\",'Section 6'!C24,0)","v":0},"Do you have other miscellaneous expenses?",null,"Fill out Section 6",{"$f":"IF(OR(Section6=0,AND(Section6=\"Yes\",Miscellaneous_Other_Expenses<1)),1,0)","v":1}]
["Total Expense",{"$f":"SUM(B26:B31)","v":0}]
["Unallocated Expenses"]
[null,"Total Amount"]
["Administrative & General"]
["Management Fee",null,"*Please provide management contract abstracts in a separate attachment with your Parcel ID."]
["Marketing"]
["Repairs & Maintenance"]
["Utilities"]
["Total Unallocated",{"$f":"SUM(B35:B39)","v":0}]
["Fixed Charges"]
[null,"Total Amount"]
["Return on Personal Property",null,"*Please provide detailed documentation in a separate attachment with your Parcel ID"]
["Return of Personal Property",null,"*Please provide detailed documentation in a separate attachment with your Parcel ID"]
["Insurance"]
["Incentive Management Fee"]
["Municipal Charges",null,"Please answer using the drop down menu:"]
["Other",{"$f":"IF(D48=\"Yes\",'Section 7'!C24,0)","v":0},"Do you have other fixed charges?",null,"Fill out Section 7",{"$f":"IF(OR(Section7=0,AND(Section7=\"Yes\",Other<1)),1,0)","v":1}]
["Total Fixed",{"$f":"SUM(B43:B48)","v":0}]
["Other Expenses"]
[null,"Total Amount","Please answer using the drop down menu:"]
["Capital Expenditures",{"$f":"IF(D52=\"Yes\",'Section 8'!F24,0)","v":0},"Do you have capital expenditures?",null,"Fill out Section 8",{"$f":"IF(OR(Section8=0,AND(Section8=\"Yes\",Capital_Expenditures<1)),1,0)","v":1}]
["Franchise Fee",null,"*Please provide detailed documentation in a separate attachment with your Parcel ID"]
["Reserve Replacement"]
["Ground Rent"]
["Total Other",{"$f":"SUM(B52:B55)","v":0}]
["Net Operating Income"]
["Net Operating Income",{"$f":"Total_Revenue-Total_Expense-Total_Unallocated-Total_Fixed-Total_Other","v":0}]
[]
[]
[]
[]
[]
[null,"B5",{"$f":"COUNTBLANK(Number_of_Rooms)","v":1}]
[null,"B7",{"$f":"COUNTBLANK(Percent_Occupancy)","v":1}]
[null,"B9",{"$f":"COUNTBLANK(Average_Daily_Rate__ADR)","v":1}]
[null,"CountBlank B13:B18",{"$f":"COUNTBLANK(B13:B18)","v":6}]
[null,"CountBlank B26:B29",{"$f":"COUNTBLANK(B26:B29)","v":4}]
[null,"CountBlank B35:B40",{"$f":"COUNTBLANK(B35:B39)","v":5}]
[null,"CountBlank B44:B48",{"$f":"COUNTBLANK(B43:B47)","v":5}]
[null,"CountBlank B54:B56",{"$f":"COUNTBLANK(B53:B55)","v":3}]
[null,"Sum Column F",{"$f":"SUM(F3:F60)","v":8}]
[null,"Total Report Blanks",{"$f":"SUM(C64:C72)","v":34}]
[null,"Total Overview Blanks",{"$f":"TotalBlanks","v":20}]
[null,"All Blanks",{"$f":"SUM(C73:C74)","v":54}]

{"sheet":"Section 1","index":2,"n_rows":25,"n_cols":4,"rows_kept":25,"cut":false,"hidden":true,"merged":[[1,0,1,3],[24,1,24,3],[0,0,0,1]]}
[null,null,"FY 2018 \nCity of Boston\n38D Property Tax Return\nForm H: Hotel/Motel/Bed & Breakfast","Notice Mailing Date: February 8, 2017"]
["Section 1: Hotel Operated Shops"]
[null,"Revenue Source","Total Revenue Collected","Rentable SF"]
[1]
[2]
[3]
[4]
[5]
[6]
[7]
[8]
[9]
[10]
[11]
[12]
[13]
[14]
[15]
[16]
[17]
[18]
[19]
[20]
[null,null,{"$f":"SUM(C4:C23)","v":0}]
[null,"Return to Income Expense Report"]

{"sheet":"Section 2","index":3,"n_rows":37,"n_cols":13,"rows_kept":37,"cut":false,"hidden":true,"merged":[[1,0,1,11],[25,1,25,11],[0,2,0,8]]}
[null,null,"FY 2018 \nCity of Boston\n38D Property Tax Return\nForm H: Hotel/Motel/Bed & Breakfast",null,null,null,null,null,null,null,null,"Notice Mailing Date: February 8, 2017"]
["Section 2: Leased Space Revenue"]
[null,"Floor","Tenant Name","Use of Space","Rentable Area (SF)","Rent/SF on Jan. 1, 2016 (annual)","Lease Start Date (mm/dd/yyyy)","Lease Term (in months)","Lease Basis (Gross, N, NN, NNN)","Free rent Term (in months)","Tenant Fit-out ($/SF)","Commission ($/SF)"]
["Example","Mezzanine","Black Tie Café","Café",500,5,"2016-01-01",24,"N",2,1,5]
[1,null,null,null,null,null,null,null,null,null,null,null,{"$f":"E5*F5","v":0}]
[2,null,null,null,null,null,null,null,null,null,null,null,{"$f":"E6*F6","v":0}]
[3,null,null,null,null,null,null,null,null,null,null,null,0]
[4,null,null,null,null,null,null,null,null,null,null,null,0]
[5,null,null,null,null,null,null,null,null,null,null,null,0]
[6,null,null,null,null,null,null,null,null,null,null,null,0]
[7,null,null,null,null,null,null,null,null,null,null,null,0]
[8,null,null,null,null,null,null,null,null,null,null,null,0]
[9,null,null,null,null,null,null,null,null,null,null,null,0]
[10,null,null,null,null,null,null,null,null,null,null,null,0]
[11,null,null,null,null,null,null,null,null,null,null,null,0]
[12,null,null,null,null,null,null,null,null,null,null,null,0]
[13,null,null,null,null,null,null,null,null,null,null,null,0]
[14,null,null,null,null,null,null,null,null,null,null,null,0]
[15,null,null,null,null,null,null,null,null,null,null,null,0]
[16,null,null,null,null,null,null,null,null,null,null,null,0]
[17,null,null,null,null,null,null,null,null,null,null,null,0]
[18,null,null,null,null,null,null,null,null,null,null,null,0]
[19,null,null,null,null,null,null,null,null,null,null,null,0]
[20,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(M5:M24)","v":0}]
[null,"Return to Income Expense Report"]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"Gross"]
[null,null,null,null,"N"]
[null,null,null,null,"NN"]
[null,null,null,null,"NNN"]

{"sheet":"Section 3","index":4,"n_rows":27,"n_cols":3,"rows_kept":27,"cut":false,"hidden":true,"merged":[[1,0,1,2],[24,1,24,2],[0,3,0,6],[0,0,0,2]]}
["FY 2018 \nCity of Boston\n38D Property Tax Return\nForm H: Hotel/Motel/Bed & Breakfast"]
["Section 3: Food & Beverage Other Income"]
[null,"Revenue Source","Total Revenue Collected"]
[1]
[2]
[3]
[4]
[5]
[6]
[7]
[8]
[9]
[10]
[11]
[12]
[13]
[14]
[15]
[16]
[17]
[18]
[19]
[20]
[null,null,{"$f":"SUM(C4:C23)","v":0}]
[null,"Return to Income Expense Report"]
[]
[null,"Any text","0 or greater"]

{"sheet":"Section 4","index":5,"n_rows":25,"n_cols":3,"rows_kept":25,"cut":false,"hidden":true,"merged":[[1,0,1,2],[24,1,24,2],[0,3,0,6],[0,0,0,2]]}
["FY 2018 \nCity of Boston\n38D Property Tax Return\nForm H: Hotel/Motel/Bed & Breakfast"]
["Section 4: Other Revenue"]
[null,"Revenue Source","Total Revenue Collected"]
[1]
[2]
[3]
[4]
[5]
[6]
[7]
[8]
[9]
[10]
[11]
[12]
[13]
[14]
[15]
[16]
[17]
[18]
[19]
[20]
[null,null,{"$f":"SUM(C4:C23)","v":0}]
[null,"Return to Income Expense Report"]

{"sheet":"Section 5","index":6,"n_rows":25,"n_cols":3,"rows_kept":25,"cut":false,"hidden":true,"merged":[[1,0,1,2],[24,1,24,2],[0,3,0,6],[0,0,0,2]]}
["FY 2018 \nCity of Boston\n38D Property Tax Return\nForm H: Hotel/Motel/Bed & Breakfast"]
["Section 5: Departmental Expense"]
[null,"Expense Source","Expense Amount"]
[1]
[2]
[3]
[4]
[5]
[6]
[7]
[8]
[9]
[10]
[11]
[12]
[13]
[14]
[15]
[16]
[17]
[18]
[19]
[20]
[null,null,{"$f":"SUM(C4:C23)","v":0}]
[null,"Return to Income Expense Report"]

{"sheet":"Section 6","index":7,"n_rows":25,"n_cols":3,"rows_kept":25,"cut":false,"hidden":true,"merged":[[1,0,1,2],[24,1,24,2],[0,3,0,6],[0,0,0,2]]}
["FY 2018 \nCity of Boston\n38D Property Tax Return\nForm H: Hotel/Motel/Bed & Breakfast"]
["Section 6: Miscellaneous Expense"]
[null,"Expense Source","Expense Amount"]
[1]
[2]
[3]
[4]
[5]
[6]
[7]
[8]
[9]
[10]
[11]
[12]
[13]
[14]
[15]
[16]
[17]
[18]
[19]
[20]
[null,null,{"$f":"SUM(C4:C23)","v":0}]
[null,"Return to Income Expense Report"]

{"sheet":"Section 7","index":8,"n_rows":25,"n_cols":3,"rows_kept":25,"cut":false,"hidden":true,"merged":[[1,0,1,2],[24,1,24,2],[0,1,0,2],[0,3,0,6]]}
[null,"FY 2018 \nCity of Boston\n38D Property Tax Return\nForm H: Hotel/Motel/Bed & Breakfast"]
["Section 7: Other Fixed Charges"]
[null,"Expense Source","Expense Amount"]
[1]
[2]
[3]
[4]
[5]
[6]
[7]
[8]
[9]
[10]
[11]
[12]
[13]
[14]
[15]
[16]
[17]
[18]
[19]
[20]
[null,null,{"$f":"SUM(C4:C23)","v":0}]
[null,"Return to Income Expense Report"]

{"sheet":"Section 8","index":9,"n_rows":25,"n_cols":6,"rows_kept":25,"cut":false,"hidden":true,"merged":[[1,0,1,5],[24,1,24,5],[0,1,0,5]]}
[null,"FY 2018 \nCity of Boston\n38D Property Tax Return\nForm H: Hotel/Motel/Bed & Breakfast"]
["Section 8: Capital Expenditures"]
[null,"Description","Start Date (mm/dd/yyyy)","End Date (mm/dd/yyyy)","Expected Life (Years)","Amount"]
[1]
[2]
[3]
[4]
[5]
[6]
[7]
[8]
[9]
[10]
[11]
[12]
[13]
[14]
[15]
[16]
[17]
[18]
[19]
[20]
[null,null,null,null,null,{"$f":"SUM(F4:F23)","v":0}]
[null,"Return to Income Expense Report"]

{"sheet":"SummarySheet","index":10,"n_rows":12,"n_cols":8,"rows_kept":12,"cut":false,"hidden":true,"merged":[[0,3,0,4],[11,0,11,1],[10,0,10,1],[8,0,9,1]]}
[null,"FY 2018 \nCity of Boston\n38D Property Tax Return\nForm H: Hotel/Motel/Bed & Breakfast"]
[null,"Thank you, your data entry is complete.  If you have any comments regarding your data, please enter them in the box below:"]
["Comments\nSection"]
[null,"Please save and submit your workbook online at https://www.boston.gov/38d-form-h along with any attachments listed below:",null,null,{"$f":"IF(Management_Fee>0, \"Alert\", \"Check\")","v":"Check"},{"$f":"IF(Return_on_Personal_Property>0, \"Alert\", \"Check\")","v":"Check"},{"$f":"IF(Return_of_Personal_Property>0, \"Alert\", \"Check\")","v":"Check"},{"$f":"IF(Franchise_Fee>0, \"Alert\", \"Check\")","v":"Check"}]
[null,{"$f":"IF(Management_Fee>0, \"*You indicated that you have a management fee, please provide your management contract abstracts in a separate attachment with your PID as part of the file name such as 0102223334_MgmtFee\",\" \")","v":" "}]
[null,{"$f":"IF(Return_on_Personal_Property>0, \"*You indicated that you have a return on personal property, please provide detailed documentation in a separate attachment with your PID as part of the file name such as 0102223334_RetOnPP.\",\" \")","v":" "}]
[null,{"$f":"IF(Return_of_Personal_Property>0, \"*You indicated that you have a return of personal property, please provide detailed documentation in a separate attachment with your PID as part of the file name such as 0102223334_RetOfPP.\",\" \")","v":" "}]
[null,{"$f":"IF(Franchise_Fee>0, \"*You indicated that you have a management fee, please provide your management contract abstracts in a separate attachment with your PID as part of the file name such as 0102223334_FranchiseFee.\",\" \")","v":" "}]
[]
[]
["This form was saved on:"]
[{"$f":"LastSavedTimeStamp()","v":"2017-02-23T11:52:28"}]