|
MAIN Wireless Project |
|||||
|
Pro Forma P & L |
|||||
|
Year 1 |
Year 2 |
Year 3 |
Year 4 |
Year 5 |
|
|
Income |
|||||
|
User Fees (sch A) |
56,441 |
192,504 |
250,104 |
307,704 |
365,304 |
|
Grants |
580,000 |
55,000 |
- |
- |
- |
|
CPE Installation Fees |
18,500 |
18,000 |
12,000 |
12,000 |
12,000 |
|
Total Income |
654,941 |
265,504 |
262,104 |
319,704 |
377,304 |
|
Expense |
|||||
|
Salaries |
95,000 |
114,000 |
119,700 |
125,685 |
131,969 |
|
Payroll Tax Expense |
8,075 |
9,690 |
10,175 |
10,683 |
11,217 |
|
Health Insurance |
7,078 |
8,493 |
8,918 |
9,364 |
9,832 |
|
Retirement Plan |
9,000 |
11,340 |
11,907 |
12,502 |
13,127 |
|
Insurance |
6,000 |
6,300 |
6,615 |
6,946 |
7,293 |
|
Marketing |
4,000 |
4,000 |
4,000 |
4,000 |
4,000 |
|
Equipment Rental |
300 |
100 |
100 |
100 |
100 |
|
Telephone-Cell/Pager |
1,000 |
1,000 |
1,000 |
1,000 |
1,000 |
|
Travel |
1,200 |
2,500 |
2,500 |
2,500 |
2,500 |
|
Training |
11,000 |
5,000 |
5,000 |
5,000 |
5,000 |
|
Other Expenses |
1,000 |
500 |
500 |
500 |
500 |
|
Total Non-network Expense |
143,653 |
162,923 |
170,415 |
178,280 |
186,538 |
|
Network Expense |
|||||
|
Connectivity (sch B) |
19,000 |
63,000 |
52,000 |
66,000 |
80,000 |
|
Contract labor |
79,000 |
2,000 |
2,000 |
2,000 |
2,000 |
|
Equipment (sch C) |
386,865 |
20,000 |
30,000 |
60,000 |
60,000 |
|
Maintenance Contract |
15,000 |
15,000 |
15,000 |
15,000 |
15,000 |
|
Total Network Expense |
499,865 |
100,000 |
99,000 |
143,000 |
157,000 |
|
Total Expenses |
643,518 |
262,923 |
269,415 |
321,280 |
343,538 |
|
Net Income |
11,423 |
2,581 |
-7,311 |
-1,576 |
33,766 |
|
Beginning Cash Balance |
- |
11,424 |
14,005 |
6,695 |
5,119 |
|
Ending Cash Balance |
11,424 |
14,005 |
6,695 |
5,119 |
38,884 |