Business Analytics and Reporting (BAR)

Programme Objectives Good action oriented management reports are the basis for effective and successful businesses. Survey shows that 6 out of 10 CFOs in Singapore say their finance department devotes 50% or more of its time on grunt work of transaction processing and monthly closing activities, thereby hindering the generation of such action-oriented reports. This unique programme shows you how to improve your productivity in reporting & analytical work by combining the various advanced tools and features of Microsoft Excel to fulfill your monthly financial reporting, financial analysis, budgeting and investment appraisal tasks in an automated fashion. At the end of the programme, participants will be able to:

  • Design an appropriate database to support all reporting requirements<
  • Build sustainable excel-based reporting models
  • Develop interactive models for decision making
  • Conceptualise scenarios and what-if analysis for investment evaluation
  • Create value-adding reports through use of visual and graphical skills

Programme Outline Good action oriented management reports are the basis for effective and successful businesses. Survey shows that 6 out of 10 CFOs in Singapore say their finance department devotes 50% or more of its time on grunt work of transaction processing and monthly closing activities, thereby hindering the generation of such action-oriented reports. This unique programme shows you how to improve your productivity in reporting & analytical work by combining the various advanced tools and features of Microsoft Excel to fulfill your monthly financial reporting, financial analysis, budgeting and investment appraisal tasks in an automated fashion. At the end of the programme, participants will be able to:

  • Design an appropriate database to support all reporting requirements
  • Build sustainable excel-based reporting models
  • Develop interactive models for decision making
  • Conceptualise scenarios and what-if analysis for investment evaluation
  • Create value-adding reports through use of visual and graphical skills

CPD hours: 24 Fee: CRA members AU$2400 Non-members AU$3800 Presenter: Mr. Markus Lion, FCCA, CPA, CRA Mr. Lion has extensive experience working within the financial markets sector in Asia. He has deep technical knowledge covering listed companies, multinationals, initial public offerings and mergers and acquisitions due diligence gained over 18 years at PricewaterhouseCoopers. He was also the CFO of one of the largest financial institutions in Singapore. He is both a Fellow Chartered Accountant (FCA) and Fellow Certified Public Accountant (FCPA) and has provided advisory services to many public listed companies, multinationals and government-linked companies on the development of financial reporting standards, corporate governance and risk management, and changes in regulatory environment.

Register