{"text_format":"2","workbook":"xlsx","n_sheets":2,"sheets":["Assumptions","ProForma"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":2,"comments":2,"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":"Assumptions","index":0,"n_rows":39,"n_cols":11,"rows_kept":39,"cut":false,"hidden":false,"merged":[[22,9,22,10],[1,1,1,3],[4,1,4,7],[4,9,4,10]]}
[]
[null,"Vincent Court Proforma"]
[]
[]
[null,"Income - Monthly",{"$nulls":7},"Expenses - Annual"]
[" ","Unit ","BD/BA","Rennovated","Rent","Water","Parking/Pet Fee","Taxes",null,"Turnover Maintenence  (per unit) - R",1000]
[null,"Commercial Unit 1",null,"yes",1310,35,null,null,null,"Turnover Maintenence  (per unit) - C",5000]
[null,"Commercial Unit 2",null,"yes",1648,30,null,null,null,"Common Area Cleaning",1700]
[null,"1D","2024-02-01","yes",1280,60,null,null,null,"Snow Removal",1500]
[null,"2A","2024-01-01","yes",1200,45,25,null,null,"Trash Removal",10000]
[null,"2B","2024-01-01","yes",1070,60,null,null,null,"Property Insurance",13082]
[null,"2C","2024-02-02","yes",1260,60,75,null,null,"Property Tax",{"$f":"16811.6+1000","v":17811.599999999999}]
[null,"2E","0/1","no",825,60,25,null,null,"Common Area Electricity ",3482.71]
[null,"2F","2024-01-01","partially",1195,60,null,null,null,"Internet",1300]
[null,"3A","2024-01-01","yes",1125,60,75,null,null,"Water",8060.28]
[null,"3B","2024-01-01","yes",1030,60,null,null,null,"Gas",2000]
[null,"3D","2024-02-02","partially",1260,60,75,null,null,"Repairs and Maintenance",12000]
[null,"3E","0/1","yes",915,60,null,null,null,"Inspections/Licenses/Permits",3000]
[null,"3F","2024-01-01","partially",1000,30,75,null,null,"Accounting/Tax Prep",1100]
[null,"Garage #1","- ",null,125,{"$nulls":4},"Pest/Bug Control",500]
[null,"Garage #2","- ",null,125,{"$nulls":4},"Management Fees",{"$f":"0.06*ProForma!D11","v":11942.3766}]
[null,"Garage #3","- ",null,125]
[null,"Garage #4","- ",null,125,{"$nulls":4},"Assumptions"]
[null,"Garage #5","- ",null,125,{"$nulls":4},"Annual Rent Rise",0.03]
[null,"Garage #6","- ",null,125,{"$nulls":4},"Inflation",0.02]
[null,"Garage #7","- ",null,125,{"$nulls":4},"Vacancy Rate",{"$f":"K27*1/6","v":6.0606060606060608E-2}]
[null,"Garage #8","- ",null,125,{"$nulls":4},"Turnover (Residential)",{"$f":"4/COUNT(E9:E19)","v":0.36363636363636365}]
[null,"Garage #9","- ",null,125,{"$nulls":4},"Turnover (Commercial)",0]
[null,"Garage #10","- ",null,125,{"$nulls":4},"Cap Rate at Sale",0.06]
[null,"Garage #11","- ",null,125,{"$nulls":4},"Closing Costs",0]
[null,"Garage #12","- ",null,125]
[null,"Garage #13","- ",null,125]
[null,"Garage #14","- ",null,125]
[null,"Garage #15","- ",null,125]
[null,"Garage #16","- ",null,125]
[null,"Garage #17","- ",null,125]
[null,"Garage #18","- ",null,125]
[null,"Garage #19","- ",null,125]
[null,"Laundry","- ",null,{"$f":"500/12","v":41.666666666666664}]

{"sheet":"ProForma","index":1,"n_rows":46,"n_cols":8,"rows_kept":46,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,2025,{"$f":"D2+1","v":2026},{"$f":"E2+1","v":2027},2028,2029]
[null,"Operating Revenue"]
[null,"Gross Commercial Rental Income",null,30788,{"$f":"SUM(Assumptions!E7:E8)*12","v":35496},{"$f":"E4*(1+Assumptions!$K$24)","v":36560.879999999997},{"$f":"F4*(1+Assumptions!$K$24)","v":37657.706399999995},{"$f":"G4*(1+Assumptions!$K$24)","v":38787.437591999995}]
[null,"Gross Residential Rental Income",null,130907.61,{"$f":"SUM(Assumptions!E9:E19)*12","v":145920},{"$f":"E5*(1+Assumptions!$K$24)","v":150297.60000000001},{"$f":"F5*(1+Assumptions!$K$24)","v":154806.52800000002},{"$f":"G5*(1+Assumptions!$K$24)","v":159450.72384000002}]
[null,"Gross Garage Income",null,25391.41,{"$f":"SUM(Assumptions!E20:E38)*12","v":28500},{"$f":"E6*(1+Assumptions!$K$24)","v":29355},{"$f":"F6*(1+Assumptions!$K$24)","v":30235.65},{"$f":"G6*(1+Assumptions!$K$24)","v":31142.719500000003}]
[null,"Gross Parking Income",null,4800,{"$f":"SUM(Assumptions!G7:G19)*12","v":4200},{"$f":"E7*(1+Assumptions!$K$24)","v":4326},{"$f":"F7*(1+Assumptions!$K$24)","v":4455.78},{"$f":"G7*(1+Assumptions!$K$24)","v":4589.4533999999994}]
[null,"Gross Water Income",null,6652.59,{"$f":"SUM(Assumptions!F7:F19)*12","v":8160},{"$f":"E8*(1+Assumptions!$K$24)","v":8404.8000000000011},{"$f":"F8*(1+Assumptions!$K$24)","v":8656.9440000000013},{"$f":"G8*(1+Assumptions!$K$24)","v":8916.6523200000011}]
[null,"Gross Laundry Income",null,500,{"$f":"Assumptions!$E$39*12","v":500},{"$f":"E9*(1+Assumptions!$K$24)","v":515},{"$f":"F9*(1+Assumptions!$K$24)","v":530.45000000000005},{"$f":"Assumptions!$E$39*12","v":500}]
[null,"Vacancy Loss",null,null,{"$f":"-Assumptions!$K$27*ProForma!E5*2/12","v":-8843.636363636364},{"$f":"-Assumptions!$K$27*ProForma!F5*2/12","v":-9108.9454545454555},{"$f":"-Assumptions!$K$27*ProForma!G5*2/12","v":-9382.2138181818191},{"$f":"-Assumptions!$K$27*ProForma!H5*2/12","v":-9663.6802327272744}]
[null,"Net Operating Revenue",null,{"$f":"SUM(D4:D10)","v":199039.61},{"$f":"SUM(E4:E10)","v":213932.36363636365},{"$f":"SUM(F4:F10)","v":220350.33454545453},226960.84458181818,233723.30641927273]
[]
[null,"Operating Expenses"]
[null,"Turnover Maintenance",null,{"$f":"-Assumptions!K6*COUNT(Assumptions!E9:E19)*Assumptions!K27+Assumptions!K7*COUNT(Assumptions!E7:E8)*Assumptions!K28","v":-4000},{"$f":"D14*(1+Assumptions!$K$25)","v":-4080},{"$f":"E14*(1+Assumptions!$K$25)","v":-4161.6000000000004},{"$f":"F14*(1+Assumptions!$K$25)","v":-4244.8320000000003},{"$f":"G14*(1+Assumptions!$K$25)","v":-4329.7286400000003}]
[null,"Common Area Cleaning",null,{"$f":"-Assumptions!K8","v":-1700},{"$f":"D15*(1+Assumptions!$K$25)","v":-1734},{"$f":"E15*(1+Assumptions!$K$25)","v":-1768.68},{"$f":"F15*(1+Assumptions!$K$25)","v":-1804.0536000000002},{"$f":"G15*(1+Assumptions!$K$25)","v":-1840.1346720000001}]
[null,"Snow Removal",null,{"$f":"-Assumptions!K9","v":-1500},{"$f":"D16*(1+Assumptions!$K$25)","v":-1530},{"$f":"E16*(1+Assumptions!$K$25)","v":-1560.6000000000001},{"$f":"F16*(1+Assumptions!$K$25)","v":-1591.8120000000001},{"$f":"G16*(1+Assumptions!$K$25)","v":-1623.6482400000002}]
[null,"Trash Removal",null,{"$f":"-Assumptions!K10","v":-10000},{"$f":"D17*(1+Assumptions!$K$25)","v":-10200},{"$f":"E17*(1+Assumptions!$K$25)","v":-10404},{"$f":"F17*(1+Assumptions!$K$25)","v":-10612.08},{"$f":"G17*(1+Assumptions!$K$25)","v":-10824.321599999999}]
[null,"Property Insurance",null,{"$f":"-Assumptions!K11","v":-13082},{"$f":"D18*(1+Assumptions!$K$25)","v":-13343.64},{"$f":"E18*(1+Assumptions!$K$25)","v":-13610.5128},{"$f":"F18*(1+Assumptions!$K$25)","v":-13882.723056000001},{"$f":"G18*(1+Assumptions!$K$25)","v":-14160.377517120001}]
[null,"Property Tax",null,{"$f":"-Assumptions!K12","v":-17811.599999999999},{"$f":"D19*(1+Assumptions!$K$25)","v":-18167.831999999999},{"$f":"E19*(1+Assumptions!$K$25)","v":-18531.18864},{"$f":"F19*(1+Assumptions!$K$25)","v":-18901.812412800002},{"$f":"G19*(1+Assumptions!$K$25)","v":-19279.848661056003}]
[null,"Common Area Electricity ",null,{"$f":"-Assumptions!K13","v":-3482.71},{"$f":"D20*(1+Assumptions!$K$25)","v":-3552.3642},{"$f":"E20*(1+Assumptions!$K$25)","v":-3623.4114840000002},{"$f":"F20*(1+Assumptions!$K$25)","v":-3695.8797136800003},{"$f":"G20*(1+Assumptions!$K$25)","v":-3769.7973079536005}]
[null,"Internet",null,{"$f":"-Assumptions!K14","v":-1300},{"$f":"D21*(1+Assumptions!$K$25)","v":-1326},{"$f":"E21*(1+Assumptions!$K$25)","v":-1352.52},{"$f":"F21*(1+Assumptions!$K$25)","v":-1379.5704000000001},{"$f":"G21*(1+Assumptions!$K$25)","v":-1407.1618080000001}]
[null,"Water",null,{"$f":"-Assumptions!K15","v":-8060.28},{"$f":"D22*(1+Assumptions!$K$25)","v":-8221.4856},{"$f":"E22*(1+Assumptions!$K$25)","v":-8385.915312000001},{"$f":"F22*(1+Assumptions!$K$25)","v":-8553.6336182400009},{"$f":"G22*(1+Assumptions!$K$25)","v":-8724.7062906048013}]
[null,"Gas (PGW)",null,{"$f":"-Assumptions!K16","v":-2000},{"$f":"D23*(1+Assumptions!$K$25)","v":-2040},{"$f":"E23*(1+Assumptions!$K$25)","v":-2080.8000000000002},{"$f":"F23*(1+Assumptions!$K$25)","v":-2122.4160000000002},{"$f":"G23*(1+Assumptions!$K$25)","v":-2164.8643200000001}]
[null,"Repairs and Maintenance",null,{"$f":"-Assumptions!K17","v":-12000},{"$f":"D24*(1+Assumptions!$K$25)","v":-12240},{"$f":"E24*(1+Assumptions!$K$25)","v":-12484.800000000001},{"$f":"F24*(1+Assumptions!$K$25)","v":-12734.496000000001},{"$f":"G24*(1+Assumptions!$K$25)","v":-12989.185920000002}]
[null,"Inspections/Licenses/Permits",null,{"$f":"-Assumptions!K18","v":-3000},{"$f":"D25*(1+Assumptions!$K$25)","v":-3060},{"$f":"E25*(1+Assumptions!$K$25)","v":-3121.2000000000003},{"$f":"F25*(1+Assumptions!$K$25)","v":-3183.6240000000003},{"$f":"G25*(1+Assumptions!$K$25)","v":-3247.2964800000004}]
[null,"Accounting/Tax Prep",null,{"$f":"-Assumptions!K19","v":-1100},{"$f":"D26*(1+Assumptions!$K$25)","v":-1122},{"$f":"E26*(1+Assumptions!$K$25)","v":-1144.44},{"$f":"F26*(1+Assumptions!$K$25)","v":-1167.3288},{"$f":"G26*(1+Assumptions!$K$25)","v":-1190.6753759999999}]
[null,"Pest/Bug Control (per unit)",null,{"$f":"-Assumptions!K20","v":-500},{"$f":"D27*(1+Assumptions!$K$25)","v":-510},{"$f":"E27*(1+Assumptions!$K$25)","v":-520.20000000000005},{"$f":"F27*(1+Assumptions!$K$25)","v":-530.60400000000004},{"$f":"G27*(1+Assumptions!$K$25)","v":-541.21608000000003}]
[null,"Total Operating Expenses",null,{"$f":"SUM(D14:D27)","v":-79536.59},{"$f":"SUM(E14:E27)","v":-81127.321799999991},{"$f":"SUM(F14:F27)","v":-82749.868236000009},{"$f":"SUM(G14:G27)","v":-84404.865600720004},{"$f":"SUM(H14:H27)","v":-86092.962912734409}]
[null,null,null," "]
[null,"Management Fees",null,{"$f":"-Assumptions!K21","v":-11942.3766},{"$f":"D30*(1+Assumptions!$K$25)","v":-12181.224131999999},{"$f":"E30*(1+Assumptions!$K$25)","v":-12424.848614639999},{"$f":"F30*(1+Assumptions!$K$25)","v":-12673.345586932799},{"$f":"G30*(1+Assumptions!$K$25)","v":-12926.812498671456}]
[null,"Total Operating Expenses (with management)",null,{"$f":"SUM(D28:D30)","v":-91478.9666},{"$f":"SUM(E28:E30)","v":-93308.545931999994},{"$f":"SUM(F28:F30)","v":-95174.716850640005},{"$f":"SUM(G28:G30)","v":-97078.211187652807},{"$f":"SUM(H28:H30)","v":-99019.775411405863}]
[]
[null,"Gross NOI",null,{"$f":"D11+D28","v":119503.01999999999},{"$f":"E11+E28","v":132805.04183636367},{"$f":"F11+F28","v":137600.46630945452},{"$f":"G11+G28","v":142555.97898109816},{"$f":"H11+H28","v":147630.34350653831}]
[null,"% of Revenue",null,{"$f":"D33/D11","v":0.60039818205029638},{"$f":"E33/E11","v":0.62078051015274172},{"$f":"F33/F11","v":0.6244622527726178},{"$f":"G33/G11","v":0.62810825031851469},{"$f":"H33/H11","v":0.63164579420122724}]
[null,"Net NOI (management fees)",null,{"$f":"D11+D31","v":107560.64339999999},{"$f":"E11+E31","v":120623.81770436365},{"$f":"F11+F31","v":125175.61769481453},{"$f":"G11+G31","v":129882.63339416537},{"$f":"H11+H31","v":134703.53100786687}]
[null,"% of Revenue",null,{"$f":"D35/D11","v":0.54039818205029644},{"$f":"E35/E11","v":0.56384090585469671},{"$f":"F35/F11","v":0.56807546016678689},{"$f":"G35/G11","v":0.57226890230108995},{"$f":"H35/H11","v":0.57633760651248112}]
[]
[null,"Cap Rate - Sales Price"]
[null,5.2499999999999998E-2,null,{"$f":"D$35/$B39","v":2048774.16},{"$f":"E$35/$B39","v":2297596.5277021648},2384297.479901229,2473954.9217936262,2565781.5430069882]
[null,5.5E-2,null,{"$f":"D$35/$B40","v":1955648.0618181815},2193160.3218975211,2275920.3217239007,2361502.4253484611,2449155.1092339433]
[null,5.7500000000000002E-2,null,1870619.885217391,{"$f":"E$35/$B41","v":2097805.5252932808},2176967.2642576438,2258828.40685505,2342670.104484641]
[null,0.06,null,{"$f":"D$35/$B42","v":1792677.39},2010396.9617393943,2086260.2949135755,2164710.5565694231,2245058.8501311145]
[null,6.25E-2,null,1720970.2943999998,1929981.0832698185,2002809.8831170325,2078122.134306646,2155256.4961258699]
[null,6.5000000000000002E-2,null,1654779.1292307689,1855751.0416055946,1925778.7337663772,1998194.3599102364,2072362.015505644]
[null,6.7500000000000004E-2,null,1593491.013333333,1787019.521546128,1854453.5954787335,1924187.1613950424,1995607.8667832129]
[null,7.0000000000000007E-2,null,{"$f":"D$35/$B46","v":1536580.6199999996},1723197.3957766234,1788223.1099259218,1855466.1913452195,1924336.1572552407]