{"text_format":"2","workbook":"xlsx","n_sheets":1,"sheets":["Detailed Analysis"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":1,"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":"Detailed Analysis","index":0,"n_rows":72,"n_cols":35,"rows_kept":72,"cut":false,"hidden":false,"merged":[[12,9,12,11],[15,9,15,10],[16,9,16,10],[1,3,1,11],[6,9,6,11],[8,9,8,10],[9,9,9,10],[14,9,14,10],[13,9,13,10],[9,5,9,6],[11,5,11,6],[3,8,3,9],[4,8,4,9],[3,1,4,1],[3,2,3,3],[4,2,4,3],[3,4,3,5],[6,1,6,3],[6,5,6,7],[4,4,4,5],[3,6,3,7],[4,6,4,7],[1,1,1,2],[9,1,9,2],[15,5,15,7],[23,1,23,11],[24,1,28,11],[12,5,12,6],[13,5,13,6],[10,1,10,2],[8,1,8,2],[3,10,3,11],[4,10,4,11],[7,5,7,6],[8,5,8,6],[10,5,10,6],[7,1,7,2],[7,9,7,10],[68,1,68,2],[48,1,48,2],[49,1,49,2],[50,1,50,2],[51,1,51,2],[52,1,52,2],[58,1,58,2],[59,1,59,2],[60,1,60,2],[61,1,61,2],[63,1,63,2],[64,1,64,2],[47,1,47,2],[11,1,11,2],[44,1,44,2],[45,1,45,2],[46,1,46,2],[13,1,13,3],[14,1,14,2],[15,1,15,2],[43,1,43,2],[19,1,19,2],[17,1,17,3],[32,1,32,3],[33,1,33,3]]}
[]
[null,"Property Address",null,"465 Colorado Boulevard, Idaho Springs, CO 80452"]
[]
[null,"Property Details","Bedroom(s)",null,"Bath(s)",null,"Square Feet",null,"Year Built",null,"Other Information"]
[null,null,"tbd",null,"tbd",null,"tbd",null,"tbd",null,"0.42 acres / 18,480 sq ft"]
[]
[null,"Cost Assumptions",null,null,null,"Financing Assumptions",null,null,null,"CF & ROI (Outsourced PM)"]
[null,"Purchase Price",null,1400000,null,"Downpayment",null,0.25,null,"Monthly Cash Flow",null,{"$f":"$E$60-$E$61","v":4938.3238006185766}]
[null,"Improvements",null,0,null,"Finance Amount",null,{"$f":"(1-H8)*D8","v":1050000},null,"Annual Cash Flow",null,{"$f":"$F$62","v":59259.885607422912}]
[null,"Set Up Costs",null,0,null,"Downpayment Amount",null,{"$f":"H8*D8","v":350000},null,"Cash ROI",null,{"$f":"$F$63","v":0.16931395887835118}]
[null,"Closing Costs",null,0,null,"Interest Rate",null,7.0000000000000007E-2]
[null,"Total Cost ",null,{"$f":"D8+D9+D10+D11","v":1400000},null,"Mortgage (Years)",null,30]
[{"$nulls":5},"Mortgage Payment",null,{"$f":"-PMT(H11/12,12*H12, H9)","v":6985.6761993814234},null,"CF & ROI (Doing My Own PM)"]
[null,"Revenue Assumptions",null,null,null,"Cash Outlay",null,{"$f":"H10+D9+D10+D11","v":350000},null,"Monthly Cash Flow",null,{"$f":"L8+(F50+F51)/12","v":4938.3238006185766}]
[null,"Monthly Rent",null,13100,{"$nulls":5},"Annual Cash Flow",null,{"$f":"L9+F50+F51","v":59259.885607422912}]
[null,"Vacancy Rate",null,0,null,"Cash Flow (Based on Outsourced PM #'s)",null,null,null,"Cash ROI",null,{"$f":"L15/H14","v":0.16931395887835118}]
[{"$nulls":5},"Cash Flow",null,{"$f":"+$L$9/$H$14","v":0.16931395887835118}]
[null,"Additional Inputs",null,null,null,"Appreciation",null,{"$f":"(($D$8*(1+$D$19))-$D$8)/$H$14","v":0.2}]
[null,"Annual Appreciation Rate",null,0.05,null,"Debt Paydown",null,{"$f":"-(CUMPRINC($H$11/12,$H$12*12,$H$9,1,12,0))/$H$14","v":3.0474294878850939E-2}]
[null,"Effective Tax Rate",null,0.24,null,"Depreciation",null,{"$f":"+($D$8*0.85/27.5)*$D$20/$H$14","v":2.9672727272727267E-2}]
[{"$nulls":5},"TOTAL ROI",null,{"$f":"+SUM(H17:H20)","v":0.42946098102992936}]
[]
[]
[null,"Additional Notes"]
[null,"County Assessor Link: https://assessor.co.clear-creek.co.us/eagleassessor/taxweb/account.jsp?accountNum=R004288&doc= \n*See Offer Memorandum for the rent breakdown details.\n*Owner does all the maintenance work and management himself."]
[]
[]
[]
[]
[]
[]
[{"$nulls":5},"Year 1","Year 2","Year 3","Year 4","Year 5","Year 6","Year 7","Year 8","Year 9","Year 10","Year 11","Year 12","Year 13","Year 14","Year 15","Year 16","Year 17","Year 18","Year 19","Year 20","Year 21","Year 22","Year 23","Year 24","Year 25","Year 26","Year 27","Year 28","Year 29","Year 30"]
[null,"Annual Revenue Increase",null,null,0.02,0,{"$f":"E33","v":0.02},{"$f":"E33","v":0.02},{"$f":"E33","v":0.02},{"$f":"E33","v":0.02},{"$f":"E33","v":0.02},{"$f":"E33","v":0.02},{"$f":"E33","v":0.02},{"$f":"E33","v":0.02},{"$f":"E33","v":0.02},{"$f":"E33","v":0.02},{"$f":"E33","v":0.02},{"$f":"E33","v":0.02},{"$f":"E33","v":0.02},{"$f":"E33","v":0.02},{"$f":"E33","v":0.02},{"$f":"G33","v":0.02},{"$f":"E33","v":0.02},{"$f":"E33","v":0.02},{"$f":"E33","v":0.02},{"$f":"E33","v":0.02},{"$f":"E33","v":0.02},{"$f":"E33","v":0.02},{"$f":"E33","v":0.02},{"$f":"E33","v":0.02},{"$f":"E33","v":0.02},{"$f":"E33","v":0.02},{"$f":"E33","v":0.02},{"$f":"E33","v":0.02},{"$f":"E33","v":0.02}]
[null,"Annual Operating Expense Increase",null,null,0.02,0,{"$f":"E34","v":0.02},{"$f":"E34","v":0.02},{"$f":"E34","v":0.02},{"$f":"E34","v":0.02},{"$f":"E34","v":0.02},{"$f":"E34","v":0.02},{"$f":"E34","v":0.02},{"$f":"E34","v":0.02},{"$f":"E34","v":0.02},{"$f":"E34","v":0.02},{"$f":"E34","v":0.02},{"$f":"E34","v":0.02},{"$f":"E34","v":0.02},{"$f":"E34","v":0.02},{"$f":"E34","v":0.02},{"$f":"G34","v":0.02},{"$f":"E34","v":0.02},{"$f":"E34","v":0.02},{"$f":"E34","v":0.02},{"$f":"E34","v":0.02},{"$f":"E34","v":0.02},{"$f":"E34","v":0.02},{"$f":"E34","v":0.02},{"$f":"E34","v":0.02},{"$f":"E34","v":0.02},{"$f":"E34","v":0.02},{"$f":"E34","v":0.02},{"$f":"E34","v":0.02},{"$f":"E34","v":0.02}]
[]
[{"$nulls":4},"Monthly","Year 1","Year 2","Year 3","Year 4","Year 5","Year 6","Year 7","Year 8","Year 9","Year 10","Year 11","Year 12","Year 13","Year 14","Year 15","Year 16","Year 17","Year 18","Year 19","Year 20","Year 21","Year 22","Year 23","Year 24","Year 25","Year 26","Year 27","Year 28","Year 29","Year 30"]
[null,"Revenues"]
[null,"Rental Income",null,null,{"$f":"+D15","v":13100},{"$f":"E38*12","v":157200},{"$f":"F38+(G33*F38)","v":160344},163550.88,166821.8976,{"$f":"I38+(J33*I38)","v":170158.335552},173561.50226303999,177032.73230830079,{"$f":"L38+(M33*L38)","v":180573.38695446681},184184.85469355615,187868.55178742728,191625.92282317582,195458.44127963934,199367.61010523213,203354.96230733677,207422.06155348351,211570.50278455319,215801.91284024424,220117.95109704914,224520.31011899014,229010.71632136992,233590.93064779733,238262.74926075328,243028.00424596833,247888.56433088769,252846.33561750545,257903.26232985556,263061.32757645269,268322.55412798177,273689.00521054142,279162.78531475225]
[null,"Vacancy/Loss Rate",null,null,{"$f":"+D16","v":0},{"$f":"+E39","v":0},{"$f":"+$E$39","v":0},{"$f":"+$E$39","v":0},{"$f":"+$E$39","v":0},{"$f":"+$E$39","v":0},{"$f":"+$E$39","v":0},{"$f":"+$F$39","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Vacancy/Loss Value",null,null,{"$f":"-($E$38*$E$39)","v":0},{"$f":"-(F38*F39)","v":0},{"$f":"-(G38*G39)","v":0},{"$f":"-(H38*H39)","v":0},0,0,0,{"$f":"-(L38*L39)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Gross Income",null,null,{"$f":"E38+E40","v":13100},{"$f":"F38+F40","v":157200},{"$f":"G38+G40","v":160344},{"$f":"H38+H40","v":163550.88},166821.8976,170158.335552,173561.50226303999,177032.73230830079,180573.38695446681,184184.85469355615,187868.55178742728,191625.92282317582,195458.44127963934,199367.61010523213,203354.96230733677,207422.06155348351,211570.50278455319,215801.91284024424,220117.95109704914,224520.31011899014,229010.71632136992,233590.93064779733,238262.74926075328,243028.00424596833,247888.56433088769,252846.33561750545,257903.26232985556,263061.32757645269,268322.55412798177,273689.00521054142,279162.78531475225]
[]
[null,"Expenses"]
[null,"Property Taxes",null,"Annual",310,{"$f":"E44","v":310},{"$f":"F44+(G34*F44)","v":316.2},322.524,328.97448000000003,{"$f":"I44+(J34*I44)","v":335.55396960000002},342.265048992,349.11034997183998,{"$f":"L44+(M34*L44)","v":356.09255697127679},363.21440811070232,370.47869627291635,377.8882701983747,385.44603560234219,393.15495631438904,401.01805544067685,409.03841654949036,417.21918488048016,425.56356857808976,434.07483994965156,442.75633674864457,451.61146348361746,460.64369275328983,469.85656660835565,479.25369794052278,488.83877189933327,498.61554733731992,508.58785828406633,518.75961544974768,529.13480775874268,539.71750391391754,550.51185399219594]
[null,"Insurance",null,"Annual",2006,{"$f":"E45","v":2006},{"$f":"F45+(G34*F45)","v":2046.12},2087.0423999999998,2128.7832479999997,{"$f":"I45+(J34*I45)","v":2171.3589129599995},2214.7860912191995,2259.0818130435837,{"$f":"L45+(M34*L45)","v":2304.2634493044552},2350.3487182905442,2397.3556926563551,2445.3028065094823,2494.2088626396717,2544.0930398924652,2594.9749006903144,2646.8743987041207,2699.8118866782033,2753.8081244117675,2808.8842869000027,2865.0619726380028,2922.3632120907628,2980.8104763325782,3040.4266858592296,3101.2352195764142,3163.2599239679425,3226.5251224473013,3291.0556248962475,3356.8767373941723,3424.0142721420557,3492.4945575848969,3562.344448736595]
[null,"Maintenance & Repairs",null,"Annual",9996,{"$f":"E46","v":9996},{"$f":"F46+(G34*F46)","v":10195.92},10399.838400000001,10607.835168000001,{"$f":"I46+(J34*I46)","v":10819.991871360002},11036.391708787201,11257.119542962946,{"$f":"L46+(M34*L46)","v":11482.261933822205},11711.90717249865,11946.145315948623,12185.068222267595,12428.769586712948,12677.344978447207,12930.891878016151,13189.509715576474,13453.299909888005,13722.365908085765,13996.813226247481,14276.74949077243,14562.284480587879,14853.530170199638,15150.60077360363,15453.612789075703,15762.685044857217,16077.938745754362,16399.497520669447,16727.487471082837,17062.037220504495,17403.277964914585,17751.343524212876]
[null,"Utilities (Water/Elec/Gas/Sewer)",null,"Annual",0,0,{"$f":"F47+(G34*F47)","v":0},0,0,{"$f":"I47+(J34*I47)","v":0},0,0,{"$f":"L47+(M34*L47)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Advertising",null,"Annual",0,0,{"$f":"F48+(G34*F48)","v":0},0,0,{"$f":"I48+(J34*I48)","v":0},0,0,{"$f":"L48+(M34*L48)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Administrative",null,"Annual",0,0,{"$f":"F49+(G34*F49)","v":0},0,0,{"$f":"I49+(J34*I49)","v":0},0,0,{"$f":"L49+(M34*L49)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Variable Cost PM",null,"(% Income)",0,{"$f":"E50*F41","v":0},{"$f":"$E50*G41","v":0},0,0,{"$f":"$E50*J41","v":0},{"$f":"$E50*K41","v":0},{"$f":"$E50*L41","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Fixed Cost PM",null,"Annual",0,{"$f":"+E51","v":0},{"$f":"F51+(G34*F51)","v":0},{"$f":"G51+(H34*G51)","v":0},0,{"$f":"I51+(J34*I51)","v":0},0,0,{"$f":"L51+(M34*L51)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Trash",null,"Annual",1800,{"$f":"E52","v":1800},{"$f":"F52+(G34*F52)","v":1836},{"$f":"G52+(H34*G52)","v":1872.72},1910.1744000000001,{"$f":"I52+(J34*I52)","v":1948.3778880000002},1987.3454457600003,2027.0923546752003,{"$f":"L52+(M34*L52)","v":2067.6342017687043},2108.9868858040786,2151.1666235201601,2194.1899559905632,2238.0737551103743,2282.8352302125818,2328.4919348168332,2375.06177351317,2422.5630089834335,2471.0142691631022,2520.4345545463643,2570.8432456372916,2622.2601105500376,2674.7053127610384,2728.1994190162591,2782.7634073965842,2838.4186755445157,2895.1870490554061,2953.0907900365141,3012.1526058372442,3072.395657953989,3133.8435711130687,3196.5204425353299]
[null,"TBD",null,"Monthly",0,{"$f":"E53","v":0},{"$f":"F53+(G34*F53)","v":0},{"$f":"G53+(H34*G53)","v":0},0,{"$f":"I53+(J34*I53)","v":0},0,0,{"$f":"L53+(M34*L53)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Total Expenses",null,null,null,{"$f":"SUM(F44:F53)","v":14112},{"$f":"SUM(G44:G53)","v":14394.24},{"$f":"SUM(H44:H53)","v":14682.1248},14975.767296000002,15275.282641920003,15580.788294758402,15892.404060653569,16210.25214186664,16534.457184703973,16865.146328398056,17202.449254966014,17546.498240065335,17897.428204866643,18255.376768963975,18620.484304343256,18992.893990430122,19372.751870238724,19760.2069076435,20155.411045796369,20558.519266712297,20969.689652046545,21389.083445087475,21816.865113989224,22253.202416269007,22698.266464594388,23152.231793886272,23615.276429764002,24087.581958359282,24569.333597526467,25060.720269476995]
[null,"Expenses as % of Gross Income",null,null,null,{"$f":"(F54-F40)/F38","v":8.9770992366412214E-2},{"$f":"(G54-G40)/G38","v":8.9770992366412214E-2},{"$f":"(H54-H40)/H38","v":8.9770992366412214E-2},8.9770992366412228E-2,8.9770992366412228E-2,8.9770992366412228E-2,8.9770992366412228E-2,8.9770992366412214E-2,8.9770992366412228E-2,8.9770992366412228E-2,8.9770992366412214E-2,8.9770992366412228E-2,8.9770992366412228E-2,8.9770992366412228E-2,8.9770992366412228E-2,8.9770992366412228E-2,8.9770992366412228E-2,8.9770992366412242E-2,8.9770992366412228E-2,8.9770992366412242E-2,8.9770992366412242E-2,8.9770992366412242E-2,8.9770992366412242E-2,8.9770992366412228E-2,8.9770992366412242E-2,8.9770992366412228E-2,8.9770992366412228E-2,8.9770992366412228E-2,8.9770992366412214E-2,8.9770992366412214E-2]
[]
[null,"Net Operating Income (NOI)",null,null,null,{"$f":"F41-F54","v":143088},{"$f":"G41-G54","v":145949.76000000001},148868.75520000001,151846.13030399999,154883.05291008,157980.71396828158,161140.32824764724,164363.13481260018,167650.39750885218,171003.40545902922,174423.4735682098,177911.94303957402,181470.18190036548,185099.5855383728,188801.57724914025,192577.60879412305,196429.16097000553,200357.74418940564,204364.89907319378,208452.19705465762,212621.24099575079,216873.66581566579,221211.13913197911,225635.3619146187,230148.06915291108,234751.03053596927,239446.0511466887,244234.97216962249,249119.67161301494,254102.06504527526]
[]
[null,"Cash Flow"]
[null,"NOI (Cash Available)",null,null,{"$f":"$F$60/12","v":11924},{"$f":"F57","v":143088},{"$f":"G57","v":145949.76000000001},148868.75520000001,151846.13030399999,154883.05291008,157980.71396828158,161140.32824764724,164363.13481260018,167650.39750885218,171003.40545902922,{"$f":"P57","v":174423.4735682098},{"$f":"Q57","v":177911.94303957402},{"$f":"R57","v":181470.18190036548},{"$f":"S57","v":185099.5855383728},{"$f":"T57","v":188801.57724914025},{"$f":"U57","v":192577.60879412305},196429.16097000553,200357.74418940564,204364.89907319378,208452.19705465762,212621.24099575079,216873.66581566579,221211.13913197911,225635.3619146187,230148.06915291108,{"$f":"AE57","v":234751.03053596927},{"$f":"AF57","v":239446.0511466887},{"$f":"AG57","v":244234.97216962249},{"$f":"AH57","v":249119.67161301494},{"$f":"AI57","v":254102.06504527526}]
[null,"Mortgage",null,null,{"$f":"$H$13","v":6985.6761993814234},{"$f":"E61*12","v":83828.114392577088},{"$f":"F61","v":83828.114392577088},83828.114392577088,83828.114392577088,{"$f":"I61","v":83828.114392577088},83828.114392577088,83828.114392577088,{"$f":"L61","v":83828.114392577088},83828.114392577088,83828.114392577088,83828.114392577088,83828.114392577088,83828.114392577088,83828.114392577088,83828.114392577088,83828.114392577088,83828.114392577088,83828.114392577088,83828.114392577088,83828.114392577088,83828.114392577088,83828.114392577088,83828.114392577088,83828.114392577088,83828.114392577088,{"$f":"AD61","v":83828.114392577088},{"$f":"AE61","v":83828.114392577088},{"$f":"AF61","v":83828.114392577088},{"$f":"AG61","v":83828.114392577088},{"$f":"AH61","v":83828.114392577088}]
[null,"Total Cash Flow",null,null,{"$f":"$E$60-$E$61","v":4938.3238006185766},{"$f":"F60-F61","v":59259.885607422912},{"$f":"G60-G61","v":62121.645607422921},65040.640807422926,68018.015911422903,71054.938517502917,74152.599575704488,77312.213855070149,80535.020420023095,83822.283116275095,87175.291066452133,{"$f":"P60-P61","v":90595.359175632708},{"$f":"Q60-Q61","v":94083.828646996932},{"$f":"R60-R61","v":97642.067507788393},{"$f":"S60-S61","v":101271.47114579572},{"$f":"T60-T61","v":104973.46285656316},{"$f":"U60-U61","v":108749.49440154596},112601.04657742844,116529.62979682855,120536.78468061669,124624.08266208053,128793.1266031737,133045.55142308871,137383.02473940203,141807.24752204161,146319.95476033399,{"$f":"AE60-AE61","v":150922.91614339218},{"$f":"AF60-AF61","v":155617.93675411161},{"$f":"AG60-AG61","v":160406.8577770454},{"$f":"AH60-AH61","v":165291.55722043785},{"$f":"AI60-AI61","v":170273.95065269817}]
[null,"Cash ROI",null,null,null,{"$f":"F62/H14","v":0.16931395887835118},{"$f":"G62/H14","v":0.17749041602120835},{"$f":"H62/H14","v":0.18583040230692263},{"$f":"I62/H14","v":0.19433718831835115},{"$f":"J62/H14","v":0.20301411005000833},{"$f":"K62/H14","v":0.21186457021629854},{"$f":"L62/H14","v":0.22089203958591472},{"$f":"M62/H14","v":0.23010005834292313},{"$f":"N62/H14","v":0.2394922374750717},{"$f":"O62/H14","v":0.24907226018986323},{"$f":"P62/H14","v":0.25884388335895059},{"$f":"Q62/H14","v":0.26881093899141978},{"$f":"R62/H14","v":0.27897733573653827},{"$f":"S62/H14","v":0.28934706041655917},{"$f":"T62/H14","v":0.29992417959018047},{"$f":"U62/H14","v":0.31071284114727415},{"$f":"V62/H14","v":0.32171727593550981},{"$f":"W62/H14","v":0.33294179941951013},{"$f":"X62/H14","v":0.34439081337319055},{"$f":"Y62/H14","v":0.35606880760594439},{"$f":"Z62/H14","v":0.36798036172335341},{"$f":"AA62/H14","v":0.38013014692311059},{"$f":"AB62/H14","v":0.39252292782686293},{"$f":"AC62/H14","v":0.40516356434869033},{"$f":"AD62/H14","v":0.41805701360095426},{"$f":"AE62/H14","v":0.4312083318382634},{"$f":"AF62/H14","v":0.44462267644031889},{"$f":"AG62/H14","v":0.45830530793441543},{"$f":"AH62/H14","v":0.47226159205839385},{"$f":"AI62/H14","v":0.4864970018648519}]
[null,"Equity Accrued",null,null,null,{"$f":"-CUMPRINC(H11/12,12*H12, H9, 1, 12, 0)","v":10666.003207597829},{"$f":"-CUMPRINC(H11/12,12*H12, H9, 13, 24, 0)","v":11437.049441887948},{"$f":"-CUMPRINC(H11/12,12*H12, H9, 25, 36, 0)","v":12263.834670798793},{"$f":"-CUMPRINC(H11/12,12*H12, H9, 37, 48, 0)","v":13150.388270758343},{"$f":"-CUMPRINC(H11/12,12*H12, H9, 49, 60, 0)","v":14101.030902142358},{"$f":"-CUMPRINC(H11/12,12*H12, H9, 61, 72, 0)","v":15120.395566214505},{"$f":"-CUMPRINC(H11/12,12*H12, H9, 73, 84, 0)","v":16213.450184274421},{"$f":"-CUMPRINC(H11/12,12*H12, H9, 85, 96, 0)","v":17385.521809054164},{"$f":"-CUMPRINC(H11/12,12*H12, H9, 97, 108, 0)","v":18642.322586358539},{"$f":"-CUMPRINC(H11/12,12*H12, H9, 109, 120, 0)","v":19989.977593474428},{"$f":"-CUMPRINC(H11/12,12*H12, H9, 121, 132, 0)","v":21435.054690021036},{"$f":"-CUMPRINC(H11/12,12*H12, H9, 133, 144, 0)","v":22984.596526720488},{"$f":"-CUMPRINC(H11/12,12*H12, H9, 145, 156, 0)","v":24646.154868085068},{"$f":"-CUMPRINC(H11/12,12*H12, H9, 157, 168, 0)","v":26427.827396294248},{"$f":"-CUMPRINC(H11/12,12*H12, H9, 169, 180, 0)","v":28338.297175626994},{"$f":"-CUMPRINC(H11/12,12*H12, H9, 181, 192, 0)","v":30386.874969781104},{"$f":"-CUMPRINC(H11/12,12*H12, H9, 193, 204, 0)","v":32583.544618314907},{"$f":"-CUMPRINC(H11/12,12*H12, H9, 205, 216, 0)","v":34939.011693355649},{"$f":"-CUMPRINC(H11/12,12*H12, H9, 217, 228, 0)","v":37464.755673705295},{"$f":"-CUMPRINC(H11/12,12*H12, H9, 229, 240, 0)","v":40173.085890616574},{"$f":"-CUMPRINC(H11/12,12*H12, H9, 241, 252, 0)","v":43077.201517893729},{"$f":"-CUMPRINC(H11/12,12*H12, H9, 253, 264, 0)","v":46191.255898682633},{"$f":"-CUMPRINC(H11/12,12*H12, H9, 265, 276, 0)","v":49530.425522449477},{"$f":"-CUMPRINC(H11/12,12*H12, H9, 277, 288, 0)","v":53110.983988311105},{"$f":"-CUMPRINC(H11/12,12*H12, H9, 289, 300, 0)","v":56950.381315180362},{"$f":"-CUMPRINC(H11/12,12*H12, H9, 301, 312, 0)","v":61067.328985248198},{"$f":"-CUMPRINC(H11/12,12*H12, H9, 313, 324, 0)","v":65481.891135266138},{"$f":"-CUMPRINC(H11/12,12*H12, H9, 325, 336, 0)","v":70215.582340053734},{"$f":"-CUMPRINC(H11/12,12*H12, H9, 337, 348, 0)","v":75291.472464783903},{"$f":"-CUMPRINC(H11/12,12*H12, H9, 349, 360, 0)","v":80734.299097048177}]
[null,"Total Return",null,null,null,{"$f":"F62+F64","v":69925.888815020735},{"$f":"G62+G64","v":73558.695049310874},{"$f":"H62+H64","v":77304.475478221721},81168.404182181243,85155.969419645277,89272.995141918989,93525.66403934457,97920.542229077255,102464.60570263363,107165.26865992656,112030.41386565374,117068.42517371742,122288.22237587346,127699.29854208996,133311.76003219016,139136.36937132708,145184.59119574336,151468.64149018421,158001.540354322,164797.16855269711,171870.32812106743,179236.80732177134,186913.45026185151,194918.23151035272,203270.33607551435,211990.24512864038,221099.82788937775,230622.44011709915,240583.02968522176,251008.24974974635]
[null,"Total ROI",null,null,null,{"$f":"F65/H14","v":0.19978825375720211},{"$f":"G65/H14","v":0.2101677001408882},{"$f":"H65/H14","v":0.22086992993777635},{"$f":"I65/H14","v":0.23190972623480355},{"$f":"J65/H14","v":0.24330276977041507},{"$f":"K65/H14","v":0.25506570040548282},{"$f":"L65/H14","v":0.2672161829695559},{"$f":"M65/H14","v":0.2797729777973636},{"$f":"N65/H14","v":0.29275601629323894},{"$f":"O65/H14","v":0.30618648188550446},{"$f":"P65/H14","v":0.3200868967590107},{"$f":"Q65/H14","v":0.33448121478204978},{"$f":"R65/H14","v":0.34939492107392417},{"$f":"S65/H14","v":0.36485513869168562},{"$f":"T65/H14","v":0.38089074294911474},{"$f":"U65/H14","v":0.39753248391807738},{"$f":"V65/H14","v":0.41481311770212387},{"$f":"W65/H14","v":0.43276754711481202},{"$f":"X65/H14","v":0.45143297244092001},{"$f":"Y65/H14","v":0.47084905300770602},{"$f":"Z65/H14","v":0.49105808034590692},{"$f":"AA65/H14","v":0.51210516377648951},{"$f":"AB65/H14","v":0.53403842931957579},{"$f":"AC65/H14","v":0.55690923288672212},{"$f":"AD65/H14","v":0.58077238878718385},{"$f":"AE65/H14","v":0.60568641465325823},{"$f":"AF65/H14","v":0.63171379396965066},{"$f":"AG65/H14","v":0.65892125747742614},{"$f":"AH65/H14","v":0.6873800848149193},{"$f":"AI65/H14","v":0.71716642785641815}]
[]
[null,"Cash Flow / Mortgage Ratio",null,null,null,{"$f":"F60/F61","v":1.7069213716283989},{"$f":"G60/G61","v":1.7410597990609669},1.7758809950421863,1.8113986149430297,1.8476265872418904,1.8845791189867278,1.9222707013664628,1.9607161153937922,1.999930437701668,2.0399290464557014,2.0807276273848152,2.1223421799325117,2.1647890235311618,2.2080848040017851,2.2522465000818208,2.2972914300834573,2.3432372586851264,2.390102003858829,2.437904043936006,2.4866621248147256,2.5363953673110204,2.5871232746572406,2.6388657401503854,2.691643054953393,2.7454759160524609,2.80038543437351,{"$f":"AF60/AF61","v":2.8563931430609806},{"$f":"AG60/AG61","v":2.9135210059222003},{"$f":"AH60/AH61","v":2.9717914260406446},{"$f":"AI60/AI61","v":3.0312272545614576}]
[]
[]
[null,"Total Equity Accrued",null,null,null,{"$f":"F64","v":10666.003207597829},{"$f":"G64+F71","v":22103.052649485777},34366.887320284572,47517.275591042911,{"$f":"J64+I71","v":61618.306493185271},76738.702059399773,92952.152243674194,{"$f":"M64+L71","v":110337.67405272835},{"$f":"N64+M71","v":128979.99663908689},148969.97423256133,170405.02892258237,{"$f":"Q64+P71","v":193389.62544930284},218035.78031738789,244463.60771368214,272801.90488930914,303188.77985909022,335772.32447740511,370711.33617076074,408176.09184446605,448349.17773508263,491426.37925297639,537617.63515165902,587148.06067410845,640259.04466241959,697209.42597759992,758276.75496284815,823758.64609811432,893974.22843816807,969265.700902952,1050000.0000000002]
[null,"Loan Payoff Amount",null,null,null,{"$f":"H9-F71","v":1039333.9967924021},{"$f":"H9-G71","v":1027896.9473505142},{"$f":"H9-H71","v":1015633.1126797154},{"$f":"H9-I71","v":1002482.7244089571},{"$f":"H9-J71","v":988381.69350681477},{"$f":"H9-K71","v":973261.2979406002},{"$f":"H9-L71","v":957047.84775632585},{"$f":"H9-M71","v":939662.32594727166},{"$f":"H9-N71","v":921020.00336091314},{"$f":"H9-O71","v":901030.0257674387},{"$f":"H9-P71","v":879594.97107741761},{"$f":"H9-Q71","v":856610.37455069716},{"$f":"H9-R71","v":831964.21968261211},{"$f":"H9-S71","v":805536.39228631789},{"$f":"H9-T71","v":777198.09511069092},{"$f":"H9-U71","v":746811.22014090978},{"$f":"H9-V71","v":714227.67552259495},{"$f":"H9-W71","v":679288.66382923932},{"$f":"H9-X71","v":641823.90815553395},{"$f":"H9-Y71","v":601650.82226491743},{"$f":"H9-Z71","v":558573.62074702361},{"$f":"H9-AA71","v":512382.36484834098},{"$f":"H9-AB71","v":462851.93932589155},{"$f":"H9-AC71","v":409740.95533758041},{"$f":"H9-AD71","v":352790.57402240008},{"$f":"H9-AE71","v":291723.24503715185},{"$f":"H9-AF71","v":226241.35390188568},{"$f":"H9-AG71","v":156025.77156183193},{"$f":"H9-AH71","v":80734.299097048002},{"$f":"H9-AI71","v":0}]