Home > Store

Mastering Financial Modelling in Microsoft Excel 3rd edn: A Practitioner's Guide to Applied Corporate Finance, 3rd Edition

Register your product to gain access to bonus material or receive a coupon.

Mastering Financial Modelling in Microsoft Excel 3rd edn: A Practitioner's Guide to Applied Corporate Finance, 3rd Edition

Best Value Purchase

Book + eBook Bundle

  • Your Price: $95.49
  • List Price: $169.98
  • About Adobe DRM eBooks
  • This eBook requires the free Adobe® Digital Editions software.

    Before downloading this DRM-encrypted PDF, be sure to:


    • Install the free Adobe Digital Editions software on your machine. Adobe Digital Editions only works on Macintosh and Windows, and requires the Adobe Flash Player. Please see the official system requirements.
    • Authorize your copy of Adobe Digital Editions using your Adobe ID (select AdobeID as the eBook vendor). If you don't already have an Adobe ID, you can create one here.

More Purchase Options

Book

  • Your Price: $63.99
  • List Price: $79.99
  • Usually ships in 24 hours.

eBook (Adobe DRM)

  • Your Price: $71.99
  • List Price: $89.99
  • About Adobe DRM eBooks
  • This eBook requires the free Adobe® Digital Editions software.

    Before downloading this DRM-encrypted PDF, be sure to:


    • Install the free Adobe Digital Editions software on your machine. Adobe Digital Editions only works on Macintosh and Windows, and requires the Adobe Flash Player. Please see the official system requirements.
    • Authorize your copy of Adobe Digital Editions using your Adobe ID (select AdobeID as the eBook vendor). If you don't already have an Adobe ID, you can create one here.

Description

  • Copyright 2012
  • Dimensions: 240X170
  • Pages: 520
  • Edition: 3rd
  • Book
  • ISBN-10: 0-273-77225-2
  • ISBN-13: 978-0-273-77225-5
  • eBook (Adobe DRM)
  • ISBN-10: 0-273-77233-3
  • ISBN-13: 978-0-273-77233-0

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.

If you are buying the ebook, companion files can be downloaded from the digital downloads section of http://www.financial-models.com/.

Sample Content

Table of Contents

Contents

Introduction – who needs this book?

Preface to the third edition 

Acknowledgements

Conventions

Executive summary

Part A  DEVELOPING FINANCIAL MODELS

1    Overview   

Introduction                     

What is financial modelling?

History of spreadsheets  

Power of spreadsheets  

Objectives for the book  

Example spreadsheet

Summary  

2    Design introduction  

Introduction

Basics of design

Objectives

User interface  

Key variables and rules  

Layout

Individual modules  

Menu structure and macros

Management reporting  

Future development

Testing

Protection  

Documentation  

Peer group comments

Summary  

3    Features and techniques

Introduction

Formats

Number format

Lines and borders  

Colours and patterns  

Specific colours for inputs and results

Data validation  

Controls – combo boxes and buttons

Conditional formatting  

Use of functions and types of function

Add-ins for more functions  

Text and updated labels

Record a version number, author, etc.  

Use names to make formulas easier to understand

Paste names as part of documentation  

Comment cells  

Graphics  

Dynamic graphs to plot individual series

Data tables

Scenarios  

Goal seek  

Solver 

Use of templates  

Summary  

4    Sample model

Introduction

Aims and objectives  

User needs and user interface  

Key variables and rules  

Breaking down the calculations into manageable groups

Setting up individual modules  

Menu structure  

Program sheets and macros

User assistance  

Summaries

Risk and multiple answers  

Testing and troubleshooting 

Protecting and securing  

Help and documentation  

Show to peers – take their advice

Control loop – listen, learn and modify

Summary  

5    Example model

Introduction

Case study  

Design

PPP 1

PPP 2

PPP 3

PPP 4

PPP 5

Documenting, testing and protecting  

PPP 6

Summary  

Part B  APPLICATIONS   

6    Analysing performance   

Introduction

Profit and loss  

Balance sheet  

Ratios

Trend analysis

Sustainability

Summary  

7   Cash flow

Deriving cash flow  

Net operating cash flow (NOCF)  

Free cash flow  

Cover ratios  

International cash flow 

Summary  

8    Forecasting models 

Introduction

Historic forecasts  

Trend lines  

Trend lines for analysis

Data smoothing

Cyclicality and seasonality

Summary  

9    Forecasting financials

Introduction

Updates

Submit Errata

More Information

Unlimited one-month access with your purchase
Free Safari Membership