Home Page Icon
Home Page
Table of Contents for
.
Close
.
by KEITH A. ALLMAN
Corporate Valuation Modeling: A Step-by-Step Guide
Title Page
Copyright Page
Preface
Acknowledgments
CHAPTER 1 - Introduction
OVERVIEW OF THE CORPORATE VALUATION PROCESS
CONCEPTUAL ROADMAP
TECHNICAL ROADMAP
A FEW BEST PRACTICES REGARDING FINANCIAL MODELING
HOW THIS BOOK WORKS
MODEL BUILDER 1.1: INITIAL SETTINGS AND ASSUMPTIONS SHEET SETUP
TOOLBOX: NAMING CELLS
CHAPTER 2 - Dates and Timing
THE NEED FOR A FLEXIBLE SYSTEM
THE FORECAST PERIOD
THE TERMINAL PERIOD
HISTORICAL TIME PERIODS
EVENT TIMING
MODEL BUILDER 2.1: DATES AND TIMING ON THE ASSUMPTIONS SHEET
MODEL BUILDER 2.2: INTRODUCING THE VECTORS SHEET
SUMMARY OF DATES AND TIMING
TOOLBOX
CHAPTER 3 - Revenue, Costs, and the Income Statement
REVENUE
MODEL BUILDER 3.1: THREE METHODS FOR ESTIMATING REVENUE BASED ON HISTORICAL DATA
COSTS
ORGANIZING REVENUE AND COST ASSUMPTIONS FOR SCENARIO ANALYSIS
MODEL BUILDER 3.2: INSTALLING AN EXCEL-BASED SCENARIO SELECTOR SYSTEM
BRINGING REVENUES AND COSTS TOGETHER: THE INCOME STATEMENT
MODEL BUILDER 3.3: INTEGRATING THE INCOME STATEMENT
A WORK IN PROGRESS
TOOLBOX
CHAPTER 4 - Capital Structure and Balance Sheet
WHAT THE COMPANY OWES
MODEL BUILDER 4.1: STARTING THE BALANCE SHEET WITH ASSETS
WHAT THE COMPANY OWES
MODEL BUILDER 4.2: CONTINUING THE BALANCE SHEET WITH LIABILITIES
WHAT THE COMPANY HAS ALREADY PAID FOR
MODEL BUILDER 4.3: CONTINUING THE BALANCE SHEET WITH EQUITY
TOOLBOX: BE CAREFUL WITH GROWTH
CHAPTER 5 - Capital Expenditures, Depreciation, Intangibles, and Amortization
CAPITAL EXPENDITURES
DEPRECIATION
A BALANCE SHEET OR AN INCOME STATEMENT ITEM?
CONCEPT STATUS
MODEL BUILDER 5.1: CAPITAL EXPENDITURE SCHEDULES SETUP
MODEL BUILDER 5.2: DEPRECIATION SCHEDULES SETUP
INTANGIBLES
AMORTIZATION
MODEL BUILDER 5.3: INTANGIBLES AND AMORTIZATION SCHEDULES
INCOME STATEMENT AND BALANCE SHEET EFFECTS
MODEL BUILDER 5.4: INTEGRATING CAPITAL EXPENDITURES, DEPRECIATION, INTANGIBLES, AND AMORTIZATION
TOOLBOX
CHAPTER 6 - Long-Term Debt
WHAT IS LONG-TERM DEBT ?
USING DEBT FOR A REASON
MODELING DEBT: DEBT COMPONENTS IN DETAIL
MODEL BUILDER 6.1: SETTING UP DEBT AND CALCULATING WHAT IS DUE
PAYING LIABILITIES
MODEL BUILDER 6.2: PAYING THE CORRECT LIABILITY AMOUNT
MODEL BUILDER 6.3: INTEGRATING LONG-TERM DEBT INTO THE INCOME STATEMENT AND BALANCE SHEET
TOOLBOX
CHAPTER 7 - Balancing the Model
MODEL BUILDER 7.1: CALCULATING CASH AND SHORT-TERM DEBT INTEREST
WORKING WITH THE MODEL
THE MODEL AS AN ANALYSIS TOOL
TOOLBOX: EXCEL’S CALCULATION MODES
CHAPTER 8 - Reconciling Cash Flow
THE CASH FLOW STATEMENT
WORKING CAPITAL
MODEL BUILDER 8.1: CALCULATING WORKING CAPITAL
MODEL BUILDER 8.2: BUILDING THE CASH FLOW STATEMENT
PREVENTING ERROR THROUGH INTERNAL VALIDATION
MODEL BUILDER 8.3: IMPLEMENTING INTERNAL VALIDATIONS
OTHER VALIDATIONS
TOOLBOX
CHAPTER 9 - Free Cash Flow, Terminal Value, and Discount Rates and Methods
FREE CASH FLOW: A MATTER OF PERSPECTIVE
MODEL BUILDER 9.1: IMPLEMENTING FREE CASH FLOW
TERMINAL VALUE: BEYOND THE FORECAST PERIOD
MODEL BUILDER 9.2: CALCULATING AND INTEGRATING A STABLE-GROWTH TERMINAL VALUE
DISCOUNT RATES AND METHODS
MODEL BUILDER 9.3: CALCULATING AND IMPLEMENTING THE WEIGHTED AVERAGE COST OF CAPITAL
MODEL BUILDER 9.4: DISCOUNTING WITH MULTIPLE RATES TO DETERMINE THE CORPORATE VALUE
AFTER THE CORPORATE VALUATION
TOOLBOX
CHAPTER 10 - Output Reporting
OUTPUT SUMMARY
MODEL BUILDER 10.1: PREPARING FOR THE OUTPUT SUMMARY SHEET
WEB DOWNLOADS
MODEL BUILDER 10.2: CONNECTING THE EXAMPLE MODEL TO THE WEB
MODEL BUILDER 10.3: CREATING THE OUTPUT SUMMARY SHEET
CHARTS
MODEL BUILDER 10.4: CREATING DYNAMIC CHARTS
TOOLBOX
CHAPTER 11 - Automation Using Visual Basic Applications (VBA)
THE OBJECT-ORIENTED PROGRAMMING LANGUAGE (OOP)
FOLLOW THE RULES
THE VISUAL BASIC EDITOR
WRITING CODE: SUBROUTINES AND FUNCTIONS
UNDERSTANDING VBA CODE AND PRACTICING CODING TECHNIQUES
MODEL BUILDER 11.1: MOVING DATA USING VBA
MODEL BUILDER 11.2: A FIRST LOOK AT LOOPS AND VARIABLES IN VBA
COMMON ERRORS FOR FIRST-TIME VBA PROGRAMMERS
VBA WITHIN A FINANCIAL MODELING CONTEXT
MODEL BUILDER 11.3: ELIMINATING CIRCULAR REFERENCES
MODEL BUILDER 11.4: CREATING A SCENARIO GENERATOR
MODEL BUILDER 11.5: AUTOMATIC SHEET PRINTING
CONTINUING WITH VBA
CONCLUSION
About the CD-ROM
About the Author
Index
Search in book...
Toggle Font Controls
Playlists
Add To
Create new playlist
Name your new playlist
Playlist description (optional)
Cancel
Create playlist
Sign In
Email address
Password
Forgot Password?
Create account
Login
or
Continue with Facebook
Continue with Google
Sign Up
Full Name
Email address
Confirm Email Address
Password
Login
Create account
or
Continue with Facebook
Continue with Google
Next
Next Chapter
Corporate Valuation Modeling
Add Highlight
No Comment
..................Content has been hidden....................
You can't read the all page of ebook, please click
here
login for view all page.
Day Mode
Cloud Mode
Night Mode
Reset