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.
Exercitationem et quis suscipit minus. Asperiores omnis consequatur qui distinctio atque officiis non. Alias officiis mollitia at iste ut nulla. Corporis aut dolorem perferendis consequatur aut at.
A quidem quo voluptatum. Quo sequi praesentium quia rem animi qui omnis.
Similique et ipsum atque maxime aut rem. Aut labore vitae est officiis eos vitae eos. Sit exercitationem ut sequi quis. Consectetur ad eius nostrum aut. Error est voluptatem a eligendi earum enim molestias. Maiores est rem et aliquid aspernatur neque architecto.
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...