Category: Organizational People Management

Building Financial Models with Excel

Building Financial Models with Excel

No Events

When looking at any financial opportunity the ability to perform accurate and realistic analysis is imperative. In today’s ever-changing business environment, the capability to write simple spreadsheets is not enough. You have to be able to incorporate all the “what if” scenarios and stress any proposal to its limits. A well-structured financial model can facilitate and improve the reliability and quality of your decision-making.

Course Objectives

At the end of the course delegates will have a good understanding of:

  • The different types of financial models and when each should be applied
  • Constructing financial models making use of a broad range of Excel methods and techniques
  • Incorporating elements such as risk, sensitivity, optimisation and forecasting into financial models
  • Meaningful management reports and charts for communication

Course Outline

  • Opening and closing Excel files
  • Excel screen menu and standard toolbar
  • Auto fill
  • Moving around a worksheet
  • Moving around the sheets in a workbook
  • Creating files
  • Deleting files and individual sheets
  • Changing column width and row height
  • Entering simple formulas
  • Entering labels
  • Cell referencing
  • Centring titles and merging cells
  • Simple cell formatting
  • Number formats
  • Changing font sizes and colours
  • Copy, cut and pasting cell contents
  • Inserting graphic objects
  • Custom views
  • Previewing worksheets
  • Printing documents and ranges

Our mission is the development of potentials in individuals and organizations in emerging economies. We believe that economies develop when entities within it are performing to their highest potential.

RELATIONSHIP

People matter to us. We are committed to understanding our clients so that we can serve them better. Our ultimate goal is to foster mutually beneficial longterm relationships with each of our clients that is built on trust.

KNOWLEDGE DISSEMINATION

Our faculty members are experts within their fields, and are supported by a network of dynamic back-office staff. We actively encourage collaboration and knowledge sharing, recognizing that winning ideas come from collaborative thinking. With the wealth of knowledge within our teams and our collaborative ethos, we create an atmosphere that is conducive to learning for all our delegates.

Call Me Back

Organizational People Management

Organizational People Management

No Events

Business leaders, of any size work group who, recognize that people are a source of competitive advantage and who want to improve their personal effectiveness in connecting to the workforce with strategic goals to achieve superior business results, are the best fit for this course.

Course Objectives

At the end of the course, delegates will have:

  • Increased confidence in aligning your work group with organizational goals
  • Familiarity with a flexible methodology and set of tools to help you think through organizational alignment and the opportunity to use these tools
  • An increased awareness of when and how to proactively plan for
  • key collaborations with other business leaders over the course of your journey
  • Insights on success factors for implementation
  • Increased proficiency in measuring the effectiveness of your talent strategy
  • An understanding that achieving and maintaining organizational alignment requires continual and deliberate attention in order to quickly adapt to constant change, such as economic conditions and strategic business direction.

Course Outline

  • Strategic Thinker’s Mindset – what it is as well as common obstacles to becoming a strategic thinker and how to overcome them
  • The Three Phases of a Talent Strategy Methodology – test drive their corresponding tools: 1) development(our emphasis in this seminar) 2) Implementation 3) Measurement of results
  • Developing a Talent Strategy – learn the foundation on which a solid talent strategy is built, discover the importance of the customers prospective, and key business processes, conduct
  • a workforce gap analysis, and select and prioritize initiatives that result in peak performance
  • Challenges – you will likely encounter and ways to effectively deal with them
  • Business Problem Solving Application – how to employ the same methodology for solving specific business performance problems

Our mission is the development of potentials in individuals and organizations in emerging economies. We believe that economies develop when entities within it are performing to their highest potential.

RELATIONSHIP

People matter to us. We are committed to understanding our clients so that we can serve them better. Our ultimate goal is to foster mutually beneficial longterm relationships with each of our clients that is built on trust.

KNOWLEDGE DISSEMINATION

Our faculty members are experts within their fields, and are supported by a network of dynamic back-office staff. We actively encourage collaboration and knowledge sharing, recognizing that winning ideas come from collaborative thinking. With the wealth of knowledge within our teams and our collaborative ethos, we create an atmosphere that is conducive to learning for all our delegates.

Call Me Back

Building Financial Models with Excel

Building Financial Models with Excel

No Events

A financial model is a quantitative representation of an organisation’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 organisations and companies use financial models every day to analyse 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 computerised environment in order to improve performance within the organisation.

Course objective

At the end of the course delegates will be able to:

  • 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.
  • Analysing 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 organisation’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

Our mission is the development of potentials in individuals and organizations in emerging economies. We believe that economies develop when entities within it are performing to their highest potential.

RELATIONSHIP

People matter to us. We are committed to understanding our clients so that we can serve them better. Our ultimate goal is to foster mutually beneficial longterm relationships with each of our clients that is built on trust.

KNOWLEDGE DISSEMINATION

Our faculty members are experts within their fields, and are supported by a network of dynamic back-office staff. We actively encourage collaboration and knowledge sharing, recognizing that winning ideas come from collaborative thinking. With the wealth of knowledge within our teams and our collaborative ethos, we create an atmosphere that is conducive to learning for all our delegates.

Call Me Back