HomeMy WebLinkAboutAFN Report
fA
l/tt
R5PORT
As of September
30, AFN had
3,182 CATV cus-
tomers. The cur-
rent plan target
for June 30,2005
is 3,275 therefore,
we need 93 addi-
tional customers
to meet plan tar-
gets for 04-05.
On the Internet
side, we had
3,575 residential
cable modem ac-
counts. The plan
target is 3,620
so, we need an
additional 45 ca-
ble modem cus-
tomers by June
30, 2005.
Page 1
3,600
3,575
3,550
3,525
3,500
3,475
3,450
3,425
3,400
AFN Net Cable Connections by Month FY 2004-
3,300 2j)_0_5-<PI~11 Y~ar 7)
3,250
3,200
3,150
3,100
3,050
3,000
EOY Jul Aug Sep Oct Nov Dee Jan Feb Mar Apr May Jun
c:::=:IActual per Billing
-<>- Target
EOY July
3,100 3,113
August
3,099
September
3,182
AFN Net ResidentiallSP Customers FY 2004-2005
(Plan Year 7)
EOY Jul Aug Sep Oct Nov Dee Jan Feb. Mar Apr May Jun
I r::::J Actual per Billing -<>- Targe~ \
EOY July August September
3,435 3,451 3,470 3,575
{if
V'v REPORT
C~sVt Flow
Co VlA. -p~ yLso V\,
This chart shows Cash In and
Cash Out by month. In July, inter-
nal borrowing and interest pay-
ments raised Cash In and Cash
Out above $400,000, August is
, skewed by refinancing and Septem-
ber incomes lag due to seasonal
impacts and shifts in receivables
(more) and payables (less) - both
causing less cash for that month.
MonthLy
cash BaLance
This chart compares actual Ending
Cash Balance (bold line) by month
with the Target Cash Balance (dash
line) extending to June 30,2005.
Each month the net impact as dis-
played in the Cash Flow Compari-
son Chart affects this chart.
Approx. $1,000,000 is needed by
the end of the year to pay debt and
operating expenses in July. The
rising target reflects the needed
cumulative affect of positive cash
flow each month.
Page 2
Cash Flow Comparison
1,000,000
900,000
800,000
700,000
600,000
500,000
400,000
300,000
200,000
100,000
,....
','-
,
,..-
- ~
- i:
c-r
.~ ~: ".
, ,
Jul Aug Sep Oct f\bv Dee Jan Feb rv1ar Apr May Jun
I 0 Cash In g Cash Out I
July August' September
Cash In
Cash Out
420,593
426,260
186,421
236,078
868,760
226,443
Monthly Cash Balance
1,200,000
1,000,000
800,000
,
.,.",
.,.",- ---
-----
600,000
400,000
200,000
Jul AJg Sep Oct Nov Dec Jan Feb Mar Apr May Jun
-Ending Cash Balance - - Target Cash Balance
July
Ending 1,181
August
643,498
September
593,841
Target 600,000
600,000
610,000
{if
V\..t R5PORT
MOV\,tVtL~ Ratto of
sales to 5X-peV\,c.ittuyeS
This chart provides an average
target ratio between revenues
and expenditures of J.J5jor the
year to generate the needed sav-
ingsfor debt service. This ratio
is an indicator that revenues
are sufficiently above expenses
to set aside funds needed to pay
debt service. Even though the
actual ratio grew in the first
quarter, it stopped short of 1. 00
requiring an average J. 23 for
the rest of the year.
opeyattoV\,aL ReVeV\,ues to
5x-peV\,Ses COVlA.-pa yts 0 V\,
This chart provides a look at what
is recorded each month. For a
better comparison, borrowing
(revenues) and issuance/debt ser-
vice costs (expenses) have been
removed. July was "favorable"
starting the new fiscal year with a
good customer base but recording
less in expenses this first month.
August's expenses included some
relating to July and annual costs
paid early in the year. September
was almost "neutral" with reve-
nues being consistent at the slow
season, awaiting fall and higher
customer counts. For the quarter,
the expenses exceeded revenues
by $2,891 or 1/2%.
Page 3
1.8
1.6
1.4
1,2
1
0.8
0.6
0.4
0.2
o
Monthly Ratio Sales to Expenditures
,,-
---
-
...... ---
-
Jul Aug Sep Oct N:lv cec Jan Feb War Apr Way Jun
Percent
Target
220,000
215,000
210,000
205,000
200,000
195,000
190,000
Percent Sales to Expenditures - -Target Ratio
July
.49
.95
August
.96
,95
September
,98
1.00
Operational Revenues to Expenses
COlf1)arison
Jul
Aug
Sep
10 Revenues: GJ Expenses: I
Revenues
Expenses
July
208,954
202,455
September
208,760
208,549
August
208,547
218,147