{"text_format":"2","workbook":"xls","n_sheets":1,"sheets":["Rent Roll Template"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":2,"defined_names":1,"comments":12,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"Rent Roll Template","index":0,"n_rows":29,"n_cols":18,"rows_kept":29,"cut":false,"hidden":false,"merged":[[7,8,7,10]],"flags":["formulas_cached_only"]}
[null,"Rent Roll Schedule ",{"$nulls":4},"Date:","2025-08-13"]
[null,"6501 S Hermitage Ave"]
[null,"Chicago, Il 60636"]
[]
[null,"Street Address","Unit #","# of Bed Rooms","# of Bath Rooms","Unit Square footage","Tenant Name","Lease Type","Tenant's Initial Lease Start Date","Current Lease Start Date","Current Lease End Date","Lease Term (Auto Calc Months)","Lease Rent"," Tenant with Rent Subsidy? (Yes/No)","Rent Subsidy Amount","Tenant's Rent Payment","Name of Rent Subsidy Program","Comments\n(Add notes as needed)"]
[null,"1721 W 65th st",1,2,1,900,"Jalecia Black, Niguel Gordon","Market Rate","2024-04-01","2025-05-01","2026-04-30",null,1350,"No",0,1350]
[null,"1721 W 65th st","2E",2,1,900,"New Tenant","Market Rate","2022-10-01","2022-10-01","MTM",null,1350,"No",0,1350]
[null,"1721 W 65th st","2W",3,2,1100,"Vacant","Market Rate","Newly Vacant for Showings",null,null,null,1650,"No",0,null,null,"Left vacant for Showings"]
[null,"6503 S Hermitage Ave",1,3,2,1200,"New Tenant","Market Rate","2025-06-01",null,null,null,1500,"No",0,1500]
[null,"6503 S Hermitage Ave",2,3,2,1200,"Cade and Lillian K","Market Rate","2024-05-01","2025-06-01","2026-05-31",null,1375,"No",0,1375]
[null,"6501 S Hermitage Ave",null,null,null,1100,"Life Industries Mech","Market Rate","2023-08-01",null,"MTM",null,1000,"Yes",0,1000]
[{"$nulls":11},""]
[{"$nulls":11},""]
[{"$nulls":11},""]
[null,"Total",null,null,null,6400,{"$nulls":6},8225,null,0,6575]
[{"$nulls":14},0]
[null,"Commercial Tenant Name\n(If applicable)","Unit Square footage","Tenant's Initial Lease Start Date","Current Lease Start Date","Current Lease End Date","Lease Rent","Comments\n(Add notes as needed)",null,null,null,"Lease Term (Auto Calc Months)"]
[null,"Life Industries",1100,"2023-08-01","2023-08-01","2023-10-31",800,null,null,null,"Proforma Gross Annual",3,98700,null,"Current Rents Annualized",78900]
[{"$nulls":10},"Coin Laundry","",1200,null,"Coin Laundry",1200]
[{"$nulls":11},""]
[{"$nulls":11},""]
[{"$nulls":11},""]
[null,"Total",{"$nulls":4},800,null,null,null,"Total Gross Income 100% occupancy",null,99900,null,"Current Gross Income less vacancy",80100]
[{"$nulls":10},"Operating Expenses (insurance, taxes, Utilities)",null,10607,null,"2024 Operating Expenses",10607]
[null,null,null,"Certified true and accurate as of ",{"$nulls":6},"Proforma NOI",null,89293,null,null,69493]
[]
[null,"X",{"$nulls":8},"Purchase Price",null,535000,null,"Purchase Price",535000]
[null,"Enter Borrower's Name, and Member Interest (i.e Managing Member, Member, etc)",{"$nulls":8},"Pro Forma Cap Rate",null,16.690280373831776,null,"Actual Cap Rate",12.989345794392523]
[{"$nulls":10},"GRM",null,5.420466058763931,null,"GRM",5.420466058763931]