大智慧資產(chǎn)預(yù)警計(jì)分模型指標(biāo)公式
大智慧指標(biāo)公式源碼概況:
- 指標(biāo)類別: 大智慧指標(biāo)公式
- 授權(quán)方式: 免費(fèi)版
- 指標(biāo)評(píng)級(jí): ★★★★★
- 指標(biāo)分類: 圖表
- 畫線方法: 副圖
- 日期:2018-12-31 來源:互聯(lián)網(wǎng)
大智慧指標(biāo)公式源碼介紹:
大智慧資產(chǎn)預(yù)警計(jì)分模型指標(biāo)公式:含有未來函數(shù)
{n:2008,0,99999,1}
資產(chǎn)總額1:=FINANCE2(14)/10;
負(fù)債總額1:=FINANCE2(20)/10;
流動(dòng)負(fù)債1:=FINANCE2(18)/10;
股東權(quán)益1:=FINANCE2(21)/10;
流動(dòng)資產(chǎn)1:=FINANCE2(15)/10;
流動(dòng)資金本1:=流動(dòng)資產(chǎn)1-流動(dòng)負(fù)債1;
每股收益1:=FINANCE2(3);
每股未分配1:=FINANCE2(8);
主營業(yè)務(wù)收入1:=FINANCE2(27)/10;
營業(yè)利潤1:=FINANCE2(29)/10;
凈利潤1:=FINANCE2(33)/10;
留存收益1:=凈利潤1/每股收益1*每股未分配1;{留存收益=未分配利潤=凈利潤/每股收益*每股未分配利潤}
銷售收入1:=主營業(yè)務(wù)收入1;
x1新:=流動(dòng)資金本1/資產(chǎn)總額1*100;
x2新:=留存收益1/資產(chǎn)總額1*100;
x3新:=營業(yè)利潤1/資產(chǎn)總額1*100;
x4新:=股東權(quán)益1/負(fù)債總額1*100;
x5新:=銷售收入1/資產(chǎn)總額1*100;
z新:(1.2*x1新+1.4*x2新+3.3*x3新+0.6*x4新+0.999*x5新)/100,linethick0;
資產(chǎn)總額2:=PFFININ(1083 ,N ,1231 )/10000;
負(fù)債總額2:=PFFININ(1106 ,N ,1231 )/10000;
流動(dòng)負(fù)債2:=PFFININ(1097 ,N ,1231 )/10000;
股東權(quán)益2:=PFFININ(1114 ,N ,1231 )/10000;
流動(dòng)資產(chǎn)2:=PFFININ(1064 ,N ,1231 )/10000;
流動(dòng)資金本2:=流動(dòng)資產(chǎn)2-流動(dòng)負(fù)債2;
主營業(yè)務(wù)收入2:=PFFININ(1251 ,N ,1231 )/10000;
營業(yè)利潤2:=PFFININ(1263 ,N ,1231 )/10000;
留存收益2:=PFFININ(1111 ,N ,1231 )/10000;{留存收益=未分配利潤=凈利潤/每股收益*每股未分配利潤}
銷售收入2:=主營業(yè)務(wù)收入2;
x1K:=流動(dòng)資金本2/資產(chǎn)總額2*100;
x2K:=留存收益2/資產(chǎn)總額2*100;
x3K:=營業(yè)利潤2/資產(chǎn)總額2*100;
x4K:=股東權(quán)益2/負(fù)債總額2*100;
x5K:=銷售收入2/資產(chǎn)總額2*100;
zK:(1.2*x1K+1.4*x2K+3.3*x3K+0.6*x4K+0.999*x5K)/100,linethick0;
資產(chǎn)總額3:=PFFININ(1083 ,n-1,1231 )/10000;
負(fù)債總額3:=PFFININ(1106 ,n-1,1231 )/10000;
流動(dòng)負(fù)債3:=PFFININ(1097 ,n-1,1231 )/10000;
股東權(quán)益3:=PFFININ(1114 ,n-1,1231 )/10000;
流動(dòng)資產(chǎn)3:=PFFININ(1064 ,n-1,1231 )/10000;
流動(dòng)資金本3:=流動(dòng)資產(chǎn)2-流動(dòng)負(fù)債2;
主營業(yè)務(wù)收入3:=PFFININ(1251 ,n-1,1231 )/10000;
營業(yè)利潤3:=PFFININ(1263 ,n-1,1231 )/10000;
留存收益3:=PFFININ(1111 ,N-1 ,1231 )/10000;{留存收益=未分配利潤=凈利潤/每股收益*每股未分配利潤}
銷售收入3:=主營業(yè)務(wù)收入3;
x1上:=流動(dòng)資金本3/資產(chǎn)總額3*100;
x2上:=留存收益3/資產(chǎn)總額3*100;
x3上:=營業(yè)利潤3/資產(chǎn)總額3*100;
x4上:=股東權(quán)益3/負(fù)債總額3*100;
x5上:=銷售收入3/資產(chǎn)總額3*100;
z上:(1.2*x1上+1.4*x2上+3.3*x3上+0.6*x4上+0.999*x5上)/100,linethick0;
資產(chǎn)總額4:=PFFININ(1083 ,n-2,1231 )/10000;
負(fù)債總額4:=PFFININ(1106 ,n-2,1231 )/10000;
流動(dòng)負(fù)債4:=PFFININ(1097 ,n-2,1231 )/10000;
股東權(quán)益4:=PFFININ(1114 ,n-2,1231 )/10000;
流動(dòng)資產(chǎn)4:=PFFININ(1064 ,n-2,1231 )/10000;
流動(dòng)資金本4:=流動(dòng)資產(chǎn)2-流動(dòng)負(fù)債2;
主營業(yè)務(wù)收入4:=PFFININ(1251 ,n-2,1231 )/10000;
營業(yè)利潤4:=PFFININ(1263 ,n-2,1231 )/10000;
留存收益4:=PFFININ(1111 ,N-2 ,1231 )/10000;{留存收益=未分配利潤=凈利潤/每股收益*每股未分配利潤}
銷售收入4:=主營業(yè)務(wù)收入4;
x1前:=流動(dòng)資金本4/資產(chǎn)總額4*100;
x2前:=留存收益4/資產(chǎn)總額4*100;
x3前:=營業(yè)利潤4/資產(chǎn)總額4*100;
x4前:=股東權(quán)益4/負(fù)債總額4*100;
x5前:=銷售收入4/資產(chǎn)總額4*100;
z前:(1.2*x1前+1.4*x2前+3.3*x3前+0.6*x4前+0.999*x5前)/100,linethick0;
DRAWTEXTREL( 0, 0, '序號(hào)' ),coloryellow;
DRAWTEXTREL( 50, 0, '指標(biāo)說明' ),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, '結(jié)果(用年報(bào))'),coloryellow;
資產(chǎn)總額1:=FINANCE2(14)/10;
負(fù)債總額1:=FINANCE2(20)/10;
流動(dòng)負(fù)債1:=FINANCE2(18)/10;
股東權(quán)益1:=FINANCE2(21)/10;
流動(dòng)資產(chǎn)1:=FINANCE2(15)/10;
流動(dòng)資金本1:=流動(dòng)資產(chǎn)1-流動(dòng)負(fù)債1;
每股收益1:=FINANCE2(3);
每股未分配1:=FINANCE2(8);
主營業(yè)務(wù)收入1:=FINANCE2(27)/10;
營業(yè)利潤1:=FINANCE2(29)/10;
凈利潤1:=FINANCE2(33)/10;
留存收益1:=凈利潤1/每股收益1*每股未分配1;{留存收益=未分配利潤=凈利潤/每股收益*每股未分配利潤}
銷售收入1:=主營業(yè)務(wù)收入1;
x1新:=流動(dòng)資金本1/資產(chǎn)總額1*100;
x2新:=留存收益1/資產(chǎn)總額1*100;
x3新:=營業(yè)利潤1/資產(chǎn)總額1*100;
x4新:=股東權(quán)益1/負(fù)債總額1*100;
x5新:=銷售收入1/資產(chǎn)總額1*100;
z新:(1.2*x1新+1.4*x2新+3.3*x3新+0.6*x4新+0.999*x5新)/100,linethick0;
資產(chǎn)總額2:=PFFININ(1083 ,N ,1231 )/10000;
負(fù)債總額2:=PFFININ(1106 ,N ,1231 )/10000;
流動(dòng)負(fù)債2:=PFFININ(1097 ,N ,1231 )/10000;
股東權(quán)益2:=PFFININ(1114 ,N ,1231 )/10000;
流動(dòng)資產(chǎn)2:=PFFININ(1064 ,N ,1231 )/10000;
流動(dòng)資金本2:=流動(dòng)資產(chǎn)2-流動(dòng)負(fù)債2;
主營業(yè)務(wù)收入2:=PFFININ(1251 ,N ,1231 )/10000;
營業(yè)利潤2:=PFFININ(1263 ,N ,1231 )/10000;
留存收益2:=PFFININ(1111 ,N ,1231 )/10000;{留存收益=未分配利潤=凈利潤/每股收益*每股未分配利潤}
銷售收入2:=主營業(yè)務(wù)收入2;
x1K:=流動(dòng)資金本2/資產(chǎn)總額2*100;
x2K:=留存收益2/資產(chǎn)總額2*100;
x3K:=營業(yè)利潤2/資產(chǎn)總額2*100;
x4K:=股東權(quán)益2/負(fù)債總額2*100;
x5K:=銷售收入2/資產(chǎn)總額2*100;
zK:(1.2*x1K+1.4*x2K+3.3*x3K+0.6*x4K+0.999*x5K)/100,linethick0;
資產(chǎn)總額3:=PFFININ(1083 ,n-1,1231 )/10000;
負(fù)債總額3:=PFFININ(1106 ,n-1,1231 )/10000;
流動(dòng)負(fù)債3:=PFFININ(1097 ,n-1,1231 )/10000;
股東權(quán)益3:=PFFININ(1114 ,n-1,1231 )/10000;
流動(dòng)資產(chǎn)3:=PFFININ(1064 ,n-1,1231 )/10000;
流動(dòng)資金本3:=流動(dòng)資產(chǎn)2-流動(dòng)負(fù)債2;
主營業(yè)務(wù)收入3:=PFFININ(1251 ,n-1,1231 )/10000;
營業(yè)利潤3:=PFFININ(1263 ,n-1,1231 )/10000;
留存收益3:=PFFININ(1111 ,N-1 ,1231 )/10000;{留存收益=未分配利潤=凈利潤/每股收益*每股未分配利潤}
銷售收入3:=主營業(yè)務(wù)收入3;
x1上:=流動(dòng)資金本3/資產(chǎn)總額3*100;
x2上:=留存收益3/資產(chǎn)總額3*100;
x3上:=營業(yè)利潤3/資產(chǎn)總額3*100;
x4上:=股東權(quán)益3/負(fù)債總額3*100;
x5上:=銷售收入3/資產(chǎn)總額3*100;
z上:(1.2*x1上+1.4*x2上+3.3*x3上+0.6*x4上+0.999*x5上)/100,linethick0;
資產(chǎn)總額4:=PFFININ(1083 ,n-2,1231 )/10000;
負(fù)債總額4:=PFFININ(1106 ,n-2,1231 )/10000;
流動(dòng)負(fù)債4:=PFFININ(1097 ,n-2,1231 )/10000;
股東權(quán)益4:=PFFININ(1114 ,n-2,1231 )/10000;
流動(dòng)資產(chǎn)4:=PFFININ(1064 ,n-2,1231 )/10000;
流動(dòng)資金本4:=流動(dòng)資產(chǎn)2-流動(dòng)負(fù)債2;
主營業(yè)務(wù)收入4:=PFFININ(1251 ,n-2,1231 )/10000;
營業(yè)利潤4:=PFFININ(1263 ,n-2,1231 )/10000;
留存收益4:=PFFININ(1111 ,N-2 ,1231 )/10000;{留存收益=未分配利潤=凈利潤/每股收益*每股未分配利潤}
銷售收入4:=主營業(yè)務(wù)收入4;
x1前:=流動(dòng)資金本4/資產(chǎn)總額4*100;
x2前:=留存收益4/資產(chǎn)總額4*100;
x3前:=營業(yè)利潤4/資產(chǎn)總額4*100;
x4前:=股東權(quán)益4/負(fù)債總額4*100;
x5前:=銷售收入4/資產(chǎn)總額4*100;
z前:(1.2*x1前+1.4*x2前+3.3*x3前+0.6*x4前+0.999*x5前)/100,linethick0;
DRAWTEXTREL( 0, 0, '序號(hào)' ),coloryellow;
DRAWTEXTREL( 50, 0, '指標(biāo)說明' ),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, '結(jié)果(用年報(bào))'),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計(jì)分模型' ),coloryellow;
DRAWTEXTREL( 50, 100, '營運(yùn)資金/資產(chǎn)總額' ),coloryellow;
DRAWTEXTREL( 50, 200, '留存收益/資產(chǎn)總額' ),coloryellow;
DRAWTEXTREL( 50, 300, '息稅前收益/資產(chǎn)總額' ),coloryellow;
DRAWTEXTREL( 50, 400, '權(quán)益市價(jià)/負(fù)債總額' ),coloryellow;
DRAWTEXTREL( 50, 500, '銷售額/資產(chǎn)總額' ),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;
IF BARSTATUS=2 and zk>=2.675 THEN DRAWTEXTREL(250,800,'若Z≥2.675 則表明企業(yè)的財(cái)務(wù)狀況良好,發(fā)生破產(chǎn)的可能性較小'),LINETHICK2,COLORFF00FF;
IF BARSTATUS=2 and zk<=1.81 THEN DRAWTEXTREL(250,800,'若Z≤1.81 則企業(yè)存在很大的破產(chǎn)危險(xiǎn)'),LINETHICK2,COLORFF00FF;
IF BARSTATUS=2 and BETWEEN(zk,2.675,1.81) THEN DRAWTEXTREL(250,800,' 若1.81<Z<2.675 則表明企業(yè)財(cái)務(wù)是極為不穩(wěn)定的。 '),LINETHICK2,COLORFF00FF;
DRAWTEXTREL( 10, 200, 'X2' ),coloryellow;
DRAWTEXTREL( 10, 300, 'X3' ),coloryellow;
DRAWTEXTREL( 10, 400, 'X4' ),coloryellow;
DRAWTEXTREL( 10, 500, 'X5' ),coloryellow;
DRAWTEXTREL( 20, 650, 'Z計(jì)分模型' ),coloryellow;
DRAWTEXTREL( 50, 100, '營運(yùn)資金/資產(chǎn)總額' ),coloryellow;
DRAWTEXTREL( 50, 200, '留存收益/資產(chǎn)總額' ),coloryellow;
DRAWTEXTREL( 50, 300, '息稅前收益/資產(chǎn)總額' ),coloryellow;
DRAWTEXTREL( 50, 400, '權(quán)益市價(jià)/負(fù)債總額' ),coloryellow;
DRAWTEXTREL( 50, 500, '銷售額/資產(chǎn)總額' ),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;
IF BARSTATUS=2 and zk>=2.675 THEN DRAWTEXTREL(250,800,'若Z≥2.675 則表明企業(yè)的財(cái)務(wù)狀況良好,發(fā)生破產(chǎn)的可能性較小'),LINETHICK2,COLORFF00FF;
IF BARSTATUS=2 and zk<=1.81 THEN DRAWTEXTREL(250,800,'若Z≤1.81 則企業(yè)存在很大的破產(chǎn)危險(xiǎn)'),LINETHICK2,COLORFF00FF;
IF BARSTATUS=2 and BETWEEN(zk,2.675,1.81) THEN DRAWTEXTREL(250,800,' 若1.81<Z<2.675 則表明企業(yè)財(cái)務(wù)是極為不穩(wěn)定的。 '),LINETHICK2,COLORFF00FF;
IF BARSTATUS=2 and zk>z上 THEN DRAWTEXTREL(850,650,'提高 '),COLORred;
IF BARSTATUS=2 and zk<=z上 THEN DRAWTEXTREL(850,650,'下降 '),COLORgreen;
IF BARSTATUS=2 and zk<=z上 THEN DRAWTEXTREL(850,650,'下降 '),COLORgreen;
IF BARSTATUS=2 and x5k>x5上 THEN DRAWTEXTREL(850,500,'提高 '),COLORred;
IF BARSTATUS=2 and x5k<=x5上 THEN DRAWTEXTREL(850,500,'下降 '),COLORgreen;
IF BARSTATUS=2 and x5k<=x5上 THEN DRAWTEXTREL(850,500,'下降 '),COLORgreen;
IF BARSTATUS=2 and x4k>x4上 THEN DRAWTEXTREL(850,400,'提高 '),COLORred;
IF BARSTATUS=2 and x4k<=x4上 THEN DRAWTEXTREL(850,400,'下降 '),COLORgreen;
IF BARSTATUS=2 and x4k<=x4上 THEN DRAWTEXTREL(850,400,'下降 '),COLORgreen;
IF BARSTATUS=2 and x3k>x3上 THEN DRAWTEXTREL(850,300,'提高 '),COLORred;
IF BARSTATUS=2 and x3k<=x3上 THEN DRAWTEXTREL(850,300,'下降 '),COLORgreen;
IF BARSTATUS=2 and x3k<=x3上 THEN DRAWTEXTREL(850,300,'下降 '),COLORgreen;
IF BARSTATUS=2 and x2k>x2上 THEN DRAWTEXTREL(850,200,'提高 '),COLORred;
IF BARSTATUS=2 and x2k<=x2上 THEN DRAWTEXTREL(850,200,'下降 '),COLORgreen;
IF BARSTATUS=2 and x2k<=x2上 THEN DRAWTEXTREL(850,200,'下降 '),COLORgreen;
IF BARSTATUS=2 and x1k>x1上 THEN DRAWTEXTREL(850,100,'提高 '),COLORred;
IF BARSTATUS=2 and x1k<=x1上 THEN DRAWTEXTREL(850,100,'下降 '),COLORgreen;
IF BARSTATUS=2 and x1k<=x1上 THEN DRAWTEXTREL(850,100,'下降 '),COLORgreen;
大智慧資產(chǎn)預(yù)警計(jì)分模型指標(biāo)公式實(shí)例圖解:
大智慧資產(chǎn)預(yù)警計(jì)分模型指標(biāo)公式
大智慧指標(biāo)相關(guān)閱讀