+91 8143 616 616 admin@financetraining.in
Select Page

Who Takes This Course

This course is designed for federal financial management personnel including budget analysts, management analysts, or consultants who need to support managerial decision-making through the analysis of financial data.

Learning Objectives

  • Perform basic statistical validity calculations
  • Calculate cost, labor hour, and project schedule variances, and forecast projects’ final costs and completion times, using Excel
  • Use Excel’s financial functions to calculate the amounts, rates, and time necessary to achieve financial goals or meet financial requirements
  • Calculate the financial value of a project or proposal and select among alternatives using basic measures such as Net Benefit (NB), Present Value (PV), Net Present Value (NPV), and the Internal Rate of Return (IRR)

Excel For Finance Managers Syllabus

 

The Push for Analytics and the Need for Valid Data

  • The Push For Analytics
  • Data Validity
  • Using Excel to Validate
  • Data Gathering

Conducting Variance Analysis

  • Getting Started
  • Calculate Variance in Standard Cost Systems
  • Earned Value Management and Variance

Solving Financial Problems Using Excel’s Financial Functions and Creating Intentional Circular References

  • Getting Started
  • Using Financial Functions
  • Resolving and Creating Circular References

Evaluating the Financial Impact of Projects and the Selection of Alternatives

  • Getting Started
  • Using Basic Financial Measures in Project Evaluation
  • Applying Discount Rates and Calculating the Internal Rate of Return (IRR)
  • Selecting Among Alternatives Using Net Present Value (NPV) and the Cost-Effectiveness Technique

Applying Excel’s Goal Seek to Cost-Volume Analysis

  • Getting Started
  • Using Graphical Analysis to Calculate Breakeven Points
  • Using the Algebraic Approach to Calculate Breakeven Points
  • Using Excel’s Goal Seek Tool to Calculate Breakeven Points and Estimate Volumes

Applying Excel’s Data Table and Scenario Manager Tools to Financial Models

  • Getting Started
  • Using Excel’s Data Table Tool for One-Variable Data Tables
  • Using Excel’s Data Table Tool for Two-Variable Data Tables
  • Using Excel’s Scenario Manager tool for Multiple-Variable Summary and PivotTable Reports

Applying Excel’s Solver Tool to Financial Problems

  • Getting Started
  • Applying Excel’s Solver Tool to Create Assignment Models
  • Applying Excel’s Solver Tool to Create Transportation Models

Queuing Theory and Application to Waiting Line Models

  • Getting Started
  • Simulating the Waiting Line Model with Fixed Service Times and Fixed or Varying Arrival Times in Single- and Two-Server Systems
  • Simulating the Waiting Line Model with Exponential Distribution Service and Arrival Times in Single-Server Systems
  • Simulating the Waiting Line Model Using the Monte Carlo Simulation Technique