Mastering Financial Modelling in Microsoft Excel
Description
Comprehensive tools and methods to help you build, develop and apply financial models using Microsoft Excel, enabling you to get better, more accurate results, faster.
The new edition of this bestselling title begins by explaining basic modelling techniques before moving through to more complex models. The book is divided into two parts: the first part outlines model designs and gives templates, key features and techniques. The second part of the book shows how to build corporate financial models in Excel. The accompanying CD allows you to use and adapt templates and models.
This new edition includes a reworking of the book in Excel 2010 (but with older material still included), inclusion of Apple Mac, addition of specific 2010 features and end of chapter exercises.
More details
Other editions
Additional editions
Person
Alastair Dayhas 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 Cash Flow and Valuation Modelling, Mastering Risk Modelling and The Financial Director's Guide to Purchasing Leasing.
Content
- Part A DEVELOPING FINANCIAL MODELS
- 1 Overview
- 2 Design introduction
- 3 Features and techniques
- 4 Sample model
- 5 Example model
- Part B APPLICATIONS
- 6 Analysing performance
- 7 Cash flow
- 8 Forecasting models
- 9 Forecasting financials
- 10 Variance analysis
- 11 Breakeven analysis
- 12 Portfolio analysis
- 13 Cost of capital
- 14 Bonds
- 15 Investment analysis
- 16 Risk Analysis
- 17 Depreciation
- 18 Leasing
- 19 Company valuation
- 20 Optimisation
- 21 Decision trees
- 22 Risk management
- 23 Data functions
- 24 Data analysis
- 25 Modelling checklist
- Appendices
- Appendix 1: Software installation
- Appendix 2: Licence
- Appendix 3: File list
- Bibliography and references
- Index
