【财务分析报表】销售收入、成本、费用、税金分析表 (2).xls
《【财务分析报表】销售收入、成本、费用、税金分析表 (2).xls》由会员分享,可在线阅读,更多相关《【财务分析报表】销售收入、成本、费用、税金分析表 (2).xls(16页珍藏版)》请在淘文阁 - 分享文档赚钱的网站上搜索。
1、销售收入、成本、费用、税金分析表共16页第1页被审计单位名称:查验人员:日期:索引号:所属时期或截至时间:复核人员:日期:金额单位:人民币元月份销售收入销售成本销售费用销售税金销售成本率销售费用率销售税金率19423.729583.95167.3371.18101.70%1.78%0.76%212450.566814.59912.7469.7354.73%7.33%0.56%39644.086410.80325.00450.9266.47%3.37%4.68%49073.867973.96913.67417.3487.88%10.07%4.60%58727.656426.12863.84480
2、.4473.63%9.90%5.50%68348.588115.34685.56200.1797.21%8.21%2.40%77373.546417.38733.52275.4587.03%9.95%3.74%88148.586789.57126.9065.4983.32%1.56%0.80%910821.647769.41818.08268.8371.80%7.56%2.48%107063.386441.4476.49194.2091.19%1.08%2.75%119646.866012.06120.78493.7662.32%1.25%5.12%128690.635379.62307.77
3、66.9361.90%3.54%0.77%合计109413.0884134.236051.693054.4376.90%5.53%2.79%一、销售收入、成本相关情况二、销售成本率变化情况回归函数为:0.1275156135848.529728平均值:78.27%Y=0.1275X+5848.5297(Y:销售成本 X:销售收入)标准差:14.57%相关系数为:r=0.1635异常销售收入、成本对比表1234567891011120.00 2000.00 4000.00 6000.00 8000.00 10000.00 12000.00 14000.00 销售收入销售成本销售成本率变化情况12
4、34567891011120.00%20.00%40.00%60.00%80.00%100.00%120.00%销售成本率销售收入、成本、费用、税金分析表共16页第2页被审计单位名称:查验人员:日期:索引号:所属时期或截至时间:复核人员:日期:金额单位:人民币元三、销售收入、费用相关情况四、销售费用率变化情况回归函数为:0.089387306-310.7041417平均值:5.47%Y=0.0894X+-310.7041(Y:销售费用 X:销售收入)标准差:3.54%相关系数为:r=0.3818异常五、销售收入、税金相关情况六、销售税金率变化情况回归函数为:-0.005059616300.66
5、81338平均值:2.85%Y=-0.0051X+300.6681(Y:销售税金 X:销售收入)标准差:1.78%相关系数为:r=-0.0437异常销售收入、费用对比表12345678910 11120.00 2000.00 4000.00 6000.00 8000.00 10000.00 12000.00 14000.00 销售收入销售费用销售费用率变化情况1234567891011120.00%2.00%4.00%6.00%8.00%10.00%12.00%销售费用率销售收入、费用对比表12345678910 11120.00 2000.00 4000.00 6000.00 8000.00
6、 10000.00 12000.00 14000.00 销售收入销售税金销售税金率变化情况1234567891011120.00%1.00%2.00%3.00%4.00%5.00%6.00%销售税金率销售收入、成本、费用、税金分析表共16页第3页销售收入、成本、费用、税金分析表共16页第4页销售收入、成本、费用、税金年度对比表共16页第5页被审计单位名称:查验人员:日期:索引号:所属时期或截至时间:复核人员:日期:金额单位:人民币元月份上年度本年度增减金额增减比率销售收入77102.72109413.0832310.3641.9%销售成本75101.4484134.239032.7912.0%
7、销售费用11030.486051.69-4978.79-45.1%销售税金3573.423054.43-518.99-14.5%销售成本率97.40%76.90%-20.51%-21.1%销售费用率14.31%5.53%-8.78%-61.3%销售税金率4.63%2.79%-1.84%-39.8%一、销售收入、成本、费用、税金对比图二、销售成本率、销售费用率、销售税金率对比图销售收入销售成本销售费用销售税金0.00 20000.00 40000.00 60000.00 80000.00 100000.00 120000.00 上年度本年度销售成本率销售费用率销售税金率0.00%20.00%40
8、.00%60.00%80.00%100.00%120.00%上年度本年度销售收入、成本汇总表共16页第6页被审计单位名称:查验人员:日期:索引号:所属时期或截至时间:复核人员:日期:金额单位:人民币元产品名称上年销售情况本年销售情况销售收入销售成本销售数量销售单价单位成本销售成本率销售收入销售成本销售数量销售单价单位成本销售成本率A4274.275582.8993.3845.7759.79130.62%1116.641362.9313.7381.3499.28 122.06%B5699.933864.5043.26131.7789.3467.80%290.78698.777.0341.3799
9、.40 240.31%C3232.6797.7171.1445.441.373.02%977.50613.505.10191.58120.2462.76%D5678.19675.4263.4089.5610.6511.89%7373.833422.3982.7789.0941.3546.41%E1080.751230.0917.3262.4171.03113.82%6836.523968.57116.9458.4633.9458.05%F4482.663946.3741.20108.8195.7988.04%5311.295378.73104.3350.9151.55 101.27%G866.
10、546990.8648.4217.90144.37806.75%5046.315346.3470.6371.4575.70 105.95%H4242.742347.6388.5447.9226.5155.33%6277.044544.81125.3250.0936.2772.40%I7265.06311.1946.53156.156.694.28%6789.475207.9897.7969.4353.2576.71%J2697.497383.0995.0928.3777.65273.70%5911.056044.3892.9363.6165.04 102.26%K5588.063026.880
11、.698128.524402.9854.17%6910.394254.37114.1960.5237.2661.56%L2661.867632.9625.08106.12304.30286.75%5250.295821.25146.7035.7939.68 110.87%M3775.871134.6083.7745.0713.5430.05%6241.535027.17136.3045.7936.8880.54%N6809.783700.9038.30177.8096.6354.35%4847.725543.17127.3138.0843.54 114.35%O907.874330.1245.
12、7419.8594.66476.95%7178.795682.91102.3470.1455.5379.16%P5630.976985.2390.2662.3877.39124.05%7075.293762.41107.9665.5434.8553.18%Q3656.935527.4428.21129.63195.94151.15%6567.903210.20125.6052.2925.5648.88%R6426.084334.1148.57132.3089.2367.45%4921.254116.08124.6839.4733.0183.64%S680.215054.9666.1110.29
13、76.46743.14%7182.224211.4696.8474.1743.4958.64%T1444.76944.5078.4718.4112.0465.37%7307.285916.81124.9158.5047.3780.97%合计77102.7275101.4497.40%109413.0884134.2376.90%一、上年销售收入结构图二、本年销售收入结构图5%7%4%7%1%6%1%5%9%3%7%3%5%9%1%7%5%8%1%2%ABCDEFGHIJKLMNOPQRST1%0%1%7%6%5%5%6%6%5%6%5%6%4%7%6%6%4%7%7%ABCDEFGHIJKLM
14、NOPQRST销售收入、成本汇总表共16页第7页三、上年销售成本结构图四、本年销售成本结构图五、销售收入对比图六、销售成本对比图七、销售成本率对比图8%5%0%1%2%5%9%3%0%10%4%10%2%5%6%9%7%6%7%1%ABCDEFGHIJKLMNOPQRST2%1%1%4%5%6%6%5%6%7%5%7%6%7%7%4%4%5%5%7%ABCDEFGHIJKLMNOPQRSTABCDEFGHIJKLM NOPQRST0.00 1000.00 2000.00 3000.00 4000.00 5000.00 6000.00 7000.00 8000.00 上年销售收入本年销售收入AB
15、CDEFGHIJKLMNOPQRST0.00 1000.00 2000.00 3000.00 4000.00 5000.00 6000.00 7000.00 8000.00 9000.00 上年销售成本本年销售成本ABCDEFGHIJKLM NOPQRST0.00%200.00%400.00%600.00%800.00%1000.00%上年销售成本率本年销售成本率5%7%4%7%1%6%1%5%9%3%7%3%5%9%1%7%5%8%1%2%ABCDEFGHIJKLMNOPQRST1%0%1%7%6%5%5%6%6%5%6%5%6%4%7%6%6%4%7%7%ABCDEFGHIJKLMNOPQ
16、RST被审计单位名称:查验人员:日期:索引号:所属时期或截至时间:复核人员:日期:金额单位:人民币元销售收入、成本汇总表共16页第8页八、销售数量对比图九、销售单价对比图十、单位成本对比图ABCDEFGHIJKLM NOPQRST0.00 20.00 40.00 60.00 80.00 100.00 120.00 140.00 160.00 上年销售数量本年销售数量ABCDEFGHIJKLMNOPQRST0.00 1000.00 2000.00 3000.00 4000.00 5000.00 6000.00 7000.00 8000.00 9000.00 上年销售单价本年销售单价ABCDEFG
17、HIJKLM NOPQRST0.00 500.00 1000.00 1500.00 2000.00 2500.00 3000.00 3500.00 4000.00 4500.00 5000.00 上年单位成本本年单位成本ABCDEFGHIJKLM NOPQRST0.00%200.00%400.00%600.00%800.00%1000.00%上年销售成本率本年销售成本率被审计单位名称:查验人员:日期:索引号:所属时期或截至时间:复核人员:日期:金额单位:人民币元销售收入、成本汇总表共16页第9页ABCDEFGHIJKLM NOPQRST0.00 500.00 1000.00 1500.00 2
18、000.00 2500.00 3000.00 3500.00 4000.00 4500.00 5000.00 上年单位成本本年单位成本被审计单位名称:查验人员:日期:索引号:所属时期或截至时间:复核人员:日期:金额单位:人民币元分产品销售收入、成本分析表共16页第10页被审计单位名称:查验人员:日期:索引号:所属时期或截至时间:复核人员:日期:金额单位:人民币元产品名称项目1月份2月份3月份4月份5月份6月份7月份8月份9月份10月份11月份12月份合计A销售收入360.70755.941116.64销售成本781.44581.491362.93销售数量2.1311.6013.73销售单价16
19、9.0865.190.000.000.000.000.000.000.000.000.000.0081.34单位成本366.3050.150.000.000.000.000.000.000.000.000.000.0099.28销售成本率216.6%76.9%0.0%0.0%0.0%0.0%0.0%0.0%0.0%0.0%0.0%0.0%122.1%收入、成本、数量对比图单价、成本对比图销售成本率趋势图产品名称项目1月份2月份3月份4月份5月份6月份7月份8月份9月份10月份11月份12月份合计B销售收入290.78290.78销售成本698.77698.77销售数量7.037.03销售单价4
20、1.370.000.000.000.000.000.000.000.000.000.000.0041.37单位成本99.400.000.000.000.000.000.000.000.000.000.000.0099.40销售成本率240.3%0.0%0.0%0.0%0.0%0.0%0.0%0.0%0.0%0.0%0.0%0.0%240.3%收入、成本、数量对比图单价、成本对比图销售成本率趋势图1234567891011120.00 100.00 200.00 300.00 400.00 500.00 600.00 700.00 800.00 900.00 销售收入销售成本销售数量123456
21、7891011120.00 50.00 100.00 150.00 200.00 250.00 300.00 350.00 400.00 销售单价单位成本1234567891011120.0%50.0%100.0%150.0%200.0%250.0%销售成本率1234567891011120.00 100.00 200.00 300.00 400.00 500.00 600.00 700.00 800.00 销售收入销售成本销售数量1234567891011120.00 20.00 40.00 60.00 80.00 100.00 120.00 销售单价单位成本1234567891011120
22、.0%50.0%100.0%150.0%200.0%250.0%300.0%销售成本率分产品销售收入、成本分析表共16页第11页产品名称项目1月份2月份3月份4月份5月份6月份7月份8月份9月份10月份11月份12月份合计C销售收入977.50977.50销售成本613.50613.50销售数量5.105.10销售单价191.580.000.000.000.000.000.000.000.000.000.000.00191.58单位成本120.240.000.000.000.000.000.000.000.000.000.000.00120.24销售成本率62.8%0.0%0.0%0.0%0.
23、0%0.0%0.0%0.0%0.0%0.0%0.0%0.0%62.8%收入、成本、数量对比图单价、成本对比图销售成本率趋势图产品名称项目1月份2月份3月份4月份5月份6月份7月份8月份9月份10月份11月份12月份合计D销售收入557.19765.72678.04624.73335.87647.54746.27450.69927.28543.90685.02411.577373.83销售成本302.8323.74220.89694.51105.3335.72480.57741.09211.23337.90100.57168.013422.39销售数量9.936.0911.982.307.051
24、2.542.621.883.993.3119.231.8682.77销售单价56.09125.7056.60271.4047.6651.64285.33239.62232.63164.1835.63221.7989.09单位成本30.483.9018.44301.7114.952.85183.74394.0252.99102.005.2390.5441.35销售成本率54.3%3.1%32.6%111.2%31.4%5.5%64.4%164.4%22.8%62.1%14.7%40.8%46.4%收入、成本、数量对比图单价、成本对比图销售成本率趋势图1234567891011120.00 200
25、.00 400.00 600.00 800.00 1000.00 1200.00 销售收入销售成本销售数量1234567891011120.00 50.00 100.00 150.00 200.00 250.00 销售单价单位成本1234567891011120.0%10.0%20.0%30.0%40.0%50.0%60.0%70.0%销售成本率1234567891011120.00 100.00 200.00 300.00 400.00 500.00 600.00 700.00 800.00 900.00 1000.00 销售收入销售成本销售数量1234567891011120.00 50.
- 配套讲稿:
如PPT文件的首页显示word图标,表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制:
部分文档作品中含有的国旗、国徽等图片,仅作为作品整体效果示例展示,禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词:
- 财务分析报表 【财务分析报表】销售收入、成本、费用、税金分析表 2 财务 分析 报表 销售收入 成本 费用 税金
限制150内