wild west end internet co-op... a practical demonstration of elephant economics
    about wwe - accounts - projections - journal - netstat


projected 4 years with 1 new member  (also see projected 2 years, and 4 years with quit or inactive members)


 avg members                       3.6
 service months                                48
 member months                                           174

                      total     avg per     avg per    avg per
costs               to-date      member      month    mbr-month

 service cost       1590.00      438.62      33.12       9.14
 + equipment         170.67       47.08       3.56       0.98
                    -------      ------     ------     ------
 = costs total      1760.67      485.70      36.68      10.12
 - others income       0.00        0.00       0.00       0.00
                    -------      ------     ------     ------
 = members cost     1760.67      485.70      36.68      10.12
 - members income  -1758.07     -484.98     -36.63     -10.10
                    -------      ------     ------     ------
 = members owe         2.60        0.72       0.05       0.01

       

                   total     avg per     avg per    avg per
assets           to-date      member      month    mbr-month

 members paid    2112.00      582.62      44.00      12.14
 + others paid      0.00        0.00       0.00       0.00
 - costs paid   -1760.67     -485.70     -36.68     -10.12
                 -------      ------     ------     ------
 = bank total     351.33       96.92       7.32       2.02
 + others owe       0.00        0.00       0.00       0.00
 - payables         0.00        0.00       0.00       0.00
 - mbr refunds   -353.93      -97.64      -7.37      -2.03
                 -------      ------     ------     ------
 = net money       -2.60        -.72       -.05       -.01
 + equipment      170.67       47.08       3.56       0.98
 - deprec        -160.00      -44.14      -3.33       -.92
                 -------      ------     ------     ------
 = net assets       8.07        2.23       0.17       0.05



costs           months   rate    cost     paid    owed           2007 feb  mar  apr  may  jun  jul  aug  sep  oct  nov  dec  2008 jan  feb  mar  apr  may  jun  jul  aug  sep  oct  nov  dec  2009 jan  feb  mar  apr  may  jun  jul  aug  sep  oct  nov  dec  2010 jan  feb  mar  apr  may  jun  jul  aug  sep  oct  nov  dec  2011 jan  feb

 service
                   48   33.12  1590.00                      cost  15        30   32   32   32   33   33   30   33   33   33        33   33   33   33   33   33   33   33   33   33   33   33        33   33   33   33   33   33   33   33   33   33   33   33        33   33   33   33   33   33   33   33   33   33   33   33        33   33
                                       1590.00              paid            30   30   30   30   30   33   33   26   27             66   32   33   33   33   33   33   33   33   33   33   33        33   68   33   33   33   33   33   33   33   33   33   33        33   33   33   33   33   33   33   33   33   33   33   33        33   33
 equipment
                   48    3.56   170.67                      cost 215  100                                         70.67                -95                                                             -120
                                        170.67              paid      100                                         70.67


members    share   use   rate   actual   bl/pd     owe           2007 feb  mar  apr  may  jun  jul  aug  sep  oct  nov  dec  2008 jan  feb  mar  apr  may  jun  jul  aug  sep  oct  nov  dec  2009 jan  feb  mar  apr  may  jun  jul  aug  sep  oct  nov  dec  2010 jan  feb  mar  apr  may  jun  jul  aug  sep  oct  nov  dec  2011 jan  feb

 dale & karen
            2.17   48    9.87   473.96  566.00 -102.04      bill  50        10   10   10   10   10   10   10   10   10   10        10   10   11   11   11   11   11   11   11   11   11   11        11   11   11   11   11   11   11   11   11   11   11   11        11   11   11   11   11   11   11   11   11   11   11   11        11   11
            27%   100%   98%            576.00              paid            70   10   10   10   10   10   10   10   10   10        10   10   11   11   11   11   11   11   11   11   11   11        11   11   11   11   11   11   11   11   11   11   11   11        11   11   11   11   11   11   11   11   11   11   11   11        11   11

 chris
            2.17   48    9.87   473.96  566.00 -102.04      bill  50        10   10   10   10   10   10   10   10   10   10        10   10   11   11   11   11   11   11   11   11   11   11        11   11   11   11   11   11   11   11   11   11   11   11        11   11   11   11   11   11   11   11   11   11   11   11        11   11
            27%   100%   98%            576.00              paid       50   20   10   10   10   10   10   10   10   10   10        10   10   11   11   11   11   11   11   11   11   11   11        11   11   11   11   11   11   11   11   11   11   11   11        11   11   11   11   11   11   11   11   11   11   11   11        11   11

 bob
            2.17   48    9.87   473.96  566.00 -102.04      bill  50        10   10   10   10   10   10   10   10   10   10        10   10   11   11   11   11   11   11   11   11   11   11        11   11   11   11   11   11   11   11   11   11   11   11        11   11   11   11   11   11   11   11   11   11   11   11        11   11
            27%   100%   98%            576.00              paid            60   10   20   10   10   10   10   10   10   10        10   10   11   11   11   11   11   11   11   11   11   11        11   11   11   11   11   11   11   11   11   11   11   11        11   11   11   11   11   11   11   11   11   11   11   11        11   11

 new member
            1.21   24   11.11   266.60  264.00    2.60      bill                                                                                                                                              11   11   11   11   11   11   11   11   11   11        11   11   11   11   11   11   11   11   11   11   11   11        11   11
            15%   50%   110%            264.00              paid                                                                                                                                              11   11   11   11   11   11   11   11   11   11        11   11   11   11   11   11   11   11   11   11   11   11        11   11

 kara & mark
            0.33   6    12.03    72.20  110.00  -47.80      bill  50        10                                      10   10        10   10   10
            4%    12%   119%            120.00              paid       50   50                                                     20

 neal
            0      0    12.34     0.00    0.00    0.00      bill  50                                                                   -25                                                              -25 
            0%     0%   122%              0.00              paid


non-members       use    rate     bill    paid     owe           2007 feb  mar  apr  may  jun  jul  aug  sep  oct  nov  dec  2008 jan  feb  mar  apr  may  jun  jul  aug  sep  oct  nov  dec  2009 jan  feb  mar  apr  may  jun  jul  aug  sep  oct  nov  dec  2010 jan  feb  mar  apr  may  jun  jul  aug  sep  oct  nov  dec  2011 jan  feb

 guests
                   0              0.00            0.00      bill
                   0%     0%              0.00              paid



history / proj      2007   feb    mar    apr    may    jun    jul    aug    sep    oct    nov    dec    2008   jan    feb    mar    apr    may    jun    jul    aug    sep    oct    nov    dec    2009   jan    feb    mar    apr    may    jun    jul    aug    sep    oct    nov    dec    2010   jan    feb    mar    apr    may    jun    jul    aug    sep    oct    nov    dec    2011   jan    feb

 member-months                     4      7      10     13     16     19     22     25     29     33            37     41     45     48     51     54     57     60     63     66     69     72            75     78     82     86     90     94     98    102    106    110    114    118           122    126    130    134    138    142    146    150    154    158    162    166           170    174
 costs / mbr-month               90.00  56.00  42.40  35.08  30.56  27.47  25.09  23.40  23.75  21.87         20.40  16.89  16.13  15.81  15.52  15.27  15.05  14.84  14.66  14.49  14.34  14.20         14.08  12.42  12.22  12.03  11.86  11.71  11.57  11.44  11.32  11.21  11.10  11.01         10.92  10.83  10.75  10.68  10.61  10.54  10.48  10.42  10.36  10.31  10.26  10.21         10.16  10.12
 income / mbr-month              72.50  41.70  31.87  26.24  22.89  20.68  19.10  17.93  17.45  16.84         16.30  15.49  15.13  14.84  14.59  14.37  14.18  14.00  13.85  13.71  13.58  13.46         13.35  12.42  12.17  11.95  11.76  11.59  11.43  11.30  11.17  11.06  10.96  10.87         10.78  10.71  10.63  10.57  10.51  10.45  10.39  10.34  10.30  10.25  10.21  10.17         10.14  10.10
 money / mbr-month              -17.50 -14.30 -10.53  -8.84  -7.67  -6.80  -5.99  -5.47  -6.30  -5.02         -4.10  -1.40  -1.00   -.96   -.93   -.90   -.87   -.84   -.81   -.79   -.77   -.74          -.72   0.00   -.05   -.08   -.11   -.12   -.14   -.14   -.14   -.14   -.14   -.14          -.13   -.13   -.12   -.11   -.10   -.09   -.08   -.07   -.06   -.05   -.04   -.03          -.02   -.01

 avg members                      4.00   3.50   3.33   3.25   3.20   3.17   3.14   3.12   3.22   3.30          3.36   3.42   3.46   3.43   3.40   3.37   3.35   3.33   3.32   3.30   3.29   3.27          3.26   3.25   3.28   3.31   3.33   3.36   3.38   3.40   3.42   3.44   3.45   3.47          3.49   3.50   3.51   3.53   3.54   3.55   3.56   3.57   3.58   3.59   3.60   3.61          3.62   3.62
 assets / avg member             56.83  51.58  47.86  41.56  35.38  29.55  24.95  19.75  14.47  15.35         15.64  25.69  26.68  24.29  22.00  19.80  17.70  15.69  13.78  11.96  10.23   8.59          7.03  13.13  11.09   9.35   7.88   6.61   5.53   4.62   3.85   3.20   2.66   2.21          1.85   1.58   1.37   1.22   1.13   1.10   1.11   1.16   1.26   1.39   1.55   1.75          1.97   2.23


notes

 internal calculations accurate to .000001, display amounts rounded to nearest cent.
 each member's % share of net assets = % share paid of total member costs.
 actual monthly rate for each member depends on months use of service - higher use, lower rate.
 members who owe more than their monthly rate may not have access to the service.
 negative debt = positive credit.  isp equipment costs waived after first 2 years.
 some isp service bills yet to be reconciled...
 please inform the treasurer of any errors or omissions.