{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Parcel Information","SectionA_B","SectionC","SectionD","SectionE"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":11,"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":[[15,0,15,10],[19,0,19,10],[0,0,0,10],[2,2,2,10],[14,0,14,10],[1,0,1,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_FY27_D (for example, 1802204000_38D_FY27_D) 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 submit the following documents at boston.gov/assessing/38D :\n• Completed Excel Workbook,\n• Any additional details can be attached as well."]
["Please submit the following information:"]
["Building Name (if applicable):",null,"*If applicable, please enter additional PIDs below"]
["Parcel ID Number(s)*:"]
["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":"SectionA_B","index":1,"n_rows":20,"n_cols":10,"rows_kept":20,"cut":false,"hidden":false,"merged":[[19,0,19,1],[0,0,0,8],[1,0,1,8],[6,0,6,9],[7,0,7,9],[8,0,8,1]]}
["Section A.  Building Description"]
["\nFor each separate building with student housing, provide a description of the building as follows. The specific type of dorm room occupancy will be listed in section B.  Please provide information on all apartment rental information as of January 1, 2026."]
["Building Name, number, address or identifier. Include any fraternity house or other group housing facility.","Building Type (Dorm, Apt, House)","Total # of dorm rooms or apt. units","Max # of beds (full capacity)","Total building square foot area","Construction type (wood frame, steel, brick, concrete)","Year Built","Story Height","Total Number of Elevators"]
[]
[]
[]
["Section B.\t Room Description"]
["1.\tProvide a complete breakdown of all housing units along with the rental income for each unit. For this questionnaire, a \"unit\" is either a dormitory room or an apartment. A fraternity house should be listed like a dormitory, with each bedroom counted as a dorm room. A dormitory room is designed for occupancy by one or more persons (or \"beds\") and includes common (shared) bathrooms on each floor, unless otherwise noted by having a private bath. Apartments include bathrooms, bedrooms and kitchen/dining areas located within each unit.\n2.\tThe housing cost paid by each student/occupant of a dorm room or apartment (excluding any meals or other fees) is considered to be the rental income for that unit. If the housing cost is combined as part of a student \"package\" that includes meals and/or other items, indicate ONLY that portion that is for the ROOM RENTAL. Otherwise, provide the total housing cost per student, per semester, and indicate that meals are included.\n3.\tComplete the summary below for each separate building that contains student housing. Describe the type and quantity of rooms/units, the duration of occupancy, and the cost that is charged to each person that is an occupant of a dormitory, fraternity or apartment building located on the property. If convenient, it is acceptable to provide the same information on your own spreadsheet. For multiple buildings, you may copy and paste this sheet as necessary."]
["Type of Room or Apt. Unit",null,"# of Beds","Private bath (Y/N)","AVERAGE Number of semesters occupied","AVERAGE Number of months occupied","AVERAGE Dollar Rate per student per academic year","Room rental includes meals (Y/N)","# of Students with free or reduced rent","Total Annual Housing Income (housing only meals not included)"]
["Dorm","1-person room (single)"]
["Dorm","2-person room (double)"]
["Dorm","3-person room (triple)"]
["Dorm","4-person room (quad)"]
["Dorm","Other:"]
["Apt","1-person studio"]
["Apt","2-bedroom"]
["Apt","3-bedroom"]
["Apt","4-bedroom"]
["Apt","Other:"]
["Totals",null,{"$f":"SUM(C10:C19)","v":0},null,null,null,null,null,null,{"$f":"SUM(J10:J19)","v":0}]

{"sheet":"SectionC","index":2,"n_rows":16,"n_cols":7,"rows_kept":16,"cut":false,"hidden":false,"merged":[[0,0,0,6]]}
["Section C. Furniture and Fixtures\n\nThis section applies only to those items that are actually provided in each dorm room for use by the occupants, and are normally replaced on a cyclical basis due to a high degree of physical deterioration.  Please provide information on all apartment rental information as of January 1, 2026.\n\n1.\t List all items that are provided (included) with each dorm unit rental, and are replaced on a regular basis.\n2.\t Indicate the typical useful life of each item: semi-annual, annual, 2-year, 3-year, 5-year, 10-year, etc.\n3.\t List the total quantity of each item that was replaced during the prior calendar year.\n4.\t List the approximate replacement cost new of each item.\n5.\t List the approximate total cost of all items replaced during the past year.\n6.\t Indicate the pro-rated annual cost of the items replaced during the past year (e.g. total cost divided by useful life)."]
["1. Item","If other please describe:","2. Length of Service","3. Total # of items replaced last year","4. Approximate cost of each item","5. Total cost of all items","6. Total annual cost (pro-rated)"]
["Bedframes"]
["Mattresses"]
["Desks"]
["Chairs"]
["Bureaus"]
["Light Fixtures"]
["Carpeting"]
["Painting"]
["Other:"]
["Other:"]
["Other:"]
["Other:"]
["Other:"]
["Other:"]

{"sheet":"SectionD","index":3,"n_rows":16,"n_cols":3,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,0,1,2],[0,0,0,2]]}
["Section D. 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/2025-12/31/2025.  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.","Parcel ID",{"$f":"MainPID","v":0}]
["Category","Annual Amount","Comments"]
["Administrative (includes management, administrative payroll, supplies, legal and general services)"]
["Security (includes all security costs, payroll and supplies)"]
["Cleaning (includes cleaning, payroll, supplies, contracts, trash/waste removal, windows, cleaning of HVAC equipment)"]
["Repairs & Maintenance (includes R&M payroll, materials, supplies and miscellaneous expenses, building exterior, grounds, landscaping and snow removal)"]
["Utilities (includes building utility expenses such as heat, lectric, tenant electric, gas, oil, water, sewer charges and other utility expenses)"]
["Advertising (includes all advertising costs related to leasing of space)"]
["Building Insurance (includes annual  building insurance cost, does NOT include any workmen's compensation premiums)"]
["Parking/Valet Expenses (includes all costs related to parking and valet operations)"]
["Total Operating Expenses"]
[]
["Replacement Reserves (include those annual amounts actually set aside by owner for future replacement of short-lived assets)"]
["Extraordinary Expenditures (include large capital expense items, necessary for the continued operation of the building. Describe the item, cost and the approximate number of years expected, economic useful life.)"]

{"sheet":"SectionE","index":4,"n_rows":33,"n_cols":9,"rows_kept":33,"cut":false,"hidden":false,"merged":[[0,0,0,1],[17,0,17,8],[18,0,18,8],[32,0,32,8]]}
["Section E. Other Income\nList below any additional revenue other than reported above (i.e. cafeteria, other retail, off-season room rentals, parking fees, vending machines, billboards).  See section below for wireless telecom/antenna leases."]
["Revenue Source","Annual Income"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Commercial Wireless Lease Information"]
["Please list any and all leases that involve telecommunications equipment located on your property, along with details of each lease. Such equipment may include installation of wireless antenna(s), cell tower(s), support platform(s), microwave or satellite dish(s), etc. The effective reporting date for this information is January 1, 2026. See notes below for details about the reporting."]
["Wireless Carrier Name","If other, describe:","Lease Amount ($) per Year","Lease Start Date (MM/DD/YYYY)","Lease Term: Number of Months","Antenna Location \n","Number of Antenna units","Support Platform Area \n(Square Feet)","Type of wireless equipment (describe briefly)"]
["Verizon"]
["Sprint"]
["AT & T"]
["T – MOBILE"]
["Metro – PCS"]
["Fiber Tower Corp"]
["American Tower"]
["Nextel"]
["Other:"]
["Other:"]
["Other: "]
["Other:"]
["Wireless Carrier:  If carrier name is not listed above, indicate the name of the service provider, lessee or telecom management company.\nLease Amount:\tIndicate the current lease amount, and whether the payment is per month or year.\nLease Terms: Indicate the current lease terms, including the most recent renewal date and the total number of years of the lease.\nAntenna Location:  Indicate the location of the antenna installation or platform itself, not the ancillary cabling, cabinets or interior base station. R – roof,   EW – exterior wall,   G – ground,   IN – Inside main building,    O – Other/describe (e. g. flagpole, steeple, etc.) \nNum. antenna units: Indicate the approximate number of antenna units, pods or dish installations, per service carrier.\nPlatform sq ft area: For installations greater than 30 sq ft, indicate the approximate sq ft of the base platform or support fixture.\nBrief Description: Describe the type of telecom equipment (e. g. 8 @ 12” panel-style antennae; 1 @ 5’ diameter microwave dish antenna)"]