{"text_format":"2","workbook":"xlsx","n_sheets":2,"sheets":["MLS","List Price"],"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":"MLS","index":0,"n_rows":37,"n_cols":13,"rows_kept":37,"cut":false,"hidden":false,"merged":[[8,7,8,9],[23,7,23,9],[38,7,38,9]]}
[]
[null,"Easy Enough: Just fill in all the blue cells while reviewing a property and the results will populate throughout the sheet!"]
[null,"Address:","2101 johnson"]
[null,"Asking Price",1299000.0,"Price Per Sq ft",{"$f":"C4/C5","v":719.66759},{"$nulls":5},"Rent Growth Calculator"]
[null,"SQ FT",1805.0,"Price Per unit",{"$f":"C4/C7","v":433000}]
[null,"Year Built",1939.0,"Gross Rent Multiplier: GRM",{"$f":"C4/(E19*12)","v":18.85888502}]
[null,"Unit #",3.0,"Stabilized GRM",{"$f":"C4/(F19*12)","v":13.56516291}]
[{"$nulls":10},"Years 1-3 10% increase"]
[null,"Sale Price",1299000.0,{"$nulls":4},"Current Analysis",null,null,"Rent Growth Rate:",0.04]
[{"$nulls":10},"Market Rent (Year 1):",{"$f":"F19","v":7980}]
[null,"Unit Breakdown",{"$nulls":5},"Item","$/Mo."]
[null,"Unit #","#Beds","#Baths","Rent/Mo","Market Rent",null,"Gross Rents",{"$f":"E19","v":5740},null,"End of Year:","Market Rent"]
[null,"1: SFR",2.0,1.0,2750.0,3200.0,null,"Property Management",{"$f":"C$30*I12","v":287},null,1.0,{"$f":"E19*1.1","v":6314},0.1]
[null,"2: Studio A /1 bed",1.0,1.0,1600.0,2390.0,null,"Property Taxes: new",{"$f":"C$23/12","v":1217.8125},null,2.0,{"$f":"L13*1.1","v":6945.4},0.1]
[null,"3: Studio B /1 bed",1.0,1.0,1390.0,2390.0,null,"Insurance: current",{"$f":"C24","v":113.6666667},null,3.0,7639.94,0.1]
[{"$nulls":7},"Owner-Paid Utilities",{"$f":"SUM(C$25:C$29)","v":255.16},null,4.0,{"$f":"L15*1.04","v":7945.5376},0.04]
[{"$nulls":7},"Vacancy Reserve",{"$f":"C31*E19","v":0},null,5.0,8263.359104,0.04]
[{"$nulls":7},"Maintenance Reserve",{"$f":"I$12*C32","v":172.2},null,6.0,8593.893468,0.04]
[null,"Totals",{"$f":"SUM(C13:C18)","v":4},3,5740,7980,null,"Total Operating Expenses",{"$f":"SUM(I13:I18)","v":2045.839167},null,7.0,8937.649207,0.04]
[{"$nulls":7},"Monthly NOI",{"$f":"I12-SUM(I13:I18)","v":3694.160833},null,8.0,9295.155175,0.04]
[null,"Expenses",null,"Mortgage",null,null,null,"Annualized NOI",{"$f":"I20*12","v":44329.93},null,9.0,9666.961382,0.04]
[{"$nulls":7},"Capitalization Rate",{"$f":"I21/C9","v":0.03412619707},null,10.0,10053.63984,0.04]
[null,"Property Tax/Yr: NEW",{"$f":"C9*0.01125","v":14613.75},"Downpayment (%)",0.35,{"$nulls":5},11.0,10455.78543,0.04]
[null,"Insurance/Mo: current",{"$f":"1364/12","v":113.6666667},"Interest Rate (%)",0.06,null,null,"Stabilized pro forma analysis",null,null,12.0,10874.01685,0.04]
[null,"Gas & Electric/Mo",67.58,"Loan Term (Years)",30.0,{"$nulls":5},13.0,11308.97752,0.04]
[null,"Water/Mo",67.58,{"$nulls":4},"Item","$/Mo.",null,14.0,11761.33662,0.04]
[null,"Sewer/Mo",{"$nulls":5},"Gross Rents",{"$f":"F19","v":7980},null,15.0,12231.79009,0.04]
[null,"Garbage/Mo",0.0,{"$nulls":4},"Property Management",{"$f":"C$30*I27","v":399},null,16.0,12721.06169,0.04]
[null,"Land Scaping",120.0,{"$nulls":4},"Property Taxes",{"$f":"C$23/12","v":1217.8125},null,17.0,13229.90416,0.04]
[null,"Management (%)",0.05,{"$nulls":4},"Insurance",{"$f":"C$24","v":113.6666667},null,18.0,13759.10033,0.04]
[null,"Vacancy (%)",0.0,{"$nulls":4},"Owner-Paid Utilities",{"$f":"SUM(C$25:C$29)","v":255.16},null,19.0,14309.46434,0.04]
[null,"Maintenance (%) EST",0.03,{"$nulls":4},"Vacancy Reserve",{"$f":"C$31*I27","v":0},null,20.0,14881.84291,0.04]
[{"$nulls":7},"Maintenance Reserve",{"$f":"C32*I27","v":239.4}]
[{"$nulls":7},"Total Operating Expenses",{"$f":"SUM(I28:I33)","v":2225.039167}]
[{"$nulls":7},"Monthly NOI",{"$f":"I27-I34","v":5754.960833}]
[{"$nulls":7},"Annualized NOI",{"$f":"I35*12","v":69059.53}]
[{"$nulls":7},"Capitalization Rate",{"$f":"I36/C9","v":0.05316361047}]

{"sheet":"List Price","index":1,"n_rows":45,"n_cols":30,"rows_kept":45,"cut":false,"hidden":false,"merged":[[8,7,8,11],[11,21,11,22],[12,21,12,22],[13,21,13,22],[14,21,14,22],[15,21,15,22],[16,21,16,22],[23,7,23,11],[38,7,38,11],[17,21,17,22],[18,21,18,22],[19,21,19,22],[20,21,20,22],[21,21,21,22],[23,21,23,22],[24,21,24,22]]}
[]
[null,"Easy Enough: Just fill in all the blue cells while reviewing a property and the results will populate throughout the sheet!"]
[null,"Address:","2101 johnson"]
[null,"Asking Price",1299000.0,"Price Per Sq ft",{"$f":"C4/C5","v":719.66759},{"$nulls":23},"Rent Growth Calculator"]
[null,"SQ FT",1805.0,"Price Per unit",{"$f":"C4/C7","v":433000}]
[null,"Year Built",1939.0,"Gross Rent Multiplier: GRM",{"$f":"C4/(E19*12)","v":18.85888502}]
[null,"Unit #",3.0,"Stabilized GRM",{"$f":"C4/(F19*12)","v":13.56516291}]
[]
[null,"Sale Price",1299000.0,{"$nulls":4},"Current Pro Forma Analysis",{"$nulls":5},"Refi Scenario",null,null,null,"5 Year Debt Paydown Summary",null,null,null,"Does it qualify for a commercial loan?",{"$nulls":6},"Rent Growth Rate:",0.035]
[{"$nulls":21},"Debt Coverage Ratio Required:",null,1.25,{"$nulls":4},"Market Rent (Year 1):",{"$f":"F19","v":7980}]
[null,"Unit Breakdown",{"$nulls":5},"Item","$/Mo.",null,"Mortgage Calculator",null,null,"Mortgage Calculator",{"$nulls":4},"Year","Figure"]
[null,"Unit #","#Beds","#Baths","Rent/Mo","Market Rent",null,"Gross Rents",{"$f":"E19","v":5740},null,"Sale Price",{"$f":"C9","v":1299000},null,"Sale Price",{"$f":"C9","v":1299000},null,null,"Total Debt Paydown",1.0,{"$f":"($L$19*12)-T30","v":10368.71689},null,null,null,"Assumption","Pro Forma","Actual",null,null,"End of Year:","Market Rent"]
[null,"1: SFR",2.0,1.0,2750.0,3200.0,null,"Property Management",{"$f":"C$30*I12","v":287},{"$f":"I13*12","v":3444},"Loan to Value Ratio",{"$f":"1-E$23","v":0.65},null,"Loan to Value Ratio",{"$f":"1-E23","v":0.65},null,null,"ROI on Paydown",1.0,{"$f":"((T12)/$L$14)","v":0.0228059318},null,"Gross Rents",null,null,{"$f":"I12*12","v":68880},{"$f":"I12*12","v":68880},null,null,1.0,{"$f":"AD$10*((1+AD$9)^(AC13-1))","v":7980}]
[null,"2: Studio/1 bed",1.0,1.0,1600.0,2390.0,null,"Property Taxes: new",{"$f":"C$23/12","v":1217.8125},null,"Down Payment",{"$f":"E23*C9","v":454650},null,"Down Payment",{"$f":"E23*C9","v":454650},null,null,"Total Debt Paydown",2.0,{"$f":"($L$19*12)-T33","v":11008.23666},null,"Vacancy",null,0.03,{"$f":"Y13*X14","v":2066.4},{"$f":"I17*12","v":0},null,null,2.0,8259.3]
[null,"3: Studio/1 bed",1.0,1.0,1390.0,2390.0,null,"Insurance: current",{"$f":"C24","v":113.6666667},null,"Closing Costs",{"$f":"E$26","v":4546.5},null,"Closing Costs",{"$f":"E26","v":4546.5},null,null,"ROI on Paydown",2.0,{"$f":"((T14)/$L$14)","v":0.02421255177},null,"Prop Mgmt",null,0.07,{"$f":"Y13*X15","v":4821.6},{"$f":"12*I13","v":3444},null,null,3.0,8548.3755]
[{"$nulls":7},"Owner-Paid Utilities",{"$f":"SUM(C$25:C$29)","v":255.16},null,"Principal",{"$f":"L12*L13","v":844350},null,"Principal",{"$f":"O12*O13","v":844350},null,null,"Total Debt Paydown",3.0,{"$f":"($L$19*12)-T36","v":11687.20061},null,"Cash Reserves",null,0.03,{"$f":"X16*Y13","v":2066.4},{"$f":"0.03*Z13","v":2066.4},null,null,4.0,8847.568643]
[{"$nulls":7},"Vacancy Reserve",{"$f":"C31*E19","v":0},null,"Interest Rate",{"$f":"E$24","v":0.06},null,"New Interest Rate",0.045,null,null,"ROI on Paydown",3.0,{"$f":"((T16)/$L$14)","v":0.02570592898},null,"Taxes (actual)",null,null,{"$f":"I14*12","v":14613.75},{"$f":"I14*12","v":14613.75},null,null,5.0,9157.233545]
[{"$nulls":7},"Maintenance Reserve",{"$f":"I$12*C32","v":172.2},null,"Term (Years) ",{"$f":"E$25","v":30},null,"Term (Years) ",30.0,null,null,"Total Debt Paydown",4.0,{"$f":"($L$19*12)-T39","v":12408.04157},null,"Insurance (actual)",null,null,1364,1364,null,null,6.0,9477.736719]
[null,"Totals",{"$f":"SUM(C13:C18)","v":4},3,5740,7980,null,"Total Operating Expenses",{"$f":"SUM(I13:I18)","v":2045.839167},{"$f":"I19*12","v":24550.07},"Monthly Mortgage ",{"$f":"-PMT(L17/12,L18*12, L16)","v":5062.304859},null,"Monthly Mortgage ",{"$f":"-PMT(O17/12,O18*12, O16)","v":4278.197414},null,null,"ROI on Paydown",4.0,{"$f":"((T18)/$L$14)","v":0.02729141443},null,"Maintenance + Utilities",null,0.1,{"$f":"Y13*X19","v":6888},{"$f":"(I16+I18)*12","v":5128.32},null,null,7.0,9809.457504]
[{"$nulls":4},{"$f":"E19*12","v":68880},null,null,"Monthly NOI",{"$f":"I12-SUM(I13:I18)","v":3694.160833},null,"Monthly Net",{"$f":"I20-L19","v":-1368.144026},null,"Monthly Net",{"$f":"I20-O19","v":-584.0365802},null,null,"Total Debt Paydown",5.0,{"$f":"($L$19*12)-T42","v":13173.34243},null,"Total Expenses",null,null,{"$f":"SUM(Y14:Y18,Y19)","v":31820.15},26616.47,null,null,8.0,10152.78852]
[null,"Expenses",null,"Mortgage",null,null,null,"Annualized NOI",{"$f":"I20*12","v":44329.93},null,"Annualized Net",{"$f":"L20*12","v":-16417.72831},null,"Annualized Net",{"$f":"O20*12","v":-7008.438962},null,null,"ROI on Paydown",5.0,{"$f":"((T20)/$L$14)","v":0.02897468916},null,"NOI",null,null,{"$f":"Y13-Y20","v":37059.85},42263.53,null,null,9.0,10508.13611]
[{"$nulls":7},"Capitalization Rate",{"$f":"I21/L12","v":0.03412619707},null,"Annualized ROI",{"$f":"L21/(L14+L15)","v":-0.03575316517},null,"Annualized ROI",{"$f":"O21/(O14+O15)","v":-0.0152623963},{"$nulls":6},"Mortgage",null,null,{"$f":"L19*12","v":60747.65831},{"$f":"Y22","v":60747.65831},null,null,10.0,10875.92088]
[null,"Property Tax/Yr: NEW",{"$f":"C9*0.01125","v":14613.75},"Downpayment (%)",0.35,{"$nulls":23},11.0,11256.57811]
[null,"Insurance/Mo: current",{"$f":"1364/12","v":113.6666667},"Interest Rate (%)",0.06,null,null,"Stabilized pro forma analysis",{"$nulls":9},"Five Year Tax Deduction Summary",null,null,null,"Debt Coverage Ratio",null,null,{"$f":"Y21/Y22","v":0.6100621988},0.6957227846,null,null,12.0,11650.55834]
[null,"Gas & Electric/Mo",67.58,"Loan Term (Years)",30.0,{"$nulls":12},"Improved Value: Assessed Value Ratio (%)",null,0.8,null,"Net Profit",null,null,{"$f":"Y21-Y22","v":-23687.80831},-18484.12831,null,null,13.0,12058.32789]
[null,"Water/Mo",67.58,"Closing Costs (1%)",{"$f":"L14*0.01","v":4546.5},null,null,"Item","$/Mo.",null,"Mortgage Calculator",null,null,"Mortgage Calculator",null,null,null,"Marginal Tax Rate",null,0.51,{"$nulls":8},14.0,12480.36936]
[null,"Sewer/Mo",{"$nulls":5},"Gross Rents",{"$f":"F19","v":7980},null,"Sale Price",{"$f":"C9","v":1299000},null,"Sale Price",{"$f":"C9","v":1299000},{"$nulls":6},"Average Annualized % Appreciation",{"$nulls":6},15.0,12917.18229]
[null,"Garbage/Mo",0.0,{"$f":"C26*12","v":810.96},null,null,null,"Property Management",{"$f":"C$30*I27","v":399},null,"Loan to Value Ratio",{"$f":"1-E$23","v":0.65},null,"Loan to Value Ratio",{"$f":"1-E23","v":0.65},null,null,null,"Year","Figure",null,"Assumed Rate:",0.05,{"$nulls":5},16.0,13369.28367]
[null,"Land Scaping",120.0,{"$nulls":4},"Property Taxes",{"$f":"C$23/12","v":1217.8125},null,"Down Payment",{"$f":"E23*L27","v":454650},null,"Down Payment",{"$f":"E23*C9","v":454650},null,null,"Depreciation (Straight Line)",1.0,{"$f":"(T25*$L$12)/27.5","v":37789.09091},{"$nulls":8},17.0,13837.2086]
[null,"Management (%)",0.05,{"$nulls":4},"Insurance",{"$f":"C$24","v":113.6666667},null,"Closing Costs",{"$f":"E$26","v":4546.5},null,"Closing Costs",{"$f":"E26","v":4546.5},null,null,"Total Interest Paid ",1.0,{"$f":"-CUMIPMT($L$17/12,$L$18*12,$L$16,(1+(12*(S30-1))),(12*S30),0)","v":50378.94142},null,"End of Year:","Est. Value","Annual Gain","%  Gain",null,null,null,18.0,14321.5109]
[null,"Vacancy (%)",0.0,{"$nulls":4},"Owner-Paid Utilities",{"$f":"SUM(C$25:C$29)","v":255.16},null,"Principal",{"$f":"L27*L28","v":844350},null,"Principal",{"$f":"O27*O28","v":844350},null,null,"Total Deductions",1.0,{"$f":"SUM($T$29+$T30)","v":88168.03233},null,1.0,{"$f":"L12+(L12*$W$28)","v":1363950},{"$f":"W31-L12","v":64950},{"$f":"X31/$L$14","v":0.1428571429},null,null,null,19.0,14822.76378]
[null,"Maintenance (%) EST",0.03,{"$nulls":4},"Vacancy Reserve",{"$f":"C$31*I27","v":0},null,"Interest Rate",{"$f":"E$24","v":0.06},null,"Interest Rate",0.045,null,null,"Depreciation (Straight Line)",2.0,{"$f":"(T25*$L$12)/27.5","v":37789.09091},null,2.0,{"$f":"W31+(W31*$W$28)","v":1432147.5},{"$f":"W32-W31","v":68197.5},0.15,null,null,null,20.0,15341.56051]
[{"$nulls":7},"Maintenance Reserve",{"$f":"C32*I27","v":239.4},null,"Term (Years) ",{"$f":"E$25","v":30},null,"Term (Years) ",30.0,null,null,"Total Interest Paid ",2.0,{"$f":"-CUMIPMT($L$17/12,$L$18*12,$L$16,(1+(12*(S33-1))),(12*S33),0)","v":49739.42165},null,3.0,1503754.875,71607.375,0.1575]
[{"$nulls":7},"Total Operating Expenses",{"$f":"SUM(I28:I33)","v":2225.039167},null,"Monthly Mortgage",{"$f":"-PMT(L32/12,L33*12, L31)","v":5062.304859},null,"Monthly Mortgage",{"$f":"-PMT(O32/12,O33*12, O31)","v":4278.197414},null,null,"Total Deductions",2.0,{"$f":"SUM($T$29+$T33)","v":87528.51256},null,4.0,1578942.619,75187.74375,0.165375]
[{"$nulls":7},"Monthly NOI",{"$f":"I27-I34","v":5754.960833},null,"Monthly Net",{"$f":"I35-L34","v":692.6559742},null,"Monthly Net",{"$f":"I35-O34","v":1476.76342},null,null,"Depreciation (Straight Line)",3.0,{"$f":"(T25*$L$12)/27.5","v":37789.09091},null,5.0,1657889.75,78947.13094,0.17364375]
[{"$nulls":7},"Annualized NOI",{"$f":"I35*12","v":69059.53},null,"Annualized Net",{"$f":"L35*12","v":8311.87169},null,"Annualized Net",{"$f":"O35*12","v":17721.16104},null,null,"Total Interest Paid ",3.0,{"$f":"-CUMIPMT($L$17/12,$L$18*12,$L$16,(1+(12*(S36-1))),(12*S36),0)","v":49060.4577}]
[{"$nulls":7},"Capitalization Rate",{"$f":"I36/L27","v":0.05316361047},null,"Annualized ROI",{"$f":"L36/(L29+L30)","v":0.01810090384},null,"Annualized ROI",{"$f":"O36/(O29+O30)","v":0.03859167271},null,null,"Total Deductions",3.0,{"$f":"SUM($T$29+$T36)","v":86849.54861},null,"Total Return (% of initial investment)"]
[{"$nulls":17},"Depreciation (Straight Line)",4.0,{"$f":"(T25*$L$12)/27.5","v":37789.09091},null,"Year",1.0,2.0,3.0,4.0,5.0]
[{"$nulls":17},"Total Interest Paid ",4.0,{"$f":"-CUMIPMT($L$17/12,$L$18*12,$L$16,(1+(12*(S39-1))),(12*S39),0)","v":48339.61674},null,"Source of Gain"]
[{"$nulls":17},"Total Deductions",4.0,{"$f":"SUM($T$29+$T39)","v":86128.70765},null,"Cash flow",{"$f":"$L$37","v":0.01810090384},0.01810090384,0.01810090384,0.01810090384,0.01810090384]
[{"$nulls":17},"Depreciation (Straight Line)",5.0,{"$f":"(T25*$L$12)/27.5","v":37789.09091},null,"Debt Paydown",{"$f":"T13","v":0.0228059318},{"$f":"T15","v":0.02421255177},{"$f":"T17","v":0.02570592898},{"$f":"T19","v":0.02729141443},{"$f":"T21","v":0.02897468916}]
[{"$nulls":17},"Total Interest Paid ",5.0,{"$f":"-CUMIPMT($L$17/12,$L$18*12,$L$16,(1+(12*(S42-1))),(12*S42),0)","v":47574.31588},null,"Tax Savings",{"$f":"(T31*T26)/L14","v":0.09890178486},{"$f":"(T34*T26)/L14","v":0.09818440867},{"$f":"(T37*T26)/L14","v":0.0974227863},{"$f":"(T40*T26)/L14","v":0.09661418872},{"$f":"(T43*T26)/L14","v":0.09575571861}]
[{"$nulls":17},"Total Deductions",5.0,{"$f":"SUM($T$29+$T42)","v":85363.40679},null,"Appreciation",{"$f":"Y31","v":0.1428571429},{"$f":"Y32","v":0.15},{"$f":"Y33","v":0.1575},{"$f":"Y34","v":0.165375},{"$f":"Y35","v":0.17364375}]
[{"$nulls":17},"Avg Yearly Tax Savings",null,{"$f":"(AVERAGE(T31,T34,T37,T40,T43))*T26","v":44271.89721},null,"Total ROI",{"$f":"SUM(W40:W43)","v":0.2826657634},0.2904978643,0.2987296191,0.307381507,0.3164750616]
[{"$nulls":17},"% Annual ROI on Tax Savings",null,{"$f":"T44/L14","v":0.09737577743},null,"Total $ Return",{"$f":"W44*$L$14","v":128513.9893},132074.854,135817.4213,139751.0022,143885.3868]