Customer Reviews

Financial Models Using Simulation and Optimization: A Step-By-Step Guide with Excel and Palisade's Decision Tools Software with CDROM

5 star:		(2)
4 star:		(1)
3 star:		(0)
2 star:		(0)
1 star:		(0)

 

 

This book does what it says it does in the title. It is a hand-on, step-by-step guide to constructing spreadsheet models to assist with decision making. The book guides the reader through intermediate to advanced modelling topics and is written at a level that is accessable to the novice and intermediate user. Advanced users are probably already familiar with the techniques presented.

Someone interested in the tiresome advanced mathematics behind the models should look instead to academic journals . . . someone interested in APPLYING that stuff to something useful should consider this book.

I highly recommend this book to anyone working with Excel & Financial Models. The author has straight forward examples that highlight approaches & methods that will help you leverage the power of Microsoft Excel. Incorporating Excels Solver can be very beneficial for financial planning and this text helps accelerate you along the learning curve at a rapid pace. I have used his "yield curve" technique, "Linear Regression" technique, and "Modeling Relationships Involving More than One Independent Variable" technique. I used this last technique to model prepayment speeds of mortgage loans consisting mainly of ARM loans (COFI & MTA). The investment in the text is small compared to the wealth of information at your disposal. It will make a great reference book.

nice book for the starters and great concepts to learn excel in an exciting way.