• Home
  • About
  • Newsletters
  • Conference
  • TMS Links
  • Calendar
  • Log In
  • Register

Room 151

  • 151 BRIEF

    What's New?

  • London CIV launches sustainable equity fund

    April 19, 2018

  • Council funding boost for stadium for Cornwall

    April 18, 2018

  • Herts creates development joint venture

    April 18, 2018

  • Half of councils ‘draw down on reserves’

    April 18, 2018

  • Northants completes HQ sale

    April 18, 2018

  • Ashford adopts commercial property strategy

    April 18, 2018

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

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...

  • Consequences of Greek turmoil 9 May, 2012
  • Crunch time for central banks Crunch time for central banks 2 Dec, 2011
  • James Bevan: QE to persist while the euro remains ‘suboptimal’ 20 Jul, 2016
  • Risk roundup: councils adopt “widely different attitudes to security” Risk roundup: councils adopt “widely different attitudes to security” 5 Apr, 2012

Leave a Reply Cancel reply

You must be logged in to post a comment.

  • Register for the Room 151 Weekly Email Digest

  • Latest tweets

    Room 151 17 hours ago

    Herts agrees JV with Morgan Sindall to develop 500 homes: Hertfordshire County Council has signed a deal to create a 50/50 development joint venture with construction firm Morgan Sindall. The council will use its standalone company, Herts Living Ltd… dlvr.it/QQ5ZZg

    Room 151 22 hours ago

    #localgov @JRolfe67 #housing #regeneration twitter.com/SHJFitzgerald/…

    Room 151 22 hours ago

    London CIV launches sustainable equity fund room151.co.uk/brief/#london-… #localgov #lgps

    Room 151 22 hours ago

    #localgov twitter.com/Rebecca_DTZi/s…

    Room 151 23 hours ago

    Newham in danger of missing deadline to publish accounts: The London Borough of Newham is in danger of missing its deadline to publish audited financial statements due to a lack of capacity in its finance team, according to auditors.[...] dlvr.it/QQ3RFn pic.twitter.com/S35NTpUMSJ

    Room 151 1 day ago

    Enfield funds new housing association with right to buy receipts: The London Borough of Enfield has agreed to fund the creation of a new housing association in which it will take a minority stake, in order to spend £50m of[...] dlvr.it/QQ2hqH pic.twitter.com/Q8Dc5eQuyY

    Room 151 2 days ago

    Council funding boost for stadium for Cornwall room151.co.uk/brief/#council… #infrastructure #development

    Room 151 2 days ago

    Herts creates #development joint venture room151.co.uk/brief/#herts-c… #housing #property

    Room 151 2 days ago

    Half of councils ‘draw down on reserves’ room151.co.uk/brief/#half-of… #localgov #lgps #treasury

    Room 151 2 days ago

    Northants completes HQ sale room151.co.uk/brief/#northam… #localgov

    Room 151 2 days ago

    Ashford adopts commercial #property strategy room151.co.uk/brief/#ashford… #localgov #lgps #housing #treasury

    Room 151 2 days ago

    Government's terms for #businessrates review published room151.co.uk/brief/#terms-f… #localgov #mhclg

    Room 151 2 days ago

    Good chat with LPP's Chris Rule about #LGPS investment in #housing and #regeneration @LPFA1 room151.co.uk/interviews/lgp… #localgov

    Room 151 3 days ago

    #localgov #lgps twitter.com/kshackleton1/s…

    Room 151 3 days ago

    LGPS Pools Roundup: Access appoints Link, CIO for Border to Coast, Central launches funds, new chair for Northern Pool: ACCESS Link wins pooling contract ACCESS  has appointed Link Fund Solutions Ltd to establish and operate its authorised contractual… dlvr.it/QPq8BJ

    Room 151 3 days ago

    Five LGPS funds invest £100m in the private rented sector: Five pension funds agreed last year to commit £100m to a fund aimed at building and managing housing in the private rented sector. Room151 reveals how it came about. The[...] dlvr.it/QPq00D pic.twitter.com/MHjD2vWny2

    Room 151 3 days ago

    Changing the Guard: New Fed leadership and what’s ahead for the world’s most important central bank: Sponsored Article: A change in leadership often sparks intrigue from investors—particularly when the leader is the chair of the world’s most important… dlvr.it/QPpzwx pic.twitter.com/9JWmWJXLzq

    Room 151 3 days ago

    LGPS Q&A: Chris Rule of Local Pensions Partnership on housing and regeneration: Interest in housing and regeneration among institutional investors is growing. In an exclusive interview for Room151, Chris Rule discusses the Local Pensions Partnership’s… dlvr.it/QPpqBS pic.twitter.com/CwuKp8m2ur

    Room 151 3 days ago

    Jeff Houston: LGPS and investment cost transparency: The LGPS Advisory Board has been the first to sign up to a new disclosure template for investment costs. Jeff Houston explains what’s happening and why. It seems a very[...] dlvr.it/QPpq0Y pic.twitter.com/gxW8PinJpX

    Room 151 3 days ago

    Karen Shackleton: The cost conundrum of active managers: LGPS is in a better position to assess the cost of active managers, even if it remains difficult. It is common sense to take costs into account when judging the[...] dlvr.it/QPpfZ1 pic.twitter.com/gfVirgWcy2

  • Categories

    • 151 News
    • Agent 151
    • Blogs
    • Cllr John Clancy
    • David Crum
    • David Green
    • Development
    • Forum
    • Funding
    • Graham Liddell
    • Ian O'Donnell
    • Interviews
    • Jackie Shute
    • James Bevan
    • Jobs
    • LGPSi
    • Mark Finnegan
    • Recent Posts
    • Resources
    • Richard Harbord
    • Stephen Sheen
    • Steve Bishop
    • Technical
    • Treasury
  • Archives

    • 2018
    • 2017
    • 2016
    • 2015
    • 2014
    • 2013
    • 2012
    • 2011
  • Previous story Murray Collins on TIF funding the Ravenscraig development
  • Next story What’s coming up next week

© Copyright 2018 Room 151. Typegrid Theme by WPBandit.

We use cookies to ensure that we give you the best experience on our website. If you continue without changing your settings, we'll assume that you are happy to receive all cookies from this website.OK