ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Bike Co LLC
2
Frames Built109101039Assumptions
3
IncomeQuarter 1Quarter 2Quarter 3Quarter 4TotalAvg. Frame price$3,200.00
4
SalesAvg Fork price$875.00
5
Frames$32,000.00$28,800.00$32,000.00$32,000.00$124,800.00% of frames sell with fork33.00%
6
Forks$2,887.50$2,598.75$2,887.50$2,887.50$11,261.25Avg. Other price$250.00
7
Other Components0$0.00$0.0000Average Parts Kit$4,250.00
8
Bike Parts (build kits etc)$23,375.00$21,037.50$23,375.00$23,375.00$91,162.50Percent of builds that get a parts kit:55.0%
9
Total Sales$58,262.50$52,436.25$58,262.50$58,262.50$227,223.75
10
11
Cost of Goods Sold
12
Frames$12,000.00$10,800.00$12,000.00$12,000.00$46,800.00Fame Avg. COGS$1,200.00
13
Forks$990.00$891.00$990.00$990.00$3,861.00Fork COGS$300.00
14
Other Componenets0$0.006000600Avg. components COGS$65.00
15
Parts$13,557.50$12,201.75$13,557.50$13,557.50$52,874.25Parts Margin42%
16
Total COGS$26,547.50$23,892.75$27,147.50$26,547.50$104,135.25
17
18
Gross Profit$31,715.00$28,543.50$31,115.00$31,715.00$123,088.50
19
Other Income
20
21
TOTAL INCOME$31,715.00$28,543.50$31,115.00$31,715.00$123,088.50
22
23
EXPENSES
24
Operating Expenses
25
Advertising$3,000.00$1,000.00$1,200.00$800.00$6,000.00
26
Insurance$475.00$475.00$475.00$475.00$1,900.00Annual Insurance expense$1,900.00
27
Office Supplies$80.00$80.00$80.00$150.00$390.00Monthly Rent$1,100.00
28
Rent$3,300.00$3,300.00$3,300.00$3,300.00$13,200.00Annual Shop supplies$5,000.00
29
Salary$20,000.00$20,000.00$20,000.00$20,000.00$80,000.00R&D Allowance$6,000.00
30
Shipping and Delivery $1,200.00$1,080.00$1,200.00$1,200.00$4,680.00Travel Allowance$1,500.00
31
Shop Supplies$1,250.00$1,250.00$1,250.00$1,250.00$5,000.00
32
R&D$0.00$0.00$2,500.00$250.00$2,750.00
33
Travel$375.00$375.00$375.00$375.00$1,500.00
Monthy avg overhead
34
Total Operating Expenses$29,680.00$27,560.00$30,380.00$27,800.00$115,420.00$9,618.33
35
36
net income before taxes$2,035.00$983.50$735.00$3,915.00$7,668.50
37
tax expense$344.23$257.25$1,370.25$2,683.98
38
39
NET INCOME$2,035.00$639.28$477.75$2,544.75$4,984.53
40
Monthly$678.33$213.09$159.25$848.25
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