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 Sep, 2023
Language - English
**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
Check out the detailed breakdown of what’s inside the course
Introduction to Financial Modeling
- Overview of entire financial modeling course 05:49 05:49
- Best way to take this course 00:50 00:50
Analyzing Caterpillar Inc's Cost of Equity using Gordon's Growth Model
Analyzing Caterpillar Inc's Cost of Equity using CAPM Model
Computing Caterpillar Inc's Cost of Debt
Computing Weighted Average Cost of Capital (WACC) for caterpillar Inc
Preparing historical financial data for modeling of Caterpillar Inc
Modeling multiple financial ratios
Preparing proforma financial model
Projecting Income Statement and Balance Sheet
Projected Free Cash Flow for the Firm
Intrinsic value of shares and buy or sell recommendation
Sanjeev MittalGold 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
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
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/
4. Educator for Management Accounting
Satara WICASA of ICAI
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.
User your certification to make a career change or to advance in your current career. Salaries are among the highest in the world.
Our students work
with the Best
Related Video CoursesView More
Become a valued member of Tutorials Point and enjoy unlimited access to our vast library of top-rated Video CoursesSubscribe now
Master prominent technologies at full length and become a valued certified professional.Explore Now