| A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z | ||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | Bản quyền thuộc Aki Đinh - Dân kế hoạch làm sáng tạo! Liên hệ với mình qua zalo 0968267682/email: akidinh91@gmail.com nếu bạn cần hỗ trợ thêm nhé! | ||||||||||||||||||||||||||
2 | |||||||||||||||||||||||||||
3 | BẢNG TÍNH GỐC LÃI - PHƯƠNG ÁN VAY | ||||||||||||||||||||||||||
4 | Tên bạn là: | Thời gian/Phí trả trước hạn | Note | ||||||||||||||||||||||||
5 | Số tiền giải ngân | 2,000,000,000 | Năm 1 | 3.00% | Phần note màu vàng là vùng bạn có thể thay đổi dữ liệu nhé! | ||||||||||||||||||||||
6 | Thời gian vay (tháng) | 420 | Năm 2 | 2.00% | |||||||||||||||||||||||
7 | Thời gian lãi suất cố định (tháng) | 12 | Năm 3 | 1.0% | |||||||||||||||||||||||
8 | Lãi suất cố định (%) | 6.70% | Năm 4 | 0% | |||||||||||||||||||||||
9 | Lãi suất thả nổi (tạm tính) | 9.40% | |||||||||||||||||||||||||
10 | Thời gian ân hạn nợ gốc (Tháng) | 0.0 | |||||||||||||||||||||||||
11 | Thời gian sau ân hạn gốc (Tháng) | 420 | |||||||||||||||||||||||||
12 | Tiền gốc trả hàng tháng | 4,761,905 | |||||||||||||||||||||||||
13 | |||||||||||||||||||||||||||
14 | Kỳ | Ngảy trả nợ | Số ngày tính lãi | Dư nợ | Trả gốc | Trả lãi | Gốc lãi trả hàng tháng | Dư nợ cuối kỳ | Phí phạt trả nợ trước hạn | ||||||||||||||||||
15 | 0 | 1/5/2025 | 0.00 | 2,000,000,000 | 0 | 0 | 0 | ||||||||||||||||||||
16 | 1 | 31/5/2025 | 30.00 | 2,000,000,000 | 4,761,905 | 11,013,699 | 15,775,603 | 1,995,238,095 | 59,857,142.86 | Năm 1 | |||||||||||||||||
17 | 2 | 30/6/2025 | 30.00 | 1,995,238,095 | 4,761,905 | 10,987,476 | 15,749,380 | 1,990,476,190 | 59,714,285.71 | ||||||||||||||||||
18 | 3 | 31/7/2025 | 31.00 | 1,990,476,190 | 4,761,905 | 11,326,628 | 16,088,532 | 1,985,714,286 | 59,571,428.57 | ||||||||||||||||||
19 | 4 | 31/8/2025 | 31.00 | 1,985,714,286 | 4,761,905 | 11,299,530 | 16,061,435 | 1,980,952,381 | 59,428,571.43 | ||||||||||||||||||
20 | 5 | 30/9/2025 | 30.00 | 1,980,952,381 | 4,761,905 | 10,908,806 | 15,670,711 | 1,976,190,476 | 59,285,714.29 | ||||||||||||||||||
21 | 6 | 31/10/2025 | 31.00 | 1,976,190,476 | 4,761,905 | 11,245,336 | 16,007,241 | 1,971,428,571 | 59,142,857.14 | ||||||||||||||||||
22 | 7 | 30/11/2025 | 30.00 | 1,971,428,571 | 4,761,905 | 10,856,360 | 15,618,265 | 1,966,666,667 | 59,000,000.00 | ||||||||||||||||||
23 | 8 | 31/12/2025 | 31.00 | 1,966,666,667 | 4,761,905 | 11,191,142 | 15,953,046 | 1,961,904,762 | 58,857,142.86 | ||||||||||||||||||
24 | 9 | 31/1/2026 | 31.00 | 1,961,904,762 | 4,761,905 | 11,164,044 | 15,925,949 | 1,957,142,857 | 58,714,285.71 | ||||||||||||||||||
25 | 10 | 28/2/2026 | 28.00 | 1,957,142,857 | 4,761,905 | 10,059,178 | 14,821,083 | 1,952,380,952 | 58,571,428.57 | ||||||||||||||||||
26 | 11 | 31/3/2026 | 31.00 | 1,952,380,952 | 4,761,905 | 11,109,850 | 15,871,755 | 1,947,619,048 | 58,428,571.43 | ||||||||||||||||||
27 | 12 | 30/4/2026 | 30.00 | 1,947,619,048 | 4,761,905 | 10,725,245 | 15,487,149 | 1,942,857,143 | 58,285,714.29 | ||||||||||||||||||
28 | 13 | 31/5/2026 | 31.00 | 1,942,857,143 | 4,761,905 | 15,510,920 | 20,272,825 | 1,938,095,238 | 38,761,904.76 | Năm 2 | |||||||||||||||||
29 | 14 | 30/6/2026 | 30.00 | 1,938,095,238 | 4,761,905 | 14,973,777 | 19,735,682 | 1,933,333,333 | 38,666,666.67 | ||||||||||||||||||
30 | 15 | 31/7/2026 | 31.00 | 1,933,333,333 | 4,761,905 | 15,434,886 | 20,196,791 | 1,928,571,429 | 38,571,428.57 | ||||||||||||||||||
31 | 16 | 31/8/2026 | 31.00 | 1,928,571,429 | 4,761,905 | 15,396,869 | 20,158,774 | 1,923,809,524 | 38,476,190.48 | ||||||||||||||||||
32 | 17 | 30/9/2026 | 30.00 | 1,923,809,524 | 4,761,905 | 14,863,405 | 19,625,310 | 1,919,047,619 | 38,380,952.38 | ||||||||||||||||||
33 | 18 | 31/10/2026 | 31.00 | 1,919,047,619 | 4,761,905 | 15,320,835 | 20,082,740 | 1,914,285,714 | 38,285,714.29 | ||||||||||||||||||
34 | 19 | 30/11/2026 | 30.00 | 1,914,285,714 | 4,761,905 | 14,789,824 | 19,551,729 | 1,909,523,810 | 38,190,476.19 | ||||||||||||||||||
35 | 20 | 31/12/2026 | 31.00 | 1,909,523,810 | 4,761,905 | 15,244,801 | 20,006,706 | 1,904,761,905 | 38,095,238.10 | ||||||||||||||||||
36 | 21 | 31/1/2027 | 31.00 | 1,904,761,905 | 4,761,905 | 15,206,784 | 19,968,689 | 1,900,000,000 | 38,000,000.00 | ||||||||||||||||||
37 | 22 | 28/2/2027 | 28.00 | 1,900,000,000 | 4,761,905 | 13,700,822 | 18,462,727 | 1,895,238,095 | 37,904,761.90 | ||||||||||||||||||
38 | 23 | 31/3/2027 | 31.00 | 1,895,238,095 | 4,761,905 | 15,130,750 | 19,892,655 | 1,890,476,190 | 37,809,523.81 | ||||||||||||||||||
39 | 24 | 30/4/2027 | 30.00 | 1,890,476,190 | 4,761,905 | 14,605,871 | 19,367,776 | 1,885,714,286 | 37,714,285.71 | ||||||||||||||||||
40 | 25 | 31/5/2027 | 31.00 | 1,885,714,286 | 4,761,905 | 15,054,716 | 19,816,621 | 1,880,952,381 | 18,809,523.81 | Năm 3 | |||||||||||||||||
41 | 26 | 30/6/2027 | 30.00 | 1,880,952,381 | 4,761,905 | 14,532,290 | 19,294,194 | 1,876,190,476 | 18,761,904.76 | ||||||||||||||||||
42 | 27 | 31/7/2027 | 31.00 | 1,876,190,476 | 4,761,905 | 14,978,682 | 19,740,587 | 1,871,428,571 | 18,714,285.71 | ||||||||||||||||||
43 | 28 | 31/8/2027 | 31.00 | 1,871,428,571 | 4,761,905 | 14,940,665 | 19,702,570 | 1,866,666,667 | 18,666,666.67 | ||||||||||||||||||
44 | 29 | 30/9/2027 | 30.00 | 1,866,666,667 | 4,761,905 | 14,421,918 | 19,183,823 | 1,861,904,762 | 18,619,047.62 | ||||||||||||||||||
45 | 30 | 31/10/2027 | 31.00 | 1,861,904,762 | 4,761,905 | 14,864,631 | 19,626,536 | 1,857,142,857 | 18,571,428.57 | ||||||||||||||||||
46 | 31 | 30/11/2027 | 30.00 | 1,857,142,857 | 4,761,905 | 14,348,337 | 19,110,241 | 1,852,380,952 | 18,523,809.52 | ||||||||||||||||||
47 | 32 | 31/12/2027 | 31.00 | 1,852,380,952 | 4,761,905 | 14,788,598 | 19,550,502 | 1,847,619,048 | 18,476,190.48 | ||||||||||||||||||
48 | 33 | 31/1/2028 | 31.00 | 1,847,619,048 | 4,761,905 | 14,750,581 | 19,512,485 | 1,842,857,143 | 18,428,571.43 | ||||||||||||||||||
49 | 34 | 29/2/2028 | 29.00 | 1,842,857,143 | 4,761,905 | 13,763,366 | 18,525,271 | 1,838,095,238 | 18,380,952.38 | ||||||||||||||||||
50 | 35 | 31/3/2028 | 31.00 | 1,838,095,238 | 4,761,905 | 14,674,547 | 19,436,451 | 1,833,333,333 | 18,333,333.33 | ||||||||||||||||||
51 | 36 | 30/4/2028 | 30.00 | 1,833,333,333 | 4,761,905 | 14,164,384 | 18,926,288 | 1,828,571,429 | 18,285,714.29 | ||||||||||||||||||
52 | 37 | 31/5/2028 | 31.00 | 1,828,571,429 | 4,761,905 | 14,598,513 | 19,360,417 | 1,823,809,524 | 0 | Năm 4 | |||||||||||||||||
53 | 38 | 30/6/2028 | 30.00 | 1,823,809,524 | 4,761,905 | 14,090,802 | 18,852,707 | 1,819,047,619 | - | ||||||||||||||||||
54 | 39 | 31/7/2028 | 31.00 | 1,819,047,619 | 4,761,905 | 14,522,479 | 19,284,384 | 1,814,285,714 | - | ||||||||||||||||||
55 | 40 | 31/8/2028 | 31.00 | 1,814,285,714 | 4,761,905 | 14,484,462 | 19,246,367 | 1,809,523,810 | - | ||||||||||||||||||
56 | 41 | 30/9/2028 | 30.00 | 1,809,523,810 | 4,761,905 | 13,980,431 | 18,742,335 | 1,804,761,905 | - | ||||||||||||||||||
57 | 42 | 31/10/2028 | 31.00 | 1,804,761,905 | 4,761,905 | 14,408,428 | 19,170,333 | 1,800,000,000 | - | ||||||||||||||||||
58 | 43 | 30/11/2028 | 30.00 | 1,800,000,000 | 4,761,905 | 13,906,849 | 18,668,754 | 1,795,238,095 | - | ||||||||||||||||||
59 | 44 | 31/12/2028 | 31.00 | 1,795,238,095 | 4,761,905 | 14,332,394 | 19,094,299 | 1,790,476,190 | - | ||||||||||||||||||
60 | 45 | 31/1/2029 | 31.00 | 1,790,476,190 | 4,761,905 | 14,294,377 | 19,056,282 | 1,785,714,286 | - | ||||||||||||||||||
61 | 46 | 28/2/2029 | 28.00 | 1,785,714,286 | 4,761,905 | 12,876,712 | 17,638,617 | 1,780,952,381 | - | ||||||||||||||||||
62 | 47 | 31/3/2029 | 31.00 | 1,780,952,381 | 4,761,905 | 14,218,343 | 18,980,248 | 1,776,190,476 | - | ||||||||||||||||||
63 | 48 | 30/4/2029 | 30.00 | 1,776,190,476 | 4,761,905 | 13,722,896 | 18,484,801 | 1,771,428,571 | - | ||||||||||||||||||
64 | 49 | 31/5/2029 | 31.00 | 1,771,428,571 | 4,761,905 | 14,142,309 | 18,904,214 | 1,766,666,667 | - | ||||||||||||||||||
65 | 50 | 30/6/2029 | 30.00 | 1,766,666,667 | 4,761,905 | 13,649,315 | 18,411,220 | 1,761,904,762 | - | ||||||||||||||||||
66 | 51 | 31/7/2029 | 31.00 | 1,761,904,762 | 4,761,905 | 14,066,275 | 18,828,180 | 1,757,142,857 | - | ||||||||||||||||||
67 | 52 | 31/8/2029 | 31.00 | 1,757,142,857 | 4,761,905 | 14,028,258 | 18,790,163 | 1,752,380,952 | - | ||||||||||||||||||
68 | 53 | 30/9/2029 | 30.00 | 1,752,380,952 | 4,761,905 | 13,538,943 | 18,300,848 | 1,747,619,048 | - | ||||||||||||||||||
69 | 54 | 31/10/2029 | 31.00 | 1,747,619,048 | 4,761,905 | 13,952,224 | 18,714,129 | 1,742,857,143 | - | ||||||||||||||||||
70 | 55 | 30/11/2029 | 30.00 | 1,742,857,143 | 4,761,905 | 13,465,362 | 18,227,267 | 1,738,095,238 | - | ||||||||||||||||||
71 | 56 | 31/12/2029 | 31.00 | 1,738,095,238 | 4,761,905 | 13,876,190 | 18,638,095 | 1,733,333,333 | - | ||||||||||||||||||
72 | 57 | 31/1/2030 | 31.00 | 1,733,333,333 | 4,761,905 | 13,838,174 | 18,600,078 | 1,728,571,429 | - | ||||||||||||||||||
73 | 58 | 28/2/2030 | 28.00 | 1,728,571,429 | 4,761,905 | 12,464,658 | 17,226,562 | 1,723,809,524 | - | ||||||||||||||||||
74 | 59 | 31/3/2030 | 31.00 | 1,723,809,524 | 4,761,905 | 13,762,140 | 18,524,044 | 1,719,047,619 | - | ||||||||||||||||||
75 | 60 | 30/4/2030 | 30.00 | 1,719,047,619 | 4,761,905 | 13,281,409 | 18,043,314 | 1,714,285,714 | - | ||||||||||||||||||
76 | 61 | 31/5/2030 | 31.00 | 1,714,285,714 | 4,761,905 | 13,686,106 | 18,448,010 | 1,709,523,810 | - | ||||||||||||||||||
77 | 62 | 30/6/2030 | 30.00 | 1,709,523,810 | 4,761,905 | 13,207,828 | 17,969,733 | 1,704,761,905 | - | ||||||||||||||||||
78 | 63 | 31/7/2030 | 31.00 | 1,704,761,905 | 4,761,905 | 13,610,072 | 18,371,977 | 1,700,000,000 | - | ||||||||||||||||||
79 | 64 | 31/8/2030 | 31.00 | 1,700,000,000 | 4,761,905 | 13,572,055 | 18,333,960 | 1,695,238,095 | - | ||||||||||||||||||
80 | 65 | 30/9/2030 | 30.00 | 1,695,238,095 | 4,761,905 | 13,097,456 | 17,859,361 | 1,690,476,190 | - | ||||||||||||||||||
81 | 66 | 31/10/2030 | 31.00 | 1,690,476,190 | 4,761,905 | 13,496,021 | 18,257,926 | 1,685,714,286 | - | ||||||||||||||||||
82 | 67 | 30/11/2030 | 30.00 | 1,685,714,286 | 4,761,905 | 13,023,875 | 17,785,780 | 1,680,952,381 | - | ||||||||||||||||||
83 | 68 | 31/12/2030 | 31.00 | 1,680,952,381 | 4,761,905 | 13,419,987 | 18,181,892 | 1,676,190,476 | - | ||||||||||||||||||
84 | 69 | 31/1/2031 | 31.00 | 1,676,190,476 | 4,761,905 | 13,381,970 | 18,143,875 | 1,671,428,571 | - | ||||||||||||||||||
85 | 70 | 28/2/2031 | 28.00 | 1,671,428,571 | 4,761,905 | 12,052,603 | 16,814,508 | 1,666,666,667 | - | ||||||||||||||||||
86 | 71 | 31/3/2031 | 31.00 | 1,666,666,667 | 4,761,905 | 13,305,936 | 18,067,841 | 1,661,904,762 | - | ||||||||||||||||||
87 | 72 | 30/4/2031 | 30.00 | 1,661,904,762 | 4,761,905 | 12,839,922 | 17,601,826 | 1,657,142,857 | - | ||||||||||||||||||
88 | 73 | 31/5/2031 | 31.00 | 1,657,142,857 | 4,761,905 | 13,229,902 | 17,991,807 | 1,652,380,952 | - | ||||||||||||||||||
89 | 74 | 30/6/2031 | 30.00 | 1,652,380,952 | 4,761,905 | 12,766,341 | 17,528,245 | 1,647,619,048 | - | ||||||||||||||||||
90 | 75 | 31/7/2031 | 31.00 | 1,647,619,048 | 4,761,905 | 13,153,868 | 17,915,773 | 1,642,857,143 | - | ||||||||||||||||||
91 | 76 | 31/8/2031 | 31.00 | 1,642,857,143 | 4,761,905 | 13,115,851 | 17,877,756 | 1,638,095,238 | - | ||||||||||||||||||
92 | 77 | 30/9/2031 | 30.00 | 1,638,095,238 | 4,761,905 | 12,655,969 | 17,417,873 | 1,633,333,333 | - | ||||||||||||||||||
93 | 78 | 31/10/2031 | 31.00 | 1,633,333,333 | 4,761,905 | 13,039,817 | 17,801,722 | 1,628,571,429 | - | ||||||||||||||||||
94 | 79 | 30/11/2031 | 30.00 | 1,628,571,429 | 4,761,905 | 12,582,387 | 17,344,292 | 1,623,809,524 | - | ||||||||||||||||||
95 | 80 | 31/12/2031 | 31.00 | 1,623,809,524 | 4,761,905 | 12,963,783 | 17,725,688 | 1,619,047,619 | - | ||||||||||||||||||
96 | 81 | 31/1/2032 | 31.00 | 1,619,047,619 | 4,761,905 | 12,925,766 | 17,687,671 | 1,614,285,714 | - | ||||||||||||||||||
97 | 82 | 29/2/2032 | 29.00 | 1,614,285,714 | 4,761,905 | 12,056,282 | 16,818,187 | 1,609,523,810 | - | ||||||||||||||||||
98 | 83 | 31/3/2032 | 31.00 | 1,609,523,810 | 4,761,905 | 12,849,733 | 17,611,637 | 1,604,761,905 | - | ||||||||||||||||||
99 | 84 | 30/4/2032 | 30.00 | 1,604,761,905 | 4,761,905 | 12,398,434 | 17,160,339 | 1,600,000,000 | - | ||||||||||||||||||
100 | 85 | 31/5/2032 | 31.00 | 1,600,000,000 | 4,761,905 | 12,773,699 | 17,535,603 | 1,595,238,095 | - | ||||||||||||||||||