Alastair Day
Broschiertes Buch

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