Mastering Financial Mathematics in Microsoft Excel: A Practical Guide for Business Calculations (2nd Edition) (Financial Times)

Mastering Financial Mathematics in Microsoft Excel: A Practical Guide for Business Calculations (2nd Edition) (Financial Times), 9780273730330 (0273730339), FT Press, 2010

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.

Comments

Amazing Books

Mac OS X Leopard All-in-One Desk Reference For Dummies

For Dummies, 2007

Your new Mac with OS X Leopard is so cool! You have digital media, including iTunes, iPhoto, iDVD, and iMovie, at your fingertips, as well as everything the Internet has to offer. Where do you start to make the most of it? With Mac OS X Leopard All-In-One Desk Reference for Dummies, of course! Here are seven handy minibooks, each devoted to one...

Max Ferguson's Digital Darkroom Masterclass

Focal Press, 2000

Max Ferguson is a leading monochrome printer. Well established in his field, he has worked for many top photographic laboratories, including Joe's Basement and Visualeyes. He has also run his own successful business. Max is now based in Australia, working for Photo Technica.

To find out 'what happens between click and...

Real World OCaml: Functional programming for the masses

O'Reilly, 2013

This fast-moving tutorial introduces you to OCaml, an industrial-strength programming language designed for expressiveness, safety, and speed. Through the book’s many examples, you’ll quickly learn how OCaml stands out as a tool for writing fast, succinct, and readable systems code.

Real World OCaml takes you...

Machine Learning and Data Mining for Computer Security: Methods and Applications

Springer, 2005

"Machine Learning and Data Mining for Computer Security" provides an overview of the current state of research in machine learning and data mining as it applies to problems in computer security. This book has a strong focus on information processing and combines and extends results from computer security.

The first part of the...

Color Atlas of Pharmacology

Thieme Medical Publishers, 2005

In many countries, medicine is at present facing urgent political and economic calls for reform. These socioeconomic pressures notwithstanding, pharmacotherapy has always been an integral part of the health care system and will remain so in the future. Well-founded knowledge of the preventive and therapeutic value of...

Performance Metrics for Haptic Interfaces (Springer Series on Touch and Haptic Systems)

Springer, 2012

Haptics technology is being used more and more in different applications, such as in computer games for increased immersion, in surgical simulators to create a realistic environment for training of surgeons, in surgical robotics due to safety issues and in mobile phones to provide feedback from user action. The existence of these applications...