From the course: Corporate Financial Statement Analysis
Join today to access over 25,200 courses taught by industry experts.
Use AI to compute key profitability ratios
From the course: Corporate Financial Statement Analysis
Use AI to compute key profitability ratios
An important element of financial statement analysis is looking at trends. For example, it is useful for me to know that for the year ended January 31st, 2025, Walmart sales had increased by 5.1% from the year before, but it would even be more useful if I could put that growth rate in context. What had Walmart sales increases been in recent years? Sure, it would be nice to see that trend, but generating those trends involves a lot of data capture and computation. So I asked ChatGPT this question, what are the annual sales growth rates for Walmart for the past 30 years? And then I sat back and relaxed for a minute or so, no opening up a spreadsheet, no scouring through 30 years of Walmart 10K filings in the SEC archives, no copying or worse typing those annual numbers into my spreadsheet. Nope, I just waited for ChatGPT to do all that for me. Now, I didn't quite get the full 30 years of growth rate that I had asked for, I only got 28. This is because the online SEC financial statement…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.