sample_retail_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 Retail Projection
2
Five Year Operating Projection
3
Automatic SuggestionsAutomatic SuggestionYour EstimateYear 1 Actual
4
$%Year 1Year 2Year 3Year 4Year 5%
5
Income
6
Retail Sales- Type 1
$100,000.0032.79%$0.00$0.00$0.00$0.00$0.00#DIV/0!
7
Retail Sales- Type 2
$100,000.0032.79%$0.00$0.00$0.00$0.00$0.00#DIV/0!
8
Retail Sales- Type 3
$100,000.0032.79%$0.00$0.00$0.00$0.00$0.00#DIV/0!
9
Other/miscellaneous income
$5,000.001.64%$0.00$0.00$0.00$0.00$0.00#DIV/0!
10
Income total$305,000.00100.00%$0.00$0.00$0.00$0.00$0.00#DIV/0!
11
12
Expense
13
Cost of Goods Sold (COGS)
14
Retail Cost- Type 1
$34,160.0014.00%$0.00$0.00$0.00$0.00$0.00#DIV/0!
15
Retail Cost- Type 2
$34,160.0014.00%$0.00$0.00$0.00$0.00$0.00#DIV/0!
16
Retail Cost- Type 3
$34,160.0014.00%$0.00$0.00$0.00$0.00$0.00#DIV/0!
17
Sub-total COGS
$102,480.0042.00%$0.00$0.00$0.00$0.00$0.00#DIV/0!
18
19
Salaries and Wages
20
Management
$36,600.0015.00%$0.00$0.00$0.00$0.00$0.00#DIV/0!
21
Sales Associates
$17,080.007.00%$0.00$0.00$0.00$0.00$0.00#DIV/0!
22
Sub-total Salaries and Wages
$53,680.0022.00%$0.00$0.00$0.00$0.00$0.00#DIV/0!
23
24
Direct Expenses
25
Cable TV/Internet
$610.000.25%$0.00$0.00$0.00$0.00$0.00#DIV/0!
26
Music Royalties
$610.000.25%$0.00$0.00$0.00$0.00$0.00#DIV/0!
27
Sub-total Direct Expenses
$1,220.000.50%$0.00$0.00$0.00$0.00$0.00#DIV/0!
28
29
Indirect Expenses
30
General & Admin
31
Bank Charges$610.000.25%$0.00$0.00$0.00$0.00$0.00#DIV/0!
32
Licenses, Permits & Fees
$2,440.001.00%$0.00$0.00$0.00$0.00$0.00#DIV/0!
33
Merchant Fees/Discounts
$2,440.001.00%$0.00$0.00$0.00$0.00$0.00#DIV/0!
34
Payroll Processing$244.000.10%$0.00$0.00$0.00$0.00$0.00#DIV/0!
35
Office supplies$244.000.10%$0.00$0.00$0.00$0.00$0.00#DIV/0!
36
Dues & Subscriptions$610.000.25%$0.00$0.00$0.00$0.00$0.00#DIV/0!
37
Postage & Delivery$610.000.25%$0.00$0.00$0.00$0.00$0.00#DIV/0!
38
Repairs & Maintenance$2,440.001.00%$0.00$0.00$0.00$0.00$0.00#DIV/0!
39
Equipment Rental$976.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$31,720.0013.00%$0.00$0.00$0.00$0.00$0.00#DIV/0!
42
Sub-total General & Admin
$42,334.0017.35%$0.00$0.00$0.00$0.00$0.00#DIV/0!
43
44
Payroll
45
FICA Tax Expense$4,270.001.75%$0.00$0.00$0.00$0.00$0.00#DIV/0!
46
Medicare Tax Expense$1,220.000.50%$0.00$0.00$0.00$0.00$0.00#DIV/0!
47
FUTA Tax Expense$488.000.20%$0.00$0.00$0.00$0.00$0.00#DIV/0!
48
GA SUTA Tax Expense$488.000.20%$0.00$0.00$0.00$0.00$0.00#DIV/0!
49
Contract Labor$488.000.20%$0.00$0.00$0.00$0.00$0.00#DIV/0!
50
Sub-total Payroll
$6,954.002.85%$0.00$0.00$0.00$0.00$0.00#DIV/0!
51
52
Marketing
53
Advertising and Promotion
$12,322.005.05%$0.00$0.00$0.00$0.00$0.00#DIV/0!
54
Sub-total Marketing
$12,322.005.05%$0.00$0.00$0.00$0.00$0.00
55
56
Insurance
57
Worker's Compensation$610.000.25%$0.00$0.00$0.00$0.00$0.00#DIV/0!
58
General Liability$2,440.001.00%$0.00$0.00$0.00$0.00$0.00#DIV/0!
59
Sub-total Insurance
$3,050.001.25%$0.00$0.00$0.00$0.00$0.00#DIV/0!
60
61
Utilities
62
Electricity$9,760.004.00%$0.00$0.00$0.00$0.00$0.00#DIV/0!
63
Gas$4,270.001.75%$0.00$0.00$0.00$0.00$0.00#DIV/0!
64
Water$1,830.000.75%$0.00$0.00$0.00$0.00$0.00#DIV/0!
65
Telephone$366.000.15%$0.00$0.00$0.00$0.00$0.00#DIV/0!
66
Trash$366.000.15%$0.00$0.00$0.00$0.00$0.00#DIV/0!
67
Janitorial$244.000.10%$0.00$0.00$0.00$0.00$0.00#DIV/0!
68
Computer$244.000.10%$0.00$0.00$0.00$0.00$0.00#DIV/0!
69
Sub-total Utilities
$17,080.007.00%$0.00$0.00$0.00$0.00$0.00#DIV/0!
70
71
Professional Fees
72
Accounting Fees$1,220.000.50%$0.00$0.00$0.00$0.00$0.00#DIV/0!
73
Legal Fees$610.000.25%$0.00$0.00$0.00$0.00$0.00#DIV/0!
74
Consulting Fees$244.000.10%$0.00$0.00$0.00$0.00$0.00#DIV/0!
75
Sub-total Professional Fees
$2,074.000.85%$0.00$0.00$0.00$0.00$0.00#DIV/0!
76
Sub-total Indirect Expenses
$83,814.0034.35%$0.00$0.00$0.00$0.00$0.00#DIV/0!
77
78
Miscellaneous Expenses
$2,806.001.15%$0.00$0.00$0.00$0.00$0.00#DIV/0!
79
Expense total$244,000.00100.00% $ - $ - $ - $ - $ - #DIV/0!
80
81
Operating Funds Summary
Automatic Suggestions
82
$Year 1Year 2Year 3Year 4Year 5
83
Income$305,000.00 $0.00 $0.00 $0.00 $0.00 $0.00
84
Expense
$244,000.00 $0.00 $0.00 $0.00 $0.00 $0.00
85
GROSS PROFIT
$61,000.00 $0.00 $0.00 $0.00 $0.00 $0.00
86
Debt Service
$ 53,196.44 $53,196.44$53,196.44$53,196.44$53,196.44$53,196.44
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
$5,303.56 ($58,196.44)($58,196.44)($58,196.44)($58,196.44)($58,196.44)
89
DCR 1.15 - - - - -
90
% Margin
1.74%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