首页
学习
活动
专区
圈层
工具
发布
共 23 篇文章
1
用 pdfplumber 从 PDF 提取表格数据(附完整代码)
2
用 pandas 自动生成银行余额调节表(附完整代码)
3
用 pandas 做多维度数据透视分析(pivot_table 实战,附完整代码)
4
用 pandas 自动检测银行流水中的异常交易(附完整代码)
5
用 pandas 自动算科目余额的同比与环比变动(附完整代码)
6
用 Python 自动测算固定资产折旧(直线法实战,附完整代码)
7
用 pandas 快速筛查异常会计分录(附完整代码)
8
Python 偿债能力综合预警:负债率 + 流动比率 + 利息保障
9
Python 审计自动化工具箱 102 篇速查总目录(收官)
10
Python 审计报告附注自动生成(从审定数一键出注释)
11
Python 现金流断裂预警:自由现金流与短债覆盖
12
Python 审计底稿自动排版(页眉页脚页码冻结一键设)
13
Python 多 Excel 工作簿批量合并与汇总
14
Python 财务异常检测:统计离群点自动筛查
15
Python 毛利率同业对标分析(行业基准导入与偏离预警)
16
Python 截止性测试自动化(收入费用跨期抽凭)
17
Python 内控缺陷识别矩阵(控制活动评价指标化)
18
Python 银行流水聚类识别潜在关联方
19
Python 实体经营风险预警:营收与经营现金流背离
20
Python 审计项目工时与排期优化(负荷与甘特)
21
Python 审计风险预警 Dashboard:从底稿数据自动出风险热力表
22
Python 审计调整分录异常预警(频繁调整=盈余管理信号)
23
Python 关键审计事项(KAM)自动提取与预警

Python 实体经营风险预警:营收与经营现金流背离

{"type":"doc","content":[{"type":"paragraph","attrs":{"id":"6d2e697a-88eb-405c-a4c3-07d880f6e8bf","textAlign":"inherit","indent":0,"color":null,"background":null,"isHoverDragHandle":false},"content":[{"type":"text","text":"问题"},{"type":"hardBreak","attrs":{"id":"af430ee3-68b9-42b4-b666-6c4b7453c96b"}},{"type":"text","text":"从审计跨进实体经营,第一个要看的就是\"增收不增现\"。营收涨了、经营现金流却没跟上甚至往下掉,要么是放宽信用虚增收入,要么是货压在应收上没回款。用 Python 算两者的增速差,背离过大就预警。"}]},{"type":"paragraph","attrs":{"id":"e4d02aa2-d875-45a7-8b0b-d979e9dd063e","textAlign":"inherit","indent":0,"color":null,"background":null,"isHoverDragHandle":false},"content":[{"type":"text","text":"示例代码"}]},{"type":"paragraph","attrs":{"id":"09a525ae-6736-4759-8201-a75250e92a0d","textAlign":"inherit","indent":0,"color":null,"background":null,"isHoverDragHandle":false},"content":[{"type":"text","marks":[{"type":"textStyle","attrs":{"color":"","background":""}}],"text":"plaintext"}]},{"type":"codeBlock","attrs":{"id":"e549e514-a11e-4551-96b3-39e9a696c062","language":"javascript","theme":"atom-one-dark","runtimes":0,"isHoverDragHandle":false,"key":"","languageByAi":"javascript"},"content":[{"type":"text","text":"def revenue_cashflow_gap(rev_prev, rev_cur, cfo_prev, cfo_cur, gap_thr=0.3):\n rev_g = (rev_cur - rev_prev) / rev_prev\n cfo_g = (cfo_cur - cfo_prev) / cfo_prev\n gap = rev_g - cfo_g\n return {\"rev_growth\": round(rev_g, 3), \"cfo_growth\": round(cfo_g, 3),\n \"gap\": round(gap, 3), \"alert\": gap >= gap_thr}\n\nprint(revenue_cashflow_gap(1000, 1300, 200, 150))\n"}]},{"type":"paragraph","attrs":{"id":"522535ef-9cd3-4030-8b4e-122694e9aa75","textAlign":"inherit","indent":0,"color":null,"background":null,"isHoverDragHandle":false},"content":[{"type":"text","text":"关键点"}]},{"type":"bulletList","attrs":{"id":"b46c718e-eb00-4226-a2dd-2c07f91fad6d","isHoverDragHandle":false},"content":[{"type":"listItem","attrs":{"id":"c6e579dd-84bc-4c94-b483-e19fdc1c5535"},"content":[{"type":"paragraph","attrs":{"id":"3379ae78-58fa-469f-a909-09f9cdbc5039","textAlign":"inherit","indent":0,"color":null,"background":null,"isHoverDragHandle":false},"content":[{"type":"text","text":"背离度 = 营收增速 - 经营现金流增速,大于 0.3(30 个百分点)就要警惕。"}]}]},{"type":"listItem","attrs":{"id":"6758b334-88a9-4ebe-8ae4-596ca3c7110f"},"content":[{"type":"paragraph","attrs":{"id":"2cba2034-8422-4377-8c98-dfb868c7e808","textAlign":"inherit","indent":0,"color":null,"background":null,"isHoverDragHandle":false},"content":[{"type":"text","text":"单年背离可能是季节性,连续两年背离才是硬信号,实战要拉 3 年趋势。"}]}]},{"type":"listItem","attrs":{"id":"36b924c9-9863-466f-947e-bdef584f3988"},"content":[{"type":"paragraph","attrs":{"id":"d61e9679-e6c8-4fd9-a257-b44936f7d1d4","textAlign":"inherit","indent":0,"color":null,"background":null,"isHoverDragHandle":false},"content":[{"type":"text","text":"结合应收增速一起看:营收涨、应收涨得更快,基本坐实\"放宽信用冲收入\"。"}]}]}]},{"type":"paragraph","attrs":{"id":"ba705617-ad6c-4c14-9ef3-26a2ffe74d3d","textAlign":"inherit","indent":0,"color":null,"background":null,"isHoverDragHandle":false},"content":[{"type":"text","text":"小结"},{"type":"hardBreak","attrs":{"id":"649ed646-56b5-4f69-8b29-53239d0c54be"}},{"type":"text","text":"营收现金流背离是实体经营恶化的早期体温计,从审计的\"账面数\"延伸到\"真实现金\",是风险预警下沉实体的第一步。"}]},{"type":"horizontalRule","attrs":{"id":"ebe49f48-c16a-4323-92b3-ee70edbcd1d5","isHoverDragHandle":false}},{"type":"paragraph","attrs":{"id":"41318c87-3021-4c1f-9cf1-b20f7704a20d","textAlign":"inherit","indent":0,"color":null,"background":null,"isHoverDragHandle":false},"content":[{"type":"text","text":"你见过\"营收翻倍、现金流腰斩\"最夸张的是哪个行业?评论区聊。"}]},{"type":"paragraph","attrs":{"id":"e1a8578a-2f94-49c0-a268-7f5fa9f082ac","textAlign":"inherit","indent":0,"color":null,"background":null,"isHoverDragHandle":false},"content":[{"type":"text","text":"如果有用,点赞收藏关注,留下审计难题。下期预告:现金流断裂预警(自由现金流与短债覆盖)。"}]},{"type":"paragraph","attrs":{"id":"4181664e-05c1-4888-8b6f-fd3a02ddc75b","textAlign":"inherit","indent":0,"color":null,"background":null,"isHoverDragHandle":false},"content":[{"type":"text","text":"会计师事务所的一名注册会计师"}]}]}

下一篇
举报
领券