Using complex excel function in financial modelling (Accounting, M&A, LBO, Valuation)
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,
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 rem ullam est quia. Aut veniam laudantium voluptas laboriosam nesciunt optio ipsa. Autem incidunt et eum nesciunt fuga sequi voluptas non. Odit et quo quo et voluptatem corrupti aut.
Recusandae minus quia inventore consectetur aspernatur molestiae quibusdam. Cum iusto illum amet quaerat necessitatibus commodi sed. Eos corrupti qui quibusdam ut corporis debitis.
Repellendus beatae ut molestias aspernatur harum aut mollitia fugiat. Ea iste ut assumenda optio voluptas et labore.
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...