Understanding the Financial Statements of CTI Logistics

After exploring the powerful ideas behind the accounting model in my earlier posts, I have now completed the task of restating the financial history of CTI Logistics Limited into my unit spreadsheet. This process was a significant 'learning by doing' moment for me. As I moved four years of data from the annual reports into the spreadsheet, I stopped seeing the numbers as just static 'answers' and started seeing them as a dual representation of the firm’s resources and obligations. By categorising Assets, Liabilities, and Equity from 2022 through 2025, I’ve been able to see the 'Accounting Equation' in action, providing a clear, balanced view of how CTI has created and managed value over the last several years.

CTI Logistics - Spreadsheet.xlsx

Download XLSX • 47KB

Please see above for my completed spreadsheet and would truly value any feedback you might have. I am particularly interested to hear how you found the process of restating your 'Operating Cash Flow' compared to your 'Net Profit'? Did you run into any specific hurdles with your company's categorisations, or did your accounting equation balance on the first go? Please leave a comment below with your thoughts or a link to your own data—I am looking forward to seeing how everyone has tackled their financial statements!