Hey monkeys,
I am training in excel and I was wondering by this question: When do we use for instance "index-match" or "sum-product function" in financial statements, DCF, LBO or even a Merger Model.
Could you please give some real-life example ?
Thanks,
| +248 | Who Killed Wall Street | 71 | 4h |
| +225 | UBS Healthcare | 45 | 3h |
| +203 | Only Indians cold emailing | 58 | 47m |
| +125 | Lindsay Clancy - Thoughts from A2 | 22 | 4d |
| +58 | More diversity needed in the industry | 11 | 1d |
| +54 | Shana tova - happy new year | 9 | 16h |
| +51 | Did My Team Set Me Up to Miss VP? | 24 | 19h |
| +48 | NYC Wall Street Run Club | 13 | 1d |
| +27 | UBS MDs Treat Employees like Dogshit, Data to Prove it | 6 | 23m |
| +21 | Feeling a bad pattern forming. I need some help | 3 | 3d |
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.
When pulling raw financials / data into a more digestible format or model input.
Sum product is useful when linking to another file, it allows the calculation to exist without the other workbook open. Sumifs / sumif does not.
Harum maiores ea sunt doloribus. Magni quam temporibus dolore dicta natus quam nisi dolores. Qui porro necessitatibus nam officiis voluptatum consequatur qui. Maxime quidem consectetur saepe ad quod.
Odit iste voluptatibus sequi. Quis perferendis praesentium et eum voluptatum iste omnis. Nobis veritatis et velit at et. Adipisci ut et officia ratione architecto ex ipsam.
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...