K MENA Three Statement Modeling & Valuation

What does the Three Statement Modeling Program Cover?

This program equips candidates with the knowledge and tools required to build models from scratch, hence equipping you with the skills required to develop a fully integrated three statement financial model and perform equity valuation.

The Three statement modelling program  by Kaplan Middle East & North Africa is approved by KHDA in the UAE.

Learning Objectives

icon

Understand how to plan the model design and structure

icon

Forecast financial statements

icon

Develop consistent and review friendly models

icon

Understand how to perform a flexible DCF valuation

icon

Perform scenario and sensitivity analysis

img

Who is it for?

The course is suitable for anyone who wants to develop their core financial modeling skills. Professionals and graduate students working or aspiring to work in asset management, investment banking, sovereign wealth funds, private equity, corporate finance, corporate banking and equity research can pursue this course.

Program Agenda

Modifying key default Excel settings for efficiency

Custom number formatting

Setting up the Quick Access Toolbar

Creating and modifying cell styles template

Understanding and applying industry best practices for model formatting, structure and readability

Incorporate model checks to ensure accuracy and build overall confidence in the model

Understand fundamentals of valuing shares and apply on a listed stock

Build an integrated three statement model (income statement, Balance Sheet and cash flow) for forecasting the financial performance of a real-life company

Construct various schedules for forecasting key line items of the financial statements (such as revenue, cost, PPE and intangibles, debt, working capital and equity)

Apply various forecasting methods (top-down vs. bottom-up approach)

What Our Students Say

See All
Financial Modelling (2019) – Eva Reinerova
56 months ago
Financial Modelling (2019) – Eva Reinerova

The trainers at Kaplan Middle East & North Africa are very understanding, knowledgeable, and patient. I have studied for the CMA and CFA courses, therefore I know the quality of the training team. They are very experienced in terms of industry and course expertise.

Watch now
Financial Modelling (2019) – Nikhil Kapoor
58 months ago
Financial Modelling (2019) – Nikhil Kapoor

Rahul is a fantastic trainer who is very coherent and gets his ideas across perfectly. He takes his time to answer all questions in-depth and ensures we learn the concepts thoroughly. I would 100% recommend Kaplan Middle East & North Africa to everyone.

Watch now
Financial Modelling (2019) – Tichaona Maviyo
75 months ago
Financial Modelling (2019) – Tichaona Maviyo

Rahul was exceptional! He ensured that he explained the concepts really well and I truly felt like I got more value than I paid for. I received financial modeling manuals, case studies, and beyond classroom support that has helped me develop models efficiently.

Watch now
Financial Modelling (2019) – Umar Masood
75 months ago
Financial Modelling (2019) – Umar Masood

The course has been really detailed right from the steps to follow to the outcomes to expect. I would highly recommend the course to anyone that would like to learn about the practical application of financial models.

Watch now
56 months ago
Bank Financial Statements Analysis – Private Banking Company (2021)

This is one of the best courses I have attended. The course was very well instructed and very beneficial to our scope of business such as analyzing the ratios and going deeper into financial analysis.

Request a Call Back

The answer to your doubts is just a click away! Simply fill in your details in the form, and we will get in touch with you shortly.