Skip to content

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

Best in textbook rentals since 2012!

ISBN-10: 0273688669

ISBN-13: 9780273688662

Edition: 2005

Authors: Alastair Day

List price: $65.99
Blue ribbon 30 day, 100% satisfaction guarantee!
what's this?
Rush Rewards U
Members Receive:
Carrot Coin icon
XP icon
You have reached 400 XP and carrot coins. That is the daily max!

Description:

Aimed at financial managers, finance professionals and finance students, this practical guide provides a set of tools and methods for using Excel for solving problems in financial mathematics.
Customers also bought

Book details

List price: $65.99
Copyright year: 2005
Publisher: FT Press
Publication date: 9/8/2005
Binding: Mixed Media
Pages: 368
Size: 6.75" wide x 9.25" long x 1.00" tall
Weight: 1.782
Language: English

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.

Acknowledgements
About the author
Conventions
Overview
Warranty and disclaimer
Introduction
Overview
Common Excel errors
Systematic design method
Auditing
Summary
Basic financial arithmetic
Simple interest
Compound interest
Nominal and effective rates
Continuous discounting
Conversions and comparisons
Exercise
Summary
Cash flows
Net present value
Internal rate of return
XNPV and XIRR
XNPV periodic example
Modified internal rate of return
Exercise
Summary
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
Bonds risks
Risks
Duration
Convexity
Comparison
Exercise
Summary
Floating rate securities
Floating rates
Characteristics of interest rate securities
Yield evaluation
Coupon stripping
Exercise
Summary
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
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
Forward interest rates
Definitions
Example forward rates
Hedging principles
Forward rate agreement
Yield curves
Exercise
Summary
Futures
Futures market
Terminology
Benefits
Clearinghouse operation
Bond futures
Hedging mechanisms
Hedging example one
Hedging example two
Exercise
Summary
Foreign exchange
Risk
Spot rates
Longer dates
Equivalence
Comparisons and arbitrage
Exercise
Summary
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
Real options
Real options
Black Scholes model
Binomial model
Exercise
Summary
Valuation
Valuation methods
Assets
Market methods
Multi-period dividend discount models
Free cash flow valuation
Adjusted present value
Economic profit
Exercise
Summary
Leasing
Economics of leasing
Interest rates
Classification
Amortization
Accounting
Settlements
Lessor evaluation
Lessee evaluation
Exercise
Summary
Basic statistics
Methods
Descriptive statistics
Probability distributions
Sampling/Central Limit Theorem
Hypothesis testing
Correlation and regression
LINEST function
Exercise
Summary
Appendix
Index