| This session is delivered via live webinar (zoom platform). |
A detailed set of instructions on the Live Webinar will be sent to you closer to date.
Programme Objective
The course content has been revised. This course was formerly known as BF135: Public Sector Financial Planning & Analysis Methodologies – A Practical Approach.
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 based on accounting and finance knowledge, market data and data visualisation using charts using Microsoft Excel spreadsheet to demonstrate how it works in practice!
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
- 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
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?
Note: Cash accounting is out-of-scope in this workshop.
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
Live Webinar 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 who manage budgeting, financial planning/analysis and treasury, as well as credit and business analysis, auditors and anyone who wishes to upskill for career development.
Competency Mapping
Others = 7.00 Hours
Schedule & Fees
Date & Time
27 Nov 2024 (9:00 AM - 5:00 PM)
There are no seats available.
Fee (inclusive of GST)
For Members:
$ 318.28
For Non-Members:
$ 382.59
Programme Facilitator(s)
Dr. TAN Teck Keong Patrick
Venue
Online Classroom in or outside of
Singapore
Testimonial
Funding
1] SkillsFuture Credit (SFC)
Funding Period: Until 02-01-2025
Course Reference Number: TGS-2020501904
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.60 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)
Dr. TAN Teck Keong Patrick
Dr. TAN Teck Keong Patrick is a Fellow Chartered Accountant (FCA) with the Institute of Singapore Chartered Accountants (ISCA). He graduated from the National University of Singapore (NUS) with a Bachelor of Accountancy and Master of Business Administration. He has been awarded the Doctorate of Business Administration from the Singapore University of Social Sciences (SUSS) for his dissertation on Environmental, Social and Governance (ESG) in Investing.
Other qualifications: Chief Financial Officer (CFO) Certification Program by The City University of New York, Chartered Financial Consultant (ChFC), Myers-Briggs Type Indicator® (MBTI®), Strong Interest Inventory®, Advanced Certificate for Training and Assessment (ACTA), Distinguished Toastmasters (DTM), Advanced Certificate for Career Development and Facilitation (ACCDF), and Independent Associate for Hofstede Culture In The Workplace Certification.
Currently, he is a Senior Specialist and Associate Faculty at SUSS. He teaches accountancy, finance, strategy and industry-based courses for undergraduates, Master of Management programme and working professionals.
His contributions to the Accountancy profession includes his appointment as Principal and Mentor for SUSS Accredited Training Organisation (ATO) accreditation, served at ISCA’s Information Technology Services Advisory Panel and ISCA Accountants Journal Advisory Panel, Trainer @ ISCA, and Marker for ISCA Chartered Accountant Pathway Examination.
Attendees will greatly benefit from his more than 35 years' experience, holding appointments of CFO, Group Chief Investment Officer, Investment Director, Head of Corporate Finance, Head of Management Accounting, Treasurer and Educator.
His specialisations: Treasury, financing, investment, IPOs, corporate restructuring, M&A, financial accounting, management reporting, strategic finance, financial operations, compliance and risk management.
His sectors coverage: Financial Markets, Consultancy, Education, Info-communications, Leisure, Property, Shipping, Transport and Utilities.
| This session is delivered via live webinar (zoom platform). |
A detailed set of instructions on the Live Webinar will be sent to you closer to date.
Programme Objective
The course content has been revised. This course was formerly known as BF135: Public Sector Financial Planning & Analysis Methodologies – A Practical Approach.
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 based on accounting and finance knowledge, market data and data visualisation using charts using Microsoft Excel spreadsheet to demonstrate how it works in practice!
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
- 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
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?
Note: Cash accounting is out-of-scope in this workshop.
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
Live Webinar 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 who manage budgeting, financial planning/analysis and treasury, as well as credit and business analysis, auditors and anyone who wishes to upskill for career development.
Competency Mapping
Others = 7.00 Hours
Programme Facilitator(s)
Dr. TAN Teck Keong Patrick
Dr. TAN Teck Keong Patrick is a Fellow Chartered Accountant (FCA) with the Institute of Singapore Chartered Accountants (ISCA). He graduated from the National University of Singapore (NUS) with a Bachelor of Accountancy and Master of Business Administration. He has been awarded the Doctorate of Business Administration from the Singapore University of Social Sciences (SUSS) for his dissertation on Environmental, Social and Governance (ESG) in Investing.
Other qualifications: Chief Financial Officer (CFO) Certification Program by The City University of New York, Chartered Financial Consultant (ChFC), Myers-Briggs Type Indicator® (MBTI®), Strong Interest Inventory®, Advanced Certificate for Training and Assessment (ACTA), Distinguished Toastmasters (DTM), Advanced Certificate for Career Development and Facilitation (ACCDF), and Independent Associate for Hofstede Culture In The Workplace Certification.
Currently, he is a Senior Specialist and Associate Faculty at SUSS. He teaches accountancy, finance, strategy and industry-based courses for undergraduates, Master of Management programme and working professionals.
His contributions to the Accountancy profession includes his appointment as Principal and Mentor for SUSS Accredited Training Organisation (ATO) accreditation, served at ISCA’s Information Technology Services Advisory Panel and ISCA Accountants Journal Advisory Panel, Trainer @ ISCA, and Marker for ISCA Chartered Accountant Pathway Examination.
Attendees will greatly benefit from his more than 35 years' experience, holding appointments of CFO, Group Chief Investment Officer, Investment Director, Head of Corporate Finance, Head of Management Accounting, Treasurer and Educator.
His specialisations: Treasury, financing, investment, IPOs, corporate restructuring, M&A, financial accounting, management reporting, strategic finance, financial operations, compliance and risk management.
His sectors coverage: Financial Markets, Consultancy, Education, Info-communications, Leisure, Property, Shipping, Transport and Utilities.