Financial Modeling in Excel

  • Overview
  • Course Content
  • Requirements & Materials
Overview

Financial Modeling in Excel

Course Description

In this course, you will learn how to build financial models including valuation models such as Free Cash Flow to the Firm (FCFF) and Free Cash Flow to equity (FCFE). You will build a Three Statement Model and Discounted Cash Flow (DCF) models for an actual firm. In addition, advanced Excel functions and data analysis techniques, such as sensitivity analysis and Monte Carlo simulation, will be covered.

Course Content

THEORY AND APPLICATION OF VARIOUS FINANCIAL MODELS

EXCEL FUNCTIONS AND DATA ANALYSIS TOOLS

LEARN TO BUILD FINANCIAL VALUATION MODELS

LEARN ADVANCED FINANCE FUNCTIONS

Requirements & Materials

Materials

Required

  • Laptop with webcam and microphone
  • Internet connection

Microsoft Excel

Provided

  • Course materials

Who Should Attend

This course is intended for those interested in building financial models and for those wanting to acquire new spreadsheet skills.

Management professionals collaborating in classroom

What You Will Learn

  • How to build a working financial model
  • How to build a Three Statement Model
  • Discounted cash flow (DCF) valuation, including Free Cash Flow to the Firm and Free Cash Flow to Equity
  • Comparable Analysis
  • Advanced Excel functions and Data Analysis techniques
Finance professional looking at graphs on laptop

How You Will Benefit

  • Gain expertise in financial modeling and Excel.
  • Apply the knowledge learned immediately.
  • Develop essential skills for careers in investment banking, financial planning, and other areas of finance.
  • Taught by Experts in the Field icon
    Taught by Experts in the Field
  • Grow Your Professional Network icon
    Grow Your Professional Network

Georgia Tech provides a great learning environment and also facilitates a great networking environment.

- Niki Jones
Development Administrator

TRAIN AT YOUR LOCATION

We enable employers to provide specialized, on-location training on their own timetables. Our world-renowned experts can create unique content that meets your employees' specific needs. We also have the ability to deliver courses via web conferencing or on-demand online videos. For 15 or more students, it is more cost-effective for us to come to you.

  • Save Money
  • Flexible Schedule
  • Group Training
  • Customize Content
  • On-Site Training
  • Earn a Certificate
Learn More

Want to learn more about this course?