Financial Modeling & Valuation Online

    Sign Up For A Callback

    Our Alumni Works At

    Moody's Analytics
    duff & phelps
    visible alpha
    care ratings
    yes bank
    veristart
    xceedance
    IHS Markit
    oxane
    SG Analytics
    CIANS
    Aurum
    evalueserve
    WNS
    KPMG
    genpact
    ONICRA
    M cube Financial
    silvelskills
    Northern ARC
    Eli Global
    Drewry
    Smart Cube
    PWC
    EY
    Wipro
    GREEN
    S&P Global
    Aneriprise
    Bank of America

    Target Audience

    Our training is open to ambitious candidates who come from a range of backgrounds and will typically be

    bulb

    Graduates

    chart

    Post-Graduates

    user

    CA/CFA/ACCAs

    list

    Finance Professionals

    lock

    Investment Professionals

    Speak to our Counselor to know if you are good fit for the program at +91-9354266554 or Mail Us at [email protected]

    Training Approach

    Our training program is blend of Classroom Sessions followed by Project Work and Soft Skill training. Upon Successful completion of all 3 Milestones, candidates become eligible for 4 Milestone that is Placement, and provided support for CV building and Interviews.

    01

    Classroom
    Training

    100 hours of intensive classroom training spanning over ~2.5 months, with cases, quiz, & assessments.

    02

    Capstone
    Project

    The candidate goes through intensive project work/assessments that help them immensely in the placement process and helps them in real-life challenges.

    03

    Resume &
    Interview Prep

    We understand what recruiters look for in a Resume. We help candidates in writing professional resume and help them in interviews preparation by mock interviews and making them understand the Do’s and Don’ts of an interview.

    04

    Final
    Placement

    Based upon candidates’ profile, performance, and interest area, we schedule interviews for the candidates and help them crack interviews.

    Financial Modeling and Valuation Analysis Curriculum Highlights

    • Keyboard Accelerators and Shortcuts
    • Create and Customize the Excel List
    • Data entry with Auto Fill Feature
    • Working with Advance Cut, Copy, Paste Command
    • Use of Find and Replace
    • Using Paste Special
    • Sorting and Filtering
    • Advance Formatting
    • Mathematical Functions
    • Text Functions
    • Statistical Functions
    • Date & Time Functions
    • Array Functions
    • Database and Logical Functions
    • Reference and Lookup Functions
    • Financial Function
    • What if Analysis (Goal Seek, Scenarios, Data Table)
    • Pivot Table and Pivot Chart Reports
    • Dashboard Creation and Visualization
    • VBA Macro Basics
    • Most used chart creation including Bar, Stacked, Line, Pie, Waterfall, Football Field etc
    • PPT training for writing, formatting and alignment
    • Best practices and shortcuts for pitch creation, overview slides, chart pasting
    • Introduction to Financial Statements
    • Understanding Income Statement, Balance Sheet and Cash Flow and Key Line Items
    • Reading, Skipping and Skimming Annual Report
    • Understanding Management Discussion & Analysis (MD&A)
    • Ratio Analysis and Interpretation
    • DuPont Analysis
    • Modeling for 3 Financial Statements
    • Revenue and Cost Modeling
    • Building Supporting Schedule including Depreciation, Working Capital, Debt, Equity, Asset Schedules etc
    • Building Scenarios (Base, Best, Worst Cases)
    • Maintaining, Updating and Model Adjustments for Corporate Actions (CACS)
    • Keeping the Model Dynamic
    • Cost of Equity Modeling
    • Cost of Debt Modeling
    • WACC Calculation Best Practices
    • Cash Flow Modeling (FCFF / FCFE) and Terminal Value Calculation
    • Approaches to DCF Valuation
    • Football Field Analysis and Discussion
    • Introduction to Comparable Companies Analysis
    • Select the Universe of Comparable Companies
    • Locate the Necessary Financial Information
    • Spread Key Statistics, Ratios, and Trading Multiples
    • Determine Valuation using Comparable Companies
    • Adjustment / Normalization of EBIT, EBITDA and Net Income
    • Adjustments of Options, Warrants and Restricted Stock Units for Dilution/li>
    • Concept of Calendarisation and Last Twelve Months
    • Interpreting Results
    • Introduction to Precedent Transactions Analysis
    • Select the Universe of Comparable Acquisitions
    • Locate the Necessary Deal-Related and Financial Information
    • Spread Key Statistics, Ratios, and Transaction Multiples
    • Benchmark the Comparable Acquisitions
    • Determine Valuation using Comparable Acquisitions
    • Normalization of EBIT, EBITDA and Net Income
    • Interpreting Results
    • Introduction to Project Finance
    • Sources and Uses of Funds
    • IRR, Modified IRR, NPV, Profitability Index and Discounted Payback Period
    • Project Finance – Case Study
    • Real Estate Modeling – Overview
    • Understanding NOI, Cap rate, CoCR, Debt Amortization, among others 
    • Real Estate Modeling – Case Study
    • Use of Financial Models in Pitchbook
    • Flow of M&A / Restructuring Transaction
    • Introduction to company profile – best practices to follow
    • Discussion on live case
    • Post Classroom Sessions, candidates are asked to complete an integrated project covering all the training aspects of program. The project helps candidates get the hold of the concepts and make them aware about best practices.
    • Do’s and Don’ts of Interviews Process
    • CV Edits and LinkedIn Profile Building
    • Candidate will have to sit for Mock Interview and clear the rounds to become eligible for  placements

    Financial Modeling & Valuation - Course Fee

    Classroom / Live Online Self-Paced
    INR 37000 INR 25000
    Classroom / Live Zoom Yes
    Class Recordings Yes Yes
    Detailed Study Material Yes Yes
    Case Studies Yes Yes
    Capstone Project Yes Yes
    App Access (Android) Yes Yes
    100% Placement Support Yes Yes
    CV & Interview Prep Yes Yes
    Live Doubts Sessions Yes
    Whatsapp Group Yes
    Email Support Yes
    BUY NOW BUY NOW

    100% Placement Support*

    CFI Education provides placement assistance to all the candidates who complete our in-house Financial Modeling or Investment banking programs. Apart from technical classroom training, we prepare candidates for soft skills, and conduct mock interviews. Once they feel confident, they can start applying for various job opportunities provided by our dedicated placement team. The placement process is usually start at 8th week of the training program.

    We charge a placement fee of 5% of annual fixed ctc. This fee is applicable only when candidates is selected through our placement team efforts and accepts the job offer. Contact our team to know more about how CFI Education can help you launch your career in core finance domain.

    Success Stories

    Students Speak

    Certification