Financial Modelling with Excel Training in Berlin

$1,642.00 $1,407.00

Course Overview:

Financial modeling is the task of building an abstract representation (a model) of a real world financial situation. This is a mathematical model designed to represent (a simplified version of) the performance of a financial asset or portfolio of a business, project, or any other investment.

Financial modeling is a general term that means different things to different users; the reference usually relates either to accounting and corporate finance applications, or to quantitative finance applications. While there has been some debate in the industry as to the nature of financial modeling.

Workshop Details

DateCourse TypeCityStandard PriceEarlybird Price
Aug 17 – Aug 19
3 Days
9.00 AM – 5.00 PM
ClassroomBerlinEUR 1399EUR 1199
till 02 Aug 17
DateCourse TypeCityStandard PriceEarlybird Price
Oct 26 – Oct 28
3 Days
9.00 AM – 5.00 PM
ClassroomBerlinEUR 1399EUR 1199
till 12 Oct 17
  • Overview of financial modeling
  • Understanding projections
  • Excel best practices foundation and exercises
  • Useful Excel shortcuts and functions
  • Gathering historical documents / information
  • Preparation of Income and Cash Flow statements and Balance Sheet
  • Ratio Analysis
  • Du Pont Analysis
  • Financial Statement Analysis
  • Valuation of Companies
  • Valuation of IPOs
  • Valuation of Merger & Acquisitions
  • Valuation of Bonds
  • Valuation of Equity
  • Leverage Buyout Analysis (LBOs)
  • Sensitivity/Scenario Analysis
  • Monte Carlo Simulation
  • Case Study

Anyone can attend this course with basic excel knowledge.