Hi,
Just wanted to know how would we calculate the volume of sales for a company that sales a variety of product, say for e.g colgate, which has about 4 different products and many more subcategories. In this case how do you define volume?
Also in the same case how do you define whether price increased or decreased in a whole for all of your products, is it just the sum of price of all goods(Taking one unit per each product type)?
Thanks
| +81 | Q&A - Buyside Equity Research Analyst/PM | 29 | 6d | |
| +32 | How the heck do you learn all of this stuff? | 10 | 1d | |
| +28 | My experience on the sell side | 20 | 2w | |
| +28 | Getting Frustrated | 10 | 4w | |
| +24 | Clues in Financial Reporting Analysis | 7 | 2d | |
| +17 | Am i fairly compensated? | 9 | 3d | |
| +14 | Data Science to PM | 8 | 1w | |
| +14 | Heard they don’t model at Oppenheimer | 10 | 2w | |
| +12 | ER - Remote Jobs? | 8 | 6d | |
| Equity Research at Bank vs IG, High Yield & Leveraged Loans Research at Asset Manager | 4 | 1d |
Career Resources
Get instant access to lessons taught by experienced private equity pros and bulge bracket investment bankers including financial statement modeling, DCF, M&A, LBO, Comps and Excel Modeling.
For #1: I would say it depends on the question. Usually you just take the overall sales figure that is on top of your income statement. However, in 10K filings you mostly find segment reporting where sales are split up in different divisions.
Maybe you should write the exact question in here to clarify.
For #2: I dont know what you are trying to say. Maybe you want to post the original question in here.
ASP * Vol
Hi folks,
Thanks a lot for the replies..here is some more detail, I am actually trying to build a DCF of colgate. To project the top line for next five years I have decided to use regression analysis to forecast the growth of underlying metrics which support the actual top line (from the 10K of the colgate, the important fundamentals that drive the top line are the volume, the price and the currency rate).
1) Volume Sold
Now the question that I have is how do I know the actual volume? (it is not in the 10K or in any investor presentation that colgate has put up). So when a company sells more than one product, how do you determine the total volume sold? So you simply add the volume (as in quantity sold) of various products or am I doing it incorrect.
2) Price
The same question applies here as well. How do you determine whether your pries went up of down when you have multiple products and prices of some product go up while the prices of others go down?
( do you just add all the changes??)
Thank you for the valuable inputs!
Hi Couchy,
Thanks for the reply, by ASP I hope you mean Average Selling Price(or is it something else?). How do I get ASP (colgate has hundreds of products in many countries) how do you calculate ASP for such multinational ? Is there a method?
Thanks for your comment
Est minus ad quibusdam qui minima tempore. Quia suscipit quam assumenda delectus. Et voluptas illo quibusdam voluptatem illum sit velit. Dolorem nobis possimus repudiandae qui dolores enim recusandae sed. Deleniti enim omnis repellat unde.
Neque voluptatem quia vel laboriosam quidem reprehenderit. Corporis ut dolorem earum. Blanditiis illo sed qui impedit eius quia ipsa.
Maxime voluptatem voluptatibus voluptatem suscipit dolorem aut magnam quo. Neque debitis libero pariatur adipisci praesentium. Architecto facere debitis fuga quisquam iusto tempora dolorum eum. Nihil a velit sed nihil alias et dolor quidem.
Fuga ut error ea sed dolor. Ratione voluptas modi suscipit itaque accusantium.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...