JavaScript required
We’re sorry, but Coda doesn’t work properly without JavaScript enabled.
Skip to content
Flixbus business case
Introduction
More
Share
Explore
Building the partner's business case
Amortization schedule
Show the outcome in a sync table or calculate on the flow.
calculate on the flow
calculate on the flow
Name
amount
years
annual interest rate
yearly admin fee
admin freq
Name
amount
years
annual interest rate
yearly admin fee
admin freq
€7.506,09
€540.000,00
7
4,5
€200,00
Annual
€8.596,82
€540.000,00
6
4,6
€220,00
Annual
€10.116,41
€540.000,00
5
4,7
€240,00
Annual
€12.386,96
€540.000,00
4
4,8
€260,00
Annual
There are no rows in this table
Amortization schedule
Amortization schedule
Month entry
Month number
i
Date
i
Payment
i
Base payment
i
Principal
i
Interest
i
Admin fee
i
Remaining balance
i
Paid percentage
i
Applied percentage
i
Cumulative interest
i
Total interest
i
Cumulative admin fee
i
Is admin fee month
i
Fee type
i
Yearly admin fee
i
Loan amount
i
Month entry
Month number
i
Date
i
Payment
i
Base payment
i
Principal
i
Interest
i
Admin fee
i
Remaining balance
i
Paid percentage
i
Applied percentage
i
Cumulative interest
i
Total interest
i
Cumulative admin fee
i
Is admin fee month
i
Fee type
i
Yearly admin fee
i
Loan amount
i
1
Sun, 31 Aug 2025
$10.368,73
$10.128,73
$7.991,23
$2.137,50
$240,00
$532.008,77
1,48 %
4,75 %
$2.137,50
0,4 %
$240,00
Annual
$240,00
$540.000,00
2
Wed, 1 Oct 2025
$10.128,73
$10.128,73
$8.022,86
$2.105,87
$0,00
$523.985,90
2,97 %
4,75 %
$4.243,37
0,79 %
$240,00
Annual
$240,00
$540.000,00
3
Fri, 31 Oct 2025
$10.128,73
$10.128,73
$8.054,62
$2.074,11
$0,00
$515.931,28
4,46 %
4,75 %
$6.317,48
1,17 %
$240,00
Annual
$240,00
$540.000,00
4
Mon, 1 Dec 2025
$10.128,73
$10.128,73
$8.086,50
$2.042,23
$0,00
$507.844,78
5,95 %
4,75 %
$8.359,71
1,55 %
$240,00
Annual
$240,00
$540.000,00
5
Wed, 31 Dec 2025
$10.128,73
$10.128,73
$8.118,51
$2.010,22
$0,00
$499.726,26
7,46 %
4,75 %
$10.369,93
1,92 %
$240,00
Annual
$240,00
$540.000,00
6
Sat, 31 Jan 2026
$10.128,73
$10.128,73
$8.150,65
$1.978,08
$0,00
$491.575,61
8,97 %
4,75 %
$12.348,01
2,29 %
$240,00
Annual
$240,00
$540.000,00
7
Tue, 3 Mar 2026
$10.128,73
$10.128,73
$8.182,91
$1.945,82
$0,00
$483.392,70
10,48 %
4,75 %
$14.293,83
2,65 %
$240,00
Annual
$240,00
$540.000,00
8
Tue, 31 Mar 2026
$10.128,73
$10.128,73
$8.215,30
$1.913,43
$0,00
$475.177,40
12 %
4,75 %
$16.207,26
3 %
$240,00
Annual
$240,00
$540.000,00
9
Fri, 1 May 2026
$10.128,73
$10.128,73
$8.247,82
$1.880,91
$0,00
$466.929,58
13,53 %
4,75 %
$18.088,17
3,35 %
$240,00
Annual
$240,00
$540.000,00
10
Sun, 31 May 2026
$10.128,73
$10.128,73
$8.280,47
$1.848,26
$0,00
$458.649,11
15,06 %
4,75 %
$19.936,43
3,69 %
$240,00
Annual
$240,00
$540.000,00
11
Wed, 1 Jul 2026
$10.128,73
$10.128,73
$8.313,25
$1.815,49
$0,00
$450.335,86
16,6 %
4,75 %
$21.751,92
4,03 %
$240,00
Annual
$240,00
$540.000,00
12
Fri, 31 Jul 2026
$10.128,73
$10.128,73
$8.346,15
$1.782,58
$0,00
$441.989,71
18,15 %
4,75 %
$23.534,50
4,36 %
$240,00
Annual
$240,00
$540.000,00
13
Mon, 31 Aug 2026
$10.368,73
$10.128,73
$8.379,19
$1.749,54
$240,00
$433.610,52
19,7 %
4,75 %
$25.284,04
4,68 %
$480,00
Annual
$240,00
$540.000,00
14
Thu, 1 Oct 2026
$10.128,73
$10.128,73
$8.412,36
$1.716,37
$0,00
$425.198,16
21,26 %
4,75 %
$27.000,42
5 %
$480,00
Annual
$240,00
$540.000,00
15
Sat, 31 Oct 2026
$10.128,73
$10.128,73
$8.445,66
$1.683,08
$0,00
$416.752,50
22,82 %
4,75 %
$28.683,49
5,31 %
$480,00
Annual
$240,00
$540.000,00
16
Tue, 1 Dec 2026
$10.128,73
$10.128,73
$8.479,09
$1.649,65
$0,00
$408.273,42
24,39 %
4,75 %
$30.333,14
5,62 %
$480,00
Annual
$240,00
$540.000,00
17
Thu, 31 Dec 2026
$10.128,73
$10.128,73
$8.512,65
$1.616,08
$0,00
$399.760,77
25,97 %
4,75 %
$31.949,22
5,92 %
$480,00
Annual
$240,00
$540.000,00
18
Sun, 31 Jan 2027
$10.128,73
$10.128,73
$8.546,35
$1.582,39
$0,00
$391.214,42
27,55 %
4,75 %
$33.531,61
6,21 %
$480,00
Annual
$240,00
$540.000,00
19
Wed, 3 Mar 2027
$10.128,73
$10.128,73
$8.580,18
$1.548,56
$0,00
$382.634,25
29,14 %
4,75 %
$35.080,16
6,5 %
$480,00
Annual
$240,00
$540.000,00
20
Wed, 31 Mar 2027
$10.128,73
$10.128,73
$8.614,14
$1.514,59
$0,00
$374.020,11
30,74 %
4,75 %
$36.594,76
6,78 %
$480,00
Annual
$240,00
$540.000,00
21
Sat, 1 May 2027
$10.128,73
$10.128,73
$8.648,24
$1.480,50
$0,00
$365.371,87
32,34 %
4,75 %
$38.075,25
7,05 %
$480,00
Annual
$240,00
$540.000,00
22
Mon, 31 May 2027
$10.128,73
$10.128,73
$8.682,47
$1.446,26
$0,00
$356.689,40
33,95 %
4,75 %
$39.521,52
7,32 %
$480,00
Annual
$240,00
$540.000,00
23
Thu, 1 Jul 2027
$10.128,73
$10.128,73
$8.716,84
$1.411,90
$0,00
$347.972,56
35,56 %
4,75 %
$40.933,41
7,58 %
$480,00
Annual
$240,00
$540.000,00
24
Sat, 31 Jul 2027
$10.128,73
$10.128,73
$8.751,34
$1.377,39
$0,00
$339.221,22
37,18 %
4,75 %
$42.310,80
7,84 %
$480,00
Annual
$240,00
$540.000,00
25
Tue, 31 Aug 2027
$10.368,73
$10.128,73
$8.785,98
$1.342,75
$240,00
$330.435,24
38,81 %
4,75 %
$43.653,55
8,08 %
$720,00
Annual
$240,00
$540.000,00
26
Fri, 1 Oct 2027
$10.128,73
$10.128,73
$8.820,76
$1.307,97
$0,00
$321.614,48
40,44 %
4,75 %
$44.961,53
8,33 %
$720,00
Annual
$240,00
$540.000,00
27
Sun, 31 Oct 2027
$10.128,73
$10.128,73
$8.855,68
$1.273,06
$0,00
$312.758,81
42,08 %
4,75 %
$46.234,58
8,56 %
$720,00
Annual
$240,00
$540.000,00
28
Wed, 1 Dec 2027
$10.128,73
$10.128,73
$8.890,73
$1.238,00
$0,00
$303.868,08
43,73 %
4,75 %
$47.472,59
8,79 %
$720,00
Annual
$240,00
$540.000,00
29
Fri, 31 Dec 2027
$10.128,73
$10.128,73
$8.925,92
$1.202,81
$0,00
$294.942,16
45,38 %
4,75 %
$48.675,40
9,01 %
$720,00
Annual
$240,00
$540.000,00
30
Mon, 31 Jan 2028
$10.128,73
$10.128,73
$8.961,25
$1.167,48
$0,00
$285.980,90
47,04 %
4,75 %
$49.842,88
9,23 %
$720,00
Annual
$240,00
$540.000,00
31
Thu, 2 Mar 2028
$10.128,73
$10.128,73
$8.996,72
$1.132,01
$0,00
$276.984,18
48,71 %
4,75 %
$50.974,89
9,44 %
$720,00
Annual
$240,00
$540.000,00
32
Fri, 31 Mar 2028
$10.128,73
$10.128,73
$9.032,34
$1.096,40
$0,00
$267.951,84
50,38 %
4,75 %
$52.071,28
9,64 %
$720,00
Annual
$240,00
$540.000,00
33
Mon, 1 May 2028
$10.128,73
$10.128,73
$9.068,09
$1.060,64
$0,00
$258.883,75
52,06 %
4,75 %
$53.131,92
9,84 %
$720,00
Annual
$240,00
$540.000,00
34
Wed, 31 May 2028
$10.128,73
$10.128,73
$9.103,98
$1.024,75
$0,00
$249.779,77
53,74 %
4,75 %
$54.156,67
10,03 %
$720,00
Annual
$240,00
$540.000,00
35
Sat, 1 Jul 2028
$10.128,73
$10.128,73
$9.140,02
$988,71
$0,00
$240.639,75
55,44 %
4,75 %
$55.145,38
10,21 %
$720,00
Annual
$240,00
$540.000,00
36
Mon, 31 Jul 2028
$10.128,73
$10.128,73
$9.176,20
$952,53
$0,00
$231.463,55
57,14 %
4,75 %
$56.097,92
10,39 %
$720,00
Annual
$240,00
$540.000,00
37
Thu, 31 Aug 2028
$10.368,73
$10.128,73
$9.212,52
$916,21
$240,00
$222.251,02
58,84 %
4,75 %
$57.014,13
10,56 %
$960,00
Annual
$240,00
$540.000,00
38
Sun, 1 Oct 2028
$10.128,73
$10.128,73
$9.248,99
$879,74
$0,00
$213.002,04
60,56 %
4,75 %
$57.893,87
10,72 %
$960,00
Annual
$240,00
$540.000,00
39
Tue, 31 Oct 2028
$10.128,73
$10.128,73
$9.285,60
$843,13
$0,00
$203.716,44
62,27 %
4,75 %
$58.737,00
10,88 %
$960,00
Annual
$240,00
$540.000,00
40
Fri, 1 Dec 2028
$10.128,73
$10.128,73
$9.322,35
$806,38
$0,00
$194.394,08
64 %
4,75 %
$59.543,38
11,03 %
$960,00
Annual
$240,00
$540.000,00
41
Sun, 31 Dec 2028
$10.128,73
$10.128,73
$9.359,26
$769,48
$0,00
$185.034,83
65,73 %
4,75 %
$60.312,86
11,17 %
$960,00
Annual
$240,00
$540.000,00
42
Wed, 31 Jan 2029
$10.128,73
$10.128,73
$9.396,30
$732,43
$0,00
$175.638,52
67,47 %
4,75 %
$61.045,29
11,3 %
$960,00
Annual
$240,00
$540.000,00
43
Sat, 3 Mar 2029
$10.128,73
$10.128,73
$9.433,50
$695,24
$0,00
$166.205,03
69,22 %
4,75 %
$61.740,52
11,43 %
$960,00
Annual
$240,00
$540.000,00
44
Sat, 31 Mar 2029
$10.128,73
$10.128,73
$9.470,84
$657,89
$0,00
$156.734,19
70,98 %
4,75 %
$62.398,42
11,56 %
$960,00
Annual
$240,00
$540.000,00
45
Tue, 1 May 2029
$10.128,73
$10.128,73
$9.508,33
$620,41
$0,00
$147.225,86
72,74 %
4,75 %
$63.018,82
11,67 %
$960,00
Annual
$240,00
$540.000,00
46
Thu, 31 May 2029
$10.128,73
$10.128,73
$9.545,96
$582,77
$0,00
$137.679,90
74,5 %
4,75 %
$63.601,59
11,78 %
$960,00
Annual
$240,00
$540.000,00
47
Sun, 1 Jul 2029
$10.128,73
$10.128,73
$9.583,75
$544,98
$0,00
$128.096,15
76,28 %
4,75 %
$64.146,58
11,88 %
$960,00
Annual
$240,00
$540.000,00
48
Tue, 31 Jul 2029
$10.128,73
$10.128,73
$9.621,69
$507,05
$0,00
$118.474,46
78,06 %
4,75 %
$64.653,62
11,97 %
$960,00
Annual
$240,00
$540.000,00
49
Fri, 31 Aug 2029
$10.368,73
$10.128,73
$9.659,77
$468,96
$240,00
$108.814,69
79,85 %
4,75 %
$65.122,58
12,06 %
$1.200,00
Annual
$240,00
$540.000,00
50
Mon, 1 Oct 2029
$10.128,73
$10.128,73
$9.698,01
$430,72
$0,00
$99.116,69
81,65 %
4,75 %
$65.553,31
12,14 %
$1.200,00
Annual
$240,00
$540.000,00
51
Wed, 31 Oct 2029
$10.128,73
$10.128,73
$9.736,40
$392,34
$0,00
$89.380,29
83,45 %
4,75 %
$65.945,65
12,21 %
$1.200,00
Annual
$240,00
$540.000,00
52
Sat, 1 Dec 2029
$10.128,73
$10.128,73
$9.774,94
$353,80
$0,00
$79.605,35
85,26 %
4,75 %
$66.299,44
12,28 %
$1.200,00
Annual
$240,00
$540.000,00
53
Mon, 31 Dec 2029
$10.128,73
$10.128,73
$9.813,63
$315,10
$0,00
$69.791,73
87,08 %
4,75 %
$66.614,55
12,34 %
$1.200,00
Annual
$240,00
$540.000,00
54
Thu, 31 Jan 2030
$10.128,73
$10.128,73
$9.852,47
$276,26
$0,00
$59.939,25
88,9 %
4,75 %
$66.890,81
12,39 %
$1.200,00
Annual
$240,00
$540.000,00
55
Sun, 3 Mar 2030
$10.128,73
$10.128,73
$9.891,47
$237,26
$0,00
$50.047,78
90,73 %
4,75 %
$67.128,07
12,43 %
$1.200,00
Annual
$240,00
$540.000,00
56
Sun, 31 Mar 2030
$10.128,73
$10.128,73
$9.930,63
$198,11
$0,00
$40.117,15
92,57 %
4,75 %
$67.326,17
12,47 %
$1.200,00
Annual
$240,00
$540.000,00
57
Wed, 1 May 2030
$10.128,73
$10.128,73
$9.969,94
$158,80
$0,00
$30.147,22
94,42 %
4,75 %
$67.484,97
12,5 %
$1.200,00
Annual
$240,00
$540.000,00
58
Fri, 31 May 2030
$10.128,73
$10.128,73
$10.009,40
$119,33
$0,00
$20.137,82
96,27 %
4,75 %
$67.604,30
12,52 %
$1.200,00
Annual
$240,00
$540.000,00
59
Mon, 1 Jul 2030
$10.128,73
$10.128,73
$10.049,02
$79,71
$0,00
$10.088,80
98,13 %
4,75 %
$67.684,01
12,53 %
$1.200,00
Annual
$240,00
$540.000,00
60
Wed, 31 Jul 2030
$10.128,73
$10.128,73
$10.088,80
$39,93
$0,00
$0,00
100 %
4,75 %
$67.723,95
12,54 %
$1.200,00
Annual
$240,00
$540.000,00
There are no rows in this table
Want to print your doc?
This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (
Ctrl
P
) instead.