Course Detail(A189v : Deferred Tax Computation using Excel Spreadsheet (Synchronous e-learning))

SkillsFuture Credit, UTAP Funding

A189v : Deferred Tax Computation using Excel Spreadsheet (Synchronous e-learning)

7.00 CPE Hours (Category 1)
Live Webinar

This session is delivered via live webinar (zoom platform).

Introduction
Setting up deferred tax computation lead schedule and supporting working papers for “temporary difference approach” is inherently more complex that “timing different approach”. The former is based on the difference between accounting balance sheet and tax balance sheet while the later is based on accounting profit or loss and tax profit or loss. FRS12/IAS12 requires several steps in determining deferred tax information, first is the construction of a tax balance sheet that involved the determination of ‘tax base’ for each asset and liability recognised in the accounting balance sheet in order to calculate taxable or deductible temporary differences. This is followed by the recognition and measurement of deferred tax assets or deferred tax liabilities, and final hurdle is the presentation and disclosure of deferred tax information in the financial statements. Each of these steps does pose significant challenges to practicing accountants.
 
Programme Objectives
There are two main objectives, first is to provide a systematic approach to the computation of deferred tax information in order to enhance your skills of applying the fundamental principles of FRS12/IAS12. The second is to provide practical guidance on how to use spreadsheet to facilitate the complex task of deferred tax computation based on “balance sheet liability approach”
 
The seminar achieved the above objectives by:
1st       Honing your knowledge in the fundamental principles of FRS12/IAS12

  •  providing step-by-step guide on how the principles of deferred taxation are applied in practice
  • using case study approach to explain the complex technical requirements of the Standard

2nd     Show you how to design deferred tax computation format using spreadsheet

  • Designing a master deferred tax computation lead schedule, supporting schedules and working papers
  • How to incorporate the spreadsheet working papers to facilitate the complex disclosure requirements

Programme Outline

History, Development and objective of Deferred Taxation

  • The difference between deferral method and liability method
  • Timing difference method Versus temporary difference method
  • The concept of future tax consequences

 
Understanding and Determining Tax Base of Assets and Liabilities

  • Non-current assets: assets with capital allowance and those without
  • Current assets: inventories, receivables, prepayments, cash
  • Current liabilities: payables, accruals, deferred income
  • Non-current liabilities: long-term borrowings

 
Recognition of Deferred Tax Assets and Liabilities

  • The four practical steps of recognising deferred tax assets and liabilities
  • Determining deductible temporary difference and taxable temporary difference
  • Accounting for deferred tax liability and asset arising from initial recognition

 
Measurement of Deferred Tax Assets and Deferred Tax Liabilities

  • Determining tax rate enacted and substantively enacted
  • Manner of recovery or settlement of assets and liabilities

 
Presentation and Disclosure

  • Presenting deferred tax in profit and loss and other comprehensive income
  • Presenting deferred tax assets and liabilities in statement of financial position
  • Disclosure of accounting policies, notes to support deferred tax expense/income and deferred tax assets and liabilities
  • Designing working papers to facilitate quantitative disclosure requirements

 
Computation Format Using Spreadsheet

  • A comprehensive case study on how to design and use spreadsheet for computing deferred taxation

 
Pre-requisites

Please take note of the following admission requirements:

  • Trainings will be conducted on Zoom platform, thus video camera and microphone are compulsory
  • Mandatory for video camera to be turned on throughout the course
  • Display your official name (as per NRIC) in Zoom, to facilitate attendance taking


Training Methodology

Lecture style, with practical illustrations, technical flow-charts, conceptual “mind maps” and interactive discussions. 

Closing Date for Registration

1 week before programme or until full enrolment

Intended For

This programme is suitable for all Finance Professionals, Audit Professionals, Members of Audit Committee, Finance Directors and Regulators. Those who are keen on attending a practical course that examines the use of spreadsheet to determine deferred tax assets and liabilities based on balance sheet liability method are welcome to attend.

NOTE: Participants are required to bring their own laptop installed with Mocrosoft Office 2016 and above. 

Competency Mapping

Category 1 = 7.00 Hours

Schedule & Fees

Date & Time

18 Nov 2024 (9:00 AM - 5:00 PM)

Fee (inclusive of GST)

For Members: $ 318.28
For Non-Members: $ 382.59

Programme Facilitator(s)

Danny Tan

Venue

Online Classroom in or outside of
Singapore

Testimonial

Funding

1] SkillsFuture Credit (SFC)
Funding Period: Until 07 Jan 2025
Course Reference Number: TGS-2020501119

All Singaporeans aged 25 and above will receive an opening credit of S$500 from the government. You may wish to use your SFC to pay for partial/full ISCA course fees. 

On 1 Oct 2020, the Government provided a one-off SkillsFuture Credit Top-up of $500 for all eligible Singaporeans aged 25 or above by 31 Dec 2020. Singaporeans aged 40 to 60 by 31 Dec 2020 will also receive an Additional SkillsFuture Credit (Mid-Career Support) of $500 which can be used for courses under: (i) SGUnited Skills Programme, (ii) SGUnited Mid-Career Pathways Programme – Company Training, and (iii) Career Transition Programmes. This additional SFC (Mid-Career Support) is NOT applicable for use on ISCA courses. (For more information on the SFC scheme, please visit www.myskillsfuture.gov.sg)

If you wish to enrol for the course with SFC Funding, please proceed with the following steps:

Failure to submit claim application and obtain necessary approval before the course start date will result in topping up of the SFC indicated for use. Please note that there will be an administrative fee of $43.20 for any revision of invoice.

 

2] NTUC Union Training Assistance Programme (UTAP)
UTAP (Union Training Assistance Programme) is an individual skills upgrading account for NTUC members.

To find out more on the UTAP funding and support validity period please click here.

Should you have queries on the funding scheme, you can email to UTAP@e2i.com.sg or call NTUC Membership Hotline at 6213-8008

 

Programme Facilitator(s)


Danny Tan
 

Danny is a consultant providing continuing professional development training for the accountancy profession as well as providing consultancy services on financial reporting technical matters. He has over 35 years’ experience in public practice, commerce, and industry. He was trained and qualified as a professional accountant with a firm in London. Danny conducts courses in IFRS and IPSAS in Europe, Middle East, and Asia Pacific. He is currently a member of the Small and Medium-size Entities Implementation Group (SMEIG) that consider the need to amend IFRS for SMEs Accounting Standard and make recommendation to the Board of IASB. He is also a project manager for the MASB. He currently holds several advisory roles in financial reporting technical matters.

 

Danny holds an Honours Degree in Economics (major in finance and investment) from Manchester Metropolitan University (UK), MBA from Heriot-Watt University (UK) and Master in Advance Business Practice from University of South Australia. He is a fellow member of The Chartered Instituted of Management Accountants, and The Association of Chartered Certified Accountants. He is also a member of The Institute of Singapore Chartered Accountants, Malaysian Institute of Accountants and an associate member of Chartered Tax Institute of Malaysia.

This session is delivered via live webinar (zoom platform).

Introduction
Setting up deferred tax computation lead schedule and supporting working papers for “temporary difference approach” is inherently more complex that “timing different approach”. The former is based on the difference between accounting balance sheet and tax balance sheet while the later is based on accounting profit or loss and tax profit or loss. FRS12/IAS12 requires several steps in determining deferred tax information, first is the construction of a tax balance sheet that involved the determination of ‘tax base’ for each asset and liability recognised in the accounting balance sheet in order to calculate taxable or deductible temporary differences. This is followed by the recognition and measurement of deferred tax assets or deferred tax liabilities, and final hurdle is the presentation and disclosure of deferred tax information in the financial statements. Each of these steps does pose significant challenges to practicing accountants.
 
Programme Objectives
There are two main objectives, first is to provide a systematic approach to the computation of deferred tax information in order to enhance your skills of applying the fundamental principles of FRS12/IAS12. The second is to provide practical guidance on how to use spreadsheet to facilitate the complex task of deferred tax computation based on “balance sheet liability approach”
 
The seminar achieved the above objectives by:
1st       Honing your knowledge in the fundamental principles of FRS12/IAS12

  •  providing step-by-step guide on how the principles of deferred taxation are applied in practice
  • using case study approach to explain the complex technical requirements of the Standard

2nd     Show you how to design deferred tax computation format using spreadsheet

  • Designing a master deferred tax computation lead schedule, supporting schedules and working papers
  • How to incorporate the spreadsheet working papers to facilitate the complex disclosure requirements

Programme Outline

History, Development and objective of Deferred Taxation

  • The difference between deferral method and liability method
  • Timing difference method Versus temporary difference method
  • The concept of future tax consequences

 
Understanding and Determining Tax Base of Assets and Liabilities

  • Non-current assets: assets with capital allowance and those without
  • Current assets: inventories, receivables, prepayments, cash
  • Current liabilities: payables, accruals, deferred income
  • Non-current liabilities: long-term borrowings

 
Recognition of Deferred Tax Assets and Liabilities

  • The four practical steps of recognising deferred tax assets and liabilities
  • Determining deductible temporary difference and taxable temporary difference
  • Accounting for deferred tax liability and asset arising from initial recognition

 
Measurement of Deferred Tax Assets and Deferred Tax Liabilities

  • Determining tax rate enacted and substantively enacted
  • Manner of recovery or settlement of assets and liabilities

 
Presentation and Disclosure

  • Presenting deferred tax in profit and loss and other comprehensive income
  • Presenting deferred tax assets and liabilities in statement of financial position
  • Disclosure of accounting policies, notes to support deferred tax expense/income and deferred tax assets and liabilities
  • Designing working papers to facilitate quantitative disclosure requirements

 
Computation Format Using Spreadsheet

  • A comprehensive case study on how to design and use spreadsheet for computing deferred taxation

 
Pre-requisites

Please take note of the following admission requirements:

  • Trainings will be conducted on Zoom platform, thus video camera and microphone are compulsory
  • Mandatory for video camera to be turned on throughout the course
  • Display your official name (as per NRIC) in Zoom, to facilitate attendance taking


Training Methodology

Lecture style, with practical illustrations, technical flow-charts, conceptual “mind maps” and interactive discussions. 

Closing Date for Registration

1 week before programme or until full enrolment

Intended For

This programme is suitable for all Finance Professionals, Audit Professionals, Members of Audit Committee, Finance Directors and Regulators. Those who are keen on attending a practical course that examines the use of spreadsheet to determine deferred tax assets and liabilities based on balance sheet liability method are welcome to attend.

NOTE: Participants are required to bring their own laptop installed with Mocrosoft Office 2016 and above. 

Competency Mapping

Category 1 = 7.00 Hours

Programme Facilitator(s)

Danny Tan
 

Danny is a consultant providing continuing professional development training for the accountancy profession as well as providing consultancy services on financial reporting technical matters. He has over 35 years’ experience in public practice, commerce, and industry. He was trained and qualified as a professional accountant with a firm in London. Danny conducts courses in IFRS and IPSAS in Europe, Middle East, and Asia Pacific. He is currently a member of the Small and Medium-size Entities Implementation Group (SMEIG) that consider the need to amend IFRS for SMEs Accounting Standard and make recommendation to the Board of IASB. He is also a project manager for the MASB. He currently holds several advisory roles in financial reporting technical matters.

 

Danny holds an Honours Degree in Economics (major in finance and investment) from Manchester Metropolitan University (UK), MBA from Heriot-Watt University (UK) and Master in Advance Business Practice from University of South Australia. He is a fellow member of The Chartered Instituted of Management Accountants, and The Association of Chartered Certified Accountants. He is also a member of The Institute of Singapore Chartered Accountants, Malaysian Institute of Accountants and an associate member of Chartered Tax Institute of Malaysia.


Upcoming Schedule

Date & Time

18 Nov 2024 (9:00 AM - 5:00 PM)

Fee (inclusive of GST)

For Members: $ 318.28
For Non-Members: $ 382.59

Programme Facilitator(s)

Danny Tan

Venue

Online Classroom in or outside of
Singapore