ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
2
Newsletter business model
3
4
Notes:
5
1. This models a 5 year newsletter business that started from scratch (10 subscribers)
6
2. Summary tab shows yearly metrics and estimated valuation
7
3. Model tab breaks the business revenue and costs down by month. Cost assumptions were simplified. Adjust the case in cell C5
8
4. Assumptions tab provides justification for assumptions made
9
5. Model shows 2 cases and can be configured to add more - add a row for the case under each metric, and the new case under the case toggle in the area around cell B5
10
6. The 2 cases modeled are a newsletter that monetises paid subs early at expense of growth, and a newsletter that monetises paid subs late at expense of early profitability
11
7. You can use this for your own newsletter by making a copy (File, make a copy)
12
8. If this was helpful and you want to give me credit, my twitter is @Leonlinsx and newsletter is https://avoidboringpeople.substack.com/
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
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