← Finance & Business

Fees by level

Start at any level, or take the complete programme. The fee you pay for a level is locked for you.

All fees are in Indian Rupees and include applicable taxes. See our pricing & payment terms.

The complete curriculum

01 Introduction to Financial Analytics 2 lessons ▶

1. 1.1Introduction video
2. 1.2Course outline

02 Excel Basics 4 lessons ▶

1. 2.1Basics 1
2. 2.2Excel formulas and functions
3. 2.3excel shortcuts 1
4. 2.4Excel shortcuts 2

03 Make your Excel look professional 5 lessons ▶

1. 3.1Optimisation
2. 3.2Macros
3. 3.3abs and rel ref
4. 3.4Named Ranges
5. 3.5DV and custom F

04 Excel Be a Pro 8 lessons ▶

1. 4.1find and replace, CF
2. 4.2IF ELSE
3. 4.3Countif, Average If, MaxIF, Sum IF
4. 4.4Error handling
5. 4.5Vlookup Hlookup
6. 4.6Xlookup
7. 4.7Index and match function
8. 4.8String Functions

05 Financial Functions 2 lessons ▶

1. 5.1What IF Analysis
2. 5.2PMT and Date function

06 Introduction to Basic Accounting 5 lessons ▶

1. 6.1What is accounting, why do we need accounting
2. 6.2Accounting equation
3. 6.3Book keeping
4. 6.4Rules of Accounting
5. 6.5Financial Accounting

07 Financial Statements 3 lessons ▶

1. 7.1FS Income Statement
2. 7.2FS Balance Sheet
3. 7.3FS Cash Flow Statement

08 Learn to make your own Financial statements FROM SCRATCH! 3 lessons ▶

1. 8.1P&L from scratch
2. 8.2Balance Sheet from scratch
3. 8.3Cash Flow Statement from scratch

09 Charts in MS EXCEL 4 lessons ▶

1. 9.1Introduction to charts and column chart
2. 9.2Bar chart, line chart
3. 9.3Pivot tables
4. 9.4Slicers and Timelines

10 3 Statement model 12 lessons ▶

1. 10.13 statement model(theory)
2. 10.2Fixed Asset Roll Forward
3. 10.3Equity Schedule
4. 10.4Liabilities Schedule
5. 10.53SM IS
6. 10.63SM BS
7. 10.73SM CFS
8. 10.8Ratio Analysis( theory)
9. 10.9Ratio Analysis Part 1
10. 10.10Ratio Analysis part 2
11. 10.11Forecasting Part 1
12. 10.12Forecasting part2

11 DCF Modelling 7 lessons ▶

1. 11.1DCF Theory
2. 11.2WACC
3. 11.3Beta (L and UL)
4. 11.4DCF Model
5. 11.5Comp Analysis 1
6. 11.6COMP Analysis 2
7. 11.7Other Financial Models

12 Revenue and Cost Recognition 6 lessons ▶

1. 12.1Cash vs Accrual
2. 12.2Revenue recognmition
3. 12.3Revenue Recognition importance and examples
4. 12.4Challenges in rev recognition
5. 12.5Cost recognition
6. 12.6Cost recognition example

13 Advanced Accounting 6 lessons ▶

1. 13.1Trade Recievables
2. 13.2Trade Payables
3. 13.3Inventory
4. 13.4fixed assets
5. 13.5liabilites
6. 13.6leverage

14 Equity Everything you need to know 7 lessons ▶

1. 14.1equity
2. 14.2types of equity
3. 14.3raising equity
4. 14.4dividend
5. 14.5shareholders
6. 14.6basic terms
7. 14.7stock splits

15 Capital Budgeting Techniques 6 lessons ▶

1. 15.1cap budget tech
2. 15.2time value of money
3. 15.3NPV
4. 15.4IRR
5. 15.5PBP and DPBP
6. 15.6PI and final Example

16 Working Capital Management 2 lessons ▶

1. 16.1working cap mgmt
2. 16.2WCM Part 2

17 Business Analysis 13 lessons ▶

1. 17.1Business analysis
2. 17.2Time Series Analysis theory
3. 17.3Time series data excel
4. 17.4Correlation analysis theory
5. 17.5Correlation Analysis Excel
6. 17.6Trend Analysis theory
7. 17.7Trend Analysis Excel
8. 17.8regression analysis theroy
9. 17.9Regression analysis excel
10. 17.10Comparative analysis theory
11. 17.11Comparative analysis excel
12. 17.12Value based analysis theory
13. 17.13Value based analysis excel

18 How to Analyse Financial Statements 4 lessons ▶

1. 18.1how to analyse fin statements
2. 18.2Tools in FS analysis
3. 18.3Common Size Statements
4. 18.4Understanding Annual Reports

19 Your First Capstone Project 11 lessons ▶

1. 19.1Downloading the info HUL
2. 19.2Analysis Report HUL
3. 19.3Analysis report HUL 2
4. 19.4Historical FS HUL
5. 19.5Forecasting HUL
6. 19.6Ratio Analysis HUL 1
7. 19.7Ratio Analysis HUL 2
8. 19.8DCF Model HUL
9. 19.9Trend Analysis HUL
10. 19.10COMP Analysis HUL
11. 19.11Common Size Statement

20 Tips and Tricks for the future 1 lesson ▶

1. 20.1Tips and Tricks

21 What to do now? 1 lesson ▶

1. 21.1What to do now

Tools you'll use

Related courses