Cost-Benefit Analysis using Microsoft Excel Course


Course Cover

Register for this course

We are proud to offer this course in a variety of training formats to suit your needs. We use the highest quality learning facilities to make sure your experience is as comfortable as possible. Our face to face calendar allows you to choose any classroom course of your choice to be delivered at any venue of your choice - offering you the ultimate in convenience and value for money.


July 2024

Code Date Duration Location Fee Action
CBA04 22 Jul 2024 - 2 Aug 2024 10 days Nairobi, Kenya KES 159,000 | $2,200 Register
CBA04 29 Jul 2024 - 9 Aug 2024 10 days Kisumu, Kenya KES 165,000 | $2,200 Register
CBA04 22 Jul 2024 - 2 Aug 2024 10 days Johannesburg, South Africa $4,400 Register
CBA04 29 Jul 2024 - 9 Aug 2024 10 days Accra, Ghana $4,400 Register
I Want To See More Dates...

Unfortunately, we do not have any dates scheduled at this time. Do you have a date in mind when you would like to take your training?

Request Custom Schedule

Contact Us on (+254) 715 077 817 / (+254) 792 516 000 or email us [email protected].

July 2024

Date
Duration
Location
Fee
Action
22 Jul - 2 Aug
10 days
Nairobi
KES 159,000 | $2,200
29 Jul - 9 Aug
10 days
Kisumu
KES 165,000 | $2,200
22 Jul - 2 Aug
10 days
Johannesburg
- | $4,400
29 Jul - 9 Aug
10 days
Accra
- | $4,400
I Want To See More Dates...

Unfortunately, we do not have any dates scheduled at this time. Do you have a date in mind when you would like to take your training?

Request Custom Schedule

Contact Us on (+254) 715 077 817 / (+254) 792 516 000 or email us [email protected].


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

10 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.


Course Level:

Course 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

COURSE OUTLINE

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-U

Related Courses


Course Administration Details:

METHODOLOGY

The instructor led trainings are delivered using a blended learning approach and comprise 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 Institute (IRES) certificate certified by the National Industrial Training Authority (NITA).

TRAINING VENUE

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

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

ACCOMMODATION AND AIRPORT PICKUP

Accommodation and airport pickup are arranged upon request. For reservations contact the Training Officer.

Email:[email protected]/[email protected]

Mob: +254 715 077 817/+250789621067

TAILOR- MADE

This training can also be customized to suit the needs of your institution upon request. You can have it delivered in our IRES Training Centre or at a convenient location.

For further inquiries, please contact us on Tel: +254 715 077 817/+250789621067

Mob: +254 792516000+254 792516010 , +250 789621067 ,or mail [email protected]/[email protected]

PAYMENT

Payment should be transferred to IRES account through bank on or before start of the course.

Send proof of payment to [email protected]/[email protected]


Share this course:


Related Courses

People who took this course also viewed: