ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
2
3
4
5
6
7
8
9
10
11
5-Year Financial Projections, Version 3.1.0
12
13
About this tool.
14
This worksheet allows entrepreneurs to create a five-year forecast, and to explore the impact of various funding scenarios.
15
Investors will want to see your financial roadmap. And when this tool is coupled with past financials, you can tell a complete financial story.
16
But updating a financial forecast every month is tedious.
17
That's why this Financial Projections tool takes a quarterly approach. You can map out a plan, starting with your last quarter's data. An update is needed only once every three months.
18
19
20
Some tips.
21
We designed the tool to be as simple and straightforward, but robust enough to allow you to explore funding scenarios.
22
But a few pointers should help.
23
First, gather together your last quarter's financial data: income statement and balance sheet.
24
Second, follow the 10 Steps on the "Inputs and Assumptions" worksheet, making decisions as you go.
25
Fill in the YELLOW cells, like this one:
26
Several categories of data allow you to choose two or more models (for example, straight percentage, varying percentage, dollar amount).
27
Be sure to select that method on the far left side of every input range!
28
When available, we've provided you with percentages based on your last quarter's data, so you can see what might be realistic.
29
We recommend not filling in the projections for long-term loans, revenue-based financing, and equity until you have everything else entered.
30
And while we've run piles of test data through, double-check the numbers for accuracy.
31
All cells except the yellow ones are protected, so formulas don't inadvertently get written over.
32
If you need to unlock the worksheets, the code is TEN. (And you'll have to unlock them to use the group/ungroup, courtesy of Microsoft.)
33
34
Disclaimers and other stuff.
35
We've made every reasonable effort to assure that this tool is accurate. However, it is possible that we made an error, or you have a unique set of data that our tool doesn't handle. Neither Texas Entrepreneur Networks nor Value Strategies LLC warrant, guarantee, or otherwise assert that this tool is accurate or complete. You use it at your own risk.
36
37
38
If you find an error, please email a copy of the workbook with your data and an explanation of the error to: tools@valuestrategiesllc.com.
39
This tool is copyrighted 2013 by Value Strategies LLC. It is provided to Texas Entrepreneur Networks under license. The license permits clients of Texas Entrepreneur Networks to use and modify the tool for their own purposes, but clients cannot sell, distribute, copy, or otherwise transfer the tool, either in whole or in part.
40
41
42
43
44
45
About Us
46
47
Texas Entrepreneur Networks
48
Texas Entrepreneur Networks helps startups and mid-market companies raise funding from angel investors, private, equity, family offices, and venture capitalists throughout the state of Texas.  In addition to fund raising, TEN provides support to companies for financial, marketing, sales, interim CEO, and other services.
49
50
51
52
Contact us!
Email:hallmartin@tencapital.group
53
Phone:512-656-9487
54
Web:www.tencapital.group
55
56
Value Strategies LLC
57
Value Strategies supports companies with a variety of services covering financial, accounting, and operational needs . Whether as a part-time CFO, developing business strategies, forecasting capital needs, calculating a firm’s valuation, or providing a sounding board, our focus for more than 10 years is on helping you get the most out of your company.
58
59
60
61
Contact us!
Email:Info@ValueStrategiesLLC.com
62
Phone:303-549-3981
63
Web:www.valuestrategiesllc.com
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100