Forecasting and Budgeting Using Excel for Project Managers Training Class

Program Agenda
Day One
Project Management in Today's Financial Management Environment
-Overview of the strategic, tactical, and operational aspects of today's global business entity
-The Organizational Planning Model
-The Product/Decision/Information Cycle
-The objectives of Financial Analysis

The Strategic Vision as a Budgeting Tool
-Development of the long-range vision
-Focusing the Vision
-Creation of Definable, Measurable Objectives
-Development of the Key Performance Indicator Matrix
-Identification of required activities, resources, and consumption rates

Case Exercise - Part I
In order to enhance the learning process, and to provide a structured environment to reinforce the skills learned in each section, you will work as part of a management team, developing a real budget of a real process.

Day Two
The Budgeting Process - The Nine-Step Budgeting Model??
-The Nine-Step Budgeting Model
-The principles of Activity-Based Budgeting
-The role of assumptions in the budget model
-Projecting Headcount
-Projecting the cost of Employee Benefits
-Accounting for Depreciation in the Budget Model
-Fixed, Variable and Mixed Expenses
-Discretionary Expenses

Projecting Revenues - The Sales Budget
-Projecting Revenues
-Using Excel?? to project optimum product mix
-Projecting sales volume
-Projecting new product introduction and speed to market
-Developing the bases for cost projections using revenue assumptions

Case Exercise - Part II

Day Three
The Nature and Behavior of Costs
-The behavior of costs
-Fixed Costs
-Variable Costs
-Mixed Costs
-Non-Cash Expenses
-Cost / Volume / Profit Analysis

Projecting Expenses
-Projecting costs in unique cost categories including ; travel, outside services, and communication costs
-Using Activity-Based Budgeting to project expenses
-Applying the Key Performance Indicator Matrix to the Budget Development Model
-Identification of activities critical to objective achievement
-Determining resources requirements

The Time Value of Money
-The impact time has on the value of money.
-Understand the various interest calculations
-Using WACC and ROIC as benchmarks
-Use Excel??, to determine Present Value, Future Value, Net Present Value, Internal Rate of -Return, Modified Internal Rate of Return
-Using MIRR and a basis for capital project evaluation

Projecting the Cost of Capital Investments
-Projecting the Initial Cash Outflows
-Projecting Ongoing Cash Inflows resulting from the project
-Projecting Ongoing Cash Outflows resulting from the project
-Developing the NPV Cash Flow Model

Case Exercise - Part III<