Building Financial Models

This updated and augmented second edition of Building Financial Models provides a state-of-the-art method for creating projection models that will accurately determine a company's valuation today and its earnings and profits tomorrow.

John S. Tjia is a founding partner in TMG Associates, LLC, a consulting firm with investment and commercial banking clients that specializes in financial modeling for corporate finance. A former vice president at JPMorgan Chase, he has taught modeling and valuation classes to hundreds of analysts and associates.

Introduction	p. vii
A Financial Projection Model	p. 1
Best Practices	p. 15
Setting the Stage	p. 29
Accounting for Modeling	p. 65
The Model Building Toolbox: F Keys and Ranges	p. 83
The Model Building Toolbox: Functions	p. 107
Building a Pilot Model	p. 159
Circular References and Iterative Calculations	p. 171
Variations on Balancing Plugs	p. 199
Preparing to Build a Full Model	p. 209
Building an Integrated Financial Model: Part 1	p. 225
The Cash Flow Statement	p. 255
The Cash Sweep	p. 269
Ratios	p. 313
Forecasting Guidelines	p. 335
Discounted Cash Flow Valuation	p. 345
Introduction to Visual Basic for Applications	p. 365
A VBA Primer	p. 379
Tips and Tricks	p. 409
Appendix: Abbreviations	p. 437
Index	p. 439
About the Author	p. 450
Table of Contents provided by Ingram. All Rights Reserved.

What is included with this book?

The New copy of this book will include any supplemental materials advertised. Please check the title of the book to determine if it should include any access cards, study guides, lab manuals, CDs, etc.

The Used, Rental and eBook copies of this book are not guaranteed to include any supplemental materials. Typically, only the book itself is included. This is true even if the title states it includes any access cards, study guides, lab manuals, CDs, etc.

FREE SHIPPING

Amazon no longer offers textbook rentals. We do!

Building Financial Models

Summary

Author Biography

Table of Contents

Supplemental Materials