Tweet

$49

Complete Financial Model

• Fully-functioning Excel financial model template.
• Estimate marketing, sales, hiring plans, revenue, costs, and profit and loss.
• Model your viral customer acquisition strategies and online marketing conversions by sales channels for B2C and B2B.
• Example revenue models include freemium, per-download, subscription, in-app transaction fees, and activity pricing.
• Complete financial statements, including income statement, balance sheet, and statement of cash flows.
• Complete capitalization table.
• Save 60 to 80 hours compared to creating your own.
• Perfect for building complete financial projections.

Daniel Hughes, Storage by Mail: "The benefits of creating a financial model for your business comes not from the mechanics of building the spreadsheet but rather from the rigorous thought that goes into figuring out the revenue and cost drivers. Beginning with Taylor's models allowed us to spend less time on the former and more on the latter --- and the end product was better as a result."

Yes, financial models are always wrong. But it's important to create one anyway. Trust me. I have created, modified, and delivered hundreds of custom financial models in Excel for a range of clients over the past decade, and learned a lot about how to create and use financial models in decision-making.

Creating a financial model forces an entrepreneur to outline very specifically how a business “works”: how a company creates their products, how users and customers find and use their products and how those processes create revenues and costs. The result, a set of operational metrics, financial statements and the “equation of the business”, is one view of a potential reality of the business. While any one view is inevitably wrong, by digging deeper and analyzing the key drivers and testing a range of assumptions an entrepreneur can create multiple views to help make crucial product design, marketing, organizational and strategy decisions.

Instead of focusing on the bottom line profit and net income, focus on the assumptions and key drivers of the business. Developing a financial model creates the type of thought and data that helps entrepreneurs figure out what they are betting on and how likely their bets will pay off.

$49

Outline your assumptions. Link your marketing plan to your revenue model. Estimate your cost structure. Build complete financial statements.

The Complete Model is a fully-functioning financial model that is intended to help entrepreneurs:

• Create marketing plans and estimate the costs and success in acquiring customers
• Estimate pricing plans, price points and estimate revenues
• Understand the key components of cost of goods sold (COGS) and selling, general and administrative (SG&A) costs behind the business
• Create the full financial statements needed for investors (income statement, balance sheet, statement of cash flows)
• Create funding estimates and outline a complete capitalization table to estimate ownership structure

The Complete Model uses a mix of assumptions to estimate all revenue and cost line-items monthly over a flexible four year period, and then sums the monthly results into years for an easy view into the various time periods. You can easily set the start date and year for key decisions, and the model adjusts automatically.

Please note a couple limitations:

• The model is not built for all types of businesses or for all different types of revenue or cost models. It will require customization.
• This model is by no means perfect, nor will they be applicable for everyone. In fact, the revenue and cost estimates are only applicable for certain businesses, revenue models, products and cost structures.
• Also, these spreadsheets is provided AS-IS. No representations or warranties are granted for their use. No support guaranteed. Use it, learn from it, but please check your results before using this spreadsheet to make any decisions.

$49

The model is formatted for usability:

• Cell color: all cells where the number is typed in is a BLUE-colored text; all cells that have BLACK-colored text are the result of formulas and should not be changed.
• Row names: many are just named "XXX" - just type in the name on the Detailed Sheet and month sheets will change automatically

As far as the default asumptions go, any numbers in assumptions should not be trusted for your business, and should not be considered indicative of anything except to show how assumptions can be used.

If you're looking for a simpler model to get started, you should start with the Simple Model. The Simple Model does not include the full financial statements and capitalization table, but is built exactly the same and completely compatible with the Complete Model if you eventually decide to upgrade. Purchase the Simple Model here.