Course curriculum

  • 1

    Course Introduction

  • 2

    Pre-Course Quiz

    • Pre-Course Quiz

  • 3

    MODULE 1: FINANCIAL ANALYSIS, RATIOS, AND METRICS

    • Module Material

    • Module Overview

      FREE PREVIEW
    • Introduction to Financial Analysis

    • Income Statement vs Balance Sheet Analysis

    • Vertical, Trend, and Horizontal Analysis

    • Liquidity Ratios

    • Management and Ativity Ratios

    • Solvency and Leverage Ratios

    • Profitability Ratios

  • 4

    MODULE 2: FINANCIAL MODELING BEST PRACTICES

    • Module Material

    • Module Overview

    • Introduction to Financial Modeling Best Practices

    • Modeling as a Discipline

    • Model Planning

    • Design and Presentation

    • Tab Structures

    • Model Construction Tips

  • 5

    MODULE 3: FINANCIAL MODELING ATTRIBUTES

    • Module Material

    • Module Overview

    • Introduction to Financial Modeling Attributes

    • Attribute 1: Dynamic

    • Attribute 2: Flexible

    • Attribute 3: Intuitive

    • Attribute 4: Transparent

    • Attribute 5: Printable

    • Attribute 6: Transferable

  • 6

    MODULE 4: MODELING SHORTCUTS

    • Module Material

    • Module Overview

    • Introduction to Modeling Shortcuts

  • 7

    MODULE 5: PROFESSIONAL EXCEL SKILLS

    • Module Material

    • Module Overview

    • Introduction to Professional Excel Skills

    • Custom Formatting

    • Logical Functions

    • Lookup and Reference Functions

    • Absolute References

    • Conditional Formatting

    • Forms & Drop-Down Boxes

    • Printing

  • 8

    MODULE 6: MODELING TOOLS AND TECHNIQUES

    • Module Overview

      FREE PREVIEW
    • Module Material

    • Introduction to Modeling Tools and Techniques

    • Dynamic Chart Titles

    • Check Box Data Modeling

    • Spinner Data Modeling

    • List Box Data Modeling

    • Option Box Data Modeling

    • Error Checking Techniques

  • 9

    MODULE 7: MODEL CALCULATIONS, INTEGRATION, AND CASE STUDY

    • Module Material

    • Module Overview

    • Model Design

  • 10

    MODEL CONSTRUCTION: ASSUMPTIONS

    • Revenue Assumptions

    • Cost Assumptions

    • Working Capital Assumptions

    • Fixed Assets Assumptions

    • Intangible Assets Assumptions

    • Debt Assumptions

    • Tax Assumptions

    • Equity Assumptions

  • 11

    MODEL CONSTRUCTION: REVENUE

    • Revenue Schedule Layout

    • Revenue Schedule Construction

  • 12

    MODEL CONSTRUCTION: COSTS

    • Costs Schedule Layout

    • Costs Schedule Construction

  • 13

    MODEL CONSTRUCTION: WORKING CAPITAL

    • Working Capital Schedule Layout

    • Working Capital Construction

    • Working Capital Changes

  • 14

    MODEL CONSTRUCTION: CAPITAL EXPENDITURES

    • Capital Expenditures: Fixed Assets

    • Capital Expenditures: Depreciation

    • Capital Expenditures: Intangible Assets

    • Capital Expenditures: Amortization

  • 15

    MODEL CONSTRUCTION: DEBT, INTEREST EXPENSE, AND INTEREST INCOME

    • Debt Schedule Layout

    • Debt Schedule: Fixed Rate Debt

    • Debt Schedule: Variable Rate Debt

    • Debt Schedule: Interest Income

  • 16

    MODEL CONSTRUCTION: TAXES

    • Taxes Schedule Construction

  • 17

    MODEL CONSTRUCTION: EQUITY

    • Equity Schedule: Common Equity

    • Equity Schedule: Preferred Equity

    • Equity Schedule: Retained Earnings

  • 18

    MODEL CONSTRUCTION: FINANCIAL STATEMENTS INTEGRATION

    • Financial Statement Integration: Income Statement

    • Financial Statement Integration: Balance Sheet

    • Financial Statement Integration: Cash Flow Statement

    • Financial Statement Integration: Loose Ends

  • 19

    MODULE CONSTRUCTION: THE REVOLVER

    • Revolver Construction and Integration

  • 20

    MODEL CONSTRUCTION: SUMMARY

    • Summary Sheet Construction

  • 21

    MODULE CONSTRUCTION: SCENARIOS

    • Scenarios Construction and Integration

  • 22

    MODULE CONSTRUCTION: PRINTING

    • Printing the Financial Model

  • 23

    MODULE 8: FINANCIAL CALCULATIONS AND APPLICATIONS

  • 24

    Post-Course Quiz

    • Post-Course Quiz