Financial Analysis

Microsoft Excel

1. Quick Introduction
2. Useful Tools
3. Best Practices That Will Make a Difference
4. Beginner, Intermediate & Advanced Functions
5. Financial functions in Excel
6. Practical Exercise Build a P&L From Scratch
7. Building Professional Charts in Excel
8. Working with Pivot Tables in Excel

Pivot Tables & Slicers in Practice

Modeling in Excel

1. Building a complete 3-statement model
2. Let's build a flexible model with multiple scenarios
3. We are almost there! Completing the 3-statement model

Accounting

1. Introduction to Accounting & Bookkeeping
2. Types of revenues, costs, assets, and liabilities
3. Revenue recognition
4. Cost recognition
5. Understanding the Big Picture Why, What, When, and How Much
6. The Core Principles of Accounting
7. Practical Exercise The Accounting Transactions of a Lemonade Stand
8. Preparing a Cash Flow Statement Understanding Cash Flow Analysis
9. The Importance of Timing

Advanced Accounting

1. Trade receivables
2. Inventory
3. Fixed Assets
4. Trade payables
5. Financial liabilities
6. Leasing Liabilties
7. Using leverage
8. Raising equity, types of equity, and dividend payments

Financial Statement Analysis

1. An Introduction
2. Subtleties
3. Practical Case Study Analyzing P&G's Financials
4. Tesla exercise

Working Capital Management

Fundamentals of Business & Financial Analysis

Finance

1. The Time Value of Money and Interest Rate Components
2. The Value of Cash Flows with Different Timing
3. Loan Calculations

Capital Budgeting

1. Basic notions
2. A Complete Case Study

Practical Case Study

1. Building a financial planning model

PowerPoint

1. Introduction to PowerPoint
2. Tips & Tricks That Will Transform You Into An Advanced User