ABCDE
1
BẢNG TÍNH LÃI TRÊN DƯ NỢ GIẢM DẦN
2
Số năm vay10.0Made bySteven Hoang
(Hoang Tuan Thanh)
3
Lãi suất cho vay (%/tháng, = lãi suất năm /12)0.8DeptMazda team
4
Số tiền cần vay
(Điền số tiền cần vay)
1,200,000,000
5
Thứ tự
các tháng
Tiền gốc còn lạiTiền gốc trả
hàng tháng
Tiền lãi trả
hàng tháng
Tiền trả hàng tháng
bao gồm cả gốc và lãi
6
01,200,000,000000
7
11,190,000,00010,000,0009,600,00019,600,000
8
21,180,000,00010,000,0009,520,00019,520,000
9
31,170,000,00010,000,0009,440,00019,440,000
10
41,160,000,00010,000,0009,360,00019,360,000
11
51,150,000,00010,000,0009,280,00019,280,000
12
61,140,000,00010,000,0009,200,00019,200,000
13
71,130,000,00010,000,0009,120,00019,120,000
14
81,120,000,00010,000,0009,040,00019,040,000
15
91,110,000,00010,000,0008,960,00018,960,000
16
101,100,000,00010,000,0008,880,00018,880,000
17
111,090,000,00010,000,0008,800,00018,800,000
18
121,080,000,00010,000,0008,720,00018,720,000
19
131,070,000,00010,000,0008,640,00018,640,000
20
141,060,000,00010,000,0008,560,00018,560,000
21
151,050,000,00010,000,0008,480,00018,480,000
22
161,040,000,00010,000,0008,400,00018,400,000
23
171,030,000,00010,000,0008,320,00018,320,000
24
181,020,000,00010,000,0008,240,00018,240,000
25
191,010,000,00010,000,0008,160,00018,160,000
26
201,000,000,00010,000,0008,080,00018,080,000
27
21990,000,00010,000,0008,000,00018,000,000
28
22980,000,00010,000,0007,920,00017,920,000
29
23970,000,00010,000,0007,840,00017,840,000
30
24960,000,00010,000,0007,760,00017,760,000
31
25950,000,00010,000,0007,680,00017,680,000
32
26940,000,00010,000,0007,600,00017,600,000
33
27930,000,00010,000,0007,520,00017,520,000
34
28920,000,00010,000,0007,440,00017,440,000
35
29910,000,00010,000,0007,360,00017,360,000
36
30900,000,00010,000,0007,280,00017,280,000
37
31890,000,00010,000,0007,200,00017,200,000
38
32880,000,00010,000,0007,120,00017,120,000
39
33870,000,00010,000,0007,040,00017,040,000
40
34860,000,00010,000,0006,960,00016,960,000
41
35850,000,00010,000,0006,880,00016,880,000
42
36840,000,00010,000,0006,800,00016,800,000
43
37830,000,00010,000,0006,720,00016,720,000
44
38820,000,00010,000,0006,640,00016,640,000
45
39810,000,00010,000,0006,560,00016,560,000
46
40800,000,00010,000,0006,480,00016,480,000
47
41790,000,00010,000,0006,400,00016,400,000
48
42780,000,00010,000,0006,320,00016,320,000
49
43770,000,00010,000,0006,240,00016,240,000
50
44760,000,00010,000,0006,160,00016,160,000
51
45750,000,00010,000,0006,080,00016,080,000
52
46740,000,00010,000,0006,000,00016,000,000
53
47730,000,00010,000,0005,920,00015,920,000
54
48720,000,00010,000,0005,840,00015,840,000
55
49710,000,00010,000,0005,760,00015,760,000
56
50700,000,00010,000,0005,680,00015,680,000
57
51690,000,00010,000,0005,600,00015,600,000
58
52680,000,00010,000,0005,520,00015,520,000
59
53670,000,00010,000,0005,440,00015,440,000
60
54660,000,00010,000,0005,360,00015,360,000
61
55650,000,00010,000,0005,280,00015,280,000
62
56640,000,00010,000,0005,200,00015,200,000
63
57630,000,00010,000,0005,120,00015,120,000
64
58620,000,00010,000,0005,040,00015,040,000
65
59610,000,00010,000,0004,960,00014,960,000
66
60600,000,00010,000,0004,880,00014,880,000
67
TỔNG SỐ600,000,000434,400,0001,034,400,000
68
Ghi chú: Phần chữ mầu đỏ là phần nhập số liệu
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