Topic outline

  • General

  • 2. What does it mean to be a finance manager

    • 1. How we measure financial performance Lesson
      Restricted Not available unless: The activity Quiz1 is complete and passed
    • 2. Improving performance measurement and collecting data Lesson
      Restricted Not available unless: The activity 1. How we measure financial performance is marked complete
  • 3. The importance of Enterprise Resource Planning (ERP) systems

    • 1. What is an ERP system Lesson
      Restricted Not available unless: The activity 2. Improving performance measurement and collecting data is marked complete
    • 2. Strongest advantages of ERP systems Lesson
      Restricted Not available unless: The activity 1. What is an ERP system is marked complete
    • Quiz 1: Quiz ERP systems
      Restricted Not available unless: The activity 2. Strongest advantages of ERP systems is marked complete
    • 3. Difficulties when implementing an ERP system Lesson
      Restricted Not available unless: The activity Quiz 1: Quiz ERP systems is complete and passed
    • 4. Best practices when implementing a new ERP system Lesson
      Restricted Not available unless: The activity 3. Difficulties when implementing an ERP system is marked complete
    • 5. A finance manager's leadership is crucial when implementing a new system Lesson
      Restricted Not available unless: The activity 4. Best practices when implementing a new ERP system is marked complete
    • 6. Case study Hershey's Lesson
      Restricted Not available unless: The activity 5. A finance manager's leadership is crucial when implementing a new system is marked complete
    • Quiz 2: Quiz ERP systems
      Restricted Not available unless: The activity 6. Case study Hershey's is marked complete
    • Assignment 1: ERP Systems - Course Challenge #1
      Restricted Not available unless: The activity Quiz 2: Quiz ERP systems is complete and passed
  • 4. Accounting Basics - Types of revenues, costs, assets, and liabilities

    • 1. Introduction to the section Lesson
      Restricted Not available unless: The activity Assignment 1: ERP Systems - Course Challenge #1 is marked complete
    • 2. The different types of accounting standards Lesson
      Restricted Not available unless: The activity 1. Introduction to the section is marked complete
    • 3. The three financial statements Lesson
      Restricted Not available unless: The activity 2. The different types of accounting standards is marked complete
    • 4. Types of revenues Lesson
      Restricted Not available unless: The activity 3. The three financial statements is marked complete
    • 5. Types of revenues - exercise Lesson
      Restricted Not available unless: The activity 4. Types of revenues is marked complete
    • 6. Types of expenses Lesson
      Restricted Not available unless: The activity 5. Types of revenues - exercise is marked complete
    • 7. Income taxes Lesson
      Restricted Not available unless: The activity 6. Types of expenses is marked complete
    • 8. Depreciation & Amortization Lesson
      Restricted Not available unless: The activity 7. Income taxes is marked complete
    • 9. Types of assets Lesson
      Restricted Not available unless: The activity 8. Depreciation & Amortization is marked complete
    • 10. Asset categories - practical example Lesson
      Restricted Not available unless: The activity 9. Types of assets is marked complete
    • 11. Types of liabilities Lesson
      Restricted Not available unless: The activity 10. Asset categories - practical example is marked complete
    • 12. Liability categories - practical example Lesson
      Restricted Not available unless: The activity 11. Types of liabilities is marked complete
    • 13. Equity Lesson
      Restricted Not available unless: The activity 12. Liability categories - practical example is marked complete
    • 14. Accrual accounting Lesson
      Restricted Not available unless: The activity 13. Equity is marked complete
  • 5. Accounting Basics - Revenue recognition

    • 1. The importance of timing when recognizing revenues Lesson
      Restricted Not available unless: The activity 14. Accrual accounting is marked complete
    • 2. Revenue recognition criteria - technical Lesson
      Restricted Not available unless: The activity 1. The importance of timing when recognizing revenues is marked complete
    • 3. Potential conflicts of interest when recognizing revenue Lesson
      Restricted Not available unless: The activity 2. Revenue recognition criteria - technical is marked complete
    • 4. A practical example Lesson
      Restricted Not available unless: The activity 3. Potential conflicts of interest when recognizing revenue is marked complete
  • 6. Accounting Basics - Cost recognition

    • 1. Cost recognition principles Lesson
      Restricted Not available unless: The activity 4. A practical example is marked complete
    • 2. Technical aspects of cost recognition Lesson
      Restricted Not available unless: The activity 1. Cost recognition principles is marked complete
    • 3. The two types of Income Statement formats Lesson
      Restricted Not available unless: The activity 2. Technical aspects of cost recognition is marked complete
    • Assignment 2: Basic Accounting - Course Challenge #2
      Restricted Not available unless: The activity 3. The two types of Income Statement formats is marked complete
  • 7. Advanced Accounting - Trade receivables

    • 1. Introduction to the section Lesson
      Restricted Not available unless: The activity Assignment 2: Basic Accounting - Course Challenge #2 is marked complete
    • 2. The importance of Trade receivables Lesson
      Restricted Not available unless: The activity 1. Introduction to the section is marked complete
    • 3. What happens when clients do not pay on time Lesson
      Restricted Not available unless: The activity 2. The importance of Trade receivables is marked complete
    • 4. Case study - dealing with non-paying customers Lesson
      Restricted Not available unless: The activity 3. What happens when clients do not pay on time is marked complete
    • 5. A technique to improve receivables collection Lesson
      Restricted Not available unless: The activity 4. Case study - dealing with non-paying customers is marked complete
  • 8. Advanced Accounting - Inventory

    • 1. Types of Inventory Lesson
      Restricted Not available unless: The activity 5. A technique to improve receivables collection is marked complete
    • 2. The relationship between Cogs and Inventory Lesson
      Restricted Not available unless: The activity 1. Types of Inventory is marked complete
    • 3. The different cost flow methods Lesson
      Restricted Not available unless: The activity 2. The relationship between Cogs and Inventory is marked complete
    • 4. Cost flow methods - a practical exercise Lesson
      Restricted Not available unless: The activity 3. The different cost flow methods is marked complete
  • 9. Advanced Accounting - Fixed assets

    • 1. The types of fixed assets Lesson
      Restricted Not available unless: The activity 4. Cost flow methods - a practical exercise is marked complete
    • 2. Capitalizing interest expenses Lesson
      Restricted Not available unless: The activity 1. The types of fixed assets is marked complete
    • 3. Fair value accounting Lesson
      Restricted Not available unless: The activity 2. Capitalizing interest expenses is marked complete
    • 4. Intangible assets with finite life vs. Intangible assets with infinite life Lesson
      Restricted Not available unless: The activity 3. Fair value accounting is marked complete
    • 5. The revaluation model Lesson
      Restricted Not available unless: The activity 4. Intangible assets with finite life vs. Intangible assets with infinite life is marked complete
    • 6. The revaluation model - practical exercise Lesson
      Restricted Not available unless: The activity 5. The revaluation model is marked complete
    • 7. Intangible assets created internally Lesson
      Restricted Not available unless: The activity 6. The revaluation model - practical exercise is marked complete
  • 10. Advanced Accounting - Trade payables

    • 1. Accounting for trade payables Lesson
      Restricted Not available unless: The activity 7. Intangible assets created internally is marked complete
    • 2. Accounts payable vs notes payable Lesson
      Restricted Not available unless: The activity 1. Accounting for trade payables is marked complete
    • 3. The advantages of e-invoicing Lesson
      Restricted Not available unless: The activity 2. Accounts payable vs notes payable is marked complete
  • 11. Advanced Accounting - Financial liabilities

    • 1. Distinguishing between debt and equity Lesson
      Restricted Not available unless: The activity 3. The advantages of e-invoicing is marked complete
    • 2. Loan amortization Lesson
      Restricted Not available unless: The activity 1. Distinguishing between debt and equity is marked complete
    • 3. Debt covenants Lesson
      Restricted Not available unless: The activity 2. Loan amortization is marked complete
    • 4. Debt covenants - Case study Lesson
      Restricted Not available unless: The activity 3. Debt covenants is marked complete
  • 12. Advanced Accounting - Leasing liabilities

    • 1. Why companies lease assets Lesson
      Restricted Not available unless: The activity 4. Debt covenants - Case study is marked complete
    • 2. Leasing exercise Lesson
      Restricted Not available unless: The activity 1. Why companies lease assets is marked complete
    • Assignment: Cost flow methods, Leasing, Revaluation - Course Challenge #3
      Restricted Not available unless: The activity 2. Leasing exercise is marked complete
  • 13. Sources of financing - Debt financing

    • 1. Why use leverage Lesson
      Restricted Not available unless: The activity Assignment: Cost flow methods, Leasing, Revaluation - Course Challenge #3 is marked complete
    • 2. The relationship between leverage and cost of debt Lesson
      Restricted Not available unless: The activity 1. Why use leverage is marked complete
  • 14. Sources of financing - Equity financing

    • 1. Types of equity Lesson
      Restricted Not available unless: The activity 2. The relationship between leverage and cost of debt is marked complete
    • 2. Raising equity in different stages of a company's lifecycle Lesson
      Restricted Not available unless: The activity 1. Types of equity is marked complete
    • 3. What type of dividends are distributed to shareholders Lesson
      Restricted Not available unless: The activity 2. Raising equity in different stages of a company's lifecycle is marked complete
    • 4. Timing mechanics of dividend payments Lesson
      Restricted Not available unless: The activity 3. What type of dividends are distributed to shareholders is marked complete
    • 5. Share repurchases Lesson
      Restricted Not available unless: The activity 4. Timing mechanics of dividend payments is marked complete
    • 6. Stock splits Lesson
      Restricted Not available unless: The activity 5. Share repurchases is marked complete
  • 15. Financial statement analysis

    • 1. Introduction to financial statement analysis Lesson
      Restricted Not available unless: The activity 6. Stock splits is marked complete
    • 2. Performing financial statement analysis Lesson
      Restricted Not available unless: The activity 1. Introduction to financial statement analysis is marked complete
    • 3. Ratio analysis Lesson
      Restricted Not available unless: The activity 2. Performing financial statement analysis is marked complete
    • 4. Practical example Analyzing P&G's financial report (12) Lesson
      Restricted Not available unless: The activity 3. Ratio analysis is marked complete
    • 5. Practical example Analyzing P&G's financial report (22) Lesson
      Restricted Not available unless: The activity 4. Practical example Analyzing P&G's financial report (12) is marked complete
    • Assignment: Financial statement analysis of Tesla Inc. - Course Challenge #5
      Restricted Not available unless: The activity 5. Practical example Analyzing P&G's financial report (22) is marked complete
  • 16. Working capital management

    • 1. Introduction Lesson
      Restricted Not available unless: The activity Assignment: Financial statement analysis of Tesla Inc. - Course Challenge #5 is marked complete
    • 2. The importance of working capital optimization case study Lesson
      Restricted Not available unless: The activity 1. Introduction is marked complete
    • 3. Overtrading vs. excessive investment Lesson
      Restricted Not available unless: The activity 2. The importance of working capital optimization case study is marked complete
    • 4. Trade receivables management Lesson
      Restricted Not available unless: The activity 3. Overtrading vs. excessive investment is marked complete
    • 5. Re-order level Lesson
      Restricted Not available unless: The activity 4. Trade receivables management is marked complete
    • 6. Economic order quantity (EOQ) Lesson
      Restricted Not available unless: The activity 5. Re-order level is marked complete
    • 7. Inventory optimization techniques Lesson
      Restricted Not available unless: The activity 6. Economic order quantity (EOQ) is marked complete
    • 8. Trade payables management Lesson
      Restricted Not available unless: The activity 7. Inventory optimization techniques is marked complete
    • 9. Working capital optimization - a roadmap Lesson
      Restricted Not available unless: The activity 8. Trade payables management is marked complete
    • 10. Symptoms of inefficient working capital - Trade payables Lesson
      Restricted Not available unless: The activity 9. Working capital optimization - a roadmap is marked complete
    • 11. Symptoms of inefficient working capital - Trade receivables Lesson
      Restricted Not available unless: The activity 10. Symptoms of inefficient working capital - Trade payables is marked complete
    • Assignment 5: Working capital optimization - Course Challenge #5
      Restricted Not available unless: The activity 11. Symptoms of inefficient working capital - Trade receivables is marked complete
  • 17. Capital budgeting - The theory behind capital budgeting

    • 1. An introduction to capital budgeting Lesson
      Restricted Not available unless: The activity Assignment 5: Working capital optimization - Course Challenge #5 is marked complete
    • 2. Why companies need capital budgeting Lesson
      Restricted Not available unless: The activity 1. An introduction to capital budgeting is marked complete
    • 3. The time value of money in a capital budgeting exercise Lesson
      Restricted Not available unless: The activity 2. Why companies need capital budgeting is marked complete
    • 4. Working with present and future cash flows Lesson
      Restricted Not available unless: The activity 3. The time value of money in a capital budgeting exercise is marked complete
    • 5. Calculating cost of debt and cost of equity Lesson
      Restricted Not available unless: The activity 4. Working with present and future cash flows is marked complete
    • 6. An important subtlety - project-specific beta Lesson
      Restricted Not available unless: The activity 5. Calculating cost of debt and cost of equity is marked complete
    • 7. Calculating WACC Lesson
      Restricted Not available unless: The activity 6. An important subtlety - project-specific beta is marked complete
    • 8. How to treat the value of residual assets at the end of the project Lesson
      Restricted Not available unless: The activity 7. Calculating WACC is marked complete
    • 9. Forecasting future cash flows Lesson
      Restricted Not available unless: The activity 8. How to treat the value of residual assets at the end of the project is marked complete
  • 18. Capital budgeting - A complete case study

    • 1. An introduction to the case study Lesson
      Restricted Not available unless: The activity 9. Forecasting future cash flows is marked complete
    • 2. Going through the 'Drivers' sheet Lesson
      Restricted Not available unless: The activity 1. An introduction to the case study is marked complete
    • 3. Forecasting the savings that will be generated by the project Lesson
      Restricted Not available unless: The activity 2. Going through the 'Drivers' sheet is marked complete
    • 4. Performing a fixed asset roll forward Lesson
      Restricted Not available unless: The activity 3. Forecasting the savings that will be generated by the project is marked complete
    • 5. Forecasting working capital needs Lesson
      Restricted Not available unless: The activity 4. Performing a fixed asset roll forward is marked complete
    • 6. Modeling the project's financing Lesson
      Restricted Not available unless: The activity 5. Forecasting working capital needs is marked complete
    • 7. Creating a P&L sheet Lesson
      Restricted Not available unless: The activity 6. Modeling the project's financing is marked complete
    • 8. Cash flow calculation Lesson
      Restricted Not available unless: The activity 7. Creating a P&L sheet is marked complete
    • 9. Calculating the discount rate we will use - WACC Lesson
      Restricted Not available unless: The activity 8. Cash flow calculation is marked complete
    • 10. Calculating cost of equity Lesson
      Restricted Not available unless: The activity 9. Calculating the discount rate we will use - WACC is marked complete
    • 11. Discounting cash flows Lesson
      Restricted Not available unless: The activity 10. Calculating cost of equity is marked complete
    • 12. Performing sensitivity analysis Lesson
      Restricted Not available unless: The activity 11. Discounting cash flows is marked complete
    • Assignment 6: Power plant capital budgeting - Course Challenge #6
      Restricted Not available unless: The activity 12. Performing sensitivity analysis is marked complete
  • 19. Financial reporting in Excel - Introduction to Pivot tables

    • 1. Introduction to Pivot tables Lesson
      Restricted Not available unless: The activity Assignment 6: Power plant capital budgeting - Course Challenge #6 is marked complete
    • 2. Structuring a Pivot table Lesson
      Restricted Not available unless: The activity 1. Introduction to Pivot tables is marked complete
    • 3. Pivot table formatting Lesson
      Restricted Not available unless: The activity 2. Structuring a Pivot table is marked complete
    • 4. Modifying a Pivot table's content Lesson
      Restricted Not available unless: The activity 3. Pivot table formatting is marked complete
    • 5. Using GETPIVOTDATA Lesson
      Restricted Not available unless: The activity 4. Modifying a Pivot table's content is marked complete
    • 6. Learn how to work with slicers Lesson
      Restricted Not available unless: The activity 5. Using GETPIVOTDATA is marked complete
  • 20. Financial reporting in Excel - World-class reporting (Slicers and Pivot Table)

    • 1. Introduction to the Case Study Lesson
      Restricted Not available unless: The activity 6. Learn how to work with slicers is marked complete
    • 2. Understanding the source data Lesson
      Restricted Not available unless: The activity 1. Introduction to the Case Study is marked complete
    • 3. Mapping of the source data Lesson
      Restricted Not available unless: The activity 2. Understanding the source data is marked complete
    • 4. Setting up a structure for the dashboard we'll create Lesson
      Restricted Not available unless: The activity 3. Mapping of the source data is marked complete
    • 5. Working on the dashboard's layout Lesson
      Restricted Not available unless: The activity 4. Setting up a structure for the dashboard we'll create is marked complete
    • 6. Inserting calculation formulas Lesson
      Restricted Not available unless: The activity 5. Working on the dashboard's layout is marked complete
    • 7. Creating the source Pivot table Lesson
      Restricted Not available unless: The activity 6. Inserting calculation formulas is marked complete
    • 8. Using GETPIVOTDATA to connect the Pivot table and the dashboard Lesson
      Restricted Not available unless: The activity 7. Creating the source Pivot table is marked complete
    • 9. Adding slicers and making our dashboard interactive Lesson
      Restricted Not available unless: The activity 8. Using GETPIVOTDATA to connect the Pivot table and the dashboard is marked complete
    • 10. Improving the layout of the slicers we added Lesson
      Restricted Not available unless: The activity 9. Adding slicers and making our dashboard interactive is marked complete
    • 11. How the dashboard can be used in practice Lesson
      Restricted Not available unless: The activity 10. Improving the layout of the slicers we added is marked complete
    • Assignment: Pivot table dashboards with slicers - Course Challenge #7
      Restricted Not available unless: The activity 11. How the dashboard can be used in practice is marked complete
  • 21. Creating effective presentations - Introduction

    • 1. Introduction to creating effective presentations Lesson
      Restricted Not available unless: The activity Assignment: Pivot table dashboards with slicers - Course Challenge #7 is marked complete
    • 2. Types of corporate presentations Lesson
      Restricted Not available unless: The activity 1. Introduction to creating effective presentations is marked complete
    • 3. What you will see next Lesson
      Restricted Not available unless: The activity 2. Types of corporate presentations is marked complete
  • 22. Creating effective presentations - Key principles

    • 1. Principle #1 - Deliver maximum information in a limited space Lesson
      Restricted Not available unless: The activity 3. What you will see next is marked complete
    • 2. Principle #2 - Develop logical slide flow Lesson
      Restricted Not available unless: The activity 1. Principle #1 - Deliver maximum information in a limited space is marked complete
    • 3. Principle #3 - Key messages start from the title Lesson
      Restricted Not available unless: The activity 2. Principle #2 - Develop logical slide flow is marked complete
    • 4. Principle #4 - Tailor the presentation to the intended audience Lesson
      Restricted Not available unless: The activity 3. Principle #3 - Key messages start from the title is marked complete
    • 5. Principle #5 - Keep text messages short Lesson
      Restricted Not available unless: The activity 4. Principle #4 - Tailor the presentation to the intended audience is marked complete
    • 6. Principle #6 - Use key words Lesson
      Restricted Not available unless: The activity 5. Principle #5 - Keep text messages short is marked complete
  • 23. Creating effective presentations - Key principles

    • 1. Principle #7 - A picture is worth a thousand words Lesson
      Restricted Not available unless: The activity 6. Principle #6 - Use key words is marked complete
    • 2. Principle #8 - Have the big picture in mind Lesson
      Restricted Not available unless: The activity 1. Principle #7 - A picture is worth a thousand words is marked complete
    • 3. Principle #9 - Plan well ahead Lesson
      Restricted Not available unless: The activity 2. Principle #8 - Have the big picture in mind is marked complete
    • 4. Principle #10 - Decide what information should be included in slides Lesson
      Restricted Not available unless: The activity 3. Principle #9 - Plan well ahead is marked complete
  • 24. Creating effective presentations - Technical skills

    • 1. Adding text boxes with instructions Lesson
      Restricted Not available unless: The activity 4. Principle #10 - Decide what information should be included in slides is marked complete
    • 2. Populating slide content Lesson
      Restricted Not available unless: The activity 1. Adding text boxes with instructions is marked complete
    • 3. Formatting and polishing slides Lesson
      Restricted Not available unless: The activity 2. Populating slide content is marked complete
  • 25. Creating effective presentations - The importance of consistency

    • 1. Ensuring consistency across the entire presentation Lesson
      Restricted Not available unless: The activity 3. Formatting and polishing slides is marked complete
    • 2. Consistent font and font size Lesson
      Restricted Not available unless: The activity 1. Ensuring consistency across the entire presentation is marked complete
    • 3. Aligning objects Lesson
      Restricted Not available unless: The activity 2. Consistent font and font size is marked complete
    • 4. Working in a team Lesson
      Restricted Not available unless: The activity 3. Aligning objects is marked complete
    • 5. Adding watermarks Lesson
      Restricted Not available unless: The activity 4. Working in a team is marked complete
  • 26. Creating effective presentations - Company profile

    • 1. Introduction Lesson
      Restricted Not available unless: The activity 5. Adding watermarks is marked complete
    • 2. What is a company profile Lesson
      Restricted Not available unless: The activity 1. Introduction is marked complete
    • 3. Content going in company profile slides Lesson
      Restricted Not available unless: The activity 2. What is a company profile is marked complete
    • 4. Creating a company profile Lesson
      Restricted Not available unless: The activity 3. Content going in company profile slides is marked complete
    • 5. Key financials Lesson
      Restricted Not available unless: The activity 4. Creating a company profile is marked complete
    • 6. Company profiles - research Lesson
      Restricted Not available unless: The activity 5. Key financials is marked complete
    • 7. One-page company profile layout Lesson
      Restricted Not available unless: The activity 6. Company profiles - research is marked complete
  • 27. Creating effective presentations - Share price slide

    • 1. Why create share price slides Lesson
      Restricted Not available unless: The activity 7. One-page company profile layout is marked complete
    • 2. What content goes into a share price chart Lesson
      Restricted Not available unless: The activity 1. Why create share price slides is marked complete
    • 3. Designing a share price chart Lesson
      Restricted Not available unless: The activity 2. What content goes into a share price chart is marked complete
  • 28. Creating effective presentations - Other slides in a company presentation

    • 1. Group structure Lesson
      Restricted Not available unless: The activity 3. Designing a share price chart is marked complete
    • 2. The management team slide Lesson
      Restricted Not available unless: The activity 1. Group structure is marked complete
    • 3. Waterfall charts Lesson
      Restricted Not available unless: The activity 2. The management team slide is marked complete
    • 4. Financial information overview Lesson
      Restricted Not available unless: The activity 3. Waterfall charts is marked complete
    • 5. Geographical presence Lesson
      Restricted Not available unless: The activity 4. Financial information overview is marked complete
    • 6. KPI evolution overview Lesson
      Restricted Not available unless: The activity 5. Geographical presence is marked complete
    • Assignment: Preparing a company presentation - Course Challenge #8
      Restricted Not available unless: The activity 6. KPI evolution overview is marked complete
  • 29. Company valuation - The fundamentals you need to learn

    • 1. The reason we want to value a business Lesson
      Restricted Not available unless: The activity Assignment: Preparing a company presentation - Course Challenge #8 is marked complete
    • 2. The investor perspective to company valuation Lesson
      Restricted Not available unless: The activity 1. The reason we want to value a business is marked complete
    • 3. The two variables determining a company's valuation Lesson
      Restricted Not available unless: The activity 2. The investor perspective to company valuation is marked complete
    • 4. Calculating Unlevered Cash Flow Lesson
      Restricted Not available unless: The activity 3. The two variables determining a company's valuation is marked complete
    • 5. Weighted average cost of capital (WACC) - the discount factor we will use Lesson
      Restricted Not available unless: The activity 4. Calculating Unlevered Cash Flow is marked complete
    • 6. Forecasting the firm's future cash flows Lesson
      Restricted Not available unless: The activity 5. Weighted average cost of capital (WACC) - the discount factor we will use is marked complete
    • 7. Two stages of valuation - explicit forecast period and terminal value Lesson
      Restricted Not available unless: The activity 6. Forecasting the firm's future cash flows is marked complete
    • 8. Discounting cash flows Lesson
      Restricted Not available unless: The activity 7. Two stages of valuation - explicit forecast period and terminal value is marked complete
    • 9. Coming up with Enterprise and Equity value Lesson
      Restricted Not available unless: The activity 8. Discounting cash flows is marked complete
  • 30. Company valuation - A practical exercise

    • 1. Introduction to the case study Lesson
      Restricted Not available unless: The activity 9. Coming up with Enterprise and Equity value is marked complete
    • 2. How we build a complete DCF model Lesson
      Restricted Not available unless: The activity 1. Introduction to the case study is marked complete
    • 3. The structure of the model we will build Lesson
      Restricted Not available unless: The activity 2. How we build a complete DCF model is marked complete
    • 4. The company we are valuing Lesson
      Restricted Not available unless: The activity 3. The structure of the model we will build is marked complete
    • 5. Modeling revenues Lesson
      Restricted Not available unless: The activity 4. The company we are valuing is marked complete
    • 6. Using the CHOOSE function to create flexible financial models Lesson
      Restricted Not available unless: The activity 5. Modeling revenues is marked complete
    • 7. Modeling other items (13) Lesson
      Restricted Not available unless: The activity 6. Using the CHOOSE function to create flexible financial models is marked complete
    • 8. Modeling other items (23) Lesson
      Restricted Not available unless: The activity 7. Modeling other items (13) is marked complete
    • 9. Modeling other items (33) Lesson
      Restricted Not available unless: The activity 8. Modeling other items (23) is marked complete
    • 10. Forecasting Balance sheet figures Lesson
      Restricted Not available unless: The activity 9. Modeling other items (33) is marked complete
    • 11. The Days technique Lesson
      Restricted Not available unless: The activity 10. Forecasting Balance sheet figures is marked complete
    • 12. Calculating Days Lesson
      Restricted Not available unless: The activity 11. The Days technique is marked complete
    • 13. Using Days to forecast trade receivables, inventory, and trade payables Lesson
      Restricted Not available unless: The activity 12. Calculating Days is marked complete
    • 14. Forecasting PP&E, Other assets, and Other liabilities Lesson
      Restricted Not available unless: The activity 13. Using Days to forecast trade receivables, inventory, and trade payables is marked complete
    • 15. Creating an output P&L sheet Lesson
      Restricted Not available unless: The activity 14. Forecasting PP&E, Other assets, and Other liabilities is marked complete
    • 16. Filling in the P&L sheet Lesson
      Restricted Not available unless: The activity 15. Creating an output P&L sheet is marked complete
    • 17. Adding an output Balance sheet Lesson
      Restricted Not available unless: The activity 16. Filling in the P&L sheet is marked complete
    • 18. Filling in the output Balance sheet Lesson
      Restricted Not available unless: The activity 17. Adding an output Balance sheet is marked complete
    • 19. Structuring unlevered cash flow Lesson
      Restricted Not available unless: The activity 18. Filling in the output Balance sheet is marked complete
    • 20. Reconciling Unlevered cash flow and net cash flow Lesson
      Restricted Not available unless: The activity 19. Structuring unlevered cash flow is marked complete
    • 21. Calculating cash flow Lesson
      Restricted Not available unless: The activity 20. Reconciling Unlevered cash flow and net cash flow is marked complete
    • 22. Obtaining net cash flow figures Lesson
      Restricted Not available unless: The activity 21. Calculating cash flow is marked complete
    • 23. Editing multiple cell references at the same time Lesson
      Restricted Not available unless: The activity 22. Obtaining net cash flow figures is marked complete
    • 24. Adding WACC to the model Lesson
      Restricted Not available unless: The activity 23. Editing multiple cell references at the same time is marked complete
    • 25. Using WACC to obtain the present value of future cash flows Lesson
      Restricted Not available unless: The activity 24. Adding WACC to the model is marked complete
    • 26. Calculating Terminal value and Enterprise value Lesson
      Restricted Not available unless: The activity 25. Using WACC to obtain the present value of future cash flows is marked complete
    • 27. Obtaining Equity value Lesson
      Restricted Not available unless: The activity 26. Calculating Terminal value and Enterprise value is marked complete
    • 28. Performing sensitivity analysis for improved decision-making Lesson
      Restricted Not available unless: The activity 27. Obtaining Equity value is marked complete
    • 29. Applying Goal seek Lesson
      Restricted Not available unless: The activity 28. Performing sensitivity analysis for improved decision-making is marked complete
    • 30. Recap of the model + charts we can build Lesson
      Restricted Not available unless: The activity 29. Applying Goal seek is marked complete
    • Assignment: Company valuation Tesla Inc. - Course Challenge #9
      Restricted Not available unless: The activity 30. Recap of the model + charts we can build is marked complete
    • 32. Tesla Inc. company valuation - detailed walkthrough and solutions Lesson
      Restricted Not available unless: The activity Assignment: Company valuation Tesla Inc. - Course Challenge #9 is marked complete
  • 31. Becoming a manager - An Introduction

    • 1. What are we going to see next Lesson
      Restricted Not available unless: The activity 32. Tesla Inc. company valuation - detailed walkthrough and solutions is marked complete
    • 2. Why companies need managers Lesson
      Restricted Not available unless: The activity 1. What are we going to see next is marked complete
    • 3. How to distinguish good managers Lesson
      Restricted Not available unless: The activity 2. Why companies need managers is marked complete
    • 4. Managerial positions in an organization Lesson
      Restricted Not available unless: The activity 3. How to distinguish good managers is marked complete
    • 5. Managerial functions Lesson
      Restricted Not available unless: The activity 4. Managerial positions in an organization is marked complete
    • Quiz 3: Introduction quiz
      Restricted Not available unless: The activity 5. Managerial functions is marked complete
  • 32. Becoming a manager - how to approach planning

    • 1. Why companies need planning Lesson
      Restricted Not available unless: The activity Quiz 3: Introduction quiz is marked complete
    • 2. The objectives pyramid Lesson
      Restricted Not available unless: The activity 1. Why companies need planning is marked complete
    • 3. Applying the SMART framework Lesson
      Restricted Not available unless: The activity 2. The objectives pyramid is marked complete
    • 4. Environmental scanning - competitor research Lesson
      Restricted Not available unless: The activity 3. Applying the SMART framework is marked complete
    • 5. Financial analysis and calculating break-even Lesson
      Restricted Not available unless: The activity 4. Environmental scanning - competitor research is marked complete
    • 6. The importance of budgeting Lesson
      Restricted Not available unless: The activity 5. Financial analysis and calculating break-even is marked complete
    • 7. Using project management to boost productivity Lesson
      Restricted Not available unless: The activity 6. The importance of budgeting is marked complete
    • Quiz 4: How to approach planning
      Restricted Not available unless: The activity 7. Using project management to boost productivity is marked complete
  • 33. Becoming a manager - Organizing human resources

    • 1. How do we organize human resources in a company Lesson
      Restricted Not available unless: The activity Quiz 4: How to approach planning is marked complete
    • 2. Why human resources are considered the most important asset of companies Lesson
      Restricted Not available unless: The activity 1. How do we organize human resources in a company is marked complete
    • 3. Planning the firm's HR needs Lesson
      Restricted Not available unless: The activity 2. Why human resources are considered the most important asset of companies is marked complete
    • Quiz 5: Organizing human resources
      Restricted Not available unless: The activity 3. Planning the firm's HR needs is marked complete
  • 34. Becoming a manager - Pre-hire activities

    • 1. Finding the right people for the job Lesson
      Restricted Not available unless: The activity Quiz 5: Organizing human resources is marked complete
    • 2. Meeting candidates Lesson
      Restricted Not available unless: The activity 1. Finding the right people for the job is marked complete
    • 3. Selecting among candidates Lesson
      Restricted Not available unless: The activity 2. Meeting candidates is marked complete
    • Quiz 6: Pre-hire activities
      Restricted Not available unless: The activity 3. Selecting among candidates is marked complete
  • 35. Becoming a manager - Post-hire activities

    • 1. Onboarding successful candidates Lesson
      Restricted Not available unless: The activity Quiz 6: Pre-hire activities is marked complete
    • 2. Learning and development - the key to employee engagement Lesson
      Restricted Not available unless: The activity 1. Onboarding successful candidates is marked complete
    • 3. Giving constructive feedback Lesson
      Restricted Not available unless: The activity 2. Learning and development - the key to employee engagement is marked complete
    • 4. Performance appraisal Lesson
      Restricted Not available unless: The activity 3. Giving constructive feedback is marked complete
    • 5. Aligning compensation and performance Lesson
      Restricted Not available unless: The activity 4. Performance appraisal is marked complete
    • Quiz 7: Post-hire activities
      Restricted Not available unless: The activity 5. Aligning compensation and performance is marked complete
  • 36. Becoming a manager - The leading function

    • 1. The core principles of employee motivation Lesson
      Restricted Not available unless: The activity Quiz 7: Post-hire activities is marked complete
    • 2. Proven employee motivation tips Lesson
      Restricted Not available unless: The activity 1. The core principles of employee motivation is marked complete
    • 3. Stress management tips Lesson
      Restricted Not available unless: The activity 2. Proven employee motivation tips is marked complete
    • 4. A measure of last resort - terminating employee contracts Lesson
      Restricted Not available unless: The activity 3. Stress management tips is marked complete
    • Quiz 8: The leading function
      Restricted Not available unless: The activity 4. A measure of last resort - terminating employee contracts is marked complete
  • 37. The subtleties of Negotiation for managers - An introduction

    • 1. What are we going to see next Lesson
      Restricted Not available unless: The activity Quiz 8: The leading function is complete and passed
    • 2. Why finance managers need to be good negotiators Lesson
      Restricted Not available unless: The activity 1. What are we going to see next is marked complete
    • 3. The reason people are not always good at negotiations Lesson
      Restricted Not available unless: The activity 2. Why finance managers need to be good negotiators is marked complete
  • 38. The subtleties of Negotiation for managers - The negotiation toolbox

    • 1. You need to know what BATNA is Lesson
      Restricted Not available unless: The activity 3. The reason people are not always good at negotiations is marked complete
    • 2. Reservation point and the Bargaining range Lesson
      Restricted Not available unless: The activity 1. You need to know what BATNA is is marked complete
    • Quiz 9: Introduction
      Restricted Not available unless: The activity 2. Reservation point and the Bargaining range is marked complete
  • 39. The subtleties of Negotiation for managers - Preparation is key

    • 1. Self-assessment Lesson
      Restricted Not available unless: The activity Quiz 9: Introduction is complete and passed
    • 2. Counterpart assessment Lesson
      Restricted Not available unless: The activity 1. Self-assessment is marked complete
    • 3. Situational assessment Lesson
      Restricted Not available unless: The activity 2. Counterpart assessment is marked complete
    • Quiz 10: Preparation is key
      Restricted Not available unless: The activity 3. Situational assessment is marked complete
  • 40. The subtleties of Negotiation for managers - Types of negotiation

    • 1. Splitting the difference - Distributive negotiations Lesson
      Restricted Not available unless: The activity Quiz 10: Preparation is key is complete and passed
    • 2. Pie-slicing strategies Lesson
      Restricted Not available unless: The activity 1. Splitting the difference - Distributive negotiations is marked complete
    • 3. Interest-based bargaining Lesson
      Restricted Not available unless: The activity 2. Pie-slicing strategies is marked complete
    • 4. Interest-based negotiation strategies Lesson
      Restricted Not available unless: The activity 3. Interest-based bargaining is marked complete
    • 5. Claiming Lesson
      Restricted Not available unless: The activity 4. Interest-based negotiation strategies is marked complete
    • 6. Choosing an optimal negotiation strategy Lesson
      Restricted Not available unless: The activity 5. Claiming is marked complete
    • Quiz 11: Types of negotiation
      Restricted Not available unless: The activity 6. Choosing an optimal negotiation strategy is marked complete
  • 41. The subtleties of Negotiation for managers - Long-term success tactics

    • 1. Aversive tactics and counter action Lesson
      Restricted Not available unless: The activity Quiz 11: Types of negotiation is complete and passed
    • 2. Dealing with conflict situations Lesson
      Restricted Not available unless: The activity 1. Aversive tactics and counter action is marked complete
    • 3. The importance of trust Lesson
      Restricted Not available unless: The activity 2. Dealing with conflict situations is marked complete
    • 4. How to fix broken trust Lesson
      Restricted Not available unless: The activity 3. The importance of trust is marked complete
    • 5. Mediums of negotiation Lesson
      Restricted Not available unless: The activity 4. How to fix broken trust is marked complete
    • Quiz 12: Long-term success tactics
      Restricted Not available unless: The activity 5. Mediums of negotiation is marked complete
  • 42. The subtleties of Negotiation for managers - It's time for a Case Study

    • 1. Disney buys Lucasfilm - a case study Lesson
      Restricted Not available unless: The activity Quiz 12: Long-term success tactics is complete and passed
    • Assignment 10: Management and Negotiation - Course Challenge #10
      Restricted Not available unless: The activity 1. Disney buys Lucasfilm - a case study is marked complete