Lsnnmn1drmel6irmlzey

商务分析全能实战训练

微信扫描下方二维码报名付款,立减$20!

   视频介绍

课程简介

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

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

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

实战操作

  • 提供16个上市公司真实财务分析财务模型
  • 详解3种报表分析方法
  • 提供5种常见财务分析思路

课程内容

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+年薪进军做好准备。


Your Instructor


Jason Liu
Jason Liu

澳洲最大医疗上市公司Finance Manager

高级财务模型研发、应用掌门人。超过十年的澳洲本地上市公司财务与管理经验。


Course Curriculum


  课程视频
Available in days
days after you enroll
  课件
Available in days
days after you enroll

Frequently Asked Questions


When does the course start and finish?
The course starts now and never ends! It is a completely self-paced online course - you decide when you start and when you finish.
How long do I have access to the course?
How does lifetime access sound? After enrolling, you have unlimited access to this course for as long as you like - across any and all devices you own.
What if I am unhappy with the course?
We would never want you to be unhappy! If you are unsatisfied with your purchase, contact us in the first 30 days and we will give you a full refund.

Get started now!