Strongest advantages of ERP systems 
 
Difficulties when implementing an ERP system 
 
Best practices when implementing a new ERP system 
 
A finance manager's leadership is crucial when implementing a new system 
 
ERP Systems - Course Challenge #1 
 
Introduction to the section 
 
The different types of accounting standards 
 
The three financial statements 
 
Types of revenues - exercise 
 
Depreciation & Amortization 
 
Asset categories - practical example 
 
Liability categories - practical example 
 
Introduction to the section 
 
The importance of Trade receivables 
 
What happens when clients do not pay on time? 
 
Case study - dealing with non-paying customers 
 
A technique to improve receivables collection 
 
The types of fixed assets 
 
Capitalizing interest expenses 
 
Intangible assets with finite life vs. Intangible assets with infinite life 
 
The revaluation model - practical exercise 
 
Intangible assets created internally 
 
Introduction to financial statement analysis 
 
Performing financial statement analysis 
 
Practical example: Analyzing P&G's financial report (1/2) 
 
Practical example: Analyzing P&G's financial report (2/2) 
 
Financial statement analysis of Tesla Inc. - Course Challenge #5 
 
The importance of working capital optimization: case study 
 
Overtrading vs. excessive investment 
 
Trade receivables management 
 
Economic order quantity (EOQ) 
 
Inventory optimization techniques 
 
Trade payables management 
 
Working capital optimization - a roadmap 
 
Symptoms of inefficient working capital - Trade payables 
 
Symptoms of inefficient working capital - Trade receivables 
 
Working capital optimization - Course Challenge #5 
 
An introduction to capital budgeting 
 
Why companies need capital budgeting 
 
The time value of money in a capital budgeting exercise 
 
Working with present and future cash flows 
 
Calculating cost of debt and cost of equity 
 
An important subtlety - project-specific beta 
 
Completed 33% of the course 
 
How to treat the value of residual assets at the end of the project 
 
Forecasting future cash flows 
 
An introduction to the case study 
 
Going through the 'Drivers' sheet 
 
Forecasting the savings that will be generated by the project 
 
Performing a fixed asset roll forward 
 
Forecasting working capital needs 
 
Modeling the project's financing 
 
Calculating the discount rate we will use - WACC 
 
Calculating cost of equity 
 
Performing sensitivity analysis 
 
Power plant capital budgeting - Course Challenge #6 
 
Introduction to the Case Study 
 
Understanding the source data 
 
Mapping of the source data 
 
Setting up a structure for the dashboard we'll create 
 
Working on the dashboard's layout 
 
Inserting calculation formulas 
 
Creating the source Pivot table 
 
Using GETPIVOTDATA to connect the Pivot table and the dashboard 
 
Adding slicers and making our dashboard interactive 
 
Improving the layout of the slicers we added 
 
How the dashboard can be used in practice 
 
Pivot table dashboards with slicers - Course Challenge #7 
 
Principle #1 - Deliver maximum information in a limited space 
 
Principle #2 - Develop logical slide flow 
 
Principle #3 - Key messages start from the title 
 
Principle #4 - Tailor the presentation to the intended audience 
 
Completed 50% of the course 
 
Principle #5 - Keep text messages short 
 
Principle #6 - Use key words 
 
What is a company profile 
 
Content going in company profile slides 
 
Creating a company profile 
 
Company profiles - research 
 
One-page company profile layout 
 
The reason we want to value a business 
 
The investor perspective to company valuation 
 
The two variables determining a company's valuation 
 
Calculating Unlevered Cash Flow 
 
Weighted average cost of capital (WACC) - the discount factor we will use 
 
Forecasting the firm's future cash flows 
 
Two stages of valuation - explicit forecast period and terminal value 
 
Coming up with Enterprise and Equity value 
 
Introduction to the case study 
 
How we build a complete DCF model 
 
The structure of the model we will build 
 
The company we are valuing 
 
Using the CHOOSE function to create flexible financial models 
 
Modeling other items (1/3) 
 
Modeling other items (2/3) 
 
Modeling other items (3/3) 
 
Forecasting Balance sheet figures 
 
Using "Days" to forecast trade receivables inventory and trade payables 
 
Forecasting PP&E Other assets and Other liabilities 
 
Creating an output P&L sheet 
 
Adding an output Balance sheet 
 
Filling in the output Balance sheet 
 
Structuring unlevered cash flow 
 
Reconciling Unlevered cash flow and net cash flow 
 
Obtaining net cash flow figures 
 
Editing multiple cell references at the same time 
 
Using WACC to obtain the present value of future cash flows 
 
Calculating Terminal value and Enterprise value 
 
Performing sensitivity analysis for improved decision-making 
 
Recap of the model + charts we can build 
 
Company valuation Tesla Inc. - Course Challenge #9 
 
Tesla Inc. company valuation - detailed walkthrough and solutions 
 
Why companies need planning 
 
Applying the SMART framework 
 
Environmental scanning - competitor research 
 
Financial analysis and calculating break-even 
 
The importance of budgeting 
 
Using project management to boost productivity