90% off on Premium Membership - Mega Sale
Financial Modelling & Valuations
Created by: ProCapitas
This course includes:
- Analyzing backtesting reports.
- Costs of trading - Slippages and Brokerage.
- How to build trading psychology.
- Problems with manual backtesting.
LESSONS
Lessons | 16 Hours
1
Introduction to Financial Modelling & Valuation
Learning Resources (Presentations & Worksheets)
Introduction to Financial Modelling & Valuation
00:32:222
Ms Excel : Basic To Advance
Excel Interface, Basic shortcuts, Navigation keys, Manipulating worksheets & Modifying rows/columns/cells
01:50:48Entering data, Name Manager, Go To, Trace Precedents & Dependents, Quick Access Shortcuts
00:56:47Fomatting Tools
00:54:39Custom Cell Formats, Paste Special, Transpose, Hyperlink
00:56:25Sorting & Filtering, Table & its Features, Importing data, Grouping & Hiding, Data Validation
01:10:57Printing setup, Text-to-columns, Math Functions, SUMPRODUCT, Date functions
01:22:44Text functions, Flash Fill, Consolidate
01:32:10Conditional Formatting, IF Functions/AND/OR
00:58:36CHOOSE, SUBTOTAL
00:36:50Pivot Table
00:35:37HLOOKUP, INDEX, MATCH, OFFSET
00:53:07VLOOKUP, DGET
00:50:18Goal Seek, Data Table, Scenario Manager
00:54:46FORECAST, TREND, GROWTH, Wild Card Characters, Error Types, Error Checks
01:09:56VBA & Macros, Solver
01:31:57Interactive Charts
00:43:333
Corporate Finance
Time Value of Money Part - I
01:36:12Time Value of Money Part - 2
01:14:54Capital Budgeting Part- I
00:54:16Capital Budgeting Part- II
00:22:46Cost of Capital
00:49:42Equity Valuation Part- I
00:55:52Equity Valuation Part- II
01:14:394
Financial Statement Analysis
Financial Statements : Basics
00:45:45Cash Flow Statement + Other Concepts
01:09:54Depreciation Methods + Working Capital
01:26:43Working Capital + DuPont Analysis
00:53:09Ratio Analysis + Common Sizing
00:46:065