# Mastering Financial Mathematics in Microsoft Excel: A Practical Guide for Business Calculations / Edition 2

Paperback (Print)
\$70.43
(Save 17%)
Used and New from Other Sellers
Used and New from Other Sellers
from \$52.29
Usually ships in 1-2 business days
(Save 38%)
Other sellers (Paperback)
• All (6) from \$52.29
• New (4) from \$52.29
• Used (2) from \$58.76

### Overview

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

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.

*
• *
• *
• *

### Product Details

• ISBN-13: 9780273730330
• Publisher: FT Press
• Publication date: 7/21/2010
• Series: Financial Times Series
• Edition description: New Edition
• Edition number: 2
• Pages: 384
• Sales rank: 1,048,421
• Product dimensions: 6.70 (w) x 9.40 (h) x 1.10 (d)

### Meet 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.

Acknowledgements

Conventions

Overview

Warranty and disclaimer

1 Introduction

Overview

Common Excel errors

Systematic design method

Auditing

Summary

Exercises

2 Basic financial arithmetic

Simple interest

Compound interest

Nominal and effective rates

Continuous discounting

Conversions and comparisons

Exercise

Summary

3 Cash flows

Net present value

Internal rate of return

XNPV and XIRR

XNPV periodic example

Modified internal rate of return

Exercise

Summary

4 Bonds calculations

Description

Cash flows

Zero coupons

Yield

Yield to call

Price and yield relationship

Yield curve pricing

Other yield measures

Yield measures

Exercise

Summary

5 Bonds risks

Risks

Duration

Convexity

Comparison

Exercise

Summary

6 Floating rate securities

Floating rates

Characteristics of interest rate securities

Yield evaluation

Coupon stripping

Exercise

Summary

7 Amortization and depreciation

Amortization

Full amortization

Delayed payments

Sum of digits

Straight line and declining balance depreciation

UK declining balance method

Double declining balance depreciation

French depreciation

Exercise

Summary

8 Swaps

Definitions

How swaps save money

Terminating interest rate swaps

Implicit credit risk

Worked single currency swap

Valuation

Cross currency swap

Worked example

Swaptions

Exercise

Summary

9 Forward interest rates

Definitions

Example forward rates

Hedging principles

Forward rate agreement

Yield curves

Exercise

Summary

10 Futures

Futures market

Terminology

Benefits

Clearinghouse operation

Bond futures

Hedging mechanisms

Hedging example one

Hedging example two

Exercise

Summary

11 Foreign exchange

Risk

Spot rates

Longer dates

Equivalence

Comparisons and arbitrage

Exercise

Summary

12 Options

Description

Terminology

Underlying asset

Call options

Put options

Example

Covered call

Insurance using a stock and a long put

Pricing models

Black Scholes model

Call put parity

Greeks

Binomial models

Comparison to Black Scholes

Exercise

Summary

13 Real options

Real options

Black Scholes model

Binomial model

Exercise

Summary

14 Valuation

Valuation methods

Assets

Market methods

Multi-period dividend discount models

Free cash flow valuation

Economic profit

Exercise

Summary

15 Leasing

Economics of leasing

Interest rates

Classification

Amortization

Accounting

Settlements

Lessor evaluation

Lessee evaluation

Exercise

Summary

16 Basic statistics

Methods

Descriptive statistics

Probability distributions

Sampling/Central Limit Theorem

Hypothesis testing

Correlation and regression

LINEST function

Exercise

Summary

Appendix

Glossary

Index

## Customer Reviews

Be the first to write a review
( 0 )
Rating Distribution

(0)

(0)

(0)

(0)

### 1 Star

(0)

Your Name: Create a Pen Name or

### Barnes & Noble.com Review Rules

Our reader reviews allow you to share your comments on titles you liked, or didn't, with others. By submitting an online review, you are representing to Barnes & Noble.com that all information contained in your review is original and accurate in all respects, and that the submission of such content by you and the posting of such content by Barnes & Noble.com does not and will not violate the rights of any third party. Please follow the rules below to help ensure that your review can be posted.

### Reviews by Our Customers Under the Age of 13

We highly value and respect everyone's opinion concerning the titles we offer. However, we cannot allow persons under the age of 13 to have accounts at BN.com or to post customer reviews. Please see our Terms of Use for more details.

### What to exclude from your review:

Please do not write about reviews, commentary, or information posted on the product page. If you see any errors in the information on the product page, please send us an email.

### Reviews should not contain any of the following:

• - HTML tags, profanity, obscenities, vulgarities, or comments that defame anyone
• - Time-sensitive information such as tour dates, signings, lectures, etc.
• - Single-word reviews. Other people will read your review to discover why you liked or didn't like the title. Be descriptive.
• - Comments focusing on the author or that may ruin the ending for others
• - Phone numbers, addresses, URLs
• - Pricing and availability information or alternative ordering information

### Reminder:

• - By submitting a review, you grant to Barnes & Noble.com and its sublicensees the royalty-free, perpetual, irrevocable right and license to use the review in accordance with the Barnes & Noble.com Terms of Use.
• - Barnes & Noble.com reserves the right not to post any review -- particularly those that do not follow the terms and conditions of these Rules. Barnes & Noble.com also reserves the right to remove any review at any time without notice.
Search for Products You'd Like to Recommend

### Recommend other products that relate to your review. Just search for them below and share!

Create a Pen Name

Your Pen Name is your unique identity on BN.com. It will appear on the reviews you write and other website activities. Your Pen Name cannot be edited, changed or deleted once submitted.

Your Pen Name can be any combination of alphanumeric characters (plus - and _), and must be at least two characters long.

Continue Anonymously

If you find inappropriate content, please report it to Barnes & Noble
Why is this product inappropriate?