Financial Statement Analysis using Excel

Program

Objectives:

  • Enter and Format data in Excel
  • Use Formulas and Conditionals in Excel
  • Create Charts in Excel
  • Use Excel to perform Time Value of Money calculations
  • Analyse the three Financial Statements using Excel:
    • the income statement
    • balance sheet
    • statement of cash flows

Navigation and Data

  • Navigation, Arrow Keys, SHIFT & CTRL
  • Inserting & Editing Cells, Rows and Columns
  • Deleting Cells & Commenting
  • Freezing Rows & Splitting the Screen
  • Special Paste: Your New Best Friend
  • Sorting
  • Filtering

Formatting and Style

  • Introduction to Formatting & Style
  • Formatting Walkthrough
  • The Five Rules for Financial Modeling
  • Cell Dimensions
  • Styling Fundamentals
  • Styling Practice
  • Special Paste Review
  • Applying Special Paste to the Model
  • Best Practices for Number Formatting
  • Forward Multiples
  • Negative Numbers & Percentages
  • Go To Special
  • Grouping Data

Formulas and Conditionals

  • Introduction to Formulas & Conditionals
  • Best Practices for Formulas and Conditionals
  • Relative and Absolute Values Part 1
  • Relative and Absolute Values Part 2
  • Sum, Max, Min, Average
  • Median, Rank, Percentile, Bonus
  • Concatenation Part 1
  • Concatenation Part 2
  • IF
  • Asking IF Twice
  • Formula Error
  • AND
  • OR
  • SMALL
  • SUMIF
  • SUMPRODUCT
  • COUNT, COUNTA, COUNTIF
  • COUNTIFS
  • INDIRECT
  • INDEX
  • MATCH
  • INDEX and MATCH
  • Cell Color
  • Custom Formulas
  • Hidden Values
  • Test

Charts

  • Introduction to Charts
  • Best Practices for Charts
  • The Basics
  • Selecting Data In Column Cahrts
  • Customize Your Chart Part 1
  • Customize Your Chart Part 2
  • Line
  • Columns

Time Value of Money

  • Understand and be able to apply the concepts of the time value of money.
  • Recognize the sensitivity of financial payoffs to changes in interest rates and other conditions that business managers must cope with.
  • Tailor a series of future cash inflows or outflows necessary to satisfy present or future business objectives.
  • Use Excel’s financial commands to convert future values to their equivalent present values, and vice versa.
  • Use Excel’s financial commands to determine the net present value of a series of future cash flows.
  • Calculate periodic payments for mortgages and other loans to identify how much of each payment goes to paying off the principal and how much goes to paying interest.
  • Use Excel’s Goal Seek and Solver tools to achieve an objective.
  • Create one- and two-variable input tables to do sensitivity analysis.

Financial Statement Analysis

  • Create spreadsheets for financial statements
  • Identify the three key financial statements of corporations (i.e., the income statement, balancesheet, and statement of cash flows) and describe their contents and purposes.
  • Follow the standard formats for organizing items on financial statements.
  • Interpret the items on financial statements and recognize how they’re related.
  • Recognize when errors have been made in financial statements.

Forecasting

  • Use Excel’s Chart Wizard to create a scatter plot of a set of data values.
  • Select noncontiguous cell ranges for plotting.
  • Insert different types of trend lines on a scatter plot to see which best fits a set of data values.
  • Use Excel commands (e.g., INTERCEPT, SLOPE, and CORREL) and tools (e.g., LINESTand LOGEST) to create a statistical model that follows the trend of historical data for annual revenues.
  • 1. Business analysts
  • 2. Researchers
  • 3. Controllers
  • 4. Consultants
  • 5. Small and medium business owners
  • 6. Startups founders
  • 12 Hours

    Rs. 12,000

    For further details regarding contents,
    E-mail: training@bseindia.com