利润表本年利润公式

项 目本期金额

一、营业收入 =ACCT("6001","SY","",0,0,0,"") 减：营业成本 =ACCT("6401","SY","",0,0,0,"") 营业税金及附加 =ACCT("6403","SY","",0,0,0,"") 销售费用=ACCT("6601","SY","",0,0,0,"") 管理费用=ACCT("6602","SY","",0,0,0,"") 财务费用=ACCT("6603","SY","",0,0,0,"") 资产减值损失=ACCT("6701","SY","",0,0,0,"")

=ACCT("6101","SY","",0,0,0,"") 加：公允价值变动收益（损失以“

=ACCT("6111","SY","",0,0,0,"") 投资收益（损失以“－”号填

其中：对联营企业和合营企业的投资收益

二、营业利润（亏损以“－”号填列） =B2-SUM(B3:B8)+B9+B10

加：营业外收入=ACCT("6301","SY","",0,0,0,"") 减：营业外支出 =ACCT("6711","SY","",0,0,0,"") 其中：非流动资产处置损失

=B12+B13-B14

三、利润总额（亏损总额以“－”号填列）

减：所得税费用 =ACCT("6801","SY","",0,0,0,"")

四、净利润（净亏损以“－”号填列） =B16-B17

五、每股收益：

（一）基本每股收益

（二）稀释每股收益

上期金额

=ACCT("6001","SY","",0,-1,-1,"")+ACCT("6051","SY","",0,-=ACCT("6001","SL","",0,0,0

=ACCT("6401","SY","",0,-1,-1,"")+ACCT("6402","SY","",0,-=ACCT("6401","SL","",0,0,0

=ACCT("6403","SY","",0,-1,-1,"")

=ACCT("6403","SL","",0,0,0

=ACCT("6601","SY","",0,-1,-1,"")

=ACCT("6601","SL","",0,0,0

=ACCT("6602","SY","",0,-1,-1,"")

=ACCT("6602","SL","",0,0,0

=ACCT("6603","SL","",0,0,0

=ACCT("6603","SY","",0,-1,-1,"")

=ACCT("6701","SY","",0,-1,-1,"")

=ACCT("6701","SL","",0,0,0

=ACCT("6101","SL","",0,0,0

=ACCT("6101","SY","",0,-1,-1,"")

=ACCT("6111","SY","",0,-1,-1,"")

=ACCT("6111","SL","",0,0,0

=C2-SUM(C3:C8)+C9+C10=D2-SUM(D3:D8)+D9+D10

=ACCT("6301","SY","",0,-1,-1,"")

=ACCT("6301","SL","",0,0,0

=ACCT("6711","SY","",0,-1,-1,"")

=ACCT("6711","SL","",0,0,0

=C12+C13-C14=D12+D13-D14

=ACCT("6801","SL","",0,0,0

=ACCT("6801","SY","",0,-1,-1,"")

=C16-C17=D16-D17

",0,-1,-1,"") ,"SY","",0,-1,-1,"")