Part I
Modeling with worksheets: Basic and advanced Microsoft Excel commands, Model-building and model-building tools, Linear Programming (LP), Statistical methods, Decision analysis, Simulation.
Part II
Financial models: Financial statements, Ratio Analysis, Capital budgeting and Decision trees, Cash Flow Analysis.
Investment analysis: Risk preferences and utility modeling with worksheets, Markowitz model and portfolio selection, Duration, Bond volatility
Part III
Corporate finance: Basic capital budgeting analysis for a project to compute NPV, IRR, and ROI, Financial planning and investments, Equity and Debt financing options, Hybrid securities.