ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
2
Your Company
3
4
Template Revision date: 1/1/2020
5
Introduction
6
One of the most important roles you will play as a business owner is that of Financial Manager of your company. The Current Business Plan tool is designed to help you plan, manage, and monitor the performance of your company as easily and efficiently as possible.
7
Step by step instructions for using the tool follow:
8
2) Enter your basic business identity information
9
'2 Info'!A1
10
3) Enter all capital expenditures required to start your company
11
'3 Cap Ex'!A1
12
4) Enter details of the loan for your capital expenditures
13
'4 Cap Ex Loan'!A1
14
5) Enter your payroll expenses
15
'5 Team'!A1
16
6) Enter the pricing for for your products and services
17
'6 Services'!A1
18
7) Enter the number of units you expect to sell for each of your products and services
19
'7 Sales by Unit'!A1
20
8) Enter your anticipated monthly expenses bearing in mind that the payroll expenses will be entered on a different tab
21
'8 Mo P&L'!A1
22
23
SPECIAL NOTES:
24
When filling out this spreadsheet, note that most cells are protected.
25
In general, you should not enter data into boxes that are colored like this since they will contain formulas for auto-computing.
26
In general, expect to enter information in boxes that are colored like this.
27
You can turn off protection at any time as needed, but note that you risk losing some formulas if you do so. If you find you are
28
unable to enter information into a cell that you want to make an entry to, click on the cell and examine
29
the formula first, and see if there is another nearby cell you should fill in instead. Note that some cells
30
are named. If you want to jump to one of these, click on the down-arrow in the cell-address box, find
31
the name, and click on it. You will jump to that cell, no matter which worksheet it is on.
32
It is assumed that the values you type in will be in the local currency, while the final results will
33
print in US Dollars ($). It is also assumed that the exchange rate remains constant throughout
34
the time period being analyzed. For these purposes, we are not taking into account either
35
inflation or currency exchange rate changes. The time that the Exchange Rate is important
36
is at the time of funding of the business.
37
The VAT amount is not to be included in the costs of the materials we purchase or in the price at which we sell.
38
39
Copyright © Life2Live, LLC. 2005 to Present. All Rights Reserved.
No part of this document may be used, displayed or reproduced without the consent of the author.
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