Guy Dore

The Cash Flow Statement

Building an Integrated Financial Model

A VBA Primer

Variations on Balancing Plugs

The Model Building Toolbox: F Keys and Ranges

Setting the Stage

Tips and Tricks

The Model Building Toolbox: Functions

Discounted Cash Flow Valuation

Ratios

A Financial Projection Model

The Cash Sweep

Circular References and Iterative Calculations

Building a Pilot Model

Best Practices

Forecasting Guidelines

Accounting for Modeling

Preparing to Build a Full Model

Introduction to Visual Basic for Applications