Building Financial Models
The ability to effectively create and interpret financial models is one of the most valued skills in corporate finance—from Wall Street to Main Street. Now, the acclaimed guide to designing, building, and implementing valuation projection models is fully revised and expanded to keep finance and accounting professionals competitive in today's marketplace.\ This second edition of Building Financial Models continues the tradition of its predecessor by providing a hands-on approach to creating a...
Search in google:
The most up-to-date guide available for designing, building, and implementing valuation projection modelsThis 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.Complete with brand new material on discounted cash flow (DCF) modeling and an accompanying website with example spreadsheets, Building Financial Models is the most comprehensive guide to real-world projection modeling available.Globally recognized by accounting and finance professionals for its proven step-by-step approach, this hands-on road map to projection model design and implementation features: An overview of projection models—what they are, how they are used, and how they vary between industries In-depth explanations of the accounting and finance concepts that underpin working financial models Detailed directions for using spreadsheet software to create dynamically powerful financial models Clear strategies for producing and using a projection model that allows the user to change inputs quickly for sensitivity testingBuilding Financial Models is a single, go-to resource that offers unparalleled depth of coverage and breadth of topic.Get started on Building Financial Models now to develop the skills you need to stay competitive in today's corporate finance arena.John S. Tjia is a founding partner of TMG Associates, LLC, a consulting firm 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.
IntroductionCh. 1A financial projection model1Ch. 2Design principles for good model building13Ch. 3Starting out23Ch. 4Your model-building toolbox : F keys and ranges47Ch. 5Your model-building toolbox : functions63Ch. 6Guerilla accounting for modeling109Ch. 7Balancing the balance sheet119Ch. 8Income statement and balance sheet accounts145Ch. 9Putting everything together155Ch. 10The IS and BS output sheets193Ch. 11The CF sheet199Ch. 12Ratios : key performance indicators209Ch. 13Forecasting guidelines227Ch. 14The cash sweep237Ch. 15The cash flow variation for cash sweep257Ch. 16Recording macros271Ch. 17On-screen controls287Ch. 18Bells and whistles297Ch. 19Writing a macro in Visual Basic for applications315Index329
