Flat 80% off + Extra 10% Cart Discount
🚀 FREE AI WORKSHOP! 🚀
Join us this weekend and unlock the power of AI to stay ahead in your career!
"One person using AI will replace 100 professionals not using AI" – Are you ready?
Reserve Your Spot Now!Financial Modelling & Valuations
Financial models are important tools for all business decisions. When you're looking to raise finance, buy or sell a business, assess strategic options, or simply plan for the future, you are going to need a forecast.
Click to view Trailer
Jobaaj Learnings
Course description
Financial models are important tools for all business decisions. When you're looking to raise finance, buy or sell a business, assess strategic options, or simply plan for the future, you are going to need a forecast. This is likely to come from a financial model. Finance professionals usually need to work with large volumes of numerical data. However, the key to successfully handle such data is the ability to organize and structure it meaningfully to render them useful to senior management for decision making. This entails the creation of robust and dynamic financial models facilitating accurate and efficient analysis of historical data and appropriate projection of financial performance.
Jobaaj Learnings offers a comprehensive programme to upskill participants on financial modelling and valuation techniques. This programme will help you to create financial models, use such models for funding proposals, credit rating or business valuation and take decisions by analyzing such models.
Prerequisite
-
No prerequisites
Lesson List
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
Project Finance Model
Financial Modelling Process
01:02:54
Project Finance Management - PDF
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
6
Building a Financial Model
Resources - DCF Models
Creating the model structure
00:08:23
Getting the inputs
00:20:33
Income Statement
00:20:20
Balance Sheet
00:25:08
Cash Flow Statement
00:17:00
Supporting Schedules
00:09:35
Ratios & Assumptions
00:14:16
Revenue Scenarios
00:22:26
Forecasting
00:19:46
Comps Valuation
00:24:08
Market Returns
00:06:38
Calculation of WACC
00:16:48
Calculation of Beta
00:08:45
DCF Analysis
00:24:57
Sensitivity Analysis
00:09:22
Football Field Chart
00:13:17
7
DCF & Comparable Models (Old Videos - Optional)
DCF Model Part – I
01:31:30
DCF Model Part – II
01:00:30
DCF Model Part – III
00:53:59
Comparables Valuation Model – I
00:36:58
Comparables Valuation Model – II
00:26:48
Introduction to Financial Modelling & Valuation
Learning Resources (Presentations & Worksheets)
Introduction to Financial Modelling & Valuation
00:32:22Ms 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:33Corporate 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:39Financial 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:06Project Finance Model
Financial Modelling Process
01:02:54Project Finance Management - PDF
Project Finance Model Part - I
00:29:50Project Finance Model Part - II
01:43:00Project Finance Model Part - III
01:36:46Project Finance Model Part - IV
01:23:53Building a Financial Model
Resources - DCF Models
Creating the model structure
00:08:23Getting the inputs
00:20:33Income Statement
00:20:20Balance Sheet
00:25:08Cash Flow Statement
00:17:00Supporting Schedules
00:09:35Ratios & Assumptions
00:14:16Revenue Scenarios
00:22:26Forecasting
00:19:46Comps Valuation
00:24:08Market Returns
00:06:38Calculation of WACC
00:16:48Calculation of Beta
00:08:45DCF Analysis
00:24:57Sensitivity Analysis
00:09:22Football Field Chart
00:13:17DCF & Comparable Models (Old Videos - Optional)
DCF Model Part – I
01:31:30DCF Model Part – II
01:00:30DCF Model Part – III
00:53:59Comparables Valuation Model – I
00:36:58Comparables Valuation Model – II
00:26:48" Hear what our students have to say "
I’ve learned a lot so far, and financial statements are much more fun to use than I thought they w Read More
Aqeel
Excellent Course! Highly recommended for those looking to learn Excel and Financial Modeling in a co Read More
Divyansh Choudhary
More courses like this
Python for Finance – Financial Analysis
By Jobaaj Learnings
₹6,999/-₹13,999/-
Python for Finance - Technical Analysis
By Jobaaj Learnings
₹6,999/-₹13,999/-
