Course Detail()

This is an e-learning programme and also a module from the ISCA Professional Business Accountant (PBA) Programme.

Upon successful registration and payment, you will be notified via email within 10-15 mins on your enrolment confirmation with user instructions to access this programme.

Please complete all topics and sub-topics within the E-Learning courseware.
(The programme and assessment is valid for 6 months from the date of purchase)

Programme Objective

This e-learning course will guide you, with hands-on practice, through the process of building and integrating a three-statement financial model. The constructed model will then be used to project the financials of a business and applied in the context of valuing the enterprise. Finally, valuation risk will be assessed through the use of scenario and sensitivity analyses. This course will acquaint you with the best practices of financial modelling and an Excel toolkit curated for accountants to improve spreadsheet productivity.

A basic understanding of financial statement and time value of money concepts is assumed and prior knowledge of valuation, while not necessary, can be helpful.

Learning outcomes:

To construct a simple three-statement financial model
To understand the key drivers of a business and their interrelationships
To perform discounted cash flow valuation
To identify factors that affect valuation risk and the degree of their impact
To improve productivity through the use of Excel shortcuts and functions

Programme Outline

(1) Objectives and introduction to financial modelling

(2) Building a three-statement projection model

Excel content: Keyboard navigation and formula shortcuts, VLOOKUP

(3) Valuing an enterprise

Excel content: NPV

(4) Conducting scenario and sensitivity analyses

Excel content: ABS, SMALL, INDEX, MATCH, CHOOSE, data tables, conditional formatting

Training Methodology

E-Learning (24/7) with videos and MCQ Assessment

Intended For

Finance professionals in the initial of the accountancy and finance career and those who are interested to learn financial modelling with step-by-step guidance will find this course useful.

Schedule & Fees

Testimonial

Funding

1] 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)

To construct a simple three-statement financial model
To understand the key drivers of a business and their interrelationships
To perform discounted cash flow valuation
To identify factors that affect valuation risk and the degree of their impact
To improve productivity through the use of Excel shortcuts and functions