Financial Analysis

Duration: 2 days
Workshops:  16-17 Dec 2017
            09-10 Jun 2018
            22-23 Sep 2018

Accurate financial analysis is a fundamental element for company’s growth, strategy and overall success.
In this hands-on comprehensive course, you will learn to use proven analytical tools to analyse financial indicators, evaluate management performance, and allocate resources effectively to improve your company’s profit.

FinanicalAnalysis

Key Modules in this Course

Model Analysis Tools

  • Build assumptions documentation tools.
  • Use the scenario manager
  • Show multiple scenario outcomes simultaneously with one and two-dimensional data tables

Building a Business Case

  • Build business case scenarios
  • Business case study-financial calculations
  • Business case study-scenario analysis

Financial Statements Analysis

  • Revise the contents of the financial statements to suit for management reporting purpose
  • Prepare horizontal and vertical analysis
  • Trend analysis case: YTY (year to year) growth model
  • Prepare common-sized financial statement analysis
  • Prepare comparative financial statement analysis
  • Build DuPont analysis model
  • Evaluate profit margins, asset turnover (efficiency) and leverage
  • Prepare benchmark analysis for company performance
  • Prepare actual vs. budget variance analysis

Operation Analysis

  • Sales analysis: Marketing Effectiveness, Sales Leads, Conversion Rate
  • Cost variance analysis: Price Impact & Volume Impact
  • Human resource analysis: HR acquisition、deployment、performance & compensation、motivation & development
  • Operating cycle & Working capital management
  • Prepare weight analysis for OPEX
  • Company valuation-DCF model
  • Break-even analysis model

Cash Flow Analysis

  • Understand cash flow from operations, investing and financing
  • Prepare ratios and metrics for cash flow analysis
  • Identify patterns of value
  • Understand cash flow performance indicators—profitability, liquidity and solvency
  • Evaluate past performance and project future cash flow

20 Comments

  1. 物超所值!非常实用的课程 老师经验丰富同时讲解的也很好。希望开设更多更好的课程,比如税务,资金之类的!

  2. Great course and fantastic training! I really learned a lot about financial analysis tools, techniques and precess. Looking forward to doing the next course.

  3. Obviously the knowledge and experience gained from this training course is tremendous and fantastic. I would like to highly recommend to take this course.

    Thanks again!

  4. This course is informative and knowledgeable. It is impressed the course is like a big assignment with couple of cases, which are split into different segments with a tight logic for the understandable purpose.

Leave a Reply