Practical Real Company's Financial Modeling + Valuation 2021

person icon Sanjeev Mittal

Practical Real Company's Financial Modeling + Valuation 2021

You will be most preferable candidate for getting a job/advance your career in Financial Modeling from the day 1!

updated on icon Updated on Sep, 2023

language icon Language - English

person icon Sanjeev Mittal

architecture icon Business,Finance & Accounting,Financial Modeling


30-days Money-Back Guarantee

Training 5 or more people ?

Get your team access to 19,000+ top Tutorialspoint courses anytime, anywhere.

Course Description

**Updated for October, 2021**

  • Are you a person who want to apply your brain in Real world Financial Modeling and Valuation?

  • Are you really looking for a course which can advance your knowledge of Financial Modeling?

  • Are you graduate looking for starting your first job in finance world?

  • Are you a professional looking for a pay hike or new position?

  • Would you like to be your team lead in financial modelling projects?

If answers to above questions is yes, then this is the perfect course for you !

Experience of Instructor

  • Mr. CA Sanjeev Mittal had worked with Treasury and Finance department of multiple listed companies for more than 7+ years.

  • He is having experience of taught more than 15,000+ students online and offline both.

  • He had advised multiple companies on their financial model and Business valuation.

Learn the advance Financial Modeling from the expert who had walked on the same path several times in the past.

You shall get the best understanding of:

  • Building sound financial model for real world company Caterpillar Inc

  • Gain and learn in-depth understanding of company valuation and Intrinsic value of Shares

  • Demonstrate superior skills at Work or University

  • Get ready for Investment Banking, Consulting career or any job Interview

You will get the best:

  • Understanding of Material and well-structured course

  • Detailed Explanation and Downloadable Resources

  • Regular Course update as required

After completing this course, you will be great at:

  • Build Real world Projected Income Statement, Balance Sheet and Cash Flow Statement for any company

  • Know the Real intrinsic value of a company

  • Create Financial Model for a Company based upon real data

About the Course:

  • Very Basic understanding of finance is needed to start this course.

  • Unlimited access to all resources, excel files, sheets, links and much more.

  • Learning by doing

  • You can contact us in message and we shall clarify your queries free of charge.

Are you ready to make a choice of higher return on investment by purchasing this course? Still there is an unconditional 30 days money back guarantee, because we believe in quality content and client satisfaction. Go ahead and subscribe this course so that you don’t miss the opportunity to separate yourself from others and get to the top of your career. Let’s start learning together.


What will you learn in this course:

  • Finding real world cost of capital and business value of companies

  • Build projected income statement, balance sheet and cash flow statement for Caterpillar Inc

  • Find the intrinsic value so that Buy/Sell recommendation for shares can be given

  • Master the financial modeling for real world companies

  • Design Professional and good-looking charts to advance your career

  • Direct Important discussion, no unnecessary stuff – so that your time can be saved


What are the prerequisites for this course?

  • Very basic knowledge of finance

Practical Real Company's Financial Modeling + Valuation 2021


Check out the detailed breakdown of what’s inside the course

Introduction to Financial Modeling
2 Lectures
  • play icon Overview of entire financial modeling course 05:49 05:49
  • play icon Best way to take this course 00:50 00:50
Analyzing Caterpillar Inc's Cost of Equity using Gordon's Growth Model
5 Lectures
Analyzing Caterpillar Inc's Cost of Equity using CAPM Model
11 Lectures
Computing Caterpillar Inc's Cost of Debt
5 Lectures
Computing Weighted Average Cost of Capital (WACC) for caterpillar Inc
3 Lectures
Preparing historical financial data for modeling of Caterpillar Inc
9 Lectures
Modeling multiple financial ratios
7 Lectures
Preparing proforma financial model
2 Lectures
Projecting Income Statement and Balance Sheet
24 Lectures
Projected Free Cash Flow for the Firm
9 Lectures
Intrinsic value of shares and buy or sell recommendation
3 Lectures

Instructor Details

Sanjeev Mittal

Sanjeev Mittal

Gold Standard Educator for Finance and Management Accounting


I was associated with a $3 billion valuation startup (Unacademy – Sorting hats technology private limited) wherein I have taught more than 30,000+ students. I am a Chartered Accountant by profession having teaching experience of more than 6+ years. I have taught students pursuing courses related to Chartered Accountant, Company Secretary, ACCA, CPA, CMA, MBA Finance, CFA, University undergraduates and postgraduates in Finance and Management Accounting.

Also, I have practical experience in the treasury department of a listed company “Welspun Enterprises Limited” wherein my routine work was to analyze the Bond market and available investment opportunities for parking idle funds of the company for a short-term basis.

I have also written content on money management for India’s top websites like Taxguru.com.

Besides that, My Student got All India Rank 1 in the Chartered Accountancy course (CA Intermediate-Old Course).

I have a complete studio setup at my location with a green screen, so I can teach students in an engaging and live learning environment.

Work Experience details

1. Educator for Cost and Management Accounting:

Sorting hats technology private limited

2020 to 2021

I was associated with the brand's team of Sorting hats technology private limited wherein, my role was to teach cost and management accounting to students online through their learning app. The company is valued at $3 billion. I have taught more than 30,000 students there on their subscription model as well as the free cost platform. Students have watched my sessions for more than 527k minutes.

My students review on platform: https://unacademy.com/@casanjeevmittal301-8574

My teaching Video: https://youtu.be/biuOx0KKdB0 

2. Educator for Financial Management

Gour's E-Learning

I was managing e-learning content provided by teachers across India. At the same time, I was teaching financial management to the students offline and online. Through online mode,  I had a good presence and review among students. You can check students reviews and teaching styles -https://youtu.be/kyNwhIrDpfI 

3. Content creator for Udemy

Udemy Inc

2020 to 2021

I have a 4.5 Rating on the Udemy platform where I have created the following courses:

1.  Practical Financial Modeling for Caterpillar Inc (NYSE) course.

2. Technical Analysis of the stock market.

My video sessions details on udemy: 

1. Technical Analysis Course - https://www.udemy.com/course/technical-analysis-of-stocks-mastery-zero-to-hero/

2. https://www.udemy.com/course/practical-real-companys-financial-modeling-and-valuation/

4. Educator for Management Accounting


2019 to 2020

I have taught as a visiting faculty for their multiple short courses.

5. Financial Management Educator

The Western India Regional Council of ICAI 

2016 to 2019

Taught management accounting and financial management at The Western India Regional Council to CA Inter and CA Final Students. 

Financial Management Educator

6. Financial Management Educator

Rajkot Branch of ICAI

2017 to 2020

7. Strategic Financial Management Educator

Uttam Prakash Agarwal Chartered Accountants (UPACA)

2016 to 2018

Taught Strategic Financial Management as a subject to Uttam Prakash Agarwal Chartered Accountants (UPACA) (From the year 2016 to 2018).

8. Private and Group tuitions

2019 to Current

Taught Private group tuition to Canadian and US students for their CPA, ACCA, and CMA exam preparation.

9. Company Secretary financial Management Educator

Sidhpura’s Commerce Classes

2018 to 2020

Offline teaching to students at Sidhpura's commerce classes

10. Graduation and Post Graduation Financial Management Educator

Assets Commerce Classes

2016 to 2017

Visiting Faculty of Assets Commerce Classes for graduation and post-graduation courses.

11. Welpsun Enterprises Limited 

Finance and Treasury Department (Jan 2015 to June 2016) 

Education Experience of Educator:

The Institute of Chartered Accountants of India

Finance and Management Accounting

2012 to 2016

University of Rajasthan



2013 to 2016

My Academic achievements

1. Consistent 1st Rank in School from Grade 1 to Grade 12th.

2. All India 26th Rank in my CA Foundation Examination.

3. 12th State merit while preparing for a senior secondary examination.

Course Certificate

User your certification to make a career change or to advance in your current career. Salaries are among the highest in the world.

sample Tutorialspoint certificate

Our students work
with the Best

Related Video Courses

View More

Annual Membership

Become a valued member of Tutorials Point and enjoy unlimited access to our vast library of top-rated Video Courses

Subscribe now
People having fun around a laptop

Online Certifications

Master prominent technologies at full length and become a valued certified professional.

Explore Now
People having fun around a laptop

Talk to us