The PGDM – Retail Management Department (Trimester II, Batch 2025–2027) at Jagan Institute of Management Studies (JIMS), Rohini organized an intensive three-hour hands-on workshop on “Financial Decision Making: A Workshop on Time Value of Money (TVM) & Project Evaluation” on 13th December 2025 (Saturday).
The session was conducted by Mr. Jatin Kalra, Alumni PGDM (2015 - 2017), Assistant Manager at KPMG Global Services (KGS) and an esteemed alumnus of JIMS Rohini, Sector 5. The workshop was designed to bridge the gap between theoretical financial concepts and their practical application in real-world corporate decision-making, with a strong focus on Excel-based financial analysis.
Mr. Kalra provided students with practical exposure to core Financial Management tools widely used in corporate finance and consulting roles. The session began with a comprehensive explanation of Time Value of Money (TVM) concepts using Excel, including Present Value, Future Value, multi-period compounding and decompounding, annuities, annuity due, and uneven cash flows. Each concept was demonstrated through Excel formulas, enabling students to develop both conceptual clarity and technical proficiency.
The workshop further progressed into an in-depth discussion on capital budgeting and project evaluation techniques, such as Net Present Value (NPV), Profitability Index (PI), Internal Rate of Return (IRR), Modified IRR (MIRR), and Discounted Payback Period. Students actively practiced multiple numerical problems in Excel, reinforcing learning through hands-on problem-solving and real-time application.
Throughout the session, Mr. Kalra remained highly approachable, addressing academic queries and sharing valuable insights into career opportunities in finance, consulting, and analytics domains. His industry perspectives helped students understand how financial models support strategic investment and business decisions in organizations.
Key Takeaways
- Understanding the practical relevance of TVM concepts in corporate finance
- Hands-on exposure to Excel-based financial modeling and analysis
- Application of capital budgeting tools for project evaluation and investment decisions
- Importance of combining strong conceptual clarity with Excel proficiency
- Insights into finance-related career paths and industry expectations
The workshop successfully reinforced the importance of applied financial skills and highlighted how Excel-driven financial analysis plays a critical role in modern corporate environments. The session aligned well with JIMS Rohini’s objective of equipping students with industry-relevant, career-ready competencies.