Building Financial Models, Third Edition: The Complete Guide to Designing, Building, and Applying Projection Models

✍ Scribed by John S. Tjia

• Publisher: McGraw Hill Professional
• Year: 2018
• Tongue: English
• Leaves: 379
• Edition: 3
• Category: Library

✦ Synopsis

The go-to-guide for building projection models for financial analysis and valuation—updated with new content and materials Building Financial Models is considered the best guide to designing and building financial models for use in a wide variety of finance roles. This third edition of the popular resource features updated content, new materials, and a more accessible instructional layout supported by all new exercise files available to readers from a companion website. As with previous editions, the book offers a hands-on approach for creating a core model that is supported by broad coverage of cornerstone accounting and finance principles. The author, a seasoned developer and trainer with over 25 years’ experience developing financial models, takes you step by step through the entire process of developing a projection model. From the basics of accounting and Excel to the final “tips and tricks” for a completed model, you will be led assuredly through the steps of building an integrated financial statement model, one that can serve as the core for transactions or analysis in the LBO, M&A, business valuation model, or credit underwriting space. ●NEW: Updates on the latest Microsoft Excel shortcuts, functions, accounting concepts and modeling techniques●NEW: “Tips and tricks” on how to make your final model product both user-friendly and solidly built●NEW: Additional materials on valuation analysis and sections on scenarios and sensitivity analysis through the use of Data Tables●Online access to sample models you can download, and more

✦ Table of Contents

Cover
Title Page
Copyright Page
Dedication
Contents
Introduction
Acknowledgments
Chapter 1 A Financial Projection Model
Chapter 2 Best Practices
Chapter 3 Setting the Stage
Chapter 4 The Model Building Toolbox: F Keys and Ranges
Chapter 5 The Toolbox
Chapter 6 Accounting in Modeling
Chapter 7 Building a Pilot Model
Chapter 8 Circular References and Iterative Calculations
Chapter 9 Variations on Balancing
Chapter 10 The Cash Sweep and Interest Calculations
Chapter 11 Reorganizing the Model
Chapter 12 Scenarios and Other Tips
Chapter 13 Ratios
Chapter 14 Forecasting Guidelines
Chapter 15 Discounted Cash Flow Valuation
Chapter 16 Using VBA for Balancing
Appendix
Index