{"text_format":"2","workbook":"xlsx","n_sheets":3,"sheets":["2025 Finanacials","4plex ProForma","4plex ProForma Self-Managed"],"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":"2025 Finanacials","index":0,"n_rows":58,"n_cols":11,"rows_kept":58,"cut":false,"hidden":false,"merged":[]}
[null,null,"Name:","2120 4th Ave 4Plex",{"$nulls":4},"ANNUAL PROPERTY OPERATING DATA"]
[null,null,"Location:","2120 4th Ave, Marion, IA, 52302",{"$nulls":4},"Date:"]
[null,"Type of Property:","Multi-Family Property",{"$nulls":4},"Purchase Price:",null,260000]
[null,null,"Size of Property: # Units: 4",{"$nulls":4},"Cost of Acquisition:",null,0]
[null,"Purpose:","Owner's Statement",null,"Broker's Reconstructed",null,null,"Pricer Per Unit",null,{"$f":"J3/4","v":65000}]
[null,null,"Existing Financing",null,"Potential Financing",null,null,"Down Payment: 25%",null,{"$f":"J3*0.25","v":65000}]
[null,null,"Seller's Position",null,"Buyer's Position"]
[null,null,"Forecast"]
[]
[null,"Existing","Balance","Payment","#Pmts/Yr","Interest","Term"]
[null,"1st",{"$nulls":7},"Dwelling Value"]
[null,"2nd",{"$nulls":6},"Improvement"]
[null,"3rd"]
[null,null,"Potential:",{"$nulls":5},"TOTAL",null,1]
[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,31020,null,null,"Rents currently at $650, $675, $675, $585"]
[2,"Less: Vacancy & Cr Losses",null,null,0]
[3,"EFFECTIVE RENTAL INCOME",null,null,{"$f":"E19-E20","v":31020}]
[4,"Plus: Other Income",null,null,916,null,"Laundry and water/trash RUB"]
[5,"GROSS OPERATING INCOME",null,null,{"$f":"E21+E22","v":31936}]
[null,"OPERATING EXPENSES:"]
[6,"Real Estate Taxes",null,null,3636]
[7,"Personal Property Taxes"]
[8,"Property Insurance",null,null,2090]
[9,"Off-site Management",null,null,1861]
[10," Management"]
[11,"Expenses / Benefits"]
[12,"Taxes / Workers' Comp"]
[13,"Repairs and Maintenance",null,null,3244]
[null,"Utilities"]
[14,"Electric",null,null,961,null,"Owner pays common electric."]
[15,"Gas",null,null,0,null,"Baseboard Heat"]
[16,"Water",null,null,3749,null,"Water paid for by seller. Figure includes water, sewer, water softener, and city trash. "]
[17,"ALL COMMON COSTS"]
[18,"Accounting and Legal",null,null,150]
[19,"RE Leasing Commissions"]
[20,"Advertising/Licenses/Permits"]
[21,"Supplies",null,null,152]
[22,"Miscellaneous"]
[null,"Contract Services:"]
[23,"Lawn & Snow",null,null,402]
[24,"Garbage",null,null,0,null,"Trash built into water and sewer bill. "]
[25,"Cleaning Payroll",null,null,0]
[26,"Exterminator",null,null,647,null,"No pest issues. Just preventitive. "]
[27,"Reserves"]
[28]
[29,"TOTAL OPERATING EXPENSES",null,null,{"$f":"SUM(E25:E49)","v":16892}]
[30,"NET OPERATING INCOME",null,null,{"$f":"E23-E50","v":15044}]
[31,"Less:Annual Debt Service"]
[35,"CASH FLOW BEFORE TAXES",null,null,{"$f":"E51-E52","v":15044},null,null,{"$f":"E53/260000","v":5.7861538461538464E-2}]
[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":"4plex ProForma","index":1,"n_rows":58,"n_cols":11,"rows_kept":58,"cut":false,"hidden":false,"merged":[]}
[null,null,"Name:","2120 4th Ave 4Plex",{"$nulls":4},"ANNUAL PROPERTY OPERATING DATA"]
[null,null,"Location:","2120 4th Ave, Marion, IA, 52302",{"$nulls":4},"Date:"]
[null,"Type of Property:","Multi-Family Property",{"$nulls":4},"Purchase Price:",null,260000]
[null,null,"Size of Property: # Units: 4",{"$nulls":4},"Cost of Acquisition:",null,0]
[null,"Purpose:","Owner's Statement",null,"Broker's Reconstructed",null,null,"Pricer Per Unit",null,{"$f":"J3/4","v":65000}]
[null,null,"Existing Financing",null,"Potential Financing",null,null,"Down Payment: 25%",null,{"$f":"J3*0.25","v":65000}]
[null,null,"Seller's Position",null,"Buyer's Position"]
[null,null,"Forecast"]
[]
[null,"Existing","Balance","Payment","#Pmts/Yr","Interest","Term"]
[null,"1st",{"$nulls":7},"Dwelling Value"]
[null,"2nd",{"$nulls":6},"Improvement"]
[null,"3rd"]
[null,null,"Potential:",{"$nulls":5},"TOTAL",null,1]
[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,36000,null,"Rents Stabalized at $750"]
[2,"Less: Vacancy & Cr Losses",null,null,{"$f":"E19*0.05","v":1800},0.05]
[3,"EFFECTIVE RENTAL INCOME",null,null,{"$f":"E19-E20","v":34200}]
[4,"Plus: Other Income",null,null,1800,null,"Laundry and estimated water/trash RUB"]
[5,"GROSS OPERATING INCOME",null,null,{"$f":"E21+E22","v":36000}]
[null,"OPERATING EXPENSES:"]
[6,"Real Estate Taxes",null,null,4709]
[7,"Personal Property Taxes"]
[8,"Property Insurance",null,null,1987]
[9,"Off-site Management",null,null,{"$f":"E19*0.07","v":2520.0000000000005},"Spire Management Fee 7%"]
[10," Management"]
[11,"Expenses / Benefits"]
[12,"Taxes / Workers' Comp"]
[13,"Repairs and Maintenance",null,null,{"$f":"0.1*E19","v":3600},0.1]
[null,"Utilities"]
[14,"Electric",null,null,961,null,"Owner pays common electric."]
[15,"Gas",null,null,0,null,"No gas on property."]
[16,"Water",null,null,3800,null,"Water paid for by seller. Figure includes water, sewer, water softener, and city trash. "]
[17,"ALL COMMON COSTS"]
[18,"Accounting and Legal",null,null,150]
[19,"RE Leasing Commissions"]
[20,"Advertising/Licenses/Permits"]
[21,"Supplies",null,null,152]
[22,"Miscellaneous"]
[null,"Contract Services:"]
[23,"Lawn & Snow",null,null,402]
[24,"Garbage",null,null,0,null,"Trash built into water and sewer bill. "]
[25,"Cleaning Payroll",null,null,0]
[26,"Exterminator",null,null,0]
[27,"Reserves"]
[28]
[29,"TOTAL OPERATING EXPENSES",null,null,{"$f":"SUM(E25:E49)","v":18281}]
[30,"NET OPERATING INCOME",null,null,{"$f":"E23-E50","v":17719}]
[31,"Less:Annual Debt Service"]
[35,"CASH FLOW BEFORE TAXES",null,null,{"$f":"E51-E52","v":17719}]
[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":"4plex ProForma Self-Managed","index":2,"n_rows":58,"n_cols":11,"rows_kept":58,"cut":false,"hidden":false,"merged":[]}
[null,null,"Name:","2120 4th Ave 4Plex",{"$nulls":4},"ANNUAL PROPERTY OPERATING DATA"]
[null,null,"Location:","2120 4th Ave, Marion, IA, 52302",{"$nulls":4},"Date:"]
[null,"Type of Property:","Multi-Family Property",{"$nulls":4},"Purchase Price:",null,260000]
[null,null,"Size of Property: # Units: 4",{"$nulls":4},"Cost of Acquisition:",null,0]
[null,"Purpose:","Owner's Statement",null,"Broker's Reconstructed",null,null,"Pricer Per Unit",null,{"$f":"J3/4","v":65000}]
[null,null,"Existing Financing",null,"Potential Financing",null,null,"Down Payment: 25%",null,{"$f":"J3*0.25","v":65000}]
[null,null,"Seller's Position",null,"Buyer's Position"]
[null,null,"Forecast"]
[]
[null,"Existing","Balance","Payment","#Pmts/Yr","Interest","Term"]
[null,"1st",{"$nulls":7},"Dwelling Value"]
[null,"2nd",{"$nulls":6},"Improvement"]
[null,"3rd"]
[null,null,"Potential:",{"$nulls":5},"TOTAL",null,1]
[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,36000,null,"Rents Stabalized at $750"]
[2,"Less: Vacancy & Cr Losses",null,null,{"$f":"E19*0.05","v":1800},0.05]
[3,"EFFECTIVE RENTAL INCOME",null,null,{"$f":"E19-E20","v":34200}]
[4,"Plus: Other Income",null,null,1800,null,"Laundry and estimated water/trash RUB"]
[5,"GROSS OPERATING INCOME",null,null,{"$f":"E21+E22","v":36000}]
[null,"OPERATING EXPENSES:"]
[6,"Real Estate Taxes",null,null,4709]
[7,"Personal Property Taxes"]
[8,"Property Insurance",null,null,1987]
[9,"Off-site Management",null,null,0]
[10," Management"]
[11,"Expenses / Benefits"]
[12,"Taxes / Workers' Comp"]
[13,"Repairs and Maintenance",null,null,{"$f":"0.1*E19","v":3600},0.1]
[null,"Utilities"]
[14,"Electric",null,null,961,null,"Owner pays common electric."]
[15,"Gas",null,null,0,null,"No gas on property."]
[16,"Water",null,null,3800,null,"Water paid for by seller. Figure includes water, sewer, water softener, and city trash. "]
[17,"ALL COMMON COSTS"]
[18,"Accounting and Legal",null,null,150]
[19,"RE Leasing Commissions"]
[20,"Advertising/Licenses/Permits"]
[21,"Supplies",null,null,152]
[22,"Miscellaneous"]
[null,"Contract Services:"]
[23,"Lawn & Snow",null,null,0]
[24,"Garbage",null,null,0,null,"Trash built into water and sewer bill. "]
[25,"Cleaning Payroll",null,null,0]
[26,"Exterminator",null,null,0]
[27,"Reserves"]
[28]
[29,"TOTAL OPERATING EXPENSES",null,null,{"$f":"SUM(E25:E49)","v":15359}]
[30,"NET OPERATING INCOME",null,null,{"$f":"E23-E50","v":20641}]
[31,"Less:Annual Debt Service"]
[35,"CASH FLOW BEFORE TAXES",null,null,{"$f":"E51-E52","v":20641}]
[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."]