✔ 100% Money-Back Guarantee on Eligible Items
✔ Prices Displayed in Your Local Currency
✔ Final Price = No Surprise Import Fees
✔ Complimentary Insured Worldwide Shipping on Qualifying Orders
✔ Select Collector & Specialty Pieces May Require Secured Delivery Handling
by John Charnes (Author)
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 simulation--an 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.
Front Jacket
Praise for the previous edition
Professor Charnes's book drives clarity into applied Monte Carlo analysis using examples and tools relevant to real-world finance. The book will prove useful for analysts of all levels and as a supplement to academic courses in multiple disciplines.
--Mark Odermann, Senior Financial Analyst, Microsoft
Think you really know financial modeling? This is a must-have for power Excel users. Professor Charnes shows how to make more realistic models that result in fewer surprises. Every analyst needs this credibility booster.
--James Franklin, CEO, SendGrid
This book packs a first-year MBA's worth of financial and business modeling education into a few dozen easy-to-understand examples. Crystal Ball software does the housekeeping, so readers can concentrate on the business decision. A careful reader who works the examples on a computer will master the best general-purpose technology available for working with uncertainty.
--Aaron Brown, Risk Manager, AQR Capital Management, and author of The Poker Face of Wall Street and Red-Blooded Risk
Using Crystal Ball and Excel, John Charnes takes you step by step, demonstrating a conceptual framework that turns static Excel data and financial models into true risk models. I am astonished by the clarity of the text and the hands-on, step-by-step examples using Crystal Ball and Excel; Professor Charnes is a masterful teacher, and this is an absolute gem of a book for the new generation of analyst.
--Brian Watt, Chief Operating Officer, GECC, Inc.
Financial Modeling with Crystal Ball and Excel is a comprehensive, well-written guide to one of the most useful analysis tools available to professional risk managers and quantitative analysts. This is a must-have book for anyone using Crystal Ball, and anyone wanting an overview of basic risk management concepts.
--Paul Dietz, Manager, Quantitative Analysis, Westar Energy
John Charnes presents an insightful exploration of techniques for analysis and understanding of risk and uncertainty in business cases. By application of real options theory and Monte Carlo simulation to planning, doors are opened to analysis of what used to be impossible, such as modeling the value today of future project choices.
--Bruce Wallace, former Director of Technology Strategy and Investments, Nortel
The Second Edition of Financial Modeling with Oracle(R) Crystal Ball and Excel(R)+ Website puts an emphasis on practical application. To that end, this book provides readers with exclusive access to a companion website filled with supplementary materials, allowing you to continue to learn in a hands-on fashion long after closing the book.
Back Jacket
Praise for the previous edition
"Professor Charnes's book drives clarity into applied Monte Carlo analysis using examples and tools relevant to real-world finance. The book will prove useful for analysts of all levels and as a supplement to academic courses in multiple disciplines."
--Mark Odermann, Senior Financial Analyst, Microsoft
"Think you really know financial modeling? This is a must-have for power Excel users. Professor Charnes shows how to make more realistic models that result in fewer surprises. Every analyst needs this credibility booster."
--James Franklin, CEO, SendGrid
"This book packs a first-year MBA's worth of financial and business modeling education into a few dozen easy-to-understand examples. Crystal Ball software does the housekeeping, so readers can concentrate on the business decision. A careful reader who works the examples on a computer will master the best general-purpose technology available for working with uncertainty."
--Aaron Brown, Risk Manager, AQR Capital Management, and author of The Poker Face of Wall Street and Red-Blooded Risk
"Using Crystal Ball and Excel, John Charnes takes you step by step, demonstrating a conceptual framework that turns static Excel data and financial models into true risk models. I am astonished by the clarity of the text and the hands-on, step-by-step examples using Crystal Ball and Excel; Professor Charnes is a masterful teacher, and this is an absolute gem of a book for the new generation of analyst."
--Brian Watt, Chief Operating Officer, GECC, Inc.
"Financial Modeling with Crystal Ball and Excel is a comprehensive, well-written guide to one of the most useful analysis tools available to professional risk managers and quantitative analysts. This is a must-have book for anyone using Crystal Ball, and anyone wanting an overview of basic risk management concepts."
--Paul Dietz, Manager, Quantitative Analysis, Westar Energy
"John Charnes presents an insightful exploration of techniques for analysis and understanding of risk and uncertainty in business cases. By application of real options theory and Monte Carlo simulation to planning, doors are opened to analysis of what used to be impossible, such as modeling the value today of future project choices."
--Bruce Wallace, former Director of Technology Strategy and Investments, Nortel
The Second Edition of Financial Modeling with Oracle(R) Crystal Ball and Excel(R)+ Website puts an emphasis on practical application. To that end, this book provides readers with exclusive access to a companion website filled with supplementary materials, allowing you to continue to learn in a hands-on fashion long after closing the book.
Author Biography
John Charnes, PhD, MBA, is President of the Risk Analytics and Predictive Intelligence Division (RAPID) of Syntelli Solutions Inc. Prior to this, he was finance department chair at the University of Kansas and senior vice president of global portfolio strategies at Bank of America. Charnes created the Crystal Ball Training CD, a multimedia course on the basic elements of stochastic modeling with Crystal Ball, acquired by Oracle. His specialty is the application of computer simulation and statistical methods for identifying and solving business problems, including the use of simulation for option pricing and hedging with derivatives to comply with Financial Accounting Standard (FAS) 133.
- In stock, ready to ship
- ✔ Authenticity Guaranteed — Verified Designer Goods
- ✔ Sourced from Authorized European/U.S. Luxury Distributors
- ✔ Secure Checkout — SSL Encrypted Payments
- ✔ Fast Global Delivery — 3–11 Business Days
- ✔ Easy Returns on Eligible Items
- ✔ 100% Money-Back Guarantee — Full Refund if Not Satisfied
AUTHENTICITY GUARANTEED
Reserved for you — complete your purchase to secure this piece.
OFFICIALLY AUTHORIZED RESELLER
Discover Officially Authorized Authentic Items at STORE7994.com - Certificates Available on Request!
Independently verified for store quality and customer safety.
Trust score: 91/100
All designer items offered by STORE 7994 are sourced from trusted luxury distributors and verified through independent authentication services.
Learn how STORE 7994 authenticates luxury items
Guaranteed Authentic — Includes Brand Documentation & Third-Party Verification Options.
Shipping information
- Free Shipping* on all orders over $300 USD to most countries* Estimated delivery: 2-5 business days Mon-Sat to U.S., CA, EU etc.
- Tracking available: DHL Express
- Store 7994 Shipping policy
- Global delivery in 3–9 business days (location dependent).
- Free Worldwide Shipping $300+. International duties & VAT are calculated by destination country and may be collected upon delivery. UK orders are subject to 20% import VAT upon delivery.

Our innovation isn’t just in the brands we carry — it’s in the way we connect them. From our automation engine that keeps collections globally updated to our commitment to authenticity-first presentation, STORE 7994 exists where timeless design meets modern precision.
Every product we offer is:
Elevated · Intentional · Exclusive · Authentic
STORE 7994 is an authorized reseller of luxury fashion houses. Certificates and proof of authenticity are available to brand owners and partners upon request.
Returns & Refunds
We want you to shop with confidence at STORE 7994. If your purchase does not meet expectations, eligible items may be returned under the conditions below.
Return Eligibility
Items must be unused, unworn, and in original condition with all tags, packaging, and accessories included. Items showing any signs of wear or damage will not be accepted.
Return Window
Return requests must be made within 14 days of delivery.
Return Shipping
Customers are responsible for return shipping costs unless the item is defective, damaged, or incorrect.
Luxury Items
Items valued over $1,000 may be subject to a 7% restocking fee upon approved return.
Non-Returnable Items
For hygiene and product integrity reasons, the following items are final sale once opened or used:
• Underwear
• Fragrances
• Any worn or used items
Made-to-Order Items
Custom-designed products, including STORE 7994 hoodies, are made exclusively for each customer and are final sale. These items are not eligible for return or exchange unless defective or incorrect.
If you receive a defective or incorrect item, please contact us and we will make it right.
International Shipping & Duties
Many of our products ship directly from trusted international partners. Any applicable customs duties or import taxes are calculated at checkout and are non-refundable, even if the item is returned.
Returns & Associated Fees
All approved returns are subject to a $24 return processing fee. For international orders, duties, taxes, and return fees will be deducted from the original payment.
Shipping Policy
Complimentary shipping is offered on orders over $300. Orders below this threshold are subject to standard shipping rates at checkout.
>