Property Operation Budget

Document Sample
Property Operation Budget Powered By Docstoc
					                                                          Annual Budget


    Sample Spreadsheet for Annual Budget Development

EXPENSE BUDGET O&M, General and Administrative
                                                              Prior Year       Current Year                  Current Year   Next Year   Next Year
                                                                                   Year to       Projected
                                                                                    Date          to Year    Projected       Changes
                                                                 Actuals           Actuals          End       Actuals       to Budget   Budget
    EXPENSES
        Operation and Maintenance
    Personnel Costs w/benefits                                                                                          0                        0

    Utilities - Power                                                                                                   0                        0
               Gas                                                                                                      0                        0
               Telephone                                                                                                0                        0
               Sewer                                                                                                    0                        0
    Chemicals, Treatment, and Monitoring                                                                                0                        0
    Outside Services - Operator, Backhoe, Equip Rentals                                                                 0                        0
    Small Equipment, Materials, and Parts                                                                               0                        0
    Purchased Water - Wholesale                                                                                         0                        0
    Transportation                                                                                                      0                        0

         General and Administrative
    Personnel Costs w/benefits                                                                                          0                        0
    Office Supplies-Postage, Paper, Copies                                                                              0                        0
    Insurance - Vehicles, Liability, Workers Comp                                                                       0                        0
    Customer Billing and Collection                                                                                     0                        0
    Income Tax                                                                                                          0                        0
    Fees - Permits                                                                                                      0                        0
    Property taxes or payments in lieu of taxes                                                                         0                        0
    Professional Services - Engr, Acctg, Legal                                                                          0                        0
    Regulatory fees                                                                                                     0                        0


    Depreciation (if appliable)                                                                                        0                         0
    Total Expenses (total lines 2A to 23A)                   $             -   $             -   $       -   $         - $          -   $        -




                                                             Page 1
                                                           Expense Budget Proj (A)




                                                                                                               Inflation Rate                              5%

      WORKSHEET A - EXPENSE BUDGET O&M, General and Administrative
                                                                   Current Year    Year 1         Year 2            Year 3           Year 4           Year 5
                                                                   Projected       Annual
                                                                    Actuals        Budget                      Projected Budget
1A        EXPENSES
2A            Operation and Maintenance
3A        Personnel Costs w/benefits                                          0             0              0                 0                0                0

4A        Utilities - Power                                                   0             0              0                 0                0                0
4B                   Gas                                                      0             0              0                 0                0                0
4C                   Telephone                                                0             0              0                 0                0                0
4D                   Sewer                                                    0             0              0                 0                0                0
5A        Chemicals, Treatment, and Monitoring                                0             0              0                 0                0                0
6A        Outside Services - Operator, Backhoe, Equip Rentals                 0             0              0                 0                0                0
7A        Small Equipment, Materials, and Parts                               0             0              0                 0                0                0
8A        Purchased Water - Wholesale                                         0             0              0                 0                0                0
9A        Transportation                                                      0             0              0                 0                0                0
10A
11A            General and Administrative
12A       Personnel Costs w/benefits                                          0             0              0                 0                0                0
13A       Office Supplies-Postage, Paper, Copies                              0             0              0                 0                0                0
14A       Insurance - Vehicles, Liability, Workers Comp                       0             0              0                 0                0                0
15A       Customer Billing and Collection                                     0             0              0                 0                0                0
16A       Income Tax                                                          0             0              0                 0                0                0
17A       Fees - Permits                                                      0             0              0                 0                0                0
18A       Property taxes or payments in lieu of taxes                         0             0              0                 0                0                0
19A       Professional Services - Engr, Acctg, Legal                          0             0              0                 0                0                0
20A       Regulatory fees                                                     0             0              0                 0                0                0
21A
22A
23A       Depreciation (if appliable)                                        0              0
24A       Total Expenses (total lines 2A to 23A)                   $         - $            - $            -    $            -   $            -   $            -




                                                   1bb211e4-b1b4-4a82-8002-ae6dff0fd417.xls
                                                                  Capital Budget (B)




      WORKSHEET B - CAPITAL BUDGET
                                                                                Current Year       Year 1           Year 2            Year 3           Year 4           Year 5
                                                                                 Projected         Annual
                                                                                  Actuals          Budget                        Projected Budget
1B                                                                     Capital Outlays
2B         New Capital Facilities
3B         Renewal and Replacement Facilities
4B         SDWA Facilities
5B
6B
7B
8B      Total Capital Outlays (total lines 2B to 7B)                            $         -    $            -   $            -    $            -   $            -   $            -
9B                                                                    Capital Sources
10B        Loan/Bond Proceeds
11B        Contributions/Connection Fees
12B        Draw from Replacement Reserve                                                   0                0                0                 0                0                0
13B        Grant Funds
14B        Working Capital (other savings accounts)
15B
16B
17B
18B     Total Capital Sources (total lines 10B to 17B)                          $         -    $            -   $            -    $            -   $            -   $            -
19B   NET CAPITAL OUTLAYS (line 8B less line 18B)                               $         -    $            -   $            -    $            -   $            -   $            -
20B                                                                     Debt Service
21B        Principal and Interest
22B
23B
24B
25B     Total Capital Financing (total lines 21B to 24B)                        $         -    $            -   $            -    $            -   $            -   $            -




                                                       1bb211e4-b1b4-4a82-8002-ae6dff0fd417.xls
                                                            Reserves Budget (C)




      WORKSHEET C - RESERVES BUDGET
                                                                          Current Year       Year 1           Year 2            Year 3           Year 4           Year 5
                                                                          Projected          Annual
                                                                           Actuals           Budget                        Projected Budget
1C          Reserve for Operations and Maintenance
2C         Annual Installment
3C
4C         Running Balance                                                           0                0                0                 0                0                0
5C         Target Balance
6C          Reserve for Emergencies
7C         Annual Installment
8C
9C         Running Balance                                                           0                0                0                 0                0                0
10C        Target Balance
11C         Reserve for Capital Improvement Projects
12C        Annual Installment
13C        Withdrawal (to line 12B)
14C        Running Balance                                                           0                0                0                 0                0                0
15C        Target Balance
16C         Reserve for Debt Service
17C        Annual Installment
18C
19C        Running Balance                                                           0                0                0                 0                0                0
20C        Target Balance
21C   TOTAL ANNUAL RESERVE INSTALLMENTS (total lines 2c,7c,12c,17c)       $         -    $            -   $            -    $            -   $            -   $            -
22C   TOTAL RUNNING BALANCE (total lines 4C, 9C, 14C, 19C)                $         -    $            -   $            -    $            -   $            -   $            -
23C   TOTAL TARGET BALANCE (total lines 5C, 10C, 15C, 20C)                $         -    $            -   $            -    $            -   $            -   $            -




                                                 1bb211e4-b1b4-4a82-8002-ae6dff0fd417.xls
                                                                      Revenue Analysis (D)




      WORKSHEET D - REVENUE ANALYSIS
                                                                            Current Year            Year 1           Year 2            Year 3           Year 4           Year 5
                                                                               Projected           Annual
                                                                                Actuals            Budget                         Projected Budget
1D          Revenue Requirements
2D        Total Expenses (line 24A)                                        $               -   $             -   $            -    $            -   $            -   $            -
3D        Total Capital Financing Debt Service (line 25B)                  $               -   $             -   $            -    $            -   $            -   $            -
4D        Total Annual Reserve Installments (line 21C)                     $               -   $             -   $            -    $            -   $            -   $            -
5D    TOTAL REVENUE REQUIREMENT (total lines 2D to 4D)                     $               -   $             -   $            -    $            -   $            -   $            -
6D        Number of Connections
7D        (000's) Gallons Sold
8D      Revenue Requirement per Number of Connections (line 5D/line 6D)         #DIV/0!            #DIV/0!       #DIV/0!           #DIV/0!          #DIV/0!          #DIV/0!
9D      Revenue Requirement per (000's) Gallons Sold (line 5D/line 7D)          #DIV/0!            #DIV/0!       #DIV/0!           #DIV/0!          #DIV/0!          #DIV/0!
10D         Revenue Sources
11D       Rate Revenue
12D       Other revenues (specify source)
13D
14D
15D   TOTAL REVENUE (total lines 11D to 14D)                               $               -   $             -   $       -         $       -        $       -        $       -
16D   BUDGET SURPLUS (DEFICIT) (line 15D less line 5D)                     $               -   $             -   $       -         $       -        $       -        $       -
17D     Total Revenue per Number of Connections (line 15D/line 6D)              #DIV/0!            #DIV/0!        #DIV/0!           #DIV/0!          #DIV/0!          #DIV/0!
18D     Total Revenue per (000's) Gallons Sold (line 15D/line 7D)               #DIV/0!            #DIV/0!        #DIV/0!           #DIV/0!          #DIV/0!          #DIV/0!




                                                             1bb211e4-b1b4-4a82-8002-ae6dff0fd417.xls
                                          Fiscal Year Statement (E)



XYZ Water System's fiscal year starts the first day of ____________ (month) and ends the last day

of _________________________(month).




                                 1bb211e4-b1b4-4a82-8002-ae6dff0fd417.xls
                                               Revenue projection




         WORKSHEET E - REVENUE PROJECTION
                                               Current Year Year 1          Year 2            Year 3           Year 4           Year 5
                                                Projected    Annual
                                                 Actuals     Budget                      Projected Budget
1E                     REVENUE
2E    OPERATING REVENUE
3E     Water rates
4E       Meter charge
5E       Water sales
6E       Shut off fees
7E       Bad check fees
8E       Reconnect fees
9E       Late charges
10E      New connection fees
11E                    Total operating revenue $          - $       -   $            -    $            -   $            -   $            -
12E
13E   NON-OPERATING REVENUE
14E    Interest
15E       Checking account
16E       Reserve accounts
17E    Deposits
18E       Meter deposits
19E    Sale of surplus property
20E    Other Income
21E               Total non-operating revenue $          -    $     -   $            -    $            -   $            -   $            -
22E
23E   TOTAL REVENUE                            $         -    $     -   $            -    $            -   $            -   $            -




                                                     Page 7

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:3
posted:7/22/2011
language:English
pages:7
Description: Property Operation Budget document sample