Building Financial Models

  • ISBN13:


  • ISBN10:


  • Edition: 2nd
  • Format: Hardcover
  • Copyright: 2009-06-17
  • Publisher: McGraw-Hill Education
  • View Upgraded Edition
  • Purchase Benefits
  • Free Shipping On Orders Over $35!
    Your order must be $35 or more to qualify for free economy shipping. Bulk sales, PO's, Marketplace items, eBooks and apparel do not qualify for this offer.
  • Get Rewarded for Ordering Your Textbooks! Enroll Now
List Price: $85.00
  • eBook
    Add to Cart


Supplemental Materials

What is included with this book?

  • The eBook copy of this book is 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.


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

Introductionp. vii
A Financial Projection Modelp. 1
Best Practicesp. 15
Setting the Stagep. 29
Accounting for Modelingp. 65
The Model Building Toolbox: F Keys and Rangesp. 83
The Model Building Toolbox: Functionsp. 107
Building a Pilot Modelp. 159
Circular References and Iterative Calculationsp. 171
Variations on Balancing Plugsp. 199
Preparing to Build a Full Modelp. 209
Building an Integrated Financial Model: Part 1p. 225
The Cash Flow Statementp. 255
The Cash Sweepp. 269
Ratiosp. 313
Forecasting Guidelinesp. 335
Discounted Cash Flow Valuationp. 345
Introduction to Visual Basic for Applicationsp. 365
A VBA Primerp. 379
Tips and Tricksp. 409
Appendix: Abbreviationsp. 437
Indexp. 439
About the Authorp. 450
Table of Contents provided by Ingram. All Rights Reserved.

Rewards Program

Write a Review