Alastair Day – Mastering Financial Mathematics in Microsoft Excel. A Practical Guide for Business Calculations

Description

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

 

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

 

About the authors

 

Alastair Day has worked in the finance industry for more than 25 years in treasury and marketing functions and was formerly a director of a vendor leasing company specializing in the IT and technology industries. After sale to a public company he established Systematic Finance as a consultancy specializing in:

 

■ Financial modelling – review, design, build and audit

 

■ Training in financial modelling, corporate finance, leasing and credit analysis on an in-house and public basis throughout Europe, Middle East, Africa, Asia and America

 

■ Finance and operating lease structuring as a consultant and lessor

 

Alastair is author of three modelling books published by FT Prentice Hall: Mastering Financial Modelling, Mastering Risk Modelling and Mastering Financial Mathematics in Excel, all of which are in their second editions, as well as other books and publications on financial analysis and leasing.

 

 

 

Alastair has a degree in Economics and German from London University and an MBA from the Open University Business School.