{"text_format":"2","workbook":"xlsx","n_sheets":1,"sheets":["Pro Forma"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":1,"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":"Pro Forma","index":0,"n_rows":46,"n_cols":6,"rows_kept":46,"cut":false,"hidden":false,"merged":[[3,1,3,5],[20,1,20,5],[29,1,29,5],[6,1,6,5],[1,1,1,5],[15,1,15,5],[2,1,2,5],[4,1,4,5],[44,1,44,5],[45,1,45,5],[35,1,35,5]]}
[]
[null,"CK SELECT COMMERCIAL REAL ESTATE"]
[null,"INVESTOR PRO FORMA"]
[null,"1129–1135 Kenly Street  |  Salisbury, NC 28144  |  4-Home SFR Portfolio"]
[]
[]
[null,"KEY ASSUMPTIONS  (blue cells = inputs you can change)"]
[null,"Purchase Price",940000,"Per Unit",235000]
[null,"Number of Units",4,"SF Per Unit",1181]
[null,"Est. Rent Per Unit/Mo",1725,"Year Built",2026,"Source: Local rental comps, March 2026"]
[null,"Vacancy Rate",0.05,"Down Payment",0.25]
[null,"Mgmt Fee (% of rent)",0.1,"Interest Rate",0.075]
[null,"Maintenance Reserve/Unit",1200,"Loan Term (yrs)",30]
[null,"Annual Insurance",6000,"Annual Taxes",5000]
[]
[null,"INCOME"]
[null,"Gross Rental Income (Annual)",{"$f":"C9*C10*12","v":null}]
[null,"Less: Vacancy Allowance",{"$f":"-C17*C11","v":null}]
[null,"Effective Gross Income (EGI)",{"$f":"C17+C18","v":null}]
[]
[null,"OPERATING EXPENSES"]
[null,"Property Taxes (Annual)",{"$f":"E14","v":null}]
[null,"Insurance (Annual)",{"$f":"C14","v":null}]
[null,"Property Management",{"$f":"C9*C10*12*C12","v":null}]
[null,"Maintenance Reserve",{"$f":"C9*C13","v":null}]
[null,"Total Operating Expenses",{"$f":"SUM(C22:C25)","v":null}]
[]
[null,"NET OPERATING INCOME (NOI)",{"$f":"C19-C26","v":null}]
[]
[null,"FINANCING"]
[null,"Down Payment Amount",{"$f":"C8*E11","v":null}]
[null,"Loan Amount",{"$f":"C8-C31","v":null}]
[null,"Monthly P&I Payment",{"$f":"IFERROR(PMT(E12/12,E13*12,-C32),0)","v":null}]
[null,"Annual Debt Service",{"$f":"C33*12","v":null}]
[]
[null,"RETURN METRICS"]
[null,"Cap Rate",{"$f":"IFERROR(C28/C8,0)","v":null}]
[null,"Gross Yield",{"$f":"IFERROR(C17/C8,0)","v":null}]
[null,"Cash Flow Before Tax (Annual)",{"$f":"C28-C34","v":null}]
[null,"Cash-on-Cash Return",{"$f":"IFERROR((C28-C34)/C31,0)","v":null}]
[null,"DSCR",{"$f":"IFERROR(C28/C34,0)","v":null}]
[null,"Price Per Unit",{"$f":"C8/C9","v":null}]
[null,"Price Per SF",{"$f":"C8/(C9*C10)","v":null}]
[]
[null,"Kirk Hanson, Broker  |  704-791-9469     Rodney Green, Broker  |  704-787-4608  |  greengrp.net     CK Select Commercial Real Estate"]
[null,"Information deemed reliable but not guaranteed. All projections are estimates based on current market conditions and are not a guarantee of future performance."]