Feasibility Studies: Preparation, Analysis and Evaluation Course

The overall aim of this course is to provide participants with competencies required to prepare, analyze and evaluate feasibility studies. The course involves building a feasibility study financial model using hands-on training on Microsoft Excel. The course also aims at enabling participants to appraise service and industrial investments using different capital budgeting techniques as well as analyzing the related financial parameters.

Course Methodology

The course uses a mix of interactive techniques, such as brief presentations by the consultant and the participants, group exercises and case studies. The course also includes building a feasibility study model using Microsoft Excel software.

Course Objectives

By the end of the course, participants will be able to:

• Define feasibility study and compare it to business plan
• Identify the crucial elements in the feasibility study
• Build the feasibility study financial model using Microsoft Excel
• Apply different investment appraisal methods and analyze financial parameters
• Analyze the feasibility study and find its merits and shortcomings

Target Audience

Project sponsors, senior management, functional managers, project managers and individuals involved in preparing, writing and analyzing feasibility studies. This course is worth 30 PDUs.

Target Competencies

• Planning
• Analyzing data
• Evaluating options
• Thinking proactively
• Managing scenarios
• Cognitive ability

Note: This course involves practical and hands-on training on a feasibility study financial model using Microsoft Excel. Participants are to come along with their Laptops.

Course Outline

Introduction and Definitions

• Feasibility study definitions
• Feasibility study objectives
• Feasibility study versus business plan
• Feasibility study cycle
• Feasibility study preparation steps

Feasibility Study Elements

• Feasibility study report elements
• Executive summary
• Feasibility study outline
• Market feasibility

• Market research and analysis
• Market research data types
• Sales projections analysis
  • Technical feasibility

• Critical technical questions
• Supply feasibility
• Operational feasibility
  • Financial feasibility

• Project costs
• Indirect costs
• Ongoing costs

Feasibility Study Financial Model Using Microsoft Excel

• Building the feasibility study financial model
• Weighted Average Cost of Capital (WACC)
• Cost of equity using the Capital Asset Pricing Model (CAPM)
• Unlevered Free Cash Flow (UFCF)
• Terminal value of the project
• Preparing sensitivity tables
• Creating different scenario analysis

Feasibility Study Appraisal and Analysis

• Financial analysis parameters

• Liquidity ratios
• Operating ratios
• Financial leverage ratios
• Security ratios
• Profitability ratios
  • Investment appraisal analysis

• Quantity and sales Breakeven Points (BEP)
• Payback Period (PP)
• Net Present Value (NPV)
• Internal Rate of Return (IRR)
• Profitability Index (PI)

Feasibility Study Evaluation and Implementation

• Internal recommendations and conclusions
• Evaluating feasibility studies
• Common mistakes in using the feasibility study results
• Implementing the proposals