Testimonials

Services

Video meeting . 20 mins
₹1,800₹2,800
Video meeting . 30 mins
5
₹2,800₹4,300
Video meeting . 5 mins
FREE
Video meeting . 15 mins
5
₹1,099₹1,800
Popular
Priority DM . 2 days reply
₹100
Popular

About me

A Chartered Accountant by profession and a Passionate Educator, Pranav has trained >20000 Students, Working Professionals, Entrepreneurs and CXOs in building skillsets giving them an edge over their competition in the Corporate World. Pranav’s forte lies in Advanced Financial Modelling, Corporate Finance and Advanced Microsoft Excel. Apart from this, Pranav is a Content Creator with a niche in Productivity, Self-Improvement and Career-Focussed Content. He is also an ardent Music Lover. Pranav takes Guest Lectures and Speaker Sessions at various colleges and universities. With a Cohesive mix of Corporate Experience and a Trainer mindset, Pranav looks forward to partaking his experience with learners.

Frequently asked questions

What is financial modelling and valuation?

Financial modelling is the process of building a spreadsheet representation of a company's finances — usually its income statement, balance sheet and cash flow — to forecast performance and test business decisions. Valuation then uses that model to estimate what the business is worth through methods like DCF, comparable companies and precedent transactions. Together, these are core skills for investment banking, equity research, FP&A and startup fundraising roles.

What is a financial modelling course, and how do I choose the right one in India?

A financial modelling course teaches you to build complete models in Excel — historical statements, assumptions, forecasts, ratios and valuation — usually through case studies on real companies. When comparing financial modelling courses, check for live sessions, real-company case studies, Excel templates, doubt-solving support and a certificate employers actually recognise. Freshers from B.Com, CA, CFA, MBA or engineering backgrounds benefit most from hands-on, case-study-driven training rather than theory-heavy videos.

How to learn financial modelling from scratch?

Build three foundations first: basic accounting (how the three financial statements link), Excel fundamentals and everyday business logic. Then follow a structured sequence — rebuild a model for one listed company step by step (historicals → assumptions → forecasts → valuation), practise with real annual reports, and get your models reviewed by a mentor or peer group. With consistent practice, most learners become job-ready in two to six months.

How to do financial modelling for a company step by step?

Start by defining the model's purpose — forecast, valuation, fundraising or credit analysis. Next, collect three to five years of historical financials, set assumptions for growth, margins and working capital, link the three statements, build the forecast and calculate free cash flows. Apply valuation methods like DCF or comparables, and finish with sensitivity analysis and sanity checks so your numbers survive scrutiny.

What are financial modelling courses fees in India?

Financial modelling courses fees in India typically range from ₹10,000 to ₹60,000. Short self-paced programmes sit at the lower end, while comprehensive live programmes with case studies, templates, mentor feedback and placement support cost more. Compare what's included rather than price alone — live teaching and doubt-solving usually justify a higher fee far better than a certificate by itself.

Are there financial modelling courses free with certificate in India?

Yes. Government platforms like NPTEL and SWAYAM offer introductory courses where the learning content is free with an optional certificate for a small exam fee, and global MOOC platforms run financial modelling courses free with certificate through audit tracks and financial aid. Free options are ideal for testing your interest, but they rarely go beyond basics — job-ready skill needs real company models and personal feedback, which structured paid programmes provide.

Is financial modelling a good career in India?

Yes — demand is steady across investment banking, equity research, FP&A, credit analysis, Big 4 valuation teams and startup finance. Financial modelling jobs in India reward demonstrable skill over pedigree: if you can build a clean three-statement model and defend your assumptions in an interview, you can compete regardless of your college tag. If you're unsure which path suits your background, a 1:1 career-guidance session with a finance mentor can save you months of guesswork.

What is a corporate finance job and what does it involve?

A corporate finance job means managing a company's own funds — planning, raising and deploying money to grow the business. Day-to-day work includes budgeting and forecasting, working-capital management, evaluating new projects, arranging debt or equity funding and investor reporting. Common roles include FP&A analyst, treasury analyst, finance manager and CFO-track positions, and strong Excel and modelling skills are expected from day one.

What is the Corporate Finance Institute (CFI) and is it worth it?

The Corporate Finance Institute (CFI) is a global online training platform for financial modelling, valuation, Excel and banking skills, best known for its FMVA certification. Corporate Finance Institute free courses on Excel and finance fundamentals are a low-risk way to judge the teaching style before you pay. It's worth it if you want self-paced, internationally recognised credentials — many Indian learners combine it with live mentoring and India-specific case studies for better results.

Which corporate finance books should I read to build strong fundamentals?

Start with "Principles of Corporate Finance" by Brealey, Myers and Allen, or the simpler "Fundamentals of Corporate Finance" by Ross, Westerfield and Jordan, for core ideas like time value of money, capital budgeting and capital structure. Add Aswath Damodaran's valuation books for practical frameworks and Simon Benninga's "Financial Modeling" to connect theory with Excel. Work through one book fully with solved examples instead of skimming several.

What are advanced Excel skills that employers look for?

Advanced Excel skills go beyond basic formulas: XLOOKUP and INDEX-MATCH, SUMIFS and COUNTIFS, nested IFs with IFERROR, pivot tables, Power Query for data cleaning, What-If analysis and data tables, dashboards, conditional formatting and basic macros/VBA. In finance hiring, employers test whether you can apply these quickly and error-free inside a model, so practise on raw datasets instead of only watching tutorials.

What are advanced Excel course fees in India?

Advanced Excel course fees in India vary widely: self-paced online courses often cost ₹500–₹5,000, live online batches usually ₹5,000–₹15,000, and classroom programmes in metro cities can cross ₹20,000. Check what the fee covers — practice files, business case studies, doubt-solving access and certification matter more than the price. If budget is tight, start with free resources and upgrade to a paid programme once you're consistent.

Which advanced Excel formulas should every finance professional know?

Master XLOOKUP (or INDEX-MATCH) for lookups, SUMIFS and COUNTIFS for conditional totals, IFERROR for clean outputs, and date and text functions like EOMONTH and TEXT. For finance work specifically, add NPV, IRR, XNPV, XIRR, PMT for loan schedules, and CHOOSE with data tables for scenario analysis. Practise combining these inside a live financial model, because that is exactly how interviews and real jobs test you.

How to learn Microsoft Excel for free?

Use Microsoft's free documentation and templates, YouTube tutorials, and free courses on platforms like NPTEL and Microsoft Learn, then practise by rebuilding everything yourself on sample datasets — an expense tracker or sales dashboard is a good first project. Once the basics are solid, you can even take an advanced Excel course online free of cost through SWAYAM or free trial modules before paying for certification. Consistent daily practice matters more than any single course.

What questions are asked in a financial modelling interview?

Expect a mix of concepts and hands-on work: how the three financial statements link, how a change in depreciation flows through the statements, which valuation method you'd use for a given company, and live Excel tasks like building a quick revenue forecast or DCF. Many interviewers also ask you to present a model you've built, so keep one real-company model ready, know every assumption in it, and practise explaining your logic out loud in under five minutes.