Mastering Financial Mathematics in Excel

2nd Edition : Apr 2010

ISBN13: 9780273730330
ISBN10: 0273730339

A practical guide for business calculations

 Mastering Financial Mathematics in Microsoft © Excel provides a comprehensive set of tools, methods and formulas which apply Excel to solving mathematical problems.

The book:

• Explains basic calculations for mathematical finance
• Shows how to use formulas using straightforward Excel templates
• Provides a CD of basic templates

This fully revised and updated guide is an essential companion for anyone involved in finance, from company accountants, through to analysts, treasury managers and business students. Explaining basic calculations and using examples and exercises, the book covers:

• Cash flows
• Bonds calculations and bonds risks
• Amortization and depreciation
• Forward interest rates and futures
• Foreign exchange
• Valuation
• Leasing

Mastering Financial Mathematics in Microsoft Excel is a practical guide to using Excel for financial mathematics. This new edition includes:

• Excel 2007
• Addition of a glossary of key terms
• Functions list in English and Euro languages
• Continuity check on all formats, layouts and charts
• More worked examples
• Addition of exercises at the end of each chapter to help build models