Advanced Valuation and Financial Modelling

Master the essentials of finance, including valuation, financial modeling, and related principles.

Overview

What you’ll learn

This course covers finance and valuation techniques like Discounted Cash Flow, Comparable Companies, and Precedent Transactions using Excel. It combines theory with practical case studies, replicating tasks professionals face. Exercises include forecasting financial statements and creating valuation models of top companies.

150+ hours of Practical Content

Excel Templates and Reading Materials

Live and Self-paced Session

Certificate Provided

Learning Core Valuation Methods

In this course, we will learn the fundamental valuation techniques applied in the industry standard. It covers a wide range, from comparable companies and precedent transactions analysis to creating a discounted cash flow analysis from scratch.

Learn using real life examples

In this cohort, the valuation exercises focus on real, publicly-traded companies, providing students with tangible outputs that mimic actual finance deliverables used for informed investment decisions. By participating, you can acquire valuable modelling experience that will enhance your resume or CV with demonstrable skills.

Student Profile

Who are these courses for?

Academic undergraduates

For aspiring college students seeking internships or full-time positions in leading business, finance, or investment firms, these courses are tailor-made to suit your needs.

Employed Individual

For professionals aiming to advance their technical career skills, this course is the ideal choice.

Career shifters

If you aim to enhance your technical skills and increase your chances of transitioning into a business or finance role, this course is the perfect fit.

Course Curriculum

    • No matter whether you are a CA, CFA, CMA, MBA, etc
    • Or Just a Plain graduated, or never read accounting ever.
    • This moduleis a must for you
    • In more than 20 hours of sessions, you will understand the basic to most advanced partial applications of Financial Statement Analysis
    • Including tonnes of real-world case studies

    • Understanding Risk -Free Rate With Case Studies.
    • Calculating ERP in 5 Different Ways.
    • Understanding Cost Of Finance.
    • Earning To CF
    • Forecasting Growth.
    • Other ADD-ONS.

    • Comparable Company Analysis.
    • Comparable Transaction Analysis.
    • Bonus:A Database of 25 Companies will be shared,so you can practice and prepare Financial Models & Valuation Report.

    • Dashboard Overview & Customization
    • Navigating Company Profile and Markets
    • In-depth knowledge of Screening.
    • How to use Chart Builder 
    • How to export charts and data in Excel.
    • Database and Tools
    • How to use Excel plugin

    • Advanced Excel Setup for Financial Modeling
    • Excel Shortcut - Zero mouse use technique
    • Advanced Excel Formatting
    • Understanding the usage of Row, Columns, and Alignments
    • Common errors in Excel.
    • Cell Naming and Anchoring
    • Master Custom Formatting
    • Dynamic Text and Concatenate
    • Tracking and Editing Data
    • Rounding Functions
    • Practical Usage of Flash fills
    • Vlookup, Hlookup, and Xlookup - The easy way
    • Index and Match function
    • Basic to advanced IF functions (including NestedIF)
    • SumProduct, SumIFs, and AverageIFs
    • Goalseek and Data Tables
    • Text to Columns
    • Filtering and Subtotal
    • Paste Special
    • Fundamentals of Pivot Tables
    • Summarize Data with Pivot Table
    • Updation and Sorting of Pivot Table
    • Analyzing Pivot Tables
    • Designing Pivot Tables
    • Filtering with Slicer and Timelines
    • Pivot Charting
    • Intro to Power Pivot
       

     

    FINANCE FUCTIONS (INCLUDING PRACTICE SHEETS)

    • Presents Value & Future Value
    • Net Present Value (NPV)
    • CAGR & RRI
    • XNPV & XIRR
    • Internal Rate of Return
    • Loan Repayment Schedule - PPMT, IPMT, CUMIPMT

     

     

    DATA VISUALIZATION (INCLUDING PRACTICE SHEETS)

    • Bar Charts
    • Pie and Doughnut Charts
    • Waterfall Chart
    • Gantt Chart
    • Football Field Chart
    • Area Chart
    • Pivot Chart
    • Sparklines
    • Combo Chart
    • Stock Price Chart with Volume Bars
    • Registration Ananlysis

     

    STATEMENT MODELING

    • PLot Historical FS
    • Model Inputs
    • Modeling Revenue
    • Revenue Schedules
    • Sensitizing Revenue
    • Modeling COGS
    • Sensitizing COGS
    • Modeling Expences
    • Depreciation Schedule
    • Modeling WC
    • WC Schedule
    • Modeling Retained Earnings
    • Retained Earnings Schedule
    • Modeling Debt Schedule
    • Modeling Cash & Revolver
    • Modeling Interest Exps
    • Building a Circuit Breaker
    • Building Income Statement
    • Building Balance Sheet
    • Building Cash Flow Statement
    • Linking 3-Statements
    • Common Size Statements

     

     

    ADVANCED RATION ANALYSIS

     

    Plotting and analyzing

    • Liquidity Ratios
    • Solvency Ratios
    • Profitability Ratios
    • Efficiency Ratios
    • Coverage Ratios

     

     

    Analyzing through Ratios

    • Income Statement Analysis
    • Balance Sheet Analysis
    • Cash Flow Analysis
    • Common Size Analysis

    • Building DCF Structure
    • Calculating Cost of Debt
    • Calculating Cost of Equity
    • Calculating WACC
    • Calculating FCFF
    • Projecting Cash Flows
    • Calculating Terminal Value
    • Mid Year Convention
    • Building three cases
    • Calculation of Enterprise Value
    • Calculation of Equity Value
    • Running Sensitivity Analysis

     

    • Determining Universe of Comparables
    • Locating required Information from Financial Statement
    • Spreading the Comparables.
    • Refining the Comps
    • EV/EBITDA Multiple
    • EV/Revenue Multiple
    • Determining Relative Valuation

    • Determining Universe of Precedent Transactions
    • Finding Financial Information
    • Control Premium Adjustment
    • Spreading the Precedents
    • Refining the Precedents
    • Deriving Valuation Range
    • Plotting Football Field Analysis
    • Inputting Equations
    • Lists and Bullets
    • Object Alignment
    • Front & Back Feature
    • Superscripting

    • Colour Themes
    • Formatting Lines
    • Formatting Slide Titles
    • Applying Master Layout
    • Formatting heading bars
    • Formatting tables
    • Inserting Tables from Excel
    • Inserting Charts from Excel

    • Inserting background picture & colour filter
    • Cropping to Shape
    • Object animations
    • Text Animations
    • Slide Animations
    • Slide Transition
    • Hidden Slides
    • Mastering Presenter tools
    • Presentation Comments
    • Sharing Presentations

    • Understanding best practices of report writing
    • Drafting table of content
    • Drafting Executive Summary
    • Drafting Company Overview
    • Inserting section divider
    • Inserting Tables and charts
    • Understanding alignments
    • Creating timelines
    • Drafting & Formatting Valuation Summary
    • Drafting Industry Overview section
    • Drafting conclusions
    • Understanding disclosures

    • Our 3-step method to prepare your customized ATS resume is to get in the Top 1% of job seekers.
    • Our 2-step method to prepare a targeted resume & Cover letter within 10 & 30 minutes.
    • How to check how good or bad your resume is and how to Improve.
    • ​How to Check Your chances of getting an interview call and how to improve. ​
    • How to clear all ATS and rank in the top 10%, 5%, and 1% of the people. ​
    • Live Resume Format and Resume content creation. ​
    • How to create your LinkedIn Profile: Top 3 things to take care of in your LinkedIn Profile. ​
    • How to Test how good or bad your LinkedIn profile is.
    • ​How to make a cover letter for Freshers, Experienced, Career change
    • ​Industry accepted Resume Template

    • Our LinkedIn profile optimization strategy and how to beat your competition on LinkedIn.
    • 2-step easiest & Fastest method to get a job.
    • Our LinkedIn hacking blueprint to reach out to your target brands and get a job.
    • Our value creation method for your network, even when you don’t have anything to offer.
    • My Strategy is to increase your credibility and visibility on LinkedIn to get a job.
    • Top 7 tricks to target Brands and find the latest Job opportunities
    • Incredible follow-up strategy to get Interview calls
    • The 30-second email hack gets me a 5x response from the recruiters.

    • Step-by-step - Interview Preparation Process.
    • Answer all the important questions ​
    • 4-Step Process to do your salary research & Negotiation ​
    • How to manage your Body language for Interview success. ​
    • Best way to answer “Behaviour question” and Interview template.
    • 3-Layer Onion Model to Prepare for All the Interview Questions.
    • Special “POA” to Get out of objections, Gap, Less experience, and other loopholes
    • Perfect Strategy to break free & Stand out in the interview got my clients a hike of up to 300.
Testimonial

What our Students says

"When I initially contacted Parth sir for this course, as a student without any formal education in finance. He only asked me one thing- my willingness to exert effort on par with his. I provided a positive response. I have been attending lectures diligently, taking lots of notes, and doing independent research for the past few months to comprehend the topics. Despite the challenges, I was determined to put in the time and effort required to fill in the gaps in my knowledge and succeed in this course. And I'm confident that learning will pay off. I would strongly vouch for Parth sir's advice and assistance to anyone interested in the course."

Vardaan Khattar

Very comprehensive and industry-specific content provided by Sir, the level of knowledge served is priceless. Highly Beneficial if anyone aspires to learn about valuation & financial modeling in-depth. I am fortunate to attend his classes.

Soumyadeep Das

Sessions are way more practical than any other institute offers on valuations, that too at very affordable fees.

Ravinderbir Singh

Glad to be a part of The Valuation School's Advance Valuation and Financial Modelling Cohort!
This course has been a great value addition to everyday life. Highly highly recommended for finance aspirants!

AKASH DEEP DHIMAN

Currently enrolled…. the content of the classes are so rich and engaging that one doesn't get to keep track of time …one of my best career decisions to get enrolled in this absolute masterclass

Abir Poddar

I am writing to give an update on my progress in the valuation and financial modeling course. As a non-management student with limited prior knowledge of finance, I find the course material detailed and challenging. However, I want to express my appreciation for the comprehensive instruction provided thus far. Over the past four to five sessions, I have diligently attended lectures, taken thorough notes, and engaged in independent study to enhance my understanding of the subject matter. Despite the initial difficulties, I am committed to putting in the necessary effort to bridge the gaps in my knowledge and excel in this course. I am grateful to Parth sir for guidance and support. I am confident that with continued dedication, I will overcome the challenges and succeed in mastering the concepts of valuation and financial modeling.

Ayush Nautiyal

In India, no one teaches valuation like Parth, Sir! He covers everything with an industry holistic view, from scratch to Advance.

Vishvam Jayswal

Best course available for valuation currently in India. Highly Recommended.

Kiran Sadvelkar

Best course for learning Valuation in depth along with the case studies and applying that knowledge practically to make financial models and valuation report. Had a very good experience in the last cohort and would strongly recommend to anyone who really wants to make a career in finance

Ishan Gupta

Parth Sir is a great teacher . Content is practical with real life examples which helps students to understand better. He promotes and provokes higher order thinking skills and provides holistic learning . Absolutely amazing classes

Haritika Chhatwal

Vouching for the Practicality of this course! No books only real life examples!

Mandar Mitra

Best course ever. Understanding each concept with real life case studies and examples.

Shashwat Sahu

The best place to learn valuation in depth! Parth Sir is a brilliant person who helps each student to understand the concept crystal clearly... We will start falling in loving with studying. .

Jomol Mammen

Loved every minute of content of the course. Leaning new things, appreciate it very much.

Himanshu Rawat

the content is absolutely brilliant. must attend

Abhik Patra

Really value added session, practical exposure, career guidance, in depth analysis, and what not... blessed to have a mentor like him.

Nishi Sinha

One word: valuable

Sukhdev Motlani

Great course! Loved the practical content and knowledge of the course.

Kirti Bhojwani

Very practical course. Learned a lot. Got to know many things, which I always thought to be true but were different. Recommend to any one who is interested in this domain.

Aman Bakshi

Parth sir is just amazing....content and industry knowledge he gives is fabulous…best course availabe for valuation industry…highly recommended

Saurabh Agarwal

Amazing course. Highly recommended because it is purely practical. I love the way he teaches. I am glad to be a part of The Valuation School

Kapil Juneja

100 % recommended course...The content is so vast and explained in such an easy manner.

Shruti Chourasia

This program is very practical with real case study and parth sir is on fire every moment.

Rohan Sharma

Amazing cohort by Mr. Parth Verma. No books are required. Explaining live examples. One of the best mentor I've ever meet.

Purvish Kachhadiya

Best teacher ever. Highly recommended course.

Suraj Sharma

Best knowledge best guidance at very affordable cost

aunjaneya singh

You connect very well with your students…....best classes for financial modelling

Shweta Agarwal

His guidance transformed the system from a theoretical one to a practical one. Every idea and possibility is examined in light of the reasons why it shouldn't be used if the industry doesn't. He always answers everyone's questions. Additionally, theere is conceptual simplicity allows and examples for each question in his responses.

Tashi Poonia

Course Pricing

Plans for Everyone

Frequently Asked Questions

  • You will receive a mail from the admin team.
  • Install the App
  • Put in your credentials

You are good to go.

P.S-Check your spam folder too for the mail.

We believe in the practical application of concepts and therefore encourage our students to practice and prepare models even after completion of the program.

Yes, as we said it's a 100% practical program, all the participants will be preparing a financial model and valuation report of the company of their choice from the database of 25 companies.

No, we believe it's a gimmick and nobody in a sane mind should offer a job guarantee. We focus on upskilling our participants and polishing their profile as per the requirements of the industry. Our students successfully get interview calls on their own without paying any "Success Foes".

The access to all resources will be available for 1 yr with a view limit of 2x.

2x.

No worries you’ll have the access to recordings and study

We don't do refunds.

No, only one device is allowed to be given access.

Yes,you will be added to a Whatsapp group where you will have like mind people .You can discuss ,share notes and grow together.

PPTs, PDF, Research articles that are being discussed in the class will be shared to you post class.

Hindi and English both.

Yes. it's always better to start early as it gives you an edge over others, further, this program will help you to grab internships in the core finance domain.

We will deliver all necessary sessions LIVE to accommodate recent-events and macroeconomic changes. However, basis our experience, Financial Modeling, and PowerPoint can be best learned in recorded sessions as everyone has a different pace.

The program is 100% practical and includes real-world case studies and real company data.

Yes, we will share all required data of 25 companies to emable you to perform all the tasks.