Printer: Yet to Come

—Jeffrey Nuechterlein, Managing Partner, Isis Capital
“Building Financial Models with Microsoft Excel takes a complex but criti-
cal subject and presents it in a concise, easy-to-follow fashion. This book 
is an indispensable reference guide for anyone who needs to build or ana-
lyze fi nancial models using Microsoft Excel.”
—Michael R. Lincoln, Partner, Cooley Godward LL
Building Financial Models with
 
Microsoft
®
 Excel
®
A Guide for Business Professionals
PROCTOR
Includes
CD-ROM
Second Edition
wileyfi nance.com

---

Document Outline

• Building Financial Models with Microsoft® Excel®, Second Edition: A Guide for Business Professionals
  • Contents
  • Foreword
  • Preface
    • PURPOSE OF THIS BOOK
    • NEED FOR THIS BOOK
    • TARGET AUDIENCE FOR THIS BOOK
    • SUMMARY OF CONTENTS
    • A FINAL NOTE
  • Acknowledgments
  • Part One: The Master Budget
    • Chapter 1: Overview of Budgets and Financial Models
      • BUDGETS
      • FINANCIAL MODELS
      • QUESTIONS
    • Chapter 2: Operating Budget—Assumptions, Sales, and Collections
      • NAPAVALE—BACKGROUND INFORMATION ON EXAMPLE COMPANY
      • STEP 1: ASSUMPTIONS AND DASHBOARD WORKSHEET
      • STEP 2A: UNIT SALES AND PRICE BUDGET
      • FORMATTING TIPS
      • FEATURE TIP: NAMING CELLS AND CELL RANGES
      • STEP 2B: SALES COMPOSITION BUDGET
      • STEP 2C: CASH COLLECTIONS FROM CUSTOMERS BUDGET
      • STEP 2D: ACCOUNTS RECEIVABLE BUDGET
      • QUESTIONS
    • Chapter 3: Operating Budget—Cost of Goods Sold, Inventory, and Purchases
      • STEP 3: COST-OF-GOODS-SOLD BUDGET
      • STEP 4A: INVENTORY BUDGET
      • STEP 4B: PURCHASES BUDGET
      • STEP 4C: DISBURSEMENTS FOR PURCHASES BUDGET
      • STEP 4D: ACCOUNTS PAYABLE BUDGET
      • QUESTIONS
    • Chapter 4: Operating Budget—Operating Expenses
      • STEP 5A: HEADCOUNT BUDGET
      • STEP 5B: OPERATING EXPENSES BUDGET
      • STEP 5C: DISBURSEMENTS FOR OPERATING EXPENSES BUDGET
      • QUESTIONS
    • Chapter 5: Operating Budget—Income Statement
      • STEP 6: BUDGETED STATEMENT OF INCOME
      • QUESTIONS
    • Chapter 6: Financial Budget—Capital Budget and Cash Budget
      • STEP 7A: CAPITAL EXPENDITURES BUDGET
      • STEP 7B: DISBURSEMENTS FOR CAPITAL EXPENDITURES BUDGET
      • STEP 7C: DEPRECIATION BUDGET
      • STEP 8: CASH BUDGET
      • QUESTIONS
    • Chapter 7: Financial Budget—Balance Sheet
      • STEP 9: BUDGETED BALANCE SHEET
      • QUESTIONS
  • Part Two: Financial Statements and Free Cash Flows
    • Chapter 8: Consolidated Financial Statements
      • BALANCE SHEET
      • INCOME STATEMENT
      • STATEMENT OF CASH FLOWS
      • QUESTIONS
    • Chapter 9: Free Cash Flows and Dashboard
      • CALCULATION OF FREE CASH FLOWS
      • DASHBOARD
      • QUESTIONS
  • Part Three: Analysis of a Financial Model
    • Chapter 10: Sensitivity Analysis
      • DASHBOARD
      • DATA TABLES
      • QUESTIONS
    • Chapter 11: Contribution Margin Analysis
      • FIXED AND VARIABLE COSTS
      • CONTRIBUTION MARGIN
      • OPERATING LEVERAGE
      • BREAKEVEN POINTS IN UNITS
      • BREAKEVEN POINT IN DOLLARS
      • QUESTIONS
    • Chapter 12: Financial Ratios Analysis
      • PROFIT MARGINS—FINANCIAL RATIOS
      • INVESTMENT RETURNS—FINANCIAL RATIOS
      • MANAGEMENT EFFICIENCY—FINANCIAL RATIOS
      • QUESTIONS
    • Chapter 13: Valuation
      • DISCOUNTED CASH FLOW
      • PUBLIC COMPANY COMPARABLES
      • MERGERS AND ACQUISITIONS COMPARABLES
      • WEIGHTED VALUATION
      • QUESTIONS
    • Chapter 14: Capitalization Chart
      • FOUNDING CAPITALIZATION CHART
      • EQUITY INVESTMENT’S EFFECT ON CAPITALIZATION CHART
      • STOCK OPTIONS’ EFFECT ON CAPITALIZATION CHART
      • QUESTIONS
  • Answers to Chapter Questions
  • Appendix: General Overview of Microsoft Excel 2007 Features and Functionality
    • BASIC FUNCTIONALITY
    • FORMATTING
    • FORMULAS AND FUNCTIONS
    • ADVANCED FEATURES
  • About the CD-ROM
  • About the Author
  • Index