BSD CFO-Growth 3yr: GrowthRate([Cash from operations Y1],[Cash from operations Y4],3)

BSD CFO to NI 12m: ([Cash from operations 12m]/[Net income 12m])*100

BSD Tangible BV Growth: GrowthRate([Equity (common) Q1]-[Goodwill and intangibles Q1],[Equity (common) Q5]-[Goodwill and intangibles Q5],1)



BSD CFO-Grth 3yr Score: IIF(IsFieldNull([BSD CFO-Growth 3yr])=0,null,IIF([BSD CFO-Growth 3yr]<0,0,IIF([BSD CFO-Growth 3yr]<5,1,IIF([BSD CFO-Growth 3yr]<15,3,5))))

BSD CFO to NI 12m Score: IIF(IsFieldNull([BSD CFO to NI 12m])=0,null,IIF([BSD CFO to NI 12m]<0,0,IIF([BSD CFO to NI 12m]<100,1,IIF([BSD CFO to NI 12m]<200,3,5))))

BSD Div Grth 3yr Score: IIF(IsFieldNull([Dividend-Growth 3yr])=0,null,IIF([Dividend-Growth 3yr]<0,0,IIF([Dividend-Growth 3yr]<2.5,1,IIF([Dividend-Growth 3yr]<10,3,5))))

BSD Dividend Yield Score: IIF(IsFieldNull([Yield])=0,null,IIF([Yield]<0.5,0,IIF([Yield]<2.0,1,IIF([Yield]<3.5,3,5))))

BSD EPS DC Grth 3yr Score: IIF(IsFieldNull([EPS Dil Cont-Growth 3yr])=0,null,IIF([EPS Dil Cont-Growth 3yr]<0,0,IIF([EPS Dil Cont-Growth 3yr]<2.5,1,IIF([EPS Dil Cont-Growth 3yr]<15,3,5))))

BSD EPS Growth Est Score: IIF(IsFieldNull([EPS Growth Est])=0,null,IIF([EPS Growth Est]<0,0,IIF([EPS Growth Est]<10,1,IIF([EPS Growth Est]<15,3,5))))

BSD Payout Ratio Score: IIF(IsFieldNull([Payout ratio 12m])=0,null,IIF([Payout ratio 12m]<15,5,IIF([Payout ratio 12m]<50,3,IIF([Payout ratio 12m]<60,1,0))))

BSD RS 26wk Score: IIF(IsFieldNull([Relative Strength 26 week])=0,null,IIF([Relative Strength 26 week]<0,0,IIF([Relative Strength 26 week]<10,1,IIF([Relative Strength 26 week]<20,3,5))))

BSD TIE 12m Score: IIF(IsFieldNull([Times interest earned 12m])=0,null,IIF([Times interest earned 12m]<1,0,IIF([Times interest earned 12m]<5,1,IIF([Times interest earned 12m]<25,3,5))))

BSD Tangible BV Grth Score: IIF(IsFieldNull([BSD Tangible BV Growth])=0,null,IIF([BSD Tangible BV Growth]<0,0,IIF([BSD Tangible BV Growth]<10,1,IIF([BSD Tangible BV Growth]<20,3,5))))


BSD Composite Score: [BSD Payout Ratio Score]*0.3+[BSD TIE 12m Score]*0.1+[BSD CFO to NI 12m Score]*0.05+[BSD Dividend Yield Score]*0.05+[BSD RS 26wk Score]*0.1+[BSD Tangible BV Grth Score]*0.1+[BSD EPS Growth Est Score]*0.1+[BSD CFO-Grth 3yr Score]*0.05+[BSD Div Grth 3yr Score]*0.1+[BSD EPS DC Grth 3yr Score]*0.05