Portfolio Tools & Techniques: Financial Management and Decision Support: Spreadsheet Models

Workshop Overview  

Spreadsheets are instrumental in modeling optimization problems, particularly those laden with inherent complexities such as uncertainty and multi-dimensionality. The model itself is not dependent of such tool in as much as the means for solution which is iterative in nature posing in turn a question of limitation that still accommodates most managerial problems. The structure of the portfolio management problem lends itself perfectly for electronic spreadsheets due to the common tabular structure as well as the report-formation format required and furnished. This course capitalizes on the aforementioned in order to deliver a state-of-the-art decision making for portfolio management, particularly for the selection of projects/investments. 
Learning Objectives

  • Formulate portfolio inclusion problems in a requisite manner.
  • Solve such problems without much logistic, cost, or temporal overhead.
  • Understand the underlying complexities of portfolio decision making.
  • Incorporate any decision with the right amount of precision/assumptions.
  • Conduct sensitivity analysis to further extend future-proofing the decision.
  • Resolve conflicting decisions in portfolio to reach an optimal solution. 

Workshop Outline  

  • Introducing the complexity of portfolio decision problems
    • Real-world problems and complexity
    • Trade-offs and simplifying assumptions
    • Computational costs and infrastructure
  • The respective structures of the problem and the electronic sheets  
    • Relational structure represented in tables
    • The spreadsheet four-area values environment
  • Introduction to spreadsheet tools
    • Reference
    • Functions
    • Add-ins
    • Pivot tables
    • Preliminary dashboards 
  • Quantitative selection models applied to spreadsheets
    • Feasibility problems
    • Scoring problems
    • Prescriptive problems
    • Predictive problems 
  • Linear programming as an origin to portfolio management solution
    • The constrained nature of resources
    • The demanding nature of portfolio objectives
    • The urgent nature of decision variables
    • The parametric quest 
  • The use of spreadsheets in solving Linear Programming problems and nonlinear problems
    • Simple scheduling problem
    • Capital budgeting for projects
    • Project selection problems
    • Investments aggregation problems
    • Project selection as total and partial investments
    • Financial resourcing and funding solutions 
  • Sensitivity reports and analysis
    • Future-proofing decisions
    • Risk on parametric changes
    • Sensitivity maps and reports
    • Reports analysis
  • Peripheral problems and solutions
    • Resources management
    • Network problems 
  • Conflicting Goals and Multiple Objectives
    • Goal programming
    • Multi-objective optimization 

Course Duration

24 hours  
Workshop format

Interactive sessions matched with exercises, mini-cases and discussions. 
Intended audience

Decision makers, Portfolio managers, Risk managers, Business analysts, General Managers, Strategic PMO consultants, Functional managers. 


Click Here to Apply