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,
| +197 | Americas M&A League Table Q2 Updated | 79 | 3h |
| +131 | Restructuring: Anti-climactic Experience | 34 | 1d |
| +101 | IB Net Worth / Savings Check | 48 | 32m |
| +91 | Woman who emptied Knicks trashcan on street then stole it was DEI exec, worked at JPMorgan Chase | 24 | 13h |
| +80 | Stop sleeping on UBS - it’s pretty good | 26 | 2h |
| +52 | 2026 VAULT PRESTIGE RANKINGS | 29 | 1d |
| +39 | AI + Financial Modelling | 12 | 1d |
| +28 | Summer before college | 17 | 13h |
| +28 | Hardest interview experiences? | 16 | 22h |
| +26 | Current State of UBS in North America | 8 | 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.
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.
Et facere consequuntur id corrupti officiis quidem laudantium. Ex quis natus perferendis praesentium. Repellendus voluptatem quia ut. Culpa in et sequi fugit. Similique fugiat ad omnis ipsa quis dolor. Laboriosam laboriosam aliquam qui aspernatur.
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...