Financial Modelling For Budgeting and Forecasting in Excel

Location
United Kingdom
Dates
Dates flexible
Course Type
Professional Training Course
Accreditation
Yes (Details)
Language
English
Course Fee
$4,500

Course Overview

In this course you will learn to build a financial model by working in Excel and how to perform sensitivity analysis in Excel. You will also learn the formulas, functions and types of financial analysis to be an Excel power user. By attending this course, you will be able to effectively prepare and build financial models.

Who should take this course

Professionals in corporate finance, financial analysts, investment bankers, financial controllers, finance managers, professionals responsible for project valuation, project finance, portfolio managers, financial accountants, financial controllers, finance managers, accounting and finance personnel.

Accreditation

CPD (Continula Professional Development) accredited by the CPD

Course content

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

  • Apply a structured approach to financial modelling in Excel
  • Outline the hallmarks of good financial models
  • Explain the importance of planning, and prep your model structure
  • Build from operating revenues down to operating profit
  • Forecast property, plant and equipment and other operating assets
  • Forecast the various components of working capital
  • Forecast debt financing and related interest costs
  • Forecast equity financing and dividends
  • Use an iterative analytic approach to managing circular references
  • Understand the importance of error checking
  • Derive a forecast cash flow statement based on a forecast income statement and balance sheet
  • Perform Financial Model integration

About Course Provider

Global Business Advisors Ltd came into being in 2016, with the vision of extending the best services, to the global market, in the upcoming field of IT Services. GBA, with the sile aim of doing its best, started its first venture, "GBA IT Services" dealing with E-Commerce Customized Portal B2B, B2C portal, Software development, SEO and much more making GBA a name to rely upon worldwide. With all efforts, hard work, and unfathomable dedication, success started pouring in GBA, then Started a new venture as "GBA Healthcare" providing Health Care Assistants, Nurses to Private Hospitals, Nursing Homes, serving old people in UK as well in Europe.

Having insatiable hunger for serving people, and supporting them in their path of development, efforts of research and analysis wing, GBA Corporate is now a name to be reckoned with. GBA Corporate is a London Professional Training Centre, providing professional training and is one of the fastest growing UK based training organisation. We are working in the mentioned niche market with over 200 Courses, organized across the globe. GBA corporate's impact on Private organisation, Government Sector, group of expatriates or individuals, through results-oriented programmes and solutions, has brought appreciative changes.

Our motive is to improve and upgrade performance through relevant, pioneering programmes that enable you to explore new horizons, learning in multi-cultural environment. We try to become your training partner, mentor and guide as you explore and march on a journey to realise the full potential. We prepare you to meet challenge and face every hurdle to embrace new horizons, relevant new ideas and perspectives. Our program reflects new ideas and perspectives and also the need for practical solutions to go deep down into the ocean of knowledge. Our course leaders and instructors are well versed in their fields and tailor content to coach and guide you to identify and achieve the desired goals.

We pride ourselves on our track record and on our long-standing relationships with our clients, many of whom have been with us since we started business.

How to enroll?

Provide us with your contact details, course provider will get back to you.

A representative from GBA Corporate will contact you soon.