📂FA/MA必修课|Financial Analysis财务分析模型建立与评估

2017年02月15日 Seed职业培训


Financial Analysis

weekend 18th & 19th February 2017 

Melbourne (face-to-face)


An accurate financial analysis is the 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.

Key Modules Covered in the Course

Model Analysis Tools

- Build assumptions documentation tools.
- Show multiple scenario outcomes simultaneously with one and two-dimensional data tables
- Automatically highlight selected scenarios using complex conditional formatting
- Learn to use the Scenario Manager
- Learn to build manual scenario
- Learn to protect your model

Building a Business Case

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

How to Measure Management Performance

- Build DuPont analysis model
- Evaluate profit margins, asset turnover (efficiency) and leverage
- Evaluate past performance and project future outcomes
- Prepare benchmark analysis for company performance
- Trend analysis case: YTY (year to year) growth model
- Prepare horizontal and vertical analysis
- Prepare actual vs. budget variance analysis
- Prepare per unit analysis for payroll cost

How to Use 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

How to Interpret and Evaluate Financial Information

- Revise the contents of the financial statements to suit for management reporting purpose
- Prepare common-sized financial statement analysis
- Prepare comparative financial statement analysis
- Prepare weight analysis for OPEX
- Learn managing capital model
- Learn breakeven analysis model
过往学员反馈:




收藏 已赞