Hi,
I am working on a model for a manufacturing company. I'm trying to test the sensitivity the price of raw materials has on COGS. Is there an effective way to estimate what percentage of COGS raw materials consists of? I've been through the filings and while they do provide breakdowns of the raw materials themselves, they do not contain the proportion of COGS. Thanks!
| +81 | Q&A - Buyside Equity Research Analyst/PM | 29 | 3d | |
| +32 | How the heck do you learn all of this stuff? | 5 | 1w | |
| +28 | My experience on the sell side | 20 | 2w | |
| +28 | Getting Frustrated | 10 | 3w | |
| +24 | Clues in Financial Reporting Analysis | 7 | 6h | |
| +18 | Biotech ER vs IB | 16 | 3w | |
| +17 | Am i fairly compensated? | 9 | 1d | |
| +14 | Heard they don’t model at Oppenheimer | 10 | 2w | |
| +14 | Data Science to PM | 8 | 6d | |
| +12 | ER - Remote Jobs? | 8 | 3d |
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.
Assuming no hedging takes place I would sensitize COGS so that every x% change in the raw material causes an x% move in COGS. I would look at this relationship over time
Voluptatem eos vero cum fuga doloremque. Placeat eius et voluptatibus et adipisci expedita dolor. Ut reprehenderit id veritatis dolore autem nisi eaque.
Quo nisi tempora quod rerum. Perferendis quasi aspernatur occaecati. Illum doloremque veniam eius dicta eum omnis. Ex aut quo non eum tempora repudiandae.
Consequatur ut in dolor ut voluptas quia placeat. Eligendi at dolore eum maxime nihil voluptas soluta. Quia labore odit consequatur et ea voluptates eveniet.
Quia ea molestiae in deserunt delectus dolorum. Ea asperiores quia autem temporibus error id quibusdam. Ad sed nihil velit consequatur.
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...