Pro Excel Financial Modeling: Building Models for Technology Startups

Table of Contents

1. Title Page
2. Dedication
3. Contents at a Glance
4. Contents
5. About the Author
6. About the Technical Reviewer
7. Acknowledgments
8. Introduction
   1. Who This Book Is For
   2. How This Book Is Structured
   3. Prerequisites
   4. Downloading the Code
   5. Contacting the Author
9. CHAPTER 1: Business Thinking and Financial Modeling for Technology Startups
   1. Analyzing, Demonstrating, and Explaining the Value of the Financial Model
   2. Attracting the Resources You Need to Grow Your Business
   3. Common Ways of Getting Stuck
   4. Looking at Startups from the Perspective of Value
   5. Thinking Critically About the Business and Financial Model
   6. Summary
10. CHAPTER 2: Company Business Model
    1. Designing a Company
    2. Business Thinking About Financial Modeling
    3. Creating the Company Business Model
    4. Taking the 35,000-Foot View
    5. Using the Top-Down Approach
    6. Summary
11. CHAPTER 3: The Green Devil Control Systems Business Case
    1. Founding Green Devil Control Systems
    2. Giving Birth to the Idea
    3. Getting the Company Started
    4. Designing the Company
    5. Summary
12. CHAPTER 4: The Staffing Model
    1. Business Thinking About Staffing: Evolution or Intelligent Design?
    2. Reviewing the Staffing Business Case
    3. Understanding the Critical Components of the Staffing Model
    4. Planning the Staffing Model
    5. Using the Building Blocks of the STAFF Model
    6. Summary
13. CHAPTER 5: Sales and Revenue Model
    1. Business Thinking About Sales and Revenue
    2. The Products, Services, and Sales Strategy Business Case
    3. Planning the Sales and Revenue Model
    4. Exploring the Building Blocks of the REV Model
    5. Summary
14. CHAPTER 6: Cost of Goods Sold and Inventory Model
    1. Using Business Thinking About COGS
    2. Considering the Green Devil Control Systems Product Offering and Sales Strategy
    3. Planning the COGS Model
    4. Examining the COGS Model's Building Blocks
    5. Summary
15. CHAPTER 7: Cost of Sales and Marketing Model
    1. Business Thinking about the Cost of Sales and Marketing
    2. Exploring the Sales and Marketing Strategy Business Case
    3. Planning the COSM Model
    4. Using the Building Blocks of the COSM Model
    5. Summary
16. CHAPTER 8: Cost of Product Development Model
    1. Business Thinking About Product Development
    2. Product Development Objectives, Strategies, and Tactics
    3. Developing the Green Devil Control Systems Product Development Strategy
    4. Planning the DEV Model
    5. Exploring the Building Blocks of the DEV Model
    6. Summary
17. CHAPTER 9: Operating and Capital Expenditures Models
    1. Business Thinking About Cash Flow
    2. Planning the Operating Expenditure (OPEX) Model
    3. Planning the Capital Expenditure (CAPEX) Model
    4. Building and Using the OPEX and CAPEX Models
    5. Exploring the Building Blocks of the OPEX Model
    6. The Building Blocks of the CAPEX Model
    7. Summary
18. CHAPTER 10: Statements of Profit and Loss and Cash Flow
    1. Business Thinking about Profit, Loss, and Cash Flow
    2. Exploring Cash Flow Impacts of the Product Development Strategy Business Case
    3. Planning the FIN Model
    4. Understanding the Building Blocks of the FIN Model
    5. Summary
19. CHAPTER 11: Modeling Valuation and Investment with the FIN Model
    1. Business Thinking about Valuation and Investment
    2. Exploring the Valuation and Investment Strategy Business Case
    3. Planning the FIN Model
    4. Understanding the Building Blocks of the FIN Model
    5. Summary
20. CHAPTER 12: Financial Reporting and Analysis Using the FIN Model
    1. Business Thinking About Financial Reporting and Analysis
    2. Understanding the Business Case Impact on Financial Results
    3. Planning the FIN Model
    4. Understanding the Building Blocks of the FIN Model
    5. Summary
21. INDEX