MUSCATINE POWER AND WATER
    2012 OPERATING BUDGETS
    SUMMARY
    ELECTRIC ENERGY
    Gross Generation
    Less: Plant Use
    Net Generation
    Wholesale Sales
    DISTRIBUTION - KWH
    Residential
    Commercial I
    Commercial II
    Industrial I
    Industrial II
    City Enterprise Funds
    Water & Communication Utilities
    Native System Sates
    City Lighting
    City Buildings
    Offline Power Plant Usage
    Losses & Cycle Billing
    TOTAL KWH DISTRIBUTED
    Purchased Power
    Steam Sales (1.000 lbs.)
    NATIVE SYSTEM ELECTRICAL
    REQUIREMENTS -KW
    Available Gen. Capacity
    Capacity - Steam Sales (net)
    Net Available Capacity
    Summer Peak
    Reserve Reqt. (12.4%)
    MUSCATINE POWER AND WATER - ELECTRIC UTILITY
    KWH GENERATION. DISTRIBUTION. AND CAPACITY
    For the Calendar Year 2012
    2012
    Budget
    Estimate
    % Incr.
    (Deer.)
    From
    2011
    2011
    Actual/
    Estimate
    1.114,117.391
    105,539,169
    6.1
    4.6
    1,049,679,742
    100.904,402
    1,008,578.222
    6.3
    948,775,340
    1.008.578.222
    6.3
    948,775,340
    100.297.045
    38,648,285
    103,496,391
    114,855,068
    443,510,381
    5.697,971
    15.967.436
    (6.0)
    (1.6)
    0.7
    (3.6)
    (0.6)
    3.6
    3.5
    106,693,696
    39,272,977
    102,816,648
    119,176,724
    446,157.638
    5.502.485
    15,428,797
    822.472.577
    (1-5)
    835,048,965
    2.028.118
    6,257.462
    887,040
    26.765.541
    2.9
    (3.0)
    8.4
    1,971.000
    6,450,840
    4,560.095
    24.698.375
    858,410.738
    (1.6)
    n
    872,729.275
    858.410.738
    (1.6) _
    872,729,275
    1,240,925
    (54.5) _
    2,726,816
    253,000
    22.800
    230.200
    140,000
    17.360
    —
    253,000
    22.800
    —
    230.200
    (1.5)
    12.7
    142,100
    15.400
    % Incr.
    (Deer.)
    From
    2010
    2010
    Actual
    (16.4)
    1,255.201.792
    (20.2)
    126.411.662
    (15.9)
    t
    1.128,790,130
    (15.9) _
    1,128,790,130
    (1.1)
    107,828,594
    1.3
    38,779,028
    1.7
    101,098,873
    (1.4)
    120,922,082
    (1.6)
    453.353,477
    (12.4)
    6,282,407
    (4,3)
    16.124,668
    (1.1)
    844,389,129
    (0.2)
    1,974.310
    2.8
    6,275,186
    599.5
    651,914
    2.8
    24.032.822
    (0.5)
    m
    877,323,361
    (0.5)
    m
    877,323,361
    (0.9)
    (2.3)
    0.0
    (2.5)
    3.0
    (6.5)
    2,750,241
    259.000
    22.800
    236.200
    137.900
    16.465
    Required Capacity
    157.360
    (0)
    157.500
    2.0
    EXCESS CAPACITY
    72.840
    0
    72.700
    (11.2)
    NATIVE SYSTEM LOAD FACTOR
    700%
    70.1%
    CAPACITY FACTOR - ELECTRIC
    50.0%
    470%
    154.365
    72.6%
    MUSCATINE POWER AND WATER - ELECTRIC UTILITY
    STATEMENTS OF REVENUES, EXPENSES, AND CHANGES IN NET ASSETS
    For Calendar Year 2012
    SALES OF ELECTRICITY
    Residential
    Commercial I
    Commercial II
    Industrial I
    Industrial II
    City Enterprise Funds
    Water & Communication Utilities
    Native System Sales
    Wholesale Sales
    ENERGY SALES
    STEAM SALES REVENUE
    OTHER REVENUE
    Rail Car Lease
    By-Product Revenue
    Miscellaneous Revenue
    TOTAL OTHER REVENUE
    OPERATING REVENUE
    OPERATING EXPENSE
    Production Fuel
    Purchased Power
    Emissions Allowance
    Operation
    Maintenance
    Depreciation
    TOTAL OPERATING EXPENSE
    OPERATINGINCOME (LOSS)
    NONOPERATING REVENUE (EXPENSE)
    Interest Income
    Interest Expense
    Other
    TOTAL
    NONOPERATING
    REVENUE
    (EXPENSE)
    NET INCOME(LOSS) BEFORE CAPITAL
    CONTRIBUTIONS & REVENUE
    ADJUSTMENT
    CAPITAL CONTRIBUTIONS
    CHANGE IN NET ASSETS BEFORE
    REVENUE ADJUSTMENT
    REVENUE ADJUSTMENT - EXTRA
    ORDINARY O&M
    CHANGE IN NET ASSETS
    BEGINNING NET ASSETS
    ENDING NET ASSETS
    Net Income(Loss) before Rev Adj to Total Income
    Debt Service Coverage before Transfers
    Debt Service Coverage after Transfers
    Minimum Target
    2012
    Budget
    Estimate
    %lncr.
    (Deer.)
    From
    2011
    2011
    Actual/
    Estimate
    %lncr.
    (Deer.)
    From
    2010
    2010
    Actual
    $8,673,820
    3,113,011
    6.207,431
    6.234,578
    20,395,752
    323.062
    760.492
    5.9
    (0.3)
    2.1
    3.1
    3.1
    6.5
    (0.4)
    $8,187,033
    3.123,506
    6.079,184
    6,047,875
    19,786,702
    303,441
    763.636
    3.6
    5.3
    4.9
    2.4
    2.7
    (8.9)
    (22)
    $7,905,137
    2,965,597
    5,797,915
    5,903.966
    19.274,788
    333.119
    780.463
    45.708.146
    3.2
    44.291,377
    3.1
    42,960.985
    35.303.820
    16.1
    30.418.938
    (25.0)
    40.535,035
    81.011.966
    8.4
    74.710.315
    (105)
    83.496.020
    6,151.798
    (35.6)
    9.550.948
    (13.9)
    11.089.012
    400,000
    255,070
    514.488
    3.1
    34.4
    (11.1)
    387.955
    189.829
    578.842
    50.9
    (37.2)
    5.7
    257.063
    302.299
    547.877
    1,169,558
    1.1
    1.156.626
    4.5
    1.107.239
    88.333,322
    3.4
    85,417.889
    (10.7)
    95.692,271
    24.910,202
    27.468,051
    0
    22.614,435
    11,448,660
    11,232.266
    11.8
    10.0
    (100.0)
    7.6
    (18.9)
    1.6
    22.281,163
    24.971,049
    460,003
    21,023.016
    14.114.759
    11.059.272
    (4.1)
    (8.6)
    N/A
    1.5
    52.3
    (22.3)
    23.240,870
    27,314.007
    659.927
    20.711.508
    9.268,167
    14.234.724
    97.673.614
    4.0
    93.909.262
    (1.6)
    95.429.203
    (9.340.292)
    -
    (8.491.373)
    (3.327.8)
    263,068
    1.471.682
    (1.126.961)
    7.9
    47.3
    1.363.542
    (765,201)
    (5.6)
    (48.7)
    (1,386.3)
    1,444.829
    (1.491,345)
    344,721
    -
    598.341
    (46.516)
    (8,995,571)
    N/A
    (7.893,032)
    (3.744.9)
    216.552
    —
    —
    9.185
    (88.4)
    79.102
    (8.995.571)
    N/A
    (7.883.847) (2,766.6)
    (2.304.824)
    —
    17.155.162
    —
    (11.300.395)
    9.271.315
    173.113.627
    163,842.312
    $161.813.232
    $173.113.627
    -100%
    -9.1%
    2Jfl
    £23
    &2Z
    1.50
    1.25
    295.654
    748.000
    1.043,654
    162.798.658
    $163.842.312
    0.2%,
    111
    MUSCATINE POWER AND WATER - WATER UTILITY
    WATER DISTRIBUTION AND PUMPING CAPACITY
    FOR THE CALENDAR YEAR 2012
    (1,000 Gallons)
    WATER DISTRIBUTION
    Contract Customers
    Power Plants
    Residential
    Commercial
    Total Metered Customers
    City Use, Line Loss, Cycle Billing
    TOTAL WATER PUMPED
    DAILY AVERAGE WATER PUMPED
    PEAK DAY WATER PUMPED
    Peak to Average Ratio
    PUMPING CAPACITY
    Total Available
    Less: Reserve (3/3/2 wells)
    FIRM CAPACITY
    EXCESS CAPACITY
    % Incr.
    % Incr.
    2012
    (Deer.)
    2011
    (Deer.)
    Budget
    From
    Actual/
    From
    2010
    Estimate
    2011
    Estimate
    2010
    Actual
    7,260,338
    770,000
    474.000
    380.000
    (0.8)
    (7.9)
    (2.8)
    (2.0)
    7,321,645
    835,782
    487,820
    387.687
    2.3
    (8.3)
    4.8
    0.9
    7,160,419
    911,742
    465,699
    384.144
    8,884,338
    544.000
    (1.6)
    0.4
    9,032,934
    541.976
    1.2
    1.2
    8,922,004
    535.537
    £d£?,338
    (1.5)
    9.574.910
    1.2
    9.457.541
    25.831
    (1.5)
    #?,2?3
    1.2
    25.911
    35,500
    0.4
    35.341
    9.5
    32.273
    1.37
    2.0
    12S
    8.2
    12§
    42,582
    (6,480)
    2.1
    41,688
    (6.480)
    (2.8)
    50.0
    42.883
    (4.320)
    36.102
    2.5
    35.208
    (8.7)
    38.563
    602
    (552.6)
    (133)
    (102.1)
    6.290
    MUSCATINE POWER AND WATER - WATER UTILITY
    STATEMENTS OF REVENUES. EXPENSES. AND CHANGES IN NET ASSETS
    FOR THE CALENDAR YEAR 2012
    % Incr.
    % Incr.
    2012
    Budget
    (Deer.)
    From
    2011
    Actual/
    (Deer.)
    From
    2010
    SALES OF WATER
    Estimate
    2011
    Estimate
    2010
    Actual
    Contract Customers
    Power Plants
    Residential
    Commercial
    $2,277,591
    333,964
    1.493.111
    469.753
    4.2
    2.1
    3.4
    3.4
    $2,185,625
    326.975
    1.444.556
    454.380
    4.9
    1.3
    5.7
    4.3
    $2,082,844
    322,651
    1,366.655
    435.735
    WATER SALES
    4.574.419
    3.7
    4.411.536
    4.8
    4.207.885
    OTHER REVENUE
    Penalty Revenue
    Merchandise & Job Sales-Net
    Miscellaneous Revenue-Net
    6.775
    10.912
    11.341
    (4.9)
    (3.5)
    (2.0)
    7.123
    11,307
    11.577
    1.1
    20.6
    12.0
    7,044
    9,379
    10.336
    TOTAL OTHER REVENUE
    29.028
    (3.3)
    30.007
    12.1
    26.759
    OPERATING REVENUE
    4.603.447
    3.6
    4.441.543
    4.9
    4.234.644
    OPERATING EXPENSE
    Operation
    Maintenance
    Depreciation
    3,033.813
    675.175
    642.029
    0.5
    8.7
    17.1
    3,018,553
    621.023
    548.288
    2.3
    14.9
    5.3
    2,951,414
    540,423
    520.845
    TOTAL OPERATING EXPENSE
    4.351.017
    3.9
    4.187.864
    4.4
    4.012.682
    OPERATING INCOME
    252,430
    (0.5)
    253,679
    14.3
    221,962
    INTEREST AND MISCELLANEOUS
    Interest Income
    Interest Expense
    Other
    5.492
    (118.982)
    0
    N/A
    N/A
    477
    (9.401)
    0
    (49.7)
    N/A
    948
    (13,226)
    0
    TOTAL INTERESTAND MISC.
    (113.490)
    N/A
    (8.924)
    (27.3)
    (12.278)
    NET INCOME BEFORE
    CAPITAL CONTRIBUTIONS
    138.940
    (43.2)
    244.755
    16.7
    209.684
    CAPITAL CONTRIBUTIONS
    383.935
    N/A
    48.000
    (47.9)
    92,081
    CHANGE IN NET ASSETS
    $522.875
    78.6
    $292,75.5
    (3.0)
    $301,765
    BEGINNING NET ASSETS
    13.683.963
    13.391.208
    13.089.443
    ENDING NET ASSETS
    $14,206,837
    $13,391,208
    Percent to Total Income
    3.0%
    5.5%
    5.0%
    DebtService Coverage
    6.35
    19.68
    19.47
    Minimum Target
    125
    MUSCATINE
    STATEMENTS OF
    Operating Revenue
    CATV:
    VOD & PPV
    Ad Sales
    All Other
    Data/Internet
    MAN/MME
    Miscellaneous
    Total Operating Revenue
    Operating Expense
    Operation
    Maintenance
    Depreciation
    Amortization
    Total Operating Expense
    Operating Income
    Interest and Miscellaneous
    Interest Income
    Interest Expense
    Other
    Total Interest and Miscellaneous
    Net Loss before Capital Contribution
    Capital Contribution
    Change in Net Deficit
    Beginning Net Deficit
    Ending Net Deficit
    Percent to Total Income
    Debt Service Coverage on Bank Debt
    Debt Service
    Coverage Including
    Debt Owed
    the Electric Utility
    Minimum Target
    POWER AND WATER - COMMUNICATIONS UTILITY
    REVENUES. EXPENSES. AND CHANGES IN NET DEFICIT
    FOR THE CALENDAR YEAR 2012
    % Incr.
    % Incr.
    2012
    (Deer.)
    2011
    (Deer.)
    Budget
    From
    Actual/
    From
    2010
    Estimate
    2011
    Estimate
    2010
    Actual
    $327,814
    7.3
    $305,638
    5.6
    $289,421
    402,795
    0.7
    400,000
    35.7
    294.803
    7,425,460
    6.7
    6.956,549
    4.8
    6,640,617
    3,615,292
    4.9
    3,446.862
    5.5
    3,267,288
    652,710
    59.4
    409,358
    20.7
    339.246
    105.397
    1.0
    104.376
    17.2
    89.063
    12.529.468
    7.8
    11.622.783
    6.4
    10.920.438
    8,033,162
    8.0
    7,437.477
    1.3
    7,343.509
    867,428
    1.8
    852.447
    1.8
    837,231
    2,483.510
    4.4
    2,379,865
    3.9
    2.290,464
    773.136
    (0.0)
    773.137
    0.0
    773.137
    12.157.235
    372.233
    6.2
    N/A
    11.442.926
    1.8
    179.858 (155.5)
    11.244.341
    (323.903)
    141,807
    (1,440,570)
    0
    (8.6)
    (3.5)
    N/A
    155,175
    (1,493,369)
    0
    1,585.8
    14.8
    N/A
    9,205
    (1,301,406)
    0
    (1.298.763)
    (2.9)
    (1.338.194)
    3.6
    (1.292.201)
    (926,530)
    (20.0)
    (1,158.337)
    (28.3)
    (1,616,104)
    0
    N/A
    13.584
    N/A
    0
    (926.530)
    (1,144,753)
    (1,616,104)
    (20.851.270)
    (19.706.517)
    (18.090.413)
    ($21,777,800)
    ($20.851.270)
    ($19,706,517)
    -7.3%
    -9.8%
    -14.8%
    3.43
    3.17
    64.05
    1£L
    1.49
    2.13
    125

    Back to top