Sachin K Rai
Sachin K Rai

@Coolfundoo

8 Tweets 1 reads Dec 15, 2022
SOLUTION #SCREENER CHALLENGE 12 💡
🔦Result & Learning 🧵
🔗for #screener
screener.in
@Vivek_Investor
Congratulations 👏 who got this right !
Share 🔃 it if you find this useful !
1
Relatively easy #screener. Only arguable point is Net Cash definition.
Most popular defn ->
Net Cash = Cash Equivalents - Total Liabilities (Current Liabilities+Non Current Liabilities)
Non Current Liabilities is available on @Tijori but it isn't parsing. Need to be fixed.
2
Tried @Trendlyne it has some wonderful parameters available. Do give it a try guys !
I got 1 result - Ingersol Rand for all the parameters except PE. As soon as I applied PE < 15, I got 0 results.
3
Learning - May be we are too stringent & may be Net Cash only applicable to Present/Current. Doesn't make much sense to include liabilities beyond 1 yr.
In this Case,
⚡️Net Cash = Cash Equivalents - Current Liabilities.
4
Some people relate Net Cash as Net Debt free !
In this Case,
⚡️Net Cash = Cash Equivalents - Debt
5
At @screener_in Net Cash the Total Liabilities scenario can also be calculated.
In this Case,
Net Cash = Cash Equivalents - (Total Assets - Net Worth)
where Total Liabilities = Total Assets - Net Worth
6
I wish to include all above Net Cash #scenarios.
Learning - As a #screener builder my objective is to not miss out any possibilities & include all plausible scenarios.
Once we have all results we can apply further checks - Reason for OR in query!
RT 🧵 if useful ! Thanks!
7
Peter Lynch Choice #screener via @Tijori1
Hope this helps !
8

Loading suggestions...