'Quantamental' Japan Specialist, LightStream Research

Campbell Gunn

Former Japan Equity PM with over 30 of experience now providing database-driven analysis of the market, sectors, peer groups and stocks for LightStream Research.

Leveraging data and graphic analysis provided by Japan Analytics, and the related Japan Analytics iPad App, we provide insights on companies are often ignored by the sell-side as well as challenging conventional wisdom on the market overall.

'Quantamental' Japan Specialist

🇯🇵 JAPAN • Stress Tests Part 6: Currency Risk

NEC (6701 JP): Teleworking Drives Upward Revision to FY Mar-20 Guidance

Sumco: Earnings Growth Resumes in 1Q20 Amidst Covid-19 Outbreak

🇯🇵 JAPAN - Stress Tests Part 4 - From Free Cash Flow to Change in Cash

Toshiba – A ¥3.5trn Kioxia Valuation Looks Like a Stretch

🇯🇵 JAPAN - Stress Tests Part 3 - Inventory, Fixed Asset & Free Cash Flows

Long-Short Analysis on Japan, Asia and the World

LightStream Research

LightStream conducts quantitatively rigorous and data-driven analysis with a focus on Japan and Asia.

We consistently cover the Tech, Consumer and Industrial sectors, and provide ECM and Events coverage more broadly.

We supplement traditional qualitative insights from company relationships with a robust quantitative foundation that examines as much historical data as is available.
We further refine the accuracy of our insights and calls through the use of alternative data to flesh out current trends, and through a valuation framework that emphasises non-superficial peer group selection and a proper attempt to understand the metrics and changes that have driven security valuations in the past.

Thematic (Sector/Industry)

Japan Industrials / Thematic (Sector/Industry)

<figure class="editor-figure mceNonEditable"><img src="https://static-prod.smartkarma.com/images/media/000/143/496/original/2020-06-30_14-16-44.png?1593494217" class="editor-image img-responsive" data-smartkarma-image-id="143496"></figure>
<div class="content-caption">Source • Japan Analytics</div>
THE CASH CONVERSION CYCLE - Net Working Capital is a measure of how efficiently a company manages its short-term assets and liabilities to generate cash and is also known as the Cash Conversion Cycle. In practice, Net Working Capital is scaled by the number of days of Revenue or Cost of Goods Sold that are 'tied' up in three components - Receivables, Inventory, and Payables.
Net Working Capital Days varies by industry and the lower the number, the better. Amounts over 210 days are excessive, and a sign of business stress.  Net Working Capital is defined as:-
<ul>
<li>
+ Receivables/Revenue - the average number of days required to collect on sales. Businesses usually extend a degree of credit to non-cash customers.  Receivables Days over 100 are excessive.</li>
<li>
+ Inventory/Cost of Goods Sold - the average number of days it takes to sell out of Inventory. Amounts vary widely by industry but days over 210 are excessive.</li>
<li>- Payables/Cost of Goods Sold -the average number of days the company takes to settle transactions with suppliers. By extending nominally interest-free credit, suppliers provide operating leverage to a business. A larger negative number is better, but days less than -100 are excessive.</li>
</ul>
The relationship between Receivables and Payables should also be considered particularly where the company is giving more generous credit terms to its customers than it receives from its suppliers. The Cash Conversion Cycle for the aggregate of all non-financial currently-listed Japanese companies has averaged 77 days over the last thirty years. However, over the previous twelve months., a fourteen-day rise in Inventory Days during the last four years has pushed Net Working Capital Days to 93.
<figure class="editor-figure mceNonEditable"><img src="https://static-prod.smartkarma.com/images/media/000/143/529/original/2020-06-30_15-09-41.png?1593497395" class="editor-image img-responsive" data-smartkarma-image-id="143529"></figure>
<figure class="editor-figure mceNonEditable"><img src="https://static-prod.smartkarma.com/images/media/000/143/530/original/2020-06-30_15-10-32.png?1593497471" class="editor-image img-responsive" data-smartkarma-image-id="143530"></figure>
<div class="content-caption">Source • Japan Analytics</div>
<div class="content-caption"></div>
NET WORKING CAPITAL DAYS AS A STRESS TEST - The correlation between Net Working Capital Days and relative performance varies by company and by Sectors. The examples above show how signals can be heeded -  <a href="https://www.smartkarma.com/entities/nikon-corp" target="_blank" data-smartkarma-citation="entities:7117:1" rel="noopener">Nikon (7731 JP)</a>, or ignored - <a href="https://www.smartkarma.com/entities/smc-corp" target="_blank" data-smartkarma-citation="entities:20866:1" rel="noopener">SMC (6273 JP)</a> since 2018. (For more on SMC working capital issues, please see my colleague <a href="https://www.smartkarma.com/profiles/scott-foster" target="_blank" data-smartkarma-citation="accounts:1134" rel="noopener">Scott Foster</a>'s Insight of last year - <a href="https://www.smartkarma.com/insights/smc-6273-jp-getting-in-line-with-reality" target="_blank" data-smartkarma-citation="insights:30081" rel="noopener">SMC (6273 JP): Getting in Line with Reality</a>).   
For this Insight, we have limited our review to larger capitalisation manufacturing companies. In the DETAIL section below, we shall cover the outliers at both ends of Receivables Days, Inventory Days, Payables Days, and finally Net Working Capital Days.


Source • Japan Analytics
THE CASH CONVERSION CYCLE - Net Working Capital is a measure of how efficiently a company manages its short-term assets and liabilities to generate cash and is also known as the Cash Conversion Cycle. In practice, Net Working Capital is scaled by the number of days of Revenue or Cost of Goods Sold that are 'tied' up in three components - Receivables, Inventory, and Payables.
Net Working Capital Days varies by industry and the lower the number, the better. Amounts over 210 days are excessive, and a sign of business stress.  Net Working Capital is defined as:-


+ Receivables/Revenue - the average number of days required to collect on sales. Businesses usually extend a degree of credit to non-cash customers.  Receivables Days over 100 are excessive.

+ Inventory/Cost of Goods Sold - the average number of days it takes to sell out of Inventory. Amounts vary widely by industry but days over 210 are excessive.
- Payables/Cost of Goods Sold -the average number of days the company takes to settle transactions with suppliers. By extending nominally interest-free credit, suppliers provide operating leverage to a business. A larger negative number is better, but days less than -100 are excessive.

The relationship between Receivables and Payables should also be considered particularly where the company is giving more generous credit terms to its customers than it receives from its suppliers. The Cash Conversion Cycle for the aggregate of all non-financial currently-listed Japanese companies has averaged 77 days over the last thirty years. However, over the previous twelve months., a fourteen-day rise in Inventory Days during the last four years has pushed Net Working Capital Days to 93.


Source • Japan Analytics

NET WORKING CAPITAL DAYS AS A STRESS TEST - The correlation between Net Working Capital Days and relative performance varies by company and by Sectors. The examples above show how signals can be heeded -  Nikon (7731 JP), or ignored - SMC (6273 JP) since 2018. (For more on SMC working capital issues, please see my colleague Scott Foster's Insight of last year - SMC (6273 JP): Getting in Line with Reality).   
For this Insight, we have limited our review to larger capitalisation manufacturing companies. In the DETAIL section below, we shall cover the outliers at both ends of Receivables Days, Inventory Days, Payables Days, and finally Net Working Capital Days.

🇯🇵 JAPAN • Stress Tests Part 5: Net Working Capital Outliers