Financial Modeling Using Excel | IT Training & Certification | Info Trek
Respect Your Dreams
Follow through on your goals with courses

Financial Modeling Using Excel

Location

Format What’s this?
Starting From
RM 1288.00
  1. 2 Day with 08 hours per day
  1. Mon 29 Nov 09:00 - Tue 30 Nov 17:00
  1. HRDF SBL Claimable
  2. Certificate of Attendance available
  1. 2 Days
  1. All of our private classes are customized to your organization's needs.
  2. Click on the button below to send us your details and you will be contacted shortly.
Request more information

Inquiry for: Myself    My Company

By providing your contact details, you agree to our Privacy Policy

 

 

 

Thank You

Our learning consultant will get back to you in 1 business day

Financial Modeling Using Excel

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, discussions, and practical exercises

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:

o Goal Seek

o Solver

o Input Table

o Scenarios

• Record A Macro and assign it to an Object


Expand All

Modules

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


Vincent Chin Yuen Choon

Vincent Chin Yuen Choon

Read More

Course Reviews

No Remarks

0

0 Ratings