Spreadsheet Modeling in Corporate Finance Review

Average Reviews:

(More customer reviews)Although intended as a supplement for textbooks used in college level business courses, this book is also valuable to working professionals who deal with financial modeling. Because I am a consultant and project manager I'm going to slant this review towards how my peers will benefit from the book. It's value outside of my narrow scope should be apparent.
First, unlike other books that teach spreadsheet modeling, the spreadsheets that come on the CD ROM are not finished products. Instead the author has chosen spreadsheets that use dynamic charts to illustrate concepts in an interactive manner (drag a control to change the parameters and the chart changes - this is a powerful teaching tool in or out of the classroom).
Second, the book needs to be read in sequence because spreadsheets you build in one chapter are the basis for refinements and added complexity in later chapters. This leads to highly complex spreadsheets, such as the model in chapter 16 (Life-Cycle Financial Planning), which incorporates tax parameters (federal and state levels), benefits analysis and other factors.
In all there are 53 spreadsheets presented in this book, and you build them. The author calls this "active learning" (as opposed to passive learning where you are provided templates), and it is effective because you are the one who builds the models and tools while following the book. Note that this book does NOT purport to teach Excel programming, but how to build models using Excel's basic features and functions.
As a consultant and project manager the parts of this book that were immediately useful to me were: Parts I (Time Value of Money), III (Capital Budgeting) and IV (Financial Planning). In particular, project management requires a thorough understanding of time value of money and capital budgeting, and the chapters in these sections should be read by anyone who is assigned as a project manager. Financial planning, especially from the perspective of IT asset management, is another knowledge area in which IT consultants should be well versed.
The other parts of the book (II Valuation and V Options and Corporate Finance) will be more useful to finance professionals and general business managers. There is a collection of supporting material on the author's web site that augment this book, including spreadsheets that can be downloaded. Another plus for the working professional is the book is fast-paced and, dare I say, engrossing.

Click Here to see more reviews about: Spreadsheet Modeling in Corporate Finance

If you build it, you will learn.*Comes as a book and CD-ROM that teaches students how to build financial models in Excel *Provides instructions for building financial models, not templates *Progresses from simple examples to complex real-world applications *Is available is alternative versions that match the notation of most Prentice Hall Corporate Finance textbooks and other popular textbooks *Includes end-of-chapter problems *Has been extensively classroom-tested

Click here for more information about Spreadsheet Modeling in Corporate Finance

Read More...

Dynamic Modeling for Business Management: An Introduction (Modeling Dynamic Systems) Review

Average Reviews:

(More customer reviews)I read this after Sterman's 'Business Dynamics'. While 'Business Dynamics' is a graduate level text book, this book is more aligned to the requirements of practitioners like consultants and managers. MDS have a series of books on use of dynamic modeling, each focusing on a specific area like biological systems, economics, health sciences, environmental systems etc.

Click Here to see more reviews about: Dynamic Modeling for Business Management: An Introduction (Modeling Dynamic Systems)

Modelling is a tool used by savvy business managers to understand the processes of their business and to estimate the impact of changes. Dynamic Modelling for Business Management applies dynamic modelling to business management, using accessible modelling techniques that are demonstrated starting with fundamental processes and advancing to more complex business models. Discussions of modelling emphasize its practical use for decision making and implementing change for measurable results. Readers will learn about both manufacturing and service-oriented business processes using hands-on lessons. Then will then be able to manipulate additional models to try out their knowledge and address issues specific to their own businesses and interests. All of the models used in the book and a run-time version of the ithink software are included on a CD-ROM included with the book. Some of the topics covered include workflow management, supply-chain-management, and strategy.

Get 20% OFF

Click here for more information about Dynamic Modeling for Business Management: An Introduction (Modeling Dynamic Systems)

Read More...

Business Modeling: A Practical Guide to Realizing Business Value (The MK/OMG Press) Review

Average Reviews:

(More customer reviews)I enjoyed reading this book. The tone was light and the same detailed real-world style examples continued throughout the book. The four types of business models covered were explained simply and clearly. Using the example diagrams, I have begun to create my own business models. Having done business and technical modeling on and off since 1991, this book was a great introduction to some new types of models, the emerging standards, and some excellent tips on techniques for activities that take place around the models such as workshops and simulation. I appreciated the non-technical way that the models were presented, such that both a business-person and a hard-core techie could both get value from the same model. The authors' website promises to provide more details, including updates on tools, and they have been kind in helping me to identify some available tools that might fit my needs.
I am certainly in a better position to incorporate business models into my new and existing business ventures from studying this book.

Click Here to see more reviews about: Business Modeling: A Practical Guide to Realizing Business Value (The MK/OMG Press)

As business modeling becomes mainstream, every year more and more companies and government agencies are creating models of their businesses. But creating good business models is not a simple endeavor. Business modeling requires new skills. Written by two business modeling experts, this book shows you how to make your business modeling efforts successful. It provides in-depth coverage of each of the four distinct business modeling disciplines, helping you master them all and understand how to effectively combine them. It also details best practices for working with subject matter experts. And it shows how to develop models, and then analyze, simulate, and deploy them. This is essential, authoritative information that will put you miles ahead of everyone who continues to approach business modeling haphazardly. * Provides in-depth coverage of the four business modeling disciplines:process modeling, motivation modeling, organization modeling, and rules modeling.* Offers guidance on how to work effectively with subject matter experts and how to run business modeling workshops.* Details today's best practices for building effective business models, and describes common mistakes that should be avoided.* Describes standards for each business modeling discipline.* Explains how to analyze, simulate, and deploy business models.* Includes examples both from the authors' work with clients and from a single running example that spans the book.

Get 13% OFF

Click here for more information about Business Modeling: A Practical Guide to Realizing Business Value (The MK/OMG Press)

Read More...

Business Process Modeling, Simulation and Design Review

Average Reviews:

(More customer reviews)An excellent book. Though it requires some knowledge to OR, Statistics and OM to understand. A thoroughly enjoyable book, excellent end of chapter questions. Ideal to be used as a text book. The sildes that the author uses to teach in available on the web, and can be used by anybody desirous of using this book as a base text book.

Click Here to see more reviews about: Business Process Modeling, Simulation and Design

Intended for courses in Business Process Management and/or Modeling in the School of Business or a Department of Industrial Engineering or Engineering Management. It could also be used in a Business Simulation course, because a sizable portion of the book is devoted to discrete-event simulation.This book covers the design of business processes from a broad quantitative modeling perspective. The text presents a multitude of analytical tools that can be used to model, analyze, understand and ultimately, to design business processes. The range of topics in this text include graphical flowcharting tools, deterministic models for cycle time analysis and capacity decisions, analytical queuing methods, as well as the use of Data Envelopment Analysis (DEA) for benchmarking purposes. And a major portion of the book is devoted to simulation modeling using a state of the art discrete-event simulation package.

Click here for more information about Business Process Modeling, Simulation and Design

Read More...

Dynamic Modeling (Modeling Dynamic Systems) Review

Average Reviews:

(More customer reviews)This is an excellent book for beginning and intermediate modelers. I found it to be engaging, practical, and easy to understand. Dynamic modeling has become an essential tool to facilitate understanding developments in our increasingly complex and interdependent world, to communicate ideas across disciplinary boundaries, and to help solve problems. This book is a great place to begin. It offers a hands-on introduction to dynamic modeling.
The authors start with an easy to understand, step-by-step description of the modeling process, key principles of modeling, and general methods of modeling. This is followed-up with and numerous examples from chemistry, genetics, ecology, economics, and engineering. But this is not just a book to read. The book comes with run-time versions of the easy to learn STELLA and Madonna software as well as copies of the various models developed in each of the 37 chapters.
The authors encourage readers to build the models themselves as they work through the chapters, and then explore the dynamics by experimenting with the models. This is an active, fun way to learn. It definitely helped me to expand my systems thinking capability. Although my substantive interest is organizations, I learned a great deal by analogy from working through models of problems from other disciplines. Basic systems principles apply across disciplines, and useful insights can be gleaned from recognizing similar dynamic structures underlying different systems.
I particularly liked the instruction by example that is used throughout this book. I learned so much from this book because the reading and modeling, modeling and reading formed a positive feedback loop. The reading provided direction and engaged me in the modeling, and the modeling clarified and reinforced the concepts in the reading. Drawing from my experience with this book, I think it is ideal for those who are just getting started in dynamic modeling or have been learning for several years but want to sharpen and expand their systems thinking and modeling skills.

Click Here to see more reviews about: Dynamic Modeling (Modeling Dynamic Systems)

The book uses STELLA software to develop simulation models, thus allowing readers to convert their understanding of a phenomenon to a computer model, and then run it to yield the inevitable dynamic consequences built into the structure. Part I provides an introduction to modeling dynamic systems, while Part II offers general modeling methods. Parts III through VIII then apply these methods to model real-world phenomena from chemistry, genetics, ecology, economics, and engineering. Dynamic Modeling includes STELLA run-time software for both Windows and Mac systems, as well as computer files of sample models used in the book. A clear, approachable introduction to the modeling process, of interest in any field where real problems can be illuminated by computer simulation.

Get 29% OFF

Click here for more information about Dynamic Modeling (Modeling Dynamic Systems)

Read More...

Business Dynamics: Systems Thinking and Modeling for a Complex World with CD-ROM Review

Average Reviews:

(More customer reviews)The field of system dynamics was created in 1956 under the leadership of MIT Professor Jay W. Forrester to evaluate how alternative policies affect growth, stability, fluctuation, and changing behavior in corporations, cities, and countries. Forrester founded the System Dynamics Program in the Alfred P. Sloan School of Management at MIT. John Sterman is currently Director of the System Dynamics Group at MIT.
This text is a summary of the wisdom and knowledge gathered over more than twenty years of research dedicated to the study of practical methods for systems thinking and the dynamic modeling of complex systems. It is well written, easy to understand, and worthy of serious consideration.
I believe the text is destined to become a classic. It is written in a straightforward style and does not require prerequisite knowledge of higher mathematics. Indeed, in the author's words, "one of the strengths of the text is the way it presents system dynamics with a minimum of mathematical formalism. The goal is to develop the reader's intuition and conceptual understanding, without sacrificing the rigor of the scientific method." This goal is achieved well.
The text opens with a succinct and well organized description of approaches to the study of complex systems. It develops a set of principles for successful use of systems dynamics and provides well-written overviews of the Modeling Process and dynamic systems.
It covers the construction of causal loop diagrams and describes their application in a variety of business and engineering examples.
This is one of the best texts in its field for upper division undergraduate courses and graduate programs. It will be useful to many in business, engineering, and science.

Click Here to see more reviews about: Business Dynamics: Systems Thinking and Modeling for a Complex World with CD-ROM

The leading authority on system dynamics explains this approach to organizational problem solving, emphasizing simulation models to understand issues such as fluctuating sales, market growth and stagnation, the reliability of forecasts and the rationality of business decision-making. The CD includes modeling software from Vensim, ithink, and PowerSim.

Click here for more information about Business Dynamics: Systems Thinking and Modeling for a Complex World with CD-ROM

Read More...

Financial Modeling - 2nd Edition: Includes CD Review

Average Reviews:

(More customer reviews)I have used Simon Benninga's "Financial Modeling with Excel" for five years to teach undergraduate computational finance [...]. My thinking remains that my students have been well served by this textbook.
The inadequacies that limit my assessment to four stars and need to be addressed in the third edition are: 1) frustrating errors in the text and models, for which the errata sheet and corrected models (available at: [...] only improve, but do not heal. My students find new, undocumented, errors each semester. 2) the data sets and examples are getting, frankly, a little old. It is the year 2005 as I write this, but the data sets and examples end in 1999, a year in which my current students were in high school. 3) the models, while excellent as introductions to the field, are now at the point of being fundamental, rather than exemplary. This is not Prof. Benninga's fault, but as the other reviews from professionals here attest, Excel modeling has advanced in all fields (option pricing, financial statements, portfolio optimization, bond metrics, etc). When this volume was introduced, it was adequate for helping MBA and Master of Science in Finance students build essential modeling skills. Sadly, it now is only appropriate for raw beginners or undergraduates. A new text with a larger scope that addresses advances in the fields is called for. 4) While it is a subject in itself, the book is seriously hindered by not introducing basic Monte Carlo simulation in Excel. 5) No information on downloading data from BLOOMBERG, REUTERS, and other historical and market data providers. It would add to the scope of the text, but 6) fitting DCF models to yield curves also would be welcome.
Even with these criticisms, Benninga's Financial Modeling remains the best book in the field for what it seeks to accomplish. It covers the major topics of finance that are appropriately addressed with models: financial statement, firm valuation and credit metrics, portfolio construction, fixed income metrics, option pricing, etc. Benninga's FM also compares favorably with his two nearest competitors.
Powel and Baker's "The Art of Spreadsheet Modeling" is a two pronged monster: it seeks to be a meta-level theoretical work on spreadsheet modeling, and then introduces modeling Monte Carlo simulation as a fundamental component of Excel (a student edition of CrystalBall is included in the text, and is the only reason to buy this book). The gap between the two is a Grand Canyon's worth of knowledge space that this text does not fill in and nearly ignores. The student who uses only Powel and Baker is ill served; whereas if he uses Benninga, he knows how, why, when and what to model. Consider Powel & Baker as sketches of a concept car with simulated wind tunnel runs, whereas Benninga shows how to build your own kit car and drive it around. Powel and Baker's concept car is beautiful, advanced, gracious, but doesn't exist and doesn't run; Benninga's kit car is like a Lotus Super Seven: simple, runs, is a blast to drive, but is dangerous in heavy traffic and you would not want to go on a 1,000 mile journey with it (i.e. or build a DCF model for the Goldman Sachs LBO team with only Benninga).
Chandan Sengupta's "Financial Modeling Using Excel and VBA" is the only book that comes close to Benninga, and I recommend it as another perspective for my students who want to continue with financial modeling. However, Sengupta's work is flawed on two counts: 1) it is clear throughout that he had read Benninga, and 2) he dropped much of Benninga's content in favor of adding wordy explanatory paragraphs to soften the blow of the fact that modeling is mathematically and technically both boring and intense work. With those criticisms in mind, his work still has neater, leaner, more compressed models with updated contemporary detail.
There are three other books, Scott Proctor's "Building Financial Models with Microsoft Excel: A Guide for Business Professionals," which focuses on building vanilla financial statements, as does John Tjia "Building Financial Models." Mary Jackson & Mike Staunton's "Advanced Modeling in Finance using Excel and VBA" is also now dated and seriously flawed and limited in scope), however it is the next step following Benninga.
For those working in top-tier banks, the internal training and modeling documents, and examples built by colleagues, will likely surpass by light years what is offered in these books. And so for beginners, Benninga remains the the best choice and first step, until something better comes along, or Benninga himself produces a new edition.

Click Here to see more reviews about: Financial Modeling - 2nd Edition: Includes CD

Too often, finance courses stop short of making a connection between textbook finance and the problems of real-world business. Financial Modeling bridges this gap between theory and practice by providing a nuts-and-bolts guide to solving common financial models with spreadsheets. Simon Benninga takes the reader step by step through each model, showing how it can be solved using Microsoft Excel®. In this sense, this is a finance "cookbook," providing recipes with lists of ingredients and instructions.Areas covered include computation of corporate finance problems, standard portfolio problems, option pricing and applications, and duration and immunization. The second edition contains six new chapters covering financial calculations, cost of capital, value at risk (VaR), real options, early exercise boundaries, and term structure modeling. A new technical chapter contains a potpourri of tips for using Excel®.Although the reader should know enough about Excel™ to set up a simple spreadsheet, the author explains advanced Excel® techniques used in the book. The book includes chapters dealing with random number generation, data tables, matrix manipulation, and VBA programming. It also comes with a CD-ROM containing Excel® worksheets and solutions to end-of-chapter exercises.

Click here for more information about Financial Modeling - 2nd Edition: Includes CD

Read More...

Workflow Modeling: Tools for Process Improvement and Application Development, 2nd Edition Review

Average Reviews:

(More customer reviews)Rarely do I get excited about books on workflow modeling. I have a few good books on the subject, all of which provide solid approaches and most of which are well written. This book stands out because it goes beyond merely "solid" or "well written" by giving one of the most comprehensive approaches to workflow modeling I've had the pleasure of reading.
First, like most books on the topic, none of the components of the approach are new. What makes the approach refreshing is the way the authors take standard techniques and tie them together into a coherent process. Second, this book can be used as a workbook during a workflow modeling project, and is well suited to this because of the numerous checklists and diagrams that will prove invaluable every step of the way. Finally, this is the first book of its kind that incorporates use cases, making it invaluable to project teams that have standardized on UML (Unified Modeling Language)or wish to integrate an object-oriented approach into a workflow modeling project. If you're not familiar with use cases I strongly recommend Writing Effective Use Cases by Alistar Cockburn (the best book on the subject in my opinion); UML Distilled by Fowler and Scott is an excellent introduction to that subject if it's new to you.
The approach is straightforward: frame the process and define its scope, understand the existing process (if there is one), design the "to-be" process and develop use case scenarios. I wish to offer one caveat at this point: if you are reengineering a process that is seriously broken you might consider skipping the "as-is" process. Understanding the existing process is useful if your goal is incremental improvement. Reengineering efforts usually radically transform existing processes, making efforts to understand them both moot and wasted.
Some of the highlights of this book include the authors' clear definitions and way of decomposing complex systems into discrete steps and components. For example, they use a five tier view of processes that ensures you have a complete view of all issues and factors. The views are: (1) mission, strategy and goals (I personally extend goals further into Goal-Question-Metric), (2)business processes, (3) presentation, (4) application logic and (5) data. Note that the last three align nicely to a 3-tier client/server architecture. This observation clearly shows how coherent the authors' approach is and how it can foster alignment of technology to business requirements.
I also like how the authors clarify the key issues in process design by pointing out six enablers that you need to account for during the analysis and design phase: (1)workflow, (2) technology, (3) human resources, (4) motivations and measurements, (5) policies and rules and (6) environmental constraints (facilities, external process capabilities, etc.). There is one minor point of disagreement I have between their workflow modeling technique and the one I use. The authors use swimlane diagrams (also called Rummler-Brache diagrams), while I use deployment diagrams. The difference? Swimlane diagrams do not capture phases or cycles. I always place workflows into the context of Entry Criteria-Task-Validation-Exit Criteria (ETVX), which is nearly identical to the TQM Plan-Do-Check-Act (PDCA) cycle. I insist on ETVX because it allows me to spot missing validation points in an existing workflow, and ensures that I clearly define entry and exit criteria, as well as validation points in a "to-be" workflow. Of course I am stating personal preferences - following the authors' approach verbatim will definitely result in a workflow design that is not only "bulletproof", but will align information systems and business process almost perfectly.
This book is a gem. It's readable, full of ideas and, with the incorporation of use cases into the approach, completely up-to-date with respect to IS/IT methodologies. If you want a fresh, modern approach to workflow design this book is the only one that will provide it.

Click Here to see more reviews about: Workflow Modeling: Tools for Process Improvement and Application Development, 2nd Edition

At last - here's the long-awaited, extensively revised and expanded edition of the acclaimed and bestselling book, "Workflow Modeling". This thoroughly updated resource provides proven techniques for identifying, modeling, and redesigning business processes, and explaining how to implement workflow improvement, this book helps professionals define requirements for systems development or systems acquisition. By showing how to build visual models for illustrating workflow, the book helps practitioners assess their current business processes and see where process improvement and systems development can take place. Leading author Alec Sharp is an internationally recognized expert in business process management and is in high demand as a speaker and seminar leader in the field.

Get 23% OFF

Click here for more information about Workflow Modeling: Tools for Process Improvement and Application Development, 2nd Edition

Read More...