{"text_format":"2","workbook":"xlsx","n_sheets":2,"sheets":["Owner Statement","Forecast"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":0,"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"}

{"sheet":"Owner Statement","index":0,"n_rows":58,"n_cols":11,"rows_kept":58,"cut":false,"hidden":false,"merged":[]}
[null,null,"Name: IG - HMFI","12/1/2024 - 12/1/2025",{"$nulls":4},"ANNUAL PROPERTY OPERATING DATA"]
[null,null,"Location: ","1269 4th Ave SE",{"$nulls":4},"Date:","2025-05-12"]
[null,"Type of Property:","Multi-Family Property",{"$nulls":4},"Purchase Price:",179000]
[null,null,"Size of Property: # Units: 8",{"$nulls":4},"Cost of Acquisition:"]
[null,"Purpose:","Owner's Statement",null,"Broker's Reconstructed",{"$nulls":4},"Price Per Unit",{"$f":"I3/2","v":89500}]
[null,null,"Existing Financing",null,"Potential Financing",{"$nulls":4},"Down Payment:",{"$f":"I3*0.25","v":44750}]
[null,null,"Seller's Position",null,"Buyer's Position"]
[null,null,"Forecast"]
[]
[null,"Existing","Balance","Payment","#Pmts/Yr","Interest","Term"]
[null,"1st"]
[null,"2nd"]
[null,"3rd"]
[null,null,"Potential:"]
[null,"1st"]
[null,"2nd"]
[{"$nulls":4},"$/sf or",null,"%"]
[null,"ALL FIGURES ANNUAL","$/unit",null,"of GOI",null,null,"Comments/Footnotes"]
[1,"POTENTIAL RENTAL INCOME",null,null,{"$f":"2400*12","v":28800},null,null,"Rent: $1200 x 2",{"$f":"1200+1200","v":2400}]
[2,"Less: Vacancy & Cr Losses",null,null,{"$f":"E19*0.05","v":1440}]
[3,"EFFECTIVE RENTAL INCOME",null,null,{"$f":"E19-E20","v":27360}]
[4,"Plus: Other Income"]
[5,"GROSS OPERATING INCOME",null,null,{"$f":"E21+E22","v":27360}]
[null,"OPERATING EXPENSES:"]
[6,"Real Estate Taxes",null,null,1785,2025]
[7,"Personal Property Taxes"]
[8,"Property Insurance",null,null,1998]
[9,"Off-site Management"]
[10," Management"]
[11,"Expenses / Benefits"]
[12,"Taxes / Workers' Comp"]
[13,"Repairs and Maintenance",null,null,2508]
[null,"Utilities"]
[14,"Electric",{"$nulls":4},"Tenants Pay for all utilities",null,"Water",1245.79]
[15,"Gas",{"$nulls":4},"Utilities Sepreatley Metered"]
[16,"Water",{"$nulls":6},"Gas",422.69]
[17,"ALL COMMON COSTS"]
[18,"Accounting and Legal",{"$nulls":6},"Electric",2130.5100000000002]
[19,"RE Leasing Commissions"]
[20,"Advertising/Licenses/Permits"]
[21,"Supplies"]
[22,"Miscellaneous"]
[null,"Contract Services:"]
[23,"Lawn & Snow",null,null,0]
[24,"Garbage"]
[25,"Cleaning Payroll"]
[26,"Exterminator"]
[27,"Reserves"]
[28]
[29,"TOTAL OPERATING EXPENSES",null,null,{"$f":"SUM(E25:E49)","v":6291}]
[30,"NET OPERATING INCOME",null,null,{"$f":"E23-E50","v":21069}]
[31,"Less:Annual Debt Service"]
[35,"CASH FLOW BEFORE TAXES",null,null,{"$f":"E51-E52","v":21069}]
[null,"*Information deemed reliable but not"]
[null,"guaranteed. Rates of return and cash flow"]
[null,"are not warranted or guaranteed by seller"]
[null,"or by broker. Past performance does not"]
[null,"guaranty future results."]

{"sheet":"Forecast","index":1,"n_rows":58,"n_cols":11,"rows_kept":58,"cut":false,"hidden":false,"merged":[]}
[null,null,"Name: IG - HMFI","Duplex",{"$nulls":4},"ANNUAL PROPERTY OPERATING DATA"]
[null,null,"Location: ","1269 4th Ave SE",{"$nulls":4},"Date:","2025-05-12"]
[null,"Type of Property:","Multi-Family Property",{"$nulls":4},"Purchase Price:",179000]
[null,null,"Size of Property: # Units: 8",{"$nulls":4},"Cost of Acquisition:"]
[null,"Purpose:","Owner's Statement",null,"Broker's Reconstructed",{"$nulls":4},"Price Per Unit",{"$f":"I3/2","v":89500}]
[null,null,"Existing Financing",null,"Potential Financing",{"$nulls":4},"Down Payment:",{"$f":"I3*0.25","v":44750}]
[null,null,"Seller's Position",null,"Buyer's Position"]
[null,null,"Forecast"]
[]
[null,"Existing","Balance","Payment","#Pmts/Yr","Interest","Term"]
[null,"1st"]
[null,"2nd"]
[null,"3rd"]
[null,null,"Potential:"]
[null,"1st"]
[null,"2nd"]
[{"$nulls":4},"$/sf or",null,"%"]
[null,"ALL FIGURES ANNUAL","$/unit",null,"of GOI",null,null,"Comments/Footnotes"]
[1,"POTENTIAL RENTAL INCOME",null,null,{"$f":"2900*12","v":34800},null,null,"Rent: 2900","1400 & 1500"]
[2,"Less: Vacancy & Cr Losses",null,null,{"$f":"E19*0.05","v":1740},0.05]
[3,"EFFECTIVE RENTAL INCOME",null,null,{"$f":"E19-E20","v":33060}]
[4,"Plus: Other Income"]
[5,"GROSS OPERATING INCOME",null,null,{"$f":"E21+E22","v":33060}]
[null,"OPERATING EXPENSES:"]
[6,"Real Estate Taxes",null,null,1785,2025]
[7,"Personal Property Taxes"]
[8,"Property Insurance",null,null,1998]
[9,"Off-site Management"]
[10," Management",null,null,{"$f":"E23*0.07","v":2314.2000000000003},7.0000000000000007E-2]
[11,"Expenses / Benefits"]
[12,"Taxes / Workers' Comp"]
[13,"Repairs and Maintenance",null,null,{"$f":"E21*0.1","v":3306},0.1]
[null,"Utilities"]
[14,"Electric"]
[15,"Gas",{"$nulls":4},"Tenants Pay for all utilities",null,"Water",1245.79]
[16,"Water",{"$nulls":4},"Utilities Sepreatley Metered"]
[17,"ALL COMMON COSTS",{"$nulls":6},"Gas",422.69]
[18,"Accounting and Legal"]
[19,"RE Leasing Commissions",{"$nulls":6},"Electric",2130.5100000000002]
[20,"Advertising/Licenses/Permits",null,null,750]
[21,"Supplies"]
[22,"Miscellaneous"]
[null,"Contract Services:"]
[23,"Lawn & Snow",null,null,3200]
[24,"Garbage"]
[25,"Cleaning Payroll"]
[26,"Exterminator"]
[27,"Reserves",null,null,1200]
[28]
[29,"TOTAL OPERATING EXPENSES",null,null,{"$f":"SUM(E25:E49)","v":14553.2}]
[30,"NET OPERATING INCOME",null,null,{"$f":"E23-E50","v":18506.8}]
[31,"Less:Annual Debt Service"]
[35,"CASH FLOW BEFORE TAXES",null,null,{"$f":"E51-E52","v":18506.8}]
[null,"*Information deemed reliable but not"]
[null,"guaranteed. Rates of return and cash flow"]
[null,"are not warranted or guaranteed by seller"]
[null,"or by broker. Past performance does not"]
[null,"guaranty future results."]