Book Description
A practical guide to building fully operational financial cash flow models for structured finance transactions
Structured finance and securitization deals are becoming more commonplace on Wall Street. Up until now, however, market participants have had to create their own models to analyze these deals, and new entrants have had to learn as they go. Modeling Structured Finance Cash Flows with Microsoft Excel provides readers with the information they need to build a cash flow model for structured finance and securitization deals. Financial professional Keith Allman explains individual functions and formulas, while also explaining the theory behind the spreadsheets. Each chapter begins with a discussion of theory, followed by a section called "Model Builder," in which Allman translates the theory into functions and formulas. In addition, the companion CD-ROM features all of the modeling exercises, as well as a final version of the model that is created in the text.
Note: CD-ROM/DVD and other supplementary materials are not included as part of eBook file.
Customer Reviews:
Good Intro to Cash Flow Modeling.......2007-09-20
Anyone needing to learn how structured finance cash flow models work will benefit from going through this book and building the spreadsheet-based model it describes. It will be faster if you are already good at using Excel for complex modeling or pricing, but there is a fair amount of Excel advice for those who need it. The book models a single pool of mortgages that can be described by weighted average statistics incorporating both prepayment and default scenarios. Great care is taken to make the model flexible in terms of the kinds of mortgages in the pool. On the liability side the model allows for the creation of a single senior class and a sub class with an interest rate swap and a reserve. While very good for learning the cash flow consequences of sequential and pro rata payment waterfalls, this model cannot describe the structures actually issued in the market. The skills learned, however, should allow the reader to build models capable of modeling issued structures.
The writing is clear and the examples are explained well. The flow of cash into and out of the structure is emphasized by clear inputs, cash flow modeling and summary outputs.
Excellent introduction to MBS modeling.......2007-08-13
Keith's book saved me hours of trial-and-error effort with Excel for modeling structured transactions. This book takes a simple, step-by-step approach to help the reader understand the mechanics of building the cash flow model for Mortgage Backed Securities (MBS).
Once you understand the basics of model creation and cash flow, then it is a matter of refining your skills by revere-engineering more MBS transactions out there. You will find all the basic tools to become proficient in that task by following this book.
Excellent Hands-On Introduction to Structured Finance.......2007-06-03
In structured finance, there is a tremendous discrepancy between academic literature and practice. In purporting a generalizable, scientific approach, many textbooks avoid explaining the intracacies of actual structured finance deals. The fundamental issue is that the implicit value of deal transparency required for issuer and investor tends to be overlooked by authors approaching the field from an academic background. Technical pyrotechnics that suit liquid markets fail when fees, interest rates, and other deal specifics are malleable constructs negotiated among a handful of parties. At the same time, basic bond math on an unsegregated pool of loans cannot accurately describe how assets generate cash flows and the risks faced by investors.
MFSC is the *only* book (afaik) that demonstrates how real structured finance pros bridge the void between these 2 common pitfalls made by other structured finance books. For one, the calculations that belie each component of a structured finance deal is integrated into a single model rather than considered separately. Other books may describe how cash flows pay out in a senior-sub structure, but they won't, for example, take the time to step through how funding costs and triggers affect the cash flows. The primary model also gives the user flexibility to stress the model and enables the user to treat the model as a base for all structured finance deals. Through a neatly organized inputs sheet, each component in the primary model described painstakingly anticipates the gamut of variations common to these types of deals.
All this in a book that's easy to follow and a delight to read. Five stars.
Modeling of CMBS.......2007-06-03
Keith's book does an excellent job at helping both new analysts to MD's in understanding modeling of complex master tapes (models). If you need to know how to structure a fixed or floating rate transaction this book will give you key tools to understand, build and read strats, term sheets, and OC data. Many of the functions and formulas that are explained are used in real working models but in additon to that this book explains key concepts in the structured finance world. Unlike other books this book has a much more active learning style and really gets you involved.
I look forward to the day when Keith writes a book focusing on CMBS, I will defintely buy that one also.
TM
CIB
CMBS
Very Good for Professionals.......2007-05-07
The book explains very well the building and works of a very huge excell worsheet, for professionals it will be a great and interesting reading, and sometimes it will be like a great novel, when you can't stop reading
and always want to go to the next chapter before leaving it.
For begineers it will be a little hard to understand the concepts and the meanings of each chapter, but it will help too.
Average customer rating:
- Excelent book
- I thought I did a review for this book immediately when I received it! It was really good! It's like the best textbook!
- Strongly recommended to practitioner
- Good Cookbook
- Excellent book
|
Financial Modeling - 2nd Edition: Includes CD
Simon Benninga
Manufacturer: The MIT Press
ProductGroup: Book
Binding: Hardcover
 General
| Popular Economics
| Business & Investing
| Subjects
| Books
Public Finance
| Economics
| Business & Investing
| Subjects
| Books
Corporate Finance
| Finance
| Business & Investing
| Subjects
| Books
General
| Business & Investing
| Subjects
| Books
General
| Accounting
| Industries & Professions
| Business & Investing
| Subjects
| Books
General
| Personal Finance
| Software
| Computers & Internet
| Subjects
| Books
General
| Accounting
| Business
| Software
| Computers & Internet
| Subjects
| Books
Excel
| Applications
| Microsoft
| Computers & Internet
| Subjects
| Books
General
| Accounting
| Accounting & Finance
| Professional & Technical
| Subjects
| Books
General
| Finance
| Accounting & Finance
| Professional & Technical
| Subjects
| Books
Software
| Information Systems
| Computer Science & Information Systems
| New & Used Textbooks
| Stores
| Books
General
| Accounting
| Business & Finance
| New & Used Textbooks
| Stores
| Books
General
| Business & Finance
| New & Used Textbooks
| Stores
| Books
Corporate
| Finance
| Business & Finance
| New & Used Textbooks
| Stores
| Books
All Titles
| Qualifying Textbooks - Fall 2007
| Stores
| Books
Business & Investing
| Qualifying Textbooks - Fall 2007
| Stores
| Books
Computers & Internet
| Qualifying Textbooks - Fall 2007
| Stores
| Books
Professional
| Qualifying Textbooks - Fall 2007
| Stores
| Books
Similar Items:
-
Principles of Finance with Excel: Includes CD
-
Advanced modelling in finance using Excel and VBA
-
Investment Valuation: Tools and Techniques for Determining the Value of Any Asset, Second Edition
-
Building Financial Models with Microsoft Excel: A Guide for Business Professionals
-
Valuation: Measuring and Managing the Value of Companies, Fourth Edition
ASIN: 0262024829 |
Book Description
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.
Customer Reviews:
Excelent book.......2007-09-24
Is an excelent book to learn and undertand how to creat financial models in excel.
I strongly recomend it.
Romer iragorri
I thought I did a review for this book immediately when I received it! It was really good! It's like the best textbook!.......2007-09-16
Beninnga states things very clearly.
And the sophistication is great.
No matter what level you are in, it's good for you.
And these knowledge are really useful in real world!
I mean,I'm really gonna keep this book for myself after I finish the degree.
Strongly recommended to practitioner.......2007-09-03
The book has great practical value. It also applies to those who wish to implement financial models in other computing environment than Excel.
Good Cookbook.......2007-08-23
Very good on giving an introduction on many modeling techniques.
Exceptionally recommended for the new babe.
Excellent book.......2007-07-19
All students of finance must have one, It's great, If I'd have had it when I was student oh, I'd save a lot of time, now I'm teacher of finance and I recomend all my students to buy it.
Book Description
Comprehensive instruction on developing real-world financial models
This book, designed for self-study, classroom use, and reference, presents a com-prehensive approach to developing simple to sophisticated financial models in all major areas of finance. The approach is based on the author's 20 years of experience of developing such models in the business world and teaching a popular MBA class in financial modeling. The book assumes only basic knowledge of Excel and teaches all advanced features of Excel and VBA from scratch using a unique simple method. A companion CD includes all working versions of all the models presented in the book and additional useful reference material.
Chandan Sengupta (White Plains, NY) teaches finance in the MBA program at Fordham University's Graduate School of Business. Formerly, he was vice president of the Chase Manhattan Bank for eight years and senior financial advisor for Mobil Corporation for 10 years. He is also the author of The Only Proven Road to Investment Success (0-471-44307-7).
Download Description
Comprehensive instruction on developing real-world financial models
This book, designed for self-study, classroom use, and reference, presents a com-prehensive approach to developing simple to sophisticated financial models in all major areas of finance. The approach is based on the author's 20 years of experience of developing such models in the business world and teaching a popular MBA class in financial modeling. The book assumes only basic knowledge of Excel and teaches all advanced features of Excel and VBA from scratch using a unique simple method. A companion CD includes all working versions of all the models presented in the book and additional useful reference material.
Chandan Sengupta (White Plains, NY) teaches finance in the MBA program at Fordham University's Graduate School of Business. Formerly, he was vice president of the Chase Manhattan Bank for eight years and senior financial advisor for Mobil Corporation for 10 years. He is also the author of The Only Proven Road to Investment Success (0-471-44307-7).
Customer Reviews:
Horrible Experience.......2007-03-09
I ordered this book on 1/30/2007 and todays date is 3/8/2007 and I am still waiting on my order...Actually, I am no longer waiting anymore because my school semester is more than half over and I no longer have a need for this book. TOO LATE!! I have actually called my bank and insisted that I be given back the money that Amazon has charged me for the services (the book) I have never received. Not a good experience at all!
GREAT book for learning excel and Finance.......2006-09-24
I really enjoyed using this book. The author did a great job of explaining the topics...well wortht the time and price.
Not disappointed at all.......2006-08-03
Great book, step by step approach, but still requires basic knowledge of Excel's core functions. The CD provided is definitely a plus.
No access to Excel files for eBook version.......2006-02-02
I spent a lot of money on this eBook only to find out that I would not receive the Excel files that go along with it. I am stuck either going through this book without the files that it uses throughout or shelling out even more money to buy a hardcopy version just for the attached CD.
Not for professional.......2006-01-29
Just for basic models. Not enough description on complex financial models.
Book Description
In today's increasingly competitive financial world, successful risk management, portfolio management, and financial structuring demand more than up-to-date financial know-how. They also call for quantitative expertise, including the ability to effectively apply mathematical modeling tools and techniques. An Introduction to Credit Risk Modeling supplies both the bricks and the mortar of risk management. In a gentle and concise lecture-note style, it introduces the fundamentals of credit risk management, provides a broad treatment of the related modeling theory and methods, and explores their application to credit portfolio securitization, credit risk in a trading portfolio, and credit derivatives risk. The presentation is thorough but refreshingly accessible, foregoing unnecessary technical details yet remaining mathematically precise. Whether you are a risk manager looking for a more quantitative approach to credit risk or you are planning a move from the academic arena to a career in professional credit risk management, An Introduction to Credit Risk Modeling is the book you've been looking for. It will bring you quickly up to speed with information needed to resolve the questions and quandaries encountered in practice.
Customer Reviews:
read this before going for it.......2007-04-23
Well first off I would like to tell anyone who doesn't have a solid working knowledge of calculus (including multivariate) to avoid this book as it requires multiple integrals and infinite series and sequences. Now onto the good and the bad:
THE GOOD:
This text explains concepts very well and is FULL of examples. I mean literally 3/4 of the book, maybe more, is examples. Every chapter also has a section of problems that have partial solutions, which can come in very handy. This is pretty much all that is good about this text, but keep in mind that explaination is the most important part of any textbook.
THE BAD:
The proofs skip plenty of steps. And I mean plenty, so much that a proof in the book would take 5 lines but when my professor proved it in class it would take him nearly 15. Also while there are tonnes of examples, too many are theoretical and very hard. The book costs a hefty amount of change and is suprisingly small, Author couldl have given few more examples to make it interesting. However the worst thing about this book is how the author leaves important things in with the text often. However most these things are small, and overall the text is a good intro to probability theory.
a very good book.......2006-10-31
The authors wanted to write the book that they themselves would have liked to read before starting a profession in risk management. I am working for a treasury consultancy firm. This book was the best of the five I bought. The text is very clear yet does not assume too much prior knowledge. It covers theory as well as industry practice. The book contains much advanced statistics and readers must have some background in order to handle this. The authors keep it simple but not too simple. Their approach is pragmatic throughout. I am really happy to have read this book when I started doing work in credit risk management.
good combination of math and finance.......2006-02-22
As indicated on the back of the book, the authors are aiming at audience who have some knowledge in both math and finance but may be weak in one and strong in another. Either way, this is a good book to read on credit risk.
Clear and comprehensive.......2005-10-27
This book clearly articulates basic concepts of credit risk modeling. At the same time it is mathematically rigorous. This book enables non mathematician with some (basic) knowledge in probability statistic to better understand and develop his risk management skills.
A good read!.......2004-08-19
Easy to understand with not a tremendous amount of complicated math to dicipher. Just what the doctor ordered.
Book Description
Now you can apply the techniques that business analysts at leading companies use to analyze and transform data into bottom line results. For more than 10 years, well-known consultant and business professor Wayne Winston has been teaching corporate clients and MBA candidates the most effective ways to use Microsoft Excel for data analysis, modeling, and decision making. This practical, business-focused guide delivers the best of Winston's classroom experience to you in 70+ concise chapters, organized by real-world scenarios. Quickly find and apply exactly the information you need to solve a specific business problem#151;from asset allocation modeling to estimating exponential growth, forecasting sales, optimizing portfolios, and other critical functions. You also get all the book's sample files on CD-ROM#151;ready for use in your own work.
Customer Reviews:
Great Book.......2007-07-21
Excellent...It really help me to better understand the data analysis with many differents case scenarios...exercises...its for everyone.
Real Good for a textbook........2007-05-12
I had to use for a college class, but great speed in shipping.
Not bad, but not as good as expected.......2007-04-13
I am an intermediate to advanced Excel user, so my review may reflect that level. As others have said, it looks like MS rushed this book to the market, evidenced by so many errata, which can be disappointing especially when the solution is wrong. On the other hand, there are some very interesting and genuine uses of various Excel functions to solve business problems.
I wouldn't recommend this book for beginners. If you're trying to learn Excel, this is not the book. It is not a book to teach excel, but a book to teach you what you can do with Excel to solve everyday problems, given you're familiar with the mechanics of excel.
I would recommend it with these caveats. And getting Walkenbach's book on Excel functions along with this would be very helpful in my opinion. Best of luck in your endeavors.
Excellent.......2007-04-11
I have read many books in excel, but this book is really the most beneficial and excellent book I've used in my life. It is full with practical not theoritical examples. and you can benefit form it in your work.
Very practical, but full of errors.......2007-04-02
Overall, I like this book, even though it is somewhat confusing, both in scope and in the target audience.
The techniques of "naming the range" or writing the "if" formula are certainly targeted for beginners, but most of statistical tools are normally used by more advanced users.
The worst thing, though, is that the book is full of errors, both typos and mistakes in problem solutions on the disk. I consider myself an intermediate user, so finding an error in "instructor solution" was more like an additional challenge for me, but for the beginner this could be very frustrating.
On the positive side - I really liked the idea of problems in the end of each chapter; so many books just give you the theory and then you do not know how to solve a real life problem. For most of chapters, I knew the tools, but still had to spend time figuring out the best way to implement it for problem solving.
Very practical book, good for an intermediate users. Just be aware of the typos !
Book Description
Applied Equity Analysis treats stock valuation as a practical, hands-on tool rather than a vague, theoretical exercise—and covers the entire valuation process from financial statement analysis through the final investment recommendation. Its integrated approach to valuation builds viable connections between a firm’s competitive situation and the ultimate behavior of its common stock. Techniques explained include EVA, newer hybrid valuation techniques, and relative multiple analysis.
Download Description
Applied Equity Analysis treats stock valuation as a practical, hands-on tool rather than a vague, theoretical exercise--and covers the entire valuation process from financial statement analysis through the final investment recommendation.
Customer Reviews:
great book for those in finance.......2006-06-20
This book is great if you're in the field of finance. This is not for the average consumer looking for investment advice. I've been in corporate financial planning and analyis for the past five years and always wondered how equity analysts built their models. This books will give you insight into their thinking and also give enough detail to build your own models. I would have rated it five stars if the book included a CD with his examples in Excel. The author does have website where you can download sample models.
for SELL-SIDE analysts only.......2006-01-14
I bought this book based on the strong reviews as a complement to Damodaran's classic on valuation, but felt disappointed.
To qualify my comments: First, I am not a sell-side analyst, and secondly, I haven't finished the book. After about 50 pages, I threw in the towel.
My first stylistic objection to the book is its low content density. There is tremendous repetition and examples are trotted out in excruciating detail, even where the conclusions are fairly obvious. For example, on p. 34: "At competitive equilibrium, the firm can identify no incremental investment opportunities likely to generate returns in excess of capital costs. Competitive equilibrium is often defined as a condition in which investment opportunities generate returns equal to capital costs, but existing investments continue to earn abnormal rates." To me these two sentences are already redundant. But in case you still didn't get it, further DOWN on the SAME PAGE: "...This situation is called economic equilibrium, or economic parity. What does equilibrium mean? When returns are forced down to capital costs, then economic rents and/or abnormal earnings disappear and no further incentive to enter the business exists".
But the most frequently repeated point of the first two chapters, is best summed up on p. 19: "As I say many times in the coming pages [and he's not kidding, there], equity analysis is not prophecy; it's opinion. It was never meant to be objective description, but it is strong advocacy." If you're the sell-side analyst, having to "dress up a pig" to help your firm gain some banking business, this book might offer some ideas. But where does this leave the consumer of such analysis? "It's the investor's job to 'diversify' by considering a variety of analysts' positions." (p.9)
I think better advice for the investor might be to learn how to perform sound analysis themselves. For that, I recommend Damodaran's book. I lost my faith in this book's intent to provide balanced (let alone predictive) analysis.
One of the Best.......2005-11-01
There are reams and reams of investment valuation books on the market -- that is obvious.
In my opinion, the three no one should be without are Applied Equity Analysis, Stephen Penman's monster tome "financial statements and...", and lastly, Aswath Damadoran's book, "investment valuation."
Most hyperventilating MBAs default to Damadoran; I really enjoy the simplicity behind Applied Equity Analysis.
Caution: Neither of the 3 are what you'd call "light reading."
If you have any money left, honorable mention goes to Cooke's "security analysis on wall street."
Probably the best.......2004-07-15
I've been looking for a practical step by step book on equity analysis from a practitioners viewpoint. This is it. Other books try to take shortcuts. This book does not take short-cuts, but neither is it bogged down with unncessary academic exercises. If you really want to understand how to do valuation and applied equity analysis I can't recommend any book more highly. It is head and shoulders above anything else out there. Penman's book (from Columbia Business School) is also good but it is a VERY serious and weighty book that probably should only be attacked after you have read this one. Get this book by English and you will not be sorry. I have spent way too much time reading hundreds of other books that weren't nearly as educational. Again, however, it is only for the serious investor.
Very readable, very insightful, and extremely practical.......2001-09-23
James English's "Applied Equity Analysis" is a how-to manual on evaluating stocks based on his 20 years of experience at JP Morgan. The book is very well-written and readable since the author employs plain english (no pun intended) to make his three major points: 1) accounting numbers--while by no means perfect--are excellent tools in evaluating stocks, 2) accounting-based stock valuation is superior to (but does not neccessarily supplant) cash flows, and 3) competition ensures that eye-popping financial performance doesn't last forever.
Contrary to another reviewer, English employs excellent examples to clarify and explain his points. Some examples: Gateway 2000's earnings history was used to explain how to find and interpret non-recurring items (NRI) on financial statements. Ratio analysis was demonstrated by looking at the PC industry in 1998. Emerson Electric was the company chosen to show why mature companies were still good buys. Many other examples abound, and English does a successful job in tying their relevance to his arguements.
But successful use of examples is not just the only strength of the book. The author also tackles a range of topics complete with insightful and clear discussions: the flaws of the Efficient Market Hypothesis (EMH), Economic Value Added (EVA), financial statement analysis, fundamental analysis, etc.
A quick glance at the table of contents below gives you an idea of the scope of English's book. I highly recommend this book to not just Wall Street analysts, anyone who is interested in finding fundamental value in evaluating stocks instead of following the crowd.
Pt. 1 Getting Started
Ch. 1 A Day in the Life
Ch. 2 Fundamentals of Equity Valuation
Ch. 3 Strategy and Competition I: The Firm's External Environment
Ch. 4 Strategy and Competition II: The Firm's Internal Competitive Resources
Ch. 5 Fundamentals of Stock Behavior
Pt. 2 The Basic Tools
Ch. 6 Reading a Financial Statement: The Accuracy, Sustainability, and Predictability of Financial Information
Appendix 6-1 Gateway Financial Statements
Ch. 7 Reading a Financial Statement: the Composition of Returns
Appendix 7-1 Comparative Financial Analysis: Personal Computer Industry
Ch. 8 Reading a Financial Statement: Early-Stage Companies and Investment Capacity
Ch. 9 Reading a Financial Statement: Later-Stage Companies and the Transition to Maturity
Ch. 10 Economic Value Added: An Alternative to Traditional Analysis Techniques
Appendix 10-1 Gateway's Cost of Capital
Pt. 3 Financial Models
Ch. 11 Financial Modeling: Base Case Assumptions and Model Design
Appendix 11-1 Dell Computer Corporation Consolidated Statement of Income
Ch. 12 Financial Modeling: The Income Statement and Balance Sheet
Ch. 13 Financial Modeling: The Statement of Cash Flows
Pt. 4 Equity Valuation
Ch. 14 Valuation: Foundations and Fundamentals
Ch. 15 Combat Finance: Relative Methods and Companion Variable Models
Ch. 16 Hybrid Valuation Techniques
Ch. 17 The Quirky Price/Earnings Ratio
Ch. 18 Valuation of Speculative Stocks
Ch. 19 Equity Analysis and Business Combinations
Pt. 5 Getting It Down on Paper
Ch. 20 Financial Writing: Don't Bury the Lead
Bibliography
Index
Book Description
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
Customer Reviews:
goes beyond deterministic assumptions.......2007-06-24
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.
Financial Modeling with Crystal Ball and Excel.......2007-05-13
Acho que faltou um pouco mais de detalhes nos tópicos, porém o livro apresenta excelente modelos técnicos.
Book Description
An inside look at modern approaches to modeling equity portfolios
Financial Modeling of the Equity Market is the most comprehensive, up-to-date guide to modeling equity portfolios. The book is intended for a wide range of quantitative analysts, practitioners, and students of finance. Without sacrificing mathematical rigor, it presents arguments in a concise and clear style with a wealth of real-world examples and practical simulations. This book presents all the major approaches to single-period return analysis, including modeling, estimation, and optimization issues. It covers both static and dynamic factor analysis, regime shifts, long-run modeling, and cointegration. Estimation issues, including dimensionality reduction, Bayesian estimates, the Black-Litterman model, and random coefficient models, are also covered in depth. Important advances in transaction cost measurement and modeling, robust optimization, and recent developments in optimization with higher moments are also discussed.
Sergio M. Focardi (Paris, France) is a founding partner of the Paris-based consulting firm, The Intertek Group. He is a member of the editorial board of the Journal of Portfolio Management. He is also the author of numerous articles and books on financial modeling. Petter N. Kolm, PhD (New Haven, CT and New York, NY), is a graduate student in finance at the Yale School of Management and a financial consultant in New York City. Previously, he worked in the Quantitative Strategies Group of Goldman Sachs Asset Management, where he developed quantitative investment models and strategies.
Download Description
An inside look at modern approaches to modeling equity portfolios Financial Modeling of the Equity Market is the most comprehensive, up-to-date guide to modeling equity portfolios. The book is intended for a wide range of quantitative analysts, practitioners, and students of finance. Without sacrificing mathematical rigor, it presents arguments in a concise and clear style with a wealth of real-world examples and practical simulations. This book presents all the major approaches to single-period return analysis, including modeling, estimation, and optimization issues. It covers both static and dynamic factor analysis, regime shifts, long-run modeling, and cointegration. Estimation issues, including dimensionality reduction, Bayesian estimates, the Black-Litterman model, and random coefficient models, are also covered in depth. Important advances in transaction cost measurement and modeling, robust optimization, and recent developments in optimization with higher moments are also discussed. Sergio M. Focardi (Paris, France) is a founding partner of the Paris-based consulting firm, The Intertek Group. He is a member of the editorial board of the Journal of Portfolio Management. He is also the author of numerous articles and books on financial modeling. Petter N. Kolm, PhD (New Haven, CT and New York, NY), is a graduate student in finance at the Yale School of Management and a financial consultant in New York City. Previously, he worked in the Quantitative Strategies Group of Goldman Sachs Asset Management, where he developed quantitative investment models and strategies.
Customer Reviews:
great book for modeling.......2007-08-09
this is a good introductory book for quantitative developers. Many of the recent research and application of the financial engineering idea has rendered some famous books not as up-to-date as needed.
The financial modeling has a lot of different methods and directions, this book definitly did not cover all those new developments. But it is almost impossible to do that, instead, it does covers a lot interesting ground. And I find almost few other books overlap with this one so far, so even on cost per coverage basis, it is a good buy.
Also check out the other book written by this trio, "Robust Portfolio Optimization and Management".
Comprehensive Coverage of Quantitative Equity Models.......2006-09-26
Fabozzi, the guy who churned out a dozen fixed income books, has turned his attention to equity models. With two coauthors, his Financial Modeling of the Equity Market book is a comprehensive treatise on quantitative methodologies employed in equity investment and trading. Densely packed with mathematical and statistical formulae, this book is an excellent reference guide for those desiring to learn and understand equity models. The reason I didn't give it 5 stars is, like other Fabozzi books, this is heavy on the "trees" but light on the "forest," i.e., it gives you lots of equations and details but does not provide a good overview as to the why. In a sense, its audience is the technocrats, not the thinkers. It's good for the financial engineers, not the financial innovators. Still, the vast majority of us on Wall Street, yours truly included, are technical people who don't have a vision, so for us mere mortals, this is a one-stop-shop book on quant equity models.
Really good reference book.......2006-07-29
It is the book I'd like to keep on my shelf. Very comprehensive and up-to-date, though a little bit condensed. It starts from portfolio theory and covers forefront techniques and practical issues of equity market modeling. Could be better if there are more examples of model applications.
Very good book.......2006-06-09
This is one of the most complete book that I can find on the quantitative equity management.
It integrates very well both academia with real case.
Worth reading for anyone wishing having a good knowledge of equity markets.
Book Description
Credit risk is today one of the most intensely studied topics in quantitative finance. This book provides an introduction and overview for readers who seek an up-to-date reference to the central problems of the field and to the tools currently used to analyze them. The book is aimed at researchers and students in finance, at quantitative analysts in banks and other financial institutions, and at regulators interested in the modeling aspects of credit risk.
David Lando considers the two broad approaches to credit risk analysis: that based on classical option pricing models on the one hand, and on a direct modeling of the default probability of issuers on the other. He offers insights that can be drawn from each approach and demonstrates that the distinction between the two approaches is not at all clear-cut. The book strikes a fruitful balance between quickly presenting the basic ideas of the models and offering enough detail so readers can derive and implement the models themselves. The discussion of the models and their limitations and five technical appendixes help readers expand and generalize the models themselves or to understand existing generalizations. The book emphasizes models for pricing as well as statistical techniques for estimating their parameters. Applications include rating-based modeling, modeling of dependent defaults, swap- and corporate-yield curve dynamics, credit default swaps, and collateralized debt obligations.
Customer Reviews:
This book is too quick for an introduction.......2006-05-14
I took a master level credit risk class with two assigned textbooks: this one and Quantitative Risk Management by McNeil et al. I love the second book more because it explains the fundamentals in a fabulous way; most of our lectures followed materials in McNeil's. As someone explained in another entry, Lando's book is like a survey book, which is very compact for a beginner.
Not bad at all..........2004-07-22
Contrary to other people, I have found the book very interesting and readable...The author is also referring to practical issues such as asset volatility estimation and CDO pricing..I think this book is more comparable to Bielecki-Rutkowsky kind of book, than to Schonbucher. It gives a good foundation of the theory, even if sometime I would have preferred to have more proofs of theorems.
Compact, readable and fairly complete.
A casual collection of models without sound understanding.......2004-07-20
The author briefly touched many models without quite understanding them himself (or checking their validity). Most of the text were collected (and rewritten) from reading the abstract or conclusion of the original papers. There is not enough insight or new info. It is absolutely not a book for someone who wants to learn because it is like a undergraduate's study report. If a book reviews many models, it should provide some insights, pros and cons of them, and at least some framework for other researchers to follow. It loses value if it merely rephrases some obvious and straghtforward assumptions of the original models.
I admire the author and the editor (Duffie) as researchers. However, the author is not ready yet to write a book of this kind and the editor has been a super star in finance, hence should not lower himself to this level for the sake of publication. This book does not provide useful info at all. Not good for a researcher or a practitioner (at all). Why not read the original papers' abstracts? That would be more informative.
A book for those who think Robert Jarrow is a lightweight!.......2004-07-02
Robert Jarrow praises this book! I think that tells you the level of this text. It's Ivy League Ph.D.-school material with inadequate background provided. I guess if you are already a director of research in an investment bank, this book provides a lucid and compact survey of the current state-of-the-art techniques of credit risk modeling. In short, this is a book written for people who already are comfortable with the subject at a very high level.
If you are a regular Schmoe like myself (someone comfortable at the Hull or Cuthbertson and Nitzche level) much of this book may zoom over your head. But if you regulary snicker at folks like me as derivatives dilatants and poseurs, I'd say check it out.
The book may be great. But for me it was a waste of money.
Did I mention that Robert Jarrow likes it?
Book Description
The essential premise of this book is that theory and practice are equally important in describing financial modeling. In it the authors try to strike a balance in their discussions between theories that provide foundations for financial models and the institutional details that provide the context for applications of the models. The book presents the financial models of stock and bond options, exotic options, investment grade and high-yield bonds, convertible bonds, mortgage-backed securities, liabilities of financial institutions -- the business model and the corporate model. It also describes the applications of the models to corporate finance. Furthermore, it relates the models to financial statements, risk management for an enterprise, and asset/liability management with illiquid instruments. The financial models are progressively presented from option pricing in the securities markets to firm valuation in corporate finance, following a format to emphasize the three aspects of a model: the set of assumptions, the model specification, and the model applications. Generally, financial modeling books segment the world of finance as "investments," "financial institutions," "corporate finance," and "securities analysis," and in so doing they rarely emphasize the relationships between the subjects. This unique book successfully ties the thought processes and applications of the financial models together and describes them as one process that provides business solutions. Created as a companion website to the book readers can visit www.thomasho.com to gain deeper understanding of the book's financial models. Interested readers can build and test the models described in the book using Excel, and they can submit their models to the site. Readers can also use the site's forum to discuss the models and can browse server based models to gain insights into the applications of the models. For those using the book in meetings or class settings the site provides Power Point descriptions of the chapters. Students can use available question banks on the chapters for studying.
Customer Reviews:
Not recommended.......2007-09-17
"Hodge-podge" is the first term that comes to mind after reading this book. The breadth of topics is notable, but the material itself is far from satisfactory as applied to the real world. If someone offers to pay you to read this book, it would be worth reading. Also, please note that several five-star reviews were written professionally for promotional purposes.
Much worse than Hull's book.......2005-05-20
Ho and Lee's book is not bad, but not as good as Hull's book. First, this book tries to include everything, making it not easy to learn for beginners. Second, the definition in this book is not very clear as hull's book. Third, after reading the book, I really don't know what are models for and how to implement these models; hence, I still have to refer these model from Hull's book.
Excellent Book.......2004-10-07
The field of quantitative financial modeling, young as it is, has seen a massive explosion of published books in recent times. While it may appear that there is now a wealth of literature on financial modeling out there, the sad reality is it has become very difficult to find well-written comprehensive books. Dr T. S. Y. Ho and Prof S. B. Lee's book is in my opinion the most comprehsive book on financial modeling since J. Hull's book. Their book even takes a big step further than John Hull in setting a mathematical framework for consistent valuation of derivatives, corporate liabilities and valuation of firms (Corporate Finance).
This is a an excellent book for researchers, practitioners and students alike. Readers will benefit from a wealth of academic and industrial experience of the two authors, which is very well portrayed in every section of the book. In addition to the book they provide a free interactive website (www.thomasho.com) where one can be more intimate with the financial models discussed in book. One may recall that Dr Ho and Prof Lee are the authors of the Ho-Lee model.
Fake reviewers.......2004-07-17
I am afraid that the 3 reviewrs before me are the same person.
Amazon makes it quite easy for promotional wizards to do that so sales can be increased.
So far there is not even one review that tackes or critisizes this book. Are we all that perfect or should we become a victims of made up book?
Brilliant educational project.......2004-04-04
Most textbooks on financial modeling are devoted to describing specific models, such as those for stocks, bonds, or options, or to their specific applications such as arbitrage trading and portfolio management. Few books describe the financial principles behind the models and tie the models to business solutions.
The Oxford Guide to Financial Modeling by Thomas S.Y. Ho and Sang Bin Lee (yes, the authors of the Ho-Lee model, the first arbitrage-free interest rate model) successfully ties the thought processes and applications of the financial models together and describes them as one process which provides business solutions. The authors very ably explain all the models used in finance, take the financial theory and modeling to the next level and develop a business model framework that integrate the fields of corporate finance, fixed income, derivatives, and Asset & Liability management.
Each chapter begins by introducing a practical problem. The financial models that provide solutions to the problem are then described. The chapter concludes with how the models can be applied. Because of the nature of the material on financial models, the book presents many results as mathematical formulations, yet the text is very enjoyable as the more rigorous mathematical derivations are deferred to the appendices and to the epilogue.
What really makes The Oxford Guide to Financial Modeling a brilliant educational project and just not another excellent textbook is the companion web site that serves as an interactive workbook designed specifically for the book. The site is designed to further enhance understanding of the use and applications of the models referred to in the book and it is accessible free of charge.
Books:
- Modeling the Supply Chain
- Moduli Spaces of Curves, Mapping Class Groups and Field Theory
- Multivariate Calculus and Mathematica: With Applications to Geometry and Physics
- National Electrical Code 2005 Softcover Version (National Fire Protection Association National Electrical Code)
- Nonblocking Electronic and Photonic Switching Fabrics
- Numerical Recipes in C: The Art of Scientific Computing
- Numerical Solution of Stochastic Differential Equations (Stochastic Modelling and Applied Probability)
- Optimal Control: An Introduction to the Theory and Its Applications (Dover Books on Engineering)
- Physics for Scientists and Engineers with Modern Physics, Third Edition
- Physics for Scientists and Engineers with Modern Physics, Third Edition
Books Index
Books Home
Recommended Books
- The Courage to Be
- Splendid Soups: Recipes and Master Techniques for Making the World's Best Soups
- More Than Enough: A Novel
- How Democracies Lose Small Wars: State, Society, and the Failures of France in Algeria, Israel in Le
- How to Ruin Your Financial Life
- Photonic Crystals: The Road from Theory to Practice
- Lonely Planet Southeast Asia on a Shoestring
- The Rediscovered Benjamin Graham: Selected Writings of the Wall Street Legend
- Inside the Celtic Tiger: The Irish Economy and the Asian Model
- John Wesley-Into All the World
Structured Finance Modeling with Object-Oriented VBA (Wiley Finance)
Introduction to Structured Finance (Frank J. Fabozzi Series)
Credit Risk Modeling using Excel and VBA (The Wiley Finance Series)
Collateralized Debt Obligations: Structures and Analysis, 2nd Edition (Wiley Finance)
The Structured Credit Handbook (Wiley Finance)
