Mastering Financial Mathematics in Microsoft Excel: A practical guide to business calculations, 3rd Edition

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

Table of Contents

Chapter 1 Introduction
Chapter 2 Basic financial arithmetic
Chapter 3 Cash flows
Chapter 4 Bonds calculations
Chapter 5 Bond risks
Chapter 6 Floating rate securities
Chapter 7 Amortisation and depreciation
Chapter 8 Swaps
Chapter 9 Forward interest rates
Chapter 10 Futures
Chapter 11 Foreign exchange
Chapter 12 Options
Chapter 13 Real options
Chapter 14 Valuation
Chapter 15 Leasing
Chapter 16 Basic statistics