## Uttoxeter Juniors FC Cash Flow Forecast 2024-25 

|Starting cash on hand<br>Cash on hand (beginning of mon<br>Cash Receipts|£    10,731.11|Starting date|Starting date|Jul 2024|Cash minimum balance aler|Cash minimum balance aler|Cash minimum balance aler|t £      3,000.00|t £      3,000.00|t £      3,000.00|t £      3,000.00|t £      3,000.00|t £      3,000.00|
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
||Actual<br>Actual<br>Actual|||Actual<br>Actual<br>Actual<br>Actual||||||||||
||July 2024|August 2024|###|October 2024|###|###|January 2025|February 2025|March 2025|April 2025|May 2025|June 2025|Ttl|
||th £    10,731.11|£     13,424.33|£     14,625.31|£    11,653.02|£    14,682.20|£      9,887.75|£    13,282.21|£    12,610.04|£    15,039.03|£    14,416.20|£    10,338.66|£    11,352.50|oa|
|||||||||||||||
|Membership subs - One of paym<br>Membership subs - Direct Debit<br>Sponsorship funds<br>Interest, other income<br>Loan proceeds<br>Contributions<br>Fundraising Committee Income<br>Total Cash Receipts<br>Total Cash Available<br>Cash Paid Out||||||||||||||
||e £      2,280.00|£       1,140.00|£          970.00|£         375.00|£                 -|£         190.00|£                 -|£                 -|£                 -|£                 -|£                 -|£                 -|£         4,955.00|
||£         210.00|£          494.67|£       2,457.67|£      4,058.64|£      3,326.35|£      3,321.81|£      3,308.70|£      3,421.71|£      3,320.43|£      3,196.61|£      3,248.19|£      2,988.25|£       33,353.03|
||£      3,725.32|£          801.39|£       1,671.91|£      1,331.59|£         300.00|£                 -|£                 -|£                 -|£         391.65|£         900.00|£                 -|£         850.00|£         9,971.86|
||£                 -|£                 -|£                  -|£                 -|£                 -|£                 -|£                 -|£                 -|£                 -|£                 -|£                 -|£                 -|£                   -|
||£                 -|£                 -|£                  -|£                 -|£                 -|£                 -|£                 -|£                 -|£                 -|£                 -|£                 -|£                 -|£                   -|
||£      1,587.81|£                 -|£          215.99|£         153.00|£      1,037.00|£         529.57|£           25.85|£         754.75|£         192.31|£      1,545.00|£      4,200.36|£      3,086.06|£       13,327.70|
||£      1,169.16|£          353.52|£                  -|£           94.00|£         115.00|£      2,662.17|£         813.72|£      1,042.18|£         383.94|£         332.77|£         507.52|£      1,347.92|£         8,821.90|
||£      8,972.29|£       2,789.58|£       5,315.57|£      6,012.23|£      4,778.35|£      6,703.55|£      4,148.27|£      5,218.64|£      4,288.33|£      5,974.38|£      7,956.07|£      8,272.23|£       70,429.49|
||£    19,703.40|£     16,213.91|£     19,940.88|£    17,665.25|£    19,460.55|£    16,591.30|£    17,430.48|£    17,828.68|£    19,327.36|£    20,390.58|£    18,294.73|£    19,624.73||
|||||||||||||||
|BJFL<br>Mid Stafs League<br>Match kits - Players<br>Coaches kit<br>Of pitch clothing - Players<br>Training Equipment<br>Team Contribution<br>Trophies<br>Tournament Entries<br>Ref Fees<br>Everyone Active<br>Elkes<br>ULT<br>Pitch Hire<br>IT Costs<br>FA Costs<br>DBS/Safeguarding Costs<br>Taxes and licences<br>Travel<br>Utilities<br>Wages (less emp. credits)<br>Other expenses<br>Other expenses<br>Other expenses<br>Miscellaneous<br>Subtotal<br>Owners’ withdrawal<br>Total Cash Paid Out<br>Cash on hand (end of month)<br>Other OperatingData||||||||||||||
||£                 -|£                 -|£            20.00|£           75.00|£                 -|£                 -|£      1,240.00|£           20.00|£           30.00|£         102.00|£      1,310.00|£                 -|£         2,797.00|
||£                 -|£                 -|£                  -||£           40.00|£         160.99|£           30.00|£           81.00|£           46.43|£           85.00|£                 -|£                 -|£            443.42|
||£      3,943.87|£                 -|£       3,356.28|£           94.80|£         963.36|£                 -|£                 -|£                 -|£                 -|£      1,579.94|£                 -|£         391.65|£       10,329.90|
||£                 -|£          423.87|£       1,151.45|£         462.04|£      1,021.72|£                 -|£           87.30|£           26.09|£                 -|£         360.94|£                 -|£         244.57|£         3,777.98|
||£                 -|£          306.00|£       1,865.05|£         767.72|£      1,569.94|£                 -|£           50.49|£                 -|£                 -|£      1,922.51|£                 -|£         942.24|£         7,423.95|
||£         672.39|£          323.20|£          422.02|£         119.88|£         100.46|£                 -|£           69.38|£         131.92|£         331.38|£           25.80|£      3,748.99|£         480.60|£         6,426.02|
||£           66.50|£            20.00|£          143.73|£           20.00|£         143.00|£         693.82|£                 -|£                 -|£         351.00|£         114.65|£                 -|£         355.00|£         1,907.70|
||£                 -|£                 -|£                  -|£                 -|£                 -|£                 -|£                 -|£                 -|£         150.00|£           92.08|£         170.00|£      2,797.44|£         3,209.52|
||£           30.00|£            30.00|£            40.00|£                 -|£                 -|£                 -|£           40.00|£                 -|£           35.00|£         105.00|£                 -|£           65.00|£            345.00|
||£                 -|£            14.00|£          245.00|£         403.00|£         250.00|£         305.00|£         225.00|£         295.00|£         632.00|£         360.00|£         173.00|£                 -|£         2,902.00|
||£         159.36|£                 -|£                  -|£           24.84|£         139.95|£         635.51|£      1,233.17|£      1,475.83|£         971.78|£      1,327.46|£         159.30|£         256.00|£         6,383.20|
||£           83.33|£          145.14|£          280.00|£         177.64|£           20.00|£           33.00|£           45.53|£                 -|£         379.98|£         142.21|£                 -|£           39.98|£         1,346.81|
||£      1,060.00||£          210.00|£         100.00|£      3,601.91|£         418.59|£         947.50|£         288.61|£         377.50|£         180.00|£         440.22|£         100.00|£         7,724.33|
||£                 -|£          235.00|£                  -|£         373.18|£         458.92|£         441.07|£         270.92|£                 -|£         140.37|£           50.48|£                 -|£                 -|£         1,969.94|
||£           29.40|£            35.39|£            35.39|£           54.00|£           64.71|£           64.51|£           64.51|£           62.99|£         259.96|£         169.37|£         582.40|£         144.83|£         1,567.46|
||£                 -|£                 -|£            24.00|£                 -|£                 -|£             9.94|£         199.99|£           44.73|£         507.78|£           75.00|£           12.00|£      1,154.49|£         2,027.93|
||£                 -|£                 -|£            50.00|£                 -|£           40.00|£           43.00|£                 -|£           52.50|£           79.01|£         221.52|£           63.50|£         100.00|£            649.53|
||£                 -|£                 -|£                  -|£                 -|£                 -|£                 -|£                 -|£                 -|£                 -|£                 -|£                 -|£                 -|£                   -|
||£                 -|£                 -|£                  -|£                 -|£                 -|£                 -|£                 -|£                 -|£                 -|£                 -|£                 -|£                 -|£                   -|
||£                 -|£                 -|£                  -|£                 -|£                 -|£                 -|£                 -|£                 -|£                 -|£                 -|£                 -|£                 -|£                   -|
||£                 -|£                 -|£                  -|£                 -|£                 -|£                 -|£                 -|£                 -|£                 -|£                 -|£                 -|£                 -|£                   -|
||£                 -|£                 -|£          349.00|£         270.95|£      1,078.63|£         473.66|£         316.65|£         281.86|£         618.97|£      3,092.96|£         270.00|£         283.33|£         7,036.01|
||£                 -|£                 -|£                  -|£                 -|£                 -|£                 -|£                 -|£                 -|£                 -|£                 -|£                 -|£                 -|£                   -|
||£                 -|£                 -|£                  -|£                 -|£                 -|£                 -|£                 -|£                 -|£                 -|£                 -|£                 -|£                 -|£                   -|
||£         234.22|£            56.00|£            95.94|£           40.00|£           80.20|£           30.00|£                 -|£           29.12|£                 -|£           45.00|£           12.82|£                 -|£            623.30|
||£      6,279.07|£       1,588.60|£       8,287.86|£      2,983.05|£      9,572.80|£      3,309.09|£      4,820.44|£      2,789.65|£      4,911.16|£    10,051.92|£      6,942.23|£      7,355.13|£       68,891.00|
|||||||||||||||
||||||||||||||£                   -|
||£      6,279.07|£       1,588.60|£       8,287.86|£      2,983.05|£      9,572.80|£      3,309.09|£      4,820.44|£      2,789.65|£      4,911.16|£    10,051.92|£      6,942.23|£      7,355.13|£       68,891.00|
||£    13,424.33|£     14,625.31|£     11,653.02|£    14,682.20|£      9,887.75|£    13,282.21|£    12,610.04|£    15,039.03|£    14,416.20|£    10,338.66|£    11,352.50|£    12,269.60||
|||||||||||||||
|Sales volume (pounds)<br>Accounts receivable balance<br>Bad debt balance<br>Inventory on hand<br>Accounts payable balance<br>Depreciation||||||||||||||
|||||||||||||||
|||||||||||||||
|||||||||||||||
|||||||||||||||
|||||||||||||||
|||||||||||||||





## Uttoxeter Juniors FC - Cash Flow Chart 

|Month|Cash on hand||£0<br>£2,000<br>£4,000<br>£6,000<br>£8,000<br>£10,000<br>£12,000<br>£14,000<br>£16,000|Jul<br>Aug<br>Sep<br>Oct<br>Nov<br>Dec<br>Jan<br>Feb<br>Mar<br>Apr<br>May<br>Jun|
|---|---|---|---|---|
|July 2024|£           10,731.11||||
|August 2024|£           13,424.33||||
|September 2024|£           14,625.31||||
|October 2024|£           11,653.02||||
|November 2024|£           14,682.20||||
|December 2024|£             9,887.75||||
|January 2025|£           13,282.21||||
|February 2025|£           12,610.04||||
|March 2025|£           15,039.03||||
|April 2025|£           14,416.20||||
|May 2025|£           10,338.66||||
|June 2025|£           11,352.50||||



