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
(11 reviews)
16 Hours 1 Mins
Join the course
Created by
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

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
Learn from the best

Jobaaj 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

Anurag Singh

More courses like this

Python Bootcamp

By Jobaaj Learnings

₹4,999/-₹9,999/-


Top