a

Lorem ipsum dolor sit amet, conse ctetur adip elit, pellentesque turpis.

Image Alt

Business Financial Modelling and Forecasting

  /  Business Financial Modelling and Forecasting
Loading Events
  • This event has passed.
20 Jan

Business Financial Modelling and Forecasting

January 20 @ 10:00 am - January 24 @ 4:00 pm UTC+0
₦262500

A financial model is a quantitative representation of an organization’s past, present, and future business operations.  Financial models serve as the foundation and basis of standard financial accounting reports, including the Balance Sheet, the Income Statement, and the Statement of Cash Flows. All type of organizations and companies use financial models every day to analyze and plan their business activities. This course will give you a firm understanding of the steps involved in building financial models and you should know how to use Excel to put that understanding to work in the form of a working financial model. This course is designed for managers, accounting managers, auditors and accounting officers both in the public and private sector, who wish to work in a more efficient computerized environment in order to improve performance within the organization.

  • At the end of the course delegates have a better understanding of:
    How to build the Master Budget, the Operating Budget and the Financial Budget
  • Building the consolidated financial statements: Balance Sheet, Income Statement and Cash Flow Statement; and free cash flows
  • Analyzing a financial model by using sensitivity analysis to test the assumptions underlying the financial model, contribution margin analyses to assess the fixed and variable cost elements of an organization’s cost structure, and the financial ratio analysis to measure important financial ratios
  • The Master Budget
  • Overview of Budgets and Financial Models
  • Operating Budget – Assumptions, Sales, and Collections
  • Operating Budget – Cost of Goods Sold, Inventory, and Purchases
  • Operating Budget – Operating Expenses
  • Operating Budget – Income Statement
  • Financial Budget – Capital Budget and Cash Budget
  • Financial Budget – Balance Sheet
  • Financial Statements and Free Cash Flows
  • Consolidated Financial Statements
  • Free Cash Flows and Dashboard
  • Analysis of a Financial Model
  • Sensitivity Analysis
  • Contribution Margin Analysis
  • Financial Ratios Analysis

DAY 1

The Competitive Challenge in the 21st Century

  • Identifying and Managing Stakeholder Needs
  • Business Models and How They are Disrupted
  • An Integrated Approach to Risk Management
  • The Essentials of Business Performance Management

Fundamentals of Financial Modelling

  • Financial Statements Basics
  • Fundamentals of Financial Modelling

DAY 2

Mastering Financial Analysis

  • Building a Financial Ratio Database in Excel
  • Practical Modelling: The Cost-Volume-Profit Relationship
  • Measuring and Improving Return On Investment
  • Measuring and Improving Asset Management Efficiency
  • Measuring and Managing Capital Structure and Risk
  • Practical Modelling: The Effect of Gearing on Shareholders’ Earnings

DAY 3

Improving Financial Forecasting

  • Practical Modelling: Using Excel Statistical Analysis Tools
  • Avoiding Common Forecasting Problems
  • Using Moving Averages to Analyse Time Series Data
  • Using Linear Regression for Sales Trend Analysis
  • Using Excel Solver to Minimise Forecasting Error
  • Using Regression and Correlation to Forecast Costs
  • Practical Modelling: Cash Flow Forecasting

DAY 4

Financial Models to Improve Investment Decision-making

  • Principles of Capital Investment Decision-making
  • Sources and Cost of Business Finance
  • Practical Modelling: Using Excel Discounted Cash Flow Tools
  • Practical Modelling: Capital Investment Analysis
  • Essentials of Business Valuation
  • Practical Modelling: Business Valuation Based on Shareholder Value Added

DAY 5

Managing Risk and Uncertainty

  • Identifying and Analysing Business Risk
  • Probability Based Approach to Decision-making
  • Monte Carlo Simulation
  • Sensitivity Analysis and “what-if” Forecasting
  • Identifying the Key Drivers of Financial Performance
  • Practical Modelling: Key Driver “what-if” Forecast
Course Overview

A financial model is a quantitative representation of an organization’s past, present, and future business operations.  Financial models serve as the foundation and basis of standard financial accounting reports, including the Balance Sheet, the Income Statement, and the Statement of Cash Flows. All type of organizations and companies use financial models every day to analyze and plan their business activities. This course will give you a firm understanding of the steps involved in building financial models and you should know how to use Excel to put that understanding to work in the form of a working financial model. This course is designed for managers, accounting managers, auditors and accounting officers both in the public and private sector, who wish to work in a more efficient computerized environment in order to improve performance within the organization.

Course Objective
  • At the end of the course delegates have a better understanding of:
    How to build the Master Budget, the Operating Budget and the Financial Budget
  • Building the consolidated financial statements: Balance Sheet, Income Statement and Cash Flow Statement; and free cash flows
  • Analyzing a financial model by using sensitivity analysis to test the assumptions underlying the financial model, contribution margin analyses to assess the fixed and variable cost elements of an organization’s cost structure, and the financial ratio analysis to measure important financial ratios
Course Outline
  • The Master Budget
  • Overview of Budgets and Financial Models
  • Operating Budget – Assumptions, Sales, and Collections
  • Operating Budget – Cost of Goods Sold, Inventory, and Purchases
  • Operating Budget – Operating Expenses
  • Operating Budget – Income Statement
  • Financial Budget – Capital Budget and Cash Budget
  • Financial Budget – Balance Sheet
  • Financial Statements and Free Cash Flows
  • Consolidated Financial Statements
  • Free Cash Flows and Dashboard
  • Analysis of a Financial Model
  • Sensitivity Analysis
  • Contribution Margin Analysis
  • Financial Ratios Analysis
Course Schedule

DAY 1

The Competitive Challenge in the 21st Century

  • Identifying and Managing Stakeholder Needs
  • Business Models and How They are Disrupted
  • An Integrated Approach to Risk Management
  • The Essentials of Business Performance Management

Fundamentals of Financial Modelling

  • Financial Statements Basics
  • Fundamentals of Financial Modelling

DAY 2

Mastering Financial Analysis

  • Building a Financial Ratio Database in Excel
  • Practical Modelling: The Cost-Volume-Profit Relationship
  • Measuring and Improving Return On Investment
  • Measuring and Improving Asset Management Efficiency
  • Measuring and Managing Capital Structure and Risk
  • Practical Modelling: The Effect of Gearing on Shareholders’ Earnings

DAY 3

Improving Financial Forecasting

  • Practical Modelling: Using Excel Statistical Analysis Tools
  • Avoiding Common Forecasting Problems
  • Using Moving Averages to Analyse Time Series Data
  • Using Linear Regression for Sales Trend Analysis
  • Using Excel Solver to Minimise Forecasting Error
  • Using Regression and Correlation to Forecast Costs
  • Practical Modelling: Cash Flow Forecasting

DAY 4

Financial Models to Improve Investment Decision-making

  • Principles of Capital Investment Decision-making
  • Sources and Cost of Business Finance
  • Practical Modelling: Using Excel Discounted Cash Flow Tools
  • Practical Modelling: Capital Investment Analysis
  • Essentials of Business Valuation
  • Practical Modelling: Business Valuation Based on Shareholder Value Added

DAY 5

Managing Risk and Uncertainty

  • Identifying and Analysing Business Risk
  • Probability Based Approach to Decision-making
  • Monte Carlo Simulation
  • Sensitivity Analysis and “what-if” Forecasting
  • Identifying the Key Drivers of Financial Performance
  • Practical Modelling: Key Driver “what-if” Forecast

Event Details

Date: January 20 @ 10:00 am - January 24 @ 4:00 pm UTC+0
Time: 10:00 am - 4:00 pm
Venue: Vantage Consulting
Address: 40B, Commercial Avenue, Sabo-Yaba
Organizer Name: Vantage Consulting
Phone: +234 908 599 1852