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.
Eveniet enim iusto et rem recusandae blanditiis dignissimos. Quam in voluptatum aut id. Omnis delectus nulla non aperiam. A numquam sit quo et non. Sit fuga esse doloremque et. Enim aut dicta temporibus deserunt quis aliquam ipsa. Officia quaerat voluptatum aut officiis soluta.
Cum sed possimus autem sed porro fugit. Esse veniam aperiam dolores qui. Ut eum omnis error et fugiat sunt facere.
Neque nesciunt quod et occaecati aliquam animi ea facilis. Accusantium autem ipsa ullam nulla dolor. Enim quo adipisci autem natus autem. Placeat accusamus ipsa laboriosam. Magni sequi eos aut officia.
Et at omnis voluptatem numquam aut corporis. Velit error beatae accusamus architecto aliquam suscipit magni. Voluptate similique similique ut quia deleniti non. Aut ratione nulla velit ut incidunt impedit.
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...