Financial Modeling bridgesthis gap between theory and practice by providing a nuts-and-bolts guide to solvingcommon financial models with spreadsheets. Simon Benninga takes the reader step bystep through each model, showing how it can be solved using Microsoft Excel. Thelong-awaited third edition of this standard text maintains the "cookbook"features and Excel dependence that have made the first and second editions sopopular. It also offers significant new material, with new chapters covering suchtopics as bank valuation, the Black-Litterman approach to portfolio optimization, Monte Carlo methods and their applications to option pricing, and using arrayfunctions and formulas. Other chapters, including those on basic financialcalculations, portfolio models, calculating the variance-covariance matrix, andgenerating random numbers, have been revised, with many offering substantially newand improved material. Other areas covered include financial statement modeling, leasing, standard portfolio problems, value at risk (VaR), real options, durationand immunization, and term structure modeling. Technical chapters treat such topicsas data tables, matrices, the Gauss-Sidel method, and tips for using Excel. The lastsection of the text covers the Visual Basic for Applications (VBA) techniques neededfor the book. The accompanying CD contains Excel worksheets and solutions toend-of-chapter exercises.Simon Benninga is Dean of the Facultyand Professor of Finance at Tel Aviv University and Visiting Professor of Finance atthe Wharton School at the University of Pennsylvania.

    It is rare that an economist has the courage and aptitude to take a studied look at real world issues and to lay out the advantages and disadvantages of current policies. Coyle takes these potentially confusing and politically rife issues and makes them straightforward, thereby educating the reader in an entertaining and sophisticated manner. Coyle uses humour and irony to explain the issues. Who else could draw a link between Japanese teenage fashion and the country's long standing liquidity trap; or how sunspots can determine whether we will have a financial crisis on earth; or how pork belly futures depend on the weather and pigs' amorous intentions? Throughout the book, Diane Coyle highlights the fact that above all, economics is a social science, and one that affects us all.

    I shall give it in the exact words of that thoughtful historian from whom I have already quoted: "Before the end of the year 1795 the paper money was almost exclusively in the hands of the working classes, employees and men of small means, whose property was not large enough to invest in stores of goods or national lands.