Mastering Financial Mathematics in Microsoft Excel 2013

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:

  Explains basic calculations for mathematical finance

  Demonstrates how to use formulas with straightforward Excel  templates

  Provides a library of basic templates

Fully updated and compliant with the latest Microsoft Excel versions , this guide is an essential toolkit for anyone involved in finance. Designed for company accountants and financial controllers, through to business students and analysts, this book will provide a solid grounding in using Excel for financial mathematics. Explaining basic calculations and featuring examples and exercises, the third edition covers:

  Cash flows

  Bond calculations and bond risks

  Amortisation and depreciation

  Forward interest rates and futures

  Foreign exchange

  Valuation

  Leasing

  Basic statistics