ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Loan amount $ (10 000)PeriodLoan BodyInterest
Total Payment
Remaining
2
Annual interest rate8%1$970,37 $66,67 $1 037,03 $ 9 029,63 =ABS(B1)-E2
3
Loan term (months)102$976,83 $60,20 $1 037,03 $ 8 052,80
4
3$983,35 $53,69 $1 037,03 $ 7 069,45
5
Monthly loan payment
$1 037,03 4$989,90 $47,13 $1 037,03 $ 6 079,55
6
Total Amount$10 370,32 5$996,50 $40,53 $1 037,03 $ 5 083,05
7
6$1 003,15 $33,89 $1 037,03 $ 4 079,90
8
Exclude*$1 030,16 7$1 009,83 $27,20 $1 037,03 $ 3 070,07
9
8$1 016,56 $20,47 $1 037,03 $ 2 053,51
10
*We exclude from the calculation of monthly loan payments the payment made at the beginning of the period9$1 023,34 $13,69 $1 037,03 $ 1 030,16
11
10$1 030,16 $6,87 $1 037,03 $ (0,00)
12
13
14
https://exceltable.com/
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
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