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

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 dwnld, and more

About the Author

John S. Tjia (New York) is Group Consulting Head with Wall Street Prep, a top training and modeling consulting provider for the top investment banks, equity firms and business schools, and a leader in on line finance training. He has over 25 years of financial modeling experience. For over 10 years, he was Executive Director at Ernst & Young’s Business Modeling Group in New York, where he provided financial modeling consulting services to Fortune 500 companies. Earlier, he was an investment banker at JP Morgan in Hong Kong and New York, where he also led the development of that global firm’s credit analysis and M&A models for use by the investment banking teams worldwide