|
| Дебет |
Кредит |
Прогноз |
Прогноз Cash Flow |
| №пп |
Дата |
Внутр фин + налоги |
Внеш фин |
ГИБДД |
Страхование |
MTR |
Шинный сервис |
Помощь на дороге |
Доп услуги |
Сумма |
Накопительный итог |
Дата оплаты |
Сумма |
Накопительный итог |
БДР |
ДП |
КЗ, дней |
% по о/д |
БДДС |
| 1 |
26.9.2011 |
24 460.97 |
|
10 690.00 |
32 957.20 |
4 944.79 |
300.00 |
3 500.00 |
- |
76 852.96 |
76 852.96 |
26.9.2011 |
5 304.55 |
5 304.55 |
-71 548.41 |
-76 852.96 |
10 |
-358.00 |
-77 210.96 |
| 2 |
26.10.2011 |
17 945.17 |
|
- |
- |
1 922.97 |
34 011.00 |
- |
- |
53 879.14 |
130 732.10 |
26.10.2011 |
39 784.13 |
45 088.68 |
-14 095.01 |
-125 785.55 |
30 |
-1 758.00 |
-127 543.55 |
| 3 |
26.11.2011 |
17 927.36 |
|
- |
- |
- |
300.00 |
- |
- |
18 227.36 |
148 959.46 |
26.11.2011 |
39 784.13 |
84 872.81 |
21 556.77 |
-105 986.78 |
31 |
-1 530.00 |
-107 516.78 |
| 4 |
26.12.2011 |
17 909.55 |
|
- |
18 136.20 |
1 648.26 |
300.00 |
- |
- |
37 994.01 |
186 953.47 |
26.12.2011 |
39 784.13 |
124 656.94 |
1 790.12 |
-105 726.66 |
30 |
-1 477.00 |
-107 203.66 |
| 5 |
26.1.2012 |
17 891.75 |
|
- |
- |
- |
300.00 |
- |
- |
18 191.75 |
205 145.22 |
26.1.2012 |
39 784.13 |
164 441.07 |
21 592.38 |
-85 611.28 |
31 |
-1 236.00 |
-86 847.28 |
| 6 |
26.2.2012 |
17 873.94 |
|
- |
- |
1 510.91 |
300.00 |
- |
- |
19 684.85 |
224 830.07 |
26.2.2012 |
39 784.13 |
204 225.20 |
20 099.28 |
-66 748.00 |
31 |
-964.00 |
-67 712.00 |
| 7 |
26.3.2012 |
17 856.14 |
|
- |
18 136.20 |
- |
300.00 |
- |
- |
36 292.34 |
261 122.41 |
26.3.2012 |
39 784.13 |
244 009.33 |
3 491.79 |
-64 220.21 |
29 |
-867.00 |
-65 087.21 |
| 8 |
26.4.2012 |
17 838.33 |
|
- |
- |
1 373.55 |
2 011.00 |
- |
- |
21 222.88 |
282 345.29 |
26.4.2012 |
39 784.13 |
283 793.46 |
18 561.25 |
-46 525.96 |
31 |
-672.00 |
-47 197.96 |
| 9 |
26.5.2012 |
17 820.52 |
|
- |
- |
- |
300.00 |
- |
- |
18 120.52 |
300 465.81 |
26.5.2012 |
39 784.13 |
323 577.59 |
21 663.61 |
-25 534.35 |
30 |
-357.00 |
-25 891.35 |
| 10 |
26.6.2012 |
17 802.72 |
|
- |
18 136.20 |
2 197.68 |
300.00 |
- |
- |
38 436.60 |
338 902.41 |
26.6.2012 |
39 784.13 |
363 361.72 |
1 347.53 |
-24 543.82 |
31 |
-354.00 |
-24 897.82 |
| 11 |
26.7.2012 |
17 784.91 |
|
- |
- |
- |
300.00 |
- |
- |
18 084.91 |
356 987.32 |
26.7.2012 |
39 784.13 |
403 145.85 |
21 699.22 |
-3 198.60 |
30 |
-45.00 |
-3 243.60 |
| 12 |
26.8.2012 |
24 265.10 |
|
- |
- |
2 472.39 |
300.00 |
- |
- |
27 037.49 |
384 024.81 |
26.8.2012 |
39 784.13 |
442 929.98 |
12 746.64 |
9 503.04 |
31 |
0.00 |
9 503.04 |
| 13 |
26.9.2012 |
17 765.25 |
|
- |
32 957.20 |
- |
300.00 |
3 500.00 |
- |
54 522.45 |
438 547.26 |
26.9.2012 |
39 784.13 |
482 714.11 |
-14 738.32 |
-5 235.28 |
31 |
-76.00 |
-5 311.28 |
| 14 |
26.10.2012 |
17 747.25 |
|
- |
- |
2 747.10 |
2 011.00 |
- |
- |
22 505.35 |
461 052.61 |
26.10.2012 |
39 784.13 |
522 498.24 |
17 278.78 |
11 967.50 |
30 |
0.00 |
11 967.50 |
| 15 |
26.11.2012 |
17 729.25 |
|
- |
- |
- |
300.00 |
- |
- |
18 029.25 |
479 081.86 |
26.11.2012 |
39 784.13 |
562 282.37 |
21 754.88 |
33 722.38 |
31 |
0.00 |
33 722.38 |
| 16 |
26.12.2012 |
17 711.26 |
|
- |
18 136.20 |
3 571.23 |
300.00 |
- |
- |
39 718.69 |
518 800.55 |
26.12.2012 |
39 784.13 |
602 066.50 |
65.44 |
33 787.82 |
30 |
0.00 |
33 787.82 |
| 17 |
26.1.2013 |
17 693.26 |
|
- |
- |
- |
300.00 |
- |
- |
17 993.26 |
536 793.81 |
26.1.2013 |
39 784.13 |
641 850.63 |
21 790.87 |
55 578.69 |
31 |
0.00 |
55 578.69 |
| 18 |
26.2.2013 |
17 675.27 |
|
- |
- |
4 670.07 |
300.00 |
- |
- |
22 645.34 |
559 439.15 |
26.2.2013 |
39 784.13 |
681 634.76 |
17 138.79 |
72 717.48 |
31 |
0.00 |
72 717.48 |
| 19 |
26.3.2013 |
17 657.27 |
|
- |
18 136.20 |
- |
300.00 |
- |
- |
36 093.47 |
595 532.62 |
26.3.2013 |
39 784.13 |
721 418.89 |
3 690.66 |
76 408.14 |
28 |
0.00 |
76 408.14 |
| 20 |
26.4.2013 |
17 639.27 |
|
- |
- |
5 906.27 |
2 011.00 |
- |
- |
25 556.54 |
621 089.16 |
26.4.2013 |
39 784.13 |
761 203.02 |
14 227.59 |
90 635.73 |
31 |
0.00 |
90 635.73 |
| 21 |
26.5.2013 |
17 621.28 |
|
- |
- |
- |
300.00 |
- |
- |
17 921.28 |
639 010.44 |
26.5.2013 |
39 784.13 |
800 987.15 |
21 862.85 |
112 498.58 |
30 |
0.00 |
112 498.58 |
| 22 |
26.6.2013 |
17 603.28 |
|
- |
18 136.20 |
7 005.11 |
300.00 |
- |
- |
43 044.59 |
682 055.03 |
26.6.2013 |
39 784.13 |
840 771.28 |
-3 260.46 |
109 238.12 |
31 |
0.00 |
109 238.12 |
| 23 |
26.7.2013 |
24 083.29 |
|
- |
- |
- |
300.00 |
- |
- |
24 383.29 |
706 438.32 |
26.7.2013 |
39 784.13 |
880 555.41 |
15 400.84 |
124 638.96 |
30 |
0.00 |
124 638.96 |
| 24 |
26.8.2013 |
17 567.29 |
|
- |
- |
7 417.18 |
300.00 |
- |
- |
25 284.47 |
731 722.79 |
26.8.2013 |
39 784.13 |
920 339.54 |
14 499.66 |
139 138.62 |
31 |
0.00 |
139 138.62 |
| 25 |
26.9.2013 |
17 573.78 |
|
- |
32 957.20 |
- |
300.00 |
3 500.00 |
- |
54 330.98 |
786 053.77 |
26.9.2013 |
39 784.13 |
960 123.67 |
-14 546.85 |
124 591.77 |
31 |
0.00 |
124 591.77 |
| 26 |
26.10.2013 |
17 555.45 |
|
- |
- |
6 043.62 |
2 011.00 |
- |
- |
25 610.07 |
811 663.84 |
26.10.2013 |
39 784.13 |
999 907.80 |
14 174.06 |
138 765.83 |
30 |
0.00 |
138 765.83 |
| 27 |
26.11.2013 |
17 537.11 |
|
- |
- |
- |
300.00 |
- |
- |
17 837.11 |
829 500.95 |
26.11.2013 |
39 784.13 |
1 039 691.93 |
21 947.02 |
160 712.85 |
31 |
0.00 |
160 712.85 |
| 28 |
26.12.2013 |
17 518.78 |
|
- |
18 136.20 |
4 944.78 |
300.00 |
- |
- |
40 899.76 |
870 400.71 |
26.12.2013 |
39 784.13 |
1 079 476.06 |
-1 115.63 |
159 597.22 |
30 |
0.00 |
159 597.22 |
| 29 |
26.1.2014 |
17 500.44 |
|
- |
- |
- |
300.00 |
- |
- |
17 800.44 |
888 201.15 |
26.1.2014 |
39 784.13 |
1 119 260.19 |
21 983.69 |
181 580.91 |
31 |
0.00 |
181 580.91 |
| 30 |
26.2.2014 |
17 482.10 |
|
- |
- |
3 708.59 |
300.00 |
- |
- |
21 490.69 |
909 691.84 |
26.2.2014 |
39 784.13 |
1 159 044.32 |
18 293.44 |
199 874.35 |
31 |
0.00 |
199 874.35 |
| 31 |
26.3.2014 |
17 463.77 |
|
- |
18 136.20 |
- |
300.00 |
- |
- |
35 899.97 |
945 591.81 |
26.3.2014 |
39 784.13 |
1 198 828.45 |
3 884.16 |
203 758.51 |
28 |
0.00 |
203 758.51 |
| 32 |
26.4.2014 |
17 445.43 |
|
- |
- |
3 433.88 |
2 011.00 |
- |
- |
22 890.31 |
968 482.12 |
26.4.2014 |
39 784.13 |
1 238 612.58 |
16 893.82 |
220 652.33 |
31 |
0.00 |
220 652.33 |
| 33 |
26.5.2014 |
17 427.09 |
|
- |
- |
- |
300.00 |
- |
- |
17 727.09 |
986 209.21 |
26.5.2014 |
39 784.13 |
1 278 396.71 |
22 057.04 |
242 709.37 |
30 |
0.00 |
242 709.37 |
| 34 |
26.6.2014 |
23 906.76 |
|
- |
18 136.20 |
3 845.94 |
300.00 |
- |
- |
46 188.90 |
1 032 398.11 |
26.6.2014 |
39 784.13 |
1 318 180.84 |
-6 404.77 |
236 304.60 |
31 |
0.00 |
236 304.60 |
| 35 |
26.7.2014 |
17 390.42 |
|
- |
- |
- |
300.00 |
- |
- |
17 690.42 |
1 050 088.53 |
26.7.2014 |
39 784.13 |
1 357 964.97 |
22 093.71 |
258 398.31 |
30 |
0.00 |
258 398.31 |
| 36 |
26.8.2014 |
17 372.09 |
|
- |
- |
4 807.43 |
300.00 |
- |
- |
22 479.52 |
1 072 568.05 |
26.8.2014 |
39 784.13 |
1 397 749.10 |
17 304.61 |
275 702.92 |
31 |
0.00 |
275 702.92 |
| 37 |
26.9.2014 |
17 353.75 |
|
- |
32 957.20 |
- |
300.00 |
3 500.00 |
- |
54 110.95 |
1 126 679.00 |
26.9.2014 |
39 784.13 |
1 437 533.23 |
-14 326.82 |
261 376.10 |
31 |
0.00 |
261 376.10 |
| 38 |
26.10.2014 |
17 335.41 |
|
- |
- |
6 730.40 |
2 011.00 |
- |
- |
26 076.81 |
1 152 755.81 |
26.10.2014 |
39 784.13 |
1 477 317.36 |
13 707.32 |
275 083.42 |
30 |
0.00 |
275 083.42 |
| 39 |
26.11.2014 |
17 317.08 |
|
- |
- |
- |
300.00 |
- |
- |
17 617.08 |
1 170 372.89 |
26.11.2014 |
39 784.13 |
1 517 101.49 |
22 167.05 |
297 250.47 |
31 |
0.00 |
297 250.47 |
| 40 |
26.12.2014 |
17 298.74 |
|
- |
18 136.20 |
8 103.95 |
300.00 |
- |
- |
43 838.89 |
1 214 211.78 |
26.12.2014 |
39 784.13 |
1 556 885.62 |
-4 054.76 |
293 195.71 |
30 |
0.00 |
293 195.71 |
| 41 |
26.1.2015 |
17 280.41 |
|
- |
- |
- |
300.00 |
- |
- |
17 580.41 |
1 231 792.19 |
26.1.2015 |
39 784.13 |
1 596 669.75 |
22 203.72 |
315 399.43 |
31 |
0.00 |
315 399.43 |
| 42 |
26.2.2015 |
17 262.07 |
|
- |
- |
9 752.21 |
300.00 |
- |
- |
27 314.28 |
1 259 106.47 |
26.2.2015 |
39 784.13 |
1 636 453.88 |
12 469.85 |
327 869.28 |
31 |
0.00 |
327 869.28 |
| 43 |
26.3.2015 |
17 243.73 |
|
- |
18 136.20 |
- |
300.00 |
- |
- |
35 679.93 |
1 294 786.40 |
26.3.2015 |
39 784.13 |
1 676 238.01 |
4 104.20 |
331 973.48 |
28 |
0.00 |
331 973.48 |
| 44 |
26.4.2015 |
17 225.40 |
|
- |
- |
11 537.83 |
2 011.00 |
- |
- |
30 774.23 |
1 325 560.63 |
26.4.2015 |
39 784.13 |
1 716 022.14 |
9 009.90 |
340 983.38 |
31 |
0.00 |
340 983.38 |
| 45 |
26.5.2015 |
23 705.06 |
|
- |
- |
- |
300.00 |
- |
- |
24 005.06 |
1 349 565.69 |
26.5.2015 |
39 784.13 |
1 755 806.27 |
15 779.07 |
356 762.45 |
30 |
0.00 |
356 762.45 |
| 46 |
26.6.2015 |
17 188.72 |
|
- |
18 136.20 |
12 361.96 |
300.00 |
- |
- |
47 986.88 |
1 397 552.57 |
26.6.2015 |
39 784.13 |
1 795 590.40 |
-8 202.75 |
348 559.70 |
31 |
0.00 |
348 559.70 |
| 47 |
26.7.2015 |
17 170.39 |
|
- |
- |
- |
300.00 |
- |
- |
17 470.39 |
1 415 022.96 |
26.7.2015 |
39 784.13 |
1 835 374.53 |
22 313.74 |
370 873.44 |
30 |
0.00 |
370 873.44 |
| 48 |
26.8.2015 |
17 152.05 |
|
1 700.00 |
- |
14 284.93 |
300.00 |
- |
- |
33 436.98 |
1 448 459.94 |
26.8.2015 |
74 263.71 |
1 909 638.24 |
40 826.73 |
377 220.59 |
31 |
0.00 |
377 220.59 |
| Кд |
|
0.00 |
|
|
0.00 |
|
386 132.20 |
|
386 132.20 |
837 616.50 |
|
837 616.50 |
| |
Накопительно| расходы: |
1 448 459.94 |
Накопительно| доходы: |
1 909 638.24 |
валовый БДР: |
461 178.30 |
Обсл овердрафта: |
-9 694.00 |
| |
Чистый итог договора по БДР: |
451 484.30 |
Итог договора по БДДС: |
451 484.30 |
|
