LongTerm Debt Capital Leases

1
Long-Term DebtCapital Leases
James D. Moore Senior Accountant Specialized
Accounting Division Auditor-Controllers Office
February 21, 2008
2
Objectives
Departments with County Debt Obligations
Capital Leases

• Review departmental year-end responsibilities for
  capital leases.
• Provide a checklist for convenient reference.
• Provide a useful tool for analyzing current year
  lease activity.

3
Departmental Year-end Responsibilities
Capital Lease Obligations

• Maintain pertinent supporting documentation.
• Update amortization (Excel worksheets) to reflect
  adjustments, deletions or additions.
• Submit to the Auditor-Controllers Office by May
  16, 2008.
• Submit appropriate documentation by fiscal
  year-end, June 30, 2008. No schedule Q. is
  needed any longer for your Capital Leases.

4
Checklist for your reference . . .
Capital Lease Obligations

• Use the query to obtain principal and interest
  payments. You can create your query from the
  sample attached.
• Reconcile the query to your Excel departmental
  amortization worksheet.
• Compare and adjust as needed. If your Excel
  report (worksheet) does not equal the query,
  correct the amortization as needed.
• Email query results and Excel lease amortization
  schedule to me by May 16, 2008.

5
Lets review how it was done in FY06-07.
County Capital Lease Obligations
6
The Tool (PeopleSoft Query) Cont
County Capital Lease Obligations
Select your dept. here (see next slide) Use
in-tree option.
For principal, use range 532500-532680. For
interest paid, use expense range 533700-533780.
7
The Tool (PeopleSoft Query) Cont
County Capital Lease Obligations
8
The Tool (PeopleSoft Query) Cont
County Capital Lease Obligations
9
People-Soft Query Screens (version 8.8 FRP8
Environment)
Departments with County Debt Obligations
Capital Leases

• Lets review examples of what the new screen
  shots look like now (FY07-08)
• Attached pages reflect version 8.8, People-Soft
  screenshots to aid in running new queries for
  County Capital Leases (principal and interest
  payments for FY07-08)

10
Departments with County Debt Obligations
Capital Leases
11
Departments with County Debt Obligations
Capital Leases
12
County Capital Lease Obligations
13
Departments with County Debt Obligations
Capital Leases
14
County Capital Lease Obligations
15
County Capital Lease Obligations
16
County Capital Lease Obligations
17
County Capital Lease Obligations
18
Contact InformationIf you require additional
assistance
County Capital Lease Obligations

• James D. Moore [phone] jdmoore_at_co.riversi
  de.ca.us
• Jerry Wood [phone]
• Jwood_at_co.riverside.ca.us