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