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

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
Navigating AI Risks and the Ethical Imperatives
13 August 2026
CPD Hours: 7
thumbnail
Consolidation Accounting in Practice : Case Applications and Journal Entries ( 08/26 )
14 August 2026
CPD Hours: 7
thumbnail
A Deeper Look at the new FRS 118 – Presentation and Disclosure in Financial Statements ( 08/26 )
17 August 2026
CPD Hours: 7
thumbnail
Business Analytics & Reporting with Generative AI
18 August 2026
CPD Hours: 7
thumbnail
AI & Automation for Accountants : Bridging Accounting and Technology
21 August 2026
CPD Hours: 7
thumbnail
FRS Overview Part 1 : Applying the Essential Accounting Standards in Real Life
24 August 2026
CPD Hours: 7
thumbnail
GST Reporting 2026: Navigating Compliance in the Changing GST Landscape
25 August 2026
CPD Hours: 7
thumbnail
Audit of Going Concern
27 August 2026
CPD Hours: 3.5
thumbnail
Accounting Standards Updates 2026
7 September 2026
CPD Hours: 7
thumbnail
Using AI in the Audit of Financial Statements
10 September 2026
CPD Hours: 7
thumbnail
Valuation for Financial Reporting: Impairment, Expected Credit Loss and Fair Value Measurement
11 September 2026
CPD Hours: 7
thumbnail
Applied AI for the Future-Ready Accounting & Finance Professionals and Business Managers
16 September 2026
CPD Hours: 7
thumbnail
Accounting, Auditing and Ethical Lessons from Recent Financial Scandals ( 09/26 )
17 September 2026
CPD Hours: 7
thumbnail
Corporate Tax 2026 : Navigating Recent Changes and Managing Compliance Requirements
18 September 2026
CPD Hours: 7
thumbnail
IRAS Audit Spotlight : GST Input Tax
22 September 2026
CPD Hours: 7
thumbnail
Managing Procurement, Contracting & Vendor Fraud Risks : Internal Audit Techniques, Red Flags & the Ethical Dimensions
25 September 2026
CPD Hours: 7
thumbnail
Demystifying the GST Treatment of Reimbursements & Disbursements
7 October 2026
CPD Hours: 7
thumbnail
A Practical Guide to Withholding Tax in Singapore : Compliance, Challenges and Best Practices
15 October 2026
CPD Hours: 7
thumbnail
Navigating Boardroom Dynamics and Ethics: Conflict Resolution for Company Secretaries and Directors
16 October 2026
CPD Hours: 7
thumbnail
A Deeper Look at the new FRS 118 – Presentation and Disclosure in Financial Statements ( 10/26 )
19 October 2026
CPD Hours: 7
thumbnail
Vibe Coding for Accounting & Finance Professionals and Business Managers
21 October 2026
CPD Hours: 7
thumbnail
FRS Overview Part 2 : Applying the Essential Accounting Standards in Real Life
23 October 2026
CPD Hours: 7
thumbnail
The Art of Contract Negotiation: Acquiring the Practical Skills and Avoiding the Common Pitfalls
27 October 2026
CPD Hours: 7
thumbnail
GST Reporting 2026: Navigating Compliance in the Changing GST Landscape ( 11/26 )
12 November 2026
CPD Hours: 7
thumbnail
Navigating AI Risks and the Ethical Imperatives ( 11/26 )
17 November 2026
CPD Hours: 7
thumbnail
GST Treatment for Imported Services and Low-Value Goods
20 November 2026
CPD Hours: 3.5
thumbnail