Every investment banking interview, every PE firm's hiring process, every corporate finance analyst role — they all test one thing above everything else: can you build a financial model? This course teaches you to build the models that Wall Street and Dalal Street run on — 3-statement models, DCF, comparable company analysis, LBO, and M&A — using Excel, from scratch, the way working analysts actually do it.
Financial Modelling & Valuation — Full Programme
Whether you are targeting investment banking, private equity, corporate finance, or equity research — financial modelling is the one skill that separates candidates who get offers from those who do not. Here is exactly why it matters so much.
Every investment banking analyst spends the first months of their career building and maintaining 3-statement financial models. Interviewers routinely ask candidates to walk through how a 3-statement model integrates — and candidates who cannot do this comfortably do not move forward.
DCF valuation appears in every equity research report, every M&A fairness opinion, every PE investment memo. Understanding WACC calculation, free cash flow derivation, terminal value, and sensitivity analysis is non-negotiable for any serious finance career.
Private equity firms hire almost exclusively from investment banking — and LBO modelling proficiency is the minimum technical bar. You cannot survive a PE interview without knowing how to structure an LBO, model debt schedules, and calculate IRR and MOIC.
Accretion/dilution analysis, purchase price allocation, goodwill calculation, synergies modelling, and pro forma combined financials are skills that very few candidates possess — and the ones who do stand out dramatically in corporate development and M&A advisory interviews.
Equity research analysts build sector-specific models — bank models (NIM, provisions, capital ratios), insurance models (combined ratio, float), retail models (same-store sales, throughput). This course teaches the generic framework that underlies all sector-specific modelling.
Every finance professional uses Excel every day. The difference between a junior analyst who is slow and one who is fast comes down entirely to Excel efficiency. This course teaches the shortcuts, formulas, and best practices that make modelling fast and error-free.
The Financial Modelling & Valuation programme is designed for students and professionals who are serious about a finance career — not dabblers.
MBA Finance, BBA, B.Com, and CA/CFA aspirants who want to develop the practical Excel-based modelling skills that academic programmes barely touch. If your institute teaches theory but not actual model construction, this is exactly what fills that gap.
Students and young professionals targeting investment banking analyst or associate roles at domestic banks, foreign banks, or boutique advisors in Mumbai, Pune, or Bangalore. IB interviews test financial modelling directly — often with a live Excel test.
FP&A analysts, treasury analysts, and corporate development professionals who want to upgrade from basic Excel work to proper financial modelling and valuation — to qualify for senior finance roles or move into investment banking.
Students targeting analyst roles at brokerage firms, AMCs, or independent research firms. Equity research requires the ability to build company-specific models, run DCF valuations, and write research reports backed by quantitative analysis.
Chartered Accountant and CFA candidates who want to complement their theoretical knowledge with practical financial modelling skills. CA and CFA exams test concepts — this course builds the Excel skills that turn concepts into employable competencies.
Engineers, IT professionals, and professionals from other domains who want to move into finance — whether corporate finance, VC, PE, or fintech. A strong financial modelling portfolio is the most credible signal of finance readiness for career switchers.
Every module is built around building real models — not watching someone else build them. You will construct each model from a blank Excel sheet using real company financial data.
Every tool in this course is used by working financial analysts every day — you will leave with genuine proficiency in the software that finance careers run on.
The portfolio you graduate with is not a collection of templates someone else built. Every model is yours — built from a blank Excel sheet using real data, real assumptions, and real analytical decisions. Here is what it includes.
Integrated 3-Statement Model — 5-year forecast with revenue build, working capital schedule, debt schedule, and equity reconciliation for a real NSE-listed company
Full DCF Valuation — Free cash flow build, WACC calculation with beta analysis, terminal value comparison (Gordon Growth vs Exit Multiple), sensitivity tables, and football field chart
Trading Comparables Table — Complete comps spread for 8–10 comparable companies with calendarisation, normalisation, and implied valuation range
Precedent Transaction Analysis — Deal comps for a real sector with control premium calculation and valuation output
Complete LBO Model — Deal structure, debt tranches, amortisation schedule, cash sweep, exit analysis, IRR/MOIC returns table, and entry/exit multiple sensitivity
M&A Accretion/Dilution Model — Purchase price allocation, goodwill, pro forma combined financials, accretion/dilution analysis, and synergy break-even sensitivity
Equity Research Report — 5-page professional research note with company analysis, financial model, DCF valuation, price target, and investment thesis
Excel Dashboard — A dynamic financial dashboard pulling from the 3-statement model with scenario toggle, KPI cards, and management-ready charts
These are the roles our students move into — all requiring strong financial modelling and valuation as the core technical skill.
Most financial modelling courses in Pune — and online — teach you to fill in templates. Someone has already built the model structure, already labelled the rows, already connected the formulas. Your job is to plug in numbers. That is not financial modelling. That is data entry. And it will not survive the scrutiny of a real interview where the interviewer asks you to build something from scratch.
At Aapvex, every single model in this course starts from a blank Excel workbook. You decide the structure. You write every formula. You connect the statements. You debug the balance sheet when it does not balance. You run the sensitivity analysis and interpret what it tells you about the company's value. This is the only way to develop the muscle memory and genuine understanding that makes you confident in an interview — not just familiar with a template.
Our trainer for the Financial Modelling programme has worked in investment banking and corporate finance — not as an instructor who learned modelling from a course, but as a professional who built hundreds of actual models for real transactions. The shortcuts, the best practices, the mistakes that juniors consistently make — all of this comes from first-hand experience, not theory. Students consistently say that the modelling guidance in this course is more practical than anything they encountered in their MBA Finance programme.
The company cases we use are real Indian listed companies. You will model companies from sectors you know — FMCG, IT services, banking, manufacturing, pharma. Using real data, with real inconsistencies in annual reports, with real judgement calls about how to treat one-time items, is what prepares you for a real finance job in India — not hypothetical Western company cases from a textbook.
| Feature | Aapvex | Typical Online Course | MBA Finance Elective |
|---|---|---|---|
| Build from blank Excel sheet | ✓ | ✗ | ~ |
| Real Indian company cases | ✓ | ✗ | ~ |
| LBO modelling covered | ✓ | ~ | ✗ |
| M&A accretion/dilution | ✓ | ~ | ✗ |
| Equity research report writing | ✓ | ✗ | ✗ |
| Interview preparation included | ✓ | ✗ | ✗ |
| 100% placement support | ✓ | ✗ | ✗ |
| Live doubt resolution | ✓ | ✗ | ~ |
I did an MBA Finance from a decent Pune college and thought I understood financial modelling. This course showed me how wrong I was. When the trainer said we are building from a blank sheet, I was nervous — by Week 4 I was building 3-statement models on my own without looking at notes. The LBO module was intense but the most career-defining thing I have ever learned. Got into an IB analyst role in Mumbai 3 weeks after finishing.
As a CA aspirant I had the accounting knowledge but no idea how to turn that into a financial model. This course bridges that gap perfectly. The accounting for financial modellers module was quick but precise — it tells you exactly what you need to know and nothing you do not. By the end I had a complete DCF model, a trading comps table, and a proper equity research note for my portfolio. Three PE firms I applied to gave me interview calls, and I cracked one.
I am an engineer by background and switched to corporate finance after 4 years in IT. Everyone told me finance would be impossible to break into without an MBA. The Aapvex financial modelling course and the model portfolio I built changed that. I walked into a corporate development interview at a listed company and they gave me a 2-hour Excel modelling test — I finished it in 90 minutes with time to spare. The only person they interviewed who could do that. Joined at Rs.14 LPA.
Every serious financial analysis starts with a 3-statement model — an integrated Income Statement, Balance Sheet, and Cash Flow Statement that is dynamic, formula-driven, and self-consistent. The three statements are not separate documents — they are one interconnected system. Net income from the Income Statement feeds into retained earnings on the Balance Sheet. Depreciation from the Income Statement appears as an add-back in the Cash Flow Statement. Capital expenditure on the Cash Flow Statement increases PP&E on the Balance Sheet. Change in working capital connects all three.
A properly built 3-statement model balances automatically — assets always equal liabilities plus equity — and produces a cash balance from the Cash Flow Statement that matches the cash on the Balance Sheet. Getting a model to balance correctly is both a technical and conceptual test. Students who truly understand the three statements can build a balancing model. Students who are working from memorised templates cannot. This course teaches you to understand, not memorise.
DCF valuation answers a simple question: what is a company worth today, given what we expect it to earn in the future? The answer is the sum of all future cash flows, discounted back to today at a rate that reflects the risk of those cash flows not materialising. That discount rate — WACC — is the weighted average of what the company's debt investors demand (cost of debt) and what equity investors demand (cost of equity, estimated using CAPM).
The most contentious part of any DCF is the terminal value — the value of all cash flows beyond the explicit forecast period, which typically represents 60-80% of the total enterprise value. Two methods are commonly used: the Gordon Growth Model (terminal FCF / (WACC - terminal growth rate)) and the Exit Multiple Method (terminal year EBITDA × comparable company EV/EBITDA multiple). Understanding why these give different answers, which is more appropriate for a given company, and how sensitive the valuation is to terminal value assumptions is what separates analysts who understand DCF from those who just plug numbers into a template.
A leveraged buyout works by using significant debt to finance most of the purchase price of a company. The PE firm contributes a relatively small equity check — typically 30-40% of the total deal value — and finances the remainder with debt. The company's own cash flow services this debt over the holding period (typically 3-7 years), paying it down. When the PE firm eventually sells the company, the remaining equity value — amplified by the debt paydown and any operational improvements — generates the return. The entire logic of LBO economics is that debt amplifies equity returns: a modest improvement in enterprise value translates to a much larger return on the equity invested.
Building an LBO model requires understanding how each debt tranche works — Term Loans with their mandatory amortisation and cash sweep provisions, Revolving Credit Facilities for working capital, High Yield Notes with bullet repayment — and how the cash waterfall allocates free cash flow to debt service. The credit statistics (Debt/EBITDA, Interest Coverage) are lender covenants that constrain how much debt can be used — and a good LBO model tests whether the capital structure is sustainable under various scenarios.
Real questions from students who joined the Financial Modelling & Valuation course at Aapvex Technologies, Pune.
Course fees start from Rs.19,999. EMI is available at approximately Rs.3,300 per month. Call 7796731656 for current batch pricing, early enrolment discounts, and scholarship information.
A basic understanding of what a Profit & Loss account and Balance Sheet are is helpful. You do not need a commerce degree or accounting qualification. Module 2 of this course covers accounting specifically for financial modellers — everything you need to know to build models, in the context of actually building them. Engineering graduates, science graduates, and MBA students from non-finance backgrounds all join and succeed.
You should be able to navigate Excel, enter data, and use basic formulas like SUM and IF. Everything beyond that — OFFSET, INDEX/MATCH, array formulas, data tables, pivot tables — is taught in Module 1. Students who are not comfortable with even basic Excel are encouraged to do a short Excel orientation session before the first class.
Yes — significantly so. CFA curriculum covers financial statement analysis, corporate finance, equity valuation, and fixed income extensively. This course builds practical skills in all of these areas. Students preparing for CFA Level 1 and Level 2 find that the modelling work in this course deepens their understanding of valuation concepts far beyond what reading the CFAI curriculum alone provides.
Yes — we cover Bloomberg Terminal for data sourcing in the comps and LBO modules. Students get a demonstration session using the Bloomberg terminal. For those who do not have ongoing Bloomberg access, we show how to replicate key data pulls using free alternatives like Screener.in, NSE/BSE filings, and company investor relations pages.
Yes — all model projects use real NSE-listed Indian companies. You will model companies from Indian IT services, banking, FMCG, pharma, and manufacturing sectors. Working with real Indian annual reports, real BSE/NSE financial data, and real Indian market comparable companies is what prepares you for a finance career in India — not hypothetical US company exercises.
Wall Street Prep and BIWS are excellent self-paced courses built on templates — you modify and complete pre-built models. They are designed for IB professionals in the US market. Aapvex's course builds every model from a blank sheet using real Indian companies, includes live instruction with real-time doubt resolution, covers the India-specific context (SEBI regulations, IFRS vs IndAS, Indian market valuation norms), and includes 100% placement support with direct referrals to finance employers in Pune and Mumbai.
Yes — live Zoom sessions with Excel screen sharing, real-time Q&A, and the same model files used in the classroom. Students join from Mumbai, Nagpur, Bangalore, Hyderabad, and Delhi. Weekend-only batches are designed specifically for working professionals who attend online.
Investment banking roles in Pune are limited — most IB work is in Mumbai. In Pune, strong financial modelling skills open doors to: FP&A and corporate development at large listed companies and MNCs (Infosys BPM, Wipro, KPIT, Bajaj Group), equity research at broking firms and AMCs with Pune operations, credit analysis at banks and NBFCs, and financial consulting at Big 4 and mid-tier advisory firms. For students targeting Mumbai IB or PE, this course is the technical foundation for making that transition.
Our placement support for the financial modelling programme includes: complete resume rewriting focused on finance and modelling skills, LinkedIn profile optimisation for finance recruiters, 2-3 mock finance interviews including a modelling test simulation, introduction to our network of finance hiring managers in Pune and Mumbai, and 6 months of ongoing job alerts post-completion. For the finance track, we also provide guidance on networking with analysts and associates at target firms — which is often how finance placements happen.
📍 Training Near You
We conduct classroom and online training across Pune and major Indian cities. Click your area to see batch schedules, fees, and availability.
All locations offer live online training. Call 7796731656 for batch availability.
Investment banking, private equity, equity research, corporate finance — every door opens with strong financial modelling skills. Stop reading about it. Start building.