| Preface |
|
ix | |
|
Chapter 1 What Is Financial Modelling? |
|
|
1 | (30) |
|
What's the Difference between a Spreadsheet and a Financial Model? |
|
|
4 | (1) |
|
Types and Purposes of Financial Models |
|
|
5 | (1) |
|
|
|
6 | (11) |
|
What Skills Do You Need to Be a Good Financial Modeller? |
|
|
17 | (7) |
|
The Ideal Financial Modeller |
|
|
24 | (4) |
|
|
|
28 | (3) |
|
Chapter 2 Building a Model |
|
|
31 | (24) |
|
|
|
31 | (2) |
|
The Golden Rules for Model Design |
|
|
33 | (2) |
|
|
|
35 | (1) |
|
The Workbook Anatomy of a Model |
|
|
36 | (2) |
|
Project Planning Your Model |
|
|
38 | (3) |
|
Model Layout Flow Charting |
|
|
41 | (1) |
|
Steps to Building a Model |
|
|
41 | (9) |
|
|
|
50 | (1) |
|
Version-Control Documentation |
|
|
51 | (2) |
|
|
|
53 | (2) |
|
Chapter 3 Best Practice Principles of Modelling |
|
|
55 | (18) |
|
Document Your Assumptions |
|
|
55 | (1) |
|
|
|
56 | (1) |
|
|
|
57 | (1) |
|
|
|
57 | (1) |
|
|
|
57 | (1) |
|
|
|
58 | (1) |
|
Methods and Tools of Assumptions Documentation |
|
|
59 | (8) |
|
Linked Dynamic Text Assumptions Documentation |
|
|
67 | (3) |
|
|
|
70 | (2) |
|
|
|
72 | (1) |
|
Chapter 4 Financial Modelling Techniques |
|
|
73 | (24) |
|
|
|
73 | (2) |
|
Error Avoidance Strategies |
|
|
75 | (6) |
|
How Long Should a Formula Be? |
|
|
81 | (2) |
|
Linking to External Files |
|
|
83 | (3) |
|
|
|
86 | (10) |
|
|
|
96 | (1) |
|
Chapter 5 Using Excel in Financial Modelling |
|
|
97 | (30) |
|
Formulas and Functions in Excel |
|
|
97 | (4) |
|
|
|
101 | (2) |
|
|
|
103 | (6) |
|
|
|
109 | (3) |
|
|
|
112 | (3) |
|
Nesting: Combining Simple Functions to Create Complex Formulas |
|
|
115 | (4) |
|
Cell Referencing Best Practices |
|
|
119 | (3) |
|
|
|
122 | (4) |
|
|
|
126 | (1) |
|
Chapter 6 Functions for Financial Modelling |
|
|
127 | (60) |
|
|
|
127 | (13) |
|
|
|
140 | (13) |
|
|
|
153 | (4) |
|
|
|
157 | (4) |
|
|
|
161 | (3) |
|
|
|
164 | (2) |
|
|
|
166 | (8) |
|
Financial Project Evaluation Functions |
|
|
174 | (6) |
|
|
|
180 | (6) |
|
|
|
186 | (1) |
|
Chapter 7 Tools for Model Display |
|
|
187 | (46) |
|
|
|
187 | (1) |
|
|
|
187 | (6) |
|
|
|
193 | (7) |
|
|
|
200 | (4) |
|
Bulletproofing Your Model |
|
|
204 | (4) |
|
Customising the Display Settings |
|
|
208 | (8) |
|
|
|
216 | (16) |
|
|
|
232 | (1) |
|
Chapter 8 Tools for Financial Modelling |
|
|
233 | (40) |
|
Hiding Sections of a Model |
|
|
233 | (5) |
|
|
|
238 | (2) |
|
|
|
240 | (7) |
|
|
|
247 | (2) |
|
Structured Reference Tables |
|
|
249 | (2) |
|
|
|
251 | (11) |
|
|
|
262 | (10) |
|
|
|
272 | (1) |
|
Chapter 9 Common Uses of Tools in Financial Modelling |
|
|
273 | (42) |
|
Escalation Methods for Modelling |
|
|
273 | (5) |
|
Understanding Nominal and Effective (Real) Rates |
|
|
278 | (5) |
|
Calculating Cumulative Totals |
|
|
283 | (1) |
|
How to Calculate a Payback Period |
|
|
284 | (4) |
|
Weighted Average Cost of Capital (WACC) |
|
|
288 | (5) |
|
|
|
293 | (3) |
|
Modelling Depreciation Methods |
|
|
296 | (11) |
|
|
|
307 | (6) |
|
|
|
313 | (2) |
|
|
|
315 | (22) |
|
Rebuilding an Inherited Model |
|
|
315 | (8) |
|
Improving Model Performance |
|
|
323 | (5) |
|
Auditing a Financial Model |
|
|
328 | (7) |
|
|
|
335 | (1) |
|
|
|
336 | (1) |
|
Chapter 11 Stress-Testing, Scenarios, and Sensitivity Analysis in Financial Modelling |
|
|
337 | (30) |
|
What Are the Differences between Scenario, Sensitivity, and What-If Analyses? |
|
|
338 | (2) |
|
Overview of Scenario Analysis Tools and Methods |
|
|
340 | (9) |
|
Advanced Conditional Formatting |
|
|
349 | (4) |
|
Comparing Scenario Methods |
|
|
353 | (12) |
|
|
|
365 | (2) |
|
Chapter 12 Presenting Model Output |
|
|
367 | (54) |
|
Preparing an Oral Presentation for Model Results |
|
|
367 | (2) |
|
Preparing a Graphic or Written Presentation for Model Results |
|
|
369 | (3) |
|
|
|
372 | (8) |
|
|
|
380 | (6) |
|
|
|
386 | (2) |
|
|
|
388 | (6) |
|
Charting with Two Different Axes and Chart Types |
|
|
394 | (6) |
|
|
|
400 | (2) |
|
|
|
402 | (5) |
|
|
|
407 | (13) |
|
|
|
420 | (1) |
| About the Author |
|
421 | (2) |
| About the Website |
|
423 | (2) |
| Index |
|
425 | |