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

Financial Fluency Logo

Financial Modelling

We offer courses in financial spreadsheet modeling for both finance professionals. If you are looking for an introduction to financial modeling, a practical guide, a refresher or to enhance your existing understanding then we have the right course for you.

by Financial Fluency [Claim Listing ]
BMC Training and Development Logo

Foundations Of Financial Modeling Training

This course is designed to develop your financial modeling skills through the evaluation and analysis of real-life case studies. It will also develop your knowledge and understanding of finance enabling you to make financial decisions, which will reduce costs, increase profit and minimize risk.

by BMC Training and Development
Cambridge Finance Logo

Certificate in Real Estate Financial Modelling

This is an exclusive programme offered by Cambridge Finance and in line with the Royal Institution of Chartered Surveyors (RICS) financial modelling competency.

by Cambridge Finance [Claim Listing ]
Berkeleyme School of Management and Sciences Logo

Certificate in Advanced Financial Modeling and Valuation

Hands-on practical training course to help you learn exactly what is required to do in your daily work. Up-skill your knowledge to be a Financial Analyst. Practical assignments, illustration spreadsheets, excel shortcuts- all included and can be downloaded at your end for self-practice.

by Berkeleyme School of Management and Sciences [Claim Listing ]
London IT Training (LIT) Logo

Financial Modeling Training

A financial model is a tool that usually comes as an integrated part of any ‘spreadsheet software’, like Microsoft Excel to forecast the financial prediction of the business in the future. I

by London IT Training (LIT)

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