ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Democracy At Work Institute
2
Pro Forma Template
3
Version 1.3 - October 2015
4
5
Welcome
6
This workbook is a template for designing a preliminary pro forma business plan.
7
The purpose of the template is to introduce basic concepts to beginners, and to allow for quick feasibility inquries.
8
For simplicity it is designed to illustrate a retail store.
9
Every business is diffferent and their financial projects will need customization.
10
Feel free to adapt this to your needs, or to contact DAWI to request technical assistance.
11
info@institute.usworker.coop
12
13
How to fill it out
14
Each tab has some cells that are colored yellow.
15
These are the cells you should fill in with your responses to the prompting questions.
16
Your responses will be used to fill out the rest of the sheet.
17
Anything that is not yellow you should not change.
18
Try it here. Enter your business name. This will show up on all the other pages.
19
20
Retail Worker Cooperative, Inc
21
22
Some areas are also shaded.
23
Read these for guidance.
24
25
Two metaphors
26
Financial statements are a map. You plan your journey with them, but it is likely you will sometimes veer from the path.
27
Financial statements are a recipe. If you want to make more pancakes, you need to scale all the ingredients in proportion, not just increase the eggs.
28
29
Two concepts
30
When possible, don't think about dollars, think about people.
31
Think about how you would answer if a lender was looking at a number and asked you where it came from. Can you defend it?
32
33
Sequence
34
Start by filling out the workbook in the following order.
35
You can go back and change your numbers, but if you jump ahead some of the formulas may not work.
36
37
Income
38
Labor
39
Expenses
40
Sources and Uses
41
Debt
42
43
What is missing
44
This template does not include a Balance Sheet template.
45
We plan to include one in a future version.
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
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