Country dropdown

Cost-Benefit Analysis Using Microsoft Excel Course

INTRODUCTION

Cost-benefit analysis is used by governments and other organizations to evaluate the desirability of a given policy or to justify the allocation of scarce financial resources to attain an established performance goal. Cost-benefit analysis also provides a portable, scalable model for organizing facts, assumptions, estimates, and findings in support of complex decisions. This course introduces concepts that are applicable to selecting optimal decisions through the use of trade-off analysis. In the course, financial and program staff, such as budget and program analysts as well as project managers and contracting personnel, will learn to conduct accurate cost-benefit analyses, thereby identifying choices that increase public welfare and improve efficiency.

DURATION

3 Days

WHO SHOULD ATTEND

This course is designed for individuals who want to understand and apply cost-benefit analysis to support decision-making in their organizations.

LEARNING OBJECTIVES

  • Select measurement(s) and measure all cost-benefit elements
  • Forecast cost and benefits over a relevant time period
  • Convert all costs and benefits into a common currency
  • Apply a discount rate
  • Calculate net present value of project net benefits
  • Perform sensitivity analysis
  • Evaluate alternatives and select the best value option based on costs and benefits
  • Incorporate risk (uncertainty) in calculating costs and benefits
  • Utilize Microsoft Excel tools to facilitate compilation and analysis of cost-benefit elements
  • Reference applicable OMB guidance and Executive Orders

TOPICS TO BE COVERED

Cost-Benefit Analysis Fundamentals

  • Cost-Benefit Analysis Defined
  • Critical Concepts for Cost-Benefit Analysis
  • Uses for Cost-Benefit Analysis
  • What Documents Provide Guidance for Federal Programs?
  • Presidential Executive Orders
  • Cost Benefit Analysis Essentials
  • Basic CBA Decision Criteria Measures
  • Conflicting Measures
  • The Need for More than One Measure
  • Distinguishing Negative Benefits from Costs
  • Cost Effectiveness Principle
  • Lesson Wrap-Up

Costs

  • Relevant and Non-relevant Costs
  • Opportunity Costs versus Outlays
  • Sunk Costs versus Future Costs
  • Fixed Versus Variable Costs
  • Total Costs
  • Mixed Costs
  • Depreciation
  • Direct versus Indirect Costs
  • Personnel and Overhead Costs
  • Lesson Wrap-Up

Benefits

  • Guidance for Quantifying Benefits
  • Creating Models for Benefits to the Public Without Price Data
  • Weighing and Scoring Benefits
  • Calculating Benefits of Regulatory Action
  • Computing Benefits Where Price Data Is Available
  • Lesson Wrap-Up

Time Value of Money

  • Concept of the Time Value of Money
  • Simple Interest
  • Compound Interest
  • Future Value
  • Present Value
  • Present and Future Value Using Excel Functions
  • Lesson Wrap-Up

Time-Based Decision Criteria Measures Used in Cost Benefit Analysis

  • The Timing of Costs and Benefits and the Cash Flow Diagram
  • The Payback Period
  • The Net Present Value
  • The Principle of Equivalence
  • Calculating the Net Present Value
  • Excel’s NPV function
  • Discount Rate
  • Internal Rate of Return (IRR)
  • Lesson Wrap-Up

Sensitivity Analysis

  • Uncertainty Versus Risk
  • Expected Value with Uncertainty
  • Sensitivity Analysis
  • Sensitivity Analysis in Excel
  • Performing a Sensitivity Analysis Using Excel's Data Table Feature
  • Performing Sensitivity Analysis Using Excel's Scenario Manager
  • Lesson Wrap-Up

METHODOLOGY

The instructor led trainings are delivered using a blended learning approach and comprises of presentations, guided sessions of practical exercise, web based tutorials and group work. Our facilitators are seasoned industry experts with years of experience, working as professional and trainers in these fields.

All facilitation and course materials will be offered in English. The participants should be reasonably proficient in English.

ACCREDITATION

Upon successful completion of this training, participants will be issued with an Indepth Research Services (IRES) certificate.

TRAINING VENUE

The training will be held at the IRES Training Centre in Nairobi. The course fee covers the course tuition, training materials, two break refreshments, lunch, and study visits.

All participants will additionally cater for their, travel expenses, visa application, insurance, and other personal expenses.

ACCOMMODATION

Accommodation is arranged upon request. For reservations contact the Training Officer.

Email: This email address is being protected from spambots. You need JavaScript enabled to view it..  

Mob: +254 715 077 817

Tel: 020 211 3814

PAYMENT

Payment should be transferred to IRES account through bank on or before C.O.B  20th April 2020

Payment for the all courses includes a registration fee, which is non-refundable, and equals 15% of the total sum of the course fee.

  • Participants may cancel attendance 14 days or more prior to the commencement date.
  • No refunds will be made 14 days or less to the training commencement date. However, participants who are unable to attend may opt to attend a similar training at a later date, or send a substitute participant provided the participation criteria have been met.

Please Note: The program content shown here is for guidance purposes only. Our continuous course improvement process may lead to changes in topics and course structure.

Event Properties

Event Duration 3 Days
Event Date 27-04-2020
Event End Date 29-04-2020
Cut off date 20-04-2020
Individual Price(Kenyan) KES 46,999
Individual Price (International) EUR 539
Individual Price(International in Dollars) USD 627
Location Nairobi, Kenya
Share this event:

Search