Indepthresearch
outreach@indepthresearch.org
  + 254 20 211 3814 | +254 731 240 802
   +254 735 331 020 | +254 715 077 817
Westlands, Rhapta Road
Njema Court, Suite R2
fb twitter LinkedIn flikr flikr G+


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 venue of the training includes IRES training Centre or another location chosen by the group or in-house for corporates. For locations outside IRES training Centre, the participants are required to have laptops where the software and other materials for the training will be loaded.

TRAINING FEES

Payment should be transferred to IRES account through bank on or before C.O.B 26th June 2017

Send proof of payment to outreach@indepthresearch.org.

Email: outreach@indepthresearch.org.  

Mob: +254 715 077 817

Tel: 020 211 3814

CANCELLATION POLICY

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

  1. Participants may cancel attendance 14 days or more prior to thecommencement date.
  2. 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

Duration 3 Days
Event Date 03-07-2017
Event End Date 05-07-2017
Cut off date 26-06-2017
Individual Price (Kenyan) KES 37,688.00
Individual Price (International) EUR 367.00
Individual Price (International) USD 398.00
Location Nairobi, Kenya

Group Tariffs

Group Size Kenyan Rate Per day (KES) International Rate Per day (USD/EURO)
6-10 95,000.00 $ 1,118.00
€ 1,018.00
11-15 146,250.00 $ 1,721.00
€ 1,567.00
16-20 191,250.00 $ 2,250.00
€ 2,048.00
21-25 230,000.00 $ 2,706.00
€ 2,463.00
26-30 262,500.00 $ 3,089.00
€ 2,811.00
30-50 309,825.00 $ 4,556.00
€ 0.00
3-5 62,500.00 $ 736.00
€ 670.00
Share this event:



↑ Top

© Indepth Research Services Ltd 2017