This "Hands-On" interactive program goes far beyond the typical financial analysis program! To identify the strategic drivers that can dramatically enhance the shareholder value of your organization.

Using the power of Excel??, you will learn how to master the tools and techniques it provides to master the latest financial analysis techniques, understand what the numbers are saying, and be better able to predict the outcome of strategic and tactical decisions. Using Excel??, you will learn how to calculate the seven key financial indicators, explore the variants of RIOC, the impact time has on future cash flows, how to project the benefit of capital projects, make lease vs. buy decisions, determine the cost of capital, and project EVA??.

You will learn how to evaluate organizations with which you are planning to do business; determine if they are able to provide strategic strength to your company. Participants receive Excel?? Templates for use during this session, and when they return to their organizations

All financial professionals, financial management, department heads, internal auditors, project managers, and those responsible for ensuring the effective use and management of corporate resources. Also, sales and marketing professionals, R&D professionals, and anyone who needs to understand the short and long-term financial impact of key decisions. Participants should have a basic understanding of financial statements and bring a laptop computer with a full install of Excel??, including the complete "Toolbox.

The International Business Environment

• Overview of the strategic, tactical, and operational aspects of today's business entity
• The Organizational Planning Model
• The Product/Decision/Information Cycle
• The Objectives of Financial Analysis

The Financial Reporting Process and the Organizational Planning Cycle

• Review of financial statements using both American and International GAAP
• "Asset-Light" vs. "Asset Heavy" companies and the relative impact on Return 
• The picture presented by the financial statements relative to past operations
• The inter-relationship among financial statements, strategic decisions, and operations
• GAAP vs. Cash - How to spot accounting irregularities in financial statements
• Focus provided by NOPAT and ROIC

Creating Shareholder Value

• What constitutes "Shareholder Value?"
• Analysis of "The Tube" and its impact on a company's future operations
• Calculate Weighted Average Cost of Capital by using the Capital Asset Pricing Model
• Determining the company's "Beta"
• Determine the Cost of Debt, Preferred Equity and Common Equity
• Develop the EVA?? Model
• Impact of Acquisitions on WACC

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 PV, FV, NPV, IRR, MIRR
• Using MIRR and a basis for capital project evaluation

Evaluating Capital Project Proposals

• Identify the various types of capital projects
• Discuss the capital project evaluation process
• Determining the initial and subsequent capital project cash flows
• Development of the "Hurdle Rate" for capital projects
• Discuss the use of "Terminal Value" in evaluating capital projects
• Evaluate capital projects by applying NPV, IRR, MIRR, and Discounted Payback Models 

Evaluating the Leasing Option

• Why Lease?
• Leases from American and International perspectives
• Identify the various types of leases
• Discuss the lease evaluation process
• Determining the initial and subsequent cash flows related to leases
• Development of the "Hurdle Rate" for leases
• Discuss the use of "Terminal Value" in evaluating the lease option
• Evaluate leases by applying NPV, IRR, MIRR, and Discounted Payback models 

Evaluating Acquisitions and Divestitures

• Understand the nature of Acquisitions and Divestitures (Business Combinations)
• The strategic reasons for Acquisitions and Divestitures
• Pricing a company for sale
• Evaluation of Synergies in an Acquisition
• Discussion of Due Diligence
• The essential components of the Acquisition Team
• The major Takeover Defenses

Analyzing The Annual Report

• Ratio Analysis - The heart of Financial Analysis
• Use Excel?? templates to calculate and interpret liquidity, leverage and profitability ratios
• Interpret the results of ratio analysis from an accrual accounting perspective
• The inter-relationship between the DuPont Formula and EVA?? 
• How to use the Altman Z-Score
• Use various investment surveys to benchmark the results of financial analysis

Cash Flow Analysis and Cash Planning

• Understanding the Cash Flow Statement
• Using the Cash Flow Statement to identify accounting irregularities
• Determine Cash Flows related to Operations, Investing, and Financing activities
• Evaluate the various calculations of "Free Cash Flow"
• Understand the difference between accrual and cash ratios
• Use Excel?? templates to calculate and interpret cash-based liquidity, leverage and profitability ratios
• Interpret the results of ratio analysis from a cash accounting perspective

Comprehensive Case Exercise

• In order to enhance and reinforce the tools, skills and concepts presented in this program, you will work as part of a financial analysis team, evaluate the financial reports of a real company and present the results of your evaluation

A variety of methodologies will be used during the course that includes:

·         (30%) Based on Case Studies

·         (30%) Techniques 

·         (30%) Role Play

·         (10%) Concepts

·         Pre-test and Post-test

·         Variety of Learning Methods

·         Lectures

·         Case Studies and Self Questionaires

·         Group Work

·         Discussion

·         Presentation

This rate includes participant’s manual, Hand-Outs, buffet lunch, coffee/tea on arrival, morning & afternoon of each day.

Daily Course Timings:

    08:00 - 08:20       Morning Coffee / Tea

    08:20 - 10:00       First Session

    10:00 - 10:20       Coffee / Tea / Snacks

    10:20 - 12:20       Second Session

    12:20 - 13:30       Lunch Break & Prayer Break

    13:30 - 15:00       Last Session