
Mastering Financial Mathematics in Microsoft Excel 2013
Versandkostenfrei!
Versandfertig in 1-2 Wochen
48,99 €
inkl. MwSt.
Weitere Ausgaben:
PAYBACK Punkte
24 °P sammeln!
Fully updated and compliant with Excel 2013, this clearly explains the basic calculations for mathematical finance, backed up with simple templates for further use and development, and a workbook with exercises and solutions at the end of each chapter. The examples used are relevant to both managers and students in the UK and overseas.
Product Description
Fully updated and compliant with Excel 2013, this clearly explains the basic calculations for mathematical finance, backed up with simple templates for further use and development, and a workbook with exercises and solutions at the end of each chapter. The examples used are relevant to both managers and students in the UK and overseas.
New to this edition
Updated glossary of key terms
Functions list in English and Euro languages
Continuity check on all formats, layouts and charts
More worked examples
Additional exercises at the end of each chapter to help build models
Templates and models available online
Backcover
Mastering Financial Mathematics in Microsoft Excel provides a comprehensive set of tools, methods and formulas which apply Excel to solving problems in financial mathematics.
This practical guide:
· Explains basic calculations for mathematical finance
· Demonstrates how to use formulas with straightforward Excel templates
· Provides a library of basic templates
Fully updated and compliant with the latest Microsoft Excel versions , this guide is an essential toolkit for anyone involved in finance. Designed for company accountants and financial controllers, through to business students and analysts, this book will provide a solid grounding in using Excel for financial mathematics. Explaining basic calculations and featuring examples and exercises, the third edition covers:
· Cash flows
· Bond calculations and bond risks
· Amortisation and depreciation
· Forward interest rates and futures
· Foreign exchange
· Valuation
· Leasing
· Basic statistics
Acknowledgements
About the author
Conventions
Overview
Warranty and disclaimer
1 Introduction
Overview
Common Excel errors
Systematic design method
Auditing
Summary
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
Appendices
1 Exercise answers, functions list, software installation and licence
2 Microsoft® Office Menus
Index
Product Description
Fully updated and compliant with Excel 2013, this clearly explains the basic calculations for mathematical finance, backed up with simple templates for further use and development, and a workbook with exercises and solutions at the end of each chapter. The examples used are relevant to both managers and students in the UK and overseas.
New to this edition
Updated glossary of key terms
Functions list in English and Euro languages
Continuity check on all formats, layouts and charts
More worked examples
Additional exercises at the end of each chapter to help build models
Templates and models available online
Backcover
Mastering Financial Mathematics in Microsoft Excel provides a comprehensive set of tools, methods and formulas which apply Excel to solving problems in financial mathematics.
This practical guide:
· Explains basic calculations for mathematical finance
· Demonstrates how to use formulas with straightforward Excel templates
· Provides a library of basic templates
Fully updated and compliant with the latest Microsoft Excel versions , this guide is an essential toolkit for anyone involved in finance. Designed for company accountants and financial controllers, through to business students and analysts, this book will provide a solid grounding in using Excel for financial mathematics. Explaining basic calculations and featuring examples and exercises, the third edition covers:
· Cash flows
· Bond calculations and bond risks
· Amortisation and depreciation
· Forward interest rates and futures
· Foreign exchange
· Valuation
· Leasing
· Basic statistics
Acknowledgements
About the author
Conventions
Overview
Warranty and disclaimer
1 Introduction
Overview
Common Excel errors
Systematic design method
Auditing
Summary
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
Appendices
1 Exercise answers, functions list, software installation and licence
2 Microsoft® Office Menus
Index
Fully updated and compliant with Excel 2013, this clearly explains the basic calculations for mathematical finance, backed up with simple templates for further use and development, and a workbook with exercises and solutions at the end of each chapter. The examples used are relevant to both managers and students in the UK and overseas.