Excel Financial Modeling: Unlocking Your Financial Potential
If you’re looking to supercharge your financial modeling skills, Info Trek’s “Financial Modeling Using Excel” course is your ticket to Excel excellence. Whether you’re an Officer, Executive, Supervisor, Administrator, Manager, or just someone keen on mastering financial modeling, this program is tailored to elevate your spreadsheet game.
What You'll Gain
In today’s fast-paced business world, being an Excel power-user is a game-changer. This course equips you with essential skills to navigate the complex landscape of financial modeling using Microsoft Excel 2007 and above. Imagine creating intricate financial models, investment projections, and scenario analyses with ease. You’ll learn to build dashboards, employ forecasting techniques, and unlock the potential of Excel functions introduced since 2007.
Elevate Your Career
As you dive into modules like budgeting and forecasting, cash flow analysis, and price setting, you’re not just learning Excel; you’re gaining a competitive edge in the corporate arena. The ability to make data-driven decisions and create financial models is a sought-after skill in every industry. So, whether you’re eyeing a promotion, enhancing your career prospects, or simply adding a powerful tool to your skillset, “Financial Modeling Using Excel” is your pathway to success. It’s not just an Excel course; it’s your stepping stone to financial prowess.
Course Details
Course Code: EXFM; Instructor-led
Audience
This course is designed for Officers, Executives, Supervisors, Administrators, Managers of all levels; and personnel who already know and understand and want to further enhance their Financial Modeling knowledge using Microsoft Excel 2007 and above.
Prerequisites
Basic knowledge of Microsoft Excel (Foundation & Intermediate) is essential with the follow pre-requisites:
- Have attended Microsoft Excel – Foundation & Intermediate Level, OR
- Able to switch between task applications
- Able to perform SUMIF and COUNTIF Functions
- Able to perform IF Functions
- Able to perform NESTED Functions
- Able To define and use Range Names
- Able To use Auto and Advanced Filter
Methodology
This program will be conducted with interactive lectures, PowerPoint presentation, discussion and practical exercise.
Course Objectives
Upon completion of this program, participants should be able to:
- Understanding of a spreadsheet ad its benefits
- Equip with essential skills of effectively utilizing spreadsheet software in a day-to-day business environment
- Be an Excel power-user with the aim of reducing non-value adding tasks.
- Create Financial Models and Investment Models
- Create Scenario Analysis and Dash Boards
- Create Drop-down boxes and scroll-bars for flash analysis
- Understand and apply Forecasting concepts and being able to track forecasting errors
- Apply certain new functions appearing in Excel 2007 onwards
- Perform What If Analysis using:
- Goal Seek
- Solver
- Input Table
- Scenarios
- Record A Macro and assign it to an Object
Â
Outlines
Module 1: Financial Models
- Introduction & types of financial models
- Program scope
- Financial model structure
- Budgeting & forecasting
- The budgeting & forecasting process
Module 2: Building the financial model
- Building revenue & expense drivers
- Revenue & cost projection
- Modelling the Income Statement & supporting cost centre sheets
- Building the headcount & payroll model
- Projecting the balance sheet
Module 3: Forecasting methods
- Qualitative and Quantitative forecasting methods
- Naïve method, Simple Moving Average, Simple Weighted Moving Average, Exponential Smoothing, Correlation, Regression Analysis
- Forecast Sheet function (applies to Excel 2016 & above)
- Multiple Regression Analysis, Coefficient Correlation, Coefficient of Determination
- CORREL, TREND and new iterations of the FORECAST functions
- Tracking forecasting accuracy as a KPI
- Using Excel’s Data Analysis tools- Exponential Smoothing, Moving Average and Regression
Module 4: Price setting for products & services
- Understanding price and demand curves
- Price elasticity of demand computation methods
- Decisions in price setting
Module 5: Cashflow
- Working capital components, ratios & cash conversion cycle
- Cash flow projection using the direct method
- Free Cash Flow (FCF)
Module 6: Form Controls
- Essential Form Controls & overview
- Incorporating Form Controls into financial models & sensitivity analysis
Module 7: Extracting and consolidating historical accounting data
- Using Power Query to extract & consolidate historical data
- Building forecasting working templates from historical data
- Building sensitivity analysis into forecast templates
Module 8: NPV & IRR
- Time value of money & discounted cashflows
- Compounding and Discounting- what’s the difference?
- NPV vs IRR introduction
- Implications of NPV vs IRR in decision-making
Module 9: Investment metrics
- ROE
- Equity multiple
- Peak capital
Module 10: Important Excel knowledge
- Essential Excel functions in financial modeling- VLOOKUP, SUMIF, SUMIFS, COUNTIF, COUNTIFS, IFERROR, INDEX, MATCH, INDIRECT
- Utilize macros to automate simple tasks
