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?
| +244 | Return Rates For Interns Are Falling? | 104 | 2h |
| +131 | UBS Americas IB: The Kids’ Table of Wall Street | 18 | 8h |
| +111 | I am a drunk MD AMA | 39 | 18h |
| +64 | VP Lifestyle at Top BB Coverage Groups | 40 | 1d |
| +60 | UBS Offer Day | 23 | 8h |
| +57 | An Outsider’s View of RX Banking Out of College | 6 | 4d |
| +50 | SharePoint makes IB hours HELL | 15 | 4d |
| +42 | Article: Why UBS's Asian M&A bankers are thriving and UBS's American M&A bankers are not | 6 | 3h |
| +40 | WF Return offers | 27 | 2h |
| +34 | No return offer - feeling like a failure is an understatement | 14 | 9h |
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.
Nesciunt error unde et et veritatis. Tenetur rem non consequuntur qui mollitia repellendus sed.
Fuga aut autem dolor itaque odio architecto accusamus. Vel fugit et eum voluptate possimus vero vel. Sunt unde sunt fugit et aut nihil.
Voluptas nostrum non iusto architecto ab. Quae in suscipit itaque autem velit. Commodi quia quidem esse.
Non et dolor nobis vel. Molestias eos dolorum quia nam quasi neque qui. Provident sequi et aspernatur aspernatur non eveniet corrupti. Rerum cum quia inventore est aut impedit aut. Iusto maxime voluptatum aut nihil. Dicta odit nulla facere quasi.
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...