Consolidated Course Material

Financial Modeling Introduction

AFM 1 Introduction

Module Material

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

Module Material

Module Overview

Introduction to Financial Modeling Best Practices

Modeling as a Discipline

Model Planning

Design and Presentation

Tab Structures

Model Construction Tips

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

Module Material

Module Overview

Introduction to Modeling Shortcuts

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

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

Module Material

Module Overview

Model Design

Revenue Assumptions

Cost Assumptions

Working Capital Assumptions

Fixed Assets Assumptions

Intangible Assets Assumptions

Debt Assumptions

Tax Assumptions

Equity Assumptions

Revenue Schedule Layout

Revenue Schedule Construction

Costs Schedule Layout

Costs Schedule Construction

Working Capital Schedule Layout

Working Capital Construction

Working Capital Changes

Capital Expenditures: Fixed Assets

Capital Expenditures: Depreciation

Capital Expenditures: Intangible Assets

Capital Expenditures: Amortization

Debt Schedule Layout

Debt Schedule: Fixed Rate Debt

Debt Schedule: Variable Rate Debt

Debt Schedule: Interest Income

Taxes Schedule Construction

Equity Schedule: Common Equity

Equity Schedule: Preferred Equity

Equity Schedule: Retained Earnings

Financial Statement Integration: Income Statement

Financial Statement Integration: Balance Sheet

Financial Statement Integration: Cash Flow Statement

Financial Statement Integration: Loose Ends

Revolver Construction and Integration

Summary Sheet Construction

Scenarios Construction and Integration

Printing the Financial Model

Module Material

Financial Calculations Introduction

PV and FV

IRR and XIRR

NPV and XNPV

Free Cash Flows

Post-Course Quiz