The Complete Financial Analyst Course 2023

Excel, Accounting, Financial Statement Analysis, Business Analysis, Financial Math, PowerPoint: Everything is Included!

What you'll learn

Work comfortably with Microsoft Excel

Format spreadsheets professionally

Perform routine tasks quicker

Create professional charts in Microsoft Excel

Efficiently work with vast amounts of data

Understand accounting and bookkeeping principles

Build a company’s P&L from scratch

Create a company’s balance sheet

Perform Financial statement analysis

Understand the timing of revenue and cost recognition

Calculate liquidity, solvency, profitability, and growth ratios to analyze a company’s performance

Understand 10-K reports

Assess whether a project is feasible via the net present value (NPV) technique

Calculate a complete loan schedule

Know the difference between variable and fixed interest rates

Perform industry analysis

Realize what drives a company’s value

Know how to analyze a business

Work comfortably with Microsoft PowerPoint

Create professional company presentations in PowerPoint

Become a successful Financial Analyst – if you follow the course entirely!

Requirements

No experience is required. Start from the basics and progressively build your knowledge.

You will need Microsoft Excel 2010, 2013, 2016, 2020, or Excel 365

You will need Microsoft PowerPoint 2010, 2013, 2016, 2020, or PowerPoint 365

Description

* Updated for February 2023! *"If you’re trying to prepare for a career in finance, but are still looking to round out your knowledge of the subject, The Complete Financial Analyst Course might be a perfect fit for you" - Business Insider"A financial analyst career is one of the top-paying entry-level jobs on the market.” "Even in the toughest job markets, the best candidates find great positions." - ForbesYou simply need to find a way to acquire practical skills that will give you an edge over the other candidates.But how can you do that?You need the proper training, and you have never seen how analysts in large firms do their work …Stop worrying, please! We are here to help.The Complete Financial Analyst Course is the most comprehensive, dynamic, and practical course you will find online.It covers the following topics, fundamental for every aspiring financial analyst:Microsoft Excel for beginner and intermediate users — become proficient with the world’s #1 productivity softwareAccounting, financial statements, and ratios — making sense of debits and credits, profit and loss statements, balance sheets, liquidity, solvency, profitability, and growth ratiosFinance basics — interest rates, financial math calculations, loan calculations, time value of money, present and future value of cash flowsBusiness analysis — understanding what drives a business, essential items to be analyzed, the importance of industry cycles, important drivers for the business of start-up, growth, mature and declining companies, industry KPIsCapital budgeting — decide whether a company's project is feasible from a financial perspective and compare different investment opportunitiesMicrosoft PowerPoint for beginner and intermediate users — The #1 tool for a visual representation of your work, a necessary skill for every financial analystThis complete bundle ensures you receive the proper training for each critical aspect.Here comes the fun part!After covering each major roadblock, you will be asked to solve a challenge. You will:Calculate a company’s sales in ExcelRegister its bookkeeping entries, produce applicable financial statements and calculate financial ratiosCalculate a complete loan schedule for the company’s debtAnalyze the company’s business performanceCreate a PowerPoint presentation based on the results Receive personalized feedbackParticipate in our monthly Amazon Gift Card LotterySounds interesting, right?At the end of the challenge, you'll send us your work, and we'll reply with personalized feedback - creating an interactive student experience that optimizes what you'll learn from the course.What makes this course different from other finance courses?High-quality production, HD video and animations (not a collection of boring lectures)Knowledgeable instructors with experience in such prominent companies like Pwc and Coca-ColaComplete training covering all major topics and skills necessary to become a top-class financial analystExtensive case studies reinforcing everything you’ve learnedCourse Challenge that creates an interactive experienceExcellent support for when you don’t understand a concept or want to drop us a line — you’ll receive an answer within one business dayDynamic instructors who keep up a steady tempo throughout the courseWhy should you consider a career as a financial analyst?Salary. A financial analyst job typically leads to a well-paid careerPromotions. Financial analysts acquire valuable technical skills, making them the leading candidates for senior roles within a corporationSecure Future. There's high demand for financial analysts on the job market; you won’t have to be concerned about finding a jobGrowth. This isn’t a tedious job — you'll will face different challenges that will test your existing skillsThis course comes with Udemy’s 30-day unconditional, money-back guarantee. Take advantage of this opportunity to acquire the skills that will advance your career.

Overview

Section 1: Welcome! Course Introduction

Lecture 1 What Does the Course Cover?

Lecture 2 Everything We Will Learn Has a Practical Application

Lecture 3 The Best Way to Take This Course

Lecture 4 Download All Course Materials and FAQ

Section 2: Microsoft Excel - Quick Introduction

Lecture 5 Microsoft Excel: The World's #1 Office Software

Lecture 6 Excel Made Easy: A Beginner's Guide to Excel Spreadsheets

Lecture 7 Data Entry Techniques in Excel

Lecture 8 How to Make Your Spreadsheets Look Professional

Lecture 9 Inserting, Deleting, and Modifying Rows & Columns

Lecture 10 Excel Formulas for Beginners

Lecture 11 A Beginner's Introduction to Excel Functions

Lecture 12 Format Cells

Lecture 13 Work Efficiently by Using Cut, Copy, and Paste

Lecture 14 Pasting Values, Formulas and Formats with Paste Special

Section 3: Microsoft Excel - Useful Tools

Lecture 15 Inserting a Line Break with Alt + Enter

Lecture 16 Do More with Your Sales Data with Excel's Text to Columns Feature

Lecture 17 Create Easily Printable Excel Documents

Lecture 18 How to Wrap Text in Excel and Adjust a Cell's Size

Lecture 19 Insert Hyperlinks into Excel Spreadsheets

Lecture 20 Using Excel's Freeze Panes to Handle Large Datasets

Lecture 21 Find Excel Functionalities in a Quicker Way - Tell Me What You Want to Do

Lecture 22 A Quick Introduction to Excel's Pivot Tables

Section 4: Microsoft Excel - Best Practices That Will Make a Difference

Lecture 23 Initial Formatting Is Key for Creating Professional-looking Spreadsheets

Lecture 24 Macros Are a Great Timesaver! Here's Why.

Lecture 25 How to Use the Same Macro On Multiple Workbooks

Lecture 26 The Secret to Faster Scrolling in Excel

Lecture 27 Be even quicker: F5 + Enter

Lecture 28 FAQ: F5 + Enter didn't work for me

Lecture 29 Using Absolute and Relative Cell References

Lecture 30 Find and Select Cells That Meet Specific Conditions

Lecture 31 How to Create Dynamic Names in Excel Spreadsheets

Lecture 32 Using Named Ranges to Make Formulas More Readable

Lecture 33 Introduction to Custom Formatting in Excel

Lecture 34 Custom Number Formatting

Lecture 35 How to Add a Drop-down List in Excel

Lecture 36 Using Custom-sort to Sort Multiple Columns Within a Table

Lecture 37 Saving Time in Excel and Doing Everything Faster by Using Excel Shortcuts

Lecture 38 Multiply by 1

Lecture 39 Find and Replace - References

Lecture 40 FAQ: Why Do We Replace External References and How Does This Help Us?

Lecture 41 Find and Replace - Formatting

Lecture 42 Green References

Lecture 43 Beauty Saving - The Professional Way of Saving Files

Lecture 44 The Power of F2

Lecture 45 Conditional Formatting

Section 5: Microsoft Excel - Beginner, Intermediate & Advanced Functions

Lecture 46 Key Excel Functions: IF

Lecture 47 Enlarge the Formula Bar

Lecture 48 Key Excel Functions: SUM, SUMIF, SUMIFS

Lecture 49 A Helpful Consideration

Lecture 50 Key Excel Functions: COUNT, COUNTA, COUNTIF, COUNTIFS

Lecture 51 Key Excel Functions: AVERAGE & AVERAGEIF

Lecture 52 Key Excel Functions: LEFT, RIGHT, MID, UPPER, LOWER, PROPER, CONCATENATE, &

Lecture 53 Working with Text in Excel

Lecture 54 Find the Highest and Lowest Values in a Range: Max & Min

Lecture 55 = and + are Interchangeable When You Start Typing a Formula

Lecture 56 Use ROUND in Your Financial Models

Lecture 57 Excel's Lookup Functions: VLOOKUP & HLOOKUP Made Easy

Lecture 58 INDEX, MATCH, and Their Combination - The Perfect Substitute of VLOOKUP

Lecture 59 XLOOKUP: a Solid Substitute of VLOOKUP (Office 365 only)

Lecture 60 Using Excel's IFERROR Function to Trap Spreadsheet Errors

Lecture 61 A Useful Tool for Financial Analysis - The RANK Function

Lecture 62 Create Flexible Financial Models with CHOOSE

Lecture 63 Goal Seek Will Help You Find the Result You Are Looking For

Lecture 64 Perform Sensitivity Analysis with Excel's Data Tables Functionality

Section 6: Microsoft Excel - Financial Functions in Excel

Lecture 65 Discounting Cash Flows in Microsoft Excel

Lecture 66 Calculating Internal Rate of Return (IRR) in Excel

Lecture 67 Using the PMT Function to Create a Complete Loan Schedule

Lecture 68 Date Functions in Excel

Section 7: Microsoft Excel - Practical Exercise "Build a P&L From Scratch"

Lecture 69 Introduction to the Case Study

Lecture 70 What You Will See Next

Lecture 71 Understand Your Data Source Before You Start Working on It

Lecture 72 Ordering the Source Worksheet

Lecture 73 Creating a Code: The Best Way to Organize Your Data and Work Efficiently with It

Lecture 74 Learn How to Create a Database

Lecture 75 Using Lookup Functions (VLOOKUP) to Fill the Database Sheet

Lecture 76 Using SUMIF to Complete the Database Sheet

Lecture 77 FAQ: Why Net income should be 0?

Lecture 78 Using INDEX & MATCH as a Substitute for VLOOKUP

Lecture 79 XLOOKUP as a Substitute for VLOOKUP and INDEX&MATCH

Lecture 80 The Mapping Exercise

Lecture 81 Mapping the Rows in the Database Sheet

Lecture 82 Building the Structure of the P&L Sheet

Lecture 83 A Practical Example of Professional Formatting in Excel

Lecture 84 Populating the P&L Sheet with SUMIF

Lecture 85 Learn How to Find Mistakes with COUNTIF

Lecture 86 Calculating Growth Rates in Excel

Section 8: Practical Exercise - SUMIFS

Lecture 87 Practical Exercise - SUMIFS

Section 9: Microsoft Excel - Building Professional Charts in Excel

Lecture 88 Introduction to Excel Charts

Lecture 89 Beginner's Guide to Inserting Charts in Excel

Lecture 90 Modifying Excel Charts - The Easy Way

Lecture 91 Making Your Excel Charts Sexier - Proven Tips

Lecture 92 Creating a Bridge Chart in Excel 2016 - As Easy as It Gets

Lecture 93 New Ways to Visualize Your Data - Treemap Charts

Lecture 94 How to Represent Trends with Sparklines

Section 10: Microsoft Excel - Creating Complete Professional Charts from Scratch

Lecture 95 Introduction

Lecture 96 Stacked Column Chart with a Secondary Axis

Lecture 97 Doughnut Chart

Lecture 98 Area Chart

Lecture 99 Bridge Chart

Section 11: Microsoft Excel - Working with Pivot Tables in Excel

Lecture 100 Pivot Tables - Excel's Dynamic and Interactive Tables

Lecture 101 Creating a Pivot Table: Choosing Row and Column Parameters

Lecture 102 Design the Layout and Format of Your Pivot Tables

Lecture 103 Additional Techniques That Will Ease Your Work with Pivot Tables

Lecture 104 One of the Most Useful Excel Functions - GETPIVOTDATA

Lecture 105 Welcome to the Future - Pivot Table Slicers

Lecture 106 Introduction to the Course Challenge

Lecture 107 COURSE CHALLENGE - Part 1

Section 12: Microsoft Excel - Pivot Tables & Slicers - World-Class Financial Reporting

Lecture 108 Introduction to the Case Study

Lecture 109 Working with an SAP Data Extraction

Lecture 110 Preliminary Mapping of the Data Extraction

Lecture 111 Creating an Output Structure of the FMCG Model

Lecture 112 Improving the Layout and Appearance of the FMCG Report

Lecture 113 Inserting Formulas and Automating Calculations

Lecture 114 Creating a Master Pivot Table: The Main Data Source for the FMCG Report

Lecture 115 GETPIVOTDATA is Great! Extracting Data from the Master Pivot Table

Lecture 116 GETPIVOTDATA Fix

Lecture 117 FAQ: My GETPIVOTDATA Function Doesn't Work

Lecture 118 Combining Slicers and GETPIVOTDATA: The Key to Our Success

Lecture 119 Getting Fancy with Excel Slicers

Lecture 120 This is How the Report Can be Used in Practice by High-level Executives

Section 13: Modeling in Excel - Building a Complete 3-statement Model

Lecture 121 Introduction to the Exercise

Lecture 122 Let's Create a Mapping of Financials

Lecture 123 Building an Output P&L Sheet

Lecture 124 Filling in the Output P&L Sheet with Historical Financials

Lecture 125 Calculating Percentage Variances and Applying Conditional Formatting

Lecture 126 Building an Output Balance Sheet

Lecture 127 Using INDEX, MATCH, MATCH to Fill in the Output Balance Sheet

Lecture 128 Adding the Forecast Period

Section 14: Modeling in Excel - Let's Build a Flexible Model with Multiple Scenarios

Lecture 129 Calculating Historical Percentage Ratios and Use OFFSET and MATCH for Scenarios

Lecture 130 Building a Flexible Model with CHOOSE & MATCH

Lecture 131 Building a Flexible Model with VLOOKUP & COLUMNS

Lecture 132 Calculating Historical DSO, DPO, DIO, Other Assets %, and Other Liabilities %

Lecture 133 Forecasting DSO, DPO, DIO, Other Assets and Other Liabilities

Section 15: Modeling in Excel - We Are Almost There! Completing the 3-Statement Model

Lecture 134 Building a Fixed Asset Roll Forward

Lecture 135 Building a Financial Liabilities Schedule

Lecture 136 Building an Equity Schedule

Lecture 137 Preparing a Cash Flow Structure

Lecture 138 Calculating Cash Flows and Completing the Model

Section 16: Accounting - Introduction to Accounting & Bookkeeping

Lecture 139 Accounting: The Science Behind Financial Figures

Lecture 140 What is Accounting and Why Do You Need It

Lecture 141 The Importance of Bookkeeping - Good Accounting Records Are Essential

Lecture 142 An Introduction to Financial Accounting

Section 17: Accounting - Types of Revenues, Costs, Assets, and Liabilities

Lecture 143 The Different Types of Accounting Standards

Lecture 144 The Three Financial Statements

Lecture 145 Types of Revenues

Lecture 146 Types of Revenues - Exercise

Lecture 147 Types of Expenses

Lecture 148 Income Taxes

Lecture 149 Depreciation & Amortization

Lecture 150 The Two Types of Income Statement Formats

Lecture 151 Balance Sheet Items

Lecture 152 Asset Categories - Practical Example

Lecture 153 Liability Categories - Practical Example

Lecture 154 Equity

Lecture 155 Equity Categories - Practical Example

Section 18: Accounting - Revenue Recognition

Lecture 156 Accrual Accounting

Lecture 157 Revenue Recognition Criteria - Technical

Lecture 158 Potential Conflicts of Interest When Recognizing Revenue

Lecture 159 A Practical Example

Lecture 160 FAQ: Doubts Regarding Calculation

Section 19: Accounting - Cost Recognition

Lecture 161 Cost recognition principles

Lecture 162 Technical Aspects of Cost Recognition

Section 20: Accounting - Understanding the Big Picture: Why, What, When, and How Much

Lecture 163 The Revenue Recognition Principle - Why Is It So Important?

Lecture 164 The Expense Recognition Principle - When to Recognize Expenses

Lecture 165 Historical Cost vs. Fair Value Accounting

Section 21: Accounting - The Core Principles of Accounting

Lecture 166 The Accounting Equation and Its Importance

Lecture 167 Elements of the Accounting System: General Ledger

Lecture 168 T-Accounts: The Best Way to Understand Debits and Credits

Lecture 169 P&L T-Accounts

Lecture 170 The Double-Entry Principle - The Core Principle of Bookkeeping

Section 22: Accounting - Practical Exercise: The Accounting Transactions of a Lemonade Stand

Lecture 171 Case Study - The Accounting Transactions of a Lemonade Stand (1/4)

Lecture 172 Case Study - The Accounting Transactions of a Lemonade Stand (2/4)

Lecture 173 Case Study - The Accounting Transactions of a Lemonade Stand (3/4)

Lecture 174 Case Study - The Accounting Transactions of a Lemonade Stand (4/4)

Section 23: Accounting - The Importance of Timing

Lecture 175 Timing of Cash Flows and Why It Plays an Important Role in a Business

Lecture 176 Timing of Income: Principles of Revenue Recognition

Lecture 177 Timing of Expenses: Principles of Cost Recognition

Section 24: Accounting - Preparing a Cash Flow Statement: Understanding Cash Flow Analysis

Lecture 178 Calculating Cash Flows - Understand If a Business Makes or Burns Cash

Lecture 179 The Three Parts of Cash Flow Statements Explained

Lecture 180 Cash Flow Computations - The Direct Method

Lecture 181 Cash Flow Computations - The Indirect Method

Lecture 182 Calculating Cash Flow in Practice: A Complete Example

Lecture 183 FAQ: Why D&A Has Been Added in Capex?

Section 25: Advanced Accounting - Trade Receivables

Lecture 184 Why a Company Needs to Pay Attention to Trade Receivables?

Lecture 185 What If Clients Do Not Pay on Time?

Lecture 186 How to Handle Non-paying Customers? A Case-study

Lecture 187 A Technique to Collect Trade Receivables Sooner

Section 26: Advanced Accounting - Inventory

Lecture 188 The Different Types of Inventory We Can Have

Lecture 189 The Connection Between Cost of Goods Sold and Inventory

Lecture 190 Cost Flow Methods

Lecture 191 Cost Flow Methods - a Practical Exercise

Lecture 192 FAQ: How to Apply the Weighted Average Cost Method?

Section 27: Advanced Accounting - Fixed Assets

Lecture 193 The Different Types of Fixed Assets

Lecture 194 Capitalizing Interest Expenses

Lecture 195 Fair Value Accounting

Lecture 196 Intangible Assets with Finite Life vs. Intangible Assets with Infinite Life

Lecture 197 The Revaluation Model

Lecture 198 The Revaluation Model - Practical Exercise

Lecture 199 Intangible Assets Created Internally

Section 28: Advanced Accounting - Trade Payables

Lecture 200 How We Account for Trade Payables

Lecture 201 What Is the Difference Between Accounts Payable and Notes Payable?

Lecture 202 Why Use E-invoicing?

Section 29: Advanced Accounting - Financial Liabilities

Lecture 203 The Difference Between Debt and Equity

Lecture 204 Amortizing a Loan

Lecture 205 Debt Covenants

Lecture 206 Debt Covenants - A Practical Example

Section 30: Advanced Accounting - Leasing Liabilties

Lecture 207 The Reason Companies Lease Assets

Lecture 208 Solving a Complete Leasing Exercise

Section 31: Advanced Accounting - Using Leverage

Lecture 209 What is Leverage and Why Companies Use Financial Leverage?

Lecture 210 The Implications of Using Excessive Leverage

Section 32: Advanced Accounting - Raising Equity, Types of Equity, and Dividend Payments

Lecture 211 The Different Types of Equity

Lecture 212 Raising Equity in Different Stages of a Company's Lifecycle

Lecture 213 The Types of Dividends Companies Pay to Shareholders

Lecture 214 Dividend Payments - a Timeline

Lecture 215 What Are Share Repurchases and Why Companies Do Them

Lecture 216 The Idea Behind Stock Splits

Section 33: Assessment - Accounting

Section 34: Financial Statement Analysis - An Introduction

Lecture 217 What is a 10-K Report and Why Is It important for Investors?

Lecture 218 Finding, Downloading and Going Through the Annual Report of P&G

Lecture 219 What Is the Role of Auditing Firms and What Are the Benefits of an Audit?

Lecture 220 Indispensable Tools for Financial Statement Analysis

Section 35: Financial Statement Analysis - Subtleties

Lecture 221 Financial Statement Analysis - A Natural Continuation of Financial Accounting

Lecture 222 First Steps in Financial Statement Analysis

Lecture 223 Horizontal vs. Vertical Financial Statement Analysis

Lecture 224 Calculating Days Payable (DPO), Days Receivable (DSO) and Days Inventory (DIO)

Lecture 225 Using Accounting Ratios to Assess Business Performance

Section 36: Financial Statement Analysis - Practical Case Study "Analyzing P&G's Financials"

Lecture 226 Case Study - Calculating Ratios and Analyzing P&G's Financials (1/2)

Lecture 227 Case Study - Calculating Ratios and Analyzing P&G's Financials (2/2)

Lecture 228 COURSE CHALLENGE - Part 2

Section 37: Financial Statement Analysis - Tesla Exercise

Lecture 229 What You Will See Next In This Section

Lecture 230 How to Download Tesla's Historical Financials

Lecture 231 Calculating and Analyzing Growth and Profitability Ratios

Lecture 232 Calculating and Analyzing Liquidity Ratios

Lecture 233 Calculating and Analyzing Solvency Ratios

Section 38: Working Capital Management

Lecture 234 Introduction

Lecture 235 The Importance of Working Capital Optimization: Case Study

Lecture 236 Overtrading vs. Excessive Investment

Lecture 237 Trade Receivables Management

Lecture 238 Re-order Level

Lecture 239 Economic Order Quantity (EOQ)

Lecture 240 Inventory Optimization Techniques

Lecture 241 Trade Payables Management

Lecture 242 Working Capital Optimization - a Roadmap

Lecture 243 Symptoms of Inefficient Working Capital - Trade Payables

Lecture 244 Symptoms of Inefficient Working Capital - Trade Receivables

Section 39: Fundamentals of Business & Financial Analysis

Lecture 245 Fundamentals of Business & Financial Analysis

Section 40: Business Analysis in Excel

Lecture 246 Trend analysis - theory

Lecture 247 Trend analysis

Lecture 248 Comparative analysis - theory

Lecture 249 Comparative analysis

Lecture 250 Value-based analysis - theory

Lecture 251 Value-based analysis

Lecture 252 Correlation analysis - theory

Lecture 253 Correlation analysis

Lecture 254 Time series analysis - theory

Lecture 255 Time series analysis

Lecture 256 Regression analysis - theory

Lecture 257 Regression analysis

Section 41: Finance 101 - The Time Value of Money and Interest Rate Components

Lecture 258 Finance 101: Important Financial Principles That You Will Need

Lecture 259 Understanding the Time Value of Money

Lecture 260 How Interest Rates Play an Important Role in the Economy?

Lecture 261 The Components Forming Interest Rates in Real Life

Lecture 262 What Is Libor and What Purpose Does It Serve?

Lecture 263 The Difference Between Fixed and Variable Interest Rates

Lecture 264 What Is Default Risk and How Does a Bank Account For It?

Lecture 265 Corporate Loan Specifics

Section 42: Finance 101 - The Value of Cash Flows with Different Timing

Lecture 266 Calculating the Present Value of Future Cash Flows

Lecture 267 A Tool That Helps Us Decide Whether a Project Is Feasible: Net Present Value

Section 43: Finance 101 - Loan Calculations

Lecture 268 Using Annuities

Lecture 269 Calculating a Complete Loan Schedule

Lecture 270 COURSE CHALLENGE - Part 3

Section 44: Capital Budgeting - Basic Notions

Lecture 271 What is Capital Budgeting?

Lecture 272 When Do We Use Capital Budgeting?

Lecture 273 The Time Value of Money in a Capital Budgeting Setting

Lecture 274 Calculating Present and Future Value

Lecture 275 Cost of Equity

Lecture 276 Project-specific Beta

Lecture 277 The Weighted Average Cost of Capital (WACC)

Lecture 278 The Different Cash Flow Types in a Capital Budgeting Exercise

Lecture 279 Modeling Future Cash Flows

Section 45: Capital Budgeting - A Complete Case Study

Lecture 280 An Introduction to the Case Study

Lecture 281 Organizing Inputs In the "Drivers" Sheet

Lecture 282 Modeling Expected Savings - Building Cars In Italy vs. Building Cars In Vietnam

Lecture 283 Preparing a Fixed Asset Rollforward Schedule

Lecture 284 Calculating the Cash Impact of Extra Working Capital Required

Lecture 285 Debt Repayment and Interest Expenses Calculation

Lecture 286 The Project's P&L Sheet

Lecture 287 The Project's Cash Flow Calculation

Lecture 288 Calculating WACC (Weighted Average Cost of Capital)

Lecture 289 Estimating Cost of Equity

Lecture 290 Discounting Project Cash Flows

Lecture 291 Performing Sensitivity Analysis and Wrapping Up the Case Study

Lecture 292 FAQ: Data Does Not Change in the DCF Sheet, It Changes From the Drivers Sheet

Section 46: Tesla Practical Case Study - Building a Financial Planning Model

Lecture 293 Organizing External Inputs in a 'Drivers' Sheet

Lecture 294 Forecasting Tesla's Expected Deliveries

Lecture 295 Comparing Delivery Figures with the Ones of industry Peers

Lecture 296 Estimating an Average Selling Price of Tesla Vehicles

Lecture 297 Calculating Automotive Revenue

Lecture 298 Peer Comparison: Gross Profit %

Lecture 299 Calculating Automotive Gross Profit

Lecture 300 Calculating Automotive Cost of Sales

Lecture 301 Forecasting 'Energy' and 'Services' Revenue

Lecture 302 Calculating 'Energy' and 'Services' Gross Profit and Cost of Sales

Lecture 303 Forecasting Operating Expenses

Lecture 304 Building a Fixed Asset Roll Forward: PP&E

Lecture 305 Building a Fixed Asset Roll Forward: Estimating Capex

Lecture 306 Building a Fixed Asset Roll Forward: D&A Schedule

Lecture 307 Calculating DSO, DIO, DPO

Lecture 308 Producing a Clean P&L Output Sheet

Lecture 309 Calculating Investments in Working Capital

Lecture 310 Forecasting Unlevered Free Cash Flow

Lecture 311 Forecasting Other Assets

Lecture 312 Forecasting Other Liabilities

Lecture 313 Completing Unlevered Free Cash Flow

Lecture 314 Modeling Tesla's Financing Needs in the Forecast Period

Lecture 315 Calculating Net Income

Lecture 316 Bridging Unlevered Free Cash Flow to Net Cash Flow

Lecture 317 Balancing the Balance Sheet

Section 47: PowerPoint - Introduction to PowerPoint

Lecture 318 Microsoft PowerPoint: The Most Popular Presentation Software for the Office

Lecture 319 The Structure of the PowerPoint Ribbon

Lecture 320 General Considerations About Slide Structure

Lecture 321 Learn How to Insert Objects in PowerPoint

Lecture 322 Shortcuts Allow Us To Be Much Faster When Working in PowerPoint

Lecture 323 Add Frequently Used Buttons to the Quick Access Toolbar

Lecture 324 How to Easily Align Objects in PowerPoint

Lecture 325 How to Edit Shapes in Your Presentation

Lecture 326 How to Format Text Boxes in a PowerPoint Presentation

Lecture 327 Practical Learning - Exercise 1

Lecture 328 Changing an Object's Size and Rotation

Lecture 329 Using Slide Masters

Lecture 330 Bring to Front and Send to Back - An Important PowerPoint Technique

Lecture 331 Learn How to Create, Edit, Resize and Format PowerPoint Tables

Section 48: PowerPoint - Tips & Tricks That Will Transform You Into An Advanced User

Lecture 332 An Introduction to PowerPoint Animations

Lecture 333 Modifying the Beginning and Ending of a Line Object

Lecture 334 Join Shapes Together By Using Connector Lines

Lecture 335 Edit Points - Learn How to Customize PowerPoint Shapes

Lecture 336 Group or Ungroup Shapes, Pictures or Other Objects

Lecture 337 This is How You Can Fit Text When It Is Larger Than a Shape

Lecture 338 Nudge Objects

Lecture 339 PowerPoint's Smart Art Feature Offers Great Return for Your Time

Lecture 340 Creating Eye-Catching Text Effects in PowerPoint

Lecture 341 Practical Exercise - Creating an Organisational Chart

Lecture 342 COURSE CHALLENGE - Part 4

Section 49: Who Does What in the World of Finance?

Lecture 343 Who Does What in the World of Finance?

Section 50: Next Steps

Lecture 344 Next Steps

People who want a successful career in Finance,Anyone who wants to learn the practical skills of Financial analysis,People who are ambitious and want to learn faster than their peers