Click me to watch video!

Financial Modelling & Valuations

This course includes:

  • Analyzing backtesting reports.
  • Costs of trading - Slippages and Brokerage.
  • How to build trading psychology.
  • Problems with manual backtesting.
Join the course

LESSONS

Lessons | 16 Hours

0

LESSON 1

Trailer
1

Introduction to Financial Modelling & Valuation

Learning Resources (Presentations & Worksheets)
Introduction to Financial Modelling & Valuation
00:32:22
2

Ms Excel : Basic To Advance

Excel Interface, Basic shortcuts, Navigation keys, Manipulating worksheets & Modifying rows/columns/cells
01:50:48
Entering data, Name Manager, Go To, Trace Precedents & Dependents, Quick Access Shortcuts
00:56:47
Fomatting Tools
00:54:39
Custom Cell Formats, Paste Special, Transpose, Hyperlink
00:56:25
Sorting & Filtering, Table & its Features, Importing data, Grouping & Hiding, Data Validation
01:10:57
Printing setup, Text-to-columns, Math Functions, SUMPRODUCT, Date functions
01:22:44
Text functions, Flash Fill, Consolidate
01:32:10
Conditional Formatting, IF Functions/AND/OR
00:58:36
CHOOSE, SUBTOTAL
00:36:50
Pivot Table
00:35:37
HLOOKUP, INDEX, MATCH, OFFSET
00:53:07
VLOOKUP, DGET
00:50:18
Goal Seek, Data Table, Scenario Manager
00:54:46
FORECAST, TREND, GROWTH, Wild Card Characters, Error Types, Error Checks
01:09:56
VBA & Macros, Solver
01:31:57
Interactive Charts
00:43:33
3

Corporate Finance

Time Value of Money Part - I
01:36:12
Time Value of Money Part - 2
01:14:54
Capital Budgeting Part- I
00:54:16
Capital Budgeting Part- II
00:22:46
Cost of Capital
00:49:42
Equity Valuation Part- I
00:55:52
Equity Valuation Part- II
01:14:39
4

Financial Statement Analysis

Financial Statements : Basics
00:45:45
Cash Flow Statement + Other Concepts
01:09:54
Depreciation Methods + Working Capital
01:26:43
Working Capital + DuPont Analysis
00:53:09
Ratio Analysis + Common Sizing
00:46:06
5

Construction of Financial Models

Financial Modelling Process
01:02:54
Project Finance Model Part - I
00:29:50
Project Finance Model Part - II
01:43:00
Project Finance Model Part - III
01:36:46
Project Finance Model Part - IV
01:23:53
DCF Model Part - I
01:31:29
DCF Model Part - II
01:00:25
DCF Model Part - III
00:53:59
Comparables Valuation Model – I
00:36:58

The course is ultimate...I never thought that I can get something as valuable as this course for an   Read More

Rishabh Jain

It is really a good course as it covers everything, although sometimes it does not explain few conce   Read More

Ayasha Beg

It is an excellent course! It is very well explained, with lots of business case studies, which as a   Read More

Venkatesh Muppidi

It's a great course to learn how to use excel, no matter your current level. Highly recommend it for   Read More

siddhant jain

This course was really good to teach you basics from a Beginner level, however as someone who is adv   Read More

Nikhil Agarwal

That's really great course to learn financial modeling and valuation. The teacher has a strong backg   Read More

SAMRIDHI KANWAR

The course has helped me in my application and offered a deeper understanding of concepts learned in   Read More

chahat

Very detailed, in-depth explanation on financial modelling and valuation. A must-take course if one   Read More

Harshad Jain

Help?

Our Brands by Nishtya Infotech Private Limited:

Top