• Home
  • About
  • Subscribe
  • LATIF
  • Conferences
  • Dashboard
  • Edit My Profile
  • Log In
  • Logout
  • Register
  • Edit this post

Room 151

  • 151 BRIEF

    What's New?

  • EAPF criticised for water company investments

    August 10, 2022

  • Welsh pension fund confirms £50m investment in clean energy

    August 10, 2022

  • Inflation ‘disastrous’ for local services, warns LGA

    August 10, 2022

  • Consultation opens into care charging reforms

    August 9, 2022

  • ADASS survey: ‘worst fears confirmed for adult social care’

    August 5, 2022

  • GMCA to unlock funds for home energy-efficiency upgrades

    August 4, 2022

  • Treasury
  • Technical
  • Funding
  • Resources
  • LGPS
  • Development
  • 151 News
  • Blogs
    • David Green
    • Agent 151
    • Dan Bates
    • Richard Harbord
    • Stephen Sheen
    • James Bevan
    • Steve Bishop
    • Cllr John Clancy
    • David Crum
    • Graham Liddell
    • Ian O’Donnell
    • Jackie Shute
  • Interviews
  • Briefs

Long-term treasury management

0
  • by David Green
  • in Blogs · David Green · Recent Posts
  • — 13 Jul, 2012

As a consultant, I’m regularly asked questions like “how long should we borrow for?”, “should we be repaying our debt?” and “should we be making long-term investments?”  One of the questions I ask in response is “what does your long-term cash flow forecast look like?”  The reply is often a variation of “well, we’re not entirely sure …”

It stands to reason that to make an informed decision about long-term borrowing and investment, you need to have some sort of long-term cash flow forecast.  If you have a neutral view on interest rates, you would ideally arrange your loans to mature in years of cash surplus.  But if you’ve got no idea whether payments might exceed receipts, or vice versa, in ten years’ time, and by roughly how much, you’re making treasury management decisions in the dark.  I know we can’t foretell the future perfectly and it’s true that things become less certain the further forward we look, but that shouldn’t stop us making some reasonable estimates.

Near-term cash flows are usually forecast on a daily basis, and with grants, precepts, council tax, business rates, payroll and other payment runs normally on fixed dates (and often for pre-determined amounts) it’s fairly easy to build a useful day to day forecast for the next couple of months.  That approach is fine for the current financial year, and can be modified slightly to prepare month by month estimates for the following year.  But we need a different approach to create a long-term year on year cash flow forecast.

For a start, we can assume that the revenue account is always going to balance in accounting terms – we then just need to adjust for non-cash items.  In the absence of any better information, creditors and general provisions might be assumed to rise with inflation each year; this will produce a net cash inflow to the authority as growing cash income is not reflected in growing cash expenditure until a later date.  Increasing debtors, where material, will offset this.

Another major non-cash item is MRP, the minimum revenue provision for repayment of debt.  Because this is charged to the revenue account but does not result in a cash payment (except for finance leases and PFI schemes), it should be treated as a net cash inflow.  As MRP on past capital expenditure is calculated on a formula, including a 4% reducing balance for pre-2008 assets, it can be estimated for many years into the future with some degree of certainty.

The final revenue account adjustment is for movements to or from reserves.  Cash held in specific reserves is presumably going to be spent at some point, creating a cash outflow; departments will have some plans for when this might happen.  On the other hand, it may be Council policy to slowly increase general reserves year on year, which will produce a net cash inflow.

We then need to look at the capital account, where cash flows and accounting entries will be quite different from each other.  Expenditure needs to be forecast when invoices are paid, some of which will be in the year following the capital plan entry; with substantial slippage there could be an even longer gap.  And for capital financing, we are interested in when we receive the grants, contributions and capital receipts, not the year that we apply them against expenditure.  Most authorities will have a three year capital programme; some approved schemes will run beyond that time frame and can be incorporated too.  Further into the future, I would only include items that are reasonably certain, such as structural maintenance on existing assets; don’t forget that we’re not really trying to plan today’s loans around schemes that may or may not get off the ground years ahead.  MRP on future expenditure will also need to be built into the revenue cash flow.

An alternative approach is to forecast future years’ balance sheets, focusing on the main line items.  It can be helpful to group these into the capital financing requirement, working capital, reserves and net debt; estimate the first three and the movement in net debt will then equate to the cash flow.  Non-cash items like pension deficits and revaluation reserves can be ignored in both halves of the balance sheet.

Whichever method you use, it’s never going to be 100% accurate, so don’t spend too much time trying to make it so.  You’re only looking for best guesses, and figures to the nearest million will be fine for all but the smallest authorities. This exercise will help to create the liability benchmark recommended by CIPFA in their new treasury risk management toolkit.  But more importantly, you’ll have a sound basis to your long-term treasury decision making, and that can’t be a bad thing.

David Green is Head of Sterling Consultancy Services, a provider of treasury management advice to local authorities and other not for profit organisations.  This is the writer’s personal opinion and does not constitute investment advice.  It should not be relied upon when making investment decisions.

Share

You may also like...

  • LGPS weighs up alternatives 26th Oct, 2021
  • LGPS Challenges: Balancing Realpolitik and responsible investment 1st Mar, 2021
  • How best to respond to local audit delays? 7th Feb, 2022
  • 2021 and a year of two halves 12th Jan, 2021

Leave a Reply Cancel reply

You must be logged in to post a comment.

  • 151 BRIEFS – WHAT’s NEW?

    • Inflation ‘disastrous’ for local services, warns LGA
    • Consultation opens into care charging reforms
    • ADASS survey: ‘worst fears confirmed for adult social care’
    • GMCA to unlock funds for home energy-efficiency upgrades
    • Levelling up committee calls for urgent boost to social care funding
  • Room151’s LGPS Roundtables

    Biodiversity
    Valuations & Risk
    LGPS Women

  • Room151’s LGPS Roundtables

    Biodiversity
    LGPS Women
    Valuations & Risk
  • Latest tweets

    Room151 11 hours ago

    Which LGPS pools and funds are attending the LGPS Investment Forum on Nov 2 & the LGPS Private Markets Forum on Nov 1st? Answer here: lnkd.in/eDHU8tuy pic.twitter.com/D3gd63Rh7F

    Room151 1 day ago

    LGPS and levelling up: nothing to fear but fear itself: There have been a number of objections to government plans for LGPS funds to invest 5% of their assets in local projects. But George Graham says these objections can be[...] dlvr.it/SWL7vt pic.twitter.com/ebwBEkZTy4

    Room151 1 day ago

    George Graham @SYpensions @bordertocoast channels his inner FDR in a call for local government pension funds to avoid the fear factor and embrace levelling up #LGPS #localgov room151.co.uk/local-governme…

    Room151 2 days ago

    Changes to rules on capital receipts raise wider questions: Stephen Kitching argues that DLUHC’s latest rule changes are part of a series following on from revisions to MRP guidance and the purchase of commercial property. He questions whether… dlvr.it/SWGqKC pic.twitter.com/Ycr5hWZDPk

    Room151 5 days ago

    ‘No ifs, no buts’: the Bank of England continues its battle with inflation: Partner Content: CCLA Investment Management’s Robert Evans discusses the MPC’s 0.5% increase in the Official Bank Rate and its ongoing commitment to the 2% inflation target… dlvr.it/SW7SNC pic.twitter.com/ryOzYRSNA9

    Room151 6 days ago

    DLUHC changes rules on flexible use of capital receipts: The levelling up secretary has written to all council leaders to amend the rules concerning the flexible use of capital receipts to fund transformation projects. In his letter, Greg Clark[...] dlvr.it/SW3jyX pic.twitter.com/KEhSSaMITl

    Room151 1 week ago

    Local audit and financial reporting: let’s take back control: Mazars’ Suresh Patel suggests three steps that auditors and council finance teams should take to help get financial reporting and local audit back on track. Following my recent appearance… dlvr.it/SW0PfV pic.twitter.com/miL7pjukce

    Room151 1 week ago

    The case for residential investment: income, impact and resilience: Partner Content: Emma Gullifer from Columbia Threadneedle discusses the options for pension funds looking to invest in residential property including the Build-to-Rent market.… dlvr.it/SVzKwN pic.twitter.com/hdgZ4zKt4H

    Room151 1 week ago

    Draft accounts: delays continue despite deadline dash: Dan Bates discusses the latest data on the publication of local authority accounts and examines why so many councils missed the 31 July deadline. Sunday 31 July 2022 was the[...] dlvr.it/SVx2ZT pic.twitter.com/gdELhD3Yis

  • Register to become a Room151 user

  • Previous story Murray Collins on TIF funding the Ravenscraig development
  • Next story What’s coming up next week

© Copyright 2022 Room 151. Typegrid Theme by WPBandit.

0 shares