/home/norman/spreadsheet1.2/data/homeloan.sps sprsht Thu 2008 07 31 17:05:17EST 100`50` , total rows/cols; 1200`580` , window sizes 5` - number of sheets sheet 1 `1` -name and sheetno 2--------valid sps 19`12` , active rows/cols; 95`7`136`49`?`25`80`80`25`.`c`$`5`11`100`?`?`?`?`?` - current settings 80`12` 25`18`100`1` cell contents and properties homeloan.sps`1`=homeln()`1`Homeloan calculator `1`enter principal `1`interest %/a `1`periods/a `1`loan term yrs `1`start year `1``2`repayment/period `1``1`initial cost `1`home value increase %/a `1`general inflation %/a `1`maint,rates %/value `1`=homeln()`1``4`data `1`100000`1`10`1`12`1`10`1`2007`1``2`1321.507368817619180845`1``1`150000`1`4`1`2`1`1`1``5`year `1`2007.000000000000000000`1`2008.000000000000000000`1`2009.000000000000000000`1`2010.000000000000000000`1`2011.000000000000000000`1`2012.000000000000000000`1`2013.000000000000000000`1`2014.000000000000000000`1`2015.000000000000000000`1`2016.000000000000000000`1``8`debt-start yr `1`100000.000000000000000000`1`87089.302600123759475537`1`79603.199788485595490783`1`71333.204188259900547564`1`62197.231981008495495189`1`52104.604099877389671747`1`40955.146194769469730090`1`28638.194352110087493202`1`15031.496700479090577574`1`-0.000000000479449369`1``3`totals `1`real `1``3`interest `1`9723.904341720679440186`1`9081.575110025951289572`1`8371.985614173259818926`1`7588.092825585707032587`1`6722.116218560040579177`1`5765.460544680307975796`1`4708.630520703508409497`1`3541.136583152039293054`1`2251.390774180435982998`1`826.591725331859151993`1``3`58580.884258113794203382`1`54526.378158618950692471`1``3`principal `1`6134.184084090751639451`1`6776.513315785477971076`1`7486.102811638171260711`1`8269.995600225722228060`1`9135.972207251390500460`1`10092.627881131122194347`1`11149.457905107919941656`1`12316.951842659389512846`1`13606.697651630995096639`1`15031.496700479570790776`1``3`100000.000000000509317033`1`89094.724368276394670829`1``3`int+prin `1`15858.088425811432898627`10``3`158580.884258114354452118`1`143621.102526895352639258`1``3`debt-end yr `1`93865.815915909246541560`1`87089.302600123759475537`1`79603.199788485595490783`1`71333.204188259900547564`1`62197.231981008495495189`1`52104.604099877389671747`1`40955.146194769469730090`1`28638.194352110087493202`1`15031.496700479090577574`1`-0.000000000479449369`1``7`real `1`valuation `1`153022.569468518689973280`1`156106.045111650862963870`1`159251.654217022063676268`1`162460.648802671814337373`1`165734.306115383107680827`1`169073.929139053041581064`1`172480.847113307681865990`1`175956.416062567179324105`1`179502.019335771736223251`1`183119.068156983441440389`1``4`183119.068156983441440389`1`real costs - increase in real value`1``1`real `1`interest `1`9620.375431161575761507`1`8807.286207210141583346`1`7958.685191170831785712`1`7070.999700515503718634`1`6140.373504041371234052`1`5162.643081342701407266`1`4133.311920111487779650`1`3047.522688592290705856`1`1900.027107039685233758`1`685.153327433354775167`1``4`54526.378158618950692471`1` = real cost/period`1``1`real `1`maint,rates `1`6067.244920625450504303`1`6569.954449756617577805`1`7114.316635733759540017`1`7703.782664026392012602`1`8342.089672598964170902`1`9033.284444879544025753`1`9781.749065840513139847`1`10592.228703847446013242`1`11469.861694409475603607`1`12420.212116558217530837`1``4`89094.724368276394670829`1`227.242578376176680877`1``3`1530.225694685186908828`1`1561.060451116508602354`1`1592.516542170220645858`1`1624.606488026718125184`1`1657.343061153831058618`1`1690.739291390530524950`1`1724.808471133076864135`1`1759.564160625671775051`1`1795.020193357717289473`1`1831.190681569834396214`1``4`16767.075035229296190664`1``1` 8`170`128`1`8`57` 9`19`8`1`9`2`8`17`9`2`8`10`0`6`8`1`9`2`8`10`0`6`8`1`9`2`8`10`0`6`8`1`9`2`8`10`0`6`8`1`9`2`8`10`0`6`8`1`9`2`8`10`0`6`8`1`9`2`8`10`0`6`8`1`9`2`8`10`0`6`8`1`9`2`8`10`0`6`8`19` 12`228` 136`2`60`1`136`13`255`1`136`52`88`1`136`75`88`1`136`62`15`1`136`19` 109`38`101`19`109`171` 1`1`3`1`1`17`0`2`1`1`0`16`1`19`0`2`1`1`0`9`4`1`0`8`1`1`0`18`1`1`0`18`1`1`0`18`1`1`0`9`4`1`0`8`1`1`0`18`1`1`0`18`1`1`0`35` 7`228` 2`22`0`16`4`3`0`16`2`3`0`16`2`3`0`16`2`3`0`16`2`3`0`16`2`3`0`16`2`3`0`16`2`3`0`16`2`3`0`16`2`3`0`16` C-formats - continuous 3 c8`%12.10f`e23`%12.0f`c18`%12.10f` drawings - one per line 0 end of data | Sheet 2 `2` -name and sheetno 0--------valid sps | Sheet 3 `3` -name and sheetno 0--------valid sps | Sheet 4 `4` -name and sheetno 0--------valid sps | Sheet 5 `5` -name and sheetno 0--------valid sps |