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

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 ]
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 [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)
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 ]
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 ]

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