ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Financial Projection Model
2
3
This spreadsheet walks you through the process of developing an integrated set of financial projections.
4
5
To use this model, simply complete any information asked for found in the color yellow.
6
Example: Fill in boxes that look like this -
7
8
A number found in the color green is optional information that you can complete.
9
Example: Check these assumptions -
10
11
Otherwise, any information found in black type is automatically calculated for you.
12
Although the cells that are calculated are locked (or protected), you can turn off this protection to modify the sheets.
13
To do this, select "Tools" from the menu bar at the top of the screen. Then select, "Protection."
14
Finally, select "Unprotect Sheet" and you will be able to edit any labels or formulas.
15
16
Before you begin, we need some information about your business to best customize your financial statements.
17
Please enter the name of your business in the box below:
18
19
Enter Your Business Name Here
20
21
22
The first six worksheets in this workbook are steps you will need to complete. They are titled:
23
1. Required Start-Up Funds
24
2. Salaries and Wages
25
3. Fixed Operating Expenses
26
4. Projected Sales Forecast (2 sheets)
27
5. Cash Receipts and Disbursements
28
The sixth step titled, "Beginning Balance Sheet" is for existing businesses only.
29
30
31
Begin by clicking on the tabs below
32
q
33
34
35
36
37
38
39
40
41
42
43
44
45
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