Loading...
HomeMy WebLinkAboutPalm Desert_ROPS1718 13017Successor Agency:Palm Desert County:Riverside Current Period Requested Funding for Enforceable Obligations (ROPS Detail) 17-18A Total (July - December) 17-18B Total (January - June) ROPS 17-18 Total A -$ -$ -$ B - - - C - - - D - - - E 22,517,091$ 16,715,788$ 39,232,879$ F 21,989,817 16,195,323 38,185,140 G 527,274 520,465 1,047,739 H Current Period Enforceable Obligations (A+E):22,517,091$ 16,715,788$ 39,232,879$ Name Title /s/ Signature Date Recognized Obligation Payment Schedule (ROPS 17-18) - Summary Filed for the July 1, 2017 through June 30, 2018 Period Enforceable Obligations Funded as Follows (B+C+D): RPTTF Redevelopment Property Tax Trust Fund (RPTTF) (F+G): Bond Proceeds Reserve Balance Other Funds Administrative RPTTF Certification of Oversight Board Chairman: Pursuant to Section 34177 (o) of the Health and Safety code, I hereby certify that the above is a true and accurate Recognized Obligation Payment Schedule for the above named successor agency. A B C D E F G H I J K L M N O P Q R S T U V W Bond Proceeds Reserve Balance Other Funds RPTTF Admin RPTTF Bond Proceeds Reserve Balance Other Funds RPTTF Admin RPTTF $ 765,794,865 $ 39,232,879 $ - $ - $ - $ 21,989,817 $ 527,274 $ 22,517,091 $ - $ - $ - $ 16,195,323 $ 520,465 $ 16,715,788 1 2002 Tax Allocation Refunding Bonds Issued On or Before 2/28/2002 4/1/2030 US Bank Semi-Annual Debt Service Payment 1 Y $ - $ - $ - 2 2003 Tax Allocation Bond Issue - $19,000,000 Bonds Issued On or Before 12/31/10 7/15/2003 4/1/2030 US Bank Semi-Annual Debt Service Payment 1 Y $ - $ - $ - 3 2004 Tax Allocation Bond Issue - $24,945,000 Bonds Issued On or Before 12/31/10 6/9/2004 4/1/2025 US Bank Semi-Annual Debt Service Payment 1 Y $ - $ - $ - 4 2006 Tax Allocation Bond Issue - $62,320,000 Bonds Issued On or Before 12/31/10 6/22/2006 4/1/2030 US Bank Semi-Annual Debt Service Payment 1 Y $ - $ - $ - 5 2007 Tax Allocation Bond Issue - $32,600,000 Bonds Issued On or Before 12/31/10 12/13/2006 4/1/2018 US Bank Semi-Annual Debt Service Payment 1 7,615,250 N $ 3,772,000 3,772,000 $ 3,772,000 $ - 7 2002 Housing Tax Allocation Bond Issue - $12,000,000 Bonds Issued On or Before 12/31/10 8/21/2002 10/1/2031 US Bank Semi-Annual Debt Service Payment 1-4 Y $ - $ - $ - 8 2007 Housing Tax Allocation Bond Issue - $87,056,348 Bonds Issued On or Before 12/31/10 1/25/2007 10/1/2027 US Bank Semi-Annual Debt Service Payment 1-4 Y $ - $ - $ - 9 Indian Springs Stipulated Agreement Litigation 2/27/2009 2/27/2039 Indian Springs Mobilehome Park Judgement related to ISMHP 1 7,933,129 N $ 139,674 69,837 $ 69,837 69,837 $ 69,837 10 L/M Housing Fund Loan SERAF/ERAF 6/30/2010 6/30/2017 Palm Desert Housing Authority 2009/10 SERAF Loan Repayment 1 2,576,305 N $ 2,576,305 1,288,153 $ 1,288,153 1,288,152 $ 1,288,152 14 Alessandro Alleyway Bond Funded Project – Pre- 2011 2/28/2011 6/30/2017 Prest Vuksic Architects Payments per existing contract for public parking improvements along commercial corridor. 1 N $ - $ - $ - 29 El Paseo Revitlization Improvement/Infrastructure 7/10/2008 6/30/2017 Forma Design, Inc Payments for existing contract for public improvements in the central business district and commercial corridor. 1 N $ - $ - $ - 31 Vested Pension Obligation- CalPERS Unfunded Liabilities 11/25/1981 11/25/2032 RDA Assigned Employees Obligation based on accrued leaves and current MOU. 1 640,277 N $ 426,850 213,425 $ 213,425 213,425 $ 213,425 32 Stipulated Judgement Case No. 51124 Litigation 11/20/1991 11/25/2032 Various Duties required under said court order. Desert Rose, Etc. PDHA subsidy for 1,100 Afford Units 221,173,384 N 38 Portola Wall & Sidewalk Imps Bond Funded Project – Pre- 2011 5/22/2008 6/30/2017 David Evans & Associates 15197 Payments on existing contract for public improvements relative to the Portola Avenue Wall and Sidewalk Relocation project. 1 N $ - $ - $ - 43 Agency Owned Properties Property Maintenance 7/1/2013 6/30/2017 Utilities, Maint Services, HOA Dues, Etc. Agency owned properties monthly carrying costs prior to disposition. 1 100,000 N $ 30,000 15,000 $ 15,000 15,000 $ 15,000 44 Additional Disclosures on TAB's Fees 7/1/2013 6/30/2017 Willdan Additional disclosures that will be required to report changes in the allocation of tax increment and the payment on tax allocation bonds due to AB 26. These disclosures would not have been necessary without this legislative change. 1 34,300 N $ 1,400 700 $ 700 700 $ 700 45 Bond Project Overhead Costs Project Management Costs 7/1/2013 6/30/2017 Various Costs associated with administration of bond funded projects. 1 N $ - $ - $ - 46 Alessandro Alley Frontage Rd Imps Bond Funded Project – Pre- 2011 1/1/2014 6/30/2017 TBD from Unspent Bond Proceeds Approved project pursuant to bond covenants dated 7/6/06 - (Eligible upon receipt of FOC) 1 N $ - $ - $ - 47 Core Commercial Parking Improvements Bond Funded Project – Pre- 2011 1/1/2014 6/30/2017 TBD from Unspent Bond Proceeds Approved project pursuant to bond covenants dated 7/6/06 - (Eligible upon receipt of FOC) 1 N $ - $ - $ - 48 President's Plaza Parking Lot Imps Bond Funded Project – Pre- 2011 1/1/2014 6/30/2017 TBD from Unspent Bond Proceeds Approved project pursuant to bond covenants dated 7/6/06 - (Eligible upon receipt of FOC) 1 N $ - $ - $ - 49 Undergrounding Utilities Bond Funded Project – Pre- 2011 1/1/2014 6/30/2017 TBD from Unspent Bond Proceeds Approved project pursuant to bond covenants dated 7/6/06 - (Eligible upon receipt of FOC) 1 N $ - $ - $ - 50 Portola Avenue Widening Bond Funded Project – Pre- 2011 1/1/2014 6/30/2017 TBD from Unspent Bond Proceeds Approved project pursuant to bond covenants dated 7/6/06 - (Eligible upon receipt of FOC) 1 N $ - $ - $ - 55 2002 Tax Allocation Refunding Bond Issue - $17,310,000 Bonds Issued On or Before 12/31/10 6/19/2002 8/1/2022 US Bank Semi-Annual Debt Service Payment 2 Y $ - $ - $ - 56 2003 Tax Allocation Bond Issue - $15,745,000 Bonds Issued On or Before 12/31/10 3/12/2003 8/1/2033 US Bank Semi-Annual Debt Service Payment 2 25,207,328 N $ 769,006 384,503 $ 384,503 384,503 $ 384,503 57 2006 Tax Allocation Bond Issue - $67,618,273 Bonds Issued On or Before 12/31/10 6/27/2006 8/1/2036 US Bank Semi-Annual Debt Service Payment 2 Y $ - $ - $ - 59 North Sphere Hotel land City/County Loans On or Before 6/27/11 3/23/1995 7/15/2038 City of Palm Desert Balance due Property Acquisition 2 5,500,000 N $ - $ - $ - 60 North Sphere Property Acquisition City/County Loans On or Before 6/27/11 3/13/1997 7/15/2038 City of Palm Desert Loan for Property Acquisition 2 2,055,000 N $ - $ - $ - 61 City Loan for formation of Project Area No. 2- 1986 City/County Loans On or Before 6/27/11 12/5/1986 7/15/2038 City of Palm Desert Formation of PA/Prop Acquisition 2 6,000,000 N $ - $ - $ - 62 L/M Housing Loan SERAF/ERAF 6/30/2010 6/30/2017 Palm Desert Housing Authority 2009/10 SERAF Loan Repayment 2 3,755,605 N 2,672,017 1,336,008 1,336,008 1,336,009 1,336,009 82 Well Sites Bond Funded Project – Pre- 2011 11/14/1996 6/30/2017 CVWD Payments on existing contracts related to the North area required future well sites. 2 N $ - $ - $ - 85 Vested Pension Obligation- CalPERS Unfunded Liabilities 7/15/1987 7/15/2038 RDA Assigned Employees Obligation based on accrued leaves and current MOU. 2 171,314 N $ 114,210 57,105 $ 57,105 57,105 $ 57,105 86 Stipulated Judgement Case No. 51124 Litigation 11/20/1991 7/15/2038 Various Duties required under said court order. Vineyards, Emerald Brook (Palm Desert 103) PDHA subsidy for 1,100 Afford Units 2 63,072,039 N Contract/Agreement Termination Date ROPS 17-18 Total 17-18B (January - June) 17-18A Total Palm Desert Recognized Obligation Payment Schedule (ROPS 17-18) - ROPS Detail July 1, 2017 through June 30, 2018 (Report Amounts in Whole Dollars) Item #Payee Description/Project Scope Project Area Total Outstanding Debt or Obligation Retired 17-18A (July - December) 17-18B Total Project Name/Debt Obligation Obligation Type Contract/Agreement Execution Date Fund Sources Fund Sources A B C D E F G H I J K L M N O P Q R S T U V W Bond Proceeds Reserve Balance Other Funds RPTTF Admin RPTTF Bond Proceeds Reserve Balance Other Funds RPTTF Admin RPTTF Contract/Agreement Termination Date ROPS 17-18 Total 17-18B (January - June) 17-18A Total Palm Desert Recognized Obligation Payment Schedule (ROPS 17-18) - ROPS Detail July 1, 2017 through June 30, 2018 (Report Amounts in Whole Dollars) Item #Payee Description/Project Scope Project Area Total Outstanding Debt or Obligation Retired 17-18A (July - December) 17-18B Total Project Name/Debt Obligation Obligation Type Contract/Agreement Execution Date Fund Sources Fund Sources 96 Portola @ I-10 Imps Bond Funded Project – Pre- 2011 12/8/2005 6/30/2017 Dokken Engineering 12823 Payments on existing contract related to the alignment of Portola Avenue to connect with the proposed new interchange on I-10. 2 N $ - $ - $ - 100 Additional Disclosures on TAB's Fees 7/1/2013 6/30/2017 Willdan Additional disclosures that will be required to report changes in the allocation of tax increment and the payment on tax allocation bonds due to AB 26. These disclosures would not have been necessary without this legislative change. 2 14,600 N $ 600 300 $ 300 300 $ 300 102 Bond Project Overhead Costs Project Management Costs 7/1/2013 6/30/2017 Various Costs associated with administration of bond funded projects. 2 N $ - $ - $ - 103 North Sphere Fire Station Bond Funded Project – Pre- 2011 1/1/2014 6/30/2017 TBD from Unspent Bond Proceeds Approved project pursuant to bond covenants dated 7/6/06 - (Eligible upon receipt of FOC) 2 N $ - $ - $ - 106 Undergrounding Utilities Bond Funded Project – Pre- 2011 1/1/2014 6/30/2017 TBD from Unspent Bond Proceeds Approved project pursuant to bond covenants dated 7/6/06 - (Eligible upon receipt of FOC) 2 N 107 2003 Tax Allocation Bond Issue - $4,745,000 Bonds Issued On or Before 12/31/10 7/21/2003 4/1/2033 US Bank Semi-Annual Debt Service Payment 3 Y $ - $ - $ - 108 2006 Tax Allocation Bond Issue - $15,029,526 Bonds Issued On or Before 12/31/10 6/27/2006 4/1/2041 US Bank Semi-Annual Debt Service Payment 3 Y $ - $ - $ - 109 L/M Housing Loan SERAF/ERAF 6/30/2010 6/30/2017 Palm Desert Housing Authority 2009/10 SERAF Loan Repayment 3 970,313 N 118 Vested Pension Obligation- CalPERS Unfunded Liabilities 7/17/1991 7/17/2042 RDA Assigned Employees Obligation based on accrued leaves and current MOU. 3 46,552 N $ 31,038 15,519 $ 15,519 15,519 $ 15,519 119 Stipulated Judgement Case No. 51124 Litigation 11/20/1991 7/15/2038 Various Duties required under said court order. Falcon Crest Afford Housing Dev - Homeowners at lots 1 through 93, et al. PDHA Subsidy for 1,100 Affordable Units 3 16,602,589 N 132 Additional Disclosures on TAB's Fees 7/1/2013 6/30/2017 Willdan Additional disclosures that will be required to report changes in the allocation of tax increment and the payment on tax allocation bonds due to AB 26. These disclosures would not have been necessary without this legislative change. 3 9,800 N $ 400 200 $ 200 200 $ 200 135 Bond Project Overhead Costs Project Management Costs 7/1/2013 6/30/2017 Various Costs associated with administration of bond funded projects. 3 N $ - $ - $ - 137 Undergrounding Utilities Bond Funded Project – Pre- 2011 1/1/2014 6/30/2017 TBD from Unspent Bond Proceeds Approved project pursuant to bond covenants dated 7/6/06 - (Eligible upon receipt of FOC) 3 N $ - $ - $ - 138 Portola Avenue Widening Bond Funded Project – Pre- 2011 1/1/2014 6/30/2017 TBD from Unspent Bond Proceeds Approved project pursuant to bond covenants dated 7/6/06 - (Eligible upon receipt of FOC) 3 N $ - $ - $ - 139 Falcon Crest Lot K Bond Funded Project – Pre- 2011 1/1/2014 6/30/2017 TDB One-time payment per existing contract for the cost of constructing a perimeter wall & all surrounding improvements including exterior landscaping, plans for drainage & discharge, power for well operation 3 N $ - $ - $ - 140 1998 $11,020,000 Tax Allocation Bond Issue Bonds Issued On or Before 12/31/10 2/24/1998 10/1/2028 US Bank Semi-Annual Debt Service Payment 4 Y $ - $ - $ - 141 2001 $15,695,000 Tax Allocation Bond Issue Bonds Issued On or Before 12/31/10 11/15/2001 10/1/2031 US Bank Semi-Annual Debt Service Payment 4 Y $ - $ - $ - 142 2006 $19,273,089 Tax Allocation Bond Issue Bonds Issued On or Before 12/31/10 7/13/2006 10/1/2034 US Bank Semi-Annual Debt Service Payment 4 Y $ - $ - $ - 143 L/M Housing Fund Loan SERAF/ERAF 6/30/2010 6/30/2017 Palm Desert Housing Authority 2009/10 SERAF Loan Repayment 4 2,657,239 N 157 Affordable Housing-Carlos Ortega Villas Bond Funded Project – Pre- 2011 4/8/2010 6/30/2017 Interactive Design Corp Payments per existing contract for a 72 unit affordable senior complex. 4 N $ - $ - $ - 159 Vested Pension Obligation- CalPERS Unfunded Liabilities 7/19/1993 7/19/2044 RDA Assigned Employees Obligation based on accrued leaves and current MOU. 4 150,213 N $ 100,146 50,073 $ 50,073 50,073 $ 50,073 160 Stipulated Judgement Case No. 51124 Litigation 11/20/1991 7/15/2038 Various Duties required under said court order. PDHA subsidy for 1,100 Affordable Units 4 49,236,464 N 165 Additional Disclosures on TAB's Fees 7/1/2013 6/30/2017 Willdan/RWG Additional disclosures that will be required to report changes in the allocation of tax increment and the payment on tax allocation bonds due to AB 26. These disclosures would not have been necessary without this legislative change. 4 14,700 N $ 600 300 $ 300 300 $ 300 168 Carlos Ortega Villas Bond Funded Project – Pre- 2011 7/1/2013 6/30/2017 To Be Determined Agreement to build wall as part of COV construction 4 N $ - $ - $ - 170 Bond Project Overhead Costs Project Management Costs 7/1/2013 6/30/2017 Various Costs associated with administration of bond funded projects. 4 N $ - $ - $ - 171 Carlos Ortega Villas Improvement/Infrastructure 1/1/2014 6/30/2017 TBD from Unspent Bond Proceeds Approved project pursuant to bond covenants - (Eligible upon receipt of FOC) HA N $ - $ - $ - A B C D E F G H I J K L M N O P Q R S T U V W Bond Proceeds Reserve Balance Other Funds RPTTF Admin RPTTF Bond Proceeds Reserve Balance Other Funds RPTTF Admin RPTTF Contract/Agreement Termination Date ROPS 17-18 Total 17-18B (January - June) 17-18A Total Palm Desert Recognized Obligation Payment Schedule (ROPS 17-18) - ROPS Detail July 1, 2017 through June 30, 2018 (Report Amounts in Whole Dollars) Item #Payee Description/Project Scope Project Area Total Outstanding Debt or Obligation Retired 17-18A (July - December) 17-18B Total Project Name/Debt Obligation Obligation Type Contract/Agreement Execution Date Fund Sources Fund Sources 172 Desert Pointe Rehabilitation Improvement/Infrastructure 1/1/2014 6/30/2017 TBD from Unspent Bond Proceeds Approved project pursuant to bond covenants - (Eligible upon receipt of FOC) HA N $ - $ - $ - 173 Undergrounding Utilities Bond Funded Project – Pre- 2011 1/1/2014 6/30/2017 TBD from Unspent Bond Proceeds Approved projects pursuant to bond covenants - (Eligible upon receipt of FOC) 4 N $ - $ - $ - 174 Buydown Subsidies for Low-Mod Housing OPA/DDA/Construction 1/1/2014 6/30/2017 TBD from Unspent Bond Proceeds Approved project pursuant to bond covenants - (Eligible upon receipt of FOC) HA N $ - $ - $ - 175 Sagecrest Rehabilitation Improvement/Infrastructure 1/1/2014 6/30/2017 TBD from Unspent Bond Proceeds Approved project pursuant to bond covenants - (Eligible upon receipt of FOC) HA N $ - $ - $ - 176 Project Area 1 Reserve for DS Reserves 6/22/2006 4/1/2030 Wells Fargo Bank Semi-Annual Debt Service Payment N 177 North Sphere Property Acquisition City/County Loans On or Before 6/27/11 3/23/1995 7/15/2032 City of Palm Desert Balance due Property Acquisition (Eligible upon receipt of FOC) 1 2,500,000 N $ - $ - $ - 178 North Sphere Property Acquisition City/County Loans On or Before 6/27/11 8/16/1999 7/15/2032 City of Palm Desert Balance due Property Acquisition (Eligible upon receipt of FOC) 1 4,163,940 N $ - $ - $ - 179 North Sphere Property Acquisition City/County Loans On or Before 6/27/11 8/16/1999 7/15/2038 City of Palm Desert Balance due Property Acquisition (Eligible upon receipt of FOC) 2 2,436,060 N $ - $ - $ - 180 El Paseo Multi Use Community Center Bond Funded Project – Pre- 2011 1/1/2014 6/30/2017 TBD from Unspent Bond Proceeds Approved project pursuant to bond covenants dated 7/6/06 - (Eligible upon receipt of FOC) 1 N $ - $ - $ - 181 North Sphere Regional Park Bond Funded Project – Pre- 2011 1/1/2014 6/30/2017 TBD from Unspent Bond Proceeds Approved project pursuant to bond covenants dated 7/6/06 - (Eligible upon receipt of FOC) 2 N $ - $ - $ - 182 Public Parking Facility Bond Funded Project – Pre- 2011 1/1/2014 6/30/2017 TBD from Unspent Bond Proceeds Approved project pursuant to bond covenants dated 7/6/06 - (Eligible upon receipt of FOC) 3 N $ - $ - $ - 183 President's Plaza Parking Lot Imps Bond Funded Project – Pre- 2011 1/1/2014 6/30/2017 TBD from Unspent Bond Proceeds Approved project pursuant to bond covenants dated 7/6/06 - (Eligible upon receipt of FOC) 3 N $ - $ - $ - 184 Community Facilities and Public Infrastructure Bond Funded Project – Pre- 2011 1/1/2014 6/30/2017 TBD from Unspent Bond Proceeds Approved projects pursuant to bond covenants - (Eligible upon receipt of FOC) 4 N $ - $ - $ - 185 Drainage Improvements Bond Funded Project – Pre- 2011 1/1/2014 6/30/2017 TBD from Unspent Bond Proceeds Approved project pursuant to bond covenants - (Eligible upon receipt of FOC) 4 N $ - $ - $ - 186 CLO Villas/Traffic Circle Improvements Bond Funded Project – Pre- 2011 1/1/2014 6/30/2017 TBD from Unspent Bond Proceeds Approved project pursuant to bond covenants - (Eligible upon receipt of FOC) 4 N $ - $ - $ - 187 Las Serenas Expansion Improvement/Infrastructure 1/1/2014 6/30/2017 TBD from Unspent Bond Proceeds Approved project pursuant to bond covenants - (Eligible upon receipt of FOC) HA N $ - $ - $ - 189 Project Area Administration Admin Costs 11/25/1981 7/19/2044 Various Allowable Costs per Admin Plan-staff, utililities, professional services, etc. 1-4 13,710,757 N $ 1,047,739 527,274 $ 527,274 520,465 $ 520,465 190 Costs Associated with Disposition of Assets Property Dispositions 7/1/2014 6/30/2017 City of Palm Desert Remediation of Health and Safety Issues and costs related to sale of properties owned by former RDA 1-4 400,000 N $ 70,000 35,000 $ 35,000 35,000 $ 35,000 191 El Paseo Revitlization - Ph. 2 Bond Funded Project – Pre- 2011 1/1/2015 6/30/2017 Various Approved project pursuant to bond covenants - (Eligible upon receipt of FOC) 1 N $ - $ - $ - 192 2017 Tax Allocation Refunding Bond Issue - $52,390,000 Bonds Issued After 12/31/10 1/23/2017 10/1/2033 US Bank Semi-Annual Debt Service Payment 1-4 73,441,683 N $ 5,237,000 2,632,925 $ 2,632,925 2,604,075 $ 2,604,075 193 2017 Tax Allocation Refunding Bond Issue - $140,130,000 Bonds Issued After 12/31/10 1/23/2017 10/1/2041 US Bank Semi-Annual Debt Service Payment 1-4 193,604,136 N $ 9,884,287 4,334,784 $ 4,334,784 5,549,503 $ 5,549,503 194 2017 Tax Allocation Refunding Bond Issue - $7,365,000 Bonds Issued After 12/31/10 1/23/2017 10/1/2031 US Bank Semi-Annual Debt Service Payment 1-4 10,146,032 N $ 856,719 516,385 $ 516,385 340,334 $ 340,334 195 2017 Tax Allocation Refunding Bond Issue - $45,815,000 Bonds Issued After 12/31/10 1/23/2017 10/1/2023 US Bank Semi-Annual Debt Service Payment 1-4 49,855,856 N $ 11,502,888 7,267,600 $ 7,267,600 4,235,288 $ 4,235,288 A B C E F G H I Other RPTTF Bonds issued on or before 12/31/10 Prior ROPS period balances and DDR RPTTF balances retained Prior ROPS RPTTF distributed as reserve for future period(s) Rent, grants, interest, etc. Non-Admin and Admin ROPS 15-16B Actuals (01/01/16 - 06/30/16) 1 Beginning Available Cash Balance (Actual 01/01/16) 92,316,865 4,794,381 - 1,231,950 285,852 *DDR Restricted Cash: UCR Bond Funds, Energy Investment, and Bond Funds Reimb by other Govt *Actual bals include prior period accruals. Total does not consider receivable/payable as this report is cash basis. 2 Revenue/Income (Actual 06/30/16) RPTTF amounts should tie to the ROPS 15-16B distribution from the County Auditor-Controller during January 2016 16,422,435 3,008,801 16,402,174 Other: Includes intererst and revenue generated from LRPMP Sales proceeds. 3 Expenditures for ROPS 15-16B Enforceable Obligations (Actual 06/30/16) 90,512,707 41,750 2,735,764 16,688,026 Other: Includes expenditures related to LRPMP Sales proceeds to CAC, ROPS, as well as red to balances retained for Energy/Legal pursuant to DDR. 4 Retention of Available Cash Balance (Actual 06/30/16) RPTTF amount retained should only include the amounts distributed as reserve for future period(s) 4,752,631 443,233 *DDR/Other Restricted Cash: UCR Bond Funds ($2,240,000)/Energy Investment ($1,594,000)/Bond Funds Reimb ($1,309,911)/($51,953)/Reso. 119 5 ROPS 15-16B RPTTF Balances Remaining No entry required 6 Ending Actual Available Cash Balance C to G = (1 + 2 - 3 - 4), H = (1 + 2 - 3 - 4 - 5) 18,226,593$ -$ -$ 1,061,754$ -$ Palm Desert Recognized Obligation Payment Schedule (ROPS 17-18) - Report of Cash Balances (Report Amounts in Whole Dollars) source is available or when payment from property tax revenues is required by an enforceable obligation. For tips on how to complete the Report of Cash Balances Form, see Cash Balance Tips Sheet. Fund Sources Comments Bond Proceeds Reserve Balance Cash Balance Information by ROPS Period Item #Notes/Comments 1 Part of DOF approved bond refunding anticipated to close on 1/31/17, pursuant to OB-153 and OB-154. 2 Part of DOF approved bond refunding anticipated to close on 1/31/17, pursuant to OB-153 and OB-154. 3 Part of DOF approved bond refunding anticipated to close on 1/31/17, pursuant to OB-153 and OB-154. 4 Part of DOF approved bond refunding anticipated to close on 1/31/17, pursuant to OB-153 and OB-154. 6 Part of DOF approved bond refunding anticipated to close on 1/31/17, pursuant to OB-153 and OB-154. 7 Part of DOF approved bond refunding anticipated to close on 1/31/17, pursuant to OB-153 and OB-154. 8 Part of DOF approved bond refunding anticipated to close on 1/31/17, pursuant to OB-153 and OB-154. 55 Part of DOF approved bond refunding anticipated to close on 1/31/17, pursuant to OB-153 and OB-154. 57 Part of DOF approved bond refunding anticipated to close on 1/31/17, pursuant to OB-153 and OB-154. 107 Part of DOF approved bond refunding anticipated to close on 1/31/17, pursuant to OB-153 and OB-154. 108 Part of DOF approved bond refunding anticipated to close on 1/31/17, pursuant to OB-153 and OB-154. 140 Part of DOF approved bond refunding anticipated to close on 1/31/17, pursuant to OB-153 and OB-154. 141 Part of DOF approved bond refunding anticipated to close on 1/31/17, pursuant to OB-153 and OB-154. 142 Part of DOF approved bond refunding anticipated to close on 1/31/17, pursuant to OB-153 and OB-154. 192 New Debt Service based on bond refunding anticipated to close on 1/31/17, purusant to OB-153 and OB-154 193 New Debt Service based on bond refunding anticipated to close on 1/31/17, purusant to OB-153 and OB-154 194 New Debt Service based on bond refunding anticipated to close on 1/31/17, purusant to OB-153 and OB-154 195 New Debt Service based on bond refunding anticipated to close on 1/31/17, purusant to OB-153 and OB-154 Palm Desert Recognized Obligation Payment Schedule (ROPS 17-18) - Notes July 1, 2017 through June 30, 2018