(Click Category to List Courses)

30 - AAU - Accounting and Financial Auditing


AAU-ON 115 - Workshop on Financial Modeling in Excel (4 Days)

Code Start Date Duration Venue Fees
AAU-ON 115 13 June 2021 4 Days Online $ 1960 Registration Form Link
AAU-ON 115 11 July 2021 4 Days Online $ 1960 Registration Form Link
AAU-ON 115 08 August 2021 4 Days Online $ 1960 Registration Form Link
AAU-ON 115 05 September 2021 4 Days Online $ 1960 Registration Form Link
AAU-ON 115 31 October 2021 4 Days Online $ 1960 Registration Form Link
AAU-ON 115 28 November 2021 4 Days Online $ 1960 Registration Form Link
AAU-ON 115 26 December 2021 4 Days Online $ 1960 Registration Form Link
DOWNLOAD PDF

 

Course Description

The ability to create, understand the financial models is one of the most valued skills in the field of business and finance. Whether beginners in their career, an experienced finance officer, or students who soon start career, having this skill will provide participants competitive advantage in what they want to do.

This course will first recall the accounting, finance, and spreadsheets concepts and then teach participants how to combine all these three to build a professional financial model. By the end of this course, they will have created a professional, working, dynamic spreadsheet financial model that they can use to make projection for industrial/manufacturing firms.

Course Objectives

  • Recalling a basic understanding of accounting, finance and spread sheets,
  • Being able to professionally use of spread sheet for designing a professional financial model,
  • Gaining the self-confidence for the working with financial models.

Who Should Attend?

  • Bankers,
  • Finance managers and officers
  • Auditors of financial models,
  • Financial consultants,
  • Anyone who wants to learn the corporate accounting and corporate finance.

Course Details/Schedule

Day 1

  • Excel and preparation for financial modelling    
  • Key principles in modeling
  • Customizing your own toolbar and creating template for financial modeling
  • Financial FUNCTIONS
  • Recalling accounting principles
  • Low income statement, balance sheet and cash flow connects with each other
  • Historical accounts versus projected accounts

Day 2

  • Excel and preparation for financial modelling
  • How to build an income statement, balance sheet and cash flow from scratch
  • Employing two different ways to balance the balance sheet
  • Reconciliations
  • How to link income statement with balance sheet
  • Structuring our model, designing the required sheets

Day 3

  • Reviewing the key principles of forecasting
  • Income statement forecasting
  • Balance sheet forecasting
  • Cash sweeps
  • Recording Macros
  • On screen toolbars

Day 4

  • Working with excel forms and time value of money
  • Different controls to use
  • Scenario analysis
  • Data validation and model auditing
  • Conditional formatting
  • Time value of money and Free cashflow
  • NPV, IRR, FCFF, FCFE, DCF