HomeMy WebLinkAbout2009-07-14 - Finance-Accounting Committee Meeting Agenda Packet
'rb Linda
Water District
AGENDA
YORBA LINDA WATER DISTRICT
FINANCE-ACCOUNTING COMMITTEE MEETING
Tuesday, July 14, 2009, 4:00 PM
1717 E Miraloma Ave, Placentia CA 92870
COMMITTEE STAFF
Director Michael J. Beverage, Chair Ken Vecchiarelli, General Manager
Director William R. Mills, Alternate Diane Cyganik, Finance Director
Sandi Van Etten, Senior Accountant
1. PUBLIC COMMENTS
Any individual wishing to address the committee is requested to identify themselves and state the matter on
which they wish to comment. If the matter is on this agenda, the committee Chair will recognize the individual for
their comment when the item is considered. No action will be taken on matters not listed on this agenda.
Comments are limited to matters of public interest and matters within the jurisdiction of the Water District.
Comments are limited to five minutes.
2. ACTION CALENDAR
This portion of the agenda is for items where staff presentations and committee discussions are needed prior to
formal committee action.
2.1. Monthly Financial Statements for May 2009
Recommendation: That the Committee receive and file the Financial Statements.
2.2. Monthly Investment Report for May 2009
Recommendation: That the Committee receive and file the Investment Report.
3. DISCUSSION ITEMS
This portion of the agenda is for matters such as technical presentations, drafts of proposed policies, or similar
items for which staff is seeking the advice and counsel of the Committee members. This portion of the agenda
may also include items for information only.
3.1. Monthly Portfolio Reports for June 2009
3.2. Locke Ranch Sewer Assessment
3.3. Future Agenda Items and Staff Tasks
4. ADJOURNMENT
4.1. The next regular meeting of the Finance-Accounting Committee will be held August 11,
2009 at 4:00 p.m.
Items Distributed to the Committee Less Than 72 Hours Prior to the Meeting
Pursuant to Government Code section 54957.5, non-exempt public records that relate to open session agenda items
and are distributed to a majority of the Committee less than seventy-two (72) hours prior to the meeting will be available
for public inspection in the lobby of the District's business office located at 1717 E. Miraloma Avenue, Placentia, CA
92870, during regular business hours. When practical, these public records will also be made available on the District's
internet website accessible at http://www.ylwd.com/.
Accommodations for the Disabled
Any person may make a request for a disability-related modification or accommodation needed for that person to be
able to participate in the public meeting by telephoning the Executive Secretary at 714-701-3020, or writing to Yorba
Linda Water District, P.O. Box 309, Yorba Linda, CA 92885-0309. Requests must specify the nature of the disability and
the type of accommodation requested. A telephone number or other contact information should be included so the
District staff may discuss appropriate arrangements. Persons requesting a disability-related accommodation should
make the request with adequate time before the meeting for the District to provide the requested accommodation.
ITEM NO. 2.1
AGENDA REPORT
Meeting Date: July 14, 2009 Budgeted: N/A
To: Finance-Accounting Committee
Funding Source: N/A
From: Ken Vecchiarelli, General
Manager
Presented By: Sandi Van Etten, Senior Dept: Finance
Accountant
Reviewed by Legal: N/A
Prepared By: Sandi Van Etten, Senior CEQA Compliance: N/A
Accountant
Subject: Monthly Financial Statements for May 2009
SUMMARY:
A presentation will be made of the May 2009 Financial Statements.
STAFF RECOMMENDATION:
That the Committee receive and file the Financial Statements.
DISCUSSION:
The Water Fund and the Sewer Fund had operating losses through May 31, 2009 of $3,133,109
and $126,492 respectively. The key factors are as follows:
Wateffhe Water Fund's operating loss increased $395,000 in May. Water usage, and its
corresponding revenue, exceeded the prior year's water usage for every month since January.
However, both variable expenses and supplies/services increased slightly faster than the budgeted
amount; this resulted in a higher operating loss.
Sewer:Sewer Fund's revenue is still higher than expected, but expenses also are higher, resulting
in the operating loss increasing by $9,600 in May. The closing of jobs that cannot be capitalized
results in additional expenses that had not been anticipated.
The Summary Financial Report is a modified schedule of revenue and expenses. It includes other
expenditures that are not classified as expense, which affect the net operating cash position of the
District. The line items referencing "Capital" are both salaries and supplies/services that would have
been expensed, if they had not been charged to capital projects instead. Principal on debt is a large
expenditure, but it never is reflected on the Revenue/Expense report. Vehicle and Equipment outlay
are operating costs that are capitalized rather than expensed, so again they would not be captured
on a Revenue/Expense report - yet they reduce operating cash. This report is a means of relaying
basic revenue and expense information, while additionally providing a clearer picture of the real
impact on operating cash.
PRIOR RELEVANT BOARD ACTION(S):
Financial Statements are presented to the Finance-Accounting Committee on a monthly basis.
Quarterly Financial Statements are presented to the Board of Directors which are then received and
filed
ATTACHMENTS:
May 09 FS.pdf rev. Exp Reports Backup Material
07MIOS Yorba Linda Water District
12M PM Revenue/Expense Report
Sewer Detail
For the Eleven Months Ending May 31, 2009
Full Year YTD YTD YTD
Budget Budget Actual Under(Over) Month
FY 2009 FY 2009 FY 2009 Budget May12009
Revenue (Operating):.
Sewer Charge Revenue $1,141,650 $1,046,513 $1,181,581 ($135,068) $116,560
Locke Ranch Assessments 104,900 96„158 99,831 (3,673) 458
Other Operating Revenue 3,300 3,025 4,358 (1,333) 261
Total Operating Revenue: 1,249,850 1,945,696 1,285,770 (140,074) 117,279
Expenses (Operating):
Salary Related Expenses 998,748 915,519 561,948 353,571 47,011
Supplies & Services:
Communications 26,467 24,261 19,546 4,715 2,153
Contractual Services 149,889 137,398 71,964 65,434 2,069
Data Processing 46,711 42,818 1,783 41,035 395
Dues & Memberships 3,157 2,894 2,142 752 21
Fees & Permits 10,702 9,810 2,709 7,101
Board Election 3,601 3,301 3,737 (436)
Insurance 27,365 25,085 22,816 2,269 5
Materials 65,579 60,114 35,642 24,472 1,724
District Activities, Imp Recognition 1,810 1,659 1,428 231 546
Non-Capital Equipment 21,432 19,646 3,495 16,151 (76)
Office Expense 5,436 4,983 3,155 1,828 226
Professional Services 57,435 52,649 31,606 21,043 3,944
Training 9,273 8,500 4,657 3,843 328
Travel & Conferences 6,580 6,032 2,032 4,000 163
Uncollectible Accounts 1,756 1,610 1,610
Collection Agency Fee 90 83 83
Utilities 5,755 5,275 195 5,080 18
Vehicle Equipment 50,833 46,597 48,269 (1,672) 999
Job Closing Expense 98,917 (98,917) 20,189
Supplies & Services Sub-Total 493,871 452,715 354,093 98,622 32,704
Depreciation & Amortization 564,200 517,183 496,222 20,961 47,157
Total Operating Expenses 2,056,819 1,885,417 9,412,263 473,154 126,872
Operating Income (Loss) (8€16,969) (739,721) (126,493) (613,228) (9,593)
Revenue (Mon-Operating):
Interest 17,000 15,583 7,695 7,888 383
Interest (Restricted for Capital Projects) 935 (935) 66
Property Taxes 66,000 60,500 60,500
Other Non-Operating Revenue 5,000 4,583 14,368 (9,785) 626
Total Non-Operating Revenue: 88,000 80,666 2Z 998 57,668 1,075
Expenses (Nom-Operating):
Other Expense 6,700 6,142 1,990 4,152 214
Total Mon-Operating,Expenses: 6,700 6,942 1,990 4,152 214
Mon-Operating Income (Loss) 81,300 74,524 21,008 53,516 861
Total Income (Lass) (725,669) _ (665,197) {105,485} (559,712) (8,732)
Contributed Capital 251,000 230,083 1,977,505 (1,747,422) 1,180
07/08109 Yorba Linda Water District
12:07 PM Revenue/Expense Report
Water Detail
For the Eleven Months Ending May 31, 2009
Full Year YTD YTD YTD
Budget Budget Actual Under(Over) Month
FY 2009 FY 2009 FY 2009 Budget May12009
Revenue (Operating):
Water Revenue (Residential) $12,991,060 $11,908,472 $15,079,690 ($3,171,218) $1,454,900
(Restricted for Debt Service) (2,786,872) 2,786,872 (216,925)
Water Revenue (Commercial & Fire Det.) 1,341,790 1,229,974 1,489,907 (259,933) 138,690
Water Revenue (Landscape/Irrigation) 2,746,450 2,517,579 3,413,771 (896,192) 313,411
Other Operating Revenue 655,900 601,242 635,633 (34,391) 50,359
Total Operating Revenue: 17, 735, 200 96, 257, 267 17,832,129 (1, 574, 862) 1,740,435
Expenses (Operating):
Variable Water Costs (G.W., Import & Power) 11,156,500 10,226,792 9,730,209 496,583 1,020,817
Salary Related Expenses 7,114,220 6,521,368 5,053,989 1,467,379 424,433
Supplies & Services:
Communications 247,768 227,121 237,064 (9,943) 25,943
Contractual Services 729,946 669,117 603,973 65,144 59,536
Data Processing 260,931 239,187 114,215 124,972 77,747
Dues & Memberships 31,273 28,667 21,780 6,887 210
Fees & Permits 37,934 34,773 29,414 5,359 435
Board Election 39,999 36,666 37,789 (1,123)
Insurance 303,940 278,612 230,699 47,913 51
Materials 586,461 537,589 768,538 (230,949) 65,471
District Activities, Emp Recognition 20,100 18,425 14,442 3,983 5,516
Non-Capital Equipment 207,413 190,128 60,898 129,230 1,353
Office Expense 60,374 55,343 31,898 23,445 2,285
Professional Services 620,590 568,874 301,629 267,245 27,721
Training 86,262 79,073 16,339 62,734 398
Travel & Conferences 58,105 53,263 25,402 27,861 1,672
Uncollectible Accounts 19,499 17,874 17,874
Collection Agency Fee 1,000 917 917
Utilities 63,920 58,593 23,572 35,021 2,154
Vehicle Equipment 242,787 222,555 327,076 (104,521) 65,138
Job Closing Expense 84,979 (84,979) 32,177
Supplies & Services Sub-Total 3,618,302 3,316,777 2,929,707 387,070 367,807
Depreciation & Amortization 3,676,500 3,370,125 3,251,333 118,792 322,412
Total Operating Expenses 25,565,522 23,435,062 20,965,238 2,469,824 2,935,469
Operating Income (Loss) (7, 830, 322) (7,177, 795) (3,133,109) (4, 044, 686) (395, 034)
Revenue (Non-Operating):
Interest 47,500 43,542 18,630 24,912 773
Interest (Restricted for Capital Projects) 287,822 (287,822) 3,275
Property Taxes 1,200,150 1,100,138 1,241,379 (141,241) 28,682
Debt Service Income (through water revenue) 2,786,872 (2,786,872) 216,925
Other Non-Operating Revenue 449,200 411,767 583,170 (171,403) 39,617
Total Non-Operating Revenue: 1,696,850 1,555,447 4,917,873 (3,362,426) 289,272
Expenses (Non-Operating):
Interest on Long Term Debt 1,888,690 (1,886,690) 164,197
Other Expense 24,300 22,275 162,171 (139,896) 4,847
Total Non-Operating Expenses: 24,300 22,275 2,048,861 (2,026,586) 169,044
Non-Operating Income (Loss) 1,672,550 1,533,172 2,869,012 (1,335,840) 120,228
Total Income (Lass) (6,157,772) (5,644,623) ( (5,380,526) (274,806)
Contributed Capital 667,100 611,508 1,481,499 (869,991) 29,470
07108/09 Yorba Linda Water (District
11:18 AM Summary Financial Report
Water & Sewer
For the Eleven Months Ending May 31, 2009
Full Year YTD YTD YTD
Budget Budget Actual Under(Over) Month
FY 2009 FY 2009 FY 2009 Budget May/2009
Revenue (Operating):
Water Revenue (Consumption & Flat Charge) $17,441,010 $15,987,593 $20,288,571 ($4,300,978) $1,939,629
(Restricted for Debt Service) (2,786,872) 2,786,872 (216,925)
Sewer Revenue 1,246,550 1,142,671 1,281,412 (138,741) 117,018
Other 297,490 272,699 334,788 62,089) 17,992
Total Operating Revenue: 18,985,050 17,402,963 19,977,899 (1,714,936) 1,857,794
Expenses (Operating):
Variable Water Costs (G.W., Impart & Power) 11,156,500 10,226,792 9,730,209 496,583 1,020,817
Salary Related Expenses 8,112,968 7,436,887 5,615,936 1,820,951 471,444
Supplies & Services 4,112,172 3,769,491 3,283,799 485,692 400,509
Depreciation & Amortization 4,240,700 3,887,308 3,747,556 139,752 369,569
Total Operating Expenses: 27,622,340 25,320,478 22,377,500 2,942,978 2,262,339
Operating Income (Loss) (8,637,290) (7,917,515) (3,259,601) (4,657,914) (404,625)
Revenue (Nan-Operating):
Interest 64,500 59,125 26,326 32,799 1,157
Interest (Restricted for capital projects) 288,757 (288,757) 3,341
Property Taxes 1,266,150 1,160,638 1,241,379 (80,741) 28,682
Debt Service income. (through water revenue) 2,786,872 (2,786,872) 216,925
Other 454,200 416,350 597,538 (181,188) 40,243
Total Non-Operating Revenue: 1,784,850 1,636,113 4,940,872 (3,304, 759) 290,348
Expenses (Non-Operating):
Interest on Long Term Debt 1,886,690 (1,886,690) 164,197
Other Expense 31,000 28,417 164,161 (135,744) 5,060
Total Non-Operating,Expenses: 31,000 28,417 2,050,851 (2,022,434) 169,257
Non-Operating Income (Lass) 1,753,850 1,607,696 2,890,021 _ (1,282,32 121,091
Net Income (Loss) (6,883,440) (5,309,81) (369,580) _(5,940,239) 283,534
Other Expenditures and Outlay:
Capital - Direct Labor 387,200
Capital - Labor Allocation (7%) 422,705
Capital - Supplies & Services Allocation (7%) 247,168
Principal on Debt 570,000
Vehicle and Equipment Outlay 248,700
Total Other ExpenditureslOutlay: 1,875, 773
Income (Loss) wlOther Expenditures (2,245,353)
Contributed Capital 918,100 841,592 3,459,004 (2,617,412) 30,650
ITEM NO. 2.2
AGENDA REPORT
Meeting Date: July 14, 2009 Budgeted: N/A
To: Finance-Accounting Committee
Funding Source: N/A
From: Ken Vecchiarelli, General
Manager
Presented By: Sandi Van Etten, Senior Dept: Finance
Accountant
Reviewed by Legal: N/A
Prepared By: Sandi Van Etten, Senior CEQA Compliance: N/A
Accountant
Subject: Monthly Investment Report for May 2009
SUMMARY:
Government Code Section 53607, et, seq., requires the person delegated to invest funds to make a
quarterly report of the investments to the legislative body.
STAFF RECOMMENDATION:
That the Committee receive and file the Investment Report.
DISCUSSION:
Staff is submitting the May 2009 Monthly Investment Report for your review and approval. Staff will
submit a Quarterly Investment Report ending June 30, 2009 for Board action upon its approval by
the Finance-Accounting Committee.
PRIOR RELEVANT BOARD ACTION(S):
Monthly Investment Reports are presented to the Finance-Accounting Committee on a regular
basis. Quarterly Investment Reports are presented to the Board of Directors. The Investment
Report for the quarter ending March 31, 2009 was received and filed by the Board of Directors on
May 28, 2009.
ATTACHMENTS:
;escription: ype.
Agenda, 7-14 backup.doc investment backup 5-09 Backup Material
Invst_Rpt 5 09.xls C~ortfolio 5-09 Backup Material
Investment Report Summary
Below is a chart summarizing the yields as well as terms and maturities for the month of May
2009.
Avg. Portfolio Avg. Portfolio # of Avg. Term
Month Yield Without Yield With Days to of Portfolio
of 2009 Wells Capital Wells Capital Maturity in Days
May 0.36% 0.62% 123 45
Below is a chart comparing operating fund interest for current and prior fiscal years.
Actual Interest 05/31/08 05/31/09
Monthly, Operating Fund $ 691 $ 327
Year-to-Date, Operating Fund $28,209 $ 6,166
Budget 2007/2008 2008/2009
Interest Budget, Operating Fund, May YTD $78,837 $59,125
Interest Budget, Operating Fund, Annual $86,000 $64,500
Interest earned on investments is recorded in the Fund that owns the investment.
Investment Summary Comparison
The distribution of investments in the portfolio both in dollars and as a percentage of the total
portfolio by funds is as follows:
Fund Description Balance 05/31/09
Annexation $9,306,323 19.77%
Water Operating -8.10%
Water R&R 2,049,290 4.35%
Water Capital Projects 149,500 0.32%
Restricted for Debt Service 1,218,060 2.59%
COP Revenue Bond 2003 0 0.00%
COP Revenue Bond 2008 22,210,034 47.17%
Sewer Operating 1,487,461 3.16%
Sewer R&R 337,555 0.72%
Sewer Capital Projects 188,777 0.40%
ID1 4,275,610 9.08%
ID2 9,672,528 20.54%
$47,080,004 100.00%
Yorba Linda Water District
Investment Portfolio Report
May 31, 2009
Market % Percent Investment Maturity
Value Cost of Total Institution Yield Date Date
Cash & Checking Accounts:
$ 621,996 $ 621,996 Wells Fargo Bank N/A
1,200 1,200 Imprest Cash
$ 623,196 $ 623,196 1.32% Total 0.00%
Money Market Accounts:
$ 178,505 $ 178,505 Wells Fargo Money Market 0.30% N/A
- - Wells Fargo MM/Annexation 0.30%
$ 178,505 $ 178,505 0.38% Total 0.30%
$ 801,701 $ 801,701 1.70% Sub-total 0.07%
California Asset Mgmt. Program:
$ 6,686,710 $ 6,686,710 14.22% California Asset Mgmt. Program 0.60% N/A
Money Market Account:
$ 22,210,034 $ 22,210,034 US Bank 2008 Revenue Bond 0.30%
0 0 US Bank 2003 Revenue Bond 0.00% N/A
$ 22,210,034 $ 22,210,034 47.22% 0.30%
$ 29,698,445 $ 29,698,445 63.14% Sub Total Investments 0.36%
Individual Management Account:
$ 17,372,215 $ 17,339,682 36.86% Wells Capital Management 1.07% N/A
$ 47,070,660 $ 47,038,127 100% Total Investments 0.62%
Per Government Code requirements, the Investment Report is in compliance with the Yorba Linda Water District's
Investment Policy, and there are adequate funds available to meet budgeted and actual expenditures for the next
six months.
Sandi Van Etten, Senior Accountant
5/31/2009
ITEM NO. 3.1
AGENDA REPORT
Meeting Date: July 14, 2009
Subject: Monthly Portfolio Reports for June 2009
ATTACHMENTS:
YLWD Overview Pagel.pdf =VCM1 Backup Material
YLWD_SummaryPage2.pdf JCM2 Backup Material
YLWD Cash FlowPage3.pdf !4CM3 Backup Material
YLWD Holdings Page4.pdf JCM4 Backup Material
Account Overview
Yorba Linda Water District
Account #18611500
Funding Date: 10/25/2005
Portfolio Statistics as of: 6/30/2009
Account Characteristics:
Portfolio Yield to Maturity 1.10%
Total Unrealized Gains/(Losses) - Current: 15,030
Total Net Realized Gains/(Losses) - Since Inception: 2,243
Total Long-Term Investments: -
Total Short Duration Investments/Money Market Secs: 17,345,088
Total Market Value: 17,345,088
Total Number of Issues in the Portfolio: 22
MARKET DATA
Overnight Fed Funds Rate: 0.00%
6-Month T-Bill Yield: 0.34%
12-Month T-Note Yield: 0.55%
WELLS CAPITAL MANAGEMENT
Portfolio Summary Report
For the period : 06/01/09 to 06/30/09
Portfolio Characteristics
Market Value:
Unrealized G /L:
Yield To Maturity:
Portfolio Duration:
Avg. Days to Maturity:
Avg. Portfolio Credit Quality:
Market Data
Yields:
6 Month Treasury Bill:
2 Year Treasury Note:
5 Year Treasury Note:
Fed Funds Target:
Credit Quality*
Yorba Linda Water District
18611500
Portfolio Breakdown
17,345,088.15
Market Value
% of Account
15,030.37
0.28
Agency Discount Note
6,392,000.00
36.85%
Aa /AA
7.7%
Commercial Paper
2,396,950.69
13.82%
° °
Baa /BBB
Discount
499,000.00
2.88%
0.33 Years
0.16
Fixed Rate
947,423.60
5.46%
Not Rated
0.0%
Floating Rate
1,325,825.33
7.64%
140
Money Market Fund
4,065,030.76
23.44%
Aa1
0.04
Pending_Cash
- 318,236.23
- 1.83%
Fitch Ratings - Tertia rY
Treasury Obligation
1,027,773.00
5.93%
US Agency Fixed Rate
1,009,321.00
5.82%
Total
17, 345, 088.15
100.00%
06/30/09
05/31/09
0.34%
0.28%
1.11%
0.92%
2.56%
2.34%
0-0.25%
0 - 0.25%
Effective Maturity Distribution
o/n 2 to 90 91 to 180 181 to 1 year 1 to 2 years > 2 years
The above information is an estimate of certain investment calculations and does not represent your audited statement of record.
V.3L
P1 /MIG1/VMIG1 /A -1
16.7%
0.28
Aaa /AAA
48.6%
Aa /AA
7.7%
0.24
A/A
5.4%
Baa /BBB
0.0%
0.20
Other
0.0%
0.16
Cash /Overnights
21.6%
Not Rated
0.0%
0.12
100.0%
0.08
* Moody's Ratings - Primary
0.04
S &P Ratings - Secondary
Fitch Ratings - Tertia rY
000
o/n 2 to 90 91 to 180 181 to 1 year 1 to 2 years > 2 years
The above information is an estimate of certain investment calculations and does not represent your audited statement of record.
YORBA LINDA WATER DISTRICT
Statement of Cash Floccs/Earnings for June 2009
I - Beginning Period Balances As of 5/31/2(109
Total Original Cost 17 285,229
+ Net Anort/Accr to Date 54,453
=Adjusted Book Value: 17,339.682
+ Accrued Interest Receivable 9,344
+ Unrealized Gain/(Loss) 32,533
= Total Market Value Plus Accrued Interest 17,381,559
II: Period Income Earned
+ Ending Accrual 32,032
- Begininning Accrual (9,344)
+ Interest Received 1,786
- Interest Paid at Purchase (15,1 15)
+ Interest Received at Sale -
= Interest Earned in Period 9,359
+ (Anort)/Accr- This Period 6,459
= Monthly Portfolio Income $ 15,819
+ Contributions -
- Withdrawals -
+ Realized Gain/(Loss) -
- Fees Paid This Period (2,754)
- Prior- Period Unrealized Gain/Loss 32,533
+ End Of Period Unrealized Gain/Loss 15,030
+ Net Receipts/Deliveries in Kind 0.00
+ Adjustments 0.00
= Net Change to the Portfolio (13,798)
=Total Market Value Plus Accrued
Interest 17,377,L0
III: End of Period Balances As of 6/3(1/2(1(19
Total Original Cost 17,270,931
+ Net Anort/Accr to Date 59,127
= Adjusted Book Value 17,330,058
+ Accrued Interest Receivable 32,032
+ Unrealized Gain/(Loss) 15,030
= Total Market Value Plus Accrued
Interest 17,377,120
Reconciliation DI ffi rence: -
Wells Capital Management
Holdings Report
Securities Held as of: 6/30/09 on a Trade Date Basis
Identifier Credit Ratings Par Value Security Description Coupon Final
Maturity
Moody's S &P Fitch
I. Cash & Cash Equivalents (Original maturity of 90 days or less)
Cash
U.S. DOLLARS (318,236) PENDING CASH
Money Mkt Securities
Agency Discount Note
Commercial Paper
Yorba Linda Water District
18611500
Effective Days Duration Market Price Market Market Value Holdings as YTM at
Maturity to Eff Value + Accrued Percentage of Purchase
Maturity Interest Account or Reset
77619EUA6 P -1 A -1+ NR 500,000 ROMULUS FUNDING CORP 0.000 07/10/09 07/10/09
85520LUTO P -1 A -1 NR 450,000 STARBIRD FUNDING CORP 0.000 07/27/09 07/27/09
Money Market Fund
VP7000038 NR NR NR 4,065,031 WFADV MONEY MKT TR #645 0.416 07/01/09
Cash & Cash Equivalents Total: 4,696,795
II. Marketable Securities (Original maturity greater than 90 days)
IIA: Short Term Securities (Remaining maturity of less than 365 days)
Gov't Guaranteed - CP
(318,236) (318,236) -1.83%
10 0.03 99.980 499,898 499,898 2.88% 0.86%
27 0.07 99.963 449,834 449,834 2.59% 0.56%
1 0.00 100.000 4,065,031 4,066,834
4 0.01 4,696,526 4,698,329
06051 HUPO P -1 A -1 NR 500,000 BANK OF AMER CORP TLGP 0.000 07/23/09 07/23/09 23 0.06 99.800 499,000 499,000
Corporate Securities
Corporate Obligation
Fixed Rate
285659AE8 A2
A
A+
300,000
ELECTRONIC DATA SYSTEMS
7.125
10/15/09
10/15/09
617446DX4 A2
A
A
300,000
MORGAN STANLEY
8.000
06/15/10
06/15/10
Floating Rate
324,532
324,564
1.87%
0.70%
213
0.08
100.003
402479BZ1 A2
A
A
325,000
GULF POWER -SR NT
0.704
06/28/10
06/28/10
89233P3D6 Aal
AA
NR
500,000
TOYOTA MOTOR CREDIT CORP
2.304
01/29/10
01/29/10
91159HGP9 Aa3
A+
AA-
500,000
US BANCORP
1.407
05/06/10
05/06/10
Govt Securities
52
0.14
99.980
999,800
999,800
5.76%
3.02%
Agency Discount Note
0.52
99.830
798,640
798,640
4.60%
0.82%
205
313313MR6 AGY
AGY
AGY
1,000,000
FFCB
0.000
10/07/09
10/07/09
313385JB3 AGY
AGY
AGY
800,000
FHLB
0.000
07/13/09
07/13/09
313385KS4 AGY
AGY
AGY
1,000,000
FHLB
0.000
08/21/09
08/21/09
313385RK4 AGY
AGY
AGY
800,000
FHLB
0.000
01/05/10
01/05/10
313385SB3 AGY
AGY
AGY
1,000,000
FHLB
0.000
01/21/10
01/21/10
313385WR3 AGY
AGY
AGY
1,000,000
FHLB
0.000
05/11/10
05/11/10
313397LZ2 AGY
AGY
AGY
800,000
FHLMC
0.000
09/21/09
09/21/09
Treasury Obligation
912828DR8 TSY
TSY
TSY
1,000,000
UNITED STATES TREASURY
4.000
04/15/10
04/15/10
Commercial Paper
06737HXM6 P -1
A -1+
NR
450,000
BARCLAYS US FUNDING LLC
0.000
10/21/09
10/21/09
13170RVS3 P -1
A -1+
F -1+
500,000
CALYON NORTH AMERICA INC
0.000
08/26/09
08/26/09
23.44% 0.42
27.08% 0.47
2.88% 0.61
107
0.29
101.852
305,556
310,068
1.76%
2.12%
350
0.92
102.675
308,025
309,159
1.78%
1.93
363
0.25
99.856
324,532
324,564
1.87%
0.70%
213
0.08
100.003
500,016
502,032
2.88%
2.30%
310
0.10
100.255
501,277
502,371
2.89%
1.41
99
0.27
99.950
999,500
999,500
5.76%
2.00%
13
0.04
100.000
800,000
800,000
4.61%
2.99
52
0.14
99.980
999,800
999,800
5.76%
3.02%
189
0.52
99.830
798,640
798,640
4.60%
0.82%
205
0.56
99.810
998,100
998,100
5.75%
0.87
315
0.86
99.620
996,200
996,200
5.74%
0.55%
83
0.23
99.970
799,760
799,760
4.61%
0.71
289
0.78
102.777
1,027,773
1,036,188
5.93%
0.59
113
0.31
99.854
449,342
449,342
2.59%
0.99
57
0.16
99.958
499,790
499,790
2.88 %
1.11
The above information is an estimate of certain investment calculations and does not represent your audited statement of record. Page: 1 of 2
Holdings Report
Yorba Linda Water District
Securities Held as of: 6/30/09 on a Trade Date Basis
1861 1500
Identifier Credit Ratings
Par Value Security Description
Coupon
Final
Effective
Days
Duration
Market Price
Market
Market Value
Holdings as
YTM at
Maturity
Maturity
to Eff
Value
+ Accrued
Percentage of
Purchase
Maturity
Interest
Account
or Reset
Moody's S &P Fitch
83365RYL3 P -1 A -1 NR
500,000 SOCIETE GENERALE N AMER CP
0.000
11/20/09
11/20/09
143
0.39
99.617
498,087
498,087
2.87%
0.56%
Short Term Securities Total:
11,275,000
166
0.38
11,305,398
11,322,601
65.18%
1.38%
116: Long -Term Securities (Remaining maturity greater than 365 days)
Corporate Securities
Fixed Rate
073928W90 Aa3 A+ AA-
325,000 BEAR STEARNS CO INC
5.850
07/19/10
07/19/10
384
1.00
102.721
333,843
342,398
1.92%
2.30
Govt Securities
US Agency Fixed Rate
3128X8QT2 AGY AGY AGY
1,000,000 FHLMC
1.450
09/10/10
09/10/10
437
1.18
100.932
1,009,321
1,013,792
5.82%
0.78%
Long Term Securities Total:
1,325,000
424
1.13
1,343,164
1,356,190
7.74%
1.16%
Marketable Securities Total:
12,600,000
193
0.46
12,648,562
12,678,791
72.92%
1.35
Portfolio Total:
17,296,795
140
0.33
17,345,088
17,377,120
100.00%
1.10%
The above information is an estimate of certain investment calculations and does not represent your audited statement of record. Page: 2 of 2