Business risk and simulation modelling in practice : using Excel, VBA and @RISK / / Michael Rees |
Autore | Rees Michael <1964-> |
Edizione | [1st edition] |
Pubbl/distr/stampa | Chichester, England : , : Wiley, , 2015 |
Descrizione fisica | 1 online resource (467 p.) |
Disciplina | 658.15/50285554 |
Collana | Wiley Finance Series |
Soggetto topico |
Risk management - Computer simulation
Risk management - Data processing |
ISBN |
1-118-90404-4
1-118-90403-6 1-118-90402-8 |
Formato | Materiale a stampa |
Livello bibliografico | Monografia |
Lingua di pubblicazione | eng |
Nota di contenuto |
Business Risk and Simulation Modelling in Practice; Contents; Preface; About the Author; About the Website; PART I An Introduction to Risk Assessment - Its Uses, Processes, Approaches, Benefits and Challenges; 1 The Context and Uses of Risk Assessment; 1.1 Risk Assessment Examples; 1.1.1 Everyday Examples of Risk Management; 1.1.2 Prominent Risk Management Failures; 1.2 General Challenges in Decision-Making Processes; 1.2.1 Balancing Intuition with Rationality; 1.2.2 The Presence of Biases; 1.3 Key Drivers of the Need for Formalised Risk Assessment in Business Contexts; 1.3.1 Complexity
1.3.2 Scale 1.3.3 Authority and Responsibility to Identify and Execute Risk-Response Measures; 1.3.4 Corporate Governance Guidelines; 1.3.5 General Organisational Effectiveness and the Creation of Competitive Advantage; 1.3.6 Quantification Requirements; 1.3.7 Reflecting Risk Tolerances in Decisions and in Business Design; 1.4 The Objectives and Uses of General Risk Assessment; 1.4.1 Adapt and Improve the Design and Structure of Plans and Projects; 1.4.2 Achieve Optimal Risk Mitigation within Revised Plans; 1.4.3 Evaluate Projects, Set Targets and Reflect Risk Tolerances in Decision-Making 1.4.4 Manage Projects Effectively 1.4.5 Construct, Select and Optimise Business and Project Portfolios; 1.4.6 Support the Creation of Strategic Options and Corporate Planning; 2 Key Stages of the General Risk Assessment Process; 2.1 Overview of the Process Stages; 2.2 Process Iterations; 2.3 Risk Identification; 2.3.1 The Importance of a Robust Risk Identification Step; 2.3.2 Bringing Structure into the Process; 2.3.3 Distinguishing Variability from Decision Risks; 2.3.4 Distinguishing Business Issues from Risks; 2.3.5 Risk Identification in Quantitative Approaches: Additional Considerations 2.4 Risk Mapping 2.4.1 Key Objectives; 2.4.2 Challenges; 2.5 Risk Prioritisation and Its Potential Criteria; 2.5.1 Inclusion/Exclusion; 2.5.2 Communications Focus; 2.5.3 Commonality and Comparison; 2.5.4 Modelling Reasons; 2.5.5 General Size of Risks, Their Impact and Likelihood; 2.5.6 Influence: Mitigation and Response Measures, and Management Actions; 2.5.7 Optimising Resource Deployment and Implementation Constraints; 2.6 Risk Response: Mitigation and Exploitation; 2.6.1 Reduction; 2.6.2 Exploitation; 2.6.3 Transfer; 2.6.4 Research and Information Gathering; 2.6.5 Diversification 2.7 Project Management and Monitoring 3 Approaches to Risk Assessment and Quantification; 3.1 Informal or Intuitive Approaches; 3.2 Risk Registers without Aggregation; 3.2.1 Qualitative Approaches; 3.2.2 Quantitative Approaches; 3.3 Risk Register with Aggregation (Quantitative); 3.3.1 The Benefits of Aggregation; 3.3.2 Aggregation of Static Values; 3.3.3 Aggregation of Risk-Driven Occurrences and Their Impacts; 3.3.4 Requirements and Differences to Non-Aggregation Approaches; 3.4 Full Risk Modelling; 3.4.1 Quantitative Aggregate Risk Registers as a First Step to Full Models 4 Full Integrated Risk Modelling: Decision-Support Benefits |
Record Nr. | UNINA-9910131583303321 |
Rees Michael <1964-> | ||
Chichester, England : , : Wiley, , 2015 | ||
Materiale a stampa | ||
Lo trovi qui: Univ. Federico II | ||
|
Business risk and simulation modelling in practice : using Excel, VBA and @RISK / / Michael Rees |
Autore | Rees Michael <1964-> |
Edizione | [1st edition] |
Pubbl/distr/stampa | Chichester, England : , : Wiley, , 2015 |
Descrizione fisica | 1 online resource (467 p.) |
Disciplina | 658.15/50285554 |
Collana | Wiley Finance Series |
Soggetto topico |
Risk management - Computer simulation
Risk management - Data processing |
ISBN |
1-118-90404-4
1-118-90403-6 1-118-90402-8 |
Formato | Materiale a stampa |
Livello bibliografico | Monografia |
Lingua di pubblicazione | eng |
Nota di contenuto |
Business Risk and Simulation Modelling in Practice; Contents; Preface; About the Author; About the Website; PART I An Introduction to Risk Assessment - Its Uses, Processes, Approaches, Benefits and Challenges; 1 The Context and Uses of Risk Assessment; 1.1 Risk Assessment Examples; 1.1.1 Everyday Examples of Risk Management; 1.1.2 Prominent Risk Management Failures; 1.2 General Challenges in Decision-Making Processes; 1.2.1 Balancing Intuition with Rationality; 1.2.2 The Presence of Biases; 1.3 Key Drivers of the Need for Formalised Risk Assessment in Business Contexts; 1.3.1 Complexity
1.3.2 Scale 1.3.3 Authority and Responsibility to Identify and Execute Risk-Response Measures; 1.3.4 Corporate Governance Guidelines; 1.3.5 General Organisational Effectiveness and the Creation of Competitive Advantage; 1.3.6 Quantification Requirements; 1.3.7 Reflecting Risk Tolerances in Decisions and in Business Design; 1.4 The Objectives and Uses of General Risk Assessment; 1.4.1 Adapt and Improve the Design and Structure of Plans and Projects; 1.4.2 Achieve Optimal Risk Mitigation within Revised Plans; 1.4.3 Evaluate Projects, Set Targets and Reflect Risk Tolerances in Decision-Making 1.4.4 Manage Projects Effectively 1.4.5 Construct, Select and Optimise Business and Project Portfolios; 1.4.6 Support the Creation of Strategic Options and Corporate Planning; 2 Key Stages of the General Risk Assessment Process; 2.1 Overview of the Process Stages; 2.2 Process Iterations; 2.3 Risk Identification; 2.3.1 The Importance of a Robust Risk Identification Step; 2.3.2 Bringing Structure into the Process; 2.3.3 Distinguishing Variability from Decision Risks; 2.3.4 Distinguishing Business Issues from Risks; 2.3.5 Risk Identification in Quantitative Approaches: Additional Considerations 2.4 Risk Mapping 2.4.1 Key Objectives; 2.4.2 Challenges; 2.5 Risk Prioritisation and Its Potential Criteria; 2.5.1 Inclusion/Exclusion; 2.5.2 Communications Focus; 2.5.3 Commonality and Comparison; 2.5.4 Modelling Reasons; 2.5.5 General Size of Risks, Their Impact and Likelihood; 2.5.6 Influence: Mitigation and Response Measures, and Management Actions; 2.5.7 Optimising Resource Deployment and Implementation Constraints; 2.6 Risk Response: Mitigation and Exploitation; 2.6.1 Reduction; 2.6.2 Exploitation; 2.6.3 Transfer; 2.6.4 Research and Information Gathering; 2.6.5 Diversification 2.7 Project Management and Monitoring 3 Approaches to Risk Assessment and Quantification; 3.1 Informal or Intuitive Approaches; 3.2 Risk Registers without Aggregation; 3.2.1 Qualitative Approaches; 3.2.2 Quantitative Approaches; 3.3 Risk Register with Aggregation (Quantitative); 3.3.1 The Benefits of Aggregation; 3.3.2 Aggregation of Static Values; 3.3.3 Aggregation of Risk-Driven Occurrences and Their Impacts; 3.3.4 Requirements and Differences to Non-Aggregation Approaches; 3.4 Full Risk Modelling; 3.4.1 Quantitative Aggregate Risk Registers as a First Step to Full Models 4 Full Integrated Risk Modelling: Decision-Support Benefits |
Record Nr. | UNINA-9910811213003321 |
Rees Michael <1964-> | ||
Chichester, England : , : Wiley, , 2015 | ||
Materiale a stampa | ||
Lo trovi qui: Univ. Federico II | ||
|
Financial modelling in practice [[electronic resource] ] : a concise guide for intermediate and advanced level / / Michael Rees |
Autore | Rees Michael <1964-> |
Pubbl/distr/stampa | Hoboken, NJ, : Wiley, c2008 |
Descrizione fisica | 1 online resource (294 p.) |
Disciplina | 332.01/51 |
Collana | Wiley finance series |
Soggetto topico |
Finance - Mathematical models
Corporations - Finance - Mathematical models Options (Finance) - Mathematical models |
ISBN |
1-119-99520-5
1-118-37465-7 1-282-54884-0 9786612548840 0-470-74055-8 |
Formato | Materiale a stampa |
Livello bibliografico | Monografia |
Lingua di pubblicazione | eng |
Nota di contenuto | Financial Modelling in Practice; Contents; Background, Objectives and Approach; About the Author; Acknowledgements; 1 Building Blocks: Selected Excel Functions and Tools; 2 Principles of Modelling; 3 Financial Statement, Cash Flow and Valuation Modelling; 4 Risk Modelling; 5 Introduction to Options and Real Options Modelling; 6 VBA for Financial Modelling; Further Reading; Index |
Record Nr. | UNINA-9910139505503321 |
Rees Michael <1964-> | ||
Hoboken, NJ, : Wiley, c2008 | ||
Materiale a stampa | ||
Lo trovi qui: Univ. Federico II | ||
|
Financial modelling in practice : a concise guide for intermediate and advanced level / / Michael Rees |
Autore | Rees Michael <1964-> |
Edizione | [1st ed.] |
Pubbl/distr/stampa | Hoboken, NJ, : Wiley, c2008 |
Descrizione fisica | 1 online resource (294 p.) |
Disciplina | 332.01/51 |
Collana | Wiley finance series |
Soggetto topico |
Finance - Mathematical models
Corporations - Finance - Mathematical models Options (Finance) - Mathematical models |
ISBN |
1-119-99520-5
1-118-37465-7 1-282-54884-0 9786612548840 0-470-74055-8 |
Formato | Materiale a stampa |
Livello bibliografico | Monografia |
Lingua di pubblicazione | eng |
Nota di contenuto | Financial Modelling in Practice; Contents; Background, Objectives and Approach; About the Author; Acknowledgements; 1 Building Blocks: Selected Excel Functions and Tools; 2 Principles of Modelling; 3 Financial Statement, Cash Flow and Valuation Modelling; 4 Risk Modelling; 5 Introduction to Options and Real Options Modelling; 6 VBA for Financial Modelling; Further Reading; Index |
Record Nr. | UNINA-9910820234903321 |
Rees Michael <1964-> | ||
Hoboken, NJ, : Wiley, c2008 | ||
Materiale a stampa | ||
Lo trovi qui: Univ. Federico II | ||
|
Principles of financial modelling : model design and best practices using Excel and VBA / / by Michael Rees |
Autore | Rees Michael <1964-> |
Edizione | [1st edition] |
Pubbl/distr/stampa | Chichester, West Sussex, England : , : Wiley, , 2018 |
Descrizione fisica | 1 online resource (616 pages) : illustrations |
Disciplina | 332.0285554 |
Collana | Wiley Finance Series |
Soggetto topico |
Finance - Mathematical models
Corporations - Finance - Mathematical models Visual Basic for Applications (Computer program language) |
ISBN |
1-118-90400-1
1-118-90394-3 1-118-90393-5 |
Formato | Materiale a stampa |
Livello bibliografico | Monografia |
Lingua di pubblicazione | eng |
Nota di contenuto | Introduction to modelling, core themes and best practices -- Models of models -- Using models in decision support -- Core competencies and best practices : meta-themes -- Model design and planning -- Defining sensitivity and flexibility requirements -- Database versus formulae-driven approaches -- Designing the workbook structure -- Model building, testing and auditing -- Creating transparency: formula structure, flow and format -- Building robust and transparent formulae -- Choosing Excel functions for transparency, flexibility and efficiency -- Dealing with circularity -- Model review, auditing and validation -- Sensitivity and scenario analysis, simulation and optimisation -- Sensitivity and scenario analysis : core techniques -- Using Goalseek and Solver -- Using VBA macros to conduct sensitivity and scenario analyses -- Introduction to simulation and optimisation -- The modelling of risk and uncertainty, and using simulation -- Excel functions and functionality -- Core arithmetic and logical functions -- Array functions and formulae -- Mathematical functions -- Financial functions -- Statistical functions -- Information functions -- Date and time functions -- Text functions and functionality -- Lookup and reference functions -- Filters, database functions and PivotTables -- Selected short-cuts and other features -- Foundations of VBA and macros -- Getting started -- Working with objects and ranges -- Controlling execution -- Writing robust code -- Manipulation and analysis of data sets with VBA -- User-defined functions. |
Record Nr. | UNINA-9910271043903321 |
Rees Michael <1964-> | ||
Chichester, West Sussex, England : , : Wiley, , 2018 | ||
Materiale a stampa | ||
Lo trovi qui: Univ. Federico II | ||
|