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

Day, Alastair

Couverture souple

ISBN 10 : 0273730339 ISBN 13 : 9780273730330

Editeur : Pearson Education Limited, 2010

Synopsis

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

 

 

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.

 

* * * * * * *

 

A propos du livre

À propos de l?auteur

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.

À propos de la quatrième de couverture

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.

 

Mastering Financial Mathematics in Microsoft Excel is a practical guide with exercises and solutions throughout. Itprovides a comprehensive set of tools and methods that will help you apply Excel to solve mathematical problems. Alistair Day clearly explains the basic calculations for mathematical finance backed up with simple templates for further use and development, together with examples. The new edition includes the addition of end of chapter exercises to help you develop your knowledge. The accompanying CD allows you to use and adapt templates and models.  

Détails de l'édition

• Éditeur: Pearson Education Limited
• Date d'édition: 2010
• Langue: anglais
• ISBN 10: 0273730339
• ISBN 13: 9780273730330
• Reliure: Broché
• Numéro d'édition: 2
• Nombre de pages: 384
• Coordonnées du fabricant: non disponible
• Personne responsable: non disponible