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