利润表本年利润公式.xls

项目本期金额一、营业收入=ACCT("6001","SY","",0,0,0,"")+ACCT("6051","SY","",0,0,0,"")=ACCT("6001","SL","",0,0,0,"")+ACCT("6051","SL","",0,0,0,"")减:营业成本=ACCT("6401","SY","",0,0,0,"")+ACCT("6402","SY","",0,0,0,"")=ACCT("6401","SL","",0,0,0,"")+ACCT("6402","SL","",0,0,0,"")营业税金及附加=ACCT("6403","SY","",0,0,0,"")=ACCT("6403","SL","",0,0,0,"")销售费用=ACCT("6601","SY","",0,0,0,"")=ACCT("6601","SL","",0,0,0,"")管理费用=ACCT("6602","SY","",0,0,0,"")=ACCT("6602","SL","",0,0,0,"")财务费用=ACCT("6603","SY","",0,0,0,"")=ACCT("6603","SL","",0,0,0,"")资产减值损失=ACCT("6701","SY","",0,0,0,"")=ACCT("6701","SL","",0,0,0,"")加:公允价值变动收益(损失以“-”号填列)=ACCT("6101","SY","",0,0,0,"")=ACCT("6101","SL","",0,0,0,"")投资收益(损失以“-”号填列)=ACCT("6111","SY","",0,0,0,"")=ACCT("6111","SL","",0,0,0,"")其中:对联营企业和合营企业的投资收益二、营业利润(亏损以“-”号填列)=B2-SUM(B3:B8)+B9+B10=C2-SUM(C3:C8)+C9+C10加:营业外收入=ACCT("6301","SY","",0,0,0,"")=ACCT("6301","SL","",0,0,0,"")减:营业外支出=ACCT("6711","SY","",0,0,0,"")=ACCT("6711","SL","",0,0,0,"")其中:非流动资产处置损失三、利润总额(亏损总额以“-”号填列)=B12+B13-B14=C12+C13-C14减:所得税费用=ACCT("6801","SY","",0,0,0,"")=ACCT("6801","SL","",0,0,0,"")四、净利润(净亏损以“-”号填列)=B16-B17=C16-C17五、每股收益:(一)基本每股收益(二)稀释每股收益上期金额=A