Cash Flow Worksheet by aI7K1f0b

VIEWS: 11 PAGES: 9

									                                                                                 7/2/2012                                                    Page 1 of 9
                                                    Water Enterprise Fund - Cash Flow Data Entry Sheet
                                             Item                                           Data Entry                 Example Only
                                       Waterworks Name                                                                       Jones County PSA
                                        PWS ID number                                                                                  1-189-999
                   Project Name                                                                                 JONES GAP - Waterline extension
                   Estimated Project Completion / Service Start Date                                                            January 1, 2013
                   Fiscal Year End Date                                                                                            June 30, 2012
                   Project Cost:                                                                               $                    1,000,000.00
                   Residential Rates
                   Residential rate schedule dated:                                                                                 June 1, 2009
                      0-5000 gallons                                                                           $                          12.00
                   General Operations Information
                   Date of latest financial statements                                                                              June 9, 2011
Proposed Project




                   Monthly average residential consumption (gals)                                                                         4,862
                   Monthly average residential billing                                                         $                          26.31
                   Estimated number of project connections                                                                                  258
                   Projected new connections per year                                                                                         5
                   Project Associated Revenue
                   Water sales (Non-residential) projected (annual)                                            $                       3,240.00
                   Connection Fees (each)                                                                      $                       1,000.00
                   Fire Hydrant Fees                                                                           $                      20,000.00
                   Penalties                                                                                   $                       1,000.00
                   Project Associated Expenses
                   Salaries and Other Benefits (include savings from rehabilitation)                           $                      12,875.00
                   Power & Other Utilities (include savings from rehabilitation)                               $                       3,110.00
                   Chemical & Treatment                                                                        $                       2,755.00
                   Bulk Water Purchases                                                                        $                            -
                   Monitoring                                                                                  $                         500.00
                   Materials, Supplies and Parts                                                               $                         797.50
                   Other Operational Expense - Not Depreciation                                                $                         300.00
                   Entire Waterworks Enterprise Fund
Existing




                   Revenue                                                                                     $                    3,250,000.00
                   Expenses (Excluding Debt)                                                                   $                    2,800,000.00
                   Actual Debt Payments                                                                        $                       86,000.00
                   Other Planned Water Projects
Future




                   Projected start date of loan repayment                                                                        August 15, 2013
                   Revenue                                                                                     $                      75,000.00
                   Expenses                                                                                    $                      30,000.00
                   Rate Increase
Summary




                   Is rate increase needed: (Yes / No)                                                   Yes                                 No
                   Contact Information
                   Form Completed by:                                                                                                 Henry Ford
                   Contact Telephone Number                                                                                         555 555-3535
                                                                                                                                        Revised 2/4/2011
7/2/2012        Page 2 of 9




           Revised 2/4/2011
                                         7/2/2012                                                 Page 3 of 9

                   Instructions for completing this worksheet
Legal Name of the Waterworks system
The Public Waterworks System Identification Number
A brief descriptive name for the project
The estimated date that the project will be completed, and new service will begin
Date of the end of the fiscal year after the project is completed and service is initiated
The Project cost, the amount being requested from VDH-ODW

The dated or the last rate increase
An adjusted cost for residential users consuming 5000 gals/mon.

Date on the most recent audited financial statements used to complete this form
The average monthly residential consumption in gallons
Monthly average cost of residential water usage
Number of new connections to be installed as part of the project
Number of annual new connections estimated to be added as a result of this project

Total annual commercial, industrial and other water sales revenues
Cost of a single residential connection
Revenues to the waterworks from other departments for Fire Hydrants
Revenues generated from all penalties, late fees, etc.

Employee salaries and benefits, include any cost savings associated with this project
Utilities costs for operating the waterworks, include any savings from this project
Cost of supplies for water treatment, chemicals, carbon, etc
Cost of water purchases from another waterworks
Costs of monitoring the quality/quantity of raw, in-process or finished water
Expenses associated with other materials or equipment needed to operate
Any other expenses not included in the preceding line items

Revenue of the existing waterworks, taken from the financial statements
Expenses of the existing waterworks, taken from the financial statements
All debt payments associated with the waterworks system currently being repaid

Planned projects to begin in the next 12 months, the initiation date of loan repayment
Only revenues associated with the planned future project
Only expenses associated with the planned future project, including loan repayment

No, if Line 69 of CashFlowProjectLevel spreadsheet is positive after 6 years

Your Name, or the authorized representative of the waterworks
Telephone number to contact the individual named on line 42
                                                                                             Revised 2/4/2011
                           7/2/2012        Page 4 of 9




Revised: January 5, 2012




                                      Revised 2/4/2011
         Prepared: 7/2/2012                                                         WATER ENTERPRISE FUND                                                 Application Attachment # 20
                                                                                 6 YEAR CASH FLOW PROJECTION                                                               Page 5 of 9
                                                                                    FOR PROPOSED PROJECT

January 5, 2012---VDH Instructions--follow template and for application purposes use 3% for 20 years for Total Project Funds needed from VDH

Waterworks Name: 0                                Proposed Project:                                                      0
PWS ID number:      0                             Project Cost:                                     $               -
Expenses Inflation Assumption:                                  2.5% per year

                      Estimated Project Completion / Service Start Date                                 January 0, 1900
                                       Operational Year #:                                                          One          Two       Three       Four        Five           Six
                    Completed Project Operational Months (Current Fiscal Year)                                       0.0           12         12         12          12            12
                                         Year Ending:                                                   January 0, 1900      12/30/00   12/30/01   12/30/02    12/30/03      12/30/04
1. RESIDENTIAL
1. A--Residential Rate---from Schedule dated:         January 0, 1900
   0-5000 gallons               $          -

 1.B---Water Sales Information---from latest financial statements dated:          January 0, 1900
 Monthly average residential consumption (gals):                  0
 Monthly average residential billing:                                                        0.00                  0.00          0.00       0.00      0.00         0.00          0.00
 Projected total Initial (new) Connections for project:                                         0                     0             0          0         0            0             0
 Projected new connections per year:                                                            0                                   0          0         0            0             0
 Total Residential connections                                                                                                      0          0         0            0             0
 Projected annual residential water sales revenue:                                                                       0          0          0         0            0             0

2. Other Connections water sales Projected annual revenue (Explain):                                                     0         0          0          0            0             0
2. A.----Rate from Schedule dated:                       January 0, 1900
                     Residential rate is used.
2. B---Water Sales Information---from latest financial statements dated:          January 0, 1900
   10 connections with average monthly consumption of 10,000 gallons.
   No new connections anticipated.
3. Projected TOTAL annual water sales revenue:                                                                           0         0          0          0            0             0

A. REVENUES
    Water Sales                                                                                                          0         0          0          0            0             0
    Connection Fees (each)                        $                -                                                               0          0          0            0             0
    Bulk Water Sales
    Fire Hydrant Fees                                                                               $               -              0          0          0            0             0
    Interest                                                                                                                       0          0          0            0             0
    Penalties: Estimated at $200 per year                                                           $               -              0          0          0            0             0
    Other Income (Explain): No other income
         1)
         2)
                                                      TOTAL REVENUES                                                    $0        $0         $0         $0           $0            $0




         2e266cad-b094-4383-a2b2-336c66432cc0.xls                                                                                                                   Revised 2/4/2011
         Prepared: 7/2/2012                                                        WATER ENTERPRISE FUND                                                     Application Attachment # 20
                                                                                6 YEAR CASH FLOW PROJECTION                                                                   Page 6 of 9
                                                                                   FOR PROPOSED PROJECT
                       Estimated Project Completion / Service Start Date                          January 0, 1900
                                        Operational Year #:                                                   One                   Two       Three       Four        Five           Six
                     Completed Project Operational Months (Current Fiscal Year)                                0.0                    12         12         12          12            12
                                          Year Ending:                                            January 0, 1900               12/30/00   12/30/01   12/30/02    12/30/03      12/30/04

B. EXPENSES - OPERATIONAL                                                       Annual
    Labor (include savings for any rehabilitation project)                      $                -                        0            0         0          0            0             0
    Utilities (include savings for any rehabilitation project)                  $                -                        0            0         0          0            0             0
    Materials and Supplies                                                      $                -                        0            0         0          0            0             0
    Bulk Water Purchases                                                        $                -                        0            0         0          0            0             0
    Outside Service and Labor Costs                                             $                -                        0            0         0          0            0             0
    Equipment and Parts Repair                                                  $                -                        0            0         0          0            0             0
    Other Operational Expense (Explain) - Not Depreciation                      $                -                        0            0         0          0            0             0
                                                                                                                          0            0         0          0            0             0
      TOTAL EXPENSES ( Agree with section J of Application)                                                              $0           $0        $0         $0           $0            $0

C. Amount Available for Debt Payments( Total Revenues minus Total                                                        $0           $0        $0         $0           $0            $0
  Expenses)

D. DEBT EXPENSE To be incurred for proposed project
      VDH funding: Assume a loan at 3.0% for 20 years.                                                                    0            0         0          0            0             0
      Other                                                                                                               0            0         0          0            0             0

                                                    TOTAL DEBT EXPENSE                                                   $0           $0        $0         $0           $0            $0

E. Annual Cash Flow Balance ( "Amount Available for Debt Payments"                                                       $0           $0        $0         $0           $0            $0
   minus "Total Debt Expense")

F. Accumulated Cash Flow Balance                                                                                         $0           $0        $0         $0           $0            $0

G. Based on this Cash Flow Analysis, is a rate increase needed?          Yes
NOTE: Do not include exisitng connections in the analysis if they are already part of the exisitng Water Enterprise revenue stream.




         2e266cad-b094-4383-a2b2-336c66432cc0.xls                                                                                                                      Revised 2/4/2011
    Prepared: 7/2/2012                            WATER ENTERPRISE FUND      Application Attachment # 20
                                               6 YEAR CASH FLOW PROJECTION                    Page 7 of 9
                                                  FOR PROPOSED PROJECT




  Seven
      12
12/30/05




    0.00
       0
       0
       0
       0

      0




      0


      0
      0

      0
      0
      0



     $0




    2e266cad-b094-4383-a2b2-336c66432cc0.xls                                           Revised 2/4/2011
    Prepared: 7/2/2012                            WATER ENTERPRISE FUND      Application Attachment # 20
                                               6 YEAR CASH FLOW PROJECTION                    Page 8 of 9
                                                  FOR PROPOSED PROJECT

  Seven
      12
12/30/05


      0
      0
      0
      0
      0
      0
      0
      0
     $0

     $0



      0
      0

     $0

     $0


     $0




    2e266cad-b094-4383-a2b2-336c66432cc0.xls                                           Revised 2/4/2011
Prepared: 7/2/2012                                                                       WATER ENTERPRISE FUND                                                                       Application Attachment # 21
                                                                                          CASH FLOW PROJECTION                                                                                        Page9 of 9
                                                                                         FOR ENTIRE WATERWORKS



January 5, 2012----VDH instructions--follow template. -- -USE your latest Annual Financial Report Statements



Waterworks Name:              0                                Actual*           Projected*           Projected      Projected      Projected      Projected      Projected      Projected       Projected
Expenses Inflation Assumption: 2.5% per year                 Year Ending         Year Ending         Year Ending    Year Ending    Year Ending    Year Ending    Year Ending    Year Ending     Year Ending
Revenue Increase Assumption: 3.0% per year                ################ #####################      1/0/1900      12/30/1900     12/30/1901     12/30/1902     12/30/1903     12/30/1904      12/30/1905

New Project Name:
 A. Revenue                                                                                                     0              0              0              0              0              0                0
 B. Expenses                                                                                                    0              0              0              0              0              0                0
 C. Amount Available for Debt Payments                                                                          0              0              0              0              0              0                0
 D. Projected Debt Payments                                                                                     0              0              0              0              0              0                0
 E. Annual Cash Flow Balance                                                                                   $0             $0             $0             $0             $0             $0               $0
 F. Accumulated Cash Flow Balance                                                                              $0             $0             $0             $0             $0             $0               $0

Entire Waterworks Enterprise Fund:
Existing Operation
 A. Revenue                                                               0                      0              0              0              0              0              0              0                0
 B. Expenses                                                              0                      0              0              0              0              0              0              0                0
 C. Amount Available for Debt Payments                                    0                      0              0              0              0              0              0              0                0
 D. Actual Debt Payments                                                  0                      0              0              0              0              0              0              0                0
 E. Annual Cash Flow Balance                                             $0                     $0             $0             $0             $0             $0             $0             $0               $0
 F. Accumulated Cash Flow Balance                                        $0                     $0             $0             $0             $0             $0             $0             $0               $0

Other Future New Water Projects Planned
 A. Revenue                                                                                      0              0              0              0              0              0              0                0
 B. Expenses                                                                                     0              0              0              0              0              0              0                0
 C. Amount Available for Debt Payments                                                           0              0              0              0              0              0              0                0
 D. Projected Debt Payments                                                                      0              0              0              0              0              0              0                0
 E. Annual Cash Flow Balance                                                                    $0             $0             $0             $0             $0             $0             $0               $0
 F. Accumulated Cash Flow Balance                                                               $0             $0             $0             $0             $0             $0             $0               $0

Total System
 A. Revenue                                                               0                      0              0              0              0              0              0              0                0
 B. Expenses                                                              0                      0              0              0              0              0              0              0                0
 C. Amount Available for Debt Payments                                    0                      0              0              0              0              0              0              0                0
 D. Actual/Projected Debt Payments                                        0                      0              0              0              0              0              0              0                0
 E. Annual Cash Flow Balance                                             $0                     $0             $0             $0             $0             $0             $0             $0               $0
 F. Accumulated Cash Flow Balance                                        $0                     $0             $0             $0             $0             $0             $0             $0               $0

* Per Annual Financial Report Statements and Budget Projections




2e266cad-b094-4383-a2b2-336c66432cc0.xls                                                                                                                                                       Revised 2/4/2001

								
To top