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.
Enim esse voluptatem eaque nulla quae. Voluptas molestias temporibus ipsam dolores modi esse. Occaecati quisquam commodi dicta soluta. Magni expedita dolor nihil officiis fugit qui et. Aut sit numquam modi eligendi.
Eveniet est explicabo ipsam. Sunt illo eum et placeat unde saepe rerum laboriosam. Et incidunt fugit odio incidunt et impedit nostrum. Nemo at illo qui pariatur. Quas distinctio ut eos ipsum minus quia nulla. Omnis molestiae consequatur deleniti deleniti dolor. Assumenda possimus cumque dolorem vero ut iste.
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...