Info
- Utilizzare la checkbox di selezione a fianco di ciascun documento per attivare le funzionalità di stampa, invio email, download nei formati disponibili del (i) record.
Financial Modeling with Crystal Ball and Excel [[electronic resource]]
| Financial Modeling with Crystal Ball and Excel [[electronic resource]] |
| Autore | Charnes John |
| Edizione | [2nd ed.] |
| Pubbl/distr/stampa | New York, : Wiley, 2012 |
| Descrizione fisica | 1 online resource (336 p.) |
| Disciplina |
332.0113
332.0285/554 332.0285554 |
| Collana | Wiley Finance |
| Soggetto topico |
BUSINESS & ECONOMICS / Investments & Securities
Finance -- Mathematical models Microsoft Excel (Computer file) Finance - Mathematical models Investments - Mathematical models |
| ISBN |
1-119-20321-X
1-280-59278-8 9786613622617 1-118-22705-0 |
| Classificazione | BUS036000 |
| Formato | Materiale a stampa  |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Nota di contenuto |
Financial Modeling with Crystal Ball and Excel; Contents; Preface; Acknowledgments; About the Author; CHAPTER 1 Introduction; 1.1 FINANCIAL MODELING; 1.2 RISK ANALYSIS; 1.3 MONTE CARLO SIMULATION; 1.4 RISK MANAGEMENT; 1.5 BENEFITS AND LIMITATIONS OF USING CRYSTAL BALL; 1.5.1 Benefits; 1.5.2 Limitations; CHAPTER 2 Analyzing Crystal Ball Forecasts; 2.1 SIMULATING A 50-50 PORTFOLIO; 2.1.1 Accumulate.xls; 2.1.2 Frequency Chart; 2.1.3 Cumulative Frequency Chart; 2.1.4 Statistics View; 2.1.5 Forecast Window Percentiles View; 2.2 VARYING THE ALLOCATIONS; 2.2.1 Decision Table Tool; 2.2.2 Trend Chart
2.2.3 Overlay Chart 2.3 PRESENTING THE RESULTS; CHAPTER 3 Building A Crystal Ball Model; 3.1 SIMULATION MODELING PROCESS; 3.1.1 Example: AKGolf.xls; 3.2 DEFINING CRYSTAL BALL ASSUMPTIONS AND FORECASTS; 3.2.1 Defining Assumptions; 3.2.2 Defining Profit as a Forecast Cell; 3.3 RUNNING CRYSTAL BALL; 3.4 SOURCES OF ERROR; 3.5 CONTROLLING MODEL ERROR; CHAPTER 4 Selecting Crystal Ball Assumptions; 4.1 CRYSTAL BALL'S BASIC DISTRIBUTIONS; 4.1.1 Yes-No; 4.1.2 Binomial; 4.1.3 Discrete Uniform; 4.1.4 Uniform; 4.1.5 Triangular; 4.1.6 Normal; 4.1.7 Lognormal 4.2 USING HISTORICAL DATA TO CHOOSE DISTRIBUTIONS 4.2.1 Direct Sampling; 4.2.2 Sampling from a Fitted Distribution; 4.2.3 Fitting Distributions to Data; 4.2.4 Goodness-of-Fit Testing; 4.2.5 Eyeball Test; 4.2.6 Caveats; 4.2.7 What If No Historical Data Are Available?; 4.3 SPECIFYING CORRELATIONS; 4.3.1 Pearson Correlation Statistic; 4.3.2 Spearman (Rank) Correlation Statistic; 4.3.3 Using Crystal Ball to Calculate Correlations Between Two Assumptions; 4.3.4 Batch Fit; 4.3.5 Correlation Tool; CHAPTER 5 Using Decision Variables; 5.1 DEFINING DECISION VARIABLES 5.2 DECISION TABLE WITH ONE DECISION VARIABLE 5.2.1 Trend Chart; 5.2.2 Overlay Chart; 5.3 DECISION TABLE WITH TWO DECISION VARIABLES; 5.3.1 Model; 5.3.2 Threshold Values; 5.3.3 Two-Way Decision Table; 5.3.4 Interpreting the Results; 5.4 USING OPTQUEST; 5.4.1 Terminology; 5.4.2 Example; CHAPTER 6 Selecting Run Preferences; 6.1 TRIALS; 6.1.1 Number of Trials to Run; 6.1.2 Stop on Calculation Errors; 6.1.3 Stop When Precision Control Limits Are Reached; 6.2 SAMPLING; 6.2.1 Random Number Generation; 6.2.2 Sampling Method; 6.3 SPEED; 6.3.1 Run Mode; 6.3.2 Chart Windows; 6.4 OPTIONS; 6.5 STATISTICS CHAPTER 7 Net Present Value and Internal Rate of Return 7.1 DETERMINISTIC NPV AND IRR; 7.2 SIMULATING NPV AND IRR; 7.3 CAPITAL BUDGETING; 7.3.1 Tornado Chart Tool; 7.3.2 Risk Analysis; 7.3.3 Caveats; 7.4 CUSTOMER NET PRESENT VALUE; 7.4.1 Results; CHAPTER 8 Modeling Financial Statements; 8.1 DETERMINISTIC MODEL; 8.2 TORNADO CHART AND SENSITIVITY ANALYSIS; 8.3 CRYSTAL BALL SENSITIVITY CHART; 8.4 CONCLUSION; CHAPTER 9 Portfolio Models; 9.1 SINGLE-PERIOD CRYSTAL BALL MODEL; 9.2 SINGLE-PERIOD ANALYTICAL SOLUTION; 9.3 MULTI-PERIOD CRYSTAL BALL MODEL; CHAPTER 10 Value at Risk; 10.1 VAR 10.2 SHORTCOMINGS OF VAR |
| Record Nr. | UNINA-9910141251103321 |
Charnes John
|
||
| New York, : Wiley, 2012 | ||
| Materiale a stampa | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
Financial Modeling with Crystal Ball and Excel
| Financial Modeling with Crystal Ball and Excel |
| Autore | Charnes John |
| Edizione | [2nd ed.] |
| Pubbl/distr/stampa | New York, : Wiley, 2012 |
| Descrizione fisica | 1 online resource (336 p.) |
| Disciplina |
332.0113
332.0285/554 332.0285554 |
| Collana | Wiley Finance |
| Soggetto topico |
BUSINESS & ECONOMICS / Investments & Securities
Finance -- Mathematical models Microsoft Excel (Computer file) Finance - Mathematical models Investments - Mathematical models |
| ISBN |
1-119-20321-X
1-280-59278-8 9786613622617 1-118-22705-0 |
| Classificazione | BUS036000 |
| Formato | Materiale a stampa |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Nota di contenuto |
Financial Modeling with Crystal Ball and Excel; Contents; Preface; Acknowledgments; About the Author; CHAPTER 1 Introduction; 1.1 FINANCIAL MODELING; 1.2 RISK ANALYSIS; 1.3 MONTE CARLO SIMULATION; 1.4 RISK MANAGEMENT; 1.5 BENEFITS AND LIMITATIONS OF USING CRYSTAL BALL; 1.5.1 Benefits; 1.5.2 Limitations; CHAPTER 2 Analyzing Crystal Ball Forecasts; 2.1 SIMULATING A 50-50 PORTFOLIO; 2.1.1 Accumulate.xls; 2.1.2 Frequency Chart; 2.1.3 Cumulative Frequency Chart; 2.1.4 Statistics View; 2.1.5 Forecast Window Percentiles View; 2.2 VARYING THE ALLOCATIONS; 2.2.1 Decision Table Tool; 2.2.2 Trend Chart
2.2.3 Overlay Chart 2.3 PRESENTING THE RESULTS; CHAPTER 3 Building A Crystal Ball Model; 3.1 SIMULATION MODELING PROCESS; 3.1.1 Example: AKGolf.xls; 3.2 DEFINING CRYSTAL BALL ASSUMPTIONS AND FORECASTS; 3.2.1 Defining Assumptions; 3.2.2 Defining Profit as a Forecast Cell; 3.3 RUNNING CRYSTAL BALL; 3.4 SOURCES OF ERROR; 3.5 CONTROLLING MODEL ERROR; CHAPTER 4 Selecting Crystal Ball Assumptions; 4.1 CRYSTAL BALL'S BASIC DISTRIBUTIONS; 4.1.1 Yes-No; 4.1.2 Binomial; 4.1.3 Discrete Uniform; 4.1.4 Uniform; 4.1.5 Triangular; 4.1.6 Normal; 4.1.7 Lognormal 4.2 USING HISTORICAL DATA TO CHOOSE DISTRIBUTIONS 4.2.1 Direct Sampling; 4.2.2 Sampling from a Fitted Distribution; 4.2.3 Fitting Distributions to Data; 4.2.4 Goodness-of-Fit Testing; 4.2.5 Eyeball Test; 4.2.6 Caveats; 4.2.7 What If No Historical Data Are Available?; 4.3 SPECIFYING CORRELATIONS; 4.3.1 Pearson Correlation Statistic; 4.3.2 Spearman (Rank) Correlation Statistic; 4.3.3 Using Crystal Ball to Calculate Correlations Between Two Assumptions; 4.3.4 Batch Fit; 4.3.5 Correlation Tool; CHAPTER 5 Using Decision Variables; 5.1 DEFINING DECISION VARIABLES 5.2 DECISION TABLE WITH ONE DECISION VARIABLE 5.2.1 Trend Chart; 5.2.2 Overlay Chart; 5.3 DECISION TABLE WITH TWO DECISION VARIABLES; 5.3.1 Model; 5.3.2 Threshold Values; 5.3.3 Two-Way Decision Table; 5.3.4 Interpreting the Results; 5.4 USING OPTQUEST; 5.4.1 Terminology; 5.4.2 Example; CHAPTER 6 Selecting Run Preferences; 6.1 TRIALS; 6.1.1 Number of Trials to Run; 6.1.2 Stop on Calculation Errors; 6.1.3 Stop When Precision Control Limits Are Reached; 6.2 SAMPLING; 6.2.1 Random Number Generation; 6.2.2 Sampling Method; 6.3 SPEED; 6.3.1 Run Mode; 6.3.2 Chart Windows; 6.4 OPTIONS; 6.5 STATISTICS CHAPTER 7 Net Present Value and Internal Rate of Return 7.1 DETERMINISTIC NPV AND IRR; 7.2 SIMULATING NPV AND IRR; 7.3 CAPITAL BUDGETING; 7.3.1 Tornado Chart Tool; 7.3.2 Risk Analysis; 7.3.3 Caveats; 7.4 CUSTOMER NET PRESENT VALUE; 7.4.1 Results; CHAPTER 8 Modeling Financial Statements; 8.1 DETERMINISTIC MODEL; 8.2 TORNADO CHART AND SENSITIVITY ANALYSIS; 8.3 CRYSTAL BALL SENSITIVITY CHART; 8.4 CONCLUSION; CHAPTER 9 Portfolio Models; 9.1 SINGLE-PERIOD CRYSTAL BALL MODEL; 9.2 SINGLE-PERIOD ANALYTICAL SOLUTION; 9.3 MULTI-PERIOD CRYSTAL BALL MODEL; CHAPTER 10 Value at Risk; 10.1 VAR 10.2 SHORTCOMINGS OF VAR |
| Altri titoli varianti | Financial modeling with Oracle Crystal Ball and Excel + website |
| Record Nr. | UNINA-9910816079703321 |
|
Charnes John
|
||
| New York, : Wiley, 2012 | ||
| Materiale a stampa | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
Structured finance modeling with object-oriented VBA [[electronic resource] /] / Evan Tick
| Structured finance modeling with object-oriented VBA [[electronic resource] /] / Evan Tick |
| Autore | Tick Evan <1959-> |
| Edizione | [1st edition] |
| Pubbl/distr/stampa | Hoboken, N.J., : John Wiley & Sons, Inc., c2007 |
| Descrizione fisica | 1 online resource (354 p.) |
| Disciplina | 332.0113 |
| Collana | Wiley finance series |
| Soggetto topico |
Finance - Mathematical models
Investments - Mathematical models |
| ISBN |
1-118-16066-5
1-119-19668-X 1-280-83928-7 9786610839285 0-470-13041-5 |
| Formato | Materiale a stampa |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Nota di contenuto | Structured Finance Modeling with Object-Oriented VBA; Contents; Preface; List of Acronyms; Acknowledgments; About the Author; Chapter 1: Cash-Flow Structures; Chapter 2: Modeling; Chapter 3: Assets; Chapter 4: Liabilities; Chapter 5: Sizing the Structure; Chapter 6: Analysis; Chapter 7: Stochastic Models; Appendix A: Excel and VBA; Appendix B: Bond Math; References; Index |
| Record Nr. | UNINA-9910143718503321 |
|
Tick Evan <1959->
|
||
| Hoboken, N.J., : John Wiley & Sons, Inc., c2007 | ||
| Materiale a stampa | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
Structured finance modeling with object-oriented VBA [[electronic resource] /] / Evan Tick
| Structured finance modeling with object-oriented VBA [[electronic resource] /] / Evan Tick |
| Autore | Tick Evan <1959-> |
| Edizione | [1st edition] |
| Pubbl/distr/stampa | Hoboken, N.J., : John Wiley & Sons, Inc., c2007 |
| Descrizione fisica | 1 online resource (354 p.) |
| Disciplina | 332.0113 |
| Collana | Wiley finance series |
| Soggetto topico |
Finance - Mathematical models
Investments - Mathematical models |
| ISBN |
1-118-16066-5
1-119-19668-X 1-280-83928-7 9786610839285 0-470-13041-5 |
| Formato | Materiale a stampa |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Nota di contenuto | Structured Finance Modeling with Object-Oriented VBA; Contents; Preface; List of Acronyms; Acknowledgments; About the Author; Chapter 1: Cash-Flow Structures; Chapter 2: Modeling; Chapter 3: Assets; Chapter 4: Liabilities; Chapter 5: Sizing the Structure; Chapter 6: Analysis; Chapter 7: Stochastic Models; Appendix A: Excel and VBA; Appendix B: Bond Math; References; Index |
| Record Nr. | UNINA-9910830334803321 |
|
Tick Evan <1959->
|
||
| Hoboken, N.J., : John Wiley & Sons, Inc., c2007 | ||
| Materiale a stampa | ||
| Lo trovi qui: Univ. Federico II | ||
| ||