Sales Ended

Financial Modelling - Comprehensive

Event Information

Share this event

Date and Time

Location

Location

De Vere - West One

9-10 Portland Place

London

W1B 1PR

United Kingdom

View Map

Event description

Description

This two-day course is designed for financial professionals needing to build, interpret, review and audit financial models (forecast integrated income statement, cash flow statement and balance sheet). It is suitable for both accountants and non-accountants, but an existing understanding of basic accounting concepts and terminology would be helpful. Laptops (excel v.2013) are provided. Courses are limited to a maximum of twelve delegates, allowing each attendee to experience outstanding tutor support throughout the two days.

Overview

A forecast integrated set of financial statements is constructed, from scratch, for a real company (based on published historic data). Once the forecast is complete a basic discounted cash flow (DCF) valuation is performed in order to demonstrate the sensitivity analysis.

Learning outcomes include obtaining a greater understanding of:

  • Financial modeling “Golden Rules”: Best practice DOs and DON’Ts
  • Model set-up
    • Model planning
    • Worksheet grouping
    • Date functionality
  • Historic data: cleaning up the numbers
  • Integrating the statements
  • Balancing the balance sheet
  • Forecasting techniques: pros and cons
  • Forecasting the numbers and populating the financial statements
  • Valuation
    • Enterprise vs equity value
    • Essential financial maths
    • Discounted cash flow valuation
  • Scenario analysis
  • Sensitivity analysis
  • Rolling forward the forecast
  • Model audit and review
  • Circularity and trouble shooting

12 CPD Hours available

Please call 03300 603 799 for more information.

Share with friends

Date and Time

Location

De Vere - West One

9-10 Portland Place

London

W1B 1PR

United Kingdom

View Map

Save This Event

Event Saved