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.

Advanced 5(11 Ratings) 132 Students enrolled English-hindi
Created by Jobaaj Learnings
Last updated Wed, 08-Sep-2021
+ View more
Course overview

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.

What will i learn?

Requirements
  • No prerequisites
Curriculum for this course
39 Lessons 40:00:44 Hours
Introduction to Financial Modelling & Valuation
2 Lessons 00:32:22 Hours
  • Learning Resources (Presentations & Worksheets)
    .
  • Introduction to Financial Modelling & Valuation
    Preview 00:32:22
Ms Excel : Basic To Advance
16 Lessons 16:59:10 Hours
  • 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
Corporate Finance
7 Lessons 07:08:21 Hours
  • 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
Financial Statement Analysis
5 Lessons 05:01:37 Hours
  • 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
Construction of Financial Models
9 Lessons 10:19:14 Hours
  • 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
+ View more
Other related courses
12:28:30 Hours
Python for Finance Bootcamp
Updated Thu, 06-Jan-2022
5 76 ₹9999 ₹4999
10:07:38 Hours
The Complete Investment Banking Program
Updated Wed, 18-May-2022
5 126 ₹50000
03:26:27 Hours
Python for Finance Nanodegree
Updated Wed, 18-May-2022
5 46 ₹25000 ₹21000
About instructor

Jobaaj Learnings

Pioneer of personalised micro-learning model of education in India.

200 Reviews | 2646 Students | 48 Courses
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 companie...
Student feedback
5
11 Reviews
  • (0)
  • (0)
  • (0)
  • (3)
  • (8)

Reviews

  • Anurag Singh
    Very detailed, in-depth explanation on financial modelling and valuation. A must-take course if one has to learn for finance people who have the drive to learn financial modelling and valuation. Covered all important topics along with great mastery of MS Excel. Highly satisfied. Thanks a ton for the course, hands down the best course on the topic arguably! Brilliant teaching, Kuldeep Sir!
  • Manish Dixit
    This is a very useful course to work smart at our workplace with our limited time. This is a course which contains more practical examples so we can learn them more easily.
  • Priti Tiwari
    Well, it's a good course to learn excel and Financial Modelling using excel... Please also add Monte Carlo simulation analysis.
  • Deepesh Tyagi
    The course has helped me in my application and offered a deeper understanding of concepts learned in finance. Very well structured and instructed.
  • Tusshar Tyagi
    I'm not a commerce student so this course is average for me but the course helps me to learn more about excel before that I don't know anything about excel. This course helps me to know some functions that can be used in excel. Thank you
  • Anubhav Singh
    That's really great course to learn financial modeling and valuation. The teacher has a strong background and capability and I'm very happy with it. Because it's the first time, I'm empowering myself every day!
  • Priyanka Sharma
    This course was really good to teach you basics from a Beginner level, however as someone who is advanced in Excel and was hoping to learn more about Valuation Techniques and Modeling them, I found over half the course to be review and not new information for me.
  • Ayushi Sharma
    It's a great course to learn how to use excel, no matter your current level. Highly recommend it for finance students like myself.
  • Aditya Parmar
    It is an excellent course! It is very well explained, with lots of business case studies, which as an accountant student, helped me to combine excel tools with my financial knowledge. I´m looking forward to put in practice all the things I've learned!
  • Arvind Gupta
    It is really a good course as it covers everything, although sometimes it does not explain few concepts in-depth, as per me. So, it takes time to understand. Otherwise, the course is excellent, even for those who have no knowledge about excel. Thanks Jobaaj Learnings.
  • Yogendra Pal
    The course is ultimate...I never thought that I can get something as valuable as this course for an amount less than INR5000 in an offer. I highly recommend this course to all those who want to do financial modelling.
Preview this course
₹17999 ₹9999
Includes: