Financial Modeling with Crystal Ball and Excel and over one million other books are available for Amazon Kindle. Learn more


or
Sign in to turn on 1-Click ordering.
or
Amazon Prime Free Trial required. Sign up when you check out. Learn More
Kindle Edition
 
   
Sell Back Your Copy
For a $30.07 Gift Card
Trade in
More Buying Choices
Have one to sell? Sell yours here
Financial Modeling with Crystal Ball and Excel (Wiley Finance)
 
 
Start reading Financial Modeling with Crystal Ball and Excel on your Kindle in under a minute.

Don't have a Kindle? Get your Kindle here, or download a FREE Kindle Reading App.

Financial Modeling with Crystal Ball and Excel (Wiley Finance) [Paperback]

John Charnes (Author)
2.7 out of 5 stars  See all reviews (6 customer reviews)

List Price: $85.00
Price: $47.22 & this item ships for FREE with Super Saver Shipping. Details
You Save: $37.78 (44%)
  Special Offers Available
o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o
In Stock.
Ships from and sold by Amazon.com. Gift-wrap available.
Only 1 left in stock--order soon (more on the way).
Want it delivered Monday, January 30? Choose One-Day Shipping at checkout. Details
Textbook Student FREE Two-Day Shipping for Students. Learn more

Formats

Amazon Price New from Used from
Kindle Edition $42.50  
Paperback $47.22  
Sell Back Your Copy for $30.07
Whether you buy it used on Amazon for $37.16 or somewhere else, you can sell it back through our Book Trade-In Program at the current price of $30.07.
Used Price$37.16
Trade-in Price$30.07
Price after
Trade-in
$7.09
There is a newer edition of this item:
Financial Modeling with Crystal Ball and Excel, + Website (Wiley Finance) Financial Modeling with Crystal Ball and Excel, + Website (Wiley Finance)
$56.70
Available for Pre-order

Book Description

0471779725 978-0471779728 March 30, 2007
Praise for
Financial Modeling with Crystal Ball(r) and Excel(r)

"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, Decisioneering, Inc.

"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, Executive Director, Morgan Stanley, author of The Poker Face of Wall Street

"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, Nortel

Special Offers and Product Promotions

  • Buy $50 in qualifying physical textbooks, get $5 in Amazon MP3 Credit. Here's how (restrictions apply)

Frequently Bought Together

Customers buy this book with Statistics for Business and Economics $166.02

Financial Modeling with Crystal Ball and Excel (Wiley Finance) + Statistics for Business and Economics
Price For Both: $213.24

Show availability and shipping details

  • This item: Financial Modeling with Crystal Ball and Excel (Wiley Finance)

    In Stock.
    Ships from and sold by Amazon.com.
    This item ships for FREE with Super Saver Shipping. Details

  • Statistics for Business and Economics

    In Stock.
    Ships from and sold by Amazon.com.
    This item ships for FREE with Super Saver Shipping. Details



Editorial Reviews

From the Back Cover

Praise for
Financial Modeling with Crystal Ball® and Excel®

"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, Decisioneering, Inc.

"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, Executive Director, Morgan Stanley, author of The Poker Face of Wall Street

"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, Nortel

About the Author

Dr. John Charnes, PhD, MBA, is Professor, Scupin Faculty Fellow, and former director of the finance, economics, and decision sciences area in the University of Kansas School of Business. His specialty is the application of computer simulation and statistical methods for identifying and solving business problems, and his most current research involves using simulation for option pricing and hedging with derivatives to comply with Financial Accounting Standard (FAS) 133. Charnes has also performed research, consulting, and executive education for more than fifty corporations and other organizations.

Product Details

  • Paperback: 290 pages
  • Publisher: Wiley (March 30, 2007)
  • Language: English
  • ISBN-10: 0471779725
  • ISBN-13: 978-0471779728
  • Product Dimensions: 9.2 x 7.6 x 0.6 inches
  • Shipping Weight: 1.3 pounds (View shipping rates and policies)
  • Average Customer Review: 2.7 out of 5 stars  See all reviews (6 customer reviews)
  • Amazon Best Sellers Rank: #157,375 in Books (See Top 100 in Books)

More About the Author

Discover books, learn about writers, read author blogs, and more.

 

Customer Reviews

6 Reviews
5 star:    (0)
4 star:
 (3)
3 star:    (0)
2 star:
 (1)
1 star:
 (2)
 
 
 
 
 
Average Customer Review
2.7 out of 5 stars (6 customer reviews)
 
 
 
 
Share your thoughts with other customers:
Most Helpful Customer Reviews

16 of 16 people found the following review helpful:
4.0 out of 5 stars goes beyond deterministic assumptions, June 23, 2007
This review is from: Financial Modeling with Crystal Ball and Excel (Wiley Finance) (Paperback)
The book is all about simulations. In financial modelling, as opposed to engineering or science. Readers from the latter 2 fields who have coded simulations will find much in common. The specific equations in the text for finance are largely different from what you've met before. But the basic treatment is essentially the same.

Typically, the text will describe some financial equation. The Crystal Ball program lets you easily generate random data as input to simulations, which it then runs.

Despite Excel in the book's title, the book is mostly about using Crystal Ball. Charnes shows how you can go well beyond a simple deterministic treatment of an income statement or balance sheet. Typically, most companies just use the deterministic approach. The danger is that this approach relies on certain assumptions. Using Crystal Ball and the book, you can test the effect of relaxing these assumptions on the balance sheet. A more robust approach to financial planning.
Help other customers find the most helpful reviews 
Was this review helpful to you? Yes No


6 of 8 people found the following review helpful:
1.0 out of 5 stars Companion website doesn't work, September 18, 2009
Amazon Verified Purchase(What's this?)
This review is from: Financial Modeling with Crystal Ball and Excel (Wiley Finance) (Paperback)
This book is useless without the companion web site. I am stuck with this book because I cannot access the web site. The company Decisioneering Inc. was bought by Oracle and thewebsite mentioned in the book doesn't work so also the help desk email address.
I feel cheated. Don't fall prey.
Help other customers find the most helpful reviews 
Was this review helpful to you? Yes No


1 of 1 people found the following review helpful:
4.0 out of 5 stars Good but typos must be excised in the next edition, December 1, 2008
By 
Beau Sabreur (San Antonio, texas United States) - See all my reviews
Amazon Verified Purchase(What's this?)
This review is from: Financial Modeling with Crystal Ball and Excel (Wiley Finance) (Paperback)
It is a good technical book, especially for thosse who are used to work with crystal ball software, as a way to revise your knowledge and the versatility of the techniques. The only problem is that the book contains a great number of typos, some mistakes, text and titles which do not correspond to the numbering on the outline. The good thing is that it is relatively easy to spot them. All in all, I recommend the book, and expect that the next edition will be revised.
Help other customers find the most helpful reviews 
Was this review helpful to you? Yes No

Share your thoughts with other customers: Create your own review
 
 
 
Most Recent Customer Reviews




Only search this product's reviews



Inside This Book (learn more)
Key Phrases - Statistically Improbable Phrases (SIPs): (learn more)
expansion point, overlay chart, trend chart, portfolio models, forecast charts, gross operating income, portfolio loss, spreadsheet segment, tornado chart tool, decision table tool, certainty bands, forecast window, forecast cell, central limit effect, forecast chart, stochastic assumptions, assumption cell, decision variable values, four asset classes, sensitivity chart, forecast distribution, frequency view, unit variable cost, potential future values, statistics view
Key Phrases - Capitalized Phrases (CAPs): (learn more)
Crystal Ball, Decision Table, Cancel Help, Monte Carlo, Batch Fit, Simulating Financial Time Series, Using Decision Variables, Mean Std, Define Assumption, Trials Frequency View, Financial Options, Vitex Corporation, Total Loss, Define Decision, Cost of Sales, Alaskan Golf, Extreme Speed, Selecting Run Preferences, Cancel Defaults, Total Cost, Net Income, Back Next, Income Taxes, Cumulative Frequency, Latin Hypercube
Browse Sample Pages:
Front Cover | Table of Contents | First Pages | Index | Surprise Me!
Search Inside This Book:


Tags Customers Associate with This Product

 (What's this?)
Click on a tag to find related items, discussions, and people.
 

Your tags: Add your first tag
 

Customer Discussions

This product's forum
Discussion Replies Latest Post
No discussions yet

Ask questions, Share opinions, Gain insight
Start a new discussion
Topic:
First post:
Prompts for sign-in
 


Active discussions in related forums
Search Customer Discussions
Search all Amazon discussions
   
Related forums



So You'd Like to...

Create a guide


Look for Similar Items by Category


Look for Similar Items by Subject