Yes I do find DangInvestor an awesome business analysis and valuation program, there is nothing like it in the world. And that's not just because I wrote it from scratch but because it is really that awesome
View attachment 69742
Just added the 2015 and 2016 data...
From above chart, Net Capex is defined as cash spent (outflow) on PPE after deducting cash received from sales and disposal of PPE (inflow). So the negative Net Capex meant MND sold more PPE than spent on new ones.
Such definition assumes a whole lot of stuff that only honest and responsible management would do. That is, whatever amount is needed to maintain and expand PPE to keep it running smoothly are actually spent in cash getting it done. That whatever is claimed as depreciation etc., are for tax purposes only. So it's not a perfect definition but note that is is part of the quickLook analysis module and also where users get to define what they meant by capex. i.e. does capex include opex and anything that is a PPE... or capex is only "capex" required to maintain their own operation's PPE. Such definition can be quite important depending on the business you're looking at.
Anyway, MND actually have a negative CAPEX over the past 3 years. i.e. it was getting rid of its machineries more than buying/leasing new ones. So the ratio of capex to net op. cash flow does not really indicate much for MND over recent years.
Capex are MND's properties, plant and equipment... they're not the assets of their client's project. They're what MND spent on PPE to get the job done. So they buy(sell or lease) PPE and this number goes up or down depending on project wins. Note too that MND lease a lot of their PE rather than owning them inhouse.
But yes, MND does not own the assets they're hired to construct. The high Capex in other years were due to them needing to spent more on capex to get the tools, the recent negative capex show they're getting rid of PPE overall (less work) but still buying, not completely stopped.
I guess it's an example of how important it is to look at the detail rather than just the resultant ratio.
As with other series in that chart, I was trying to see how well the company's operating cash flow manage against the cash capex and interest during the year.
So net op cash b4 interests to net capex plus interests simply compare the kind of margin the company's net cash from operation could pay for these two crucial expenses (pay the bankers and maintain the machinery).
View attachment 69743
So for 2013, net op. cash could cover interests and net capEx 8.32 times. Flip that and both expenses consumes 12% of MND's net cash earnings. i.e. the remaining 88% can pay dividends.
But note that for 2013, the Blue and the Red bars could not equal to the stacked Green (dividend) and capex and interest. i.e. cash from operation alone could not cover dividends and the other two expenses.
You'd not want a business that show this kind of pattern over the years. But again, it depends... and MND have plenty of cash at the bank, so a single year isn't too bad... that and give this is the start of its industry's downturn.
Note too that net op.cashflow more than cover all these expenses the previous three years... so business, while smaller, more than covers dividends and etc. Indicating good management not playing the share market price game by sensibly managing its cash position.
It's one of the very important charts that after you get use to it, can tell a heck of a lot about the business.
View attachment 69746
NWC is defined as Current Assets minus Current Liabilities.
MND's NWC has risen again in 2016.
Though a positive and rising NWC is generally a good thing to see, whether this is reasonable and good or not depends... we'd need to look at the detail in its Balance Sheet (Fin.Position).
So it could be a bad thing since you don't want a lazy balance sheet where management aren't making good use of cash beside putting them at the bank. But then you don't want them to not be able to pay liabilities that are due within the year either.
For industrial companies, particularly one experiencing a marked downturn, you'd want it to have a lot of cash (or assets that is expected to be turn into cash within the year). This would allow the business to survive and maybe start to acquire struggling competitor or new businesses on the cheap. Something MND has managed to do very well... though they still have yet to make a big acquisition so far. That could be a good thing, maybe too cautious but yea, I like how they think.
Business slows down because the revenues are down
While the accounting equation of Assets = Liabilities + Equity might give the impression of what you said there about CL rising faster than CA... If that's the case it's, to me, just coincidental. And you can't figure if they're related from CA and NCA rising and falling.
For MND, its CA rises mean its still earning money (and storing up the cash) while selling off its NCA (the PPE being sold probably play a major part in that).
To see if CL rises faster than CA... best to look at the Current Ratio (i.e. CA over CL).
View attachment 69750
See how the current ratio (purple line) rises? It mean that the change in CA is always higher than the change in CL (for years where CRatio rises).
If you refer back to the Capital Structure chart, CA generally rises while CL decreases.
From DangInvestor's note:
So Cash Cycle depends on 3 factors, not just the working capital.
Then yes, increasing CC is bad but we should also look at which of the above three factors contribute to the increase. You can see this in the chart next to the CCC chart earlier:
View attachment 69751
MND has been able to have a negative CC from 2007 to 2012 mainly due to it paying others later while its sales was great and it was good at collecting its pay from clients.
The last few years reverses this, but with the exception of last year 2016, MND has historically pay its due faster than collecting its due. Mainly due to big clients, and you got to play nice with those guys perhaps.
But the CC is not just paying and collecting, it's also getting the work done (inventory) quicker or not. This seem to play a big role in the increases in its CC than the other factor. So why? Maybe the projects it had won (they consider this their inventory) are delayed... delayed by clients who's short on cash perhaps.
You can see how big inventory turnover affect CC by seeing above how erratic the Inventory Turnover (light blue) line moves compare to the generally stable Payables and Receivables Turnovers.
But yea, when it took MND longer to collect, they also take a bit longer to pay too. Seems all normal except for the great few years where it managed to pay slower.
Hey sorry for late reply, I haven't been on this site for very long time, I'll look into your post and get back to you. You still holding on to MND? I'm still holding since last September and with dividend reinvestment its up almost 80%, I noticed 5 brokers have a sell rating, looking at PE its definitely overvalued but FCF multiple is a whole different story. What are your thoughts??