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 on the loan?

Using the housing tab, how much equity is in the property today? (2/1/2020)

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?

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