- Gebundene Ausgabe: 272 Seiten
- Verlag: Economist Books; Auflage: Main (16. August 2001)
- Sprache: Englisch
- ISBN-10: 1861971265
- ISBN-13: 978-1861971265
- Größe und/oder Gewicht: 19,8 x 2,2 x 25,8 cm
- Durchschnittliche Kundenbewertung: Schreiben Sie die erste Bewertung
- Amazon Bestseller-Rang: Nr. 3.438.026 in Fremdsprachige Bücher (Siehe Top 100 in Fremdsprachige Bücher)
Guide to Business Modelling (Economist) (Englisch) Gebundene Ausgabe – 16. August 2001
Kunden, die diesen Artikel gekauft haben, kauften auch
Es wird kein Kindle Gerät benötigt. Laden Sie eine der kostenlosen Kindle Apps herunter und beginnen Sie, Kindle-Bücher auf Ihrem Smartphone, Tablet und Computer zu lesen.
Geben Sie Ihre Mobiltelefonnummer ein, um die kostenfreie App zu beziehen.
Wenn Sie dieses Produkt verkaufen, möchten Sie über Seller Support Updates vorschlagen?
This is a definitive guide to creating financial models that can be used to evaluate anything from a modest business proposal to a major acquisition.'
|5 Sterne (0%)|
|4 Sterne (0%)|
|3 Sterne (0%)|
|2 Sterne (0%)|
|1 Stern (0%)|
Die hilfreichsten Kundenrezensionen auf Amazon.com
The best book I know for using Excel for asking, and then answering, tough questions about things like pricing, discounts, margins, channels, anything that can be quantified or measured.
The strong point of the book is its emphasis on structuring the model and the modelling process. Models tend to take on a life of their own after the initial development, and sometimes even before the first build is complete, and time spent in thinking, planning and design is usually a very worthwhile investment. This is particularly important if there are multiple people involved in the model's design and use, and the book covers how one might organise a modelling project.
The principal modelling task is designing the mathematical model that produces the desired time series of sales, costs, etc, over time, based on a handful of input parameters. The book goes into some detail about the formulae needed to render the different kinds of time series one might encounter in a typical business model, covering areas such as macroeconomics, forecasting revenue (with good discussion of times series analysis and regression techniques), operating costs, capital expenditure, working capital, and funding, along with ancillary issues such as depreciation, tax, financial statements and company valuation methods.
Also welcome are the chapters on the often overlooked topics of testing, debugging and documenting a model. There is an introduction to recording macros and programming simple Visual Basic code, but anyone serious about programming Excel with VBA can find better material elsewhere.
As I said, a good introduction. It assumes some basic understanding of Excel and business terminology, but not a lot else. There are lots of practical spreadsheet examples with the formulae all well explained, although sometimes the text description is a little disconnected from the screenshot. It is a pity the authors did not go further in several key areas.
* The book introduces the concept of Excel range names, but does not do them enough justice. The naming of ranges is the single most important underused feature in Excel, and mastering its use will dramatically reduce the bugs in a model and, if names are chosen sensibly, provide instant documentation and a model that has a fighting chance of being understood by the next modeller who picks it up and has to maintain or update it.
* Sensitivity analysis is covered in just three paragraphs, when this is probably the single most important use of a model. Anyone can create a model that produces an answer (eg, the NPV of a business opportunity) for a given set of assumptions. But we all know these assumptions, if they represent forecasts of the future, are wrong. Regarding the model as a simulation and playing with ranges of assumptions (testing various "what-ifs"), so that you build a full understanding of the drivers of value and risk in the business situation, is where the real value of modelling lies.
* Monte Carlo simulation is again covered only briefly and with a rudimentary DIY approach. There is no mention of the many tools available that can drive a well-designed model through probabilistic analysis.
Finally, I have to comment on the chapter on macroeconomics, which makes use of the sine function to model economic cycles. Given the discussion in the press about the current recession and whether it will be V- or U-shaped (or maybe W- or--preserve us!--L-shaped), this seems hopelessly simplistic for any practical use. This jibes with the rest of the book, which is practical. However, the example does help introduce how to parameterise a time series, in this case with the cycle time and amplitude.
I have two books that I swear by as my foundation for understanding any business - This one and Business Model Generation.
Use this book as a good reference on building spreadsheet, be it for business modeling or just plain use of Excel. For years I sought for this a book. Finally I found it. ...