Building Financial Models

by Tjia, John

• ISBN13: 9780071608893
• ISBN10: 0071608893
• Edition: 2nd
• Format: Hardcover
• Copyright: 2009-06-17
• Publisher: McGraw-Hill Education

Summary

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.

Author Biography

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.

Table of Contents

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.