Finanzen 2016-2020 leer
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
View only
 
 
ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Costs and revenue of a community-based publisher for 5 years
2
Instructions: fill in all white cells below with sensible values following your best guesses.
Do not touch the grey cells.
The current values of the white cells are not realistic. Do not assume they are.
3
Assumptions12345
4
Series5791113
5
New books per series per year11111
6
Total books this year5791113
7
8
9
Basis of calculationYearScientistClerkAssistant
10
Total annual cost of employee165,920.00 €56,920.00 €6,500.00 €
11
267,897.60 €58,627.60 €6,695.00 €
12
369,934.53 €60,386.43 €6,895.85 €
13
472,032.56 €62,198.02 €7,102.73 €
14
574,193.54 €64,063.96 €7,315.81 €
15
avg days worked/yearall years20020050
16
hourly wage141.20 €35.58 €16.25 €
17
242.44 €36.64 €16.74 €
18
343.71 €37.74 €17.24 €
19
445.02 €38.87 €17.76 €
20
546.37 €40.04 €18.29 €
21
daily wage1329.60 €284.60 €130.00 €
22
2339.49 €293.14 €133.90 €
23
3349.67 €301.93 €137.92 €
24
4360.16 €310.99 €142.05 €
25
5370.97 €320.32 €146.32 €
26
Projected increase in wages3.00%3.00%3.00%
27
28
29
RevenueBase Y1Base Y2Base Y3Base Y4Base Y5
30
Print sales5,000.00 €7,000.00 €9,000.00 €11,000.00 €13,000.00 €12.35%
31
Sold copies per new book100100100100100
32
Margin10.00 €10.00 €10.00 €10.00 €10.00 €
33
Book processing charges13,125.00 €18,375.00 €23,625.00 €28,875.00 €34,125.00 €32.42%
34
Nominal BPCs per book3,500.00 €3,500.00 €3,500.00 €3,500.00 €3,500.00 €
35
Books which pay BPCs (not waived)75%75%75%75%75%
36
Institutional members (IM)17,500.00 €24,500.00 €31,500.00 €38,500.00 €45,500.00 €43.22%
37
avg membership fee3,500.00 €3,500.00 €3,500.00 €3,500.00 €3,500.00 €
38
new IMs per new series11111
39
new IMs per series this year52222
40
total IMs5791113
41
Individual members10,140.00 €10,350.00 €10,620.00 €10,950.00 €11,340.00 €10.77%
42
Supporters999999999999999
43
Conversion supporters->members0.330.330.330.330.33
44
New members per book11111
45
New members this year338791113
46
Total members338345354365378
47
Average membership fee30.00 €30.00 €30.00 €30.00 €30.00 €
48
Donations500.00 €700.00 €900.00 €1,100.00 €1,300.00 €1.23%
49
Downloads per book10001000100010001000
50
Conversion download->donation1.00%1.00%1.00%1.00%1.00%
51
Average donation10.00 €10.00 €10.00 €10.00 €10.00 €
52
Donors507090110130
53
46,265.00 €60,925.00 €75,645.00 €90,425.00 €105,265.00 €100.00%
54
55
56
CostsBasis PersonnelBasis Stunden / EinheitBasis
days / Y1
Basis
days / Y2
Basis
days / Y3
Basis
days / Y4
Basis
days / Y5
Basis
€ / month
Basis
€ / year
Costs Y1Costs Y2Costs Y3Costs Y4Costs Y5Forward projection
57
Variable costs6,026.39 €4,393.50 €5,139.62 €5,941.01 €6,800.75 €
58
Finalization print; marketing (per book)Scientist1.00 h0.63 Tage0.88 Tage1.13 Tage1.38 Tage1.63 Tage206.00 €297.05 €393.38 €495.22 €602.82 €
59
Upload PoD (per book)Assistant1.00 h0.63 Tage0.88 Tage1.13 Tage1.38 Tage1.63 Tage81.25 €117.16 €155.16 €195.32 €237.76 €
60
Coordination PoD service providers (per year)Scientist1.00 h0.13 Tage0.13 Tage0.13 Tage0.13 Tage0.13 Tage41.20 €42.44 €43.71 €45.02 €46.37 €
61
Coordination University library (year)Scientist1.00 h0.13 Tage0.13 Tage0.13 Tage0.13 Tage0.13 Tage41.20 €42.44 €43.71 €45.02 €46.37 €
62
Author support (per book)Scientist1.00 h0.63 Tage0.88 Tage1.13 Tage1.38 Tage1.63 Tage206.00 €297.05 €393.38 €495.22 €602.82 €
63
Series editor support (per series and year)Scientist1.00 h0.63 Tage0.88 Tage1.13 Tage1.38 Tage1.63 Tage206.00 €297.05 €393.38 €495.22 €602.82 €
64
Acquisition of a new institutional member (events, networking)Scientist1.00 h0.63 Tage0.25 Tage0.25 Tage0.25 Tage0.25 Tage206.00 €84.87 €87.42 €90.04 €92.74 €
65
Liaising institutional member (per year)Scientist1.00 h0.63 Tage0.88 Tage1.13 Tage1.38 Tage1.63 Tage206.00 €297.05 €393.38 €495.22 €602.82 €
66
institutional member admin (per year)Clerk1.00 h0.63 Tage0.88 Tage1.13 Tage1.38 Tage1.63 Tage177.88 €256.50 €339.67 €427.61 €520.52 €
67
Acquistionof new individual memberScientist0.02 h0.70 Tage0.01 Tage0.02 Tage0.02 Tage0.03 Tage232.09 €4.95 €6.56 €8.25 €10.05 €
68
Admin new individual memberClerk0.17 h7.04 Tage0.15 Tage0.19 Tage0.23 Tage0.27 Tage2,004.06 €42.75 €56.61 €71.27 €86.75 €
69
Support individual member (per year)Scientist0.02 h0.70 Tage0.72 Tage0.74 Tage0.76 Tage0.79 Tage232.09 €244.01 €257.88 €273.87 €292.14 €
70
Admin individual member (per year)Clerk0.17 h7.04 Tage7.19 Tage7.38 Tage7.60 Tage7.88 Tage2,004.06 €2,106.93 €2,226.75 €2,364.82 €2,522.52 €
71
Support donors (per donor)Scientist0.02 h0.10 Tage0.15 Tage0.19 Tage0.23 Tage0.27 Tage34.33 €49.51 €65.56 €82.54 €100.47 €
72
Admin donors (per donor)Clerk0.08 h0.52 Tage0.73 Tage0.94 Tage1.15 Tage1.35 Tage148.23 €213.75 €283.06 €356.34 €433.77 €
73
Fix personnel costs45,244.00 €46,601.32 €47,999.36 €49,439.34 €50,922.52 €
74
Team coordinationScientist10.00 Tage10.00 Tage10.00 Tage10.00 Tage10.00 Tage3,296.00 €3,394.88 €3,496.73 €3,601.63 €3,709.68 €
75
Liasing with administration at home institutionScientist10.00 Tage10.00 Tage10.00 Tage10.00 Tage10.00 Tage3,296.00 €3,394.88 €3,496.73 €3,601.63 €3,709.68 €
76
IT coordination and direction for service providersScientist10.00 Tage10.00 Tage10.00 Tage10.00 Tage10.00 Tage3,296.00 €3,394.88 €3,496.73 €3,601.63 €3,709.68 €
77
Coordination with advisory boardScientist10.00 Tage10.00 Tage10.00 Tage10.00 Tage10.00 Tage3,296.00 €3,394.88 €3,496.73 €3,601.63 €3,709.68 €
78
Coordination PRScientist10.00 Tage10.00 Tage10.00 Tage10.00 Tage10.00 Tage3,296.00 €3,394.88 €3,496.73 €3,601.63 €3,709.68 €
79
PRScientist10.00 Tage10.00 Tage10.00 Tage10.00 Tage10.00 Tage3,296.00 €3,394.88 €3,496.73 €3,601.63 €3,709.68 €
80
Events & conferencesScientist10.00 Tage10.00 Tage10.00 Tage10.00 Tage10.00 Tage3,296.00 €3,394.88 €3,496.73 €3,601.63 €3,709.68 €
81
Presentations & networkingScientist10.00 Tage10.00 Tage10.00 Tage10.00 Tage10.00 Tage3,296.00 €3,394.88 €3,496.73 €3,601.63 €3,709.68 €
82
Managerial accountingScientist10.00 Tage10.00 Tage10.00 Tage10.00 Tage10.00 Tage3,296.00 €3,394.88 €3,496.73 €3,601.63 €3,709.68 €
83
Financial planningScientist10.00 Tage10.00 Tage10.00 Tage10.00 Tage10.00 Tage3,296.00 €3,394.88 €3,496.73 €3,601.63 €3,709.68 €
84
BookkeepingClerk10.00 Tage10.00 Tage10.00 Tage10.00 Tage10.00 Tage2,846.00 €2,931.38 €3,019.32 €3,109.90 €3,203.20 €
85
Grant proposalsScientist10.00 Tage10.00 Tage10.00 Tage10.00 Tage10.00 Tage3,296.00 €3,394.88 €3,496.73 €3,601.63 €3,709.68 €
86
General adminClerk10.00 Tage10.00 Tage10.00 Tage10.00 Tage10.00 Tage2,846.00 €2,931.38 €3,019.32 €3,109.90 €3,203.20 €
87
Manuals and guidelinesScientist10.00 Tage10.00 Tage10.00 Tage10.00 Tage10.00 Tage3,296.00 €3,394.88 €3,496.73 €3,601.63 €3,709.68 €
88
89
Fix non-personnel costs43,410.77 €44,676.17 €45,979.53 €47,321.99 €48,704.73 €
90
Rent1,000.00 €12,000.00 €12,360.00 €12,730.80 €13,112.72 €13,506.11 €3.00%
91
Stationary and telco100.00 €1,200.00 €1,236.00 €1,273.08 €1,311.27 €1,350.61 €3.00%
92
Bookkeeping and annual closure120.00 €600.00 €2,040.00 €2,101.20 €2,164.24 €2,229.16 €2,296.04 €3.00%
93
Travel10,000.00 €10,000.00 €10,300.00 €10,609.00 €10,927.27 €11,255.09 €3.00%
94
Legal costs2,000.00 €2,000.00 €2,060.00 €2,121.80 €2,185.45 €2,251.02 €3.00%
95
Insurance500.00 €500.00 €515.00 €530.45 €546.36 €562.75 €3.00%
96
Design and marketing3,000.00 €3,000.00 €3,090.00 €3,182.70 €3,278.18 €3,376.53 €3.00%
97
IT infrastructure10,000.00 €10,000.00 €10,300.00 €10,609.00 €10,927.27 €11,255.09 €3.00%
98
Hosting120.00 €1,440.00 €1,483.20 €1,527.70 €1,573.53 €1,620.73 €3.00%
99
Depreciation of investment1,230.77 €1,230.77 €1,230.77 €1,230.77 €1,230.77 €1,230.77 €
100
Sum94,681.16 €95,670.99 €99,118.51 €102,702.34 €106,428.00 €
Loading...
 
 
 
Tabelle1
Tabelle2