九乡新闻网苹果7官方价:速达软件现金流量表中的附表公式
来源：百度文库 编辑：九乡新闻网 时间：2024/07/07 12:06:23
不知什么原因，速达财务软件的现金流量表附表并没有预置公式，这是本人摸索得到的公式：
1.净利润 =("ZWA,3131,期末余额,0,0")
2.计提的资产减值准备
=(ASC("ZWA,1102,本年贷方累计,0,0")-ASC("ZWA,1102,本年借方累计,0,0"))+(ASC("ZWA,1141,本年贷方累计,0,0")-ASC("ZWA,1141,本年借方累计,0,0"))+(ASC("ZWA,1281,本年贷方累计,0,0")-ASC("ZWA,1281,本年借方累计,0,0"))+(ASC("ZWA,1421,本年贷方累计,0,0")-ASC("ZWA,1421,本年借方累计,0,0"))+(ASC("ZWA,1505,本年贷方累计,0,0")-ASC("ZWA,1505,本年借方累计,0,0"))+ASC("ZWA,1605,本年贷方累计,0,0")-ASC("ZWA,1605,本年借方累计,0,0")+(ASC("ZWA,1805,本年贷方累计,0,0")-ASC("ZWA,1805,本年借方累计,0,0"))
3.固定资产折旧 =("ZWA,1502,本年贷方累计,0,0")
4.无形资产摊销 =("ZWA,1801,本年贷方累计,0,0")
5.长期待摊费用的摊销 =("ZWA,1901,本年贷方累计,0,0")
6.待摊费用减少(减：增加) =ASC("ZWA,1301,本年贷方累计,0,0")-ASC("ZWA,1301,本年借方累计,0,0")
7.预提费用增加（减：减少） =ASC("ZWA,2191,本年贷方累计,0,0")-ASC("ZWA,2191,本年借方累计,0,0")
8.处置固定资产、无形资产和其他长期资产损失（减：收益）
9.固定资产报废损失
10.财务费用
11.投资损失（减：收益）=ASC("SY,5201,本年借方累计")-ASC("SY,5201,本年贷方累计")
12.递延税款贷项（减：借项）
13.存货的减少（减：增加） =ASC("ZWA,1243,期末余额,0,0")-ASC("ZWA,1243,年初余额,0,0")
14.经营性应收项目的减少（减：增加） =(ASC("ZWA,1111,期末余额,0,0")-ASC("ZWA,1111,年初余额,0,0"))+(ASC("ZWA,1121,期末余额,0,0")-ASC("ZWA,1121,年初余额,0,0"))+(ASC("ZWA,1122,期末余额,0,0")-ASC("ZWA,1122,年初余额,0,0"))+(ASC("ZWA,1131,期末余额,0,0")-ASC("ZWA,1131,年初余额,0,0"))+(ASC("ZWA,1133,期末余额,0,0")-ASC("ZWA,1133,年初余额,0,0"))+(ASC("ZWA,1151,期末余额,0,0")-ASC("ZWA,1151,年初余额,0,0"))+(ASC("ZWA,1161,期末余额,0,0")-ASC("ZWA,1161,年初余额,0,0"))
15.经营性应付项目的增加（减:减少） =(ASC("ZWB,2101,2181,期末余额,0,0")-ASC("ZWB,2101,2181,年初余额,0,0"))-ASC("ZWA,2191,本年借方累计,0,0")+(ASC("ZWB,2211,2331,期末余额,0,0")-ASC("ZWB,2211,2331,年初余额,0,0"))
16.其他
17.经营活动产生现金流量净额 =SUM(C43,C57)