Mastering Financial Mathematics in Microsoft Excel: A Practical Guide for Business Calculations - Softcover

Day, Alastair

Softcover

ISBN 10: 0273688669 ISBN 13: 9780273688662

Publisher: Financial Times/ Prentice Hall, 2005

Synopsis

There are a number of books on financial mathematics, which either discuss the methods or use HP financial calculators. Using HP calculators is slow and prone to error and the variables cannot be seen once entered. Since most financial managers have Excel on their desk, it is more efficient to solve the problems on spreadsheets and gain the benefits of layout and more comprehensive information.

Day provides a set of tools and methods to apply to Excel for solving mathematical problems. This is a practical guide with exercises and solutions throughout.

About this title

About the Author

Alastair Day has worked in the finance industry for 20 years in treasury and marketing functions. In 1990 he established Systematic Finance as a consultancy and financial lessor concentrating on the computer and communications industries. Alastair has a degree in Economics and German from London University, an MBA from the Open University Business School, and is an associate lecturer in corporate finance with the OUBS. He is the successful author of several books including Mastering financial Modelling, Mastering Risk Modelling and The Financial Director’s Guide to Purchasing Leasing published by the Financial Times Prentice Hall and a range of software products. In addition, he develops and presents public and in-house courses on a range of topics including financial modelling, leasing, credit and cash flow analysis, and other corporate finance topics.

From the Back Cover

Tools enabling managers to carry out financial calculations have evolved in the last 20 years from tables through calculators to programs on PCs and personal organisers. Today, the majority of those in finance have Excel on their desks and increasingly on their laptops or pocket computers.

Mastering Financial Mathematics in Microsoft Excel provides a comprehensive set of tools and methods to apply Excel to solving mathematical problems. Alastair Day clearly explains the basic calculations for mathematical finance backed up with simple templates for further use and development, together with numerous examples and exercises.

Providing an explanation of key financial formulas and subject areas, the book includes a CD which:

·    allows you to work step-by-step through each of the chapters and examples

·    shows the use of formulas using straight-forward Excel templates

·    introduces examples and exercises for extension work

·    provides a menu of basic templates for further development

·    enables you to practise, develop and improve your efficiency and competence with Excel

Mastering Financial Mathematics in Microsoft Excel  will be invaluable in helping improve your Excel skills and understand the underlying financial concepts.

Edition details

• Publisher: Financial Times/ Prentice Hall
• Publication date: 2005
• Language: English
• ISBN 10: 0273688669
• ISBN 13: 9780273688662
• Binding: Paperback
• Edition number: 1
• Number of pages: 368