Wednesday, February 13, 2019
Low Latency Calcbench

Monday, February 11, 2019
Now Streaming on Hulu: Red Ink

Thursday, February 7, 2019
Early Look at 2018 Tax Decline

Wednesday, February 6, 2019
You Revised WHAT, Netflix?

Thursday, January 31, 2019
Talking About Huawei Exposure

Wednesday, January 30, 2019
Another Discrepancy in Reported Numbers

Wednesday, January 30, 2019
Finding Revised Facts: Hertz Edition

Wednesday, January 23, 2019
GE Commercial Aviation Services: Bringing Numbers to Light

Monday, January 21, 2019
Differences in Earnings Releases and 10-Ks

Wednesday, January 16, 2019
The Importance of Textual Analysis

Tuesday, January 8, 2019
A Look at Climate Change Disclosures

Wednesday, January 2, 2019
Quants: Point-in-Time Data for Backtesting

Friday, December 28, 2018
Now Showing: Controls & Procedures

Thursday, December 27, 2018
A Reminder on Non-GAAP Reporting Rules

Monday, December 17, 2018
Researching PG&E’s Wildfire Risk

Wednesday, December 12, 2018
Tracking Brexit Disclosures

Thursday, December 6, 2018
Campbell Soup: Looking Behind the Label

Sunday, December 2, 2018
SEC Comment Letters: The Amazon Example

Wednesday, November 28, 2018
Measuring Big Pharma’s Chemical Dependency

Monday, November 26, 2018
Analysts, Can You Relate? A True Story

Archive  |  Search:
Trends in Cash So Far This Quarter
Monday, November 6, 2017

We’re big fans of cash here at Calcbench. So as third quarter earnings continue to roll in, we decided to visit our Data Query Tool and take a quick peek at trends in cash among the S&P 500 for the last few quarters.

In absolute terms, the numbers are good. The average amount of cash reported among the S&P 500 so far this quarter is $3.71 billion, up 14.9 percent from the year-ago period. Total cash reported so far is $1.35 trillion—not nearly as much as the $1.6 trillion reported in third-quarter 2016, but we still have another 135 companies in the S&P 500 yet to file.

If those latecomers also report cash piles close to the $3.71 billion average we’ve seen so far this quarter, then the Q3 reporting season is going to close with somewhere near $1.8 trillion in cash. That would be the biggest quarterly number we’ve seen in nearly five years. See Figure 1, below.

Now, could all those latecomers still report pitiful cash holdings, and pull that average down? In theory, sure. But for third-quarter 2017 to land somewhere near Q3 2016 levels, with total cash around $1.6 trillion, the remaining companies would need to report cash at much lower levels than we’ve seen so far this quarter—somewhere around $1.88 billion per latecomer. Decide for yourself whether that’s likely to happen, or whether we’re on our way to quarter with cash all over the place.

Cash vs. Assets

Investors do not live by cash alone, however. We also looked at assets reported by the S&P 500, and how that number relates to the cash outlined above. Here the picture is a bit more mixed.

Much like cash, average assets reported so far this quarter are way up: a 25.6 percent increase, from $66.6 billion in third quarter 2016, to $83.7 billion so far this quarter. And total assets reported by the whole group so far is lower than the year-ago period, $30.72 trillion compared to $33.2 trillion. See Figure 2, below.

But again, we still have 130+ companies yet to file their third-quarter 2017 reports. So unless they all drop a stink bomb on Wall Street, assets are going to look impressive this quarter, too.

Lastly, we calculated cash as a percentage of total assets. Here we can see that the percentage is rather volatile from one quarter to the next, but heading decidedly downward in the last 12 months. Figure 3, below.

If cash piles are trending upward in dollar terms, but trending downward as a portion of total assets in percentage terms— that means assets overall are trending upward even faster than cash is.

Is that a good thing? Does it raise other questions about balance sheets overall, and how well companies are putting their assets to work?

Every company probably has its own answers to those questions, and they are answers for you to judge. Calcbench just pulls together the data for you, and lets you see what’s really going on at the single filer and macro-economic levels.

FREE Calcbench Premium
Two Week Trial

Research Financial & Accounting Data Like Never Before. More features and try our Excel add-in. Sign up now to try the Premium Suite.