配色: 字号:
V2 业务思维_现金预测快报模板
2017-06-15 | 阅:  转:  |  分享 
  
4033
40432
919
7652
329
2467
736
1987
-98
-319
12
98.3
-367
-598
115.6
983
123
873
-24.7
32
5777.9000000000005
53607.3
6/30/2017
1/31/2017
2/28/2017
3/31/2017
4/30/2017
5/31/2017
6/30/2017
7/31/2017
8/31/2017
9/30/2017
10/31/2017
11/30/2017
12/31/2017
1/31/2017
2/28/2017
3/31/2017
4/30/2017
5/31/2017
6/30/2017
7/31/2017
8/31/2017
9/30/2017
10/31/2017
11/30/2017
12/31/2017
244
244
244
244
244
244
244
244
244
244
244
244
244
244
244
244
244
244
244
244
244
244
244
244
244
244
244
244
244
18480
19180
2900
8100
38480
2980
3300
3200
3000
3100
2900
2700
2500
3200
3900
3800
3900
2980
3200
3600
3300
3200
2900
2700
2500
3400
3200
3900
3800
0.66499999999999992
0.67
0.67
0.67
0.66416666666666668
0.66
0.66
0.66
0.67
0.67
0.67
0.67
0.67
0.66
0.66
0.66
0.66
0.67
0.67
0.67
0.67
0.67
0.67
0.67
0.67
0.67
0.67
0.67
0.67
7.5666666666666674E-2
0.08
5.8000000000000003E-2
7.2666666666666671E-2
7.7833333333333324E-2
0.08
6.8000000000000005E-2
0.08
0.08
8.7999999999999995E-2
5.8000000000000003E-2
0.08
0.08
0.08
0.08
0.08
0.08
0.08
0.08
0.08
0.08
0.08
0.08
0.08
0.08
0.08
0.08
0.08
0.08
1398.3200000000002
1534.4
168.20000000000002
588.6
2995.0266666666662
238.4
224.4
256
240
272.8
168.20000000000002
216
200
256
312
304
312
238.4
256
288
264
256
232
216
200
272
256
312
304
1026
1122
155
465
2083.2000000000003
187
187
187
155
155
155
155
155
185
187.39999999999998
187.39999999999998
187.39999999999998
187
187
187
187
187
187
187
187
187
187
187
187
153
159
24.5
73.5
307.2
26.5
26.5
26.5
24.5
24.5
24.5
24.5
24.5
24.5
26.9
26.9
26.9
26.5
26.5
26.5
26.5
26.5
26.5
26.5
26.5
26.5
26.5
26.5
26.5
85.8
85.8
14.3
42.900000000000006
171.60000000000002
14.3
14.3
14.3
14.3
14.3
14.3
14.3
14.3
14.3
14.3
14.3
14.3
14.3
14.3
14.3
14.3
14.3
14.3
14.3
14.3
14.3
14.3
14.3
14.3
33
33
5.5
16.5
66
5.5
5.5
5.5
5.5
5.5
5.5
5.5
5.5
5.5
5.5
5.5
5.5
5.5
5.5
5.5
5.5
5.5
5.5
5.5
5.5
5.5
5.5
5.5
5.5
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
754.2
844.2
110.7
332.1
1538.4000000000003
140.69999999999999
140.69999999999999
140.69999999999999
110.7
110.7
110.7
110.7
110.7
140.69999999999999
140.69999999999999
140.69999999999999
140.69999999999999
140.69999999999999
140.69999999999999
140.69999999999999
140.69999999999999
140.69999999999999
140.69999999999999
140.69999999999999
140.69999999999999
140.69999999999999
140.69999999999999
140.69999999999999
140.69999999999999
45
45
45
45
45
45
45
45
45
45
45
45
45
45
45
45
45
45
45
45
45
45
45
45
45
45
45
45
45
15071.803278688525
15642.704918032787
2365.1639344262294
6606.1475409836066
31383.278688524591
2430.4098360655739
2691.3934426229507
2609.8360655737706
2446.7213114754099
2528.2786885245901
2365.1639344262294
2202.0491803278687
2038.9344262295081
2609.8360655737706
3180.7377049180327
3099.1803278688526
3180.7377049180327
2430.4098360655739
2609.8360655737706
2936.0655737704919
2691.3934426229507
2609.8360655737706
2365.1639344262294
2202.0491803278687
2038.9344262295081
2772.9508196721313
2609.8360655737706
3180.7377049180327
3099.1803278688526
10.5
10
12
12
10.333333333333334
10
12
9
10
10
12
12
12
10
10
9
8
10
10
10
10
10
10
10
10
10
10
10
10
12818.038524590163
13377.26393442623
2038.5573770491806
5693.9016393442625
26639.470947176687
2047.4065573770495
2285.1147540983607
2189.9016393442621
2092.377049180328
2162.122950819672
2038.5573770491806
1897.967213114754
1757.377049180328
2198.5573770491801
2679.4918032786886
2600.5081967213114
2658.3934426229507
2078.4278688524591
2231.8688524590166
2510.8524590163934
2301.6147540983607
2231.8688524590166
2022.6311475409839
1883.139344262295
1743.6475409836066
2371.3606557377047
2231.8688524590166
2720.0901639344261
2650.344262295082
40
40
40
40
40
40
40
40
40
40
40
40
40
40
40
40
40
40
40
40
40
40
40
40
40
40
40
40
40
-2101.3177909164201
-2192.9940876108576
-334.1897339424886
-933.42649825315777
-4367.1263847830633
-335.64041924213927
-374.60897608169842
-359.00026874496098
-343.01263101316852
-354.44638538027414
-334.1897339424886
-311.14216608438591
-288.09459822628327
-360.41924213920987
-439.26095135716207
-426.31281913464125
-435.80220370868051
-340.72588013974735
-365.88013974737976
-411.61515721580213
-377.31389411448532
-365.88013974737976
-331.57887664606289
-308.71136791185165
-285.84385917764041
-388.74764848159094
-365.88013974737976
-445.91642031711905
-434.48266595001343
66
66
11
33
132
11
11
11
11
11
11
11
11
11
11
11
11
11
11
11
11
11
11
11
11
11
11
11
11
1450
1480
0
0
2300
240
1210
230
620
240
1240
240
640
314.74484009674916
259.46375974200419
260.43563558183246
703.2379736629938
1413.1669130162118
60.946976619188376
326.82209083579653
331.21338349906
271.39787691480785
-933.76263101316852
260.43563558183246
230.76101854340203
212.85279494759442
323.97661918839088
397.25275463585024
165.37839290513364
-205.10763235689342
29.515224402042691
290.22440204246175
327.87745229776988
-940.36233539371142
290.22440204246175
261.98461435098045
243.15808922332678
224.33156409567289
309.05092717011604
50.224402042461747
-283.88276001074968
346.70397742542337
0
0
1000
2000
1000
-1000
1000
1000
2000
-1000
1000
997.47914539102487
2056.6176968556842
2056.6176968556842
1000
1000
1060.9469766191883
1387.7690674549849
1718.9824509540449
1990.3803278688529
2056.6176968556842
1317.0533324375167
547.81435098091879
760.66714592851326
1084.6437651169042
1481.8965197527546
1647.2749126578883
1000
1029.5152244020428
1319.7396264445047
1647.6170787422745
707.25474334856312
997.47914539102487
1259.4637597420053
-497.37815103466778
726.95341306100522
1036.0043402311212
1086.2287422735831
802.34598226283333
1314.7448400967492
1256.9429051330289
1317.0533324375167
759.85567051867793
1413.1669130162118
997.37815103466778
244
244
244
365
365
25600
31200
29800
33200
33200
0.65
0.66
0.67
0.67
0.67
0.08
0.06
0.08
7.0000000000000007E-2
7.0000000000000007E-2
2048
1872
2384
2324
2324
1780
1600
1870
2354
2354
230
240
265
310
310
120
130
143
165
165
45
45
55
65
65
0
0
0
0
0
1385
1185
1407
1814
1814
55
45
53
50
50
19829.508196721312
25445.901639344262
23327.049180327871
28652.054794520547
28652.054794520547
45
30
43
42
42
19708.852459016394
23123.803278688523
23484.598360655738
24803.583561643834
24803.583561643834
90
120
110
100
100
-7269.6586938994897
-11372.362268207471
-10587.318933082504
-6795.5023456558447
-6795.5023456558447
156
110
110
340
340
1427
2780
2780
2800
2800
1594.8554152109646
6661.5098091910768
2685.0566380005403
4138.4941264777626
4138.4941264777626
5000
8000
8000
1200
1500
1300
1100
1100
2794.8554152109646
3161.5098091910768
3985.0566380005403
-2761.5058735222374
-2761.5058735222374
本月数
累计
预算营业利润总额
因素:
设计贡献
采购贡献
生产贡献
销售贡献
售后服务贡献
人力贡献
资金贡献
节税贡献
行政贡献
实际经营利润总额
盈利贡献分析
现金预测快报
Sendto:
Copyto:
date:
Unit:10KRMB
本年累计YTD
Actual
Budget
Forecast
本月
本季
本年
经营天数
销售收入
变动成本率
变动费用率
变动费用支出
固定费用
预提
摊销
递延
固定费用支出
DSO
DTO
DCO
销售回款
采购付款
递延付款
购置固定资产
在建工程支付
资金需求量
贷款归还
现金存有量
现金缺口
编制:
审核:
折旧
减:
资金计划
变动成本率
变动费用支出
固定费用
减:
折旧
预提
摊销
递延
固定费用支出
销售回款
采购付款
递延付款
购置固定资产
在建工程支付
变动费用率
DSO
DTO
DCO
跟踪预测
销售收入
预算
销售收入
变动成本率
变动费用率
变动费用支出
固定费用
减:
折旧
预提
摊销
递延
固定费用支出
销售回款
采购付款
递延付款
购置固定资产
在建工程支付
资金需求量
贷款归还
现金存有量
现金缺口
资金计划
CurrentMonth
经营天数
贷款归还
现金存有量
本月
M1+2
现金余额
现金跟踪预测快报
献花(0)
+1
(本文系108qq首藏)