股票-大智慧资产预警计分模型指标公式.docx
大智慧资产预警计分模型指标公式_正点财经净利润1:=FINANCE2(33)/10;留存收益1:=净利润1/每股收益1*每股未分配1;留存收益=未分配利润=净利润/每股收益*每股未分配利润销售收入1:=主营业务收入1;x1新:=流动资金本1/资产总额1*100;x2新:=留存收益1/资产总额1*100;x3新:=营业利润1/资产总额1*100;x4新:=股东权益1/负债总额1*100;x5新:=销售收入1/资产总额1*100;z新:(1.2*x1新+1.4*x2新+3.3*x3新+0.6*x4新+0.999*x5新)/100,linethick0;资产总额2:=PFFININ(1083,N,1231)/10000;负债总额2:=PFFININ(1106,N,1231)/10000;流动负债2:=PFFININ(1097,N,1231)/10000;股东权益2:=PFFININ(1114,N,1231)/10000;流动资产2:=PFFININ(1064,N,1231)/10000;流动资金本2:=流动资产2-流动负债2;主营业务收入2:=PFFININ(1251,N,1231)/10000;营业利润2:=PFFININ(1263,N,1231)/10000;留存收益2:=PFFININ(1111,N,1231)/10000;留存收益=未分配利润=净利润/每股收益*每股未分配利润销售收入2:=主营业务收入2;x1K:=流动资金本2/资产总额2*100;x2K:=留存收益2/资产总额2*100;x3K:=营业利润2/资产总额2*100;x4K:=股东权益2/负债总额2*100;x5K:=销售收入2/资产总额2*100;zK:(1.2*x1K+1.4*x2K+3.3*x3K+0.6*x4K+0.999*x5K)/100,linethick0;资产总额3:=PFFININ(1083,n-1,1231)/10000;负债总额3:=PFFININ(1106,n-1,1231)/10000;流动负债3:=PFFININ(1097,n-1,1231)/10000;股东权益3:=PFFININ(1114,n-1,1231)/10000;流动资产3:=PFFININ(1064,n-1,1231)/10000;流动资金本3:=流动资产2-流动负债2;主营业务收入3:=PFFININ(1251,n-1,1231)/10000;营业利润3:=PFFININ(1263,n-1,1231)/10000;留存收益3:=PFFININ(1111,N-1,1231)/10000;留存收益=未分配利润=净利润/每股收益*每股未分配利润销售收入3:=主营业务收入3;x1上:=流动资金本3/资产总额3*100;x2上:=留存收益3/资产总额3*100;x3上:=营业利润3/资产总额3*100;x4上:=股东权益3/负债总额3*100;x5上:=销售收入3/资产总额3*100;z上:(1.2*x1上+1.4*x2上+3.3*x3上+0.6*x4上+0.999*x5上)/100,linethick0;资产总额4:=PFFININ(1083,n-2,1231)/10000;负债总额4:=PFFININ(1106,n-2,1231)/10000;流动负债4:=PFFININ(1097,n-2,1231)/10000;股东权益4:=PFFININ(1114,n-2,1231)/10000;流动资产4:=PFFININ(1064,n-2,1231)/10000;流动资金本4:=流动资产2-流动负债2;主营业务收入4:=PFFININ(1251,n-2,1231)/10000;营业利润4:=PFFININ(1263,n-2,1231)/10000;留存收益4:=PFFININ(1111,N-2,1231)/10000;留存收益=未分配利润=净利润/每股收益*每股未分配利润销售收入4:=主营业务收入4;x1前:=流动资金本4/资产总额4*100;x2前:=留存收益4/资产总额4*100;x3前:=营业利润4/资产总额4*100;x4前:=股东权益4/负债总额4*100;x5前:=销售收入4/资产总额4*100;z前:(1.2*x1前+1.4*x2前+3.3*x3前+0.6*x4前+0.999*x5前)/100,linethick0;DRAWTEXTREL(0,0,序号),coloryellow;DRAWTEXTREL(50,0,指标说明),coloryellow;DRAWTEXTREL(250,0,+NUMTOSTRN(n-2,0)+年),coloryellow;DRAWTEXTREL(400,0,+NUMTOSTRN(n-1,0)+年),coloryellow;DRAWTEXTREL(550,0,+NUMTOSTRN(n,0)+年),coloryellow;DRAWTEXTREL(700,0,+NUMTOSTRN(FINANCE2(1),0),coloryellow;DRAWTEXTREL(850,0,结果（用年报）),coloryellow;DRAWTEXTREL(10,100,X1),coloryellow;DRAWTEXTREL(10,200,X2),coloryellow;DRAWTEXTREL(10,300,X3),coloryellow;DRAWTEXTREL(10,400,X4),coloryellow;DRAWTEXTREL(10,500,X5),coloryellow;DRAWTEXTREL(20,650,Z计分模型),coloryellow;DRAWTEXTREL(50,100,营运资金/资产总额),coloryellow;DRAWTEXTREL(50,200,留存收益/资产总额),coloryellow;DRAWTEXTREL(50,300,息税前收益/资产总额),coloryellow;DRAWTEXTREL(50,400,权益市价/负债总额),coloryellow;DRAWTEXTREL(50,500,销售额/资产总额),coloryellow;DRAWTEXTREL(250,100,+NUMTOSTRN(x1前,2),coloryellow;DRAWTEXTREL(400,100,+NUMTOSTRN(x1上,2),coloryellow;DRAWTEXTREL(550,100,+NUMTOSTRN(x1K,2),coloryellow;DRAWTEXTREL(700,100,+NUMTOSTRN(x1新,2),coloryellow;DRAWTEXTREL(250,200,+NUMTOSTRN(x2前,2),coloryellow;DRAWTEXTREL(400,200,+NUMTOSTRN(x2上,2),coloryellow;DRAWTEXTREL(550,200,+NUMTOSTRN(x2K,2),coloryellow;DRAWTEXTREL(700,200,+NUMTOSTRN(x2新,2),coloryellow;DRAWTEXTREL(250,300,+NUMTOSTRN(x3前,2),coloryellow;DRAWTEXTREL(400,300,+NUMTOSTRN(x3上,2),coloryellow;DRAWTEXTREL(550,300,+NUMTOSTRN(x3K,2),coloryellow;DRAWTEXTREL(700,300,+NUMTOSTRN(x3新,2),coloryellow;DRAWTEXTREL(250,400,+NUMTOSTRN(x4前,2),coloryellow;DRAWTEXTREL(400,400,+NUMTOSTRN(x4上,2),coloryellow;DRAWTEXTREL(550,400,+NUMTOSTRN(x4K,2),coloryellow;DRAWTEXTREL(700,400,+NUMTOSTRN(x4新,2),coloryellow;DRAWTEXTREL(250,500,+NUMTOSTRN(x5前,2),coloryellow;DRAWTEXTREL(400,500,+NUMTOSTRN(x5上,2),coloryellow;DRAWTEXTREL(550,500,+NUMTOSTRN(x5K,2),coloryellow;DRAWTEXTREL(700,500,+NUMTOSTRN(x5新,2),coloryellow;DRAWTEXTREL(250,650,+NUMTOSTRN(z前,2),coloryellow;DRAWTEXTREL(400,650,+NUMTOSTRN(z上,2),coloryellow;DRAWTEXTREL(550,650,+NUMTOSTRN(zK,2),coloryellow;DRAWTEXTREL(700,650,+NUMTOSTRN(z新,2),coloryellow;IFBARSTATUS=2andzk=2.675THENDRAWTEXTREL(250,800,若Z2.675则表明企业的财务状况良好，发生破产的可能性较小),LINETHICK2,COLORFF00FF;IFBARSTATUS=2andzk=1.81THENDRAWTEXTREL(250,800,若Z1.81则企业存在很大的破产危险),LINETHICK2,COLORFF00FF;IFBARSTATUS=2andBETWEEN(zk,2.675,1.81)THENDRAWTEXTREL(250,800,若1.81Z2.675则表明企业财务是极为不稳定的。),LINETHICK2,COLORFF00FF;IFBARSTATUS=2andzkz上THENDRAWTEXTREL(850,650,提高),COLORred;IFBARSTATUS=2andzk=z上THENDRAWTEXTREL(850,650,下降),COLORgreen;IFBARSTATUS=2andx5kx5上THENDRAWTEXTREL(850,500,提高),COLORred;IFBARSTATUS=2andx5k=x5上THENDRAWTEXTREL(850,500,下降),COLORgreen;IFBARSTATUS=2andx4kx4上THENDRAWTEXTREL(850,400,提高),COLORred;IFBARSTATUS=2andx4k=x4上THENDRAWTEXTREL(850,400,下降),COLORgreen;IFBARSTATUS=2andx3kx3上THENDRAWTEXTREL(850,300,提高),COLORred;IFBARSTATUS=2andx3k=x3上THENDRAWTEXTREL(850,300,下降),COLORgreen;IFBARSTATUS=2andx2kx2上THENDRAWTEXTREL(850,200,提高),COLORred;IFBARSTATUS=2andx2k=x2上THENDRAWTEXTREL(850,200,下降),COLORgreen;IFBARSTATUS=2andx1kx1上THENDRAWTEXTREL(850,100,提高),COLORred;IFBARSTATUS=2andx1k=x1上THENDRAWTEXTREL(850,100,下降),COLORgreen;大智慧资产预警计分模型指标公式实例图解:大智慧资产预警计分模型指标公式
