{"text_format":"2","workbook":"xlsx","n_sheets":5,"sheets":["Overview","Unit Mix","Operations","Development Cost","10 Yr Projections"],"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":"Overview","index":0,"n_rows":53,"n_cols":5,"rows_kept":53,"cut":false,"hidden":false,"merged":[]}
[]
[null," ","SITE OVERVIEW"]
[]
[]
[null,"Name","CR 44 leesburg STORAGE"]
[]
[null,"Address","9915 County RD 44"]
[null,null,"Leesburg, FL 34788"]
[]
[]
[null,null," "," "]
[null,"Total Building Area","Sq ft",101380.0,"incl Cov parking"]
[]
[null,"Site acreage",null,6.25]
[]
[null,"Net Rentable Area","Sq ft",{"$f":"'Unit Mix'!H47","v":86175}]
[]
[null,null,null,"Sq ft","% of Total"]
[null,"CC Units",{"$f":"'Unit Mix'!B41","v":646},{"$f":"'Unit Mix'!H41","v":82075},{"$f":"D19/D16","v":0.9524223963}]
[]
[null,null,null,"Sq ft","% of Total"]
[null,"Non CC Units",{"$f":"'Unit Mix'!B21","v":21},{"$f":"'Unit Mix'!H21","v":4100},{"$f":"D22/D16","v":0.04757760371}]
[]
[null,"Parking",{"$f":"'Unit Mix'!B60","v":0}]
[]
[null,"Jurisdiction",null,"Marion County"]
[null,"Zoning",null,"RAC/Special Use Permit - Storage approved"]
[]
[null,null,"PROFORMA"]
[]
[]
[null,"Gross Potential Inc",null,{"$f":"'Unit Mix'!J71","v":1581057.482}]
[null,"Less Vacancy/Coll"," ",{"$f":"Operations!E17","v":331367.2973}]
[]
[null,"Projected Income",null,{"$f":"Operations!E18","v":1249690.185}]
[]
[null,"Projected Expenses",null,{"$f":"Operations!E34","v":255495.0841}]
[]
[null,"Net Operating Inc",null,{"$f":"Operations!E37","v":994195.101}]
[]
[]
[null,null,"VALUES"]
[]
[null,"Cap Rate Values",0.06,{"$f":"D39/C44","v":16569918.35}]
[null,"@ Projected NOI",0.055,{"$f":"D39/C45","v":18076274.56}]
[null,null,0.05,{"$f":"D39/C46","v":19883902.02}]
[]
[]
[null,"Land Cost",null,{"$f":"'Development Cost'!I6+'Development Cost'!I7","v":1890000}]
[null,"Development Cost",null,{"$f":"'Development Cost'!I71","v":9557151.66}]
[null,null,"Total",{"$f":"'Development Cost'!I70","v":11447151.66}]
[]
[null,"Cost to Value","@ 5.5 Cap",{"$f":"D51/D45","v":0.6332694062}]

{"sheet":"Unit Mix","index":1,"n_rows":74,"n_cols":10,"rows_kept":74,"cut":false,"hidden":false,"merged":[]}
[]
[{"$nulls":5},"UNIT MIX – TOTAL REVENUES"]
[]
[null,"NON CLIMATE"]
[null,"UNITS","SIZE","RSF","RATE","MONTHLY RENT / SF","ANNUAL RENT / SF","TOTAL SF","MONTHLY GROSS POTENTIAL RENT ","ANNUAL GROSS POTENTIAL RENT "]
[]
[null,0.0,"5 x 5",25.0,45.0,{"$f":"E7/D7","v":1.8},{"$f":"F7*12","v":21.6},{"$f":"B7*D7","v":0},{"$f":"B7*E7","v":0},{"$f":"I7*12","v":0}]
[null,0.0,"5 x10",50.0,55.0,1.1,13.2,0,0,0]
[null,0.0,"7.5 x 10",75.0,70.0,0.9333333333,11.2,0,0,0]
[null,0.0,"10 x 10",100.0,95.0,0.95,11.4,0,0,0]
[null,0.0,"7.5 x 15",112.5,100.0,0.8888888889,10.66666667,0,0,0]
[null,10.0,"10 x 15",150.0,110.0,0.7333333333,8.8,1500,1100,13200]
[null,3.0,"10 x 20",200.0,150.0,0.75,9,600,450,5400]
[null,8.0,"10 x 25",250.0,185.0,0.74,8.88,2000,1480,17760]
[null,0.0,"10 x 30",300.0,255.0,0.85,10.2,0,0,0]
[null,0.0,"10 x 35",350.0,275.0,0.7857142857,9.428571429,0,0,0]
[null,0.0,"10 x 40",400.0,300.0,0.75,9,0,0,0]
[]
[null,"TOTAL NON CLIMATE"]
[]
[null,{"$f":"SUM(B7:B17)","v":21},null," ",null,{"$f":"G21/12","v":0.7390243902},{"$f":"J21/H21","v":8.868292683},{"$f":"SUM(H7:H17)","v":4100},3030,36360]
[]
[null,"CLIMATE CONTROLLED"]
[null,"UNITS","SIZE","RSF","RATE","RENT / SF","ANNUAL RENT / SF","TOTAL SF","MONTHLY GROSS POTENTIAL RENT ","ANNUAL GROSS POTENTIAL RENT "]
[]
[null,60.0,"5 x 5",25.0,108.66,{"$f":"E26/D26","v":4.3464},{"$f":"F26*12","v":52.1568},{"$f":"B26*D26","v":1500},{"$f":"B26*E26","v":6519.6},{"$f":"I26*12","v":78235.2}]
[null,93.0,"5 x10",50.0,111.13,2.2226,26.6712,4650,10335.09,124021.08]
[null,43.0,"7.5 x 10",75.0,85.0,1.133333333,13.6,3225,3655,43860]
[null,157.0,"10 x 10",100.0,187.01,1.8701,22.4412,15700,29360.57,352326.84]
[null,40.0,"7.5 x 15",112.5,120.0,1.066666667,12.8,4500,4800,57600]
[null,104.0,"10 x 15",150.0,241.52,1.610133333,19.3216,15600,25118.08,301416.96]
[null,60.0,"10 x 20",200.0,384.4,1.922,23.064,12000,23064,276768]
[null,26.0,"15 x 15",225.0,215.0,0.9555555556,11.46666667,5850,5590,67080]
[null,14.0,"10 x 25",250.0,250.0,1,12,3500,3500,42000]
[null,39.0,"10 x 30",300.0,209.0,0.6966666667,8.36,11700,8151,97812]
[null,3.0,"10 x 35",350.0,300.0,0.8571428571,10.28571429,1050,900,10800]
[null,7.0,"10 x 40",400.0,325.0,0.8125,9.75,2800,2275,27300]
[]
[null,"TOTAL CLIMATE"]
[]
[null,{"$f":"SUM(B26:B37)","v":646},null," ",null,{"$f":"G41/12","v":1.501898751},{"$f":"J41/H41","v":18.02278501},{"$f":"SUM(H26:H37)","v":82075},123268.34,1479220.08]
[]
[null,"TOTAL STORAGE"]
[]
[null,"UNITS","SIZE","RSF","RATE","MONTHLY RENT / SF","ANNUAL RENT / SF","TOTAL SF","MONTHLY GROSS POTENTIAL RENT ","ANNUAL GROSS POTENTIAL RENT "]
[]
[null,{"$f":"B41+B21","v":667},null," ",null,{"$f":"G47/12","v":1.465603017},{"$f":"J47/H47","v":17.58723621},{"$f":"H41+H21","v":86175},126298.34,1515580.08]
[]
[null,"PARKING"]
[null,"Open"]
[null,0.0,"10 x 30",300.0,75.0,{"$f":"E51/D51","v":0.25},{"$f":"F51*12","v":3},{"$f":"B51*D51","v":0},{"$f":"B51*E51","v":0},{"$f":"I51*12","v":0}]
[null,0.0,"10 x 40",400.0,110.0,0.275,3.3,0,0,0]
[null,"Covered"]
[null,0.0,"12 x 25",300.0,185.0,{"$f":"E54/D54","v":0.6166666667},{"$f":"F54*12","v":7.4},{"$f":"B54*D54","v":0},{"$f":"B54*E54","v":0},{"$f":"I54*12","v":0}]
[null,0.0,"12 x 60",720.0,275.0,0.3819444444,4.583333333,0,0,0]
[]
[]
[null,"TOTAL PARKING"]
[]
[null,{"$f":"SUM(B51:B55)","v":0},null," ",null,{"$f":"G60/12","v":"#DIV/0!"},{"$f":"J60/H60","v":"#DIV/0!"},{"$f":"SUM(H51:H55)","v":0},0,0]
[]
[null,"TOTAL RENTAL INCOME"]
[]
[null,"UNITS","SIZE","RSF","RATE","MONTHLY RENT / SF","ANNUAL RENT / SF","TOTAL SF","MONTHLY GROSS POTENTIAL RENT ","ANNUAL GROSS POTENTIAL RENT "]
[]
[null,{"$f":"B60+B41+B21","v":667},null," ",null,{"$f":"G66/12","v":1.465603017},{"$f":"J66/H66","v":17.58723621},{"$f":"H60+H41+H21","v":86175},126298.34,1515580.08]
[]
[null,"MISC FEES & RETAIL",null,null,0.03,null,null,null,{"$f":"I66*E68","v":3788.9502},{"$f":"I68*12","v":45467.4024}]
[null,"TENANT PROT/INS",null,{"$f":"B47*0.5","v":333.5},5.0,null,null,null,{"$f":"E69*D69","v":1667.5},20010]
[]
[null,"GROSS POTENTIAL INCOME",{"$nulls":6},{"$f":"SUM(I66:I69)","v":131754.7902},{"$f":"I71*12","v":1581057.482}]
[null,"VACANCY",null,null,0.2,null,null,null,{"$f":"I71*E72","v":26350.95804},316211.4965]
[]
[null,null,"PROJECTED INCOME",{"$nulls":5},{"$f":"I71-I72","v":105403.8322},{"$f":"I74*12","v":1264845.986}]

{"sheet":"Operations","index":2,"n_rows":39,"n_cols":5,"rows_kept":39,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,"PROJECTED NET INCOME"]
[]
[null,null,null,"Monthly","Annual"]
[]
[null,"Gross Potential Rent"," ",{"$f":"E6/12","v":126298.34},{"$f":"'Unit Mix'!J66","v":1515580.08}]
[null,"Fee & Retail Income"," ",3788.9502,{"$f":"'Unit Mix'!J68","v":45467.4024}]
[null,"Tenant Prot"," ",1667.5,{"$f":"'Unit Mix'!J69","v":20010}]
[null,"Gross Potential Income"," ",131754.7902,{"$f":"'Unit Mix'!J71","v":1581057.482}]
[]
[null,"Vacancy",null,null,{"$f":"'Unit Mix'!E72","v":0.2}]
[null,"Bad Debt"," ",null,0.005]
[null,"Rent Concessions"," ",null,0.005]
[null,"Vacancy",null,{"$f":"E14/12","v":26350.95804},{"$f":"'Unit Mix'!J72","v":316211.4965}]
[null,"Bad Debt"," ",631.4917,{"$f":"E6*E12","v":7577.9004}]
[null,"Rent Concessions"," ",631.4917,{"$f":"E6*E13","v":7577.9004}]
[null,"Total Vacancy/DB/RC"," ",27613.94144,{"$f":"SUM(E14:E16)","v":331367.2973}]
[null,"Effective Gross Income"," ",104140.8488,{"$f":"E9-E17","v":1249690.185}]
[null," "]
[null," "," ",null," "]
[null,"On-Site Payroll"," ",{"$f":"E21/12","v":2916.666667},35000.0]
[null,"Repairs & Maintenance"," ",1250,15000.0]
[null,"General & Administrative"," ",666.6666667,8000.0]
[null,"Advertising & Promotion"," ",1000,12000.0]
[null,"Bank Charges"," ",1000,12000.0]
[null,"Professional Fees"," ",416.6666667,5000.0]
[null,"Telephone/Internet",null,266.6666667,3200.0]
[null,"Property Association Fees"," ",0.0,0.0]
[null,"Management Fee"," ",{"$f":"E29/12","v":5207.042438},{"$f":"0.05*E18","v":62484.50926}]
[null,"Real Estate Taxes"," ",3333.333333,40000.0]
[null,"Depreciation Reserves",null,1317.547902,{"$f":"E9*0.01","v":15810.57482}]
[null,"Utilities",null,2083.333333,25000.0]
[null,"Insurance",null,1833.333333,22000.0]
[null,"Total Operating Expenses"," ",21291.25701,{"$f":"SUM(E21:E33)","v":255495.0841}]
[null,"Expense Ratio"," ",null,{"$f":"E34/E18","v":0.2044467398}]
[]
[null,"NOI",null,null,{"$f":"E18-E34","v":994195.101}]
[]
[null,"Cap Rate Value",0.06,null,{"$f":"E37/C39","v":16569918.35}]

{"sheet":"Development Cost","index":3,"n_rows":73,"n_cols":14,"rows_kept":73,"cut":false,"hidden":false,"merged":[[54,12,54,13]]}
[]
[null,null,null,"DEVELOPMENT ESTIMATED VALUES"]
[]
[{"$nulls":5},"Unit ","Value",null,"Total"]
[null," "]
[null,"LAND EXPENSE",null,"Ac"," ",6.25,{"$f":"I6/F6","v":288000},null,1800000.0,null,"Land/ Closing"]
[null,null,null,"Closing",null,0.05,null,null,{"$f":"I6*F7","v":90000},null,{"$f":"SUM(I6+I7)","v":1890000}]
[]
[null,"SOFT COSTS",null,"Arch/Engineering",{"$nulls":4},179000.0]
[null,null,null,"Permits / Fees",{"$nulls":4},186000.0]
[null,null,null,"Surveys",{"$nulls":4},45000.0]
[null,null,null,"Utility Fees",{"$nulls":4},60000.0]
[null,null,null,"Due Diligence",{"$nulls":4},0.0]
[null,null,null,"Legal Fees",{"$nulls":4},50000.0]
[null,null,null,"Appraisal",{"$nulls":4},6000.0]
[null,null,null,"Builder Risk Insurance",{"$nulls":4},100000.0]
[null,null,null,"Working Capital",{"$nulls":4},50000.0]
[null,null,null,"Real Estate Taxes/ Escrow Caplitized ",{"$nulls":4},30000.0]
[null,null,null,"Constrution Draw inspection Fees",{"$nulls":4},6000.0,null,"Soft Cost "]
[null,null,null,"Contingency - Soft Cost",{"$nulls":4},100000.0,null,{"$f":"SUM(I9:I20)","v":812000}]
[]
[]
[null,"SITE WORK",null,"Silt Fence & Prep",{"$nulls":4},30000.0]
[null,null,null,"Clearing and Fill",{"$nulls":4},500000.0]
[null,null,null,"Ponds/Drainage",{"$nulls":4},250000.0]
[null,null,null,"Utilities",{"$nulls":4},450000.0]
[null,null,null,"Roads/Drives",null,70380.0,4.0,null,{"$f":"SUM(F27*G27)","v":281520}]
[null,null,null,"Landscaping/Irrigation/Fencing",{"$nulls":4},235000.0,null,"Site Cost"]
[null,null,null,"Well/ Septic",{"$nulls":4},45000.0,null,{"$f":"SUM(I23:I29)","v":1791520}]
[]
[]
[]
[null,"BUILDING COSTS",null,"Underground rough in",null,101380.0,1.53,null,{"$f":"SUM(F33*G33)","v":155111.4}]
[null,null,null,"Slabs/ Foundations",null,101380.0,9.5,null,{"$f":"G34*F34","v":963110},null,"Building Cost ",{"$f":"SUM(K35/N34)","v":59.45723614},null,101380.0]
[null,null,null,"Steel",null,101380.0,12.36,null,1253056.8,null,{"$f":"SUM(I33:I56)","v":6027774.6}]
[null,null,null,"Steel Erection",null,101380.0,6.5,null,658970]
[null,null,null,"Screws and hardware",null,101380.0,1.67,null,{"$f":"SUM(F37*G37)","v":169304.6}]
[null,null,null,"Walk Doors and hardware",null,101380.0,0.8,null,81104]
[null,null,null,"Janus Roll-up doors",null,101380.0,3.66,null,371050.8]
[null,null,null,"Roof",null,101380.0,4.0,null,{"$f":"G40*F40","v":405520}]
[null,null,null,"Spray Foam insualtion",null,101380.0,0.33,null,{"$f":"SUM(F41*G41)","v":33455.4}]
[null,null,null,"Batt Insulation",null,101380.0,1.81,null,183497.8]
[null,null,null,"Fire Walls",null,101380.0,1.42,null,143959.6]
[null,null,null,"Electrical",null,101380.0,4.2,null,425796]
[null,null,null,"HVAC",null,101380.0,4.64,null,470403.2]
[null,null,null,"Plumbing",null,null,0.0,null,32000.0]
[null,null,null,"Office Trim",{"$nulls":4},2500.0]
[null,null,null,"Hardie Board",{"$nulls":4},35000.0]
[null,null,null,"Paint",null,101380.0,0.65,null,{"$f":"SUM(F49*G49)","v":65897}]
[null,null,null,"Flooring",null,null,null," ",25000.0]
[null,null,null,"Split Jamb Doors",{"$nulls":4},3500.0]
[null,null,null,"Storefront",{"$nulls":4},17500.0]
[null,null,null,"Non-rated Drywall",{"$nulls":4},15000.0]
[null,null,null,"Cleaning",null,101380.0,0.45,null,{"$f":"SUM(F54*G54)","v":45621}]
[null,null,null,"General conditions/ Fee",null,101380.0,3.15,null,319347]
[null,null,null,"Contingency",null,101380.0,1.5,null,152070]
[]
[]
[null,"OFFICE / SIGNAGE",null,"Office- Complete",{"$nulls":4},150000.0,null,"Office/ Signage"]
[null,null,null,"Sign and permitting",{"$nulls":4},30000.0,null,{"$f":"SUM(I59:I62)","v":195000}]
[null,null,null,"Supplies/Setup",{"$nulls":4},10000.0]
[null,null,null,"Contingency",{"$nulls":4},5000.0]
[]
[null,"CARRY /  INTEREST"]
[null,null,null,"Int Cost",{"$nulls":4},476172.06]
[null,null,null,"Contingency",{"$nulls":4},250000.0]
[]
[{"$nulls":7},"round",4685.0]
[]
[{"$nulls":6},"TOTAL",null,{"$f":"SUM(I6:I68)","v":11447151.66}]
[{"$nulls":6},"less Land",null,{"$f":"I70-I6-I7","v":9557151.66}]
[]
[null,null,null," "," "," "]

{"sheet":"10 Yr Projections","index":4,"n_rows":64,"n_cols":21,"rows_kept":64,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[null," "," "," "," "," "," "," "," "," "," "]
[null," "," ","Year 1","Year 2","Year 3","Year 4","Year 5","Year 6","Year 7","Year 8","Year 9","Year 10"," "," "," "," "," "," "," "," "]
[]
[null,"Rent Growth"," ",0.0,0.0,0.015,0.015,0.02,0.02,0.02,0.02,0.02,0.02]
[null,"Gross Potential Rent"," ",{"$f":"Operations!E6","v":1515580.08},{"$f":"D10","v":1515580.08},{"$f":"(E10*F9)+E10","v":1538313.781},1561388.488,1592616.258,1624468.583,1656957.954,1690097.114,1723899.056,1758377.037]
[null,"Fee & Retail Income"," ",{"$f":"Operations!E7","v":45467.4024},{"$f":"E10*0.03","v":45467.4024},46149.41344,46841.65464,47778.48773,48734.05748,49708.73863,50702.91341,51716.97168,52751.31111]
[null,"Tenant Prot"," ",{"$f":"Operations!E8","v":20010},{"$f":"D12","v":20010},{"$f":"E12*F9+E12","v":20310.15},20614.80225,21027.0983,21447.64026,21876.59307,22314.12493,22760.40743,23215.61557]
[null,"Gross Potential Income"," ",{"$f":"Operations!E9","v":1581057.482},1581057.482,{"$f":"SUM(F10:F12)","v":1604773.345},1628844.945,1661421.844,1694650.281,1728543.286,1763114.152,1798376.435,1834343.964]
[null,null,null," "]
[null,"Vacancy Rate",null,0.7,0.5,0.3,0.15,0.1,0.1,0.1,0.1,0.1,0.1]
[null,"Vacancy",null,{"$f":"D10*D15","v":1060906.056},757790.04,461494.1344,234208.2732,159261.6258,162446.8583,165695.7954,169009.7114,172389.9056,175837.7037]
[null,"Bad Debt",0.005,{"$f":"Operations!E15","v":7577.9004},{"$f":"$C17*E10","v":7577.9004},7691.568906,7806.94244,7963.081288,8122.342914,8284.789772,8450.485568,8619.495279,8791.885185]
[null,"Rent Concessions",0.005,{"$f":"Operations!E16","v":7577.9004},{"$f":"$C18*E10","v":7577.9004},7691.568906,7806.94244,7963.081288,8122.342914,8284.789772,8450.485568,8619.495279,8791.885185]
[null,"Total Vacancy/DB/RC"," ",{"$f":"SUM(D16:D18)","v":1076061.857},772945.8408,476877.2722,249822.1581,175187.7883,178691.5441,182265.375,185910.6825,189628.8961,193421.4741]
[null,"Effective Gross Income"," ",{"$f":"D13-D19","v":504995.6256},808111.6416,1127896.072,1379022.787,1486234.055,1515958.736,1546277.911,1577203.469,1608747.539,1640922.49]
[null," ",null," "]
[null,"Expense Growth"," ",{"$f":"Operations!E20","v":" "},0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02]
[null,"On-Site Payroll"," ",{"$f":"Operations!E21","v":35000},{"$f":"$E22*D23+D23","v":35700},36414,37142.28,37885.1256,38642.82811,39415.68467,40203.99837,41008.07834,41828.2399]
[null,"Repairs & Maintenance"," ",{"$f":"Operations!E22","v":15000},{"$f":"$E22*D24+D24","v":15300},15606,15918.12,16236.4824,16561.21205,16892.43629,17230.28501,17574.89072,17926.38853]
[null,"General & Administrative"," ",{"$f":"Operations!E23","v":8000},{"$f":"$E22*D25+D25","v":8160},8323.2,8489.664,8659.45728,8832.646426,9009.299354,9189.485341,9373.275048,9560.740549]
[null,"Advertising & Promotion"," ",{"$f":"Operations!E24","v":12000},{"$f":"$E22*D26+D26","v":12240},12484.8,12734.496,12989.18592,13248.96964,13513.94903,13784.22801,14059.91257,14341.11082]
[null,"Bank Charges"," ",{"$f":"Operations!E25","v":12000},{"$f":"$E22*D27+D27","v":12240},12484.8,12734.496,12989.18592,13248.96964,13513.94903,13784.22801,14059.91257,14341.11082]
[null,"Professional Fees"," ",{"$f":"Operations!E26","v":5000},{"$f":"$E22*D28+D28","v":5100},5202,5306.04,5412.1608,5520.404016,5630.812096,5743.428338,5858.296905,5975.462843]
[null,"Telephone/Internet",null,{"$f":"Operations!E27","v":3200},{"$f":"$E22*D29+D29","v":3264},3329.28,3395.8656,3463.782912,3533.05857,3603.719742,3675.794136,3749.310019,3824.29622]
[null,"Property Association Fees"," ",{"$f":"Operations!E28","v":0},{"$f":"$E22*D30+D30","v":0},0,0,0,0,0,0,0,0]
[null,"Management Fee"," ",{"$f":"Operations!E29","v":62484.50926},{"$f":"$E22*D31+D31","v":63734.19944},65008.88343,66309.0611,67635.24232,68987.94717,70367.70611,71775.06023,73210.56144,74674.77267]
[null,"Real Estate Taxes"," ",{"$f":"Operations!E30","v":40000},{"$f":"$E22*D32+D32","v":40800},41616,42448.32,43297.2864,44163.23213,45046.49677,45947.42671,46866.37524,47803.70274]
[null,"Depreciation Reserves",null,{"$f":"Operations!E31","v":15810.57482},{"$f":"$E22*D33+D33","v":16126.78632},16449.32205,16778.30849,17113.87466,17456.15215,17805.27519,18161.3807,18524.60831,18895.10048]
[null,"Utilities",null,{"$f":"Operations!E32","v":25000},{"$f":"$E22*D34+D34","v":25500},26010,26530.2,27060.804,27602.02008,28154.06048,28717.14169,29291.48453,29877.31422]
[null,"Insurance"," ",{"$f":"Operations!E33","v":22000},{"$f":"$E22*D35+D35","v":22440},22888.8,23346.576,23813.50752,24289.77767,24775.57322,25271.08469,25776.50638,26292.03651]
[null,"Total Operating Expenses"," ",{"$f":"Operations!E34","v":255495.0841},{"$f":"SUM(E23:E35)","v":260604.9858},265817.0855,{"$f":"SUM(G23:G34)","v":247786.8512},252742.5882,257797.44,262953.3888,268212.4565,273576.7057,279048.2398]
[null,"Expense Ratio",null,{"$f":"D36/D20","v":0.5059352421},0.3224863649,0.2356751583,0.1796829273,0.1700557105,0.1700557105,0.1700557105,0.1700557105,0.1700557105,0.1700557105]
[null,null,null," "," "," "]
[null,"NOI"," ",{"$f":"D20-D36","v":249500.5415},547506.6558,862078.987,1131235.936,1233491.467,1258161.296,1283324.522,1308991.013,1335170.833,1361874.25]
[null,null," "," "," "," "," "," "," "," "," "," "," "]
[null,"Cap Rate Value",{"$f":"Operations!C39","v":0.06},{"$f":"D39/$C41","v":4158342.359},9125110.931,14367983.12,18853932.26,20558191.12,20969354.94,21388742.04,21816516.88,22252847.22,22697904.16]
[]
[]
[]
[]
[null,null,null,{"$f":"D7","v":"Year 1"},"Year 2","Year 3","Year 4","Year 5","Year 6","Year 7","Year 8","Year 9","Year 10"]
[]
[null,"Projected NOI",null,{"$f":"D39","v":249500.5415},547506.6558,862078.987,1131235.936,1233491.467,1258161.296,1283324.522,1308991.013,1335170.833,1361874.25]
[null,"Debt Service",null,{"$f":"$D63","v":558048.6434},558048.6434,558048.6434,{"$f":"$D64","v":695627.89},695627.89,695627.89,695627.89,695627.89,695627.89,695627.89]
[]
[null,"Cash Flow (NOI - DS)",null,{"$f":"D48-D49","v":-308548.1019},-10541.98759,304030.3436,435608.0455,537863.5771,562533.4065,587696.6324,613363.1229,639542.9431,666246.3598]
[]
[null,"Cash on Cash Return from cash flow",null,{"$f":"D51/$D60","v":-0.1078165507},-0.003683706794,0.1062379018,0.1522153488,0.1879466939,0.1965671193,0.2053599532,0.2143286439,0.2234767083,0.232807734]
[]
[]
[null,"Total Return on Sale @ Cap Rate",{"$f":"C41","v":0.06},{"$f":"D41+D51-$D59","v":-7597357.403},{"$f":"E41+SUM(D51:E51)-$D59","v":-2641130.819},{"$f":"F41+SUM($D51:F51)-$D59","v":2905771.711},7827328.899,10069451.34,11043148.56,12050232.3,13091370.26,14167243.54,15278546.84]
[]
[]
[null,"Total Project Cost",null,{"$f":"'Development Cost'!I70","v":11447151.66},null,"Mortgage amount"," ",{"$f":"D61","v":8585363.745}]
[null,"Equity @ 25%",null,{"$f":"D59*0.25","v":2861787.915},null,"Interest rate"," ",0.065]
[null,"Construction Loan",null,{"$f":"SUM(D59-D60)","v":8585363.745},null,"Amortization"," ",25.0]
[{"$nulls":6}," "]
[null,"Loan Terms Yrs 1-3 IO",0.065,{"$f":"D61*C63","v":558048.6434},null,"Monthly Payment"," ",{"$f":"PMT(H60/12,H61*12,-H59)","v":57968.99083}]
[null,"Stabilized Mortgage Exp",null,{"$f":"H64","v":695627.89},null,"Total Payment"," ",{"$f":"H63*12","v":695627.89}]