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?

  • 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
  • Entering data, Name Manager, Go To, Trace Precedents & Dependents, Quick Access Shortcuts
  • Fomatting Tools
  • Custom Cell Formats, Paste Special, Transpose, Hyperlink
  • Sorting & Filtering, Table & its Features, Importing data, Grouping & Hiding, Data Validation
  • Printing setup, Text-to-columns, Math Functions, SUMPRODUCT, Date functions
  • Text functions, Flash Fill, Consolidate
  • Conditional Formatting, IF Functions/AND/OR
  • Pivot Table
  • Goal Seek, Data Table, Scenario Manager
  • FORECAST, TREND, GROWTH, Wild Card Characters, Error Types, Error Checks
  • VBA & Macros, Solver
  • Interactive Charts
Corporate Finance
7 Lessons 07:08:21 Hours
  • Time Value of Money Part - I
  • Time Value of Money Part - 2
  • Capital Budgeting Part- I
  • Capital Budgeting Part- II
  • Cost of Capital
  • Equity Valuation Part- I
  • Equity Valuation Part- II
Financial Statement Analysis
5 Lessons 05:01:37 Hours
  • Financial Statements : Basics
  • Cash Flow Statement + Other Concepts
  • Depreciation Methods + Working Capital
  • Working Capital + DuPont Analysis
  • Ratio Analysis + Common Sizing
Construction of Financial Models
9 Lessons 10:19:14 Hours
  • Financial Modelling Process
  • Project Finance Model Part - I
  • Project Finance Model Part - II
  • Project Finance Model Part - III
  • Project Finance Model Part - IV
  • DCF Model Part - I
  • DCF Model Part - II
  • DCF Model Part - III
  • Comparables Valuation Model – I
+ View more
Other related courses
12:28:30 Hours
Updated Thu, 06-Jan-2022
5 76 ₹9999 ₹4999
10:07:38 Hours
Updated Wed, 18-May-2022
5 126 ₹50000
03:26:27 Hours
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
11 Reviews
  • (0)
  • (0)
  • (0)
  • (3)
  • (8)


  • 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.
₹17999 ₹9999