ABCDEFGHIJKLMNOPQRSTUVWXYZAAABACADAEAFAGAHAIAJAKALAMANAOAPAQ
1
事業シミュレーション_サンプル ソキチサイト
2
基本数値1期目2期目
3
単価費用2020年1月2020年2月2020年3月2020年4月2020年5月2020年6月2020年7月2020年8月2020年9月2020年10月2020年11月2020年12月2021年1月2021年2月2021年3月2021年4月2021年5月2021年6月2021年7月2021年8月2021年9月2021年10月2021年11月2021年12月
4
■月額型Webサービス 売上
5
電波関連広告・流入数
7,143 7,143 7,143 7,143 7,143 7,143 7,143 7,143 7,143 7,143 7,143 7,143 7,143 7,143 7,143 7,143 7,143 7,143 7,143 7,143 7,143 7,143 7,143 7,143
6
紙面関連広告・流入数
8,333 8,333 8,333 8,333 8,333 8,333 8,333 8,333 8,333 8,333 8,333 8,333 8,333 8,333 8,333 8,333 8,333 8,333 8,333 8,333 8,333 8,333 8,333 8,333
7
Web関連広告・流入数
10,000 10,000 10,000 10,000 10,000 10,000 10,000 10,000 10,000 10,000 10,000 10,000 10,000 10,000 10,000 10,000 10,000 10,000 10,000 10,000 10,000 10,000 10,000 10,000
8
流入数合計25,476 25,476 25,476 25,476 25,476 25,476 25,476 25,476 25,476 25,476 25,476 25,476 25,476 25,476 25,476 25,476 25,476 25,476 25,476 25,476 25,476 25,476 25,476 25,476
9
▼無料登録
10
登録率45%45%45%45%45%45%45%45%45%45%45%45%45%45%45%45%45%45%45%45%45%45%45%45%45%
11
登録者数/月11,464 11,464 11,464 11,464 11,464 11,464 11,464 11,464 11,464 11,464 11,464 11,464 11,464 11,464 11,464 11,464 11,464 11,464 11,464 11,464 11,464 11,464 11,464 11,464
12
離脱率3%3%3%3%3%3%3%3%3%3%3%3%3%3%3%3%3%3%3%3%3%3%3%3%3%
13
離脱数(前月までの累計購入者数×離脱率)
344 678 1,001 1,315 1,620 1,915 2,201 2,479 2,749 3,010 3,264 3,510 3,749 3,980 4,205 4,422 4,634 4,838 5,037 5,230 5,417 5,599 5,774
14
登録者数(累計)11,464 22,585 33,371 43,835 53,984 63,829 73,378 82,641 91,626 100,341 108,796 116,996 124,950 132,666 140,150 147,410 154,452 161,283 167,909 174,336 180,570 186,617 192,483 198,173
15
▼月額サービス
16
非購入者数(累計)11,464 21,209 29,492 36,532 42,517 47,604 51,927 55,603 58,726 61,382 63,639 65,557 67,188 68,574 69,752 70,754 71,605 72,328 72,943 73,466 73,911 74,288 74,609 74,882
17
購入率15%15%15%15%15%15%15%15%15%15%15%15%15%15%15%15%15%15%15%15%15%15%15%15%15%
18
購入者数(月額)1,720 3,181 4,424 5,480 6,378 7,141 7,789 8,340 8,809 9,207 9,546 9,834 10,078 10,286 10,463 10,613 10,741 10,849 10,942 11,020 11,087 11,143 11,191 11,232
19
離脱率5%5%5%5%5%5%5%5%5%5%5%5%5%5%5%5%5%5%5%5%5%5%5%5%5%
20
離脱数(前月までの累計購入者数×離脱率)
86 241 450 701 985 1,293 1,618 1,954 2,297 2,642 2,987 3,330 3,667 3,998 4,321 4,636 4,941 5,237 5,522 5,797 6,061 6,315 6,559
21
購入者数(累計)1,720 4,815 8,998 14,028 19,704 25,859 32,356 39,078 45,933 52,844 59,747 66,594 73,342 79,961 86,426 92,718 98,823 104,731 110,436 115,934 121,224 126,306 131,182 135,855
22
23
客単価¥1,500¥1,500¥1,500¥1,500¥1,500¥1,500¥1,500¥1,500¥1,500¥1,500¥1,500¥1,500¥1,500¥1,500¥1,500¥1,500¥1,500¥1,500¥1,500¥1,500¥1,500¥1,500¥1,500¥1,500¥1,500
24
25
売上¥2,579,464¥7,222,500¥13,497,047¥21,041,980¥29,556,163¥38,789,159¥48,533,348¥58,617,245¥68,899,827¥79,265,728¥89,621,164¥99,890,484¥110,013,246¥119,941,741¥129,638,902¥139,076,532¥148,233,808¥157,096,020¥165,653,500¥173,900,728¥181,835,573¥189,458,659¥196,772,824¥203,782,681
26
売上累計¥2,579,464¥9,801,964¥23,299,011¥44,340,991¥73,897,154¥112,686,312¥161,219,660¥219,836,906¥288,736,733¥368,002,461¥457,623,626¥557,514,110¥667,527,356¥787,469,097¥917,107,998¥1,056,184,530¥1,204,418,339¥1,361,514,358¥1,527,167,858¥1,701,068,586¥1,882,904,159¥2,072,362,818¥2,269,135,642¥2,472,918,323
27
■月額型Webサービス コスト
28
リニューアル費用¥30,000,000¥30,000,000¥5,000,000¥5,000,000¥30,000,000
29
サーバー
回線費
¥10¥114,643¥225,846¥333,714¥438,345¥539,838¥638,286¥733,780¥826,409¥916,260¥1,003,415¥1,087,955¥1,169,960¥1,249,504¥1,326,661¥1,401,504¥1,474,102¥1,544,522¥1,612,829¥1,679,087¥1,743,357¥1,805,699¥1,866,171¥1,924,829¥1,981,727
30
初期開発費(2年償却)
¥110,000,000¥4,583,333¥4,583,333¥4,583,333¥4,583,333¥4,583,333¥4,583,333¥4,583,333¥4,583,333¥4,583,333¥4,583,333¥4,583,333¥4,583,333¥4,583,333¥4,583,333¥4,583,333¥4,583,333¥4,583,333¥4,583,333¥4,583,333¥4,583,333¥4,583,333¥4,583,333¥4,583,333¥4,583,333
31
開発費合計¥4,583,333¥9,166,667¥13,750,000¥18,333,333¥22,916,667¥27,500,000¥32,083,333¥36,666,667¥41,250,000¥45,833,333¥50,416,667¥55,000,000¥59,583,333¥64,166,667¥68,750,000¥73,333,333¥77,916,667¥82,500,000¥87,083,333¥91,666,667¥96,250,000¥100,833,333¥105,416,667¥110,000,000
32
33
システム
技術者
¥5,000,000¥5,000,000¥5,000,000¥5,000,000¥5,000,000¥5,000,000¥5,000,000¥5,000,000¥5,000,000¥5,000,000¥5,000,000¥5,000,000¥5,000,000¥5,000,000¥5,000,000¥5,000,000¥5,000,000¥5,000,000¥5,000,000¥5,000,000¥5,000,000¥5,000,000¥5,000,000¥5,000,000¥5,000,000
34
運営者¥4,000,000¥4,000,000¥4,000,000¥4,000,000¥4,000,000¥4,000,000¥4,000,000¥4,000,000¥4,000,000¥4,000,000¥4,000,000¥4,000,000¥4,000,000¥4,000,000¥4,000,000¥4,000,000¥4,000,000¥4,000,000¥4,000,000¥4,000,000¥4,000,000¥4,000,000¥4,000,000¥4,000,000¥4,000,000
35
運用費合計¥9,000,000¥9,000,000¥9,000,000¥9,000,000¥9,000,000¥9,000,000¥9,000,000¥9,000,000¥9,000,000¥9,000,000¥9,000,000¥9,000,000¥9,000,000¥9,000,000¥9,000,000¥9,000,000¥9,000,000¥9,000,000¥9,000,000¥9,000,000¥9,000,000¥9,000,000¥9,000,000¥9,000,000
36
製品原価¥13,583,333¥18,166,667¥22,750,000¥27,333,333¥31,916,667¥36,500,000¥41,083,333¥45,666,667¥50,250,000¥54,833,333¥59,416,667¥64,000,000¥68,583,333¥73,166,667¥77,750,000¥82,333,333¥86,916,667¥91,500,000¥96,083,333¥100,666,667¥105,250,000¥109,833,333¥114,416,667¥119,000,000
37
38
39
協業会社 (対売上)
5%¥128,973¥361,125¥674,852¥1,052,099¥1,477,808¥1,939,458¥2,426,667¥2,930,862¥3,444,991¥3,963,286¥4,481,058¥4,994,524.21¥5,500,662.30¥5,997,087.05¥6,481,945.09¥6,953,826.59¥7,411,690.42¥7,854,800.99¥8,282,674.99¥8,695,036.39¥9,091,778.67¥9,472,932.93¥9,838,641.21¥10,189,134.05
40
ロイヤリティ¥128,973¥361,125¥674,852¥1,052,099¥1,477,808¥1,939,458¥2,426,667¥2,930,862¥3,444,991¥3,963,286¥4,481,058¥4,994,524¥5,500,662¥5,997,087¥6,481,945¥6,953,827¥7,411,690¥7,854,801¥8,282,675¥8,695,036¥9,091,779¥9,472,933¥9,838,641¥10,189,134
41
42
電波系広告の流入単価
¥140¥140¥140¥140¥140¥140¥140¥140¥140¥140¥140¥140¥140¥140¥140¥140¥140¥140¥140¥140¥140¥140¥140¥140¥140
43
電波系広告費¥1,000,000¥1,000,000¥1,000,000¥1,000,000¥1,000,000¥1,000,000¥1,000,000¥1,000,000¥1,000,000¥1,000,000¥1,000,000¥1,000,000¥1,000,000¥1,000,000¥1,000,000¥1,000,000¥1,000,000¥1,000,000¥1,000,000¥1,000,000¥1,000,000¥1,000,000¥1,000,000¥1,000,000¥1,000,000
44
紙面系広告の流入単価
¥120¥120¥120¥120¥120¥120¥120¥120¥120¥120¥120¥120¥120¥120¥120¥120¥120¥120¥120¥120¥120¥120¥120¥120¥120
45
紙面系広告費¥1,000,000¥1,000,000¥1,000,000¥1,000,000¥1,000,000¥1,000,000¥1,000,000¥1,000,000¥1,000,000¥1,000,000¥1,000,000¥1,000,000¥1,000,000¥1,000,000¥1,000,000¥1,000,000¥1,000,000¥1,000,000¥1,000,000¥1,000,000¥1,000,000¥1,000,000¥1,000,000¥1,000,000¥1,000,000
46
Web系広告の流入単価
¥100¥100¥100¥100¥100¥100¥100¥100¥100¥100¥100¥100¥100¥100¥100¥100¥100¥100¥100¥100¥100¥100¥100¥100¥100
47
Web系広告費¥1,000,000¥1,000,000¥1,000,000¥1,000,000¥1,000,000¥1,000,000¥1,000,000¥1,000,000¥1,000,000¥1,000,000¥1,000,000¥1,000,000¥1,000,000¥1,000,000¥1,000,000¥1,000,000¥1,000,000¥1,000,000¥1,000,000¥1,000,000¥1,000,000¥1,000,000¥1,000,000¥1,000,000¥1,000,000
48
プロモーション費合計
¥3,000,220¥3,000,220¥3,000,220¥3,000,220¥3,000,220¥3,000,220¥3,000,220¥3,000,220¥3,000,220¥3,000,220¥3,000,220¥3,000,220¥3,000,220¥3,000,220¥3,000,220¥3,000,220¥3,000,220¥3,000,220¥3,000,220¥3,000,220¥3,000,220¥3,000,220¥3,000,220¥3,000,220
49
販管費¥3,129,193¥3,361,345¥3,675,072¥4,052,319¥4,478,028¥4,939,678¥5,426,887¥5,931,082¥6,445,211¥6,963,506¥7,481,278¥7,994,744¥8,500,882¥8,997,307¥9,482,165¥9,954,047¥10,411,910¥10,855,021¥11,282,895¥11,695,256¥12,091,999¥12,473,153¥12,838,861¥13,189,354
50
51
コスト合計¥16,712,527¥21,528,012¥26,425,072¥31,385,652¥36,394,695¥41,439,678¥46,510,221¥51,597,749¥56,695,211¥61,796,840¥66,897,945¥71,994,744¥77,084,216¥82,163,974¥87,232,165¥92,287,380¥97,328,577¥102,355,021¥107,366,228¥112,361,923¥117,341,999¥122,306,486¥127,255,528¥132,189,354
52
コスト累計¥16,712,527¥38,240,538¥64,665,611¥96,051,263¥132,445,958¥173,885,636¥220,395,856¥271,993,605¥328,688,817¥390,485,656¥457,383,601¥529,378,345¥606,462,561¥688,626,535¥775,858,700¥868,146,080¥965,474,657¥1,067,829,678¥1,175,195,906¥1,287,557,829¥1,404,899,828¥1,527,206,314¥1,654,461,842¥1,786,651,196
53
54
営業利益¥-14,133,062¥-14,305,512¥-12,928,025¥-10,343,672¥-6,838,532¥-2,650,519¥2,023,127¥7,019,497¥12,204,616¥17,468,888¥22,723,219¥27,895,740¥32,929,030¥37,777,767¥42,406,737¥46,789,152¥50,905,231¥54,740,999¥58,287,271¥61,538,805¥64,493,575¥67,152,172¥69,517,296¥71,593,327
55
営業利益率-85%-66%-49%-33%-19%-6%4%14%22%28%34%39%43%46%49%51%52%53%54%55%55%55%55%54%
56
累計損益¥-14,133,062¥-28,438,574¥-41,366,599¥-51,710,272¥-58,548,804¥-61,199,323¥-59,176,196¥-52,156,699¥-39,952,083¥-22,483,195¥240,024¥28,135,764¥61,064,795¥98,842,562¥141,249,299¥188,038,450¥238,943,682¥293,684,681¥351,971,952¥413,510,757¥478,004,331¥545,156,504¥614,673,800¥686,267,127
57
Copyright © 2019 SokichiSaito All Rights Reserved.
58
Copyright © 2019 SokichiSaito All Rights Reserved.
59
https://sokichisaito.work/
60
61
62
63
Copyright © 2019 SokichiSaito All Rights Reserved.
64
https://sokichisaito.work/
65
https://sokichisaito.work/
Copyright © 2019 SokichiSaito All Rights Reserved.
Copyright © 2019 SokichiSaito All Rights Reserved.
66
https://sokichisaito.work/
67
68
69
70
71
Copyright © 2019 SokichiSaito All Rights Reserved.
72
https://sokichisaito.work/
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