Episode 78: Trend and Comparative Analysis (The Five-Year Story)

Hey! I'd love to hear your thoughts, send me a voice note.Episode SummaryThis episode puts the analytical tools from our entire company analysis season into active, multi-year motion. While looking at a single year of financial statements is a common retail habit, we expose why a single year is merely an isolated data point that can mask severe corporate decay. Using our five-episode running case study of Meridian Tool Works, we show how a seemingly decent single year—featuring $200 million in revenue and $18 million in net income—actually hides a structural collapse when laid out across a five-year horizon.We deconstruct trend (horizontal) analysis, which tracks the direction, acceleration, and divergence of specific line items over a standard five-year period. By analyzing Meridian's revenue growth, we reveal a classic pattern of deceleration—where sales growth slowed from fifteen percent down to eight percent year-over-year. Simultaneously, we track Meridian's gross margin, which contracted from forty-two percent to thirty-five percent, falling every single year without exception. This consistent, multi-year margin compression reveals a company desperately competing on price—buying decelerating revenue by cutting prices and sacrificing profitability.Most importantly, we track the dangerous divergence on Meridian's balance sheet. While revenue grew by fifty-four percent over five years, its accounts receivable surged by a hundred and forty-four percent, and its inventory ballooned by a hundred and seventy-three percent. By introducing common-size (vertical) analysis—which converts every financial line item into a percentage of revenue or assets—we show that Meridian's receivables jumped from seven percent to eleven percent of sales, proving that they are extending looser credit terms to cash-strapped customers to prop up their top-line figures. This massive working capital drain had to be funded, explaining why Meridian's debt climbed by a hundred and thirty-four percent over the same period. Finally, we cover the frameworks of comparative analysis, explaining how to select an honest peer group on SEDAR+ and warning how survivorship bias systematically flatters industry averages.Disclaimer This show provides educational content and does not constitute financial, legal, or tax advice. Speakers are not registered to advise you on securities; please consult a licensed professional or accountant for your personal situation.