Business Analysis using EXCEL

Theme

Key Topics

Introduction

Overview of EXCEL, Named Ranges and Array Formulas

Income Statement

Reporting Method, Operating and Non-operating Segments, General Journal to the Income Statement, Absolute, Relative, and Mixed References, Ledger Data to the Income Statement, Financial Analyses with Accrual Accounting, Straight-Line Depreciation, Trial Balance, Traditional Versus Contribution Approach

Current Assets

Understanding Debit and Credit Entries, Current Asset Cash Balance, Multiple Cash Accounts, Accounts Receivable Balance, Doubtful Accounts, Estimating Uncollectibles, Percentage of Sales Approach, Prepaid Expenses Balance

Inventories

Perpetual and Periodic Inventory Systems, Valuing Inventories (Specific Identification, Average Cost, Moving Average, FIFO, LIFO), Comparing the Valuation Methods, Purchase Discounts, Turns Ratios

Transactions

Understanding Journals, Dynamic Range Names, Understanding Ledgers, Getting a Current Liabilities Balance

Working Capital & Cash Flow Analysis

Matching Costs and Revenues, Cash Versus Working Capital, Amount and Changes, Analysing Cash Flow, Sources and Uses of Working Capital, Cash Flows Due to Operating Activities, Cash from Non-operating Transactions

Financial Statement Analysis

Common-Sizing of Income statement, Balance sheet and Cash flow statement, Dollar and Percent Changes, Variance Analysis, Ratio to Ratio Comparisons

Ratio Analysis

Industry Averages and Trends, Comparing Ratios Within Industries, Vertically and Horizontally, basis for Ratios, Analysing Profitability Ratios, Analysing Leverage Ratios, Analysing Liquidity Ratios, Analysing Activity Ratios

Budgeting and Planning

Creating Pro Forma Financial Statements, Sensitivity Analysis, Pro Forma to the Budget, Estimating Inventory Levels

Forecasting & Projections

Baseline, Moving Average Forecasts, Forecasting with Excel’s Regression Functions, TREND, GROWTH, Forecasting with Excel’s Smoothing Functions, Seasonal Data, Box-Jenkins ARIMA Approach, Correlograms, Other Box-Jenkins Models

Quality Measurement

Statistical Process Control, Using Averages, X-and-S Charts, Control Limits, P-Charts for Dichotomies, Sample Size, Out of Control, X-and-MR Charts, Operating Characteristic Curve, Sampling Units from a Finite Population and non-finite population

Investment Decisions

Payback Periods, Future Value, Present Value, and Net Present Value, Optimizing Costs, Managing Scenarios, Measuring Profit, Internal Rate of Return, Profitability Index, Varying the Discount Rate Input, Goal Seek Tool

Profit Planning

Effects of Leverage, Operating Leverage, Fixed Expenses, Using the DOL, Analysing Financial Leverage, Debt Ratio, Times Interest Earned Ratio

Uncertain Conditions

Standard Deviations, Confidence Intervals, Regression Analysis in Decision Making, Trend line, Multiple Regression, Interpreting Regression Output

Fixed Assets

Original Cost, Depreciating Assets, Straight-Line Depreciation, Declining Balance Method, Double Declining Balance Function, Variable Declining Balance Depreciation, Sum-of-Years’-Digits Depreciation

Contributions and Margins

Contribution Margin, Unit Contribution, Break-Even Point, Assumptions in Contribution Analysis, Linear Relationships, Determining Sales Mix

Pricing

Absorption and Contribution Costing, Contribution Analysis for New Products, Effect of Cross-Elasticity

Faculty profile

FEES

Based on the syllabus, contents and other requirements for the corporate training, scope with detailed inclusions and exclusions along with the fee will be shared.