ChandlerAssetManagement
Annual Cash Flow ‐ Example
Beg.Balance Jan‐18 Feb‐18 Mar‐18 Apr‐18 May‐18
LiquidFundBalance 95,542,961.00 94,422,259.00 93,301,557.00 92,180,855.00 91,060,153.00 89,939,451.00
Inflow
SalesTaxCollections 3,516,116 3,516,116 3,516,116 3,516,116 3,516,116
PropertyTaxCollections 10,507,259 10,507,259 10,507,259 10,507,259 10,507,259
Intergovernmental 10,264,623 10,264,623 10,264,623 10,264,623 10,264,623
OtherRevenues 7,919,282 7,919,282 7,919,282 7,919,282 7,919,282
Outflows
Personnel (12,778,319) (12,778,319) (12,778,319) (12,778,319) (12,778,319)
Operating&Maintenance (1,199,030) (1,199,030) (1,199,030) (1,199,030) (1,199,030)
ChargesforServices (1,597,717) (1,597,717) (1,597,717) (1,597,717) (1,597,717)
DebtService (1,093,706) (1,093,706) (1,093,706) (1,093,706) (1,093,706)
OtherExpenses (6,659,210) (6,659,210) (6,659,210) (6,659,210) (6,659,210)
Actual/ProjectedNetChange (1,120,702) (1,120,702) (1,120,702) (1,120,702) (1,120,702)
ProjectedLiquidBalance 94,422,259 93,301,557 92,180,855 91,060,153 89,939,451
ProjectedInvestedBalance 141,565,000 141,565,000 141,565,000 141,565,000 141,565,000
TotalProjectedBalance 235,987,259 234,866,557 233,745,855 232,625,153 231,504,451
ActualLiquidBalance 85,562,465 203,231,573 124,216,038 201,625,430 150,181,434
ActualInvestedBalance 141,565,000 146,645,000 146,645,000 146,645,000 149,645,000
TotalActualBalance 227,127,465 349,876,573 270,861,038 348,270,430 299,826,434
Difference (8,859,794) 115,010,016 37,115,183 115,645,277 68,321,983
Thissampleillustrationisbeingprovidedtodemonstratethetoolsonhowweanalyzecashbalances.Pleaserefertodisclosures attheendofthispresentation.