{"text_format":"2","workbook":"xlsx","n_sheets":2,"sheets":["CashFlow","Rent Roll"],"not_rendered":{"charts":0,"images":1,"macros":0,"external_links":0,"defined_names":4,"comments":1,"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":"CashFlow","index":0,"n_rows":59,"n_cols":6,"rows_kept":59,"cut":false,"hidden":false,"merged":[[0,2,0,3],[12,5,12,7],[13,5,13,7],[14,5,14,7],[15,5,15,7]]}
[null,"75 Clark St New Britain "]
[]
[]
[null,"Monthly Operating Income","As Is ","Pro Forma ",null,"ALL UTILITIES INCLUDED (Heat , Electric and hot water) "]
[null,"Number of Units",11.0,11.0,"9 -  1 Bedrooms","Pro Forma: $1350"]
[null,"Average Monthly Rent per Unit",{"$f":"C7/11","v":1229.090909},1386.36,"2 - 2 Bedrooms ","Pro Forma : $1550"]
[null,"Total Rental Income",13520.0,{"$f":"sum(D5*D6)","v":15249.96}]
[null,"% Vacancy and Credit Losses",0.05,0.05]
[null,"Total Vacancy Loss",{"$f":"C7*C8","v":676},{"$f":"D8*D7","v":762.498}]
[null,"Other Monthly Income (laundry, vending, parking, etc.)",200.0,200.0,"2 Pet Fees, 1 M2M Fee"]
[null,"Gross Monthly Operating Income",{"$f":"C7-C9+C10","v":13044},14687.462]
[]
[null,"Monthly Operating Expenses",null,null,null,"Gas payoff started: October 2025"]
[null,"Property Management Fees",{"$f":"C9","v":676},{"$f":"D11*0.05","v":734.3731},null,"Amount: $1,971 / mo"]
[null,"Repairs and Maintenance",{"$f":"C9","v":676},{"$f":"D11*0.05","v":734.3731},null,"Owners will payoff at closing"]
[null,"Real Estate Taxes",1953.87,1953.87,null,"Remaining Balance: $27,093.17 "]
[null,"Rental Property Insurance",825.0,825.0]
[null,"Landscaping ",100.0,100.0]
[null,"Cleaning ",200.0,200.0]
[null,"Common Utilities"]
[null,"- Water and Sewer",654.58,654.58]
[null,"- Garbage",319.0,319.0]
[null,"- Electric",1056.25,1056.25]
[null,"- Heat  ",484.71,484.71]
[null,"Pest Control"]
[null,"Advertising"]
[null,"Monthly Operating Expenses",{"$f":"SUM(C14:C26)","v":6945.41},7062.1562]
[]
[null,"Net Operating Income (NOI)"]
[null,"Total Annual Operating Income",{"$f":"C11*12","v":156528},176249.544]
[null,"Total Annual Operating Expense",{"$f":"C27*12","v":83344.92},84745.8744]
[null,"Annual Net Operating Income",{"$f":"C30-C31","v":73183.08},91503.6696]
[]
[null,"Capitalization Rate and Valuation"]
[null,"Desired Capitalization Rate",0.07,0.07]
[null,"Property Valuation (Offer Price)",{"$f":"IF(C35=0,\" - \",C32/C35)","v":1045472.571},1307195.28]
[null,"Actual Purchase Price",1050000.0,1050000.0]
[null,"Actual Capitalization Rate",{"$f":"IF(C37=0,\" - \",C32/C37)","v":0.06969817143},0.087146352]
[]
[null,"Loan Information"]
[null,"Down Payment",{"$f":"C37*0.25","v":262500},262500,"25% Down"]
[null,"Loan Amount",{"$f":"C37-C41","v":787500},787500,"75% LTV"]
[null,"Acquisition Costs and Loan Fees",{"$f":"C37*0.0075","v":7875},7875,".75% of Ask Price"]
[null,"Length of Mortgage (years)",30.0,30.0]
[null,"Annual Interest Rate",0.0625,0.0625]
[null,"Initial Investment",{"$f":"C41+C43","v":270375},270375]
[null,"Monthly Mortgage Payment (PI)",{"$f":"IF(C42=0,0,-PMT(C45/12,C44*12,C42))","v":4848.772953},4848.772953]
[null,"Annual Interest",{"$f":"IF(C42=0,0,-CUMIPMT(C45/12,C44*12,C42,1,12,0))","v":48957.38445},48957.38445]
[null,"Annual Principal",{"$f":"IF(C42=0,0,-CUMPRINC(C45/12,C44*12,C42,1,12,0))","v":9227.890993},9227.890993]
[null,"Total Annual Debt Service",{"$f":"C47*12","v":58185.27544},58185.27544]
[null,"DEBT SERVICE RATIO",{"$f":"C32/C50","v":1.257759449},1.572625873]
[]
[null,"Cash Flow and ROI"]
[null,"Total Monthly Cash Flow",{"$f":"C11-C27-C47","v":1249.817047},2776.532847]
[null,"Total Annual Cash Flow",{"$f":"C32-C50","v":14997.80456},33318.39416]
[null,"Cash on Cash Return (ROI)",{"$f":"IF(C46=0,\" \",C55/C46)","v":0.0554703821},0.1232303066]
[]
[null,"Note: This spreadsheet should only be used for informational and educational purposes. Please verify"]
[null,"calculations and seek professional assistance before making financial decisions."]

{"sheet":"Rent Roll","index":1,"n_rows":13,"n_cols":7,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
["Unit Number","Size","Current Rent","Pro Forma","Subsidized","Notes","Lease Dates"]
[1.0,null,1050.0]
[2.0,null,1150.0,null,null,"M2M"]
[3.0,null,1275.0,null,null,"M2M"]
[4.0,null,1250.0,null,null,"M2M"]
[5.0,null,1250.0]
[6.0,null,1125.0,1150.0,null,"1,150 STARTING 2/1/26"]
[7.0,null,1295.0]
[8.0,null,1350.0,null,1071.0,"M2M, HAP CONTRACT (TENANT PAYS DIFFERENCE (279))"]
[9.0,null,1200.0]
[10.0,null,1350.0,null,1188.0,"HAP CONTRACT (TENANT PAYS DIFFERENCE (162))"]
[11.0,null,1225.0]
[null,null,{"$f":"SUM(C2:C12)","v":13520}]