Estimating COGS/SG&A from EBITDA %
Was only given EBITDA % for a 3 statement + DCF model. How to estimate COGS and SG&A % given this? What is a reasonable assumption for this for a tech company?
Can you list everything that is given?
if you need to estimate bottomline numbers, you could theoretically start directly at EBITDA after all opex. But need some more info and the actual question, to figure out what to do based on what is given.
It's a model template given to me to fill out, but I do already have Interest, Tax, and Depreciation. However, on the prefilled model, it has Revenue, COGS, and Gross Margin listed on the blank Income Statement, along with then SG&A, EBITDA, and Net Income. Do you think I could just delete the COGS, Gross Margin, and SG&A cells and just find Net Income with EBITDA? I'm only concerned since COGS & SG&A are listed on the model template. I can also email and ask though
I just saw your comment - probably posted instead of replying on mine.
if you don’t need cogs and sg&a separately, I would just put it as total operating expense if only EBITDA margin is given.
so (1 - EBITDA margin) * Revenue would be the OpEx number.
if you don’t need gross profit and margins, no need to try to estimate it unless they specify that you have to or some point in the model, you specifically need to for some reason.
Qui illum in nihil doloribus. Optio reiciendis velit odit voluptas non doloribus. Voluptatem dolore deleniti et veritatis dolor.
Quisquam quos quia eum facere doloribus saepe. Est magni reiciendis blanditiis sunt non quod in voluptate. Optio debitis aut et veritatis sed a ad. Odit adipisci exercitationem consequatur voluptate nulla dolorem id. Nisi quia ipsa et. Voluptas nisi dolor quis dolores.
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...