From the Experts in Financial Modeling

Design and create a dynamic financial model of a company that adheres to the highest industry standards

Gain the skills required to design and create an interactive financial model of a company that adheres to the highest industry standards. The course material includes model design, logic, construction, financial concepts and accounting treatment. During the course, participants will build a model that includes a forecast of a company’s income statement, cash flow statement and balance sheet.

Learning Topics Include

  • Design and Structure a Financial Model

    Design and layout a financial model clearly and logically

    Discuss the need for a model to serve as a marketing tool

    Create clearly defined inputs and assumptions sections

    Connect strings of data to create assumptions and footnotes

  • Build Powerful Scenarios and Financial Statements

    Use switches to create effective scenarios and value drivers

    Forecast and build-up a company’s revenues and expenses

    Design and incorporate a company’s income statement, balance sheet and cash flow statement

  • Incorporate all Relevant Schedules

    Construct all necessary schedules

    Use Lookup functions within the model to effectively extract information

    Properly incorporate Senior Term Debt with an amortizing repayment schedule

    Create a robust Bank Operating Line (or Revolving Credit Facility)

    Design and incorporate a cash sweep for a company’s Bank Operating Line

Sample Content: Chapter 2a - Modeling as a Discipline

Register for a FREE TRIAL to access more free content

The Gold Standard of Financial Modeling

Includes all content from our live sessions and incorporates Marquee’s teaching approach honed by 20 years in the classroom

  • 55 expert videos. Pause, fast forward, and rewind to suit your individual pace

  • 7+ Hours of Interactive Content

  • Practice assignments with step-by-step instructions and full answer key

  • Presentation book of key concepts (50 pages of key finance resources and Excel formulas)

  • Dedicated course support

  • Video Closed Captions for user accessibility

Hear From Our Learners

Great Course

by Vinay B.

Overall, great course! Very detailed in explaining concepts and structure. This was worth the $$$!

Earn a Financial Modeling Certification

from the Financial Modeling Institute (FMI)

This course prepares candidates for the Advanced Financial Modeler (AFM) exam offered by the Financial Modeling Institute (FMI)

Access Financial Modeling

Get Started Today

Course curriculum

  • 3

    Chapter 2: Financial Model Design

    • Learning Objectives

    • 2a - Modeling as a Discipline

      FREE PREVIEW
    • 2b - Modeling Fundamentals

    • 2c - Precision Moldings Case Study

    • 2d - Planning the Model

    • 2e - Completed Model Review

    • 2f - Incorporating Scenarios

    • 2g - Model Structure

  • 4

    Chapter 3: Modeling Technical Skills

    • Learning Objectives

    • 3a - Centre Across Selection

    • 3b - Custom Formatting - Introduction

    • 3c - Custom Formatting - 0 vs #

    • 3d - Custom Formatting - Four Ways

    • 3e - Custom Formatting Colors and Spacing

    • 3f - CONCATENATE Function

    • 3g - CONCATENATE and Formatting

    • 3h - Scenarios Page Construction

    • 3i - Scenarios CHOOSE Function

    • 3j - Scenarios Page Drop Down Menus

    • 3k - Assignment

  • 5

    Chapter 4: Revenues

    • Learning Objectives

    • 4a - The Engine

    • 4b - Revenue Schedule

    • 4c - Revenue Constraint

    • 4d - Assignment

  • 6

    Chapter 5: Operating Costs

    • Learning Objectives

    • 5a - Operating Costs Overview

    • 5b - Operating Costs Schedule

    • 5c - Modeling Operating Leverage

    • 5d - Assignment

  • 7

    Chapter 6: The Financial Statements

    • Learning Objectives

    • 6a - Income Statement

    • 6b - Cash Flow Statement

    • 6c - Balance Sheet

  • 8

    Chapter 7: Depreciation

    • Learning Objectives

    • 7a - Introduction to Depreciation

    • 7b - Depreciation Schedule

    • 7c - HLOOKUP Function

    • 7d - Automating the HLOOKUP

    • 7e - Transposing Data

    • 7f - Depreciation Waterfall

    • 7g - Fully Depreciating Assets

    • 7h - Assignment

  • 9

    Chapter 8: Income Taxes

    • Learning Objectives

    • 8a - Introduction to Income Taxes

    • 8b - Current vs. Deferred Taxes

    • 8c - Deferred Tax Example

    • 8d - Deferred Tax Assets

    • 8e - Tax Schedule - Overview

    • 8f - Tax Schedule - Adjustment 1

    • 8g - Tax Schedule - Adjustment 2

    • 8h - Determining the Tax Assumptions

    • 8i - Assignment

  • 10

    Chapter 9: Working Capital

    • Learning Objectives

    • 9a - Introduction to Working Capital

    • 9b - Working Capital Schedule

    • 9c - Working Capital Calculations

    • 9d - Automating the Days per Year

    • 9e - Other Working Capital Issues

    • 9f - Assignment

  • 11

    Chapter 10: Debt & Equity

    • Learning Objectives

    • 10a - Modeling Debt and Equity

    • 10b - Debt Schedule

    • 10c - Revolving Credit Facility

    • 10d - Revolver MIN Function

    • 10e - Equity Schedule

    • 10f - Assignment

  • 12

    Chapter 11: Pulling it All Together

    • Learning Objectives

    • 11a - Finishing the Financial Statements

    • 11b - Calculating Output Ratios

    • 11c - Course Takeaways

    • 11d - Assignment

Also Available

In-Person and Webinar-Based Marquee Courses