Docstoc

Company Profile Samples - Excel

Document Sample
Company Profile Samples - Excel Powered By Docstoc
					SOURCE INTERLINK COMPANIES, INC.
Company     Circuit City
20.0     Company Profile
                                                Feb 29 2008 FYE    last   year


                                                                          FYE 2/28/09                                                  FYE 2/28/08                                                       FYE 2/28/07
In Millions                                       May 31        Aug 31      Nov 30      Feb 28                May 31      Aug 31         Nov 30        Feb 28                  May 31       Aug 31         Nov 30      Feb 28
                                                   Q1            Q2          Q3           Q4       Year        Q1          Q2             Q3            Q4         Year         Q1           Q2             Q3          Q4                Year

Revenue                                              2,301                                                      2,486       2,644           2,964        3,650     11,744        2,597        2,839          3,102              3,892     12,430
Cost Of Revenue                                      1,823                                                      1,925       2,098           2,398        2,897      9,318        1,961        2,163          2,413              2,964      9,501
Gross Profit                                           478           -           -            -           -       560         546             566          754      2,426          636          676            689                928      2,928
Operating Expenses                                     640                                                        648         678             708          762      2,796          634          663            721                916      2,934
Operating Income                                      (162)          -           -            -           -       (88)       (132)           (142)          (8)      (371)           1           13            (32)                12         (5)
Interest Income (expense)                              -                                                            6           4               2            5         17            7            6              5                  9         26
Other Income (expense )                                  (3)                                                       28          65             (68)           7         32           (3)          (7)            12                (32)       (31)
Income From Operations                                (165)          -           -            -           -       (55)        (63)           (208)           4       (321)           5           11            (16)               (11)       (10)

Gross Margin %                                    20.8%         #DIV/0!     #DIV/0!     #DIV/0!   #DIV/0!     22.5%       20.7%           19.1%        20.6%       20.7%       24.5%        23.8%           22.2%      23.8%              23.6%
Operating Income %                                -7.0%         #DIV/0!     #DIV/0!     #DIV/0!   #DIV/0!     -3.5%       -5.0%           -4.8%        -0.2%       -3.2%        0.1%         0.5%           -1.0%       0.3%               0.0%
Income From Operations %                          -7.2%         #DIV/0!     #DIV/0!     #DIV/0!   #DIV/0!     -2.2%       -2.4%           -7.0%         0.1%       -2.7%        0.2%         0.4%           -0.5%      -0.3%              -0.1%


Current Ratio:
          Current Assets                             2,349                                                      2,668       2,847           3,773        2,440      2,440        2,874        2,845          3,978              2,884      2,884
          Current Liabilities                        1,691                                                      1,599       1,862           2,980        1,606      1,606        2,166        1,729          2,876              1,714      1,714
                     RATIO                             1.39     #DIV/0!     #DIV/0!     #DIV/0!   #DIV/0!         1.67        1.53            1.27         1.52       1.52         1.33         1.64           1.38               1.68       1.68

Quick Ratio:
          Cash                                          92                                                        364         424             483          297        297          634          600            898                739        739
          Marketable Securities                        -                                                          -           -               -            -          -            -            -              -                  -          -
          Receivables                                  307                                                        342         305             447          331        331          212          303            421                383        383
          Current Liablities                         1,691                                                      1,599       1,862           2,980        1,606      1,606        2,166        1,729          2,876              1,714      1,714
                     RATIO                            0.18      #DIV/0!     #DIV/0!     #DIV/0!   #DIV/0!        0.44        0.39            0.31         0.39       0.39         0.39         0.52           0.46               0.65       0.65

Total Debt:

              Short Term ( Includes revolver)              67                                                      12              8              29       12       11.582          30           39             42                  7      7.162


              Long term                                    61                                                      49          51                 52       57             57        50           48             47                50      50.487


Free Cash Flow

              Operating Activities                                                                               (255)        122              26           61        (46)        (151)          82            288                 98        316
              Less:      Capex                         (40)                                                       (66)        (82)            (98)         (80)      (325)         (41)         (72)          (103)               (70)      (286)
                         Stock Div                                                                                  (7)         (7)             (7)          (6)      (27)           (3)          (3)            (7)                (7)      (20)
                         Acq of Business                                                                          -           -               -            -          -            -            -              -                  -          -

              Free Cash Flow                           (40)          -           -            -           -      (327)         33             (79)         (25)      (398)        (195)              7         178                21          11



Debt Coverage Ratio:
         Operarting Activities                         -             -           -            -           -      (255)        122              26           61        (46)        (151)          82            288                 98        316
         Total Liabilities                                                                                      2,128       2,401           3,561        2,243      2,243        2,166        2,215          3,351              2,216      2,216
                      RATIO                       #DIV/0!       #DIV/0!     #DIV/0!     #DIV/0!   #DIV/0!       (0.12)       0.05            0.01         0.03      (0.02)       (0.07)        0.04           0.09               0.04       0.14




                                                                          FYE 2/28/09                                                  FYE 2/28/08                                                       FYE 2/28/07
                                                  May 31        Aug 31      Nov 30      Feb 28                May 31      Aug 31         Nov 30        Feb 28                  May 31       Aug 31         Nov 30      Feb 28
                                                   Q1            Q2          Q3           Q4       Year        Q1          Q2             Q3            Q4         Year         Q1           Q2             Q3          Q4                Year

Adjusted Operating Income:
          Operating Income:                           (162)          -           -            -           -       (88)       (132)           (142)          (8)      (371)              1        13            (32)               12          (5)
          Add:
          Asset Impairment - Goodwill                                                                                                                       26            26                                                       92            92
SOURCE INTERLINK COMPANIES, INC.
Company     Circuit City
20.0    Company Profile


Adjusted Operating Income:                     (162)         -             -               -                -              (88)        (132)           (142)         18         (345)         1        13          (32)        104      87


Payment Terms:
         Average Industry Days                   60                                                                         60           60               60          60                     60         60          60           60
                   late beyond term              10                                                                         10           10               10          10                     10         10          10           10

           Average Source Days                   60                                                                   NA          NA                      60          60                NA        NA          NA          NA
                     late beyond term             7                                                                   NA          NA                       7           7                NA        NA          NA          NA

Cash Usage:
         Cash (Increase) Decrease              205                                                                         (29)         19               63         102          155         76        (96)        150         (305)   (175)
         Loan Increase ( Decrease)              59                                                                                                                                11

Credit Facility                                1300                                                                        500          500              500        1300        1300
Less
Borrowings                                       55                                                                          5            0               20           0            0
Letters of Credit                                49                                                                         58           58               54          50           50
Total Outstanding                               104              0             0               0                0           63           58               74          50           50         0          0           0            0       0

Availability                                   1196              0             0               0                0          437          442              426        1250        1250          0          0           0            0       0

Credit Facility Notes                   Credit Facility Expires January 2013                                                                   Amended         Due to Borrowing Base
                                        Actual Availibility of $963M                                                                           Credit Facility Formulas, Actual
                                        Expects "double digit borrowings by the end of the second quarter                                      to $1.3B        Availibility was $968M
                                        and no borrowings by the end of the third quarter (due to $80M tax benefit)                                            At 2/29/08

				
DOCUMENT INFO
Description: Company Profile Samples document sample