Two Minute Tips

Work with a spreadsheet and calculator at hand

January 29, 2020

Share this article:

Credit: Pixabay user Pexels

Would you sit to write with only a typewriter and plan to send paper drafts to an editor? Or when using a computer, would you sit to write without a dictionary or reference works within easy reach, whether paper or digital? How about not availing yourself of email or phone to check details and make inquiries?

You wouldn’t dream of doing that. When reporting on business, there is something else you should keep at hand—a spreadsheet and a calculator along with financial references.

Business balances on the twin pillars of numbers and human psychology. It’s the first pillar we’re looking at today. If you don’t have a calculator and spreadsheet at hand, you can’t rightly do the work because there are things you would be unable to check.

An example would be reading an SEC financial filing. It would seem safe to assume that the numbers are tallied correctly (although checking never hurts because someone could have made a mistake in transcription or in a calculation). But that’s only the beginning. One of the most powerful techniques available to a business reporter is to start comparing things that a company doesn’t publicly. I’ve found major companies spending less on R&D over time as a percentage of revenue, seeing shorter active periods of customers, seeing customers suddenly slowing down in payments, and more.

To make life easy, pick up a calculator that does financial functions. If you stray into technology and science, getting one that also has scientific capabilities is easy and worth the extra.

Then there are spreadsheets, as easy to get on your desktop, laptop, or tablet as it is to get into Google Docs if you don’t have something like Microsoft Office 365 loaded on your machine. They can be, I admit, harder to use, but mostly I think that is because of the intricacy of data and analysis that people typically try to do.

You can build your own models, which can be something as simple as your running total of product category sales for a company (I did that with Apple for years) so you can follow the rise and fall over time. Or you might download a company’s financials, pull them into a spread sheet, and calculate additional metrics, like expense categories as a percentage of revenue. Do that for a few leading companies in your beat and you can begin to develop your own industry benchmarks and see where a firm is outside the norm.

Think of calculators and spreadsheets as ways to directly interview the fiscal performance of a company to complement what you hear from corporate officials.

More Like This...

three people sitting at a table reviewing graphs and charts

The ABCs of funding rounds

Someone might have a great idea for a startup, but it’s not going to go anywhere without money. Initially, investors will start a business with their own savings or borrow

three people presenting to a group of executives in an office

Experts’ tips for evaluating startups

Covering startups can be exciting and frustrating all at the same time. The newest billion-dollar startup can become the hottest topic in the business and tech media overnight, and its

Two Minute Tips

Sign up now.
Get one Tuesday.

Every Tuesday we send out a quick-read email with tips for business journalism.

Subscribers also get access to the Tip archive.

Get Two Minute Tips For Business Journalism Delivered To Your Email Every Tuesday

Two Minute Tips

Every Tuesday we send out a quick-read email with tips for business journalism. Sign up now and get one Tuesday.

Our New Look
The Reynolds Center for Business Journalism is starting 2023 with a new look that we hope better illustrates our core mission to provide accurate and authoritative resources about business journalism, in order to help both reporters and news consumers understand the importance of business news and to demystify the sometimes arcane topics it covers.
Businesses, markets, and economies move in cycles – ups and downs – which is why our new logo contains a “candlestick” chart representing increases as well as downturns, and serves as a reminder that volatility is an unavoidable attribute of modern life. But it’s also possible to prepare for volatility by being well informed, and informing the general public to help level the information playing field is the primary goal of business journalism. The Reynolds Center is committed to supporting that goal, which is why the candlestick pattern in our logo merges directly into the name of our founding sponsor, Donald W. Reynolds.
Our new logo comes with a shorter name. Business is borderless, and understanding the global links in supply chains, trade, and flows of funds and people is essential to make sense of our fast-paced, globalized world. So we’re dropping the word “National” from our name and will aim to provide content that is applicable to business news globally.
We hope you like the new look. Best wishes for 2023!