Free Online Course on Financial and Valuation Model (code, conversion)

[JL]

It is normally $199, but free with coupon code TINTIN

https://www.udemy.com/financial-and-valuation-modeling/

Received this in email today. The email says "As a token of appreciation to our OLD students, we give this course worth $199 for FREE. Please use coupon "TINTIN" and enjoy the course. For limited number of coupons, students looking for a career in Investment Banking, PE Firms, Hedge Funds etc. should only enroll. Please do not waste coupons".

This course seems to have a lot of Excel work in it, so if you are interested in learning a lot of Excel stuff, then this course might be valuable to you.

The deal is for limited period (I do not know when it will expire, but the other courses they gave away for free only lasted a couple of days before the coupon codes expired). So, sign up now and take the course whenever you want. Once you sign up, you have unlimited access to the course.


SECTION 1 Introduction
Lecture 1:

Introduction
 05:22

SECTION 2 EXCEL: Excel Basics for Financial Modeling

Lecture 2:
EXCEL Excel Basics for Financial Modeling
Text

Lecture 3:
XYZ Company Basic Excel Case Study
1 page

Lecture 4:
Excel Case Study
 02:00

Quiz 1:
Quiz - Excel Case Study
2 questions

Lecture 5:
Data Entry in Excel
 08:56

Quiz 2:
Quiz - Data Entry In Excel
3 questions

Lecture 6:
Populating the Case Study in Excel
 07:42

Quiz 3:
Populating The Case Study In Excel
1 question

Lecture 7:
Calculations Addition Subtract Multiply Division
 07:29

Quiz 4:
Quiz - Calculations Addition Subtract Multiply Division
2 questions

Lecture 8:
Formulas SUM MAX MIN AVERAGE
 09:58

Quiz 5:
Quiz - Formulas SUM MAX MIN AVERAGE
3 questions

Lecture 9:
Formatting Number Formats
 08:30

Quiz 6:
Quiz - Formatting Number Formats
3 questions

Lecture 10:
Formatting Table Formats
 07:37

Quiz 7:
Quiz - Formatting Table Formats
2 questions

Lecture 11:
Updating a Calculation
 02:41

Quiz 8:
Quiz - Updating A Calculation
2 questions

Lecture 12:
Percentages and Absolute References
 09:19

Quiz 9:
Quiz - Percentages And Absolute References
1 question

Lecture 13:
IF Function
 09:58

Quiz 10:
Quiz - IF Function
1 question

Lecture 14:
COUNT IF Function
 04:18

Quiz 11:
Quiz - COUNTIF And SUMIF 13 Part 1
2 questions

Lecture 15:
SUM IF Function
 08:22

Quiz 12:
Quiz - Quiz - COUNTIF And SUMIF 13 Part 2
2 questions

Lecture 16:
Freeze and Split
 06:21

Quiz 13:
Quiz - Freeze And Split
Upcoming

SECTION 3 EXCEL: Important Excel Functions for Financial Modeling

Lecture 17:
EXCEL Important Excel Functions for Financial Modeling
Text

Lecture 18:
Logical functions AND OR IF
 05:21

Quiz 14:
Quiz - Logical functions AND OR IF
2 questions

Lecture 19:
Arithmetic functions MAX MIN ABS etc
4 pages

Lecture 20:
Arithmetic functions MAX MIN ABS etc
 08:28

Quiz 15:
Quiz - ABS LARGE MAX MIN SMALL
2 questions

Lecture 21:
COUNT COUNTIF COUNTA COUNTBLANK
3 pages

Lecture 22:
COUNT COUNTIF COUNTA COUNTBLANK
 05:57

Quiz 16:
Quiz - Count Countif Count A Countblank
2 questions

Lecture 23:
Cell Information ISERROR ISBLANK etc
 08:42

Quiz 17:
Quiz - Cell Information
1 question

Lecture 24:
PROPER UPPER LOWER LEFT RIGHT MID
 05:23

Quiz 18:
Quiz - PROPER UPPER LOWER LEFT RIGHT MID
1 question

Lecture 25:
FIND CLEAN REPT CONCATENATE
 09:12

Quiz 19:
Quz - FIND CLEAN REPT CONCATENATE
1 question

Lecture 26:
Array Function Introduction
 05:56

Quiz 20:
Quiz - Array Function Introduction
1 question

Lecture 27:
Array Function Row and Columns
 03:40

Quiz 21:
Quiz - Array Function Row And Columns
1 question

Lecture 28:
Array Function TRANSPOSE
 10:15

Quiz 22:
Quiz - Array Function TRANSPOSE
1 question

Lecture 29:
Array Function FREQUENCY
 07:47

Quiz 23:
Quiz - Array Function FREQUENCY
1 question

SECTION 4 EXCEL: Useful Excel Tools for Financial Modeling

Lecture 30:
EXCEL: Useful Excel Tools for Financial Modeling
Text

Lecture 31:
Paste Special
 02:08

Quiz 24:
Quiz - Paste Special
1 question

Lecture 32:
Grouping Tabs
 06:56

Quiz 25:
Quiz - Grouping Tabs
1 question

Lecture 33:
Hyperlinks
 04:30

Quiz 26:
Quiz - Hyperlinks
2 questions

Lecture 34:
Data Validation
 07:27

Quiz 27:
Quiz - Data Validation
1 question

Lecture 35:
Protecting Worksheet and Workbook
 08:13

Quiz 28:
Quiz - Protecting Worksheet And Workbook
3 questions

Lecture 36:
Group Boxes and Options Button
 05:08

Quiz 29:
Quiz - Group Boxes And Options Button
1 question

Lecture 37:
Check Boxes
 03:06

Quiz 30:
Quiz - Check Boxes
2 questions

Lecture 38:
List Boxes and Combo Boxes
 04:10

Quiz 31:
Quiz - List Boxes And Combo Boxes
2 questions

Lecture 39:
Scroll Bar and Spinners
 02:56

Quiz 32:
Quiz - Scroll Bar And Spinners
1 question

Lecture 40:
Auditing Toolbar
 07:58

Quiz 33:
Quiz - Auditing Toolbar
2 questions

Lecture 41:
Watch Window
 05:01

Quiz 34:
Quiz - Watch Window
1 question

Lecture 42:
Naming a Cell and a Range
 04:57

Quiz 35:
Quiz - Naming A Cell And A Range
1 question

Lecture 43:
Naming Dynamic Ranges
 05:25

Quiz 36:
Quiz - Naming Dynamic Ranges
1 question

SECTION 5 EXCEL: Scenario Analysis in Financial Modeling

Lecture 44:
EXCEL Scenario Analysis in Financial Modeling
Text

Lecture 45:
One Dimensional Data Tables
2 pages

Lecture 46:
One Dimensional Data Tables
 05:42

Quiz 37:
Quiz - One Dimensional Data Tables
3 questions

Lecture 47:
Two dimensional Data Tables
 03:39

Quiz 38:
Quiz - Two dimensional Data Tables
1 question

Lecture 48:
Solver
 06:17

Quiz 39:
Quiz - Solver
3 questions

Lecture 49:
Goal Seek
2 pages

Lecture 50:
Goal Seek
 06:03

Quiz 40:
Quiz - Goal Seek
1 question

SECTION 6 EXCEL: Advanced Charts

Lecture 51:
EXCEL Advanced Charts
Text

Lecture 52:
Excel 2010 Sparklines
 08:16

Quiz 41:
Quiz - Excel 2010 Sparklines
1 question

Lecture 53:
Range Charts Type 1 Part a
 04:42

Quiz 42:
Quiz - Range Charts Type 1 Part a
1 question

Lecture 54:
Range Charts Type 1 Part b
 04:32

Quiz 43:
Quiz - Range Charts Type 1 Part b
1 question

Lecture 55:
Range Charts Area Type 2 Part a
 04:42

Quiz 44:
Quiz - Range Charts Area Type 2 Part a
1 question

Lecture 56:
Range Charts Area Type 2 Part b
 04:34

Quiz 45:
Quiz - Range Charts Area Type 2 Part b
1 question

Lecture 57:
Funding Graph
1 page

Lecture 58:
Funding Graph
 04:18

Quiz 46:
Quiz - Funding Graph
1 question

Lecture 59:
Two Axis Graphs
1 page

Lecture 60:
Two Axis Graphs
 06:30

Quiz 47:
Quiz - Two Axis Graphs
1 question

SECTION 7 FM: Financial Modeling Introduction

Lecture 61:
Excel Template section 7 To 19
Text

Lecture 62:
What is Financial Modeling
 08:11

Lecture 63:
Snapshot of Financial Model
 03:30

SECTION 8 FM: Assumptions in Financial Modeling

Lecture 64:
Looking at the Assumptions
 01:52

Lecture 65:
Formatting a Financial Model
 08:11

SECTION 9 FM: Historical Ratio Analysis

Lecture 66:
Calculating the Historical Ratios
 04:21

SECTION 10 FM: Projecting the Income Statement

Lecture 67:
Projecting Income Statement - Revenues
 06:48

Lecture 68:
Projecting Income Statement - Costs
 05:32

SECTION 11 FM: Projecting Working Capital

Lecture 69:
Calculating the Turnover Ratios
 09:15

Lecture 70:
Forecasting the Working Capital
 06:47

Lecture 71:
Working Capital Flow Diagram
 03:44

SECTION 12 FM: Depreciation Schedule

Lecture 72:
BASE Equation & Projecting Capital Expenditure
 09:23

Lecture 73:
Projecting Depreciation - Part 1
 09:07

Lecture 74:
Projecting Depreciation - Part 2
 09:23

Lecture 75:
Depreciation Schedule Flow Diagram
 03:15

SECTION 13 FM: Amortization Schedule

Lecture 76:
BASE Equation & Projecting Intangibles
 04:58

Lecture 77:
Projecting Amortization
 08:07

Lecture 78:
Amortization Schedule Flow Diagram
 03:07

SECTION 14 FM: Other Long Term Schedule

Lecture 79:
Projecting Other Long Term Items
 02:55

Lecture 80:
Other Long Term Schedule Flow Diagram
 05:29

SECTION 15 FM: Shareholders Equity Schedule

Lecture 81:
BASE Equation & Shareholders Equity I
 06:04

Lecture 82:
BASE Equation & Shareholders Equity II
 09:52

Lecture 83:
Projecting Share-Repurchase/Buy Back and effect of Stock Options
 01:39

Lecture 84:
Shareholders Equity Schedule Flow Diagram
 00:33

SECTION 16 FM: Shareholders Outstanding Schedule

Lecture 85:
Projecting Outstanding Shares
 05:56

SECTION 17 FM: Cash Flow Statements

Lecture 86:
Completing the Cash Flow Statements
 04:55

SECTION 18 FM: Setting up the Debt Schedule

Lecture 87:
Projecting Debt - Short term and Long
 09:46

Lecture 88:
Concept of Cash Sweep Revolver & Ending
 03:32

Lecture 89:
Debt Schedule Flow Diagram
 00:42

SECTION 19 FM: Important - Circular Reference

Lecture 90:
Important - Understanding the Circular Reference in Detail
 01:05

SECTION 20 FM CASE STUDY: Asian Paints - Gearing for the Financial Model

Lecture 91:
Excel Template section 20 to 24
Text

Lecture 92:
Preparing the Infrastructure of Asian Paints
 03:44

Lecture 93:
Populating FY2010 Income Statement
 06:51

Lecture 94:
Populating EPS and Unit Conversions
 03:34

Lecture 95:
Populating FY2010 Balance Sheet
 03:41

Lecture 96:
Populating FY2010 Balance Sheet - Contd
 03:41

Lecture 97:
FY 2010 BS Change of Units & Error Rectification
 02:50

Lecture 98:
Populating FY 2010 Cash Flow
 03:07

Lecture 99:
Populating FY 2010 Cash Flow - Contd
 04:52

SECTION 21 FM CASE STUDY: Asian Paints - Ratio Analysis

Lecture 100:
Income Statement - Ratio Analysis
 07:38

Lecture 101:
BS - Calculation of Solvency Ratios
 04:15

Lecture 102:
BS - Working Capital - Receivables & Inventory Turnover
 04:06

Lecture 103:
BS - Working Capital - Payables Turnover
 06:46

Lecture 104:
BS - Cash Conversion Cycle
 04:36

Lecture 105:
IS / BS - Calculation of Operating Efficiencies
 05:53

Lecture 106:
IS / BS - Dupont Analysis
 04:45

Lecture 107:
IS / BS - Financial Risk Ratios
 02:44

SECTION 22 FM CASE STUDY: Asian Paints - Projections - Income Statement FY2011E-2015E

Lecture 108:
IS Projections - Sales & Material Costs
 06:03

Lecture 109:
IS Projections - Employee Cost
 01:36

Lecture 110:
IS Projections - PAT
 03:13

Lecture 111:
IS Projections - EBITDA & PBT
 06:57

Lecture 112:
Minority Interest Calculation
 01:29

Lecture 113:
Dividends Forecasts
 04:09

Lecture 114:
Completing the Income Statement Projections
 02:22

SECTION 23 FM CASE STUDY: Asian Paints - Projections - Balance Sheet - FY2011E-2015E

Lecture 115:
BS Projections - Shareholders Equity
 03:34

Lecture 116:
BS Projections - Minority Interest
 00:39

Lecture 117:
BS Projections Deferred Tax Liability and Goodwill
 02:45

Lecture 118:
BS Projections - Working Capital Projections
 03:30

Lecture 119:
BS Projections - Working Capital Projections - Contd
 04:11

Lecture 120:
Provision for Dividends
 03:04

Lecture 121:
Depreciation Schedule
 08:06

Lecture 122:
Forecasting Debt
 07:42

SECTION 24 FM CASE STUDY: Asian Paints - Projections - Cash Flow - FY2011E-2015E

Lecture 123:
Cash Flow Projections - Operating Activities
 08:50

Lecture 124:
Cash Flow Projections - Financing Activities
 01:44

Lecture 125:
Cash Flow Projections - Financing Activities and Reconciliation
 05:12

SECTION 25 CORPORATE VALUATION: Dividend Discount Model (DDM)

Lecture 126:
Dividend Discount Model DDM
Text

Lecture 127:
Dividend discount model DDM Example 1
 05:42

Lecture 128:
Dividend discount model DDM Example 2
 06:31

Lecture 129:
Dividend discount model DDM Example 3
 05:04

Lecture 130:
Dividend discount model DDM Example 4
 04:02

Lecture 131:
Dividend discount model DDM Example 5
 08:12

SECTION 26 CORPORATE VALUATION: DCF

Lecture 132:
Introduction to DCF
Text

Lecture 133:
Introduction to DCF
5 pages

Lecture 134:
Introduction to DCF
 04:53

SECTION 27 CORPORATE VALUATION: DCF - FCFF

Lecture 135:
Forecasting Free Cash Flow to Firm FCFF
Text

Lecture 136:
Forecasting Income Statement EBITDA
 06:26

Lecture 137:
Understanding the Working Capital
 02:30

Lecture 138:
Completing the Working Capital Calculations
 02:42

Lecture 139:
Linking the Free Cash Flow to Firm FCFF
 07:06

Lecture 140:
Discounting the Explicit Period Cash Flows
 05:12

Lecture 141:
Detailed view on Calculating FCFF
4 pages

Lecture 142:
Calculation of Terminal Values
 06:49

Lecture 143:
Terminal Value Perpetuity Growth and Exit Multiple Method
4 pages

Lecture 144:
DCF Valuation Summary
 06:11

Lecture 145:
DCF Sensitivity Analysis
 07:18

SECTION 28 CORPORATE VALUATION: DCF - Understanding Capital Structure

Lecture 146:
Understanding the Capital Structure
Text

Lecture 147:
Understanding the Capital Structure
7 pages

Lecture 148:
Options Treasury Stock Method
 06:18

Lecture 149:
Options Explained Part 2
 02:03

Lecture 150:
Calculation of inthemoney Convertibles
 04:22

Lecture 151:
Calculation of inthemoney Stock Options
 05:11

Lecture 152:
Calculation of Debt Equity Ratio
 04:06

SECTION 29 CORPORATE VALUATION: DCF: WACC CAPM Terminal Value TV

Lecture 153:
WACC CAPM Terminal Value TV
Text

Lecture 154:
Cost of Debt Calculations
 04:05

Lecture 155:
Cost of Debt Calculations
2 pages

Lecture 156:
Cost of Equity Calculation
 07:32

Lecture 157:
Weighted Average Cost of Capital WACC
1 page

SECTION 30 CORPORATE VALUATION: DCF: Calculating Enterprise Value EV

Lecture 158:
Enterprise Value Calculation Completing the Missing Links 03:27
SECTION 31 Conclusion

Lecture 159: CONCLUSION

[bobrainman]

Thanks!