Explore
refer Refer Now Login / Signup
Finance

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
(83 reviews)
44 Hours 49 Mins
₹9,999/-₹17,999/-
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

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

" 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

Image

Python Bootcamp

By Jobaaj Learnings

(19 reviews)

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

3,320 Enrolled Students
12 Hours 41 Mins
  13 Lectures

All trademarks are the property of their respective owners

All rights reserved @ 2026 Nishtya Infotech (India) Ltd.

Having an Issue!!

Please tells us more about it!

Help