| A | B | C | D | E | |
|---|---|---|---|---|---|
1 | BẢNG TÍNH LÃI TRÊN DƯ NỢ GIẢM DẦN | ||||
2 | Số năm vay | 10.0 | Made by | Steven Hoang (Hoang Tuan Thanh) | |
3 | Lãi suất cho vay (%/tháng, = lãi suất năm /12) | 0.8 | Dept | Mazda 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ại | Tiề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 | 0 | 1,200,000,000 | 0 | 0 | 0 |
7 | 1 | 1,190,000,000 | 10,000,000 | 9,600,000 | 19,600,000 |
8 | 2 | 1,180,000,000 | 10,000,000 | 9,520,000 | 19,520,000 |
9 | 3 | 1,170,000,000 | 10,000,000 | 9,440,000 | 19,440,000 |
10 | 4 | 1,160,000,000 | 10,000,000 | 9,360,000 | 19,360,000 |
11 | 5 | 1,150,000,000 | 10,000,000 | 9,280,000 | 19,280,000 |
12 | 6 | 1,140,000,000 | 10,000,000 | 9,200,000 | 19,200,000 |
13 | 7 | 1,130,000,000 | 10,000,000 | 9,120,000 | 19,120,000 |
14 | 8 | 1,120,000,000 | 10,000,000 | 9,040,000 | 19,040,000 |
15 | 9 | 1,110,000,000 | 10,000,000 | 8,960,000 | 18,960,000 |
16 | 10 | 1,100,000,000 | 10,000,000 | 8,880,000 | 18,880,000 |
17 | 11 | 1,090,000,000 | 10,000,000 | 8,800,000 | 18,800,000 |
18 | 12 | 1,080,000,000 | 10,000,000 | 8,720,000 | 18,720,000 |
19 | 13 | 1,070,000,000 | 10,000,000 | 8,640,000 | 18,640,000 |
20 | 14 | 1,060,000,000 | 10,000,000 | 8,560,000 | 18,560,000 |
21 | 15 | 1,050,000,000 | 10,000,000 | 8,480,000 | 18,480,000 |
22 | 16 | 1,040,000,000 | 10,000,000 | 8,400,000 | 18,400,000 |
23 | 17 | 1,030,000,000 | 10,000,000 | 8,320,000 | 18,320,000 |
24 | 18 | 1,020,000,000 | 10,000,000 | 8,240,000 | 18,240,000 |
25 | 19 | 1,010,000,000 | 10,000,000 | 8,160,000 | 18,160,000 |
26 | 20 | 1,000,000,000 | 10,000,000 | 8,080,000 | 18,080,000 |
27 | 21 | 990,000,000 | 10,000,000 | 8,000,000 | 18,000,000 |
28 | 22 | 980,000,000 | 10,000,000 | 7,920,000 | 17,920,000 |
29 | 23 | 970,000,000 | 10,000,000 | 7,840,000 | 17,840,000 |
30 | 24 | 960,000,000 | 10,000,000 | 7,760,000 | 17,760,000 |
31 | 25 | 950,000,000 | 10,000,000 | 7,680,000 | 17,680,000 |
32 | 26 | 940,000,000 | 10,000,000 | 7,600,000 | 17,600,000 |
33 | 27 | 930,000,000 | 10,000,000 | 7,520,000 | 17,520,000 |
34 | 28 | 920,000,000 | 10,000,000 | 7,440,000 | 17,440,000 |
35 | 29 | 910,000,000 | 10,000,000 | 7,360,000 | 17,360,000 |
36 | 30 | 900,000,000 | 10,000,000 | 7,280,000 | 17,280,000 |
37 | 31 | 890,000,000 | 10,000,000 | 7,200,000 | 17,200,000 |
38 | 32 | 880,000,000 | 10,000,000 | 7,120,000 | 17,120,000 |
39 | 33 | 870,000,000 | 10,000,000 | 7,040,000 | 17,040,000 |
40 | 34 | 860,000,000 | 10,000,000 | 6,960,000 | 16,960,000 |
41 | 35 | 850,000,000 | 10,000,000 | 6,880,000 | 16,880,000 |
42 | 36 | 840,000,000 | 10,000,000 | 6,800,000 | 16,800,000 |
43 | 37 | 830,000,000 | 10,000,000 | 6,720,000 | 16,720,000 |
44 | 38 | 820,000,000 | 10,000,000 | 6,640,000 | 16,640,000 |
45 | 39 | 810,000,000 | 10,000,000 | 6,560,000 | 16,560,000 |
46 | 40 | 800,000,000 | 10,000,000 | 6,480,000 | 16,480,000 |
47 | 41 | 790,000,000 | 10,000,000 | 6,400,000 | 16,400,000 |
48 | 42 | 780,000,000 | 10,000,000 | 6,320,000 | 16,320,000 |
49 | 43 | 770,000,000 | 10,000,000 | 6,240,000 | 16,240,000 |
50 | 44 | 760,000,000 | 10,000,000 | 6,160,000 | 16,160,000 |
51 | 45 | 750,000,000 | 10,000,000 | 6,080,000 | 16,080,000 |
52 | 46 | 740,000,000 | 10,000,000 | 6,000,000 | 16,000,000 |
53 | 47 | 730,000,000 | 10,000,000 | 5,920,000 | 15,920,000 |
54 | 48 | 720,000,000 | 10,000,000 | 5,840,000 | 15,840,000 |
55 | 49 | 710,000,000 | 10,000,000 | 5,760,000 | 15,760,000 |
56 | 50 | 700,000,000 | 10,000,000 | 5,680,000 | 15,680,000 |
57 | 51 | 690,000,000 | 10,000,000 | 5,600,000 | 15,600,000 |
58 | 52 | 680,000,000 | 10,000,000 | 5,520,000 | 15,520,000 |
59 | 53 | 670,000,000 | 10,000,000 | 5,440,000 | 15,440,000 |
60 | 54 | 660,000,000 | 10,000,000 | 5,360,000 | 15,360,000 |
61 | 55 | 650,000,000 | 10,000,000 | 5,280,000 | 15,280,000 |
62 | 56 | 640,000,000 | 10,000,000 | 5,200,000 | 15,200,000 |
63 | 57 | 630,000,000 | 10,000,000 | 5,120,000 | 15,120,000 |
64 | 58 | 620,000,000 | 10,000,000 | 5,040,000 | 15,040,000 |
65 | 59 | 610,000,000 | 10,000,000 | 4,960,000 | 14,960,000 |
66 | 60 | 600,000,000 | 10,000,000 | 4,880,000 | 14,880,000 |
67 | TỔNG SỐ | 600,000,000 | 434,400,000 | 1,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 | |||||