Swish CashFlow Draft
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
View only
 
 
ABCDEFGHIJKLMNOPQRSTUVWXY
1
2
By Year EndYear 1Year 2Year 3Year 4Year 5Year 6Year 7Year 8Year 9Year 10
3
*** Prices and tariffs set***
4
*** ASSUMPTIONS ***
5
REVENUESYear 1Year 2Year 3Year 4Year 5Year 6Year 7Year 8Year 9Year 10
6
Number of new venues connected 2,2793,4195,1287,69211,53912,69213,96215,35816,89418,583
7
Growth rate-50%50%50%50%10%10%10%10%10%
8
Effective number of venues working throughout the year1,1403,9898,26214,67324,28836,40449,73164,39080,51698,254
9
INCOME SOURCE 1 (FLAT ORDERING FEES)
10
Number of paid orders per day per venue66707377808080808080
11
Annual growth rate of number of orders per day (venues get used to Swish technology)
-5%5%5%5%0%0%0%0%0%
12
Mycelium Swish fee per food or drink order (see "Pricing Scheme..." folder for details)
$0.0205$0.0277$0.0374$0.0504$0.0681$0.0681$0.0681$0.0681$0.0681$0.0681
13
Fee per order growth rate (annual)-35.00%35%35%35%0.00%0%0%0%0%
14
Average order fee based annual earnings per venue (250 active days per year)
$339$481$682$966$1,370$1,370$1,370$1,370$1,370$1,370
15
Gross annual earnings on order fees$386,593$1,917,984$5,631,682$14,176,545$33,264,471$49,857,687$68,110,224$88,188,015$110,273,584$134,567,711
16
INCOME SOURCE 2 (LOYALTY FUNCTIONALITY % FEES)
17
Share of venues using Swish customer loyalty functionality25%26%28%29%30%36%44%53%63%76%
18
Growth rate of loyalty functionality adoption-5%5%5%5%20%20%20%20%20%
19
Loyalty functionality effective fee per order (see "Pricing.." folder for details)$0.08835$0.08835$0.08835$0.08835$0.08835$0.08835$0.08835$0.08835$0.08835$0.08835
20
Annual loyalty fees per venue (250 active days)$366$403$444$490$540$648$778$933$1,120$1,344
21
Gross annual earnings on loyalty programs$416,644$1,607,726$3,671,645$7,188,670$13,119,409$23,596,469$38,681,959$60,101,728$90,184,133$132,062,877
22
23
Ordering fees contribution48%54%61%66%72%68%64%59%55%50%
24
Loyalty fees contribution52%46%39%34%28%32%36%41%45%50%
25
Total inflows$803,237$3,525,711$9,303,327$21,365,214$46,383,880$73,454,156$106,792,182$148,289,743$200,457,717$266,630,588
26
27
COSTSYear 1Year 2Year 3Year 4Year 5Year 6Year 7Year 8Year 9Year 10
28
Manpower class A annual compensation, gross$200,000
29
Manpower class B annual compensation, gross$100,000
30
Manpower class C annual compensation, gross$50,000
31
Social taxes and benefits rate35%
32
Office, equipment, communication, business trips per class A person$100,000
33
Office, equipment, communication, business trips per class B$50,000
34
Office, equipment, communication, business trips per class C$25,000
35
Year 1Year 2Year 3Year 4Year 5Year 6Year 7Year 8Year 9Year 10
36
SALES COSTS
37
Direct (sales agents team) acquisition costs (per venue)$126$120$114$108$103$98$93$88$84$80
38
Acquisition costs decline rate: branding and awareness will ease the process
-5%-5.00%-5.00%-5.00%-5.00%-5.00%-5.00%-5.00%-5.00%
39
Annual direct acquisition expenses$287,766$410,066$584,344$832,691$1,186,584$1,239,980$1,295,779$1,354,089$1,415,023$1,478,700
40
Manpower B1111111111
41
Manpower C2222222222
42
Manpower costs$270,000$270,000$270,000$270,000$270,000$270,000$270,000$270,000$270,000$270,000
43
Office, equipment, communication, business trips$100,000$100,000$100,000$100,000$100,000$100,000$100,000$100,000$100,000$100,000
44
Total sales costs$657,766$780,066$954,344$1,202,691$1,556,584$1,609,980$1,665,779$1,724,089$1,785,023$1,848,700
45
MARKETING COSTS
46
Media buying as % of revenues10%9%8%7%7%6%5%5%4%4%
47
Media costs$80,324$317,314$753,569$1,557,524$3,043,246$4,337,394$5,675,374$7,092,652$8,629,047$10,329,815
48
Content creation$100,000$100,000$100,000$100,000$100,000$100,000$100,000$100,000$100,000$100,000
49
Trade shows$50,000$50,000$50,000$50,000$50,000$50,000$50,000$50,000$50,000$50,000
50
Manpower A2222222222
51
Manpower B1111111111
52
Manpower C2222222222
53
Manpower costs$810,000$810,000$810,000$810,000$810,000$810,000$810,000$810,000$810,000$810,000
54
Office, equipment, communication, business trips$300,000$300,000$300,000$300,000$300,000$300,000$300,000$300,000$300,000$300,000
55
Total marketing costs$1,340,324$1,577,314$2,013,569$2,817,524$4,303,246$5,597,394$6,935,374$8,352,652$9,889,047$11,589,815
56
PRODUCT SUPPORT COSTS
57
Manpower C3333333333
58
Manpower costs$202,500$202,500$202,500$202,500$202,500$202,500$202,500$202,500$202,500$202,500
59
Office, equipment, communication, business trips$75,000$75,000$75,000$75,000$75,000$75,000$75,000$75,000$75,000$75,000
60
Fixed costs outsourced services$20,000$20,000$20,000$20,000$20,000$20,000$20,000$20,000$20,000$20,000
61
Variable costs of outsourced services, depending on number of operating venues
60.00
62
Variable costs$68,377$239,319$495,732$880,351$1,457,281$2,184,212$2,983,836$3,863,422$4,830,967$5,895,267
63
Total product support costs$365,877$536,819$793,232$1,177,851$1,754,781$2,481,712$3,281,336$4,160,922$5,128,467$6,192,767
64
ADMINISTRATION
65
Manpower A1111111111
66
Manpower B2222222222
67
Manpower C2222222222
68
Manpower costs$675,000$675,000$675,000$675,000$675,000$675,000$675,000$675,000$675,000$675,000
69
Office, equipment, communication, business trips$250,000$250,000$250,000$250,000$250,000$250,000$250,000$250,000$250,000$250,000
70
Outsourcing $300,000$300,000$300,000$300,000$300,000$300,000$300,000$300,000$300,000$300,000
71
Total administration costs$1,225,000$1,225,000$1,225,000$1,225,000$1,225,000$1,225,000$1,225,000$1,225,000$1,225,000$1,225,000
72
DEVELOPMENT
73
Manpower A2222222222
74
Manpower B5555555555
75
Manpower C8888888888
76
Manpower costs$1,755,000$1,755,000$1,755,000$1,755,000$1,755,000$1,755,000$1,755,000$1,755,000$1,755,000$1,755,000
77
Office, equipment, communication, business trips$650,000$650,000$650,000$650,000$650,000$650,000$650,000$650,000$650,000$650,000
78
Total development costs$2,405,000$2,405,000$2,405,000$2,405,000$2,405,000$2,405,000$2,405,000$2,405,000$2,405,000$2,405,000
79
Year 1Year 2Year 3Year 4Year 5Year 6Year 7Year 8Year 9Year 10
80
Sales and marketing contribution to costs33%36%40%46%52%54%55%56%57%58%
81
Administration and product support contribution to costs27%27%27%27%26%28%29%30%31%32%
82
Development contribution to costs40%37%33%27%21%18%16%13%12%10%
83
Total costs$5,993,966$6,524,199$7,391,146$8,828,066$11,244,611$13,319,086$15,512,489$17,867,664$20,432,538$23,261,282
84
Costs as % of inflows746.23%185.05%79.45%41.32%24.24%18.13%14.53%12.05%10.19%8.72%
85
Year 1Year 2Year 3Year 4Year 5Year 6Year 7Year 8Year 9Year 10
86
Net cash flows, millions of USD-$5.2-$3.0$1.9$12.5$35.1$60.1$91.3$130.4$180.0$243.4
87
Net cash flows-$5,190,729-$2,998,488$1,912,181$12,537,148$35,139,269$60,135,070$91,279,693$130,422,079$180,025,179$243,369,307
88
After taxes, interest, amortization, depreciation (minus 40%)
-$5,190,729-$2,998,488$1,147,309$7,522,289$21,083,561$36,081,042$54,767,816$78,253,247$108,015,107$146,021,584
89
90
VALUATION & FUNDING
91
Earnings based valuation multiplier28.00
92
Project valuation$0$0$28,682,718$210,624,092$590,339,721$1,010,269,168$1,533,498,839$2,191,090,923$3,024,423,008$4,088,604,351
93
Year number12345678910
94
Hurdle rate20%
95
NPV-$4,325,607-$2,082,283$663,952$3,627,647$8,473,010$12,083,468$15,284,692$18,199,204$20,934,051$23,583,301
96
NPV for 10 years$96,441,435
97
Negative NPV years-$4,325,607-$2,082,283$0$0$0$0$0$0$0$0
98
Sum of all negative NPV years (needed funding amount)$6,407,891
99
100
Loading...
 
 
 
Cash Flow
Personnel plan
Pricing & table turns scheme
Sales team & acquisition costs
Valuation benchmarks
 
 
Main menu