IPMT & PPMT.xls

	A	B	C	D	E
1		Loan Amount		100,000.00
2		Annual Interest Rate		8.00%
3		Total Payment Installment		24
4		Payment Mode		Monthly
5		Monthly Payment		4,522.73
6
7	Total Installment	Monthly Payment	Monthly Interest	Monthly Principal	Balance Dues
8	0				100,000.00
9	1	4,522.73	666.67	3,856.06	96,143.94
10	2	4,522.73	640.96	3,881.77	92,262.17
11	3	4,522.73	615.08	3,907.65	88,354.52
12	4	4,522.73	589.03	3,933.70	84,420.82
13	5	4,522.73	562.81	3,959.92	80,460.90
14	6	4,522.73	536.41	3,986.32	76,474.57
15	7	4,522.73	509.83	4,012.90	72,461.68
16	8	4,522.73	483.08	4,039.65	68,422.02
17	9	4,522.73	456.15	4,066.58	64,355.44
18	10	4,522.73	429.04	4,093.69	60,261.75
19	11	4,522.73	401.74	4,120.98	56,140.76
20	12	4,522.73	374.27	4,148.46	51,992.31
21	13	4,522.73	346.62	4,176.11	47,816.19
22	14	4,522.73	318.77	4,203.95	43,612.24
23	15	4,522.73	290.75	4,231.98	39,380.26
24	16	4,522.73	262.54	4,260.19	35,120.06
25	17	4,522.73	234.13	4,288.60	30,831.47
26	18	4,522.73	205.54	4,317.19	26,514.28
27	19	4,522.73	176.76	4,345.97	22,168.32
28	20	4,522.73	147.79	4,374.94	17,793.38
29	21	4,522.73	118.62	4,404.11	13,389.27
30	22	4,522.73	89.26	4,433.47	8,955.80
31	23	4,522.73	59.71	4,463.02	4,492.78
32	24	4,522.73	29.95	4,492.78	0.00
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100