The Handbook of Financial Modeling

Jack Avon provides a technical manual for constructing robust financial simulations using Microsoft Excel. The text moves from the historical development of the practice to the specific accounting foundations necessary for accurate projections. Avon details specific frameworks for assessing corporate valuations, mapping out future project earnings, and monitoring company assets. Rather than focusing solely on software functions, the book explains how to structure an assignment from scratch, emphasizing the underlying financial logic and the necessity of designing for a specific end-user.

This handbook serves intermediate and advanced finance professionals who need to move beyond simple spreadsheets into sophisticated corporate modeling. Readers typically use this book to standardize their approach to fiscal problem-solving and to ensure their models remain transparent and scalable. By following these methods, a modeler gains the ability to translate complex business scenarios into functional data structures, providing stakeholders with clearer insights into potential profit outcomes and risk assessments.

Outward-looking, growth-minded and clear-cut; a demanding read.

Best for readers like The Practical Optimizer. Which reader are you?