Financial Modelling Using Excel

Financial Modelling Using Excel

Summary

Location

Location

Malaysia

Duration

Duration

2 Days
Format

Format

Public Class

Public Class

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

  • Introduction & types of financial models
  • Program scope
  • Financial model structure
  • Budgeting & forecasting
  • The budgeting & forecasting process
  • Building revenue & expense drivers
  • Revenue & cost projection
  • Modelling the Income Statement & supporting cost centre sheets
  • Building the headcount & payroll model
  • Projecting the balance sheet
  • 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
  • Understanding price and demand curves
  • Price elasticity of demand computation methods
  • Decisions in price setting
  • Working capital components, ratios & cash conversion cycle
  • Cash flow projection using the direct method
  • Free Cash Flow (FCF)
  • Essential Form Controls & overview
  • Incorporating Form Controls into financial models & sensitivity analysis
  • Using Power Query to extract & consolidate historical data
  • Building forecasting working templates from historical data
  • Building sensitivity analysis into forecast templates
  • 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
  • ROE
  • Equity multiple
  • Peak capital
  • Essential Excel functions in financial modeling- VLOOKUP, SUMIF, SUMIFS, COUNTIF, COUNTIFS, IFERROR, INDEX, MATCH, INDIRECT
  • Utilize macros to automate simple tasks

Trainers

Reviews

Interested In

Financial Modelling Using Excel

Starting From
RM1288
Intake Date
29-30 JULY 2024
,
6-7 AUG 2024
,
3-4 OCT 2024
Class Type
Private, Public

Why Us

Variety of Courses

Variety of Courses

Customizable Class

Customizable Class

Consultants Facilitate

Consultants Facilitate

HRDF Claimable

HRDF Claimable

Professional Certifications

Professional Certifications

Free Chat to Get Quote

Free Chat to Get Quote

Related Courses

Enquire Now

Course Name *
Name *
Email *
Contact No. *
Enquiry For
Company Name *
Job Position *
Message *

Book Now

Course Name: Financial Modelling Using Excel
Duration: 2 Days
Class Type *
Intake Date *
First Name *
Last Name *
Email *
Contact No. *
Pax *
Total Price: RM
0.00

Download Details

Name *
Email *
Contact No. *