Apress Access

Financial Modeling for Business Owners and Entrepreneurs

Developing Excel Models to Raise Capital, Increase Cash Flow, Improve Operations, Plan Projects, and Make Decisions

By Tom Y. Sawyer

  • eBook Price: $31.99
Buy eBook Buy Print Book

Financial modeling is essential skill for entrepreneurs and managers who must solve knotty problems and avoid many of the obstacles and hazards encountered in startups and small and medium-sized businesses. Financial Modeling for Business Owners and Entrepreneurs shows how to create financial models to raise capital, make better decisions, forecast sales, staff and invest appropriately, plan projects, improve ROI, and generally improve operations.

Full Description

  • Add to Wishlist
  • ISBN13: 978-1-484203-71-2
  • 348 Pages
  • User Level: Beginner to Advanced
  • Publication Date: September 27, 2014
  • Available eBook Formats: EPUB, MOBI, PDF

Related Titles

  • Getting the Message Across
  • Getting into Data Science
  • Exporting
  • Data Visualization in Excel 2016
  • Managing Humans
Full Description

Financial Modeling for Business Owners and Entrepreneurs: Developing Excel Models to Raise Capital, Increase Cash Flow, Improve Operations, Plan Projects, and Make Decisions may be one of the most important books any entrepreneur or manager in a small or medium-sized enterprise will read. It combines logical business principles and strategies with a step-by-step methodology for planning and modeling a company and solving specific business problems. You’ll learn to create operational and financial models in Excel that describe the workings of your company in quantitative terms and that make it far more likely you will avoid the traps and dead ends many businesses fall into.

Serial entrepreneur and financial expert Tom Y. Sawyer shows how to break your company down into basic functional and operational components that can be modeled. The result is a financial model that, for example, you can literally take to the bank or bring to local angel investors to receive the funding you need to launch your business or a new product. Or it might be a model that shows with startling clarity that your new product development effort is a likely winner—or loser. Even better, you’ll learn to create models that will serve as guideposts for ongoing operations. You’ll always know just where you are financially, and where you need to be. The models you will learn to build in Financial Modeling for Business Owners and Entrepreneurs can be used to:

  • Raise capital for startup or any stage of growth
  • Plan projects and new initiatives
  • Make astute business decisions, including go/no-go assessments
  • Analyze ROI on your product development and marketing expenditures
  • Streamline operations, manage budgets, improve efficiency, and reduce costs
  • Value the business when it is time to cash out or merge

In addition to many valuable exercises and tips for using Excel to model your business, this book contains a combination of practical advice born of hard-won lessons, advanced strategic thought, and the insightful use of hard skills. With a basic knowledge of Excel assumed, it will help you learn to think like an experienced business person who expects to make money on the products or services offered to the public. You’ll discover that the financial model is a key management tool that, if built correctly, provides invaluable assistance every step of the entrepreneurial journey.

Tom Y. Sawyer has used the principles this book contains to create financial models of numerous startup and early-stage companies, assisting them in planning for and raising the capital that they needed to grow their businesses and ultimately exit with multiples of their initial investment. Financial Modeling for Business Owners and Entrepreneurs, a mini-MBA in entrepreneurship and finance, will show you how you can do the same.

Note: This book is an updated version of Sawyer's 2009 title, Pro Excel Financial Modeling.

What you’ll learn

  1. Business principles, critical success factors, and practical suggestions for entrepreneurs and young companies determined to succeed.
  2. Concepts, explanations, and instructions for developing financial models and forecasts.
  3. How to raise capital, budget, keep track of and manage finances, calculate ROI, and value a firm.
  4. Best practices for building a financial models to keep a company's wheels on the tracks.

Who this book is for

Entrepreneurs, company founders, managers of (or in), small to medium-sized enterprises, finance professionals, CFOs, investors, business students, and incubator residents.

Table of Contents

Table of Contents

  • Business Thinking and Financial Modeling: Success Starts with the Right Mindset
  • The Company Business Model: Envisioning and Realizing Your Future

  • Green Devil Control Systems: Our Business Case

  • The Staffing Model: Make the Most of Human Resources

  • Sales and Revenue Model: Chart Your Financial Future

  • Cost of Goods Sold and Inventory Model: Plot Your Costs and Margins

  • Cost of Sales and Marketing Model: Calculate the Cost of Doing Business

  • Cost of Product Development Model: Ensure a Return on Your Investment

  • Operating and Capital Expenditures Models: Manage Your Budget

  • Making Business Decisions Using Quantitative Models: Decision Analysis Best Practices

  • Statements of Profit and Loss and Cash Flow: Plan for Profits and Ready Money

  • Modeling Valuation and Investment with the FIN Model: Can You Cash Out?

  • Financial Report and Analysis Using the FIN Model: Do Better and Better
Source Code/Downloads

Downloads are available to accompany this book.

Your operating system can likely extract zipped downloads automatically, but you may require software such as WinZip for PC, or StuffIt on a Mac.


If you think that you've found an error in this book, please let us know by emailing to editorial@apress.com . You will find any confirmed erratum below, so you can check if your concern has already been addressed.
No errata are currently published


    1. PHP Objects, Patterns, and Practice


      View Book

    2. Beginning Android 3D Game Development


      View Book

    3. Troubleshooting Oracle Performance


      View Book

    4. Beginning Amazon Web Services with Node.js


      View Book