{"text_format":"2","workbook":"xlsx","n_sheets":2,"sheets":["Rent Roll","Overview"],"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":"Rent Roll","index":0,"n_rows":74,"n_cols":15,"rows_kept":74,"cut":false,"hidden":false,"merged":[[12,1,12,7]]}
[null,"23 Ryan"]
[null,"Tenant Name","Other Tenants","Address ","Location","Size","Unit","Accounts Payable","SD","Utilities Covered","Lease Expiration","Rent ","2025-08-01","Market Rent","Note"]
[null,"Sub 90 Golf",null,null,null,"office 1,2,3 - 1200 SQ FT","FL 2",null,7000,null,"2029-03-31",3622.5,null,4000]
[null,"J.F Hughes",null,null,null,"Garage - 1620 SQ FT","Fl 1",null,6600,null,"2026-11-30",3300,null,3800]
[null,"Vacant",{"$nulls":4},"FL 2",{"$nulls":4},0,null,3800]
[null,"Owner Occupied",null,null,null,"Garage","FL 1",{"$nulls":4},0,null,1600]
[]
[null,"CAM Charges","All tenants (adjusted)",null,null,"CAM","CAM",null,null,"Common Area Maintenance ",null,2251,null,3696]
[{"$nulls":5},"TOTAL / MO",null,{"$f":"SUM(H3:H8)","v":0},13600,null,null,{"$f":"SUM(L3:L8)","v":9173.5},0,16896]
[{"$nulls":5},"TOTAL / ANNUAL",{"$nulls":5},{"$f":"L9*12","v":110082},0,202752]
[]
[]
[{"$nulls":9},"Expenses",null,"Current ",null,"Market"]
[{"$nulls":9},"Property Management",null,1440,null,2000]
[{"$nulls":9},"Property Tax",null,17663,null,18000]
[{"$nulls":9},"Insurance",null,3100,null,3200]
[{"$nulls":9},"Legal, Professional & Accounting",null,1000,null,1500]
[{"$nulls":9},"Brokerage Leasing Fee",null,0,null,0]
[{"$nulls":9},"Supplies & Materials"]
[{"$nulls":9},"Repairs & Maintenance (2.5%)",null,{"$f":"0.025*L10","v":2752.05},null,{"$f":"0.025*N10","v":5068.8}]
[{"$nulls":9},"Utilities - (Fire Alarm)",null,830,null,1200]
[{"$nulls":9},"Bank & Misc Financing Fees",null,200,null,500]
[{"$nulls":9},"Snow & Landscaping & Trash",null,1445,null,1800]
[]
[{"$nulls":9},"Total Expenses",null,{"$f":"SUM(L14:L24)","v":28430.05},null,{"$f":"SUM(N14:N24)","v":33268.800000000003}]
[]
[{"$nulls":9},"NOI",null,{"$f":"L10-L25","v":81651.95},null,{"$f":"N10-N25","v":169483.2}]
[{"$nulls":9},"(-) Vacancy 5%",null,{"$f":"0.05*L10","v":5504.1},null,{"$f":"0.05*N10","v":10137.6}]
[{"$nulls":9},"Adjusted NOI",null,{"$f":"L27-L28","v":76147.849999999991},null,{"$f":"N27-N28","v":159345.60000000001}]
[]
[{"$nulls":9},"Debt Service Current",null,{"$f":"D18*0.08","v":0},null,{"$f":"L31","v":0}]
[{"$nulls":9},"Net Cash Flow",null,{"$f":"L29-L31","v":76147.849999999991},null,{"$f":"N29-N31","v":159345.60000000001}]
[]
[]
[{"$nulls":9},"Mortgage Estimate P&I",null,{"$f":"PRODUCT(7700,12)","v":92400},null,{"$f":"L35","v":92400}]
[{"$nulls":9},"Net Cash Flow",null,{"$f":"L27-L35","v":-10748.050000000003},null,{"$f":"N27-N35","v":77083.200000000012}]
[]
[{"$nulls":9},"Value",null,1500000,null,1550000]
[]
[{"$nulls":9},"Purchase Total",null,1500000,null,{"$f":"N38+N39","v":1550000}]
[]
[{"$nulls":9},"Loan",null,{"$f":"L38*0.75","v":1125000},null,1150000]
[]
[]
[]
[{"$nulls":9},"Cap Rate",null,{"$f":"L29/L40","v":5.0765233333333326E-2},null,{"$f":"N29/N40","v":0.10280361290322582}]
{"$rows_empty":16}
[null,"Value",705000]
[null,"70% LTV",{"$f":"C63*0.75","v":528750}]
[null,"Repayment of Debt",440000]
[null,"Prepayment",4400]
[null,"intercompany Loans",0]
[null,"TOTAL",{"$f":"C64-C65-C66-C67","v":84350}]
[null,"Closing Costs",{"$f":"3%*C64","v":15862.5}]
[null,"Legal",1000]
[null,"Net Proceeds",{"$f":"C68-C69-C70","v":67487.5}]
[]
[null,"BB",{"$f":"C71*D73","v":16871.875},0.25]
[null,"Investor",{"$f":"D74*C71","v":50615.625},0.75]

{"sheet":"Overview","index":1,"n_rows":20,"n_cols":6,"rows_kept":20,"cut":false,"hidden":true,"merged":[]}
[]
[]
[null,"OFFER",null,"VALUATION CURRENT",null,"VALUATION OPTIMSTIC"]
["$",700000,null,750000,{"$f":"(D4-B4)/B4","v":7.1428571428571425E-2},800000]
["DEBT",440000,null,440000,null,440000]
["MEZ",0,null,0]
[]
["EQUITY",{"$f":"B4-B5-B6","v":260000},null,{"$f":"D4-D5-D6","v":310000}]
[0.75,{"$f":"A9*B8","v":195000},0.75,{"$f":"C9*D8","v":232500}]
[0.25,{"$f":"A10*B8","v":65000},0.25,{"$f":"C10*D8","v":77500}]
[]
[]
[]
[]
["ASK","Passive Involvement",3,"Passive Involvement (none)",3]
[null,"Free up cash for other opportunities",2,"Free up cash for other opportunities",2]
[null,"Defer Capital Gain",2,"Defer Capital Gain",1]
[null,"Maintain Upside of Property",3,"Maintain Upside of Property",1]
[null,"Benefit from Strong & Stabilized Yield",2,"Benefit from Strong & Stabilized Yield",1]
[null,null,{"$f":"SUM(C15:C19)","v":12},null,{"$f":"SUM(E15:E19)","v":8}]