The Complete Finance Manager

Financial Management, ERP systems, Accounting, Capital budgeting, Presentation design, Management, and Negotiation

Last updated 2022-01-10 | 4.5

- Understand how companies measure financial performance
- Determine why ERP systems facilitate business process
- Employ best practices when working on the implementation of an ERP system

What you'll learn

Understand how companies measure financial performance

Determine why ERP systems facilitate business process

Employ best practices when working on the implementation of an ERP system

Learn basic accounting principles

Specialize in advanced accounting topics (revenue recognition

invoicing mechanics

cost flow methods

capitalized costs

fair value accounting

revaluation

etc.)

Secure financing and understand debt covenants

Perform leasing calculations

Perform pension liabilities calculations

Know how to optimize a company's working capital

Perform inventory

trade receivables

and trade payables management

Recognize when a company is inefficient in its working capital management

Understand the time value of money

Be able to calculate cost of debt

cost of equity

and WACC

Forecast future cash flows

Discount future cash flows to obtain their present value

Know how to raise equity

Understand the treatment of dividend payments

share repurchases

and stock splits

Perform financial statement analysis

Assess investment opportunities

Apply capital budgeting techniques such as: NPV

IRR

and ROI

Build capital budgeting financial models from scratch

Perform sensitivity analysis

Create interactive Excel dashboards

Use Excel slicers for financial reporting

Create professional and attractive corporate presentations - in line with ones prepared by top tier investment banks

Study the ten key principles of presentation creation

Learn how to create company profile

key financials

share price

group structure

waterfall

geographical presence

and other types of slides used in finance

Calculate a company's net cash flow

Be able to create a company valuation model from scratch

Calculate a firm's enterprise and equity value using DCF

Learn how to become an effective and respected manager

Be able to recruit

select

onboard

train

develop

and retain talented employees

Provide employee feedback

Organize performance review meetings

Negotiate effectively

Apply negotiation tactics that will ensure your success in the long run

* Requirements

* Basic knowledge of accounting and financial math
* Willingness to become a finance manager

Description

Understand how companies measure financial performance
Determine why ERP systems facilitate business process
Employ best practices when working on the implementation of an ERP system
Learn basic accounting principles
Specialize in advanced accounting topics (revenue recognition, invoicing mechanics, cost flow methods, capitalized costs, fair value accounting, revaluation, etc.)
Secure financing and understand debt covenants
Perform leasing calculations
Perform pension liabilities calculations
Know how to optimize a company's working capital
Perform inventory, trade receivables, and trade payables management
Recognize when a company is inefficient in its working capital management
Understand the time value of money
Be able to calculate cost of debt, cost of equity, and WACC
Forecast future cash flows
Discount future cash flows to obtain their present value
Know how to raise equity
Understand the treatment of dividend payments, share repurchases, and stock splits
Perform financial statement analysis
Assess investment opportunities
Apply capital budgeting techniques such as: NPV, IRR, and ROI
Build capital budgeting financial models from scratch
Perform sensitivity analysis
Create interactive Excel dashboards
Use Excel slicers for financial reporting
Create professional and attractive corporate presentations - in line with ones prepared by top tier investment banks
Study the ten key principles of presentation creation
Learn how to create company profile, key financials, share price, group structure, waterfall, geographical presence, and other types of slides used in finance
Calculate a company's net cash flow
Be able to create a company valuation model from scratch
Calculate a firm's enterprise and equity value using DCF
Learn how to become an effective and respected manager
Be able to recruit, select, onboard, train, develop, and retain talented employees
Provide employee feedback
Organize performance review meetings
Negotiate effectively
Apply negotiation tactics that will ensure your success in the long run

Course content

42 sections • 266 lectures

Welcome! Course introduction 1 lectures

What does the course cover? Preview 01:47

What does it mean to be a finance manager? 2 lectures

How we measure financial performance Preview 02:29

Improving performance measurement and collecting data Preview 04:15

The importance of Enterprise Resource Planning (ERP) systems 9 lectures

What is an ERP system? Preview 05:42

Strongest advantages of ERP systems Preview 02:48

Quiz ERP systems (1/2)

Difficulties when implementing an ERP system Preview 05:34

Best practices when implementing a new ERP system Preview 05:43

A finance manager's leadership is crucial when implementing a new system Preview 05:59

Case study: Hershey's Preview 04:27

Quiz ERP systems (2/2)

ERP Systems - Course Challenge #1

Describe how the implementation of an ERP system would impact each of the processes listed. Create a scheme that shows how an ERP system helps an electronic goods retailer company manage its informational flows. Post your answers in the course Q&A section to get personalized feedback from us.

Accounting Basics - Types of revenues, costs, assets, and liabilities 14 lectures

Introduction to the section Preview 01:14

The different types of accounting standards Preview 02:34

The three financial statements Preview 01:51

Types of revenues Preview 02:15

Types of revenues - exercise Preview 01:47

Types of expenses Preview 05:19

Income taxes Preview 01:45

Depreciation & Amortization Preview 04:27

Types of assets Preview 03:35

Asset categories - practical example Preview 03:47

Types of liabilities Preview 03:45

Liability categories - practical example Preview 02:30

Equity Preview 01:54

Accrual accounting Preview 01:32

Accounting Basics - Revenue recognition 4 lectures

The importance of timing when recognizing revenues Preview 05:10

Revenue recognition criteria - technical Preview 03:40

Potential conflicts of interest when recognizing revenue Preview 01:56

A practical example Preview 05:18

Accounting Basics - Cost recognition 4 lectures

Cost recognition principles Preview 03:01

Technical aspects of cost recognition Preview 02:34

The two types of Income Statement formats Preview 01:17

Basic Accounting - Course Challenge #2

An assignment, which evaluates whether you have learned the main principles of revenue and cost recognition. Do not forget to post your answers in the course Q&A section.

Advanced Accounting - Trade receivables 5 lectures

Introduction to the section Preview 00:58

The importance of Trade receivables Preview 02:33

What happens when clients do not pay on time? Preview 03:11

Case study - dealing with non-paying customers Preview 02:39

A technique to improve receivables collection Preview 01:47

Advanced Accounting - Inventory 4 lectures

Types of Inventory Preview 02:37

The relationship between Cogs and Inventory Preview 02:34

The different cost flow methods Preview 04:21

Cost flow methods - a practical exercise Preview 00:55

Advanced Accounting - Fixed assets 7 lectures

The types of fixed assets Preview 03:08

Capitalizing interest expenses Preview 02:00

Fair value accounting Preview 02:14

Intangible assets with finite life vs. Intangible assets with infinite life Preview 04:12

The revaluation model Preview 05:13

The revaluation model - practical exercise Preview 05:19

Intangible assets created internally Preview 02:16

Advanced Accounting - Trade payables 3 lectures

Accounting for trade payables Preview 02:51

Accounts payable vs notes payable Preview 01:26

The advantages of e-invoicing Preview 03:07

Advanced Accounting - Financial liabilities 4 lectures

Distinguishing between debt and equity Preview 02:24

Loan amortization Preview 03:04

Debt covenants Preview 03:23

Debt covenants - Case study Preview 01:48

Advanced Accounting - Leasing liabilities 3 lectures

Why companies lease assets? Preview 01:19

Leasing exercise Preview 07:07

Cost flow methods, Leasing, Revaluation - Course Challenge #3

An assignment, which evaluates whether you have learned the main principles cost flow methods, how to calculate leasing, and how to perform revaluation

Sources of financing - Debt financing 2 lectures

Why use leverage? Preview 04:23

The relationship between leverage and cost of debt Preview 03:17

Sources of financing - Equity financing 6 lectures

Types of equity Preview 04:13

Raising equity in different stages of a company's lifecycle Preview 05:55

What type of dividends are distributed to shareholders? Preview 03:38

Timing mechanics of dividend payments Preview 03:05

Share repurchases Preview 03:11

Stock splits Preview 03:04

Financial statement analysis 6 lectures

Introduction to financial statement analysis Preview 01:10

Performing financial statement analysis Preview 02:57

Ratio analysis Preview 06:59

Practical example: Analyzing P&G's financial report (1/2) Preview 06:55

Practical example: Analyzing P&G's financial report (2/2) Preview 04:43

Financial statement analysis of Tesla Inc. - Course Challenge #5

Calculate financial ratios and analyze Tesla Inc.'s financials in terms of liquidity, profitability, solvency, and growth.

Working capital management 12 lectures

Introduction Preview 03:50

The importance of working capital optimization: case study Preview 08:56

Overtrading vs. excessive investment Preview 03:30

Trade receivables management Preview 08:31

Re-order level Preview 03:20

Economic order quantity (EOQ) Preview 04:05

Inventory optimization techniques Preview 04:41

Trade payables management Preview 01:57

Working capital optimization - a roadmap Preview 05:07

Symptoms of inefficient working capital - Trade payables Preview 02:03

Symptoms of inefficient working capital - Trade receivables Preview 01:51

Working capital optimization - Course Challenge #5

An assignment, which reinforces what you have learned about working capital management

Capital budgeting - The theory behind capital budgeting 10 lectures

An introduction to capital budgeting Preview 01:14

Why companies need capital budgeting Preview 01:57

The time value of money in a capital budgeting exercise Preview 02:03

Working with present and future cash flows Preview 05:16

Calculating cost of debt and cost of equity Preview 05:56

An important subtlety - project-specific beta Preview 02:53

Completed 33% of the course Preview 00:31

Calculating WACC Preview 01:48

How to treat the value of residual assets at the end of the project Preview 02:57

Forecasting future cash flows Preview 05:16

Capital budgeting - A complete case study 13 lectures

An introduction to the case study Preview 02:22

Going through the 'Drivers' sheet Preview 04:57

Forecasting the savings that will be generated by the project Preview 03:22

Performing a fixed asset roll forward Preview 04:17

Forecasting working capital needs Preview 02:16

Modeling the project's financing Preview 02:39

Creating a P&L sheet Preview 01:35

Cash flow calculation Preview 02:56

Calculating the discount rate we will use - WACC Preview 04:25

Calculating cost of equity Preview 05:48

Discounting cash flows Preview 03:05

Performing sensitivity analysis Preview 04:37

Power plant capital budgeting - Course Challenge #6

In this course challenge, you will have to prepare a complete capital budgeting exercise. The financial model you will build will assess wether the investment in a power plant is feasible from a financial perspective.

Financial reporting in Excel - Introduction to Pivot tables 6 lectures

Introduction to Pivot tables Preview 01:27

Structuring a Pivot table Preview 03:47

Pivot table formatting Preview 02:14

Modifying a Pivot table's content Preview 04:33

Using GETPIVOTDATA Preview 03:45

Learn how to work with slicers Preview 04:20

Financial reporting in Excel - World-class reporting (Slicers and Pivot Table) 12 lectures

Introduction to the Case Study Preview 02:09

Understanding the source data Preview 03:23

Mapping of the source data Preview 02:10

Setting up a structure for the dashboard we'll create Preview 02:29

Working on the dashboard's layout Preview 03:59

Inserting calculation formulas Preview 02:30

Creating the source Pivot table Preview 01:55

Using GETPIVOTDATA to connect the Pivot table and the dashboard Preview 05:45

Adding slicers and making our dashboard interactive Preview 03:20

Improving the layout of the slicers we added Preview 03:12

How the dashboard can be used in practice Preview 03:59

Pivot table dashboards with slicers - Course Challenge #7

Create a dynamic pivot table dashboard using GETPIVOTDATA and Slicers. Do not forget to post your answers in the course Q&A section. You can send your solutoin files via Dropbox.

Creating effective presentations - Introduction 3 lectures

Introduction to creating effective presentations Preview 02:01

Types of corporate presentations Preview 03:58

What you will see next Preview 01:17

Creating effective presentations - Key principles 7 lectures

Principle #1 - Deliver maximum information in a limited space Preview 01:36

Principle #2 - Develop logical slide flow Preview 01:22

Principle #3 - Key messages start from the title Preview 03:07

Principle #4 - Tailor the presentation to the intended audience Preview 02:03

Completed 50% of the course Preview 00:38

Principle #5 - Keep text messages short Preview 01:24

Principle #6 - Use key words Preview 02:26

Creating effective presentations - Key principles 4 lectures

Principle #7 - A picture is worth a thousand words Preview 01:27

Principle #8 - Have the big picture in mind Preview 01:26

Principle #9 - Plan well ahead Preview 01:56

Principle #10 - Decide what information should be included in slides Preview 00:58

Creating effective presentations - Technical skills 3 lectures

Adding text boxes with instructions Preview 02:29

Populating slide content Preview 01:28

Formatting and polishing slides Preview 02:03

Creating effective presentations - The importance of consistency 5 lectures

Ensuring consistency across the entire presentation Preview 01:36

Consistent font and font size Preview 01:23

Aligning objects Preview 01:34

Working in a team Preview 01:53

Adding watermarks Preview 02:09

Creating effective presentations - Company profile 7 lectures

Introduction Preview 00:31

What is a company profile Preview 02:02

Content going in company profile slides Preview 03:45

Creating a company profile Preview 03:00

Key financials Preview 04:39

Company profiles - research Preview 01:27

One-page company profile layout Preview 01:12

Creating effective presentations - Share price slide 3 lectures

Why create share price slides? Preview 02:04

What content goes into a share price chart? Preview 03:36

Designing a share price chart Preview 02:33

Creating effective presentations - Other slides in a company presentation 7 lectures

Group structure Preview 06:07

The management team slide Preview 01:49

Waterfall charts Preview 08:16

Financial information overview Preview 07:47

Geographical presence Preview 02:10

KPI evolution overview Preview 02:46

Preparing a company presentation - Course Challenge #8

In this assignment, students will have to prepare a complete company presentation, like Nestle's presentation we discussed in multiple of our previous lessons.

Company valuation - The fundamentals you need to learn 9 lectures

The reason we want to value a business Preview 01:36

The investor perspective to company valuation Preview 03:12

The two variables determining a company's valuation Preview 01:57

Calculating Unlevered Cash Flow Preview 04:33

Weighted average cost of capital (WACC) - the discount factor we will use Preview 04:08

Forecasting the firm's future cash flows Preview 02:31

Two stages of valuation - explicit forecast period and terminal value Preview 02:24

Discounting cash flows Preview 01:44

Coming up with Enterprise and Equity value Preview 01:10

Company valuation - A practical exercise 32 lectures

Introduction to the case study Preview 01:02

How we build a complete DCF model Preview 06:15

The structure of the model we will build Preview 02:53

The company we are valuing Preview 01:09

Modeling revenues Preview 03:39

Using the CHOOSE function to create flexible financial models Preview 02:12

Modeling other items (1/3) Preview 03:46

Modeling other items (2/3) Preview 02:33

Modeling other items (3/3) Preview 02:28

Forecasting Balance sheet figures Preview 00:43

The "Days" technique Preview 01:35

Calculating "Days" Preview 01:30

Using "Days" to forecast trade receivables, inventory, and trade payables Preview 02:23

Forecasting PP&E, Other assets, and Other liabilities Preview 02:27

Creating an output P&L sheet Preview 02:36

Filling in the P&L sheet Preview 02:14

Adding an output Balance sheet Preview 01:49

Filling in the output Balance sheet Preview 03:41

Structuring unlevered cash flow Preview 03:05

Reconciling Unlevered cash flow and net cash flow Preview 01:55

Calculating cash flow Preview 06:01

Obtaining net cash flow figures Preview 03:56

Editing multiple cell references at the same time Preview 03:52

Adding WACC to the model Preview 01:56

Using WACC to obtain the present value of future cash flows Preview 02:50

Calculating Terminal value and Enterprise value Preview 02:17

Obtaining Equity value Preview 01:21

Performing sensitivity analysis for improved decision-making Preview 04:17

Applying Goal seek Preview 01:40

Recap of the model + charts we can build Preview 04:38

Company valuation Tesla Inc. - Course Challenge #9

In this exercise, we ask you to prepare a complete company valuation model for Tesla Inc. - the US automotive producer. Your task is to forecast the firm's revenues, costs, capex, working capital investments, cost of capital, and cash flows.