Amortization schedule, conventional loan, conventional mortgage

ON AVERAGE, AMERICANS REFINANCE EVERY 4.9 YEARS. DURING THAT TIME THEY PAY VERY LITTLE TOWARDS THE PRINCIPAL. IF YOU COUNT CLOSING COSTS ON THE PREVIOUS LOAN, THE BALANCE DECREASES MUCH LESS. IF IT COSTS 3 - 4K TO CLOSE YOUR PREVIOUS LOAN, FIVE YEARS AGO, THEN YOUR TRUE BALANCE DECREASED ONLY ABOUT 4%.

Principal borrowed: $100000.00
Annual Payments: 12 Total Payments: 360
Annual interest rate: 6.00% Periodic interest rate: 0.5000%
Regular Payment amount: $599.55 Final Balloon Payment: $0.00

The following results are estimates which do not account for values being rounded to the nearest cent. See the amortization schedule for more accurate values.
Total Repaid: $215838.00
Total Interest Paid: $115838.00
Interest as percentage of Principal: 115.838%

Pmt	Principal	Interest	Cum Prin	Cum Int	Prin Bal
1	`99.55`	`500.00`	`99.55`	`500.00`	`99900.45`
2	`100.05`	`499.50`	`199.60`	`999.50`	`99800.40`
3	`100.55`	`499.00`	`300.15`	`1498.50`	`99699.85`
4	`101.05`	`498.50`	`401.20`	`1997.00`	`99598.80`
5	`101.56`	`497.99`	`502.76`	`2494.99`	`99497.24`
6	`102.06`	`497.49`	`604.82`	`2992.48`	`99395.18`
7	`102.57`	`496.98`	`707.39`	`3489.46`	`99292.61`
8	`103.09`	`496.46`	`810.48`	`3985.92`	`99189.52`
9	`103.60`	`495.95`	`914.08`	`4481.87`	`99085.92`
10	`104.12`	`495.43`	`1018.20`	`4977.30`	`98981.80`
11	`104.64`	`494.91`	`1122.84`	`5472.21`	`98877.16`
12	`105.16`	`494.39`	`1228.00`	`5966.60`	`98772.00`

13	`105.69`	`493.86`	`1333.69`	`6460.46`	`98666.31`
14	`106.22`	`493.33`	`1439.91`	`6953.79`	`98560.09`
15	`106.75`	`492.80`	`1546.66`	`7446.59`	`98453.34`
16	`107.28`	`492.27`	`1653.94`	`7938.86`	`98346.06`
17	`107.82`	`491.73`	`1761.76`	`8430.59`	`98238.24`
18	`108.36`	`491.19`	`1870.12`	`8921.78`	`98129.88`
19	`108.90`	`490.65`	`1979.02`	`9412.43`	`98020.98`
20	`109.45`	`490.10`	`2088.47`	`9902.53`	`97911.53`
21	`109.99`	`489.56`	`2198.46`	`10392.09`	`97801.54`
22	`110.54`	`489.01`	`2309.00`	`10881.10`	`97691.00`
23	`111.10`	`488.45`	`2420.10`	`11369.55`	`97579.90`
24	`111.65`	`487.90`	`2531.75`	`11857.45`	`97468.25`

25	`112.21`	`487.34`	`2643.96`	`12344.79`	`97356.04`
26	`112.77`	`486.78`	`2756.73`	`12831.57`	`97243.27`
27	`113.33`	`486.22`	`2870.06`	`13317.79`	`97129.94`
28	`113.90`	`485.65`	`2983.96`	`13803.44`	`97016.04`
29	`114.47`	`485.08`	`3098.43`	`14288.52`	`96901.57`
30	`115.04`	`484.51`	`3213.47`	`14773.03`	`96786.53`
31	`115.62`	`483.93`	`3329.09`	`15256.96`	`96670.91`
32	`116.20`	`483.35`	`3445.29`	`15740.31`	`96554.71`
33	`116.78`	`482.77`	`3562.07`	`16223.08`	`96437.93`
34	`117.36`	`482.19`	`3679.43`	`16705.27`	`96320.57`
35	`117.95`	`481.60`	`3797.38`	`17186.87`	`96202.62`
36	`118.54`	`481.01`	`3915.92`	`17667.88`	`96084.08`

37	`119.13`	`480.42`	`4035.05`	`18148.30`	`95964.95`
38	`119.73`	`479.82`	`4154.78`	`18628.12`	`95845.22`
39	`120.32`	`479.23`	`4275.10`	`19107.35`	`95724.90`
40	`120.93`	`478.62`	`4396.03`	`19585.97`	`95603.97`
41	`121.53`	`478.02`	`4517.56`	`20063.99`	`95482.44`
42	`122.14`	`477.41`	`4639.70`	`20541.40`	`95360.30`
43	`122.75`	`476.80`	`4762.45`	`21018.20`	`95237.55`
44	`123.36`	`476.19`	`4885.81`	`21494.39`	`95114.19`
45	`123.98`	`475.57`	`5009.79`	`21969.96`	`94990.21`
46	`124.60`	`474.95`	`5134.39`	`22444.91`	`94865.61`
47	`125.22`	`474.33`	`5259.61`	`22919.24`	`94740.39`
48	`125.85`	`473.70`	`5385.46`	`23392.94`	`94614.54`

49	`126.48`	`473.07`	`5511.94`	`23866.01`	`94488.06`
50	`127.11`	`472.44`	`5639.05`	`24338.45`	`94360.95`
51	`127.75`	`471.80`	`5766.80`	`24810.25`	`94233.20`
52	`128.38`	`471.17`	`5895.18`	`25281.42`	`94104.82`
53	`129.03`	`470.52`	`6024.21`	`25751.94`	`93975.79`
54	`129.67`	`469.88`	`6153.88`	`26221.82`	`93846.12`
55	`130.32`	`469.23`	`6284.20`	`26691.05`	`93715.80`
56	`130.97`	`468.58`	`6415.17`	`27159.63`	`93584.83`
57	`131.63`	`467.92`	`6546.80`	`27627.55`	`93453.20`

THIS REPRESENTS 4.9 YEARS.