NGUYỄN NGỌC BÌNH PHƯƠNG

FINANCIAL MODELING WITH CRYSTAL BALL AND EXCEL

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.

FINANCIAL MODELING WITH CRYSTAL BALL AND EXCEL, 2E
John Charnes
ISBN: 978-1-118-17544-6
Wiley (2012)
Webpage: http://as.wiley.com/WileyCDA/WileyTitle/productCd-1118175441.html

Table of Contents
CHAPTER 1 Introduction
CHAPTER 2 Analyzing Crystal Ball Forecasts
CHAPTER 3 Building A Crystal Ball Model
CHAPTER 4 Selecting Crystal Ball Assumptions
CHAPTER 5 Using Decision Variables
CHAPTER 6 Selecting Run Preferences
CHAPTER 7 Net Present Value and Internal Rate of Return
CHAPTER 8 Modeling Financial Statements
CHAPTER 9 Portfolio Models
CHAPTER 10 Value at Risk
CHAPTER 11 Simulating Financial Time Series
CHAPTER 12 Financial Options
CHAPTER 13 Real Options
CHAPTER 14 Credit Risk
CHAPTER 15 Construction Project Management
CHAPTER 16 Oil and Gas Exploration

CRYSTAL BALL 11.1.2.2.0

October 10, 2016
Nguyễn Ngọc Bình Phương 2018