Advanced Financial Modeling Based on Excel and VBA

Author: Jackson
Publisher:
Publish Date: 2006-07-01
Features: This book implements most financial models using spreadsheet software. These models cover the entire field of finance, including stocks, stock options, and bond options. Based on an overview of the financial field, the book connects the assumptions in asset pricing, mathematical problems, numerical methods, and Excel solutions, summarizing general principles. It then provides detailed explanations of how to use macros and functions in Excel to perform calculations related to stocks, options, and bonds. A key feature of this book is the organic integration of computer applications with financial calculations. By studying this book, readers can become familiar with and reinforce most classic theories in the field of finance while also learning programming knowledge for Excel. Readers will be able to easily use Excel to perform financial calculations. This book can serve as a textbook for senior undergraduate and graduate students in finance, as well as a reference tool for finance professionals. This book implements most financial models using spreadsheet software. These models cover the entire field of finance, including stocks, stock options, and bond options. Based on an overview of the financial field, the book connects the assumptions in asset pricing, mathematical problems, numerical methods, and Excel solutions, summarizing general principles. It then provides detailed explanations of how to use macros and functions in Excel to perform calculations related to stocks, options, and bonds. A key feature of this book is the organic integration of computer applications with financial calculations. By studying this book, readers can become familiar with and reinforce most classic theories in the field of finance while also learning programming knowledge for Excel. Readers will be able to easily use Excel to perform financial calculations. This book can serve as a textbook for senior undergraduate and graduate students in finance, as well as a reference tool for finance professionals.