90 likes | 257 Views
Long-Term Debt Capital Leases. Presented by James D. Moore April 21, 2005. Departments with County Debt Obligations & Capital Leases. Objectives. Review departmental year-end responsibilities for capital leases. Provide a checklist for convenient reference.
E N D
Long-Term DebtCapital Leases Presented by James D. Moore April 21, 2005
Departments with County Debt Obligations & Capital Leases Objectives • Review departmental year-end responsibilities for capital leases. • Provide a checklist for convenient reference. • Provide a useful tool for analyzing current year lease activity.
Capital Lease Obligations Departmental Year-end Responsibilities • Maintain pertinent supporting documentation. • Update amortization (Excel worksheets) to reflect adjustments, deletions or additions. • Submit to the Auditor-Controller’s Office by May 17, 2005. • Submit appropriate documentation with schedule Q at fiscal year-end, June 30, 2005.
Capital Lease Obligations Checklist for your reference . . . • 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 17, 2005.
County Capital Lease Obligations The Tool (PeopleSoft Query)
County Capital Lease Obligations The Tool (PeopleSoft Query) Con’t… 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.
County Capital Lease Obligations The Tool (PeopleSoft Query) Con’t…
County Capital Lease Obligations The Tool (PeopleSoft Query) Con’t…
County Capital Lease Obligations Contact Information • James D. Moore (951) 955-9462 jdmoore@co.riverside.ca.us • Greg Nainani (951) 955-3828 gnainani@co.riverside.ca.us