Hillards takeover

Algorithmic Indexing

387 documents 1,432 pages

Forecast balance sheet and profit and loss account for the year to 30 April 1988   page 3 of 14   previous   next

Scan of page 3 of Forecast balance sheet and profit and loss account for the year to 30 April 1988

Below is what the machine read from this scan, three times over. They are kept separate rather than merged: where they disagree, the disagreement is itself worth seeing, and a single tidy transcription would hide it.

The left column is raw output. The right is the same text after the repairs that make it searchable — joining letter-spaced words, mending split ones.

Text already in the scan

                                                                    -     3     -

6 .    B r a n c h     E x p e n s e s

       Excluding                      internal  and                external     rents                  depreciation  and        vouchers
       inflation  in  this                    area          is forecast             at                 approximately    4.2%

7.     Total     expenditure                 (excluding                the     above                     headings),  after   deducting
       inflation  has                    risen  by         just       over     £lm       of     which          £0.7m    arises from             new
       store           openings.             Of the         additional            new        expenditure        of     £300,000            some
       £110,000 relates to increased credit card charges (based on the assumption
       that            such       card       usage will            increase),            £85,000 relates                     to    increased             repair
       costs                 and    £110,000             to increased             light/heat                 usage.
       The cost of the use of vouchers (£568,184) which increased considerably
       from 1986 to 1987 is forecast to reduce from 1987 levels (£842,000).

8 .    O v e r h e a d     E x p e n d i t u r e

       8.1 Advertising                  has             been    forecast          at     £2.2m,            an          increase    of  59%         over
                       the        1987        level,         whilst       overriders,                 which     have       in   the    majority       of
                       cases              been  identified                against        particular             suppliers,         have     increased
                            from        £4.75m  (1.5%          of      sales)       to   £5.79m            (1.6%     of sales).

             8.2 Long                 term   loan        interest has             been     calculated           on     the         loan     figures
                       shown            on   the         forecast      Balance           Sheet         based     on     interest          rates           which
                       reduce           from    11.7%        to     11.3%           in   the course             of        the   forecast         year
                       (present         interest             rate      payable           is              11.125%) .

        8 . 3    T h e        o t h e r     o v e r h e a d s   a r e        f o r e c a s t     t o   i n c r e a s e    b y   i n fl a t i o n  o f
                       approximately                    5.2%          and  by    a           further   approximately                       £1 .25m     covering
                       inter      alia       £370,000                     computer       services,        £78,000     training             costs,
                       £300,000         warehouse/motor                    wages         &      expenses        costs,             £460,000      Head
                       Office         Salaries             and  £25,000             relief          and     trainee costs.               A       major
                       reduction            of           £160,000      in     respect           of          pension          cont ributions       has
                       been       forecast              on  the    assumption                   that   the board     approves                    a
                       reduction         in     the         Scheme         funding              rate    arising     as     a       result       of
                       r e c e n t  R e v e n u e        c h a n g e s.

  9 .   E x t r a o r d i n a r y        I t e m s

        A n     a m o u n t       o f     £ 5 0 0 , 0 0 0   i n r e s p e c t     o f    ' t a k e    o v e r ' d e f e n c e   c o s t s h a s    b e e n
        i n c l u d e d .

1 0 .   B a l a n c e         S h e e t

        Taxation  has                     been    estimated               on     forecast         net        profits        and   capital
        expenditure                 at an       effective             rate     of        35% .   Long       term          loans    have    been
        projected as                  increasing            from    £6m          at        the  start      of    the    year       to £9.5m          by
        the     end           of       the   year.         The                  stock/creditor       ratio      is  expected        to     increase
        t o   1 8 3 . 5       b y   A p r i l  1 9 8 8 .

1 1 .  E a r n i n g s   p e r       s h a r e

    Forecast earnings per share are 18.9p based on a 34.6% actual tax charge;
        based on     a tax              charge of            35% the earning                        per    share     figure                      becomes 18.8p.
        On     actual tax               charge           this  is      an      increase of                   43.5%.

1 2 .   S e n s i t i v i t y

        11.1     From               the    above         analysis         it   can          be       seen      that the     major         sensitive
                           areas       are   sales         inflation,      sales         volume            and     gross        margins.
                       Sensitivity           can         be     assessed            below             the   following                  calculations
                           under each of                the         above     headings.

        1 1 . 2        S a l e s       i  n fl a t i o  n

                       F o r     e a c h  m o v e m e n t     i n      i  n fl a t i o n   o f  0 . 1 %     g r o s s   p r o fi t a n d      n e t  p r o fi t
                           would    adjust      by               £57,000.     An           increase    of   1% would             therefore         cause
                       net    profits        to          increase      by      £570,000.               This     assumes            that        cost
                       inflation        does    not               increase     by     a       comparable        amount.
- 3 -

6 . BranchExpenses

Excluding internal and external rents depreciation and vouchers
inflation in this area is forecast at approximately4.2%

7. Total expenditure (excluding the above headings), after deducting
inflation has risen by just over £lm of which £0.7m arises from new
store openings. Of the additional new expenditure of £300,000some
£110,000relates to increased credit card charges (based on the assumption
that such card usage will increase),£85,000 relates to increased repair
costs and £110,000 to increased light/heat usage.
The cost of the use of vouchers(£568,184) which increased considerably
from1986 to 1987 is forecast to reduce from1987 levels(£842,000).

8 . OverheadExpenditure

8.1Advertising has been forecast at£2.2m,an increase of 59%over
the 1987level, whilst overriders, which have in the majority of
cases been identified against particular suppliers, have increased
from£4.75m(1.5% of sales) to £5.79m (1.6% of sales).

8.2Long term loan interest has been calculated on the loan figures
shown on the forecast Balance Sheet based on interest rates which
reduce from11.7% to 11.3% in the course of the forecast year
(present interest rate payable is 11.125%) .

8 . 3Theotheroverheadsareforecasttoincreasebyin fl ationof
approximately5.2% and by a further approximately £1 .25m covering
inter alia £370,000computer services,£78,000 training costs,
£300,000 warehouse/motor wages & expenses costs,£460,000 Head
Office Salaries and £25,000relief and trainee costs. A major
reduction of £160,000 in respect of pension contributions has
been forecast on the assumption that the board approves a
reduction in the Scheme funding rate arising as a result of
recentRevenuechange s.

9 . ExtraordinaryItems

Anamountof£500 , 000inrespectof ' takeover ' defencecostshasbeen
included .

1 0 . BalanceSheet

Taxation has been estimated on forecast net profits and capital
expenditure at an effective rate of 35%.Long term loans have been
projected as increasing from£6m at the start of the year to £9.5m by
the end of the year. The stock/creditor ratio is expected to increase
to183 . 5byApril1988 .

1 1 . Earningspershare

Forecast earnings per share are 18.9p based on a 34.6%actual tax charge;
based on a tax charge of 35% the earning per share figure becomes 18.8p.
On actual tax charge this is an increase of 43.5%.

1 2 . Sensitivity

11.1From the above analysis it can be seen that the major sensitive
areas are sales inflation, sales volume and gross margins.
Sensitivity can be assessed below the following calculations
under each of the above headings.

1 1 . 2Salesin fl ation

Foreachmovementinin fl ationof0 . 1 % grosspro fi tandnetpro fi t
would adjust by £57,000. An increase of 1% would therefore cause
net profits to increase by £570,000.This assumes that cost
inflation does not increase by a comparable amount.

Read by machine highest quality of the three

     Branch      Expenses

     Excluding       internal     and   external     rents   depreciation           and vouchers
     inflation       in  this area      is  forecast     at  approximately        4.2%

     Total    expenditure     (excluding        the    above  headings),       after   deducting
     inflation       has    risen  by   just   over   £lm   of which     £0.7m    arises    from  new
     store    openings.       Of   the    additional     new  expenditure       of   £300,000    some
     £110,000       relates   to   increased      credit    card  charges      (based  on    the assumption
     that      such  card usage      will   increase),      £85,000     relates    to  increased
     costs      and  £110,000     to   increased     light/heat     usage.                         repair

    The cost of the use of vouchers (£568,184) which increased
     from      1986  to  1987 is     forecast     to  reduce    from                      considerably
                                                                        1987   levels  (£842,000).

     Overhead       Expenditure

        8.1   Advertising     has      been forecast      at  £2.2m,     an   increase    of 59%  over
              the   1987  level,       whilst   overriders,         which  have   in  the majority   of
              cases   been   identified        against   particular        suppliers,     have  increased
    from £4.75m 1.5% of sales) to £5.79m 1.6% of sales).

        8.2   Long   term  loan    interest     has   been    calculated       on  the loan    figures
    shown on the forecast Balance Sheet based on interest rates which
              reduce    from  11.7%     to  11.3%    in  the       course  of  the   forecast   year
              (present    interest      rate    payable    is   11.125%).

      8.3    The other           overheads are  forecast      to increase       by    inflation  of
             approximately        5.2%     and  by a     further approximately           £1.25m  covering
             inter    alia        £370,000 computer     services,       £78,000    training    costs,
             £300,000     warehouse/motor          wages  &   expenses      costs,     £460,000  Head
             Office     Salaries       and £25,000    relief     and    trainee    costs.    A  major
    reduction of £160,000 in respect of pension contributions has
             been    forecast      on  the  assumption      that    the   board    approves   a
             reduction     in     the  Scheme   funding     rate    arising     as a  result    of
             recent     Revenue    changes.

      Extraordinary      Items

    An amount of £500,000 in respect of 'take over' defence costs has been
    included.

10.   Balance    Sheet

    Taxation has been estimated on forecast net profits and capital
      expenditure     at  an  effective       rate   of  35%.       Long  term   loans have    been
      projected    as   increasing      from   £6m   at  the    start    of  the  year to    £9.5m by
      the end    of  the  year.       The        stock/creditor    ratio  is  expected    to  increase
      to 183.5    by  April   1988.

ll.   Earnings    per   share

   Forecast earnings per share are 18.9p based on a 34.6% actual tax charge;
      based   on  a  tax  charge     of   35%  the   earning     per    share  figure  becomes     18.8p.
      On actual     tax  charge    this    is  an      increase  of  43.5%.

12.   Sensitivity

      11.1   From   the   above   analysis      it   can  be  seen      that  the  major  sensitive
    areas are sales inflation, sales volume and gross margins.
             Sensitivity     can   be   assessed       below  the    following     calculations
             under   each  of      the  above   headings.

       11.2   Sales  inflation

              For each        movement  in  inflation     of  0.1%      gross  profit  and    net profit
              would  adjust   by   £57,000.        An increase      of    1%  would     therefore cause
             net  profits to      increase      by   £570,000.      This     assumes   that  cost
    inflation does not increase by a comparable amount.
Branch Expenses

Excluding internal and external rents depreciation and vouchers
inflation in this area is forecast at approximately4.2%

Total expenditure (excluding the above headings), after deducting
inflation has risen by just over £lm of which £0.7m arises from new
store openings. Of the additional new expenditure of £300,000some
£110,000relates to increased credit card charges (based on the assumption
that such card usage will increase),£85,000 relates to increased
costs and £110,000 to increased light/heat usage. repair

The cost of the use of vouchers(£568,184) which increased
from1986 to 1987 is forecast to reduce from considerably
1987levels(£842,000).

Overhead Expenditure

8.1Advertising has been forecast at£2.2m,an increase of 59%over
the 1987level, whilst overriders, which have in the majority of
cases been identified against particular suppliers, have increased
from£4.75m1.5% of sales) to £5.79m 1.6% of sales).

8.2Long term loan interest has been calculated on the loan figures
shown on the forecast Balance Sheet based on interest rates which
reduce from11.7% to 11.3% in the course of the forecast year
(present interest rate payable is 11.125%).

8.3 The other overheads are forecast to increase by inflation of
approximately5.2% and by a further approximately £1.25m covering
inter alia £370,000computer services,£78,000 training costs,
£300,000 warehouse/motor wages & expenses costs,£460,000 Head
Office Salaries and £25,000relief and trainee costs. A major
reduction of £160,000 in respect of pension contributions has
been forecast on the assumption that the board approves a
reduction in the Scheme funding rate arising as a result of
recent Revenue changes.

Extraordinary Items

An amount of £500,000 in respect of 'take over' defence costs has been
included.

10.Balance Sheet

Taxation has been estimated on forecast net profits and capital
expenditure at an effective rate of 35%.Long term loans have been
projected as increasing from£6m at the start of the year to £9.5m by
the end of the year. The stock/creditor ratio is expected to increase
to183.5by April1988.

ll. Earnings per share

Forecast earnings per share are 18.9p based on a 34.6%actual tax charge;
based on a tax charge of 35% the earning per share figure becomes 18.8p.
On actual tax charge this is an increase of 43.5%.

12.Sensitivity

11.1From the above analysis it can be seen that the major sensitive
areas are sales inflation, sales volume and gross margins.
Sensitivity can be assessed below the following calculations
under each of the above headings.

11.2Sales inflation

For each movement in inflation of 0.1%gross profit and net profit
would adjust by £57,000. An increase of 1% would therefore cause
net profits to increase by £570,000.This assumes that cost
inflation does not increase by a comparable amount.

Read by machine, contrast corrected

     Branch      Expenses

     Excluding       internal     and   external     rents   depreciation           and vouchers
     inflation       in  this area      is  forecast     at  approximately        4.2%

     Total    expenditure     (excluding        the    above  headings),       after   deducting
     inflation       has    risen  by   just   over   £lm   of which     £0.7m    arises    from  new
     store    openings.       Of   the    additional     new  expenditure       of   £300,000    some
     £110,000       relates   to   increased      credit    card  charges      (based  on    the assumption
     that      such  card usage      will   increase),      £85,000     relates    to  increased
     costs      and  £110,000     to   increased     light/heat     usage.                         repair

    The cost of the use of vouchers (£568,184) which increased
     from      1986  to  1987 is     forecast     to  reduce    from                      considerably
                                                                        1987   levels  (£842,000).

     Overhead       Expenditure

        8.1   Advertising     has      been forecast      at  £2.2m,     an   increase    of 59%  over
              the   1987  level,       whilst   overriders,         which  have   in  the majority   of
              cases   been   identified        against   particular        suppliers,     have  increased
    from £4.75m 1.5% of sales) to £5.79m 1.6% of sales).

        8.2   Long   term  loan    interest     has   been    calculated       on  the loan    figures
    shown on the forecast Balance Sheet based on interest rates which
              reduce    from  11.7%     to  11.3%    in  the       course  of  the   forecast   year
              (present    interest      rate    payable    is   11.125%).

      8.3    The other           overheads are  forecast      to increase       by    inflation  of
             approximately        5.2%     and  by a     further approximately           £1.25m  covering
             inter    alia        £370,000 computer     services,       £78,000    training    costs,
             £300,000     warehouse/motor          wages  &   expenses      costs,     £460,000  Head
             Office     Salaries       and £25,000    relief     and    trainee    costs.    A  major
    reduction of £160,000 in respect of pension contributions has
             been    forecast      on  the  assumption      that    the   board    approves   a
             reduction     in     the  Scheme   funding     rate    arising     as a  result    of
             recent     Revenue    changes.

      Extraordinary      Items

    An amount of £500,000 in respect of 'take over' defence costs has been
    included.

10.   Balance    Sheet

    Taxation has been estimated on forecast net profits and capital
      expenditure     at  an  effective       rate   of  35%.       Long  term   loans have    been
      projected    as   increasing      from   £6m   at  the    start    of  the  year to    £9.5m by
      the end    of  the  year.       The        stock/creditor    ratio  is  expected    to  increase
      to 183.5    by  April   1988.

ll.   Earnings    per   share

   Forecast earnings per share are 18.9p based on a 34.6% actual tax charge;
      based   on  a  tax  charge     of   35%  the   earning     per    share  figure  becomes     18.8p.
      On actual     tax  charge    this    is  an      increase  of  43.5%.

12.   Sensitivity

      11.1   From   the   above   analysis      it   can  be  seen      that  the  major  sensitive
    areas are sales inflation, sales volume and gross margins.
             Sensitivity     can   be   assessed       below  the    following     calculations
             under   each  of      the  above   headings.

       11.2   Sales  inflation

              For each        movement  in  inflation     of  0.1%      gross  profit  and    net profit
              would  adjust   by   £57,000.        An increase      of    1%  would     therefore cause
             net  profits to      increase      by   £570,000.      This     assumes   that  cost
    inflation does not increase by a comparable amount.
Branch Expenses

Excluding internal and external rents depreciation and vouchers
inflation in this area is forecast at approximately4.2%

Total expenditure (excluding the above headings), after deducting
inflation has risen by just over £lm of which £0.7m arises from new
store openings. Of the additional new expenditure of £300,000some
£110,000relates to increased credit card charges (based on the assumption
that such card usage will increase),£85,000 relates to increased
costs and £110,000 to increased light/heat usage. repair

The cost of the use of vouchers(£568,184) which increased
from1986 to 1987 is forecast to reduce from considerably
1987levels(£842,000).

Overhead Expenditure

8.1Advertising has been forecast at£2.2m,an increase of 59%over
the 1987level, whilst overriders, which have in the majority of
cases been identified against particular suppliers, have increased
from£4.75m1.5% of sales) to £5.79m 1.6% of sales).

8.2Long term loan interest has been calculated on the loan figures
shown on the forecast Balance Sheet based on interest rates which
reduce from11.7% to 11.3% in the course of the forecast year
(present interest rate payable is 11.125%).

8.3 The other overheads are forecast to increase by inflation of
approximately5.2% and by a further approximately £1.25m covering
inter alia £370,000computer services,£78,000 training costs,
£300,000 warehouse/motor wages & expenses costs,£460,000 Head
Office Salaries and £25,000relief and trainee costs. A major
reduction of £160,000 in respect of pension contributions has
been forecast on the assumption that the board approves a
reduction in the Scheme funding rate arising as a result of
recent Revenue changes.

Extraordinary Items

An amount of £500,000 in respect of 'take over' defence costs has been
included.

10.Balance Sheet

Taxation has been estimated on forecast net profits and capital
expenditure at an effective rate of 35%.Long term loans have been
projected as increasing from£6m at the start of the year to £9.5m by
the end of the year. The stock/creditor ratio is expected to increase
to183.5by April1988.

ll. Earnings per share

Forecast earnings per share are 18.9p based on a 34.6%actual tax charge;
based on a tax charge of 35% the earning per share figure becomes 18.8p.
On actual tax charge this is an increase of 43.5%.

12.Sensitivity

11.1From the above analysis it can be seen that the major sensitive
areas are sales inflation, sales volume and gross margins.
Sensitivity can be assessed below the following calculations
under each of the above headings.

11.2Sales inflation

For each movement in inflation of 0.1%gross profit and net profit
would adjust by £57,000. An increase of 1% would therefore cause
net profits to increase by £570,000.This assumes that cost
inflation does not increase by a comparable amount.