3.

1 Sequential Learning
Financial Modeling
Financial Modeling involves numerically representing a company’s historical, current, and
projected activities. It aids organizations in making informed decisions by building models in
Excel spreadsheets. These models provide insights into the associated risks of implementing
various decisions.
Valuation
Valuation is the analytical process of determining the worth of an asset or a company. It
quantitatively assesses the fair value of assets and investments. Valuation models, integral to
Financial Modeling, estimate the intrinsic value of assets or investments. They are essential
for investors, analysts, and financial professionals, facilitating informed investment decisions
and asset evaluation.
3.1.1 Course Objectives
- Accurately project future financial performance of businesses/companies.
- Design and construct financial models effectively.
- Facilitate informed decision-making processes.
- Demonstrate proficient and structured Excel skills.
- Aid in predicting or determining company valuations.
- Assist in liquidity planning.
- Provide practical financial skill development.
- Predict company trends effectively.
- Serve as a practical tool for understanding and assessing business dynamics.

3.1.2 Syllabus
The training program syllabus at Zeta Coding covers a wide range of topics, from the
foundational basics of Excel to the development of complex financial models and valuation
techniques. This comprehensive curriculum ensures participants acquire practical skills and
theoretical knowledge essential for financial analysis and decision-making.
The detailed syllabus is presented in the table below:

Sl. Modules No. of Hours No. of Videos

1 Understanding of Excel 10 13
 - Basics of Excel

- Financial Modeling Tools

- Formatting and Conditioning

2 Investment Decision Technique 7 10

- Time Value of Money

- Present Value

- Net Present Value & Discount Rate

- Internal Rate of Return

- Payback Period

3 Application of Decision Technique 6 9

- Make vs. Buy Analysis

- Personal Finance Analysis

4 Financial Statement Analysis 15 25

- Introduction to Financial Statements

- Income Statement

- Balance Sheet

- Cash Flow Statement

- Coffee Shop Example

- Case Study: Hero MotoCorp

- Financial Statement Analysis

5 Valuation 12 23

- Introduction to Valuation

- Absolute Valuation (DCF Method)

- Case Study: Hero MotoCorp

- Relative Valuation

Total 50 80
3.2 Training Methodology
Zeta Coding is a premier training institution offering learners and professionals advanced
skills and practical exposure to enhance career prospects and facilitate upskilling for
professional development.
For the Financial Modeling and Valuation Course, participants are provided access to
recorded sessions that can be viewed anytime, making it a flexible learning experience. The
training program spans six weeks, comprising 80 videos and a total duration of 50 hours.
The course is divided into five key modules:
Understanding of Excel
Investment Decision Technique
Application of Decision Technique
Financial Statement Analysis
Valuation
Sequential Learning Structure
The training follows a structured chronological format, where learners can unlock the next
module only after completing the previous one. This sequential approach ensures a stepbystep
understanding of the concepts.
Knowledge Assessment
Quizzes are conducted after each topic to reinforce learning.
A comprehensive module test follows the completion of each module, allowing participants
to assess their understanding.
Detailed explanations for both correct and incorrect answers help participants gain deeper
insights into the subject matter.
Tutor Interaction
Although the sessions are prerecorded, participants can engage with tutors via:
Discussion forums: Queries can be posted here, with responses provided within 24 hours.
Chat sessions: Direct queries are also addressed promptly.
Practical Assignments
After completing the five modules, participants are required to complete an assignment and
submit it in a prescribed format.
Final Test & Certification
A 45minute final test assesses the participant's overall understanding.
3.2.1 Case Analyzed
In the Financial Modeling and Valuation course offered by Zeta Coding, the case of Hero
MotoCorp was analyzed in detail. The financial statements for the years 2017 and 2018,
including the Income Statement and Balance Sheet, were provided for analysis.
The stepbystep approach to arriving at the Discounted Cash Flow (DCF) value involved:
1. Reorganizing the company’s financial statements
2. Building forecasts for future financial performance
3. Estimating the continuing value
4. Calculating the Weighted Average Cost of Capital (WACC)
5. Calculating the DCF value and performing sensitivity analysis
This comprehensive process demonstrated the use of financial statements—Balance Sheet,
Income Statement, and Cash Flow Statements—to understand the financial position of a
company and assess its intrinsic value.
3.2.2 Training Assignment
Upon completing all five modules, participants gain access to an assignment based on the
Hero MotoCorp case analyzed during the training.
Participants are required to apply their understanding of financial analysis techniques learned
in the course to complete the assignment, which must be submitted in the prescribed format.
3.2.3 Number of Cases Analyzed During the Training Program
The training program at Zeta Coding included the analysis of several practical business cases,
such as:
Make vs. Buy Decisions in a Business
Shutdown vs. Continuation of a Business
Personal Financial Decision (Buying vs. Renting Decisions)
Investment in a New Plant using BreakEven Analysis
Calculation of Equated Monthly Installments (EMIs)
3.3 Criteria for Availing the Training Certificate
The Financial Modeling and Valuation course at Zeta Coding spans six weeks, with a total
duration of 50 hours. Participants are required to meet specific criteria to be eligible for the
course completion certificate:
1. Completion of Recorded Sessions:
Participants must watch all 80 videos to unlock access to the final test.
2. Quizzes and Module Tests:
A quiz is conducted after each topic to reinforce learning.
A comprehensive test follows the completion of each module.
3. Practical Exercises:
During training, learners are encouraged to practice exercises, although submission is not
mandatory.
4. Assignment Submission:
After completing all five modules, participants must solve an assignment based on the case
analyzed during the training program.
The assignment must be submitted in the prescribed format.
5. Final Test:
Upon assignment submission, participants can access the 45minute final test.
6. Minimum Score Requirement:
Participants must score at least 33% on the final test to qualify for the course completion
certificate.