How to compare companies' financials side by side in Google Sheets
A comparison table puts several companies' numbers in one view: tickers down the side, measures across the top. The one thing to watch is that companies' fiscal years end in different months.
Fiscal years don't line up
"Fiscal 2025" means a different period for each company. Microsoft's ended in June 2025, Apple's in September 2025 and Nvidia's in January 2025. Show the fiscal year end next to each row so the reader can see it.
=FILING("NVDA", "revenue", 2025, "period end")
returns 2025-01-26, and =FILING("NVDA", "revenue", 2025) returns 130,497,000,000.
Lay it out once, copy it down
Put tickers in column A and the AsFiled line names in a row above the headers, then use one formula for the whole table:
=FILING($A8, C$6, $B$3) / 1000000
Here A8 is the ticker, C6 the line name (such as revenue or operating income) and B3 the fiscal year. Ratios such as operating margin are then ordinary formulas over those cells. The free compare companies template is set up this way for six companies.
Try it without writing anything
Our free Google Sheets templates already contain these formulas. Make a copy, type a ticker, and the numbers fill in.
Free templates · Guides · AsFiled Pro · Terms · Privacy · Refunds · Support
AsFiled is made by Eagle Eye Insights LLC. Numbers come from companies' own filings with the U.S. Securities and Exchange Commission; AsFiled is not affiliated with the SEC.