Skip to main content
SpringerLink
Log in
Apress

Pro Excel Financial Modeling

Building Models for Technology Startups

  • Book
  • © 2009

Overview

Authors:
  1. Tom Y. Sawyer
    View author publications

    You can also search for this author in PubMed   Google Scholar

  • Covers everything the reader needs to know to build successful models, including quantification of risks, ROI modeling and good design
  • Clear focus on the business thinking required when building a viable model
  • Outlines how to successfully communicate with investors and other stakeholders in your model

This is a preview of subscription content, log in via an institution to check access.

Access this book

Log in via an institution
eBook USD 39.99
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book USD 54.99
Price excludes VAT (USA)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Other ways to access

Licence this eBook for your library

Institutional subscriptions

Table of contents (12 chapters)

  1. Front Matter

    Pages i-xxii
    Download chapter PDF

  2. Business Thinking and Financial Modeling for Technology Startups

    Pages 1-21

  3. Company Business Model

    Pages 23-41

  4. The Green Devil Control Systems Business Case

    Pages 43-50

  5. The Staffing Model

    Pages 51-75

  6. Sales and Revenue Model

    Pages 77-96

  7. Cost of Goods Sold and Inventory Model

    Pages 97-115

  8. Cost of Sales and Marketing Model

    Pages 117-142

  9. Cost of Product Development Model

    Pages 143-167

  10. Operating and Capital Expenditures Models

    Pages 169-191

  11. Statements of Profit and Loss and Cash Flow

    Pages 193-214

  12. Modeling Valuation and Investment with the FIN Model

    Pages 215-242

  13. Financial Reporting and Analysis Using the FIN Model

    Pages 243-267

  14. Back Matter

    Pages 269-280
    Download chapter PDF
Back to top

Keywords

About this book

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

About the author

Tom Y. Sawyer has a proven track record as a principal architect, leader, and strategist for successful business and technology ventures. He currently provides management and technology consulting services to technology-focused enterprises, specializing in early stage organization, product development, "go to market" strategies, and financial modeling. A serial entrepreneur, Tom founded and sold an Internet data storage dot-com, served as president of a regional Colorado Internet service provider where he directed the strategic sale of the company, and served as the first president of Mover's Suite Software, today the largest enterprise software and consulting company in the moving industry. He also served as chief technology officer and on the board of directors of Guardian ProStar, a provider of advanced GPS/GIS services to the utility industry. Tom gained Fortune 100 senior management experience as director of information technology for the Martin Marietta Space Launch Systems Titan IV missile program, where he received the Outstanding Achievement Award for Information Technology Management in his last year of service. Prior to his Fortune 100 career, he served in progressively more responsible financial management and financial planning positions in banking, technology services, and computer manufacturing. He holds a bachelor's degree in business administration in finance from the University of Florida.

Bibliographic Information

Publish with us

Policies and ethics

Back to top

Search

Navigation