(Click Category to List Courses)

24 - AAU - Accounting and Financial Auditing


AAU 115 - Workshop on Financial Modeling in Excel

Code Start Date Duration Venue Fees
AAU 115 20 October 2019 5 Days Istanbul $ 2950 Registration Form Link
AAU 115 17 November 2019 5 Days Istanbul $ 2950 Registration Form Link
AAU 115 15 December 2019 5 Days Istanbul $ 2950 Registration Form Link
AAU 115 05 January 2020 5 Days Istanbul $ 2950 Registration Form Link
AAU 115 02 February 2020 5 Days Istanbul $ 2950 Registration Form Link
AAU 115 29 March 2020 5 Days Istanbul $ 2950 Registration Form Link
AAU 115 26 April 2020 5 Days Istanbul $ 2950 Registration Form Link
AAU 115 31 May 2020 5 Days Istanbul $ 2950 Registration Form Link
AAU 115 21 June 2020 5 Days Istanbul $ 2950 Registration Form Link
AAU 115 19 July 2020 5 Days Istanbul $ 2950 Registration Form Link
AAU 115 16 August 2020 5 Days Istanbul $ 2950 Registration Form Link
AAU 115 13 September 2020 5 Days Istanbul $ 2950 Registration Form Link
AAU 115 11 October 2020 5 Days Istanbul $ 2950 Registration Form Link
AAU 115 08 November 2020 5 Days Istanbul $ 2950 Registration Form Link
AAU 115 06 December 2020 5 Days Istanbul $ 2950 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?

  • Anyone who wants to learn the corporate accounting and corporate finance,
  • Auditors of financial models,
  • Bankers,
  • Financial consultants,
  • Graduate and undergraduate students in business, finance, accounting, banking,
  • Finance managers and officers.

Course Details/Schedule

Day 1

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

Day 2

  • Excel and preparation for financial modelling, puthing every thing together
  • 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

Day 4

  • Cash sweeps, Recording Macros and On screen toolbars:
  • Cash sweeps
  • Recording Macros and On screen toolbars

Day 5

  • 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 cash flow
  • NPV, IRR, FCFF, FCFE, DCF