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

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 ]
STL Logo

Excel Financial Modelling Training Course

Specifically designed for finance professionals, this Excel Training for Finance Specialist London is the perfect course for those working with budgets on a regular basis. Further to this syllabus, many delegates went on to take the Effective Budgeting and Beyond course.

by STL [Claim Listing ]
Quartic Training Limited Logo

Financial Modelling

You will learn essential, best practice financial modelling techniques, and how to apply them in different situations, giving you the confidence and ability to develop sophisticated financial models.

by Quartic Training Limited [Claim Listing ]
Euromoney Learning Logo

Project Finance Modelling

This course examines the financing, risk analysis and financial modelling of projects in order to provide you with a complete and up-to-date understanding of the market whilst developing crucial skills.

by Euromoney Learning

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