贸易业务单价利润收益率计算表

煤炭贸易业务利润及收益率测算表,,,,,,,,,

注意事项:1.进项和销项增值税税率按照13%测算,,,,,,,,,

,,,,,,,,,,

,项目,金额,占用资金,合计,备注,勾稽,金额,占用资金,

税率,,13%,,,,税率,0.00000,0,13%

总收入,销售数量/吨,10000,,10000,,销售数量/吨,0.00000,0.00000,100000

,销售单价/含税,750,,750,,销售单价/含税,0.00000,0.00000,750

,销售单价/不含税,663.71681,,663.71681,,销售单价/不含税,0.00000,0.00000,663.71681

,收入/含税,7500000,,7500000,,收入/含税,0.00000,0.00000,75000000

,收入/不含税,6637168.14,,6637168.14,,收入/不含税,0.00000,0.00000,66371681.42

,销项税,862831.86,,862831.86,,销项税,0.00000,0.00000,8628318.58

总成本,采购数量,10000,,10000,,采购数量,0.00000,0.00000,100000

,进价/含税,740,,740,,进价/含税,0.00000,0.00000,740

,进价/不含税,654.86726,,654.86726,,进价/不含税,0.00000,#DIV/0!,654.86726

,采购成本/含税,7400000.00,,7400000.00,,采购成本/含税,0.00000,0.00000,74000000.00

,采购成本/不含税,6548672.57,,6548672.57,,采购成本/不含税,0.00000,0.00000,65486725.66

,进项税,"851,327.43",,"851,327.43",,进项税,0.00000,0.00000,"8,513,274.34"

,进销差价/含税,10.00,,10.00,,进销差价/含税,0.00000,0.00000,10.00

,进销差价/不含税,8.85,,8.85,,进销差价/不含税,0.00000,0.00000,8.85

,增值税,"11,504.42",,"11,504.42",,增值税,0.00000,0.00000,"115,044.25"

,附加税,"1,380.53",,"1,380.53",,附加税,0.00000,0.00000,"13,805.31"

,印花税,"4,470.00",,"4,470.00",,印花税,0.00000,0.00000,"44,700.00"

,税收合计,"17,354.96",,"17,354.96",,税收合计,0.00000,0.00000,"173,549.56"

收益,公司获利,"82,645.04",,"82,645.04",,公司获利,0.00000,0.00000,"826,450.44"

,公司获利：销售收入,1.10%,,1.10%,,公司获利：销售收入,0.00000,#DIV/0!,1.10%

,利润总额/财务口径,"82,645.04",,"82,645.04",,利润总额/会计口径,0.00000,0.00000,"826,450.44"

资金,资金金额（货款80%）,"5,920,000.00",,,,,,,"59,200,000.00"

,资金占用天数,45.