Avon J. The Handbook of Financial Modeling: A Practical Approach to Creating and Implementing Valuation Projection Models

Apress, 2013. — 484 p. — ISBN: 1430262052, 9781430262053The ability to create and understand financial models that assess the valuation of a company, the projects it undertakes, and its future earnings/profit projections is one of the most valued skills in corporate finance. However, while many business professionals are familiar with financial statements and accounting reports, few are truly proficient at building an accurate and effective financial model from the ground up. That's why, in The Financial Modeling Handbook, Jack Avon equips financial professionals with all the tools they need to precisely and effectively monitor a company's assets and project its future performance. Based on the author's extensive experience building models in business and finance—and teaching others to do the same—The Handbook of Financial Modeling takes readers step by step through the financial modeling process, starting with a general overview of the history and evolution of financial modeling. It then moves on to more technical topics, such as the principles of financial modeling and the proper way to approach a financial modeling assignment, before covering key application areas for modeling in Microsoft Excel.
About the Author
Jack Avon is the director and principal consultant at Isys Systems (Ringwood) Ltd., a financial modeling and analysis company in the United Kingdom. He has broad industry experience with integrating in-house systems with Microsoft Excel and Access and developing custom models and management information systems. Mr. Avon has consulted in financial modeling since 1997 and has worked with clients in banking, media, telecommunications, transportation, construction, oil, gas, and the public sector. He is the founder of the Association of Financial Modelers; is an accredited member of the ACCA; and has a master's degree in IT. Mr. Avon lives in Surrey with his wife and three children.Financial Modeling: An Overview
Financial Modeling Best Practices
Modeling Functions and Tools
Planning Your Model
Testing and Documenting Your Model
Designing and Building Your Model
The Model User: Inputs
An Introduction to Finance and Accounting for Modelers
Managing and Evaluating a Business for Modelers
The Implications and Rules of Accounting for Modelers
Financial Based Calculations
Logical and Structural Based Calculations
How to Capture Document and Track Assumptions in Your Model
Modeling to Give the User Transparency
Model Testing and Auditing
Modeling Handover Dos and Don'ts.
Case Study: Building a Full Life Cycle Model
Additional Tools and VBA for Financial Models
What is the Future of Financial Modeling?
Keyboard Shortcuts
Finance and Accounting Glossary
Readymade Functions
Sample Outputs
Housekeeping