Online Financial Modeling and Valuation Training
Learn financial modeling and valuation techniques from scratch
Duration: 6 weeks | Certified Training
About the 'Financial Modeling and Valuation' Training
The Financial Modeling and Valuation is a 6-week online training program which will give you a
comprehensive introduction to financial modeling and valuation techniques. In this training
program, you will learn about the financial modeling tools in excel, investment decision techniques
& their application, financial statement analysis along with various valuation techniques. You will
learn through video tutorials. For a great hands-on learning experience, this training program is
packed with assignments, assessment tests, quizzes, and practice exercises. At the end of this
training program, you will have a solid understanding of financial modeling and valuation techniques
and will be able to build end-to-end financial models. For doubt clearing, you can post your queries
in the forum and get answers within 24 hours.
Table of Contents
1. Understanding Excel
Learn basic excel tools, financial modeling tools and various formatting conditions required for
financial modeling and valuation.
1.1. Basic Excel Tools
1.2. Financial Modeling Tools
1.3. Formatting and Conditions
2. Investment Decision Techniques
Learn the concepts of time value of money, future value, present value and internal rate of return.
2.1. Time value of money, Future Value and Compounding
2.2. Present Value
2.3. Net Present Value (NPV) and Discount Rate
2.4. Internal Rate of Return (IRR)
2.5. Payback Period
3. Application of Decision Techniques
Learn to apply decision techniques like investment, renting vs buying, EMIs, insurance etc. in real life
scenarios.
3.1. Make or buy
3.2. Invest in a new plant or not
3.3. Personal finance
3.3.1. Rent vs buy a car
3.3.2. How EMIs are calculated
3.3.3. How much insurance cover you should buy?
3.3.4. Financial freedom
4. Financial Statement Analysis
Learn about different financial statements like income statement, cash flow statement and balance
sheet, and how to analyse them.
4.1. Introduction to Financial Statements
4.2. Income Statement
4.3. Balance Sheet
4.4. Cash Flow Statement
4.5. Financial Statement Preparation - A worked out example
4.6. Case Study - Hero MotoCorp
4.7. Financial Statement Analysis
4.8. Financial Statement Irregularities
5. Valuation
Learn different types of valuation techniques like absolute and relative valuation using a real-life
case study.
5.1. Introduction to Valuation
5.2. Types of Valuation
5.3. Absolute Valuation (with Hero MotoCorp example)
5.4. Relative Valuation
6. Final Project
Excited to learn Financial Modeling and Valuation? Click here to sign-up for the training.
FAQs
What is this training program about?
This is an online training program in which you will learn about Financial Modeling and Valuation.
You will learn financial modeling tools in excel, investment decision techniques & their application
and financial statement analysis along with various valuation techniques. At the end of this training
program, you will have a solid understanding of financial modeling and valuation techniques and will
be able to build end-to-end financial models
How will the training be imparted?
You will be taught using pre-recorded videos and text tutorials. The training has quizzes,
assignments, and tests to help you learn better. At the end of the training, you will attempt a project
to get hands-on practice of what you learned during your training.
What is the duration of this training?
This is a 6 weeks training program.
What are the timings of this training program?
As this is a purely online training program, students can choose to learn at any time of the day. The
students can decide the timing according to their convenience.
Who can join? I am a beginner/advanced user, can I learn Financial Modeling and Valuation?
This training would be better suited to beginners who have no prior knowledge of Financial
Modeling and Valuation. Anyone who is willing to learn and has interest in Financial Modeling can
opt for this training program.
Are there any prerequisites for joining this program?
This program is for beginners. There are no prerequisites.
Will there be any project that I will get to work on?
Yes, the project will involve the analysis of the financial statements of a public company and arrive at
its valuation using various valuation techniques.
What hardware/software are required for doing this training?
No hardware is required for doing this training. All the necessary software (if required) are uploaded
online which can be downloaded during the training.
Will there be a certificate provided at the end of the training?
Yes, a certificate will be provided by Internshala upon completion of the training. Students may
download a soft copy of the certificate through our portal.
Will I be able to download the training content?
Yes, you will be able to download the training content.
Can the material be used by a group of students?
No. These training programs are meant for individual users. Multiple users will not be allowed to
access the portal using the same account.
If you have any queries or doubts regarding the training, please write to us at
trainings@internshala.com or call us on +91 844 844 4853
