AFM 3

This Q&A podcast focuses on financial modeling techniques, specifically addressing common challenges and best practices. The instructor begins by reviewing previous class material and addressing student questions regarding assignments and assumptions in financial models. The core of the session involves a detailed explanation of two key modeling conventions: "repeat and link" (repeating assumptions before use for clarity) and "build it, then link it" (avoiding complex formulas on financial statements). The instructor provides practical examples using Apple's revenue structure and discusses the concept of operating leverage, illustrating how a doubling of revenue can lead to more than a doubling of profit due to fixed costs. Listeners gain actionable insights into building more efficient, understandable financial models.

Outlines

Part 1: Introduction, Assignments

Part 2: Model Assumptions, Class Overview

Part 3: Model Design, Revenue, Constraints

Part 4: Cost Modeling, Schedule Order

Part 5: Next Steps

Sign in to continue reading, translating and more.

Open full episode in Podwise

AFM

Part 1: Introduction, Assignments

Initial Greetings and Host Introduction

Addressing Student Questions Regarding Assignments

Part 2: Model Assumptions, Class Overview

Discussion on Deriving Assumptions for Financial Models

Class Schedule Overview and Technical Skill Review

Recap of Previous Class and FMI Foundations Program

Addressing Student Questions on Model Building

Part 3: Model Design, Revenue, Constraints

Discussion on Model Design for Print and Executive Summaries

Detailed Discussion on Revenue Modeling

Modeling Constraints and Capacity Limitations

Critical Modeling Conventions: Repeat and Link, Build and Link

Further Discussion on Model Design for Print and Executive Summaries

Part 4: Cost Modeling, Schedule Order

Modeling Costs: Fixed vs. Variable Costs and Operating Leverage

Building Cost Schedules: A Four-Step Process

Building the Model Engine: Optimal Schedule Order and Depreciation

Part 5: Next Steps

Next Steps and Conclusion

AFM 3

AFM

Part 1: Introduction, Assignments

00:00Initial Greetings and Host Introduction

Initial Greetings and Host Introduction

01:18Addressing Student Questions Regarding Assignments

Addressing Student Questions Regarding Assignments

Part 2: Model Assumptions, Class Overview

03:54Discussion on Deriving Assumptions for Financial Models

Discussion on Deriving Assumptions for Financial Models

10:53Class Schedule Overview and Technical Skill Review

Class Schedule Overview and Technical Skill Review

13:35Recap of Previous Class and FMI Foundations Program

Recap of Previous Class and FMI Foundations Program

16:51Addressing Student Questions on Model Building

Addressing Student Questions on Model Building

Part 3: Model Design, Revenue, Constraints

22:27Discussion on Model Design for Print and Executive Summaries

Discussion on Model Design for Print and Executive Summaries

32:54Detailed Discussion on Revenue Modeling

Detailed Discussion on Revenue Modeling

46:16Modeling Constraints and Capacity Limitations

Modeling Constraints and Capacity Limitations

54:33Critical Modeling Conventions: Repeat and Link, Build and Link

Critical Modeling Conventions: Repeat and Link, Build and Link

1:06:40Further Discussion on Model Design for Print and Executive Summaries

Further Discussion on Model Design for Print and Executive Summaries

Part 4: Cost Modeling, Schedule Order

1:08:08Modeling Costs: Fixed vs. Variable Costs and Operating Leverage

Modeling Costs: Fixed vs. Variable Costs and Operating Leverage

1:23:37Building Cost Schedules: A Four-Step Process

Building Cost Schedules: A Four-Step Process

1:39:48Building the Model Engine: Optimal Schedule Order and Depreciation

Building the Model Engine: Optimal Schedule Order and Depreciation

Part 5: Next Steps

2:08:23Next Steps and Conclusion

Next Steps and Conclusion