{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Parcel Information","SH_ParcelSummary","Financial Info","Rent Roll","Additional Income","Expenses","Key"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":13,"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":"Parcel Information","index":0,"n_rows":24,"n_cols":3,"rows_kept":24,"cut":false,"hidden":false,"merged":[[12,1,12,10],[13,1,13,10],[15,0,15,10],[19,0,19,10],[0,0,0,10],[14,0,14,10],[1,0,1,10],[2,1,2,10],[3,1,3,10],[4,1,4,10],[5,1,5,10],[6,1,6,10],[7,1,7,10],[8,1,8,10],[9,1,9,10],[10,1,10,10],[11,1,11,10]]}
["Dear Owner/Representative:\n\nThe following information is requested pursuant to Massachusetts General Law Chapter 59; Section 38D, 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.\n\nIf you fail to comply within 60 days of the request, it may be automatic grounds for dismissal of a filing at the appellate tax board. You may also face a fine of $50 for residential properties, or $250 for commercial or industrial properties. The penalty will appear on next year’s tax bill. All information submitted is confidential.\n\nCompleting this workbook provides the City of Boston with the most accurate information to assess your property class. Please save your file as YourParcelID_38D_A2 (for example, 1802204000_38D_SH) as you go, save it somewhere that will be easy to find (such as your Desktop). Complete all tabs with all applicable information.\n\nOnce you have completed all the tabs in the workbook, please visit boston.gov/assessing/38D to submit the following documents:\n• Completed Excel Workbook,\n• Rent Rolls,\n• Management Agreements,\n• Details about any additional income derived from parking operations, billboards or telcommunications leases and\n• Income and Expense statement for year ending December 31, 2018."]
["Please submit the following information:"]
["Building Name (if applicable):"]
[" Lead Parcel ID Number ONLY*:"]
["Property Street Address:"]
["City:"]
["State:"]
["Zip Code:"]
["Owner Name:"]
["Owner Company Name:"]
["Owner Street Address:"]
["Owner City:"]
["State:"]
["Zip Code:"]
["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:"]
["Position or Title:"]
["Phone Number:"]
["Contact Email Address:"]

{"sheet":"SH_ParcelSummary","index":1,"n_rows":33,"n_cols":15,"rows_kept":33,"cut":false,"hidden":false,"merged":[[0,0,0,14],[1,11,1,14],[1,4,1,10],[1,2,2,2],[1,1,2,1],[1,0,2,0],[1,3,2,3]]}
["Please list ALL parcel numbers included for this submission ***DO NOT SKIP or you may not receive credit for the submission***"]
["Parcel Count","10 digit Ward & Parcel Number","Street Address","Housing Type (see dropdown list)","Number of Units per Parcel",null,null,null,null,null,null,"Square Footage"]
[null,null,null,null,"Studio","1 BR","2 BR","3 BR","4 BR","Room Rental","Parking Spaces","Retail","Office","Other","Describe Other Space"]
[1]
[2]
[3]
[4]
[5]
[6]
[7]
[8]
[9]
[10]
[11]
[12]
[13]
[14]
[15]
[16]
[17]
[18]
[19]
[20]
[21]
[22]
[23]
[24]
[25]
[26]
[27]
[28]
[29]
[30]

{"sheet":"Financial Info","index":2,"n_rows":14,"n_cols":1,"rows_kept":14,"cut":false,"hidden":false,"merged":[[0,0,0,1],[9,0,9,1],[3,0,3,1]]}
["Partnership and Financial Information"]
["Name of Partnership"]
["Did this program receive Low Income Tax Credit?"]
["If Yes, please provide the following:"]
["Start Date"]
["Expiration Date"]
["Amount Per Year"]
[]
["Did this program receive financing?"]
["If Yes, please provide the following:"]
["Start Date"]
["Amount"]
["Number of Years"]
["Interest Rate"]

{"sheet":"Rent Roll","index":3,"n_rows":4,"n_cols":9,"rows_kept":4,"cut":false,"hidden":false,"merged":[[2,0,2,4],[1,0,1,5]]}
[{"$f":"MID(CELL(\"filename\",B1),FIND(\"]\",CELL(\"filename\",B1))+1,32)","v":"Rent Roll"}]
["Please provide information on all apartment rental information as of January 1, 2019."]
["Do not substitute this section, complete new lease information below.",null,null,null,null,"Lead Parcel ID",{"$f":"MainPID","v":0}]
["Location Parcel ID","Apartment # \n(e.g. Unit #2A)","Tenant Name","Number of Bedrooms","Square Footage","Actual Monthly Rent as of 1/1/2019","Monthly Subsidy \nAmount as of 1/1/2019","Total Annual Income for Calendar Year 2018 (Rent and Subsidy included)","Vacant as of 1/1/2019 (Y/N)"]

{"sheet":"Additional Income","index":4,"n_rows":29,"n_cols":8,"rows_kept":29,"cut":false,"hidden":false,"merged":[[27,0,27,7],[2,1,2,4],[12,0,12,3]]}
["Additional Sources of Income",null,"Parcel ID",{"$f":"MainPID","v":0}]
[]
["Parking Information ","If you have parking income, please report the following information:"]
[null,"Number of Spaces","Monthly Rate per Parking Space on 1/1/2019","Total Collected Income for CY 2018","Valet or Self-Park"]
["Residential"]
["Commercial"]
["Other"]
["Is there a lease or management agreement? (Yes/No)"]
["Date of lease or management agreement (MM/DD/YYYY)"]
["Name of lessee or operator"]
[]
[]
["Other Income received from Tenants:"]
[null,"Description","Monthly Fee per Unit","Annual Income"]
["Amenity Fees"]
["Amenity Fees"]
["Amenity Fees"]
["Amenity Fees"]
[]
["Telecommunications"]
["Equipment Type","Monthly Fee","Annual Income for CY 2018"]
["Antenna"]
["Satellite Dish"]
["Cell tower"]
["Other Income"]
[]
[]
["Non-Apartment Leases (Commercial or Other)"]
["Occupancy Type (Bank, Office, Restaurant, etc…)","Tenant Name","Rentable Square Feet (SF)","Rent per SF as of 1/1/2019","Lease Basis","Lease Term (months)","Lease Start Date (MM/DD/YYYY)","Lease End Date\n(MM/DD/YYYY)"]

{"sheet":"Expenses","index":5,"n_rows":43,"n_cols":4,"rows_kept":43,"cut":false,"hidden":false,"merged":[[0,0,0,3],[1,0,1,3],[3,0,4,0],[5,0,10,0],[2,0,2,1],[42,0,42,2],[3,3,4,3],[3,1,4,1],[11,0,15,0],[16,0,23,0],[24,0,29,0],[30,0,32,0],[33,0,37,0],[39,0,39,1],[3,2,4,2]]}
["Expenses"]
["Fill out all white boxes with the appropriate amount, if there is no expense in the category, please enter \"0\". Provide the property expense information for the period 1/1/2018-12/31/2018.  Provide the actual annual costs to operate the building on an accrual basis; do NOT use \"budgeted\" or projected expense amounts. "]
["Do not substitute this section.",null,"Parcel ID",{"$f":"MainPID","v":0}]
["FY 2020","Category","Annual Amount","Comments"]
[]
["Administrative","Payroll"]
[null,"Management"]
[null,"Legal"]
[null,"General Services"]
[null,"Security"]
[null,"Total Administrative"]
["Cleaning","Payroll"]
[null,"Contracts"]
[null,"HVAC"]
[null,"Miscellaneous"]
[null,"Total Cleaning"]
["Repairs & Maintenance","Payroll"]
[null,"Elevators"]
[null,"HVAC"]
[null,"Electrical "]
[null,"Plumbing"]
[null,"Supplies"]
[null,"Miscellaneous"]
[null,"Total Repairs & Maintenance"]
["Utilities","Electric"]
[null,"Gas"]
[null,"Steam"]
[null,"Water"]
[null,"Other"]
[null,"Total Utilities"]
["Leasing Expenses","Advertising"]
[null,"Commissions"]
[null,"Total Leasing Expenses"]
["Fixed Expenses","Buildings Insurance"]
[null,"Replacement Reserves"]
[null,"Extraordinary Expenditures"]
[null,"Government Mandated Improvements"]
[null,"Fixed Expenses Total"]
["Other Expense","Other Expense (Describe in Comments)"]
["Total Expenses"]
[]
[]
["Comments (Please provide an overview of the building's operations in calendar year 2018.)"]

{"sheet":"Key","index":6,"n_rows":36,"n_cols":2,"rows_kept":36,"cut":false,"hidden":true,"merged":[]}
["USE OF SPACE","ABBREVIATE"]
["ATM","ATM"]
["Bank","BNK"]
["Cell antenna/Telecom","ANT"]
["Classroom","CLS"]
["Conduit ","PIP"]
["Conference Roon","CON"]
["Daycare ","DAY"]
["Fitness Center/Gym","GYM"]
["Garage ","GAR"]
["Medical Office ","MED"]
["Office","OFF"]
["Restaurant","RES"]
["Other","OTH"]
["Retail ","RET"]
["Storage","STG"]
["Warehouse","WRH"]
["LAB","LAB"]
[]
[]
["LEASE TYPE","ABBREVIATE"]
["New ","NEW"]
["Renewal ","REN"]
["Expansion","EXP"]
["Extension","EXT"]
["Downsize & Renew","DWN/REN"]
["Expand & Renew","EXP/REN"]
["Relocation","RELO"]
["Other","OTH"]
[]
["BASIS OF LEASE","ABBREVIATE"]
["Gross","GRS"]
["Modified Gross","MGR"]
["Net","NET"]
["Triple Net ","NNN"]
["Other","OTH"]