COMPLETE Financial Modeling Masterclass 2025! | Ft. Peeyush Chitlangia | KwK #202

➡ Recommend A Guest For Our Podcast Here – https://forms.gle/eotmhzWMx6KpJQH86

➡ Join This Group To Be Invited To Future Offline KwK Events in Mumbai: https://chat.whatsapp.com/F3MbHDPwTwC…

In this value-packed episode, we are joined with Peeyush Chitlangia from @FinShiksha to give a practical walkthrough of how financial modeling works — from forecasting Maruti Suzuki’s revenue to linking balance sheets, P&L, and cash flow statements. Learn how to source real data, make correct assumptions, and use Excel to model company performance and valuation.

The conversation also sheds light on how financial modeling acts as a non-negotiable skill for roles in equity research, PE/VC, and investment banking, and how professionals from diverse backgrounds (CAs, MBAs, engineers) can master it and command top salaries. From job market realities to projection techniques, this is a must-watch for every finance aspirant.

👉 Don’t forget to subscribe for more such expert-led discussions on finance, careers, and investing.

#FinanceJobs #ModelingSkills #ExcelForFinance #InvestmentCareers

➡ Order my book ‘Acing CA’ here:

➡ Order my book ‘Unlocking Unicorn Secrets’ here:

Follow Kushal Lodha on Social Media:
📝 LinkedIn: https://in.linkedin.com/in/kushallodha548
📷 Instagram: https://www.instagram.com/kushallodha548/
📱 Twitter: https://twitter.com/kushallodha548

Follow KAGR Club on Social Media:
📝 LinkedIn: https://www.linkedin.com/company/kagr-club/
📷 Instagram: https://www.instagram.com/kagrclub/

FinShiksha YouTube: @FinShiksha

FinShikshaWebsite: https://finshiksha.com/

Learn Financial Modeling and Equity Valuation in detail: https://finshiksha.com/courses/equity-valuation-certification/

Timestamp:
00:00 Intro
02:05 Financial modeling and its importance
04:55 What’s the average package in financial modeling?
09:40 How a financial model is created
11:41 Maruti financial data model example
25:14 How to predict future revenue
44:45 5-year revenue projection of Maruti
56:25 How the range affects future revenue
1:10:19 How to calculate the valuation of a company
1:18:29 What is capital work in progress?
1:30:00 Why does a company borrow?
1:59:53 Common mistakes in a balance sheet
2:07:51 India automobile statistics
2:30:49 Cash flow statement of Maruti
2:52:48 College incident during financial modeling classes
2:54:20 Want to learn financial modeling in depth?

#kushallodha

source