AFM 1

This monologue podcast is a lecture on financial modeling, delivered by Tim Benson, a reformed investment banker and instructor. The lecture introduces the course syllabus, which includes participation, a Financial Modeling Institute (FMI) Foundations course (worth 5% of the grade), and a final exam. Benson emphasizes the importance of building models that work both electronically (efficient, easy to understand) and on paper (printable, presentable to senior executives). He highlights key modeling attributes (dynamic, flexible, intuitive, printable, transparent, transferable) and provides practical tips, such as avoiding hard-coding and using keyboard shortcuts. The lecture concludes with an assignment focusing on building the first few pages of a financial model for a case study company, Medallion Moldings, using specific Excel skills like custom number formatting and the concatenate function.

Outlines

Part 1: Course Introduction

Part 2: Modeling Fundamentals

Part 3: Case Study and Planning

Part 4: Model Building and Excel Skills

Part 5: Assignment and Conclusion

Sign in to continue reading, translating and more.

Open full episode in Podwise

AFM

Part 1: Course Introduction

Course Introduction and Instructor Background

Course Structure and Grading

Course Goals and Objectives

Part 2: Modeling Fundamentals

Defining Financial Modeling and its Applications

Attributes of a Good Financial Model

Modeling Basics: Simplicity, Avoiding Hardcoding, and Color-Coding Conventions

Efficient Modeling Techniques: Keyboard Shortcuts and Formatting

Model Presentation and Client Readiness

Part 3: Case Study and Planning

Case Study Introduction: Medallion Moldings

The Financial Modeling Planning Process

Identifying Key Drivers and Assumptions for Medallion Moldings

Creating a Request List for Management and Identifying Necessary Schedules

Part 4: Model Building and Excel Skills

Model Walkthrough and Answer Key Explanation

Important Modeling Tips and Vertical Model Building

Essential Excel Skills: Linking, Centering, and Merging Cells

Advanced Excel Skills: Custom Number Formatting and Concatenate Function

Building an Economic and Pricing Scenarios Page

Part 5: Assignment and Conclusion

Assignment 1 and Course Conclusion

AFM 1

AFM

Part 1: Course Introduction

00:00Course Introduction and Instructor Background

Course Introduction and Instructor Background

07:34Course Structure and Grading

Course Structure and Grading

13:46Course Goals and Objectives

Course Goals and Objectives

Part 2: Modeling Fundamentals

15:45Defining Financial Modeling and its Applications

Defining Financial Modeling and its Applications

21:20Attributes of a Good Financial Model

Attributes of a Good Financial Model

28:30Modeling Basics: Simplicity, Avoiding Hardcoding, and Color-Coding Conventions

Modeling Basics: Simplicity, Avoiding Hardcoding, and Color-Coding Conventions

40:09Efficient Modeling Techniques: Keyboard Shortcuts and Formatting

Efficient Modeling Techniques: Keyboard Shortcuts and Formatting

43:58Model Presentation and Client Readiness

Model Presentation and Client Readiness

Part 3: Case Study and Planning

48:02Case Study Introduction: Medallion Moldings

Case Study Introduction: Medallion Moldings

53:04The Financial Modeling Planning Process

The Financial Modeling Planning Process

1:00:12Identifying Key Drivers and Assumptions for Medallion Moldings

Identifying Key Drivers and Assumptions for Medallion Moldings

1:15:56Creating a Request List for Management and Identifying Necessary Schedules

Creating a Request List for Management and Identifying Necessary Schedules

Part 4: Model Building and Excel Skills

1:20:12Model Walkthrough and Answer Key Explanation

Model Walkthrough and Answer Key Explanation

1:38:02Important Modeling Tips and Vertical Model Building

Important Modeling Tips and Vertical Model Building

1:48:26Essential Excel Skills: Linking, Centering, and Merging Cells

Essential Excel Skills: Linking, Centering, and Merging Cells

1:54:59Advanced Excel Skills: Custom Number Formatting and Concatenate Function

Advanced Excel Skills: Custom Number Formatting and Concatenate Function

2:15:56Building an Economic and Pricing Scenarios Page

Building an Economic and Pricing Scenarios Page

Part 5: Assignment and Conclusion

2:29:03Assignment 1 and Course Conclusion

Assignment 1 and Course Conclusion