ZAMREN Business Plan Model bandwidth dependent Year Income Broadband services NICHE ZM072 6% NICHE ZM072 budget UNZA contribution CBU staff contribution Internet Exchange Zicta Africa Connect Zesco backbone Advance payment
Financial overview Remarks 2012
$327.500 $43.000 $62.500 $86.240 $111.240 $240.000 $130.000
2013 $1.200.000 $43.000 $90.000 $21.560 $28.644
2014
2015
2016
$1.976.500 $43.000 $75.000
$2.165.000
$2.165.000
$25.000
$40.000
$50.000
$360.000 $180.000
$135.000
$101.250
$75.938
Totals $7.834.000 $129.000 $227.500 $107.800 $139.884 $115.000 $360.000 $732.188
Parameters Model number:
1
Bandwidth level multiplyer:
1
Tariiff decrease factor:
0,625
Average $/Mbps/Month Ph1: Average $/Mbps/Month Ph2:
$909 $523
Total income
$1.000.480
$1.923.204
$2.254.500
$2.306.250
$2.290.938
$9.775.372 Total revenues
OPEX
$1.020.495
$1.827.462
$2.068.993
$2.055.361
$2.133.108
$9.105.419 Operational expenses from OPEX
$95.743
$185.507
$250.889
$157.830
$669.953 Total income minus OPEX $506.333 Depreciation starts in the year following procurement
Ebitda
($20.015)
Depreciation
$0
$97.833
$113.667
$138.250
$156.583
Amortisation
$0
$0
$50.000
$80.000
$0
$21.840
$32.639
$1.247
$32.373
$33.620
$110.000
$60.000
2015 $264.750
2016 $361.333
EBIT per year
($20.015)
($2.091)
Ebit cummulative
($20.015)
($22.106)
CAPEX
$428.000
$100.000
Equipment fund Cash flow
2012 $0 ($20.015)
Version 6, d.d. December, 2012
2013 $97.833 $75.728
($266) $135.000
2014 $186.500 $186.234
$297.123
Cummulative loss or profit over given years! $833.000 Starting 2015 from ZAMREN equipment fund
$394.953
Page 1 of 16
ZAMREN Business Plan Opex Year
2012
2013
2014
2015
2016
Total
Staff costs
255.595
676.062
695.593
715.711
736.433
$3.079.394
Office
42.500
70.500
70.500
70.500
70.500
$324.500
NOC
37.000
32.000
35.000
35.000
35.000
$174.000
National network
268.400
186.400
141.400
107.650
82.338
$786.188
International traffic
409.500
817.500
1.096.500
1.096.500
1.178.838
$4.598.838
ZAMREN activities
7.500
45.000
30.000
30.000
30.000
$142.500
$1.020.495
$1.827.462
$2.068.993
$2.055.361
$2.133.108
$9.105.419
Totals
1%
2% 3%
7% Staff costs 34%
2014 Staff costs $695.593 International traffic $1.096.500 Office $70.500 NOC $35.000 National network $141.400 ZAMREN activities $30.000
34% 53% 3% 2% 7% 1%
Interna4onal traffic Office NOC Na4onal network
53%
Version 6, d.d. December, 2012
ZAMREN ac4vi4es
Page 2 of 16
ZAMREN Business Plan Capex Year Depreciation period NOC & POP's
2012
2013
2014
2015
2016
Totals
4 368.000
Vehicles
15.000
25.000
50.000
50.000
25.000
Office
10.000
10.000
$508.000 $25.000
10.000
ZAMREN training centre
25000
Internet Exchange
25000
10.000
10.000
$50.000
$60.000 $143.250
$633.000
Activity 3 Subtotals Depreciation per year
$378.000 $0
$50.000 $94.500
$85.000 $107.000
$60.000 $128.250
Last mile connectivity
50.000
50.000
50.000
50.000
0
Sub total Depreciation/year
50.000 0
50.000 3.333
50.000 6.667
50.000 10.000
0 13.333
$428.000 $0
$100.000 $97.833
$135.000 $113.667
$110.000 $138.250
$60.000 $156.583
Depreciation period FO
Totals investments Totals depreciation
Version 6, d.d. December, 2012
15 $200.000
$833.000 $506.333
Page 3 of 16
ZAMREN Business Plan
2011 Investments Office
Staff costs
Salaries Overhead
#REF! #REF!
Training
Office Furniture Training Centre
10%
25.000 Subtotal
Budget
Nuffice budget
#REF!
Nuffic budget Nuffic budget subtotal
0
Vehicles
CEO Personal to holder vehicle
1
No budget!
International connectivity
Ubuntunet Transit
0
Ubuntunet Membership
1.500 Subtotal
subtotal
0
subtotal
0
subtotal
0
Total:
0
NOC & POP's
1.500
National connectivity
Private Network Licence application Local Transit Charges AfriNIC IP Address Fees
2.500 0 6.400
Subtotal
8.900
NOC
Software Licences & Upgrades Hardware maintenance Housing (incl. Insurance and power)
5.000 0 0
Subtotal
Nuffic budget
5.000
OFFICE
VehIcle Maintenance Fuel Adverts and Publicity Office rental Board Meetings Travel/lodging General Assembly meeting Audit Fees
3.000 5.000 2.500 5.000 3.000 5.000
Last mile
Mulungushi
Nuffice budget (50%)
Zicta
2.000 Subtotal
25.500
ZAMREN activities
Annual User Conference IPv6 training Security training
7.500 18.000 Subtotal
Total: Total from Nuffic budget:
Version 6, d.d. December, 2012
Nuffic budget Nuffic budget
25.500
#REF!
40.000
Page 4 of 16
ZAMREN Business Plan
2012 Investments Office
Staff costs
Salaries Overhead
230.595 0
Training
25.000 Subtotal
Budget
Lump sum
10.000 Nuffic budget
0% Nuffice budget
255.595
subtotal
10.000
Vehicles
Utility vehicle
0
No budget
International connectivity
Ubuntunet transit
408.000
Ubuntunet Membership
subtotal
1.500 Subtotal
NOC
Spam filter Bandwidthmanager PoP Luska PoP Kabwe PoP Kitwe Access switches NOC flat screen FO connectors
409.500
National connectivity
Private Network Licence Local Transit Charges AfriNIC IP Address Fees
22.000 240.000 6.400 Subtotal
0
268.400
15.000 15.000 97.500 81.250 81.250 44.000 4.000 30.000
Nuffic budget Nuffic budget Nuffic budget Nuffic budget Nuffic budget Nuffic budget Nuffic budget Nuffic budget
NOC
Software Licences & Upgrades Hardware maintenance Housing (incl. Insurance and power)
25.000 0 12.000
Subtotal
Nuffic budget UNZA in kind
37.000 subtotal
368.000
OFFICE
VehIcle Maintenance Fuel Adverts and Publicity Office rental Board Meetings Travel/lodging General Assembly meeting Audit Fees
0 12.000 2.500 10.000 6.000 10.000 0 2.000 Subtotal
Last mile
MU campus
50.000 Zicta
UNZA in kind Nuffice budget (50%) subtotal
50.000
42.500 Total:
428.000
ZAMREN activities
Annual User Conference Virtualisation training
0 7.500
Subtotal
Total:
Total UNZA inkind
35.000
Total from Nuffic budget:
62.500
Version 6, d.d. December, 2012
Nuffic budget Nuffic budget Nuffic budget Nuffic budget
7.500 1.020.495
Page 5 of 16
ZAMREN Business Plan
2013 Investments Office
Staff costs
Salaries Overhead
591.874 59.187
Training
25.000 Subtotal
Budget
Lumpsum
10.000 Nuffic budget
10% Nuffice budget
subtotal
10.000
676.062
Utility vehicle
25.000 Nuffic budget (?)
International connectivity
Ubuntunet transit
816.000
Ubuntunet Membership
subtotal
1.500 Subtotal
NOC
Radio links Uni.colleges
817.500
National connectivity
15.000 Nuffic budget subtotal
5-‐year Private Network Licence Local Transit Charges AfriNIC IP Address Fees
0 180.000 6.400 Subtotal
25.000
15000
Last mile
New institutions
50.000 Zicta subtotal
50.000
186.400 Total:
100.000
NOC
Software Licences & Upgrades Hardware maintenance Housing (incl. Insurance and power)
15.000 5.000 12.000
Subtotal
Nuffic budget
32.000
OFFICE
VehIcle Maintenance Fuel Adverts and Publicity Office rental Board Meetings Travel/lodging General Assembly meeting Audit Fees
15.000 20.000 5.000 10.000 6.000 10.000 2.500 2.000 Subtotal
Nuffice budget (50%)
70.500
ZAMREN activities
Annual User Conference Lumpsum training Project management training Identity Management training
5.000 25.000 7.500 7.500 Subtotal
Total:
Nuffic budget Nuffic budget Nuffic budget Nuffic budget
45.000 1.827.462
UNZA in kind Total from Nuffic budget:
Version 6, d.d. December, 2012
90.000
Page 6 of 16
ZAMREN Business Plan
2014 Investments Office
Staff costs
Salaries Overhead
609.630 60.963
Training
25.000 Subtotal
Budget
Lump sum
10.000 Nuffic budget
10% Nuffice budget
695.593
subtotal
Lumpsum International connectivity Ubuntunet Transit
1095000
Ubuntunet Membership
25.000 subtotal
1.500 Subtotal
10.000
NOC
25.000
Last mile
New institutions
1.096.500
50.000 Zecto subtotal
50000
National connectivity
5-‐year Private Network Licence Local Transit Charges AfriNIC IP Address Fees
0 135.000 6.400 Subtotal
ZAMREN activities
Training Centre Internet Exchange
141.400
30000 25000 subtotal
55000
NOC
Software Licences & Upgrades Hardware maintenance Housing (incl. Insurance and power)
15.000 10.000 10.000
Subtotal
Nuffic budget
Total
115.000
35.000
OFFICE
VehIcle Maintenance Fuel Adverts and Publicity Office rental Board Meetings Travel/lodging General Assembly meeting Audit Fees
15.000 20.000 5.000 10.000 6.000 10.000 2.500 2.000 Subtotal
Nuffice budget (50%)
70.500
ZAMREN activities
Annual User Conference Lump sum training
5.000 25.000
Subtotal
Total: Total from Nuffic budget:
Version 6, d.d. December, 2012
Nuffic budget Nuffic budget
30.000
2.068.993
75.000
Page 7 of 16
ZAMREN Business Plan
2015 Investments Office
Staff costs
Salaries Overhead
627.919 62.792
Training
Lumpsum
715.711
International connectivity Ubuntunet Transit
1.500 1.096.500
Subtotal
subtotal
10.000
subtotal
0
Vehicles
1095000
Ubuntunet Membership
10.000
10%
25.000 Subtotal
Budget
NOC
Lumpsum
National connectivity
50.000 subtotal
5-‐year Private Network Licence Local Transit Charges AfriNIC IP Address Fees
0 101.250 6.400 Subtotal
50000
Last mile
New institutions
50.000 subtotal
50.000
107.650
NOC
Software Licences & Upgrades Hardware maintenance Housing (incl. Insurance and power)
15.000 10.000 10.000
Subtotal
Total
110.000
35.000
OFFICE
VehIcle Maintenance Fuel Adverts and Publicity Office rental Board Meetings Travel/lodging General Assembly meeting Audit Fees
15.000 20.000 5.000 10.000 6.000 10.000 2.500 2.000 70.500
Subtotal
ZAMREN activities
Annual User Conference Lumpsum training
5.000 25.000 30.000
Subtotal
Total: Total from Nuffic budget:
Version 6, d.d. December, 2012
2.055.361 0
Page 8 of 16
ZAMREN Business Plan
2016 Investments Office
Staff costs
Salaries Overhead
646.757 64.676
Training
Lumpsum
736.433
International connectivity Ubuntunet Transit
1.500 1.096.500
Subtotal
subtotal
10.000
subtotal
0
Vehicles
1095000
Ubuntunet Membership
10.000
10%
25.000 Subtotal
Budget
NOC
Lumpsum
National connectivity
50.000 subtotal
5-‐year Private Network Licence Local Transit Charges AfriNIC IP Address Fees
0 75.938 6.400 Subtotal
50000
Last mile
New institutions
0 subtotal
0
82.338
NOC
Software Licences & Upgrades Hardware maintenance Housing (incl. Insurance and power)
15.000 10.000 10.000
Subtotal
Total
60.000
35.000
OFFICE
VehIcle Maintenance Fuel Adverts and Publicity Office rental Board Meetings Travel/lodging General Assembly meeting Audit Fees
15.000 20.000 5.000 10.000 6.000 10.000 2.500 2.000 70.500
Subtotal
ZAMREN activities
Annual User Conference Lumpsum training
5.000 25.000 30.000
Subtotal
Total: Total from Nuffic budget:
Version 6, d.d. December, 2012
2.050.770 0
Page 9 of 16
ZAMREN Business Plan Salaries
2012 2011 2012 2012 2012
2013
2014
2015
2016
CEO Secretary Orderly Driver
111.240 8.240
114.577 8.487 8.000 14.500
118.015 8.742 8.240 14.935
121.555 9.004 8.487 15.383
125.202 9.274 8.742 15.845
2012 Fin. Officer 2012 Assist. Accoun
43.000
43.000
44.290
45.619
46.987
2012 2012 2012 2013 2012 2013
26.400
82.400 80.000 55.620 57.289 14.322 57.289
84.872 82.400 57.289 59.007 14.752 59.007
87.418 84.872 59.007 60.777 15.194 60.777
90.041 87.418 60.777 62.601 15.650 62.601
22.915 33.475
23.603 34.479
24.311 35.514
25.040 36.579
591.874
609.630
627.919
646.757
CTO Ntw CTO Serv Netw. Eng. 1 Netw. Eng. 2 Serv. Eng. 1 Serv. Eng. 2
27.810 13.905
2013 PR officer 2013 Proj. Assist
Salaries CEO Secretary Orderly Driver CTO Ntw CTO Serv Ntw. Eng. Serv. Eng. Accountant Assis. Account PR officer Proj. Assistant Students
108000 8000 11000 14500 80000 80000 54000 54000 43000 21600 21600 32500 10000
2013 Students
Totals
Overhead Inflation compensation
Version 6, d.d. December, 2012
230.595
0% 3%
Page 10 of 16
ZAMREN Business Plan
Institution
Staff
Students Points
UNZA CBU Mulungushi Nkrumah Coteco University Teaching Hospital Evelyn Hone College National Institute for Public Administration Mount Makulu Research Zambia Institute for Economic and Social Research Chainama College of Health Science National Scientific Research Station Chalimbana Teachers Training College National Resources for Development College Northern Technical College ZESCO Training Centre ZAMTEL Training College Luanshya Trades Institute Mwekera College of Forestrying College
2.050 12.820 723 6.045 216 1.454 100 800 100 800 100 800 30 150 100 800 100 0 800 800 800 800 800 800 300 800 800 400
180 180 180 180 180 180 80 180 180 90
Totals:
4.419 30.769
7.496
Weight of students (0 - 1.0):
Version 6, d.d. December, 2012
100 100 100 100 100 100 50 100 100 50
3.332 1.328 361 180 180 180 45 180 100
Points 2012
2013
2014 2015-2016
3.332 3.332 3.332 3.332 1.328 1.328 1.328 1.328 361 361 361 361 0 180 180 180 0 180 180 180 0 180 180 180 0 45 45 45 0 180 180 180 0 100 100 100 0 0 0 0 0 0 0 0 0 0
180 180 180 180 180 180 80 180 180 90
180 180 180 180 180 180 80 180 180 90
Factor 2012 66% 26% 7%
180 180 180 180 180 180 80 180 180 90
5.021 7.496 7.496 7.496
100%
2013
2014 2012-2016
44% 18% 5% 2% 2% 2% 1% 2% 1%
44% 18% 5% 2% 2% 2% 1% 2% 1%
44% 18% 5% 2% 2% 2% 1% 2% 1%
2% 2% 2% 2% 2% 2% 1% 2% 2% 1%
2% 2% 2% 2% 2% 2% 1% 2% 2% 1%
2% 2% 2% 2% 2% 2% 1% 2% 2% 1%
100%
100%
100%
0,1
Page 11 of 16
ZAMREN Business Plan
MOREnet Building Blocks PoP Router Cabinet UPS
$125.000
Sub-total 35% Total:
PoP Lusaka Router Cabinet UPS
$125.000 $43.750 $81.250
$150.000
Sub-total 35% Total:
$150.000 $52.500 $97.500
NOC Switch Server X-terminals HD screen Cabinet UPS Total:
$0
Transit
Service Router Cabinet UPS
Total:
Switch Server-1 Server-2 Cabinet UPS $0
Version 6, d.d. December, 2012
Total:
$0
Page 12 of 16
ZAMREN Business Plan
ZAMREN International circuits Installation Bandwidth after off load CC Liquid STM-1 to Jo'burg Ubutunet Africa Connect
Totals International traffc
GeANT transit tariff
2013 110
2014 345
2015 345
2016 345
$408.000
$816.000
$816.000 $279.000
$816.000 $279.000
$816.000 $279.000
$408.000
$816.000 $1.095.000 $1.095.000 $1.095.000
â‚Ź3.000 per year per Mbps
Off load factor
100%
Bandwidth Buying tariff Mbps/Month Africa Connect
2012 70
155 $438,71
155 $438,71
155 $588,71
155 $588,71
155 $588,71
Mbps/mon Mbps/STM-1 $150 $279.000
Version 6, d.d. December, 2012
Page 13 of 16
ZAMREN Business Plan
ZAMREN national circuits Zesco STM-1
Installation
2012 $240.000
2013 $180.000
2014 $135.000
2015 $101.250
2016 $75.938
Total:
$240.000
$180.000
$135.000
$101.250
$75.938
Tariff 2012 Tariff erosion
$240.000 25%
Version 6, d.d. December, 2012
Page 14 of 16
ZAMREN Business Plan Model bandwidth dependent 1 Institution UNZA CBU Mulungushi Nkrumah Coteco University Teaching Hospital Evelyn Hone College National Institute for Public Administration Mount Makulu Research Zambia Institute for Economic and Social Research Chainama College of Health Science National Scientific Research Station Chalimbana Teachers Training College National Resources for Development College Northern Technical College ZESCO Training Centre ZAMTEL Training College Luanshya Trades Institute Mwekera College of Forestrying College New institutions in 2014 (25)
Totals: Fee:
2012 2013 2014 2015 2016 Bandwidth Tariff Bandwidth Tariff Bandwidth Tariff Bandwidth tariff Bandwidth tariff 40 402.000 40 402.000 80 377.000 80 377.000 80 377.000 20 202.000 20 202.000 40 252.000 40 252.000 40 252.000 10 51.000 10 102.000 20 127.000 20 127.000 20 127.000 0 5 52.000 10 64.500 10 64.500 10 64.500 0 5 52.000 10 64.500 10 64.500 10 64.500 0 5 52.000 10 64.500 10 64.500 10 64.500 0 5 52.000 10 64.500 10 64.500 10 64.500 0 5 52.000 10 64.500 10 64.500 10 64.500 0 5 52.000 10 64.500 10 64.500 10 64.500 0 0 0 0 0 0 0 0 0 0
70
0 0 0 0 0 0 0 0
5 5 5 5 5 5 5 5 5 5
52.000 52.000 52.000 52.000 52.000 52.000 52.000 52.000 52.000 52.000
10 10 10 10 10 10 10 10 10 10 250
64.500 64.500 64.500 64.500 64.500 64.500 64.500 64.500 64.500 64.500 377.000
10 10 10 10 10 10 10 10 10 10 250
64.500 64.500 64.500 64.500 64.500 64.500 64.500 64.500 64.500 64.500 377.000
10 10 10 10 10 10 10 10 10 10 250
64.500 64.500 64.500 64.500 64.500 64.500 64.500 64.500 64.500 64.500 377.000
327.500
110
1.200.000
345
1.976.500
345
2.165.000
345
2.165.000
$2.000
2012-2013 Multipyer Average
1 $909 per Mbps/Month
Mbps Tariff/year 0 0 5 50000 10 100000 20 200000 40 400000 60 600000
Version 6, d.d. December, 2012
Factor: Multiplyer Average:
2014-2015 0,625 1 $523 Mbps/Month
Mbps Tariff/year 0 0 5 31250 10 62500 20 125000 40 250000 60 375000
Page 15 of 16
ZAMREN Business Plan Model User and Bandwidth dependent 2 Institution UNZA CBU Mulungushi Nkrumah Coteco University Teaching Hospital Evelyn Hone College National Institute for Public Administration Mount Makulu Research Zambia Institute for Economic and Social Research Chainama College of Health Science National Scientific Research Station Chalimbana Teachers Training College National Resources for Development College Northern Technical College ZESCO Training Centre ZAMTEL Training College Luanshya Trades Institute Mwekera College of Forestrying College New institutions in 2014 (25) Totals: National part of OPEX Donor contribution International connectivity Fee:
2012 2013 2014 2015 2016 Bandwidth Tariff Bandwidth Tariff Bandwidth Tariff Bandwidth tariff Bandwidth tariff 40 575.996 40 620.932 80 597.695 80 624.973 80 622.932 20 251.019 20 268.922 40 291.443 40 302.311 40 301.498 10 92.480 10 97.354 20 109.521 20 112.480 20 112.258 0 5 48.591 10 54.677 10 56.150 10 56.040 0 0 5 48.591 10 54.677 10 56.150 10 56.040 0 0 5 48.591 10 54.677 10 56.150 10 56.040 0 0 5 32.023 10 38.513 10 38.881 10 38.854 0 0 5 48.591 10 54.677 10 56.150 10 56.040 0 0 5 38.773 10 45.098 10 45.917 10 45.856 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0
5 5 5 5 5 5 5 5 5 5
48.591 48.591 48.591 48.591 48.591 48.591 36.318 48.591 48.591 37.546
70
919.495
110
1.351.085
$610.995 $62.500 $409.500
$0
$1.009.962 $90.000 $817.500
54.677 54.677 54.677 54.677 54.677 54.677 42.703 54.677 54.677 43.901 198.750 1.511.201
Average:
1 $1.024 Mbps/Month
Mbps Tariff/year 0 0 5 26500 10 53000 20 106000 40 212000 60 318000
10 10 10 10 10 10 10 10 10 10 250 345
$972.493 $75.000 $1.096.500
2012-2013 Multiplyer
Version 6, d.d. December, 2012
10 10 10 10 10 10 10 10 10 10 250 345
Multiplyer Factor Average
56.150 56.150 56.150 56.150 56.150 56.150 43.358 56.150 56.150 44.638 198.750 1.562.438 $958.861 $0 $1.096.500
10 10 10 10 10 10 10 10 10 10 250 345
56.040 56.040 56.040 56.040 56.040 56.040 43.309 56.040 56.040 44.583 198.750 1.558.604 $954.270 $0 $1.178.838
2014-2016 1 0,625 $365
Mbps Tariff/year 0 0 5 16562,5 10 33125 20 66250 40 132500 60 198750
Page 16 of 16