PROJ02004

• Contract/PO #: FS0074FX
• Contractor Name: Highland Ditch Company
• Contract Type: Grant
• Water District: 0
• Loan Projects - Doc Type: Feasibility Study

rj
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I

Annual Income

Year % of buildout
Cumulative % of buildout

Forecast number of residential taps

Hookup Revenues
Annual Water Revenues
Total Projected Income

Expenses

Additional CWCB Loan Amount
Total Loan Amount Outstanding

Current Year Loan P&I Payment (approx.)
Loan repayment contingency (20%)

Field Office Space
Office Supplies
Telephone and related communications
Staff (contractual)
Staff (payroll, burdened)
GIS/GPS equipment
Vehicle expense (purchase or mileage)
Misc.
Power Costs
System repair & maintenance
Accounting & legal
Support engineering (not CDs)
Insurance
Billing services contract
Contingency at 20%
Total Expense

Capital Improvement Fund / Sinking Fund / Savings

TABLE 12

The Highland Ditch Company
POTENTIAL INCOME AND CASH FLOW PROJECTION OVER FIRST 10 YEARS

Y2005

Y2011

Y2012

Y2013

Y2014

Y2009

Y2010

Y2006

Y2007

Y2008

2% 5% 5% 5% 5% 5% 5% 5% 5% 5%
2% 7% 12% 17% 22% 27% 32% 37% 42% 47%
193 481 481 481 481 481 481 481 481 481
$624,108 $1,560,269 $1,560,269 $1,560,269 $1,560,269 $1,560,269 $1,560,269 $1,560,269 $1,560,269 $1,560,269
91,943 321,799 551,655 781,511 1,011,368 1 ,241 ,224 1,471,080 1,700,936 1,930,793 2,160,649
$716,050 $1,882,068 $2,111,924 $2,341,781 $2,571,637 $2,801,493 $3,031,349 $3,261,206 $3,491,062 $3,720,918

660,000 1,650,000 1,650,000 1,650,000 1,650,000 1,650,000 1,650,000 1,650,000 1,650,000 1,650,000
660,000 2,310,000 3,960,000 5,610,000 7,260,000 8,910,000 10,560,000 12,210,000 13,860,000 15,510,000
31,533 110,366 189,199 268,033 346,866 425,699 504,532 583,365 662,198 741,031
6,307 22,073 37,840 53,607 69,373 85,140 100,906 116,673 132,440 148,206
20,000 20,000 20,000 20,000 20,000 30,000 30,000 30,000 30,000 30,000
1,200 1,200 1,200 1,200 1,200 1,200 1,200 1,200 1,200 1,200
2,400 2,400 3,600 3,600 3,600 4,800 4,800 4,800 4,800 4,800
100,000 100,000 150,000 150,000 150,000 150,000 200,000 200,000 200,000 200,000
60,000 100,000 100,000 120,000 120,000 180,000 180,000 240,000 240,000 240,000
12,000 12,000 12,000 12,000 12,000 12,000 12,000 12,000 12,000 12,000
12,000 12,000 12,000 18,000 18,000 18,000 24,000 24,000 24,000 24,000
6,000 6,000 10,000 10,000 20,000 20,000 20,000 20,000 20,000 20,000
161,250 322,500 322,500 322,500 376,250 376,250 376,250 430,000 430,000 430,000
5,000 7,500 10,000 20,000 25,000 30,000 35,000 40,000 45,000 50,000
37,985 58,360 64,130 67,730 74,605 82,225 88,325 100,200 100,700 101 ,200
25,000 25,000 25,000 50,000 50,000 50,000 50,000 75,000 75,000 75,000
41,784 64,196 70,543 74,503 82,066 90,448 97,158 110,220 110,770 111,320
14,321 37,641 42,238 46,836 51,433 56,030 60,627 65,224 69,821 74,418
99,788 153,759 168,642 183,274 200,831 220,190 235,872 270,529 272,658 274,788
$636,567 $1,054,996 $1,238,893 $1,421,281 $1,621,223 $1,831,981 $2,020,670 $2,323,211 $2,430,587 $2,537,963
100,000 200,000 400,000 800,000 1,000,000 1,000,000 1,000,000 1,000,000 1,000,000 1,000,000

Note: This table shows a potential income and cash flow projection for the first 10 years following construction of the first phase of the Highland Ditch secondary supply infrastructure. The expenses have been listed to show what's being accounted for, and "best guesses"
have been shown for costs. This projection is preliminary and should not be interpreted as anything other than preliminary, Discussions with the Board can help further this table by adjusting costs as needed,