Search courses 👉
Corporate Training for Teams

Excel, Modelling & Valuation within Financial Services | In Company

ZISHI, Online (+1 locations)
Length
Tailored to your needs
Next course start
Contact us for group bookings (+3 start dates)
Course delivery
Virtual Classroom, Blended, In Company
Length
Tailored to your needs
Next course start
Contact us for group bookings (+3 start dates)
Course delivery
Virtual Classroom, Blended, In Company
Leave your details so the provider can get in touch

Course description

This training course is designed for professionals aiming to master the intricacies of financial analysis and valuation using Excel.

The curriculum begins with fundamental Excel skills, covering basics, tricks, shortcuts, and essential functions, before progressing to more complex modelling techniques that include building financial frameworks, forecasting, scenario analysis, and constructing debt schedules.

Delve into LBO (Leveraged Buyout) modelling, exploring both basic and advanced structures and tools.

The programme further Excel’s application in emphasising essential mathematical and financial and data analysis tools.

Advanced topics include modelling and VBA for automation, principles of valuation and analysis, financial maths, and key Excel formulae for financial modelling.

Specialised modules cover the cost of capital, capital structure, financial forecasting, comparable company analysis, cash flow-based valuation, and merger modelling.

Participants will also explore sector­ specific valuation including real estate, oil and gas, and insurance, along with project finance principles, ensuring a thorough understanding of Excel’s powerful capabilities in various financial contexts.

Upcoming start dates

Choose between 3 start dates

Contact us for group bookings

  • In Company
  • United Kingdom

Contact us for group bookings

  • Virtual Classroom
  • Online

Contact us for group bookings

  • Blended
  • Online

Outcome / Qualification etc.

  • Master Excel for Financial Modelling and Valuation: Navigate Excel with proficiency, mastering essential functions, shortcuts, and advanced tools for financial analysis, including a deep dive into Excel basics, tricks, mathematical, trigonometric functions, and key formulae specifically tailored for financial modelling.
  • Develop Comprehensive Financial Models: Construct basic, intermediate, and advanced financial models, including forecasting income statements, managing fixed assets and working capital, balancing balance sheets, linking cash flow statements, and conducting scenario and debt schedule analyses.
  • Perform LBO and Merger Modelling: Gain the knowledge to model leveraged buyouts (LBOs) from basic to advanced structures, including forecasting for LBOs, and to conduct merger and demerger modelling, analysing transactions, estimating synergies, and restructuring costs.
  • Apply Valuation Techniques across Different Sectors: Apply a range of valuation techniques, including cash flow-based valuation, comparable company analysis, and sector-specific valuation methods for industries such as real estate, oil and gas, and insurance companies.
  • Analyse and Forecast Financial Statements: Participants will be trained in financial forecasting, building comprehensive models to forecast income statements, cash flows, and balance sheets, and employing ratio analysis for deeper financial insights.
  • Integrate Corporate Strategy and Valuation: Understand the development and application of corporate strategy in financial modelling, including strategic options for case companies, cost of capital theories, and valuing distressed companies through non-traditional techniques and uncovering hidden values in distressed assets.

Training Course Content

  • Excel functions and tools
  • Basic, intermediate and advanced modelling
  • LBO modelling
  • Excel for markets
  • Modelling and VBA
  • Principles of valuation and analysis
  • Financial maths
  • Excel for finance
  • Cost of capital and capital structure
  • Financial forecasting
  • Comparable company analysis
  • Cash flow based valuation
  • Merger modelling
  • The project finance view
  • Excel for finance
  • Cost of capital
  • Intermediate modelling
  • LBO valuation and modelling
  • Comparable company analysis
  • Valuing distressed companies
  • Valuing insurance companies
  • Real estate valuation

Course delivery details

All courses can be delivered ONSITE, ONLINE or BLENDED to suit your distinct requirements.

Whether one-to-one or group deliveries, entry level or boardroom executives, are consultants are here to develop a programme to meet your specific business needs.

Simply contact us to discuss your requirements.

Content for this course, including start date and length, can be tailored to meet client needs.

Request info

Contact form

Fill out your details to find out more about Excel, Modelling & Valuation within Financial Services | In Company.

  Contact the provider

  Get more information

  Register your interest

Country *

reCAPTCHA logo This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.
Ads