Financial modeling is a crucial concept for business leaders to understand and execute effectively, but few have the tools necessary to do so. While many professionals are familiar with financial statements and accounting reports, not many are truly proficient at building an accurate and practical financial model from the ground up. The Handbook of Financial Modeling provides these skills and so much more.
Now in its second edition, The Handbook of Financial Modeling takes into account the new tech released since its successful initial release. Author Jack Avon uses his expertise to analyze the changes and improvements in industry-wide financial modeling through the past five years, in addition to instilling core concepts for readers of all experience levels. Approaching your company’s financial issues with a modeler’s perspective will transform and improve the rest of your business career’s trajectory.
Financial professionals, students, business leaders, aspiring CFOs, and more will come away with all the tools necessary to precisely and efficiently monitor an organization’s assets and project future performance. The engaging case studies and Avon’s expert analysis leave you prepared to monitor and predict your organization’s finances effectively. Financial modeling’s latest technology is at your fingertips, and this book’s deep understanding of the topic ensures that you stay ahead of the pack.
What You Will Learn
- Approach financial issues and solutions from a modeler's perspective
- Discover the importance of thinking about end users when developing a financial model
- Plan, design, and build a fully functional financial model
Who This Book Is For
Analysts who would typically be middle management, VPs, and associates. It is also written for business graduates and MBA students.
| About the Author |
|
vii | |
| Acknowledgments |
|
ix | |
| Introduction |
|
xi | |
|
Chapter 1 The Role of a Financial Modeler Today |
|
|
1 | (8) |
|
Chapter 2 Types of Financial Models |
|
|
9 | (30) |
|
Chapter 3 Review of Best Practices for Financial Modelers |
|
|
39 | (26) |
|
Chapter 4 The Modeling Life Cycle Explained |
|
|
65 | (20) |
|
Chapter 5 Planning and Designing Models |
|
|
85 | (46) |
|
Chapter 6 It's All About the Outputs |
|
|
131 | (10) |
|
|
|
141 | (32) |
|
Chapter 8 Financial Modeling and Accountancy |
|
|
173 | (18) |
|
Chapter 9 The Implications of Accounting Rules for Modelers |
|
|
191 | (10) |
|
Chapter 10 Modeling Scenarios Explored |
|
|
201 | (16) |
|
Chapter 11 Calculations for Financial Modelers |
|
|
217 | (42) |
|
Chapter 12 The Importance of Documentation |
|
|
259 | (6) |
|
Chapter 13 Model Stress Testing |
|
|
265 | (24) |
|
Chapter 14 Model Audit and Review |
|
|
289 | (10) |
|
Chapter 15 The Role of VBA in Financial Models |
|
|
299 | (16) |
|
|
|
315 | (10) |
|
Chapter 17 Financial Modeling, Where Next? |
|
|
325 | (4) |
| Appendix A Modeling Glossary and Terminology |
|
329 | (4) |
| Appendix B Ready-Made Functions |
|
333 | (10) |
| Appendix C References |
|
343 | (2) |
| Index |
|
345 | |
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 (Apress, 2013) and The Basics of Financial Modeling (Apress, 2015). He holds his MBA in information technology and BS from Bournemouth University and his MS from the University of London.
