ABCDEFGHIJKLMNOPQRSTUVWXYZAAABACADAEAFAGAHAIAJAKALAMANAOAPAQARASATAUAVAWAXAYAZBABBBCBDBEBFBGBHBIBJ
1
SUMMARY
2
3
REVENUE AND COSTS
4
Jan-22Feb-22Mar-22Apr-22May-22Jun-22Jul-22Aug-22Sep-22Oct-22Nov-22Dec-22Jan-23Feb-23Mar-23Apr-23May-23Jun-23Jul-23Aug-23Sep-23Oct-23Nov-23Dec-23Jan-24Feb-24Mar-24Apr-24May-24Jun-24Jul-24Aug-24Sep-24Oct-24Nov-24Dec-24Jan-25Feb-25Mar-25Apr-25May-25Jun-25Jul-25Aug-25Sep-25Oct-25Nov-25Dec-25Jan-26Feb-26Mar-26Apr-26May-26Jun-26Jul-26Aug-26Sep-26Oct-26Nov-26Dec-26
5
Sales Revenue $ - $ - $ - $ - $ - $ - $ - $ - $ 3,749.81 $ 3,749.81 $ 3,749.81 $ 3,749.81 $ 6,249.69 $ 6,249.69 $ 7,499.63 $ 7,499.63 $ 7,499.63 $ 18,674.07 $ 14,011.80 $ 14,686.77 $ 16,274.19 $ 14,274.29 $ 13,024.35 $ 14,124.29 $ 11,856.55 $ 13,285.05 $ 15,142.10 $ 13,713.60 $ 17,570.55 $ 17,570.55 $ 14,142.15 $ 16,999.15 $ 30,569.90 $ 30,569.90 $ 30,569.90 $ 22,284.60 $ 22,284.60 $ 22,284.60 $ 22,998.85 $ 24,427.35 $ 33,712.60 $ 36,569.60 $ 32,998.35 $ 36,569.60 $ 58,568.50 $ 61,425.50 $ 61,425.50 $ 50,854.60 $ 59,330.37 $ 59,330.37 $ 59,330.37 $ 65,996.70 $ 77,662.78 $ 77,662.78 $ 79,329.37 $ 82,662.53 $ 98,328.42 $ 113,327.67 $ 104,994.75 $ 104,994.75
6
Product Costs $ - $ - $ - $ - $ - $ - $ - $ (5,018.90) $ - $ (5,018.90) $ - $ - $ - $ - $ (5,018.90) $ - $ (40,150.00) $ - $ - $ - $ - $ - $ - $ - $ (40,150.00) $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ (40,150.00) $ - $ - $ - $ - $ - $ (40,150.00) $ - $ - $ - $ - $ - $ (40,150.00) $ - $ (40,150.00) $ - $ (40,150.00) $ - $ (40,150.00) $ - $ (40,150.00) $ - $ - $ -
7
Marketing Costs $ - $ - $ - $ - $ - $ - $ - $ - $ (1,500.00) $ (1,500.00) $ (1,500.00) $ (1,500.00) $ (2,500.00) $ (2,500.00) $ (3,000.00) $ (3,000.00) $ (3,000.00) $ (7,470.00) $ (5,605.00) $ (5,875.00) $ (6,510.00) $ (5,710.00) $ (5,210.00) $ (5,650.00) $ (4,150.00) $ (4,650.00) $ (5,300.00) $ (4,800.00) $ (6,150.00) $ (6,150.00) $ (4,950.00) $ (5,950.00) $ (10,700.00) $ (10,700.00) $ (10,700.00) $ (7,800.00) $ (7,800.00) $ (7,800.00) $ (8,050.00) $ (8,550.00) $ (11,800.00) $ (12,800.00) $ (11,550.00) $ (12,800.00) $ (20,500.00) $ (21,500.00) $ (21,500.00) $ (17,800.00) $ (17,800.00) $ (17,800.00) $ (17,800.00) $ (19,800.00) $ (23,300.00) $ (23,300.00) $ (23,800.00) $ (24,800.00) $ (29,500.00) $ (34,000.00) $ (31,500.00) $ (31,500.00)
8
Operating Costs $ (11,125.00) $ (11,000.00) $ (11,000.00) $ (11,000.00) $ (11,000.00) $ (11,000.00) $ (9,500.00) $ (9,500.00) $ (9,500.00) $ (9,500.00) $ (9,500.00) $ (9,500.00) $ (8,530.00) $ (8,500.00) $ (8,500.00) $ (8,500.00) $ (7,000.00) $ (4,500.00) $ (4,500.00) $ (5,000.00) $ (5,000.00) $ (5,000.00) $ (2,500.00) $ (2,500.00) $ (7,030.00) $ (5,000.00) $ (5,000.00) $ (5,000.00) $ (5,000.00) $ (5,000.00) $ (7,000.00) $ (5,000.00) $ (5,000.00) $ (5,000.00) $ (5,000.00) $ (5,000.00) $ (7,030.00) $ (5,000.00) $ (5,000.00) $ (5,000.00) $ (5,000.00) $ (5,000.00) $ (7,000.00) $ (5,000.00) $ (5,000.00) $ (5,000.00) $ (5,000.00) $ (5,000.00) $ (7,030.00) $ (5,000.00) $ (5,000.00) $ (5,000.00) $ (5,000.00) $ (5,000.00) $ (7,000.00) $ (5,000.00) $ (5,000.00) $ (5,000.00) $ (5,000.00) $ (5,000.00)
9
TOTAL REVENUE (monthly)
 $ - $ - $ - $ - $ - $ - $ - $ - $ 3,749.81 $ 3,749.81 $ 3,749.81 $ 3,749.81 $ 6,249.69 $ 6,249.69 $ 7,499.63 $ 7,499.63 $ 7,499.63 $ 18,674.07 $ 14,011.80 $ 14,686.77 $ 16,274.19 $ 14,274.29 $ 13,024.35 $ 14,124.29 $ 11,856.55 $ 13,285.05 $ 15,142.10 $ 13,713.60 $ 17,570.55 $ 17,570.55 $ 14,142.15 $ 16,999.15 $ 30,569.90 $ 30,569.90 $ 30,569.90 $ 22,284.60 $ 22,284.60 $ 22,284.60 $ 22,998.85 $ 24,427.35 $ 33,712.60 $ 36,569.60 $ 32,998.35 $ 36,569.60 $ 58,568.50 $ 61,425.50 $ 61,425.50 $ 50,854.60 $ 59,330.37 $ 59,330.37 $ 59,330.37 $ 65,996.70 $ 77,662.78 $ 77,662.78 $ 79,329.37 $ 82,662.53 $ 98,328.42 $ 113,327.67 $ 104,994.75 $ 104,994.75
10
TOTAL COSTS (monthly
 $ 11,125.00 $ 11,000.00 $ 11,000.00 $ 11,000.00 $ 11,000.00 $ 11,000.00 $ 9,500.00 $ 14,518.90 $ 11,000.00 $ 16,018.90 $ 11,000.00 $ 11,000.00 $ 11,030.00 $ 11,000.00 $ 16,518.90 $ 11,500.00 $ 50,150.00 $ 11,970.00 $ 10,105.00 $ 10,875.00 $ 11,510.00 $ 10,710.00 $ 7,710.00 $ 8,150.00 $ 51,330.00 $ 9,650.00 $ 10,300.00 $ 9,800.00 $ 11,150.00 $ 11,150.00 $ 11,950.00 $ 10,950.00 $ 15,700.00 $ 15,700.00 $ 15,700.00 $ 12,800.00 $ 54,980.00 $ 12,800.00 $ 13,050.00 $ 13,550.00 $ 16,800.00 $ 17,800.00 $ 58,700.00 $ 17,800.00 $ 25,500.00 $ 26,500.00 $ 26,500.00 $ 22,800.00 $ 64,980.00 $ 22,800.00 $ 62,950.00 $ 24,800.00 $ 68,450.00 $ 28,300.00 $ 70,950.00 $ 29,800.00 $ 74,650.00 $ 39,000.00 $ 36,500.00 $ 36,500.00
11
PROFIT (monthly) $ (11,125.00) $ (11,000.00) $ (11,000.00) $ (11,000.00) $ (11,000.00) $ (11,000.00) $ (9,500.00) $ (14,518.90) $ (7,250.19) $ (12,269.09) $ (7,250.19) $ (7,250.19) $ (4,780.31) $ (4,750.31) $ (9,019.28) $ (4,000.38) $ (42,650.38) $ 6,704.07 $ 3,906.80 $ 3,811.77 $ 4,764.19 $ 3,564.29 $ 5,314.35 $ 5,974.29 $ (39,473.45) $ 3,635.05 $ 4,842.10 $ 3,913.60 $ 6,420.55 $ 6,420.55 $ 2,192.15 $ 6,049.15 $ 14,869.90 $ 14,869.90 $ 14,869.90 $ 9,484.60 $ (32,695.40) $ 9,484.60 $ 9,948.85 $ 10,877.35 $ 16,912.60 $ 18,769.60 $ (25,701.65) $ 18,769.60 $ 33,068.50 $ 34,925.50 $ 34,925.50 $ 28,054.60 $ (5,649.63) $ 36,530.37 $ (3,619.63) $ 41,196.70 $ 9,212.78 $ 49,362.78 $ 8,379.37 $ 52,862.53 $ 23,678.42 $ 74,327.67 $ 68,494.75 $ 68,494.75
12
TOTAL PROFIT $ (11,125.00) $ (22,125.00) $ (33,125.00) $ (44,125.00) $ (55,125.00) $ (66,125.00) $ (75,625.00) $ (90,143.90) $ (97,394.09) $ (109,663.18) $ (116,913.36) $ (124,163.55) $ (128,943.86) $ (133,694.18) $ (142,713.45) $ (146,713.83) $ (189,364.20) $ (182,660.13) $ (178,753.33) $ (174,941.57) $ (170,177.38) $ (166,613.10) $ (161,298.75) $ (155,324.45) $ (194,797.90) $ (191,162.85) $ (186,320.75) $ (182,407.15) $ (175,986.60) $ (169,566.05) $ (167,373.90) $ (161,324.75) $ (146,454.85) $ (131,584.95) $ (116,715.05) $ (107,230.45) $ (139,925.85) $ (130,441.25) $ (120,492.40) $ (109,615.05) $ (92,702.45) $ (73,932.85) $ (99,634.50) $ (80,864.90) $ (47,796.40) $ (12,870.90) $ 22,054.60 $ 50,109.20 $ 44,459.56 $ 80,989.93 $ 77,370.30 $ 118,567.00 $ 127,779.78 $ 177,142.56 $ 185,521.93 $ 238,384.46 $ 262,062.88 $ 336,390.55 $ 404,885.30 $ 473,380.05
13
14
SALES/PROFIT (YEARLY)
PROFIT SUMMATION (YEARLY)
INVENTORY (YEARLY)
15
Quantity SoldProfitTotal CostRevenueProfitProfit MarginBeginningPurchased# SoldEnding
16
Year 175 $ (124,163.55)Year 1 $ 139,162.80 $ 14,999.25 $ (124,163.55)-828%
*Becoming MORE profitable over time.
Year 1020075125
17
Year 2700 $ (31,160.90)Year 2 $ 171,228.90 $ 140,068.00 $ (31,160.90)-22%
Due to increasing profit margins
Year 21251100700525
18
Year 31171 $ 48,094.00 Year 3 $ 186,180.00 $ 234,274.00 $ 48,094.00 21%Year 352510001171353
19
Year 42321 $ 157,339.65 Year 4 $ 306,780.00 $ 464,119.65 $ 157,339.65 34%Year 43532000232132
20
Year 54915 $ 423,270.85 Year 5 $ 559,680.00 $ 982,950.85 $ 423,270.85 43%
*Year 6 will scale when purchasing in quantities of 10000
Year 53250004915117
21
TOTAL9183 $ 473,380.05 TOTAL $ 1,363,031.70 $ 1,836,411.75 $ 473,380.05 26%TOTAL93009183
22
23
SUMMATION OF CHANGES
24
Summary of Changes V2
25
Sales are now calculated based on the predicted Customer Acquisition Cost
26
Sources in the form of links are now added to show where our data is coming from
27
Detailing on the Marketing sheet about why there are certain expenditures
28
Detailing and sources added on the Operating Costs sheet about app dev costs
29
Added chart on the Sales sheet in order to show growth over time
30
31
Summary of Changes V4
32
Added the Valuation Tab on the sheet
33
Calculated the breakeven point and added a chart
34
Created a table on the Summary tab summarizing the total costs, revenues, and profits annually
35
36
Summary of Changes V5
37
Edited to make profitability increase over time
38
Added CAC on the Sales Tab to edit as we scale over time
39
Added wages on the Operating Costs Tab
40
Added profit margin column on the Summary Tab to easily analyze return
41
Modified the marketing costs
42
43
Summary of Changes V7
44
Added inventory section on Product Costs Tab
45
Added inventory section on the Summary Tab
46
Added Summary Cost-Rev Chart Tab to display costs and revenues more easily
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