Risk and Uncertainty, Model Building, Search functions
If function and nested if functions, Goal seek
Statistical functions, Vector and matrix functions
Linear programming: mathematical settings, applications to management problems
Probability spaces, Conditional probability, independence
Random variables, Probability distribution and Distribution functions
Regression, Simulation, Expectation and variance, Bayes Rule,
Decision trees, Maximx, maximin and minimax, Financial functions (NPV, IRR,.), Investment analysis (choice of projects)
Financial portfolio management, Variance and covariance of returns, case study: Barney Briggs
Portfolio management, efficient frontier, Excel solver
Capital Budgeting with scenario trees, Investment financing, Debt and Equity financing options