Long comments. Thanks. Most have understood. But really want to see simple spreadsheet chart on this. If someone has a reference besides what I have below, which I know is INCORRECT.
Given
http://en.wikipedia.org/wiki/Future_value for calculating interest
[TABLE="width: 821"]
[TR]
[TD="class: xl63, width: 139, bgcolor: transparent"][/TD]
[TD="class: xl63, width: 84, bgcolor: transparent"]
Interest rate
[/TD]
[TD="class: xl63, width: 64, bgcolor: transparent"]
Principal
[/TD]
[TD="class: xl63, width: 109, bgcolor: transparent"]
Monthly Cost
[/TD]
[TD="class: xl63, width: 100, bgcolor: transparent"]
Ten year Value
[/TD]
[TD="class: xl63, width: 96, bgcolor: transparent"]
Ten Year Taxes
[/TD]
[TD="class: xl63, width: 110, bgcolor: transparent"]
Ten Year Repairs
[/TD]
[TD="class: xl63, width: 125, bgcolor: transparent"]
Ten Year Insurance
[/TD]
[TD="class: xl63, width: 144, bgcolor: transparent"]
Ten Year Interest paid
[/TD]
[TD="class: xl63, width: 123, bgcolor: transparent"]
Ten Year full value
[/TD]
[/TR]
[TR]
[TD="class: xl63, bgcolor: transparent"]
Rental
[/TD]
[TD="class: xl63, bgcolor: transparent"][/TD]
[TD="class: xl63, bgcolor: transparent"][/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]
-1400
[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]
-168000
[/TD]
[TD="class: xl63, bgcolor: transparent"][/TD]
[TD="class: xl63, bgcolor: transparent"][/TD]
[TD="class: xl63, bgcolor: transparent"][/TD]
[TD="class: xl63, bgcolor: transparent"][/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]
-168000
[/TD]
[/TR]
[TR]
[TD="class: xl63, bgcolor: transparent"]
Homeloan-savings
[/TD]
[TD="class: xl64, bgcolor: transparent, align: right"]
9%
[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]
50000
[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]
416.6666667
[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]
50000
[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]
0
[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]
0
[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]
0
[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]
0
[/TD]
[TD="class: xl63, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl63, bgcolor: transparent"]
Homeloan-regular
[/TD]
[TD="class: xl64, bgcolor: transparent, align: right"]
5%
[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]
150000
[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]
-1250
[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]
150000
[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]
-30000
[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]
-10000
[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]
-5000
[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]
-37500
[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]
67500
[/TD]
[/TR]
[TR]
[TD="class: xl63, bgcolor: transparent"][/TD]
[TD="class: xl63, bgcolor: transparent"][/TD]
[TD="class: xl63, bgcolor: transparent"][/TD]
[TD="class: xl63, bgcolor: transparent"][/TD]
[TD="class: xl63, bgcolor: transparent"][/TD]
[TD="class: xl63, bgcolor: transparent"][/TD]
[TD="class: xl63, bgcolor: transparent"][/TD]
[TD="class: xl63, bgcolor: transparent"][/TD]
[TD="class: xl63, bgcolor: transparent"][/TD]
[TD="class: xl63, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl63, bgcolor: transparent"]
Savings $50k
[/TD]
[TD="class: xl64, bgcolor: transparent, align: right"]
20%
[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]
50000
[/TD]
[TD="class: xl63, bgcolor: transparent"][/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]
300000
[/TD]
[TD="class: xl63, bgcolor: transparent"][/TD]
[TD="class: xl63, bgcolor: transparent"][/TD]
[TD="class: xl63, bgcolor: transparent"][/TD]
[TD="class: xl63, bgcolor: transparent"][/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]
300000
[/TD]
[/TR]
[/TABLE]