A property is bought 5 years ago for $250,000 putting 20% down and financing the rest for 30 years with a fixed-rate loan of 5% a year.

What is the monthly payment of the loan?

Using the "housing" tab, how much equity is in the property today?

What percent of the equity today is due to the paying down of the principal?

What percent is due to the increase in the value of the property?

Where did the rest come from? What percent was it?

If the property was refinanced today using a 25 year loan with an annual rate of 4%, what would be the monthly savings?

35 1/1/2018 194.95 36 2/1/2018 195.22 37 3/1/2018 195.58 38 4/1/2018 195.99 39 5/1/2018 196.27 40 6/1/2018 197.06 41 7/1/2018 198.73 142 8/1/2018 200.7 43 9/1/2018 202.63 4 10/1/2018 204.23 45 11/1/2018 205.15 46 12/1/2018 205.52 47 1/1/2019 205.57 48 2/1/2019 205.57 49 3/1/2019 205.31 | 50 4/1/2019 204.9 151 5/1/2019 204.42 52 6/1/2019 204.67 53 1/2019 206.03 54 8/1/2019 207.96 55 9/1/2019 209.61 56 10/1/2019 210.86 57 11/1/2019 211.63 58 12/1/2019 212.02 59 1/1/2020 212.21 | 60 2/1/2020 212.43 Date housing index 0 2/1/2015 166.93 1 3/1/2015 166.68 2 4 /1/2015 166.49 3 5/1/2015 166.29 4 6/1/2015 166.68 5 7/1/2015 168.14 6 8/1/2015 170.01 7 9/1/2015 171.88 8 10/1/2015 173.48 9 11/1/2015 174.52 10 12/1/2015 174.97 11 1/1/2016 175.08 12 2/1/2016 175.09 13 3/1/2016 175.19 14 4/1/2016 175.17 15 5/1/2016 175.09 16 6/1/2016 175.33 17 7/1/2016 176.65 18 8/1/2016 178.53 19 9/1/2016 180.38 20 10/1/2016 181.96 21 11/1/2016 183.08 22 12/1/2016 183.73 23 1/1/2017 184.03 24 2/1/2017 184.11 25 3/1/2017 184.33 26 4/1/2017 184.51 27 5/1/2017 184.76 28 6/1/2017 185.12 29 7/1/2017 186.63 30 8/1/2017 188.63 31 9/1/2017 190.63 32 10/1/2017 192.38 33 11/1/2017 193.64 34 12/1/2017 194.48