A | B | C | D | E | F | |
---|---|---|---|---|---|---|
1 | ||||||
2 | 貸款金額 | 2400000 | ||||
3 | 代辨費用 | 137040 | ||||
4 | 貸款利率(年) | 4.48% | ||||
5 | 等效IRR | 6.253% | ||||
6 | 期數(月) | 償還本金 | 償還利息 | 還月償還金額 | 貸款餘額 | |
7 | 0 | $2,400,000 | $2,262,960 | |||
8 | 1 | $24,382 | $8,952 | $33,334 | $2,375,618 | $-33,334 |
9 | 2 | $24,473 | $8,861 | $33,334 | $2,351,146 | $-33,334 |
10 | 3 | $24,564 | $8,770 | $33,334 | $2,326,582 | $-33,334 |
11 | 4 | $24,655 | $8,678 | $33,334 | $2,301,927 | $-33,334 |
12 | 5 | $24,747 | $8,586 | $33,334 | $2,277,179 | $-33,334 |
13 | 6 | $24,840 | $8,494 | $33,334 | $2,252,339 | $-33,334 |
14 | 7 | $24,932 | $8,401 | $33,334 | $2,227,407 | $-33,334 |
15 | 8 | $25,025 | $8,308 | $33,334 | $2,202,382 | $-33,334 |
16 | 9 | $25,119 | $8,215 | $33,334 | $2,177,263 | $-33,334 |
17 | 10 | $25,212 | $8,121 | $33,334 | $2,152,051 | $-33,334 |
18 | 11 | $25,306 | $8,027 | $33,334 | $2,126,744 | $-33,334 |
19 | 12 | $25,401 | $7,933 | $33,334 | $2,101,343 | $-33,334 |
20 | 13 | $25,496 | $7,838 | $33,334 | $2,075,848 | $-33,334 |
21 | 14 | $25,591 | $7,743 | $33,334 | $2,050,257 | $-33,334 |
22 | 15 | $25,686 | $7,647 | $33,334 | $2,024,571 | $-33,334 |
23 | 16 | $25,782 | $7,552 | $33,334 | $1,998,789 | $-33,334 |
24 | 17 | $25,878 | $7,455 | $33,334 | $1,972,911 | $-33,334 |
25 | 18 | $25,975 | $7,359 | $33,334 | $1,946,936 | $-33,334 |
26 | 19 | $26,072 | $7,262 | $33,334 | $1,920,865 | $-33,334 |
27 | 20 | $26,169 | $7,165 | $33,334 | $1,894,696 | $-33,334 |
28 | 21 | $26,266 | $7,067 | $33,334 | $1,868,429 | $-33,334 |
29 | 22 | $26,364 | $6,969 | $33,334 | $1,842,065 | $-33,334 |
30 | 23 | $26,463 | $6,871 | $33,334 | $1,815,602 | $-33,334 |
31 | 24 | $26,561 | $6,772 | $33,334 | $1,789,041 | $-33,334 |
32 | 25 | $26,660 | $6,673 | $33,334 | $1,762,380 | $-33,334 |
33 | 26 | $26,760 | $6,574 | $33,334 | $1,735,621 | $-33,334 |
34 | 27 | $26,860 | $6,474 | $33,334 | $1,708,761 | $-33,334 |
35 | 28 | $26,960 | $6,374 | $33,334 | $1,681,801 | $-33,334 |
36 | 29 | $27,060 | $6,273 | $33,334 | $1,654,740 | $-33,334 |
37 | 30 | $27,161 | $6,172 | $33,334 | $1,627,579 | $-33,334 |
38 | 31 | $27,263 | $6,071 | $33,334 | $1,600,316 | $-33,334 |
39 | 32 | $27,364 | $5,969 | $33,334 | $1,572,952 | $-33,334 |
40 | 33 | $27,466 | $5,867 | $33,334 | $1,545,485 | $-33,334 |
41 | 34 | $27,569 | $5,765 | $33,334 | $1,517,916 | $-33,334 |
42 | 35 | $27,672 | $5,662 | $33,334 | $1,490,245 | $-33,334 |
43 | 36 | $27,775 | $5,559 | $33,334 | $1,462,470 | $-33,334 |
44 | 37 | $27,879 | $5,455 | $33,334 | $1,434,591 | $-33,334 |
45 | 38 | $27,983 | $5,351 | $33,334 | $1,406,608 | $-33,334 |
46 | 39 | $28,087 | $5,247 | $33,334 | $1,378,521 | $-33,334 |
47 | 40 | $28,192 | $5,142 | $33,334 | $1,350,330 | $-33,334 |
48 | 41 | $28,297 | $5,037 | $33,334 | $1,322,033 | $-33,334 |
49 | 42 | $28,402 | $4,931 | $33,334 | $1,293,630 | $-33,334 |
50 | 43 | $28,508 | $4,825 | $33,334 | $1,265,122 | $-33,334 |
51 | 44 | $28,615 | $4,719 | $33,334 | $1,236,507 | $-33,334 |
52 | 45 | $28,721 | $4,612 | $33,334 | $1,207,786 | $-33,334 |
53 | 46 | $28,829 | $4,505 | $33,334 | $1,178,957 | $-33,334 |
54 | 47 | $28,936 | $4,398 | $33,334 | $1,150,021 | $-33,334 |
55 | 48 | $29,044 | $4,290 | $33,334 | $1,120,977 | $-33,334 |
56 | 49 | $29,152 | $4,181 | $33,334 | $1,091,825 | $-33,334 |
57 | 50 | $29,261 | $4,073 | $33,334 | $1,062,564 | $-33,334 |
58 | 51 | $29,370 | $3,963 | $33,334 | $1,033,194 | $-33,334 |
59 | 52 | $29,480 | $3,854 | $33,334 | $1,003,714 | $-33,334 |
60 | 53 | $29,590 | $3,744 | $33,334 | $974,124 | $-33,334 |
61 | 54 | $29,700 | $3,633 | $33,334 | $944,424 | $-33,334 |
62 | 55 | $29,811 | $3,523 | $33,334 | $914,613 | $-33,334 |
63 | 56 | $29,922 | $3,412 | $33,334 | $884,691 | $-33,334 |
64 | 57 | $30,034 | $3,300 | $33,334 | $854,657 | $-33,334 |
65 | 58 | $30,146 | $3,188 | $33,334 | $824,511 | $-33,334 |
66 | 59 | $30,258 | $3,075 | $33,334 | $794,253 | $-33,334 |
67 | 60 | $30,371 | $2,963 | $33,334 | $763,882 | $-33,334 |
68 | 61 | $30,484 | $2,849 | $33,334 | $733,398 | $-33,334 |
69 | 62 | $30,598 | $2,736 | $33,334 | $702,800 | $-33,334 |
70 | 63 | $30,712 | $2,621 | $33,334 | $672,088 | $-33,334 |
71 | 64 | $30,827 | $2,507 | $33,334 | $641,261 | $-33,334 |
72 | 65 | $30,942 | $2,392 | $33,334 | $610,319 | $-33,334 |
73 | 66 | $31,057 | $2,276 | $33,334 | $579,262 | $-33,334 |
74 | 67 | $31,173 | $2,161 | $33,334 | $548,089 | $-33,334 |
75 | 68 | $31,289 | $2,044 | $33,334 | $516,800 | $-33,334 |
76 | 69 | $31,406 | $1,928 | $33,334 | $485,394 | $-33,334 |
77 | 70 | $31,523 | $1,811 | $33,334 | $453,871 | $-33,334 |
78 | 71 | $31,641 | $1,693 | $33,334 | $422,230 | $-33,334 |
79 | 72 | $31,759 | $1,575 | $33,334 | $390,472 | $-33,334 |
80 | 73 | $31,877 | $1,456 | $33,334 | $358,594 | $-33,334 |
81 | 74 | $31,996 | $1,338 | $33,334 | $326,598 | $-33,334 |
82 | 75 | $32,115 | $1,218 | $33,334 | $294,483 | $-33,334 |
83 | 76 | $32,235 | $1,098 | $33,334 | $262,248 | $-33,334 |
84 | 77 | $32,355 | $978 | $33,334 | $229,892 | $-33,334 |
85 | 78 | $32,476 | $857 | $33,334 | $197,416 | $-33,334 |
86 | 79 | $32,597 | $736 | $33,334 | $164,819 | $-33,334 |
87 | 80 | $32,719 | $615 | $33,334 | $132,100 | $-33,334 |
88 | 81 | $32,841 | $493 | $33,334 | $99,259 | $-33,334 |
89 | 82 | $32,963 | $370 | $33,334 | $66,296 | $-33,334 |
90 | 83 | $33,086 | $247 | $33,334 | $33,210 | $-33,334 |
91 | 84 | $33,210 | $124 | $33,334 | $0 | $-33,334 |