|
| Дебет |
Кредит |
Прогноз |
Прогноз Cash Flow |
| №пп |
Дата |
Внутр фин + налоги |
Внеш фин |
ГИБДД |
Страхование |
MTR |
Шинный сервис |
Помощь на дороге |
Доп услуги |
Сумма |
Накопительный итог |
Дата оплаты |
Сумма |
Накопительный итог |
БДР |
ДП |
КЗ, дней |
% по о/д |
БДДС |
| 1 |
16.6.2011 |
60 013.41 |
|
10 690.00 |
39 434.53 |
11 242.42 |
200.00 |
3 500.00 |
- |
125 080.36 |
125 080.36 |
16.6.2011 |
18 317.41 |
18 317.41 |
-106 762.95 |
-125 080.36 |
10 |
-583.00 |
-125 663.36 |
| 2 |
16.7.2011 |
20 978.45 |
|
- |
- |
- |
200.00 |
- |
- |
21 178.45 |
146 258.81 |
16.7.2011 |
39 251.60 |
57 569.01 |
18 073.15 |
-128 524.40 |
30 |
-1 796.00 |
-130 320.40 |
| 3 |
16.8.2011 |
20 943.49 |
|
- |
- |
7 341.99 |
200.00 |
- |
- |
28 485.48 |
174 744.29 |
16.8.2011 |
39 251.60 |
96 820.61 |
10 766.12 |
-119 554.28 |
31 |
-1 726.00 |
-121 280.28 |
| 4 |
16.9.2011 |
20 908.53 |
|
- |
24 613.53 |
- |
200.00 |
- |
- |
45 722.06 |
220 466.34 |
16.9.2011 |
39 251.60 |
136 072.21 |
-6 470.46 |
-127 750.74 |
31 |
-1 845.00 |
-129 595.74 |
| 5 |
16.10.2011 |
20 873.57 |
|
- |
- |
- |
21 797.00 |
- |
- |
42 670.57 |
263 136.91 |
16.10.2011 |
39 251.60 |
175 323.81 |
-3 418.97 |
-133 014.71 |
30 |
-1 859.00 |
-134 873.71 |
| 6 |
16.11.2011 |
20 838.61 |
|
- |
- |
8 030.30 |
200.00 |
- |
- |
29 068.91 |
292 205.82 |
16.11.2011 |
39 251.60 |
214 575.41 |
10 182.69 |
-124 691.02 |
31 |
-1 800.00 |
-126 491.02 |
| 7 |
16.12.2011 |
20 803.65 |
|
- |
24 613.53 |
- |
200.00 |
- |
- |
45 617.18 |
337 823.00 |
16.12.2011 |
39 251.60 |
253 827.01 |
-6 365.58 |
-132 856.60 |
30 |
-1 856.00 |
-134 712.60 |
| 8 |
16.1.2012 |
20 768.69 |
|
- |
- |
- |
200.00 |
- |
- |
20 968.69 |
358 791.69 |
16.1.2012 |
39 251.60 |
293 078.61 |
18 282.91 |
-116 429.69 |
31 |
-1 681.00 |
-118 110.69 |
| 9 |
16.2.2012 |
20 733.73 |
|
- |
- |
8 259.74 |
200.00 |
- |
- |
29 193.47 |
387 985.16 |
16.2.2012 |
39 251.60 |
332 330.21 |
10 058.13 |
-108 052.56 |
31 |
-1 560.00 |
-109 612.56 |
| 10 |
16.3.2012 |
20 698.77 |
|
- |
24 613.53 |
- |
200.00 |
- |
- |
45 512.30 |
433 497.45 |
16.3.2012 |
39 251.60 |
371 581.81 |
-6 260.70 |
-115 873.26 |
29 |
-1 565.00 |
-117 438.26 |
| 11 |
16.4.2012 |
20 663.81 |
|
- |
- |
- |
1 797.00 |
- |
- |
22 460.81 |
455 958.26 |
16.4.2012 |
39 251.60 |
410 833.41 |
16 790.79 |
-100 647.47 |
31 |
-1 453.00 |
-102 100.47 |
| 12 |
16.5.2012 |
59 628.85 |
|
- |
- |
6 653.68 |
200.00 |
- |
- |
66 482.53 |
522 440.79 |
16.5.2012 |
39 251.60 |
450 085.01 |
-27 230.93 |
-129 331.40 |
30 |
-1 807.00 |
-131 138.40 |
| 13 |
16.6.2012 |
20 634.59 |
|
- |
39 434.53 |
- |
200.00 |
3 500.00 |
- |
63 769.12 |
586 209.91 |
16.6.2012 |
39 251.60 |
489 336.61 |
-24 517.52 |
-155 655.92 |
31 |
-2 247.00 |
-157 902.92 |
| 14 |
16.7.2012 |
20 598.96 |
|
- |
- |
- |
200.00 |
- |
- |
20 798.96 |
607 008.87 |
16.7.2012 |
39 251.60 |
528 588.21 |
18 452.64 |
-139 450.28 |
30 |
-1 948.00 |
-141 398.28 |
| 15 |
16.8.2012 |
20 563.34 |
|
- |
- |
5 506.49 |
200.00 |
- |
- |
26 269.83 |
633 278.70 |
16.8.2012 |
39 251.60 |
567 839.81 |
12 981.77 |
-128 416.51 |
31 |
-1 854.00 |
-130 270.51 |
| 16 |
16.9.2012 |
20 527.72 |
|
- |
24 613.53 |
- |
200.00 |
- |
- |
45 341.25 |
678 619.94 |
16.9.2012 |
39 251.60 |
607 091.41 |
-6 089.65 |
-136 360.16 |
31 |
-1 969.00 |
-138 329.16 |
| 17 |
16.10.2012 |
20 492.10 |
|
- |
- |
- |
1 797.00 |
- |
- |
22 289.10 |
700 909.04 |
16.10.2012 |
39 251.60 |
646 343.01 |
16 962.50 |
-121 366.66 |
30 |
-1 696.00 |
-123 062.66 |
| 18 |
16.11.2012 |
20 456.48 |
|
- |
- |
6 194.81 |
200.00 |
- |
- |
26 851.29 |
727 760.33 |
16.11.2012 |
39 251.60 |
685 594.61 |
12 400.31 |
-110 662.35 |
31 |
-1 598.00 |
-112 260.35 |
| 19 |
16.12.2012 |
20 420.86 |
|
- |
24 613.53 |
- |
200.00 |
- |
- |
45 234.39 |
772 994.72 |
16.12.2012 |
39 251.60 |
724 846.21 |
-5 982.79 |
-118 243.14 |
30 |
-1 652.00 |
-119 895.14 |
| 20 |
16.1.2013 |
20 385.24 |
|
- |
- |
- |
200.00 |
- |
- |
20 585.24 |
793 579.96 |
16.1.2013 |
39 251.60 |
764 097.81 |
18 666.36 |
-101 228.78 |
31 |
-1 462.00 |
-102 690.78 |
| 21 |
16.2.2013 |
20 349.62 |
|
- |
- |
7 112.55 |
200.00 |
- |
- |
27 662.17 |
821 242.13 |
16.2.2013 |
39 251.60 |
803 349.41 |
11 589.43 |
-91 101.35 |
31 |
-1 315.00 |
-92 416.35 |
| 22 |
16.3.2013 |
20 313.99 |
|
- |
24 613.53 |
- |
200.00 |
- |
- |
45 127.52 |
866 369.64 |
16.3.2013 |
39 251.60 |
842 601.01 |
-5 875.92 |
-98 292.27 |
28 |
-1 282.00 |
-99 574.27 |
| 23 |
16.4.2013 |
59 278.37 |
|
- |
- |
- |
1 797.00 |
- |
- |
61 075.37 |
927 445.01 |
16.4.2013 |
39 251.60 |
881 852.61 |
-21 823.77 |
-121 398.04 |
31 |
-1 753.00 |
-123 151.04 |
| 24 |
16.5.2013 |
20 242.75 |
|
- |
- |
8 259.74 |
200.00 |
- |
- |
28 702.49 |
956 147.50 |
16.5.2013 |
39 251.60 |
921 104.21 |
10 549.11 |
-112 601.93 |
30 |
-1 573.00 |
-114 174.93 |
| 25 |
16.6.2013 |
20 207.13 |
|
- |
39 434.53 |
- |
200.00 |
3 500.00 |
- |
63 341.66 |
1 019 489.16 |
16.6.2013 |
39 251.60 |
960 355.81 |
-24 090.06 |
-138 264.99 |
31 |
-1 996.00 |
-140 260.99 |
| 26 |
16.7.2013 |
20 171.51 |
|
- |
- |
- |
200.00 |
- |
- |
20 371.51 |
1 039 860.67 |
16.7.2013 |
39 251.60 |
999 607.41 |
18 880.09 |
-121 380.90 |
30 |
-1 696.00 |
-123 076.90 |
| 27 |
16.8.2013 |
20 135.89 |
|
- |
- |
10 324.68 |
200.00 |
- |
- |
30 660.57 |
1 070 521.24 |
16.8.2013 |
39 251.60 |
1 038 859.01 |
8 591.03 |
-114 485.87 |
31 |
-1 653.00 |
-116 138.87 |
| 28 |
16.9.2013 |
20 100.27 |
|
- |
24 613.53 |
- |
200.00 |
- |
- |
44 913.80 |
1 115 435.03 |
16.9.2013 |
39 251.60 |
1 078 110.61 |
-5 662.20 |
-121 801.07 |
31 |
-1 759.00 |
-123 560.07 |
| 29 |
16.10.2013 |
20 064.65 |
|
- |
- |
- |
1 797.00 |
- |
- |
21 861.65 |
1 137 296.68 |
16.10.2013 |
39 251.60 |
1 117 362.21 |
17 389.95 |
-106 170.12 |
30 |
-1 483.00 |
-107 653.12 |
| 30 |
16.11.2013 |
20 029.02 |
|
- |
- |
10 783.55 |
200.00 |
- |
- |
31 012.57 |
1 168 309.25 |
16.11.2013 |
39 251.60 |
1 156 613.81 |
8 239.03 |
-99 414.09 |
31 |
-1 435.00 |
-100 849.09 |
| 31 |
16.12.2013 |
19 993.40 |
|
- |
24 613.53 |
- |
200.00 |
- |
- |
44 806.93 |
1 213 116.18 |
16.12.2013 |
39 251.60 |
1 195 865.41 |
-5 555.33 |
-106 404.42 |
30 |
-1 487.00 |
-107 891.42 |
| 32 |
16.1.2014 |
19 957.78 |
|
- |
- |
- |
200.00 |
- |
- |
20 157.78 |
1 233 273.96 |
16.1.2014 |
39 251.60 |
1 235 117.01 |
19 093.82 |
-88 797.60 |
31 |
-1 282.00 |
-90 079.60 |
| 33 |
16.2.2014 |
19 922.16 |
|
- |
- |
10 095.24 |
200.00 |
- |
- |
30 217.40 |
1 263 491.36 |
16.2.2014 |
39 251.60 |
1 274 368.61 |
9 034.20 |
-81 045.40 |
31 |
-1 170.00 |
-82 215.40 |
| 34 |
16.3.2014 |
58 886.54 |
|
- |
24 613.53 |
- |
200.00 |
- |
- |
83 700.07 |
1 347 191.42 |
16.3.2014 |
39 251.60 |
1 313 620.21 |
-44 448.47 |
-126 663.87 |
28 |
-1 652.00 |
-128 315.87 |
| 35 |
16.4.2014 |
19 850.92 |
|
- |
- |
- |
1 797.00 |
- |
- |
21 647.92 |
1 368 839.34 |
16.4.2014 |
39 251.60 |
1 352 871.81 |
17 603.68 |
-110 712.19 |
31 |
-1 599.00 |
-112 311.19 |
| 36 |
16.5.2014 |
19 815.30 |
|
1 700.00 |
- |
8 259.74 |
200.00 |
- |
- |
29 975.04 |
1 398 814.38 |
16.5.2014 |
60 185.79 |
1 413 057.60 |
30 210.75 |
-103 034.63 |
30 |
-1 440.00 |
-104 474.63 |
| Кд |
|
0.00 |
|
|
0.00 |
|
587 437.29 |
|
587 437.29 |
543 148.45 |
|
543 148.45 |
| |
Накопительно| расходы: |
1 398 814.38 |
Накопительно| доходы: |
1 413 057.60 |
валовый БДР: |
14 243.16 |
Обсл овердрафта: |
-58 532.00 |
| |
Чистый итог договора по БДР: |
-44 288.84 |
Итог договора по БДДС: |
-44 288.84 |
|
