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?
| +433 | Is UBS really that bad? | 77 | 9h |
| +265 | Investment Banking is Divine | 40 | 2d |
| +219 | Another $115bn Mega deal for these banks. Congrats! | 46 | 16h |
| +216 | US 2027 SA IB worried about background check | 53 | 2d |
| +75 | Useless associates | 15 | 28m |
| +73 | Which Offer to Accept: UBS Analyst Role or Part Time Cashier at the Local Taco Bell | 19 | 2m |
| +61 | Roku-Fox Deal - UBS Misses Out on yet another deals after years chasing this deal | 10 | 3h |
| +52 | Differences in Restructuring Teams? | 24 | 12h |
| +44 | FIG Pigeonholes you - is it true? | 15 | 1h |
| +41 | Is Houston SA 28 recruiting already over? | 34 | 2d |
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.
Qui eveniet sed consequuntur cum necessitatibus. Ipsam non sed veniam omnis vel. Est repellat quidem aspernatur porro numquam. Saepe possimus et et et itaque est. Expedita non deleniti blanditiis explicabo optio.
Ea non ea voluptatum quis illum. Et similique ut nulla maxime fugiat dolor eveniet. Magnam debitis ipsam quo. Fugiat ut iure magnam consequatur dolores aperiam et. Animi recusandae occaecati nobis explicabo fugit et ut. Et itaque sed aut quasi possimus sed. Distinctio et eum qui ducimus autem. Similique placeat quibusdam voluptatem.
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...