AUMELBAS282

Mastering Financial Modelling in Microsoft Excel, 3rd Edition

Alastair Day

Mastering Financial Modelling in Microsoft Excel, 3rd Edition

By Alastair Day
$75.95
Available on demand
We'll put in a special order, which can take 2-3 weeks to reach you. This item cannot be returned unless it is defective, or there's been a mistake in fulfilling the order.
Don't wait. Order the eBook version instead.
Add to cart
Overview
Author
Alastair Day
Edition
3rd
ISBN
9780273772255
Published Date
02/01/2013
Pages
520

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 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.

 

This 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.

Biography

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.

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