快速编制现金流量表中不理解的公式

星火燎原

<p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt;"><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">我在网上下了一个快速编制现金流量表</span></p><table cellspacing="0" cellpadding="0" width="332" border="0" style="WIDTH: 249pt; BORDER-COLLAPSE: collapse; mso-padding-alt: 0cm 0cm 0cm 0cm;"><tbody><tr style="HEIGHT: 13.5pt;"><td valign="bottom" nowrap="true" width="332" style="BORDER-RIGHT: windowtext 0.5pt solid; PADDING-RIGHT: 0cm; BORDER-TOP: windowtext 0.5pt solid; PADDING-LEFT: 0cm; BACKGROUND: #ccccff; PADDING-BOTTOM: 0cm; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 249pt; PADDING-TOP: 0cm; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 13.5pt;"><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt;"><span lang="EN-US" style="FONT-SIZE: 9pt; FONT-FAMILY: Arial;"><span style="mso-spacerun: yes;">&nbsp;&nbsp;&nbsp; </span></span><span style="FONT-SIZE: 9pt; FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'; mso-bidi-font-family: Arial;">支付的其他与经营活动有关的现金</span><span lang="EN-US" style="FONT-SIZE: 9pt; FONT-FAMILY: Arial;"><p></p></span></p></td></tr></tbody></table><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt;"><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">这栏的公式如下</span><span lang="EN-US"><font face="Times New Roman">:</font></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt;"><span lang="EN-US"><font face="Times New Roman">=IF(((</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">资产负债表</span><span lang="EN-US"><font face="Times New Roman">!D12-</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">资产负债表</span><span lang="EN-US"><font face="Times New Roman">!C12)+</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">利润及利润分配表</span><span lang="EN-US"><font face="Times New Roman">!D17+</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">利润及利润分配表</span><span lang="EN-US"><font face="Times New Roman">!D11+</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">利润及利润分配表</span><span lang="EN-US"><font face="Times New Roman">!D10-</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">现金流量表</span><span lang="EN-US"><font face="Times New Roman">!C11+(C33-</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">利润及利润分配表</span><span lang="EN-US"><font face="Times New Roman">!D12)-(</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">资产负债表</span><span lang="EN-US"><font face="Times New Roman">!D27-</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">资产负债表</span><span lang="EN-US"><font face="Times New Roman">!C27)-(</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">资产负债表</span><span lang="EN-US"><font face="Times New Roman">!D11+</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">资产负债表</span><span lang="EN-US"><font face="Times New Roman">!D12)*0.005/0.995-</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">表外数据录入</span><span lang="EN-US"><font face="Times New Roman">!C28)&lt;0,ABS(((</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">资产负债表</span><span lang="EN-US"><font face="Times New Roman">!D12-</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">资产负债表</span><span lang="EN-US"><font face="Times New Roman">!C12)+</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">利润及利润分配表</span><span lang="EN-US"><font face="Times New Roman">!D17+</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">利润及利润分配表</span><span lang="EN-US"><font face="Times New Roman">!D11+</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">利润及利润分配表</span><span lang="EN-US"><font face="Times New Roman">!D10-</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">现金流量表</span><span lang="EN-US"><font face="Times New Roman">!C11+(C33-</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">利润及利润分配表</span><span lang="EN-US"><font face="Times New Roman">!D12)-(</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">资产负债表</span><span lang="EN-US"><font face="Times New Roman">!D27-</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">资产负债表</span><span lang="EN-US"><font face="Times New Roman">!C27)-(</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">资产负债表</span><span lang="EN-US"><font face="Times New Roman">!D11+</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">资产负债表</span><span lang="EN-US"><font face="Times New Roman">!D12)*0.005/0.995-</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">表外数据录入</span><span lang="EN-US"><font face="Times New Roman">!C28)*0.8)," ")</font></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt;"><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">我下面把单元格名写成报表项名</span><span lang="EN-US"><font face="Times New Roman">:</font></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt;"><span lang="EN-US"><font face="Times New Roman">=IF(((</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">其他应收款期末</span><span lang="EN-US"><font face="Times New Roman">-</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">期初</span><span lang="EN-US"><font face="Times New Roman">)+(</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">营业外支出累计</span><span lang="EN-US"><font face="Times New Roman">+</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">管理费用累计</span><span lang="EN-US"><font face="Times New Roman">+</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">营业费用累计</span><span lang="EN-US"><font face="Times New Roman">-</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">现金流量表中支付给职工的</span><span lang="EN-US"><font face="Times New Roman">+(</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">分配股利利润利息支付的</span><span lang="EN-US"><font face="Times New Roman">-</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">财务费用累计</span><span lang="EN-US"><font face="Times New Roman">)-(</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">累计折旧期末</span><span lang="EN-US"><font face="Times New Roman">-</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">期初</span><span lang="EN-US"><font face="Times New Roman">)-(</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">应收帐款期末</span><span lang="EN-US"><font face="Times New Roman">+</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">其他应收款期末</span><span lang="EN-US"><font face="Times New Roman">) *0.005/0.995-</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">表外数据管理费用中税金</span><span lang="EN-US"><font face="Times New Roman">)&lt;0,ABS(((</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">其他应收款期末</span><span lang="EN-US"><font face="Times New Roman">-</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">期初</span><span lang="EN-US"><font face="Times New Roman">)+(</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">营业外支出累计</span><span lang="EN-US"><font face="Times New Roman">+</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">管理费用累计</span><span lang="EN-US"><font face="Times New Roman">+</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">营业费用累计</span><span lang="EN-US"><font face="Times New Roman">-</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">现金流量表中支付给职工的</span><span lang="EN-US"><font face="Times New Roman">+(</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">分配股利利润利息支付的</span><span lang="EN-US"><font face="Times New Roman">-</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">财务费用累计</span><span lang="EN-US"><font face="Times New Roman">)-(</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">累计折旧期末</span><span lang="EN-US"><font face="Times New Roman">-</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">期初</span><span lang="EN-US"><font face="Times New Roman">)-(</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">应收帐款期末</span><span lang="EN-US"><font face="Times New Roman">+</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">其他应收款期末</span><span lang="EN-US"><font face="Times New Roman">) *0.005/0.995-</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">表外数据管理费用中税金</span><span lang="EN-US"><font face="Times New Roman">) *0.8)," ")</font></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt;"><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">公式最后的</span><span lang="EN-US"><font face="Times New Roman">*0.8),</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">怎么已理解不了</span><span lang="EN-US"><font face="Times New Roman">,</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">望高手帮帮忙</span><span lang="EN-US"><font face="Times New Roman">,</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">解释解释</span><span lang="EN-US"><font face="Times New Roman">!</font></span></p>

星火燎原

<p> rEb15Y48.rar (21.25 KB, 下载次数: 34)

2008-6-26 23:44 上传

点击文件名下载附件
快速编制现金流量表中不理解的公式 <br/></p><p>我把现金流量表传了上来，高手帮忙看看，解释解释</p><p>提问的公式中，我把利润表的本年改在了D列，原C列记录本月数，我上转的是原下载表，没改动过。</p>

似水年华往事

资产负债表，利润表。现金流量表之间允许有20%的误差