The Reality of the Benninga Workbook Ecosystem
Simon Benninga's Financial Modelling textbook is a staple in many graduate finance programs, but the actual solution files that circulate online tell a different story than the printed exercises. The solutions are generally organized by chapter, each one replicating the spreadsheet models described in the book. I spent more time than I care to admit debugging a Chapter 4 bond valuation model where the Macaulay duration output was consistently three basis points off from what the textbook answer listed. The issue wasn't a calculation error on my part. It was the textbook itself using a slightly different day-count convention for semi-annual coupons than the solution file assumed. I worked around it by overriding the payment frequency input directly in the model and hardcoding the accrued interest calculation instead of relying on Excel's built-in financial functions. The most common place to find these files is on academic resource sites and student-sharing platforms. Many universities have a dedicated page on their finance department website where the instructor uploads the workbook files alongside the textbook. The fourth edition, which is the one most people are looking for, has solution files that correspond to roughly every chapter through Chapter 18. You will also find them on GitHub repositories where students have forked and cleaned up older versions. The MIT OpenCourseWare site has some of the material linked from Benninga's own courses there. I typically check the MIT OCW page first because those files go through at least one round of verification by teaching staff. The student-uploaded versions on file-sharing sites are fine but they come with a higher risk of containing copy-paste errors or outdated formula structures that break when you change input parameters. The difference usually shows up when you toggle the sensitivity tables and the results don't recompute correctly.
How the Models Are Structured
Benninga's approach to financial modelling is deliberately Excel-native. He does not rely on VBA except in the more advanced chapters. The core technique he teaches is building fully linked financial models where every cell references another cell rather than using hardcoded values. This means when you change an assumption like the discount rate or the revenue growth rate, the entire model updates cleanly. That is the main reason people look for the solution files, because understanding how Benninga structures his inputs sheet, calculation sheet, and outputs sheet takes significant trial and error if you are working through the book alone. The input sheet is where all assumptions sit, usually highlighted in blue or shaded differently. The calculation sheets sit in the middle and contain the actual formula logic. The outputs sheet presents the final numbers in a clean summary format. This separation is not trivial. A lot of beginners skip this structure and build everything into one sheet, which makes debugging painful once the model grows past twelve or fifteen lines of logic. The solution files show you exactly how the separation works in practice.
A Common Pitfall That Costs People Hours
The most frustrating issue I encountered involved the iterative calculations in the dividend discount model section. Benninga uses iterative methods to solve for the internal rate of return when the cash flow pattern is irregular. Excel's iteration settings are not always aligned with what the solution files expect. If your manual iteration limit is set lower than what the model requires, you will get circular reference errors or wrong answers that look plausible at first glance. I spent about forty minutes chasing a problem that turned out to be Excel's default iteration settings being too conservative for the cash flow schedule in Chapter 7. The fix is straightforward. Go to File, Options, Formulas, and increase the maximum iterations to at least 100 and set the maximum change to 0.0001 or lower. This is not something Benninga emphasizes enough in the text. The solution files assume your iteration settings are configured to handle the tighter convergence tolerances he builds into the models. Without adjusting those settings, the solver will give you answers that are close but not exact, and you will have no way to know which ones are wrong without manually checking each case.
What the Solutions Actually Cover
The solution files span the major topics in the book. Chapter 1 covers the time value of money and annuity calculations. Chapter 2 moves into bond valuation and yield curve construction. Chapters 3 through 5 deal with portfolio theory, the CAPM, and factor models. The later chapters cover option pricing using binomial trees, Monte Carlo simulation, and basic corporate finance applications like WACC and DCF valuation. Each solution file mirrors the textbook problem set, so if you are working through a specific chapter you can open the corresponding workbook and compare your setup against it. The binomial option pricing models are where the files become most useful. Building a multi-period binomial tree from scratch in Excel is more cumbersome than it sounds because the grid structure requires careful attention to how the up and down factors propagate across time steps. The solution file handles the lattice construction cleanly and shows you how to back-solve from the terminal nodes to the present value without getting lost in nested IF statements or messy reference chains.
Limitations You Should Know About
The Benninga solutions are not a complete standalone curriculum. They are supplements to the textbook, and they assume you are comfortable with Excel at a fairly advanced level. If you are still learning how to use functions like NPV, XNPV, IRR, and XIRR correctly, working through the solution files alone will not fill those gaps. The book explains the theory behind the models but sometimes skips over the Excel implementation details, leaving you to figure out the practical side on your own or by cross-referencing the solutions. Another limitation is that several of the older solution files use Excel formulas that rely on calculation engines from older versions of Excel. If you are running Excel 365 or Excel 2021, most of these files work without issue, but a few of the legacy array formulas may behave differently depending on whether you are using the dynamic array engine or the traditional CSE formula entry method. I ran into one case in Chapter 14 where a matrix inversion function returned an error in the newer Excel version until I converted it to use the MDETERM and MINVERSE functions with explicit array declarations. The fix took about ten minutes but it was easy to miss if you were just comparing your final output number to the solution.
Practical Advice for Using the Files Effectively
Start by opening the solution file before you attempt the problem. This is the opposite of what most students do, but it gives you a clear map of what the model should look like before you waste time building something that will need to be torn apart later. Take notes on the structure. Pay attention to how Benninga names his ranges, how he uses helper columns to break complex calculations into readable pieces, and how he separates the calculation of intermediate values from the final output presentation. When you are building your own version, run the sensitivity analysis on at least two key variables before you consider the model complete. Benninga always includes data tables or scenario analysis in his models, and skipping this step is a common mistake that leads to models that look correct in one narrow set of assumptions but break immediately when you change a single input. The solution files show you exactly which cells drive the most sensitivity in each model, which helps you validate that your version is behaving the same way. If you are using the files for a university course, make sure you understand the academic integrity policy around solution sets. Some professors allow open access to the workbook files as study aids, while others treat them as restricted material. The models themselves are simple enough that you can reconstruct them from the textbook without the files if you have the time, so having them available as a reference is valuable but not absolutely necessary for learning the material.
