PAR - EXPENSE SHEET.xlsx
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
View only
 
 
ABCDEFGHIJKLMNOPQRSTUVWXYZAAABACADAEAFAGAHAIAJAKALAMANAOAPAQARAS
1
SummaryYear 1Year 2Year 3
2
Sales $ 1,693,425 $ 2,659,125 $ 3,082,425
3
COGS $ (698,990) $ (1,097,599) $ (1,272,323)
4
People $ (110,400) $ (204,800) $ (243,200)
5
Office $ (1,650) $ (2,190) $ (2,190)
6
Marketing $ (24,000) $ (24,000) $ (24,000)
7
Professional Services
$ (1,200) $ (1,200) $ (1,200)
8
Amazon fulfillment fees
$ (295,143) $ (502,752) $ (582,784)
9
One-Time Costs $ (245,700)
10
Operating Expense
$ (836,240) $ (1,329,789) $ (1,542,913)
11
Net Profit $ 316,343 $ 1,329,336 $ 1,539,512
12
13
Cost of Goods Sold
(per unit)
14
Electronics $ 4.00
15
Hardware $ 2.00
16
Manufacturing $ 2.00
17
Shipping to warehouse $ 2.25
18
Total $ 10.25
19
20
Profit from SalesPer Unit Price $ 75.00
21
COGS $ (10.25)
22
CC Fees (2.7%) $ (2.03)
23
S&H $ (4.50)
24
Amazon fulfillment fees $ (14.18)
25
Total cose for each unit $ (30.96)
26
Profit/item $ 44.04
27
Margin59%
28
29
30
31
32
33
Y1Y1Y1Y1Y1Y1Y1Y1Y1Y1Y1Y1Y2Y2Y2Y2Y2Y2Y2Y2Y2Y2Y2Y2Y3Y3Y3Y3Y3Y3Y3Y3Y3Y3Y3Y3
34
M1M2M3M4M5M6M7M8M9M10M11M12M13M14M15M16M17M18M19M20M21M22M23M24M25M26M27M28M29M30M31M32M33M34M35M36Y1Y2Y3
35
Sales Model
Sales Model
36
Physical Product Sales - Depend on Markting Efficiency
Physical Product Sales - Depend on Markting Efficiency
37
Flyers & Brochures: # Sales per 100 flyers
1 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Flyers & Brochures: # Sales per 100 flyers
- - -
38
Salespeople: # Sales per person per month
500000500500500500500500500500500500500500500500500500500500500500500500500500500500500500500500500500500
Salespeople: # Sales per person per month
4,500 6,000 6,000
39
Internet Ads: Sales per $100 of advertising
40 1,600 400 400 800 800 800 800 800 800 800 800 800 800 800 800 800 800 800 800 800 800 800 800 800 800 800 800 800 800 800 800 800 800 800 800 800
Internet Ads: Sales per $100 of advertising
9,600 9,600 9,600
40
Word of Mouth: % Growth per # Units sold so far
1%0 17 17 17 36 57 78 101 124 148 173 199 225 252 280 308 336 365 395 424 455 485 517 548 580 612 645 678 711 745 779 813 848 883 919 955
Word of Mouth: % Growth per # Units sold so far
967 4,590 9,168
41
Sales from App users: % of app users who buy the product
1% 165 327 470 593 700 792 872 941 1,000 1,052 1,096 1,135 1,168 1,197 1,221 1,243 1,261 1,277 1,291 1,303 1,314 1,323 1,330 1,337 1,343 1,348 1,352 1,356 1,359 1,362 1,364 1,366 1,368 1,370 1,371 1,372
Sales from App users: % of app users who buy the product
9,143 15,265 16,331
42
43
Physical Product + App
Physical Product + App
44
Total Sales 1,765 - - 1,910 2,036 2,149 2,250 2,342 2,424 2,500 2,569 2,634 2,693 2,749 2,801 2,851 2,897 2,942 2,986 3,027 3,069 3,108 3,147 3,185 3,223 3,260 3,297 3,334 3,370 3,407 3,443 3,479 3,516 3,553 3,590 3,627 Total Sales 22,579 35,455 41,099
45
Revenue From Sales $ 132,375 $ - $ - $ 143,250 $ 152,700 $ 161,175 $ 168,750 $ 175,650 $ 181,800 $ 187,500 $ 192,675 $ 197,550 $ 201,975 $ 206,175 $ 210,075 $ 213,825 $ 217,275 $ 220,650 $ 223,950 $ 227,025 $ 230,175 $ 233,100 $ 236,025 $ 238,875 $ 241,725 $ 244,500 $ 247,275 $ 250,050 $ 252,750 $ 255,525 $ 258,225 $ 260,925 $ 263,700 $ 266,475 $ 269,250 $ 272,025 Revenue From Sales $ 1,693,425 $ 2,659,125 $ 3,082,425
46
Cost of Sales $ 54,640 $ - $ - $ 59,129 $ 63,030 $ 66,528 $ 69,654 $ 72,503 $ 75,041 $ 77,394 $ 79,530 $ 81,542 $ 83,369 $ 85,102 $ 86,712 $ 88,260 $ 89,684 $ 91,077 $ 92,439 $ 93,708 $ 95,009 $ 96,216 $ 97,423 $ 98,600 $ 99,776 $ 100,922 $ 102,067 $ 103,212 $ 104,327 $ 105,472 $ 106,587 $ 107,701 $ 108,847 $ 109,992 $ 111,138 $ 112,283 Cost of Sales $ 698,990 $ 1,097,599 $ 1,272,323
47
Profit From Sales $ 77,735 $ - $ - $ 84,121 $ 89,670 $ 94,647 $ 99,096 $ 103,147 $ 106,759 $ 110,106 $ 113,145 $ 116,008 $ 118,606 $ 121,073 $ 123,363 $ 125,565 $ 127,591 $ 129,573 $ 131,511 $ 133,317 $ 135,166 $ 136,884 $ 138,602 $ 140,275 $ 141,949 $ 143,578 $ 145,208 $ 146,838 $ 148,423 $ 150,053 $ 151,638 $ 153,224 $ 154,853 $ 156,483 $ 158,112 $ 159,742 Profit From Sales $ 994,435 $ 1,561,526 $ 1,810,102
48
Amazon fulfillment fees$14.18 $ 27,084 $ 28,870 $ 30,473 $ 31,905 $ 33,210 $ 34,372 $ 35,450 $ 36,428 $ 37,350 $ 38,187 $ 38,981 $ 39,718 $ 40,427 $ 41,079 $ 41,718 $ 42,341 $ 42,923 $ 43,518 $ 44,071 $ 44,624 $ 45,163 $ 45,702 $ 46,227 $ 46,751 $ 47,276 $ 47,787 $ 48,311 $ 48,822 $ 49,332 $ 49,857 $ 50,382 $ 50,906 $ 51,431 Amazon fulfillment fees $ 295,143 $ 502,752 $ 582,784
49
50
Standalone App DLs
Standalone App DLs
51
Addressable Market (12% of 6.9M adults in US that take medication for mental health disorder use health wearables)
828000
52
53
New Ad-supported Users
% of difference between current users and eventual user base size
2% 16,560 16,229 15,904 15,619 15,372 15,159 14,975 14,815 14,677 14,558 14,456 14,367 14,290 14,223 14,166 14,116 14,073 14,036 14,004 13,976 13,952 13,932 13,914 13,898 13,885 13,874 13,864 13,855 13,847 13,841 13,835 13,831 13,827 13,823 13,820 13,817 New Ad-supported Users 182,691 168,580 166,119
54
Total Ad-supported Users 16,560 32,789 47,037 59,377 70,045 79,267 87,237 94,125 100,079 105,224 109,672 113,517 116,840 119,711 122,193 124,338 126,192 127,794 129,179 130,375 131,409 132,304 133,077 133,745 134,322 134,821 135,253 135,626 135,948 136,226 136,466 136,675 136,855 137,011 137,145 137,261 Total Ad-supported Users 914,930 1,527,156 1,633,610
55
Attrition (%/month)10% - 1,656 3,279 4,704 5,938 7,005 7,927 8,724 9,413 10,008 10,522 10,967 11,352 11,684 11,971 12,219 12,434 12,619 12,779 12,918 13,038 13,141 13,230 13,308 13,374 13,432 13,482 13,525 13,563 13,595 13,623 13,647 13,667 13,686 13,701 13,715 Attrition (%/month) 80,141 150,693 163,009
56
New Paid Users (% of ad-supported users)
0% - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
New Paid Users (% of ad-supported users)
- - -
57
Total Paid Users - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - Total Paid Users - - -
58
59
Free User Ad RevenueRevenue Each/month $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - Free User Ad Revenue $ - $ - $ -
60
New Paid Users Revenue Each $ 2.00 $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - New Paid Users $ - $ - $ -
61
62
Total Users 16,560 32,789 47,037 59,377 70,045 79,267 87,237 94,125 100,079 105,224 109,672 113,517 116,840 119,711 122,193 124,338 126,192 127,794 129,179 130,375 131,409 132,304 133,077 133,745 134,322 134,821 135,253 135,626 135,948 136,226 136,466 136,675 136,855 137,011 137,145 137,261 Total Users 914,930 1,527,156 1,633,610
63
Total Revenue $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - Total Revenue $ - $ - $ -
64
65
Y1Y1Y1Y1Y1Y1Y1Y1Y1Y1Y1Y1Y2Y2Y2Y2Y2Y2Y2Y2Y2Y2Y2Y2Y3Y3Y3Y3Y3Y3Y3Y3Y3Y3Y3Y3
66
M1M2M3M4M5M6M7M8M9M10M11M12M13M14M15M16M17M18M19M20M21M22M23M24M25M26M27M28M29M30M31M32M33M34M35M36Y1Y2Y3
67
PeoplePeople
68
Part Time (FTE)$15/hr000111111111111111111111111111111111 Part Time (FTE) 0.8 1.0 1.0
69
FT$40k/yr000000000000111111111111111111111111
70
FT Sales$40k/yr (+comm)000111111111111111111111111111111111 FT Sales 0.8 1.0 1.0
71
FT CEO
$0 (Y1), $30K (Y2), $60K (Y3)
111111111111111111111111111111111111 FT CEO 1.0 1.0 1.0
72
FT Developer$110K000000000000000000000000000000000000 FT Developer - - -
73
Total People111333333333444444444444444444444444 Total People 2.5 4.0 4.0
74
75
76
Personnel Cost
Personnel Cost
77
Part Time$15/hr $ - $ - $ - $ 4,800 $ 4,800 $ 4,800 $ 4,800 $ 4,800 $ 4,800 $ 4,800 $ 4,800 $ 4,800 $ 4,800 $ 4,800 $ 4,800 $ 4,800 $ 4,800 $ 4,800 $ 4,800 $ 4,800 $ 4,800 $ 4,800 $ 4,800 $ 4,800 $ 4,800 $ 4,800 $ 4,800 $ 4,800 $ 4,800 $ 4,800 $ 4,800 $ 4,800 $ 4,800 $ 4,800 $ 4,800 $ 4,800 Part Time $ 43,200 $ 57,600 $ 57,600
78
FT $40k/yr $ 40,000 $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ 3,333.33 $ 3,333.33 $ 3,333.33 $ 3,333.33 $ 3,333.33 $ 3,333.33 $ 3,333.33 $ 3,333.33 $ 3,333.33 $ 3,333.33 $ 3,333.33 $ 3,333.33 $ 3,333.33 $ 3,333.33 $ 3,333.33 $ 3,333.33 $ 3,333.33 $ 3,333.33 $ 3,333.33 $ 3,333.33 $ 3,333.33 $ 3,333.33 $ 3,333.33 $ 3,333.33
79
FT Sales
$40k/yr (+$5 comm per sale)
$ 40,000 $ - $ - $ - $ 5,833.33 $ 5,833.33 $ 5,833.33 $ 5,833.33 $ 5,833.33 $ 5,833.33 $ 5,833.33 $ 5,833.33 $ 5,833.33 $ 5,833.33 $ 5,833.33 $ 5,833.33 $ 5,833.33 $ 5,833.33 $ 5,833.33 $ 5,833.33 $ 5,833.33 $ 5,833.33 $ 5,833.33 $ 5,833.33 $ 5,833.33 $ 5,833.33 $ 5,833.33 $ 5,833.33 $ 5,833.33 $ 5,833.33 $ 5,833.33 $ 5,833.33 $ 5,833.33 $ 5,833.33 $ 5,833.33 $ 5,833.33 $ 5,833.33 FT Sales $ 52,500 $ 70,000 $ 70,000
80
FT CEO
$0 (Y1), $30K (Y2), $60K (Y3)
$ 60,000 $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ 2,500 $ 2,500 $ 2,500 $ 2,500 $ 2,500 $ 2,500 $ 2,500 $ 2,500 $ 2,500 $ 2,500 $ 2,500 $ 2,500 $ 5,000 $ 5,000 $ 5,000 $ 5,000 $ 5,000 $ 5,000 $ 5,000 $ 5,000 $ 5,000 $ 5,000 $ 5,000 $ 5,000 FT CEO $ - $ 30,000 $ 60,000
81
FT Developer$110K $ 110,000 $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - FT Developer $ - $ - $ -
82
Benefits28% of FT worker pay $ - $ - $ - $ 1,633 $ 1,633 $ 1,633 $ 1,633 $ 1,633 $ 1,633 $ 1,633 $ 1,633 $ 1,633 $ 3,267 $ 3,267 $ 3,267 $ 3,267 $ 3,267 $ 3,267 $ 3,267 $ 3,267 $ 3,267 $ 3,267 $ 3,267 $ 3,267 $ 3,967 $ 3,967 $ 3,967 $ 3,967 $ 3,967 $ 3,967 $ 3,967 $ 3,967 $ 3,967 $ 3,967 $ 3,967 $ 3,967 Benefits $ 14,700 $ 39,200 $ 47,600
83
Training$2k/pp/yr $ 2,000 $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ 666.67 $ 666.67 $ 666.67 $ 666.67 $ 666.67 $ 666.67 $ 666.67 $ 666.67 $ 666.67 $ 666.67 $ 666.67 $ 666.67 $ 666.67 $ 666.67 $ 666.67 $ 666.67 $ 666.67 $ 666.67 $ 666.67 $ 666.67 $ 666.67 $ 666.67 $ 666.67 $ 666.67 Training $ - $ 8,000 $ 8,000
84
Total $ - $ - $ - $ 12,267 $ 12,267 $ 12,267 $ 12,267 $ 12,267 $ 12,267 $ 12,267 $ 12,267 $ 12,267 $ 20,400 $ 20,400 $ 20,400 $ 20,400 $ 20,400 $ 20,400 $ 20,400 $ 20,400 $ 20,400 $ 20,400 $ 20,400 $ 20,400 $ 23,600 $ 23,600 $ 23,600 $ 23,600 $ 23,600 $ 23,600 $ 23,600 $ 23,600 $ 23,600 $ 23,600 $ 23,600 $ 23,600 Total $ 110,400 $ 204,800 $ 243,200
85
86
Office, Equipment, Tech
Office, Equipment, Tech
87
Rent$450/pp/month $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - Rent $ - $ - $ -
88
Office Supplies$10/pp/month $ 10 $ 10 $ 10 $ 10 $ 30 $ 30 $ 30 $ 30 $ 30 $ 30 $ 30 $ 30 $ 30 $ 40 $ 40 $ 40 $ 40 $ 40 $ 40 $ 40 $ 40 $ 40 $ 40 $ 40 $ 40 $ 40 $ 40 $ 40 $ 40 $ 40 $ 40 $ 40 $ 40 $ 40 $ 40 $ 40 $ 40 Office Supplies $ 300 $ 480 $ 480
89
Stationary$10/pp/month $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - Stationary $ - $ - $ -
90
Business Cards$5/pp/month $ 5 $ 5 $ 5 $ 5 $ 15 $ 15 $ 15 $ 15 $ 15 $ 15 $ 15 $ 15 $ 15 $ 20 $ 20 $ 20 $ 20 $ 20 $ 20 $ 20 $ 20 $ 20 $ 20 $ 20 $ 20 $ 20 $ 20 $ 20 $ 20 $ 20 $ 20 $ 20 $ 20 $ 20 $ 20 $ 20 $ 20 Business Cards $ 150 $ 240 $ 240
91
Software - MS Office & Email$15/pp/month $ 15 $ 15 $ 15 $ 15 $ 45 $ 45 $ 45 $ 45 $ 45 $ 45 $ 45 $ 45 $ 45 $ 60 $ 60 $ 60 $ 60 $ 60 $ 60 $ 60 $ 60 $ 60 $ 60 $ 60 $ 60 $ 60 $ 60 $ 60 $ 60 $ 60 $ 60 $ 60 $ 60 $ 60 $ 60 $ 60 $ 60
Software - MS Office & Email
$ 450 $ 720 $ 720
92
Zendesk$20/pp/month $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - Zendesk $ - $ - $ -
93
Adobe CC$50/month $ 50 $ 50 $ 50 $ 50 $ 50 $ 50 $ 50 $ 50 $ 50 $ 50 $ 50 $ 50 $ 50 $ 50 $ 50 $ 50 $ 50 $ 50 $ 50 $ 50 $ 50 $ 50 $ 50 $ 50 $ 50 $ 50 $ 50 $ 50 $ 50 $ 50 $ 50 $ 50 $ 50 $ 50 $ 50 $ 50 $ 50 Adobe CC $ 600 $ 600 $ 600
94
Website$150/yr $ 12.50 $ 12.50 $ 12.50 $ 12.50 $ 12.50 $ 12.50 $ 12.50 $ 12.50 $ 12.50 $ 12.50 $ 12.50 $ 12.50 $ 12.50 $ 12.50 $ 12.50 $ 12.50 $ 12.50 $ 12.50 $ 12.50 $ 12.50 $ 12.50 $ 12.50 $ 12.50 $ 12.50 $ 12.50 $ 12.50 $ 12.50 $ 12.50 $ 12.50 $ 12.50 $ 12.50 $ 12.50 $ 12.50 $ 12.50 $ 12.50 $ 12.50 $ 12.50 Website $ 150 $ 150 $ 150
95
iOS License$100/yr $ 100.00 $ 100 $ 100 $ 100 iOS License $ 100 $ 100 $ 100
96
Kickstarter fees5% of total funds raised5% $ 6,619
97
Total $ 6,811 $ 93 $ 93 $ 153 $ 153 $ 153 $ 153 $ 153 $ 153 $ 153 $ 153 $ 153 $ 183 $ 183 $ 183 $ 183 $ 183 $ 183 $ 183 $ 183 $ 183 $ 183 $ 183 $ 183 $ 183 $ 183 $ 183 $ 183 $ 183 $ 183 $ 183 $ 183 $ 183 $ 183 $ 183 $ 183 Total $ 1,650 $ 2,190 $ 2,190
98
99
MarketingMarketing
100
Flyers & Brochures$148/5K Flyers $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - Flyers & Brochures $ - $ - $ -
Loading...
Main menu