利润
表
关于同志近三年现实表现材料材料类招标技术评分表图表与交易pdf视力表打印pdf用图表说话 pdf
会企02表单位:2013年4月单位:元项目本月金额本年累计金额上年同期累计一、营业收入720,557.30720,557.300#公式以单元格名称加“=”号开始,以英文分号“;”结束减:营业成本000#每独立行设置一个公式,公式中涉及到的数字、英文、符号均为英文半角格式营业税金及附加000#例如设置B6请在单独一行中输入:B6=QueryAYear()+QueryAMonth()+B4;销售费用000管理费用1,019.401,019.400A3="单位:"+QueryCom();财务费用000B3=QueryAYear()+"年"+QueryAMonth()+"月";资产减值损失4,000.004,000.000B5=FS("6001","","年","月","贷")+FS("6051","","年","月","贷");加:公允价值变动收益(损失以"-"填列)000B6=FS("6401","","年","月","借")+FS("6402","","年","月","借");投资收益(损失以"-"填列)000B7=FS("6403","","年","月","借");其中:对联营企业和合营企业的投资收益B8=FS("6601","","年","月","借");二、营业利润(亏损以"-"号填列)715,537.90715,537.900B9=FS("6602","","年","月","借");加:营业外收入2,495,103.232,495,103.230B10=FS("6603","","年","月","借");减:营业外支出000B11=FS("6701","","年","月","借");其中:非流动资产处置损失B12=FS("6101","","年","月","贷");三、利润总额(亏损总额以"-"号填列)3,210,641.133,210,641.130B13=FS("6111","","年","月","贷");减:所得税费用000B15=B5-B6-B7-B8-B9-B10-B11+B12+B13;四、净利润(净亏损以"-"号填列)3,210,641.133,210,641.130B16=FS("6301","","年","月","贷");五、每股收益:B17=FS("6711","","年","月","借");(一)基本每股收益B19=B15+B16-B17;(二)稀释每股收益B20=FS("6801","","年","月","借");单位负责人:会计主管:制表人:B21=B19-B20;C5=LFS("6001","","年","月","贷")+LFS("6051","","年","月","贷");C6=LFS("6401","","年","月","借")+LFS("6402","","年","月","借");C7=LFS("6403","","年","月","借");C8=LFS("6601","","年","月","借");C9=LFS("6602","","年","月","借");C10=LFS("6603","","年","月","借");C11=LFS("6701","","年","月","借");C12=LFS("6101","","年","月","贷");C13=LFS("6111","","年","月","贷");C15=C5-C6-C7-C8-C9-C10-C11+C12+C13;C16=LFS("6301","","年","月","贷");C17=LFS("6711","","年","月","借");C19=C15+C16-C17;C20=LFS("6801","","年","月","借");C21=C19-C20;D5=LFS("6001","","年-1","月","贷")+LFS("6051","","年-1","月","贷");D6=LFS("6401","","年-1","月","借")+LFS("6402","","年-1","月","借");D7=LFS("6403","","年-1","月","借");D8=LFS("6601","","年-1","月","借");D9=LFS("6602","","年-1","月","借");D10=LFS("6603","","年-1","月","借");D11=LFS("6701","","年-1","月","借");D12=LFS("6101","","年-1","月","贷");D13=LFS("6111","","年-1","月","贷");D15=D5-D6-D7-D8-D9-D10-D11+D12+D13;D16=LFS("6301","","年-1","月","贷");D17=LFS("6711","","年-1","月","借");D19=d15+d16-d17;D20=LFS("6801","","年-1","月","借");D21=d19-d20;