{"text_format":"1","workbook":"xlsx","n_sheets":19,"sheets":["reportCreation","cmpLogo","HOME_FORM","Company Info","General Assumptions","Income Assumptions","Cover Page","tblReference","Executive Summary","Property Description","Property Photos","Cash Flow Analysis","Expense Assumptions","Mortgage Summary","Amortization Schedule","Graphs CashFlowProj_CashRet","Graphs CapRate_DebtRat","About Us","Terms & Definitions"],"not_rendered":{"charts":5,"images":3,"macros":1,"external_links":8,"defined_names":134,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"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":"reportCreation","index":0,"n_rows":2,"n_cols":2,"rows_kept":2,"cut":false,"hidden":true,"merged":[[1,1,4,7]]}
[]
[null,"Printing: Please check which pages you'd like generated in the report"]

{"sheet":"cmpLogo","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"HOME_FORM","index":2,"n_rows":9,"n_cols":9,"rows_kept":9,"cut":false,"hidden":false,"merged":[[8,1,8,4],[8,8,8,11],[4,1,6,12]]}
[]
[]
[]
[]
[null,"Real Estate Investment Analysis Software"]
[]
[]
[]
[null,"Inputs",null,null,null,null,null,null,"Marketing Reports"]

{"sheet":"Company Info","index":3,"n_rows":11,"n_cols":2,"rows_kept":11,"cut":false,"hidden":true,"merged":[]}
["Your COMPANY Information"]
["Your Name","[Enter Name]"]
["Your Company Name","[Enter Company Name]"]
["Company Address","[Enter Company Address]"]
["City, State, Zip","[Enter City, State, Zip]"]
["Phone with Area Code","[Enter Phone]"]
[]
["PROPERTY Information"]
["Property Name","[Enter Property Name]"]
["Property Street Address","[Enter Property Street Address]"]
["City, State, Zip","[Enter City, State, Zip]"]

{"sheet":"General Assumptions","index":4,"n_rows":42,"n_cols":3,"rows_kept":42,"cut":false,"hidden":true,"merged":[[3,1,5,6]]}
[]
[]
[]
[null,"Real Estate Investment Analysis Software"]
[]
[]
[]
[]
[null,"GENERAL ASSUMPTIONS"]
[]
[null,"Property"]
[null,"Purhase Price",1000000]
[null,"*Closing Costs",10000]
[null,"Cash Reserves ",2000]
[null,"Initial Improvements ",5000]
[null,"Total Cost",{"$f":"C12+C13+C15","v":1015000}]
[null,"*Include commissions, legal, appraisal, home inspection, applicances"]
[]
[null,"Mortgage Details"]
[null,"Down Payment %",0.3]
[null,"Total Equity Investment",{"$f":"C12*C20","v":300000}]
[null,"Total Loan Amount ",{"$f":"C12-C21","v":700000}]
[null,"Interest Rate",3.2399999999999998E-2]
[null,"**Mortgage Compounding Frequency",2]
[null,"Amortization (yrs)",25]
[null,"Total Number of Monthly Payments",{"$f":"C25*12","v":300}]
[null,"Mortgage Start Date","2020-07-01"]
[null,"Monthly Mortgage Payment",{"$f":"'Amortization Schedule'!K18","v":3399.519167287664}]
[null,"**Enter 1 for Annually, 2 for Semi-Annually, 4 for Quarterly, 12 for Monthly"]
[]
[null,"Exit Assumptions"]
[null,"Length of Hold (yrs)",7]
[null,"Annual Appreciation ",0.03]
[null,"Projected Sale Price",{"$f":"C12*(1+C33)^MIN(C32,C32)","v":1229873.86542487}]
[null,"  less Closing Costs",0.06]
[null,"  less Rehab Costs",2500]
[null,"Adjusted Sale Price ",{"$f":"C34*(1-C35)-C36","v":1153581.4334993777}]
[]
[null,"Core Deal Assumptions"]
[null,"Discount Rate (%) for NPV Calculation",0.06]
[null,"Rent Growth Rate (%/yr)",2.5000000000000001E-2]
[null,"Annual Property Appreciation (%)",0.03]

{"sheet":"Income Assumptions","index":5,"n_rows":50,"n_cols":5,"rows_kept":50,"cut":false,"hidden":true,"merged":[[3,1,5,7]]}
[]
[]
[]
[null,"Real Estate Investment Analysis Software"]
[]
[]
[]
[null,null,"INCOME ASSUMPTIONS"]
[]
[null,null,"Type of Property: ","Single Family"]
[]
[null,null,"RENT ROLL "]
[]
[null,null,"Unit Type","Number of Units","Lease Amount "]
[]
[null,1,{"$f":"IF(D10=\"Type Of Property\",\"\",IF(ISNA(VLOOKUP(CONCATENATE(B16,D10),tblReference!C:D,2,FALSE)),\"\",VLOOKUP(CONCATENATE(B16,D10),tblReference!C:D,2,FALSE)))","v":"Single Family"},{"$f":"IF(C16=\"\",\"\",VLOOKUP(C16,tblReference!D:F,2,FALSE))","v":1},6000]
[null,{"$f":"B16+1","v":2},{"$f":"IF(D10=\"Type Of Property\",\"\",IF(ISNA(VLOOKUP(CONCATENATE(B17,D10),tblReference!C:D,2,FALSE)),\"\",VLOOKUP(CONCATENATE(B17,D10),tblReference!C:D,2,FALSE)))","v":""},{"$f":"IF(C17=\"\",\"\",VLOOKUP(C17,tblReference!D:F,2,FALSE))","v":""}]
[null,{"$f":"B17+1","v":3},{"$f":"IF(D10=\"Type Of Property\",\"\",IF(ISNA(VLOOKUP(CONCATENATE(B18,D10),tblReference!C:D,2,FALSE)),\"\",VLOOKUP(CONCATENATE(B18,D10),tblReference!C:D,2,FALSE)))","v":""},{"$f":"IF(C18=\"\",\"\",VLOOKUP(C18,tblReference!D:F,2,FALSE))","v":""}]
[null,4]
[null,5]
[null,6]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,{"$f":"SUM(D16:D35)","v":1},{"$f":"SUMPRODUCT(D16:D35,E16:E35)","v":6000}]
[]
[null,null,"OTHER INCOME"]
[]
[null,null,null,null,"Monthly Total"]
[null,null,"Laundry",null,0]
[null,null,"Parking ",null,0]
[null,null,"Vending Machines",null,0]
[null,null,"Other",null,0]
[]
[null,null,null,null,{"$f":"SUM(E42:E46)","v":0}]
[]
[null,null,"GROSS RENTAL INCOME MONTHLY ",null,{"$f":"E37+E47","v":6000}]
[null,null,"ANNUAL GROSS RENTAL INCOME ",null,{"$f":"E49*12","v":72000}]

{"sheet":"Cover Page","index":6,"n_rows":58,"n_cols":2,"rows_kept":58,"cut":false,"hidden":true,"merged":[[15,0,15,10],[18,0,18,10],[4,0,6,10]]}
[]
[]
[]
[]
["Real Estate Investment Analysis Software"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["RENTAL PROPERTY INVESTMENT PROPOSAL"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,{"$f":"'Company Info'!B2","v":"[Enter Name]"}]
[null,{"$f":"'Company Info'!B3","v":"[Enter Company Name]"}]
[null,{"$f":"'Company Info'!B4","v":"[Enter Company Address]"}]
[null,{"$f":"'Company Info'!B5","v":"[Enter City, State, Zip]"}]

{"sheet":"tblReference","index":7,"n_rows":5,"n_cols":6,"rows_kept":5,"cut":false,"hidden":true,"merged":[]}
["Record Num (col B on inc. Assumption)","Type Of Property","Concatenate","Unit Type","Number Of Units","Lease Amount"]
[1,"Single Family",{"$f":"CONCATENATE(A2,B2)","v":"1Single Family"},"Single Family",1,6500]
[1,"Multi-Tenant",{"$f":"CONCATENATE(A3,B3)","v":"1Multi-Tenant"},"1 Bedroom",5,450]
[2,"Multi-Tenant",{"$f":"CONCATENATE(A4,B4)","v":"2Multi-Tenant"},"2 Bedroom",8,650]
[3,"Multi-Tenant",{"$f":"CONCATENATE(A5,B5)","v":"3Multi-Tenant"},"3 Bedroom",4,1250]

{"sheet":"Executive Summary","index":8,"n_rows":52,"n_cols":9,"rows_kept":52,"cut":false,"hidden":true,"merged":[[21,6,21,9],[42,4,42,5],[43,4,43,5],[44,4,44,5],[45,4,45,5],[42,6,42,7],[43,6,43,7],[44,6,44,7],[45,6,45,7],[42,8,42,9],[43,8,43,9],[44,8,44,9],[45,8,45,9],[31,8,31,9],[38,8,38,9],[39,8,39,9],[37,6,37,7],[38,6,38,7],[39,6,39,7],[36,4,36,5],[37,4,37,5],[49,8,49,9],[50,8,50,9],[51,8,51,9],[23,4,23,5],[24,4,24,5],[25,4,25,5],[26,4,26,5],[27,4,27,5],[31,4,31,5],[31,6,31,7],[33,6,33,7],[34,6,34,7],[35,6,35,7],[33,4,33,5],[34,4,34,5],[35,4,35,5],[7,6,7,9],[4,1,6,9],[29,4,29,5],[47,6,47,9],[48,8,48,9],[41,4,41,5],[41,6,41,7],[41,8,41,9],[33,8,33,9],[34,8,34,9],[35,8,35,9],[36,8,36,9],[37,8,37,9],[38,4,38,5],[39,4,39,5],[36,6,36,7]]}
[]
[]
[]
[]
[null,"Real Estate Investment Analysis Software"]
[]
[]
[null,"Executive Summary"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,{"$f":"'Company Info'!B9","v":"[Enter Property Name]"}]
[null,null,null,null,null,null,{"$f":"'Company Info'!B10","v":"[Enter Property Street Address]"}]
[null,null,null,null,null,null,{"$f":"'Company Info'!B11","v":"[Enter City, State, Zip]"}]
[]
[null,"Property  Overview",null,null,null,null,"Projected Cash Flow "]
[]
[null,"Type of Property",null,null,{"$f":"'Income Assumptions'!D10","v":"Single Family"}]
[null,"Purchase Price",null,null,{"$f":"'General Assumptions'!C12","v":1000000}]
[null,"Closing Costs",null,null,{"$f":"'General Assumptions'!C13","v":10000}]
[null,"Cash Reserves ",null,null,{"$f":"'General Assumptions'!C14","v":2000}]
[null,"Initial Improvements ",null,null,{"$f":"'General Assumptions'!C15","v":5000}]
[]
[null,"Total Acquisition Cost",null,null,{"$f":"'General Assumptions'!C16","v":1015000}]
[]
[null,"Operating Cash Flow",null,null,"Year 1",null,"Year 3",null,"Year 7"]
[]
[null,"Total Annual Income",null,null,{"$f":"'Cash Flow Analysis'!D12","v":72000},null,{"$f":"'Cash Flow Analysis'!F12","v":75645},null,{"$f":"'Cash Flow Analysis'!J12","v":83497.926111328125}]
[null,"  less Vacancy/Bad Debts",null,null,{"$f":"'Cash Flow Analysis'!D13","v":-3600},null,{"$f":"'Cash Flow Analysis'!F13","v":-3782.25},null,{"$f":"'Cash Flow Analysis'!J13","v":-4174.8963055664062}]
[null,"  less Operating Expenses",null,null,{"$f":"'Cash Flow Analysis'!D14","v":-15084},null,{"$f":"'Cash Flow Analysis'!F14","v":-15693.393599999999},null,{"$f":"'Cash Flow Analysis'!J14","v":-16987.033932178176}]
[null,"Net Operating Income (NOI)",null,null,{"$f":"'Cash Flow Analysis'!D15","v":53316},null,{"$f":"'Cash Flow Analysis'!F15","v":56169.356400000004},null,{"$f":"'Cash Flow Analysis'!J15","v":62335.995873583539}]
[null,"   less Debt Service",null,null,{"$f":"'Cash Flow Analysis'!D16","v":-40794.230007451974},null,{"$f":"'Cash Flow Analysis'!F16","v":-40794.230007451974},null,{"$f":"'Cash Flow Analysis'!J16","v":-40794.230007451974}]
[null,"   less Capital Expenditures",null,null,{"$f":"'Cash Flow Analysis'!D17","v":-5000},null,{"$f":"'Cash Flow Analysis'!F17","v":0},null,{"$f":"'Cash Flow Analysis'!J17","v":0}]
[null,"Annual Cash Flow ",null,null,{"$f":"'Cash Flow Analysis'!D18","v":7521.7699925480265},null,{"$f":"'Cash Flow Analysis'!F18","v":15375.126392548031},null,{"$f":"'Cash Flow Analysis'!J18","v":21541.765866131565}]
[]
[null,"Return Measures",null,null,"Year 1",null,"Year 3",null,"Year 7"]
[null,"Debt Service Coverage Ratio",null,null,{"$f":"'Cash Flow Analysis'!D40","v":1.3069495364972117},null,{"$f":"'Cash Flow Analysis'!F40","v":1.3768946341122119},null,{"$f":"'Cash Flow Analysis'!J40","v":1.5280591363581684}]
[null,"Operating Expense Ratio ",null,null,{"$f":"'Cash Flow Analysis'!D41","v":0.20949999999999999},null,{"$f":"'Cash Flow Analysis'!F41","v":0.20746108268887567},null,{"$f":"'Cash Flow Analysis'!J41","v":0.20344258502336088}]
[null,"Capitalization Rate (Cap Rate) ",null,null,{"$f":"'Cash Flow Analysis'!D42","v":5.2528078817733991E-2},null,{"$f":"'Cash Flow Analysis'!F42","v":5.5339267389162568E-2},null,{"$f":"'Cash Flow Analysis'!J42","v":6.1414774259688214E-2}]
[null,"Cash-on-Cash Return (%)",null,null,{"$f":"'Cash Flow Analysis'!D43","v":2.3727981049047404E-2},null,{"$f":"'Cash Flow Analysis'!F43","v":4.8501976001728807E-2},null,{"$f":"'Cash Flow Analysis'!J43","v":6.79550973695002E-2}]
[]
[null,"Core Deal Assumptions",null,null,null,null,"Mortgage Summary"]
[null,"Rental Growth Rate ",null,null,{"$f":"'General Assumptions'!C41","v":2.5000000000000001E-2},null,"Total Loan Amount ",null,{"$f":"'General Assumptions'!C22","v":700000}]
[null,"Expense Growth Rate",null,null,{"$f":"'Expense Assumptions'!D38","v":0.02},null,"Interest Rate",null,{"$f":"'General Assumptions'!C23","v":3.2399999999999998E-2}]
[null,"Annual Vacancy ",null,null,{"$f":"'Expense Assumptions'!D39","v":0.05},null,"Monthly Payment",null,{"$f":"'General Assumptions'!C28","v":3399.519167287664}]
[null,"Annual Property Appreciation ",null,null,{"$f":"'General Assumptions'!C33","v":0.03},null,"Total Investment",null,{"$f":"'General Assumptions'!C21","v":300000}]

{"sheet":"Property Description","index":9,"n_rows":23,"n_cols":7,"rows_kept":23,"cut":false,"hidden":true,"merged":[[4,1,6,9],[7,1,7,9],[22,1,49,9]]}
[]
[]
[]
[]
[null,"Real Estate Investment Analysis Software"]
[]
[]
[null,"Property Overview"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,{"$f":"'Company Info'!B9","v":"[Enter Property Name]"}]
[null,null,null,null,null,null,{"$f":"'Company Info'!B10","v":"[Enter Property Street Address]"}]
[null,null,null,null,null,null,{"$f":"'Company Info'!B11","v":"[Enter City, State, Zip]"}]
[]
[]
[null,"Enter Text Here [Double Click To Enter Box]"]

{"sheet":"Property Photos","index":10,"n_rows":68,"n_cols":11,"rows_kept":68,"cut":false,"hidden":true,"merged":[[4,1,6,14],[52,1,53,5],[52,10,53,14],[67,1,68,5],[67,10,68,14],[7,1,8,14],[22,1,23,5],[22,10,23,14],[37,1,38,5],[37,10,38,14],[9,1,10,14]]}
[]
[]
[]
[]
[null,"Real Estate Investment Analysis Software"]
[]
[]
[null,{"$f":"'Company Info'!B9","v":"[Enter Property Name]"}]
[]
[null,{"$f":"CONCATENATE('Company Info'!B10,CHAR(10),'Company Info'!B11)","v":"[Enter Property Street Address]\n[Enter City, State, Zip]"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Enter Description",null,null,null,null,null,null,null,null,"Enter Description"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Enter Description",null,null,null,null,null,null,null,null,"Enter Description"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Enter Description",null,null,null,null,null,null,null,null,"Enter Description"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Enter Description",null,null,null,null,null,null,null,null,"Enter Description"]

{"sheet":"Cash Flow Analysis","index":11,"n_rows":48,"n_cols":22,"rows_kept":48,"cut":false,"hidden":true,"merged":[[4,1,6,12]]}
[]
[]
[]
[]
[null,"Real Estate Investment Analysis Software"]
[]
[]
[]
[null,"CASH FLOW ANALYSIS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pie Chart"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Annual Income",{"$f":"D18","v":7521.7699925480265}]
[null,"Operating Cash Flow",null,1,{"$f":"D11+1","v":2},{"$f":"E11+1","v":3},4,5,6,7,{"$f":"J11+1","v":8},9,10,null,null,null,null,null,null,null,"Vacancy/Bad Debts",{"$f":"-D13","v":3600}]
[null,"Total Annual Income",null,{"$f":"'Income Assumptions'!$E$49*12","v":72000},{"$f":"((D12*'General Assumptions'!$C$41)+D12)*IF(E11<='General Assumptions'!$C$32,1,0)","v":73800},{"$f":"((E12*'General Assumptions'!$C$41)+E12)*IF(F11<='General Assumptions'!$C$32,1,0)","v":75645},{"$f":"((F12*'General Assumptions'!$C$41)+F12)*IF(G11<='General Assumptions'!$C$32,1,0)","v":77536.125},{"$f":"((G12*'General Assumptions'!$C$41)+G12)*IF(H11<='General Assumptions'!$C$32,1,0)","v":79474.528124999997},{"$f":"((H12*'General Assumptions'!$C$41)+H12)*IF(I11<='General Assumptions'!$C$32,1,0)","v":81461.391328124999},{"$f":"((I12*'General Assumptions'!$C$41)+I12)*IF(J11<='General Assumptions'!$C$32,1,0)","v":83497.926111328125},{"$f":"((J12*'General Assumptions'!$C$41)+J12)*IF(K11<='General Assumptions'!$C$32,1,0)","v":0},{"$f":"((K12*'General Assumptions'!$C$41)+K12)*IF(L11<='General Assumptions'!$C$32,1,0)","v":0},{"$f":"((L12*'General Assumptions'!$C$41)+L12)*IF(M11<='General Assumptions'!$C$32,1,0)","v":0},null,null,null,null,null,null,null,"Operating Expenses",{"$f":"-D14","v":15084}]
[null,"  less Vacancy/Bad Debts",null,{"$f":"-D12*'Expense Assumptions'!$D$39","v":-3600},{"$f":"-E12*'Expense Assumptions'!$D$39","v":-3690},{"$f":"-F12*'Expense Assumptions'!$D$39","v":-3782.25},{"$f":"-G12*'Expense Assumptions'!$D$39","v":-3876.8062500000001},{"$f":"-H12*'Expense Assumptions'!$D$39","v":-3973.7264062499999},{"$f":"-I12*'Expense Assumptions'!$D$39","v":-4073.06956640625},{"$f":"-J12*'Expense Assumptions'!$D$39","v":-4174.8963055664062},{"$f":"-K12*'Expense Assumptions'!$D$39","v":0},{"$f":"-L12*'Expense Assumptions'!$D$39","v":0},{"$f":"-M12*'Expense Assumptions'!$D$39","v":0},null,null,null,null,null,null,null,"Debt Service",{"$f":"-D16","v":40794.230007451974}]
[null,"  less Operating Expenses",null,{"$f":"-'Expense Assumptions'!$D$35","v":-15084},{"$f":"((D14*'Expense Assumptions'!$D$38)+D14)*IF(E11<='General Assumptions'!$C$32,1,0)","v":-15385.68},{"$f":"((E14*'Expense Assumptions'!$D$38)+E14)*IF(F11<='General Assumptions'!$C$32,1,0)","v":-15693.393599999999},{"$f":"((F14*'Expense Assumptions'!$D$38)+F14)*IF(G11<='General Assumptions'!$C$32,1,0)","v":-16007.261472},{"$f":"((G14*'Expense Assumptions'!$D$38)+G14)*IF(H11<='General Assumptions'!$C$32,1,0)","v":-16327.406701440001},{"$f":"((H14*'Expense Assumptions'!$D$38)+H14)*IF(I11<='General Assumptions'!$C$32,1,0)","v":-16653.954835468801},{"$f":"((I14*'Expense Assumptions'!$D$38)+I14)*IF(J11<='General Assumptions'!$C$32,1,0)","v":-16987.033932178176},{"$f":"((J14*'Expense Assumptions'!$D$38)+J14)*IF(K11<='General Assumptions'!$C$32,1,0)","v":0},{"$f":"((K14*'Expense Assumptions'!$D$38)+K14)*IF(L11<='General Assumptions'!$C$32,1,0)","v":0},{"$f":"((L14*'Expense Assumptions'!$D$38)+L14)*IF(M11<='General Assumptions'!$C$32,1,0)","v":0},null,null,null,null,null,null,null,"Capital Expenditures",{"$f":"-D17","v":5000}]
[null,"Net Operating Income (NOI)",null,{"$f":"D12+D13+D14","v":53316},{"$f":"E12+E13+E14","v":54724.32},56169.356400000004,57652.057278000007,59173.395017309995,60734.366926249946,62335.995873583539,{"$f":"K12+K13+K14","v":0},0,0]
[null,"   less Debt Service",null,{"$f":"'Mortgage Summary'!C24+'Mortgage Summary'!C25","v":-40794.230007451974},{"$f":"'Mortgage Summary'!D24+'Mortgage Summary'!D25","v":-40794.230007451974},{"$f":"'Mortgage Summary'!E24+'Mortgage Summary'!E25","v":-40794.230007451974},{"$f":"'Mortgage Summary'!F24+'Mortgage Summary'!F25","v":-40794.230007451974},{"$f":"'Mortgage Summary'!G24+'Mortgage Summary'!G25","v":-40794.230007451974},{"$f":"'Mortgage Summary'!H24+'Mortgage Summary'!H25","v":-40794.230007451974},{"$f":"'Mortgage Summary'!I24+'Mortgage Summary'!I25","v":-40794.230007451974},{"$f":"'Mortgage Summary'!J24+'Mortgage Summary'!J25","v":0},{"$f":"'Mortgage Summary'!K24+'Mortgage Summary'!K25","v":0},{"$f":"'Mortgage Summary'!L24+'Mortgage Summary'!L25","v":0}]
[null,"   less Capital Expenditures",null,{"$f":"-'General Assumptions'!C15","v":-5000},0,0,0,0,0,0,0,0,0]
[null,"Annual Cash Flow ",null,{"$f":"D15+D16+D17","v":7521.7699925480265},{"$f":"E15+E16+E17","v":13930.089992548026},15375.126392548031,16857.827270548034,18379.165009858021,19940.136918797973,21541.765866131565,{"$f":"K15+K16+K17","v":0},0,0]
[]
[null,"Property Overview"]
[null,"Purhase Price",{"$f":"-'General Assumptions'!C12","v":-1000000}]
[null,"Add Closing Costs",{"$f":"-'General Assumptions'!C13","v":-10000}]
[null,"Add Cash Reserves ",{"$f":"-'General Assumptions'!C14","v":-2000}]
[null,"Add Initial Improvements ",{"$f":"-'General Assumptions'!C15","v":-5000}]
[null,"Total Acquisition Cost",{"$f":"SUM(C21:C24)","v":-1017000}]
[]
[null,"Property Resale Analysis",null,1,{"$f":"D27+1","v":2},{"$f":"E27+1","v":3},{"$f":"F27+1","v":4},{"$f":"G27+1","v":5},{"$f":"H27+1","v":6},{"$f":"I27+1","v":7},{"$f":"J27+1","v":8},{"$f":"K27+1","v":9},{"$f":"L27+1","v":10}]
[null,"Projected Sale Price  ",null,{"$f":"IF(D11='General Assumptions'!$C$32,'General Assumptions'!$C$34,'General Assumptions'!C12+'General Assumptions'!C12*'General Assumptions'!C42)*IF(D11>'General Assumptions'!$C$32,0,1)","v":1030000},{"$f":"IF(E11='General Assumptions'!$C$32,'General Assumptions'!$C$34,D28+D28*'General Assumptions'!$C$42)*IF(E11>'General Assumptions'!$C$32,0,1)","v":1060900},{"$f":"IF(F11='General Assumptions'!$C$32,'General Assumptions'!$C$34,E28+E28*'General Assumptions'!$C$42)*IF(F11>'General Assumptions'!$C$32,0,1)","v":1092727},{"$f":"IF(G11='General Assumptions'!$C$32,'General Assumptions'!$C$34,F28+F28*'General Assumptions'!$C$42)*IF(G11>'General Assumptions'!$C$32,0,1)","v":1125508.81},{"$f":"IF(H11='General Assumptions'!$C$32,'General Assumptions'!$C$34,G28+G28*'General Assumptions'!$C$42)*IF(H11>'General Assumptions'!$C$32,0,1)","v":1159274.0743},{"$f":"IF(I11='General Assumptions'!$C$32,'General Assumptions'!$C$34,H28+H28*'General Assumptions'!$C$42)*IF(I11>'General Assumptions'!$C$32,0,1)","v":1194052.2965289999},{"$f":"IF(J11='General Assumptions'!$C$32,'General Assumptions'!$C$34,I28+I28*'General Assumptions'!$C$42)*IF(J11>'General Assumptions'!$C$32,0,1)","v":1229873.86542487},{"$f":"IF(K11='General Assumptions'!$C$32,'General Assumptions'!$C$34,J28+J28*'General Assumptions'!$C$42)*IF(K11>'General Assumptions'!$C$32,0,1)","v":0},{"$f":"IF(L11='General Assumptions'!$C$32,'General Assumptions'!$C$34,K28+K28*'General Assumptions'!$C$42)*IF(L11>'General Assumptions'!$C$32,0,1)","v":0},{"$f":"IF(M11='General Assumptions'!$C$32,'General Assumptions'!$C$34,L28+L28*'General Assumptions'!$C$42)*IF(M11>'General Assumptions'!$C$32,0,1)","v":0}]
[null,"  less Commission & Selling Costs",null,{"$f":"-D28*'General Assumptions'!$C$35","v":-61800},{"$f":"-E28*'General Assumptions'!$C$35","v":-63654},{"$f":"-F28*'General Assumptions'!$C$35","v":-65563.62},{"$f":"-G28*'General Assumptions'!$C$35","v":-67530.528600000005},{"$f":"-H28*'General Assumptions'!$C$35","v":-69556.444457999998},{"$f":"-I28*'General Assumptions'!$C$35","v":-71643.137791739995},{"$f":"-J28*'General Assumptions'!$C$35","v":-73792.431925492201},{"$f":"-K28*'General Assumptions'!$C$35","v":0},{"$f":"-L28*'General Assumptions'!$C$35","v":0},{"$f":"-M28*'General Assumptions'!$C$35","v":0}]
[null,"  less Rehab Costs",null,{"$f":"IF(D27='General Assumptions'!$C$32,'General Assumptions'!$C$36,0)","v":0},{"$f":"IF(E27='General Assumptions'!$C$32,'General Assumptions'!$C$36,0)","v":0},{"$f":"IF(F27='General Assumptions'!$C$32,'General Assumptions'!$C$36,0)","v":0},{"$f":"IF(G27='General Assumptions'!$C$32,'General Assumptions'!$C$36,0)","v":0},{"$f":"IF(H27='General Assumptions'!$C$32,'General Assumptions'!$C$36,0)","v":0},{"$f":"IF(I27='General Assumptions'!$C$32,'General Assumptions'!$C$36,0)","v":0},{"$f":"IF(J27='General Assumptions'!$C$32,'General Assumptions'!$C$36,0)","v":2500},{"$f":"IF(K27='General Assumptions'!$C$32,'General Assumptions'!$C$36,0)","v":0},{"$f":"IF(L27='General Assumptions'!$C$32,'General Assumptions'!$C$36,0)","v":0},{"$f":"IF(M27='General Assumptions'!$C$32,'General Assumptions'!$C$36,0)","v":0}]
[null,"Adjusted Sale Price  ",null,{"$f":"(D28+D29+D30)","v":968200},{"$f":"(E28+E29+E30)","v":997246},1027163.38,1057978.2814,1089717.6298420001,1122409.1587372599,1158581.4334993779,{"$f":"(K28+K29+K30)","v":0},0,0]
[]
[null,"add Mortgage Balance",{"$f":"'General Assumptions'!C22","v":700000}]
[null,"less Mortgage Balance Payoff",null,{"$f":"-IF(D11='General Assumptions'!$C$32,-SUMIF('Mortgage Summary'!22:22,'Cash Flow Analysis'!D11,'Mortgage Summary'!26:26),'Mortgage Summary'!C27)","v":-681462.32065455709},{"$f":"-IF(E11='General Assumptions'!$C$32,-SUMIF('Mortgage Summary'!22:22,'Cash Flow Analysis'!E11,'Mortgage Summary'!26:26),'Mortgage Summary'!D27)","v":-662319.15546975436},{"$f":"-IF(F11='General Assumptions'!$C$32,-SUMIF('Mortgage Summary'!22:22,'Cash Flow Analysis'!F11,'Mortgage Summary'!26:26),'Mortgage Summary'!E27)","v":-642550.72780069301},{"$f":"-IF(G11='General Assumptions'!$C$32,-SUMIF('Mortgage Summary'!22:22,'Cash Flow Analysis'!G11,'Mortgage Summary'!26:26),'Mortgage Summary'!F27)","v":-622136.61504899652},{"$f":"-IF(H11='General Assumptions'!$C$32,-SUMIF('Mortgage Summary'!22:22,'Cash Flow Analysis'!H11,'Mortgage Summary'!26:26),'Mortgage Summary'!G27)","v":-601055.72756439459},{"$f":"-IF(I11='General Assumptions'!$C$32,-SUMIF('Mortgage Summary'!22:22,'Cash Flow Analysis'!I11,'Mortgage Summary'!26:26),'Mortgage Summary'!H27)","v":-579286.28685718006},{"$f":"-IF(J11='General Assumptions'!$C$32,-SUMIF('Mortgage Summary'!22:22,'Cash Flow Analysis'!J11,'Mortgage Summary'!26:26),'Mortgage Summary'!I27)","v":-556805.80309903261},{"$f":"-IF(K11='General Assumptions'!$C$32,-SUMIF('Mortgage Summary'!22:22,'Cash Flow Analysis'!K11,'Mortgage Summary'!26:26),'Mortgage Summary'!J27)","v":0},{"$f":"-IF(L11='General Assumptions'!$C$32,-SUMIF('Mortgage Summary'!22:22,'Cash Flow Analysis'!L11,'Mortgage Summary'!26:26),'Mortgage Summary'!K27)","v":0},{"$f":"-IF(M11='General Assumptions'!$C$32,-SUMIF('Mortgage Summary'!22:22,'Cash Flow Analysis'!M11,'Mortgage Summary'!26:26),'Mortgage Summary'!L27)","v":0}]
[null,"Net Sale Proceeds ",null,{"$f":"D31+D34","v":286737.67934544291},{"$f":"E31+E34","v":334926.84453024564},384612.65219930699,435841.66635100346,488661.90227760549,543122.87188007985,601775.63040034531,0,0,0]
[]
[null,"Total Leveraged Cash Flow",{"$f":"C18+C33+C34+SUM(C21:C24)+C31","v":-317000},{"$f":"IF(D11='General Assumptions'!$C$32,D18+D33+D34+SUM(D21:D24)+D31,SUM(D21:D24)+'Cash Flow Analysis'!D18)","v":7521.7699925480265},{"$f":"IF(E11='General Assumptions'!$C$32,E18+E33+E34+SUM(E21:E24)+E31,SUM(E21:E24)+'Cash Flow Analysis'!E18)","v":13930.089992548026},{"$f":"IF(F11='General Assumptions'!$C$32,F18+F33+F34+SUM(F21:F24)+F31,SUM(F21:F24)+'Cash Flow Analysis'!F18)","v":15375.126392548031},{"$f":"IF(G11='General Assumptions'!$C$32,G18+G33+G34+SUM(G21:G24)+G31,SUM(G21:G24)+'Cash Flow Analysis'!G18)","v":16857.827270548034},{"$f":"IF(H11='General Assumptions'!$C$32,H18+H33+H34+SUM(H21:H24)+H31,SUM(H21:H24)+'Cash Flow Analysis'!H18)","v":18379.165009858021},{"$f":"IF(I11='General Assumptions'!$C$32,I18+I33+I34+SUM(I21:I24)+I31,SUM(I21:I24)+'Cash Flow Analysis'!I18)","v":19940.136918797973},{"$f":"IF(J11='General Assumptions'!$C$32,J18+J33+J34+SUM(J21:J24)+J31,SUM(J21:J24)+'Cash Flow Analysis'!J18)","v":623317.39626647683},{"$f":"IF(K11='General Assumptions'!$C$32,K18+K33+K34+SUM(K21:K24)+K31,SUM(K21:K24)+'Cash Flow Analysis'!K18)","v":0},{"$f":"IF(L11='General Assumptions'!$C$32,L18+L33+L34+SUM(L21:L24)+L31,SUM(L21:L24)+'Cash Flow Analysis'!L18)","v":0},{"$f":"IF(M11='General Assumptions'!$C$32,M18+M33+M34+SUM(M21:M24)+M31,SUM(M21:M24)+'Cash Flow Analysis'!M18)","v":0}]
[]
[null,"Return Measures",null,1,{"$f":"D39+1","v":2},{"$f":"E39+1","v":3},{"$f":"F39+1","v":4},{"$f":"G39+1","v":5},{"$f":"H39+1","v":6},{"$f":"I39+1","v":7},{"$f":"J39+1","v":8},{"$f":"K39+1","v":9},{"$f":"L39+1","v":10}]
[null,"Debt Service Coverage Ratio",null,{"$f":"IF(D18=0,\"\",D15/-D16)","v":1.3069495364972117},{"$f":"IF(E18=0,\"\",E15/-E16)","v":1.3414720657799739},1.3768946341122119,1.4132404819865108,1.4505334456980965,1.4887979725357106,1.5280591363581684,"","",""]
[null,"Operating Expense Ratio ",null,{"$f":"IF(D18=0,\"\",-D14/D12)","v":0.20949999999999999},{"$f":"IF(E18=0,\"\",-E14/E12)","v":0.20847804878048781},0.20746108268887567,0.20644907740746651,0.20544200873718621,0.20443985259700481,0.20344258502336088,"",{"$f":"IF(L18=0,\"\",-L14/L12)","v":""},{"$f":"IF(M18=0,\"\",-M14/M12)","v":""}]
[null,"Capitalization Rate (Cap Rate) ",null,{"$f":"IF(D18=0,\"\",D15/'General Assumptions'!$C$16)","v":5.2528078817733991E-2},{"$f":"IF(E18=0,\"\",E15/'General Assumptions'!$C$16)","v":5.391558620689655E-2},{"$f":"IF(F18=0,\"\",F15/'General Assumptions'!$C$16)","v":5.5339267389162568E-2},{"$f":"IF(G18=0,\"\",G15/'General Assumptions'!$C$16)","v":5.68000564315271E-2},{"$f":"IF(H18=0,\"\",H15/'General Assumptions'!$C$16)","v":5.8298911347103445E-2},{"$f":"IF(I18=0,\"\",I15/'General Assumptions'!$C$16)","v":5.9836814705664973E-2},{"$f":"IF(J18=0,\"\",J15/'General Assumptions'!$C$16)","v":6.1414774259688214E-2},{"$f":"IF(K18=0,\"\",K15/'General Assumptions'!$C$16)","v":""},{"$f":"IF(L18=0,\"\",L15/'General Assumptions'!$C$16)","v":""},{"$f":"IF(M18=0,\"\",M15/'General Assumptions'!$C$16)","v":""}]
[null,"Cash-on-Cash Return (%)",null,{"$f":"IFERROR(-IF(D18=0,\"\",D18/($C$37)),\"\")","v":2.3727981049047404E-2},{"$f":"IFERROR(-IF(E18=0,\"\",E18/($C$37)),\"\")","v":4.3943501553779261E-2},4.8501976001728807E-2,5.3179265837690962E-2,5.7978438516902278E-2,6.2902640122391079E-2,6.79550973695002E-2,"","",{"$f":"IFERROR(-IF(M18=0,\"\",M18/($C$37)),\"\")","v":""}]
[]
[null,"Levered IRR",{"$f":"IRR(C37:M37)","v":0.13335711242902204}]
[null,"Levered Cash Multiple ",{"$f":"SUMIF(C37:M37,\">0\",C37:M37)/-SUMIF(C37:M37,\"<0\",C37:M37)","v":2.256534737676104}]
[null,"Net Present Value (NPV)",{"$f":"NPV('General Assumptions'!C40,'Cash Flow Analysis'!C37:M37)","v":161404.36799900222}]
[null,"Return on Equity Investment",{"$f":"SUM(C37:M37)/-C37","v":1.256534737676104}]

{"sheet":"Expense Assumptions","index":12,"n_rows":40,"n_cols":4,"rows_kept":40,"cut":false,"hidden":true,"merged":[[4,1,6,7],[8,1,8,3]]}
[]
[]
[]
[]
[null,"Real Estate Investment Analysis Software"]
[]
[]
[]
[null,"Annual Expenses"]
[]
[]
[]
[null,"Expense Description "]
[null,"Accounting",null,1200]
[null,"Advertising",null,0]
[null,"Association Fees",null,0]
[null,"Auto & Travel",null,0]
[null,"Cleaning ",null,0]
[null,"Condo Fee",null,7200]
[null,"Insurance",null,0]
[null,"Landscaping ",null,0]
[null,"Leasing Fees",null,0]
[null,"Legal",null,0]
[null,"Payroll",null,0]
[null,"Pest Control",null,0]
[null,"Professional Fees",null,0]
[null,"Property Management",null,{"$f":"(D40*SUM('Cash Flow Analysis'!D12:D13))","v":684}]
[null,"Property Taxes",null,6000]
[null,"Supplies",null,0]
[null,"Tenant Incentive ",null,0]
[null,"Trash Removal",null,0]
[null,"Utilities",null,0]
[null,"Other Expenses",null,0]
[null,"Other Expenses",null,0]
[null,"Total Annual Expenses",null,{"$f":"SUM(D14:D34)","v":15084}]
[]
[null,"Core Deal Assumptions "]
[null,"Annual Expense Growth Rate",null,0.02]
[null,"Annual Vacancy Loss ",null,0.05]
[null,"Property Management Fee",null,0.01]

{"sheet":"Mortgage Summary","index":13,"n_rows":27,"n_cols":12,"rows_kept":27,"cut":false,"hidden":true,"merged":[[4,1,6,11]]}
[]
[]
[]
[]
[null,"Real Estate Investment Analysis Software"]
[]
[]
[]
[null,"MORTGAGE SUMMARY"]
[]
[null,"Total Property Cost ",{"$f":"'General Assumptions'!C12","v":1000000}]
[null,"Down Payment ",{"$f":"'General Assumptions'!C21","v":300000}]
[null,"Mortgage Amount",{"$f":"'General Assumptions'!C22","v":700000}]
[null,"Interest Rate",{"$f":"'General Assumptions'!C23","v":3.2399999999999998E-2}]
[null,"Monthly Interest Rate",{"$f":"'Amortization Schedule'!K17","v":2.6819533824777864E-3}]
[null,"Mortgage Compounding Frequency",{"$f":"'General Assumptions'!C24","v":2}]
[null,"Amortization (Years)",{"$f":"'General Assumptions'!C25","v":25}]
[null,"Total Number of Payments ",{"$f":"C17*12","v":300}]
[null,"Monthly Payment ",{"$f":"-PMT(C15,C18,C13,0,0)","v":3399.519167287664}]
[null,"Total Annual Payment",{"$f":"C19*12","v":40794.230007451966}]
[]
[null,"Schedule",1,{"$f":"C22+1","v":2},{"$f":"D22+1","v":3},4,5,6,7,{"$f":"I22+1","v":8},9,10]
[null,"Outstanding Balance",{"$f":"C13","v":700000},{"$f":"C27","v":681462.32065455709},{"$f":"D27","v":662319.15546975436},{"$f":"E27","v":642550.72780069301},{"$f":"F27","v":622136.61504899652},601055.72756439459,579286.28685718006,{"$f":"I27","v":0},{"$f":"J27","v":0},{"$f":"K27","v":0}]
[null,"less AmortizationPaid",{"$f":"-SUMIF('Amortization Schedule'!$B:$B,'Mortgage Summary'!C22,'Amortization Schedule'!$G:$G)*IF(C22<='General Assumptions'!$C$32,1,0)","v":-18537.679345442903},{"$f":"-SUMIF('Amortization Schedule'!$B:$B,'Mortgage Summary'!D22,'Amortization Schedule'!$G:$G)*IF(D22<='General Assumptions'!$C$32,1,0)","v":-19143.165184802678},{"$f":"-SUMIF('Amortization Schedule'!$B:$B,'Mortgage Summary'!E22,'Amortization Schedule'!$G:$G)*IF(E22<='General Assumptions'!$C$32,1,0)","v":-19768.427669061384},{"$f":"-SUMIF('Amortization Schedule'!$B:$B,'Mortgage Summary'!F22,'Amortization Schedule'!$G:$G)*IF(F22<='General Assumptions'!$C$32,1,0)","v":-20414.112751696448},{"$f":"-SUMIF('Amortization Schedule'!$B:$B,'Mortgage Summary'!G22,'Amortization Schedule'!$G:$G)*IF(G22<='General Assumptions'!$C$32,1,0)","v":-21080.887484601975},{"$f":"-SUMIF('Amortization Schedule'!$B:$B,'Mortgage Summary'!H22,'Amortization Schedule'!$G:$G)*IF(H22<='General Assumptions'!$C$32,1,0)","v":-21769.44070721454},{"$f":"-SUMIF('Amortization Schedule'!$B:$B,'Mortgage Summary'!I22,'Amortization Schedule'!$G:$G)*IF(I22<='General Assumptions'!$C$32,1,0)","v":-22480.483758147493},{"$f":"-SUMIF('Amortization Schedule'!$B:$B,'Mortgage Summary'!J22,'Amortization Schedule'!$G:$G)*IF(J22<='General Assumptions'!$C$32,1,0)","v":0},{"$f":"-SUMIF('Amortization Schedule'!$B:$B,'Mortgage Summary'!K22,'Amortization Schedule'!$G:$G)*IF(K22<='General Assumptions'!$C$32,1,0)","v":0},{"$f":"-SUMIF('Amortization Schedule'!$B:$B,'Mortgage Summary'!L22,'Amortization Schedule'!$G:$G)*IF(L22<='General Assumptions'!$C$32,1,0)","v":0}]
[null,"less Interesst Paid",{"$f":"-SUMIF('Amortization Schedule'!$B:$B,'Mortgage Summary'!C22,'Amortization Schedule'!$F:$F)*IF(C22<='General Assumptions'!$C$32,1,0)","v":-22256.550662009067},{"$f":"-SUMIF('Amortization Schedule'!$B:$B,'Mortgage Summary'!D22,'Amortization Schedule'!$F:$F)*IF(D22<='General Assumptions'!$C$32,1,0)","v":-21651.064822649296},{"$f":"-SUMIF('Amortization Schedule'!$B:$B,'Mortgage Summary'!E22,'Amortization Schedule'!$F:$F)*IF(E22<='General Assumptions'!$C$32,1,0)","v":-21025.802338390586},{"$f":"-SUMIF('Amortization Schedule'!$B:$B,'Mortgage Summary'!F22,'Amortization Schedule'!$F:$F)*IF(F22<='General Assumptions'!$C$32,1,0)","v":-20380.117255755522},{"$f":"-SUMIF('Amortization Schedule'!$B:$B,'Mortgage Summary'!G22,'Amortization Schedule'!$F:$F)*IF(G22<='General Assumptions'!$C$32,1,0)","v":-19713.342522849995},{"$f":"-SUMIF('Amortization Schedule'!$B:$B,'Mortgage Summary'!H22,'Amortization Schedule'!$F:$F)*IF(H22<='General Assumptions'!$C$32,1,0)","v":-19024.789300237433},{"$f":"-SUMIF('Amortization Schedule'!$B:$B,'Mortgage Summary'!I22,'Amortization Schedule'!$F:$F)*IF(I22<='General Assumptions'!$C$32,1,0)","v":-18313.746249304477},{"$f":"-SUMIF('Amortization Schedule'!$B:$B,'Mortgage Summary'!J22,'Amortization Schedule'!$F:$F)*IF(J22<='General Assumptions'!$C$32,1,0)","v":0},{"$f":"-SUMIF('Amortization Schedule'!$B:$B,'Mortgage Summary'!K22,'Amortization Schedule'!$F:$F)*IF(K22<='General Assumptions'!$C$32,1,0)","v":0},{"$f":"-SUMIF('Amortization Schedule'!$B:$B,'Mortgage Summary'!L22,'Amortization Schedule'!$F:$F)*IF(L22<='General Assumptions'!$C$32,1,0)","v":0}]
[null,"less Principal Repayment",{"$f":"-IF(C22='General Assumptions'!$C$32,'Mortgage Summary'!C23+C24,0)","v":0},{"$f":"-IF(D22='General Assumptions'!$C$32,'Mortgage Summary'!D23+D24,0)","v":0},{"$f":"-IF(E22='General Assumptions'!$C$32,'Mortgage Summary'!E23+E24,0)","v":0},{"$f":"-IF(F22='General Assumptions'!$C$32,'Mortgage Summary'!F23+F24,0)","v":0},{"$f":"-IF(G22='General Assumptions'!$C$32,'Mortgage Summary'!G23+G24,0)","v":0},{"$f":"-IF(H22='General Assumptions'!$C$32,'Mortgage Summary'!H23+H24,0)","v":0},{"$f":"-IF(I22='General Assumptions'!$C$32,'Mortgage Summary'!I23+I24,0)","v":-556805.80309903261},{"$f":"-IF(J22='General Assumptions'!$C$32,'Mortgage Summary'!J23+J24,0)","v":0},{"$f":"-IF(K22='General Assumptions'!$C$32,'Mortgage Summary'!K23+K24,0)","v":0},{"$f":"-IF(L22='General Assumptions'!$C$32,'Mortgage Summary'!L23+L24,0)","v":0}]
[null,"End of Year Balance ",{"$f":"C23+C24+C26","v":681462.32065455709},{"$f":"D23+D24+D26","v":662319.15546975436},642550.72780069301,622136.61504899652,601055.72756439459,579286.28685718006,{"$f":"I23+I24+I26","v":0},0,0,{"$f":"L23-L24","v":0}]

{"sheet":"Amortization Schedule","index":14,"n_rows":314,"n_cols":11,"rows_kept":314,"cut":false,"hidden":true,"merged":[[4,1,6,10]]}
[]
[]
[]
[]
[null,"Real Estate Investment Analysis Software"]
[]
[]
[]
[]
[null,"AMORTIZATION SCHEDULE"]
[]
[null,"Year","Payment ","Payment ","Monthly","Interest","Amortization","Remaining ",null,"Mortgage ",{"$f":"'Mortgage Summary'!C13","v":700000}]
[null,"#","#","Date","Payment","Paid","Paid","Balance",null,"Annual Compounding Frequency",{"$f":"'General Assumptions'!C24","v":2}]
[null,0,0,{"$f":"'General Assumptions'!C27","v":"2020-07-01"},null,null,null,{"$f":"'General Assumptions'!C22","v":700000},null,"Amortization ",{"$f":"'General Assumptions'!C25","v":25}]
[null,1,1,{"$f":"EDATE(D14,1)","v":"2020-08-01"},{"$f":"$K$18","v":3399.519167287664},{"$f":"IF(H14>0,H14*$K$17,0)","v":1877.3673677344505},{"$f":"IF(H14>0,E15-F15,0)","v":1522.1517995532136},{"$f":"H14-G15","v":698477.84820044681},null,"Total # of Payments",{"$f":"'General Assumptions'!C26","v":300}]
[null,{"$f":"B15","v":1},2,"2020-09-01",3399.519167287664,1873.2850275669941,{"$f":"IF(H15>0,E16-F16,0)","v":1526.2341397206699},{"$f":"H15-G16","v":696951.61406072613},null,"Interest Rate",{"$f":"'General Assumptions'!C23","v":3.2399999999999998E-2}]
[null,{"$f":"B16","v":1},3,"2020-10-01",3399.519167287664,1869.1917387535173,1530.3274285341467,695421.28663219197,null,"Monthly Interest Rate",{"$f":"((1+K16/K13)^(K13/12))-1","v":2.6819533824777864E-3}]
[null,1,4,"2020-11-01",3399.519167287664,1865.0874719302615,1534.4316953574025,693886.85493683454,null,"Monthly Payment",{"$f":"-PMT(K17,K15,K12,0,0)","v":3399.519167287664}]
[null,1,5,"2020-12-01",3399.519167287664,1860.9721976547164,1538.5469696329476,692348.30796720157,null,"Annual Payment  ",{"$f":"K18*12","v":40794.230007451966}]
[null,1,6,"2021-01-01",3399.519167287664,1856.8458864054085,1542.6732808822555,690805.63468631927]
[null,1,7,"2021-02-01",3399.519167287664,1852.708508581688,1546.810658705976,689258.82402761327]
[null,1,8,"2021-03-01",3399.519167287664,1848.5600345035186,1550.9591327841454,687707.86489482911]
[null,1,9,"2021-04-01",3399.519167287664,1844.4004344112634,1555.1187328764006,686152.74616195273]
[null,1,10,"2021-05-01",3399.519167287664,1840.2296784654711,1559.2894888221929,684593.45667313051]
[null,1,11,"2021-06-01",3399.519167287664,1836.0477367466622,1563.4714305410018,683029.98524258949]
[null,1,12,"2021-07-01",3399.519167287664,1831.8545792551154,1567.6645880325486,681462.32065455697]
[null,{"$f":"B15+1","v":2},13,"2021-08-01",3399.519167287664,1827.6501759106509,1571.8689913770131,679890.45166317991]
[null,{"$f":"B16+1","v":2},14,"2021-09-01",3399.519167287664,1823.4344965524153,1576.0846707352487,678314.36699244461]
[null,2,15,"2021-10-01",3399.519167287664,1819.2075109386653,1580.3116563489987,676734.05533609563]
[null,2,16,"2021-11-01",3399.519167287664,1814.969188746551,1584.549978541113,675149.50535755453]
[null,2,17,"2021-12-01",3399.519167287664,1810.7194995718978,1588.7996677157662,673560.70568983874]
[null,2,18,"2022-01-01",3399.519167287664,1806.4584129289879,1593.0607543586761,671967.64493548009]
[null,2,19,"2022-02-01",3399.519167287664,1802.1858982503429,1597.3332690373211,670370.31166644278]
[null,2,20,"2022-03-01",3399.519167287664,1797.901924886504,1601.61724240116,668768.69442404166]
[null,2,21,"2022-04-01",3399.519167287664,1793.6064621058117,1605.9127051818523,667162.7817188598]
[null,2,22,"2022-05-01",3399.519167287664,1789.299479094185,1610.219688193479,665552.56203066627]
[null,2,23,"2022-06-01",3399.519167287664,1784.980944954902,1614.538222332762,663938.02380833356]
[null,2,24,"2022-07-01",3399.519167287664,1780.6508287083773,1618.8683385792867,662319.15546975425]
[null,3,25,"2022-08-01",3399.519167287664,1776.3090992919383,1623.2100679957257,660695.94540175854]
[null,3,26,"2022-09-01",3399.519167287664,1771.9557255596051,1627.5634417280589,659068.38196003053]
[null,3,27,"2022-10-01",3399.519167287664,1767.5906762818656,1631.9284910057984,657436.45346902474]
[null,3,28,"2022-11-01",3399.519167287664,1763.2139201454506,1636.3052471422134,655800.14822188253]
[null,3,29,"2022-12-01",3399.519167287664,1758.8254257531114,1640.6937415345526,654159.45448034792]
[null,3,30,"2023-01-01",3399.519167287664,1754.4251616233926,1645.0940056642714,652514.36047468369]
[null,3,31,"2023-02-01",3399.519167287664,1750.0130961904076,1649.5060710972564,650864.85440358648]
[null,3,32,"2023-03-01",3399.519167287664,1745.5891978036107,1653.9299694840533,649210.92443410237]
[null,3,33,"2023-04-01",3399.519167287664,1741.1534347275715,1658.3657325600925,647552.55870154232]
[null,3,34,"2023-05-01",3399.519167287664,1736.7057751417467,1662.8133921459173,645889.74530939641]
[null,3,35,"2023-06-01",3399.519167287664,1732.2461871402515,1667.2729801474125,644222.47232924902]
[null,3,{"$f":"C49+1","v":36},"2023-07-01",3399.519167287664,1727.7746387316315,1671.7445285560325,642550.72780069301]
[null,4,{"$f":"C50+1","v":37},"2023-08-01",3399.519167287664,1723.2910978386319,1676.2280694490321,640874.49973124394]
[null,4,38,"2023-09-01",3399.519167287664,1718.795532297969,1680.723634989695,639193.77609625424]
[null,4,39,"2023-10-01",3399.519167287664,1714.2879098600979,1685.2312574275661,637508.54483882664]
[null,4,40,"2023-11-01",3399.519167287664,1709.7681981889825,1689.7509690986815,635818.79386972799]
[null,4,41,"2023-12-01",3399.519167287664,1705.2363648618634,1694.2828024258006,634124.5110673022]
[null,4,42,"2024-01-01",3399.519167287664,1700.6923773690237,1698.8267899186403,632425.68427738361]
[null,4,43,"2024-02-01",3399.519167287664,1696.1362031135575,1703.3829641741065,630722.30131320946]
[null,4,44,"2024-03-01",3399.519167287664,1691.5678094111356,1707.9513578765284,629014.34995533293]
[null,4,45,"2024-04-01",3399.519167287664,1686.9871634897711,1712.5320037978929,627301.81795153499]
[null,4,46,"2024-05-01",3399.519167287664,1682.3942324895838,1717.1249347980802,625584.69301673688]
[null,4,47,"2024-06-01",3399.519167287664,1677.7889834625651,1721.7301838250989,623862.96283291175]
[null,4,48,"2024-07-01",3399.519167287664,1673.1713833723411,1726.3477839153229,622136.61504899641]
[null,5,49,"2024-08-01",3399.519167287664,1668.5413990939364,1730.9777681937276,620405.63728080271]
[null,5,50,"2024-09-01",3399.519167287664,1663.8989974135354,1735.6201698741286,618670.01711092854]
[null,5,51,"2024-10-01",3399.519167287664,1659.2441450282447,1740.2750222594193,616929.7420886691]
[null,5,52,"2024-11-01",3399.519167287664,1654.5768085458544,1744.9423587418096,615184.79972992733]
[null,5,53,"2024-12-01",3399.519167287664,1649.8969544845982,1749.6222128030658,613435.17751712422]
[null,5,54,"2025-01-01",3399.519167287664,1645.2045492729126,1754.3146180147514,611680.86289910949]
[null,5,55,"2025-02-01",3399.519167287664,1640.4995592491978,1759.0196080384662,609921.84329107101]
[null,5,56,"2025-03-01",3399.519167287664,1635.7819506615742,1763.7372166260898,608158.10607444495]
[null,5,57,"2025-04-01",3399.519167287664,1631.051689667642,1768.467477620022,606389.63859682495]
[null,5,58,"2025-05-01",3399.519167287664,1626.3087423342372,1773.2104249534268,604616.42817187158]
[null,5,59,"2025-06-01",3399.519167287664,1621.5530746371885,1777.9660926504755,602838.46207922115]
[null,5,60,"2025-07-01",3399.519167287664,1616.7846524610738,1782.7345148265902,601055.72756439459]
[null,6,61,"2025-08-01",3399.519167287664,1612.0034415989749,1787.5157256886891,599268.21183870593]
[null,6,62,"2025-09-01",3399.519167287664,1607.209407752232,1792.309759535432,597475.90207917045]
[null,6,63,"2025-10-01",3399.519167287664,1602.4025165301978,1797.1166507574662,595678.78542841296]
[null,6,64,"2025-11-01",3399.519167287664,1597.5827334499916,1801.9364338376724,593876.84899457532]
[null,6,65,"2025-12-01",{"$f":"$K$18","v":3399.519167287664},{"$f":"IF(H78>0,H78*$K$17,0)","v":1592.750023936251},1806.769143351413,592070.07985122385]
[null,6,66,{"$f":"EDATE(D79,1)","v":"2026-01-01"},3399.519167287664,1587.9043533208828,{"$f":"IF(H79>0,E80-F80,0)","v":1811.6148139667812},{"$f":"H79-G80","v":590258.46503725706}]
[null,6,67,"2026-02-01",3399.519167287664,1583.0456868428178,1816.4734804448462,588441.99155681219]
[null,6,68,"2026-03-01",3399.519167287664,1578.1739896477575,1821.3451776399065,586620.64637917234]
[null,6,69,"2026-04-01",3399.519167287664,1573.2892267879267,1826.2299404997373,584794.41643867258]
[null,6,70,"2026-05-01",3399.519167287664,1568.3913632218212,1831.1278040658428,582963.28863460675]
[null,6,71,"2026-06-01",3399.519167287664,1563.4803638139576,1836.0388034737064,581127.24983113306]
[null,6,72,"2026-07-01",3399.519167287664,1558.556193334621,1840.962973953043,579286.28685718006]
[null,7,73,"2026-08-01",3399.519167287664,1553.6188164596113,1845.9003508280528,577440.38650635199]
[null,7,74,"2026-09-01",3399.519167287664,1548.6681977699911,1850.8509695176729,575589.53553683427]
[null,7,75,"2026-10-01",3399.519167287664,1543.7043017518306,1855.8148655358334,573733.72067129845]
[null,7,76,"2026-11-01",3399.519167287664,1538.7270927959544,1860.7920744917096,571872.92859680671]
[null,7,77,"2026-12-01",3399.519167287664,1533.7365351976835,1865.7826320899806,570007.14596471668]
[null,{"$f":"B80+1","v":7},78,"2027-01-01",3399.519167287664,1528.7325931565813,1870.7865741310827,568136.35939058557]
[null,7,79,"2027-02-01",3399.519167287664,1523.7152307761962,1875.8039365114678,566260.55545407406]
[null,7,80,"2027-03-01",3399.519167287664,1518.6844120638041,1880.8347552238599,564379.72069885023]
[null,7,81,"2027-04-01",3399.519167287664,1513.6401009301496,1885.8790663575144,562493.84163249272]
[null,7,82,"2027-05-01",3399.519167287664,1508.5822611891881,1890.9369060984759,560602.90472639422]
[null,7,83,"2027-06-01",3399.519167287664,1503.5108565578253,1896.0083107298387,558706.89641566435]
[null,7,84,"2027-07-01",3399.519167287664,1498.4258506556573,1901.0933166320067,556805.80309903238]
[null,8,85,"2027-08-01",3399.519167287664,1493.3272070047101,1906.1919602829539,554899.6111387494]
[null,8,86,"2027-09-01",3399.519167287664,1488.2148890291774,1911.3042782584866,552988.30686049093]
[null,8,87,"2027-10-01",3399.519167287664,1483.0888600551577,1916.4303072325063,551071.87655325839]
[null,8,88,"2027-11-01",3399.519167287664,1477.9490833103926,1921.5700839772715,549150.30646928109]
[null,8,89,"2027-12-01",3399.519167287664,1472.7955219240014,1926.7236453636626,547223.58282391739]
[null,8,90,"2028-01-01",3399.519167287664,1467.6281389262183,1931.8910283614457,545291.69179555599]
[null,8,91,"2028-02-01",3399.519167287664,1462.4468972481259,1937.0722700395381,543354.61952551641]
[null,8,92,"2028-03-01",3399.519167287664,1457.2517597213894,1942.2674075662746,541412.3521179501]
[null,8,93,"2028-04-01",3399.519167287664,1452.0426890779906,1947.4764782096734,539464.87563974038]
[null,8,94,"2028-05-01",3399.519167287664,1446.81964794996,1952.699519337704,537512.17612040264]
[null,8,95,"2028-06-01",3399.519167287664,1441.5825988691095,1957.9365684185545,535554.23955198412]
[null,8,96,"2028-07-01",3399.519167287664,1436.3315042667625,1963.1876630209015,533591.05188896321]
[null,9,97,"2028-08-01",3399.519167287664,1431.0663264734849,1968.4528408141791,531622.59904814907]
[null,9,98,"2028-09-01",3399.519167287664,1425.7870277188154,1973.7321395688487,529648.86690858018]
[null,9,99,"2028-10-01",3399.519167287664,1420.4935701309935,1979.0255971566705,527669.84131142346]
[null,9,100,"2028-11-01",3399.519167287664,1415.1859157366889,1984.3332515509751,525685.50805987243]
[null,9,{"$f":"C114+1","v":101},"2028-12-01",3399.519167287664,1409.8640264607284,1989.6551408269356,523695.85291904549]
[null,9,102,"2029-01-01",3399.519167287664,1404.5278641258233,1994.9913031618407,521700.86161588365]
[null,9,103,"2029-02-01",3399.519167287664,1399.1773904522947,2000.3417768353693,519700.51983904827]
[null,9,104,"2029-03-01",3399.519167287664,1393.8125670577995,2005.7066002298645,517694.81323881843]
[null,9,105,"2029-04-01",3399.519167287664,1388.4333554570551,2011.0858118306089,515683.72742698784]
[null,9,106,"2029-05-01",3399.519167287664,1383.0397170615629,2016.4794502261011,513667.24797676172]
[null,9,107,"2029-06-01",3399.519167287664,1377.6316131793319,2021.8875541083321,511645.36042265338]
[null,9,108,"2029-07-01",3399.519167287664,1372.2090050146014,2027.3101622730626,509618.05026038032]
[null,10,109,"2029-08-01",3399.519167287664,1366.7718536675616,2032.7473136201024,507585.3029467602]
[null,10,110,"2029-09-01",3399.519167287664,1361.3201201340755,2038.1990471535885,505547.10389960662]
[null,10,111,"2029-10-01",3399.519167287664,1355.8537653053988,2043.6654019822652,503503.43849762436]
[null,10,112,"2029-11-01",3399.519167287664,1350.3727499678998,2049.1464173197642,501454.29208030459]
[null,10,113,"2029-12-01",3399.519167287664,1344.8770348027767,2054.642132484887,499399.64994781971]
[null,10,114,"2030-01-01",3399.519167287664,1339.3665803857775,2060.1525869018865,497339.4973609178]
[null,10,115,"2030-02-01",3399.519167287664,1333.8413471869155,2065.6778201007482,495273.81954081706]
[null,10,116,"2030-03-01",3399.519167287664,1328.301295570187,2071.217871717477,493202.60166909959]
[null,10,117,"2030-04-01",3399.519167287664,1322.746385793286,2076.7727814943783,491125.82888760522]
[null,10,118,"2030-05-01",3399.519167287664,1317.1765780073194,2082.3425892803443,489043.48629832489]
[null,10,119,"2030-06-01",3399.519167287664,1311.5918322565215,2087.9273350311423,486955.55896329373]
[null,10,120,"2030-07-01",3399.519167287664,1305.9921084779667,2093.5270588096973,484862.03190448403]
[null,11,121,"2030-08-01",3399.519167287664,1300.3773665012834,2099.1418007863804,482762.89010369766]
[null,11,122,"2030-09-01",3399.519167287664,1294.7475660483638,2104.7716012393003,480658.11850245838]
[null,11,123,"2030-10-01",3399.519167287664,1289.1026667330768,2110.4165005545874,478547.70200190379]
[null,11,124,"2030-11-01",3399.519167287664,1283.4426280609775,2116.0765392266867,476431.6254626771]
[null,11,125,"2030-12-01",3399.519167287664,1277.7674094290167,2121.7517578586476,474309.87370481843]
[null,11,126,"2031-01-01",3399.519167287664,1272.0769701252495,2127.4421971624142,472182.431507656]
[null,11,127,"2031-02-01",3399.519167287664,1266.3712693285438,2133.1478979591202,470049.2836096969]
[null,11,128,"2031-03-01",3399.519167287664,1260.6502661082868,2138.8689011793772,467910.41470851749]
[null,11,129,"2031-04-01",{"$f":"$K$18","v":3399.519167287664},{"$f":"IF(H142>0,H142*$K$17,0)","v":1254.9139194240922},2144.605247863572,465765.80946065392]
[null,11,130,{"$f":"EDATE(D143,1)","v":"2031-05-01"},3399.519167287664,1249.1621881255048,{"$f":"IF(H143>0,E144-F144,0)","v":2150.3569791621594},{"$f":"H143-G144","v":463615.45248149178}]
[null,11,131,"2031-06-01",3399.519167287664,1243.3950309517063,2156.1241363359577,461459.32834515581]
[null,11,132,"2031-07-01",3399.519167287664,1237.6124065312181,2161.9067607564457,459297.42158439936]
[null,12,133,"2031-08-01",3399.519167287664,1231.8142733816057,2167.7048939060583,457129.71669049328]
[null,12,134,"2031-09-01",3399.519167287664,1226.0005899091807,2173.5185773784833,454956.19811311481]
[null,12,135,"2031-10-01",3399.519167287664,1220.1713144087021,2179.3478528789619,452776.85026023583]
[null,12,136,"2031-11-01",3399.519167287664,1214.3264050630776,2185.1927622245867,450591.65749801125]
[null,12,137,"2031-12-01",3399.519167287664,1208.4658199430635,2191.0533473446003,448400.60415066662]
[null,12,138,"2032-01-01",3399.519167287664,1202.5895170069632,2196.929650280701,446203.67450038594]
[null,12,139,"2032-02-01",3399.519167287664,1196.6974541003271,2202.8217131873371,444000.85278719862]
[null,12,140,"2032-03-01",3399.519167287664,1190.7895889556489,2208.7295783320151,441792.12320886657]
[null,12,141,"2032-04-01",3399.519167287664,1184.8658791920627,2214.6532880956011,439577.46992077096]
[null,{"$f":"B144+1","v":12},142,"2032-05-01",3399.519167287664,1178.9262823150391,2220.5928849726251,437356.87703579833]
[null,12,143,"2032-06-01",3399.519167287664,1172.9707557160807,2226.5484115715835,435130.32862422673]
[null,12,144,"2032-07-01",3399.519167287664,1166.9992566724156,2232.5199106152486,432897.80871361151]
[null,13,145,"2032-08-01",3399.519167287664,1161.011742346692,2238.5074249409718,430659.30128867051]
[null,13,146,"2032-09-01",3399.519167287664,1155.0081697866699,2244.5109975009941,428414.79029116954]
[null,13,147,"2032-10-01",3399.519167287664,1148.9884959249137,2250.5306713627506,426164.25961980678]
[null,13,148,"2032-11-01",3399.519167287664,1142.9526775784823,2256.566489709182,423907.69313009758]
[null,13,149,"2032-12-01",3399.519167287664,1136.9006714486206,2262.6184958390431,421645.07463425852]
[null,13,150,"2033-01-01",3399.519167287664,1130.8324341204484,2268.6867331672156,419376.38790109131]
[null,13,151,"2033-02-01",3399.519167287664,1124.7479220626481,2274.7712452250162,417101.61665586627]
[null,13,152,"2033-03-01",3399.519167287664,1118.6470916271535,2280.8720756605107,414820.74458020576]
[null,13,153,"2033-04-01",3399.519167287664,1112.5298990488368,2286.9892682388272,412533.75531196693]
[null,13,154,"2033-05-01",3399.519167287664,1106.3963004451932,2293.122866842471,410240.63244512444]
[null,13,155,"2033-06-01",3399.519167287664,1100.2462518160278,2299.2729154716362,407941.35952965281]
[null,13,156,"2033-07-01",3399.519167287664,1094.079709043139,2305.4394582445248,405635.92007140827]
[null,14,157,"2033-08-01",3399.519167287664,1087.8966278900025,2311.6225393976615,403324.29753201059]
[null,14,158,"2033-09-01",3399.519167287664,1081.6969640014529,2317.8222032862113,401006.47532872437]
[null,14,159,"2033-10-01",3399.519167287664,1075.4806729033673,2324.0384943842964,398682.43683434004]
[null,14,160,"2033-11-01",3399.519167287664,1069.2477100023448,2330.2714572853192,396352.16537705471]
[null,14,161,"2033-12-01",3399.519167287664,1062.9980305853869,2336.5211367022771,394015.64424035244]
[null,14,162,"2034-01-01",3399.519167287664,1056.7315898195773,2342.787577468087,391672.85666288435]
[null,14,163,"2034-02-01",3399.519167287664,1050.4483427517598,2349.0708245359042,389323.78583834844]
[null,14,164,"2034-03-01",3399.519167287664,1044.1482443082159,2355.3709229794481,386968.41491536901]
[null,14,{"$f":"C178+1","v":165},"2034-04-01",3399.519167287664,1037.8312492943414,2361.6879179933226,384606.72699737566]
[null,14,166,"2034-05-01",3399.519167287664,1031.4973123943223,2368.0218548933417,382238.7051424823]
[null,14,167,"2034-06-01",3399.519167287664,1025.1463881708096,2374.3727791168544,379864.33236336545]
[null,14,168,"2034-07-01",3399.519167287664,1018.778431064594,2380.7407362230701,377483.59162714239]
[null,15,169,"2034-08-01",3399.519167287664,1012.3933953942779,2387.1257718933862,375096.46585524903]
[null,15,170,"2034-09-01",3399.519167287664,1005.9912353559487,2393.5279319317151,372702.93792331731]
[null,15,171,"2034-10-01",3399.519167287664,999.57190502284925,2399.9472622648145,370302.99066105252]
[null,15,172,"2034-11-01",3399.519167287664,993.13535834504989,2406.383808942614,367896.60685210989]
[null,15,173,"2034-12-01",3399.519167287664,986.68154914911645,2412.8376181385474,365483.76923397137]
[null,15,174,"2035-01-01",3399.519167287664,980.21043113778023,2419.3087361498838,363064.46049782151]
[null,15,175,"2035-02-01",3399.519167287664,973.72195788960505,2425.7972093980588,360638.66328842344]
[null,15,176,"2035-03-01",3399.519167287664,967.21608285865477,2432.3030844290092,358206.36020399444]
[null,15,177,"2035-04-01",3399.519167287664,960.69275937415921,2438.8264079135047,355767.53379608091]
[null,15,178,"2035-05-01",3399.519167287664,954.15194064017942,2445.3672266474846,353322.16656943341]
[null,15,179,"2035-06-01",3399.519167287664,947.59357973527176,2451.9255875523922,350870.24098188104]
[null,15,180,"2035-07-01",3399.519167287664,941.01762961215184,2458.5015376755123,348411.73944420554]
[null,16,181,"2035-08-01",3399.519167287664,934.42404309735628,2465.0951241903076,345946.64432001521]
[null,16,182,"2035-09-01",3399.519167287664,927.81277289090451,2471.7063943967596,343474.93792561843]
[null,16,183,"2035-10-01",3399.519167287664,921.18377156596011,2478.3353957217041,340996.60252989671]
[null,16,184,"2035-11-01",3399.519167287664,914.53699156848973,2484.9821757191744,338511.62035417755]
[null,16,185,"2035-12-01",3399.519167287664,907.87238521692279,2491.6467820707412,336019.9735721068]
[null,16,186,"2036-01-01",3399.519167287664,901.18990470180825,2498.3292625858558,333521.64430952095]
[null,16,187,"2036-02-01",3399.519167287664,894.48950208547285,2505.0296652021912,331016.61464431876]
[null,16,188,"2036-03-01",3399.519167287664,887.77112930167664,2511.7480379859871,328504.86660633277]
[null,16,189,"2036-04-01",3399.519167287664,881.0347381552682,2518.4844291323957,325986.3821772004]
[null,16,190,"2036-05-01",3399.519167287664,874.28028032183897,2525.2388869658253,323461.14329023456]
[null,16,191,"2036-06-01",3399.519167287664,867.50770734737648,2532.0114599402878,320929.13183029427]
[null,16,192,"2036-07-01",3399.519167287664,860.71697064791715,2538.8021966397469,318390.3296336545]
[null,17,193,"2036-08-01",{"$f":"$K$18","v":3399.519167287664},{"$f":"IF(H206>0,H206*$K$17,0)","v":853.90802150919706},2545.6111457784668,315844.71848787606]
[null,17,194,{"$f":"EDATE(D207,1)","v":"2036-09-01"},3399.519167287664,847.08081108630347,{"$f":"IF(H207>0,E208-F208,0)","v":2552.4383562013604},{"$f":"H207-G208","v":313292.28013167472}]
[null,17,195,"2036-10-01",3399.519167287664,840.23529040332323,2559.2838768843408,310732.9962547904]
[null,17,196,"2036-11-01",3399.519167287664,833.37141035299248,2566.1477569346716,308166.84849785571]
[null,17,197,"2036-12-01",3399.519167287664,826.48912169634366,2573.0300455913202,305593.81845226442]
[null,17,198,"2037-01-01",3399.519167287664,819.58837506235307,2579.9307922253111,303013.88766003912]
[null,17,199,"2037-02-01",3399.519167287664,812.66912094758595,2586.8500463400778,300427.03761369904]
[null,17,200,"2037-03-01",3399.519167287664,805.73130971584123,2593.7878575718228,297833.24975612719]
[null,17,201,"2037-04-01",3399.519167287664,798.77489159779668,2600.7442756898672,295232.50548043731]
[null,17,202,"2037-05-01",3399.519167287664,791.79981669065046,2607.7193505970135,292624.7861298403]
[null,17,203,"2037-06-01",3399.519167287664,784.80603495776404,2614.7131323299,290010.07299751037]
[null,17,204,"2037-07-01",3399.519167287664,777.79349622830273,2621.725671059361,287388.34732645104]
[null,18,205,"2037-08-01",3399.519167287664,770.76215019687629,2628.7570170907875,284759.59030936024]
[null,{"$f":"B208+1","v":18},206,"2037-09-01",3399.519167287664,763.71194642317732,2635.8072208644867,282123.78308849578]
[null,18,207,"2037-10-01",3399.519167287664,756.64283433162052,2642.8763329560434,279480.90675553976]
[null,18,208,"2037-11-01",3399.519167287664,749.55476321097865,2649.9644040766852,276830.94235146308]
[null,18,209,"2037-12-01",3399.519167287664,742.44768221401944,2657.0714850736445,274173.87086638942]
[null,18,210,"2038-01-01",3399.519167287664,735.32154035714086,2664.1976269305233,271509.67323945888]
[null,18,211,"2038-02-01",3399.519167287664,728.17628652000519,2671.3428807676587,268838.33035869122]
[null,18,212,"2038-03-01",3399.519167287664,721.01186944517247,2678.5072978424914,266159.82306084875]
[null,18,213,"2038-04-01",3399.519167287664,713.82823773773248,2685.6909295499318,263474.13213129883]
[null,18,214,"2038-05-01",3399.519167287664,706.62533986493611,2692.893827422728,260781.2383038761]
[null,18,215,"2038-06-01",3399.519167287664,699.40312415582616,2700.1160431318376,258081.12226074428]
[null,18,216,"2038-07-01",3399.519167287664,692.1615388008662,2707.3576284867977,255373.76463225749]
[null,19,217,"2038-08-01",3399.519167287664,684.9005318515691,2714.6186354360948,252659.1459968214]
[null,19,218,"2038-09-01",3399.519167287664,677.62005122012397,2721.89911606754,249937.24688075387]
[null,19,219,"2038-10-01",3399.519167287664,670.32004467902334,2729.1991226086407,247208.04775814523]
[null,19,220,"2038-11-01",3399.519167287664,663.00045986068778,2736.5187074269761,244471.52905071827]
[null,19,221,"2038-12-01",3399.519167287664,655.66124425709029,2743.8579230305736,241727.6711276877]
[null,19,222,"2039-01-01",3399.519167287664,648.30234521937996,2751.2168220682843,238976.45430561941]
[null,19,223,"2039-02-01",3399.519167287664,640.92370995750412,2758.5954573301597,236217.85884828924]
[null,19,224,"2039-03-01",3399.519167287664,633.52528553982961,2765.9938817478342,233451.86496654141]
[null,19,225,"2039-04-01",3399.519167287664,626.10701889276322,2773.4121483949007,230678.4528181465]
[null,19,226,"2039-05-01",3399.519167287664,618.66885680037046,2780.8503104872934,227897.60250765921]
[null,19,227,"2039-06-01",3399.519167287664,611.21074590399462,2788.3084213836692,225109.29408627553]
[null,19,228,"2039-07-01",3399.519167287664,603.7326327018734,2795.7865345857908,222313.50755168975]
[null,20,{"$f":"C242+1","v":229},"2039-08-01",3399.519167287664,596.23446354875523,2803.2847037389088,219510.22284795085]
[null,20,230,"2039-09-01",3399.519167287664,588.71618465551444,2810.8029826321495,216699.41986531869]
[null,20,231,"2039-10-01",3399.519167287664,581.17774208876551,2818.3414251988984,213881.0784401198]
[null,20,232,"2039-11-01",3399.519167287664,573.6190817704761,2825.900085517188,211055.17835460263]
[null,20,233,"2039-12-01",3399.519167287664,566.04014947757901,2833.4790178100848,208221.69933679255]
[null,20,234,"2040-01-01",3399.519167287664,558.44089084158338,2841.0782764460805,205380.62106034646]
[null,20,235,"2040-02-01",3399.519167287664,550.82125134818466,2848.6979159394796,202531.92314440699]
[null,20,236,"2040-03-01",3399.519167287664,543.18117633687336,2856.3379909507908,199675.5851534562]
[null,20,237,"2040-04-01",3399.519167287664,535.52061100054311,2863.9985562871207,196811.58659716908]
[null,20,238,"2040-05-01",3399.519167287664,527.83950038509738,2871.6796669025666,193939.9069302665]
[null,20,239,"2040-06-01",3399.519167287664,520.13778938905534,2879.3813778986087,191060.52555236788]
[null,20,240,"2040-07-01",3399.519167287664,512.41542276315658,2887.1037445245074,188173.42180784338]
[null,21,241,"2040-08-01",3399.519167287664,504.67234510996479,2894.8468221776993,185278.57498566568]
[null,21,242,"2040-09-01",3399.519167287664,496.90850088347025,2902.6106664041936,182375.96431926149]
[null,21,243,"2040-10-01",3399.519167287664,489.12383438869142,2910.3953328989728,179465.56898636252]
[null,21,244,"2040-11-01",3399.519167287664,481.31828978127544,2918.2008775063887,176547.36810885611]
[null,21,245,"2040-12-01",3399.519167287664,473.4918110670975,2926.0273562205666,173621.34075263556]
[null,21,246,"2041-01-01",3399.519167287664,465.64434210185925,2933.8748251858046,170687.46592744975]
[null,21,247,"2041-02-01",3399.519167287664,457.77582659068577,2941.7433406969781,167745.72258675279]
[null,21,248,"2041-03-01",3399.519167287664,449.88620808772203,2949.632959199942,164796.08962755284]
[null,21,249,"2041-04-01",3399.519167287664,441.97542999572778,2957.5437372919364,161838.5458902609]
[null,21,250,"2041-05-01",3399.519167287664,434.04343556567164,2965.4757317219924,158873.0701585389]
[null,21,251,"2041-06-01",3399.519167287664,426.09016789632409,2973.4289993913399,155899.64115914758]
[null,21,252,"2041-07-01",3399.519167287664,418.11556993384897,2981.4035973538148,152918.23756179377]
[null,22,253,"2041-08-01",3399.519167287664,410.11958447139449,2989.3995828162697,149928.83797897751]
[null,22,254,"2041-09-01",3399.519167287664,402.1021541486827,2997.4170131389815,146931.42096583854]
[null,22,255,"2041-10-01",3399.519167287664,394.06322145159822,3005.4559458360659,143925.96502000248]
[null,22,256,"2041-11-01",3399.519167287664,386.00272871177521,3013.516438575889,140912.44858142658]
[null,22,257,"2041-12-01",{"$f":"$K$18","v":3399.519167287664},{"$f":"IF(H270>0,H270*$K$17,0)","v":377.92061810618418},3021.5985491814799,137890.8500322451]
[null,22,258,{"$f":"EDATE(D271,1)","v":"2042-01-01"},3399.519167287664,369.81683165671694,{"$f":"IF(H271>0,E272-F272,0)","v":3029.7023356309469},{"$f":"H271-G272","v":134861.14769661415}]
[null,22,259,"2042-02-01",3399.519167287664,361.69131122977063,3037.8278560578933,131823.31984055624]
[null,22,260,"2042-03-01",3399.519167287664,353.54399853583089,3045.9751687518333,128777.34467180441]
[null,22,261,"2042-04-01",3399.519167287664,345.37483512905357,3054.1443321586103,125723.2003396458]
[null,22,262,"2042-05-01",3399.519167287664,337.18376240684546,3062.3354048808187,122660.86493476498]
[null,22,263,"2042-06-01",3399.519167287664,328.97072160944384,3070.5484456782201,119590.31648908676]
[null,22,264,"2042-07-01",3399.519167287664,320.73565381949521,3078.7835134681686,116511.5329756186]
[null,23,265,"2042-08-01",3399.519167287664,312.47849996163245,3087.0406673260313,113424.49230829257]
[null,23,266,"2042-09-01",3399.519167287664,304.19920080205094,3095.3199664856129,110329.17234180696]
[null,23,267,"2042-10-01",3399.519167287664,295.89769694808382,3103.6214703395804,107225.55087146738]
[null,23,268,"2042-11-01",3399.519167287664,287.5739288477759,3111.9452384398883,104113.60563302749]
[null,23,269,"2042-12-01",3399.519167287664,279.22783678945638,3120.2913304982076,100993.31430252928]
[null,{"$f":"B272+1","v":23},270,"2043-01-01",3399.519167287664,270.85936090131059,3128.6598063863535,97864.654496142932]
[null,23,271,"2043-02-01",3399.519167287664,262.46844115095041,3137.0507261367138,94727.603770006215]
[null,23,272,"2043-03-01",3399.519167287664,254.05501734498367,3145.4641499426803,91582.139620063535]
[null,23,273,"2043-04-01",3399.519167287664,245.6190291285823,3153.9001381590815,88428.239481904457]
[null,23,274,"2043-05-01",3399.519167287664,237.16041598504938,3162.3587513026146,85265.880730601843]
[null,23,275,"2043-06-01",3399.519167287664,228.67911723538512,3170.8400500522789,82095.040680549559]
[null,23,276,"2043-07-01",3399.519167287664,220.17507203785135,3179.3440952498127,78915.696585299753]
[null,24,277,"2043-08-01",3399.519167287664,211.64821938753536,3187.8709479001286,75727.825637399626]
[null,24,278,"2043-09-01",3399.519167287664,203.09849811591195,3196.4206691717523,72531.404968227871]
[null,24,279,"2043-10-01",3399.519167287664,194.52584689040486,3204.9933203972591,69326.41164783061]
[null,24,280,"2043-11-01",3399.519167287664,185.93020421394672,3213.5889630737174,66112.822684756888]
[null,24,281,"2043-12-01",3399.519167287664,177.31150842453786,3222.2076588631262,62890.615025893763]
[null,24,282,"2044-01-01",3399.519167287664,168.66969769480409,3230.8494695928598,59659.765556300903]
[null,24,283,"2044-02-01",3399.519167287664,160.00471003155295,3239.5144572561112,56420.251099044792]
[null,24,284,"2044-03-01",3399.519167287664,151.31648327532923,3248.2026840123349,53172.048415032456]
[null,24,285,"2044-04-01",3399.519167287664,142.60495509996892,3256.9142121876953,49915.134202844762]
[null,24,286,"2044-05-01",3399.519167287664,133.87006301215214,3265.6491042755119,46649.485098569246]
[null,24,287,"2044-06-01",3399.519167287664,125.11174435095488,3274.4074229367093,43375.077675632536]
[null,24,288,"2044-07-01",3399.519167287664,116.32993628739941,3283.1892310002645,40091.88844463227]
[null,25,289,"2044-08-01",3399.519167287664,107.52457582400359,3291.9945914636605,36799.893853168607]
[null,25,290,"2044-09-01",3399.519167287664,98.695599794329041,3300.8235674933348,33499.070285675276]
[null,25,291,"2044-10-01",3399.519167287664,89.842944862527915,3309.6762224251361,30189.39406325014]
[null,25,292,"2044-11-01",3399.519167287664,80.966547522888519,3318.5526197647755,26870.841443485366]
[null,25,{"$f":"C306+1","v":293},"2044-12-01",3399.519167287664,72.066344099379862,3327.4528231882841,23543.388620297083]
[null,25,294,"2045-01-01",3399.519167287664,63.142270745194786,3336.3768965424692,20207.011723754615]
[null,25,295,"2045-02-01",3399.519167287664,54.194263442291977,3345.3249038453719,16861.686819909242]
[null,25,296,"2045-03-01",3399.519167287664,45.222258000936698,3354.2969092867274,13507.389910622514]
[null,25,297,"2045-04-01",3399.519167287664,36.22619005924038,3363.2929772284238,10144.09693339409]
[null,25,298,"2045-05-01",3399.519167287664,27.20599508269882,3372.3131722049652,6771.7837611891246]
[null,25,299,"2045-06-01",3399.519167287664,18.161608363729318,3381.3575589239349,3390.4262022651897]
[null,25,300,"2045-07-01",3399.519167287664,9.0929650212064406,3390.4262022664575,-1.267835614271462E-9]

{"sheet":"Graphs CashFlowProj_CashRet","index":15,"n_rows":1,"n_cols":1,"rows_kept":1,"cut":false,"hidden":true,"merged":[[0,0,1,7]]}
["Cash Flow Projections & Cash On Cash Return"]

{"sheet":"Graphs CapRate_DebtRat","index":16,"n_rows":1,"n_cols":1,"rows_kept":1,"cut":false,"hidden":true,"merged":[[0,0,1,7]]}
["Capitalization Rate & Debt Coverage Ratio"]

{"sheet":"About Us","index":17,"n_rows":23,"n_cols":5,"rows_kept":23,"cut":false,"hidden":true,"merged":[[4,1,7,9],[22,1,49,9],[8,1,8,9]]}
[]
[]
[]
[]
[null,"Real Estate Investment Analysis Software"]
[]
[]
[]
[null,"About Us"]
[]
[]
[]
[]
[]
[null,null,null,null,{"$f":"'Company Info'!B2","v":"[Enter Name]"}]
[null,null,null,null,{"$f":"'Company Info'!B3","v":"[Enter Company Name]"}]
[null,null,null,null,{"$f":"'Company Info'!B4","v":"[Enter Company Address]"}]
[null,null,null,null,{"$f":"'Company Info'!B5","v":"[Enter City, State, Zip]"}]
[null,null,null,null,{"$f":"'Company Info'!B6","v":"[Enter Phone]"}]
[]
[]
[]
[null,"Enter Text Here [Double Click To Enter Box]"]

{"sheet":"Terms & Definitions","index":18,"n_rows":53,"n_cols":1,"rows_kept":53,"cut":false,"hidden":true,"merged":[[3,0,5,0]]}
[]
[]
[]
["Real Estate Investment Analysis Software"]
[]
[]
[]
["Terms & Definitions"]
[]
[]
["General Assumptions"]
["Purchase Price – Agreed upon price by the buyer and seller to purchase the property."]
["Closing Costs – Fees paid upon closing of a real estate transaction. For our purposes, this includes all commissions, legal fees, appraisal costs, home inspection, appliances, and taxes."]
["Cash Reserves – Money set aside by the investor(s) for short-term and emergency funds."]
["Initial Improvements – Estimated cost of any property renovations to be made after closing."]
[""]
["Mortgage Details"]
["Down Payment % – Percentage of the full purchase price paid by the buyer at the onset of the property purchase."]
["Total Equity Investment – Amount of cash/down payment the investor makes towards the property purchase."]
["Total Loan Amount – Amount the investor has borrowed to purchase the property."]
["Interest Rate – Proportion of a loan charged as interest to the borrower, expressed as an annual percentage."]
["Mortgage Compounding Frequency – Compound interest is the addition of interest to the principal loan sum. Compounding frequency is the number of times per year that interest compounds, or in other words, the number of times per year accrued “interest is charged upon interest”. The frequency could be yearly, semi-annually, quarterly, or monthly."]
["Amortization – Systematic repayment of a loan over time, frequently used to extend the cost of an expensive and long-lived item such as real estate over many years."]
["Total # of Monthly Payments – Total number of loan payments amortized over a period of time. For example, a loan with a 25-year amortization will require the borrower to make 300 monthly payments in total (i.e.; 25 years x 12 months = 300 payments)."]
[""]
["Exit Assumptions"]
["Length of Hold (years) – Number of years the buyer intends to keep the property before selling it."]
["Annual Appreciation – Estimated annual property appreciation (expressed as a percentage)."]
["Projected Sale Price – Estimated sale price of the property is calculated by adding estimated annual appreciation to the purchase price over the estimated length of hold."]
["Adjusted Sale Price – Estimated sale price after all closing and renovation costs."]
[""]
["Core Deal Assumptions"]
["Net Present Value (NPV) – Value of all future cash flows (positive and negative) over the life of an investment discounted to the present. In other words, investors are using the time value of money to translate future cash flows into today’s dollars."]
["Discount Rate (%) for NPV Calculation – Required rate of return an investor expects to generate to make the investment worthwhile."]
["Rent Growth Rate (% per year) – Estimated annual rent increase is based upon multiple factors. For real estate investors, the most important factors deal with bringing the property up to its “highest and best use.”"]
["Annual Expense Growth Rate – Estimated annual percentage increase in expenses due to inflation."]
["Annual Vacancy Loss – Estimated annual percentage of vacancy."]
["Property Management Fee – Total expenses paid to a property manager for maintaining and managing the property."]
[""]
["Cash Flow Analysis"]
["Total Annual Income – Gross rental income received annually."]
["Net Operating Income (NOI) – Gross rental income minus all operating expenses."]
["Annual Cash Flow – Incoming cash minus outgoing cash. Net operating income minus annual debt service minus capital expenditures equals annual cash flow."]
["Debt Coverage Ratio – Measures the available cash flow’s ability to pay the current debt obligation. Calculated by net operating income (NOI) divided by the annual debt service. It is common to see an “x” after the ratio, which indicates that NOI covers the debt service “x” amount of times. The higher the ratio the better."]
["Operating Expense Ratio – Total operating expense divided by gross operating income, expressed as a percentage. A percentage below 35 is considered good."]
["Capitalization Rate – The ratio between an asset’s net operating income and its capital cost (the original price paid to buy the asset)."]
["Cash on Cash Return – Measures the total cash earned (before taxes) on the total cash invested, expressed as a percentage, calculated by taking the annual cash flow divided by the initial investment (down payment + closing costs + initial improvements)."]
["Leveraged Internal Rate of Return (IRR) – IRR is calculated using the same concept as NPV, except IRR sets the NPV to zero before computing the discount rate. The more debt (leverage) used will result in a higher IRR. For instance, 10–15% is considered a good IRR, but there are many other factors to consider (see disclaimer below)."]
["Leveraged Cash Multiple – Amount of cash the investor has after meeting financial obligations. The cash multiple, or “x” beside the number, represents the amount of money gained for every dollar invested. For example, 2x means the investor has doubled the initial investment."]
["Return on Equity Investment – Investor’s percentage of return in the property."]
[""]
["DISCLAIMER"]
["This report is intended for educational purposes only. Nothing should be considered a recommendation to make an investment. Please consult with your own independent business and financial advisor regarding any investment, including any contemplated investment evaluated using “Real Estate Investment Analysis Software” or any information contained in this report. You agree to hold www.RealEstateInvestmentSpecialist.com, its affiliates, and subsidiaries harmless for any consequences from choosing to act on any personal investment decisions."]