05-25-2025, 01:02 PM
What Is This
Attached to this thread is a copy of Packaging Corporation of America (PKG) analysis spreadsheet. It is created in LibreOffice (https://www.libreoffice.org/), an open source software package that is compatible with Microsoft Office/Office 365. The format is Open Document Format (ODF) which Microsoft Excel can open natively. You shouldn't see much difference except for any formatting glitches in the translation. If you want to look, I recommend downloading the spreadsheet to your computer and opening it from there as there may be some issues with your browser and the data format passed to Excel.
Once it is open, you can create your own graphs or add your own statistics to supplement the data that is already there. I've tried to include the most common ones.
For more details on what and why I'm doing this, please go to the original post in this series for Sonoco Corporation.
Disclaimers:
Attached to this thread is a copy of Packaging Corporation of America (PKG) analysis spreadsheet. It is created in LibreOffice (https://www.libreoffice.org/), an open source software package that is compatible with Microsoft Office/Office 365. The format is Open Document Format (ODF) which Microsoft Excel can open natively. You shouldn't see much difference except for any formatting glitches in the translation. If you want to look, I recommend downloading the spreadsheet to your computer and opening it from there as there may be some issues with your browser and the data format passed to Excel.
Once it is open, you can create your own graphs or add your own statistics to supplement the data that is already there. I've tried to include the most common ones.
For more details on what and why I'm doing this, please go to the original post in this series for Sonoco Corporation.
Disclaimers:
- I can't guarantee every number is correct. After looking through a ton of pdf files and hand copying data, errors are bound to creep in. If you find any errors, feel free to let me know about them so I can correct it.
- Sometimes data from a prior year is restated in a following document due to accounting rule changes, data changing or clarified through the reorganization process, etc. When I enter it in the spreadsheet, I generally use the numbers published in the original data for that year. I DO NOT go back and modify prior data since it is my opinion that the pricing of a company's stock is dependent on the data that was available at the time it was published.
- I am not a financial planner nor a degreed accountant so any misstatement or calculation of statistics are as I best understand it. Often statistics can be calculated in several different ways depending on how that data is being used. I've used Investopedia extensively to double check my calculations using the data specifically available to me and focusing on the investment viewpoint.
- When a company is going through some financial hardship or reorganization, some of the numbers don't make any sense; i.e., a negative P/E ratio or ROE. Other rating services usually mark it as "Not Measurable" or set it to zero. I will usually leave it as calculated so I can judge how drastic the change is from the norm. You can mark these fields zero (0) or NM (Not Measurable) and the statistics should adjust if you desire.
- Do not use this information as the sole source to make investment decisions. I highly recommend you at least skim a couple years of annual reports to become familiar with the company. I make no guarantees along with all the other disclaimers other organizations usually list.
=====
“While the dividend itself is merely a rearrangement of equity, over time it's more like owning an apple tree. The tree grows the apples back again and again and again, and the theoretical value of the tree doesn't change just because of when the apples are about to fall.” - earthtodan
“While the dividend itself is merely a rearrangement of equity, over time it's more like owning an apple tree. The tree grows the apples back again and again and again, and the theoretical value of the tree doesn't change just because of when the apples are about to fall.” - earthtodan