Introduction To Financial Modelling with Excel

by Kaplan UK Claim Listing

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.

Price : Enquire Now

Contact the Institutes

Fill this form

Advertisement

Kaplan UK Logo

img Duration

Please Enquire

Course Details

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.

 

Learning Outcomes:

  • Learn and apply Excel tools useful in financial forecasting
  • Understand and design the layout of a flexible model
  • Forecast financial statements of a public or private company
  • Apply scenario analysis to the forecasted financial statements
  • Prepare charts for data presentation

 

Key Topics:

  • Overview of financial modelling
  • Excel tools used in financial modelling
  • Model design and structure for the case study company
  • Know the key model outputs and their drivers and understand the requisite inputs
  • Developing cell styles for model transparency and review
  • Incorporating historical financial statements of the subject company
  • Building balance sheet error checks in the model
  • Forecasting financial statements: forecasting revenue and key operating expenses
  • Projecting key schedules: debt and interest, capex and depreciation, and working capital
  • Stepwise projection of income state
  • London Branch

    179-191 Borough High Street, London
  • Birmingham Branch

    Baskerville House, 2 Centenary Square, Birmingham
  • Reading Branch

    on Ground and 1st Floor, The Blade, Abbey Square, Reading
  • Southampton Branch

    Broadcasting House, 10 Havelock Road, Southampton
  • Nottingham Branch

    n 3rd Floor, Alan House, 5 Clumber Street, Nottingham
  • Newcastle Branch

    2nd Floor Provincial House, 148 - 152 Northumberland Street, Newcastle
  • Milton Keynes Branch

    564-598 Elder House, Elder Gate, Milton Keynes
  • Manchester Branch

    6th Floor, St James Building, 79 Oxford Street, Manchester
  • Liverpool Branch

    n 4th Floor Cotton House, Old Hall St, Liverpool
  • Leicester Branch

    _on 2nd Floor, Enkalon House, 86-92 Regent Road, Leicester
  • Leeds Branch

    1st Floor, City Exchange, 11 Albion Street, Leeds
  • Glasgow Branch

    2nd Floor, 112 West George Street, Glasgow
  • Cardiff Branch

    n Clayton Hotel, St Mary Street, Cardiff
  • Bristol Branch

    1st Floor Linear Park, Avon Street, Bristol
  • Glasgow Branch

    2nd Floor, 112 West George Street, Glasgow

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 ]
Global Business Advisors (Corporate Training Providers) Logo

Financial Modelling for Budgeting and Forecasting in Excel

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 Global Business Advisors (Corporate Training Providers)
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