{"text_format":"2","workbook":"xlsx","n_sheets":2,"sheets":["Data","Proforma"],"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":"Data","index":0,"n_rows":38,"n_cols":9,"rows_kept":38,"cut":false,"hidden":false,"merged":[[32,1,32,8],[29,1,29,2],[0,1,0,8]]}
[null,"Quick Proforma Data Sunlight Apts 11715 124 Street"]
[]
[null,"Building Data",{"$nulls":5},"Investment Data"]
[null,"Unit Type (br/ba)","# of Units","Avg Rent /Mo","Total Annual Rent",null,null,"Purchase Price",3000000]
[null,"1 br / 1 ba",6,1150,{"$f":"+C5*D5*12","v":82800},null,null,"Terminal Cap Rate",6.0999999999999999E-2]
[null,"2 br / 1 ba",9,1295,{"$f":"+C6*D6*12","v":139860},null,null,"Cost of Sale EOY 5",0.03]
[null,"3 br / 1 ba",3,1495,53820]
[null,"bach",2,1050,25200]
[null,"Totals:",{"$f":"SUM(C5:C8)","v":20},{"$f":"+SUMPRODUCT(C5:C8,D5:D8)/C9","v":1257},{"$f":"SUM(E5:E8)","v":301680}]
[]
[null,"First Year Operating Statement",{"$nulls":5},"Financing Data"]
[null,"Potential Rental Income",null,{"$f":"E9","v":301680},null,null,null,"Loan Interest Rate",4.3999999999999997E-2]
[null,"Total Other Income Laundry revenue",500,5000,null,null,null,"Loan Amortization (years)",30]
[null,"Potential Gross Income",null,{"$f":"SUM(D12:D13)","v":306680},null,null,null,"LTV",0.7]
[null,"Vacancy & Credit Loss",0.02,{"$f":"-C15*D14","v":-6133.6},null,null,null,"DSCR",1.25]
[null,"Effective Gross Income",null,{"$f":"SUM(D14:D15)","v":300546.40000000002},null,null,null,"Loan Amount (LTV)",{"$f":"I4*I14","v":2100000}]
[null,"Property Taxes",null,26000,null,null,null,"Loan Amount (DSCR)",{"$f":"IF(I12=0,0,IF(ISERROR(PV(I12/12,I13*12,-D24/I15/12)),0,PV(I12/12,I13*12,-D24/I15/12)))","v":2336698.3647624059}]
[null,"Insurance",null,13000,null,null,null,"Maximum Loan Amount",{"$f":"MIN(I16,I17)","v":2100000}]
[null,"Maintenance",null,24000,null,null,null,"Initial Equity",{"$f":"I4-I18","v":900000}]
[null,"Management Fee",0.05,{"$f":"C20*D16","v":15027.320000000002},null,null,null,"Monthly Debt Service",{"$f":"IF(I18>0,PMT(I12/12,I13*12,-I18),0)","v":10515.97911418858}]
[null,"Other Expenses","Utilities",42000,null,null,null,"Annual Debt Service",{"$f":"I20*12","v":126191.74937026296}]
[null,"CapEx Reserves",250,{"$f":"C22*C9","v":5000}]
[null,"Total Expenses",null,{"$f":"SUM(D17:D22)","v":125027.32}]
[null,"Net Operating Income",null,{"$f":"D16-D23","v":175519.08000000002}]
[null,"Operating Margin",null,0]
[null,"Debt Service",null,126192]
[null,"Cash Flow Before Tax",null,{"$f":"D24-D26","v":49327.080000000016}]
[]
[]
[]
[]
[]
[null,"Inflation / Variable Rates"]
[null,null,"Year 1","Year 2","Year 3","Year 4","Year 5","Year 6"]
[null,"Vacancy",{"$f":"C15","v":0.02},0.08,0.05,0.05,0.05,0.05]
[null,"Potential Rental Income","N/A",0.05,0.02,0.02,0.02,0.02]
[null,"Other Income","N/A",0.03,0.02,0.02,0.02,0.02]
[null,"Operating Expenses","N/A",0.02,0.02,0.02,0.02,0.02]

{"sheet":"Proforma","index":1,"n_rows":20,"n_cols":8,"rows_kept":20,"cut":false,"hidden":false,"merged":[[0,1,0,7]]}
[null,"Proforma"]
[]
[null,null,"Year 1","Year 2","Year 3","Year 4","Year 5","Year 6"]
[null,"Potential Rental Income",{"$f":"Data!D12","v":301680},{"$f":"C4*(1+Data!D36)","v":316764},{"$f":"D4*(1+Data!E36)","v":323099.28000000003},{"$f":"E4*(1+Data!F36)","v":329561.26560000004},{"$f":"F4*(1+Data!G36)","v":336152.49091200007},{"$f":"G4*(1+Data!H36)","v":342875.54073024006}]
[null,"Total Other Income",{"$f":"Data!D13","v":5000},{"$f":"C5*(1+Data!D37)","v":5150},{"$f":"D5*(1+Data!E37)","v":5253},{"$f":"E5*(1+Data!F37)","v":5358.06},{"$f":"F5*(1+Data!G37)","v":5465.2212000000009},{"$f":"G5*(1+Data!H37)","v":5574.5256240000008}]
[null,"Potential Gross Income",{"$f":"SUM(C4:C5)","v":306680},{"$f":"SUM(D4:D5)","v":321914},328352.28000000003,334919.32560000004,341617.7121120001,348450.06635424006]
[null,"Vacancy & Credit Loss",{"$f":"Data!D15","v":-6133.6},{"$f":"-D6*Data!D35","v":-25753.119999999999},{"$f":"-E6*Data!E35","v":-16417.614000000001},{"$f":"-F6*Data!F35","v":-16745.966280000004},{"$f":"-G6*Data!G35","v":-17080.885605600004},{"$f":"-H6*Data!H35","v":-17422.503317712002}]
[null,"Effective Gross Income",{"$f":"SUM(C6:C7)","v":300546.40000000002},{"$f":"SUM(D6:D7)","v":296160.88},311934.66600000003,318173.35932000005,324536.82650640007,331027.56303652807]
[null,"Operating Expenses",{"$f":"Data!D23","v":125027.32},{"$f":"C9*(1+Data!D38)","v":127527.86640000001},{"$f":"D9*(1+Data!E38)","v":130078.42372800001},{"$f":"E9*(1+Data!F38)","v":132679.99220256001},{"$f":"F9*(1+Data!G38)","v":135333.59204661121},{"$f":"G9*(1+Data!H38)","v":138040.26388754343}]
[null,"Net Operating Income",{"$f":"C8-C9","v":175519.08000000002},{"$f":"D8-D9","v":168633.01360000001},181856.242272,185493.36711744004,189203.23445978886,192987.29914898463]
[null,"Operating Margin",{"$f":"C10/C8","v":0.58399994143999068},{"$f":"D10/D8","v":0.56939665225197877},0.58299465270717932,0.58299465270717943,0.58299465270717943,0.58299465270717943]
[null,"Debt Service",{"$f":"Data!$D$26","v":126192},{"$f":"Data!$D$26","v":126192},{"$f":"Data!$D$26","v":126192},{"$f":"Data!$D$26","v":126192},{"$f":"Data!$D$26","v":126192}]
[null,"Cash Flow Before Tax",{"$f":"C10-C12","v":49327.080000000016},{"$f":"D10-D12","v":42441.013600000006},55664.242272000003,59301.367117440037,63011.234459788859]
[]
[]
[]
[null,"Future Sale Value",{"$nulls":4},{"$f":"G10/Data!I5","v":3101692.3681932599}]
[null,"less: Cost of Sale",{"$nulls":4},{"$f":"G17*Data!I6","v":93050.771045797796}]
[null,"less: Loan Balance",{"$nulls":4},{"$f":"FV(Data!I12/12,5*12,Data!I20,-Data!I18)","v":1911399.436084911}]
[null,"Net Sale Proceeds",{"$nulls":4},{"$f":"G17-G18-G19","v":1097242.161062551}]