Corporate training in the Gulf, London, Europe & Asia since 2015
+44 7462 102778[email protected]WhatsAppالعربية
Enquire now
CoursesSubjectsVenuesIn-House TrainingWhy ARUKContactالعربيةEnquire now
AF-022

Financial Analysis Modeling and Forecasting

Intensive 5-day course · English, Arabic & European languages

Management relies on financial projections to make informed decisions. Throughout this course, delegates learn to analyse financial performance. They then build forecasting models using Microsoft Excel. The programme covers ratio analysis, the time value of money, and techniques for modelling the income statement, balance sheet, and cash flow statement.

Classroom

Public courses in our cities

  • 19–23 Oct 2026Paris£3,600 + VAT
  • 19–23 Oct 2026Abu Dhabi£4,200 + VAT
  • 2–6 Nov 2026Frankfurt£2,600 + VAT
  • 16–20 Nov 2026Jeddah£4,200 + VAT
  • 7–11 Dec 2026Muscat£3,080 + VAT
  • 21–25 Dec 2026Barcelona£3,080 + VAT
Show 24 more dates
  • 4–8 Jan 2027Berlin£3,400 + VAT
  • 18–22 Jan 2027Vienna£3,400 + VAT
  • 1–5 Feb 2027Milan£3,400 + VAT
  • 15–19 Feb 2027Barcelona£3,080 + VAT
  • 1–5 Mar 2027Malaga£3,080 + VAT
  • 15–19 Mar 2027Paris£3,600 + VAT
  • 5–9 Apr 2027Frankfurt£2,600 + VAT
  • 19–23 Apr 2027Sarajevo£3,400 + VAT
  • 3–7 May 2027Dubai£4,200 + VAT
  • 17–21 May 2027Barcelona£3,080 + VAT
  • 7–11 Jun 2027Riyadh£4,200 + VAT
  • 21–25 Jun 2027Vienna£3,400 + VAT
  • 5–9 Jul 2027Doha£4,200 + VAT
  • 19–23 Jul 2027Barcelona£3,080 + VAT
  • 2–6 Aug 2027Geneva£4,200 + VAT
  • 16–20 Aug 2027Paris£3,600 + VAT
  • 6–10 Sep 2027Frankfurt£2,600 + VAT
  • 20–24 Sep 2027Abu Dhabi£4,200 + VAT
  • 4–8 Oct 2027Cairo£2,280 + VAT
  • 18–22 Oct 2027Barcelona£3,080 + VAT
  • 1–5 Nov 2027Jeddah£4,200 + VAT
  • 15–19 Nov 2027Vienna£3,400 + VAT
  • 6–10 Dec 2027Singapore£4,200 + VAT
  • 20–24 Dec 2027Barcelona£3,080 + VAT

Group discount: 2 delegates 20% · 3 delegates 35% · 5 or more delegates 50%

Can't make these dates? We can run this course for your team on dates that suit you. Ask for custom dates · In-house options

Online (live)

With a trainer, on dates to suit your team

This course can be taught live online by a trainer, in English, Arabic or any European language, for one person or a whole team.

£1,850 + VAT

Group discount: 2 delegates 20% · 3 delegates 35% · 5 or more delegates 50%

Special requests

Tailor this course

Pick what you want changed and we’ll come back with a proposal and price.

Special request

Financial Analysis Modeling and Forecasting

What would you like to change? (pick any)
or

Course overview

Financial professionals are frequently asked to predict how a business will perform under different scenarios. Doing this accurately requires strong analytical skills. It also requires the ability to build flexible models in Excel. This course teaches delegates how to interpret past performance, before using it as a reliable baseline for future projections.

The programme starts with financial analysis, showing delegates how to perform vertical, horizontal, and trend analysis. Delegates calculate and interpret a wide range of ratios. These cover liquidity, solvency, profitability, and asset management. They explore the DuPont models. They also evaluate cash flow patterns to determine the quality of earnings.

The second half of the course focuses entirely on Excel modelling. Delegates practice calculating Present Value, Net Present Value, and Internal Rate of Return using built-in functions. They then learn to construct interactive models using data tables, Goal Seek, and form controls like spinners and option boxes. The final modules walk delegates through the process of forecasting sales, expenses, and asset requirements. This hands-on practice culminates in building a complete set of projected financial statements.

Course objectives

By the end of the course, delegates will be able to:

  1. Interpret organisational performance using financial ratio analysis
  2. Calculate ratios related to the cash flow statement
  3. Calculate the time value of money using Microsoft Excel
  4. Build interactive models using Excel form controls
  5. Forecast sales and operating expenses
  6. Build complete models for the three primary financial statements

Target competencies

  • Financial analysis
  • Vertical, horizontal, and trend analysis
  • Financial forecasting
  • Modelling financial statements
  • Applying Excel functions

Who should attend

This course suits:

  • Financial controllers
  • Finance analysts
  • Finance and accounting managers
  • Supervisors and finance professionals

Training methodology

  • Hands-on workshop format
  • Practical Excel exercises
  • Case study analysis

Course modules

  1. Module 1

    Financial analysis techniques

    • Applying vertical analysis to strategy
    • Conducting horizontal and trend analysis
  2. Module 2

    Liquidity analysis

    • Calculating current, quick, and cash ratios, defensive intervals, and cash conversion cycles
  3. Module 3

    Asset management and activity ratios

    • Calculating total asset turnover
    • Measuring fixed asset turnover
  4. Module 4

    Solvency analysis

    • Calculating debt and equity ratios
    • Measuring times interest earned
  5. Module 5

    Profitability analysis

    • Calculating profit and gross margins, returns on assets and equity, and EBITDA
  6. Module 6

    Market and valuation

    • Using price-earnings and earnings-per-share ratios
    • The three-step and five-step DuPont models
    • Understanding the limitations of ratio analysis
  7. Module 7

    Interpreting the cash flow statement

    • Operating, investing, and financing cash flows
    • Identifying cash flow patterns and cash cows
  8. Module 8

    Cash-flow ratios

    • Assessing the quality of earnings
    • Evaluating financial management
    • Measuring mandatory cash flow
    • Calculating discretionary cash flow
  9. Module 9

    Financial calculations in Excel

    • The time value of money
    • Calculating Present Value (PV) and Net Present Value (NPV)
    • Calculating Internal Rate of Return (IRR) and Multiple IRR (MIRR)
    • Using the XNPV and XIRR functions
    • Calculating effective yields and returns
  10. Module 10

    Model construction techniques

    • Using data tables
    • Applying Goal Seek
    • Modelling with spinner controls
    • Modelling with list boxes
    • Modelling with option boxes
  11. Module 11

    Modelling projected financial statements

    • Incorporating micro and macro factors
  12. Module 12

    Forecasting sales and statements

    • Estimating overall market demand
    • Estimating company demand
    • Developing a sales forecast
    • Forecasting the cost of sales
    • Forecasting operating expenses
    • Projecting key asset and liability accounts
    • Modelling the income statement
    • Modelling the balance sheet
    • Modelling the cash flow statement

Certificate

Every delegate who completes the course receives an ARUK Training Certificate of Attendance.

Frequently asked questions

How do I register?

Choose a date and city in the schedule and press Register, or send us an enquiry. Our team confirms your place and sends an invoice.

Are fees shown with VAT?

Fees are shown per delegate and exclude VAT, which is added to the invoice where applicable.

Can this course be delivered for our team only?

Yes. Any ARUK course can be delivered in-house at your premises, in a meeting room we book for you, or 1-to-1.

Is this course available online?

Yes. We run it live online with a trainer, on dates that suit your team, for £1,850 + VAT per delegate.

Is there a group discount?

Yes. 20% for 2 delegates, 35% for 3 delegates and 50% for 5 or more delegates on the same course.

Can the course be delivered in Arabic or another language?

Yes. Our courses can be delivered in English, Arabic or any European language, by a trainer who teaches in that language. Mention your preferred language when you register or enquire.

What certificate will I receive?

An ARUK Training Certificate of Attendance.

Related courses

Register

Financial Analysis Modeling and Forecasting

Key booking terms (read before you register)
  • The full fee is paid in advance, before the course starts.
  • Cancel in writing 30 or more days before the start date (45 for in-house) for a refund. Later than that, the full fee is payable.
  • No refund for non-attendance or partial attendance.
  • Places are for the named delegate only; another person cannot attend instead.
  • Moving to another date or city is only possible if ARUK agrees in writing.
  • Travel, accommodation and visas are your responsibility. A refused visa does not change the cancellation terms.

booking terms and conditions

Get a quotation

Financial Analysis Modeling and Forecasting