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?
| +161 | As Lehman people reconvene at UBS, Barclays needs to hire (2023) | 23 | 1d |
| +149 | Worlds Worst MDs Competition (2026 Edition) | 20 | 14h |
| +136 | Is pay at BofA really that bad? | 65 | 9h |
| +92 | Day at Macquarie | 12 | 2d |
| +91 | Lindsay Clancy - Thoughts from A2 | 21 | 9h |
| +76 | Who Killed Wall Street | 29 | 15m |
| +51 | How bad did I mess up | 10 | 2d |
| +38 | EB (EVR/CVP/LAZ) vs MBB (Bain/BCG) | 16 | 12m |
| +35 | Misrepresented Houston IB | 14 | 3d |
| +29 | No BB RO 2026 | 10 | 4d |
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.
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.
Corrupti est ut nam. Aut ipsum assumenda voluptates et ea amet alias. Voluptatum velit voluptatem ipsam sit recusandae cupiditate commodi.
Odio ducimus vero iure est sed. Quia tempora debitis corporis soluta cupiditate et distinctio inventore. Maiores et nostrum quo itaque explicabo aut quas. Exercitationem et error repellendus sed placeat doloremque repellendus.
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...