资产负债表公式设置
合集下载
相关主题
- 1、下载文档前请自行甄别文档内容的完整性，平台不提供额外的编辑、内容补充、找答案等附加服务。
- 2、"仅部分预览"的文档,不可在线预览部分如存在完整性等问题,可反馈申请退款(可完整预览的文档不适用该条件!)。
- 3、如文档侵犯您的权益，请联系客服反馈,我们会尽快为您处理(人工客服工作时间：9:00-18:30)。
利润表
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 一、营业收入 减：营业成本 营业税金及附加 销售费用 管理费用 财务费用 资产减值损失 项目 本期金额
=ACCT("6001","SY","",0,0,0,"")+ACCT("6051","SY","",0,0,0,"") =ACCT("6401","SY","",0,0,0,"")+ACCT("6402","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,"")
=C2-SUM(C3:C8)+C9+C10 =ACCT("6301","SL","",0,0,0,"") =ACCT("6711","SL","",0,0,0,"")
=C12+C13-C14 =ACCT("6801","SL","",0,0,0,"") =C16-C17
加：公允价值变动收益（损失以“-”号填列） =ACCT("6101","SY","",0,0,0,"") 投资收益（损失以“-”号填列） 其中：对联营企业和合营企业的投资收益 二、营业利润（亏损以“-”号填列） 加：营业外收入 减：营业外支出 其中：非流动资产处置损失 三、利润总额（亏损总额以“-”号填列） 减：所得税费用 四、净利润（净亏损以“-”号填列） 五、每股收益： （一）基本每股收益 （二）稀释每股收益 =B12+B13-B14 =ACCT("6801","SY","",0,0,0,"") =B16-B17 =B2-SUM(B3:B8)+B9+B10 =ACCT("6301","SY","",0,0,0,"") =ACCT("6711","SY","",0,0,0,"") =ACCT("6111","SY","",0,0,0,"")
企会02表
Fra Baidu bibliotek利润表
金额单位:人民币元 本年累计
=ACCT("6001","SL","",0,0,0,"")+ACCT("6051","SL","",0,0,0,"") =ACCT("6401","SL","",0,0,0,"")+ACCT("6402","SL","",0,0,0,"")
=ACCT("6403","SL","",0,0,0,"") =ACCT("6601","SL","",0,0,0,"") =ACCT("6602","SL","",0,0,0,"") =ACCT("6603","SL","",0,0,0,"") =ACCT("6701","SL","",0,0,0,"") =ACCT("6101","SL","",0,0,0,"") =ACCT("6111","SL","",0,0,0,"")
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 一、营业收入 减：营业成本 营业税金及附加 销售费用 管理费用 财务费用 资产减值损失 项目 本期金额
=ACCT("6001","SY","",0,0,0,"")+ACCT("6051","SY","",0,0,0,"") =ACCT("6401","SY","",0,0,0,"")+ACCT("6402","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,"")
=C2-SUM(C3:C8)+C9+C10 =ACCT("6301","SL","",0,0,0,"") =ACCT("6711","SL","",0,0,0,"")
=C12+C13-C14 =ACCT("6801","SL","",0,0,0,"") =C16-C17
加：公允价值变动收益（损失以“-”号填列） =ACCT("6101","SY","",0,0,0,"") 投资收益（损失以“-”号填列） 其中：对联营企业和合营企业的投资收益 二、营业利润（亏损以“-”号填列） 加：营业外收入 减：营业外支出 其中：非流动资产处置损失 三、利润总额（亏损总额以“-”号填列） 减：所得税费用 四、净利润（净亏损以“-”号填列） 五、每股收益： （一）基本每股收益 （二）稀释每股收益 =B12+B13-B14 =ACCT("6801","SY","",0,0,0,"") =B16-B17 =B2-SUM(B3:B8)+B9+B10 =ACCT("6301","SY","",0,0,0,"") =ACCT("6711","SY","",0,0,0,"") =ACCT("6111","SY","",0,0,0,"")
企会02表
Fra Baidu bibliotek利润表
金额单位:人民币元 本年累计
=ACCT("6001","SL","",0,0,0,"")+ACCT("6051","SL","",0,0,0,"") =ACCT("6401","SL","",0,0,0,"")+ACCT("6402","SL","",0,0,0,"")
=ACCT("6403","SL","",0,0,0,"") =ACCT("6601","SL","",0,0,0,"") =ACCT("6602","SL","",0,0,0,"") =ACCT("6603","SL","",0,0,0,"") =ACCT("6701","SL","",0,0,0,"") =ACCT("6101","SL","",0,0,0,"") =ACCT("6111","SL","",0,0,0,"")