Benefit-Cost Analysis Using Microsoft Excel

Overview

Discover how to utilize Microsoft Excel for benefit-cost analysis to organize facts, assumptions, estimates, and findings to align your decisions with your organization’s goals and mission. You will learn to conduct accurate benefit-cost analyses in Microsoft Excel using fundamental principles, best practices, and powerful tools.

Who Attends

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

Course Level: Intermediate
CLP: 24 | CPE: 24
Duration: 3 Days

Price: $ 1699.00 Course prices shown here do not include a credit card surcharge. Payments by ACH, EFT, or check do not include the surcharge and are offered at a lower price. At checkout, you may choose a payment method that avoids the credit card surcharge.
A 3% credit card surcharge will be applied.

Course Details

FAQs Technology Requirements

For Groups

Volume Discounts (5+ Seats) Private Group Training Icon

Private Group Training

Available Dates

Guaranteed to Run are designated with a

November 18 - November 20, 2026

Class ID: 265405005

Washington, DC

8 AM - 4 PM EST

March 22 - March 24, 2027

Class ID: 275405001

Virtual

9 AM - 5 PM EST

June 14 - June 16, 2027

Class ID: 275405002

Virtual

9 AM - 5 PM EST

August 9 - August 11, 2027

Class ID: 275405003

Virtual

9 AM - 5 PM EST

November 17 - November 19, 2027

Class ID: 275405004

Virtual

9 AM - 5 PM EST

Learning Objectives

Select measurement(s) and measure all benefit-cost elements
Forecast costs and benefits over a relevant time period
Convert all future costs and benefits into an equivalent present value
Apply a discount rate
Calculate the discounted net benefits of a proposal
Evaluate alternatives and select the best value option based on costs and benefits
Perform a sensitivity analysis by incorporating risk (uncertainty) in estimates
Utilize Microsoft Excel tools to facilitate compilation and analysis of benefit-cost elements
Reference applicable OMB guidance

Additional Features

Learn More

Related Courses and Products

COURSE

Program and Budget Analysis Using Microsoft Excel

Learn to effectively navigate Excel for more productive analyses and the ability to graphically represent data, aiding in organizational efforts to track expenditures and control budget execution. You...

Loading Course Details

Benefit-Cost Analysis Using Microsoft Excel

Overview

Who Attends

For Groups

Available Dates

Learning Objectives

Additional Features

Credits

This course is part of the following Management Concepts Certificate Programs:

Core Courses

Elective Courses

Prerequisites:

Mandatory

Suggested

Course Activities

Course Topics