{"text_format":"1","workbook":"xlsx","n_sheets":15,"sheets":["Instructions","Summary","Drop Downs","Property 1","Property 2","Property 3","Property 4","Property 5","Property 6","Property 7","Property 8","Property 9","Property 10","Property 11","Property 12"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":2,"defined_names":2,"comments":12,"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":"Instructions","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Summary","index":1,"n_rows":43,"n_cols":16,"rows_kept":43,"cut":false,"hidden":false,"merged":[[2,3,2,15],[1,3,1,4],[42,1,42,2],[9,1,9,2],[30,1,30,2],[32,1,32,2]]}
[]
[" ","CUSTOMER/ENTITY NAME",null,2024]
[null,"MULTI-PROPERTY OVERVIEW",null,"Enter data on individual property sheets. Overview information will populate automatically.  "]
[null,"INCOME",null,1,2,3,4,5,6,7,8,9,10,11,12,"YTD TOTAL"]
[null,"MULTI-PROPERTY INCOME OVERVIEW"]
[null,"RENTS RECEIVED",null,{"$f":"'Property 1'!P5","v":0},{"$f":"'Property 2'!P5","v":0},{"$f":"'Property 3'!P5","v":0},{"$f":"'Property 4'!P5","v":0},{"$f":"'Property 5'!P5","v":0},{"$f":"'Property 6'!P5","v":0},{"$f":"'Property 7'!P5","v":0},{"$f":"'Property 8'!P5","v":0},{"$f":"'Property 9'!P5","v":0},{"$f":"'Property 10'!P5","v":0},{"$f":"'Property 11'!P5","v":0},{"$f":"'Property 12'!P5","v":0},{"$f":"SUM(D6:O6)","v":0}]
[null,"SECURITY DEPOSIT (TO BE RETURNED)",null,{"$f":"'Property 1'!P6","v":0},{"$f":"'Property 2'!P6","v":0},{"$f":"'Property 3'!P6","v":0},{"$f":"'Property 4'!P6","v":0},{"$f":"'Property 5'!P6","v":0},{"$f":"'Property 6'!P6","v":0},{"$f":"'Property 7'!P6","v":0},{"$f":"'Property 8'!P6","v":0},{"$f":"'Property 9'!P6","v":0},{"$f":"'Property 10'!P6","v":0},{"$f":"'Property 11'!P6","v":0},{"$f":"'Property 12'!P6","v":0},{"$f":"SUM(D7:O7)","v":0}]
[null,"SECURITY DEPOSIT FORFEITED",null,{"$f":"'Property 1'!P7","v":0},{"$f":"'Property 2'!P7","v":0},{"$f":"'Property 3'!P7","v":0},{"$f":"'Property 4'!P7","v":0},{"$f":"'Property 5'!P7","v":0},{"$f":"'Property 6'!P7","v":0},{"$f":"'Property 7'!P7","v":0},{"$f":"'Property 8'!P7","v":0},{"$f":"'Property 9'!P7","v":0},{"$f":"'Property 10'!P7","v":0},{"$f":"'Property 11'!P7","v":0},{"$f":"'Property 12'!P7","v":0},0]
[null,"OTHER RENTAL INCOME  – Late Fees, Move out charges, Etc.",null,{"$f":"'Property 1'!P8","v":0},{"$f":"'Property 2'!P8","v":0},{"$f":"'Property 3'!P8","v":0},{"$f":"'Property 4'!P8","v":0},{"$f":"'Property 5'!P8","v":0},{"$f":"'Property 6'!P8","v":0},{"$f":"'Property 7'!P8","v":0},{"$f":"'Property 8'!P8","v":0},{"$f":"'Property 9'!P8","v":0},{"$f":"'Property 10'!P8","v":0},{"$f":"'Property 11'!P8","v":0},{"$f":"'Property 12'!P8","v":0},{"$f":"SUM(D9:O9)","v":0}]
[null,"GROSS RENTAL INCOME",null,{"$f":"SUM(D6:D9)","v":0},{"$f":"SUM(E6:E9)","v":0},0,0,0,0,0,0,0,0,0,{"$f":"SUM(O6:O9)","v":0},{"$f":"SUM(D10:O10)","v":0}]
[]
[null,"EXPENSES",null,1,2,3,4,5,6,7,8,9,10,11,12,"YTD TOTAL"]
[null,"MULTI-PROPERTY EXPENSES OVERVIEW"]
[null,"ADVERTISING / MARKETING",null,{"$f":"'Property 1'!P13+'Property 1'!P14","v":0},{"$f":"'Property 2'!P13+'Property 2'!P14","v":0},{"$f":"'Property 3'!P13+'Property 3'!P14","v":0},{"$f":"'Property 4'!P13+'Property 4'!P14","v":0},{"$f":"'Property 5'!P13+'Property 5'!P14","v":0},{"$f":"'Property 6'!P13+'Property 6'!P14","v":0},{"$f":"'Property 7'!P13+'Property 7'!P14","v":0},{"$f":"'Property 8'!P13+'Property 8'!P14","v":0},{"$f":"'Property 9'!P13+'Property 9'!P14","v":0},{"$f":"'Property 10'!P13+'Property 10'!P14","v":0},{"$f":"'Property 11'!P13+'Property 11'!P14","v":0},{"$f":"'Property 12'!P13+'Property 12'!P14","v":0},{"$f":"SUM(D14:O14)","v":0}]
[null,"AUTO & TRAVEL",null,{"$f":"'Property 1'!P15","v":0},{"$f":"'Property 2'!P15","v":0},{"$f":"'Property 3'!P15","v":0},{"$f":"'Property 4'!P15","v":0},{"$f":"'Property 5'!P15","v":0},{"$f":"'Property 6'!P15","v":0},{"$f":"'Property 7'!P15","v":0},{"$f":"'Property 8'!P15","v":0},{"$f":"'Property 9'!P15","v":0},{"$f":"'Property 10'!P15","v":0},{"$f":"'Property 11'!P15","v":0},{"$f":"'Property 12'!P15","v":0},{"$f":"SUM(D15:O15)","v":0}]
[null,"CLEANING & MAINTENANCE",null,{"$f":"'Property 1'!P24+'Property 1'!P25+'Property 1'!P26","v":0},{"$f":"'Property 2'!P24+'Property 2'!P25+'Property 2'!P26","v":0},{"$f":"'Property 3'!P24+'Property 3'!P25+'Property 3'!P26","v":0},{"$f":"'Property 4'!P24+'Property 4'!P25+'Property 4'!P26","v":0},{"$f":"'Property 5'!P24+'Property 5'!P25+'Property 5'!P26","v":0},{"$f":"'Property 6'!P24+'Property 6'!P25+'Property 6'!P26","v":0},{"$f":"'Property 7'!P24+'Property 7'!P25+'Property 7'!P26","v":0},{"$f":"'Property 8'!P24+'Property 8'!P25+'Property 8'!P26","v":0},{"$f":"'Property 9'!P24+'Property 9'!P25+'Property 9'!P26","v":0},{"$f":"'Property 10'!P24+'Property 10'!P25+'Property 10'!P26","v":0},{"$f":"'Property 11'!P24+'Property 11'!P25+'Property 11'!P26","v":0},{"$f":"'Property 12'!P24+'Property 12'!P25+'Property 12'!P26","v":0},0]
[null,"COMMISSIONS",null,{"$f":"'Property 1'!P16","v":0},{"$f":"'Property 2'!P16","v":0},{"$f":"'Property 3'!P16","v":0},{"$f":"'Property 4'!P16","v":0},{"$f":"'Property 5'!P16","v":0},{"$f":"'Property 6'!P16","v":0},{"$f":"'Property 7'!P16","v":0},{"$f":"'Property 8'!P16","v":0},{"$f":"'Property 9'!P16","v":0},{"$f":"'Property 10'!P16","v":0},{"$f":"'Property 11'!P16","v":0},{"$f":"'Property 12'!P16","v":0},0]
[null,"INSURANCE",null,{"$f":"'Property 1'!P23","v":0},{"$f":"'Property 2'!P23","v":0},{"$f":"'Property 3'!P23","v":0},{"$f":"'Property 4'!P23","v":0},{"$f":"'Property 5'!P23","v":0},{"$f":"'Property 6'!P23","v":0},{"$f":"'Property 7'!P23","v":0},{"$f":"'Property 8'!P23","v":0},{"$f":"'Property 9'!P23","v":0},{"$f":"'Property 10'!P23","v":0},{"$f":"'Property 11'!P23","v":0},{"$f":"'Property 12'!P23","v":0},0]
[null,"LEGAL & OTHER PROFESSIONAL FEES",null,{"$f":"'Property 1'!P19+'Property 1'!P20+'Property 1'!P18","v":0},{"$f":"'Property 2'!P19+'Property 2'!P20+'Property 2'!P18","v":0},{"$f":"'Property 3'!P19+'Property 3'!P20+'Property 3'!P18","v":0},{"$f":"'Property 4'!P19+'Property 4'!P20+'Property 4'!P18","v":0},{"$f":"'Property 5'!P19+'Property 5'!P20+'Property 5'!P18","v":0},{"$f":"'Property 6'!P19+'Property 6'!P20+'Property 6'!P18","v":0},{"$f":"'Property 7'!P19+'Property 7'!P20+'Property 7'!P18","v":0},{"$f":"'Property 8'!P19+'Property 8'!P20+'Property 8'!P18","v":0},{"$f":"'Property 9'!P19+'Property 9'!P20+'Property 9'!P18","v":0},{"$f":"'Property 10'!P19+'Property 10'!P20+'Property 10'!P18","v":0},{"$f":"'Property 11'!P19+'Property 11'!P20+'Property 11'!P18","v":0},{"$f":"'Property 12'!P19+'Property 12'!P20+'Property 12'!P18","v":0},0]
[null,"MANAGEMENT FEES",null,{"$f":"'Property 1'!P21","v":0},{"$f":"'Property 2'!P21","v":0},{"$f":"'Property 3'!P21","v":0},{"$f":"'Property 4'!P21","v":0},{"$f":"'Property 5'!P21","v":0},{"$f":"'Property 6'!P21","v":0},{"$f":"'Property 7'!P21","v":0},{"$f":"'Property 8'!P21","v":0},{"$f":"'Property 9'!P21","v":0},{"$f":"'Property 10'!P21","v":0},{"$f":"'Property 11'!P21","v":0},{"$f":"'Property 12'!P21","v":0},0]
[null,"MORTGAGE INTEREST (Form 1098)",null,{"$f":"'Property 1'!P27","v":0},{"$f":"'Property 2'!P27","v":0},{"$f":"'Property 3'!P27","v":0},{"$f":"'Property 4'!P27","v":0},{"$f":"'Property 5'!P27","v":0},{"$f":"'Property 6'!P27","v":0},{"$f":"'Property 7'!P27","v":0},{"$f":"'Property 8'!P27","v":0},{"$f":"'Property 9'!P27","v":0},{"$f":"'Property 10'!P27","v":0},{"$f":"'Property 11'!P27","v":0},{"$f":"'Property 12'!P27","v":0},0]
[null,"OTHER INTEREST",null,{"$f":"'Property 1'!P28","v":0},{"$f":"'Property 2'!P28","v":0},{"$f":"'Property 3'!P28","v":0},{"$f":"'Property 4'!P28","v":0},{"$f":"'Property 5'!P28","v":0},{"$f":"'Property 6'!P28","v":0},{"$f":"'Property 7'!P28","v":0},{"$f":"'Property 8'!P28","v":0},{"$f":"'Property 9'!P28","v":0},{"$f":"'Property 10'!P28","v":0},{"$f":"'Property 11'!P28","v":0},{"$f":"'Property 12'!P28","v":0},0]
[null,"REPAIRS",null,{"$f":"'Property 1'!P30","v":0},{"$f":"'Property 2'!P30","v":0},{"$f":"'Property 3'!P30","v":0},{"$f":"'Property 4'!P30","v":0},{"$f":"'Property 5'!P30","v":0},{"$f":"'Property 6'!P30","v":0},{"$f":"'Property 7'!P30","v":0},{"$f":"'Property 8'!P30","v":0},{"$f":"'Property 9'!P30","v":0},{"$f":"'Property 10'!P30","v":0},{"$f":"'Property 11'!P30","v":0},{"$f":"'Property 12'!P30","v":0},0]
[null,"SUPPLIES",null,{"$f":"'Property 1'!P31+'Property 1'!P29","v":0},{"$f":"'Property 2'!P31+'Property 2'!P29","v":0},{"$f":"'Property 3'!P31+'Property 3'!P29","v":0},{"$f":"'Property 4'!P31+'Property 4'!P29","v":0},{"$f":"'Property 5'!P31+'Property 5'!P29","v":0},{"$f":"'Property 6'!P31+'Property 6'!P29","v":0},{"$f":"'Property 7'!P31+'Property 7'!P29","v":0},{"$f":"'Property 8'!P31+'Property 8'!P29","v":0},{"$f":"'Property 9'!P31+'Property 9'!P29","v":0},{"$f":"'Property 10'!P31+'Property 10'!P29","v":0},{"$f":"'Property 11'!P31+'Property 11'!P29","v":0},{"$f":"'Property 12'!P31+'Property 12'!P29","v":0},0]
[null,"TAXES",null,{"$f":"'Property 1'!P32","v":0},{"$f":"'Property 2'!P32","v":0},{"$f":"'Property 3'!P32","v":0},{"$f":"'Property 4'!P32","v":0},{"$f":"'Property 5'!P32","v":0},{"$f":"'Property 6'!P32","v":0},{"$f":"'Property 7'!P32","v":0},{"$f":"'Property 8'!P32","v":0},{"$f":"'Property 9'!P32","v":0},{"$f":"'Property 10'!P32","v":0},{"$f":"'Property 11'!P32","v":0},{"$f":"'Property 12'!P32","v":0},0]
[null,"UTILITIES",null,{"$f":"'Property 1'!P33+'Property 1'!P34+'Property 1'!P35+'Property 1'!P36+'Property 1'!P37","v":0},{"$f":"'Property 2'!P33+'Property 2'!P34+'Property 2'!P35+'Property 2'!P36+'Property 2'!P37","v":0},{"$f":"'Property 3'!P33+'Property 3'!P34+'Property 3'!P35+'Property 3'!P36+'Property 3'!P37","v":0},{"$f":"'Property 4'!P33+'Property 4'!P34+'Property 4'!P35+'Property 4'!P36+'Property 4'!P37","v":0},{"$f":"'Property 5'!P33+'Property 5'!P34+'Property 5'!P35+'Property 5'!P36+'Property 5'!P37","v":0},{"$f":"'Property 6'!P33+'Property 6'!P34+'Property 6'!P35+'Property 6'!P36+'Property 6'!P37","v":0},{"$f":"'Property 7'!P33+'Property 7'!P34+'Property 7'!P35+'Property 7'!P36+'Property 7'!P37","v":0},{"$f":"'Property 8'!P33+'Property 8'!P34+'Property 8'!P35+'Property 8'!P36+'Property 8'!P37","v":0},{"$f":"'Property 9'!P33+'Property 9'!P34+'Property 9'!P35+'Property 9'!P36+'Property 9'!P37","v":0},{"$f":"'Property 10'!P33+'Property 10'!P34+'Property 10'!P35+'Property 10'!P36+'Property 10'!P37","v":0},{"$f":"'Property 11'!P33+'Property 11'!P34+'Property 11'!P35+'Property 11'!P36+'Property 11'!P37","v":0},{"$f":"'Property 12'!P33+'Property 12'!P34+'Property 12'!P35+'Property 12'!P36+'Property 12'!P37","v":0},0]
[null,"DEPRECIATION EXPENSE OR DEPLETION",null,{"$f":"'Property 1'!T22","v":0},{"$f":"'Property 2'!T21","v":0},{"$f":"'Property 3'!T21","v":0},{"$f":"'Property 4'!T21","v":0},{"$f":"'Property 5'!T21","v":0},{"$f":"'Property 6'!T21","v":0},{"$f":"'Property 7'!T21","v":0},{"$f":"'Property 8'!T21","v":0},{"$f":"'Property 9'!T21","v":0},{"$f":"'Property 10'!T21","v":0},{"$f":"'Property 11'!T21","v":0},{"$f":"'Property 12'!T21","v":0},0]
[null,"OTHER: HOA DUES",null,{"$f":"'Property 1'!P22","v":0},{"$f":"'Property 2'!P22","v":0},{"$f":"'Property 3'!P22","v":0},{"$f":"'Property 4'!P22","v":0},{"$f":"'Property 5'!P22","v":0},{"$f":"'Property 6'!P22","v":0},{"$f":"'Property 7'!P22","v":0},{"$f":"'Property 8'!P22","v":0},{"$f":"'Property 9'!P22","v":0},{"$f":"'Property 10'!P22","v":0},{"$f":"'Property 11'!P22","v":0},{"$f":"'Property 12'!P22","v":0},0]
[null,"OTHER: BANK FEES",null,{"$f":"'Property 1'!P17","v":0},{"$f":"'Property 2'!P17","v":0},{"$f":"'Property 3'!P17","v":0},{"$f":"'Property 4'!P17","v":0},{"$f":"'Property 5'!P17","v":0},{"$f":"'Property 6'!P17","v":0},{"$f":"'Property 7'!P17","v":0},{"$f":"'Property 8'!P17","v":0},{"$f":"'Property 9'!P17","v":0},{"$f":"'Property 10'!P17","v":0},{"$f":"'Property 11'!P17","v":0},{"$f":"'Property 12'!P17","v":0},0]
[null,"OTHER",null,{"$f":"'Property 1'!P38+'Property 1'!P39+'Property 1'!P40+'Property 1'!P41","v":0},{"$f":"'Property 2'!P38+'Property 2'!P39+'Property 2'!P40+'Property 2'!P41","v":0},{"$f":"'Property 3'!P38+'Property 3'!P39+'Property 3'!P40+'Property 3'!P41","v":0},{"$f":"'Property 4'!P38+'Property 4'!P39+'Property 4'!P40+'Property 4'!P41","v":0},{"$f":"'Property 5'!D38+'Property 5'!D39+'Property 5'!D40+'Property 5'!D41","v":0},{"$f":"'Property 6'!P38+'Property 6'!P39+'Property 6'!P40+'Property 6'!P41","v":0},{"$f":"'Property 7'!P38+'Property 7'!P39+'Property 7'!P40+'Property 7'!P41","v":0},{"$f":"'Property 8'!P38+'Property 8'!P39+'Property 8'!P40+'Property 8'!P41","v":0},{"$f":"'Property 9'!P38+'Property 9'!P39+'Property 9'!P40+'Property 9'!P41","v":0},{"$f":"'Property 10'!P38+'Property 10'!P39+'Property 10'!P40+'Property 10'!P41","v":0},{"$f":"'Property 11'!P38+'Property 11'!P39+'Property 11'!P40+'Property 11'!P41","v":0},{"$f":"'Property 12'!P38+'Property 12'!P39+'Property 12'!P40+'Property 12'!P41","v":0},0]
[null,"TOTAL EXPENSES",null,{"$f":"SUM(D14:D30)","v":0},0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(D31:O31)","v":0}]
[]
[null,"YEAR-TO-DATE INCOME LESS EXPENSES",null,{"$f":"D10-D31","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[]
[]
[null,"IMPROVEMENTS","DATE OF PURCHASE",1,2,3,4,5,6,7,8,9,10,11,12,"YR TOTAL"]
[null,"EQUIPMENT / APPLIANCE PURCHASES","see property sheet",{"$f":"'Property 1'!P48","v":0},{"$f":"'Property 2'!P48","v":0},{"$f":"'Property 3'!P48","v":0},{"$f":"'Property 4'!P48","v":0},{"$f":"'Property 5'!P48","v":0},{"$f":"'Property 6'!P48","v":0},{"$f":"'Property 7'!P48","v":0},{"$f":"'Property 8'!P48","v":0},{"$f":"'Property 9'!P48","v":0},{"$f":"'Property 10'!P48","v":0},{"$f":"'Property 11'!P48","v":0},{"$f":"'Property 12'!P48","v":0},{"$f":"SUM(D37:O37)","v":0}]
[null,"REMODEL","see property sheet",{"$f":"'Property 1'!P49","v":0},{"$f":"'Property 2'!P49","v":0},{"$f":"'Property 3'!P49","v":0},{"$f":"'Property 4'!P49","v":0},{"$f":"'Property 5'!P49","v":0},{"$f":"'Property 6'!P49","v":0},{"$f":"'Property 7'!P49","v":0},{"$f":"'Property 8'!P49","v":0},{"$f":"'Property 9'!P49","v":0},{"$f":"'Property 10'!P49","v":0},{"$f":"'Property 11'!P49","v":0},{"$f":"'Property 12'!P49","v":0},{"$f":"SUM(D38:O38)","v":0}]
[null,"FLOORING","see property sheet",{"$f":"'Property 1'!P50","v":0},{"$f":"'Property 2'!P50","v":0},{"$f":"'Property 3'!P50","v":0},{"$f":"'Property 4'!P50","v":0},{"$f":"'Property 5'!P50","v":0},{"$f":"'Property 6'!P50","v":0},{"$f":"'Property 7'!P50","v":0},{"$f":"'Property 8'!P50","v":0},{"$f":"'Property 9'!P50","v":0},{"$f":"'Property 10'!P50","v":0},{"$f":"'Property 11'!P50","v":0},{"$f":"'Property 12'!P50","v":0},0]
[null,"ROOF","see property sheet",{"$f":"'Property 1'!P51","v":0},{"$f":"'Property 2'!P51","v":0},{"$f":"'Property 3'!P51","v":0},{"$f":"'Property 4'!P51","v":0},{"$f":"'Property 5'!P51","v":0},{"$f":"'Property 6'!P51","v":0},{"$f":"'Property 7'!P51","v":0},{"$f":"'Property 8'!P51","v":0},{"$f":"'Property 9'!P51","v":0},{"$f":"'Property 10'!P51","v":0},{"$f":"'Property 11'!P51","v":0},{"$f":"'Property 12'!P51","v":0},0]
[null,"OTHER","see property sheet",{"$f":"'Property 1'!P52","v":0},{"$f":"'Property 2'!P52","v":0},{"$f":"'Property 3'!P52","v":0},{"$f":"'Property 4'!P52","v":0},{"$f":"'Property 5'!P52","v":0},{"$f":"'Property 6'!P52","v":0},{"$f":"'Property 7'!P52","v":0},{"$f":"'Property 8'!P52","v":0},{"$f":"'Property 9'!P52","v":0},{"$f":"'Property 10'!P52","v":0},{"$f":"'Property 11'!P52","v":0},{"$f":"'Property 12'!P52","v":0},0]
[null,"OTHER","see property sheet",{"$f":"'Property 1'!P53","v":0},{"$f":"'Property 2'!P53","v":0},{"$f":"'Property 3'!P53","v":0},{"$f":"'Property 4'!P53","v":0},{"$f":"'Property 5'!P53","v":0},{"$f":"'Property 6'!P53","v":0},{"$f":"'Property 7'!P53","v":0},{"$f":"'Property 8'!P53","v":0},{"$f":"'Property 9'!P53","v":0},{"$f":"'Property 10'!P53","v":0},{"$f":"'Property 11'!P53","v":0},{"$f":"'Property 12'!P53","v":0},0]
[null,"TOTAL IMPROVEMENTS",null,{"$f":"SUM(D37:D42)","v":0},{"$f":"SUM(E37:E42)","v":0},0,0,{"$f":"SUM(H37:H42)","v":0},0,0,0,0,0,0,0,{"$f":"SUM(P37:P42)","v":0}]

{"sheet":"Drop Downs","index":2,"n_rows":6,"n_cols":7,"rows_kept":6,"cut":false,"hidden":true,"merged":[]}
["Ownership",null,"STR/LTR",null,"Column1",null,"Property Type"]
["No",null,"Short Term",null,"Yes",null,"Single Family Residence"]
["LLC",null,"Long Term",null,"No",null,"Multi-Family Residence"]
["Trust",null,null,null,null,null,"Vacation/Short-Term Rental"]
["Estate",null,null,null,null,null,"Commercial"]
[null,null,null,null,null,null,"Land"]

{"sheet":"Property 1","index":3,"n_rows":54,"n_cols":20,"rows_kept":54,"cut":false,"hidden":false,"merged":[[53,1,53,2],[10,1,10,2],[2,1,2,2],[8,1,8,2],[7,1,7,2],[6,1,6,2],[5,1,5,2],[4,1,4,2],[3,1,3,2],[11,1,11,2],[46,1,46,2],[1,3,1,15],[2,18,2,19],[0,3,0,4],[43,1,43,2],[41,1,41,2],[0,1,0,2],[1,1,1,2],[36,18,36,19],[19,18,19,19],[24,18,24,19],[37,18,37,19],[38,18,41,19]]}
[" ",{"$f":"Summary!B2","v":"CUSTOMER/ENTITY NAME"},null,{"$f":"Summary!D2","v":2024}]
[null,"PROPERTY 1 ADDRESS",null,"123 Main Street, City, State 10001"]
[null,"INCOME",null,"JAN","FEB","MAR","APR","MAY","JUN","JUL","AUG","SEPT","OCT","NOV","DEC","YR TOTAL",null,null,"PROPERTY FACT SHEET"]
[null,"MULTI-PROPERTY INCOME OVERVIEW"]
[null,{"$f":"Summary!B6","v":"RENTS RECEIVED"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D5:O5)","v":0},null,null,"Property Type"]
[null,{"$f":"Summary!B7","v":"SECURITY DEPOSIT (TO BE RETURNED)"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D6:O6)","v":0},null,null,"Purchase Date"]
[null,{"$f":"Summary!B8","v":"SECURITY DEPOSIT FORFEITED"},null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"Placed in Service Date"]
[null,{"$f":"Summary!B9","v":"OTHER RENTAL INCOME  – Late Fees, Move out charges, Etc."},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D8:O8)","v":0},null,null,"Property Cost details are available to Formations","Yes"]
[null,"GROSS RENTAL INCOME",null,{"$f":"SUM(D5:D8)","v":0},{"$f":"SUM(E5:E8)","v":0},0,0,0,0,0,0,0,0,0,{"$f":"SUM(O5:O8)","v":0},{"$f":"SUM(D9:O9)","v":0},null,null,"Purchase Price"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"# Fair Rental Days (out of 365)"]
[null,"EXPENSES",null,"JAN","FEB","MAR","APR","MAY","JUN","JUL","AUG","SEPT","OCT","NOV","DEC","YR TOTAL",null,null,"Land Value"]
[null,{"$f":"Summary!B13","v":"MULTI-PROPERTY EXPENSES OVERVIEW"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Is property owned in LLC, Trust, or Estate?"]
[null,"ADVERTISING: LISTING FEES",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D13:O13)","v":0},null,null,"Is property owned with another person (non-spouse)?"]
[null,"ADVERTISING: MARKETING",null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"Is property rented to family?"]
[null,"AUTO & TRAVEL EXPENSES (associated with maintaining prop)",null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"Do you use the property personally?"]
[null,"COMMISSIONS",null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"         Square Footage of Total Property"]
[null,"FEES: BANK CHARGES",null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"         Square Footage of Rentable Space (if different from above)"]
[null,"FEES: EQUIPMENT / APPLIANCE RENTAL",null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"Long term or short term rental?"]
[null,"FEES: INSPECTION",null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"FEES: LEGAL/PROFESSIONAL",null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"DEPRECIATION CALCULATION (internal use only)"]
[null,"FEES: MANAGEMENT",null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"HOA DUES",null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"Calculated Yearly Depreciation (estimated)",{"$f":"IF(T8=\"Yes\",0,IF(T5=\"Commercial\",(T9-T11)/39,IF(T5=\"Land\",\"N/A\",(T9-T11)/27.5)))","v":0}]
[null,"INSURANCE: RENTER or HOME",null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"Calculated Yearly Depreciation (actual)"]
[null,"MAINTENANCE: CLEANING",null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"MAINTENANCE: INTERIOR & EXTERIOR",null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"QUESTIONNAIRE"]
[null,"MAINTENANCE: LANDSCAPING / GROUNDSKEEPING",null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"MORTGAGE INTEREST (Form 1098)",null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"Did/Will you sell this property during the year?"]
[null,"OTHER INTEREST",null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"*If yes, please upload the settlement statement."]
[null,"POSTAGE",null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"     Date of Sale"]
[null,"REPAIRS: INTERIOR & EXTERIOR",null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"     Sale Price"]
[null,"SUPPLIES",null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"Did you participate in a 1031 exchange?"]
[null,"TAXES: PROPERTY/LAND",null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"Has this property undergone a cost segregation study?"]
[null,"UTILITY: ELECTRIC",null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"*If no, are you interested in learning more about cost segregation?"]
[null,"UTILITY: GARBAGE / REFUSE",null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"Were any insurance claims filed due to property damage?"]
[null,"UTILITY: GAS",null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"*For example: fires, flood, natural disasters (explain below)"]
[null,"UTILITY: SECURITY SYSTEM",null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"UTILITY: WATER/SEWER",null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"ADDITIONAL NOTES (optional)"]
[null,"OTHER (type new category here)",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D38:O38)","v":0},null,null,"Please add any additional details you feel are important for us to know."]
[null,"OTHER (type new category here)",null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"OTHER (type new category here)",null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"OTHER (type new category here)",null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"TOTAL EXPENSES",null,{"$f":"SUM(D13:D41)","v":0},0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(D42:O42)","v":0}]
[]
[null,"YEAR TO-DATE-INCOME LESS EXPENSES",null,{"$f":"D9-D42","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[]
[]
[null,"IMPROVEMENTS                                                              DATE OF PURCHASE",null,"JAN","FEB","MAR","APR","MAY","JUN","JUL","AUG","SEPT","OCT","NOV","DEC","YR TOTAL"]
[null,"EQUIPMENT / APPLIANCE PURCHASES",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D48:O48)","v":0}]
[null,"REMODEL",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D49:O49)","v":0}]
[null,"FLOORING",null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"ROOF",null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"OTHER (type new category here)",null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"OTHER (type new category here)",null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"TOTAL IMPROVEMENTS",null,{"$f":"SUM(D48:D53)","v":0},{"$f":"SUM(E48:E53)","v":0},0,0,{"$f":"SUM(H48:H53)","v":0},0,0,0,0,0,0,0,{"$f":"SUM(P48:P53)","v":0}]

{"sheet":"Property 2","index":4,"n_rows":54,"n_cols":20,"rows_kept":54,"cut":false,"hidden":false,"merged":[[38,18,41,19],[36,18,36,19],[53,1,53,2],[7,1,7,2],[1,3,1,15],[2,18,2,19],[43,1,43,2],[41,1,41,2],[5,1,5,2],[4,1,4,2],[8,1,8,2],[11,1,11,2],[6,1,6,2],[46,1,46,2],[10,1,10,2],[19,18,19,19],[24,18,24,19],[37,18,37,19],[0,3,0,4],[3,1,3,2],[2,1,2,2],[1,1,1,2],[0,1,0,2]]}
[" ",{"$f":"Summary!B2","v":"CUSTOMER/ENTITY NAME"},null,{"$f":"Summary!D2","v":2024}]
[null,"PROPERTY 2 ADDRESS",null,"123 Main Street, City, State 10001"]
[null,"INCOME",null,"JAN","FEB","MAR","APR","MAY","JUN","JUL","AUG","SEPT","OCT","NOV","DEC","YR TOTAL",null,null,"PROPERTY FACT SHEET"]
[null,"MULTI-PROPERTY INCOME OVERVIEW"]
[null,{"$f":"Summary!B6","v":"RENTS RECEIVED"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D5:O5)","v":0},null,null,"Property Type"]
[null,{"$f":"Summary!B7","v":"SECURITY DEPOSIT (TO BE RETURNED)"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D6:O6)","v":0},null,null,"Purchase Date"]
[null,{"$f":"Summary!B8","v":"SECURITY DEPOSIT FORFEITED"},null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"Placed in Service Date"]
[null,{"$f":"Summary!B9","v":"OTHER RENTAL INCOME  – Late Fees, Move out charges, Etc."},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D8:O8)","v":0},null,null,"Property Cost details are available to Formations","Yes"]
[null,"GROSS RENTAL INCOME",null,{"$f":"SUM(D5:D8)","v":0},{"$f":"SUM(E5:E8)","v":0},0,0,0,0,0,0,0,0,0,{"$f":"SUM(O5:O8)","v":0},{"$f":"SUM(D9:O9)","v":0},null,null,"Purchase Price"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"# Fair Rental Days (out of 365)"]
[null,"EXPENSES",null,"JAN","FEB","MAR","APR","MAY","JUN","JUL","AUG","SEPT","OCT","NOV","DEC","YR TOTAL",null,null,"Land Value"]
[null,{"$f":"Summary!B13","v":"MULTI-PROPERTY EXPENSES OVERVIEW"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Is property owned in LLC, Trust, or Estate?"]
[null,{"$f":"'Property 1'!B13","v":"ADVERTISING: LISTING FEES"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D13:O13)","v":0},null,null,"Is property owned with another person (non-spouse)?"]
[null,{"$f":"'Property 1'!B14","v":"ADVERTISING: MARKETING"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D14:O14)","v":0},null,null,"Is property rented to family?"]
[null,{"$f":"'Property 1'!B15","v":"AUTO & TRAVEL EXPENSES (associated with maintaining prop)"},null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"Do you use the property personally?"]
[null,{"$f":"'Property 1'!B16","v":"COMMISSIONS"},null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"         Square Footage of Total Property"]
[null,{"$f":"'Property 1'!B17","v":"FEES: BANK CHARGES"},null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"         Square Footage of Rentable Space (if different from above)"]
[null,{"$f":"'Property 1'!B18","v":"FEES: EQUIPMENT / APPLIANCE RENTAL"},null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"Long term or short term rental?"]
[null,{"$f":"'Property 1'!B19","v":"FEES: INSPECTION"},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,{"$f":"'Property 1'!B20","v":"FEES: LEGAL/PROFESSIONAL"},null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"DEPRECIATION CALCULATION (internal use only)"]
[null,{"$f":"'Property 1'!B21","v":"FEES: MANAGEMENT"},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,{"$f":"'Property 1'!B22","v":"HOA DUES"},null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"Calculated Yearly Depreciation (estimated)",{"$f":"IF(T8=\"Yes\",0,IF(T5=\"Commercial\",(T9-T11)/39,IF(T5=\"Land\",\"N/A\",(T9-T11)/27.5)))","v":0}]
[null,{"$f":"'Property 1'!B23","v":"INSURANCE: RENTER or HOME"},null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"Calculated Yearly Depreciation (actual)"]
[null,{"$f":"'Property 1'!B24","v":"MAINTENANCE: CLEANING"},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,{"$f":"'Property 1'!B25","v":"MAINTENANCE: INTERIOR & EXTERIOR"},null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"QUESTIONNAIRE"]
[null,{"$f":"'Property 1'!B26","v":"MAINTENANCE: LANDSCAPING / GROUNDSKEEPING"},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,{"$f":"'Property 1'!B27","v":"MORTGAGE INTEREST (Form 1098)"},null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"Did/Will you sell this property during the year?"]
[null,{"$f":"'Property 1'!B28","v":"OTHER INTEREST"},null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"*If yes, please upload the settlement statement."]
[null,{"$f":"'Property 1'!B29","v":"POSTAGE"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D29:O29)","v":0},null,null,"     Date of Sale"]
[null,{"$f":"'Property 1'!B30","v":"REPAIRS: INTERIOR & EXTERIOR"},null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"     Sale Price"]
[null,{"$f":"'Property 1'!B31","v":"SUPPLIES"},null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"Did you participate in a 1031 exchange?"]
[null,{"$f":"'Property 1'!B32","v":"TAXES: PROPERTY/LAND"},null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"Has this property undergone a cost segregation study?"]
[null,{"$f":"'Property 1'!B33","v":"UTILITY: ELECTRIC"},null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"*If no, are you interested in learning more about cost segregation?"]
[null,{"$f":"'Property 1'!B34","v":"UTILITY: GARBAGE / REFUSE"},null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"Were any insurance claims filed due to property damage?"]
[null,{"$f":"'Property 1'!B35","v":"UTILITY: GAS"},null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"*For example: fires, flood, natural disasters (explain below)"]
[null,{"$f":"'Property 1'!B36","v":"UTILITY: SECURITY SYSTEM"},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,{"$f":"'Property 1'!B37","v":"UTILITY: WATER/SEWER"},null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"ADDITIONAL NOTES (optional)"]
[null,"OTHER (type new category here)",null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"Please add any additional details you feel are important for us to know."]
[null,"OTHER (type new category here)",null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"OTHER (type new category here)",null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"OTHER (type new category here)",null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"TOTAL EXPENSES",null,{"$f":"SUM(D13:D41)","v":0},{"$f":"SUM(E13:E41)","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(D42:O42)","v":0}]
[]
[null,"YEAR-TO-DATE INCOME LESS EXPENSES",null,{"$f":"D9-D42","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[]
[]
[null,"IMPROVEMENTS                                                              DATE OF PURCHASE",null,"JAN","FEB","MAR","APR","MAY","JUN","JUL","AUG","SEPT","OCT","NOV","DEC","YR TOTAL"]
[null,"EQUIPMENT / APPLIANCE PURCHASES",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D48:O48)","v":0}]
[null,"REMODEL",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D49:O49)","v":0}]
[null,"FLOORING",null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"ROOF",null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"OTHER (type new category here)",null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"OTHER (type new category here)",null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"TOTAL IMPROVEMENTS",null,{"$f":"SUM(D48:D53)","v":0},{"$f":"SUM(E48:E53)","v":0},0,0,{"$f":"SUM(H48:H53)","v":0},0,0,0,0,0,0,0,{"$f":"SUM(P48:P53)","v":0}]

{"sheet":"Property 3","index":5,"n_rows":54,"n_cols":20,"rows_kept":54,"cut":false,"hidden":false,"merged":[[38,18,41,19],[36,18,36,19],[53,1,53,2],[7,1,7,2],[1,3,1,15],[2,18,2,19],[43,1,43,2],[41,1,41,2],[5,1,5,2],[4,1,4,2],[8,1,8,2],[11,1,11,2],[6,1,6,2],[46,1,46,2],[10,1,10,2],[19,18,19,19],[24,18,24,19],[37,18,37,19],[0,3,0,4],[3,1,3,2],[2,1,2,2],[1,1,1,2],[0,1,0,2]]}
[" ",{"$f":"Summary!B2","v":"CUSTOMER/ENTITY NAME"},null,{"$f":"Summary!D2","v":2024}]
[null,"PROPERTY 3 ADDRESS",null,"123 Main Street, City, State 10001"]
[null,"INCOME",null,"JAN","FEB","MAR","APR","MAY","JUN","JUL","AUG","SEPT","OCT","NOV","DEC","YR TOTAL",null,null,"PROPERTY FACT SHEET"]
[null,"MULTI-PROPERTY INCOME OVERVIEW"]
[null,{"$f":"Summary!B6","v":"RENTS RECEIVED"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D5:O5)","v":0},null,null,"Property Type"]
[null,{"$f":"Summary!B7","v":"SECURITY DEPOSIT (TO BE RETURNED)"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D6:O6)","v":0},null,null,"Purchase Date"]
[null,{"$f":"Summary!B8","v":"SECURITY DEPOSIT FORFEITED"},null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"Placed in Service Date"]
[null,{"$f":"Summary!B9","v":"OTHER RENTAL INCOME  – Late Fees, Move out charges, Etc."},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D8:O8)","v":0},null,null,"Property Cost details are available to Formations","Yes"]
[null,"GROSS RENTAL INCOME",null,{"$f":"SUM(D5:D8)","v":0},{"$f":"SUM(E5:E8)","v":0},0,0,0,0,0,0,0,0,0,{"$f":"SUM(O5:O8)","v":0},{"$f":"SUM(D9:O9)","v":0},null,null,"Purchase Price"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"# Fair Rental Days (out of 365)"]
[null,"EXPENSES",null,"JAN","FEB","MAR","APR","MAY","JUN","JUL","AUG","SEPT","OCT","NOV","DEC","YR TOTAL",null,null,"Land Value"]
[null,{"$f":"Summary!B13","v":"MULTI-PROPERTY EXPENSES OVERVIEW"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Is property owned in LLC, Trust, or Estate?"]
[null,{"$f":"'Property 1'!B13","v":"ADVERTISING: LISTING FEES"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D13:O13)","v":0},null,null,"Is property owned with another person (non-spouse)?"]
[null,{"$f":"'Property 1'!B14","v":"ADVERTISING: MARKETING"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D14:O14)","v":0},null,null,"Is property rented to family?"]
[null,{"$f":"'Property 1'!B15","v":"AUTO & TRAVEL EXPENSES (associated with maintaining prop)"},null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"Do you use the property personally?"]
[null,{"$f":"'Property 1'!B16","v":"COMMISSIONS"},null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"         Square Footage of Total Property"]
[null,{"$f":"'Property 1'!B17","v":"FEES: BANK CHARGES"},null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"         Square Footage of Rentable Space (if different from above)"]
[null,{"$f":"'Property 1'!B18","v":"FEES: EQUIPMENT / APPLIANCE RENTAL"},null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"Long term or short term rental?"]
[null,{"$f":"'Property 1'!B19","v":"FEES: INSPECTION"},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,{"$f":"'Property 1'!B20","v":"FEES: LEGAL/PROFESSIONAL"},null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"DEPRECIATION CALCULATION (internal use only)"]
[null,{"$f":"'Property 1'!B21","v":"FEES: MANAGEMENT"},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,{"$f":"'Property 1'!B22","v":"HOA DUES"},null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"Calculated Yearly Depreciation (estimated)",{"$f":"IF(T8=\"Yes\",0,IF(T5=\"Commercial\",(T9-T11)/39,IF(T5=\"Land\",\"N/A\",(T9-T11)/27.5)))","v":0}]
[null,{"$f":"'Property 1'!B23","v":"INSURANCE: RENTER or HOME"},null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"Calculated Yearly Depreciation (actual)"]
[null,{"$f":"'Property 1'!B24","v":"MAINTENANCE: CLEANING"},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,{"$f":"'Property 1'!B25","v":"MAINTENANCE: INTERIOR & EXTERIOR"},null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"QUESTIONNAIRE"]
[null,{"$f":"'Property 1'!B26","v":"MAINTENANCE: LANDSCAPING / GROUNDSKEEPING"},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,{"$f":"'Property 1'!B27","v":"MORTGAGE INTEREST (Form 1098)"},null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"Did/Will you sell this property during the year?"]
[null,{"$f":"'Property 1'!B28","v":"OTHER INTEREST"},null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"*If yes, please upload the settlement statement."]
[null,{"$f":"'Property 1'!B29","v":"POSTAGE"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D29:O29)","v":0},null,null,"     Date of Sale"]
[null,{"$f":"'Property 1'!B30","v":"REPAIRS: INTERIOR & EXTERIOR"},null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"     Sale Price"]
[null,{"$f":"'Property 1'!B31","v":"SUPPLIES"},null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"Did you participate in a 1031 exchange?"]
[null,{"$f":"'Property 1'!B32","v":"TAXES: PROPERTY/LAND"},null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"Has this property undergone a cost segregation study?"]
[null,{"$f":"'Property 1'!B33","v":"UTILITY: ELECTRIC"},null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"*If no, are you interested in learning more about cost segregation?"]
[null,{"$f":"'Property 1'!B34","v":"UTILITY: GARBAGE / REFUSE"},null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"Were any insurance claims filed due to property damage?"]
[null,{"$f":"'Property 1'!B35","v":"UTILITY: GAS"},null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"*For example: fires, flood, natural disasters (explain below)"]
[null,{"$f":"'Property 1'!B36","v":"UTILITY: SECURITY SYSTEM"},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,{"$f":"'Property 1'!B37","v":"UTILITY: WATER/SEWER"},null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"ADDITIONAL NOTES (optional)"]
[null,"OTHER (type new category here)",null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"Please add any additional details you feel are important for us to know."]
[null,"OTHER (type new category here)",null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"OTHER (type new category here)",null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"OTHER (type new category here)",null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"TOTAL EXPENSES",null,{"$f":"SUM(D13:D41)","v":0},0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(D42:O42)","v":0}]
[]
[null,"YEAR-TO-DATE INCOME LESS EXPENSES",null,{"$f":"D9-D42","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[]
[]
[null,"IMPROVEMENTS                                                              DATE OF PURCHASE",null,"JAN","FEB","MAR","APR","MAY","JUN","JUL","AUG","SEPT","OCT","NOV","DEC","YR TOTAL"]
[null,"EQUIPMENT / APPLIANCE PURCHASES",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D48:O48)","v":0}]
[null,"REMODEL",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D49:O49)","v":0}]
[null,"FLOORING",null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"ROOF",null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"OTHER (type new category here)",null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"OTHER (type new category here)",null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"TOTAL IMPROVEMENTS",null,{"$f":"SUM(D48:D53)","v":0},{"$f":"SUM(E48:E53)","v":0},0,0,{"$f":"SUM(H48:H53)","v":0},0,0,0,0,0,0,0,{"$f":"SUM(P48:P53)","v":0}]

{"sheet":"Property 4","index":6,"n_rows":54,"n_cols":20,"rows_kept":54,"cut":false,"hidden":false,"merged":[[38,18,41,19],[36,18,36,19],[53,1,53,2],[7,1,7,2],[1,3,1,15],[2,18,2,19],[43,1,43,2],[41,1,41,2],[5,1,5,2],[4,1,4,2],[8,1,8,2],[11,1,11,2],[6,1,6,2],[46,1,46,2],[10,1,10,2],[19,18,19,19],[24,18,24,19],[37,18,37,19],[0,3,0,4],[3,1,3,2],[2,1,2,2],[1,1,1,2],[0,1,0,2]]}
[" ",{"$f":"Summary!B2","v":"CUSTOMER/ENTITY NAME"},null,{"$f":"Summary!D2","v":2024}]
[null,"PROPERTY 4 ADDRESS",null,"123 Main Street, City, State 10001"]
[null,"INCOME",null,"JAN","FEB","MAR","APR","MAY","JUN","JUL","AUG","SEPT","OCT","NOV","DEC","YR TOTAL",null,null,"PROPERTY FACT SHEET"]
[null,"MULTI-PROPERTY INCOME OVERVIEW"]
[null,{"$f":"Summary!B6","v":"RENTS RECEIVED"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D5:O5)","v":0},null,null,"Property Type"]
[null,{"$f":"Summary!B7","v":"SECURITY DEPOSIT (TO BE RETURNED)"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D6:O6)","v":0},null,null,"Purchase Date"]
[null,{"$f":"Summary!B8","v":"SECURITY DEPOSIT FORFEITED"},null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"Placed in Service Date"]
[null,{"$f":"Summary!B9","v":"OTHER RENTAL INCOME  – Late Fees, Move out charges, Etc."},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D8:O8)","v":0},null,null,"Property Cost details are available to Formations","Yes"]
[null,"GROSS RENTAL INCOME",null,{"$f":"SUM(D5:D8)","v":0},{"$f":"SUM(E5:E8)","v":0},0,0,0,0,0,0,0,0,0,{"$f":"SUM(O5:O8)","v":0},{"$f":"SUM(D9:O9)","v":0},null,null,"Purchase Price"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"# Fair Rental Days (out of 365)"]
[null,"EXPENSES",null,"JAN","FEB","MAR","APR","MAY","JUN","JUL","AUG","SEPT","OCT","NOV","DEC","YR TOTAL",null,null,"Land Value"]
[null,{"$f":"Summary!B13","v":"MULTI-PROPERTY EXPENSES OVERVIEW"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Is property owned in LLC, Trust, or Estate?"]
[null,{"$f":"'Property 1'!B13","v":"ADVERTISING: LISTING FEES"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D13:O13)","v":0},null,null,"Is property owned with another person (non-spouse)?"]
[null,{"$f":"'Property 1'!B14","v":"ADVERTISING: MARKETING"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D14:O14)","v":0},null,null,"Is property rented to family?"]
[null,{"$f":"'Property 1'!B15","v":"AUTO & TRAVEL EXPENSES (associated with maintaining prop)"},null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"Do you use the property personally?"]
[null,{"$f":"'Property 1'!B16","v":"COMMISSIONS"},null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"         Square Footage of Total Property"]
[null,{"$f":"'Property 1'!B17","v":"FEES: BANK CHARGES"},null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"         Square Footage of Rentable Space (if different from above)"]
[null,{"$f":"'Property 1'!B18","v":"FEES: EQUIPMENT / APPLIANCE RENTAL"},null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"Long term or short term rental?"]
[null,{"$f":"'Property 1'!B19","v":"FEES: INSPECTION"},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,{"$f":"'Property 1'!B20","v":"FEES: LEGAL/PROFESSIONAL"},null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"DEPRECIATION CALCULATION (internal use only)"]
[null,{"$f":"'Property 1'!B21","v":"FEES: MANAGEMENT"},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,{"$f":"'Property 1'!B22","v":"HOA DUES"},null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"Calculated Yearly Depreciation (estimated)",{"$f":"IF(T8=\"Yes\",0,IF(T5=\"Commercial\",(T9-T11)/39,IF(T5=\"Land\",\"N/A\",(T9-T11)/27.5)))","v":0}]
[null,{"$f":"'Property 1'!B23","v":"INSURANCE: RENTER or HOME"},null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"Calculated Yearly Depreciation (actual)"]
[null,{"$f":"'Property 1'!B24","v":"MAINTENANCE: CLEANING"},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,{"$f":"'Property 1'!B25","v":"MAINTENANCE: INTERIOR & EXTERIOR"},null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"QUESTIONNAIRE"]
[null,{"$f":"'Property 1'!B26","v":"MAINTENANCE: LANDSCAPING / GROUNDSKEEPING"},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,{"$f":"'Property 1'!B27","v":"MORTGAGE INTEREST (Form 1098)"},null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"Did/Will you sell this property during the year?"]
[null,{"$f":"'Property 1'!B28","v":"OTHER INTEREST"},null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"*If yes, please upload the settlement statement."]
[null,{"$f":"'Property 1'!B29","v":"POSTAGE"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D29:O29)","v":0},null,null,"     Date of Sale"]
[null,{"$f":"'Property 1'!B30","v":"REPAIRS: INTERIOR & EXTERIOR"},null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"     Sale Price"]
[null,{"$f":"'Property 1'!B31","v":"SUPPLIES"},null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"Did you participate in a 1031 exchange?"]
[null,{"$f":"'Property 1'!B32","v":"TAXES: PROPERTY/LAND"},null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"Has this property undergone a cost segregation study?"]
[null,{"$f":"'Property 1'!B33","v":"UTILITY: ELECTRIC"},null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"*If no, are you interested in learning more about cost segregation?"]
[null,{"$f":"'Property 1'!B34","v":"UTILITY: GARBAGE / REFUSE"},null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"Were any insurance claims filed due to property damage?"]
[null,{"$f":"'Property 1'!B35","v":"UTILITY: GAS"},null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"*For example: fires, flood, natural disasters (explain below)"]
[null,{"$f":"'Property 1'!B36","v":"UTILITY: SECURITY SYSTEM"},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,{"$f":"'Property 1'!B37","v":"UTILITY: WATER/SEWER"},null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"ADDITIONAL NOTES (optional)"]
[null,"OTHER (type new category here)",null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"Please add any additional details you feel are important for us to know."]
[null,"OTHER (type new category here)",null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"OTHER (type new category here)",null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"OTHER (type new category here)",null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"TOTAL EXPENSES",null,{"$f":"SUM(D13:D41)","v":0},0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(D42:O42)","v":0}]
[]
[null,"YEAR-TO-DATE INCOME LESS EXPENSES",null,{"$f":"D9-D42","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[]
[]
[null,"IMPROVEMENTS                                                              DATE OF PURCHASE",null,"JAN","FEB","MAR","APR","MAY","JUN","JUL","AUG","SEPT","OCT","NOV","DEC","YR TOTAL"]
[null,"EQUIPMENT / APPLIANCE PURCHASES",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D48:O48)","v":0}]
[null,"REMODEL",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D49:O49)","v":0}]
[null,"FLOORING",null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"ROOF",null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"OTHER (type new category here)",null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"OTHER (type new category here)",null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"TOTAL IMPROVEMENTS",null,{"$f":"SUM(D48:D53)","v":0},{"$f":"SUM(E48:E53)","v":0},0,0,{"$f":"SUM(H48:H53)","v":0},0,0,0,0,0,0,0,{"$f":"SUM(P48:P53)","v":0}]

{"sheet":"Property 5","index":7,"n_rows":54,"n_cols":20,"rows_kept":54,"cut":false,"hidden":false,"merged":[[38,18,41,19],[36,18,36,19],[53,1,53,2],[7,1,7,2],[1,3,1,15],[2,18,2,19],[43,1,43,2],[41,1,41,2],[5,1,5,2],[4,1,4,2],[8,1,8,2],[11,1,11,2],[6,1,6,2],[46,1,46,2],[10,1,10,2],[19,18,19,19],[24,18,24,19],[37,18,37,19],[0,3,0,4],[3,1,3,2],[2,1,2,2],[1,1,1,2],[0,1,0,2]]}
[" ",{"$f":"Summary!B2","v":"CUSTOMER/ENTITY NAME"},null,{"$f":"Summary!D2","v":2024}]
[null,"PROPERTY 5 ADDRESS",null,"123 Main Street, City, State 10001"]
[null,"INCOME",null,"JAN","FEB","MAR","APR","MAY","JUN","JUL","AUG","SEPT","OCT","NOV","DEC","YR TOTAL",null,null,"PROPERTY FACT SHEET"]
[null,"MULTI-PROPERTY INCOME OVERVIEW"]
[null,{"$f":"Summary!B6","v":"RENTS RECEIVED"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D5:O5)","v":0},null,null,"Property Type"]
[null,{"$f":"Summary!B7","v":"SECURITY DEPOSIT (TO BE RETURNED)"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D6:O6)","v":0},null,null,"Purchase Date"]
[null,{"$f":"Summary!B8","v":"SECURITY DEPOSIT FORFEITED"},null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"Placed in Service Date"]
[null,{"$f":"Summary!B9","v":"OTHER RENTAL INCOME  – Late Fees, Move out charges, Etc."},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D8:O8)","v":0},null,null,"Property Cost details are available to Formations","Yes"]
[null,"GROSS RENTAL INCOME",null,{"$f":"SUM(D5:D8)","v":0},{"$f":"SUM(E5:E8)","v":0},0,0,0,0,0,0,0,0,0,{"$f":"SUM(O5:O8)","v":0},{"$f":"SUM(D9:O9)","v":0},null,null,"Purchase Price"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"# Fair Rental Days (out of 365)"]
[null,"EXPENSES",null,"JAN","FEB","MAR","APR","MAY","JUN","JUL","AUG","SEPT","OCT","NOV","DEC","YR TOTAL",null,null,"Land Value"]
[null,{"$f":"Summary!B13","v":"MULTI-PROPERTY EXPENSES OVERVIEW"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Is property owned in LLC, Trust, or Estate?"]
[null,{"$f":"'Property 1'!B13","v":"ADVERTISING: LISTING FEES"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D13:O13)","v":0},null,null,"Is property owned with another person (non-spouse)?"]
[null,{"$f":"'Property 1'!B14","v":"ADVERTISING: MARKETING"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D14:O14)","v":0},null,null,"Is property rented to family?"]
[null,{"$f":"'Property 1'!B15","v":"AUTO & TRAVEL EXPENSES (associated with maintaining prop)"},null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"Do you use the property personally?"]
[null,{"$f":"'Property 1'!B16","v":"COMMISSIONS"},null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"         Square Footage of Total Property"]
[null,{"$f":"'Property 1'!B17","v":"FEES: BANK CHARGES"},null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"         Square Footage of Rentable Space (if different from above)"]
[null,{"$f":"'Property 1'!B18","v":"FEES: EQUIPMENT / APPLIANCE RENTAL"},null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"Long term or short term rental?"]
[null,{"$f":"'Property 1'!B19","v":"FEES: INSPECTION"},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,{"$f":"'Property 1'!B20","v":"FEES: LEGAL/PROFESSIONAL"},null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"DEPRECIATION CALCULATION (internal use only)"]
[null,{"$f":"'Property 1'!B21","v":"FEES: MANAGEMENT"},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,{"$f":"'Property 1'!B22","v":"HOA DUES"},null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"Calculated Yearly Depreciation (estimated)",{"$f":"IF(T8=\"Yes\",0,IF(T5=\"Commercial\",(T9-T11)/39,IF(T5=\"Land\",\"N/A\",(T9-T11)/27.5)))","v":0}]
[null,{"$f":"'Property 1'!B23","v":"INSURANCE: RENTER or HOME"},null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"Calculated Yearly Depreciation (actual)"]
[null,{"$f":"'Property 1'!B24","v":"MAINTENANCE: CLEANING"},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,{"$f":"'Property 1'!B25","v":"MAINTENANCE: INTERIOR & EXTERIOR"},null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"QUESTIONNAIRE"]
[null,{"$f":"'Property 1'!B26","v":"MAINTENANCE: LANDSCAPING / GROUNDSKEEPING"},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,{"$f":"'Property 1'!B27","v":"MORTGAGE INTEREST (Form 1098)"},null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"Did/Will you sell this property during the year?"]
[null,{"$f":"'Property 1'!B28","v":"OTHER INTEREST"},null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"*If yes, please upload the settlement statement."]
[null,{"$f":"'Property 1'!B29","v":"POSTAGE"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D29:O29)","v":0},null,null,"     Date of Sale"]
[null,{"$f":"'Property 1'!B30","v":"REPAIRS: INTERIOR & EXTERIOR"},null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"     Sale Price"]
[null,{"$f":"'Property 1'!B31","v":"SUPPLIES"},null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"Did you participate in a 1031 exchange?"]
[null,{"$f":"'Property 1'!B32","v":"TAXES: PROPERTY/LAND"},null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"Has this property undergone a cost segregation study?"]
[null,{"$f":"'Property 1'!B33","v":"UTILITY: ELECTRIC"},null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"*If no, are you interested in learning more about cost segregation?"]
[null,{"$f":"'Property 1'!B34","v":"UTILITY: GARBAGE / REFUSE"},null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"Were any insurance claims filed due to property damage?"]
[null,{"$f":"'Property 1'!B35","v":"UTILITY: GAS"},null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"*For example: fires, flood, natural disasters (explain below)"]
[null,{"$f":"'Property 1'!B36","v":"UTILITY: SECURITY SYSTEM"},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,{"$f":"'Property 1'!B37","v":"UTILITY: WATER/SEWER"},null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"ADDITIONAL NOTES (optional)"]
[null,"OTHER (type new category here)",null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"Please add any additional details you feel are important for us to know."]
[null,"OTHER (type new category here)",null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"OTHER (type new category here)",null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"OTHER (type new category here)",null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"TOTAL EXPENSES",null,{"$f":"SUM(D13:D41)","v":0},0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(D42:O42)","v":0}]
[]
[null,"YEAR-TO-DATE INCOME LESS EXPENSES",null,{"$f":"D9-D42","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[]
[]
[null,"IMPROVEMENTS                                                              DATE OF PURCHASE",null,"JAN","FEB","MAR","APR","MAY","JUN","JUL","AUG","SEPT","OCT","NOV","DEC","YR TOTAL"]
[null,"EQUIPMENT / APPLIANCE PURCHASES",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D48:O48)","v":0}]
[null,"REMODEL",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D49:O49)","v":0}]
[null,"FLOORING",null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"ROOF",null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"OTHER (type new category here)",null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"OTHER (type new category here)",null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"TOTAL IMPROVEMENTS",null,{"$f":"SUM(D48:D53)","v":0},{"$f":"SUM(E48:E53)","v":0},0,0,{"$f":"SUM(H48:H53)","v":0},0,0,0,0,0,0,0,{"$f":"SUM(P48:P53)","v":0}]

{"sheet":"Property 6","index":8,"n_rows":54,"n_cols":20,"rows_kept":54,"cut":false,"hidden":false,"merged":[[38,18,41,19],[36,18,36,19],[53,1,53,2],[7,1,7,2],[1,3,1,15],[2,18,2,19],[43,1,43,2],[41,1,41,2],[5,1,5,2],[4,1,4,2],[8,1,8,2],[11,1,11,2],[6,1,6,2],[46,1,46,2],[10,1,10,2],[19,18,19,19],[24,18,24,19],[37,18,37,19],[0,3,0,4],[3,1,3,2],[2,1,2,2],[1,1,1,2],[0,1,0,2]]}
[" ",{"$f":"Summary!B2","v":"CUSTOMER/ENTITY NAME"},null,{"$f":"Summary!D2","v":2024}]
[null,"PROPERTY 6 ADDRESS",null,"123 Main Street, City, State 10001"]
[null,"INCOME",null,"JAN","FEB","MAR","APR","MAY","JUN","JUL","AUG","SEPT","OCT","NOV","DEC","YR TOTAL",null,null,"PROPERTY FACT SHEET"]
[null,"MULTI-PROPERTY INCOME OVERVIEW"]
[null,{"$f":"Summary!B6","v":"RENTS RECEIVED"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D5:O5)","v":0},null,null,"Property Type"]
[null,{"$f":"Summary!B7","v":"SECURITY DEPOSIT (TO BE RETURNED)"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D6:O6)","v":0},null,null,"Purchase Date"]
[null,{"$f":"Summary!B8","v":"SECURITY DEPOSIT FORFEITED"},null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"Placed in Service Date"]
[null,{"$f":"Summary!B9","v":"OTHER RENTAL INCOME  – Late Fees, Move out charges, Etc."},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D8:O8)","v":0},null,null,"Property Cost details are available to Formations","Yes"]
[null,"GROSS RENTAL INCOME",null,{"$f":"SUM(D5:D8)","v":0},{"$f":"SUM(E5:E8)","v":0},0,0,0,0,0,0,0,0,0,{"$f":"SUM(O5:O8)","v":0},{"$f":"SUM(D9:O9)","v":0},null,null,"Purchase Price"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"# Fair Rental Days (out of 365)"]
[null,"EXPENSES",null,"JAN","FEB","MAR","APR","MAY","JUN","JUL","AUG","SEPT","OCT","NOV","DEC","YR TOTAL",null,null,"Land Value"]
[null,{"$f":"Summary!B13","v":"MULTI-PROPERTY EXPENSES OVERVIEW"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Is property owned in LLC, Trust, or Estate?"]
[null,{"$f":"'Property 1'!B13","v":"ADVERTISING: LISTING FEES"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D13:O13)","v":0},null,null,"Is property owned with another person (non-spouse)?"]
[null,{"$f":"'Property 1'!B14","v":"ADVERTISING: MARKETING"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D14:O14)","v":0},null,null,"Is property rented to family?"]
[null,{"$f":"'Property 1'!B15","v":"AUTO & TRAVEL EXPENSES (associated with maintaining prop)"},null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"Do you use the property personally?"]
[null,{"$f":"'Property 1'!B16","v":"COMMISSIONS"},null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"         Square Footage of Total Property"]
[null,{"$f":"'Property 1'!B17","v":"FEES: BANK CHARGES"},null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"         Square Footage of Rentable Space (if different from above)"]
[null,{"$f":"'Property 1'!B18","v":"FEES: EQUIPMENT / APPLIANCE RENTAL"},null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"Long term or short term rental?"]
[null,{"$f":"'Property 1'!B19","v":"FEES: INSPECTION"},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,{"$f":"'Property 1'!B20","v":"FEES: LEGAL/PROFESSIONAL"},null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"DEPRECIATION CALCULATION (internal use only)"]
[null,{"$f":"'Property 1'!B21","v":"FEES: MANAGEMENT"},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,{"$f":"'Property 1'!B22","v":"HOA DUES"},null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"Calculated Yearly Depreciation (estimated)",{"$f":"IF(T8=\"Yes\",0,IF(T5=\"Commercial\",(T9-T11)/39,IF(T5=\"Land\",\"N/A\",(T9-T11)/27.5)))","v":0}]
[null,{"$f":"'Property 1'!B23","v":"INSURANCE: RENTER or HOME"},null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"Calculated Yearly Depreciation (actual)"]
[null,{"$f":"'Property 1'!B24","v":"MAINTENANCE: CLEANING"},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,{"$f":"'Property 1'!B25","v":"MAINTENANCE: INTERIOR & EXTERIOR"},null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"QUESTIONNAIRE"]
[null,{"$f":"'Property 1'!B26","v":"MAINTENANCE: LANDSCAPING / GROUNDSKEEPING"},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,{"$f":"'Property 1'!B27","v":"MORTGAGE INTEREST (Form 1098)"},null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"Did/Will you sell this property during the year?"]
[null,{"$f":"'Property 1'!B28","v":"OTHER INTEREST"},null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"*If yes, please upload the settlement statement."]
[null,{"$f":"'Property 1'!B29","v":"POSTAGE"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D29:O29)","v":0},null,null,"     Date of Sale"]
[null,{"$f":"'Property 1'!B30","v":"REPAIRS: INTERIOR & EXTERIOR"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D30:O30)","v":0},null,null,"     Sale Price"]
[null,{"$f":"'Property 1'!B31","v":"SUPPLIES"},null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"Did you participate in a 1031 exchange?"]
[null,{"$f":"'Property 1'!B32","v":"TAXES: PROPERTY/LAND"},null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"Has this property undergone a cost segregation study?"]
[null,{"$f":"'Property 1'!B33","v":"UTILITY: ELECTRIC"},null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"*If no, are you interested in learning more about cost segregation?"]
[null,{"$f":"'Property 1'!B34","v":"UTILITY: GARBAGE / REFUSE"},null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"Were any insurance claims filed due to property damage?"]
[null,{"$f":"'Property 1'!B35","v":"UTILITY: GAS"},null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"*For example: fires, flood, natural disasters (explain below)"]
[null,{"$f":"'Property 1'!B36","v":"UTILITY: SECURITY SYSTEM"},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,{"$f":"'Property 1'!B37","v":"UTILITY: WATER/SEWER"},null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"ADDITIONAL NOTES (optional)"]
[null,"OTHER (type new category here)",null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"Please add any additional details you feel are important for us to know."]
[null,"OTHER (type new category here)",null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"OTHER (type new category here)",null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"OTHER (type new category here)",null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"TOTAL EXPENSES",null,{"$f":"SUM(D13:D41)","v":0},0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(D42:O42)","v":0}]
[]
[null,"YEAR-TO-DATE INCOME LESS EXPENSES",null,{"$f":"D9-D42","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[]
[]
[null,"IMPROVEMENTS                                                              DATE OF PURCHASE",null,"JAN","FEB","MAR","APR","MAY","JUN","JUL","AUG","SEPT","OCT","NOV","DEC","YR TOTAL"]
[null,"EQUIPMENT / APPLIANCE PURCHASES",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D48:O48)","v":0}]
[null,"REMODEL",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D49:O49)","v":0}]
[null,"FLOORING",null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"ROOF",null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"OTHER (type new category here)",null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"OTHER (type new category here)",null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"TOTAL IMPROVEMENTS",null,{"$f":"SUM(D48:D53)","v":0},{"$f":"SUM(E48:E53)","v":0},0,0,{"$f":"SUM(H48:H53)","v":0},0,0,0,0,0,0,0,{"$f":"SUM(P48:P53)","v":0}]

{"sheet":"Property 7","index":9,"n_rows":54,"n_cols":20,"rows_kept":54,"cut":false,"hidden":false,"merged":[[38,18,41,19],[36,18,36,19],[53,1,53,2],[7,1,7,2],[1,3,1,15],[2,18,2,19],[43,1,43,2],[41,1,41,2],[5,1,5,2],[4,1,4,2],[8,1,8,2],[11,1,11,2],[6,1,6,2],[46,1,46,2],[10,1,10,2],[19,18,19,19],[24,18,24,19],[37,18,37,19],[0,3,0,4],[3,1,3,2],[2,1,2,2],[1,1,1,2],[0,1,0,2]]}
[" ",{"$f":"Summary!B2","v":"CUSTOMER/ENTITY NAME"},null,{"$f":"Summary!D2","v":2024}]
[null,"PROPERTY 7 ADDRESS",null,"123 Main Street, City, State 10001"]
[null,"INCOME",null,"JAN","FEB","MAR","APR","MAY","JUN","JUL","AUG","SEPT","OCT","NOV","DEC","YR TOTAL",null,null,"PROPERTY FACT SHEET"]
[null,"MULTI-PROPERTY INCOME OVERVIEW"]
[null,{"$f":"Summary!B6","v":"RENTS RECEIVED"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D5:O5)","v":0},null,null,"Property Type"]
[null,{"$f":"Summary!B7","v":"SECURITY DEPOSIT (TO BE RETURNED)"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D6:O6)","v":0},null,null,"Purchase Date"]
[null,{"$f":"Summary!B8","v":"SECURITY DEPOSIT FORFEITED"},null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"Placed in Service Date"]
[null,{"$f":"Summary!B9","v":"OTHER RENTAL INCOME  – Late Fees, Move out charges, Etc."},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D8:O8)","v":0},null,null,"Property Cost details are available to Formations","Yes"]
[null,"GROSS RENTAL INCOME",null,{"$f":"SUM(D5:D8)","v":0},{"$f":"SUM(E5:E8)","v":0},0,0,0,0,0,0,0,0,0,{"$f":"SUM(O5:O8)","v":0},{"$f":"SUM(D9:O9)","v":0},null,null,"Purchase Price"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"# Fair Rental Days (out of 365)"]
[null,"EXPENSES",null,"JAN","FEB","MAR","APR","MAY","JUN","JUL","AUG","SEPT","OCT","NOV","DEC","YR TOTAL",null,null,"Land Value"]
[null,{"$f":"Summary!B13","v":"MULTI-PROPERTY EXPENSES OVERVIEW"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Is property owned in LLC, Trust, or Estate?"]
[null,{"$f":"'Property 1'!B13","v":"ADVERTISING: LISTING FEES"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D13:O13)","v":0},null,null,"Is property owned with another person (non-spouse)?"]
[null,{"$f":"'Property 1'!B14","v":"ADVERTISING: MARKETING"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D14:O14)","v":0},null,null,"Is property rented to family?"]
[null,{"$f":"'Property 1'!B15","v":"AUTO & TRAVEL EXPENSES (associated with maintaining prop)"},null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"Do you use the property personally?"]
[null,{"$f":"'Property 1'!B16","v":"COMMISSIONS"},null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"         Square Footage of Total Property"]
[null,{"$f":"'Property 1'!B17","v":"FEES: BANK CHARGES"},null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"         Square Footage of Rentable Space (if different from above)"]
[null,{"$f":"'Property 1'!B18","v":"FEES: EQUIPMENT / APPLIANCE RENTAL"},null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"Long term or short term rental?"]
[null,{"$f":"'Property 1'!B19","v":"FEES: INSPECTION"},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,{"$f":"'Property 1'!B20","v":"FEES: LEGAL/PROFESSIONAL"},null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"DEPRECIATION CALCULATION (internal use only)"]
[null,{"$f":"'Property 1'!B21","v":"FEES: MANAGEMENT"},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,{"$f":"'Property 1'!B22","v":"HOA DUES"},null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"Calculated Yearly Depreciation (estimated)",{"$f":"IF(T8=\"Yes\",0,IF(T5=\"Commercial\",(T9-T11)/39,IF(T5=\"Land\",\"N/A\",(T9-T11)/27.5)))","v":0}]
[null,{"$f":"'Property 1'!B23","v":"INSURANCE: RENTER or HOME"},null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"Calculated Yearly Depreciation (actual)"]
[null,{"$f":"'Property 1'!B24","v":"MAINTENANCE: CLEANING"},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,{"$f":"'Property 1'!B25","v":"MAINTENANCE: INTERIOR & EXTERIOR"},null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"QUESTIONNAIRE"]
[null,{"$f":"'Property 1'!B26","v":"MAINTENANCE: LANDSCAPING / GROUNDSKEEPING"},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,{"$f":"'Property 1'!B27","v":"MORTGAGE INTEREST (Form 1098)"},null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"Did/Will you sell this property during the year?"]
[null,{"$f":"'Property 1'!B28","v":"OTHER INTEREST"},null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"*If yes, please upload the settlement statement."]
[null,{"$f":"'Property 1'!B29","v":"POSTAGE"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D29:O29)","v":0},null,null,"     Date of Sale"]
[null,{"$f":"'Property 1'!B30","v":"REPAIRS: INTERIOR & EXTERIOR"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D30:O30)","v":0},null,null,"     Sale Price"]
[null,{"$f":"'Property 1'!B31","v":"SUPPLIES"},null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"Did you participate in a 1031 exchange?"]
[null,{"$f":"'Property 1'!B32","v":"TAXES: PROPERTY/LAND"},null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"Has this property undergone a cost segregation study?"]
[null,{"$f":"'Property 1'!B33","v":"UTILITY: ELECTRIC"},null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"*If no, are you interested in learning more about cost segregation?"]
[null,{"$f":"'Property 1'!B34","v":"UTILITY: GARBAGE / REFUSE"},null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"Were any insurance claims filed due to property damage?"]
[null,{"$f":"'Property 1'!B35","v":"UTILITY: GAS"},null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"*For example: fires, flood, natural disasters (explain below)"]
[null,{"$f":"'Property 1'!B36","v":"UTILITY: SECURITY SYSTEM"},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,{"$f":"'Property 1'!B37","v":"UTILITY: WATER/SEWER"},null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"ADDITIONAL NOTES (optional)"]
[null,"OTHER (type new category here)",null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"Please add any additional details you feel are important for us to know."]
[null,"OTHER (type new category here)",null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"OTHER (type new category here)",null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"OTHER (type new category here)",null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"TOTAL EXPENSES",null,{"$f":"SUM(D13:D41)","v":0},0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(D42:O42)","v":0}]
[]
[null,"YEAR-TO-DATE INCOME LESS EXPENSES",null,{"$f":"D9-D42","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[]
[]
[null,"IMPROVEMENTS                                                              DATE OF PURCHASE",null,"JAN","FEB","MAR","APR","MAY","JUN","JUL","AUG","SEPT","OCT","NOV","DEC","YR TOTAL"]
[null,"EQUIPMENT / APPLIANCE PURCHASES",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D48:O48)","v":0}]
[null,"REMODEL",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D49:O49)","v":0}]
[null,"FLOORING",null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"ROOF",null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"OTHER (type new category here)",null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"OTHER (type new category here)",null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"TOTAL IMPROVEMENTS",null,{"$f":"SUM(D48:D53)","v":0},{"$f":"SUM(E48:E53)","v":0},0,0,{"$f":"SUM(H48:H53)","v":0},0,0,0,0,0,0,0,{"$f":"SUM(P48:P53)","v":0}]

{"sheet":"Property 8","index":10,"n_rows":54,"n_cols":20,"rows_kept":54,"cut":false,"hidden":false,"merged":[[38,18,41,19],[36,18,36,19],[53,1,53,2],[7,1,7,2],[1,3,1,15],[2,18,2,19],[43,1,43,2],[41,1,41,2],[5,1,5,2],[4,1,4,2],[8,1,8,2],[11,1,11,2],[6,1,6,2],[46,1,46,2],[10,1,10,2],[19,18,19,19],[24,18,24,19],[37,18,37,19],[0,3,0,4],[3,1,3,2],[2,1,2,2],[1,1,1,2],[0,1,0,2]]}
[" ",{"$f":"Summary!B2","v":"CUSTOMER/ENTITY NAME"},null,{"$f":"Summary!D2","v":2024}]
[null,"PROPERTY 8 ADDRESS",null,"123 Main Street, City, State 10001"]
[null,"INCOME",null,"JAN","FEB","MAR","APR","MAY","JUN","JUL","AUG","SEPT","OCT","NOV","DEC","YR TOTAL",null,null,"PROPERTY FACT SHEET"]
[null,"MULTI-PROPERTY INCOME OVERVIEW"]
[null,{"$f":"Summary!B6","v":"RENTS RECEIVED"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D5:O5)","v":0},null,null,"Property Type"]
[null,{"$f":"Summary!B7","v":"SECURITY DEPOSIT (TO BE RETURNED)"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D6:O6)","v":0},null,null,"Purchase Date"]
[null,{"$f":"Summary!B8","v":"SECURITY DEPOSIT FORFEITED"},null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"Placed in Service Date"]
[null,{"$f":"Summary!B9","v":"OTHER RENTAL INCOME  – Late Fees, Move out charges, Etc."},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D8:O8)","v":0},null,null,"Property Cost details are available to Formations","Yes"]
[null,"GROSS RENTAL INCOME",null,{"$f":"SUM(D5:D8)","v":0},{"$f":"SUM(E5:E8)","v":0},0,0,0,0,0,0,0,0,0,{"$f":"SUM(O5:O8)","v":0},{"$f":"SUM(D9:O9)","v":0},null,null,"Purchase Price"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"# Fair Rental Days (out of 365)"]
[null,"EXPENSES",null,"JAN","FEB","MAR","APR","MAY","JUN","JUL","AUG","SEPT","OCT","NOV","DEC","YR TOTAL",null,null,"Land Value"]
[null,{"$f":"Summary!B13","v":"MULTI-PROPERTY EXPENSES OVERVIEW"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Is property owned in LLC, Trust, or Estate?"]
[null,{"$f":"'Property 1'!B13","v":"ADVERTISING: LISTING FEES"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D13:O13)","v":0},null,null,"Is property owned with another person (non-spouse)?"]
[null,{"$f":"'Property 1'!B14","v":"ADVERTISING: MARKETING"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D14:O14)","v":0},null,null,"Is property rented to family?"]
[null,{"$f":"'Property 1'!B15","v":"AUTO & TRAVEL EXPENSES (associated with maintaining prop)"},null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"Do you use the property personally?"]
[null,{"$f":"'Property 1'!B16","v":"COMMISSIONS"},null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"         Square Footage of Total Property"]
[null,{"$f":"'Property 1'!B17","v":"FEES: BANK CHARGES"},null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"         Square Footage of Rentable Space (if different from above)"]
[null,{"$f":"'Property 1'!B18","v":"FEES: EQUIPMENT / APPLIANCE RENTAL"},null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"Long term or short term rental?"]
[null,{"$f":"'Property 1'!B19","v":"FEES: INSPECTION"},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,{"$f":"'Property 1'!B20","v":"FEES: LEGAL/PROFESSIONAL"},null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"DEPRECIATION CALCULATION (internal use only)"]
[null,{"$f":"'Property 1'!B21","v":"FEES: MANAGEMENT"},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,{"$f":"'Property 1'!B22","v":"HOA DUES"},null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"Calculated Yearly Depreciation (estimated)",{"$f":"IF(T8=\"Yes\",0,IF(T5=\"Commercial\",(T9-T11)/39,IF(T5=\"Land\",\"N/A\",(T9-T11)/27.5)))","v":0}]
[null,{"$f":"'Property 1'!B23","v":"INSURANCE: RENTER or HOME"},null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"Calculated Yearly Depreciation (actual)"]
[null,{"$f":"'Property 1'!B24","v":"MAINTENANCE: CLEANING"},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,{"$f":"'Property 1'!B25","v":"MAINTENANCE: INTERIOR & EXTERIOR"},null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"QUESTIONNAIRE"]
[null,{"$f":"'Property 1'!B26","v":"MAINTENANCE: LANDSCAPING / GROUNDSKEEPING"},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,{"$f":"'Property 1'!B27","v":"MORTGAGE INTEREST (Form 1098)"},null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"Did/Will you sell this property during the year?"]
[null,{"$f":"'Property 1'!B28","v":"OTHER INTEREST"},null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"*If yes, please upload the settlement statement."]
[null,{"$f":"'Property 1'!B29","v":"POSTAGE"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D29:O29)","v":0},null,null,"     Date of Sale"]
[null,{"$f":"'Property 1'!B30","v":"REPAIRS: INTERIOR & EXTERIOR"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D30:O30)","v":0},null,null,"     Sale Price"]
[null,{"$f":"'Property 1'!B31","v":"SUPPLIES"},null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"Did you participate in a 1031 exchange?"]
[null,{"$f":"'Property 1'!B32","v":"TAXES: PROPERTY/LAND"},null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"Has this property undergone a cost segregation study?"]
[null,{"$f":"'Property 1'!B33","v":"UTILITY: ELECTRIC"},null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"*If no, are you interested in learning more about cost segregation?"]
[null,{"$f":"'Property 1'!B34","v":"UTILITY: GARBAGE / REFUSE"},null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"Were any insurance claims filed due to property damage?"]
[null,{"$f":"'Property 1'!B35","v":"UTILITY: GAS"},null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"*For example: fires, flood, natural disasters (explain below)"]
[null,{"$f":"'Property 1'!B36","v":"UTILITY: SECURITY SYSTEM"},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,{"$f":"'Property 1'!B37","v":"UTILITY: WATER/SEWER"},null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"ADDITIONAL NOTES (optional)"]
[null,"OTHER (type new category here)",null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"Please add any additional details you feel are important for us to know."]
[null,"OTHER (type new category here)",null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"OTHER (type new category here)",null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"OTHER (type new category here)",null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"TOTAL EXPENSES",null,{"$f":"SUM(D13:D41)","v":0},0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(D42:O42)","v":0}]
[]
[null,"YEAR-TO-DATE INCOME LESS EXPENSES",null,{"$f":"D9-D42","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[]
[]
[null,"IMPROVEMENTS                                                              DATE OF PURCHASE",null,"JAN","FEB","MAR","APR","MAY","JUN","JUL","AUG","SEPT","OCT","NOV","DEC","YR TOTAL"]
[null,"EQUIPMENT / APPLIANCE PURCHASES",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D48:O48)","v":0}]
[null,"REMODEL",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D49:O49)","v":0}]
[null,"FLOORING",null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"ROOF",null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"OTHER (type new category here)",null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"OTHER (type new category here)",null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"TOTAL IMPROVEMENTS",null,{"$f":"SUM(D48:D53)","v":0},{"$f":"SUM(E48:E53)","v":0},0,0,{"$f":"SUM(H48:H53)","v":0},0,0,0,0,0,0,0,{"$f":"SUM(P48:P53)","v":0}]

{"sheet":"Property 9","index":11,"n_rows":54,"n_cols":20,"rows_kept":54,"cut":false,"hidden":false,"merged":[[38,18,41,19],[36,18,36,19],[53,1,53,2],[7,1,7,2],[1,3,1,15],[2,18,2,19],[43,1,43,2],[41,1,41,2],[5,1,5,2],[4,1,4,2],[8,1,8,2],[11,1,11,2],[6,1,6,2],[46,1,46,2],[10,1,10,2],[19,18,19,19],[24,18,24,19],[37,18,37,19],[0,3,0,4],[3,1,3,2],[2,1,2,2],[1,1,1,2],[0,1,0,2]]}
[" ",{"$f":"Summary!B2","v":"CUSTOMER/ENTITY NAME"},null,{"$f":"Summary!D2","v":2024}]
[null,"PROPERTY 9 ADDRESS",null,"123 Main Street, City, State 10001"]
[null,"INCOME",null,"JAN","FEB","MAR","APR","MAY","JUN","JUL","AUG","SEPT","OCT","NOV","DEC","YR TOTAL",null,null,"PROPERTY FACT SHEET"]
[null,"MULTI-PROPERTY INCOME OVERVIEW"]
[null,{"$f":"Summary!B6","v":"RENTS RECEIVED"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D5:O5)","v":0},null,null,"Property Type"]
[null,{"$f":"Summary!B7","v":"SECURITY DEPOSIT (TO BE RETURNED)"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D6:O6)","v":0},null,null,"Purchase Date"]
[null,{"$f":"Summary!B8","v":"SECURITY DEPOSIT FORFEITED"},null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"Placed in Service Date"]
[null,{"$f":"Summary!B9","v":"OTHER RENTAL INCOME  – Late Fees, Move out charges, Etc."},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D8:O8)","v":0},null,null,"Property Cost details are available to Formations","Yes"]
[null,"GROSS RENTAL INCOME",null,{"$f":"SUM(D5:D8)","v":0},{"$f":"SUM(E5:E8)","v":0},0,0,0,0,0,0,0,0,0,{"$f":"SUM(O5:O8)","v":0},{"$f":"SUM(D9:O9)","v":0},null,null,"Purchase Price"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"# Fair Rental Days (out of 365)"]
[null,"EXPENSES",null,"JAN","FEB","MAR","APR","MAY","JUN","JUL","AUG","SEPT","OCT","NOV","DEC","YR TOTAL",null,null,"Land Value"]
[null,{"$f":"Summary!B13","v":"MULTI-PROPERTY EXPENSES OVERVIEW"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Is property owned in LLC, Trust, or Estate?"]
[null,{"$f":"'Property 1'!B13","v":"ADVERTISING: LISTING FEES"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D13:O13)","v":0},null,null,"Is property owned with another person (non-spouse)?"]
[null,{"$f":"'Property 1'!B14","v":"ADVERTISING: MARKETING"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D14:O14)","v":0},null,null,"Is property rented to family?"]
[null,{"$f":"'Property 1'!B15","v":"AUTO & TRAVEL EXPENSES (associated with maintaining prop)"},null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"Do you use the property personally?"]
[null,{"$f":"'Property 1'!B16","v":"COMMISSIONS"},null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"         Square Footage of Total Property"]
[null,{"$f":"'Property 1'!B17","v":"FEES: BANK CHARGES"},null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"         Square Footage of Rentable Space (if different from above)"]
[null,{"$f":"'Property 1'!B18","v":"FEES: EQUIPMENT / APPLIANCE RENTAL"},null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"Long term or short term rental?"]
[null,{"$f":"'Property 1'!B19","v":"FEES: INSPECTION"},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,{"$f":"'Property 1'!B20","v":"FEES: LEGAL/PROFESSIONAL"},null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"DEPRECIATION CALCULATION (internal use only)"]
[null,{"$f":"'Property 1'!B21","v":"FEES: MANAGEMENT"},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,{"$f":"'Property 1'!B22","v":"HOA DUES"},null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"Calculated Yearly Depreciation (estimated)",{"$f":"IF(T8=\"Yes\",0,IF(T5=\"Commercial\",(T9-T11)/39,IF(T5=\"Land\",\"N/A\",(T9-T11)/27.5)))","v":0}]
[null,{"$f":"'Property 1'!B23","v":"INSURANCE: RENTER or HOME"},null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"Calculated Yearly Depreciation (actual)"]
[null,{"$f":"'Property 1'!B24","v":"MAINTENANCE: CLEANING"},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,{"$f":"'Property 1'!B25","v":"MAINTENANCE: INTERIOR & EXTERIOR"},null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"QUESTIONNAIRE"]
[null,{"$f":"'Property 1'!B26","v":"MAINTENANCE: LANDSCAPING / GROUNDSKEEPING"},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,{"$f":"'Property 1'!B27","v":"MORTGAGE INTEREST (Form 1098)"},null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"Did/Will you sell this property during the year?"]
[null,{"$f":"'Property 1'!B28","v":"OTHER INTEREST"},null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"*If yes, please upload the settlement statement."]
[null,{"$f":"'Property 1'!B29","v":"POSTAGE"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D29:O29)","v":0},null,null,"     Date of Sale"]
[null,{"$f":"'Property 1'!B30","v":"REPAIRS: INTERIOR & EXTERIOR"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D30:O30)","v":0},null,null,"     Sale Price"]
[null,{"$f":"'Property 1'!B31","v":"SUPPLIES"},null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"Did you participate in a 1031 exchange?"]
[null,{"$f":"'Property 1'!B32","v":"TAXES: PROPERTY/LAND"},null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"Has this property undergone a cost segregation study?"]
[null,{"$f":"'Property 1'!B33","v":"UTILITY: ELECTRIC"},null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"*If no, are you interested in learning more about cost segregation?"]
[null,{"$f":"'Property 1'!B34","v":"UTILITY: GARBAGE / REFUSE"},null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"Were any insurance claims filed due to property damage?"]
[null,{"$f":"'Property 1'!B35","v":"UTILITY: GAS"},null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"*For example: fires, flood, natural disasters (explain below)"]
[null,{"$f":"'Property 1'!B36","v":"UTILITY: SECURITY SYSTEM"},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,{"$f":"'Property 1'!B37","v":"UTILITY: WATER/SEWER"},null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"ADDITIONAL NOTES (optional)"]
[null,"OTHER (type new category here)",null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"Please add any additional details you feel are important for us to know."]
[null,"OTHER (type new category here)",null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"OTHER (type new category here)",null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"OTHER (type new category here)",null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"TOTAL EXPENSES",null,{"$f":"SUM(D13:D41)","v":0},0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(D42:O42)","v":0}]
[]
[null,"YEAR-TO-DATE INCOME LESS EXPENSES",null,{"$f":"D9-D42","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[]
[]
[null,"IMPROVEMENTS                                                              DATE OF PURCHASE",null,"JAN","FEB","MAR","APR","MAY","JUN","JUL","AUG","SEPT","OCT","NOV","DEC","YR TOTAL"]
[null,"EQUIPMENT / APPLIANCE PURCHASES",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D48:O48)","v":0}]
[null,"REMODEL",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D49:O49)","v":0}]
[null,"FLOORING",null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"ROOF",null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"OTHER (type new category here)",null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"OTHER (type new category here)",null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"TOTAL IMPROVEMENTS",null,{"$f":"SUM(D48:D53)","v":0},{"$f":"SUM(E48:E53)","v":0},0,0,{"$f":"SUM(H48:H53)","v":0},0,0,0,0,0,0,0,{"$f":"SUM(P48:P53)","v":0}]

{"sheet":"Property 10","index":12,"n_rows":54,"n_cols":20,"rows_kept":54,"cut":false,"hidden":false,"merged":[[38,18,41,19],[36,18,36,19],[53,1,53,2],[7,1,7,2],[1,3,1,15],[2,18,2,19],[43,1,43,2],[41,1,41,2],[5,1,5,2],[4,1,4,2],[8,1,8,2],[11,1,11,2],[6,1,6,2],[46,1,46,2],[10,1,10,2],[19,18,19,19],[24,18,24,19],[37,18,37,19],[0,3,0,4],[3,1,3,2],[2,1,2,2],[1,1,1,2],[0,1,0,2]]}
[" ",{"$f":"Summary!B2","v":"CUSTOMER/ENTITY NAME"},null,{"$f":"Summary!D2","v":2024}]
[null,"PROPERTY 10 ADDRESS",null,"123 Main Street, City, State 10001"]
[null,"INCOME",null,"JAN","FEB","MAR","APR","MAY","JUN","JUL","AUG","SEPT","OCT","NOV","DEC","YR TOTAL",null,null,"PROPERTY FACT SHEET"]
[null,"MULTI-PROPERTY INCOME OVERVIEW"]
[null,{"$f":"Summary!B6","v":"RENTS RECEIVED"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D5:O5)","v":0},null,null,"Property Type"]
[null,{"$f":"Summary!B7","v":"SECURITY DEPOSIT (TO BE RETURNED)"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D6:O6)","v":0},null,null,"Purchase Date"]
[null,{"$f":"Summary!B8","v":"SECURITY DEPOSIT FORFEITED"},null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"Placed in Service Date"]
[null,{"$f":"Summary!B9","v":"OTHER RENTAL INCOME  – Late Fees, Move out charges, Etc."},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D8:O8)","v":0},null,null,"Property Cost details are available to Formations","Yes"]
[null,"GROSS RENTAL INCOME",null,{"$f":"SUM(D5:D8)","v":0},{"$f":"SUM(E5:E8)","v":0},0,0,0,0,0,0,0,0,0,{"$f":"SUM(O5:O8)","v":0},{"$f":"SUM(D9:O9)","v":0},null,null,"Purchase Price"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"# Fair Rental Days (out of 365)"]
[null,"EXPENSES",null,"JAN","FEB","MAR","APR","MAY","JUN","JUL","AUG","SEPT","OCT","NOV","DEC","YR TOTAL",null,null,"Land Value"]
[null,{"$f":"Summary!B13","v":"MULTI-PROPERTY EXPENSES OVERVIEW"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Is property owned in LLC, Trust, or Estate?"]
[null,{"$f":"'Property 1'!B13","v":"ADVERTISING: LISTING FEES"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D13:O13)","v":0},null,null,"Is property owned with another person (non-spouse)?"]
[null,{"$f":"'Property 1'!B14","v":"ADVERTISING: MARKETING"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D14:O14)","v":0},null,null,"Is property rented to family?"]
[null,{"$f":"'Property 1'!B15","v":"AUTO & TRAVEL EXPENSES (associated with maintaining prop)"},null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"Do you use the property personally?"]
[null,{"$f":"'Property 1'!B16","v":"COMMISSIONS"},null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"         Square Footage of Total Property"]
[null,{"$f":"'Property 1'!B17","v":"FEES: BANK CHARGES"},null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"         Square Footage of Rentable Space (if different from above)"]
[null,{"$f":"'Property 1'!B18","v":"FEES: EQUIPMENT / APPLIANCE RENTAL"},null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"Long term or short term rental?"]
[null,{"$f":"'Property 1'!B19","v":"FEES: INSPECTION"},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,{"$f":"'Property 1'!B20","v":"FEES: LEGAL/PROFESSIONAL"},null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"DEPRECIATION CALCULATION (internal use only)"]
[null,{"$f":"'Property 1'!B21","v":"FEES: MANAGEMENT"},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,{"$f":"'Property 1'!B22","v":"HOA DUES"},null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"Calculated Yearly Depreciation (estimated)",{"$f":"IF(T8=\"Yes\",0,IF(T5=\"Commercial\",(T9-T11)/39,IF(T5=\"Land\",\"N/A\",(T9-T11)/27.5)))","v":0}]
[null,{"$f":"'Property 1'!B23","v":"INSURANCE: RENTER or HOME"},null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"Calculated Yearly Depreciation (actual)"]
[null,{"$f":"'Property 1'!B24","v":"MAINTENANCE: CLEANING"},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,{"$f":"'Property 1'!B25","v":"MAINTENANCE: INTERIOR & EXTERIOR"},null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"QUESTIONNAIRE"]
[null,{"$f":"'Property 1'!B26","v":"MAINTENANCE: LANDSCAPING / GROUNDSKEEPING"},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,{"$f":"'Property 1'!B27","v":"MORTGAGE INTEREST (Form 1098)"},null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"Did/Will you sell this property during the year?"]
[null,{"$f":"'Property 1'!B28","v":"OTHER INTEREST"},null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"*If yes, please upload the settlement statement."]
[null,{"$f":"'Property 1'!B29","v":"POSTAGE"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D29:O29)","v":0},null,null,"     Date of Sale"]
[null,{"$f":"'Property 1'!B30","v":"REPAIRS: INTERIOR & EXTERIOR"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D30:O30)","v":0},null,null,"     Sale Price"]
[null,{"$f":"'Property 1'!B31","v":"SUPPLIES"},null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"Did you participate in a 1031 exchange?"]
[null,{"$f":"'Property 1'!B32","v":"TAXES: PROPERTY/LAND"},null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"Has this property undergone a cost segregation study?"]
[null,{"$f":"'Property 1'!B33","v":"UTILITY: ELECTRIC"},null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"*If no, are you interested in learning more about cost segregation?"]
[null,{"$f":"'Property 1'!B34","v":"UTILITY: GARBAGE / REFUSE"},null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"Were any insurance claims filed due to property damage?"]
[null,{"$f":"'Property 1'!B35","v":"UTILITY: GAS"},null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"*For example: fires, flood, natural disasters (explain below)"]
[null,{"$f":"'Property 1'!B36","v":"UTILITY: SECURITY SYSTEM"},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,{"$f":"'Property 1'!B37","v":"UTILITY: WATER/SEWER"},null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"ADDITIONAL NOTES (optional)"]
[null,"OTHER (type new category here)",null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"Please add any additional details you feel are important for us to know."]
[null,"OTHER (type new category here)",null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"OTHER (type new category here)",null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"OTHER (type new category here)",null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"TOTAL EXPENSES",null,{"$f":"SUM(D13:D41)","v":0},0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(D42:O42)","v":0}]
[]
[null,"YEAR-TO-DATE INCOME LESS EXPENSES",null,{"$f":"D9-D42","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[]
[]
[null,"IMPROVEMENTS                                                              DATE OF PURCHASE",null,"JAN","FEB","MAR","APR","MAY","JUN","JUL","AUG","SEPT","OCT","NOV","DEC","YR TOTAL"]
[null,"EQUIPMENT / APPLIANCE PURCHASES",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D48:O48)","v":0}]
[null,"REMODEL",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D49:O49)","v":0}]
[null,"FLOORING",null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"ROOF",null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"OTHER (type new category here)",null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"OTHER (type new category here)",null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"TOTAL IMPROVEMENTS",null,{"$f":"SUM(D48:D53)","v":0},{"$f":"SUM(E48:E53)","v":0},0,0,{"$f":"SUM(H48:H53)","v":0},0,0,0,0,0,0,0,{"$f":"SUM(P48:P53)","v":0}]

{"sheet":"Property 11","index":13,"n_rows":54,"n_cols":20,"rows_kept":54,"cut":false,"hidden":false,"merged":[[38,18,41,19],[36,18,36,19],[53,1,53,2],[7,1,7,2],[1,3,1,15],[2,18,2,19],[43,1,43,2],[41,1,41,2],[5,1,5,2],[4,1,4,2],[8,1,8,2],[11,1,11,2],[6,1,6,2],[46,1,46,2],[10,1,10,2],[19,18,19,19],[24,18,24,19],[37,18,37,19],[0,3,0,4],[3,1,3,2],[2,1,2,2],[1,1,1,2],[0,1,0,2]]}
[" ",{"$f":"Summary!B2","v":"CUSTOMER/ENTITY NAME"},null,{"$f":"Summary!D2","v":2024}]
[null,"PROPERTY 11 ADDRESS",null,"123 Main Street, City, State 10001"]
[null,"INCOME",null,"JAN","FEB","MAR","APR","MAY","JUN","JUL","AUG","SEPT","OCT","NOV","DEC","YR TOTAL",null,null,"PROPERTY FACT SHEET"]
[null,"MULTI-PROPERTY INCOME OVERVIEW"]
[null,{"$f":"Summary!B6","v":"RENTS RECEIVED"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D5:O5)","v":0},null,null,"Property Type"]
[null,{"$f":"Summary!B7","v":"SECURITY DEPOSIT (TO BE RETURNED)"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D6:O6)","v":0},null,null,"Purchase Date"]
[null,{"$f":"Summary!B8","v":"SECURITY DEPOSIT FORFEITED"},null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"Placed in Service Date"]
[null,{"$f":"Summary!B9","v":"OTHER RENTAL INCOME  – Late Fees, Move out charges, Etc."},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D8:O8)","v":0},null,null,"Property Cost details are available to Formations","Yes"]
[null,"GROSS RENTAL INCOME",null,{"$f":"SUM(D5:D8)","v":0},{"$f":"SUM(E5:E8)","v":0},0,0,0,0,0,0,0,0,0,{"$f":"SUM(O5:O8)","v":0},{"$f":"SUM(D9:O9)","v":0},null,null,"Purchase Price"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"# Fair Rental Days (out of 365)"]
[null,"EXPENSES",null,"JAN","FEB","MAR","APR","MAY","JUN","JUL","AUG","SEPT","OCT","NOV","DEC","YR TOTAL",null,null,"Land Value"]
[null,{"$f":"Summary!B13","v":"MULTI-PROPERTY EXPENSES OVERVIEW"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Is property owned in LLC, Trust, or Estate?"]
[null,{"$f":"'Property 1'!B13","v":"ADVERTISING: LISTING FEES"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D13:O13)","v":0},null,null,"Is property owned with another person (non-spouse)?"]
[null,{"$f":"'Property 1'!B14","v":"ADVERTISING: MARKETING"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D14:O14)","v":0},null,null,"Is property rented to family?"]
[null,{"$f":"'Property 1'!B15","v":"AUTO & TRAVEL EXPENSES (associated with maintaining prop)"},null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"Do you use the property personally?"]
[null,{"$f":"'Property 1'!B16","v":"COMMISSIONS"},null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"         Square Footage of Total Property"]
[null,{"$f":"'Property 1'!B17","v":"FEES: BANK CHARGES"},null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"         Square Footage of Rentable Space (if different from above)"]
[null,{"$f":"'Property 1'!B18","v":"FEES: EQUIPMENT / APPLIANCE RENTAL"},null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"Long term or short term rental?"]
[null,{"$f":"'Property 1'!B19","v":"FEES: INSPECTION"},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,{"$f":"'Property 1'!B20","v":"FEES: LEGAL/PROFESSIONAL"},null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"DEPRECIATION CALCULATION (internal use only)"]
[null,{"$f":"'Property 1'!B21","v":"FEES: MANAGEMENT"},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,{"$f":"'Property 1'!B22","v":"HOA DUES"},null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"Calculated Yearly Depreciation (estimated)",{"$f":"IF(T8=\"Yes\",0,IF(T5=\"Commercial\",(T9-T11)/39,IF(T5=\"Land\",\"N/A\",(T9-T11)/27.5)))","v":0}]
[null,{"$f":"'Property 1'!B23","v":"INSURANCE: RENTER or HOME"},null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"Calculated Yearly Depreciation (actual)"]
[null,{"$f":"'Property 1'!B24","v":"MAINTENANCE: CLEANING"},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,{"$f":"'Property 1'!B25","v":"MAINTENANCE: INTERIOR & EXTERIOR"},null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"QUESTIONNAIRE"]
[null,{"$f":"'Property 1'!B26","v":"MAINTENANCE: LANDSCAPING / GROUNDSKEEPING"},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,{"$f":"'Property 1'!B27","v":"MORTGAGE INTEREST (Form 1098)"},null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"Did/Will you sell this property during the year?"]
[null,{"$f":"'Property 1'!B28","v":"OTHER INTEREST"},null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"*If yes, please upload the settlement statement."]
[null,{"$f":"'Property 1'!B29","v":"POSTAGE"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D29:O29)","v":0},null,null,"     Date of Sale"]
[null,{"$f":"'Property 1'!B30","v":"REPAIRS: INTERIOR & EXTERIOR"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D30:O30)","v":0},null,null,"     Sale Price"]
[null,{"$f":"'Property 1'!B31","v":"SUPPLIES"},null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"Did you participate in a 1031 exchange?"]
[null,{"$f":"'Property 1'!B32","v":"TAXES: PROPERTY/LAND"},null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"Has this property undergone a cost segregation study?"]
[null,{"$f":"'Property 1'!B33","v":"UTILITY: ELECTRIC"},null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"*If no, are you interested in learning more about cost segregation?"]
[null,{"$f":"'Property 1'!B34","v":"UTILITY: GARBAGE / REFUSE"},null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"Were any insurance claims filed due to property damage?"]
[null,{"$f":"'Property 1'!B35","v":"UTILITY: GAS"},null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"*For example: fires, flood, natural disasters (explain below)"]
[null,{"$f":"'Property 1'!B36","v":"UTILITY: SECURITY SYSTEM"},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,{"$f":"'Property 1'!B37","v":"UTILITY: WATER/SEWER"},null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"ADDITIONAL NOTES (optional)"]
[null,"OTHER (type new category here)",null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"Please add any additional details you feel are important for us to know."]
[null,"OTHER (type new category here)",null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"OTHER (type new category here)",null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"OTHER (type new category here)",null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"TOTAL EXPENSES",null,{"$f":"SUM(D13:D41)","v":0},0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(D42:O42)","v":0}]
[]
[null,"YEAR-TO-DATE INCOME LESS EXPENSES",null,{"$f":"D9-D42","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[]
[]
[null,"IMPROVEMENTS                                                              DATE OF PURCHASE",null,"JAN","FEB","MAR","APR","MAY","JUN","JUL","AUG","SEPT","OCT","NOV","DEC","YR TOTAL"]
[null,"EQUIPMENT / APPLIANCE PURCHASES",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D48:O48)","v":0}]
[null,"REMODEL",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D49:O49)","v":0}]
[null,"FLOORING",null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"ROOF",null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"OTHER (type new category here)",null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"OTHER (type new category here)",null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"TOTAL IMPROVEMENTS",null,{"$f":"SUM(D48:D53)","v":0},{"$f":"SUM(E48:E53)","v":0},0,0,{"$f":"SUM(H48:H53)","v":0},0,0,0,0,0,0,0,{"$f":"SUM(P48:P53)","v":0}]

{"sheet":"Property 12","index":14,"n_rows":54,"n_cols":20,"rows_kept":54,"cut":false,"hidden":false,"merged":[[38,18,41,19],[36,18,36,19],[53,1,53,2],[7,1,7,2],[1,3,1,15],[2,18,2,19],[43,1,43,2],[41,1,41,2],[5,1,5,2],[4,1,4,2],[8,1,8,2],[11,1,11,2],[6,1,6,2],[46,1,46,2],[10,1,10,2],[19,18,19,19],[24,18,24,19],[37,18,37,19],[0,3,0,4],[3,1,3,2],[2,1,2,2],[1,1,1,2],[0,1,0,2]]}
[" ",{"$f":"Summary!B2","v":"CUSTOMER/ENTITY NAME"},null,{"$f":"Summary!D2","v":2024}]
[null,"PROPERTY 12 ADDRESS",null,"123 Main Street, City, State 10001"]
[null,"INCOME",null,"JAN","FEB","MAR","APR","MAY","JUN","JUL","AUG","SEPT","OCT","NOV","DEC","YR TOTAL",null,null,"PROPERTY FACT SHEET"]
[null,"MULTI-PROPERTY INCOME OVERVIEW"]
[null,{"$f":"Summary!B6","v":"RENTS RECEIVED"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D5:O5)","v":0},null,null,"Property Type"]
[null,{"$f":"Summary!B7","v":"SECURITY DEPOSIT (TO BE RETURNED)"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D6:O6)","v":0},null,null,"Purchase Date"]
[null,{"$f":"Summary!B8","v":"SECURITY DEPOSIT FORFEITED"},null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"Placed in Service Date"]
[null,{"$f":"Summary!B9","v":"OTHER RENTAL INCOME  – Late Fees, Move out charges, Etc."},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D8:O8)","v":0},null,null,"Property Cost details are available to Formations","Yes"]
[null,"GROSS RENTAL INCOME",null,{"$f":"SUM(D5:D8)","v":0},{"$f":"SUM(E5:E8)","v":0},0,0,0,0,0,0,0,0,0,{"$f":"SUM(O5:O8)","v":0},{"$f":"SUM(D9:O9)","v":0},null,null,"Purchase Price"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"# Fair Rental Days (out of 365)"]
[null,"EXPENSES",null,"JAN","FEB","MAR","APR","MAY","JUN","JUL","AUG","SEPT","OCT","NOV","DEC","YR TOTAL",null,null,"Land Value"]
[null,{"$f":"Summary!B13","v":"MULTI-PROPERTY EXPENSES OVERVIEW"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Is property owned in LLC, Trust, or Estate?"]
[null,{"$f":"'Property 1'!B13","v":"ADVERTISING: LISTING FEES"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D13:O13)","v":0},null,null,"Is property owned with another person (non-spouse)?"]
[null,{"$f":"'Property 1'!B14","v":"ADVERTISING: MARKETING"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D14:O14)","v":0},null,null,"Is property rented to family?"]
[null,{"$f":"'Property 1'!B15","v":"AUTO & TRAVEL EXPENSES (associated with maintaining prop)"},null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"Do you use the property personally?"]
[null,{"$f":"'Property 1'!B16","v":"COMMISSIONS"},null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"         Square Footage of Total Property"]
[null,{"$f":"'Property 1'!B17","v":"FEES: BANK CHARGES"},null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"         Square Footage of Rentable Space (if different from above)"]
[null,{"$f":"'Property 1'!B18","v":"FEES: EQUIPMENT / APPLIANCE RENTAL"},null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"Long term or short term rental?"]
[null,{"$f":"'Property 1'!B19","v":"FEES: INSPECTION"},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,{"$f":"'Property 1'!B20","v":"FEES: LEGAL/PROFESSIONAL"},null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"DEPRECIATION CALCULATION (internal use only)"]
[null,{"$f":"'Property 1'!B21","v":"FEES: MANAGEMENT"},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,{"$f":"'Property 1'!B22","v":"HOA DUES"},null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"Calculated Yearly Depreciation (estimated)",{"$f":"IF(T8=\"Yes\",0,IF(T5=\"Commercial\",(T9-T11)/39,IF(T5=\"Land\",\"N/A\",(T9-T11)/27.5)))","v":0}]
[null,{"$f":"'Property 1'!B23","v":"INSURANCE: RENTER or HOME"},null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"Calculated Yearly Depreciation (actual)"]
[null,{"$f":"'Property 1'!B24","v":"MAINTENANCE: CLEANING"},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,{"$f":"'Property 1'!B25","v":"MAINTENANCE: INTERIOR & EXTERIOR"},null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"QUESTIONNAIRE"]
[null,{"$f":"'Property 1'!B26","v":"MAINTENANCE: LANDSCAPING / GROUNDSKEEPING"},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,{"$f":"'Property 1'!B27","v":"MORTGAGE INTEREST (Form 1098)"},null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"Did/Will you sell this property during the year?"]
[null,{"$f":"'Property 1'!B28","v":"OTHER INTEREST"},null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"*If yes, please upload the settlement statement."]
[null,{"$f":"'Property 1'!B29","v":"POSTAGE"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D29:O29)","v":0},null,null,"     Date of Sale"]
[null,{"$f":"'Property 1'!B30","v":"REPAIRS: INTERIOR & EXTERIOR"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D30:O30)","v":0},null,null,"     Sale Price"]
[null,{"$f":"'Property 1'!B31","v":"SUPPLIES"},null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"Did you participate in a 1031 exchange?"]
[null,{"$f":"'Property 1'!B32","v":"TAXES: PROPERTY/LAND"},null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"Has this property undergone a cost segregation study?"]
[null,{"$f":"'Property 1'!B33","v":"UTILITY: ELECTRIC"},null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"*If no, are you interested in learning more about cost segregation?"]
[null,{"$f":"'Property 1'!B34","v":"UTILITY: GARBAGE / REFUSE"},null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"Were any insurance claims filed due to property damage?"]
[null,{"$f":"'Property 1'!B35","v":"UTILITY: GAS"},null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"*For example: fires, flood, natural disasters (explain below)"]
[null,{"$f":"'Property 1'!B36","v":"UTILITY: SECURITY SYSTEM"},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,{"$f":"'Property 1'!B37","v":"UTILITY: WATER/SEWER"},null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"ADDITIONAL NOTES (optional)"]
[null,"OTHER (type new category here)",null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"Please add any additional details you feel are important for us to know."]
[null,"OTHER (type new category here)",null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"OTHER (type new category here)",null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"OTHER (type new category here)",null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"TOTAL EXPENSES",null,{"$f":"SUM(D13:D41)","v":0},0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(D42:O42)","v":0}]
[]
[null,"YEAR-TO-DATE INCOME LESS EXPENSES",null,{"$f":"D9-D42","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[]
[]
[null,"IMPROVEMENTS                                                              DATE OF PURCHASE",null,"JAN","FEB","MAR","APR","MAY","JUN","JUL","AUG","SEPT","OCT","NOV","DEC","YR TOTAL"]
[null,"EQUIPMENT / APPLIANCE PURCHASES",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D48:O48)","v":0}]
[null,"REMODEL",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D49:O49)","v":0}]
[null,"FLOORING",null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"ROOF",null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"OTHER (type new category here)",null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"OTHER (type new category here)",null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"TOTAL IMPROVEMENTS",null,{"$f":"SUM(D48:D53)","v":0},{"$f":"SUM(E48:E53)","v":0},0,0,{"$f":"SUM(H48:H53)","v":0},0,0,0,0,0,0,0,{"$f":"SUM(P48:P53)","v":0}]