|
| Дебет |
Кредит |
Прогноз |
Прогноз Cash Flow |
| №пп |
Дата |
Внутр фин + налоги |
Внеш фин |
ГИБДД |
Страхование |
MTR |
Шинный сервис |
Помощь на дороге |
Доп услуги |
Сумма |
Накопительный итог |
Дата оплаты |
Сумма |
Накопительный итог |
БДР |
ДП |
КЗ, дней |
% по о/д |
БДДС |
| 1 |
23.6.2011 |
12 796.52 |
1 138.00 |
11 990.00 |
29 525.00 |
3 459.96 |
200.00 |
3 500.00 |
1 880.00 |
64 489.48 |
64 489.48 |
22.8.2011 |
6 891.73 |
6 891.73 |
-57 597.75 |
-64 489.48 |
10 |
-265.00 |
-64 754.48 |
| 2 |
23.7.2011 |
12 084.24 |
1 138.00 |
- |
- |
1 345.54 |
200.00 |
- |
1 880.00 |
16 647.78 |
81 137.26 |
22.9.2011 |
29 536.00 |
36 427.73 |
12 888.22 |
-74 510.53 |
31 |
-949.00 |
-75 459.53 |
| 3 |
23.8.2011 |
12 064.97 |
1 138.00 |
- |
- |
1 153.32 |
200.00 |
- |
1 880.00 |
16 436.29 |
97 573.55 |
22.10.2011 |
29 536.00 |
65 963.73 |
13 099.71 |
-62 359.82 |
30 |
-769.00 |
-63 128.82 |
| 4 |
23.9.2011 |
12 045.69 |
1 138.00 |
- |
14 625.00 |
- |
200.00 |
- |
1 880.00 |
29 888.69 |
127 462.24 |
22.11.2011 |
29 536.00 |
95 499.73 |
-352.69 |
-63 481.51 |
31 |
-809.00 |
-64 290.51 |
| 5 |
23.10.2011 |
12 026.41 |
1 138.00 |
- |
- |
1 057.21 |
27 793.00 |
- |
1 880.00 |
43 894.62 |
171 356.86 |
22.12.2011 |
29 536.00 |
125 035.73 |
-14 358.62 |
-78 649.13 |
30 |
-970.00 |
-79 619.13 |
| 6 |
23.11.2011 |
12 007.13 |
1 138.00 |
- |
- |
961.10 |
200.00 |
- |
1 880.00 |
16 186.23 |
187 543.09 |
22.1.2012 |
29 536.00 |
154 571.73 |
13 349.77 |
-66 269.36 |
31 |
-844.00 |
-67 113.36 |
| 7 |
23.12.2011 |
11 987.85 |
1 138.00 |
- |
14 625.00 |
- |
200.00 |
- |
1 880.00 |
29 830.85 |
217 373.94 |
22.2.2012 |
29 536.00 |
184 107.73 |
-294.85 |
-67 408.21 |
31 |
-859.00 |
-68 267.21 |
| 8 |
23.1.2012 |
11 968.57 |
1 138.00 |
- |
- |
1 537.76 |
200.00 |
- |
1 880.00 |
16 724.33 |
234 098.27 |
22.3.2012 |
29 536.00 |
213 643.73 |
12 811.67 |
-55 455.54 |
29 |
-661.00 |
-56 116.54 |
| 9 |
23.2.2012 |
11 949.29 |
1 138.00 |
- |
- |
1 729.98 |
200.00 |
- |
1 880.00 |
16 897.27 |
250 995.54 |
22.4.2012 |
29 536.00 |
243 179.73 |
12 638.73 |
-43 477.81 |
31 |
-554.00 |
-44 031.81 |
| 10 |
23.3.2012 |
11 930.01 |
1 138.00 |
- |
14 625.00 |
- |
200.00 |
- |
1 880.00 |
29 773.01 |
280 768.55 |
22.5.2012 |
29 536.00 |
272 715.73 |
-237.01 |
-44 268.82 |
30 |
-546.00 |
-44 814.82 |
| 11 |
23.4.2012 |
11 910.73 |
1 138.00 |
- |
- |
1 922.20 |
1 793.00 |
- |
1 880.00 |
18 643.93 |
299 412.48 |
22.6.2012 |
29 536.00 |
302 251.73 |
10 892.07 |
-33 922.75 |
31 |
-432.00 |
-34 354.75 |
| 12 |
23.5.2012 |
12 584.45 |
1 138.00 |
- |
- |
2 498.85 |
200.00 |
- |
1 880.00 |
18 301.30 |
317 713.78 |
22.7.2012 |
29 536.00 |
331 787.73 |
11 234.70 |
-23 120.05 |
30 |
-285.00 |
-23 405.05 |
| 13 |
23.6.2012 |
11 895.13 |
1 138.00 |
- |
29 525.00 |
- |
200.00 |
3 500.00 |
1 880.00 |
48 138.13 |
365 851.91 |
22.8.2012 |
29 536.00 |
361 323.73 |
-18 602.13 |
-42 007.18 |
31 |
-535.00 |
-42 542.18 |
| 14 |
23.7.2012 |
11 875.48 |
1 138.00 |
- |
- |
3 267.73 |
200.00 |
- |
1 880.00 |
18 361.21 |
384 213.12 |
22.9.2012 |
29 536.00 |
390 859.73 |
11 174.79 |
-31 367.39 |
31 |
-400.00 |
-31 767.39 |
| 15 |
23.8.2012 |
11 855.84 |
1 138.00 |
- |
- |
4 132.72 |
200.00 |
- |
1 880.00 |
19 206.56 |
403 419.68 |
22.10.2012 |
29 536.00 |
420 395.73 |
10 329.44 |
-21 437.95 |
30 |
-264.00 |
-21 701.95 |
| 16 |
23.9.2012 |
11 836.19 |
1 138.00 |
- |
14 625.00 |
- |
200.00 |
- |
1 880.00 |
29 679.19 |
433 098.87 |
22.11.2012 |
29 536.00 |
449 931.73 |
-143.19 |
-21 845.14 |
31 |
-278.00 |
-22 123.14 |
| 17 |
23.10.2012 |
11 816.55 |
1 138.00 |
- |
- |
4 901.60 |
1 793.00 |
- |
1 880.00 |
21 529.15 |
454 628.02 |
22.12.2012 |
29 536.00 |
479 467.73 |
8 006.85 |
-14 116.29 |
30 |
-174.00 |
-14 290.29 |
| 18 |
23.11.2012 |
11 796.91 |
1 138.00 |
- |
- |
5 189.93 |
200.00 |
- |
1 880.00 |
20 204.84 |
474 832.86 |
22.1.2013 |
29 536.00 |
509 003.73 |
9 331.16 |
-4 959.13 |
31 |
-63.00 |
-5 022.13 |
| 19 |
23.12.2012 |
11 777.26 |
1 138.00 |
- |
14 625.00 |
- |
200.00 |
- |
1 880.00 |
29 620.26 |
504 453.12 |
22.2.2013 |
29 536.00 |
538 539.73 |
-84.26 |
-5 106.39 |
31 |
-65.00 |
-5 171.39 |
| 20 |
23.1.2013 |
11 757.62 |
1 138.00 |
- |
- |
4 228.83 |
200.00 |
- |
1 880.00 |
19 204.45 |
523 657.57 |
22.3.2013 |
29 536.00 |
568 075.73 |
10 331.55 |
5 160.16 |
28 |
0.00 |
5 160.16 |
| 21 |
23.2.2013 |
11 737.97 |
1 138.00 |
- |
- |
3 459.95 |
200.00 |
- |
1 880.00 |
18 415.92 |
542 073.49 |
22.4.2013 |
29 536.00 |
597 611.73 |
11 120.08 |
16 280.24 |
31 |
0.00 |
16 280.24 |
| 22 |
23.3.2013 |
11 718.33 |
1 138.00 |
- |
14 625.00 |
- |
200.00 |
- |
1 880.00 |
29 561.33 |
571 634.82 |
22.5.2013 |
29 536.00 |
627 147.73 |
-25.33 |
16 254.91 |
30 |
0.00 |
16 254.91 |
| 23 |
23.4.2013 |
12 391.69 |
1 138.00 |
- |
- |
2 594.96 |
1 793.00 |
- |
1 880.00 |
19 797.65 |
591 432.47 |
22.6.2013 |
29 536.00 |
656 683.73 |
9 738.35 |
25 993.26 |
31 |
0.00 |
25 993.26 |
| 24 |
23.5.2013 |
11 679.04 |
1 138.00 |
- |
- |
2 402.74 |
200.00 |
- |
1 880.00 |
17 299.78 |
608 732.25 |
22.7.2013 |
29 536.00 |
686 219.73 |
12 236.22 |
38 229.48 |
30 |
0.00 |
38 229.48 |
| 25 |
23.6.2013 |
11 659.40 |
1 138.00 |
- |
29 525.00 |
- |
200.00 |
3 500.00 |
1 880.00 |
47 902.40 |
656 634.65 |
22.8.2013 |
29 536.00 |
715 755.73 |
-18 366.40 |
19 863.08 |
31 |
0.00 |
19 863.08 |
| 26 |
23.7.2013 |
11 639.75 |
1 138.00 |
- |
- |
2 691.07 |
200.00 |
- |
1 880.00 |
17 548.82 |
674 183.47 |
22.9.2013 |
29 536.00 |
745 291.73 |
11 987.18 |
31 850.26 |
31 |
0.00 |
31 850.26 |
| 27 |
23.8.2013 |
11 620.11 |
1 138.00 |
- |
- |
3 363.84 |
200.00 |
- |
1 880.00 |
18 201.95 |
692 385.42 |
22.10.2013 |
29 536.00 |
774 827.73 |
11 334.05 |
43 184.31 |
30 |
0.00 |
43 184.31 |
| 28 |
23.9.2013 |
11 600.47 |
1 138.00 |
- |
14 625.00 |
- |
200.00 |
- |
1 880.00 |
29 443.47 |
721 828.89 |
22.11.2013 |
29 536.00 |
804 363.73 |
92.53 |
43 276.84 |
31 |
0.00 |
43 276.84 |
| 29 |
23.10.2013 |
11 580.82 |
1 138.00 |
- |
- |
4 709.38 |
1 793.00 |
- |
1 880.00 |
21 101.20 |
742 930.09 |
22.12.2013 |
29 536.00 |
833 899.73 |
8 434.80 |
51 711.64 |
30 |
0.00 |
51 711.64 |
| 30 |
23.11.2013 |
11 561.18 |
1 138.00 |
- |
- |
5 670.48 |
200.00 |
- |
1 880.00 |
20 449.66 |
763 379.75 |
22.1.2014 |
29 536.00 |
863 435.73 |
9 086.34 |
60 797.98 |
31 |
0.00 |
60 797.98 |
| 31 |
23.12.2013 |
11 541.53 |
1 138.00 |
- |
14 625.00 |
- |
200.00 |
- |
1 880.00 |
29 384.53 |
792 764.28 |
22.2.2014 |
29 536.00 |
892 971.73 |
151.47 |
60 949.45 |
31 |
0.00 |
60 949.45 |
| 32 |
23.1.2014 |
11 521.89 |
1 138.00 |
- |
- |
6 823.79 |
200.00 |
- |
1 880.00 |
21 563.68 |
814 327.96 |
22.3.2014 |
29 536.00 |
922 507.73 |
7 972.32 |
68 921.77 |
28 |
0.00 |
68 921.77 |
| 33 |
23.2.2014 |
11 502.24 |
1 138.00 |
- |
- |
8 073.22 |
200.00 |
- |
1 880.00 |
22 793.46 |
837 121.42 |
22.4.2014 |
29 536.00 |
952 043.73 |
6 742.54 |
75 664.31 |
31 |
0.00 |
75 664.31 |
| 34 |
23.3.2014 |
12 175.60 |
1 138.00 |
- |
14 625.00 |
- |
200.00 |
- |
1 880.00 |
30 018.60 |
867 140.02 |
22.5.2014 |
29 536.00 |
981 579.73 |
-482.60 |
75 181.71 |
30 |
0.00 |
75 181.71 |
| 35 |
23.4.2014 |
11 462.96 |
1 138.00 |
- |
- |
8 649.88 |
1 793.00 |
- |
1 880.00 |
24 923.84 |
892 063.86 |
22.6.2014 |
29 536.00 |
1 011 115.73 |
4 612.16 |
79 793.87 |
31 |
0.00 |
79 793.87 |
| 36 |
23.5.2014 |
11 443.31 |
1 138.00 |
- |
- |
9 995.42 |
200.00 |
- |
1 880.00 |
24 656.73 |
916 720.59 |
22.7.2014 |
52 180.27 |
1 063 296.00 |
27 523.54 |
84 673.14 |
30 |
0.00 |
84 673.14 |
| Кд |
|
0.00 |
|
|
0.00 |
|
336 110.17 |
|
336 110.17 |
472 963.58 |
|
472 963.58 |
| |
Накопительно| расходы: |
916 720.59 |
Накопительно| доходы: |
1 063 296.00 |
валовый БДР: |
146 575.41 |
Обсл овердрафта: |
-9 722.00 |
| |
Чистый итог договора по БДР: |
136 853.41 |
Итог договора по БДДС: |
136 853.41 |
|
