The most up-to-date guide available for designing, building, and implementing valuation projection models
This updated and augmented second edition of Building Financial Models provides a state-of-the-art method for creating projection models that will accurately determine a company's valuation today and its earnings and profits tomorrow.
Complete with brand new material on discounted cash flow (DCF) modeling and an accompanying website with example spreadsheets, Building Financial Models is the most comprehensive guide to real-world projection modeling available.
Globally recognized by accounting and finance professionals for its proven step-by-step approach, this hands-on road map to projection model design and implementation features:
- An overview of projection models--what they are, how they are used, and how they vary between industries
- In-depth explanations of the accounting and finance concepts that underpin working financial models
- Detailed directions for using spreadsheet software to create dynamically powerful financial models
- Clear strategies for producing and using a projection model that allows the user to change inputs quickly for sensitivity testing
Building Financial Models is a single, go-to resource that offers unparalleled depth of coverage and breadth of topic.
Get started on Building Financial Models now to develop the skills you need to stay competitive in today's corporate finance arena.
Table of Contents
|
Introduction |
|
| Ch. 1 |
A financial projection model |
1 |
| Ch. 2 |
Design principles for good model building |
13 |
| Ch. 3 |
Starting out |
23 |
| Ch. 4 |
Your model-building toolbox : F keys and ranges |
47 |
| Ch. 5 |
Your model-building toolbox : functions |
63 |
| Ch. 6 |
Guerilla accounting for modeling |
109 |
| Ch. 7 |
Balancing the balance sheet |
119 |
| Ch. 8 |
Income statement and balance sheet accounts |
145 |
| Ch. 9 |
Putting everything together |
155 |
| Ch. 10 |
The IS and BS output sheets |
193 |
| Ch. 11 |
The CF sheet |
199 |
| Ch. 12 |
Ratios : key performance indicators |
209 |
| Ch. 13 |
Forecasting guidelines |
227 |
| Ch. 14 |
The cash sweep |
237 |
| Ch. 15 |
The cash flow variation for cash sweep |
257 |
| Ch. 16 |
Recording macros |
271 |
| Ch. 17 |
On-screen controls |
287 |
| Ch. 18 |
Bells and whistles |
297 |
| Ch. 19 |
Writing a macro in Visual Basic for applications |
315 |
|
Index |
329 |