The Auditors’ Guide to Impairment and Data Analytics for the Audit of Financial Statements
August 17, 2024
The Auditors’ Guide to Impairment and Data Analytics for the Audit of Financial Statements

Overview

This workshop will share practical and salient updates on key changes in the Singapore Financial Reporting Landscape. The Trainer will also discuss practical ways to manage and mitigate the accounting impact arising from climate change movements.

Practical Examples and Illustrations will be used throughout the workshop to demonstrate the real-life application of these updates and changes.

Impairment of assets and goodwill involve significant judgment. A recurring deficiency in the quality of audit reported by the regulator is auditing the accounting estimates such as impairment analysis. The workshop aims to use the impairment analysis of an individual asset and goodwill relating to a subsidiary (a cash generating unit) to illustrate the development of value-in-use cash flow, the assumptions and the evaluation of the cash flow forecast.

There is a trend in auditors performing data analytics in an audit of financial statements to increase the efficiency and effectiveness of an audit. The Trainer will demonstrate how Excel spreadsheet can be used as a tool to perform data analytics.

Impairment

  • Estimate future cash flows
    • Gather data
    • Develop assumptions
  • Calculate value in use
  • Compare recoverable amount and carrying amount
  • Recognise impairment loss
  • Difference in the value-in-use analysis for an individual asset and for goodwill

Data analytics

  • Downloading accounting data from accounting software
  • Casting
  • Completeness check
  • Sequence check
  • Date format conversion
  • Compare dates
  • Cutoff dates check
  • PV dates and payment dates
  • Round sum figures
  • Weekend journal entries
  • Duplicates check
  • Identify unusual transactions

Participants are encouraged to bring along their laptops ( with MS Excel ) to try out the hands-on exercises. 

This workshop qualifies for:

4.0 hours in Auditing and Assurance Standards, Pronouncements and Methodology (Category 3); and

3.0 hours in Information Technology (Category 5)

Participants are encouraged to bring along their laptops ( with MS Excel ) to try out the hands-on exercises.

This is a hybrid session. You have the option to attend this live in-person or online via Zoom. Please indicate in “Remarks” section in your registration the mode of attendance.

As part of our commitment towards minimizing carbon footprint and contributing to a healthier planet, we will only be issuing the soft copy of the training materials.

The training materials will be emailed to you 2 days before the workshop. Charging points are also available in the training room to charge your digital device.

 

  • Audit Professionals
  • Accountants interested in understanding the practical aspects of impairment of assets and goodwill 
  • Directors and Audit Committee Members

Chee Hay Kheong Daniel
Chee Hay Kheong Daniel

Daniel holds an Honours degree in Accountancy from the National University of Singapore and is a Certified Information Systems Auditor (CISA). He has more than 15 years of experience in the accounting profession, having worked for one of the Big 4 accounting firms both in Singapore and in the United Kingdom. He has also more than 5 years of senior management experience with MNCs, managing their operations in Singapore and Asia.

Daniel is a highly sought-after seminar trainer. He was an Adjunct Professor in the School of Business, Singapore University of Social Sciences and an Adjunct Associate Professor in the Department of Accounting of the NUS Business School. He served as a committee member of both the IT Committee and the Examination Committee of ISCA, and was a Committee member of the Disciplinary Sub-Committee of Accounting and Corporate Regulatory Authority (ACRA).

Next
Practical Insights on the FRS Hot Spots, Common Accounting Lapses and Non-Compliances flagged by the Regulator
thumbnail
Consolidation Accounting in Practice : Case Applications and Journal Entries
21 April 2026
CPD Hours: 7
thumbnail
Designing Anti-fraud Controls to Prevent Waste, Abuse & Misuse of Funds : Lessons from Real-life Lapses and Failures
27 April 2026
CPD Hours: 7
thumbnail
A Practical Guide to FRS Application ( Part 2 )
8 May 2026
CPD Hours: 7
thumbnail
Managing Procurement, Contracting & Vendor Fraud Risks : Internal Audit Techniques, Red Flags & Real-World Lessons
14 May 2026
CPD Hours: 7
thumbnail
A Deeper Look at the new FRS 118 – Presentation and Disclosure in Financial Statements ( 05/26 )
15 May 2026
CPD Hours: 7
thumbnail
Managing a Multigenerational Workforce : Building Inclusive, Collaborative and Future Ready Teams
15 May 2026
CPD Hours: 7
thumbnail
GST Reporting 2026: Navigating Compliance in the Changing GST Landscape
19 May 2026
CPD Hours: 7
thumbnail
GST Treatment for Imported Services and Low-Value Goods
25 May 2026
CPD Hours: 3.5
thumbnail
GST Compliance Risks: Understanding MTF and Applying the Due Diligence Checks to protect your Input Tax Claims
18 June 2026
CPD Hours: 3.5
thumbnail
2026 Corporate Tax Challenges & Updates: Navigating Recent Changes and Managing Compliance Requirements
19 June 2026
CPD Hours: 7
thumbnail
AGO Findings & Prominent Ethical Lapses: Key Learning Points and Ethical Considerations
23 June 2026
CPD Hours: 7
thumbnail
A Deeper Look at the new FRS 118 – Presentation and Disclosure in Financial Statements ( 06/26 )
24 June 2026
CPD Hours: 7
thumbnail
Applied AI for the Future-Ready Accounting & Finance Professionals and Business Managers
25 June 2026
CPD Hours: 7
thumbnail
Accounting Standards Updates 2026
26 June 2026
CPD Hours: 7
thumbnail
Demystifying the Zero-Rating of GST for International Services & Exports
10 July 2026
CPD Hours: 7
thumbnail
Vibe Coding for Accounting & Finance Professionals and Business Managers
13 July 2026
CPD Hours: 7
thumbnail
Auditing Third-party & Outsourcing Fraud Risks: Due Diligence, Contract Integrity & Case-based Red Flags
16 July 2026
CPD Hours: 7
thumbnail
Navigating AI Risks and the Ethical Imperatives
13 August 2026
CPD Hours: 7
thumbnail