Revised edition of the author's Mastering financial mathematics in Microsoft Excel, 2010.
Fully updated and compliant with Excel 2013, this clearly explains the basic calculations for mathematical finance, backed up with simple templates for further use and development, and a workbook with exercises and solutions at the end of each chapter. The examples used are relevant to both managers and students in the UK and overseas.
Mastering Financial Mathematics in Microsoft Excel provides a comprehensive set of tools, methods and formulas which apply Excel to solving problems in financial mathematics. This practical guide:
Alastair Day has worked in the finance industry for 20 years in treasury and marketing functions. Alastair has a degree in Economics and German from London University, an MBA from the Open University Business School, and is an associate lecturer in corporate finance with the OUBS.
1 Introduction
2 Basic financial arithmetic
3 Cash flows
4 Bonds calculations
5 Bonds risks
6 Floating rate securities
7 Amortization and depreciation
8 Swaps
9 Forward interest rates
10 Futures
11 Foreign exchange
12 Options
13 Real options
14 Valuation
15 Leasing
16 Basic statistics
Fully updated and compliant with Excel 2013 , this clearly explains the basic calculations for mathematical finance, backed up with simple templates for further use and development, and a workbook with exercises and solutions at the end of each chapter. The examples used are relevant to both managers and students in the UK and overseas. New to this edition Updated glossary of key terms Functions list in English and Euro languages Continuity check on all formats, layouts and charts More worked examples Additional exercises at the end of each chapter to help build models Templates and models available online