Risk and Uncertanty, 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, annual financial statements and ratio analysis
Financial functions (NPV, IRR,.), Invesment 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, Cash flow analysis
Investment financing, Financial planning,
Debt and Equity financing options