sample_service_financial_projections_10.25.17
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
View only
 
 
ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Sample Service Projection
2
Five Year Operating Projection
3
Automatic SuggestionsAutomatic SuggestionYour EstimateYear 1 Actual
4
$%Year 1Year 2Year 3Year 4Year 5%
5
Income
6
Service Sales- Type 1
$50,000.0032.79%$0.00$0.00$0.00$0.00$0.00#DIV/0!
7
Service Sales- Type 2
$50,000.0032.79%$0.00$0.00$0.00$0.00$0.00#DIV/0!
8
Service Sales- Type 3
$50,000.0032.79%$0.00$0.00$0.00$0.00$0.00#DIV/0!
9
Other/miscellaneous income
$2,500.001.64%$0.00$0.00$0.00$0.00$0.00#DIV/0!
10
Income total$152,500.00100.00%$0.00$0.00$0.00$0.00$0.00#DIV/0!
11
12
Expense
13
Cost of Goods Sold (COGS)
14
Service Materials- Type 1
$6,100.005.00%$0.00$0.00$0.00$0.00$0.00#DIV/0!
15
Service Materials- Type 2
$6,100.005.00%$0.00$0.00$0.00$0.00$0.00#DIV/0!
16
Service Materials- Type 3
$6,100.005.00%$0.00$0.00$0.00$0.00$0.00#DIV/0!
17
Sub-total COGS
$18,300.0015.00%$0.00$0.00$0.00$0.00$0.00#DIV/0!
18
19
Salaries and Wages
20
Management
$30,500.0025.00%$0.00$0.00$0.00$0.00$0.00#DIV/0!
21
Sales Associates
$8,540.007.00%$0.00$0.00$0.00$0.00$0.00#DIV/0!
22
Sub-total Salaries and Wages
$39,040.0032.00%$0.00$0.00$0.00$0.00$0.00#DIV/0!
23
24
Direct Expenses
25
Cable TV/Internet
$305.000.25%$0.00$0.00$0.00$0.00$0.00#DIV/0!
26
Music Royalties
$305.000.25%$0.00$0.00$0.00$0.00$0.00#DIV/0!
27
Sub-total Direct Expenses
$610.000.50%$0.00$0.00$0.00$0.00$0.00#DIV/0!
28
29
Indirect Expenses
30
General & Admin
31
Bank Charges$305.000.25%$0.00$0.00$0.00$0.00$0.00#DIV/0!
32
Licenses, Permits & Fees
$1,220.001.00%$0.00$0.00$0.00$0.00$0.00#DIV/0!
33
Merchant Fees/Discounts
$1,220.001.00%$0.00$0.00$0.00$0.00$0.00#DIV/0!
34
Payroll Processing$122.000.10%$0.00$0.00$0.00$0.00$0.00#DIV/0!
35
Office supplies$122.000.10%$0.00$0.00$0.00$0.00$0.00#DIV/0!
36
Dues & Subscriptions$305.000.25%$0.00$0.00$0.00$0.00$0.00#DIV/0!
37
Postage & Delivery$305.000.25%$0.00$0.00$0.00$0.00$0.00#DIV/0!
38
Repairs & Maintenance$1,220.001.00%$0.00$0.00$0.00$0.00$0.00#DIV/0!
39
Equipment Rental$488.000.40%$0.00$0.00$0.00$0.00$0.00#DIV/0!
40
Storage Expense$0.000.00%$0.00$0.00$0.00$0.00$0.00#DIV/0!
41
Rent/Mortgage Expense$15,860.0013.00%$0.00$0.00$0.00$0.00$0.00#DIV/0!
42
Sub-total General & Admin
$21,167.0017.35%$0.00$0.00$0.00$0.00$0.00#DIV/0!
43
44
Payroll
45
FICA Tax Expense$2,135.001.75%$0.00$0.00$0.00$0.00$0.00#DIV/0!
46
Medicare Tax Expense$610.000.50%$0.00$0.00$0.00$0.00$0.00#DIV/0!
47
FUTA Tax Expense$244.000.20%$0.00$0.00$0.00$0.00$0.00#DIV/0!
48
GA SUTA Tax Expense$244.000.20%$0.00$0.00$0.00$0.00$0.00#DIV/0!
49
Contract Labor$244.000.20%$0.00$0.00$0.00$0.00$0.00#DIV/0!
50
Sub-total Payroll
$3,477.002.85%$0.00$0.00$0.00$0.00$0.00#DIV/0!
51
52
Marketing
53
Advertising and Promotion
$6,161.005.05%$0.00$0.00$0.00$0.00$0.00#DIV/0!
54
Sub-total Marketing
$6,161.005.05%$0.00$0.00$0.00$0.00$0.00
55
56
Insurance
57
Worker's Compensation$305.000.25%$0.00$0.00$0.00$0.00$0.00#DIV/0!
58
General Liability$1,220.001.00%$0.00$0.00$0.00$0.00$0.00#DIV/0!
59
Sub-total Insurance
$1,525.001.25%$0.00$0.00$0.00$0.00$0.00#DIV/0!
60
61
Utilities
62
Electricity$4,880.004.00%$0.00$0.00$0.00$0.00$0.00#DIV/0!
63
Gas$2,135.001.75%$0.00$0.00$0.00$0.00$0.00#DIV/0!
64
Water$915.000.75%$0.00$0.00$0.00$0.00$0.00#DIV/0!
65
Telephone$183.000.15%$0.00$0.00$0.00$0.00$0.00#DIV/0!
66
Trash$183.000.15%$0.00$0.00$0.00$0.00$0.00#DIV/0!
67
Janitorial$122.000.10%$0.00$0.00$0.00$0.00$0.00#DIV/0!
68
Computer$122.000.10%$0.00$0.00$0.00$0.00$0.00#DIV/0!
69
Sub-total Utilities
$8,540.007.00%$0.00$0.00$0.00$0.00$0.00#DIV/0!
70
71
Professional Fees
72
Accounting Fees$610.000.50%$0.00$0.00$0.00$0.00$0.00#DIV/0!
73
Legal Fees$305.000.25%$0.00$0.00$0.00$0.00$0.00#DIV/0!
74
Consulting Fees$122.000.10%$0.00$0.00$0.00$0.00$0.00#DIV/0!
75
Sub-total Professional Fees
$1,037.000.85%$0.00$0.00$0.00$0.00$0.00#DIV/0!
76
Sub-total Indirect Expenses
$41,907.0034.35%$0.00$0.00$0.00$0.00$0.00#DIV/0!
77
78
Miscellaneous Expenses
$1,403.001.15%$0.00$0.00$0.00$0.00$0.00#DIV/0!
79
Expense total$101,260.0083.00% $ - $ - $ - $ - $ - #DIV/0!
80
81
Operating Funds Summary
Automatic Suggestions
82
$Year 1Year 2Year 3Year 4Year 5
83
Income$152,500.00 $0.00 $0.00 $0.00 $0.00 $0.00
84
Expense
$122,000.00 $0.00 $0.00 $0.00 $0.00 $0.00
85
GROSS PROFIT
$30,500.00 $0.00 $0.00 $0.00 $0.00 $0.00
86
Debt Service
$ 17,164.21 $17,164.21$17,164.21$17,164.21$17,164.21$17,164.21
87
Retained/Reinvestment/Reserve
$ 2,500.00 $5,000.00$5,000.00$5,000.00$5,000.00$5,000.00
88
NET PROFIT
$10,835.79 ($22,164.21)($22,164.21)($22,164.21)($22,164.21)($22,164.21)
89
DCR 1.78 - - - - -
90
% Margin
7.11%0.00%0.00%0.00%0.00%0.00%
91
92
Target margin80%
93
Annual Income Rise:5%
Annual Expense Rise:
4%
94
95
96
97
98
99
100
Loading...
Main menu