{"text_format":"2","workbook":"xlsx","n_sheets":2,"sheets":["Lease Calculations ","Pro Forma"],"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":"Lease Calculations ","index":0,"n_rows":28,"n_cols":5,"rows_kept":28,"cut":false,"hidden":false,"merged":[]}
["NNN LEASE - 10 YEAR"]
["Year #","Building SF","Annual Base Rent Per SF","Monthly Rent","Annual Rent"]
["Year 1",56178,{"$f":"B16","v":20},{"$f":"(B3*C3)/12","v":93630},{"$f":"(D3*12)-(D3*3)","v":842670}]
["Year 2",56178,{"$f":"C3*B17","v":20.6},{"$f":"(B4*C4)/12","v":96438.900000000009},{"$f":"D4*12","v":1157266.8}]
["Year 3",56178,{"$f":"C4*B17","v":21.218000000000004},{"$f":"(B5*C5)/12","v":99332.067000000025},1191984.8040000002]
["Year 4",56178,{"$f":"C5*B17","v":21.854540000000004},102312.02901000001,1227744.3481200002]
["Year 5",56178,{"$f":"C6*B17","v":22.510176200000004},105381.38988030002,1264576.6785636002]
["Year 6",56178,{"$f":"C7*B17","v":23.185481486000004},108542.83157670901,1302513.9789205082]
["Year 7",56178,{"$f":"C8*B17","v":23.881045930580004},111799.1165240103,1341589.3982881235]
["Year 8",56178,{"$f":"C9*B17","v":24.597477308497407},115153.09001973062,1381837.0802367674]
["Year 9",56178,{"$f":"C10*B17","v":25.335401627752329},118607.68272032253,1423292.1926438704]
["Year 10",56178,{"$f":"C11*B17","v":26.095463676584899},122165.91320193221,1465990.9584231866]
[null,null,null,"Total",{"$f":"SUM(E3:E12)","v":12599466.239196055}]
[]
[]
["Total Rent $ per SF",20]
["Annual Rent Increase (3%)",1.03]
[]
["NNN Terms:"]
["1. The tenant pays those operating expenses on top of the base rent. Operating expenses include line items related to utilities, building insurance, maintenance costs, and property taxes. "]
["2. Two Months Deposit"]
["3. 3 Months Free Rent"]
["4. Lease Guaranteed for the 10 years"]
[]
[]
["DISCLAIMER: While the information is deemed reliable, no warranty is expressed or implied. "]
["Any information important to you or another party should be independently confirmed "]
["within an applicable due diligence period. "]

{"sheet":"Pro Forma","index":1,"n_rows":20,"n_cols":11,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
[null,"Year 1 ","Year 2","Year 3"," Year 4","Year 5","Year 6","Year 7","Year 8","Year 9","Year 10"]
["Potential Rental Income ($500 ADR and 84 Beds)",15330000,{"$f":"B2*B20","v":15789900},{"$f":"C2*B20","v":16263597},{"$f":"D2*B20","v":16751504.91},{"$f":"E2*B20","v":17254050.057300001},{"$f":"F2*B20","v":17771671.559019003},{"$f":"G2*B20","v":18304821.705789573},{"$f":"H2*B20","v":18853966.356963262},{"$f":"I2*B20","v":19419585.347672161},{"$f":"J2*B20","v":20002172.908102326}]
[]
["Occupancy",0.35,0.65,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8]
[]
["Gross Operating Income",{"$f":"B2*B4","v":5365500},{"$f":"C2*C4","v":10263435},13010877.600000001,13401203.928000001,13803240.045840003,14217337.247215204,14643857.36463166,15083173.085570611,15535668.278137729,16001738.326481862]
[]
["Expenses at 80%",{"$f":"B6*0.8","v":4292400},{"$f":"C6*0.8","v":8210748},10408702.080000002,10720963.142400002,11042592.036672004,11373869.797772164,11715085.891705329,12066538.46845649,12428534.622510184,12801390.66118549]
[]
["NOI",{"$f":"B6-B8","v":1073100},{"$f":"C6-C8","v":2052687},2602175.5199999996,2680240.7855999991,2760648.009167999,2843467.4494430404,2928771.4729263317,3016634.6171141211,3107133.655627545,3200347.665296372]
[]
["Annual Lease Service growing 3% ",{"$f":"'Lease Calculations '!E3","v":842670},{"$f":"'Lease Calculations '!E4","v":1157266.8},{"$f":"'Lease Calculations '!E5","v":1191984.8040000002},{"$f":"'Lease Calculations '!E6","v":1227744.3481200002},{"$f":"'Lease Calculations '!E7","v":1264576.6785636002},{"$f":"'Lease Calculations '!E8","v":1302513.9789205082},{"$f":"'Lease Calculations '!E9","v":1341589.3982881235},{"$f":"'Lease Calculations '!E10","v":1381837.0802367674},{"$f":"'Lease Calculations '!E11","v":1423292.1926438704},{"$f":"'Lease Calculations '!E12","v":1465990.9584231866}]
[]
["Cashflow",{"$f":"B10-B12","v":230430},{"$f":"C10-C12","v":895420.2},1410190.7159999993,1452496.4374799989,1496071.3306043989,1540953.4705225322,1587182.0746382081,1634797.5368773537,1683841.4629836746,1734356.7068731855]
[]
["% Occupancy | Break Even",{"$f":"(B8+B12)/B2","v":0.33496868884540115}]
[]
["Sales Price@ 10% CAP",{"$f":"B10/0.1","v":10731000},20526870,{"$f":"D10/0.1","v":26021755.199999996},{"$f":"E10/0.1","v":26802407.855999991},27606480.09167999,28434674.494430404,29287714.729263317,30166346.171141211,31071336.55627545,32003476.65296372]
[]
["Revenue increase per year",1.03]