Course Detail(BF135 : Public Sector Financial Planning & Analysis Methodologies – A Practical Approach)

SDF Funding, SkillsFuture Credit

BF135 : Public Sector Financial Planning & Analysis Methodologies – A Practical Approach

7.00 CPE Hours (Others)
Classroom
In Collaboration with:  

Programme Objective

FP&A is increasingly important in statutory boards and government agencies, as well as the private sector.  FP&A provides insight and impact on strategic decisions affecting an entity’s top line, bottom line, cash flow, financial position and shareholders’ value.

It is therefore important to invest more time in FP&A and develop alternate business and financial strategies than spending time in validating data, and preparing rolling budgets and monthly management reports.  More time should be spent analysing the current and future internal business scenarios as well as external developments on the impact on business and financials.

This hands-on workshop equips you with portable FP&A skills especially for statutory boards and government agencies based on accounting and finance knowledge, market data and data visualisation using charts

Programme Outline

Session 1: Budgeting to Achieve Management Objectives

  • Importance of Budget Marksmanship given resources constraint
  • Various budgeting approaches - Zero-Based Budgeting, Incremental Budgeting, Probability-Adjusted Budgeting, Scenario Budgeting
  • Analysis of Operating Cashflow, Investing Cashflow and Financing Cashflows
  • Estimate revenue, expenses and resources required to execute business plans

Session 2: Hands-on Exercise to Develop an Annual Budget

  • Using a statutory board’s financial statements^, develop Annual Budget for next financial year based on the last 5 years’ historical information, covering:
    • Art of normalising cashflows
    • Time-series analysis on financial statements
    • Analysis of Revenue Structure, Expense Structure and Capital Structure
    • Probability adjustments to budgets
    • Business and financial assumptions for Base Case
    • SWOT analysis on achievability of Management Objectives

 ^ Learners who prefer to use listed company’s financials will be guided by Facilitator.

Session 3: Long-Term Forecasting for Strategic Decisions

  • Concept of Free Cash Flows
  • Long-term Financial Planning Process – role of Business Units, Treasury, Finance and Stakeholders
  • Continuing from above, develop business and financial assumptions for 5-year Forecast (Base Case, Best Case and Worst Case)
  • Strategic review of 5-year plan:
    • Operational decisions e.g., pricing strategy, best-sourcing, headcount cut, salary freeze
    • Investment decisions e.g., deployment of idle cash, cash war-chest, capital expenditure
    • Financing decisions e.g., debt maturity profile, access to money market versus capital markets, debt management/refinancing, risk management
    • Market conditions  e.g., interest rate, foreign exchange rates
    • Key success factors, drivers and controllability           

Session 4: Hands-on Exercise to Develop 5-Year Forecast & Financial Analysis

  • Continuing from above, develop the 5-year Forecast (Base Case, Base Case and Worst Case)
  • Cost-benefit analysis of major Operational, Investment and Financing decisions e.g., investment of surplus funds, bond issue, financial requirements to execute future sales strategy
  • Review of liquidity, profitability, sustainability, long-term viability and bankability
  • Key Financial Indicators:
    • Liquidity
    • Profitability, Growth and Quality of Earnings
    • Operational Efficiency
    • DuPont analysis
    • Leverage and Coverage
    • Valuation
    • Bankability
  • What are the limitations of these financial indicators?

 
Training Methodology

Presentation style with interactive case studies, open discussions and hands-on activities using Microsoft Excel.

  • Develop Annual Budget
  • Develop 5-year Forecast & Financial Analysis

Closing Date for Registration
 
1 week before programme or until full enrolment

Intended For

This workshop is designed for accounting and finance professionals in statutory boards/government agencies who manage budgeting, financial planning/analysis and treasury, as well as credit and business analysis, auditors and anyone who wishes to upskill for career upside.

Competency Mapping

Others = 7.00 Hours

Schedule & Fees

Date & Time

03 Oct 2019 (9:00 AM - 5:00 PM)

Registration is closed

Programme Facilitator(s)

Patrick TK Tan

Date & Time

24 Jun 2019 (9:00 AM - 5:00 PM)

Registration is closed

Programme Facilitator(s)

Patrick TK Tan

Date & Time

15 Feb 2019 (9:00 AM - 5:00 PM)

Registration is closed

Programme Facilitator(s)

Patrick TK Tan

Testimonial

Funding

1] SkillsFuture Credit (SFC)
Funding Period: Until 2 Jan 2021
Course Ref No.: CRS-N-0045951

All Singaporeans aged 25 and above will receive an opening credit of S$500 from the government. The credits will not expire and periodic top-ups will be provided by the government. SFC may be accumulated to pay for skills related course fees. You may wish to use your SFC to pay for partial/full ISCA course fees.  (For more information on the SFC scheme, please visit http://www.skillsfuture.sg/credit)

 

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

  • Step 1: Register for the course online via ISCA Portal. Upon adding to cart, the system will prompt a question “Do you wish to apply for SkillsFuture Credit?”, click “Yes” and input all required information. At the Cart page, please ensure that SFC funding is applied before clicking “Checkout”.
  • Step 2: After successful enrolment, please proceed to submit SFC claim on Skillsfuture Portal within 60 days before the course start date and obtain the necessary approval. Please submit SFC claim via SFC portal here: http://www.skillsfuture.sg/credit.

 

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 $42.80 for any revision of invoice.


2] WDA Training Grant - SDF Funding
This course is approved for SDF funding ($2 per training hour) for Company-sponsored participants only (Eligibility criteria apply). 
 
Funding Period: Until 2 Jan 2021
Funded Hours: 7 hours
Course Ref No.: CRS-N-0045951

If you wish to enrol participants with SDF Funding, please proceed with the following steps (For Corporate enrolments only) :

  • Step 1: Register for the course online via ISCA Portal. Upon adding to cart, the system will prompt a question “Do you wish to apply for WDA Funding?”, click Yes and input all required information. At the Cart page, please ensure that SDF funding is applied before clicking “Checkout”.
     
  • Step 2: After successful enrolment, please proceed to submit the Training Grant application via SkillsConnect Portal here: https://www.skillsconnect.gov.sg/

 

Employers of company-sponsored participants must submit training grant via SkillsConnect system to obtain training grant for course fees. You may submit the Training Grant application within the period from 30 days before the course start date to 30 days after course start date. Please note that there will be an administrative fee of $42.80 for any revision of invoice.

 

Eligibility Criteria:

  • Company must be registered or incorporated in Singapore and;
  • Applicant is taking the course for the first time.
  • Applicant must be employed, and is either Singapore Citizen or Permanent Resident of Singapore and;
  • Applicant must achieve at least 75% attendance, and pass all examinations /assessments and;
  • Applicant must be fully sponsored by the Company for all costs associated with the training and;
  • Payment has to be made via corporate means (e.g. corporate cheque, corporate GIRO, corporate credit card).

 

Programme Facilitator(s)



Patrick TK Tan


Patrick TK Tan is a Fellow Chartered Accountant (FCA) with the Institute of Singapore Chartered Accountants (ISCA).  He also holds the Chartered Financial Consultant (ChFC), Distinguished Toastmasters (DTM) and Advanced Certificate for Training and Assessment (ACTA) qualifications.  He graduated from the National University of Singapore (NUS) with a Bachelor of Accountancy and Master of Business Administration.

 

Currently, he is a Specialist and Senior Lecturer at the Singapore University of Social Sciences.  He teaches Financial Accounting, Managerial Accounting and Financial Reporting, as well as conduct Accounting and Finance workshops.

 

In addition, he serves in the Accountant Journal Editorial Advisory Panel and Information Technology Services Advisory Panel at ISCA.

 

He has about 30 years of experience holding appointments of Chief Financial Officer (CFO), Group Chief Investment Officer (Group CIO), Investment Director, Head of Corporate Finance, Head of Management Accounting and Treasurer.

 

He has real-life hands-on experience in treasury, financing, investment, IPOs, M&A, financial accounting, management reporting, strategic finance, financial operations, compliance, taxation, insurance and risk management.

 

His career spans across utilities, property, consultancy, port, leisure, transport, info-communications, financial and education sectors locally and overseas.

 

Attendees from statutory boards/government agencies will greatly benefit from his experiences in HQ and downstream companies of Public Utilities Board, Singapore Power, Jurong Town Corporation, Info-communications Development Corporation, Sentosa Development Corporation and Singapore University of Social Science.

 

Programme Objective

FP&A is increasingly important in statutory boards and government agencies, as well as the private sector.  FP&A provides insight and impact on strategic decisions affecting an entity’s top line, bottom line, cash flow, financial position and shareholders’ value.

It is therefore important to invest more time in FP&A and develop alternate business and financial strategies than spending time in validating data, and preparing rolling budgets and monthly management reports.  More time should be spent analysing the current and future internal business scenarios as well as external developments on the impact on business and financials.

This hands-on workshop equips you with portable FP&A skills especially for statutory boards and government agencies based on accounting and finance knowledge, market data and data visualisation using charts

Programme Outline

Session 1: Budgeting to Achieve Management Objectives

  • Importance of Budget Marksmanship given resources constraint
  • Various budgeting approaches - Zero-Based Budgeting, Incremental Budgeting, Probability-Adjusted Budgeting, Scenario Budgeting
  • Analysis of Operating Cashflow, Investing Cashflow and Financing Cashflows
  • Estimate revenue, expenses and resources required to execute business plans

Session 2: Hands-on Exercise to Develop an Annual Budget

  • Using a statutory board’s financial statements^, develop Annual Budget for next financial year based on the last 5 years’ historical information, covering:
    • Art of normalising cashflows
    • Time-series analysis on financial statements
    • Analysis of Revenue Structure, Expense Structure and Capital Structure
    • Probability adjustments to budgets
    • Business and financial assumptions for Base Case
    • SWOT analysis on achievability of Management Objectives

 ^ Learners who prefer to use listed company’s financials will be guided by Facilitator.

Session 3: Long-Term Forecasting for Strategic Decisions

  • Concept of Free Cash Flows
  • Long-term Financial Planning Process – role of Business Units, Treasury, Finance and Stakeholders
  • Continuing from above, develop business and financial assumptions for 5-year Forecast (Base Case, Best Case and Worst Case)
  • Strategic review of 5-year plan:
    • Operational decisions e.g., pricing strategy, best-sourcing, headcount cut, salary freeze
    • Investment decisions e.g., deployment of idle cash, cash war-chest, capital expenditure
    • Financing decisions e.g., debt maturity profile, access to money market versus capital markets, debt management/refinancing, risk management
    • Market conditions  e.g., interest rate, foreign exchange rates
    • Key success factors, drivers and controllability           

Session 4: Hands-on Exercise to Develop 5-Year Forecast & Financial Analysis

  • Continuing from above, develop the 5-year Forecast (Base Case, Base Case and Worst Case)
  • Cost-benefit analysis of major Operational, Investment and Financing decisions e.g., investment of surplus funds, bond issue, financial requirements to execute future sales strategy
  • Review of liquidity, profitability, sustainability, long-term viability and bankability
  • Key Financial Indicators:
    • Liquidity
    • Profitability, Growth and Quality of Earnings
    • Operational Efficiency
    • DuPont analysis
    • Leverage and Coverage
    • Valuation
    • Bankability
  • What are the limitations of these financial indicators?

 
Training Methodology

Presentation style with interactive case studies, open discussions and hands-on activities using Microsoft Excel.

  • Develop Annual Budget
  • Develop 5-year Forecast & Financial Analysis

Closing Date for Registration
 
1 week before programme or until full enrolment

Intended For

This workshop is designed for accounting and finance professionals in statutory boards/government agencies who manage budgeting, financial planning/analysis and treasury, as well as credit and business analysis, auditors and anyone who wishes to upskill for career upside.

Competency Mapping

Others = 7.00 Hours

Programme Facilitator(s)


Patrick TK Tan


Patrick TK Tan is a Fellow Chartered Accountant (FCA) with the Institute of Singapore Chartered Accountants (ISCA).  He also holds the Chartered Financial Consultant (ChFC), Distinguished Toastmasters (DTM) and Advanced Certificate for Training and Assessment (ACTA) qualifications.  He graduated from the National University of Singapore (NUS) with a Bachelor of Accountancy and Master of Business Administration.

 

Currently, he is a Specialist and Senior Lecturer at the Singapore University of Social Sciences.  He teaches Financial Accounting, Managerial Accounting and Financial Reporting, as well as conduct Accounting and Finance workshops.

 

In addition, he serves in the Accountant Journal Editorial Advisory Panel and Information Technology Services Advisory Panel at ISCA.

 

He has about 30 years of experience holding appointments of Chief Financial Officer (CFO), Group Chief Investment Officer (Group CIO), Investment Director, Head of Corporate Finance, Head of Management Accounting and Treasurer.

 

He has real-life hands-on experience in treasury, financing, investment, IPOs, M&A, financial accounting, management reporting, strategic finance, financial operations, compliance, taxation, insurance and risk management.

 

His career spans across utilities, property, consultancy, port, leisure, transport, info-communications, financial and education sectors locally and overseas.

 

Attendees from statutory boards/government agencies will greatly benefit from his experiences in HQ and downstream companies of Public Utilities Board, Singapore Power, Jurong Town Corporation, Info-communications Development Corporation, Sentosa Development Corporation and Singapore University of Social Science.

 


Upcoming Schedule

Registration is closed

Date & Time

03 Oct 2019 (9:00 AM - 5:00 PM)

Fee (inclusive of GST)

For Members: $ 345.61
For Non-Members: $ 415.16

Programme Facilitator(s)

Patrick TK Tan

Venue

60 Cecil Street
ISCA House
Singapore 049709