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.
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
Who Can Enroll:
Course proper for Project supports, senior administration, utilitarian directors, venture chiefs and people associated with planning, composing and dissecting practicality contemplates.
- 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
- Course worth 30PDUs
- This course involves practical and hands-on training on a feasibility study financial model using Microsoft Excel. Laptops should be available.
- The following will be distributed during the course:
Feasibility study financial model built in Excel – soft copy
Templates for feasibility study proposals – soft copy
- To achieve certification, participants shall achieve 80% in CHOOLS exams.
- Course could be customized for organization requirements including company LOGO.
Why Choose Chools?
• Top 100,000 Ebooks.
• 250,000 Management slides and presentations.
• 1 million excel templates.
• 60,000 business documents.
• 15,000 top books in abstract forms.
• 40,000 audio podcast.
• 550 audio library books.
• 50,000 video libraries.
• 1500 training courses.
• 2.6 million Journals and articles.
• 137 Lean Six Sigma toolkit.
• Leadership assessments.
• Quiz, Exam prep, Q&As, Case-studies.
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 research and analysis
- Market research data types
- Sales projections analysis
- Critical technical questions
- Supply feasibility
- Operational 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 evaluation and implementation
- Internal recommendations and conclusions
- Evaluating feasibility studies
- Common mistakes in using the feasibility study results
- Implementing the proposals
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)