The Three Statement Modeling 2.0

Buy $450.00

Course curriculum

1. Welcome
1. Live Sessions
1. Introduction to Financial Modeling
2. The Role and Crafting of Assumptions
3. The Tactic Financial Model
4. Quiz
1. The Case Study - Duramax©
1. How the assignments will work
2. Consent Form for Feedback and Social Media Highlights
3. Practice Case 001: Vertex
4. Practice Case 002: Prime Realty
1. The Headers
2. The Three Hooks
3. Quiz
1. What to consider when building a Revenue Schedule
2. Duramax - Revenue Schedule
3. Business Models Exercises
4. quiz
1. Introduction to Costs
2. Direct and Indirect Costs
3. Variable Cost vs. Fixed Cost
4. The matching principle
5. Operating Leverage
6. All about Cost
7. Duramax - Cost Schedule
8. Quiz
1. What is The Working Capital?
2. Cash Conversion Cycle
3. The impact of the Working capital in the Financial Statements
4. Duramax - Working Capital Schedule
5. Quiz
1. Fixed Assets
2. CAPEX
3. Depreciation
4. Fixed Assets and Depreciation impact on Financial Statements
5. Duramax - Fixed Assets Schedule
6. Quiz
1. Income Taxes
2. Duramax - The Income Taxes Schedule
1. Capital Structure
2. Types of Equity
3. Preferred Shares
4. Common Shares
5. Other Shareholder's Equity
6. Practical Case Study - The Equity Schedule
1. Debt
2. Duramax - The Debt Schedule
1. Creating Scenarios In Financial Modeling
2. Duramax - Creating Scenarios
3. Vertex - Using Scenarios to Cash Strategies
1. Presenting the Results
2. Charts
3. Charts Library
4. Executive Summary
5. Dashboards
6. Reports
7. Use an Excel Model as a Presentation
8. Final Thoughts
1. Auditing the Financial Model
2. Audit Formulas
3. Error Checking
4. Stress Testing
5. Sanity Check
1. Impact of Business Decisions on Finance
2. Practice the impact of Business Decisions
1. The TACTIC Approach
2. How to create your own learning Path
1. Final Assignment

About this course

$450.00
68 lessons
1 hour of video content

Discover your potential, starting today

Enroll today

The Three Statement Modeling 2.0

Course curriculum

Welcome

Bonus: Live workshops

Introduction to Financial Modeling

Practical Case Study

Bonus: Practice Cases

Preparing the Model

Forecasting Revenue

Forecasting Cost

The Working Capital Schedule

Fixed Assets & Depreciation

The Income Tax Schedule

Equity Forecast

Forecasting Debt

Creating Scenarios in Financial Modeling

Presenting the Results

Auditing the Financial Model

The Impact of Business decisions on Finance

Modeling in the Real World: the TACTIC Approach

Final Assignment

About this course

Discover your potential, starting today