Advanced Valuation and Financial Modelling

• Comparable Companies Analysis
• Comparable Transaction Analysis

Bonus material - We will share the complete database of the 25 companies. So you can practice and prepare Financial Models and Valuation Reports after the program.

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

a) Basic to advance

• Advanced Excel Setup for Financial Modelling
• 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
• Conditional Formatting
• Text Functions
• Rounding Functions
• Practical Usage of Flash fills
• Vlookup, Hlookup, and Xlookup- Easy Way
• Index and Match function
• Basic to advanced IF functions (including NestedIF)
• SumProduct, SumIFs, and AverageIFs
• Choose Function
• Counting Functions
• Date and Time Functions
• Goal seek and Data Tables
• Text to Columns
• Filtering and Subtotal
• Paste Special

b) Pivot Tables

• 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

c) Finance Functions

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

d) Data Visualization

• 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
• Regression Analysis

a) Statement Modelling

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

b) DCF Modelling

• 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

c) Comparable Modelling (Including Practice sheets)

• 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

d) Precedent Transaction Modelling (including Practice sheets)

• Determining Universe of Precedent Transactions
• Finding Financial Information
• Control Premium Adjustment
• Spreading the Precedents
• Refining the Precedents
• Deriving Valuation Range
• Plotting Football Field Analysis

a) Basic of PowerPoint

• PPT setup and settings for finance
• Ribbon essentials
• Setup Slide Masters
• Understanding Slide Layout
• Managing Header and Footer

b) Formatting

• Color Themes
• Formatting Lines
• Formatting Slide Titles
• Applying Master Layout
• Formatting heading bars
• Formatting tables
• Inserting tables from Excel
• Inserting charts from Excel
• Inputting Equations
• Lists and Bullets
• Object Alignment
• Front & Back Feature
• Super scripting

c) Mastering Live Presentation

• Inserting background picture & color 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

a) Resume BUILDING

• Our 3-step ATS resume method: Get into the top 1% of job seekers.
• Our 2-step method to prepare a targeted resume and cover letter within 10 and 30 minutes.
• How to check and improve your resume quality.
• How to check your chances of getting an interview call and how to improve them.
• How to clear all ATS and rank in the top 10%, 5%, and 1% of candidates.
• 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

b) How to get Interview Calls?

• Our LinkedIn Profile Optimization: Enhance your profile to outshine competitors.
• My Fastest Job Method: Two steps to quickly land a job.
• Our LinkedIn Hacking Blueprint: Reach target brands and secure a job.
• Our Value Creation Method: Offer value to your network even with limited resources.
• My Credibility and Visibility Strategy: Boost your LinkedIn presence to get hired.
• Our Top 7 Tricks: Find job opportunities with top brands.
• Our Follow-Up Strategy: Effective methods to get interview calls.
• My 30-Second Email Hack: Achieve a 5x response rate from recruiters.

c) How to crack the interview?

• Step-by-step interview preparation process.
• Answer all important questions.
• 4-step salary research and negotiation process.
• Manage your body language for interview success.
• Best way to answer behavior questions and interview template.
• 3-layer onion model to prepare for all interview questions.
• Special "POA" to handle objections, gaps, less experience, and other loopholes.
• Perfect strategy to stand out in the interview helped my clients get up to a 300% hike.

• 15 hours of live sessions on preparing for technical questions.
• Discuss exactly what interviewers are trying to understand with each technical question.
• How to frame your answers for each question.
• How to tackle technical questions if you don't know the answer.
• Includes a carefully handcrafted interview question booklet with 300+ relevant questions and ideal answers.