Simon Benninga

Objetivos Aprender Finanzas con Excel sirve para dos propósitos: le enseña una importante materia academica y práctica (finanzas), y le enseña cómo implementar el análisis financiero utilizando la más importante herramienta (en la mayoria de los casos, la unica) para analisis financiero (Excel). Su conocimiento de finanzas y de Excel se potenciara trabajando cuidadosamente con los ejemplos y ejercicios en cada capitulo. Finanzas es una disciplina muy practica. La mayoria de los lectores de este libro estudiaran finanzas no solo para incrementar su comprension del proceso de valuacion, sino tambien con el fin de obtener respuestas a problemas practicos. Usted descubrira que la diversidad de calculos requeridos en este libro no solo le posibilitara obtener respuestas numericas a importantes problemas (lo que ya por si mismo justificaria la orientacion a Excel de este libro) sino tambien profundizara su entendimiento de los conceptos involucrados. Contenidos Prologo Introduccion a las finanzas ¿Que son las finanzas?. Microsoft Excel: ¿por que este libro y no otro? Ocho principios de finanzas. Nota sobre Excel - Construir modelos financieros optimos. Un comentario sobre las versiones de Excel. Agregando "GETFORMULA" a su hoja de calculo. El valor del dinero en el tiempo Conce

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.

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 books auxiliary website) covering Excels 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.