|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
AnyWhere, Ontario, FTTH |
|
|
Copyright © 2005, Maxwell
J. Toms |
|
|
|
|
|
|
FTTH & FTTB
OPERATIONS P&L MODEL |
|
100% Open System, any
supplier to any client. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Network Development Size: |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Number of Dwellings: |
|
|
|
928 |
|
|
|
|
|
|
|
|
|
|
Number
of Commercial & MUSH Connections: |
|
139 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Total Clients: |
|
|
|
1067 |
Assumes a 100% build, so Telephone and
Cable could be distributed on the new network. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Network Construction
Estimate : |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Total Engineering |
|
|
$98,382 |
Labour |
|
|
|
|
|
|
|
|
Total
Management & Procurement |
|
|
$282,296 |
Labour |
|
|
|
|
|
|
|
|
Total
Construction Sub Contracts & Support |
|
$2,927,676 |
Material & Labour |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Total CPE
Installation Sub Contracts & Support |
|
$1,830,204 |
Material & Labour |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Total Build Cost |
|
|
|
$5,138,558 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
OPERATIONS REVENUE MODEL: |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
RESIDENTIAL SERVICE: |
|
Year 1 |
Year 2 |
Year 3 |
Year 4 |
Year 5 |
Year 6 |
Year 7 |
Year 8 |
Year 9 |
Year 10 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
One-Time Hook-up Fee: |
|
$150 |
$150 |
$150 |
$150 |
$150 |
$150 |
$150 |
$150 |
$150 |
$150 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Uptake Rate: |
35% |
45% |
55% |
65% |
75% |
85% |
95% |
100% |
100% |
100% |
|
|
|
|
Total Clients: |
|
325 |
418 |
510 |
603 |
696 |
789 |
882 |
928 |
928 |
928 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Sales: |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Internet Revenue |
|
$50 |
$50 |
$50 |
$50 |
$50 |
$50 |
$50 |
$50 |
$50 |
$50 |
|
|
|
|
|
Video Revenue |
|
$40 |
$40 |
$40 |
$40 |
$40 |
$40 |
$40 |
$40 |
$40 |
$40 |
|
|
|
|
|
Video On Demand |
|
$0 |
$5 |
$15 |
$15 |
$15 |
$15 |
$15 |
$15 |
$15 |
$15 |
|
|
|
|
|
Voice-Over IP |
|
$0 |
$10 |
$10 |
$10 |
$10 |
$10 |
$10 |
$10 |
$10 |
$10 |
|
|
|
|
|
Water Meter Records |
|
$0 |
$2 |
$2 |
$2 |
$2 |
$2 |
$2 |
$2 |
$2 |
$2 |
|
|
|
|
|
Electric Meter Records |
|
$0 |
$2 |
$2 |
$2 |
$2 |
$2 |
$2 |
$2 |
$2 |
$2 |
|
|
|
|
|
Security System Access |
|
$0 |
$0 |
$2 |
$2 |
$2 |
$2 |
$2 |
$2 |
$2 |
$2 |
|
|
|
|
|
Game System Access |
|
$2 |
$2 |
$2 |
$2 |
$2 |
$2 |
$2 |
$2 |
$2 |
$2 |
|
|
|
|
|
Software Server |
|
$0 |
$0 |
$2 |
$2 |
$2 |
$2 |
$2 |
$2 |
$2 |
$2 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Monthly Sales Average
/Client |
|
$92 |
$111 |
$125 |
$125 |
$125 |
$125 |
$125 |
$125 |
$125 |
$125 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Total Income from
Residential: |
|
$29,900 |
$46,398 |
$63,750 |
$75,375 |
$87,000 |
$98,625 |
$110,250 |
$116,000 |
$116,000 |
$116,000 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
BUSINESS SERVICE: |
|
Year 1 |
Year 2 |
Year 3 |
Year 4 |
Year 5 |
Year 6 |
Year 7 |
Year 8 |
Year 9 |
Year 10 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
One-Time Hook-up Fee |
|
$250 |
$250 |
$250 |
$250 |
$250 |
$250 |
$250 |
$250 |
$250 |
$250 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Uptake Rate: |
45% |
55% |
65% |
75% |
85% |
95% |
97% |
99% |
100% |
100% |
|
|
|
|
Total Clients |
|
63 |
76 |
90 |
104 |
118 |
132 |
135 |
138 |
139 |
139 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Monthly Sales Average
/Client |
|
$235 |
$235 |
$235 |
$235 |
$235 |
$235 |
$235 |
$235 |
$235 |
$235 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Total Business Income: |
|
$14,805 |
$17,860 |
$21,150 |
$24,440 |
$27,730 |
$31,020 |
$31,725 |
$32,430 |
$32,665 |
$32,665 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
NETWORK SERVICES: |
|
Year 1 |
Year 2 |
Year 3 |
Year 4 |
Year 5 |
Year 6 |
Year 7 |
Year 8 |
Year 9 |
Year 10 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
One-Time Hook-up /mo |
|
$
5,296 |
$
6,713 |
$
8,138 |
$ 9,574 |
$ 11,011 |
$
12,448 |
$
13,669 |
$
14,303 |
$ 14,322 |
$ 14,322 |
|
|
|
|
|
|
Inflation: |
0% |
2% |
2% |
2% |
2% |
2% |
2% |
2% |
2% |
2% |
|
|
|
|
|
|
Service Call Fee: |
$75 |
$77 |
$78 |
$80 |
$81 |
$83 |
$84 |
$86 |
$88 |
$90 |
|
|
|
|
|
|
Clients: |
388 |
494 |
600 |
707 |
814 |
921 |
1017 |
1066 |
1067 |
1067 |
|
|
|
|
|
|
Billable Service Take-up Rate: |
5% |
5% |
5% |
5% |
5% |
5% |
5% |
5% |
5% |
5% |
|
|
|
|
Client Service Calls: |
|
$1,455 |
$1,890 |
$2,341 |
$2,814 |
$3,304 |
$3,813 |
$4,295 |
$4,592 |
$4,688 |
$4,782 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Total Network Services
Income: |
|
$6,751 |
$8,603 |
$10,478 |
$12,388 |
$14,315 |
$16,261 |
$17,964 |
$18,894 |
$19,010 |
$19,104 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
ISP SERVICES: |
|
Year 1 |
Year 2 |
Year 3 |
Year 4 |
Year 5 |
Year 6 |
Year 7 |
Year 8 |
Year 9 |
Year 10 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Web Service Take-up Rate: |
20% |
30% |
40% |
50% |
52.00% |
54.00% |
56.00% |
58.00% |
60.00% |
62.00% |
|
|
|
|
Web Service Revenue: |
$20 |
$1,552 |
$2,964 |
$4,800 |
$7,070 |
$8,466 |
$9,947 |
$11,390 |
$12,366 |
$12,804 |
$13,231 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Inflation: |
0% |
2% |
2% |
2% |
2% |
2% |
2% |
2% |
2% |
2% |
|
|
|
|
Other Services Revenue: |
|
$200 |
$204 |
$208 |
$212 |
$216 |
$221 |
$225 |
$230 |
$234 |
$239 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Total ISP Services
Income: |
|
$1,752 |
$3,168 |
$5,008 |
$7,282 |
$8,682 |
$10,168 |
$11,616 |
$12,595 |
$13,038 |
$13,470 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Monthly Gross Revenue |
|
$53,208 |
$76,029 |
$100,386 |
$119,485 |
$137,727 |
$156,073 |
$171,554 |
$179,920 |
$180,714 |
$181,239 |
|
|
|
|
|
|
|
|
|
|
|
|
|
Yearly Gross Revenue |
|
$638,499 |
$912,347 |
$1,204,638 |
$1,433,819 |
$1,652,725 |
$1,872,880 |
$2,058,651 |
$2,159,036 |
$2,168,562 |
$2,174,865 |
|
|
|
|
|
|
OPERATIONS COST MODEL: |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
INFRASRRUCTURE: |
|
Year 1 |
Year 2 |
Year 3 |
Year 4 |
Year 5 |
Year 6 |
Year 7 |
Year 8 |
Year 9 |
Year 10 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Inflation |
0% |
1% |
1% |
1% |
1% |
1% |
1% |
1% |
1% |
1% |
|
|
|
|
Contracted Maintainence
/month: |
|
$ 9,500 |
$
9,595 |
$
9,691 |
$
9,788 |
$
9,886 |
$
9,985 |
$
10,084 |
$
10,185 |
$
10,287 |
$
10,390 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Network Financing @
10% /mo: |
13.11 |
$67,366 |
$67,366 |
$67,366 |
$67,366 |
$67,366 |
$67,366 |
$67,366 |
$67,366 |
$67,366 |
$67,366 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Sinking Fund for Network
Renewal: |
5% |
$2,660 |
$3,801 |
$5,019 |
$5,974 |
$6,886 |
$7,804 |
$8,578 |
$8,996 |
$9,036 |
$9,062 |
|
|
|
|
|
|
|
|
|
|
|
|
Monthly Owner Cost |
|
$79,527 |
$80,763 |
$82,077 |
$83,129 |
$84,139 |
$85,155 |
$86,029 |
$86,548 |
$86,689 |
$86,818 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
INTERNET SERVICES
PROVIDER |
|
Year 1 |
Year 2 |
Year 3 |
Year 4 |
Year 5 |
Year 6 |
Year 7 |
Year 8 |
Year 9 |
Year 10 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Inflation |
0% |
-5% |
-5% |
-5% |
-5% |
-5% |
-5% |
-5% |
-5% |
-5% |
|
|
|
|
|
|
T1 Cost |
$ 1,650 |
$
1,568 |
$
1,489 |
$
1,415 |
$
1,344 |
$
1,277 |
$
1,213 |
$
1,152 |
$
1,095 |
$
1,040 |
|
|
|
|
Internet Connection
/month |
100 |
$6,600 |
$7,838 |
$8,935 |
$9,903 |
$10,751 |
$11,491 |
$12,129 |
$12,675 |
$12,041 |
$11,439 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Services/Client: |
$42 |
$61 |
$75 |
$75 |
$75 |
$75 |
$75 |
$75 |
$75 |
$75 |
|
|
|
|
|
|
Residential Clients: |
325 |
418 |
510 |
603 |
696 |
789 |
882 |
928 |
928 |
928 |
|
|
|
|
Services Purchases
/month |
35% |
$4,778 |
$8,924 |
$13,388 |
$15,829 |
$18,270 |
$20,711 |
$23,153 |
$24,360 |
$24,360 |
$24,360 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
EquipmentCost |
$ 40,000 |
|
|
|
|
$ 50,000 |
|
|
|
|
|
|
|
|
Equipment Financing @
10% /mo |
21.15 |
$846 |
$846 |
$846 |
$846 |
$846 |
$1,058 |
$1,058 |
$1,058 |
$1,058 |
$1,058 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Inflation |
0% |
1% |
1% |
1% |
1% |
1% |
1% |
1% |
1% |
1% |
|
|
|
|
Contracted Maintainence
/month |
|
$ 3,000 |
$
3,030 |
$
3,060 |
$
3,091 |
$
3,122 |
$
3,153 |
$
3,185 |
$
3,216 |
$
3,249 |
$
3,281 |
|
|
|
|
|
|
|
|
|
|
|
|
Monthly ISP Cost |
|
$15,224 |
$20,638 |
$26,229 |
$29,668 |
$32,989 |
$36,412 |
$39,524 |
$41,309 |
$40,707 |
$40,138 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Total Monthly Expenses |
|
$94,750 |
$101,401 |
$108,305 |
$112,797 |
$117,128 |
$121,567 |
$125,552 |
$127,856 |
$127,396 |
$126,956 |
|
|
|
|
|
|
|
|
|
|
|
Total Yearly Cost |
|
$1,137,005 |
$1,216,809 |
$1,299,664 |
$1,353,563 |
$1,405,535 |
$1,458,806 |
$1,506,627 |
$1,534,278 |
$1,528,758 |
$1,523,472 |
|
|
|
|
|
|
OPERATIONS
P&L |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
ANNUAL PERFORMANCE: |
|
Year 1 |
Year 2 |
Year 3 |
Year 4 |
Year 5 |
Year 6 |
Year 7 |
Year 8 |
Year 9 |
Year 10 |
|
|
|
|
|
|
|
|
|
|
Monthly Gross Margin: |
|
-$41,542 |
-$25,372 |
-$7,919 |
$6,688 |
$20,599 |
$34,506 |
$46,002 |
$52,063 |
$53,317 |
$54,283 |
|
|
|
|
|
|
|
|
|
|
Yearly Margin |
|
-$498,506 |
-$304,462 |
-$95,026 |
$80,256 |
$247,190 |
$414,074 |
$552,025 |
$624,759 |
$639,805 |
$651,393 |
|
|
|
|
|
|
|
|
|
|
Accumulating P&L |
|
-$498,506 |
-$802,968 |
-$897,994 |
-$817,738 |
-$570,548 |
-$156,475 |
$395,550 |
$1,020,308 |
$1,660,113 |
$2,311,506 |
|
|
|
|
|
|
|
|
|
|
|
Accumulating Finance Payments /yr |
|
|
$808,398 |
$1,616,796 |
$2,425,194 |
$3,233,592 |
$4,041,990 |
$4,850,388 |
$5,658,786 |
$6,467,184 |
$7,275,582 |
$8,083,980 |
|
|
|
|
|
|
|
|
|
|
|
Accumulating Sinking Fund Value
/yr |
|
|
$31,925 |
$77,542 |
$137,774 |
$209,465 |
$292,101 |
$385,745 |
$488,678 |
$596,630 |
$705,058 |
$813,801 |
|
|
|
|
|
|
|
|
|
|
|
Accumulating Network Value /yr |
|
|
$5,202,113 |
$5,282,673 |
$5,380,323 |
$5,495,213 |
$5,627,343 |
$5,776,713 |
$5,940,738 |
$6,112,368 |
$6,284,233 |
$6,456,098 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|