Financial Modelling for Budgeting and Forecasting in Excel

by Global Business Advisors (Corporate Training Providers)

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.

£3950

Contact the Institutes

Fill this form

Advertisement

Global Business Advisors (Corporate Training Providers) Logo

img Duration

5 Days

Course Details

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.

 

Objective

  • 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

 

  • Central London Branch

    20-22 Wenlock Road, London, Central London, London
  • Broughton Branch

    Brooklands, Milton Keynes MK10 7LQ, Broughton, Milton Keynes

Check out more Financial Modeling courses in UK

LEORON Institute UK Logo

Financial Modelling Master

The course will emphasize some important financial concepts that will assist in building vigorous models. It is designed to give you the information you need without making you wade through cumbersome explanations and endless technical background.

by LEORON Institute UK [Claim Listing ]
CCTD (Centre for Capacity Training and Development) Logo

Financial Modelling

Financial Modelling is designed for senior secretaries, executive secretaries, personal assistants and top-level management secretaries aiming to improve their performance and maximise opportunities for promotion to executive positions.

by CCTD (Centre for Capacity Training and Development) [Claim Listing ]
Boston Institute of Analytics Logo

Financial Analysis and Modelling

Learn to use conceptual knowledge, practical and functional skills to design and implement precise financial solutions.

by Boston Institute of Analytics [Claim Listing ]
City Training UK Logo

Financial Modelling

Using best practice modelling rules and Excel shortcuts, based on real historical financial statements, participants will learn how to forecast and put together a fully integrated financial model. This training will give them the basic modelling fundamentals to continue working on their in-house m...

by City Training UK [Claim Listing ]
  • Price
  • Start Date
  • Duration
BPP Professional Education Logo

Financial Modelling - Advanced (& Introduction to VBA)

This two-day course is designed for those looking to expand their financial modelling skills. Numerous hands-on practical Excel exercises are used to demonstrate different functionality in a modelling context.

by BPP Professional Education [Claim Listing ]

© 2024 coursetakers.com All Rights Reserved. Terms and Conditions of use | Privacy Policy