{"text_format":"2","workbook":"xls","n_sheets":8,"sheets":["Rent Data","Single Unit","4 unit","Trial Est. Req. Ownership","Sheet2","Sheet1","template","Definitions"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":2,"defined_names":25,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"Rent Data","index":0,"n_rows":183,"n_cols":17,"rows_kept":183,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
[]
[null,"http://www.stlleasing.com/rental_property_listings.htm"]
[null,null,"Beds","Baths","Garage","basement","Age","Rent","school/comment","sq ft","comp low","comp high","Contact","Last Purchase","Purchase Year","Appraisal"]
["Fenton","From STLToday.com"]
[null,"Condo",2,2,null,null,null,675,"and up"]
[null,"745 Guibor",3,2,null,null,1923,775,"remodeled in 1988",{"$nulls":6},181500]
[null,"?",4,2,2,null,null,975]
[null,"128 Babs Ln",1,1,null,null,null,425]
[null,"apt",2,2,null,null,null,900]
[null,"141 & 30",3,1,null,null,null,725]
[null,"?",5,2,null,null,null,1050,"Lindbergh schools"]
[null,"5 room house",{"$nulls":5},595,null,1300]
[null,"?",{"$nulls":5},595,null,900]
[null,"82 E Lake",3,2,2,null,null,1250]
[null,"in San Luis Trails",3,1,2,null,null,900]
[null,"Jeffco NW",4,2,2,null,null,975,"Split foyer"]
[null,"split level house",2,1,2,null,null,825]
[null,"1636 Glen Mill - - Fenton , MO 63026",4,2.5,2,"yes",1989,1475,"Rockwood Summit School District",null,150000,200000,null,136300,1991,177500]
[null,"?",3,2,null,"partially finished",null,995,{"$nulls":4},"314-842-2225"]
[null,"?",3,2,null,null,null,950,"appl, fence, deck",null,null,null,"314-892-9098"]
[null,"?",3,2,"y","yes",null,975,{"$nulls":4},"636-225-4234 "]
[null,"241 Stillbrook Estates Dr",2,2,2,null,null,875,"fenced",null,null,null,"314-845-1914"]
[null,null,3,1,"y",null,null,950,"washer/dryer, no pets, fenced",null,null,null,"636-464-8885"]
[null,"1388 Little Brennan",3,2,2,null,null,975,"7/1/2 years old, no pets",null,null,null,"636-464-1880"]
[null,"?",3,1.5,2,null,null,675,"no pets",null,null,null,"636-938-5507"]
[null,"?",3,null,2,null,null,1000,"1 acre - Rockwood Schools",null,null,null,"314-781-7951"]
[null,"?",3,null,2,null,null,1100,"1 acre - Rockwood Schools",null,null,null,"314-781-7951"]
[null,"?",2,null,"big",null,null,800,"1.5 acre lot",null,null,null,"314-606-4506"]
[null,"1272 Meadow Trail",3,2,2,null,null,925,"7 years old",null,null,null,"636-464-1880"]
[null,"?",3,null,"y","yes",null,925,{"$nulls":4},"636-464-8885"]
[null,"FENTON - Northwest",3,1.5,"y","finished",null,850,"fenced",null,null,null,"314-374-8125"]
[]
[]
[]
["Ballwin",null,3,1,null,null,null,900]
[null,null,3,2,null,null,null,1750]
[null,"410 Woodland Hill",3,2,null,null,null,1200,"new crpt/pnt Pet friendly",null,null,null,"314-983-0788   mirowitzrealestate.com"]
[null,"697 Woorun ",3,{"$nulls":4},950]
[null,"condo",3,2.5,null,null,null,1100,"finished lower level"]
[null,"heart of ballwin'",3,null,2,null,null,895]
[null,"home in the woods'",2,{"$nulls":4},725]
[null,"1445-K Whispering Creek",2,2,null,null,null,875]
[null,"13375 Hiddendale lane (condo)",2,2.5,null,null,null,1150,"pool, tennis courts, applic"]
[null,"condo",2,2,null,null,null,650,"washer/dryer"]
["*good","279 Baxter",5,2.5,null,null,null,1495,"1 mi. N. of Manchester, 5 bdrm. 2½ ba. kit. w/brkfst. rm. den\nw/fplc. 2800 sq. ft. rec rm. in bsmnt. Parkway W. Schools Was 1550.  ",2500,null,null,"Paul,  636-405-0509",155000,2001,193500,"CAT TRACKS CO LLC "]
[null,null,3,2,2,"finished",null,1200]
[null,"524 Cherry Ridge Ct.",3,2,2,null,1977,1150,{"$nulls":5},85000,1987,119900]
[null,null,3,1,null,"y",null,900,"no pets"]
[null,"410 Woodland Hill",3,2,"y","y",1977,1200,"mirowitzrealestate.com , pet friendly\n",null,null,null,"314-983-0788",86000,1996,102000]
[null,"7 Amitie Lane",4,3,2,null,null,1550]
[null,null,2,2,1,null,null,1495,"fireplace, jacuzzi"]
[null,"condo",3,2.5,null,null,null,1100]
[null,"castlewood cottage",2,{"$nulls":4},725]
[null,"small house'",2,1,null,null,null,700,"(500 deposit)"]
[null,"13 Parkrose - - Ballwin , MO 63021",5,2.5,2,"finished",1969,1400,"Parkway West School District",2246,null,null,null,125000,1992,183200]
[null,"13375 Hiddendale Lane (Hidden Meadows Condos)",2,2.5,null,null,1977,1095,"appls., C/A, pool & tennis courts",null,null,null,"Efthim Co Rltrs 781-0010",83500,1999,89000]
[null,"condo, near Post Offc",2,1.5,1,null,null,625,"deck, 314-640-1069"]
[null,null,3,1,null,"y",null,900,"Rockwood Schools, no pets - 1 year lease",null,null,null,"636-227-1137 "]
[null,null,3,2,null,null,null,"??","Rockwood Schools. Subd pool. 1 or 2 year lease",null,null,null,"636-230-5524"]
[null,"Castlewood COTTAGE In The Woods",2,1,null,null,null,725,"pets ok",null,null,null,"314-993-1122"]
[null,"condo",3,2.5,2,null,null,1100,"wb fp, no pets",null,null,null,"Kevin Re/Max 314-517-7355"]
[null,null,2,2,1,null,null,895,"storqge, appls ground level",null,null,null,"Terry 636-299-3533"]
[null,"332 Cherry Hill",4,2,2,"full","lease/pur",1500,"updated kit., new flrs., full bsmt.",2000,null,null,"Mark Rubin 997-9176 Bellington Rlty "]
[null,null,4,2,2,"full",null,null,"updated kit, new flors, full bsmt",2000]
[null,"457 Oak Glen Dr.",4,{"$nulls":4},1600,{"$nulls":4},"314-576-2707 "]
[null,"Apt",2,{"$nulls":4},565,"Ceiling fans, blinds, W/D hook-ups, parking, close to Rec Center/Park"]
[null,null,3,2,2,null,null,1295,"2 story, frplc, cul de sac",null,null,null,"314-220-7993"]
[null,"$1095-$1475 homes",{"$nulls":6},"ELITE PROP. MGMT stlleasing.com",null,null,null,"636-926-2227"]
[null,"1072 PINRUN",4,2.5,null,null,null,1300,"2 story,, parkway west schools",null,null,null,"314-821-8532"]
[null,null,4,{"$nulls":4},1350,"fenced, walkout basement, remodeled",null,null,null,"Rmax 314-826-6688"]
[null,"2313 Barrett Pl. Cr",4,3.5,null,null,null,1350,"WEST END LEASING ",null,null,null,"994-7440 & 994-7207"]
[null,"1208 Castle Manor",4,2.5,null,null,null,1850,"WEST END LEASING ",null,null,null,"994-7440 & 994-7207"]
[null,"369 Messina",3,2,null,null,null,1200,"WEST END LEASING",null,null,null,"994-7440 & 994-7207"]
[null,"1024 Big Bend Crossing",3,2.5,null,null,null,2000,"WEST END LEASING",null,null,null,"994-7440 & 994-7207"]
[null,"1210 Carmen",4,2.5,null,null,null,2200,"WEST END LEASING",null,null,null,"994-7440 & 994-7207"]
[]
[null,"240 Geremma",4,2,2,null,null,1300,{"$nulls":4},"314-822-4809"]
[null,"285 Village Creek Drive",3,2,2,"finished",null,1200,"ranch, fenced - Barry Upchurch Realty",null,null,null,"314-878-1900"]
[null,null,3,1,1,null,null,890,"fenced",null,null,null,"636-458-1523 "]
[null,"480 Manorcrest by Henry/Clayton",3,2,null,null,null,1300,{"$nulls":4},"314-713-2438 "]
[null,"533 LEMONWOOD",3,{"$nulls":4},950,{"$nulls":4},"314-871-1650"]
[null,"#2 Silvercreek",4,2,2,"finished",null,1500,"cul-de-sac",null,null,null,"314-565-2318"]
[null,null,3,2,{"$nulls":4},"subdivision pool",null,null,null,"636-230-5524"]
[null,null,4,{"$nulls":4},1200,"2 stpry, parkway south, ",null,null,null,"314-576-2707"]
[null,null,2,2,"carport",null,null,795,{"$nulls":4},"314-409-3578"]
[null,"8 Morena Ct",4,2,2,"partial, non finshed",null,1475,"fireplace",null,null,null,"http://www.stlleasing.com",null,null,null,"LEPKOWSKI MAREK B TRUSTEE "]
[null,"within a 1/4 mile of Big Bend and Sulphur Springs ",3,2,2,"partal",null,1200,null,1100,null,null,"http://www.stlleasing.com"]
[null,"232 Creve Coeur",3,2,"2 - detached","partial",null,1095,{"$nulls":4},"http://www.stlleasing.com",null,"636-926-2227"]
[null,"608 Clear Spring Dr",2,{"$nulls":4},850,{"$nulls":4},"636-230-0223"]
[null,"5 room",2,null,"y","y",null,1075,"ranch",null,null,null,"314-966-2400"]
[null,"140 Old Ballwin Rd.",2,1,null,null,null,650,"hdwd. Flrs,Leonmarie, Bellington Rlty 725-3329",null,null,null,"568-1029"]
[null,"232 Creve Coeur",3,{"$nulls":5},"ELITE PROP. MGMT  stlleasing.com",null,null,null,"636-926-2227"]
[null,"8 Morena",4,{"$nulls":5},"ELITE PROP. MGMT  stlleasing.com",null,null,null,"636-926-2227"]
[null,"822 Dutchmill",4,2,2,"full'",null,1450,{"$nulls":4},"314-569-3999"]
[null,"?",3,2,null,null,null,1150,"clean, updated, cul-de-sac. No Pets",null,null,null,"636-346-4766"]
[null,"?",3,2,null,null,null,1200,"lease purchase available",null,null,null,"314-360-8933"]
[null,"Lock Dr",2,{"$nulls":4},975," large trees, quiet neighborhood, gar., bsmnt, spacious lot",null,null,null,"314-966-2400"]
[null,"Sulphur Spring Rd",3,2,2,null,null,1050,"c/a, lge. yd., appls., Pkwy. Schls",null,null,null,"314-822-5277"]
[]
[]
[]
[]
["ellisville","906 Prince Charles way",3,2,null,null,null,1200,null,1315,null,null,null,"no data"]
[null,"417 Parkview Place",2,1.5,null,null,null,995]
[null,"Castlewood Cottage in the woods",2,{"$nulls":4},725]
[null,null,4,2,null,null,null,1275]
[null,null,2,{"$nulls":4},550,{"$nulls":4},"(636)394-8509"]
[null,null,3,2,2,"y",null,1050,"all appliances, across from school, pets ok",null,null,null,"(636)527-6922"]
[null,null,3,2,null,null,null,1450,"Rockwood Schl Dist",null,null,null,"(314)220-8184"]
[]
[]
[]
["manchester","523 Sulpher Springs",3,1.5,null,null,null,850,"advantagepropertiesllc.com"]
[null,"815 Boleyn",3,2,null,null,1973,1100,{"$nulls":7},129400]
["*good example","1312 Wyncrest",3,2.5,null,null,null,1250,"WEST END REALTY ",null,null,null,"994-7440 & 994-7207",145200,2001,123200]
[null,"310 Spring Meadows Dr",3,2,null,null,null,1000]
[null,"1115 Burgundy",3,1.5,"y","finsihed",1965,895,"Parkway W",null,null,null,"636-394-2313 ",105000,1998,99800]
[null,null,4,2.5,2,null,null,1395,"Parkway South Schools",null,null,null,"Terry 636-299-3533"]
[null,"516 Ranch",4,2,{"$nulls":4},"Cathy @ C21 Fortune Rlty 692-2028",null,null,null,"517-4145"]
[null,null,3,null,null,"finished",null,995,{"$nulls":4},"314-991-5747"]
[null,null,3,2,null,null,null,1450,"Rockwood School Dist",null,null,null,"314-220-8184"]
[null,null,3,2.5,null,null,null,1250,"walk to pool, tennis, park; talk to BOB",null,null,null,"314-807-6600"]
[]
[]
["CrestWood","958 Sanders",2,1,null,null,null,775]
[null,null,3,1.5,null,null,null,800]
[null,null,3,{"$nulls":4},900]
[null,"673 Canover",3,2,null,null,null,900]
[null,"920 Grovena",4,1,2,null,null,1150,{"$nulls":5},115000,2001]
[null,"9536 Arban",2,1,null,null,null,900]
[null,null,3,2,2,null,null,1150]
[null,null,3,{"$nulls":4},950]
[null,null,3,2,null,null,null,900]
[null,"614 Attucks",3,2,null,null,null,1200,{"$nulls":5},109000,1999]
[null,"9146 Saddlebrook",4,2,2,null,null,1595,"www.decarealty.com ",null,null,null,"314-631-3306",205300,"appraisal","BOMAN JOAN DOROTHY TRUSTEE ETAL"]
[null,"217 Deane Ct.",3,2,null,"finished","1950s",825,"freshly painted",null,null,null,"314-842-3963"]
[null,null,3,1,null,null,null,950,"nice yard, nice yard",null,null,null,"314-680-8658, 314/842-1313"]
[null,"654 Clover",3,1,"y",null,1949,800,"frplc, garage, x-lg. Lot",null,null,null,"636-677-8736"]
[null,"615 Acorn",3,null,null,null,1956,"1075 900","Call Sandy Hancock, Remax Results ",null,null,null,"314-966-2929 ",81000,1996]
[null,"9310 Queenston",2,2,null,null,1960,975,"appliances, near grants farm",null,null,null,"314-962-2555",null,null,12000]
[null,null,3,1.5,2,null,null,1190,"everything new",null,null,null,"636-305-1999"]
[null,"970 Woodbine",2,{"$nulls":5},"frplc, fenced",null,null,null,"965-6477"]
[null,"?",3,null,"y",null,null,950,"small pets",null,null,null,"314-680-8658 / 314-842-1313"]
[null,"?",3,1,"finished",null,null,925,"fenced",null,null,null,"314-258-1593"]
[]
[]
["Eureka/Pacific"]
[null,"509 Rockwood Parc Ct",3,2,2,null,null,1300,{"$nulls":5},124815,1994,154900]
[null,"704 Cerny Eureka",3,2,2,null,1976,"1300, 1200","ranch(nice) probably150-170",null,null,null,"314-276-0398 ",92900,1997,127500]
[null,"nice' in eureka",3,1,null,null,null,850]
[null,"Duplex",2,{"$nulls":4},450,"front & back porches, util. rm., yard",null,null,null,"636-257-6056"]
[null,null,3,2,"y","full",null,1100,"3 yrs. old, all elec. Rockwood Dist. Conv.to I-44",null,null,null,"636-938-6689"]
[null,null,3,2,2,"finished",null,750,"non smoker",null,null,null,"636-257-4101 "]
[null,null,3,1.5,{"$nulls":4},"2 Story 30x30 gar. Rockwood Schools. Scenic view. Private- On 9 acres. Appls",null,null,null,"636-458-9380"]
[null,null,3,1,null,null,null,550,"Mr. V",null,null,null,"314-389-7127"]
[null,"2BR. Mobile",2,{"$nulls":4},450,{"$nulls":4},"636-587-2607"]
[null,null,1,{"$nulls":4},465,"Lge 2 BR with lndry, large yard",null,null,null,"636-271-8320"]
[null,"?",2,1,null,null,null,850,"carport, cute dollhouse on 1 ac. no pets",null,null,null,"314-753-1100"]
[null,"731 Top Notch",3,2.5,2,null,null,1390,{"$nulls":4},"636-938-5764"]
[null,"?",3,1,1,null,null,750,"no pets",null,null,null,"314-971-4568"]
[]
[]
["WILDWOOD"]
[null,null,3,2,"4 car",null,null,"1295-1495"]
[null,"2614 East Avenue",2,1,null,null,null,850,{"$nulls":4},"636-451-2725"]
[null,"16231 Waterfront Way",3,2,null,null,null,"1450,1,195","WEST END REALTY ",null,null,null,"994-7440 & 994-7207"]
[null,"2614 East Avenue",2,1,null,null,null,875,{"$nulls":4},"636-451-2725"]
[null,"16938 Manchester Rd",4,1,2,null,null,1000,"new carpet & flooring",null,null,null,"636-451-2727"]
[]
["OTHER"]
["condo","2037 Trailcrest #5 - - - Kirkwood, MO 63122 ",2,2,null,null,null,1295,"Kirkwood School District",1628]
[null,"1140 Birdie Hills - - St. Peters , MO 63376",4,2,2,"finished","5-10+",1200,"Fort Zumwalt School District"]
[null,"219 Lancaster - - Clayton , MO 63105",2,1.5,1,"partial",null,1195,"Clayton School District"]
[null,"924 Windsor - - Webster Groves , MO 63119",2,1,"1-detach","partial",null,1100,"Webster Groves School District"]
[null,"1110 Sunny Ridge - - O'Fallon , MO 63366",3,2,2,"unfinished","newer"]
[null,"309 Clark - -Webster Groves , MO 63119",3,1.5,"1-detach",null,"old",975,"Webster Groves School District"]
[null,"12533 Glenbush - - Maryland Heights , MO 63043",3,2," car carport","unfinished","old",950,"Parkway North School District"]
[null,"12925 Fernway - - Creve Couer , MO 63141",3,2," car carport",null,"old",895,"Parkway North School District"]
["condo","1440 Heritage #302 - - - St. Charles, MO 63303",3,2,0,null,null,850,"Francis Howell South School District"]
[null,"1975 Forest Haven  - - - Imperial, MO 63052",3,2,1,null,null,850,"Imperial School District"]
[null,"3119 Persimmon - - St. Charles , MO 63301",3,2,2,"unfinished",null,825,"Orchard Farm School District"]
[null,"2572 Seascape - - Florissant , MO 63031",3,2,2,"partial","old",775,"Hazelwood Central School District"]
[null,"502  Mason - - - Webster Groves, MO ",1,1,"?",null,"old",575,"Webster Groves School District"]

{"sheet":"Single Unit","index":1,"n_rows":133,"n_cols":25,"rows_kept":133,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
["Basic",{"$nulls":12},"Yearly appreciation",null,0.02,null,"Sales Commision",0.07]
["rate",null,null,0.06,{"$nulls":9},"Yearly Tax Increase",null,0.02,null,"Sales Fees",1000]
["Purchase/Sale Price",null,null,112000,{"$nulls":6},"Net Valu. Increase","Net Val. Inc. + income",null,"Yearly Rent Increase",null,0.04,null,"Yearly Ins. Increase",0.02,null,null,null,"Yearly Income","Tot. Income To Date","Internal Rate of return"]
["% Down",null,null,0.2,null,"Year","Prop Val","Equity","Sales Cost","net sale (Val-Sales)","orig Puch-net sale",null,null,"Mortgage","Insurance","Maint","Tax","Unit1",null,"Unit2","Unit3","Unit4",-24400,-24400]
["Loan",null,null,89600,null,1,112000,1100.2984941999896,8840,103160,-8840,-1422.3672464424635,null,6446.3672464424635,560,0,1176,14400,1200,0,0,0,7417.6327535575365,7417.6327535575365,{"$error":"#NUM!"}]
["Years",null,null,30,null,2,114240,2268.460991920038,8996.800000000001,105243.2,-6756.800000000003,8678.94550711507,null,6446.3672464424635,560,0,1199.52,14976,1248,0,0,0,8018.112753557536,15435.745507115073,-0.25494335973879106]
["Months",null,null,360,null,3,116524.8,3508.6731964016267,9156.736,107368.064,-4631.9360000000015,19446.891860672607,null,6446.3672464424635,560,0,1223.5104,15575.04,1297.92,0,0,0,8643.082353557536,24078.82786067261,-0.006433164227123668]
["Pmt",null,null,537.197270536872,"monthly",4,118855.29599999999,4825.378975903286,9319.87072,109535.42527999998,-2464.5747200000187,30907.783686230126,null,6446.3672464424635,560,0,1247.9806079999998,16198.041600000002,1349.8368000000003,0,0,0,9293.530545557538,33372.358406230145,0.13253220219163567]
["Ins.",null,null,560,"yearly",5,121232.40192,6223.296286753948,9486.268134400001,111746.1337856,-253.86621439999726,43088.97826122768,null,6446.3672464424635,560,0,1272.9402201599999,16845.963264,1403.8302720000002,0,0,0,9970.486069397537,43342.84447562768,0.21473903499890687]
["PMI",null,null,0,null,6,123657.0499584,7707.434078505386,9655.993497088,114001.05646131201,2001.0564613120077,56018.91994337403,null,6446.3672464424635,560,0,1298.3990245631999,17519.801794560004,1459.9834828800003,0,0,0,10675.019006434342,54017.86348206202,0.26596277933191365]
["Tax",null,null,1176,"yearly",7,126130.190957568,9283.110241757464,9829.11336702976,116301.07759053825,4301.077590538247,69727.18350964095,null,6446.3672464424635,560,0,1324.3670050544638,18220.593866342406,1518.3828221952006,0,0,0,11408.242437040677,65426.1059191027,0.2992372637394919]
["Initial Investment",{"$nulls":4},8,128652.79477671934,10955.970662965981,10005.695634370355,118647.09914234899,6647.09914234899,84244.51922593279,null,6446.3672464424635,560,0,1350.8543451555531,18949.417620996104,1579.1181350830086,0,0,0,12171.314164481097,77597.4200835838,0.3215693212117504]
["Down",null,null,22400,null,9,131225.85067225373,12732.009454509367,10185.809547057761,121040.04112519597,9040.041125195974,99602.89971660092,null,6446.3672464424635,560,0,1377.8714320586641,19707.39432583595,1642.2828604863291,0,0,0,12965.43850782115,90562.85859140495,0.3369468151106954]
["Fees",null,null,2000,null,10,133850.36768569882,14617.590432501616,10369.525737998918,123480.8419476999,11480.841947699897,115835.5687057377,null,6446.3672464424635,560,0,1405.4288606998375,20495.69009886939,1707.9741749057823,0,0,0,13791.86816663287,104354.72675803781,0.3477525354176044]
["=",null,null,24400]
[]
["Pmt with Insure/Tax",null,null,733.197270536872,"monthly",{"$nulls":8},64463.67246442463,5600,0,12876.871895691718,172887.94257060386,null,0,0,0,104354.72675803781]
[{"$nulls":5},"Effect of Rent Increases:"]
[null,"Year 1",null,null,null,2,3,4,5,6,7,8,9,10,11]
["Income"]
["Unit1",null,null,1200,"monthly",1248,1297.92,1349.8368,1403.8302720000002,1459.98348288,1518.3828221952,1579.1181350830082,1642.2828604863284,1707.9741749057816,1776.293141902013]
["Unit2",null,null,0,"monthly",0,0,0,0,0,0,0,0,0,0]
["Unit3",null,null,0,"monthly",0,0,0,0,0,0,0,0,0,0]
["Unit4",null,null,0,null,0,0,0,0,0,0,0,0,0,0]
[]
["Tot Income",null,null,1200,"monthly",1248,1297.92,1349.8368,1403.8302720000002,1459.98348288,1518.3828221952,1579.1181350830082,1642.2828604863284,1707.9741749057816,1776.293141902013]
["Gross Scheduled Rental Income",null,null,14400,"yearly",14976,15575.04,16198.0416,16845.963264,17519.80179456,18220.593866342402,18949.417620996097,19707.394325835943,20495.69009886938,21315.517702824156]
["Ratio: Rent To Payment",null,null,1.6366673039048811]
["Vacancy Rate and Credit Losses",null,null,0.1,null,0.1,0.1,0.1,0.1,0.1,0.1,0.1,0.1,0.1,0.1]
[null,null,null,1440,"yearly",1497.6000000000001,1557.5040000000001,1619.8041600000001,1684.5963264000002,1751.980179456,1822.0593866342404,1894.9417620996098,1970.7394325835944,2049.569009886938,2131.551770282416]
["Gross Operating Income(GOI)",null,null,12960,"yearly",13478.4,14017.536,14578.23744,15161.366937600002,15767.821615104,16398.534479708163,17054.475858896487,17736.654893252347,18446.121088982443,19183.96593254174]
[]
["Operating Expenses (all yearly)"]
["Accounting and Legal",null,0.0216,279.93600000000004,"yearly",291.13344,302.7787776,314.88992870400006,327.48552585216004,340.5849468862464,354.20834476169637,368.37667855216415,383.1117456942507,398.4362155220208,414.37366414290165]
["Advertising, License, Permits",null,0.02,259.2,"yearly",269.568,280.35072,291.5647488,303.22733875200004,315.35643230208,327.9706895941633,341.08951717792974,354.73309786504694,368.92242177964886,383.67931865083483]
["Property Insurance",null,0.005,560,"yearly",571.2,582.624,594.27648,606.1620096,618.2852497920001,630.6509547878401,643.2639738835969,656.1292533612689,669.2518384284942,682.6368751970641]
["Property Management",null,0,0,"yearly",0,0,0,0,0,0,0,0,0,0]
["Paroll-Resident Mgr/mo",null,0,0,"yearly",0,0,0,0,0,0,0,0,0,0]
[null,"Other",null,0,"yearly",0,0,0,0,0,0,0,0,0,0]
[null,"Taxes-Wrkmn Comp",null,0,"yearly",0,0,0,0,0,0,0,0,0,0]
["Personal Property Taxes",null,null,0,"yearly",0,0,0,0,0,0,0,0,0,0]
["Real EstateTaxes",null,0.0105,1176,"yearly",1199.52,1223.5104,1247.9806079999998,1272.9402201599999,1298.3990245631999,1324.3670050544638,1350.8543451555531,1377.8714320586641,1405.4288606998375,1433.5374379138343]
["Repairs and Maintenance",null,0.05,648,"yearly",673.9200000000001,700.8768,728.9118720000001,758.0683468800001,788.3910807552,819.9267239854082,852.7237929448244,886.8327446626174,922.3060544491223,959.1982966270871]
["Services","Elevator",null,0,"yearly",0,0,0,0,0,0,0,0,0,0]
[null,"Janitorial",null,0,"yearly",0,0,0,0,0,0,0,0,0,0]
[null,"Lawn",null,0,"yearly",0,0,0,0,0,0,0,0,0,0]
[null,"Pool",null,0,"yearly",0,0,0,0,0,0,0,0,0,0]
[null,"Rubbish",null,0,"yearly",0,0,0,0,0,0,0,0,0,0]
[null,"Other",null,0,"yearly",0,0,0,0,0,0,0,0,0,0]
["Supplies",null,0.01,129.6,"yearly",134.784,140.17536,145.7823744,151.61366937600002,157.67821615104,163.98534479708164,170.54475858896487,177.36654893252347,184.46121088982443,191.83965932541741]
["Utilities","Electricity",0,0,"yearly",0,0,0,0,0,0,0,0,0,0]
[null,"Gas & Oil",null,0,"yearly",0,0,0,0,0,0,0,0,0,0]
[null,"Sewer & Water",null,0,"yearly",0,0,0,0,0,0,0,0,0,0]
[null,"Telephone",null,0,"yearly",0,0,0,0,0,0,0,0,0,0]
[null,"Other",null,0,"yearly",0,0,0,0,0,0,0,0,0,0]
["Miscellaneous",null,0.0403,522.288,"yearly",543.17952,564.9067008000001,587.5029688320001,611.0030875852801,635.4432110886912,660.8609395322391,687.2953771135285,714.7871921980696,743.3786798859925,773.1138270814322]
["Total Operating Expense",null,null,3575.024,"yearly",3683.3049600000004,3795.2227584,3910.9089807360006,4030.500198205441,4154.138161538458,4281.970002512892,4414.148443416561,4550.832014772442,4692.185281654941,4838.379078938571]
[]
["Net Operating Income (NOI)",null,null,9384.976,null,9795.09504,10222.3132416,10667.328459264001,11130.866739394562,11613.683453565542,12116.564477195272,12640.327415479926,13185.822878479907,13753.935807327503,14345.58685360317]
["Total Annual Debt Service",null,null,6446.3672464424635,null,6446.3672464424635,6446.3672464424635,6446.3672464424635,6446.3672464424635,6446.3672464424635,6446.3672464424635,6446.3672464424635,6446.3672464424635,6446.3672464424635,6446.3672464424635]
["Annual Cash Flow Before Taxes",null,null,2938.608753557537,null,3348.7277935575366,3775.9459951575373,4220.961212821538,4684.499492952098,5167.316207123078,5670.1972307528085,6193.960169037462,6739.455632037443,7307.56856088504,7899.219607160707]
[null,"Monthly",null,244.88406279646142,null,279.0606494631281,314.6621662631281,351.7467677351281,390.3749577460082,430.6096839269232,472.5164358960674,516.1633474197885,561.6213026697869,608.96404674042,658.2683005967256]
["Cap Rate. (stay > 6%)",null,null,0.08379442857142858,null,0.08745620571428571,0.09127065394285715,0.09524400410057143,0.0993827387445943,0.10369360226397804,0.10818361140352921,0.11286006620964219,0.11773056141499917,0.12280299827970985,0.12808559690717117]
["Cash on Cash Return (stay > 8-9%)",null,null,0.12043478498186627,null,0.13724294235891543,0.15475188504744006,0.17299021364022696,0.19198768413738107,0.21177525439029007,0.23238513240790198,0.253850826599896,0.2762071980343214,0.2994905147903705,0.3237385084901929]
[]
["Gross Rent Multiplier (stay under 5/6)",null,null,8.641975308641975,null,8.309591642924977,7.9899919643509385,7.682684581106671,7.387196712602568,7.103073762117855,6.829878617421013,6.567190978289436,6.314606709893689,6.071737221051623,5.838208866395791]
["Debt Coverage Ratio (stay over 1.2)",null,null,1.4558550019282965,null,1.5194751812201808,1.5857478872680355,1.6547813755337855,1.726688274785666,1.8015857628922318,1.8795957496653641,1.9608450670345694,2.0454656668461957,2.1335948265928915,2.225375363390912]
[]
["Cash Inflow",null,null,1200,"monthly",1248,1297.92,1349.8368,1403.8302720000002,1459.98348288,1518.3828221952,1579.1181350830082,1642.2828604863284,1707.9741749057816,1776.293141902013]
[null,null,null,14400,"yearly",14976,15575.04,16198.0416,16845.963264,17519.80179456,18220.593866342402,18949.417620996097,19707.394325835943,20495.69009886938,21315.517702824156]
["Depreciation/Tax View"]
["Est. Depreciable Amount",null,0.75,84000,null,84000,84000,84000,84000,84000,84000,84000,84000,84000,84000]
["Est. Yearly Depreciation",null,27.5,3054.5454545454545,null,3054.5454545454545,3054.5454545454545,3054.5454545454545,3054.5454545454545,3054.5454545454545,3054.5454545454545,3054.5454545454545,3054.5454545454545,3054.5454545454545,3054.5454545454545]
["Mortgage Interest Paid",null,null,5346.068752242452,null,5212.325251933398,5136.212241963178,5055.404748083572,4969.613224799219,4878.530268082165,4781.829513896653,4679.164468787333,4570.167268340702,4454.447359071165,4331.590099008725]
["Operating Expenses (from above)(no edit)",null,null,3575.024,null,3683.3049600000004,3795.2227584,3910.9089807360006,4030.500198205441,4154.138161538458,4281.970002512892,4414.148443416561,4550.832014772442,4692.185281654941,4838.379078938571]
["Tax Loss or Gain",null,null,-9037.029453230369,null,-8601.447872921315,-8210.034459751096,-7799.897970543489,-7370.159384598017,-6919.897677043,-6448.147740202192,-5953.898197711887,-5436.089105621155,-4893.60953438652,-4325.295025332043]
["Tax Loss or Due",null,0.27,-2439.9979523721995,null,-2322.390925688755,-2216.709304132796,-2105.972452046742,-1989.9430338414647,-1868.37237280161,-1740.9998898545919,-1607.5525133822098,-1467.744058517712,-1321.2745742843604,-1167.8296568396518]
["Cash + Tax/Depreciation Advantage",null,null,5378.606705929737,null,5671.118719246291,5992.6552992903335,6326.93366486828,6674.442526793563,7035.688579924688,7411.1971206074,7801.512682419672,8207.199690555155,8628.8431351694,9067.049264000358]
["'Derived' Cash on Cash Return",null,null,0.2204347010626941,null,0.23242289832976604,0.24560062702009564,0.25930056003558527,0.27354272650793293,0.28834789261986427,0.30373758691013936,0.3197341263286751,0.33636064305553914,0.3536411120971065,0.3716003796721458]
["Projected home appreciation value",null,null,114240,null,116524.8,118855.296,121232.40192,123657.0499584,126130.190957568,128652.79477671937,131225.85067225376,133850.36768569885,136527.37503941281,139257.92254020108]
["Projected appreciation delta",null,0.02,2240,null,2284.800000000003,2330.495999999999,2377.105920000002,2424.6480384000024,2473.1409991679975,2522.6038191513653,2573.0558955343877,2624.517013445089,2677.0073537139688,2730.5475007882633]
["Projected total 'return' (w/ appreciation)",null,null,0.3122379797512187,null,0.32606224259206124,0.34111275816763664,0.3567229338060771,0.3729135477538346,0.38970613029068385,0.4071229893343757,0.4251872368013959,0.4439228157377149,0.46335452823292494,0.4835080641306812]
{"$rows_empty":41}
[null,null,null,"Cash flow analysis"]
[]
[]
[null,null,null,"include depreciation?"]
[]
[]
[null,null,null,"rent roll"]
[]
[]
[null,null,null,"operating expenses"]

{"sheet":"4 unit","index":2,"n_rows":140,"n_cols":25,"rows_kept":140,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
["Basic",{"$nulls":12},"Yearly appreciation",null,0.02,null,"Sales Commision",0.07]
["rate",null,null,0.07,{"$nulls":9},"Yearly Tax Increase",null,0.02,null,"Sales Fees",1000]
["Purchase/Sale Price",null,null,190000,{"$nulls":6},"Net Valu. Increase","Net Val. Inc. + income",null,"Yearly Rent Increase",null,0.02,{"$nulls":6},"Yearly Income","Tot. Income To Date","Internal Rate of return"]
["% Down",null,null,0.2,null,"Year","Prop Val","Equity","Sales Cost","net sale (Val-Sales)","orig Puch-net sale",null,null,"Mortgage","Insurance","Maint","Tax","Unit1",null,"Unit2","Unit3","Unit4",-40000,-40000]
["Loan",null,null,152000,null,1,190000,1544.030940528441,14300.000000000002,175700,-14300,-6020.117512068293,null,12135.117512068293,2090,0,1995.0000000000002,6000,500,6000,6000,6000,8279.882487931707,8279.882487931707,{"$error":"#NUM!"}]
["Years",null,null,30,null,2,193800,3199.6800025922144,14566.000000000002,179234,-10766,6243.864975863413,null,12135.117512068293,2090,0,2034.9000000000003,6120,510,6120,6120,6120,8729.982487931708,17009.864975863413,-0.4180022440969209]
["Months",null,null,360,null,3,197676,4975.016069222129,14837.320000000002,182838.68,-7161.320000000007,19037.629463795114,null,12135.117512068293,2090,0,2075.5980000000004,6242.400000000001,520.2,6242.400000000001,6242.400000000001,6242.400000000001,9189.08448793171,26198.94946379512,-0.18240113554478163]
["Pmt",null,null,1011.2597926723577,"monthly",4,201629.52,6878.691323655709,15114.0664,186515.45359999998,-3484.546400000021,32371.771591726807,null,12135.117512068293,2090,0,2117.1099600000007,6367.2480000000005,530.604,6367.2480000000005,6367.2480000000005,6367.2480000000005,9657.368527931707,35856.31799172683,-0.04134012094335849]
["Ins.",null,null,2090,"yearly",5,205662.1104,8919.983416156312,15396.347728000002,190265.762672,265.76267200001166,46257.09891245855,null,12135.117512068293,2090,0,2159.4521592000006,6494.592960000001,541.21608,6494.592960000001,6494.592960000001,6494.592960000001,10135.01824873171,45991.336240458535,0.046742196711067024]
["PMI",null,null,0,null,6,209775.35260800002,11108.840679074976,15684.274682560002,194091.07792544,4091.0779254400113,60704.635129846254,null,12135.117512068293,2090,0,2202.6412023840007,6624.484819200001,552.0404016000001,6624.484819200001,6624.484819200001,6624.484819200001,10622.220963947704,56613.55720440624,0.10432376779849752]
["Tax",null,null,1995.0000000000002,"yearly",7,213970.85966016003,13455.930610512789,15977.960176211203,197992.89948394883,7992.89948394883,75725.6244218231,null,12135.117512068293,2090,0,2246.694026431681,6756.974515584001,563.0812096320001,6756.974515584001,6756.974515584001,6756.974515584001,11119.167733468032,67732.72493787427,0.14346282813627514]
["Initial Investment",{"$nulls":4},8,218250.27685336323,15972.6918628711,16277.519379735428,201972.7574736278,11972.757473627804,91331.53584988083,null,12135.117512068293,2090,0,2291.6279069603147,6892.114005895681,574.34283382464,6892.114005895681,6892.114005895681,6892.114005895681,11626.053438378756,79358.77837625303,0.1709250030434967]
["Down",null,null,38000,null,9,222615.2823904305,18671.38998965823,16583.069767330137,206032.21262310038,16032.212623100379,107534.06785674111,null,12135.117512068293,2090,0,2337.460465099521,7029.956286013595,585.8296905011329,7029.956286013595,7029.956286013595,7029.956286013595,12143.0768573877,91501.85523364073,0.1906971791109403]
["Fees",null,null,2000,null,10,227067.58803823913,21565.17722223738,16894.73116267674,210172.8568755624,20172.8568755624,124345.15285397996,null,12135.117512068293,2090,0,2384.2096744015116,7170.555411733867,597.5462843111555,7170.555411733867,7170.555411733867,7170.555411733867,12670.440744776824,104172.29597841756,0.2052352845599451]
["Tot Initial Investment",null,null,40000,null,11,231608.9397990039,24668.156567840426,17212.625785930275,214396.31401307363,24396.31401307363,141776.9619014049,null,12135.117512068293,2090,0,2431.893867889542,7313.966519968544,609.4972099973787,7313.966519968544,7313.966519968544,7313.966519968544,13208.35190991372,117380.64788833128,0.21611135817141716]
[]
["Pmt with Insure/Tax",null,null,1343.7597926723577,"monthly",{"$nulls":8},133486.2926327512,22990,0,24276.58726236657,73012.29251839568,null,73012.29251839568,73012.29251839568,73012.29251839568,117380.64788833128]
[{"$nulls":5},"Effect of Rent Increases:"]
[null,"Year 1",null,null,null,2,3,4,5,6,7,8,9,10,11]
["Income"]
["Unit1",null,null,500,"monthly",510,520.2,530.604,541.21608,552.0404016,563.081209632,574.34283382464,585.8296905011329,597.5462843111555,609.4972099973787]
["Unit2",null,null,500,"monthly",510,520.2,530.604,541.21608,552.0404016,563.081209632,574.34283382464,585.8296905011329,597.5462843111555,609.4972099973787]
["Unit3",null,null,500,"monthly",510,520.2,530.604,541.21608,552.0404016,563.081209632,574.34283382464,585.8296905011329,597.5462843111555,609.4972099973787]
["Unit4",null,null,500,null,510,520.2,530.604,541.21608,552.0404016,563.081209632,574.34283382464,585.8296905011329,597.5462843111555,609.4972099973787]
["Unit5",{"$nulls":4},0,0,0,0,0,0,0,0,0,0]
["Unit6",{"$nulls":4},0,0,0,0,0,0,0,0,0,0]
[]
["Tot Income",null,null,2000,"monthly",2040,2080.8,2122.416,2164.86432,2208.1616064,2252.324838528,2297.37133529856,2343.3187620045314,2390.185137244622,2437.988839989515]
["Gross Scheduled Rental Income",null,null,24000,"yearly",24480,24969.600000000002,25468.992000000002,25978.37184,26497.9392768,27027.898062335997,27568.456023582723,28119.825144054375,28682.221646935468,29255.866079874177]
[]
["Vacancy Rate and Credit Losses",null,null,0.1,null,0.1,0.1,0.1,0.1,0.1,0.1,0.1,0.1,0.1,0.1]
[null,null,null,2400,"yearly",2448,2496.9600000000005,2546.8992000000003,2597.837184,2649.7939276800003,2702.7898062336,2756.8456023582726,2811.9825144054375,2868.222164693547,2925.5866079874177]
["Gross Operating Income(GOI)",null,null,21600,"yearly",22032,22472.640000000003,22922.092800000002,23380.534656,23848.14534912,24325.108256102398,24811.61042122445,25307.842629648938,25813.99948224192,26330.27947188676]
[]
["Operating Expenses (all yearly)"]
["Accounting and Legal",null,0.0216,466.56,"yearly",475.8912,485.4090240000001,495.11720448000005,505.01954856960003,515.119939540992,525.4223383318118,535.9307850984482,546.6494008004171,557.5823888164256,568.734036592754]
["Advertising, License, Permits",null,0.02,432,"yearly",440.64,449.4528000000001,458.44185600000003,467.61069312,476.9629069824,486.502165122048,496.232208424489,506.1568525929788,516.2799896448385,526.6055894377351]
["Property Insurance","was 0.5%",0.011,2090,"yearly",2131.8,2174.436,2217.92472,2262.2832144,2307.528878688,2353.67945626176,2400.7530453869954,2448.7681062947354,2497.74346842063,2547.698337789043]
["Property Management",null,0,0,"yearly",0,0,0,0,0,0,0,0,0,0]
["Paroll-Resident Mgr/mo",null,0,0,"yearly",0,0,0,0,0,0,0,0,0,0]
[null,"Other",null,0,"yearly",0,0,0,0,0,0,0,0,0,0]
[null,"Taxes-Wrkmn Comp",null,0,"yearly",0,0,0,0,0,0,0,0,0,0]
["Personal Property Taxes",null,null,0,"yearly",0,0,0,0,0,0,0,0,0,0]
["Real EstateTaxes",null,0.0105,1995.0000000000002,"yearly",2034.9000000000003,2075.5980000000004,2117.1099600000007,2159.4521592000006,2202.6412023840007,2246.694026431681,2291.6279069603147,2337.460465099521,2384.2096744015116,2431.893867889542]
["Repairs and Maintenance",null,0.05,1080,"yearly",1101.6000000000001,1123.6320000000003,1146.1046400000002,1169.0267328,1192.407267456,1216.25541280512,1240.5805210612225,1265.392131482447,1290.6999741120962,1316.513973594338]
["Services","Elevator",null,0,"yearly",0,0,0,0,0,0,0,0,0,0]
[null,"Janitorial",null,0,"yearly",0,0,0,0,0,0,0,0,0,0]
[null,"Lawn",null,0,"yearly",0,0,0,0,0,0,0,0,0,0]
[null,"Pool",null,0,"yearly",0,0,0,0,0,0,0,0,0,0]
[null,"Rubbish",null,0,"yearly",0,0,0,0,0,0,0,0,0,0]
[null,"Other",0.04,864,"yearly",881.28,898.9056000000002,916.8837120000001,935.22138624,953.9258139648,973.004330244096,992.464416848978,1012.3137051859576,1032.559979289677,1053.2111788754703]
["Supplies",null,0.01,216,"yearly",220.32,224.72640000000004,229.22092800000001,233.80534656,238.4814534912,243.251082561024,248.1161042122445,253.0784262964894,258.1399948224192,263.3027947188676]
["Utilities","Electricity",0,0,"yearly",0,0,0,0,0,0,0,0,0,0]
[null,"Gas & Oil",null,0,"yearly",0,0,0,0,0,0,0,0,0,0]
[null,"Sewer & Water",null,0,"yearly",0,0,0,0,0,0,0,0,0,0]
[null,"Telephone",null,0,"yearly",0,0,0,0,0,0,0,0,0,0]
[null,"Other",null,0,"yearly",0,0,0,0,0,0,0,0,0,0]
["Miscellaneous",null,0.0403,870.48,"yearly",887.8896000000001,905.6473920000002,923.7603398400001,942.2355466368,961.0802575695361,980.3018627209267,999.9078999753453,1019.9060579748523,1040.3041791343494,1061.1102627170364]
["Total Operating Expense",null,null,8014.040000000001,"yearly",8174.3208,8337.807216000003,8504.56336032,8674.6546275264,8848.14772007693,9025.110674478468,9205.612887968038,9389.7251457274,9577.519648641948,9769.070041614787]
[]
["Net Operating Income (NOI)",null,null,13585.96,null,13857.679199999999,14134.832784,14417.529439680002,14705.880028473599,14999.997629043071,15299.99758162393,15605.997533256412,15918.117483921538,16236.479833599973,16561.20943027197]
["Total Annual Debt Service",null,null,12135.117512068293,null,12135.117512068293,12135.117512068293,12135.117512068293,12135.117512068293,12135.117512068293,12135.117512068293,12135.117512068293,12135.117512068293,12135.117512068293,12135.117512068293]
["Annual Cash Flow Before Taxes",null,null,1450.8424879317063,null,1722.5616879317058,1999.7152719317073,2282.411927611709,2570.762516405306,2864.8801169747785,3164.8800695556365,3470.880021188119,3782.9999718532454,4101.36232153168,4426.091918203678]
[null,"Monthly",null,120.90354066097552,null,143.54680732764214,166.64293932764227,190.2009939676424,214.23020970044217,238.7400097478982,263.740005796303,289.2400017656766,315.2499976544371,341.78019346097335,368.8409931836398]
["Cap Rate. (stay > 6%)",null,null,0.07150505263157894,null,0.07293515368421052,0.07439385675789474,0.07588173389305264,0.07739936857091367,0.07894735594233196,0.08052630306117857,0.08213682912240217,0.0837795657048502,0.08545515701894722,0.08716426015932616]
["Cash on Cash Return (stay > 8-9%)",null,null,0.03627106219829266,null,0.04306404219829264,0.049992881798292685,0.05706029819029272,0.06426906291013265,0.07162200292436946,0.07912200173889092,0.08677200052970298,0.09457499929633113,0.102534058038292,0.11065229795509195]
[]
["Gross Rent Multiplier (stay under 5/6)",null,null,8.796296296296296,null,8.623819898329701,8.454725390519314,8.288946461293445,8.126418099307301,7.967076567948334,7.810859380341505,7.657705274844611,7.507554191024129,7.360347246102086,7.2160267118647905]
["Debt Coverage Ratio (stay over 1.2)",null,null,1.1195573496909983,null,1.1419484966848183,1.1647874666185147,1.1880832159508852,1.2118448802699027,1.2360817778753006,1.2608034134328066,1.286019481701463,1.311739871335492,1.3379746687622023,1.364734162137446]
[]
["Cash Inflow",null,null,2000,"monthly",2040,2080.8,2122.416,2164.86432,2208.1616064,2252.324838528,2297.37133529856,2343.3187620045314,2390.185137244622,2437.988839989515]
[null,null,null,24000,"yearly",24480,24969.600000000002,25468.992000000002,25978.37184,26497.9392768,27027.898062335997,27568.456023582723,28119.825144054375,28682.221646935468,29255.866079874177]
["Depreciation/Tax View"]
["Est. Depreciable Amount",null,0.75,142500,null,142500,142500,142500,142500,142500,142500,142500,142500,142500,142500]
["Est. Yearly Depreciation",null,27.5,5181.818181818182,null,5181.818181818182,5181.818181818182,5181.818181818182,5181.818181818182,5181.818181818182,5181.818181818182,5181.818181818182,5181.818181818182,5181.818181818182,5181.818181818182]
["Mortgage Interest Paid",null,null,10591.086571539854,null,10370.077512104837,10242.482627792988,10105.663898977396,9958.954533193075,9801.63953549384,9632.952223891027,9452.070492893026,9258.112806935766,9050.133904177963,8827.12018972341]
["Operating Expenses (from above)(no edit)",null,null,8014.040000000001,null,8174.3208,8337.807216000003,8504.56336032,8674.6546275264,8848.14772007693,9025.110674478468,9205.612887968038,9389.7251457274,9577.519648641948,9769.070041614787]
["Tax Loss or Gain",null,null,-22336.10226542633,null,-22003.654805991315,-21762.392753679465,-21509.633513503868,-21244.66482613235,-20966.725320414174,-20675.00101063204,-20368.621541491128,-20046.656162628104,-19708.109413106413,-19351.9164949527]
["Tax Loss or Due",null,0.27,-6030.74761166511,null,-5940.986797617656,-5875.846043493456,-5807.601048646045,-5736.059503055735,-5661.015836511828,-5582.250272870651,-5499.527816202605,-5412.597163909589,-5321.189541538732,-5225.01745363723]
["Cash + Tax/Depreciation Advantage",null,null,7481.590099596816,null,7663.548485549361,7875.561315425163,8090.0129762577535,8306.82201946104,8525.895953486606,8747.130342426288,8970.407837390725,9195.597135762833,9422.551863070412,9651.109371840907]
["Derived' Cash on Cash Return",null,null,0.18703975248992039,null,0.19158871213873405,0.1968890328856291,0.20225032440644383,0.207670550486526,0.21314739883716516,0.2186782585606572,0.22426019593476812,0.22988992839407082,0.2355637965767603,0.24127773429602267]
["Projected home appreciation value",null,null,193800,null,197676,201629.52,205662.11039999998,209775.352608,213970.85966016,218250.2768533632,222615.28239043048,227067.5880382391,231608.93979900389,236241.11859498397]
["Projected appreciation delta",null,0.02,3800,null,3876,3953.5199999999895,4032.5903999999864,4113.242208000011,4195.507052160014,4279.417193203204,4365.005537067278,4452.305647808622,4541.351760764781,4632.178795980086]
["Projected total 'return' (w/ appreciation)",null,null,0.28203975248992036,null,0.28848871213873406,0.2957270328856288,0.3030650844064435,0.3105016056865263,0.3180350751411655,0.3256636883907373,0.33338533436145007,0.3411975695892864,0.3490975905958798,0.35708220419552483]
[]
[]
[]
[]
[]
[]
["http://rhol.org/rental/analysis.asp"]
[]
[]
["Payback Period (fully payback initial cash investment with monthly income (after expenses, taxes))"]
[null,null,null,20,"months"]
[null,null,null,1.6666666666666667,"years"]
["Yearly % payback",null,null,0.6]
[]
["How to: take into account rising rents"]
["Project future value of property"]
["calculate earliest property sell date, income/appreciation based."]
{"$rows_empty":29}
[null,null,null,"Cash flow analysis"]
[]
[]
[null,null,null,"include depreciation?"]
[]
[]
[null,null,null,"rent roll"]
[]
[]
[null,null,null,"operating expenses"]

{"sheet":"Trial Est. Req. Ownership","index":3,"n_rows":6,"n_cols":5,"rows_kept":6,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
["This worksheet is to attempt to estimate the value/amount of real estate required to provide income replacement"]
[null,"(this is a very primitive analysis)"]
[]
["Desired Income replacement",null,null,80000,"yearly"]
["Assumption: Req Min. Net Profit of a property",null,null,0.1]
["(after debt service, costs, taxes)"]

{"sheet":"Sheet2","index":4,"n_rows":84,"n_cols":23,"rows_kept":84,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
["Expense",{"$nulls":10},"Yearly appreciation",null,0.02,null,"Sales Commision",0.07]
["rate",0.06,{"$nulls":9},"Yearly Tax Increase",null,0.02,null,"Sales Fees",1000]
["House",425000,{"$nulls":6},"Net Valu. Increase","Net Val. Inc. + income",null,"Yearly Rent Increase",null,0.02,{"$nulls":6},"Yearly Income","Tot. Income To Date","Internal Rate of return"]
["Down",0.3,null,"Year","Prop Val","Equity","Sales Cost","net sale (Val-Sales)","orig Puch-net sale",null,null,"Mortgage","Insurance","Maint","Tax","Unit1",null,"Unit2","Unit3","Unit4",-40000,-40000]
["Loan",297500,null,1,425000,1544.030940528441,30750.000000000004,394250,204250,210821.0462520465,null,21403.953747953496,1200,250,1200,7500,625,7500,7500,7500,6571.046252046504,6571.046252046504,{"$error":"#NUM!"}]
["Years",30,null,2,433500,3199.6800025922144,31345.000000000004,402155,212155,225885.59250409302,null,21403.953747953496,1200,250,1224,7650,637.5,7650,7650,7650,7159.546252046504,13730.592504093009,{"$error":"#NUM!"}]
["Months",360,null,3,442170,4975.016069222129,31951.9,410218.1,220218.09999999998,241708.5087561395,null,21403.953747953496,1200,250,1248.48,7803,650.25,7803,7803,7803,7759.816252046505,21490.408756139514,-0.25097833910979006]
["Pmt",1783.662812329458,"monthly",4,451013.4,6878.691323655709,32570.938000000006,418442.462,228442.462,258304.96240818602,null,21403.953747953496,1200,250,1273.4496000000001,7959.06,663.255,7959.06,7959.06,7959.06,8372.091652046507,29862.50040818602,-0.10376053581887515]
["Ins.",1200,"yearly",5,460033.668,8919.983416156312,33202.35676,426831.31124,236831.31124,275690.42420823255,null,21403.953747953496,1200,250,1298.9185920000002,8118.2412,676.5201000000001,8118.2412,8118.2412,8118.2412,8996.612560046506,38859.112968232526,-0.009100869153549275]
["PMI",0,null,6,469234.34136,11108.840679074976,33846.403895200005,435387.9374648,245387.93746480002,293880.67431923904,null,21403.953747953496,1200,250,1324.8969638400004,8280.606024,690.050502,8280.606024,8280.606024,8280.606024,9633.623886206504,48492.736854439034,0.05424379532852634]
["Tax",1200,"yearly",7,478619.0281872,13455.930610512789,34503.331973104,444115.69621409604,254115.69621409604,312891.8085074248,null,21403.953747953496,1200,250,1351.3949031168004,8446.21814448,703.8515120400001,8446.21814448,8446.21814448,8446.21814448,10283.375438889703,58776.11229332874,0.09817244188825756]
["Maint",3000,"yearly",8,488191.408750944,15972.6918628711,35173.39861256608,453018.01013837795,263018.01013837795,332740.24445433327,null,21403.953747953496,1200,250,1378.4228011791365,8615.142507369601,717.9285422808001,8615.142507369601,8615.142507369601,8615.142507369601,10946.122022626572,69722.23431595531,0.1295571548710034]
["Tot",2233.6628123294577,null,9,497955.2369259629,18671.38998965823,35856.866584817406,462098.3703411455,272098.3703411455,353442.728195139,null,21403.953747953496,1200,250,1405.9912572027192,8787.445357516994,732.2871131264161,8787.445357516994,8787.445357516994,8787.445357516994,11622.123538038177,81344.35785399348,0.1525369318738167]
[null,null,null,10,507914.3416644822,21565.17722223738,36554.00391651376,471360.33774796844,281360.33774796844,375016.3406857199,null,21403.953747953496,1200,250,1434.1110823467736,8963.194264667334,746.9328553889445,8963.194264667334,8963.194264667334,8963.194264667334,12311.645083758009,93656.00293775149,0.16970700732938235]
["Income",null,null,11,518072.62849777186,24668.156567840426,37265.08399484403,480807.5445029278,290807.5445029278,397478.5045010715,null,21403.953747953496,1200,250,1462.793303993709,9142.458149960681,761.8715124967234,9142.458149960681,9142.458149960681,9142.458149960681,13014.95706039224,106670.95999814372,0.18275391667885918]
["Unit1",625,"monthly",12,528434.0810677273,27995.45054123233,37990.385674740915,490443.6953929864,300443.6953929864,420846.9906676893,null,21403.953747953496,1200,250,1492.0491700735834,9325.307312959894,777.1089427466578,9325.307312959894,9325.307312959894,9325.307312959894,13732.335276559155,120403.29527470288,0.1928083450008145]
["Unit2",625,"monthly",13,539002.7626890818,31563.274864993215,38730.19338823573,500272.5693008461,310272.5693008461,445139.92563259834,null,21403.953747953496,1200,250,1521.890153475055,9511.813459219093,792.6511216015911,9511.813459219093,9511.813459219093,9511.813459219093,14464.061057049406,134867.3563317523,0.20064906922217127]
["Unit3",625,"monthly",14,549782.8179428634,35389.01749759961,39484.79725600044,510298.020686863,320298.020686863,470375.7983717647,null,21403.953747953496,1200,250,1552.3279565445562,9702.049728403475,808.504144033623,9702.049728403475,9702.049728403475,9702.049728403475,15210.421353149472,150077.77768490175,0.20682520430817003]
["Unit4",625,"monthly",15,560778.4743017207,39491.32337445228,40254.49320112046,520523.9811006003,330523.9811006003,496573.46764067357,null,21403.953747953496,1200,250,1583.3745156754474,9896.090722971545,824.6742269142954,9896.090722971545,9896.090722971545,9896.090722971545,15971.708855171535,166049.4865400733,0.211731918656477]
[null,null,null,16,571994.0437877552,43890.185274839634,41039.58306514287,530954.4607226123,340954.46072261233,523752.1693699197,null,21403.953747953496,1200,250,1615.0420059889564,10094.012537430975,841.1677114525813,10094.012537430975,10094.012537430975,10094.012537430975,16748.222107234033,182797.70864730733,0.21565872063609617]
["Tot Income",2500,"monthly",17,583433.9246635103,48607.0412576814,41840.37472644573,541593.5499370645,351593.5499370645,551931.5242087096,null,21403.953747953496,1200,250,1647.3428461087356,10295.892788179595,857.9910656816329,10295.892788179595,10295.892788179595,10295.892788179595,17540.265624337786,200337.97427164513,0.21882106585011316]
[null,null,null,18,595102.6031567805,53664.87914091003,42657.18222097464,552445.4209358059,362445.4209358059,581131.5452192347,null,21403.953747953496,1200,250,1680.2897030309102,10501.810643943187,875.1508869952655,10501.810643943187,10501.810643943187,10501.810643943187,18348.150011783608,218686.12428342874,0.2213815340074944]
["Cash Inflow",266.33718767054233,"monthly",19,607004.6552199161,59088.34853367499,43490.32586539413,563514.329354522,373514.32935452205,611372.6457249292,null,21403.953747953496,1200,250,1713.8954970915286,10711.84685682205,892.6539047351708,10711.84685682205,10711.84685682205,10711.84685682205,19172.192086978346,237858.3163704071,0.22346431678452375]
[null,3196.046252046508,"yearly",20,619144.7483243145,64903.880967364246,44340.13238270202,574804.6159416125,384804.6159416125,642675.6473156966,null,21403.953747953496,1200,250,1748.1734070333591,10926.083793958493,910.5069828298743,10926.083793958493,10926.083793958493,10926.083793958493,20012.71500367699,257871.03137408406,0.22516531750772667]
[null,null,null,21,631527.6432908007,71139.81871090695,45206.93503035606,586320.7082604447,396320.7082604447,675061.7880132383,null,21403.953747953496,1200,250,1783.1368751740263,11144.605469837663,928.7171224864719,11144.605469837663,11144.605469837663,11144.605469837663,20870.048378709602,278741.07975279365,0.2265593123329535]
["Initial Investment",null,null,22,644158.1961566168,77826.55289814482,46091.07373096318,598067.1224256536,408067.1224256536,708552.7305996901,null,21403.953747953496,1200,250,1818.7996126775067,11367.497579234416,947.2914649362014,11367.497579234416,11367.497579234416,11367.497579234416,21744.528421242867,300485.6081740365,0.22770510668132812]
["Down",127500,null,23,657041.3600797491,84996.67164044228,46992.89520558244,610048.4648741666,420048.46487416665,743170.57111283,null,21403.953747953496,1200,250,1855.1756049310568,11594.847530819105,966.2372942349253,11594.847530819105,11594.847530819105,11594.847530819105,22636.49806462679,323122.10623866325,0.22864930056535235]
["Fees",2000,null,24,670182.1872813441,92685.11884636921,47912.75310969409,622269.43417165,432269.43417165,778937.8475111916,null,21403.953747953496,1200,250,1892.279117029678,11826.744481435488,985.5620401196239,11826.744481435488,11826.744481435488,11826.744481435488,23546.307100878406,346668.41333954164,0.22942907352521855]
["Tot Initial",129500,null,25,683585.831026971,100929.36452247151,48851.008171887974,634734.822855083,444734.82285508304,815877.5485124798,null,21403.953747953496,1200,250,1930.1246993702716,12063.279371064198,1005.2732809220165,12063.279371064198,12063.279371064198,12063.279371064198,24474.312317855045,371142.7256573967,0.2300742687329631]
[null,null,null,26,697257.5476475104,109769.58738509793,49808.02833532573,647449.5193121847,457449.51931218465,854013.1226087526,null,21403.953747953496,1200,250,1968.7271933576772,12304.544958485481,1025.3787465404569,12304.544958485481,12304.544958485481,12304.544958485481,25420.877639171205,396563.6032965679,0.23060896950349463]
["Month Maint",250,null,27,711202.6986004607,119248.87067325076,50784.18890203225,660418.5096984284,470418.50969842845,893368.48726191,null,21403.953747953496,1200,250,2008.1017372248307,12550.635857655192,1045.886321471266,12550.635857655192,12550.635857655192,12550.635857655192,26386.37426691371,422949.9775634816,0.23105270369756206]
[]
[]
[{"$nulls":11},577906.7511947447,32400,6750,42413.18859846632,265082.4287404145,null,265082.4287404145,265082.4287404145,265082.4287404145,422949.9775634816]
["http://rhol.org/rental/analysis.asp"]
[]
[]
["Payback Period (fully payback initial cash investment with monthly income (after expenses, taxes))"]
[null,486.2257544004362,"months"]
[null,40.518812866703016,"years",null,"For Finding Remaining Principal Balance"]
["Yearly % payback",0.02467989383819697,null,null,"P = P * (1 - ((1 + J) ** t - 1) / ((1 + J) ** N - 1))"]
[{"$nulls":4},"P = principal, the initial amount of the loan"]
["How to: take into account rising rents",null,null,null,"I = the annual interest rate (from 1 to 100 percent)"]
["Project future value of property",null,null,null,"L = length, the length (in years) of the loan, or at least the length over which the loan is amortized."]
["calculate earliest property sell date, income/appreciation based.",null,null,null,"J = monthly interest in decimal form = I / (12 x 100)"]
[{"$nulls":4},"N = number of months over which loan is amortized = L x 12"]
["TODO: Vacancy adjustments",null,null,null,"t=number of paid monthly loan payments"]
["TODO: Upgrade adjustments"]
[{"$nulls":9},"OR use "]
[{"$nulls":4},"P",152000,null,null,null,"CUMPRINC(9.5%/12, 30*12, 100000, 1, 12, 0)"]
[{"$nulls":4},"J",0.005833333333333334]
[{"$nulls":4},"I",0.07]
[{"$nulls":4},"L",30]
[{"$nulls":4},"N",360]
[{"$nulls":4},"t",1]
[]
[null,null,null,"A","(1+ J)",1.0058333333333334]
[null,null,null,"B","pow(a, t) - 1",0.005833333333333357]
[null,null,null,"C","pow(a, N) -1",7.116497475359662]
[null,null,null,"d","P*B/C",124.59312600569129]
[null,null,null,"Remaining","P- D",151875.4068739943]
[]
[]
[null,null,null,"Prinicpal paid in",null,6.490959044363474e+25,{"$nulls":5},"LOanAmount*(POWER((1+InterestRate/12), PaidPayments) -1)/(POWER((1+InterestRate/12), LoanMonths) -1)"]
[null,null,null,"Amount Reamining",null,-6.490959044363474e+25,{"$nulls":5},"LOanAmount - (LOanAmount*(power((1+InterestRate/12), PaidPayments) -1)/(power((1+InterestRate/12), LoanMonths) -1))"]
{"$rows_empty":9}
[null,"Cash flow analysis"]
[]
[]
[null,"include depreciation?"]
[]
[]
[null,"rent roll"]
[]
[]
[null,"operating expenses"]

{"sheet":"Sheet1","index":5,"n_rows":18,"n_cols":4,"rows_kept":18,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
["Purchase Price",null,150000]
["Cash Invested",null,45000]
["Est. Improvements"]
["Scheduled Annual Rents",null,1000]
["Vacancy allowance (5-10%)",0.1,100]
["Net Rental Income",null,900]
["Operating Expenses (repairs, maint)",0.1,90]
["Property Tax",null,1100]
["NOI (net operating income, prior mort)",null,-290]
["Annual interest on the mortgage"]
["Cash Flow Before Tax",null,-290]
["Depreciation",null,4909.090909090909,"90% of property value / 27.5"]
["Tax loss or gain",null,-5199.090909090909]
["Annual tax loss or tax due",0.27,-1403.7545454545455]
["After Tax Cash Flow",null,-1693.7545454545455]
["Cash on Cash Return",null,-0.0376389898989899]
["Projected 1 year gain in value",0.03,4500]
["Projected total after tax return first year",null,2806.245454545455]

{"sheet":"template","index":6,"n_rows":48,"n_cols":10,"rows_kept":48,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
["CFBT/YR",{"$error":"#DIV/0!"},"CFBT/MO",{"$error":"#DIV/0!"},"%CashFlow",{"$error":"#DIV/0!"},"Cap Rate",{"$error":"#DIV/0!"}]
["REAL ESTATE EVALUATION SPREADSHEET",{"$nulls":8},"CFBT/YR-Annual Cash Flow Before Taxes: In our adaptation of Robert Allen's example this number is shown on the top line, left-most cell. This is simply the total annual debt service subtracted from the Net Operating Income"]
["Date:",null,null,"Price:",null,"Assessed/Appraised Value",null,null,null,"CFBT/MO-Monthly Cash Flow Before Taxes: In our model this number appears toward the middle of the top line. This is the annual cash flow before taxes divided by 12. This is the monthly cash flow that Robert Kiyosaki would use to determine if what we purchase is an asset and is the most critical number in the analysis of investment property."]
["Name:",null,null,"Loans:",null,"Land:",null,{"$error":"#DIV/0!"},null,"% Cash Flow: This is simply the return on you investment (ROI) or your cash on cash return, which is calculated by dividing the Annual Cash Flow Before Taxes by your down payment. This does not take into account your equity build-up, tax savings or appreciation. For a discussion these calculations see Nothing Down for the 90's Ch7 p87. For our own analysis we do not consider equity build-up, tax savings or appreciation because we feel that the most conservative and safest measure of return is simply the cash flow from the operation of the investment."]
["Address:",null,null,"Equity:",0,"Improvmt:",null,{"$error":"#DIV/0!"},null,"Cap Rate: This is calculated by dividing the net operating income by the selling price and is simply the rate of return on capital. Robert Allen gives a discussion of this parameter in Nothing Down for the 90's p94.\"The higher the cap rate the better the price of the property. If a property has a cap rate of 10% or higher you had better act fast… On the other end of the scale, if a property has a cap rate of 5% or less, you can be sure that one of three things is wrong: 1) rents are too low; 2) expenses are too high; 3) price of the property is out of line.\""]
["Type:",{"$nulls":4},"Property:"]
[{"$nulls":5},"Total:",0,{"$error":"#DIV/0!"}]
["Existing Mortgage",null,null,null,"Potential Mortgage"]
["Type","Balance","Pmts/mo","Interest","Type","Balance","Pmts/mo","Interest"]
["1st",null,null,null,"1st",0,{"$error":"#DIV/0!"}]
["2nd",null,null,null,"2nd",null,{"$error":"#DIV/0!"}]
["Total",0,0,null,"Total",0,"$0"]
[null,null,"Term(yrs)",null,"Down Pmt",null,"Term(yrs)"]
["# Units=",null,"Rent/Unit=",null,"# Units=",null,"Rent/Unit="]
["# Units=",null,"Rent/Unit=",null,"# Units=",null,"Rent/Unit="]
["# Units=",null,"Rent/Unit=",null,"%","Expenses","Income","Comments"]
["GROSS SCHEDULED RENTAL INCOME",{"$nulls":5},0,null,null,"Gross Scheduled Rental Income: This is simply the amount of income the property would generate if the building were rented all year with no vacancies and is calculated by multiplying the # Units by the Rent/Unit and summing over all the different units."]
["Other Income"]
["TOTAL GROSS INCOME",{"$nulls":5},0]
["Vacancy Rate and Credit Losses ",null,null,null,0.05,0,null,null,null,"Vacancy Rate and Credit Losses: You will always have some vacancy. You should assume a 5% vacancy rate on the Gross Scheduled Income to account for lost days in rent between tenants. "]
["GROSS OPERATING INCOME ",{"$nulls":5},0]
["Operating Expenses"]
[null,"Accounting and Legal",null,null,0.0216,0]
[null,"Advertising, License, Permits",null,null,0.02,0]
[null,"Property Insurance",null,null,0.005,0]
[null,"Property Management",null,null,0.07,0]
[null,"Paroll-Resident Mgr/mo",null,null,0.0431,0]
[null,null,"Other",null,null,0]
[null,null,"Taxes-Wrkmn Comp",null,null,0]
[null,"Personal Property Taxes",null,null,null,0]
[null,"Real EstateTaxes",null,null,0.01,0]
[null,"Repairs and Maintenance",null,null,0.05,0]
[null,"Services","Elevator",null,null,0]
[null,null,"Janitorial",null,null,0]
[null,null,"Lawn",null,null,0]
[null,null,"Pool",null,null,0]
[null,null,"Rubbish",null,null,0]
[null,null,"Other",null,null,0]
[null,"Supplies",null,null,0.01,0]
[null,"Utilities","Electricity",null,0.0575,0]
[null,null,"Gas & Oil",null,null,0]
[null,null,"Sewer & Water",null,null,0]
[null,null,"Telephone",null,null,0]
[null,null,"Other",null,null,0]
[null,"Miscellaneous",null,null,0.0403,0]
["TOTAL OPERATING EXPENSES",{"$nulls":4},0]
["NET OPERATING INCOME",{"$nulls":5},0]
["Total Annual Debt Service ",{"$nulls":4},{"$error":"#DIV/0!"},null,null,null,"Total Annual Debt Service or Mortgage: This is simply the monthly mortgage payment multiplied by 12"]

{"sheet":"Definitions","index":7,"n_rows":108,"n_cols":2,"rows_kept":108,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
[null,"The most conservative rental housing investment is a single family home in a stable suburban neighborhood. It also usually has the highest appreciation rate over the long term. Unfortunately, it will produce the lowest cash on cash return in early years"]
[null,"Banks require at least 30% down on investment property "]
[]
[]
["Capitalization Rate"]
[null,"Net Operating Income / Selling Price(Purchase Price)"]
[null,"This is the rate of return on capital"]
[null,"The higher the cap rate, the better the property is."]
[null,"10%+ is good, under 5, something is wrong with property (rents too low, costs too much, expenses too high)"]
[null,"Used to determine the value of income producing investments"]
[]
[]
["Cash on Cash Rate of Return"]
[null,"Net Operating Income - Debt Service  / Equity"]
[]
["Debt Coverage Ratio"]
[null,"Net Operating Income / Annual Debt Service"]
[null,"Most lenders require a Debt Coverage Ratio of at least 1.2 and usually desire 1.5 to finance an income property. This ratio is intended to predict our ability to meet mortgage payments. A presentation to a lender should always include the anticipated Debt Coverage Ratio extended to at lease five years. "]
[]
["Fair Market Value"]
[null,"The most probable price a property should bring in a competitive and open market under all conditions requisite to a fair sale, the buyer and the seller each acting prudently, knowledgeably and assuming the price is not affected by undue stimulus"]
[]
["Gross Rent Multiplier"]
[null,"Sale (purchase ) price / Gross Annual Rents"]
[null,"The simplest way to obtain cursory estimates of the value of a property—the so-called \"yardstick value\"—is to calculate the gross rent multiplier (GRM). This method compares the property's sale price with its current gross annual rental income to determine whether the income will cover your new mortgage and operating expenses"]
[]
[null,"The higher the gross rent multiplier, the more likely the property will yield a negative cash flow. Investors should not pay more than five to six times gross rent"]
[]
[null," Investors should note that the gross rent multiplier does not take operating expenses into consideration; this can sometimes result in overvaluation. For example, buildings with common heat, electric or water have much higher expenses that those in which tenants are responsible for their own utilities; this dramatically lowers net operating income, but would not be reflected in the gross rent multiplier analysis. As noted above, GRM analysis should be used only to obtain a rough estimate of the property's value as it relates to income. The analysis is usually used to check sales information in a multi-listing service where only gross income and sales price are available on a comparable properties"]
[]
[]
["Internal Rate of Return"]
[]
[null,"Internal rate of return (IRR) and financial market rate of return (FMRR) are sophisticated valuation methods used when properties have uneven and/or negative cash flows. They usually factor in tax ramifications and a sale of the property at some future date. The IRR uses discounted cash analysis to measure investment yield. The FMRR is a modified IRR that accounts for negative cash flows by using a safe estimated rate to save funds and earn interest in profitable years. Investors should note that IRR and FMRR are based on assumptions that may not be accurately predicted"]
[]
["Market Analysis"]
[null,"A real estate appraisal term for determining what price the property is likely to bring in the local market at a certain point in time. The value is determined by comparing the subject property to similar properties that have recently sold, those that did not sell, and those that are currently being offered for sale. The best indicator of value for owner occupied housing."]
[]
["NOI - Net Operating Income before mortgage expense "]
[]
[]
["Price Per Square Foot"]
[null,"Calculating price per square foot and price per unit is a good way to evaluate a property against comparable buildings in the area. Commercial buildings are usually leased at a annual square foot r"]
[]
["Price Per Unit"]
[null,"Price per rentable unit is more commonly used on residential rental properties. Price per unit is derived by dividing the sale price by the number of units"]
[]
["Payback Rate"]
[null,"The payback rate is an old-fashioned but widely used yardstick to calculate the owner's return. It simply measures how long it will take for an investor to earn back the investment. If the investor purchased a building for $1,000,000 in cash, and the property delivered an annual return of $100,000, at an 8% cost of funds, the payback period would be just under 14 years"]
[]
[]
[]
["For Finding Remaining Principal Balance"]
["P = P * (1 - ((1 + J) ** t - 1) / ((1 + J) ** N - 1))"]
["P = principal, the initial amount of the loan"]
["I = the annual interest rate (from 1 to 100 percent)"]
["L = length, the length (in years) of the loan, or at least the length over which the loan is amortized."]
["J = monthly interest in decimal form = I / (12 x 100)"]
["N = number of months over which loan is amortized = L x 12"]
["t=number of paid monthly loan payments"]
[]
[]
[null,"LOanAmount*(POWER((1+InterestRate/12), PaidPayments) -1)/(POWER((1+InterestRate/12), LoanMonths) -1)"]
[null,"LOanAmount - (LOanAmount*(power((1+InterestRate/12), PaidPayments) -1)/(power((1+InterestRate/12), LoanMonths) -1))"]
[]
[]
[]
["Payback Period (how long does it take to get your money back?)"]
[null,"Gross Rent Multiplier"]
[null,"Net Income Multiplier"]
[null,"Before-Tax Cash Flow Multiplier"]
[null,"After-Tax Cash Flow Multiplier"]
[null,"Effective Gross Income Multiplier"]
[null,"Net-Income Multiplier and many others."]
[]
["Rates Of Return (how profitable a particular investment is at a given time)"]
[null,"Capitalization Rate"]
[null,"Cash-on-Equity Rate"]
[null,"After-Tax Cash-on-Equity Rate"]
[null,"Net Operating Income Average Return"]
[null,"Before-Tax Cash Flow Return"]
[null,"After-Tax Cash Flow Return"]
[null,"Average Rate of Return Pre-and-Post Sale and others."]
[]
[]
[]
[]
["Net present value of an investment"]
[null,"This is just a fancy way of explaining that there is a difference between what an investment costs and what it is worth.  Technically any investment is valued at the difference between the present value of the income it generates minus the present value of what an investment costs.  Since most investments are made on the \"Buy Now, Receive Income Later\" plan, an adjustment in the actual worth of future income streams needs to be made.  A dollar received five years from now is not worth one dollar paid out today to receive it.  Most NPV analysis is helpful and necessary but terribly confusing especially since it is tough enough to predict future cash flows with certainty, let alone value them."]
["Building and development cost ratios"]
[null,"These are mostly internal numbers used by developers to judge how efficiently they are putting up projects.  Developers like to know that they are fully utilizing their time and resources and are building the most lucrative projects they can so they have a set of \"house\" numbers they use to measure their effectiveness.  Here developers often make the same \"relative\" versus \"comparative\" mistake described above by comparing two projects instead of trying to measure the success or failure of any given one.  Some of the most common ratios here are:"]
[null,"Equity to Total Cost Ratio"]
[null,"Appraised Project Value to Total Cost Ratio"]
[null,"Equity to Final Project Value"]
[null,"Equity to Projected Final Project Sales Price"]
[null,"Development Yield and many others"]
[]
[]
["Time value of money considerations"]
[null,"Without getting too overly complex here, developers generally use two time value of money ratios.  The first is the commonly used IRR or \"internal rate of return\" analysis but with a twist.  IRR is simply the rate of return on an investment where the present value of the cash inflows equals the present value of all cash expenditures, expenses, and other outflows.  But since IRR analysis assumes that all the outflows are reinvested at the same rate that the investment is currently returning, developers use a \"zero net present value\" analysis that supplements traditional IRR calculations.  This IRR with-a-twist analysis is called \"Financial Management Rate of Return\" or FMRR.  FMRR starts with basic IRR calculations but while IRR assumes a reinvestment rate on outflows at the same rate as the return, FMRR calculates the reinvestment rate on outflows at a series of set and individually selected rates.  Needless to say, the math here can get extremely complex.  Computers do all the work but interpreting the data requires even more extensive analysis.\n\nThe bottom line here is that discounting a series of uneven cash inflows and outflows is a necessary chore of complex development projects but most of the numbers generated fail to provide a clear picture of an investment's merit.  They are helpful but not definitive.  These numbers cannot be ignored but they cannot be relied on with confidence either.  I use them to confirm trends and ideas but not to establish them.  I know many experienced developers who haven't a clue what IRR or FMRR calculations are because they are so arcane and others who take devilish delight in the complex mathematics of these calculations and rely upon them as if they were Gospel."]
["Leasing and selling ratios"]
[null,"The whole business of real estate development is creating rentable square footage for tenants and leasing ratios are the acid test of whether or not a developer has been doing their job as best they can."]
[null,"Sales price per gross square foot"]
[null,"Sales price per net square foot"]
[null,"Sales price per sales unit"]
[null,"Sales price per room"]
[null,"Gross rental income per square foot"]
[null,"Net rental income per square foot and many others"]