Mastering Financial Mathematics in Microsoft Excel
A Practical Guide for Business Calculations
2nd Edition
Published on 29. April 2010
Book
Mixed media product
384 pages
978-0-273-73033-0 (ISBN)
Description
A practical guide for business calculations
Mastering Financial Mathematics in Microsoft (c) 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.
* * * * * * *
Mastering Financial Mathematics in Microsoft (c) 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.
* * * * * * *
More details
Series
Edition
2nd edition
Language
English
Place of publication
Harlow
United Kingdom
Target group
Professional and scholarly
Dimensions
Height: 239 mm
Width: 175 mm
Thickness: 26 mm
Weight
830 gr
ISBN-13
978-0-273-73033-0 (9780273730330)
Copyright in bibliographic data and cover images is held by Nielsen Book Services Limited or by the publishers or by their respective licensors: all rights reserved.
Schweitzer Classification
Other editions
New editions
Alastair Day
Mastering Financial Mathematics in Microsoft Excel 2013
A practical guide to business calculations
Book
10/2015
3rd Edition
FT Publishing International
€87.99
Shipment within 10-20 days
Person
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.
Content
Table of Contents
Acknowledgements
About the Author
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
Advantages of swaps
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
Adjusted present value
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
Acknowledgements
About the Author
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
Advantages of swaps
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
Adjusted present value
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