DS_Template.xlsx

	B	C	D	E	F	G	H	I	J	K	L	M	N	O
1
2	Сублимит	Сублимит 1/НКЛ			Сублимит 2/НКЛ			Сублимит 3/КД		Сублимит 4/ВКЛ			Итого основной долг	Итого платежи
3	Параметр	Итого остаток долга	Итого выборка	Итого платежи	Итого остаток долга	Итого выборка	Итого платежи	Итого остаток долга	Итого платежи	Итого остаток долга	Итого выборка	Итого платежи	Итого основной долг	Итого платежи
4	Сумма лимита	500,000,000			400,000,000			250,000,000		100,000,000			1,250,000,000
5	Дата
6	30/11/2025	250,000,000	250,000,000		200,000,000	200,000,000		-		-			450,000,000	-
7	31/12/2025	400,000,000	150,000,000		200,000,000			-		-			600,000,000	-
8	31/01/2026	500,000,000	100,000,000		200,000,000			-		-			700,000,000	-
9	28/02/2026	500,000,000			200,000,000			-		50,000,000	50,000,000		750,000,000	-
10	31/03/2026	500,000,000			400,000,000	200,000,000		-		60,000,000	10,000,000		960,000,000	-
11	30/04/2026	500,000,000			400,000,000			-		65,000,000	5,000,000		965,000,000	-
12	31/05/2026	475,000,000		25,000,000	400,000,000			-		35,000,000		30,000,000	910,000,000	55,000,000
13	30/06/2026	445,000,000		30,000,000	400,000,000			-		35,000,000			880,000,000	30,000,000
14	31/07/2026	414,000,000		31,000,000	400,000,000			-		45,000,000	10,000,000		859,000,000	31,000,000
15	31/08/2026	382,800,000		31,200,000	380,000,000		20,000,000	250,000,000		50,000,000	5,000,000		1,062,800,000	51,200,000
16	30/09/2026	351,560,000		31,240,000	360,000,000		20,000,000	230,000,000	20,000,000	20,000,000		30,000,000	961,560,000	101,240,000
17	31/10/2026	320,312,000		31,248,000	340,000,000		20,000,000	210,000,000	20,000,000	20,000,000			890,312,000	71,248,000
18	30/11/2026	289,062,400		31,249,600	320,000,000		20,000,000	190,000,000	20,000,000	20,000,000			819,062,400	71,249,600
19	31/12/2026	257,812,480		31,249,920	300,000,000		20,000,000	170,000,000	20,000,000	20,000,000			747,812,480	71,249,920
20	31/01/2027	-		257,812,480	280,000,000		20,000,000	150,000,000	20,000,000	20,000,000			450,000,000	297,812,480
21	28/02/2027	-			260,000,000		20,000,000	130,000,000	20,000,000	20,000,000			410,000,000	40,000,000
22	31/03/2027	-			240,000,000		20,000,000	110,000,000	20,000,000	30,000,000	10,000,000		380,000,000	40,000,000
23	30/04/2027	-			220,000,000		20,000,000	90,000,000	20,000,000	35,000,000	5,000,000		345,000,000	40,000,000
24	31/05/2027	-			180,000,000		40,000,000	70,000,000	20,000,000	5,000,000		30,000,000	255,000,000	90,000,000
25	30/06/2027	-			140,000,000		40,000,000	50,000,000	20,000,000	5,000,000			195,000,000	60,000,000
26	31/07/2027	-			100,000,000		40,000,000	30,000,000	20,000,000	5,000,000			135,000,000	60,000,000
27	31/08/2027	-			60,000,000		40,000,000	10,000,000	20,000,000	25,000,000	20,000,000		95,000,000	60,000,000
28	30/09/2027	-			20,000,000		40,000,000	-	10,000,000	25,000,000			45,000,000	50,000,000
29	31/10/2027	-			-		20,000,000	-		25,000,000			25,000,000	20,000,000
30	30/11/2027	-			-			-		20,000,000		5,000,000	20,000,000	5,000,000
31	31/12/2027	-			-			-		15,000,000		5,000,000	15,000,000	5,000,000
32	31/01/2028	-			-			-		10,000,000		5,000,000	10,000,000	5,000,000
33	29/02/2028	-			-			-		5,000,000		5,000,000	5,000,000	5,000,000
34	31/03/2028	-			-			-		-		5,000,000	-	5,000,000
35	ИТОГО		500,000,000	500,000,000		400,000,000	400,000,000		250,000,000		115,000,000	115,000,000		1,265,000,000
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