ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
2
AssumptionsInput data in cells colored like this
3
These cells contain formula, so they will be automatically updated. Don't input data in them
4
5
AssumptionsunitBaselineYear 1Year 2Year 3Year 4Year 5Year 6Year 7Year 8Year 9Year 10
6
Provide the requested information for your business in each of the ten Assumption sections below. Terms with an asterisk in front of them are defined in the section glossary at the end of each section
7
8
A. General
9
Income Statement
Select your business country, business currency (local currency or US Dollar), and list the names/descriptions of your business offerings below. Also, input the applicable tax, interest and inflation rates for your country, and depreciation rates for your business assets
10
11
Business Country37
12
13
Balance SheetBusiness Currency1
14
15
Business Products/Services
16
Product/Service 1Virtual Support services
17
Cash flow StatementProduct/Service 2Digital Marketing and Creative Services
18
Product/Service 3Admin, Technical and other Support services
19
20
Company tax rate%8%
21
SummaryBank interest rate%28%
22
Inflation rate (might need to drop this a bit to make the business plan rosier)
%24%
23
Depreciation rates
24
Building%1%
25
Furniture%20%
26
Equipment / Machinery%25%
27
Vehicles%1%
28
Installations%10%
29
30
B. Growth Rates
31
Enter the expected yearly growth rates for your business below. You can use the growth rates to demonstrate projected expansion plans for your business
32
33
Revenue (should calcuate with chatgpt on realistic growth rates)
34
Virtual Support services
35
Sales volume %400%200%100%100%50%20%10%10%10%10%
36
Price%0%24%8%19%5%18%3%18%3%18%
37
Digital Marketing and Creative Services
38
Sales volume%400%200%100%100%50%20%10%10%10%10%
39
Price%0%24%8%19%5%18%3%18%3%18%
40
Admin, Technical and other Support services
41
Sales volume%400%200%100%100%50%20%10%10%10%10%
42
Price%0%24%8%19%5%18%3%18%3%18%
43
Costs
44
Direct costs%0%206%100%100%50%20%10%10%10%10%
45
Salaries%0%30%30%15%15%10%10%10%10%10%
46
Rent%0%24%24%24%24%24%24%24%24%24%
47
Utilities%0%18%18%18%18%18%18%18%18%18%
48
Marketing/Advertisement%0%100%260%154%60%20%8%7%7%7%
49
Administrative%0%125%67%20%44%23%22%13%11%8%
50
Maintenance%24%24%24%24%24%24%24%24%24%24%
51
Insurance%0%10%15%15%12%12%12%12%12%12%
52
Transport%
53
Subscription/Licenses%0%24%24%24%24%24%24%24%24%24%
54
55
Glossary
56
Utilities: covers costs for electricity, water, gas, internet and telephone usage
57
58
C. Startup Costs
59
Enter the costs you expect to incur in the process of setting up your business below. Note that not all costs may be relevant to your business, so only fill where necessary
60
* Re-purchase of CAPEX costs automatically compute in the year after assets reach salvage value of 0, at compounded inflation rate
61
Land$ - - - - - - - - - - -
62
Building / Civil Works$ - - - - - - - - - - -
63
Furnitures and Fittings$ 375.00 375.00 - - - 1,086.56 - - - - 3,148.32
64
Equipment and Machinery$ 312.50 312.50 - - 731.93 - - - 1,714.31 - -
65
Vehicles$ - - - - - - - - - - -
66
Installations$ 612.50 612.50 - - - - - - - - 5,142.26
67
68
Automatically compute the additional startup costs by selecting from the drop-down menus to the right:
69
Opening Inventory$0 592.87
70
Initial Working Capital*$0 1,777.75
71
Contingency$ 1,101.19 30%of total startup cost
72
73
Total$ 4,771.81 - - 731.93 1,086.56 - - 1,714.31 - 8,290.58
74
75
Glossary
76
Opening Inventory: allocation for purchase of initial stock of products for sale or services to be delivered in the first few months of operating the business
77
Initial Working Capital: allocation for payments to vendors and employees in the first few months of operating the business
78
79
D. Headcount analysis
80
Enter the salary and number of employees you expect for each key business function. Note that not all headcount groups may be relevant to your own business, so only fill if necessary.
81
82
Benefits* % of salary%0.002.007.0011.0014.0022.0028.0033.0038.0043.0047.00
83
90.00180.00360.00540.00648.00712.80784.08862.49948.74
84
Senior Management (CEO, COO, CFO, etc)
* Future salary costs are automatically computed from annual growth rates entered in Section B above
85
Number of employees#1.002.002.002.003.003.003.003.003.003.00
86
Base annual salary$218.75218.75284.38369.69425.14488.91537.80591.58650.74715.82787.40
87
the rate of salary growth for senior manaement should be a differerent, much sharper bumps
88
Total Salaries & Benefits for Senior Management personnel
218.75568.75739.38850.281466.741613.411774.751952.222147.452362.19
89
90
Business Development*
91
Number of employees (Manager)#1.001.001.001.001.001.001.001.00
92
Number of employees (Associate)#1.002.003.003.003.004.004.00
93
Base annual salary (Manager)$187.50187.50243.75316.88364.41419.07460.97507.07557.78613.56674.91
94
Base annual salary (Associate)$125.00125.00162.50211.25242.94279.38307.32338.05371.85409.04449.94
95
96
Total Salaries & Benefits for Business Development personnel
0.000.00316.88607.34977.821382.921521.211673.342249.712474.68
97
98
Sales/Customer Support
99
Number of employees (Manager)#1.001.002.002.002.003.003.003.00
100
Number of employees (Associate)#2.002.003.003.005.006.006.006.008.00