This recorded webinar will take you through some practical examples and provide a reusable model for the calculation of FIFO.
Description
Have you ever tried to calculate FIFO using an Excel Spreadsheet? It would be one of the more difficult tasks in an Excel spreadsheet! This webinar will take you through some practical examples and provide a reusable model for the calculation of FIFO.
Key topics:
• Generate a FIFO model which can be used in a range of real life situations
• Address some of the complexities faced when building a FIFO model in Excel
• Produce flexible VBA code to accomplish this common stock or inventory task
Learning objectives
• Gain an understanding of FIFO models in Excel
• Work through detailed tasks to test your knowledge
• Build models to calculate FIFO in Excel
Audience
Professionals working in SME or Corporate entities in specialist or analyst and mid-level career roles working in job functions such as external reporting, financial control and management accounting.