FINANCIAL MODELING WITH CRYSTAL BALL AND EXCEL

Financial Modeling with Crystal Ball and Excel 2E provides tools and techniques you to need know to perform spreadsheet simulation, and answers the essential question of why risk analysis is vital to the decision-making process, whatever the problem you are facing in finance and investment. After reviewing the basics, this book covers how to define and refine probability distributions in financial modeling, and exhaustively reviews the concepts behind the simulation modeling process. It discusses simulation controls and analysis of simulation results. Exercises models help you apply risk analysis to such areas as derivative pricing, cost estimation, portfolio allocation and optimization, design analysis, and cash flow analysis. The tools and techniques reviewed are designed to make anyone expert in financial modeling and simulation. They will help you immediately develop essential skills in the areas of areas of valuation, pricing, hedging, trading, risk management, project evaluation and portfolio management. 

Updated look at financial modeling and Monte Carlo simulation with software by Oracle Crystal Ball This revised and updated edition of the bestselling book on financial modeling provides the tools and techniques needed to perform spreadsheet simulation. It answers the essential question of why risk analysis is vital to the decision-making process, for any problem posed in finance and investment. This reliable resource reviews the basics and covers how to define and refine probability distributions in financial modeling, and explores the concepts driving the simulation modeling process. It also discusses simulation controls and analysis of simulation results. The second edition of Financial Modeling with Crystal Ball and Excel contains instructions, theory, and practical example models to help apply risk analysis to such areas as derivative pricing, cost estimation, portfolio allocation and optimization, credit risk, and cash flow analysis. It includes the resources needed to develop essential skills in the areas of valuation, pricing, hedging, trading, risk management, project evaluation, credit risk, and portfolio management. Offers an updated edition of the bestselling book covering the newest version of Oracle Crystal Ball Contains valuable insights on Monte Carlo simulationan essential skill applied by many corporate finance and investment professionals Written by John Charnes, the former finance department chair at the University of Kansas and senior vice president of global portfolio strategies at Bank of America, who is currently President and Chief Data Scientist at Syntelli Solutions, Inc. Risk Analytics and Predictive Intelligence Division (Syntelli RAPID) Engaging and informative, this book is a vital resource designed to help you become more adept at financial modeling and simulation.