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

Ascent Training Wales Logo

Financial Modelling and Analysis course

This course provides a comprehensive exploration of advanced financial modelling techniques, data analysis methods, and analytical tools, offering the knowledge and practical skills needed to make sound financial decisions.

by Ascent Training Wales [Claim Listing ]
Kaplan UK Logo

Introduction To Financial Modelling with Excel

You'll cover the principles and practice of financial modelling, focusing on a case study involving the construction of an integrated set of financial statements, and subsequent investment appraisal.

by Kaplan UK [Claim Listing ]
LMC (London Management Centre) Logo

Financial Modelling And Decision Making

The modern business professional needs to be able to use spreadsheet software such as Excel to support good business decisions. This course offers training in the enhanced use of spreadsheets to support both short-term and long-term financial decisions.

by LMC (London Management Centre) [Claim Listing ]
London IT Training (LIT) Logo

Financial Modelling Training

In this course, you are going to learn to make such financial forecasts based on the previous performance of the business and forecasting the future progress with the help of income statement, cash flow statement, balance sheet and so on.

by London IT Training (LIT)
Clearly Financial Markets Professional Training Logo

Financial Modelling

Financial Modelling training is offered by Clearly Financial Markets Professional Training for all skill level. Clearly Financial Markets provide a wide range of courses for our clients.

by Clearly Financial Markets Professional Training [Claim Listing ]

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