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

Video Description

➡ 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: https://www.amazon.in/dp/8195816886?ref_=cm_sw_r_cp_ud_dp_X13KX7DBZEK4FDZ2ATBX ➡ Order my book 'Unlocking Unicorn Secrets' here: https://www.amazon.in/dp/0143461605?ref_=cm_sw_r_cp_ud_dp_2N298HH57745310Z4TAM 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