Course curriculum

  • 1

    Introduction

    • Course introduction

    • Downloadable files

    • Instructors

    • Course objectives

    • Preview of final product

  • 2

    Financial Modeling Best Practices

    • Robust rolling forecast models

    • Inputs and assumptions

    • Processing and formulas

    • Outputs and graphs

    • Modeling best practices and tradeoffs

    • Interactive exercise 1

  • 3

    Modeling Cash Flows (Review)

    • Key learning objectives

    • Operating cash flow

    • Investing cash flow

    • Financing cash flow & circular references

    • Interactive exercise 2

  • 4

    Building Your Financial Model in Excel

    • Overview of the modeling process

    • Time periods

    • Historical assumptions and drivers

    • Forecast assumptions and drivers

    • Income statement: revenue to EBITDA

    • Balance sheet: AR, inventory & AP

    • Supporting schedules: PP&E

    • Supporting schedules: debt schedule

    • Completing the income statement and balance sheet

    • Cash flow statement and cash balance

    • Interactive exercise 3

  • 5

    Enhancing Your Model

    • Key learning objectives

    • Conditional formatting

    • Data validation

    • Protecting the worksheet

    • Auditing the model

    • Charts and graphs

    • Interactive exercise 4

  • 6

    Final Product

    • Roll forward one month (example)

    • Download completed model

    • Summary

  • 7

    Qualified Assessment

    • Qualified assessment

    • Share Your Feedback

    • Course Completion