ARTICLE · 1379434
EXCEL小技巧:利用模拟运算进行敏感性分析
<section style="max-width: 100%;box-sizing: border-box;color: rgb(62, 62, 62);font-size: 16px;white-space: normal;background-color: rgb(255, 255, 255);word-wrap: break-word !important;"><section powered-by="xiumi.us" style="max-width: 100%;box-sizing: border-box;word-wrap: break-word !important;"><section style="max-width: 100%;box-sizing: border-box;word-wrap: break-word !important;"><section style="padding-right: 10px;padding-left: 10px;max-width: 100%;box-sizing: border-box;line-height: 1.6;word-wrap: break-word !important;"><section style="max-width: 100%;box-sizing: border-box;word-wrap: break-word !important;"><section powered-by="xiumi.us" style="max-width: 100%;box-sizing: border-box;word-wrap: break-word !important;"><section style="max-width: 100%;box-sizing: border-box;word-wrap: break-word !important;"><section style="padding-right: 30px;padding-left: 30px;max-width: 100%;box-sizing: border-box;line-height: 1.6;word-wrap: break-word !important;"><p style="max-width: 100%;box-sizing: border-box;min-height: 1em;word-wrap: break-word !important;"><strong style="max-width: 100%;box-sizing: border-box !important;word-wrap: break-word !important;"><span style="max-width: 100%;color: rgb(136, 136, 136);font-size: 20px;box-sizing: border-box !important;word-wrap: break-word !important;">“</span></strong><span style="max-width: 100%;color: rgb(136, 136, 136);box-sizing: border-box !important;word-wrap: break-word !important;"> 在之前的文章中,有提到过敏感性分析的概念(</span><a target="_blank" href="http://mp.weixin.qq.com/s?__biz=MzkxODE5OTg3Mw==&mid=2247483701&idx=1&sn=80086c5f75fe0bda1f98fce57a3c56a2&chksm=c1b44a1bf6c3c30ddab5349bc3f10a527b50092aac1d6cbe2db69fd725f8398e5ccf704f32c1&scene=21#wechat_redirect" data-itemshowtype="0" tab="innerlink" style="text-decoration: underline;max-width: 100%;color: rgb(120, 172, 254);box-sizing: border-box !important;overflow-wrap: break-word !important;" data-linktype="2"><span style="max-width: 100%;color: rgb(120, 172, 254);box-sizing: border-box !important;overflow-wrap: break-word !important;">在历史的基础上预测未来——财务分析报告的内容</span></a><span style="max-width: 100%;color: rgb(136, 136, 136);box-sizing: border-box !important;word-wrap: break-word !important;">),敏感性分析可以展示在不同的假设条件下得到的结果,本文会告诉大家怎样利用EXCEL的模拟运算来快捷的进行敏感性分析。<strong style="max-width: 100%;box-sizing: border-box !important;word-wrap: break-word !important;"><span style="max-width: 100%;font-size: 20px;box-sizing: border-box !important;word-wrap: break-word !important;">”</span></strong></span><br style="max-width: 100%;box-sizing: border-box !important;word-wrap: break-word !important;" /></p></section></section></section></section><section style="max-width: 100%;box-sizing: border-box;word-wrap: break-word !important;"><section powered-by="xiumi.us" style="max-width: 100%;box-sizing: border-box;word-wrap: break-word !important;"><section style="max-width: 100%;box-sizing: border-box;word-wrap: break-word !important;"><section style="padding-right: 22px;padding-left: 22px;max-width: 100%;box-sizing: border-box;line-height: 1.6;word-wrap: break-word !important;"><p style="max-width: 100%;box-sizing: border-box;min-height: 1em;word-wrap: break-word !important;"><br style="max-width: 100%;box-sizing: border-box !important;word-wrap: break-word !important;" /></p><p style="max-width: 100%;box-sizing: border-box;min-height: 1em;word-wrap: break-word !important;"><br style="max-width: 100%;box-sizing: border-box !important;word-wrap: break-word !important;" /></p></section></section></section></section><section style="max-width: 100%;box-sizing: border-box;min-height: 1em;text-indent: 2em;overflow-wrap: break-word !important;">敏感性分析法是指从众多不确定因素中找出对投资项目经济效益指标有重要影响的敏感性因素,并分析、测算其对项目经济效益指标的影响程度和敏感性程度,进而判断项目承受风险能力的一种不确定性分析方法。<br /></section><section style="max-width: 100%;box-sizing: border-box;min-height: 1em;text-indent: 2em;overflow-wrap: break-word !important;">在实际运用中,这种方法的运用范围比较广泛,当存在<strong>两种不确定</strong>的假设条件的情况下,均可以采用下面的技巧来测算相应的结果。<br /></section><p style="max-width: 100%;box-sizing: border-box;min-height: 1em;word-wrap: break-word !important;"><br /></p><p style="text-align: center;"><img class="rich_pages js_insertlocalimg" data-ratio="0.66640625" data-s="300,640" data-src="https://mmbiz.qpic.cn/mmbiz_jpg/ria05yicJ7wDszybfb97szQFIGZZbzQjGZoWOhEibNUib6iaXGHrX8YKfWsbQbSuZCuZqPHicxAbXHJxYJDPF3BxA5Bw/640?wx_fmt=jpeg" data-type="jpeg" data-w="1280" style="" /></p><p style="max-width: 100%;box-sizing: border-box;min-height: 1em;word-wrap: break-word !important;"><br /></p></section></section></section></section><p><br /></p><section style="max-width: 100%;box-sizing: border-box;color: rgb(62, 62, 62);font-size: 16px;white-space: normal;background-color: rgb(255, 255, 255);word-wrap: break-word !important;"><section powered-by="xiumi.us" style="max-width: 100%;box-sizing: border-box;word-wrap: break-word !important;"><section style="max-width: 100%;box-sizing: border-box;word-wrap: break-word !important;"><section style="padding-right: 20px;padding-left: 20px;max-width: 100%;box-sizing: border-box;line-height: 0.8;word-wrap: break-word !important;"><p style="max-width: 100%;box-sizing: border-box;min-height: 1em;text-align: center;word-wrap: break-word !important;"><span style="max-width: 100%;box-sizing: border-box;color: rgb(26, 173, 25);font-size: 24px;word-wrap: break-word !important;">01</span></p><p style="max-width: 100%;box-sizing: border-box;min-height: 1em;text-align: center;word-wrap: break-word !important;"><span style="max-width: 100%;box-sizing: border-box;letter-spacing: 0px;color: rgb(26, 173, 25);font-size: 20px;word-wrap: break-word !important;">—</span></p></section></section></section></section><p style="max-width: 100%;min-height: 1em;color: rgb(62, 62, 62);font-size: 16px;white-space: normal;background-color: rgb(255, 255, 255);text-align: center;box-sizing: border-box !important;word-wrap: break-word !important;"><strong><span style="max-width: 100%;font-size: 20px;box-sizing: border-box !important;word-wrap: break-word !important;"><span style="max-width: 100%;box-sizing: border-box !important;word-wrap: break-word !important;">准备工作</span></span></strong><span style="max-width: 100%;font-size: 20px;box-sizing: border-box !important;word-wrap: break-word !important;"><span style="max-width: 100%;box-sizing: border-box !important;word-wrap: break-word !important;"></span></span></p><p><br /></p><section style="max-width: 100%;box-sizing: border-box;color: rgb(62, 62, 62);font-size: 16px;white-space: normal;background-color: rgb(255, 255, 255);word-wrap: break-word !important;"><section powered-by="xiumi.us" style="max-width: 100%;box-sizing: border-box;word-wrap: break-word !important;"><section style="max-width: 100%;box-sizing: border-box;word-wrap: break-word !important;"><section style="padding-right: 10px;padding-left: 10px;max-width: 100%;box-sizing: border-box;line-height: 1.6;word-wrap: break-word !important;"><section style="max-width: 100%;box-sizing: border-box;min-height: 1em;text-indent: 2em;overflow-wrap: break-word !important;">首先,需要点开EXCEL-文件-选项</section><p style="text-align: center;"><img class="rich_pages" data-ratio="0.5398645127670662" data-s="300,640" data-src="https://mmbiz.qpic.cn/mmbiz_png/ria05yicJ7wDszybfb97szQFIGZZbzQjGZzyGQGvO8w8PbnJTEXqKBIT6sLI0D1yfic3icJ8MOnH6t3jC1z4dTic6ag/640?wx_fmt=png" data-type="png" data-w="1919" style="" /></p><p style="text-align: center;"><br /></p><section style="text-align: left;text-indent: 2em;">点开后,选择公式标签,在“启用迭代计算”前面的方框内打勾<br /></section><p style="text-align: center;"><img class="rich_pages" data-ratio="0.8058823529411765" data-s="300,640" data-src="https://mmbiz.qpic.cn/mmbiz_png/ria05yicJ7wDszybfb97szQFIGZZbzQjGZRFO5o0fyxNGCc5a10eY1eUbGSC6LdcTlDsicnoQvWskqztygt7icHwMQ/640?wx_fmt=png" data-type="png" data-w="850" style="" /></p><p style="max-width: 100%;box-sizing: border-box;min-height: 1em;word-wrap: break-word !important;"><br style="max-width: 100%;box-sizing: border-box !important;word-wrap: break-word !important;" /></p><p style="max-width: 100%;box-sizing: border-box;min-height: 1em;word-wrap: break-word !important;"><span style="max-width: 100%;text-align: center;box-sizing: border-box !important;word-wrap: break-word !important;"></span></p><section style="max-width: 100%;box-sizing: border-box;word-wrap: break-word !important;"><section powered-by="xiumi.us" style="max-width: 100%;box-sizing: border-box;word-wrap: break-word !important;"><section style="max-width: 100%;box-sizing: border-box;word-wrap: break-word !important;"><section style="padding-right: 20px;padding-left: 20px;max-width: 100%;box-sizing: border-box;line-height: 0.8;word-wrap: break-word !important;"><p style="max-width: 100%;box-sizing: border-box;min-height: 1em;text-align: center;word-wrap: break-word !important;"><span style="max-width: 100%;box-sizing: border-box;color: rgb(26, 173, 25);font-size: 24px;word-wrap: break-word !important;">02</span></p><p style="max-width: 100%;box-sizing: border-box;min-height: 1em;text-align: center;word-wrap: break-word !important;"><span style="max-width: 100%;box-sizing: border-box;letter-spacing: 0px;color: rgb(26, 173, 25);font-size: 20px;word-wrap: break-word !important;">—</span><br style="max-width: 100%;box-sizing: border-box;word-wrap: break-word !important;" /></p></section></section></section></section><p style="max-width: 100%;box-sizing: border-box;min-height: 1em;text-align: center;word-wrap: break-word !important;"><strong><span style="max-width: 100%;font-size: 20px;box-sizing: border-box !important;word-wrap: break-word !important;">模拟运算的使用</span></strong><span style="max-width: 100%;font-size: 20px;box-sizing: border-box !important;word-wrap: break-word !important;"><br /></span></p><p style="max-width: 100%;box-sizing: border-box;min-height: 1em;word-wrap: break-word !important;"><br style="max-width: 100%;box-sizing: border-box !important;word-wrap: break-word !important;" /></p><section style="max-width: 100%;box-sizing: border-box;min-height: 1em;text-indent: 2em;overflow-wrap: break-word !important;">下面我们之前文章里面的表格来举例</section><p style="text-align: center;"><img class="rich_pages" data-ratio="0.3805601317957166" data-s="300,640" data-src="https://mmbiz.qpic.cn/mmbiz_png/ria05yicJ7wDszybfb97szQFIGZZbzQjGZJ22dID1PPJiangicBxnrp1YKevkOpMBql03bCuwrkgVBFjCZleTic1gFg/640?wx_fmt=png" data-type="png" data-w="607" style="" /></p><section style="text-align: left;text-indent: 2em;">6月的单价和单位成本预计会发生变化,因为市场竞争加剧,单价预计会下降,价格下调区间在10%-20%,因为原材料上涨,单位成本预计上涨区间在5%-15%,在这两种变量的影响下,我们需要计算毛利率的情况。<br /></section><section style="text-align: left;text-indent: 2em;">我们可以在旁边构建敏感性分析的表格,销售单价分为四个区间,分别为5月单价、在5月基础上下降10%、在5月基础上下降15%、在5月基础上下降20%,单位成本同样分为4个区间,分别为5月单位成本、在5月基础上上涨5%、在5月基础上上涨10%,在5月基础上上涨15%。<span style="color: rgb(120, 172, 254);">请注意5月单价(O3)和5月单位成本(K4)两个单元格需键入数值,剩余单元格可以在此基础上使用公式,否则模拟运算结果可能出现问题。</span><br /></section><section style="text-align: left;text-indent: 2em;">选中K3单元格,另此单元格数值=H10,也就是6月毛利率。<br /></section><p style="text-align: center;"><img class="rich_pages" data-ratio="0.2761998041136141" data-s="300,640" data-src="https://mmbiz.qpic.cn/mmbiz_png/ria05yicJ7wDszybfb97szQFIGZZbzQjGZSUJGnKP0EAKHDhUQRdf6sXs0oNY3N9w9qSQOUdq53IgK9w3t96Hjww/640?wx_fmt=png" data-type="png" data-w="1021" style="" /></p><section style="text-align: left;text-indent: 2em;"><span style="text-indent: 2em;">接下来选中K3</span><span style="text-indent: 2em;">:</span><span style="text-indent: 2em;">O7</span><span style="text-indent: 2em;">单元格</span><span style="text-indent: 2em;">,</span><span style="text-indent: 2em;">选择“数据”表页</span><span style="text-indent: 2em;">,点击“模拟分析”的下拉箭头,选择“模拟运算表”</span><span style="text-indent: 2em;"></span><br /></section><p style="text-align: center;"><img class="rich_pages" data-ratio="0.3960573476702509" data-s="300,640" data-src="https://mmbiz.qpic.cn/mmbiz_png/ria05yicJ7wDszybfb97szQFIGZZbzQjGZohXTUOTanAInT1icogXqe1s4aDfeBHfpibGymYC4zhBIlqj8ICOkJSxg/640?wx_fmt=png" data-type="png" data-w="1116" style="" /></p><section style="text-align: left;text-indent: 2em;"><span style="text-indent: 2em;"></span>选择“模拟运算表”后会弹出相应界面,需要选中“输入引用行的单元格”和“输入引用列的单元格”,我们构建的表格中,行是销售价格,列是单位成本,所以“输入引用行的单元格”选中6月单价,也就是“H6”,<span style="color: rgb(62, 62, 62);font-size: 16px;text-align: left;text-indent: 32px;background-color: rgb(255, 255, 255);">“输入引用列的单元格</span><span style="color: rgb(62, 62, 62);font-size: 16px;text-align: left;text-indent: 32px;background-color: rgb(255, 255, 255);">”</span>选中6月单位成本,也就是“H8”,选择完毕之后点击确定,在构建的表格中就会出现在不同假设条件下的毛利率情况。</section><p style="text-align: center;"><img class="rich_pages" data-ratio="0.323956442831216" data-s="300,640" data-src="https://mmbiz.qpic.cn/mmbiz_png/ria05yicJ7wDszybfb97szQFIGZZbzQjGZIres3exfyvyVY8Of6ba6kcbRbtlsfJXWFUqeCcsGmialxyGAZxu6fBA/640?wx_fmt=png" data-type="png" data-w="1102" style="" /></p><section style="text-align: left;text-indent: 2em;">在此基础上,我们可以进一步加工,假设公司的毛利率底线是30%,那么选择L4:O7单元格,跳转“开始”页面,选择“条件格式-突出显示单元格规则-大于</section><p style="text-align: center;"><img class="rich_pages" data-ratio="0.39431616341030196" data-s="300,640" data-src="https://mmbiz.qpic.cn/mmbiz_png/ria05yicJ7wDszybfb97szQFIGZZbzQjGZW2swxKfm6jibrV7YAHEd9nHpCZmcdbuk0pX8HEyK3NdeqD1uHxk5YcA/640?wx_fmt=png" data-type="png" data-w="1126" style="" /></p><section style="text-align: left;text-indent: 2em;"><br /></section><section style="text-align: left;text-indent: 2em;">在弹出的界面中,输入值30%,点击确定,所有大于30%的情况会被标记成红色,这些情况是可以被公司接受的。<br /></section><p style="text-align: center;"><img class="rich_pages" data-ratio="0.6355140186915887" data-s="300,640" data-src="https://mmbiz.qpic.cn/mmbiz_png/ria05yicJ7wDszybfb97szQFIGZZbzQjGZW0HiabSPx9nLWlBjJ0wyAUTl6UT4PBt84VXP59p1p7iaicEqzUraOk1qQ/640?wx_fmt=png" data-type="png" data-w="535" style="" /></p><section style="text-align: left;text-indent: 2em;">以上是一个简单的例子,是两种变量情况下的结构展示,同样一种变量下也可以使用敏感性分析,下图中右边是敏感性分析的表格,变量是“退出乘数”,在不同的退出乘数情况下计算股权价值和每股价格,道理同上。<br /></section><p style="text-align: center;"><img class="rich_pages" data-ratio="0.366412213740458" data-s="300,640" data-src="https://mmbiz.qpic.cn/mmbiz_png/ria05yicJ7wDszybfb97szQFIGZZbzQjGZkvPe0CqZ8KpNMrCNO4R0qDt8A3KKneBWrFK1hp85trgmbnbZIWCqJg/640?wx_fmt=png" data-type="png" data-w="917" style="" /></p><section style="text-align: left;text-indent: 2em;"><br /></section><section style="text-align: left;text-indent: 2em;">以上就是怎样利用模拟运算进行敏感性分析,EXCEL中有许多公式和模块,可以帮助我们提高工作效率,协助进行财务分析,更好的展示分析结果,如何更好的运用EXCEL技巧,也是财务工作的重要部分。<br /></section><section style="text-align: left;text-indent: 2em;"><br /></section><section style="max-width: 100%;box-sizing: border-box;min-height: 1em;padding-right: 30px;padding-left: 30px;line-height: 1.6;color: rgb(62, 62, 62);font-size: 16px;white-space: normal;background-color: rgb(255, 255, 255);overflow-wrap: break-word !important;"><span style="max-width: 100%;color: rgb(136, 136, 136);box-sizing: border-box !important;word-wrap: break-word !important;">结束后的碎碎念:EXCEL真的是很好用的工具,而且会在不断的使用中越来越熟练。刚转做财务分析的时候,面对大量的数据很头疼,EXCEL使用的也不是很好,所以遇到情况只能百度,慢慢的在使用中熟悉了各种公式,工作效率也就提升了,后续可以自己搭建各种模板,将基础数据整合,这个过程很艰辛,但是非常有收获。</span></section><section style="max-width: 100%;box-sizing: border-box;min-height: 1em;padding-right: 30px;padding-left: 30px;line-height: 1.6;color: rgb(62, 62, 62);font-size: 16px;white-space: normal;background-color: rgb(255, 255, 255);overflow-wrap: break-word !important;"><br /></section><section style="max-width: 100%;box-sizing: border-box;min-height: 1em;padding-right: 30px;padding-left: 30px;line-height: 1.6;color: rgb(62, 62, 62);font-size: 16px;white-space: normal;background-color: rgb(255, 255, 255);overflow-wrap: break-word !important;"><span style="text-align: left;text-indent: 2em;">财务分析报告:<br /></span></section><section style="max-width: 100%;box-sizing: border-box;min-height: 1em;padding-right: 30px;padding-left: 30px;line-height: 1.6;color: rgb(62, 62, 62);font-size: 16px;white-space: normal;background-color: rgb(255, 255, 255);overflow-wrap: break-word !important;"><span style="text-align: left;text-indent: 2em;"><a target="_blank" href="http://mp.weixin.qq.com/s?__biz=MzkxODE5OTg3Mw==&mid=2247483662&idx=1&sn=22b7416f16ab5bdf2cb26c924a7a8913&chksm=c1b44a20f6c3c3362134a9cdf05112ca74a2770254171209cce5fc8b0cbe7ccbdbea35ff38ab&scene=21#wechat_redirect" data-itemshowtype="0" tab="innerlink" data-linktype="2">如何简单快速的制作一份财务分析报告—模板搭建</a><br /></span></section><section style="max-width: 100%;box-sizing: border-box;min-height: 1em;padding-right: 30px;padding-left: 30px;line-height: 1.6;color: rgb(62, 62, 62);font-size: 16px;white-space: normal;background-color: rgb(255, 255, 255);overflow-wrap: break-word !important;"><a target="_blank" href="http://mp.weixin.qq.com/s?__biz=MzkxODE5OTg3Mw==&mid=2247483675&idx=1&sn=c91b557feede1eac086e7089e0824706&chksm=c1b44a35f6c3c323f1f5a37927d27c43bc7eb857fdd665e9b4e8bf7c8720faa0d341d423146e&scene=21#wechat_redirect" data-itemshowtype="0" tab="innerlink" data-linktype="2">这样的财务分析报告看起来更舒服——图表和格式</a><br /></section><section style="max-width: 100%;box-sizing: border-box;min-height: 1em;padding-right: 30px;padding-left: 30px;line-height: 1.6;color: rgb(62, 62, 62);font-size: 16px;white-space: normal;background-color: rgb(255, 255, 255);overflow-wrap: break-word !important;"><a target="_blank" href="http://mp.weixin.qq.com/s?__biz=MzkxODE5OTg3Mw==&mid=2247483701&idx=1&sn=80086c5f75fe0bda1f98fce57a3c56a2&chksm=c1b44a1bf6c3c30ddab5349bc3f10a527b50092aac1d6cbe2db69fd725f8398e5ccf704f32c1&scene=21#wechat_redirect" data-itemshowtype="0" tab="innerlink" data-linktype="2">在历史的基础上预测未来——财务分析报告的内容</a><br /></section><section style="max-width: 100%;box-sizing: border-box;min-height: 1em;padding-right: 30px;padding-left: 30px;line-height: 1.6;color: rgb(62, 62, 62);font-size: 16px;white-space: normal;background-color: rgb(255, 255, 255);overflow-wrap: break-word !important;">财务报表:</section><section style="max-width: 100%;box-sizing: border-box;min-height: 1em;padding-right: 30px;padding-left: 30px;line-height: 1.6;color: rgb(62, 62, 62);font-size: 16px;white-space: normal;background-color: rgb(255, 255, 255);overflow-wrap: break-word !important;"><a target="_blank" href="http://mp.weixin.qq.com/s?__biz=MzkxODE5OTg3Mw==&mid=2247483683&idx=1&sn=b2caa1c8d7e2cae653b84846d548a04f&chksm=c1b44a0df6c3c31b6bffa9b1f81ad465baaa01bf7bcdb48fdf1f66dbe5675fd5f3742b5eba2e&scene=21#wechat_redirect" data-itemshowtype="0" tab="innerlink" data-linktype="2">揭开资产的面纱——关注资产质量</a></section><section style="max-width: 100%;box-sizing: border-box;min-height: 1em;padding-right: 30px;padding-left: 30px;line-height: 1.6;color: rgb(62, 62, 62);font-size: 16px;white-space: normal;background-color: rgb(255, 255, 255);overflow-wrap: break-word !important;">全面预算管理:</section><section style="max-width: 100%;box-sizing: border-box;min-height: 1em;padding-right: 30px;padding-left: 30px;line-height: 1.6;color: rgb(62, 62, 62);font-size: 16px;white-space: normal;background-color: rgb(255, 255, 255);overflow-wrap: break-word !important;"><a target="_blank" href="http://mp.weixin.qq.com/s?__biz=MzkxODE5OTg3Mw==&mid=2247483711&idx=1&sn=ec5e0fee82e1b1947cb6d43f72e84a26&chksm=c1b44a11f6c3c3077aa1c00418081320c03375d0053e39274b853e0b4cfa7bc087588b75230d&scene=21#wechat_redirect" data-itemshowtype="0" tab="innerlink" data-linktype="2">那些预算编制前需要解决的问题</a></section><section style="max-width: 100%;box-sizing: border-box;min-height: 1em;padding-right: 30px;padding-left: 30px;line-height: 1.6;color: rgb(62, 62, 62);font-size: 16px;white-space: normal;background-color: rgb(255, 255, 255);overflow-wrap: break-word !important;"><br /></section><section style="max-width: 100%;box-sizing: border-box;min-height: 1em;padding-right: 30px;padding-left: 30px;line-height: 1.6;color: rgb(62, 62, 62);font-size: 16px;white-space: normal;background-color: rgb(255, 255, 255);overflow-wrap: break-word !important;"><span style="color: rgb(62, 62, 62);font-family: -apple-system, BlinkMacSystemFont, "Helvetica Neue", "PingFang SC", "Hiragino Sans GB", "Microsoft YaHei UI", "Microsoft YaHei", Arial, sans-serif;font-size: 16px;letter-spacing: 0.544px;background-color: rgb(255, 255, 255);">后续会继续发布财务管理相关文章,如感兴趣请关注公众号</span><img data-ratio="1" data-type="png" data-w="20" data-src="https://mmbiz.qpic.cn/mmbiz_png/ria05yicJ7wDufkgxAQdYETmrH7GQZMorg5vTicDxibLGwonzksL04SJ8YpfXEWHCHzSicY1T1WvwZeSytia2cdACUBw/640?wx_fmt=png" style="color: rgb(62, 62, 62);font-family: -apple-system, BlinkMacSystemFont, "Helvetica Neue", "PingFang SC", "Hiragino Sans GB", "Microsoft YaHei UI", "Microsoft YaHei", Arial, sans-serif;font-size: 16px;letter-spacing: 0.544px;white-space: normal;background-color: rgb(255, 255, 255);display: inline-block;vertical-align: text-bottom;box-sizing: border-box !important;overflow-wrap: break-word !important;width: 20px !important;visibility: visible !important;" /><br /></section><p style="text-align: center;"><img class="rich_pages" data-ratio="1" data-s="300,640" data-src="https://mmbiz.qpic.cn/mmbiz_png/ria05yicJ7wDueO3BTTZLjCFxqBo5Ilc1GLu7nV4LfIPAaPMkBrlJr18xw0LBMhJNqQ0KCaR5icoc4ZzPaiayEGl2Q/640?wx_fmt=png" data-type="png" data-w="600" style="" /></p><section style="max-width: 100%;box-sizing: border-box;min-height: 1em;padding-right: 30px;padding-left: 30px;line-height: 1.6;color: rgb(62, 62, 62);font-size: 16px;white-space: normal;background-color: rgb(255, 255, 255);overflow-wrap: break-word !important;"><br /></section></section></section></section></section><p><br /></p><p><br /></p><p><br /></p>















































































