Mastering Financial Mathematics in Microsoft Excel: A Practical Guide to Business Calculations: The Mastering Series

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

• 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