Pro Excel Financial Modeling: Building Models for Technology Startups

by Tom Sawyer

Overview

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

Product Details

ISBN-13:	9781430218982
Publisher:	Apress
Publication date:	03/26/2009
Series:	Expert's Voice in Office
Edition description:	1st ed.
Pages:	304
Product dimensions:	7.00(w) x 9.10(h) x 1.00(d)

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.

Table of Contents

Business Thinking and Financial Modeling for Technology Startups.- Company Business Model.- The Green Devil Control Systems Business Case.- The Staffing Model.- Sales and Revenue Model.- Cost of Goods Sold and Inventory Model.- Cost of Sales and Marketing Model.- Cost of Product Development Model.- Operating and Capital Expenditures Models.- Statements of Profit and Loss and Cash Flow.- Modeling Valuation and Investment with the FIN Model.- Financial Reporting and Analysis Using the FIN Model.