商务分析全能实战训练

财务分析作为所有财务从业人员为企业提供决策支持的重要手段，也是企业运营管理的重要组成部分。本课程通过实例，剖析澳洲上市公司三大报表，通过各种比例，趋势，对比过去和同行业等手段，来分析收入，成本，利润等业务事项，找出问题的根源，推演解决问题的各种方法。并在此基础上，结合企业的非财务数据，改善企业经营状况。

课程将具体讲述企业招聘时与财务分析相关的常见问题，并全面展示该如何用Star Model进行完整回答，让财务分析成为求职中的闪光点。

透过实例，来step by step的学习澳洲上市公司财务分析的思路和流程，提供练习和指导辅助，快速掌握澳洲上市公司的financial analysis的经验，提供scenario analysis和决策支持。

Part 1：Interpretation of financial statements

· Actual vs Budget vs Forecast vs Last year (Excel model)

· Ratio & trend analysis (Excel model)

· Dupont analysis (Excel model)

Part 2：Interpretation of restructured financial statements

· Restructure Profit and Loss statements (Excel model)

· Ratio & trend analysis (Excel model)

· Dupont analysis (Excel model)

Part 3：Financial analysis and decision making support

· Sales analysis (Excel model), including Tableau demo

· Labour analysis (Excel model)

· Rent analysis (Excel model)

· IT cost analysis (Excel model)

· Inventory analysis (Excel model)

Part 4：KPI Introduction

· Understand company strategy

· Sales KPI: 4 different products and 3 different markets (Excel model)

· Operation KPI including typical non-financial KPIs (Excel model)

Part 5：Evaluate business value

· Evaluate a project (Excel model)

· Evaluate a business value internally (Excel model)

· Evaluate a business value externally (Excel model)

Accounts All-rounder

Accounts Officer/Clerk

Accounts Payable

Accounts Receivable

Bookkeeper

Payroll

Assistant Accountant and

Financial Accountant

等相关岗位会计、财务工作人员

Management Accountant

Financial Analyst

Business Analyst

Commercial Analyst

Financial Planning and Analyst

Finance Business Partner

熟练掌握计算比例，趋势以及关键指标来分析财务报表，从而掌握高级财务人员阅读财务报表的诀窍，透过财务报表分析与透视企业运营状况与经营风险，设计与评估经营改进方案。全面上手澳洲上市公司的财务分析和常见分析思路，进而为进入500M+turnover以上澳洲大型公司的Management Accountant /Financial Analyst岗位，向100k+年薪进军做好准备。