O'Reilly logo

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Pro Excel Financial Modeling: Building Models for Technology Startups

Pro Excel Financial Modeling: Building Models for Technology Startups

by Tom Y. Sawyer
Publisher: Apress
Release Date: March 2009
ISBN: 9781430218982
View table of contents
Start reading

Book Description

Learn the business thinking behind financial modeling and execute what you know effectively using Microsoft Excel. Many believe that sales and profitability projections shown in financial models are the keys to success in attracting investors. The truth is that investors will come up with their own projections. The investor wants to understand the assumptions, structure, and relationships within the modeling of a startup. If the investor is satiated, the entrepreneur has successfully demonstrated a complete understanding of the business side of the enterprise. Pro Excel Financial Modeling provides the keys necessary to learn this thinking and to build the models that will illustrate it.

    Step-by-step approach to developing financial models in Excel

    Extensive case studies and Excel templates provided

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