Mastering Financial Modelling in Microsoft Excel: A Practitioner'S Guide To Applied Corporate Finance, 3rd Edition

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.

Sample Content

Table of Contents

• 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

Updates

Submit Errata