{"text_format":"2","workbook":"xlsx","n_sheets":1,"sheets":["Proforma"],"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":"Proforma","index":0,"n_rows":74,"n_cols":15,"rows_kept":74,"cut":false,"hidden":false,"merged":[[0,2,0,3],[0,6,0,7],[0,11,0,14],[0,16,0,19],[1,2,1,3],[1,6,1,7],[2,6,2,7],[3,8,4,8],[3,9,4,9],[10,11,10,14],[20,11,20,14],[21,16,21,19],[30,11,30,14],[40,11,40,14],[50,11,50,14],[2,2,2,3],[3,2,4,2],[3,3,4,3],[3,4,4,4],[3,5,4,5],[3,6,4,6],[3,7,4,7]]}
[353.0,"Property Name","CACHE LLC",{"$nulls":8},"Current "]
[null,"Address","191 Park Ave, Yonkers, NY 10703",{"$nulls":8},"Unit Type","Number","Rent ","Total"]
[null,"Type of Property","Garden Style Resi Apartments ETPA"]
[null,"Units",{"$f":"L1","v":"Current "},"2% Increase & 1 yr Lease","3% Increase &  2 yr Lease","Market Value | Section 8 Lease",{"$nulls":5},"Apartments",37.0,63000.0,756000.0]
[null,"Annual Operating Income",{"$nulls":9},"Garages ",26.0,7500.0,90000.0]
[null,"Rental Income",886800.0,904536.0,913404.0,1360000.0,null,null,null,{"$f":"O61","v":""},null,"Parking Lot ",14.0,2925.0,32400.0]
[{"$nulls":8},{"$f":"I6*0.08","v":0},0,null,"Washer/Dryer","2026-03-03",700.0,8400.0]
[null,"Effective Rental Income",{"$f":"C6-C7","v":886800},904536.0,913404.0,1360000.0,null,null,{"$f":"I6-I7","v":0},0,null,"Total",null,"Monthly Rent",73900.0]
[null,"Other Income",{"$nulls":11},"Annual Rent",886800.0]
[null,"Gross Operating Income",{"$f":"C8+C9","v":886800},904536.0,{"$f":"E8+E9","v":913404},1360000.0,null,null,{"$f":"I8+I9","v":0},0]
[{"$nulls":11},"Market Value | Section 8 Lease"]
[null,"Monthly Expenses",{"$nulls":9},"Unit Type","Number","Rent ","Total"]
[null,"RE Taxes",14611.13,14611.13,14611.13,14611.13,null,null,{"$f":"H13","v":""},"",null,{"$f":"L3","v":""},""]
[null,"Insurance",3656.0,3656.0,3656.0,3656.0,null,null,{"$f":"H14","v":""},"",null,{"$f":"L4","v":"Apartments"},37,65835.0,1110000.0]
[null,"Electricity & Gas",5416.0,5416.0,5416.0,5416.0,null,null,{"$f":"H15","v":""},"",null,{"$f":"L5","v":"Garages "},31.0,9300.0,111600.0]
[null,"Water and Sewer",1583.0,1583.0,1583.0,1583.0,null,null,{"$f":"H16","v":""},"",null,"Parking Lot ",20.0,4500.0,54000.0]
[null,"Waste Management","Super","Super","Super","Super",null,null,{"$f":"H17","v":""},"",null,"Washer/Dryer",{"$f":"M7","v":"2026-03-03"},700.0,8400.0]
[{"$nulls":8},{"$f":"H18","v":""},"",null,"Total",null,"Monthly Rent",113333.0]
[null,"Landscaping","Super","Super ","Super ","Super ",null,null,{"$f":"H19","v":""},"",null,null,null,"Annual Rent",1360000.0]
[null,"Pest Control",150.0,150.0,150.0,150.0,null,null,{"$f":"H20","v":""},""]
[{"$nulls":8},{"$f":"H21","v":""},"",null,"Capital Improvements 2025"]
[null,"Repairs and Maintenance  ",500.0,500.0,500.0,500.0,null,null,{"$f":"H22","v":""},""]
[null,"Misc",1800.0,1800.0,1800.0,1800.0,null,null,{"$f":"H23","v":""},"",null,null,"Roof"]
[null,"Management",{"$nulls":6},{"$f":"I8*0.08","v":0},0,null,null,"Siding"]
[{"$nulls":8},{"$f":"I8*3%","v":0},0,null,null,"Insulation"]
[null,"Expenses",{"$f":"SUM(C13:C25)","v":27716.13},27716.13,27716.13,27716.13,null,null,{"$f":"SUM(I13:I25)","v":0},0,null,null,"Water Heater "]
[{"$nulls":12},"Apartment #15 "]
[null,"Net Operating Income (NOI)"]
[null,"Total Annual Operating Income",886800.0,913380.0,920000.0,1360000.0,null,null,{"$f":"I10","v":0},0]
[null,"Total Annual Operating Expense",332581.56,332581.56,332581.56,332581.56,null,null,{"$f":"I26","v":0},0]
[null,"Net Operating Income (NOI)",{"$f":"C29-C30","v":554218.44},580798.44,587418.44,893572.0,null,null,{"$f":"I29-I30","v":0},0,null,"Capital Improvements 2025"]
[]
[null,"Initial Debt Service Ratio ",{"$nulls":10},"Asphalt"]
[null,"Debt Service Property",{"$f":"C51*12","v":0},0,0,null,null,null,{"$f":"I51*12","v":0},0,null,null,"Laundry Room"]
[null,"Debt Service Homes",{"$f":"C57*12","v":0},0,0,null,null,null,{"$f":"I57*12","v":0},0,null,null,"Striping"]
[null,"Cash Flow Before Taxes",{"$f":"C31+C35+C34","v":554218.44},580798.0,587418.44,893572.0,null,null,{"$f":"I31+I35+I34","v":0},0,null,null,"Windows"]
[null,"1/5 Share",{"$f":"C36/5","v":110843.688},116159.6,117483.688,178714.4,null,null,{"$f":"I36/4","v":0},0,null,null,"Garages"]
[null,"Add Back Principal Payments",{"$f":"-C35-(C53*C55)+-C34-(C48*C49)","v":0},0,{"$nulls":4},{"$f":"-I35-(I53*I55)","v":0},0]
[null,"Taxable Net Income",{"$nulls":6},{"$f":"I36+I38","v":0},0]
["Project Costs"]
[null,"Price",0.0,{"$f":"C41","v":0},{"$nulls":4},{"$f":"H41","v":""},"",null,"Bedroom Count"]
[null,"New Home Set Up",{"$nulls":9},"Units","Bedrooms","Bathrooms"]
[null,"CapEx",{"$nulls":9},10.0,1.0,1.0]
[null,"Total Project Cost",{"$f":"C41+C43+C42","v":0},0,{"$nulls":4},{"$f":"I41+I43+I42","v":0},0,null,15.0,1.0,2.0]
[{"$nulls":11},10.0,2.0,2.0]
["Property Mortgage",{"$nulls":10},2.0,3.0,2.0]
[null,"Down Payment",{"$nulls":6},{"$f":"I44*0.3","v":0},0]
[null,"Mortgage Balance"]
[null,"Interest Rate"]
[null,"Loan Term (Months)"]
[null,"Payment"]
[]
[null,"Mortgage Balance"]
[]
[null,"Interest Rate"]
[null,"Loan Term (Months)"]
[null,"Payment"]
[]
[null,"CAP Rate",0.055,0.058,0.059,0.081]
[null,"COC Return"]
[]
[]
[null,"Value (CAP Rate)"]
[null,5.0,{"$nulls":6},{"$f":"I31/0.05","v":0},0]
[null,6.0,{"$nulls":6},{"$f":"I31/0.06","v":0},0]
[null,7.0,{"$nulls":6},{"$f":"I31/0.07","v":0},0]
[null,8.0,{"$nulls":6},{"$f":"I31/0.08","v":0},0]
[null,9.0,{"$nulls":6},{"$f":"I31/0.09","v":0},0]
[null,10.0,{"$nulls":6},{"$f":"I31/0.1","v":0},0]
[null,11.0,{"$nulls":6},{"$f":"I31/0.11","v":0},0]
[null,12.0,{"$nulls":6},{"$f":"I31/0.12","v":0},0]
[]
[{"$nulls":8},{"$f":"I67+I53-I44","v":0},0]
[{"$nulls":8},{"$f":"I73/4","v":0},0]