Excel in Reporting Business Financial Modeling
September 04 – September 08 \ 2022: Kuwait
September 18 – September 22 \ 2022 : Amman
October 02 – October 06 \ 2022 : Kuwait
October 16 – October 20 \ 2022 : Amman
October 30 – November 03 \ 2022 : Kuwait
November 06 – November 10 \ 2022 : Amman
Introduction
If you want to prepare for a possible career in finance but still want to complete your knowledge of the subject, the Excel Business and Financial Modeling Course is the right option for you.
A Career in Business and Financial Modeling is the highest paying profession all around the world and being able to manage that in MS Excel Business and Financial Modeling will take your skills to a whole new level and will outperform all your competition
IACT Excel Business and Financial Modeling Course is the most comprehensive, dynamic and practical .
It covers several topics that are important for any Professional Excel Financial Modeling Expert
Ü Excel Financial Modeling for Beginners and Advanced Users: Familiarize Yourself with Global Productivity Software 1 i.e MS Excel Business and Financial Modeling
Ü Fundamentals of financial Modeling: financial calculations, NPV, IRR, Depreciation Schedules, time value of money, present and future value of cash flows
Ü Business Analysis: Understand what drives a business, key elements that need to be analyzed and their meaning, the importance of industry cycles, key drivers for starting a business, growth, companies maturing and declining, key drivers for an industry
Objectives
Participants attending the training seminar will:
Ü Master Excel Financial Modeling and its many powerful features
Ü Become one of the best Excel users on your team
Ü Perform routine tasks faster than ever
Ü Generate P&L report from raw data extraction
Ü Create a cash flow statement
Ü Find out how you rate the company
Ü Build a valuation model from scratch
Ü Create models with multiple scenarios
Ü Design professional and good-looking advanced diagrams
Ü Use MS Excel Business and Financial Modeling to create and automate financial metric calculations
Ü Experience Excel data tools such as sorting, filtering, validating data, and importing data
Who Should Attend?
This course is an introduction to financial modelling for those new to the subject. This course assumes a
sound understanding of the structure and composition of financial statements, specifically the Income Statement,
Balance Sheet and Cash Flow Statements.
Course Methodology
The course uses self-assessments and a wide mix of business cases that promote healthy discussions around the importance of managing multiple tasks, deadlines and priorities. Participants will benefit from role plays covering workplace challenges related to handling tasks, deadlines and priorities. They will learn how to deal with conflicts that may arise as a result. Interactive team exercises are also used with each team presenting their findings and comments.
This interactive training course includes the following training methodologies as a percentage of the total tuition hours:
- 30% Lectures, Concepts, Role Play
- 30% Workshops & Work Presentations, Techniques
- 20% Based on Case Studies & Practical Exercises
- 20% Videos, Software & General Discussions
Pre and Post Test
Outline
DAY 1: Excel Tools
Ü Excel Versions
Ü Upgrading to Excel 365 and technical differences between versions. Considerations when building a model for users of different versions.
Ü Conditional Formatting
Ü Creating an automatic variance alert. Using icon sets, colour scales and data bars to add visual interest to model outputs.
Ü Hiding and Grouping
Ü Keep your model tidy and easy to follow by hide unnecessary information or unused parts of the model whilst still following best practice guidelines
Ü Dos and Don’ts for Linking Between Files
Ü Ways to improve model integrity and reduce errors between linked files
DAY 2 :
Financial Modelling Techniques
Ü What Makes a Good Financial Model?
Ü Attributes of a good model such as user-friendly and structural features
Ü Strategies for Reducing Errors
Ü Techniques to employ during the model building process to reduce the potential for formula or logic error
Ü Building Error Checks
Ü Creating in-built, self-balancing error checks and error alerts
Ü Bullet-Proofing your Model
Ü Using worksheet protection to prevent entry, and restricting data entries using data validations. Prevent misuse of your model by restricting incorrect inputs.
Ü What-if Analysis with Goal Seek
Ü Back-solve from a desired formula output to determine a model input using the goal seek Excel tool
Ü Overview of Scenario Analysis Methods
Ü Technical methods of creating scenario and sensitivity analysis in Excel
DAY 3 :
Essential Formulas
Ü Cell Referencing & Named Ranges
Ü Applying absolute and relative cell referencing and understanding its importance in Financial Modelling. Using named ranges for assumptions reference.
Ü Logical Nested Functions
Ü Using IF, OR and AND functions, and nesting these together to create simple but intelligent formulas for use within financial models
Ü Aggregation Functions
Ü Applying the COUNTIF and SUMIF functions to reports and data summaries
Ü Using a VLOOKUP or XLOOKUP Function
Ü Correctly building this much-loved and often over-used Excel function
Ü Tiering Tables
Ü Practical application of one of the more complex and widely used calculations in financial modelling, such as tax calculations and volume break discounting
Ü Using the FORECAST / TREND Function
Ü Hypothetically forecasting future data based on historical trends using simple regression analysis in Excel
Ü Formula Selection
Ü Which formula or tool is most appropriate in which modelling situation?
Ü your Time and Respect Other People’s Agendas
Ü Time and Project Management for Administrators (cont’d) Event Planning and Project Management (Template)
Ü Training Wrap-Up
Ü End of the Course
DAY 4:
Building a Business Case
Ü Case Study: Build an individual business case using a range of financial functions and tools utilising best practice financial modelling techniques
Ü Calculating Staff costs
Ü Modelling with consistent, nested formulas to calculate costs for employees with variable start and end dates, including compounding inflation
Ü Forecasting customer numbers
Ü Calculating customer acquisition numbers from the potential pool of customers with documented assumptions. Mitigate liability by including appropriate caveats and key assumptions.
Ü Modelling market penetration in a business case
Ü Using assumed takeup rates to model market penetration
Ü Forecasting Product Profitability
Ü Assess business case feasibility cashflow forecast
Ü Project Evaluation
Ü Evaluate project feasibility with IRR (Internal Rate of Return), NPV (Net Present Value) and the payback period
DAY 5 :
Analyzing & Presenting your Model
Ü Practical: Create a best, base and worst case scenario on your model. Select from the drop-down box and watch the results change
Ü Scenarios and Sensitivity Analysis
Ü Manual sensitivity analysis, creating drop-down switches for scenario selection. Adjusting inputs variables to impact outcomes.
Ü Model Documentation
Ü Summarizing key assumptions, documentation and source referencing, Writing operation instructions
Ü Presentation of Model Output
Ü Summarizing results and display of findings. Communicate the results of your model clearly and concisely whilst getting the key message across to the audience. Summarizing model data into a presentation
Fees:
The Fee for the seminar, including instruction materials, documentation, lunch, coffee/tea breaks & snack is: 3.750USD$
Schedule:
08:30 – 10:15 First Session
10:15 – 10:30 Coffee Break
10:30 – 12:15 Second Session
12:15 – 12:30 Coffee Break
12:30 – 14:00 Third Session