Course Detail(BF136 : Quantitative Tender Evaluation and Project Viability Analysis for the Public Sector)

BF136 : Quantitative Tender Evaluation and Project Viability Analysis for the Public Sector

7.00 CPE Hours (Others)
Classroom

Programme Objective

How do we develop a Quality-Price Evaluation Matrix for Tenders Evaluation?

How do we conduct Financial Viability Analysis of multi-year projects before committing scare resources?  What are the Key Financial Indicators (KFIs) to decide whether to proceed or abandon a project?

This hands-on workshop equips you with portable skills to quantitatively conduct Tender Evaluation and Project Viability Analysis, which are relevant whether you are working for the public or private sector.

The facilitator will also discuss issues faced by government agencies and past Auditor-General Office (AGO) Reports on lapses in tender/quotation and project evaluations

Programme Outline

Session 1: Building Blocks for Tender Evaluation Matrix

  • Some examples of non-homogenous products/services procured:
    • Accounting: Statutory auditors, accounting system, tax services
    • Investment: Appointment of fund managers/custodian
  • What are appropriate Evaluation Criteria and sub-criteria?
  • How are weights assigned to Quality and Price main criteria and sub-criteria?
  • How is total contract price determined if it is based on actual number of transactions over multi-years contract period?
  • What to build in a low-balling disincentive formula?
  • How are bids in different currencies with different payment terms converted to a common currency equivalent in present value terms?
  • What are some of the overriding decision considerations? 
Session 2: Hands-on Exercise to Develop Tender Evaluation Matrix
  • Develop Tender Evaluation Matrix for to evaluate procurement of Accounting and Investment services
  • Evaluate three bids received using the Tender Evaluation Matrix developed earlier
Session 3: Building Blocks for Project Viability Analysis
  • How should the following items be treated in a Project Viability Analysis?
    • Government grants
    • Sunk costs
    • Opportunity costs
    • Contingency costs
    • Depreciation of Property, Plant and Equipment
    • Impairment of Property, Plant and Equipment in future years
    • Allocated HQ costs and other fixed costs
    • Financing cash flows
    • Working capital requirements
    • Foreign currency exposure
    • Other considerations
  • How is discount rate determined?
  • What is the Minimum Acceptable Rate of Return?
  • How is Terminal Value determined?
  • Financial indicators influencing decision to proceed or abandon project:
    • Payback Period
    • Discounted Payback Period
    • Accounting Rate of Return (ARR)
    • Net Present Value (NPV)
    • Internal Rate of Return (IRR)
  • What are the limitations of financial indicators?
  • What if different financial indicators produce conflicting results?      
Session 4: Hands-on Exercise to Develop Project Viability Analysis
  • Discussion on the business and financial assumptions and cash inflows and outflows for an infrastructural project
  • Develop Project Viability Analysis to evaluate whether to proceed or abandon the project based on the above decision considerations and financial indicators
Training Methodology

Presentation style with interactive case studies, open discussions and hands-on activities using Microsoft Excel.
  • Develop Tender Evaluation Matrix
  • Develop Project Viability Analysis
 
Closing Date for Registration
 
1 week before programme or until full enrolmen

Intended For

This workshop is designed for accounting and finance professionals in statutory boards/government agencies who evaluate tenders/quotations and project evaluations and anyone who wishes to upskill for career upside.

Competency Mapping

Others = 7.00 Hours

Schedule & Fees

Date & Time

21 May 2019 (9:00 AM - 5:00 PM)

Registration is closed

Programme Facilitator(s)

Patrick TK Tan

Date & Time

07 Sep 2018 (9:00 AM - 5:00 PM)

Registration is closed

Programme Facilitator(s)

Patrick TK Tan

Date & Time

09 Feb 2018 (9:00 AM - 5:00 PM)

Registration is closed

Programme Facilitator(s)

Patrick TK Tan

Testimonial

Funding

No funding Available!

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

How do we develop a Quality-Price Evaluation Matrix for Tenders Evaluation?

How do we conduct Financial Viability Analysis of multi-year projects before committing scare resources?  What are the Key Financial Indicators (KFIs) to decide whether to proceed or abandon a project?

This hands-on workshop equips you with portable skills to quantitatively conduct Tender Evaluation and Project Viability Analysis, which are relevant whether you are working for the public or private sector.

The facilitator will also discuss issues faced by government agencies and past Auditor-General Office (AGO) Reports on lapses in tender/quotation and project evaluations

Programme Outline

Session 1: Building Blocks for Tender Evaluation Matrix

  • Some examples of non-homogenous products/services procured:
    • Accounting: Statutory auditors, accounting system, tax services
    • Investment: Appointment of fund managers/custodian
  • What are appropriate Evaluation Criteria and sub-criteria?
  • How are weights assigned to Quality and Price main criteria and sub-criteria?
  • How is total contract price determined if it is based on actual number of transactions over multi-years contract period?
  • What to build in a low-balling disincentive formula?
  • How are bids in different currencies with different payment terms converted to a common currency equivalent in present value terms?
  • What are some of the overriding decision considerations? 
Session 2: Hands-on Exercise to Develop Tender Evaluation Matrix
  • Develop Tender Evaluation Matrix for to evaluate procurement of Accounting and Investment services
  • Evaluate three bids received using the Tender Evaluation Matrix developed earlier
Session 3: Building Blocks for Project Viability Analysis
  • How should the following items be treated in a Project Viability Analysis?
    • Government grants
    • Sunk costs
    • Opportunity costs
    • Contingency costs
    • Depreciation of Property, Plant and Equipment
    • Impairment of Property, Plant and Equipment in future years
    • Allocated HQ costs and other fixed costs
    • Financing cash flows
    • Working capital requirements
    • Foreign currency exposure
    • Other considerations
  • How is discount rate determined?
  • What is the Minimum Acceptable Rate of Return?
  • How is Terminal Value determined?
  • Financial indicators influencing decision to proceed or abandon project:
    • Payback Period
    • Discounted Payback Period
    • Accounting Rate of Return (ARR)
    • Net Present Value (NPV)
    • Internal Rate of Return (IRR)
  • What are the limitations of financial indicators?
  • What if different financial indicators produce conflicting results?      
Session 4: Hands-on Exercise to Develop Project Viability Analysis
  • Discussion on the business and financial assumptions and cash inflows and outflows for an infrastructural project
  • Develop Project Viability Analysis to evaluate whether to proceed or abandon the project based on the above decision considerations and financial indicators
Training Methodology

Presentation style with interactive case studies, open discussions and hands-on activities using Microsoft Excel.
  • Develop Tender Evaluation Matrix
  • Develop Project Viability Analysis
 
Closing Date for Registration
 
1 week before programme or until full enrolmen

Intended For

This workshop is designed for accounting and finance professionals in statutory boards/government agencies who evaluate tenders/quotations and project evaluations 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

21 May 2019 (9:00 AM - 5:00 PM)

Fee (inclusive of GST)

For Members: $ 321.00
For Non-Members: $ 385.20

Programme Facilitator(s)

Patrick TK Tan

Venue

60 Cecil Street
ISCA House
Singapore 049709