Skip to main content
SpringerLink
Log in
Apress

The Handbook of Financial Modeling

A Practical Approach to Creating and Implementing Valuation Projection Models

  • Book
  • © 2013

Overview

Authors:
  1. Jack Avon
    View author publications

    You can also search for this author in PubMed   Google Scholar

  • A comprehensive guide to designing, building, and implementing financial models, The Handbook of Financial Modeling provides corporate finance and accounting professionals with the tools they need to precisely and effectively create and utilize effective corporate and financial models.

This is a preview of subscription content, log in via an institution to check access.

Access this book

Log in via an institution
eBook USD 64.99
Price excludes VAT (USA)
  • Available as EPUB and PDF
  • Read on any device
  • Instant download
  • Own it forever

Tax calculation will be finalised at checkout

Other ways to access

Licence this eBook for your library

Institutional subscriptions

Table of contents (25 chapters)

  1. Front Matter

    Pages i-xiv
    Download chapter PDF

  2. Financial Modeling: An Overview

    • Jack Avon
    Pages 1-9

  3. Financial Modeling Best Practices

    • Jack Avon
    Pages 11-47

  4. Modeling Functions and Tools

    • Jack Avon
    Pages 49-111

  5. Planning Your Model

    • Jack Avon
    Pages 113-126

  6. Testing and Documenting Your Model

    • Jack Avon
    Pages 127-141

  7. Designing and Building Your Model

    • Jack Avon
    Pages 143-176

  8. The Model User: Inputs

    • Jack Avon
    Pages 177-200

  9. Finance and Accounting for Modelers

    • Jack Avon
    Pages 201-217

  10. Managing and Evaluating a Business for Modelers

    • Jack Avon
    Pages 219-245

  11. The Implications and Rules of Accounting for Modelers

    • Jack Avon
    Pages 247-254

  12. Financial-Based Calculations

    • Jack Avon
    Pages 255-281

  13. Logical and Structural-Based Calculations

    • Jack Avon
    Pages 283-297

  14. How to Capture, Document, and Track Assumptions in Your Model

    • Jack Avon
    Pages 299-317

  15. Modeling to Give the User Transparency

    • Jack Avon
    Pages 319-342

  16. Model Testing and Auditing

    • Jack Avon
    Pages 343-366

  17. Modeling Handovers Dos and Don’ts

    • Jack Avon
    Pages 367-377

  18. Case Study: Building a Full Life Cycle Model

    • Jack Avon
    Pages 379-422

  19. Additional Tools and VBA for Financial Models

    • Jack Avon
    Pages 423-443

  20. What Is the Future of Financial Modeling?

    • Jack Avon
    Pages 445-448
Back to top

About this book

The 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. 

Designed for intermediate and advanced modelers who wish to expand and enhance their knowledge, The Handbook of Financial Modeling also covers:

  • The accounting and finance concepts that underpin working financial models;
  • How to approach financial issues and solutions from a modeler's perspective;
  • The importance of thinking about end users when developing a financial model;
  • How to plan, design, and build a fully functional financial model;
  • And more.

A nuts-to-bolts guide to solving common financial problems with spreadsheets, The Handbook of Financial Modeling is a one-stop resource for anyone who needs to build or analyze financial models.

About the author

Jack Avon is the principal consultant at Isys Systems, an international provider of financial modeling and analysis services. He specializes in integrating in-house ERP systems and bespoke financial models, automated dashboards, and automated reporting packages using Microsoft Access, Excel, VBA, SQL Server, and SQL. He trains corporate personnel and develops training manuals in financial data analysis and financial reporting. Clients include British Telecom, Huawei, HSBC, Crossrail, Fujitsu, and the UK Electoral Commission. Avon is the author of The Handbook of Financial Modeling and The Basics of Financial Modeling. He holds his MBA in Information Technology and BS from Bournemouth University and his MS from the University of London.

Bibliographic Information

  • Book Title: The Handbook of Financial Modeling

  • Book Subtitle: A Practical Approach to Creating and Implementing Valuation Projection Models

  • Authors: Jack Avon

  • DOI: https://doi.org/10.1007/978-1-4302-6206-0

  • Publisher: Apress Berkeley, CA

  • eBook Packages: Business and Economics, Business and Management (R0), Apress Access Books

  • Copyright Information: Jack Avon 2013

  • eBook ISBN: 978-1-4302-6206-0Published: 02 December 2013

  • Edition Number: 1

  • Number of Pages: X, 504

  • Number of Illustrations: 299 b/w illustrations

  • Topics: Business and Management, general

Publish with us

Policies and ethics

Back to top

Search

Navigation