The Department of Management & Commerce, in collaboration with the Internal Quality Assurance Cell (IQAC), is pleased to offer an Online Faculty Development Programme (FDP) on Financial Modeling using Excel VBA, R, and AI Tools.
Programme Details:
- Duration: 15th April 2025 – 30th April 2025 (excluding Sundays & holidays)
- Timings: 6:30 PM – 9:00 PM
- Mode: Online
- Eligibility: Open to faculty members of Business Schools, Colleges, and Universities across India offering MBA, MMS, MS in Finance, M. Com, and related undergraduate courses.
Resource Persons:
- Dr. L. Goverthanan, MS, FCMA
- Dr. Subramanian S. Iyer, MBA, FRM
Objective:
This FDP is designed to enhance the professional skills of faculty members by equipping them with advanced financial modeling techniques. By incorporating Excel VBA, R, and AI tools into their teaching methodologies, educators can create an engaging learning environment that fosters student comprehension and application of financial concepts. The focus will be on practical knowledge transfer to meet the evolving needs of the academic sector.
Expected Outcomes:
Upon completing this course, educators will gain proficiency in financial modeling and revolutionize their teaching techniques by incorporating accessible open-source tools! Tailored for college educators, this Faculty Development Programme is designed to enhance understanding of financial modeling using Excel-VBA, R, and AI. Educators will empower students to easily grasp and master these skills, fostering motivation and engagement in the learning process.
Key Topics Covered:
Excel VBA for Financial Modeling: Custom user-defined functions for financial computations (Income Tax, DCF, PV/FV, Convexity, etc.), Recording Macros and developing reusable financial widgets, creating custom Ribbon Menus for easy navigation, Sensitivity and scenario analysis using VBA.
R for Financial Data Analysis: Fetching live stock data and computing portfolio return and variance. Constructing Markowitz Efficient Frontier and animating in R, Integrating R functions seamlessly with Excel.
AI Tools in Financial Modeling: Building financial dashboards for ratio analysis (Dupont Chart), Corporate Valuation Models, Monte Carlo Simulation for financial risk analysis, Automation of financial models using AI tools in R.
This 14-day FDP is an excellent opportunity for faculty members to refine their skills and stay at the forefront of financial modeling advancements. Join us to revolutionize the way financial concepts are taught and applied!
Register: https://forms.gle/Ya2RzvL5TU17c3q38
Last date to apply: 12 April 2025
