Syllabus
MS Excel Introduction Functions Random numbers Data tables Advanced functions Goal Seek/ Solver Data Analysis
VBA
Introduction VBA fundamentals Sub procedures Function procedures VBA techniques User Form Advanced User Form
Basic financial application which will be solved by MS Excel and VBA
Basics finance calculationNet present Value, compounding interest
Corporate FinanceCost of CapitalFinancial Statement modelingValuation
Portfolio ModelsVariance-covariance matrixBetas and SMLOptimalizationValue at Risk
Option PricingBinomial option pricingBlack&Sholes
Annotation
This course is aimed to present some financial and business models and to show how they can be developed, solved or simulated using Microsoft Excel and its embedded Visual Basic for Applications (VBA) programming language. After a general short repetition of Excel and basic teaching in VBA, the course covers standard financial models (portfolio models, option pricing, simulation, corporate finance etc.).
The aim of the course is to be a hands-on course with little theory where the students implement what they have studied on previous courses. The course should serve to bridge the gap between financial theory and its implementation.