{"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  11925 101 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",1860000]
[null,"1 br / 1 ba",1,1250,{"$f":"+C5*D5*12","v":15000},null,null,"Terminal Cap Rate",5.3499999999999999E-2]
[null,"1 br w Den",1,1350,{"$f":"+C6*D6*12","v":16200},null,null,"Cost of Sale EOY 5",0.03]
[null,"3 br / 1 ba",0,0,0]
[null,"bach",10,1100,132000]
[null,"Totals:",{"$f":"SUM(C5:C8)","v":12},{"$f":"+SUMPRODUCT(C5:C8,D5:D8)/C9","v":1133.3333333333333},{"$f":"SUM(E5:E8)","v":163200}]
[]
[null,"First Year Operating Statement",{"$nulls":5},"Financing Data"]
[null,"Potential Rental Income",null,{"$f":"E9","v":163200},null,null,null,"Loan Interest Rate",4.3999999999999997E-2]
[null,"Total Other Income Laundry revenue",250,3000,null,null,null,"Loan Amortization (years)",30]
[null,"Potential Gross Income",null,{"$f":"SUM(D12:D13)","v":166200},null,null,null,"LTV",0.7]
[null,"Vacancy & Credit Loss",0.02,{"$f":"-C15*D14","v":-3324},null,null,null,"DSCR",1.25]
[null,"Effective Gross Income",null,{"$f":"SUM(D14:D15)","v":162876},null,null,null,"Loan Amount (LTV)",{"$f":"I4*I14","v":1302000}]
[null,"Property Taxes",null,10500,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":1325745.1206982329}]
[null,"Insurance",null,9650,null,null,null,"Maximum Loan Amount",{"$f":"MIN(I16,I17)","v":1302000}]
[null,"Maintenance",null,12000,null,null,null,"Initial Equity",{"$f":"I4-I18","v":558000}]
[null,"Management Fee",0.05,{"$f":"C20*D16","v":8143.8},null,null,null,"Monthly Debt Service",{"$f":"IF(I18>0,PMT(I12/12,I13*12,-I18),0)","v":6519.90705079692}]
[null,"Other Expenses","Utilities",20000,null,null,null,"Annual Debt Service",{"$f":"I20*12","v":78238.884609563043}]
[null,"CapEx Reserves",250,{"$f":"C22*C9","v":3000}]
[null,"Total Expenses",null,{"$f":"SUM(D17:D22)","v":63293.8}]
[null,"Net Operating Income",null,{"$f":"D16-D23","v":99582.2}]
[null,"Operating Margin",null,0]
[null,"Debt Service",null,126192]
[null,"Cash Flow Before Tax",null,{"$f":"D24-D26","v":-26609.800000000003}]
[]
[]
[]
[]
[]
[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":163200},{"$f":"C4*(1+Data!D36)","v":171360},{"$f":"D4*(1+Data!E36)","v":174787.20000000001},{"$f":"E4*(1+Data!F36)","v":178282.94400000002},{"$f":"F4*(1+Data!G36)","v":181848.60288000002},{"$f":"G4*(1+Data!H36)","v":185485.57493760003}]
[null,"Total Other Income",{"$f":"Data!D13","v":3000},{"$f":"C5*(1+Data!D37)","v":3090},{"$f":"D5*(1+Data!E37)","v":3151.8},{"$f":"E5*(1+Data!F37)","v":3214.8360000000002},{"$f":"F5*(1+Data!G37)","v":3279.1327200000005},{"$f":"G5*(1+Data!H37)","v":3344.7153744000007}]
[null,"Potential Gross Income",{"$f":"SUM(C4:C5)","v":166200},{"$f":"SUM(D4:D5)","v":174450},177939,181497.78000000003,185127.73560000001,188830.29031200003]
[null,"Vacancy & Credit Loss",{"$f":"Data!D15","v":-3324},{"$f":"-D6*Data!D35","v":-13956},{"$f":"-E6*Data!E35","v":-8896.9500000000007},{"$f":"-F6*Data!F35","v":-9074.889000000001},{"$f":"-G6*Data!G35","v":-9256.3867800000007},{"$f":"-H6*Data!H35","v":-9441.5145156000017}]
[null,"Effective Gross Income",{"$f":"SUM(C6:C7)","v":162876},{"$f":"SUM(D6:D7)","v":160494},169042.05,172422.89100000003,175871.34882000001,179388.77579640003]
[null,"Operating Expenses",{"$f":"Data!D23","v":63293.8},{"$f":"C9*(1+Data!D38)","v":64559.676000000007},{"$f":"D9*(1+Data!E38)","v":65850.869520000007},{"$f":"E9*(1+Data!F38)","v":67167.886910400004},{"$f":"F9*(1+Data!G38)","v":68511.244648608001},{"$f":"G9*(1+Data!H38)","v":69881.469541580169}]
[null,"Net Operating Income",{"$f":"C8-C9","v":99582.2},{"$f":"D8-D9","v":95934.323999999993},103191.18047999998,105255.00408960003,107360.10417139201,109507.30625481986]
[null,"Operating Margin",{"$f":"C10/C8","v":0.61139885557110929},{"$f":"D10/D8","v":0.59774399042954873},0.61044681178440507,0.61044681178440519,0.61044681178440519,0.61044681178440519]
[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":-26609.800000000003},{"$f":"D10-D12","v":-30257.676000000007},-23000.819520000019,-20936.995910399972,-18831.895828607987]
[]
[]
[]
[null,"Future Sale Value",{"$nulls":4},{"$f":"G10/Data!I5","v":2006730.9190914396}]
[null,"less: Cost of Sale",{"$nulls":4},{"$f":"G17*Data!I6","v":60201.927572743181}]
[null,"less: Loan Balance",{"$nulls":4},{"$f":"FV(Data!I12/12,5*12,Data!I20,-Data!I18)","v":1185067.6503726449}]
[null,"Net Sale Proceeds",{"$nulls":4},{"$f":"G17-G18-G19","v":761461.34114605142}]