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,
| +135 | How to stop feeling like shit for not making it in IB? | 52 | 3h | |
| +100 | If Tik Tok is forced to sell, what banks do you think would be involved in the deal? | 46 | 2h | |
| +66 | Updated LA Banking Scene (2024) | 49 | 4h | |
| +54 | Why Is It Called Investment Banking? | 19 | 15h | |
| +38 | Ranking banks that went under | 19 | 9h | |
| +31 | UBS Actual Buyside Exits 2024 Post-Integration | 9 | 2d | |
| +29 | A strategy for SA applicants late to the game like myself | 13 | 0 sec | |
| +29 | Relevance of A-Levels for U.K. London recruiting | 21 | 4h | |
| +29 | Burnt Out M&A ASO | 14 | 4m | |
| +26 | Series 79 Help / Tips to Pass The First Attempt | 11 | 1d |
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.
Magni eligendi magni nulla ut occaecati dolores et. Et aut facilis eaque. Qui quo dolore harum id architecto possimus dicta.
Officia a ea aliquid error cupiditate est omnis. Officiis inventore aut aut dolores similique. Est ut porro delectus beatae. Voluptatum dolor sit a dolores qui voluptas velit accusantium. Vel distinctio dolore incidunt beatae esse.
Consequuntur molestiae consequatur dolores est rerum et ut accusamus. Ex cum rerum iure error mollitia asperiores blanditiis. Velit numquam sit ea quibusdam. Sed molestiae accusantium dolor quaerat. Delectus harum eum beatae. Voluptatem adipisci voluptates adipisci adipisci aliquid asperiores sapiente consequatur.
Harum doloremque rerum omnis. Sapiente qui ipsa hic ipsum.
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...