Compare Refinance HomeLoan 02 12 2014.xlsx

	A	B	C	D	E	F	I	J	K	L	M	N
1
2
3
4		MLR=7%			วงเงินกู้	3,500,000		MLR=7.4%			วงเงินกู้	3,500,000
5
6	งวดที่	อัตราดอกเบี้ย	ชำระเงินต้น	ชำระดอกเบี้ย	ยอดชำระ	ยอดหนี้คงเหลือ	งวดที่	อัตราดอกเบี้ย	ชำระเงินต้น	ชำระดอกเบี้ย	ยอดชำระ	ยอดหนี้คงเหลือ
7	1	3.250%	12,650.68	9,349.32	22,000	3,487,349.32	1	3.250%	12,650.68	9,349.32	22,000	3,487,349.32
8	2	3.250%	12,684.48	9,315.52	22,000	3,474,664.84	2	3.250%	12,684.48	9,315.52	22,000	3,474,664.84
9	3	3.250%	12,718.36	9,281.64	22,000	3,461,946.48	3	3.250%	12,718.36	9,281.64	22,000	3,461,946.48
10	4	3.250%	12,752.33	9,247.67	22,000	3,449,194.15	4	3.250%	12,752.33	9,247.67	22,000	3,449,194.15
11	5	3.250%	12,786.40	9,213.60	22,000	3,436,407.75	5	3.250%	12,786.40	9,213.60	22,000	3,436,407.75
12	6	3.250%	12,820.55	9,179.45	22,000	3,423,587.20	6	3.250%	12,820.55	9,179.45	22,000	3,423,587.20
13	7	3.250%	12,854.80	9,145.20	22,000	3,410,732.40	7	3.250%	12,854.80	9,145.20	22,000	3,410,732.40
14	8	3.250%	12,889.14	9,110.86	22,000	3,397,843.26	8	3.250%	12,889.14	9,110.86	22,000	3,397,843.26
15	9	3.250%	12,923.57	9,076.43	22,000	3,384,919.69	9	3.250%	12,923.57	9,076.43	22,000	3,384,919.69
16	10	3.250%	12,958.09	9,041.91	22,000	3,371,961.60	10	3.250%	12,958.09	9,041.91	22,000	3,371,961.60
17	11	3.250%	12,992.71	9,007.29	22,000	3,358,968.89	11	3.250%	12,992.71	9,007.29	22,000	3,358,968.89
18	12	3.250%	13,027.41	8,972.59	22,000	3,345,941.48	12	3.250%	13,027.41	8,972.59	22,000	3,345,941.48
19	13	6.750%	3,436.90	18,563.10	22,000	3,342,504.58	13	6.750%	3,436.90	18,563.10	22,000	3,342,504.58
20	14	6.750%	3,455.97	18,544.03	22,000	3,339,048.61	14	6.750%	3,455.97	18,544.03	22,000	3,339,048.61
21	15	6.750%	3,475.14	18,524.86	22,000	3,335,573.47	15	6.750%	3,475.14	18,524.86	22,000	3,335,573.47
22	16	6.750%	3,494.42	18,505.58	22,000	3,332,079.05	16	6.750%	3,494.42	18,505.58	22,000	3,332,079.05
23	17	6.750%	3,513.81	18,486.19	22,000	3,328,565.24	17	6.750%	3,513.81	18,486.19	22,000	3,328,565.24
24	18	6.750%	3,533.30	18,466.70	22,000	3,325,031.94	18	6.750%	3,533.30	18,466.70	22,000	3,325,031.94
25	19	6.750%	3,552.90	18,447.10	22,000	3,321,479.04	19	6.750%	3,552.90	18,447.10	22,000	3,321,479.04
26	20	6.750%	3,572.62	18,427.38	22,000	3,317,906.42	20	6.750%	3,572.62	18,427.38	22,000	3,317,906.42
27	21	6.750%	3,592.44	18,407.56	22,000	3,314,313.98	21	6.750%	3,592.44	18,407.56	22,000	3,314,313.98
28	22	6.750%	3,612.37	18,387.63	22,000	3,310,701.61	22	6.750%	3,612.37	18,387.63	22,000	3,310,701.61
29	23	6.750%	3,632.41	18,367.59	22,000	3,307,069.20	23	6.750%	3,632.41	18,367.59	22,000	3,307,069.20
30	24	6.750%	3,652.56	18,347.44	22,000	3,303,416.64	24	6.750%	3,652.56	18,347.44	22,000	3,303,416.64
31	25	6.750%	3,672.83	18,327.17	22,000	3,299,743.81	25	6.750%	3,672.83	18,327.17	22,000	3,299,743.81
32	26	6.750%	3,693.20	18,306.80	22,000	3,296,050.61	26	6.750%	3,693.20	18,306.80	22,000	3,296,050.61
33	27	6.750%	3,713.69	18,286.31	22,000	3,292,336.92	27	6.750%	3,713.69	18,286.31	22,000	3,292,336.92
34	28	6.750%	3,734.30	18,265.70	22,000	3,288,602.62	28	6.750%	3,734.30	18,265.70	22,000	3,288,602.62
35	29	6.750%	3,755.01	18,244.99	22,000	3,284,847.61	29	6.750%	3,755.01	18,244.99	22,000	3,284,847.61
36	30	6.750%	3,775.85	18,224.15	22,000	3,281,071.76	30	6.750%	3,775.85	18,224.15	22,000	3,281,071.76
37	31	6.750%	3,796.79	18,203.21	22,000	3,277,274.97	31	6.750%	3,796.79	18,203.21	22,000	3,277,274.97
38	32	6.750%	3,817.86	18,182.14	22,000	3,273,457.11	32	6.750%	3,817.86	18,182.14	22,000	3,273,457.11
39	33	6.750%	3,839.04	18,160.96	22,000	3,269,618.07	33	6.750%	3,839.04	18,160.96	22,000	3,269,618.07
40	34	6.750%	3,860.34	18,139.66	22,000	3,265,757.73	34	6.750%	3,860.34	18,139.66	22,000	3,265,757.73
41	35	6.750%	3,881.75	18,118.25	22,000	3,261,875.98	35	6.750%	3,881.75	18,118.25	22,000	3,261,875.98
42	36	6.750%	3,903.29	18,096.71	22,000	3,257,972.69	36	6.750%	3,903.29	18,096.71	22,000	3,257,972.69
43	37	6.750%	3,924.95	18,075.05	22,000	3,254,047.74	37	1.290%	18,545.66	3,454.34	22,000	3,239,427.03
44	38	6.750%	3,946.72	18,053.28	22,000	3,250,101.02	38	1.290%	18,565.32	3,434.68	22,000	3,220,861.71
45	39	6.750%	3,968.62	18,031.38	22,000	3,246,132.40	39	1.290%	18,585.00	3,415.00	22,000	3,202,276.71
46	40	6.750%	3,990.64	18,009.36	22,000	3,242,141.76	40	1.290%	18,604.71	3,395.29	22,000	3,183,672.00
47	41	6.750%	4,012.78	17,987.22	22,000	3,238,128.98	41	1.290%	18,624.44	3,375.56	22,000	3,165,047.56
48	42	6.750%	4,035.04	17,964.96	22,000	3,234,093.94	42	1.290%	18,644.18	3,355.82	22,000	3,146,403.38
49	43	6.750%	4,057.42	17,942.58	22,000	3,230,036.52	43	1.290%	18,663.95	3,336.05	22,000	3,127,739.43
50	44	6.750%	4,079.93	17,920.07	22,000	3,225,956.59	44	1.290%	18,683.74	3,316.26	22,000	3,109,055.69
51	45	6.750%	4,102.57	17,897.43	22,000	3,221,854.02	45	1.290%	18,703.55	3,296.45	22,000	3,090,352.14
52	46	6.750%	4,125.33	17,874.67	22,000	3,217,728.69	46	5.750%	7,394.91	14,605.09	22,000	3,082,957.23
53	47	6.750%	4,148.22	17,851.78	22,000	3,213,580.47	47	5.750%	7,429.86	14,570.14	22,000	3,075,527.37
54	48	6.750%	4,171.23	17,828.77	22,000	3,209,409.24	48	5.750%	7,464.97	14,535.03	22,000	3,068,062.40
55	49	6.750%	4,194.37	17,805.63	22,000	3,205,214.87	49	5.750%	7,500.25	14,499.75	22,000	3,060,562.15
56	50	6.750%	4,217.64	17,782.36	22,000	3,200,997.23	50	5.750%	7,535.70	14,464.30	22,000	3,053,026.45
57	51	6.750%	4,241.04	17,758.96	22,000	3,196,756.19	51	5.750%	7,571.31	14,428.69	22,000	3,045,455.14
58	52	6.750%	4,264.57	17,735.43	22,000	3,192,491.62	52	5.750%	7,607.10	14,392.90	22,000	3,037,848.04
59	53	6.750%	4,288.23	17,711.77	22,000	3,188,203.39	53	5.750%	7,643.05	14,356.95	22,000	3,030,204.99
60	54	6.750%	4,312.02	17,687.98	22,000	3,183,891.37	54	5.750%	7,679.17	14,320.83	22,000	3,022,525.82
61	55	6.750%	4,335.94	17,664.06	22,000	3,179,555.43	55	5.750%	7,715.46	14,284.54	22,000	3,014,810.36
62	56	6.750%	4,360.00	17,640.00	22,000	3,175,195.43	56	5.750%	7,751.92	14,248.08	22,000	3,007,058.44
63	57	6.750%	4,384.19	17,615.81	22,000	3,170,811.24	57	5.750%	7,788.56	14,211.44	22,000	2,999,269.88
64	58	6.750%	4,408.51	17,591.49	22,000	3,166,402.73	58	5.750%	7,825.37	14,174.63	22,000	2,991,444.51
65	59	6.750%	4,432.97	17,567.03	22,000	3,161,969.76	59	5.750%	7,862.35	14,137.65	22,000	2,983,582.16
66	60	6.750%	4,457.56	17,542.44	22,000	3,157,512.20	60	5.750%	7,899.51	14,100.49	22,000	2,975,682.65
67	61	6.750%	4,482.30	17,517.70	22,000	3,153,029.90	61	5.750%	7,936.84	14,063.16	22,000	2,967,745.81
68	62	6.750%	4,507.16	17,492.84	22,000	3,148,522.74	62	5.750%	7,974.35	14,025.65	22,000	2,959,771.46
69	63	6.750%	4,532.17	17,467.83	22,000	3,143,990.57	63	5.750%	8,012.04	13,987.96	22,000	2,951,759.42
70	64	6.750%	4,557.31	17,442.69	22,000	3,139,433.26	64	5.750%	8,049.90	13,950.10	22,000	2,943,709.52
71	65	6.750%	4,582.60	17,417.40	22,000	3,134,850.66	65	5.750%	8,087.95	13,912.05	22,000	2,935,621.57
72	66	6.750%	4,608.02	17,391.98	22,000	3,130,242.64	66	5.750%	8,126.17	13,873.83	22,000	2,927,495.40
73	67	6.750%	4,633.59	17,366.41	22,000	3,125,609.05	67	5.750%	8,164.58	13,835.42	22,000	2,919,330.82
74	68	6.750%	4,659.29	17,340.71	22,000	3,120,949.76	68	5.750%	8,203.16	13,796.84	22,000	2,911,127.66
75	69	6.750%	4,685.14	17,314.86	22,000	3,116,264.62	69	5.750%	8,241.93	13,758.07	22,000	2,902,885.73
76	70	6.750%	4,711.13	17,288.87	22,000	3,111,553.49	70	5.750%	8,280.88	13,719.12	22,000	2,894,604.85
77	71	6.750%	4,737.27	17,262.73	22,000	3,106,816.22	71	5.750%	8,320.02	13,679.98	22,000	2,886,284.83
78	72	6.750%	4,763.55	17,236.45	22,000	3,102,052.67	72	5.750%	8,359.34	13,640.66	22,000	2,877,925.49
79	73	6.750%	4,789.98	17,210.02	22,000	3,097,262.69	73	6.150%	7,452.68	14,547.32	22,000	2,870,472.81
80	74	6.750%	4,816.56	17,183.44	22,000	3,092,446.13	74	6.150%	7,490.35	14,509.65	22,000	2,862,982.46
81	75	6.750%	4,843.28	17,156.72	22,000	3,087,602.85	75	6.150%	7,528.21	14,471.79	22,000	2,855,454.25
82	76	6.750%	4,870.15	17,129.85	22,000	3,082,732.70	76	6.150%	7,566.27	14,433.73	22,000	2,847,887.98
83	77	6.750%	4,897.17	17,102.83	22,000	3,077,835.53	77	6.150%	7,604.51	14,395.49	22,000	2,840,283.47
84	78	6.750%	4,924.34	17,075.66	22,000	3,072,911.19	78	6.150%	7,642.95	14,357.05	22,000	2,832,640.52
85	79	6.750%	4,951.66	17,048.34	22,000	3,067,959.53	79	6.150%	7,681.58	14,318.42	22,000	2,824,958.94
86	80	6.750%	4,979.13	17,020.87	22,000	3,062,980.40	80	6.150%	7,720.41	14,279.59	22,000	2,817,238.53
87	81	6.750%	5,006.75	16,993.25	22,000	3,057,973.65	81	6.150%	7,759.44	14,240.56	22,000	2,809,479.09
88	82	6.750%	5,034.53	16,965.47	22,000	3,052,939.12	82	6.150%	7,798.66	14,201.34	22,000	2,801,680.43
89	83	6.750%	5,062.46	16,937.54	22,000	3,047,876.66	83	6.150%	7,838.08	14,161.92	22,000	2,793,842.35
90	84	6.750%	5,090.55	16,909.45	22,000	3,042,786.11	84	6.150%	7,877.70	14,122.30	22,000	2,785,964.65
91	85	6.750%	5,118.79	16,881.21	22,000	3,037,667.32	85	6.150%	7,917.52	14,082.48	22,000	2,778,047.13
92	86	6.750%	5,147.19	16,852.81	22,000	3,032,520.13	86	6.150%	7,957.54	14,042.46	22,000	2,770,089.59
93	87	6.750%	5,175.74	16,824.26	22,000	3,027,344.39	87	6.150%	7,997.77	14,002.23	22,000	2,762,091.82
94	88	6.750%	5,204.46	16,795.54	22,000	3,022,139.93	88	6.150%	8,038.19	13,961.81	22,000	2,754,053.63
95	89	6.750%	5,233.33	16,766.67	22,000	3,016,906.60	89	6.150%	8,078.82	13,921.18	22,000	2,745,974.81
96	90	6.750%	5,262.37	16,737.63	22,000	3,011,644.23	90	6.150%	8,119.66	13,880.34	22,000	2,737,855.15
97	91	6.750%	5,291.56	16,708.44	22,000	3,006,352.67	91	6.150%	8,160.70	13,839.30	22,000	2,729,694.45
98	92	6.750%	5,320.92	16,679.08	22,000	3,001,031.75	92	6.150%	8,201.96	13,798.04	22,000	2,721,492.49
99	93	6.750%	5,350.44	16,649.56	22,000	2,995,681.31	93	6.150%	8,243.41	13,756.59	22,000	2,713,249.08
100	94	6.750%	5,380.12	16,619.88	22,000	2,990,301.19	94	6.150%	8,285.08	13,714.92	22,000	2,704,964.00