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 TrailerJobaaj 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
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
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:06Construction of Financial Models
Financial Modelling Process
01:02:54Project 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:53DCF Model Part - I
01:31:29DCF Model Part - II
01:00:25DCF Model Part - III
00:53:59Comparables Valuation Model – I
00:36:58Jobaaj Learnings
Jobaaj Learnings offer the best in class industry-focused programs to students.
Our trainers have several years of experience in the respective field and work with leading companies.
We are the pioneer of a personalised micro-learning education model in India.
Why micro-learning?
A rise in digital devices, fast internet, and a rapidly changing environment has made micro-learning the demand of an hour.
We consider it the most effective method of consuming learning content & are on a mission of making professionals habitual of upskilling by stealing little time daily from their busy lifestyle.
The course is ultimate...I never thought that I can get something as valuable as this course for an Read More
Yogendra Pal
It is really a good course as it covers everything, although sometimes it does not explain few conce Read More
Arvind Gupta
It is an excellent course! It is very well explained, with lots of business case studies, which as a Read More
Aditya Parmar
It's a great course to learn how to use excel, no matter your current level. Highly recommend it for Read More
Ayushi Sharma
This course was really good to teach you basics from a Beginner level, however as someone who is adv Read More
Priyanka Sharma
That's really great course to learn financial modeling and valuation. The teacher has a strong backg Read More
Anubhav Singh
I'm not a commerce student so this course is average for me but the course helps me to learn more ab Read More
Tusshar Tyagi
The course has helped me in my application and offered a deeper understanding of concepts learned in Read More
Deepesh Tyagi
Well, it's a good course to learn excel and Financial Modelling using excel... Please also add Monte Read More
Priti Tiwari
This is a very useful course to work smart at our workplace with our limited time. This is a course Read More
Manish Dixit
Very detailed, in-depth explanation on financial modelling and valuation. A must-take course if one Read More
