{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["rentals","for sale","favorites","Rental P&L","Inputs","lists","Amortization Table","to-do","SC Home"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":8,"comments":0,"pivot_tables":2},"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":"rentals","index":0,"n_rows":245,"n_cols":23,"rows_kept":245,"cut":false,"hidden":false,"merged":[]}
[]
[null,"City","draper",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"List"]
[null,"Price Minimum",1200,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Any",0,{"$f":"VLOOKUP(C5,U3:V11,2,FALSE)","v":1}]
[null,"Price Maximum",2200,null,null,null,null,null,"don't tamper",null,null,"don't tamper","don't tamper",null,null,null,null,null,null,null,"Single-family home",1]
[null,"Property Type","Single-family home",null,null,null,null,null,"hide",null,null,"hide","hide",null,null,null,null,null,null,null,"Apartment",2]
[null,"Bedrooms (minimum)",3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Condo/Townhome",3]
[null,"Bathrooms (minimum)",1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mult-family home",4]
[null,"Year Built (minimum)",1995,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Manufactured home",5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Horse/Livestock",6]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Single Room",7]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sublease or Student Contract",8]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(F13=\"\",\"\",(RIGHT((LEFT(B13,(FIND(\"/\",B13,1)-1))),(LEN((LEFT(B13,(FIND(\"/\",B13,1)-1)))))-(FIND(\"$\",B13,1))))/(LEFT(F13,FIND(\" \",F13,1)-1)))","v":""},{"$f":"IF(K13=\"\",\"\",VALUE(((RIGHT((LEFT(B13,(FIND(\"/\",B13,1)-1))),(LEN((LEFT(B13,(FIND(\"/\",B13,1)-1)))))-(FIND(\"$\",B13,1)))))))","v":""},{"$f":"IF(K13=\"\",\"\",(MID(I13,FIND(\"?ad\",I13,1)+4,FIND(\"&amp\",I13,1)-FIND(\"?ad\",I13,1)-4)))","v":""}]
["Description & Link","Price per Month","Address","Bedrooms","Bathrooms","Square Feet","Year Built","Date Posted","Links","a","Rent Price / Sq. Foot","Price"]
["3 Bedrooms available !!\n","$1,275/mo.","13343 S Minuteman Dr","3 beds","2 baths","1,215 sq. ft.",1997,"Posted April 8, 2016 ",{"$f":"HYPERLINK(\"http://www.ksl.com:80/homes/listing/rentler?ad=r811878&amp;PropertyTypeCode=2\")","v":"http://www.ksl.com:80/homes/listing/rentler?ad=r811878&amp;PropertyTypeCode=2"},null,{"$f":"IF(F15=\"\",\"\",(RIGHT((LEFT(B15,(FIND(\"/\",B15,1)-1))),(LEN((LEFT(B15,(FIND(\"/\",B15,1)-1)))))-(FIND(\"$\",B15,1))))/(LEFT(F15,FIND(\" \",F15,1)-1)))","v":1.0493827160493827},{"$f":"IF(K15=\"\",\"\",VALUE(((RIGHT((LEFT(B15,(FIND(\"/\",B15,1)-1))),(LEN((LEFT(B15,(FIND(\"/\",B15,1)-1)))))-(FIND(\"$\",B15,1)))))))","v":1275},{"$f":"IF(K15=\"\",\"\",(MID(I15,FIND(\"?ad\",I15,1)+4,FIND(\"&amp\",I15,1)-FIND(\"?ad\",I15,1)-4)))","v":"r811878"},null,"Average of Price","Column Labels"]
["Beautiful 5BD 3BA Rambler in Draper 3000 SQ FT\n","$1,900/mo.","725 E Sunset Ponds Dr","5 beds","3 baths","3,000 sq. ft.",1998,"Posted April 10, 2016 ",{"$f":"HYPERLINK(\"http://www.ksl.com:80/homes/listing/rentler?ad=r79141&amp;PropertyTypeCode=1\")","v":"http://www.ksl.com:80/homes/listing/rentler?ad=r79141&amp;PropertyTypeCode=1"},null,{"$f":"IF(F16=\"\",\"\",(RIGHT((LEFT(B16,(FIND(\"/\",B16,1)-1))),(LEN((LEFT(B16,(FIND(\"/\",B16,1)-1)))))-(FIND(\"$\",B16,1))))/(LEFT(F16,FIND(\" \",F16,1)-1)))","v":0.6333333333333333},{"$f":"IF(K16=\"\",\"\",VALUE(((RIGHT((LEFT(B16,(FIND(\"/\",B16,1)-1))),(LEN((LEFT(B16,(FIND(\"/\",B16,1)-1)))))-(FIND(\"$\",B16,1)))))))","v":1900},{"$f":"IF(K16=\"\",\"\",(MID(I16,FIND(\"?ad\",I16,1)+4,FIND(\"&amp\",I16,1)-FIND(\"?ad\",I16,1)-4)))","v":"r79141"},null,"Row Labels","2 baths","2.5 baths","3 baths","4 baths","3.5 baths","Grand Total"]
["$1500 Includes HOA Furnished theater in basement\n","$1,600/mo.","13548 S Villa Rosa Way","3 beds","3.5 baths","2,000 sq. ft.",2003,"Posted April 8, 2016 ",{"$f":"HYPERLINK(\"http://www.ksl.com:80/homes/listing/rentler?ad=r28977&amp;PropertyTypeCode=3\")","v":"http://www.ksl.com:80/homes/listing/rentler?ad=r28977&amp;PropertyTypeCode=3"},null,0.8,1600,"r28977",null,"3 beds",1436.25,1722.5,1500,null,1650,1549]
["Beautiful 3 bed 3 bath townhouse\n","$1,500/mo.","623 E Autumn Branch Way","3 beds","3 baths","2,300 sq. ft.",2012,"Posted April 8, 2016 ",{"$f":"HYPERLINK(\"http://www.ksl.com:80/homes/listing/rentler?ad=r1314009&amp;PropertyTypeCode=3\")","v":"http://www.ksl.com:80/homes/listing/rentler?ad=r1314009&amp;PropertyTypeCode=3"},null,0.65217391304347827,1500,"r1314009",null,"4 beds",1600,2100,2000,1700,1800,1866.6666666666667]
["Beautiful Draper Rambler.  Great Views\n","$2,100/mo.","499 E Parowan Way","4 beds","3 baths","3,359 sq. ft.",1998,"Posted April 8, 2016 ",{"$f":"HYPERLINK(\"http://www.ksl.com:80/homes/listing/rentler?ad=r1712836&amp;PropertyTypeCode=1\")","v":"http://www.ksl.com:80/homes/listing/rentler?ad=r1712836&amp;PropertyTypeCode=1"},null,0.62518606728192916,2100,"r1712836",null,"5 beds",null,null,1947.5,null,null,1947.5]
["BEAUTIFUL DRAPER CONDO\n","$1,295/mo.","191 E Spencer Peak Way","3 beds","2 baths","1,250 sq. ft.",2006,"Posted April 5, 2016 ",{"$f":"HYPERLINK(\"http://www.ksl.com:80/homes/listing/rentler?ad=r14011&amp;PropertyTypeCode=3\")","v":"http://www.ksl.com:80/homes/listing/rentler?ad=r14011&amp;PropertyTypeCode=3"},null,1.036,1295,"r14011",null,"Grand Total",1469,1848.3333333333333,1815.8333333333333,1700,1700,1699.1666666666667]
["Spacious 3 Bd 2 Ba 1780 sq ft End Unit Townhome\n","$1,275/mo.","409 E Culross Ln","3 beds","2 baths","1,780 sq. ft.",2001,"Posted April 4, 2016 ",{"$f":"HYPERLINK(\"http://www.ksl.com:80/homes/listing/rentler?ad=r476585&amp;PropertyTypeCode=3\")","v":"http://www.ksl.com:80/homes/listing/rentler?ad=r476585&amp;PropertyTypeCode=3"},null,0.7162921348314607,1275,"r476585"]
["Beautiful Draper 3bed\n","$1,495/mo.","71 E Bella Monte Dr","3 beds","2.5 baths","1,700 sq. ft.",2007,"Posted April 3, 2016 ",{"$f":"HYPERLINK(\"http://www.ksl.com:80/homes/listing/rentler?ad=r1336745&amp;PropertyTypeCode=3\")","v":"http://www.ksl.com:80/homes/listing/rentler?ad=r1336745&amp;PropertyTypeCode=3"},null,0.87941176470588234,1495,"r1336745"]
["Spacious 5 Bedroom Draper Mountain House\n","$1,995/mo.","14024 S New Saddle Rd","5 beds","3 baths","3,073 sq. ft.",2003,"Posted April 1, 2016 ",{"$f":"HYPERLINK(\"http://www.ksl.com:80/homes/listing/rentler?ad=r1660104&amp;PropertyTypeCode=1\")","v":"http://www.ksl.com:80/homes/listing/rentler?ad=r1660104&amp;PropertyTypeCode=1"},null,0.64920273348519364,1995,"r1660104"]
["Townhome for rent in Draper\n","$1,500/mo.","14108 S Pepi Band Rd","3 beds","3 baths","1,742 sq. ft.",1997,"Posted March 31, 2016 ",{"$f":"HYPERLINK(\"http://www.ksl.com:80/homes/listing/rentler?ad=r1049561&amp;PropertyTypeCode=3\")","v":"http://www.ksl.com:80/homes/listing/rentler?ad=r1049561&amp;PropertyTypeCode=3"},null,0.86107921928817455,1500,"r1049561"]
["Great Deal -3000 SF walkout basement\n","$1,600/mo.","929 E Rocky Mouth Ln","4 beds","2 baths","3,000 sq. ft.",1997,"Posted March 30, 2016 ",{"$f":"HYPERLINK(\"http://www.ksl.com:80/homes/listing/rentler?ad=r478881&amp;PropertyTypeCode=1\")","v":"http://www.ksl.com:80/homes/listing/rentler?ad=r478881&amp;PropertyTypeCode=1"},null,0.53333333333333333,1600,"r478881"]
["3 bed2bath new\n","$1,900/mo.","497 W Sunland Dr","3 beds","2 baths","3,200 sq. ft.",2015,"Posted March 30, 2016 ",{"$f":"HYPERLINK(\"http://www.ksl.com:80/homes/listing/rentler?ad=r1433939&amp;PropertyTypeCode=7\")","v":"http://www.ksl.com:80/homes/listing/rentler?ad=r1433939&amp;PropertyTypeCode=7"},null,0.59375,1900,"r1433939"]
["Darling Draper Townhome for rent\n","$1,700/mo.","13585 S Luscerno Dr","4 beds","4 baths","1,815 sq. ft.",2009,"Posted March 25, 2016 ",{"$f":"HYPERLINK(\"http://www.ksl.com:80/homes/listing/rentler?ad=r1691947&amp;PropertyTypeCode=3\")","v":"http://www.ksl.com:80/homes/listing/rentler?ad=r1691947&amp;PropertyTypeCode=3"},null,0.9366391184573003,1700,"r1691947"]
["Draper 4 Bed w/ Landscaping! Hardwood! Fireplace!\n","$1,900/mo.","513 East Steep Mountain Drive","4 beds","3 baths","2,800 sq. ft.",2005,"Posted March 24, 2016 ",{"$f":"HYPERLINK(\"http://www.ksl.com:80/homes/listing/rentler?ad=r105194&amp;PropertyTypeCode=1\")","v":"http://www.ksl.com:80/homes/listing/rentler?ad=r105194&amp;PropertyTypeCode=1"},null,0.6785714285714286,1900,"r105194"]
["DRAPER BEST LOCATION NEW PAINT/CARPET\n","$1,800/mo.","235 E Rawlins Ln","4 beds","3.5 baths","2,100 sq. ft.",1996,"Posted March 23, 2016 ",{"$f":"HYPERLINK(\"http://www.ksl.com:80/homes/listing/rentler?ad=r1681960&amp;PropertyTypeCode=1\")","v":"http://www.ksl.com:80/homes/listing/rentler?ad=r1681960&amp;PropertyTypeCode=1"},null,0.8571428571428571,1800,"r1681960"]
["3 bed $1700\n","$1,700/mo.","13460 S 1300 E","3 beds","3.5 baths","2,150 sq. ft.",2014,"Posted March 19, 2016 ",{"$f":"HYPERLINK(\"http://www.ksl.com:80/homes/listing/rentler?ad=r1052993&amp;PropertyTypeCode=1\")","v":"http://www.ksl.com:80/homes/listing/rentler?ad=r1052993&amp;PropertyTypeCode=1"},null,0.79069767441860461,1700,"r1052993"]
["Draper Condo\n","$1,950/mo.","615 E Harvest Bend Way","3 beds","2.5 baths","2,300 sq. ft.",2010,"Posted March 16, 2016 ",{"$f":"HYPERLINK(\"http://www.ksl.com:80/homes/listing/rentler?ad=r1661864&amp;PropertyTypeCode=3\")","v":"http://www.ksl.com:80/homes/listing/rentler?ad=r1661864&amp;PropertyTypeCode=3"},null,0.84782608695652173,1950,"r1661864"]
["3100 Sqft Beautiful CuldeSac Home\n","$2,100/mo.","12542 S Stonebridge Cir","4 beds","2.5 baths","3,100 sq. ft.",1997,"Posted March 14, 2016 ",{"$f":"HYPERLINK(\"http://www.ksl.com:80/homes/listing/rentler?ad=r13129&amp;PropertyTypeCode=1\")","v":"http://www.ksl.com:80/homes/listing/rentler?ad=r13129&amp;PropertyTypeCode=1"},null,0.67741935483870963,2100,"r13129"]
[null,null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(F80=\"\",\"\",(RIGHT((LEFT(B80,(FIND(\"/\",B80,1)-1))),(LEN((LEFT(B80,(FIND(\"/\",B80,1)-1)))))-(FIND(\"$\",B80,1))))/(LEFT(F80,FIND(\" \",F80,1)-1)))","v":""},{"$f":"IF(K80=\"\",\"\",VALUE(((RIGHT((LEFT(B80,(FIND(\"/\",B80,1)-1))),(LEN((LEFT(B80,(FIND(\"/\",B80,1)-1)))))-(FIND(\"$\",B80,1)))))))","v":""},{"$f":"IF(K80=\"\",\"\",(MID(I80,FIND(\"?ad\",I80,1)+4,FIND(\"&amp\",I80,1)-FIND(\"?ad\",I80,1)-4)))","v":""}]
[null,null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(F144=\"\",\"\",(RIGHT((LEFT(B144,(FIND(\"/\",B144,1)-1))),(LEN((LEFT(B144,(FIND(\"/\",B144,1)-1)))))-(FIND(\"$\",B144,1))))/(LEFT(F144,FIND(\" \",F144,1)-1)))","v":""},{"$f":"IF(K144=\"\",\"\",VALUE(((RIGHT((LEFT(B144,(FIND(\"/\",B144,1)-1))),(LEN((LEFT(B144,(FIND(\"/\",B144,1)-1)))))-(FIND(\"$\",B144,1)))))))","v":""},{"$f":"IF(K144=\"\",\"\",(MID(I144,FIND(\"?ad\",I144,1)+4,FIND(\"&amp\",I144,1)-FIND(\"?ad\",I144,1)-4)))","v":""}]
[null,null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(K167=\"\",\"\",VALUE(((RIGHT((LEFT(B167,(FIND(\"/\",B167,1)-1))),(LEN((LEFT(B167,(FIND(\"/\",B167,1)-1)))))-(FIND(\"$\",B167,1)))))))","v":""},{"$f":"IF(K167=\"\",\"\",(MID(I167,FIND(\"?ad\",I167,1)+4,FIND(\"&amp\",I167,1)-FIND(\"?ad\",I167,1)-4)))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(K208=\"\",\"\",VALUE(((RIGHT((LEFT(B208,(FIND(\"/\",B208,1)-1))),(LEN((LEFT(B208,(FIND(\"/\",B208,1)-1)))))-(FIND(\"$\",B208,1)))))))","v":""},{"$f":"IF(K208=\"\",\"\",(MID(I208,FIND(\"?ad\",I208,1)+4,FIND(\"&amp\",I208,1)-FIND(\"?ad\",I208,1)-4)))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,"",""]

{"sheet":"for sale","index":1,"n_rows":152,"n_cols":18,"rows_kept":152,"cut":false,"hidden":false,"merged":[]}
[]
[null,"City","draper"]
[null,"Price Minimum",175000]
[null,"Price Maximum",350000]
[null,"Bedrooms (minimum)",2]
[null,"Bathrooms (minimum)",1]
[null,"Year Built (minimum)",1995,null,null,null,null,null,null,"don't tamper"]
[null,"Square footage (minimum)",1000,null,null,null,null,null,null,"will hide"]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,{"$f":"IF(G13=\"\",\"\",B13/(LEFT(G13,4)))","v":""}]
["Description & Link","Price","Bedrooms","Bathrooms","Square Feet","Year Built","Days Online","a","Price / Sq. Foot",null,null,"Average of Price","Column Labels"]
["\t\t\t\t\t\t15063 S Junction Circle  Draper, UT 84020\t\t\t\t\t",325000,"4 beds","3 baths","2745 sq. ft.",1998,"0 days",null,{"$f":"IF(G15=\"\",\"\",B15/(LEFT(E15,4)))","v":118.39708561020036},40016152,null,"Row Labels","2 baths","2.5 baths","3 baths","3.5 baths","4 baths","Grand Total"]
["\t\t\t\t\t\t14254 S Daisyfield Dr  Draper, UT 84020\t\t\t\t\t",186500,"3 beds","2.5 baths","1308 sq. ft.",2000,"0 days",null,{"$f":"IF(G16=\"\",\"\",B16/(LEFT(E16,4)))","v":142.58409785932722},40016121,null,"2 beds",284900,205959.8,199900,null,null,216371.28571428571]
["\t\t\t\t\t\t1839 E Longbranch Dr S  Draper, UT 84020\t\t\t\t\t",339900,"6 beds","4 baths","2761 sq. ft.",2005,"1 days",null,123.10756972111554,40005717,null,"3 beds",250912.26666666666,252880.35714285713,269200,236633.33333333334,null,252519.69444444444]
["\t\t\t\t\t\t14278 S Draper Hill Dr  Draper, UT 84020\t\t\t\t\t",260000,"3 beds","2.5 baths","2308 sq. ft.",2014,"2 days",null,112.65164644714038,40015576,null,"4 beds",289000,null,313224.28571428574,null,null,310196.25]
["\t\t\t\t\t\t438 W Long Creek Ln  Draper, UT 84020\t\t\t\t\t",287900,"3 beds","3 baths","2077 sq. ft.",2012,"2 days",null,138.61338468945596,40015571,null,"5 beds",null,null,null,329900,null,329900]
["\t\t\t\t\t\t604 E Rocky Mouth Ln  Draper, UT 84020\t\t\t\t\t",330000,"3 beds","2.5 baths","2365 sq. ft.",1999,"2 days",null,139.53488372093022,40015451,null,"6 beds",null,null,327450,null,339900,331600]
["\t\t\t\t\t\t693 Buckie Ct  Draper, UT 84020\t\t\t\t\t",296170,"3 beds","2.5 baths","1690 sq. ft.",2016,"3 days",null,175.24852071005918,40015224,null,"Grand Total",255152,240532.84210526315,294583.57142857142,273940,339900,263240.67857142858]
["\t\t\t\t\t\t12215 South 670 East  Draper, UT 84020\t\t\t\t\t",185900,"3 beds","2 baths","1150 sq. ft.",2011,"3 days",null,161.65217391304347,40014978]
["\t\t\t\t\t\t238 W BEVERLEE ANN DR  Draper, UT 84020\t\t\t\t\t",289900,"4 beds","3 baths","2354 sq. ft.",2001,"5 days",null,123.15208156329652,40014439]
["\t\t\t\t\t\t238 W Beverlee Ann Dr  Draper, UT 84020\t\t\t\t\t",289900,"4 beds","3 baths","2354 sq. ft.",2001,"5 days",null,123.15208156329652,40014426]
["\t\t\t\t\t\t264 W 13165 S  Draper, UT 84020\t\t\t\t\t",240000,"3 beds","2 baths","2041 sq. ft.",2002,"5 days",null,117.58941695247428,40008294]
["\t\t\t\t\t\t11989 S Draperville Ave  Draper, UT 84020\t\t\t\t\t",199900,"2 beds","3 baths","1391 sq. ft.",1998,"5 days",null,143.70956146657082,40014169]
["\t\t\t\t\t\t640 E NORMANDY LOOP LN  Draper, UT 84020\t\t\t\t\t",284900,"2 beds","2 baths","2684 sq. ft.",2006,"6 days",null,106.14754098360656,40013722]
["\t\t\t\t\t\t611 E Autumn Branch Way S  Draper, UT 84020\t\t\t\t\t",260000,"3 beds","3 baths","2213 sq. ft.",2012,"8 days",null,117.48757342973339,40013299]
["\t\t\t\t\t\t14293 S Honeyfield Dr  Draper, UT 84020\t\t\t\t\t",289000,"4 beds","2 baths","1886 sq. ft.",1999,"9 days",null,153.23435843054082,40012911]
["\t\t\t\t\t\t56 E Saddle Villa Dr # 40  Draper, UT 84020\t\t\t\t\t",199900,"3 beds","2 baths","1270 sq. ft.",2009,"11 days",null,157.4015748031496,40012317]
["\t\t\t\t\t\t240 West Inauguration Road Suite 600 Draper, UT 84020\t\t\t\t\t",279000,"3 beds","2.5 baths","1956 sq. ft.",1996,"13 days",null,142.63803680981596,40011333]
["\t\t\t\t\t\tNO MONEY DOWN PROGRAMS AVAILABLE!! 264 13165 Draper, UT 84020\t\t\t\t\t",240000,"3 beds","2 baths","2041 sq. ft.",2002,"14 days",null,117.58941695247428,40010913]
["\t\t\t\t\t\t264 W 13165 S  Draper, UT 84020\t\t\t\t\t",240000,"3 beds","2 baths","2041 sq. ft.",2002,"15 days",null,117.58941695247428,40010771]
["\t\t\t\t\t\t643 E Wyngate Pointe Ln  Draper, UT 84020\t\t\t\t\t",269900,"3 beds","2.5 baths","2431 sq. ft.",2006,"16 days",null,111.02426984779926,40010697]
["\t\t\t\t\t\t264 W 13165 S  Draper, UT 84020\t\t\t\t\t",240000,"3 beds","2 baths","2041 sq. ft.",2002,"16 days",null,117.58941695247428,40010413]
["\t\t\t\t\t\t264 W 13165 S  Draper, UT 84020\t\t\t\t\t",240000,"3 beds","2 baths","2041 sq. ft.",2002,"18 days",null,117.58941695247428,40009791]
["\t\t\t\t\t\t264 W 13165 S  Draper, UT 84020\t\t\t\t\t",240000,"3 beds","2 baths","2041 sq. ft.",2002,"18 days",null,117.58941695247428,40009655]
["\t\t\t\t\t\t264 W 13165 S  Draper, UT 84020\t\t\t\t\t",240000,"3 beds","2 baths","1609 sq. ft.",2002,"19 days",null,149.16096954630206,40009404]
["\t\t\t\t\t\t264 W 13165 S  Draper, UT 84020\t\t\t\t\t",240000,"3 beds","2 baths","2041 sq. ft.",2002,"19 days",null,117.58941695247428,40009342]
["\t\t\t\t\t\t14788 S Dryburg Cv  Draper, UT 84020\t\t\t\t\t",240000,"3 beds","3.5 baths","2088 sq. ft.",2006,"19 days",null,114.94252873563218,40009254]
["\t\t\t\t\t\t264 W 13165 S  Draper, UT 84020\t\t\t\t\t",240000,"3 beds","2 baths","2041 sq. ft.",2002,"19 days",null,117.58941695247428,40009166]
["\t\t\t\t\t\t2156 E Whitekirk Way  Draper, UT 84020\t\t\t\t\t",235000,"3 beds","3.5 baths","2002 sq. ft.",2006,"23 days",null,117.38261738261738,40008096]
["\t\t\t\t\t\t907 E Rosebud Ct  Draper, UT 84020\t\t\t\t\t",329900,"5 beds","3.5 baths","3461 sq. ft.",2002,"25 days",null,95.319271886737937,40007428]
["\t\t\t\t\t\t14276 S Draper Hill Dr  Draper, UT 84020\t\t\t\t\t",259900,"3 beds","2.5 baths","2308 sq. ft.",2014,"25 days",null,112.60831889081456,40007310]
["\t\t\t\t\t\t87 E Bridle Villa Dr  Draper, UT 84020\t\t\t\t\t",215000,"2 beds","2.5 baths","1405 sq. ft.",2009,"26 days",null,153.02491103202846,40007062]
["\t\t\t\t\t\t907 E Rosebud Ct  Draper, UT 84020\t\t\t\t\t",329900,"5 beds","3.5 baths","3461 sq. ft.",2002,"26 days",null,95.319271886737937,40006853]
["\t\t\t\t\t\t1956 E Brookings Dr  Draper, UT 84020\t\t\t\t\t",350000,"4 beds","3 baths","3632 sq. ft.",2010,"27 days",null,96.365638766519822,40006583]
["\t\t\t\t\t\t71 E Bridle Villa Dr  Draper, UT 84020\t\t\t\t\t",211900,"2 beds","2.5 baths","1420 sq. ft.",2008,"29 days",null,149.22535211267606,38378609]
["\t\t\t\t\t\t549 E Braidhill Dr  Draper, UT 84020\t\t\t\t\t",189999,"2 beds","2.5 baths","1600 sq. ft.",2003,"30 days",null,118.749375,40005326]
["\t\t\t\t\t\t14301 S Draper Hill Dr  Draper, UT 84020\t\t\t\t\t",259900,"3 beds","2.5 baths","2308 sq. ft.",2014,"34 days",null,112.60831889081456,40003946]
["\t\t\t\t\t\t743 E Sunset Ponds Dr  Draper, UT 84020\t\t\t\t\t",299900,"4 beds","3 baths","2558 sq. ft.",1998,"34 days",null,117.24003127443315,35832548]
["\t\t\t\t\t\tUnder contract  Draper, UT 84020\t\t\t\t\t",266900,"3 beds","2.5 baths","2237 sq. ft.",2011,"36 days",null,119.31157800625839,40003224]
["\t\t\t\t\t\t12173 S Fox Chase Dr  Draper, UT 84020\t\t\t\t\t",240940,"3 beds","2.5 baths","2202 sq. ft.",2016,"39 days",null,109.41871026339692,38308173]
["\t\t\t\t\t\t12216 S Pixie Dr  Draper, UT 84020\t\t\t\t\t",244615,"3 beds","2.5 baths","2202 sq. ft.",2015,"39 days",null,111.08764759309719,38468516]
["\t\t\t\t\t\t1952 E Brookings Dr  Draper, UT 84020\t\t\t\t\t",344900,"6 beds","3 baths","3190 sq. ft.",2006,"47 days",null,108.11912225705329,38622682]
["\t\t\t\t\t\t248 East 13800 South Unit # 23 Draper, UT 84020\t\t\t\t\t",229900,"2 beds","2.5 baths","1777 sq. ft.",2012,"50 days",null,129.37535171637592,38586798]
["\t\t\t\t\t\t14981 S Eagle Crest Dr  Draper, UT 84020\t\t\t\t\t",330000,"3 beds","2 baths","3119 sq. ft.",2006,"59 days",null,105.80314203270279,38472181]
["\t\t\t\t\t\t11717 S Shadow View Ln  Draper, UT 84020\t\t\t\t\t",259900,"3 beds","3 baths","2270 sq. ft.",2010,"65 days",null,114.49339207048457,36225571]
["\t\t\t\t\t\t1755 E Lone Oak Dr  Draper, UT 84020\t\t\t\t\t",307970,"4 beds","3 baths","2966 sq. ft.",2001,"68 days",null,103.8334457181389,38368410]
["\t\t\t\t\t\t407 E Culross Ln  Draper, UT 84020\t\t\t\t\t",188400,"3 beds","2.5 baths","1780 sq. ft.",2001,"68 days",null,105.84269662921348,38367601]
["\t\t\t\t\t\t525 W Sunpark Ln  Draper, UT 84020\t\t\t\t\t",277985,"3 beds","2 baths","3276 sq. ft.",2016,"73 days",null,84.855006105006112,38308746]
["\t\t\t\t\t\t955 E Senior Band Rd  Draper, UT 84020\t\t\t\t\t",234900,"3 beds","3.5 baths","2150 sq. ft.",1999,"79 days",null,109.25581395348837,38238358]
["\t\t\t\t\t\t2014 E Brookings Dr  Draper, UT 84020\t\t\t\t\t",299900,"3 beds","2 baths","3098 sq. ft.",2006,"82 days",null,96.804389928986438,38197508]
["\t\t\t\t\t\t14782 S DEER PARK LN  Draper, UT 84020\t\t\t\t\t",178200,"3 beds","2.5 baths","2204 sq. ft.",2009,"91 days",null,80.852994555353902,38084870]
["\t\t\t\t\t\t15151 S Walnut Grove Dr  Draper, UT 84020\t\t\t\t\t",269000,"3 beds","3 baths","2074 sq. ft.",2001,"94 days",null,129.70106075216972,38051754]
["\t\t\t\t\t\t14209  Draper, UT 84020\t\t\t\t\t",310000,"6 beds","3 baths","3048 sq. ft.",1996,"124 days",null,101.70603674540682,35034271]
["\t\t\t\t\t\t14152 S Radial Ln  Draper, UT 84020\t\t\t\t\t",309999,"3 beds","2 baths","3023 sq. ft.",1996,"138 days",null,102.54680780681443,37499999]
["\t\t\t\t\t\t743 E Sunset Ponds Dr  Draper, UT 84020\t\t\t\t\t",329900,"4 beds","3 baths","2558 sq. ft.",1998,"139 days",null,128.96794370602032,34804667]
["\t\t\t\t\t\t182 E Rideout Hall Ln  Draper, UT 84020\t\t\t\t\t",183000,"2 beds","2.5 baths","1124 sq. ft.",1999,"141 days",null,162.81138790035587,37455348]
["\t\t\t\t\t\t15159 S Eagle Chase Dr  Draper, UT 84020\t\t\t\t\t",279900,"3 beds","2.5 baths","2748 sq. ft.",2006,"180 days",null,101.85589519650655,36941557]
[null,null,null,null,null,null,null,null,"",38223756]
[null,null,null,null,null,null,null,null,"",38223153]
[null,null,null,null,null,null,null,null,"",38199337]
[null,null,null,null,null,null,null,null,"",38137722]
[null,null,null,null,null,null,null,null,"",38068991]
[null,null,null,null,null,null,null,null,"",38058658]
[null,null,null,null,null,null,null,null,"",38030631]
[null,null,null,null,null,null,null,null,"",37919441]
[null,null,null,null,null,null,null,null,"",37765844]
[null,null,null,null,null,null,null,null,{"$f":"IF(G80=\"\",\"\",B80/(LEFT(E80,4)))","v":""},37726054]
[null,null,null,null,null,null,null,null,"",37694859]
[null,null,null,null,null,null,null,null,"",37498004]
[null,null,null,null,null,null,null,null,"",37040344]
[null,null,null,null,null,null,null,null,"",37218792]
[null,null,null,null,null,null,null,null,"",37181240]
[null,null,null,null,null,null,null,null,"",37051428]
[null,null,null,null,null,null,null,null,"",36853313]
[null,null,null,null,null,null,null,null,"",36820710]
[null,null,null,null,null,null,null,null,"",36780384]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(G144=\"\",\"\",B144/(LEFT(E144,4)))","v":""}]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]

{"sheet":"favorites","index":2,"n_rows":2,"n_cols":7,"rows_kept":2,"cut":false,"hidden":true,"merged":[]}
[]
["\t\t\t\t\t\t154 E CRESCENT PINE LN  Sandy, UT 84070\t\t\t\t\t",319900,"4 beds","3 baths","2407 sq. ft.",2011,"7 days"]

{"sheet":"Rental P&L","index":3,"n_rows":34,"n_cols":15,"rows_kept":34,"cut":false,"hidden":false,"merged":[[23,14,24,15],[0,11,0,13],[25,12,25,13],[0,1,0,9],[26,12,26,13],[27,12,28,13],[1,11,2,13],[16,11,17,13],[19,11,20,12],[7,11,8,12],[23,11,23,13],[27,11,28,11]]}
[null,"Rental P&L",null,null,null,null,null,null,null,null,null,"Ratios"]
[null,null,null,null,null,null,null,null,null,null,null,"First-Year Investment Measures"]
[]
[null,null,null,"Year 0","Year 1","Year 2","Year 3","Year 4","Year 5",null,null,"Payback Period",null,{"$f":"ROUND((ABS(D34)/E34),1)&\" years\"","v":"-35.4 years"}]
[null,null,"+ Potential Gross Income",null,{"$f":"Inputs!$E$13*12","v":18000},{"$f":"(E5)*(1+Inputs!$E$28)","v":18180},{"$f":"(F5)*(1+Inputs!$E$28)","v":18361.8},{"$f":"(G5)*(1+Inputs!$E$28)","v":18545.417999999998},{"$f":"(H5)*(1+Inputs!$E$28)","v":18730.872179999998},null,null,"Profit Margin",null,{"$f":"E34/E9","v":-2.9917115619664161E-2}]
[null,null,"- Vacancy & Collections Loss",null,{"$f":"(Inputs!$E$15/52)*E5","v":1384.6153846153848},{"$f":"(Inputs!$E$15/52)*F5","v":1398.4615384615386},{"$f":"(Inputs!$E$15/52)*G5","v":1412.4461538461539},{"$f":"(Inputs!$E$15/52)*H5","v":1426.5706153846154},{"$f":"(Inputs!$E$15/52)*I5","v":1440.8363215384616},null,null,"Default Ratio",null,{"$f":"(E17+E22)/E9","v":0.98692353209980743}]
[null,null,"+ Other Income",null,{"$f":"Inputs!$E$14","v":0},{"$f":"Inputs!$E$14","v":0},{"$f":"Inputs!$E$14","v":0},{"$f":"Inputs!$E$14","v":0},{"$f":"Inputs!$E$14","v":0},null,null,"Operating Expense Ratio",null,{"$f":"E17/E9","v":0.26629166666666665}]
[null,null,null,null,null,null,null,null,null,null,null,"Debt-Coverage Ratio"]
[null,null,"= Effective Gross Income",null,{"$f":"E5-E6+E7","v":16615.384615384617},{"$f":"F5-F6+F7","v":16781.538461538461},{"$f":"G5-G6+G7","v":16949.353846153845},{"$f":"H5-H6+H7","v":17118.847384615383},{"$f":"I5-I6+I7","v":17290.035858461539},null,null,null,null,{"$f":"E19/E22","v":1.0181458363520088}]
[]
[null,null,"Operating Expenses",null,null,null,null,null,null,null,null,"Loan-to-Value Ratio",null,{"$f":"(Inputs!E4-Inputs!E7-(Inputs!E4*Inputs!E5))/Inputs!E4","v":0.94999986363636368}]
[null,null,"-   Property Taxes",null,{"$f":"Inputs!$E$17","v":1000},{"$f":"E12*(1+Inputs!$E$29)","v":1010},{"$f":"F12*(1+Inputs!$E$29)","v":1020.1},{"$f":"G12*(1+Inputs!$E$29)","v":1030.3009999999999},{"$f":"H12*(1+Inputs!$E$29)","v":1040.60401},null,null,"EGI Multiplier",null,{"$f":"Inputs!E4/E9","v":13.240740740740739}]
[null,null,"-   Landlord Insurance",null,{"$f":"Inputs!$E$18","v":963},{"$f":"E13*(1+Inputs!$E$29)","v":972.63},{"$f":"F13*(1+Inputs!$E$29)","v":982.35630000000003},{"$f":"G13*(1+Inputs!$E$29)","v":992.17986300000007},{"$f":"H13*(1+Inputs!$E$29)","v":1002.1016616300001},null,null,"CAP Rate",null,{"$f":"E19/Inputs!E4","v":5.5412937062937075E-2}]
[null,null,"-   Property Management Fee",null,{"$f":"Inputs!$E$16*E9","v":1661.5384615384619},{"$f":"Inputs!$E$16*F9","v":1678.1538461538462},{"$f":"Inputs!$E$16*G9","v":1694.9353846153845},{"$f":"Inputs!$E$16*H9","v":1711.8847384615383},{"$f":"Inputs!$E$16*I9","v":1729.003585846154},null,null,"BTCF Return",null,{"$f":"-E24/D31","v":-0.10431385198707961}]
[null,null,"-   HOA Association Fees",null,{"$f":"Inputs!$E$19*12","v":600},{"$f":"E15*(1+Inputs!$E$29)","v":606},{"$f":"F15*(1+Inputs!$E$29)","v":612.06000000000006},{"$f":"G15*(1+Inputs!$E$29)","v":618.18060000000003},{"$f":"H15*(1+Inputs!$E$29)","v":624.36240600000008},null,null,"ATCF Return",null,{"$f":"-E29/D31","v":-2.8243430829752884E-2}]
[null,null,"-   Maintenance & Repairs",null,{"$f":"Inputs!$E$20","v":200},{"$f":"E16*(1+Inputs!$E$29)","v":202},{"$f":"F16*(1+Inputs!$E$29)","v":204.02},{"$f":"G16*(1+Inputs!$E$29)","v":206.06020000000001},{"$f":"H16*(1+Inputs!$E$29)","v":208.120802}]
[null,null,"Total Operating Expenses",null,{"$f":"SUM(E12:E16)","v":4424.5384615384619},{"$f":"SUM(F12:F16)","v":4468.7838461538468},{"$f":"SUM(G12:G16)","v":4513.4716846153851},{"$f":"SUM(H12:H16)","v":4558.6064014615376},{"$f":"SUM(I12:I16)","v":4604.1924654761542},null,null,"Holding Period Measures"]
[]
[null,null," = Net Operating Income",null,{"$f":"E9-E17","v":12190.846153846156},{"$f":"F9-F17","v":12312.754615384614},{"$f":"G9-G17","v":12435.882161538459},{"$f":"H9-H17","v":12560.240983153846},{"$f":"I9-I17","v":12685.843392985385},null,null,"NPV",null,{"$f":"NPV(Inputs!E24,E34:I34)+D34","v":509.60506814459222}]
[null,null,null,null,null,null,null,null,null,null,null,"IRR"]
[null,null,"- Private Mortgage Insurance",null,{"$f":"Inputs!$E$6*('Amortization Table'!$C$3-VLOOKUP(E$4,'Amortization Table'!$J:$N,5,FALSE))","v":2053.1943385450322},{"$f":"Inputs!$E$6*('Amortization Table'!$C$3-VLOOKUP(F$4,'Amortization Table'!$J:$N,5,FALSE))","v":2014.8891576542053},{"$f":"Inputs!$E$6*('Amortization Table'!$C$3-VLOOKUP(G$4,'Amortization Table'!$J:$N,5,FALSE))","v":1975.0233645920646},{"$f":"Inputs!$E$6*('Amortization Table'!$C$3-VLOOKUP(H$4,'Amortization Table'!$J:$N,5,FALSE))","v":1933.5333776108509},{"$f":"Inputs!$E$6*('Amortization Table'!$C$3-VLOOKUP(I$4,'Amortization Table'!$J:$N,5,FALSE))","v":1890.3530245443012},null,null,null,null,{"$f":"IFERROR(IRR(D34:I34),\"n/a\")","v":8.5942854328847407E-2}]
[null,null,"- Annual Debt Service",null,{"$f":"VLOOKUP(E$4,'Amortization Table'!$J:$M,4,FALSE)","v":11973.575610273725},{"$f":"VLOOKUP(F$4,'Amortization Table'!$J:$M,4,FALSE)","v":11973.575610273723},{"$f":"VLOOKUP(G$4,'Amortization Table'!$J:$M,4,FALSE)","v":11973.575610273723},{"$f":"VLOOKUP(H$4,'Amortization Table'!$J:$M,4,FALSE)","v":11973.575610273725},{"$f":"VLOOKUP(I$4,'Amortization Table'!$J:$M,4,FALSE)","v":11973.575610273723}]
[]
[null,null,"= Before Tax Cash Flow",null,{"$f":"E19-E21-E22","v":-1835.9237949726012},{"$f":"F19-F21-F22","v":-1675.7101525433136},{"$f":"G19-G21-G22","v":-1512.7168133273299},{"$f":"H19-H21-H22","v":-1346.8680047307298},{"$f":"I19-I21-I22","v":-1178.0852418326394},null,null,"Partitioning the IRR",null,null,"% of total PV"]
[]
[null,null,"- Taxes Due",null,{"$f":"IF(Inputs!J7<0,0,Inputs!J7*Inputs!$E$23)","v":0},{"$f":"IF(Inputs!K7<0,0,Inputs!K7*Inputs!$E$23)","v":0},{"$f":"IF(Inputs!L7<0,0,Inputs!L7*Inputs!$E$23)","v":0},{"$f":"IF(Inputs!M7<0,0,Inputs!M7*Inputs!$E$23)","v":0},{"$f":"IF(Inputs!N7<0,0,Inputs!N7*Inputs!$E$23)","v":0},null,null,"Operating Cash Flow",{"$f":"NPV(N21,E29:I29)","v":-1353.6483086217268},null,{"$f":"M26/M28","v":-7.6911835717074772E-2}]
[null,null,"+ Tax Savings from Passive Activity Loss",null,{"$f":"IF(Inputs!J7<0,-Inputs!J7*Inputs!$E$23,0)","v":1338.8394123689504},{"$f":"IF(Inputs!K7<0,-Inputs!K7*Inputs!$E$23,0)","v":1261.298015865158},{"$f":"IF(Inputs!L7<0,-Inputs!L7*Inputs!$E$23,0)","v":1181.5343767783138},{"$f":"IF(Inputs!M7<0,-Inputs!M7*Inputs!$E$23,0)","v":1099.4673266523473},{"$f":"IF(Inputs!N7<0,-Inputs!N7*Inputs!$E$23,0)","v":1015.0124837944095},null,null,"Sale of Property",{"$f":"NPV(N21,E32:I32)","v":18953.648308637468},null,{"$f":"M27/M28","v":1.0769118357170748}]
[null,null,null,null,null,null,null,null,null,null,null,"Total Present Value",{"$f":"SUM(M26:M27)","v":17600.000000015742}]
[null,null,"= After Tax Cash Flow from Operations",null,{"$f":"E24-E26+E27","v":-497.08438260365074},{"$f":"F24-F26+F27","v":-414.41213667815555},{"$f":"G24-G26+G27","v":-331.18243654901607},{"$f":"H24-H26+H27","v":-247.4006780783825},{"$f":"I24-I26+I27","v":-163.07275803822995}]
[]
[null,null,"- Initial Equity Investment",{"$f":"-(Inputs!E4*Inputs!E5)-(Inputs!E7*Inputs!E4)","v":-17600},0,0,0,0,0]
[null,null,"+ After Tax Cash on Sale (Reversion)",null,0,0,0,0,{"$f":"Inputs!E59","v":28623.825626977887}]
[]
[null,null,"= Total After Tax Cash Flow",{"$f":"SUM(D29:D31)","v":-17600},{"$f":"SUM(E29:E32)","v":-497.08438260365074},{"$f":"SUM(F29:F32)","v":-414.41213667815555},{"$f":"SUM(G29:G32)","v":-331.18243654901607},{"$f":"SUM(H29:H32)","v":-247.4006780783825},{"$f":"SUM(I29:I32)","v":28460.752868939657}]

{"sheet":"Inputs","index":4,"n_rows":59,"n_cols":16,"rows_kept":59,"cut":false,"hidden":true,"merged":[[37,3,37,4],[2,3,2,4],[11,3,11,4],[21,3,21,4],[26,3,26,4],[30,3,30,4]]}
[]
[]
[null,null,null,"Home Purchase Assumptions"]
[null,null,null,"Buying Price:",220000]
[null,null,null,"Down Payment:",0.05,null,null,"Less Annual Depreciation",null,{"$f":"((1-$E$8)*$E$4)/27.5","v":7200},{"$f":"((1-$E$8)*$E$4)/27.5","v":7200},{"$f":"((1-$E$8)*$E$4)/27.5","v":7200},{"$f":"((1-$E$8)*$E$4)/27.5","v":7200},{"$f":"((1-$E$8)*$E$4)/27.5","v":7200}]
[null,null,null,"PMI (estimate):",0.01,null,null,"Plus Annual Principal Paid",null,{"$f":"-CUMPRINC($E$9/12,$E$10*12,$E$4*(1-$E$5),(12*RIGHT('Rental P&L'!D4,1))+1,(12*RIGHT('Rental P&L'!E4,1)),0)","v":3680.5661454967994},{"$f":"-CUMPRINC($E$9/12,$E$10*12,$E$4*(1-$E$5),(12*RIGHT('Rental P&L'!E4,1))+1,(12*RIGHT('Rental P&L'!F4,1)),0)","v":3830.5180890826814},{"$f":"-CUMPRINC($E$9/12,$E$10*12,$E$4*(1-$E$5),(12*RIGHT('Rental P&L'!F4,1))+1,(12*RIGHT('Rental P&L'!G4,1)),0)","v":3986.5793062140747},{"$f":"-CUMPRINC($E$9/12,$E$10*12,$E$4*(1-$E$5),(12*RIGHT('Rental P&L'!G4,1))+1,(12*RIGHT('Rental P&L'!H4,1)),0)","v":4148.9986981213406},{"$f":"-CUMPRINC($E$9/12,$E$10*12,$E$4*(1-$E$5),(12*RIGHT('Rental P&L'!H4,1))+1,(12*RIGHT('Rental P&L'!I4,1)),0)","v":4318.0353066550015}]
[null,null,null,"Buyer Closing Costs:",0.03,null,null,"Taxable Income/ (Loss)",null,{"$f":"'Rental P&L'!E24-J5+J6","v":-5355.3576494758017},{"$f":"'Rental P&L'!F24-K5+K6","v":-5045.1920634606322},{"$f":"'Rental P&L'!G24-L5+L6","v":-4726.1375071132552},{"$f":"'Rental P&L'!H24-M5+M6","v":-4397.8693066093892},{"$f":"'Rental P&L'!I24-N5+N6","v":-4060.049935177638}]
[null,null,null,"Land Allocation:",0.1]
[null,null,null,"Mortgage Interest Rate:",0.04,null,null,null,null,null,null,null,null,null,null,{"$f":"CUMPRINC(E9/12,E10*12,E4,1/1/2000,12/31/2004,0)","v":{"$error":"#NUM!"}}]
[null,null,null,"# Years Loan:",30]
[]
[null,null,null,"Rental Assumptions"]
[null,null,null,"Rental Price (per month):",1500]
[null,null,null,"Other Income (per month):",0]
[null,null,null,"Vacancy (# of weeks out of the year):",4]
[null,null,null,"Property management fees (%):",0.1]
[null,null,null,"Property Taxes (annual):",1000]
[null,null,null,"Landlord insurance (annual):",963]
[null,null,null,"HOA fees (monthly):",50]
[null,null,null,"Repairs/maintenance (annual):",200]
[]
[null,null,null,"Investor Assumptions"]
[null,null,null,"Marginal Tax Rate:",0.25]
[null,null,null,"Cost of Capital:",0.08]
[null,null,null,"Recapture Tax Rate:",0.25]
[]
[null,null,null,"Market Assumptions"]
[null,null,null,"Rental Price Growth Rate:",0.01]
[null,null,null,"Operating Expenses Growth Rate:",0.01]
[]
[null,null,null,"Home Selling Assumptions"]
[null,null,null,"Appreciation Rate:",0.02]
[null,null,null," Selling Closing Costs:",0.06]
[]
[]
[]
[]
[null,null,null,"Termination (Reversion) Statement"]
[]
[null,null,null,"Gross Future Sales Price",{"$f":"E4*(1+E32)^5","v":242897.77670400002}]
[null,null,null,"Less Selling Expenses",{"$f":"E40*E33","v":14573.866602240001}]
[null,null,null,"Net Sales Proceeds",{"$f":"E40-E41","v":228323.91010176}]
[null,null,null,"Less Mortgage Balance",{"$f":"'Amortization Table'!G66","v":189035.30245443012}]
[null,null,null,"Before Tax Cash on Sale",{"$f":"E42-E43","v":39288.607647329889}]
[]
[null,null,null,"Net Sales Proceeds",{"$f":"E42","v":228323.91010176}]
[null,null,null,"Less Cost Basis",{"$f":"E4","v":220000}]
[null,null,null,"Capital Gain (Economic Gain)",{"$f":"E46-E47","v":8323.9101017600042}]
[null,null,null,"X Capital Gains Rate",0.2]
[null,null,null,"Capital Gains Taxes",{"$f":"E49*E48","v":1664.7820203520009}]
[]
[null,null,null,"Accumulated Depreciation",{"$f":"SUM(J5:N5)","v":36000}]
[null,null,null,"X Recapture Tax Rate",{"$f":"E25","v":0.25}]
[null,null,null,"Recapture Taxes",{"$f":"IF(E48>0,E52*E53,MAX((E52+E48)*E53,0))","v":9000}]
[]
[null,null,null,"Before Tax Cash on Sale",{"$f":"E44","v":39288.607647329889}]
[null,null,null,"Less Capital Gains Taxes",{"$f":"E50","v":1664.7820203520009}]
[null,null,null,"Less Recapture Taxes",{"$f":"E54","v":9000}]
[null,null,null,"After Tax Cash on Sale",{"$f":"E56-E57-E58","v":28623.825626977887}]

{"sheet":"lists","index":5,"n_rows":22,"n_cols":25,"rows_kept":22,"cut":false,"hidden":true,"merged":[]}
["Purchase Prices",null,"Down Payment",null,"Buyer Closing Costs",null,"Land Allocation %",null,"Mortgage Interest Rate",null,"Rental Price (monthly)",null,"Property Management Fee",null,"Property Taxes",null,"Landlord Insurance",null,"HOA Fees",null,"Repairs/Maintenance",null,"Marginal Tax Rates",null,"Seller Closing Costs"]
[100000,null,3.5000000000000003E-2,null,0.02,null,0.1,null,0.03,null,800,null,0,null,500,null,500,null,0,null,0,null,0.1,null,0.03]
[{"$f":"A2+20000","v":120000},null,0.05,null,2.5000000000000001E-2,null,0.2,null,{"$f":"I2+0.25%","v":3.2500000000000001E-2},null,{"$f":"K2+100","v":900},null,0.01,null,{"$f":"O2+100","v":600},null,{"$f":"Q2+100","v":600},null,25,null,{"$f":"U2+100","v":100},null,0.15,null,3.5000000000000003E-2]
[{"$f":"A3+20000","v":140000},null,0.1,null,0.03,null,0.3,null,{"$f":"I3+0.25%","v":3.5000000000000003E-2},null,{"$f":"K3+100","v":1000},null,0.02,null,{"$f":"O3+100","v":700},null,700,null,{"$f":"S3+25","v":50},null,200,null,0.25,null,0.04]
[160000,null,0.15,null,3.5000000000000003E-2,null,0.4,null,3.7500000000000006E-2,null,1100,null,0.03,null,800,null,800,null,75,null,300,null,0.28000000000000003,null,4.4999999999999998E-2]
[180000,null,0.2,null,0.04,null,null,null,4.0000000000000008E-2,null,1200,null,0.04,null,900,null,900,null,100,null,400,null,0.33,null,4.9999999999999996E-2]
[200000,null,null,null,null,null,null,null,4.250000000000001E-2,null,1300,null,0.05,null,1000,null,1000,null,125,null,500,null,0.35,null,5.4999999999999993E-2]
[220000,null,null,null,null,null,null,null,4.5000000000000012E-2,null,1400,null,0.06,null,1100,null,1100,null,150,null,600,null,0.39600000000000002,null,5.9999999999999991E-2]
[240000,null,null,null,null,null,null,null,4.7500000000000014E-2,null,1500,null,7.0000000000000007E-2,null,1200,null,1200,null,175,null,700,null,null,null,6.4999999999999988E-2]
[260000,null,null,null,null,null,null,null,5.0000000000000017E-2,null,1600,null,0.08,null,1300,null,1300,null,200,null,800,null,null,null,6.9999999999999993E-2]
[280000,null,null,null,null,null,null,null,5.2500000000000019E-2,null,1700,null,0.09,null,1400,null,1400,null,null,null,900,null,null,null,7.4999999999999997E-2]
[300000,null,null,null,null,null,null,null,5.5000000000000021E-2,null,1800,null,0.1,null,1500,null,1500,null,null,null,1000,null,null,null,0.08]
[320000,null,null,null,null,null,null,null,5.7500000000000023E-2,null,1900,null,0.11,null,1600,null,1600,null,null,null,1100]
[340000,null,null,null,null,null,null,null,6.0000000000000026E-2,null,2000,null,0.12,null,1700,null,1700,null,null,null,1200]
[360000,null,null,null,null,null,null,null,null,null,2100,null,0.13,null,1800,null,1800,null,null,null,1300]
[380000,null,null,null,null,null,null,null,null,null,2200,null,0.14000000000000001,null,1900,null,1900,null,null,null,1400]
[400000,null,null,null,null,null,null,null,null,null,2300,null,0.15,null,2000,null,2000,null,null,null,{"$f":"U16+100","v":1500}]
[420000,null,null,null,null,null,null,null,null,null,2400,null,null,null,null,null,null,null,null,null,1600]
[440000,null,null,null,null,null,null,null,null,null,2500,null,null,null,null,null,null,null,null,null,1700]
[460000,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1800]
[480000,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1900]
[500000,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2000]

{"sheet":"Amortization Table","index":6,"n_rows":366,"n_cols":14,"rows_kept":366,"cut":false,"hidden":true,"merged":[]}
[null,null,{"$f":"Inputs!E4","v":220000},"Home Value"]
[null,null,{"$f":"Inputs!E5*'Amortization Table'!C1","v":11000},"Down Payment",null,{"$f":"Inputs!E9","v":0.04},"rate"]
[null,null,{"$f":"C1-C2","v":209000},"Principal Value",null,{"$f":"Inputs!E10","v":30},"# of years"]
[]
[]
[null,null,"BB Principal","PMT","Interest","Principal","EB Principal",null,null,null,"Principal Paid","Interest Paid","Total","Total Principal Paid"]
[1,"Period 1",{"$f":"C3","v":209000},{"$f":"-PMT($F$2/12,12*$F$3,$C$3,0)","v":997.79796752281027},{"$f":"C7*$F$2/12","v":696.66666666666663},{"$f":"D7-E7","v":301.13130085614364},{"$f":"C7-F7","v":208698.86869914384},136.37,null,"Year 1",{"$f":"SUMIF($A$7:$A$366,RIGHT(J7,2),$F$7:$F$366)","v":3680.5661454967985},{"$f":"SUMIF($A$7:$A$366,RIGHT(J7,2),$E$7:$E$366)","v":8293.0094647769256},{"$f":"K7+L7","v":11973.575610273725},{"$f":"K7","v":3680.5661454967985}]
[1,"Period 2",{"$f":"G7","v":208698.86869914384},{"$f":"-PMT($F$2/12,12*$F$3,$C$3,0)","v":997.79796752281027},{"$f":"C8*$F$2/12","v":695.66289566381283},{"$f":"D8-E8","v":302.13507185899743},{"$f":"C8-F8","v":208396.73362728485},{"$f":"H7/G7","v":6.5342951234004189E-4},null,"Year 2",{"$f":"SUMIF($A$7:$A$366,RIGHT(J8,2),$F$7:$F$366)","v":3830.51808908268},{"$f":"SUMIF($A$7:$A$366,RIGHT(J8,2),$E$7:$E$366)","v":8143.0575211910436},{"$f":"K8+L8","v":11973.575610273723},{"$f":"K8+N7","v":7511.084234579479}]
[1,"Period 3",{"$f":"G8","v":208396.73362728485},997.79796752281027,{"$f":"C9*$F$2/12","v":694.65577875761619},{"$f":"D9-E9","v":303.14218876519408},{"$f":"C9-F9","v":208093.59143851965},{"$f":"H7*12","v":1636.44},null,"Year 3",3986.5793062140719,7986.9963040596513,11973.575610273723,{"$f":"K9+N8","v":11497.66354079355}]
[1,"Period 4",208093.59143851965,997.79796752281027,693.6453047950655,304.15266272774477,207789.4387757919,{"$f":"H9/G7","v":7.8411541480805039E-3},null,"Year 4",4148.9986981213387,7824.5769121523854,11973.575610273725,15646.662238914889]
[1,"Period 5",207789.4387757919,997.79796752281027,692.63146258597305,305.16650493683721,207484.27227085506,null,null,"Year 5",4318.0353066550006,7655.5403036187226,11973.575610273723,19964.697545569888]
[1,"Period 6",207484.27227085506,997.79796752281027,691.61424090285027,306.18372661996,207178.0885442351,null,null,"Year 6",4493.958727430253,7479.6168828434702,11973.575610273723,24458.656273000142]
[1,"Period 7",207178.0885442351,997.79796752281027,690.59362848078365,307.20433904202662,206870.88420519308,null,null,"Year 7",4677.0495398036164,7296.5260704701077,11973.575610273725,29135.705812803761]
[1,"Period 8",206870.88420519308,997.79796752281027,689.5696140173103,308.22835350549997,206562.6558516876,null,null,"Year 8",4867.5997543675094,7105.9758559062129,11973.575610273721,34003.305567171272]
[1,"Period 9",206562.6558516876,997.79796752281027,688.54218617229196,309.2557813505183,206253.40007033708,null,null,"Year 9",5065.913278676433,6907.6623315972911,11973.575610273725,39069.218845847703]
[1,"Period 10",206253.40007033708,997.79796752281027,687.5113335677903,310.28663395501997,205943.11343638206,null,null,"Year 10",5272.3064019475605,6701.2692083261627,11973.575610273723,44341.52524779526]
[1,"Period 11",205943.11343638206,997.79796752281027,686.47704478794014,311.32092273487012,205631.7925136472,null,null,"Year 11",5487.1082995087891,6486.4673107649342,11973.575610273723,49828.633547304053]
[1,"Period 12",205631.7925136472,997.79796752281027,685.43930837882408,312.35865914398619,205319.43385450321,null,null,"Year 12",5710.6615577987604,6262.9140524749637,11973.575610273725,55539.295105102814]
[{"$f":"A18+1","v":2},"Period 13",205319.43385450321,997.79796752281027,684.39811284834411,313.39985467446616,205006.03399982874,null,null,"Year 13",5943.3227207562104,6030.2528895175128,11973.575610273723,61482.617825859023]
[{"$f":"A19","v":2},"Period 14",205006.03399982874,997.79796752281027,683.35344666609581,314.44452085671446,204691.58947897202,null,null,"Year 14",6185.4628584700586,5788.1127518036637,11973.575610273721,67668.080684329077]
[{"$f":"A20","v":2},"Period 15",204691.58947897202,997.79796752281027,682.30529826324005,315.49266925957022,204376.09680971244,null,null,"Year 15",6437.4681589971806,5536.1074512765417,11973.575610273721,74105.548843326251]
[{"$f":"A21","v":2},"Period 16",204376.09680971244,997.79796752281027,681.25365603237481,316.54431149043546,204059.55249822201,null,null,"Year 16",6699.7405442917461,5273.8350659819771,11973.575610273723,80805.289387618002]
[2,"Period 17",204059.55249822201,997.79796752281027,680.19850832740678,317.59945919540348,203741.95303902662,null,null,"Year 17",6972.6983112284606,5000.8772990452608,11973.575610273721,87777.987698846468]
[2,"Period 18",203741.95303902662,997.79796752281027,679.13984346342204,318.65812405938823,203423.29491496723,null,null,"Year 18",7256.7767987421221,4716.7988115316011,11973.575610273723,95034.764497588592]
[2,"Period 19",203423.29491496723,997.79796752281027,678.0776497165574,319.72031780625287,203103.57459716097,null,null,"Year 19",7552.4290821474078,4421.1465281263154,11973.575610273723,102587.19357973601]
[2,"Period 20",203103.57459716097,997.79796752281027,677.01191532386986,320.78605219894041,202782.78854496204,null,null,"Year 20",7860.1266957463849,4113.4489145273401,11973.575610273725,110447.32027548239]
[2,"Period 21",202782.78854496204,997.79796752281027,675.94262848320682,321.85533903960345,202460.93320592243,null,null,"Year 21",8180.3603848761195,3793.2152253976037,11973.575610273723,118627.68066035851]
[2,"Period 22",202460.93320592243,997.79796752281027,674.86977735307471,322.92819016973556,202138.00501575269,null,null,"Year 22",8513.6408885958954,3459.9347216778265,11973.575610273721,127141.32154895441]
[2,"Period 23",202138.00501575269,997.79796752281027,673.79335005250903,324.00461747030124,201814.0003982824,null,null,"Year 23",8860.4997542623023,3113.0758560114218,11973.575610273725,136001.82130321671]
[2,"Period 24",201814.0003982824,997.79796752281027,672.71333466094131,325.08463286186895,201488.91576542053,null,null,"Year 24",9221.4901852913645,2752.0854249823574,11973.575610273721,145223.31148850807]
[{"$f":"A30+1","v":3},"Period 25",201488.91576542053,997.79796752281027,671.62971921806843,326.16824830474184,201162.74751711579,null,null,"Year 25",9597.1879234598346,2376.38768681389,11973.575610273725,154820.4994119679]
[{"$f":"A31","v":3},"Period 26",201162.74751711579,997.79796752281027,670.54249172371931,327.25547579909096,200835.4920413167,null,null,"Year 26",9988.192167152758,1985.3834431209643,11973.575610273721,164808.69157912067]
[{"$f":"A32","v":3},"Period 27",200835.4920413167,997.79796752281027,669.45164013772239,328.34632738508787,200507.14571393162,null,null,"Year 27",10395.126527021919,1578.4490832518034,11973.575610273723,175203.8181061426]
[{"$f":"A33","v":3},"Period 28",200507.14571393162,997.79796752281027,668.35715237977206,329.44081514303821,200177.70489878859,null,null,"Year 28",10818.640020579229,1154.9355896944958,11973.575610273725,186022.45812672182]
[3,"Period 29",200177.70489878859,997.79796752281027,667.25901632929538,330.53895119351489,199847.16594759509,null,null,"Year 29",11259.40810731141,714.16750296231339,11973.575610273723,197281.86623403322]
[3,"Period 30",199847.16594759509,997.79796752281027,666.15721982531693,331.64074769749334,199515.52519989759,null,null,"Year 30",11718.133765966864,255.44184430685814,11973.575610273723,209000.00000000009]
[3,"Period 31",199515.52519989759,997.79796752281027,665.05175066632535,332.74621685648492,199182.77898304109]
[3,"Period 32",199182.77898304109,997.79796752281027,663.942596610137,333.85537091267327,198848.92361212842]
[3,"Period 33",198848.92361212842,997.79796752281027,662.8297453737614,334.96822214904887,198513.95538997938]
[3,"Period 34",198513.95538997938,997.79796752281027,661.71318463326463,336.08478288954564,198177.87060708983]
[3,"Period 35",198177.87060708983,997.79796752281027,660.59290202363275,337.20506549917752,197840.66554159066]
[3,"Period 36",197840.66554159066,997.79796752281027,659.46888513863553,338.32908238417474,197502.33645920648]
[{"$f":"A42+1","v":4},"Period 37",197502.33645920648,997.79796752281027,658.34112153068827,339.456845992122,197162.87961321435]
[{"$f":"A43","v":4},"Period 38",197162.87961321435,997.79796752281027,657.20959871071443,340.58836881209584,196822.29124440224]
[{"$f":"A44","v":4},"Period 39",196822.29124440224,997.79796752281027,656.0743041480074,341.72366337480287,196480.56758102743]
[{"$f":"A45","v":4},"Period 40",196480.56758102743,997.79796752281027,654.93522527009145,342.86274225271882,196137.70483877472]
[4,"Period 41",196137.70483877472,997.79796752281027,653.79234946258237,344.0056180602279,195793.69922071448]
[4,"Period 42",195793.69922071448,997.79796752281027,652.64566406904828,345.15230345376199,195448.54691726071]
[4,"Period 43",195448.54691726071,997.79796752281027,651.49515639086906,346.30281113194121,195102.24410612878]
[4,"Period 44",195102.24410612878,997.79796752281027,650.34081368709599,347.45715383571428,194754.78695229307]
[4,"Period 45",194754.78695229307,997.79796752281027,649.18262317431027,348.6153443485,194406.17160794456]
[4,"Period 46",194406.17160794456,997.79796752281027,648.02057202648189,349.77739549632838,194056.39421244824]
[4,"Period 47",194056.39421244824,997.79796752281027,646.85464737482755,350.94332014798272,193705.45089230026]
[4,"Period 48",193705.45089230026,997.79796752281027,645.68483630766752,352.11313121514274,193353.3377610851]
[{"$f":"A54+1","v":5},"Period 49",193353.3377610851,997.79796752281027,644.51112587028365,353.28684165252662,193000.05091943257]
[{"$f":"A55","v":5},"Period 50",193000.05091943257,997.79796752281027,643.3335030647753,354.46446445803497,192645.58645497455]
[{"$f":"A56","v":5},"Period 51",192645.58645497455,997.79796752281027,642.15195484991511,355.64601267289515,192289.94044230165]
[{"$f":"A57","v":5},"Period 52",192289.94044230165,997.79796752281027,640.96646814100552,356.83149938180475,191933.10894291985]
[5,"Period 53",191933.10894291985,997.79796752281027,639.77702980973288,358.02093771307739,191575.08800520678]
[5,"Period 54",191575.08800520678,997.79796752281027,638.58362668402265,359.21434083878762,191215.873664368]
[5,"Period 55",191215.873664368,997.79796752281027,637.38624554789328,360.41172197491699,190855.46194239307]
[5,"Period 56",190855.46194239307,997.79796752281027,636.18487314131028,361.61309438149999,190493.84884801158]
[5,"Period 57",190493.84884801158,997.79796752281027,634.97949616003859,362.81847136277167,190131.03037664879]
[5,"Period 58",190131.03037664879,997.79796752281027,633.770101255496,364.02786626731427,189767.00251038148]
[5,"Period 59",189767.00251038148,997.79796752281027,632.55667503460495,365.24129248820532,189401.76121789328]
[5,"Period 60",189401.76121789328,997.79796752281027,631.3392040596442,366.45876346316606,189035.30245443012]
[{"$f":"A66+1","v":6},"Period 61",189035.30245443012,997.79796752281027,630.11767484810036,367.6802926747099,188667.6221617554]
[{"$f":"A67","v":6},"Period 62",188667.6221617554,997.79796752281027,628.89207387251793,368.90589365029234,188298.71626810511]
[{"$f":"A68","v":6},"Period 63",188298.71626810511,997.79796752281027,627.66238756035034,370.13557996245993,187928.58068814265]
[{"$f":"A69","v":6},"Period 64",187928.58068814265,997.79796752281027,626.42860229380892,371.36936522900135,187557.21132291364]
[6,"Period 65",187557.21132291364,997.79796752281027,625.19070440971211,372.60726311309816,187184.60405980053]
[6,"Period 66",187184.60405980053,{"$f":"-PMT($F$2/12,12*$F$3,$C$3,0)","v":997.79796752281027},623.94868019933517,373.8492873234751,186810.75477247706]
[6,"Period 67",{"$f":"G72","v":186810.75477247706},997.79796752281027,{"$f":"C73*$F$2/12","v":622.70251590825683},{"$f":"D73-E73","v":375.09545161455344},{"$f":"C73-F73","v":186435.6593208625}]
[6,"Period 68",186435.6593208625,997.79796752281027,621.4521977362084,376.34576978660186,186059.3135510759]
[6,"Period 69",186059.3135510759,997.79796752281027,620.19771183691967,377.6002556858906,185681.71329539001]
[6,"Period 70",185681.71329539001,997.79796752281027,618.9390443179667,378.85892320484356,185302.85437218516]
[6,"Period 71",185302.85437218516,997.79796752281027,617.67618124061721,380.12178628219306,184922.73258590297]
[6,"Period 72",184922.73258590297,997.79796752281027,616.40910861967654,381.38885890313372,184541.34372699982]
[{"$f":"A78+1","v":7},"Period 73",184541.34372699982,997.79796752281027,615.13781242333278,382.66015509947749,184158.68357190036]
[{"$f":"A79","v":7},"Period 74",184158.68357190036,997.79796752281027,613.86227857300116,383.9356889498091,183774.74788295056]
[{"$f":"A80","v":7},"Period 75",183774.74788295056,997.79796752281027,612.58249294316852,385.21547457964175,183389.53240837093]
[{"$f":"A81","v":7},"Period 76",183389.53240837093,997.79796752281027,611.29844136123643,386.49952616157384,183003.03288220934]
[7,"Period 77",183003.03288220934,997.79796752281027,610.01010960736448,387.78785791544578,182615.24502429389]
[7,"Period 78",182615.24502429389,997.79796752281027,608.71748341431305,389.08048410849722,182226.16454018539]
[7,"Period 79",182226.16454018539,997.79796752281027,607.42054846728468,390.37741905552559,181835.78712112986]
[7,"Period 80",181835.78712112986,997.79796752281027,606.11929040376629,391.67867711904398,181444.10844401081]
[7,"Period 81",181444.10844401081,997.79796752281027,604.81369481336935,392.98427270944092,181051.12417130137]
[7,"Period 82",181051.12417130137,997.79796752281027,603.50374723767129,394.29422028513898,180656.82995101623]
[7,"Period 83",180656.82995101623,997.79796752281027,602.18943317005414,395.60853435275612,180261.22141666347]
[7,"Period 84",180261.22141666347,997.79796752281027,600.87073805554485,396.92722946726542,179864.29418719621]
[{"$f":"A90+1","v":8},"Period 85",179864.29418719621,997.79796752281027,599.54764729065403,398.25032023215624,179466.04386696406]
[{"$f":"A91","v":8},"Period 86",179466.04386696406,997.79796752281027,598.22014622321353,399.57782129959674,179066.46604566445]
[{"$f":"A92","v":8},"Period 87",179066.46604566445,997.79796752281027,596.88822015221479,400.90974737059548,178665.55629829384]
[{"$f":"A93","v":8},"Period 88",178665.55629829384,997.79796752281027,595.55185432764608,402.24611319516418,178263.31018509867]
[8,"Period 89",178263.31018509867,997.79796752281027,594.2110339503289,403.58693357248137,177859.72325152619]
[8,"Period 90",177859.72325152619,997.79796752281027,592.86574417175393,404.93222335105634,177454.79102817512]
[8,"Period 91",177454.79102817512,997.79796752281027,591.51597009391708,406.28199742889319,177048.50903074624]
[8,"Period 92",177048.50903074624,997.79796752281027,590.1616967691541,407.63627075365616,176640.87275999258]
[8,"Period 93",176640.87275999258,997.79796752281027,588.80290919997526,408.99505832283501,176231.87770166973]
[8,"Period 94",176231.87770166973,997.79796752281027,587.43959233889916,410.35837518391111,175821.51932648581]
[8,"Period 95",175821.51932648581,997.79796752281027,586.07173108828601,411.72623643452425,175409.79309005127]
[8,"Period 96",175409.79309005127,997.79796752281027,584.69931030017085,413.09865722263942,174996.69443282863]
[{"$f":"A102+1","v":9},"Period 97",174996.69443282863,997.79796752281027,583.32231477609548,414.47565274671479,174582.21878008192]
[{"$f":"A103","v":9},"Period 98",174582.21878008192,997.79796752281027,581.94072926693968,415.85723825587058,174166.36154182605]
[{"$f":"A104","v":9},"Period 99",174166.36154182605,997.79796752281027,580.55453847275351,417.24342905005676,173749.11811277599]
[{"$f":"A105","v":9},"Period 100",173749.11811277599,997.79796752281027,579.16372704258663,418.63424048022364,173330.48387229576]
[9,"Period 101",173330.48387229576,997.79796752281027,577.76827957431919,420.02968794849107,172910.45418434727]
[9,"Period 102",172910.45418434727,997.79796752281027,576.36818061449094,421.42978690831933,172489.02439743895]
[9,"Period 103",172489.02439743895,997.79796752281027,574.96341465812986,422.8345528646804,172066.18984457426]
[9,"Period 104",172066.18984457426,997.79796752281027,573.5539661485808,424.24400137422947,171641.94584320002]
[9,"Period 105",171641.94584320002,997.79796752281027,572.13981947733339,425.65814804547688,171216.28769515455]
[9,"Period 106",171216.28769515455,997.79796752281027,570.7209589838485,427.07700853896176,170789.21068661558]
[9,"Period 107",170789.21068661558,997.79796752281027,569.29736895538531,428.50059856742496,170360.71008804816]
[9,"Period 108",170360.71008804816,997.79796752281027,567.86903362682722,429.92893389598305,169930.78115415218]
[{"$f":"A114+1","v":10},"Period 109",169930.78115415218,997.79796752281027,566.43593718050727,431.362030342303,169499.41912380987]
[{"$f":"A115","v":10},"Period 110",169499.41912380987,997.79796752281027,564.99806374603293,432.79990377677734,169066.61922003308]
[{"$f":"A116","v":10},"Period 111",169066.61922003308,997.79796752281027,563.55539740011034,434.24257012269993,168632.37664991038]
[{"$f":"A117","v":10},"Period 112",168632.37664991038,997.79796752281027,562.10792216636798,435.69004535644228,168196.68660455395]
[10,"Period 113",168196.68660455395,997.79796752281027,560.6556220151798,437.14234550763047,167759.54425904632]
[10,"Period 114",167759.54425904632,997.79796752281027,559.19848086348782,438.59948665932245,167320.94477238701]
[10,"Period 115",167320.94477238701,997.79796752281027,557.73648257462344,440.06148494818683,166880.88328743883]
[10,"Period 116",166880.88328743883,997.79796752281027,556.26961095812942,441.52835656468085,166439.35493087416]
[10,"Period 117",166439.35493087416,997.79796752281027,554.79784976958058,443.00011775322969,165996.35481312094]
[10,"Period 118",165996.35481312094,997.79796752281027,553.32118271040315,444.47678481240712,165551.87802830854]
[10,"Period 119",165551.87802830854,997.79796752281027,551.83959342769515,445.95837409511512,165105.91965421342]
[10,"Period 120",165105.91965421342,997.79796752281027,550.35306551404472,447.44490200876555,164658.47475220464]
[{"$f":"A126+1","v":11},"Period 121",164658.47475220464,997.79796752281027,548.86158250734877,448.9363850154615,164209.53836718918]
[{"$f":"A127","v":11},"Period 122",164209.53836718918,997.79796752281027,547.36512789063056,450.43283963217971,163759.105527557]
[{"$f":"A128","v":11},"Period 123",163759.105527557,997.79796752281027,545.86368509185661,451.93428243095366,163307.17124512605]
[{"$f":"A129","v":11},"Period 124",163307.17124512605,997.79796752281027,544.35723748375347,453.4407300390568,162853.73051508699]
[11,"Period 125",162853.73051508699,997.79796752281027,542.84576838362329,454.95219913918697,162398.7783159478]
[11,"Period 126",162398.7783159478,997.79796752281027,541.32926105315937,456.4687064696509,161942.30960947814]
[11,"Period 127",161942.30960947814,997.79796752281027,539.80769869826042,457.99026882454984,161484.31934065357]
[11,"Period 128",161484.31934065357,997.79796752281027,538.28106446884522,459.51690305396505,161024.8024375996]
[11,"Period 129",161024.8024375996,997.79796752281027,536.7493414586653,461.04862606414497,160563.75381153545]
[11,"Period 130",160563.75381153545,{"$f":"-PMT($F$2/12,12*$F$3,$C$3,0)","v":997.79796752281027},535.21251270511823,462.58545481769204,160101.16835671777]
[11,"Period 131",{"$f":"G136","v":160101.16835671777},997.79796752281027,{"$f":"C137*$F$2/12","v":533.67056118905919},{"$f":"D137-E137","v":464.12740633375108},{"$f":"C137-F137","v":159637.04095038402}]
[11,"Period 132",159637.04095038402,997.79796752281027,532.12346983461339,465.67449768819688,159171.36645269583]
[{"$f":"A138+1","v":12},"Period 133",159171.36645269583,997.79796752281027,530.57122150898613,467.22674601382414,158704.13970668201]
[{"$f":"A139","v":12},"Period 134",158704.13970668201,997.79796752281027,529.01379902227336,468.78416850053691,158235.35553818147]
[{"$f":"A140","v":12},"Period 135",158235.35553818147,997.79796752281027,527.45118512727151,470.34678239553875,157765.00875578594]
[{"$f":"A141","v":12},"Period 136",157765.00875578594,997.79796752281027,525.88336251928649,471.91460500352377,157293.09415078242]
[12,"Period 137",157293.09415078242,997.79796752281027,524.31031383594143,473.48765368686884,156819.60649709555]
[12,"Period 138",156819.60649709555,997.79796752281027,522.73202165698524,475.06594586582503,156344.54055122973]
[12,"Period 139",156344.54055122973,997.79796752281027,521.14846850409913,476.64949901871114,155867.89105221102]
[12,"Period 140",155867.89105221102,997.79796752281027,519.55963684070343,478.23833068210683,155389.65272152892]
[12,"Period 141",155389.65272152892,997.79796752281027,517.96550907176311,479.83245845104716,154909.82026307788]
[12,"Period 142",154909.82026307788,997.79796752281027,516.36606754359298,481.43189997921729,154428.38836309867]
[12,"Period 143",154428.38836309867,997.79796752281027,514.7612945436623,483.03667297914797,153945.35169011951]
[12,"Period 144",153945.35169011951,997.79796752281027,513.15117230039834,484.64679522241192,153460.70489489709]
[{"$f":"A150+1","v":13},"Period 145",153460.70489489709,997.79796752281027,511.53568298299029,486.26228453981997,152974.44261035728]
[{"$f":"A151","v":13},"Period 146",152974.44261035728,997.79796752281027,509.91480870119091,487.88315882161936,152486.55945153566]
[{"$f":"A152","v":13},"Period 147",152486.55945153566,997.79796752281027,508.2885315051189,489.50943601769137,151997.05001551798]
[{"$f":"A153","v":13},"Period 148",151997.05001551798,997.79796752281027,506.65683338505988,491.14113413775038,151505.90888138022]
[13,"Period 149",151505.90888138022,997.79796752281027,505.01969627126738,492.77827125154289,151013.13061012869]
[13,"Period 150",151013.13061012869,997.79796752281027,503.37710203376236,494.42086548904791,150518.70974463964]
[13,"Period 151",150518.70974463964,997.79796752281027,501.72903248213214,496.06893504067813,150022.64080959896]
[13,"Period 152",150022.64080959896,997.79796752281027,500.07546936532987,497.7224981574804,149524.91831144149]
[13,"Period 153",149524.91831144149,997.79796752281027,498.41639437147165,499.38157315133861,149025.53673829016]
[13,"Period 154",149025.53673829016,997.79796752281027,496.75178912763386,501.04617839517641,148524.49055989497]
[13,"Period 155",148524.49055989497,997.79796752281027,495.08163519964995,502.71633232316032,148021.77422757182]
[13,"Period 156",148021.77422757182,997.79796752281027,493.40591409190603,504.39205343090424,147517.38217414092]
[{"$f":"A162+1","v":14},"Period 157",147517.38217414092,997.79796752281027,491.72460724713642,506.07336027567385,147011.30881386524]
[{"$f":"A163","v":14},"Period 158",147011.30881386524,997.79796752281027,490.03769604621743,507.76027147659283,146503.54854238866]
[{"$f":"A164","v":14},"Period 159",146503.54854238866,997.79796752281027,488.34516180796214,509.45280571484813,145994.0957366738]
[{"$f":"A165","v":14},"Period 160",145994.0957366738,997.79796752281027,486.64698578891267,511.15098173389759,145482.9447549399]
[14,"Period 161",145482.9447549399,997.79796752281027,484.94314918313302,512.85481833967719,144970.08993660024]
[14,"Period 162",144970.08993660024,997.79796752281027,483.23363312200081,514.56433440080946,144455.52560219943]
[14,"Period 163",144455.52560219943,997.79796752281027,481.51841867399816,516.27954884881206,143939.24605335062]
[14,"Period 164",143939.24605335062,997.79796752281027,479.79748684450209,518.00048067830812,143421.24557267231]
[14,"Period 165",143421.24557267231,997.79796752281027,478.07081857557438,519.72714894723595,142901.51842372507]
[14,"Period 166",142901.51842372507,997.79796752281027,476.33839474575024,521.45957277705998,142380.058850948]
[14,"Period 167",142380.058850948,997.79796752281027,474.60019616982669,523.19777135298364,141856.86107959502]
[14,"Period 168",141856.86107959502,997.79796752281027,472.8562035986501,524.94176392416011,141331.91931567085]
[{"$f":"A174+1","v":15},"Period 169",141331.91931567085,997.79796752281027,471.10639771890283,526.69156980390744,140805.22774586696]
[{"$f":"A175","v":15},"Period 170",140805.22774586696,997.79796752281027,469.35075915288985,528.44720836992042,140276.78053749705]
[{"$f":"A176","v":15},"Period 171",140276.78053749705,997.79796752281027,467.58926845832349,530.20869906448684,139746.57183843257]
[{"$f":"A177","v":15},"Period 172",139746.57183843257,997.79796752281027,465.82190612810859,531.97606139470167,139214.59577703787]
[15,"Period 173",139214.59577703787,997.79796752281027,464.04865259012627,533.749314932684,138680.8464621052]
[15,"Period 174",138680.8464621052,997.79796752281027,462.26948820701733,535.52847931579299,138145.31798278939]
[15,"Period 175",138145.31798278939,997.79796752281027,460.48439327596469,537.31357424684552,137608.00440854253]
[15,"Period 176",137608.00440854253,997.79796752281027,458.6933480284751,539.10461949433511,137068.89978904818]
[15,"Period 177",137068.89978904818,997.79796752281027,456.89633263016066,540.90163489264955,136527.99815415553]
[15,"Period 178",136527.99815415553,997.79796752281027,455.09332718051843,542.7046403422919,135985.29351381323]
[15,"Period 179",135985.29351381323,997.79796752281027,453.2843117127108,544.51365581009941,135440.77985800314]
[15,"Period 180",135440.77985800314,997.79796752281027,451.4692661933438,546.32870132946641,134894.45115667366]
[{"$f":"A186+1","v":16},"Period 181",134894.45115667366,997.79796752281027,449.64817052224549,548.14979700056483,134346.30135967309]
[{"$f":"A187","v":16},"Period 182",134346.30135967309,997.79796752281027,447.82100453224365,549.97696299056656,133796.32439668252]
[{"$f":"A188","v":16},"Period 183",133796.32439668252,997.79796752281027,445.98774798894175,551.81021953386858,133244.51417714867]
[{"$f":"A189","v":16},"Period 184",133244.51417714867,997.79796752281027,444.14838059049561,553.64958693231461,132690.86459021634]
[16,"Period 185",132690.86459021634,997.79796752281027,442.3028819673878,555.49508555542252,132135.36950466092]
[16,"Period 186",132135.36950466092,997.79796752281027,440.45123168220312,557.34673584060715,131578.02276882032]
[16,"Period 187",131578.02276882032,997.79796752281027,438.59340922940106,559.20455829340926,131018.81821052691]
[16,"Period 188",131018.81821052691,997.79796752281027,436.72939403508968,561.06857348772064,130457.74963703919]
[16,"Period 189",130457.74963703919,997.79796752281027,434.85916545679726,562.93880206601307,129894.81083497318]
[16,"Period 190",129894.81083497318,997.79796752281027,432.98270278324395,564.81526473956637,129329.99557023362]
[16,"Period 191",129329.99557023362,997.79796752281027,431.09998523411201,566.69798228869831,128763.29758794492]
[16,"Period 192",128763.29758794492,997.79796752281027,429.21099195981645,568.58697556299376,128194.71061238192]
[{"$f":"A198+1","v":17},"Period 193",128194.71061238192,997.79796752281027,427.31570204127314,570.48226548153707,127624.22834690039]
[{"$f":"A199","v":17},"Period 194",127624.22834690039,{"$f":"-PMT($F$2/12,12*$F$3,$C$3,0)","v":997.79796752281027},425.414094489668,572.38387303314221,127051.84447386724]
[{"$f":"A200","v":17},"Period 195",{"$f":"G200","v":127051.84447386724},997.79796752281027,{"$f":"C201*$F$2/12","v":423.5061482462242},{"$f":"D201-E201","v":574.29181927658601},{"$f":"C201-F201","v":126477.55265459066}]
[{"$f":"A201","v":17},"Period 196",126477.55265459066,997.79796752281027,421.59184218196884,576.20612534084148,125901.34652924981]
[17,"Period 197",125901.34652924981,997.79796752281027,419.67115509749942,578.12681242531085,125323.2197168245]
[17,"Period 198",125323.2197168245,997.79796752281027,417.7440657227483,580.05390180006202,124743.16581502445]
[17,"Period 199",124743.16581502445,997.79796752281027,415.81055271674813,581.98741480606213,124161.17840021838]
[17,"Period 200",124161.17840021838,997.79796752281027,413.87059466739464,583.92737285541557,123577.25102736297]
[17,"Period 201",123577.25102736297,997.79796752281027,411.92417009120987,585.87379743160045,122991.37722993137]
[17,"Period 202",122991.37722993137,997.79796752281027,409.97125743310454,587.82671008970578,122403.55051984166]
[17,"Period 203",122403.55051984166,997.79796752281027,408.01183506613893,589.78613245667134,121813.76438738499]
[17,"Period 204",121813.76438738499,997.79796752281027,406.04588129128325,591.75208623152707,121222.01230115346]
[{"$f":"A210+1","v":18},"Period 205",121222.01230115346,997.79796752281027,404.07337433717822,593.7245931856321,120628.28770796783]
[{"$f":"A211","v":18},"Period 206",120628.28770796783,997.79796752281027,402.09429235989279,595.70367516291753,120032.58403280491]
[{"$f":"A212","v":18},"Period 207",120032.58403280491,997.79796752281027,400.10861344268301,597.68935408012726,119434.89467872478]
[{"$f":"A213","v":18},"Period 208",119434.89467872478,997.79796752281027,398.11631559574926,599.68165192706101,118835.21302679772]
[18,"Period 209",118835.21302679772,997.79796752281027,396.11737675599238,601.68059076681789,118233.5324360309]
[18,"Period 210",118233.5324360309,997.79796752281027,394.11177478676967,603.68619273604054,117629.84624329486]
[18,"Period 211",117629.84624329486,997.79796752281027,392.09948747764952,605.69848004516075,117024.1477632497]
[18,"Period 212",117024.1477632497,997.79796752281027,390.08049254416568,607.71747497864453,116416.43028827105]
[18,"Period 213",116416.43028827105,997.79796752281027,388.05476762757013,609.7431998952402,115806.68708837581]
[18,"Period 214",115806.68708837581,997.79796752281027,386.02229029458607,611.77567722822414,115194.91141114758]
[18,"Period 215",115194.91141114758,997.79796752281027,383.98303803715862,613.81492948565165,114581.09648166192]
[18,"Period 216",114581.09648166192,997.79796752281027,381.93698827220641,615.8609792506038,113965.23550241132]
[{"$f":"A222+1","v":19},"Period 217",113965.23550241132,997.79796752281027,379.88411834137105,617.91384918143922,113347.32165322988]
[{"$f":"A223","v":19},"Period 218",113347.32165322988,997.79796752281027,377.82440551076633,619.97356201204389,112727.34809121783]
[{"$f":"A224","v":19},"Period 219",112727.34809121783,997.79796752281027,375.75782697072617,622.04014055208404,112105.30795066575]
[{"$f":"A225","v":19},"Period 220",112105.30795066575,997.79796752281027,373.68435983555247,624.11360768725785,111481.19434297849]
[19,"Period 221",111481.19434297849,997.79796752281027,371.60398114326159,626.19398637954873,110855.00035659893]
[19,"Period 222",110855.00035659893,997.79796752281027,369.51666785532979,628.28129966748043,110226.71905693146]
[19,"Period 223",110226.71905693146,997.79796752281027,367.42239685643818,630.37557066637214,109596.34348626509]
[19,"Period 224",109596.34348626509,997.79796752281027,365.321144954217,632.47682256859321,108963.86666369649]
[19,"Period 225",108963.86666369649,997.79796752281027,363.21288887898828,634.58507864382204,108329.28158505267]
[19,"Period 226",108329.28158505267,997.79796752281027,361.09760528350893,636.70036223930128,107692.58122281337]
[19,"Period 227",107692.58122281337,997.79796752281027,358.97527074271125,638.82269678009902,107053.75852603327]
[19,"Period 228",107053.75852603327,997.79796752281027,356.84586175344424,640.95210576936597,106412.80642026391]
[{"$f":"A234+1","v":20},"Period 229",106412.80642026391,997.79796752281027,354.70935473421304,643.08861278859717,105769.7178074753]
[{"$f":"A235","v":20},"Period 230",105769.7178074753,997.79796752281027,352.56572602491769,645.23224149789257,105124.4855659774]
[{"$f":"A236","v":20},"Period 231",105124.4855659774,997.79796752281027,350.41495188659133,647.38301563621894,104477.10255034118]
[{"$f":"A237","v":20},"Period 232",104477.10255034118,997.79796752281027,348.25700850113731,649.54095902167296,103827.56159131951]
[20,"Period 233",103827.56159131951,997.79796752281027,346.09187197106502,651.70609555174519,103175.85549576776]
[20,"Period 234",103175.85549576776,997.79796752281027,343.9195183192258,653.87844920358452,102521.97704656418]
[20,"Period 235",102521.97704656418,997.79796752281027,341.73992348854728,656.05804403426305,101865.91900252992]
[20,"Period 236",101865.91900252992,997.79796752281027,339.5530633417664,658.24490418104392,101207.67409834887]
[20,"Period 237",101207.67409834887,997.79796752281027,337.35891366116294,660.43905386164738,100547.23504448723]
[20,"Period 238",100547.23504448723,997.79796752281027,335.15745014829076,662.6405173745195,99884.594527112713]
[20,"Period 239",99884.594527112713,997.79796752281027,332.94864842370902,664.84931909910119,99219.745208013614]
[20,"Period 240",99219.745208013614,997.79796752281027,330.73248402671203,667.0654834960983,98552.679724517511]
[{"$f":"A246+1","v":21},"Period 241",98552.679724517511,997.79796752281027,328.50893241505838,669.28903510775194,97883.39068940976]
[{"$f":"A247","v":21},"Period 242",97883.39068940976,997.79796752281027,326.2779689646992,671.51999855811107,97211.870690851647]
[{"$f":"A248","v":21},"Period 243",97211.870690851647,997.79796752281027,324.03956896950552,673.75839855330469,96538.112292298349]
[{"$f":"A249","v":21},"Period 244",96538.112292298349,997.79796752281027,321.79370764099451,676.00425988181576,95862.108032416538]
[21,"Period 245",95862.108032416538,997.79796752281027,319.54036010805515,678.25760741475506,95183.850425001787]
[21,"Period 246",95183.850425001787,997.79796752281027,317.27950141667264,680.51846610613757,94503.331958895651]
[21,"Period 247",94503.331958895651,997.79796752281027,315.01110652965218,682.78686099315814,93820.54509790249]
[21,"Period 248",93820.54509790249,997.79796752281027,312.73515032634162,685.06281719646859,93135.482280706026]
[21,"Period 249",93135.482280706026,997.79796752281027,310.45160760235342,687.34635992045685,92448.135920785571]
[21,"Period 250",92448.135920785571,997.79796752281027,308.16045306928521,689.637514453525,91758.498406332044]
[21,"Period 251",91758.498406332044,997.79796752281027,305.86166135444017,691.93630616837004,91066.562100163675]
[21,"Period 252",91066.562100163675,997.79796752281027,303.55520700054558,694.24276052226469,90372.319339641414]
[{"$f":"A258+1","v":22},"Period 253",90372.319339641414,997.79796752281027,301.24106446547137,696.5569030573389,89675.762436584075]
[{"$f":"A259","v":22},"Period 254",89675.762436584075,997.79796752281027,298.91920812194695,698.87875940086337,88976.883677183214]
[{"$f":"A260","v":22},"Period 255",88976.883677183214,997.79796752281027,296.58961225727739,701.20835526553287,88275.675321917675]
[{"$f":"A261","v":22},"Period 256",88275.675321917675,997.79796752281027,294.25225107305891,703.54571644975135,87572.129605467926]
[22,"Period 257",87572.129605467926,997.79796752281027,291.90709868489313,705.8908688379172,86866.23873663001]
[22,"Period 258",86866.23873663001,{"$f":"-PMT($F$2/12,12*$F$3,$C$3,0)","v":997.79796752281027},289.55412912210005,708.24383840071027,86157.994898229299]
[22,"Period 259",{"$f":"G264","v":86157.994898229299},997.79796752281027,{"$f":"C265*$F$2/12","v":287.19331632743098},{"$f":"D265-E265","v":710.60465119537935},{"$f":"C265-F265","v":85447.390247033924}]
[22,"Period 260",85447.390247033924,997.79796752281027,284.82463415677972,712.9733333660306,84734.416913667897]
[22,"Period 261",84734.416913667897,997.79796752281027,282.448056378893,715.34991114391732,84019.067002523982]
[22,"Period 262",84019.067002523982,997.79796752281027,280.06355667507995,717.73441084773026,83301.332591676255]
[22,"Period 263",83301.332591676255,997.79796752281027,277.67110863892088,720.12685888388933,82581.205732792369]
[22,"Period 264",82581.205732792369,997.79796752281027,275.27068577597458,722.52728174683568,81858.678451045533]
[{"$f":"A270+1","v":23},"Period 265",81858.678451045533,997.79796752281027,272.86226150348512,724.93570601932515,81133.742745026204]
[{"$f":"A271","v":23},"Period 266",81133.742745026204,997.79796752281027,270.44580915008737,727.3521583727229,80406.390586653477]
[{"$f":"A272","v":23},"Period 267",80406.390586653477,997.79796752281027,268.0213019555116,729.77666556729866,79676.613921086173]
[{"$f":"A273","v":23},"Period 268",79676.613921086173,997.79796752281027,265.58871307028727,732.20925445252306,78944.404666633651]
[23,"Period 269",78944.404666633651,997.79796752281027,263.14801555544551,734.64995196736481,78209.754714666284]
[23,"Period 270",78209.754714666284,997.79796752281027,260.69918238222095,737.09878514058937,77472.655929525688]
[23,"Period 271",77472.655929525688,997.79796752281027,258.24218643175232,739.55578109105795,76733.100148434634]
[23,"Period 272",76733.100148434634,997.79796752281027,255.77700049478213,742.02096702802817,75991.079181406603]
[23,"Period 273",75991.079181406603,997.79796752281027,253.30359727135536,744.49437025145494,75246.584811155146]
[23,"Period 274",75246.584811155146,997.79796752281027,250.82194937051716,746.97601815229314,74499.608793002859]
[23,"Period 275",74499.608793002859,997.79796752281027,248.33202931000952,749.46593821280078,73750.142854790058]
[23,"Period 276",73750.142854790058,997.79796752281027,245.83380951596686,751.96415800684338,72998.178696783216]
[{"$f":"A282+1","v":24},"Period 277",72998.178696783216,997.79796752281027,243.32726232261072,754.47070520019952,72243.707991583011]
[{"$f":"A283","v":24},"Period 278",72243.707991583011,997.79796752281027,240.81235997194338,756.98560755086692,71486.722384032139]
[{"$f":"A284","v":24},"Period 279",71486.722384032139,997.79796752281027,238.28907461344045,759.50889290936982,70727.213491122762]
[{"$f":"A285","v":24},"Period 280",70727.213491122762,997.79796752281027,235.75737830374257,762.04058921906767,69965.172901903701]
[24,"Period 281",69965.172901903701,997.79796752281027,233.21724300634568,764.58072451646456,69200.59217738724]
[24,"Period 282",69200.59217738724,997.79796752281027,230.6686405912908,767.12932693151947,68433.462850455719]
[24,"Period 283",68433.462850455719,997.79796752281027,228.11154283485237,769.68642468795792,67663.776425767763]
[24,"Period 284",67663.776425767763,997.79796752281027,225.54592141922589,772.25204610358435,66891.524379664173]
[24,"Period 285",66891.524379664173,997.79796752281027,222.97174793221393,774.82621959059634,66116.698160073574]
[24,"Period 286",66116.698160073574,997.79796752281027,220.38899386691193,777.40897365589831,65339.289186417678]
[24,"Period 287",65339.289186417678,997.79796752281027,217.79763062139227,780.000336901418,64559.288849516262]
[24,"Period 288",64559.288849516262,997.79796752281027,215.19762949838753,782.60033802442274,63776.68851149184]
[{"$f":"A294+1","v":25},"Period 289",63776.68851149184,997.79796752281027,212.5889617049728,785.20900581783746,62991.479505674004]
[{"$f":"A295","v":25},"Period 290",62991.479505674004,997.79796752281027,209.9715983522467,787.82636917056357,62203.653136503439]
[{"$f":"A296","v":25},"Period 291",62203.653136503439,997.79796752281027,207.34551045501146,790.45245706779883,61413.200679435642]
[{"$f":"A297","v":25},"Period 292",61413.200679435642,997.79796752281027,204.71066893145215,793.08729859135815,60620.113380844283]
[25,"Period 293",60620.113380844283,997.79796752281027,202.06704460281426,795.73092291999603,59824.382457924286]
[25,"Period 294",59824.382457924286,997.79796752281027,199.41460819308097,798.38335932972927,59025.999098594555]
[25,"Period 295",59025.999098594555,997.79796752281027,196.75333032864853,801.04463719416174,58224.95446140039]
[25,"Period 296",58224.95446140039,997.79796752281027,194.0831815380013,803.71478598480894,57421.239675415578]
[25,"Period 297",57421.239675415578,997.79796752281027,191.40413225138525,806.39383527142502,56614.845840144153]
[25,"Period 298",56614.845840144153,997.79796752281027,188.7161528004805,809.0818147223298,55805.76402542182]
[25,"Period 299",55805.76402542182,997.79796752281027,186.01921341807272,811.77875410473757,54993.985271317084]
[25,"Period 300",54993.985271317084,997.79796752281027,183.31328423772359,814.4846832850867,54179.500588031995]
[{"$f":"A306+1","v":26},"Period 301",54179.500588031995,997.79796752281027,180.59833529343999,817.19963222937031,53362.300955802624]
[{"$f":"A307","v":26},"Period 302",53362.300955802624,997.79796752281027,177.87433651934211,819.92363100346813,52542.377324799156]
[{"$f":"A308","v":26},"Period 303",52542.377324799156,997.79796752281027,175.14125774933052,822.65670977347975,51719.720615025675]
[{"$f":"A309","v":26},"Period 304",51719.720615025675,997.79796752281027,172.39906871675225,825.39889880605801,50894.321716219616]
[26,"Period 305",50894.321716219616,997.79796752281027,169.6477390540654,828.1502284687449,50066.171487750871]
[26,"Period 306",50066.171487750871,997.79796752281027,166.8872382925029,830.91072923030742,49235.260758520562]
[26,"Period 307",49235.260758520562,997.79796752281027,164.11753586173521,833.68043166107509,48401.58032685949]
[26,"Period 308",48401.58032685949,997.79796752281027,161.33860108953164,836.45936643327866,47565.120960426211]
[26,"Period 309",47565.120960426211,997.79796752281027,158.55040320142072,839.24756432138952,46725.87339610482]
[26,"Period 310",46725.87339610482,997.79796752281027,155.7529113203494,842.04505620246084,45883.828339902357]
[26,"Period 311",45883.828339902357,997.79796752281027,152.94609446634118,844.85187305646912,45038.976466845888]
[26,"Period 312",45038.976466845888,997.79796752281027,150.12992155615296,847.66804596665725,44191.308420879228]
[{"$f":"A318+1","v":27},"Period 313",44191.308420879228,997.79796752281027,147.30436140293077,850.49360611987947,43340.814814759346]
[{"$f":"A319","v":27},"Period 314",43340.814814759346,997.79796752281027,144.4693827158645,853.32858480694574,42487.486229952403]
[{"$f":"A320","v":27},"Period 315",42487.486229952403,997.79796752281027,141.62495409984135,856.17301342296889,41631.313216529437]
[{"$f":"A321","v":27},"Period 316",41631.313216529437,997.79796752281027,138.77104405509814,859.02692346771209,40772.286293061727]
[27,"Period 317",40772.286293061727,997.79796752281027,135.90762097687244,861.89034654593786,39910.39594651579]
[27,"Period 318",39910.39594651579,997.79796752281027,133.03465315505264,864.76331436775763,39045.63263214803]
[27,"Period 319",39045.63263214803,997.79796752281027,130.15210877382677,867.64585874898353,38177.986773399047]
[27,"Period 320",38177.986773399047,997.79796752281027,127.25995591133017,870.5380116114801,37307.448761787564]
[27,"Period 321",37307.448761787564,997.79796752281027,124.35816253929188,873.43980498351834,36434.008956804042]
[27,"Period 322",36434.008956804042,{"$f":"-PMT($F$2/12,12*$F$3,$C$3,0)","v":997.79796752281027},121.44669652268014,876.35127100013017,35557.657685803912]
[27,"Period 323",{"$f":"G328","v":35557.657685803912},997.79796752281027,{"$f":"C329*$F$2/12","v":118.52552561934637},{"$f":"D329-E329","v":879.27244190346391},{"$f":"C329-F329","v":34678.385243900448}]
[27,"Period 324",34678.385243900448,997.79796752281027,115.59461747966816,882.20335004314211,33796.181893857305]
[{"$f":"A330+1","v":28},"Period 325",33796.181893857305,997.79796752281027,112.65393964619102,885.14402787661925,32911.037865980688]
[{"$f":"A331","v":28},"Period 326",32911.037865980688,997.79796752281027,109.70345955326896,888.09450796954127,32022.943358011147]
[{"$f":"A332","v":28},"Period 327",32022.943358011147,997.79796752281027,106.74314452670383,891.0548229961064,31131.888535015041]
[{"$f":"A333","v":28},"Period 328",31131.888535015041,997.79796752281027,103.77296178338348,894.02500573942677,30237.863529275615]
[28,"Period 329",30237.863529275615,997.79796752281027,100.79287843091872,897.00508909189159,29340.858440183725]
[28,"Period 330",29340.858440183725,997.79796752281027,97.802861467279072,899.99510605553121,28440.863334128193]
[28,"Period 331",28440.863334128193,997.79796752281027,94.802877780427309,902.99508974238302,27537.868244385809]
[28,"Period 332",27537.868244385809,997.79796752281027,91.792894147952708,906.0050733748576,26631.863171010951]
[28,"Period 333",26631.863171010951,997.79796752281027,88.772877236703167,909.02509028610712,25722.838080724843]
[28,"Period 334",25722.838080724843,997.79796752281027,85.742793602416143,912.05517392039417,24810.782906804448]
[28,"Period 335",24810.782906804448,997.79796752281027,82.702609689348165,915.09535783346212,23895.687548970986]
[28,"Period 336",23895.687548970986,997.79796752281027,79.652291829903291,918.14567569290693,22977.541873278078]
[{"$f":"A342+1","v":29},"Period 337",22977.541873278078,997.79796752281027,76.591806244260269,921.20616127854998,22056.335711999527]
[{"$f":"A343","v":29},"Period 338",22056.335711999527,997.79796752281027,73.521119039998425,924.27684848281183,21132.058863516715]
[{"$f":"A344","v":29},"Period 339",21132.058863516715,997.79796752281027,70.44019621172238,927.35777131108784,20204.701092205629]
[{"$f":"A345","v":29},"Period 340",20204.701092205629,997.79796752281027,67.349003640685439,930.44896388212487,19274.252128323504]
[29,"Period 341",19274.252128323504,997.79796752281027,64.247507094411688,933.55046042839854,18340.701667895104]
[29,"Period 342",18340.701667895104,997.79796752281027,61.135672226317013,936.66229529649331,17404.03937259861]
[29,"Period 343",17404.03937259861,997.79796752281027,58.013464575328705,939.78450294748154,16464.254869651129]
[29,"Period 344",16464.254869651129,997.79796752281027,54.880849565503759,942.91711795730646,15521.337751693824]
[29,"Period 345",15521.337751693824,997.79796752281027,51.737792505646077,946.06017501716417,14575.277576676659]
[29,"Period 346",14575.277576676659,997.79796752281027,48.584258588922204,949.21370893388803,13626.063867742771]
[29,"Period 347",13626.063867742771,997.79796752281027,45.420212892475909,952.37775463033438,12673.686113112437]
[29,"Period 348",12673.686113112437,997.79796752281027,42.245620377041455,955.55234714576886,11718.133765966668]
[{"$f":"A354+1","v":30},"Period 349",11718.133765966668,997.79796752281027,39.060445886555563,958.73752163625466,10759.396244330414]
[{"$f":"A355","v":30},"Period 350",10759.396244330414,997.79796752281027,35.864654147768043,961.93331337504219,9797.4629309553711]
[{"$f":"A356","v":30},"Period 351",9797.4629309553711,997.79796752281027,32.65820976985124,965.13975775295899,8832.3231732024124]
[{"$f":"A357","v":30},"Period 352",8832.3231732024124,997.79796752281027,29.441077244008042,968.35689027880221,7863.9662829236104]
[30,"Period 353",7863.9662829236104,997.79796752281027,26.213220943078699,971.58474657973159,6892.3815363438789]
[30,"Period 354",6892.3815363438789,997.79796752281027,22.974605121146265,974.82336240166399,5917.558173942215]
[30,"Period 355",5917.558173942215,997.79796752281027,19.725193913140718,978.07277360966953,4939.4854003325454]
[30,"Period 356",4939.4854003325454,997.79796752281027,16.464951334441817,981.33301618836845,3958.1523841441767]
[30,"Period 357",3958.1523841441767,997.79796752281027,13.193841280480589,984.6041262423297,2973.5482579018471]
[30,"Period 358",2973.5482579018471,997.79796752281027,9.9118275263394917,987.88613999647077,1985.6621179053764]
[30,"Period 359",1985.6621179053764,997.79796752281027,6.6188737263512545,991.17909379645903,994.48302410891733]
[30,"Period 360",994.48302410891733,997.79796752281027,3.3149434136963909,994.4830241091139,-1.9656454242067412E-10]

{"sheet":"to-do","index":7,"n_rows":11,"n_cols":3,"rows_kept":11,"cut":false,"hidden":true,"merged":[]}
[]
[]
[null,null,"setup P&L to be dynamic for how many years I want to hold onto it"]
[null,null,"create dashboard of rental ratios"]
[null,null,"look into pulling data from Zillow"]
[null,null,"put in risk measures --- low, medium, high scenarios"]
[null,null,"regression"]
[null,null,"create a new tab that pasts favorites"]
[null,null,"create a website link to rentometer.com"]
[null,null,"make hi-medium-low case scenarios"]
[null,null,"make system load default scenario"]

{"sheet":"SC Home","index":8,"n_rows":41,"n_cols":20,"rows_kept":41,"cut":false,"hidden":true,"merged":[]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Inputs:"]
[null,null,null,2014,2015,2016,2017,2018,null,null,null,null,null,null,null,null,null,"Termination (Reversion) Statement"]
[null,null,"Year 0","Year 1","Year 2","Year 3","Year 4","Year 5",null,null,null,null,null,null,null,null,null,"Gross Future Sales Price",{"$f":"O5*(1+O35)^5","v":191447.61127488001},"need to automate to correspond to # of years"]
[null,"Potential Gross Income",null,{"$f":"$O$14*12","v":17400},{"$f":"(D4)*(1+$O$31)","v":17748},{"$f":"(E4)*(1+$O$31)","v":18102.96},{"$f":"(F4)*(1+$O$31)","v":18465.019199999999},{"$f":"(G4)*(1+$O$31)","v":18834.319584000001},null,null,null,null,null,"Home Purchase Info",null,null,null,"Less Selling Expenses",{"$f":"S3*O36","v":11486.8566764928}]
[null,"Less Vacancy & CL",null,{"$f":"($O$16/12)*D4","v":725},{"$f":"($O$16/12)*E4","v":739.5},{"$f":"($O$16/12)*F4","v":754.29},{"$f":"($O$16/12)*G4","v":769.37579999999991},{"$f":"($O$16/12)*H4","v":784.76331600000003},null,null,null,null,null,"Buying Price:",173400,null,null,"Net Sales Proceeds",{"$f":"S3-S4","v":179960.7545983872}]
[null,"Plus Other Income",null,{"$f":"$O$15","v":0},{"$f":"$O$15","v":0},{"$f":"$O$15","v":0},{"$f":"$O$15","v":0},{"$f":"$O$15","v":0},null,null,null,null,null,"Down Payment:",0.2,null,null,"Less Mortgage Balance",{"$f":"'Amortization Table'!G66","v":189035.30245443012},"need to automate to correspond to # of years"]
[null,"Effective Gross Income",null,{"$f":"D4-D5+D6","v":16675},{"$f":"E4-E5+E6","v":17008.5},{"$f":"F4-F5+F6","v":17348.669999999998},{"$f":"G4-G5+G6","v":17695.643399999997},{"$f":"H4-H5+H6","v":18049.556268},null,null,null,null,null,"PMI (estimate):",0,null,null,"Before Tax Cash on Sale",{"$f":"S5-S6","v":-9074.5478560429183}]
[null,"Operating Expenses",null,null,null,null,null,null,null,null,null,null,null," Buying Closing Costs:",0.03]
[null,"   Property Taxes",null,{"$f":"$O$18","v":1300},{"$f":"D9*(1+$O$32)","v":1326},1352.52,1379.5704000000001,1407.1618080000001,null,null,null,null,null,"Land Allocation:",0.1,null,null,"Net Sales Proceeds",{"$f":"S5","v":179960.7545983872}]
[null,"   Condo Insurance",null,{"$f":"$O$19","v":850},867,884.34,902.02680000000009,920.06733600000007,null,null,null,null,null,"Mortgage Interest Rate:",3.2500000000000001E-2,null,null,"Less Cost Basis",{"$f":"O5","v":173400}]
[null,"   Property Mgt. Fee",null,{"$f":"$O$17*D7","v":1334},{"$f":"$O$17*E7","v":1360.68},{"$f":"$O$17*F7","v":1387.8935999999999},{"$f":"$O$17*G7","v":1415.6514719999998},{"$f":"$O$17*H7","v":1443.96450144},null,null,null,null,null,"# Years Loan:",30,null,null,"Capital Gain (Economic Gain)",{"$f":"S9-S10","v":6560.7545983871969}]
[null,"   Association Fees",null,{"$f":"$O$20*12","v":1620},{"$f":"D12*(1+$O$32)","v":1652.4},1685.4480000000001,1719.15696,1753.5400992,null,null,null,null,null,null,null,null,null,"X Capital Gains Rate",0.2]
[null,"   Interior Maintenance",null,{"$f":"$O$21","v":0},0,0,0,0,null,null,null,null,null,"Rental Info",null,null,null,"Capital Gains Taxes",{"$f":"S12*S11","v":1312.1509196774396}]
[null,"Total Oper. Expenses",null,{"$f":"SUM(D9:D13)","v":5104},{"$f":"SUM(E9:E13)","v":5206.08},{"$f":"SUM(F9:F13)","v":5310.2016000000003},{"$f":"SUM(G9:G13)","v":5416.405632},{"$f":"SUM(H9:H13)","v":5524.7337446399997},null,null,null,null,null,"Rental Price (per month):",1450]
[null,"Net Operating Income",null,{"$f":"D7-D14","v":11571},{"$f":"E7-E14","v":11802.42},{"$f":"F7-F14","v":12038.468399999998},{"$f":"G7-G14","v":12279.237767999997},{"$f":"H7-H14","v":12524.822523360001},null,null,null,null,null,"Other Income (per month):",0,null,null,"Accumulated Depreciation",{"$f":"SUM(D19:H19)","v":28374.545454545456},"need to automate to correspond to # of years"]
[null,"Less Annual Private Mortgage Ins.",null,{"$f":"$O$7*('Amortization Table'!$C$3-VLOOKUP(D$3,'Amortization Table'!$J:$N,5,FALSE))","v":0},{"$f":"$O$7*('Amortization Table'!$C$3-VLOOKUP(E$3,'Amortization Table'!$J:$N,5,FALSE))","v":0},{"$f":"$O$7*('Amortization Table'!$C$3-VLOOKUP(F$3,'Amortization Table'!$J:$N,5,FALSE))","v":0},{"$f":"$O$7*('Amortization Table'!$C$3-VLOOKUP(G$3,'Amortization Table'!$J:$N,5,FALSE))","v":0},{"$f":"$O$7*('Amortization Table'!$C$3-VLOOKUP(H$3,'Amortization Table'!$J:$N,5,FALSE))","v":0},null,null,null,null,null,"Vacancy (# of months out of the year):",0.5,null,null,"X Recapture Tax Rate",{"$f":"O27","v":0.25}]
[null,"Less Annual Debt Service",null,{"$f":"VLOOKUP(D$3,'Amortization Table'!$J:$M,4,FALSE)","v":11973.575610273725},{"$f":"VLOOKUP(E$3,'Amortization Table'!$J:$M,4,FALSE)","v":11973.575610273723},{"$f":"VLOOKUP(F$3,'Amortization Table'!$J:$M,4,FALSE)","v":11973.575610273723},{"$f":"VLOOKUP(G$3,'Amortization Table'!$J:$M,4,FALSE)","v":11973.575610273725},{"$f":"VLOOKUP(H$3,'Amortization Table'!$J:$M,4,FALSE)","v":11973.575610273723},null,null,null,null,null,"Property management fees (%):",0.08,null,null,"Recapture Taxes",{"$f":"S16*S15","v":7093.636363636364}]
[null,"Before Tax Cash Flow",null,{"$f":"D15-D16-D17","v":-402.57561027372503},{"$f":"E15-E16-E17","v":-171.15561027372314},{"$f":"F15-F16-F17","v":64.892789726274714},{"$f":"G15-G16-G17","v":305.6621577262722},{"$f":"H15-H16-H17","v":551.24691308627735},null,null,null,null,null,"Property Taxes (annual):",1300]
[null,"Less Annual Depreciation",null,{"$f":"((1-$O$9)*$O$5)/27.5","v":5674.909090909091},{"$f":"((1-$O$9)*$O$5)/27.5","v":5674.909090909091},{"$f":"((1-$O$9)*$O$5)/27.5","v":5674.909090909091},{"$f":"((1-$O$9)*$O$5)/27.5","v":5674.909090909091},{"$f":"((1-$O$9)*$O$5)/27.5","v":5674.909090909091},null,null,null,null,null,"Landlord insurance (annual):",850,null,null,"Before Tax Cash on Sale",{"$f":"S7","v":-9074.5478560429183}]
[null,"Plus Annual Principal Paid",null,{"$f":"VLOOKUP(D$3,'Amortization Table'!$J:$M,2,FALSE)","v":3680.5661454967985},{"$f":"VLOOKUP(E$3,'Amortization Table'!$J:$M,2,FALSE)","v":3830.51808908268},{"$f":"VLOOKUP(F$3,'Amortization Table'!$J:$M,2,FALSE)","v":3986.5793062140719},{"$f":"VLOOKUP(G$3,'Amortization Table'!$J:$M,2,FALSE)","v":4148.9986981213387},{"$f":"VLOOKUP(H$3,'Amortization Table'!$J:$M,2,FALSE)","v":4318.0353066550006},null,null,null,null,null,"HOA fees (monthly):",135,null,null,"Less Capital Gains Taxes",{"$f":"S13","v":1312.1509196774396}]
[null,"Taxable Income/ (Loss)",null,{"$f":"D18-D19+D20","v":-2396.9185556860175},{"$f":"E18-E19+E20","v":-2015.5466121001341},{"$f":"F18-F19+F20","v":-1623.4369949687443},{"$f":"G18-G19+G20","v":-1220.24823506148},{"$f":"H18-H19+H20","v":-805.62687116781308},null,null,null,null,null,"Repairs/maintenance (annual):",0,null,null,"Less Recapture Taxes",{"$f":"S17","v":7093.636363636364}]
[null,"Less Taxes Due",null,{"$f":"IF(D21<0,0,D21*$O$25)","v":0},{"$f":"IF(E21<0,0,E21*$O$25)","v":0},{"$f":"IF(F21<0,0,F21*$O$25)","v":0},{"$f":"IF(G21<0,0,G21*$O$25)","v":0},{"$f":"IF(H21<0,0,H21*$O$25)","v":0},null,null,null,null,null,null,null,null,null,"After Tax Cash on Sale",{"$f":"S19-S20-S21","v":-17480.335139356721}]
[null,"Tax Savings from PAL",null,{"$f":"IF(D22<0,D21*$O$25,0)","v":0},{"$f":"IF(E22<0,E21*$O$25,0)","v":0},{"$f":"IF(F22<0,F21*$O$25,0)","v":0},{"$f":"IF(G22<0,G21*$O$25,0)","v":0},{"$f":"IF(H22<0,H21*$O$25,0)","v":0}]
[null,"After Tax Cash Flow from Operations",null,{"$f":"D18+D22-D23","v":-402.57561027372503},{"$f":"E18+E22-E23","v":-171.15561027372314},{"$f":"F18+F22-F23","v":64.892789726274714},{"$f":"G18+G22-G23","v":305.6621577262722},{"$f":"H18+H22-H23","v":551.24691308627735},null,null,null,null,null,"Investor Info"]
[null,"Initial Equity Investment",null,0,0,0,0,0,null,null,null,null,null,"Marginal Tax Rate:",0.25]
[null,"After Tax Cash on Sale (Reversion)",{"$f":"-(O5*O6)-(O8*O5)","v":-39882},0,0,0,0,{"$f":"S22","v":-17480.335139356721},null,null,null,null,null,"Cost of Capital:",0.08]
[null,"Total After Tax Cash Flow",{"$f":"SUM(C24:C26)","v":-39882},-402.57561027372503,-171.15561027372314,64.892789726274714,305.6621577262722,-16929.088226270444,null,null,null,null,null,"Recapture Tax Rate:",0.25]
[]
[null,null,"Low","Medium","High"]
[null,"Payback Period",null,{"$f":"ROUND((ABS(C27)/ABS(D27)),1)&\" years\"","v":"99.1 years"},null,null,null,null,null,null,null,null,null,"Market Assumptions"]
[null,"Profit Margin",null,{"$f":"D27/D7","v":-2.4142465383731635E-2},null,null,null,null,null,null,null,null,null,"Rental Price Growth Rate:",0.02]
[null,"Default Ratio",null,{"$f":"(D14+D17)/D7","v":1.0241424653837317},null,null,null,null,null,null,null,null,null,"Operating Expenses Growth Rate:",0.02]
[null,"Operating Expense Ratio",null,{"$f":"D14/D7","v":0.30608695652173912}]
[null,"Debt-Coverage Ratio",null,{"$f":"D15/D17","v":0.96637799573184291},null,null,null,null,null,null,null,null,null,"Home Sales Info"]
[null,"Loan-to-Value Ratio",null,{"$f":"(O5-O8-(O5*O6))/O5","v":0.79999982698961936},null,null,null,null,null,null,null,null,null,"Appreciation Rate:",0.02]
[null,"EGI Multiplier",null,{"$f":"O5/D7","v":10.39880059970015},null,null,null,null,null,null,null,null,null," Selling Closing Costs:",0.06]
[null,"CAP Rate",null,{"$f":"D15/O5","v":6.6730103806228375E-2}]
[null,"BTCF Return",null,{"$f":"-D18/C26","v":-1.0094168052598291E-2}]
[null,"ATCF Return",null,{"$f":"-D24/C26","v":-1.0094168052598291E-2}]
[null,"NPV",null,{"$f":"NPV(O26,D27:H27)+C27","v":-51646.96173210616}]
[null,"IRR",null,{"$f":"IF(D40<0,\"n/a\",IRR(C27:H27))","v":"n/a"}]