- A nuts-to-bolts guide to solving common financial problems with spreadsheets
- Explains the tools needed to create accurate financial models and put them to use
- A one-stop resource
Buy this book
- About this book
-
Learn to create and understand financial models that assess the value of your company, the projects it undertakes, and its future earnings/profit projections. Follow this step-by-step guide organized in a quick-read format to build an accurate and effective financial model from the ground up.
In this short book, The Basics of Financial Modeling—an abridgment of the Handbook of Financial Modeling—author Jack Avon equips business professionals who are familiar with financial statements and accounting reports to become truly proficient. Based on the author's extensive experience building models in business and finance, and teaching others to do the same, this book takes you 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.
What You'll Learn
- Understand the accounting and finance concepts that underpin working financial models
- Approach financial issues and solutions from a modeler's perspective
- Think about end users when developing a financial model
- Plan, design, and build a financial model
Who This Book Is For
Beginning to intermediate modelers who wish to expand and enhance their knowledge of using Excel to build and analyze financial models
- About the authors
-
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.
- Table of contents (9 chapters)
-
-
Financial Modeling: An Overview
Pages 1-9
-
Financial Modeling Best Practices
Pages 11-49
-
Modeling Functions and Tools
Pages 51-113
-
Planning Your Model
Pages 115-129
-
Testing and Documenting Your Model
Pages 131-146
-
Table of contents (9 chapters)
Recommended for you

Bibliographic Information
- Bibliographic Information
-
- Book Title
- The Basics of Financial Modeling
- Authors
-
- Jack Avon
- Copyright
- 2015
- Publisher
- Apress
- Copyright Holder
- Jack Avon
- eBook ISBN
- 978-1-4842-0871-7
- DOI
- 10.1007/978-1-4842-0871-7
- Softcover ISBN
- 978-1-4842-0872-4
- Edition Number
- 1
- Number of Pages
- IX, 248
- Number of Illustrations
- 159 b/w illustrations
- Topics