{"text_format":"2","workbook":"xlsx","n_sheets":2,"sheets":["Stabilized","Stabilized Details"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":15,"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":"Stabilized","index":0,"n_rows":35,"n_cols":9,"rows_kept":35,"cut":false,"hidden":false,"merged":[[24,0,24,3],[31,0,31,4],[40,3,40,4],[0,0,0,1],[1,0,1,1],[1,2,1,3],[3,0,3,3],[3,5,3,8],[14,0,14,3],[22,5,22,8]]}
["Central 12",null,null,null,"KEY","Edit the yellow cells"]
["Financial Overview ",null,{"$f":"TODAY()","v":"2026-03-09"}]
[]
["PROPERTY SUMMARY",{"$nulls":4},"PROPERTY INCOME: STABILIZED"]
[null,null,"Total","$ Per Unit"]
["Number of units",null,12.0,{"$nulls":4},"Annual","Per Unit Avg"]
["Purchase Price",null,1350000.0,{"$f":"C7/C6","v":112500},null,"Gross Potential Rent",null,{"$f":"E35","v":165600},{"$f":"H7/$C$6","v":13800}]
["Retrofit Cost","ADD WD in unit",60000.0,{"$f":"C8/C6","v":5000},null,"Other Income",null,{"$f":"'Stabilized Details'!D5","v":13680},1140]
[{"$nulls":5},"Gross Potential Income",null,{"$f":"H7+H8","v":179280},14940]
[{"$nulls":5},"Vacancy Loss @",{"$f":"'Stabilized Details'!B7","v":0.05},{"$f":"'Stabilized Details'!D7","v":-8280},-690]
[{"$nulls":5},"Effective Gross Income",null,{"$f":"H9+H10","v":171000},14250]
[{"$nulls":5},"Less: Expenses",null,{"$f":"'Stabilized Details'!D16","v":-62920},-5243.333333]
["Total",null,{"$f":"SUM(C7:C12)","v":1410000},117500,null,"Net Operating Income",null,{"$f":"SUM(H11:H12)","v":108080}]
[{"$nulls":5},"Cap Rate",null,{"$f":"H13/C13","v":0.07665248227}]
["FINANCING ASSUMPTIONS",{"$nulls":4},"Annual Debt Service",null,{"$f":"-C23","v":-83712.04411}]
[{"$nulls":5},"Operating Cash Flow",null,{"$f":"H15+H13","v":24367.95589}]
["Initial Equity",null,{"$f":"(1-C19)*C13","v":352500},null,null,"Debt Service Coverage Ratio",null,{"$f":"-H13/H15","v":1.291092592}]
["Loan Amount",null,{"$f":"C19*C13","v":1057500},null,null,"Gross Rent Multiplier",null,{"$f":"C13/H9","v":7.864792503}]
["Loan-to-Value",null,0.75,null,null,"Internal Rate of Return",null,{"$f":"'Stabilized Details'!L11","v":0.2664409134}]
[{"$nulls":5},"Year 1 Cash-on-Cash Return",null,{"$f":"H16/C17","v":0.06912895288}]
["Interest Rate",null,0.0625,null,null,"First Year Principal Reduction ",null,{"$f":"CUMPRINC('Stabilized Details'!L18/12,'Stabilized Details'!O20,'Stabilized Details'!L17,1,12,0)","v":-18131.85036}]
["Amortization",null,25.0,"YR"]
["Annual Payment",null,{"$f":"'Stabilized Details'!O25","v":83712.04411},null,null,"DISPOSITION"]
[{"$nulls":5},"Anticipated Sale Year",null,null,"Year 5"]
["ACQUISITION / DISPOSITION TIMELINE",{"$nulls":4},"Cap Rate at Sale",null,null,{"$f":"'Stabilized Details'!D26","v":0.06}]
[{"$nulls":5},"Sale Price Per Unit",null,null,{"$f":"'Stabilized Details'!D27/C6","v":167317.0357}]
["Acquisition Month/Year",null,{"$f":"C2+60","v":"2026-05-08"},null,null,"Gross Cap of Proforma Yr NOI",null,null,{"$f":"'Stabilized Details'!D27","v":2007804.429}]
["Months to Stabilization",null,12.0,null,null,"Net Proceeds (Minus Equity Invested)",null,null,{"$f":"'Stabilized Details'!D32","v":580432.7546}]
["Anticipated Hold after Stabilization",null,"5 years",null,null,"Yield on Equity",null,null,{"$f":"I28/C17","v":1.646617744}]
[]
[]
["Unit Mix / Rent Schedule"]
["Units","Type","SF","Mkt Rent","Annual Rent"]
[12.0,"1BR 1BA",740.0,1150.0,{"$f":"(D34*12)*A34","v":165600}]
[{"$f":"SUM(A34)","v":12},null,null,null,{"$f":"sum(E34)","v":165600}]

{"sheet":"Stabilized Details","index":1,"n_rows":39,"n_cols":15,"rows_kept":39,"cut":false,"hidden":false,"merged":[[0,0,0,1],[0,4,0,5],[1,8,1,13],[10,8,10,10]]}
[{"$f":"Stabilized!A1","v":"Central 12"},null,null,"KEY","Edit the yellow cells"]
["Snapshot",{"$nulls":4},"Yr 5",null,null,"IRR"]
[null,"Assumptions",null,"Stabilized","GPR","Proforma","GPR",null,"EOY","Cash Flows","+","Sale Proceeds","Total","Return"]
["Gross Potential Rent",null,null,{"$f":"Stabilized!H7","v":165600},null,{"$f":"(D4*(1+D$38))*(1+D$38)*(1+D$38)*(1+D$38)","v":184581.2806},null,null,"0",{"$f":"-Stabilized!C17","v":-352500},null,null,{"$f":"-Stabilized!C17","v":-352500}]
["Other Inc avg: Pet, Park, Trash, Water",95.0,null,{"$f":"B5*12*Stabilized!C6","v":13680},null,15248.01883,null,null,1.0,{"$f":"Stabilized!H16","v":24367.95589},"+",null,{"$f":"J5+L5","v":24367.95589},{"$f":"M5/Stabilized!$C$17","v":0.06912895288}]
["Gross Potential Income",null,null,{"$f":"SUM(D4:D5)","v":179280},null,{"$f":"F5+F4","v":199829.2994},null,null,2.0,{"$f":"J5*(1+'Stabilized Details'!D$38)","v":25038.07468},"+",null,25038.07468,{"$f":"M6/Stabilized!$C$17","v":0.07102999909}]
["Less: Vacancy %",0.05,null,{"$f":"B7*-D4","v":-8280},{"$f":"B7","v":0.05},{"$f":"B7*-F4","v":-9229.064028},{"$f":"B7","v":0.05},null,3.0,{"$f":"J6*(1+'Stabilized Details'!D$38)","v":25726.62173},"+",null,25726.62173,{"$f":"M7/Stabilized!$C$17","v":0.07298332406}]
["Effective Gross Income",null,null,{"$f":"SUM(D6:D7)","v":171000},null,{"$f":"SUM(F6:F7)","v":190600.2354},null,null,4.0,{"$f":"J7*(1+'Stabilized Details'!D$38)","v":26434.10383},"+",null,26434.10383,{"$f":"M8/Stabilized!$C$17","v":0.07499036548}]
[{"$nulls":8},5.0,{"$f":"J8*(1+'Stabilized Details'!D$38)","v":27161.04169},"+",{"$f":"'Stabilized Details'!D31","v":932932.7546},960093.7963,{"$f":"M9/Stabilized!$C$17","v":2.723670344}]
["Real Estate Taxes","2025 Actual",null,-11760.0,{"$f":"-D10/$D$8","v":0.06877192982},{"$f":"(D10*(1+D$39))*(1+D$39)*(1+D$39)*(1+D$39)","v":-13107.94601},{"$f":"-F10/$F$8","v":0.06877192982},{"$nulls":5},{"$f":"SUM(M4:M9)","v":709160.5524}]
["Property Insurance","$900 per unit",null,-10800.0,0.06315789474,-12037.9096,0.06315789474,null,"IRR",null,null,{"$f":"IRR(M4:M9)","v":0.2664409134}]
["Utilities: Vacant, Common Utils","Est",null,-8725.0,0.05102339181,-9725.070488,0.05102339181]
["Management @",0.08,null,{"$f":"-($D$8*B13)","v":-13680},0.08,-15248.01883,0.08]
["Leasing @",0.015,null,-2565,0.015,-2859.00353,0.015]
["Maintenance @",0.09,null,-15390,0.09,-17154.02118,0.09]
["Total Expenses:",null,null,{"$f":"SUM(D10:D15)","v":-62920},{"$f":"SUM(E7:E15)","v":0.4179532164},-70131.96964,{"$f":"SUM(G7:G15)","v":0.4179532164},null,null,"LOAN DATA"]
[{"$nulls":10},"Loan amount:",{"$f":"+Stabilized!$C$18","v":1057500}]
["NOI",null,null,{"$f":"D8+D16","v":108080},null,{"$f":"F8+F16","v":120468.2657},{"$nulls":4}," **Annual interest rate:",{"$f":"Stabilized!C21","v":0.0625}]
["Cap Rate to Cost",null,null,{"$f":"D18/Stabilized!C13","v":0.07665248227},null,{"$f":"F18/Stabilized!C13","v":0.08543848632},{"$nulls":4},"Term in years:",{"$f":"Stabilized!C22","v":25}]
["Annual Debt Service",null,null,{"$f":"-Stabilized!C23","v":-83712.04411},null,{"$f":"-Stabilized!C23","v":-83712.04411},{"$nulls":4},"Payments per year:",12.0,null,"Total Payments",{"$f":"L19*L20","v":300}]
["Operating Cash Flow",null,null,{"$f":"D18+D20","v":24367.95589},null,{"$f":"F18+F20","v":36756.22161},{"$nulls":4},"First payment due:",{"$f":"Stabilized!$C$27","v":"2026-05-08"},null,"Periodic Rate",{"$f":"L18/L20","v":0.005208333333}]
["Cash-on-Cash Return",null,null,{"$f":"D21/Stabilized!C17","v":0.06912895288},null,{"$f":"F21/Stabilized!C17","v":0.1042729691}]
[{"$nulls":9},"PERIODIC PAYMENT"]
[{"$nulls":10},"Entered payment:",0.0]
["DISPOSITION",{"$nulls":9},"Calculated payment:",{"$f":"PMT($O$21,$O$20,-$L$17)","v":6976.003676},null,"Annual Payment",{"$f":"L25*L20","v":83712.04411}]
["Anticipated Cap Rate at Sale",null,null,0.06]
["Gross Cap of Proforma YR NOI",null,null,{"$f":"F18/D26","v":2007804.429}]
["Disposition Costs @",0.06,null,{"$f":"-B28*D27","v":-120468.2657}]
["Net Sale Proceeds befor eTax and Debt Repayment",null,null,{"$f":"D27+D28","v":1887336.163}]
["Less Loan Principal Remaining",null,null,{"$f":"-FV($L$18/12,60,$L$25,-$L$17,0)","v":-954403.4083}]
["Net Sales Proceeds (After Debt)",null,null,{"$f":"D29+D30","v":932932.7546}]
["Net Profit (Minus Equity) **",null,null,{"$f":"D31-Stabilized!C17","v":580432.7546}]
["Yield on Equity",null,null,{"$f":"D32/Stabilized!C17","v":1.646617744}]
[]
["Notes: "]
["*Anticipated Sale Year"]
["**Does not take operating cash flow into consideration"]
["Global Annual Income Growth Rate",null,null,0.0275]
["Global Annual Expense Growth Rate ",null,null,0.0275]