HomeMy WebLinkAboutAppendixA,MstrSvr,BB
Appendix A.
PROJECTED REVENUE AND EXPENDITURES
REVENUE
ServiceProgram Year
200220072012
Advertising$8,828$16,062$18,068
Business Installation Fees14,8651,329-761
Cable Installation81,02689,234100,379
Cable Television: Basic and Digital Packages556,4961,012,4991,138,959
Cable Television: Premium Package129,318236,728266,295
Cable Television: Pay-Per-View15,27127,78431,254
Equipment Rental: Cable Television Settop Box6,59211,99313,491
Hosting, Email, and Ancillary Services5,87110,68112,015
ISP: Business118,824239,106295,980
ISP: High Speed Residential and Small Business133,289263,169296,039
Late Fees and NOC Rental Fees to IP Provider71,471377,458424,603
PEG Revenue (Hospital, Schools, and Government)5,21918,42018,420
SCADA (savings to District's Electric and Water Units)94,537140,000140,000
Security and SCADA (AMR) Monitoring108,731371,622418,038
Telephony0199,292224,183
In-Lieu-of-Franchise Fees39,10668,31276,844
Gross Income
1,350,3883,015,3773,396,964
Less Bad Debt and Collections Pilot Program42,81230,15433,970
Total Income
$1,307,526$2,985,224$3,362,994
EXPENDITURES
ExpenseProgram Year
200220072012
Access to WWW$78,000$144,000$144,000
Capital Expenditures/Installation Costs
Amoritized over 10 years919,5171,058,7371,236,747
General and Administrative
Auto mileage program for employees18,95927,75844,705
Employee benefits (all)131,250176,530204,647
Freight and postage3,7924,4365,397
Insurance: liability, WC, fire18,00026,35442,443
Legal & accounting35,00442,54854,303
Management & administrative personnel226,500297,987345,448
Miscellaneous22,75127,65435,294
Office supply7,5849,21811,765
Phone, cell phone, long distance18,95915,44211,949
Professional & outside services147,00011,50011,505
Tax, licenses, permits11,37511,37511,375
Travel & entertainment15,16719,88127,884
In-Lieu-of-Franchise Fees39,10668,31276,844
ISP: Back Office0395,149444,503
ISP: Equipment Share087,72398,680
Operations
Plant Maintenance (techs)36,00055,07363,846
Facility Rental18,00018,00018,000
Transportation Overhead40,11849,78857,718
Utilities (elec, water, tel)18,00018,00018,000
Sales and Marketing30,97035,00035,000
Operating Expenses
1,836,0522,600,4653,000,053
Repayment of Startup Costs25,000200,0000
Total Expenses
$1,861,052$2,800,465$3,000,053
Operating Income
($553,526)$184,759$362,941
Add-back of non-cash items (Depreciation+Amoritization)
$919,516$1,058,736$1,236,748
Subtract and Interest Payments
($590,304)($507,689)($204,339)
Net Income (accrual basis)
($224,314)$735,806$1,395,350