Financial Modelling

FINANCIAL MODELLING

  • PURPOSE

  • COURSE CONTENT

  • DELIVERY

  • ACCREDITATION

While knowing Microsoft Excel's basic and intermediate capabilities is beneficial, for some, simply automating the day-to-day mathematical processes involved in a simple balance sheet may not suffice to meet a major company's financial accounting needs. A more in-depth knowledge is required.
This course will equip you with the skills to significantly improve your company’s control of its financials.

The following topics are covered:
• Creating reports from multiple sources
• Simplifying reporting
• Reconciliation model
• Creating reports where actuals, budgets and prior years change with lists
• Compiling an age analysis in five minutes
• Amortisation tables

  • Unit 1: Creating reports from multiple sources
    1. Creating a pivot table to use as a database
    2. Consolidating multiple pivot tables
    3. Updating multiple pivot tables

  • Unit 2: Converting multiple columns into a database format
    1. Converting multiple columns into a
      database format
  • Unit 3: Simplifying reporting
    1. Introduction
    2. Setting up the structure
    3. Checking source data
    4. Consolidating source data
    5. Creating a mapping table, mapping data and
      validating mapping
    6. Completing the report
  • Unit 4: Automatic reconciliations
    1. Introduction
    2. Numbering data automatically and making it
      unique
    3. Steps in reconciling data (one list)
    4. Reconciling two list
  • Unit 5: Reporting by using the indirect formula
    1. Introduction
    2. Using indirect formula to report on column
      format data
  • Unit 6: Compiling an age analysis
    1. Introduction
    2. Fixing the dates and calculating the number
      of days
    3. Creating a mapping table
    4. Finishing an age analysis and reporting
  • Unit 7: Amortisation tables
    1. Amortisation tables where the rates stay
      consistent
    2. Amortisation tables where the rates and
      capital payments can change
  • Unit 8: Cash flows
    1. Introduction
    2. Fixing the signage
    3. Creating adjustment columns
    4. Creating a mapping table
    5. Finishing the cash flow statement
  •  

Duration: 1 Day

Delivery: Classroom/Online

 

5 Day Courses: Participants will receive a SpecCon Holdings certificate upon completion of all courses.

1 Day Courses: Participants will receive a SpecCon Holdings certificate upon completion of this course.

Other Related Courses