A substantially updated new edition of the essential text on financial modeling, with revised material, new data, and implementations shown in Excel, R, and Python. Financial Modeling has become the gold-standard text in its field, an essential guide for students, researchers, and practitioners that provides the computational tools needed for modeling finance fundamentals. This fifth edition has been substantially updated but maintains the straightforward, hands-on approach, with an optimal mix of explanation and implementation, that made the previous editions so popular. Using detailed Excel spreadsheets, it explains basic and advanced models in the areas of corporate finance, portfolio management, options, and bonds. This new edition offers revised material on valuation, second-order and third-order Greeks for options, value at risk (VaR), Monte Carlo methods, and implementation in R. The examples and implementation use up-to-date and relevant data. Parts I to V cover corporate finance topics, bond and yield curve models, portfolio theory, options and derivatives, and Monte Carlo methods and their implementation in finance. Parts VI and VII treat technical topics, with part VI covering Excel and R issues and part VII (now on the book’s auxiliary website) covering Excel’s programming language, Visual Basic for Applications (VBA), and Python implementations. Knowledge of technical chapters on VBA and R is not necessary for understanding the material in the first five parts. The book is suitable for use in advanced finance classes that emphasize the need to combine modeling skills with a deeper knowledge of the underlying financial models.

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 problems with spreadsheets. The CD-ROM contains Excel* worksheets and solutions to end-of-chapter exercises. 634 illustrations.

The Oxford Guide to Financial Modeling is accompanied by a companion web site that serves as an interactive workbook designed specifically for the book. This site is simple to use yet exceedingly robust with regard to its technological efficiency and purposeful usability. It 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 at www.thomasho.com. This on-line workbook and resource tool contains more than 95 downloadable Excel models. The models provide clear expositions of the mathematical formulations and can be used along with the book. The companion web site is rich with a plethora of research and analytic tools designed for "doing finance" on-line.

This book contains several innovative models for the prices of financial assets. First published in 1986, it is a classic text in the area of financial econometrics. It presents ARCH and stochastic volatility models that are often used and cited in academic research and are applied by quantitative analysts in many banks. Another often-cited contribution of the first edition is the documentation of statistical characteristics of financial returns, which are referred to as stylized facts. This second edition takes into account the remarkable progress made by empirical researchers during the past two decades from 1986 to 2006. In the new Preface, the author summarizes this progress in two key areas: firstly, measuring, modelling and forecasting volatility; and secondly, detecting and exploiting price trends. Sample Chapter(s). Chapter 1: Introduction (1,134 KB). Contents: Features of Financial Returns; Modelling Price Volatility; Forecasting Standard Deviations; The Accuracy of Autocorrelation Estimates; Testing the Random Walk Hypothesis; Forecasting Trends in Prices; Evidence Against the Efficiency of Futures Markets; Valuing Options; Appendix: A Computer Program for Modelling Financial Time Series. Readership: Academic researchers in finance & economics; quantitative analysts.

Financial Modeling for Business Owners and Entrepreneurs: Developing Excel Models to Raise Capital, Increase Cash Flow, Improve Operations, Plan Projects, and Make Decisions may be one of the most important books any entrepreneur or manager in a small or medium-sized enterprise will read. It combines logical business principles and strategies with a step-by-step methodology for planning and modeling a company and solving specific business problems. You’ll learn to create operational and financial models in Excel that describe the workings of your company in quantitative terms and that make it far more likely you will avoid the traps and dead ends many businesses fall into. Serial entrepreneur and financial expert Tom Y. Sawyer shows how to break your company down into basic functional and operational components that can be modeled. The result is a financial model that, for example, you can literally take to the bank or bring to local angel investors to receive the funding you need to launch your business or a new product. Or it might be a model that shows with startling clarity that your new product development effort is a likely winner—or loser. Even better, you’ll learn to create models that will serve as guideposts for ongoing operations. You’ll always know just where you are financially, and where you need to be. The models you will learn to build in Financial Modeling for Business Owners and Entrepreneurs can be used to: Raise capital for startup or any stage of growth Plan projects and new initiatives Make astute business decisions, including go/no-go assessments Analyze ROI on your product development and marketing expenditures Streamline operations, manage budgets, improve efficiency, and reduce costs Value the business when it is time to cash out or merge In addition to many valuable exercises and tips for using Excel to model your business, this book contains a combination of practical advice born of hard-won lessons, advanced strategic thought, and the insightful use of hard skills. With a basic knowledge of Excel assumed, it will help you learn to think like an experienced business person who expects to make money on the products or services offered to the public. You’ll discover that the financial model is a key management tool that, if built correctly, provides invaluable assistance every step of the entrepreneurial journey. Tom Y. Sawyer has used the principles this book contains to create financial models of numerous startup and early-stage companies, assisting them in planning for and raising the capital that they needed to grow their businesses and ultimately exit with multiples of their initial investment. Financial Modeling for Business Owners and Entrepreneurs, a mini-MBA in entrepreneurship and finance, will show you how you can do the same. Note: This book is an updated version of Sawyer's 2009 title, Pro Excel Financial Modeling.

In this book, Pascal Costantini gives a lively and wonderfully readable account of ten years of efforts by a small group of investment analysts to find a reliable, practical and implementable method for valuing and selecting shares. The result of their effort is an original investment methodology called CROCI (Cash Return on Capital Invested), best described as a variation of the economic profit model. For over a decade now, Costantinis group at Deutsche Bank has been using this valuation tool every time it has had to take a view on the pricing of an equity asset, be it a market, a sector or an individual sharein other words, every single working day, since it is this groups job to advise institutional investors on equity valuation. Costantini describes in detail, accompanied by concrete examples in the form of charts and graphs, the precise investment results of the actual implementation of the CROCI approach in the global equity markets since 1996. Readers will enjoy taking this journey with Costantini to see how and why the model was developed, assess the results of ten years of actual implementation and measure the successes of using this model in stock picking and portfolio construction. This book will also make it easy for them to see how the CROCI approach can be used successfully by others now and in the future.The book is divided into four parts. The first part is a review and discussion of the fundamentals of investment analysis. The second part is dedicated to the construction of economic data, with the sole objective of calculating an economically meaningful asset multiple and relative return, the combination of which gives an economic PE ratio, the authors main stock selection tool. While the economic profit model is not exactly new, it is still largely ignored by the investment community. In essence, it does three things: it calculates the real amount of cash, or value created by a business; it compares the market value of an asset to an approximation of its replacement value; and it assumes that the former will converge to the latter through the arbitrage of investors and capital providers. The third part is dedicated to the analysis of economic data, and the last part deals with the actual implementation of the CROCI economic profit model, including real life examples. This final part also discusses how to use the output of the CROCI model with individual stocks, and then with investment portfolios.*Techniques are based on the authors performance record at Deutsche Bank since 1996 *Based on almost ten years of proprietary knowledge and implementation of these techniques*Factual illustrations of the results of the valuation techniques are provided at each step*Techniques are based on the author's performance record at Deutsche Bank since 1996 *Based on almost ten years of proprietary knowledge and implementation of these techniques*Factual illustrations of the results of the valuation techniques are provided at each step

The requirement to maximise value for shareholders is at the core of any corporate investment or financing decision. The intrinsic value of proposed investments should be assessed before deciding how much capital to allocate; the benefits and risks associated with each available source of finance should be considered when capital is being raised; and capital, and any associated financial risks, should be managed in a way that continues to maximise value. At every stage, an analysis should be carried out to ensure the decision is optimal for shareholders and other capital providers.This book provides practical guidance on the application of financial evaluation techniques and methods (mainly covered in Appendices), as well as comprehensive coverage of traditional corporate finance topics, discussed in the context of capital investment, raising and management and financial risk management (using derivatives). Models, formulae and other quantitative techniques are illustrated in over 100 examples (using only basic mathematics). Topics discussed include the following:* business appraisal using financial ratios* corporate valuation (mainly discounted cash flow and real options)*investment appraisal techniques* acquisition structuring and evaluation* the nature of loans and loan agreements* features and pricing of bonds (straight and convertible)* leasing (including leveraged leasing)* equity raising (Initial Public Offerings)* long and short term capital management* basic pricing of derivatives (forwards, futures, options, swaps)* interest rate and currency risk management using derivativesCapital Investment & Financing provides a comprehensive, in-depth coverage of concepts, methods and techniques involved when evaluating acquisitions and other investments, assessing financing opportunities, and managing capital. The core chapters provide practical guidance on key corporate finance topics; the Appendices contain more quantitative material, focusing on pricing techniques. Examples are used throughout, and an integrated case study (fictional) in the final Appendix uses many of the techniques discussed.*Discusses all key areas of corporate investing and financing, focusing on key financial issues *Concise, thorough and technical, it enables to reader to acquire knowledge effectively *Can be used in everyday analysis and decision making

"[This book is] the most authoritative assessment of the advantages and disadvantages of recent trends toward the commercialization of health care," says Robert Pear of The New York Times. This major study by the Institute of Medicine examines virtually all aspects of for-profit health care in the United States, including the quality and availability of health care, the cost of medical care, access to financial capital, implications for education and research, and the fiduciary role of the physician. In addition to the report, the book contains 15 papers by experts in the field of for-profit health care covering a broad range of topicsâ€"from trends in the growth of major investor-owned hospital companies to the ethical issues in for-profit health care. "The report makes a lasting contribution to the health policy literature." â€"Journal of Health Politics, Policy and Law.