Advanced Financial Modeling based on Excel and VBA

Author: Mary Jackson (UK)
Publisher:
Publish Date: 2006-07-01
Features: Most of the financial models in this book are implemented 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, this 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 apply macros and functions in Excel to perform calculations for 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 of the 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. Most of the financial models in this book are implemented 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, this 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 apply macros and functions in Excel to perform calculations for 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 of the 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.