{"text_format":"2","workbook":"xlsx","n_sheets":1,"sheets":["ExampleSheet"],"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":"ExampleSheet","index":0,"n_rows":37,"n_cols":11,"rows_kept":37,"cut":false,"hidden":false,"merged":[]}
["Data Type","Year 1","Year 2","Year 3","Year 4","Year 5","Year 6","Year 7","Year 8","Year 9","Year 10"]
[{"$nulls":9},"Income statement"]
["Potential gross rent",51900,52938,53996.76,55076.7,56178.23,57301.8,58447.83,59616.79,60809.13,62025.31]
["Other income",0,0,0,0,0,0,0,0,0,0]
["Potential gross income",51900,52938,53996.76,55076.7,56178.23,57301.8,58447.83,59616.79,60809.13,62025.31]
["Vacancy loss",6228,6352.56,6479.61,6609.2,6741.39,6876.22,7013.74,7154.01,7297.1,7443.04]
["Concession loss",0,0,0,0,0,0,0,0,0,0]
["Effective gross income",45672,46585.440000000002,47517.15,48467.5,49436.84,50425.58,51434.09,52462.78,53512.03,54582.27]
["Expenses",17173.439999999999,17484.509999999998,17801.8,18125.43,18455.54,18792.25,19135.7,19486.009999999998,19843.330000000002,20207.8]
["NOI",28498.560000000001,29100.93,29715.35,30342.06,30981.3,31633.33,32298.39,32976.76,33668.699999999997,34374.47]
["Below NOI One Time Expense",0,0,0,0,0,0,0,0,0,0]
["Below NOI One Time Income",0,0,0,0,0,0,0,0,0,0]
["Below NOI Other Income",0,0,0,0,0,0,0,0,0,0]
["Debt service",0,0,0,0,0,0,0,0,0,0]
["Cash flow",28498.560000000001,29100.93,29715.35,30342.06,30981.3,31633.33,32298.39,32976.76,33668.699999999997,34374.47]
[{"$nulls":9},"Balance sheet"]
["Property value",474976,485015.52,495255.83,505701.02,516354.98,527222.16,538306.51,549612.68999999994,561145.01,572907.87]
["Plus return of working",0,0,0,0,0,0,0,0,0,0]
["Selling expenses",28498.560000000001,29100.93,29715.35,30342.06,30981.3,31633.33,32298.39,32976.76,33668.699999999997,34374.47]
["Mortgage balance",0,0,0,0,0,0,0,0,0,0]
["Prepayment penalty",0,0,0,0,0,0,0,0,0,0]
["Sales proceeds pre tax",446477.44,455914.59,465540.48,475358.96,485373.68,495588.83,506008.12,516635.93,527476.31000000006,538533.4]
[{"$nulls":9},"Financing"]
["Cash inflow from new loans",0,0,0,0,0,0,0,0,0,0]
["Less repayment of old loans",0,0,0,0,0,0,0,0,0,0]
["Less prepayment of old loans",0,0,0,0,0,0,0,0,0,0]
["Proceeds from financing",0,0,0,0,0,0,0,0,0,0]
[{"$nulls":9},"Financing measures"]
["Cash On Cash",6.3299999999999995E-2,6.4699999999999994E-2,6.6000000000000003E-2,6.7400000000000002E-2,6.88E-2,7.0300000000000001E-2,7.1800000000000003E-2,7.3300000000000004E-2,7.4800000000000005E-2,7.6399999999999996E-2]
["IRR",5.5599999999999997E-2,7.0400000000000004E-2,7.5300000000000006E-2,7.7800000000000008E-2,7.9299999999999995E-2,8.0299999999999996E-2,8.1000000000000003E-2,8.1500000000000003E-2,8.1900000000000001E-2,8.2200000000000009E-2]
["Equity multiple",1.06,1.1399999999999999,1.23,1.32,1.41,1.5,1.6,1.69,1.79,1.89]
["LTV",0,0,0,0,0,0,0,0,0,0]
["DSCR",0,0,0,0,0,0,0,0,0,0]
["Break even ratio",0.33090000000000003,0.33030000000000004,0.32969999999999999,0.32909999999999995,0.32850000000000001,0.32799999999999996,0.32740000000000002,0.32689999999999997,0.32630000000000003,0.32579999999999998]
["Operating expense ratio",0.376,0.37530000000000002,0.37459999999999999,0.374,0.37329999999999997,0.37270000000000003,0.37200000000000005,0.37140000000000001,0.37079999999999996,0.37020000000000003]
["Cap rate on basis",6.3299999999999995E-2,6.4699999999999994E-2,6.6000000000000003E-2,6.7400000000000002E-2,6.88E-2,7.0300000000000001E-2,7.1800000000000003E-2,7.3300000000000004E-2,7.4800000000000005E-2,7.6399999999999996E-2]
["Cash in the deal",450000,450000,450000,450000,450000,450000,450000,450000,450000,450000]