Zigya Academy Program | Cost Benefit Analysis using Excel

ZIGYA ACADEMY
BEING RELEVANT

NEET Solved Papers | JEE Solved Papers | Download Zigya App Today

Foundation Programs
Optimal decision-making requires trade-off analysis; justification of the allocation of scarce financial resources to attain performance goals; and evaluation of policies for organizational benefit. This process can be daunting if your actions aren’t root
Zig In

Basic Programs
provides a model for organizing facts, assumptions, estimates, and findings to align your decisions with your organization’s goals and mission
Zig In

Advanced Programs
provides a model for organizing facts, assumptions, estimates, and findings to align your decisions with your organization’s goals and mission principles, best practices, and powerful tools.
Zig In

Bootcamp Programs
provides a model for organizing facts, assumptions, estimates, and findings to align your decisions with your organization’s goals and mission
Zig In

Specialization Programs
provides a model for organizing facts, assumptions, estimates, and findings to align your decisions with your organization’s goals and mission.
Zig In

Certification Programs
provides a model for organizing facts, assumptions, estimates, and findings to align your decisions with your organization’s goals and mission
Zig In

Expert Programs
Expert program is well suited to businesses and individuals who provide retail services and support to clients, implement point of sale and retail management systems, or are IT or Apple specialists. But anyone interested in expanding their services portfolio, earning revenue share, and providing ongoing support to retail clients is invited to apply.
Zig In

Cost Benefit Analysis using Excel

Optimal decision-making requires trade-off analysis; justification of the allocation of scarce financial resources to attain performance goals; and evaluation of policies for organizational benefit. This process can be daunting if your actions aren’t rooted in empirical evidence. Cost-benefit analysis provides a model for organizing facts, assumptions, estimates, and findings to align your decisions with your organization’s goals and mission. You will learn to conduct accurate cost-benefit analyses using fundamental principles, best practices, and powerful tools.

  • Category

    Basic

    Delivery

    Class Room

  • Availability

    Individual | Group

    Duration

    48 hours

Methodology

Case Studies
Debates
Introspective Fill-Outs
Periodic Assignments
Participative Lectures
  • Topics
    Program Topics
  • Objectives
    Learning Objectives

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

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 Data Tables

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)

Who should take this course

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

Share It
Share it