E-Book Overview
Designed for finance directors, finance managers, analysts and decision-makers, Mastering Financial Mathematics in Microsoft Excel, is a practical guide to applying Excel for solving mathematical problems. Financial mathematics can be applied more quickly and easily in Excel than any other package, there is therefore demand for a book in this field. Will improve financial managers’ abilities with Excel and provide them with solutions to their financial problems. Highly practical: includes a library of templates, exercises and solutions as an illustration of the methods. Part of the highly respected and recognised Mastering series. The second edition will be updated throughout. Specific amendments: Excel 2007 and Windows Vista, 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.
E-Book Content
in Microsoft® Excel
A practical guide for business calculations 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 two other modelling books published by FT Prentice Hall: Mastering Financial Modelling and Mastering Risk Modelling both of which are in their second editions, as well as other books and publications on financial analysis and leasing.
MASTERING FINANCIAL mathematics
in Microsoft Excel ®
second edition
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. This practical guide: • 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
Alastair has a degree in Economics and German from London University and an MBA from the Open University Business School.
MASTERING FINANCIAL MATHEMATICS
MASTERING FINANCIAL mathematics
A practical guide for business calculations
mastering financial mathematics in Microsoft® Excel
• A n invaluable explanation of basic calculations and their underlying financial concepts • Includes a companion CD with practical examples, exercises and templates
MASTERING FINANCIAL mathematics
in Microsoft® Excel
A practical guide for business calculations
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 European 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
second edition