Corporate Financial Modeling Training

Build a financial model and learn corporate finance and accounting principles. By the end of this course, you'll have a comprehensive Discounted Cash Flow (DCF) model to add to your portfolio. You'll have a fundamental knowledge of corporate finance and accounting concepts. Finally, your advanced Microsoft Excel skills will aid you in building financial models quickly and accurately.

Master the advanced Excel tricks, techniques, and tools financial analysts use to build and audit financial models. By the end of this course, you will know how to write efficient and flexible formulas, create sensitivity analysis, and master Excel's features for finance.

Learn the essentials of corporate finance, from capital allocation to corporate valuation, initial public offerings, financial instruments, and mergers and acquisitions. Throughout the class, we will use real-world case studies of recent deals and examine live pricing of various securities.

Learn how to analyze financial statements and reports. Master financial accounting fundamentals such as accrual accounting, the three main financial statements, and the metrics and ratios analysts use.

Learn what moves stock prices and how stocks are valued by investors. In this course, you will learn the essentials of valuation (such as P/E ratios and DCF analysis), financial statements, and fundamentals of stock investing. We will analyze recent earnings releases and valuation multiples of companies such as Google and Apple to provide a framework for fundamental investment research.

Go from novice to expert in our three-day comprehensive Excel Bootcamp. You’ll learn advanced database functions, calculations, and formulas, shortcuts, Pivot Tables and scripts, and macros for automating tasks with ease.