february, 2017

15febAll Day16RUS Financial Forecasting Workshop11140 Woodmen Road, Falcon, CO 80831

Event Details

E – RUS Financial Forecasting




Wednesday & Thursday,

February 15 & 16, 2017



7:30 am:  set up

8:00 am: class begins

4:00 pm: class ends



Mountain View Electric

11140 Woodmen Road

Falcon, CO  80831



Howard Barnes



There is no charge for attending, but you must register


To Register:

Contact Jen Hight at

(303) 455-2700 ext. 700 or jenhight@coloradorea.org


Registration Deadline:  February 13, 2017



A letter will be sent to all participants confirming their registration in the course.




If you have questions about this course contact Howard Barnes at (970) 481-2221 (mobile), or by e-mail at Howard.Barnes.co@gmail.com



I.               Introduction

A.             General Forecasting Discussion

B.             Utilizing and Moving About the Forecast Program


II.              Historical Data (1971 – 2015) And ASR Data File w/State Comparisons

III.            Consumers and KWh Sales

IV.            Retail Rates and Revenue

V.             Plant Additions

VI.            Input Data For “Primary Assumptions” Sheet

A.             General – TIER, DSC, General Funds and Balance Sheet

B.             Changes To Operating Revenue and Cash

C.             Expenses

D.             Cushion of Credit (Advance Payments)

E.             Interest Rates

VII.          Prior Loans

A.             Old Loans (2% and Pre-1983 5% Loans)

B.             Newer Loans (Post 1983 RUS Loans, Treasury, FFB, CFC, CoBank, etc)

C.             Controlling Interest Rates


VIII.         New Loans

A.             Control Whether to Borrow or not in any Individual Year

B.             Automatic Borrowing

C.             Manual Control of Borrowing

IX.            Checking the Results (Error Checking)

X.             Graphical Analysis

XI.            Forecast Scenarios and Sensitivities

A.        Use of Controls Other Than TIER:  DSC and Modified DSC

XII.        Summary




The primary objectives of this workshop will be to assist the Colorado RECs in preparing a 10-year financial forecast for their individual system as well as provide instructions in use of the Excel program furnished by RUS for this purpose. This training should result in the development of a base line forecast during these two days, with guidance as to how it might be subsequently revised to determine the impact of alternative scenarios desired to be analyzed by management or the board. Among the uses of the resulting forecast are: a) timing and need for new loan funds as well as a required document for such loan application; b) timing and need for future rate increase; c) impact of various capital credit retirement scenarios; d) assistance in developing annual operating and capital budgets; e) relative comparison of future projections together with historical performance, which is enhanced by the availability of data / graphs for years 1971-2015. Those attending will also be provided tips to better utilize Microsoft Excel software.


The following list of resource materials will be needed at this meeting:


1)    Year-end Form 7’s for 2013, 2014, 2015, and 2016 (if available).


2)    2017 Budget (including both operating and capital budgets, if available). If there are known modifications to specific budget amounts, this information would also be helpful.


3)    Year-to-date Form 7 (most recent month available) as well as for the same month from one year earlier. This should include statement of operations, balance sheet, and consumer kWh and revenue data.


4)    Most recent Load Forecast Study (or equivalent information), along with any desired modifications to be made to this information.


5)    Primary assumptions to be used for base case forecast including the following items. Note that different control levels can be used for each year of 10-year forecast period, 2017- 2026:


  1. a) TIER control level (a rate increase will be generated if TIER falls below this level).


  1. b) General funds control (either a specific dollar amount or percentage of total utility plant). This level triggers new borrowing should the general funds fall below this level.


  1. c) Composite investment rate for available general funds.


  1. d) Extent of unadvanced loan funds as of 12/31/16 (separated into RUS and other sources), along with information as to whether these funds will reimburse general funds (i.e. will they finance construction which was completed in a year prior to their advance).


  1. e) Extent of any short-term loan funds outstanding as of 12/31/16, including amount, when funds will be advanced and anticipated year to be repaid.


  1. f) For future loan funds, what proportion will be funded by RUS and other lenders. We will explain possible loan options in detail during class, so that an initial loan selection may be made, and subsequently revised as desired.


  1. g) Date(s) of most recent retail rate adjustment and to what extent rates were changed by rate category (percent increase or decrease).





  1. h) Estimates for “Other Electric Revenue” for years 2017-2026. This is shown on line 13 of Part O of the year-end Form 7.


  1. i) Plant investment estimates for each future year (2017-2026). This should be separated into distribution, transmission, general plant, headquarters (office and warehouse), and SCADA (as appropriate), as well as consumer and other contributions.


  1. j) Estimated amounts of capital credits to be both allocated and paid from others including CFC, Federated, etc., if applicable.


  1. k) Debt information including the following:


1)   Year-end (12/31/16) principal balances by individual notes.

2)   Date when each individual note was established.

3)   Original face amount of each individual note.

4)   Maturity date (final repayment) for each individual note.

5)   Interest rate for each individual note.

6)   Copy of RUS debt service statement, Form 696, for a date as close as

possible to year-end 2016. Copy of similar information for CFC, or other lender(s).


  1. l) What assumptions should be used for future year’s expenses including wholesale power, O&M, A&G, Consumer Accounting, Depreciation, etc? This will be discussed in detail during the meeting, including available options for handling these items.
  2. m) Amount of any RUS Cushion of Credit (advance payment) outstanding as of 12/31/16, including when this advance payment might be applied to debt service.



To be most effective during this workshop, as much of this information that can be brought with each system will facilitate completing these activities during the time available. If there are any questions about any of these items, please don’t hesitate to contact Howard Barnes, at (970) 481-2221 (mobile), or by e-mail at Howard.Barnes.co@gmail.com prior to this meeting. If you have an earlier forecast prepared for your system, you might consider bringing it to this meeting. However, this is not essential to your attendance.


Please arrange to either bring a notebook computer with you with Microsoft Excel software (any version).


We are confident that this meeting will help your system forecast its future performance and better anticipate what lies ahead. Looking forward to working with you during this workshop!


Howard W. Barnes, Consultant








Colorado Electric Educational Institute

Colorado Rural Electric Association



february 15 (Wednesday) - 16 (Thursday)


Mountain View Electric Offices

11140 Woodmen Road, Falcon, CO 80831

© Copyright - Colorado Rural Electric Association