Training

Advanced Excel + Financial Modelling & Forecasting in Excel

Efficiently build an effective and robust financial model based on real-world financial modelling challenges.

Advanced Excel + Financial Modelling & Forecasting in Excel

Duration: 3 days | 18 hours

Available delivery methods:

Classroom

Efficiently build an effective and robust financial model based on real-world financial modelling challenges.

Course Information

The course aims at equipping delegates with skills to efficiently build an effective and robust financial model based on real-world financial modelling challenges.

Expected Outcome:

Delegates are expected to be able to:

  • Master best practice techniques for Financial Modelling & Forecasting
  • Prepare trusted analysis of commercial outputs with a focus on company valuation
  • Select the most appropriate Excel formula to achieve the desired outcome.

Key areas covered on the course include:

Advanced Data Manipulation Techniques

  • Avoid typing a column index number in VLOOKUP by combining VLOOKUP + MATCH functions
  • Say good-bye to VLOOKUP and hello to INDEX + MATCH for two-way (matrix) lookups, as well as a right- to-left lookup
  • Working with TEXT functions –extract characters from a string, split up one field (e.g. an account code) into several fields; convert improper dates to proper dates in Excel
  • Iterations switch
  • Grouping and ungrouping of data using Outline

Sensitivity Analysis & Modeling in Excel

  • Sensitivity (“What-if”) analysis on models using Data Tables, Goal Seek;

Introduction to Financial Modelling

  • Why are Financial Models used?
  • General Structure and model design

Historical Data

  • Sources of information
  • Presentation of historical data
  • Analysis of Historical Data

Projection Schedules

  • Revenues, Costs
  • Fixed asset, capital expenditure and depreciation expenditure
  • Amortization schedule
  • Working capital and change in working capital schedule
  • Shareholders’ equity schedule
  • Shares outstanding schedule
  • Other long-term items schedule
  • Debt and debt repayment schedule
  • Interest schedule

Income Statement Drivers

  • Revenues, Costs
  • Operating Expenses
  • Other income statement items
  • Income taxes
  • Equity income

Balance Sheet Drivers – Assets

  • Working capital
  • Cash and cash equivalents
  • Accounts receivables, Inventories
  • Fixed assets (PPE, depreciation and net fixed assets)

Balance Sheet Drivers – Liabilities

  • Short-term debt, Accounts payable
  • Deferred taxes, accrued liabilities and other current liabilities
  • Equity

Balancing the Cash Flow Statement

  • Calculating cash flow from operations
  • Calculating cash flow from investing activities
  • Calculating cash flow from financing activities

Prerequisites

 There are no formal prerequisites

 What is the experience of my instructor?

All our Microsoft Excel instructors are confident, with many years of teaching experience.

 What’s included in this course?

3 day’s worth of Instructor-led, practical and interactive training, a course pack including all presentation slides, and a certificate.

Learners taking this course are:

  • Financial Analysts
  • Chief Financial Officers (CFOs)
  • Risk Managers
  • Financial Advisors
  • Traders

What key skills will I gain in this course?

  • Create your own quantitative models
  • Harness the power of spreadsheets to map and predict data
  • Structure your decision-making for optimum results
  • Understand the measurement and management of risk

Do you offer In-house corporate training?

We offer corporate trainings for a minimum number of 6 participant at your preferred venue.

Find out more


Or call us now
+254 20 222 95 66
+254 716 56 88 99
+254 732 56 88 99

 

Interested in our training courses?

Get 20% off!

...on select training bundles.

Our Best Selling Courses

Microsoft Excel - Essentials

Become more effective in your reporting processes. Gain useful data manipulation skills!

Advanced Analysis & Visualization in Excel

Make the process of “Data to Decisions” efficient and cost effective.

Analytics for Finance Professionals in Excel

Drive productivity, efficiency, transparency and lower risk as a Finance professional.

Advanced PowerPoint

For professional, engaging in presentations that yield results.

Microsoft Excel - Intermediate

Become more effective in your reporting processes. Gain useful data manipulation skills!

Report Automation with Excel VBA/Macros

Get ahead of others! Automate the mundane tasks and create stunning reports with greater flexibility.

Microsoft Power BI

Connect, Integrate, Model and Visualize Business Data Reliably!

Microsoft Excel - Advanced

Connect, Integrate, Analyze and Visualize data like a pro!

Advanced Excel + Financial Modelling & Forecasting in Excel

Efficiently build an effective and robust financial model based on real-world financial modelling challenges.

Data Analysis & Visualization in Power BI

Connect, Integrate, Model and Visualize Business Data Reliably!

R for Data Science

Python for Data Science

Are you ready to transform your business?

Contact Us

0716 56 88 99

Accreditation

Sign up for updates

We shall send you occasional updates on new courses and special offers. We respect your privacy and don't spam. You may cancel your subscription at any time. (* = required field)

Get In Touch

First floor, Kampus Mall, University Way

P.O.Box 51269-00100
Nairobi, Kenya

agsdix-smt2-local-phone

+254 20 222 95 66

+254 716 56 88 99
+254 732 56 88 99

Connect with us