BUILDING
FINANCIAL
MODELS
A Guide to Creating
and Interpreting
Financial Statements
JOHN S. TJIA
McGraw-Hill
INTRODUCTION v
CHAPTER 1
A Financial Projection Model 1
CHAPTER 2
Design Principles for Good Model Building 13
CHAPTER 3
Starting Out 23
CHAPTER 4
Your Model-Building Toolbox: F Keys and Ranges 47
CHAPTER 5
Your Model-Building Toolbox: Functions 63
CHAPTER 6
Guerilla Accounting for Modeling 109
CHAPTER 7
Balancing the Balance Sheet 119
CHAPTER 8
Income Statement and Balance Sheet Accounts 145
CHAPTER 9
Putting Everything Together 155
CHAPTER 10
The IS and BS Output Sheets 193
CHAPTER 11
The CF Sheet 199
CHAPTER 12
Ratios: Key Performance Indicators 209
CHAPTER 13
Forecasting Guidelines 227
INTRODUCTION v
CHAPTER 1
A Financial Projection Model 1
CHAPTER 2
Design Principles for Good Model Building 13
CHAPTER 3
Starting Out 23
CHAPTER 4
Your Model-Building Toolbox: F Keys and Ranges 47
CHAPTER 5
Your Model-Building Toolbox: Functions 63
CHAPTER 6
Guerilla Accounting for Modeling 109
CHAPTER 7
Balancing the Balance Sheet 119
CHAPTER 8
Income Statement and Balance Sheet Accounts 145
CHAPTER 9
Putting Everything Together 155
CHAPTER 10
The IS and BS Output Sheets 193
CHAPTER 11
The CF Sheet 199
CHAPTER 12
Ratios: Key Performance Indicators 209
CHAPTER 13
Forecasting Guidelines 227
2# dumb