Budget Presentation Worksheet by o83B6OQ

VIEWS: 0 PAGES: 14

									Car Enhancers, LLC.
2006 FINANCIAL SALES PLAN

                          JAN-06         FEB-06       MAR-06       APR-06       MAY-06        JUN-06       JUL-06       AUG-06          SEP-06       OCT-06       NOV-06        DEC-06        TOTAL

       Audio

Basic
 Units                           300           300          450          550        1,250         1,300        1,800        1,300             750          300        1,200         2,500        12,000
 Price per Unit               $95.00        $95.00       $95.00       $95.00       $95.00        $95.00       $95.00       $95.00          $95.00       $95.00       $95.00        $95.00        $95.00
 Total Sales                  $28,500       $28,500      $42,750      $52,250     $118,750      $123,500     $171,000     $123,500         $71,250      $28,500     $114,000      $237,500    $1,140,000
 Mat'l Cost per Unit           $50.00       $50.00       $50.00       $50.00        $50.00       $50.00       $50.00        $50.00         $50.00       $50.00        $50.00        $50.00       $50.00
 Total Mat'l Cost             $15,000      $15,000      $22,500      $27,500       $62,500      $65,000      $90,000       $65,000        $37,500      $15,000       $60,000      $125,000     $600,000    52.6%

Deluxe
 Units                            150          200          225          275          575           650          900          650             375          150          600         1,250         6,000
 Price per Unit               $195.00      $195.00      $195.00      $195.00      $195.00       $195.00      $195.00      $195.00         $195.00      $195.00      $195.00       $195.00       $195.00
 Total Sales                   $29,250      $39,000      $43,875      $53,625     $112,125      $126,750     $175,500     $126,750         $73,125      $29,250     $117,000      $243,750    $1,170,000
 Mat'l Cost per Unit           $95.00       $95.00       $95.00       $95.00        $95.00       $95.00       $95.00        $95.00         $95.00       $95.00        $95.00        $95.00       $95.00
 Total Mat'l Cost             $14,250      $19,000      $21,375      $26,125       $54,625      $61,750      $85,500       $61,750        $35,625      $14,250       $57,000      $118,750     $570,000    48.7%


       Video

LCD
 Units                             60           75           90          110           235          260          360           260            150           60           240          500         2,400
 Price per Unit               $250.00      $250.00      $250.00      $250.00       $250.00      $250.00      $250.00       $250.00        $250.00      $250.00       $250.00      $250.00       $250.00
 Total Sales                   $15,000      $18,750      $22,500      $27,500       $58,750      $65,000      $90,000       $65,000        $37,500      $15,000       $60,000     $125,000      $600,000
 Mat'l Cost per Unit          $123.00      $123.00      $123.00      $123.00       $123.00      $123.00      $123.00       $123.00        $123.00      $123.00       $123.00       $123.00      $123.00
 Total Mat'l Cost              $7,380       $9,225      $11,070      $13,530       $28,905      $31,980      $44,280       $31,980        $18,450       $7,380       $29,520       $61,500     $295,200    49.2%

Plasma
  Units                            15           25           23           28            58           65           85            65             38           15            60           125          601
  Price per Unit              $600.00      $601.00      $602.00      $603.00       $604.00      $605.00      $606.00       $607.00        $608.00      $609.00       $610.00       $611.00      $606.80
  Total Sales                   $9,000      $15,025      $13,545      $16,583       $35,032      $39,325      $51,510       $39,455        $22,800       $9,135       $36,600       $76,375     $364,385
 Mat'l Cost per Unit          $290.00      $290.00      $290.00      $290.00       $290.00      $290.00      $290.00       $290.00        $290.00      $290.00       $290.00       $290.00      $290.00
 Total Mat'l Cost              $4,350       $7,250       $6,525       $7,975       $16,820      $18,850      $24,650       $18,850        $10,875       $4,350       $17,400       $36,250     $174,145    47.8%


        Total

 Units                            525          600          788          963         2,118        2,275        3,145         2,275          1,313          525         2,100         4,375       21,001
 Ave. Price/Unit              $155.71      $168.79      $155.77      $155.80       $153.28      $155.86      $155.17       $155.91        $155.94      $155.97       $156.00       $156.03      $155.92
 Total Sales                   81,750      101,275      122,670      149,958       324,657      354,575      488,010       354,705        204,675       81,885       327,600       682,625    $3,274,385
 Ave. Mat'l Cost/Unit          $78.06       $84.13       $78.06       $78.06        $76.89       $78.06       $77.72        $78.06         $78.06       $78.06        $78.06        $78.06        $78.06
 Total Mat'l Cost             $40,980      $50,475      $61,470      $75,130      $162,850     $177,580     $244,430      $177,580       $102,450      $40,980      $163,920      $341,500    $1,639,345   50.1%




                1/31/2013 7:04 PM                                                                                                1/14                                                                              d717a066-6e63-4b51-9dad-2082a0e4c286.xls
Car Enhancers, LLC.
MANUFACTURING DEPARTMENT
2006 BUDGET
                                       2006     2006     2006     2006     2006     2006     2006     2006     2006     2006     2006     2006     2006
                                       JAN      FEB      MAR      APR      MAY      JUN      JUL      AUG      SEP      OCT      NOV      DEC      YEAR

WAGES                                   4,231    3,846    4,423    3,846    4,423    4,231    4,038    4,423    4,038    4,231    4,231    4,038    50,000
          WAGES                         4,231    3,846    4,423    3,846    4,423    4,231    4,038    4,423    4,038    4,231    4,231    4,038    50,000

TOTAL WAGES                             4,231    3,846    4,423    3,846    4,423    4,231    4,038    4,423    4,038    4,231    4,231    4,038    50,000



FRINGES
          PAYROLL TAXES                 1,472    1,360    1,309     952     1,040     907      589      660      589      631      603      561     10,673
          FRINGES - FICA                  617      574      646     574       646     631      589      660      589      631      603      561      7,320
          FRINGES -FEDERAL UC              65       51       32      20         0       0        0        0        0        0        0        0        168
          FRINGES -STATE UC               791      735      631     358       394     276        0        0        0        0        0        0      3,185

          GROUP INSURANCE               1,000    1,000    1,000    1,000    1,000    1,000    1,000    1,000    1,000    1,000    1,000    1,000    12,000
          FRINGES - HEALTH INSURAN      1,000    1,000    1,000    1,000    1,000    1,000    1,000    1,000    1,000    1,000    1,000    1,000    12,000

          WORKMEN'S COMP                 500      500      500      500      500      500      500      500      500      500      500      500      6,000
          FRINGES - WORKERS COMP         500      500      500      500      500      500      500      500      500      500      500      500      6,000

          GENERAL LIABILITY             1,130    1,130    1,130    1,130    1,130    1,130    1,130    1,130    1,130    1,130    1,130    1,130    13,560
          PROPERTY INSURANCE EXPEN        765      765      765      765      765      765      765      765      765      765      765      765     9,180
          LIABILITY INSURANCE EXPE        365      365      365      365      365      365      365      365      365      365      365      365     4,380

          VAC, HOLIDAY, SICK ACCRUAL     381      381      381      381      381      381      381      381      381      381      381      381      4,568
          FRINGES - VACATION PAY         381      381      381      381      381      381      381      381      381      381      381      381      4,568

TOTAL FRINGES                           4,483    4,371    4,320    3,962    4,050    3,918    3,599    3,671    3,599    3,642    3,614    3,571    46,801



EXPENSES
        SUPPLIES                          400      400      400      400      400      400      400      400      400      400      400      400     4,800
        REPAIRS/MAINTENANCE             1,000    1,000    1,000    1,000    1,000    1,000    1,000    1,000    1,000    1,000    1,000    1,000    12,000
        GAS                               650      650      650      650      650      650      650      650      650      650      650      650     7,800
        ELECTRIC                        4,500    4,500    4,500    4,500    4,500    4,500    4,500    4,500    4,500    4,500    4,500    4,500    54,000
        DEPRECIATION                    7,000    7,000    7,000    7,000    7,000    7,000    7,000    7,000    7,000    7,000    7,000    7,000    84,000
        RENT EXPENSE                   10,250   10,250   10,250   10,250   10,250   10,250   10,250   10,250   10,250   10,250   10,250   10,250   123,000

TOTAL EXPENSES                         23,800   23,800   23,800   23,800   23,800   23,800   23,800   23,800   23,800   23,800   23,800   23,800   285,600



TOTAL MANUFACTURING EXPENSE            32,514   32,017   32,543   31,609   32,274   31,948   31,438   31,894   31,438   31,673   31,645   31,410   382,401
     Key: Fields to Update/Change
          Calculated Fields

                                                   Days in Month        22              20             23           20           23           22           21           23           21           22           22           21          260
                                                                       2006            2006           2006         2006         2006         2006         2006         2006         2006         2006         2006         2006         2006
                                                                       Jan             Feb            Mar          Apr          May          Jun           Jul         Aug          Sep          Oct          Nov          Dec          Year

WAGES                                   Salary
Operatns Manufacturing Manager      $     50,000                   $    4,231      $    3,846     $    4,423   $    3,846   $    4,423   $    4,231   $    4,038   $    4,423   $    4,038   $    4,231   $    4,231   $    4,038   $     50,000
          Open                      $        -                     $      -        $      -       $      -     $      -     $      -     $      -     $      -     $      -     $      -     $      -     $      -     $      -     $        -
                                                                   $    4,231      $    3,846     $    4,423   $    3,846   $    4,423   $    4,231   $    4,038   $    4,423   $    4,038   $    4,231   $    4,231   $    4,038   $     50,000


PAYROLL TAXES
        FICA-MED & SS                                              $    90,000 <-----FICA Maximum
          Manufacturing Manager                                    $      324      $      294     $      338   $      294   $      338   $      324   $      309   $      338   $      309   $      324   $      324   $      309   $      3,825
          Open                                                     $      -        $      -       $      -     $      -     $      -     $      -     $      -     $      -     $      -     $      -     $      -     $      -     $        -
                                                                   $      324      $      294     $      338   $      294   $      338   $      324   $      309   $      338   $      309   $      324   $      324   $      309   $      3,825

          FEDERAL UC                                               $     7,000            0.8%    <-----FUTA Maximum and Rate
          Manufacturing Manager                                    $          34   $         22    $       -   $      -   $        -     $      -     $      -     $      -     $      -     $      -     $      -     $      -     $              56
          Open                                                     $      -        $       -       $       -   $      -   $        -     $      -     $      -     $      -     $      -     $      -     $      -     $      -     $          -
                                                                   $          34   $         22    $       -   $      -   $        -     $      -     $      -     $      -     $      -     $      -     $      -     $      -     $              56


          STATE UC                                                 $    10,500            9.8%    <-----SUTA Maximum and Rate
          Manufacturing Manager                                    $      415      $      377      $      237 $       -   $        -     $      -     $      -     $      -     $      -     $      -     $      -     $      -     $      1,029
          Open                                                     $      -        $       -       $       -   $      -   $        -     $      -     $      -     $      -     $      -     $      -     $      -     $      -     $        -
                                                                   $      415      $      377      $      237 $       -   $        -     $      -     $      -     $      -     $      -     $      -     $      -     $      -     $      1,029


GROUP INSURANCE                                                        Monthly Medical
                                                                    Insurance Rates (after
                                                                   employee contribution)
                                                                     Choices      Rates
                                                                         NONE        $0.00
                                        Medical                            HMO $   250.00
                                         Plan                              PPO $   500.00
          Medical                       Choice                     Medical
          Manufacturing Manager          HMO                               250         250               250          250          250          250          250          250          250          250          250          250          3,000
          Open                           NONE                              -            -                -            -            -            -            -            -            -            -            -            -              -
                                                                           250         250               250          250          250          250          250          250          250          250          250          250          3,000
     Key: Fields to Update/Change
          Calculated Fields

                                                           Workdays in Month        21              20            22           20           22           22           20           23           20           22           20           18           250
                                                                                   2006            2006          2006         2006         2006         2006         2006         2006         2006         2006         2006         2006         2006
                                                                                   Jan             Feb           Mar          Apr          May          Jun           Jul         Aug          Sep          Oct          Nov          Dec          Year

DIRECT LABOR - EMPLOYEES                 Hourly Rate
D-Labor Laborer 1                         $    11.42                           $    1,919      $    1,827    $    2,010   $    1,827   $    2,010   $    2,010   $    1,827   $    2,101   $    1,827   $    2,010   $    1,827   $    1,644   $    22,840
D-Labor Laborer 2                         $    11.42                           $    1,919      $    1,827    $    2,010   $    1,827   $    2,010   $    2,010   $    1,827   $    2,101   $    1,827   $    2,010   $    1,827   $    1,644   $    22,840
D-Labor (employee name) - start date      $      -                             $      -        $      -      $      -     $      -     $      -     $      -     $      -     $      -     $      -     $      -     $      -     $      -     $       -
DIRECT LABOR TOTAL                                                             $    3,837      $    3,654    $    4,020   $    3,654   $    4,020   $    4,020   $    3,654   $    4,203   $    3,654   $    4,020   $    3,654   $    3,289   $    45,680




PAYROLL TAXES
        FICA-MED & SS                                                          $    90,000 <-----FICA Maximum
          Laborer 1                                                            $      147      $      140    $      154   $      140   $      154   $      154   $      140   $      161   $      140   $      154   $      140   $      126   $     1,747
          Laborer 2                                                            $      147      $      140    $      154   $      140   $      154   $      154   $      140   $      161   $      140   $      154   $      140   $      126   $     1,747
          (employee name) - start date                                         $      -        $      -      $      -     $      -     $      -     $      -     $      -     $      -     $      -     $      -     $      -     $      -     $       -
          DIRECT LABOR TOTAL                                                   $      294      $      280    $      308   $      280   $      308   $      308   $      280   $      321   $      280   $      308   $      280   $      252   $     3,495

          FEDERAL UC                                                           $     7,000           0.8%    <-----FUTA Maximum and Rate
          Laborer 1                                                            $          15   $        15    $         16 $      10 $        -     $      -     $      -     $      -     $      -     $      -     $      -     $      -     $          56
          Laborer 2                                                            $          15   $        15    $         16 $      10 $        -     $      -     $      -     $      -     $      -     $      -     $      -     $      -     $          56
          (employee name) - start date                                         $      -        $      -       $       -    $    -    $        -     $      -     $      -     $      -     $      -     $      -     $      -     $      -     $      -
          DIRECT LABOR TOTAL                                                   $          31   $        29    $         32 $      20 $        -     $      -     $      -     $      -     $      -     $      -     $      -     $      -     $      112


          STATE UC                                                             $    11,000           9.8%    <-----SUTA Maximum and Rate
          Laborer 1                                                            $      188      $     179      $      197 $      179 $         197   $      138   $      -     $      -     $      -     $      -     $      -     $      -     $     1,078
          Laborer 2                                                            $      188      $     179      $      197 $      179 $         197   $      138   $      -     $      -     $      -     $      -     $      -     $      -     $     1,078
          (employee name) - start date                                         $      -        $      -       $      -    $     -    $        -     $      -     $      -     $      -     $      -     $      -     $      -     $      -     $       -
          DIRECT LABOR TOTAL                                                   $      376      $     358      $      394 $      358 $         394   $      276   $      -     $      -     $      -     $      -     $      -     $      -     $     2,156




GROUP INSURANCE                                                                    Monthly Medical
                                                                                Insurance Rates (after
                                                                               employee contribution)
                                                                                 Choices      Rates
                                                                                     NONE        $0.00
                                          Medical                                      HMO $   250.00
                                           Plan                                        PPO $   500.00
Medical                                   Choice                               Medical
          Laborer 1                           HMO                                      250         250              250          250          250          250          250          250          250          250          250          250         3,000
          Laborer 2                            PPO                                     500         500              500          500          500          500          500          500          500          500          500          500         6,000
          (employee name) - start date        NONE                                     -           -                -            -            -            -            -            -            -            -            -            -             -
          DIRECT LABOR TOTAL                                                   $       750 $       750       $      750   $      750   $      750   $      750   $      750   $      750   $      750   $      750   $      750   $      750   $     9,000




VACATION, HOLIDAY,SICK                                 HOURS
                                         Holidays      Vacation   Sick
          Laborer 1                          88          80           32              190             190           190          190          190          190          190          190          190          190          190          190         2,284
          Laborer 2                          88          80           32              190             190           190          190          190          190          190          190          190          190          190          190         2,284
          (employee name) - start date       88          80           32              -               -             -            -            -            -            -            -            -            -            -            -             -
          DIRECT LABOR TOTAL                                                   $      381      $      381    $      381   $      381   $      381   $      381   $      381   $      381   $      381   $      381   $      381   $      381         4,568
Car Enhancers, LLC.
SELLING DEPARTMENT
2006 BUDGET
                                     2006       2006       2006     2006       2006       2006       2006       2006       2006       2006       2006       2006       2006
                                     JAN        FEB        MAR      APR        MAY        JUN        JUL        AUG        SEP        OCT        NOV        DEC        YEAR

WAGES                                16,923     15,385     17,692   15,385     17,692     16,923     16,154     17,692     16,154     16,923     16,923     16,154     200,000
          WAGES                      16,923     15,385     17,692   15,385     17,692     16,923     16,154     17,692     16,154     16,923     16,923     16,154     200,000

TOTAL WAGES                          16,923     15,385     17,692   15,385     17,692     16,923     16,154     17,692     16,154     16,923     16,923     16,154     200,000



FRINGES
          PAYROLL TAXES               3,052      1,589      1,353    1,177      1,353      1,295      1,236      1,353      1,003       639        639        610       15,300
          FRINGES - FICA              1,295      1,177      1,353    1,177      1,353      1,295      1,236      1,353      1,003       639        639        610       13,130
          FRINGES -FEDERAL UC           107          5          0        0          0          0          0          0          0         0          0          0          112
          FRINGES -STATE UC           1,651        407          0        0          0          0          0          0          0         0          0          0        2,058

          GROUP INSURANCE              500        500        500      500        500        500        500        500        500        500        500        500        6,000
          FRINGES - HEALTH INSURAN     500        500        500      500        500        500        500        500        500        500        500        500        6,000

          401(k) MATCH                 400        400        400      400        400        400        400        400        400        400        400        400        4,800
          FRINGES - 401(k) MATCH       400        400        400      400        400        400        400        400        400        400        400        400        4,800

          MISCELLANEOUS                     0          0   10,000          0          0          0          0          0          0          0          0          0    10,000
          FRINGES -VACATION                 0          0        0          0          0          0          0          0          0          0          0          0         0
          FRINGES -TUITION                  0          0        0          0          0          0          0          0          0          0          0          0         0
          FRINGES -OTHER                    0          0   10,000          0          0          0          0          0          0          0          0          0    10,000

TOTAL FRINGES                         3,952      2,489     12,253    2,077      2,253      2,195      2,136      2,253      1,903      1,539      1,539      1,510      36,100



GENERAL
          TRAVEL & ENTERTAINMENT      7,125      7,125      7,125    7,125      7,125      7,125      7,125      7,125      7,125      7,125      7,125      7,125      85,500
          TRAVEL EXPENSE              6,000      6,000      6,000    6,000      6,000      6,000      6,000      6,000      6,000      6,000      6,000      6,000      72,000
          MEALS AND ENTERTAINMENT     1,125      1,125      1,125    1,125      1,125      1,125      1,125      1,125      1,125      1,125      1,125      1,125      13,500

          ADVERTISING                 4,000      4,000      4,000    4,000      4,000      4,000      4,000      4,000      4,000      4,000      4,000      4,000      48,000
          ADVERTISING                 4,000      4,000      4,000    4,000      4,000      4,000      4,000      4,000      4,000      4,000      4,000      4,000      48,000

          OTHER EXPENSE               2,900      2,900      2,900    2,900      2,900      2,900      2,900      2,900      2,900      2,900      2,900      2,900      34,800
          CONVENTION                  1,000      1,000      1,000    1,000      1,000      1,000      1,000      1,000      1,000      1,000      1,000      1,000      12,000
          RENT EXPENSE                  750        750        750      750        750        750        750        750        750        750        750        750       9,000
          SUPPLIES - MISC               250        250        250      250        250        250        250        250        250        250        250        250       3,000
          TELEPHONE                       0          0          0        0          0          0          0          0          0          0          0          0           0
          SAMPLES                       500        500        500      500        500        500        500        500        500        500        500        500       6,000
          PROFESSIONAL SERVICES           0          0          0        0          0          0          0          0          0          0          0          0           0
          DUES & SUBSCRIPTIONS          150        150        150      150        150        150        150        150        150        150        150        150       1,800
          MISC                          250        250        250      250        250        250        250        250        250        250        250        250       3,000

TOTAL GENERAL                        14,025     14,025     14,025   14,025     14,025     14,025     14,025     14,025     14,025     14,025     14,025     14,025     168,300



TOTAL SELLING EXPENSE                34,900     31,899     43,971   31,487     33,971     33,143     32,315     33,971     32,082     32,487     32,487     31,689     404,400
    Key: Fields to Update/Change
         Calculated Fields

                                   Work Days/Holidays in Month:        22            20           23           20           23           22           21           23           21           22           22           21          260
                                                                      2006          2006         2006         2006         2006         2006         2006         2006         2006         2006         2006         2006         2006
                                                                      Jan           Feb          Mar          Apr          May          Jun           Jul         Aug          Sep           Oct         Nov          Dec          Year

SALARIES                                     Salary
           VP Sales                      $     125,000            $   10,577    $    9,615   $   11,058   $    9,615   $   11,058   $   10,577   $   10,096   $   11,058   $   10,096   $   10,577   $   10,577   $   10,096   $    125,000
           Salesperson                   $      75,000            $    6,346    $    5,769   $    6,635   $    5,769   $    6,635   $    6,346   $    6,058   $    6,635   $    6,058   $    6,346   $    6,346   $    6,058   $     75,000
           Open                          $         -              $      -      $      -     $      -     $      -     $      -     $      -     $      -     $      -     $      -     $      -     $      -     $      -     $        -
                                                                  $   16,923    $   15,385   $   17,692   $   15,385   $   17,692   $   16,923   $   16,154   $   17,692   $   16,154   $   16,923   $   16,923   $   16,154   $    200,000




PAYROLL TAXES
        FICA-MED & SS                                             $    90,000 <-----FICA Maximum
           VP Sales                                               $      809    $      736   $      846   $      736   $      846   $      809   $      772   $      846   $      540   $      153   $      153   $      146   $      7,393
           Salesperson                                            $      485    $      441   $      508   $      441   $      508   $      485   $      463   $      508   $      463   $      485   $      485   $      463   $      5,738
           Open                                                   $      -      $      -     $      -     $      -     $      -     $      -     $      -     $      -     $      -     $      -     $      -     $      -     $        -
                                                                  $    1,295    $    1,177   $    1,353   $    1,177   $    1,353   $    1,295   $    1,236   $    1,353   $    1,003   $      639   $      639   $      610   $     13,130

           FEDERAL UC                                             $     7,000         0.8%   <-----FUTA Maximum and Rate
           VP Sales                                               $       56    $      -      $       -   $      -   $        -     $      -     $      -     $      -     $      -     $      -     $      -     $      -     $           56
           Salesperson                                            $       51    $        5    $       -   $      -   $        -     $      -     $      -     $      -     $      -     $      -     $      -     $      -     $           56
           Open                                                   $      -      $      -      $       -   $      -   $        -     $      -     $      -     $      -     $      -     $      -     $      -     $      -     $          -
                                                                  $      107    $        5    $       -   $      -   $        -     $      -     $      -     $      -     $      -     $      -     $      -     $      -     $          112


           STATE UC                                               $    10,500         9.8%   <-----SUTA Maximum and Rate
           VP Sales                                               $    1,029    $      -      $       -   $      -   $        -     $      -     $      -     $      -     $      -     $      -     $      -     $      -     $      1,029
           Salesperson                                            $      622    $     407     $       -   $      -   $        -     $      -     $      -     $      -     $      -     $      -     $      -     $      -     $      1,029
           Open                                                   $      -      $      -      $       -   $      -   $        -     $      -     $      -     $      -     $      -     $      -     $      -     $      -     $        -
                                                                       1,651          407             -          -            -            -            -            -            -            -            -            -            2,058




GROUP INSURANCE                                                       Monthly Medical
                                                                   Insurance Rates (after
                                                                   employee contribution)
                                                                    Choices      Rates
                                                                        NONE        $0.00
                                             Medical                      HMO $    250.00
                                              Plan                        PPO $    500.00
           Medical                           Choice               Medical
           VP Sales                           HMO                         250         250           250          250          250          250          250          250          250          250          250          250          3,000
           Salesperson                        HMO                         250         250           250          250          250          250          250          250          250          250          250          250          3,000
           Open                               NONE                        -            -            -            -            -            -            -            -            -            -            -            -              -
                                                                          500         500           500          500          500          500          500          500          500          500          500          500          6,000
Car Enhancers, LLC.
ADMINISTRATIVE DEPARTMENT
2006 BUDGET
                                      2006       2006       2006       2006       2006     2006       2006       2006       2006       2006       2006       2006     2006
                                      JAN        FEB        MAR        APR        MAY      JUN        JUL        AUG        SEP        OCT        NOV        DEC      YEAR

WAGES                                 21,577     19,615     22,558     19,615     22,558   21,577     20,596     22,558     20,596     21,577     21,577     20,596   255,000
          WAGES                       21,577     19,615     22,558     19,615     22,558   21,577     20,596     22,558     20,596     21,577     21,577     20,596   255,000

TOTAL WAGES                           21,577     19,615     22,558     19,615     22,558   21,577     20,596     22,558     20,596     21,577     21,577     20,596   255,000

FRINGES
          PAYROLL TAXES                3,592      2,206      2,009      1,695      1,942    1,711      1,214       821        749        785        785        749     18,260
          FRINGES - FICA               1,651      1,501      1,726      1,501      1,726    1,651      1,214       821        749        785        785        749     14,858
          FRINGES -FEDERAL UC            117         27         18          6          0        0          0         0          0          0          0          0        168
          FRINGES -STATE UC            1,824        678        266        188        217       60          0         0          0          0          0          0      3,234

          GROUP INSURANCE              1,250      1,250      1,250      1,250      1,250    1,250      1,250      1,250      1,250      1,250      1,250      1,250    15,000
          FRINGES - HEALTH INSURAN     1,250      1,250      1,250      1,250      1,250    1,250      1,250      1,250      1,250      1,250      1,250      1,250    15,000

          401(k) MATCH                  600        600        600        600        600      600        600        600        600        600        600        600      7,200
          FRINGES - 401(k) MATCH        600        600        600        600        600      600        600        600        600        600        600        600      7,200

          MISCELLANEOUS                      0          0          0          0     500           0          0          0          0          0          0     500      1,000
          FRINGES -TUITION                   0          0          0          0     500           0          0          0          0          0          0     500      1,000
          FRINGES -OTHER                     0          0          0          0       0           0          0          0          0          0          0       0          0

TOTAL FRINGES                          5,442      4,056      3,859      3,545      4,292    3,561      3,064      2,671      2,599      2,635      2,635      3,099    41,460



GENERAL
          TRAVEL & ENTERTAINMENT       1,750      1,750      1,750      1,750      1,750    1,750      1,750      1,750      1,750      1,750      1,750      1,750    21,000
          TRAVEL EXPENSE               1,000      1,000      1,000      1,000      1,000    1,000      1,000      1,000      1,000      1,000      1,000      1,000    12,000
          MEALS AND ENTERTAINMENT        750        750        750        750        750      750        750        750        750        750        750        750     9,000

          PROFIT SHARING EXPENSE       3,000      3,000      3,000      3,000      3,000    3,000      3,000      3,000      3,000      3,000      3,000      3,000    36,000
          PROFIT SHARING EXPENSE -     3,000      3,000      3,000      3,000      3,000    3,000      3,000      3,000      3,000      3,000      3,000      3,000    36,000

          INCENTIVE                    1,000      1,000      1,000      1,000      1,000    1,000      1,000      1,000      1,000      1,000      1,000      1,000    12,000
          BONUS                        1,000      1,000      1,000      1,000      1,000    1,000      1,000      1,000      1,000      1,000      1,000      1,000    12,000

          PROFESSIONAL SERVICES        3,275      3,275      3,275      3,275      3,275    3,275      3,275      3,275      3,275      3,275      3,275      3,275    39,300
          PROF. SERVICES - OTHER         300        300        300        300        300      300        300        300        300        300        300        300     3,600
          PROF. SERVICES - AUDIT       1,500      1,500      1,500      1,500      1,500    1,500      1,500      1,500      1,500      1,500      1,500      1,500    18,000
          PROF. SERVICES - LEGAL         300        300        300        300        300      300        300        300        300        300        300        300     3,600
          PROF. SERVICES - PAYROLL       250        250        250        250        250      250        250        250        250        250        250        250     3,000
          PROF. SERVICES - 401(K)        325        325        325        325        325      325        325        325        325        325        325        325     3,900
          PROF. SERVICES - HUMAN R       250        250        250        250        250      250        250        250        250        250        250        250     3,000
          PROF. SERVICES - I/T REL       350        350        350        350        350      350        350        350        350        350        350        350     4,200

          DUES & SUBSCRIPTIONS          500        500        500        500        500      500        500        500        500        500        500        500      6,000
          DUES & SUBSCRIPTIONS          500        500        500        500        500      500        500        500        500        500        500        500      6,000

          SUPPLIES                     1,150      1,150      1,150      1,150      1,150    1,150      1,150      1,150      1,150      1,150      1,150      1,150    13,800
          SUPPLIES - MISC                175        175        175        175        175      175        175        175        175        175        175        175     2,100
          SUPPLIES - IT EQUIP            300        300        300        300        300      300        300        300        300        300        300        300     3,600
          SUPPLIES - IT EQUIP MAINT      125        125        125        125        125      125        125        125        125        125        125        125     1,500
          SUPPLIES - IT SOFT             300        300        300        300        300      300        300        300        300        300        300        300     3,600
          SUPPLIES - IT SOFT MAIN        250        250        250        250        250      250        250        250        250        250        250        250     3,000

          POSTAGE                       450        450        450        450        450      450        450        450        450        450        450        450      5,400
          POSTAGE                       450        450        450        450        450      450        450        450        450        450        450        450      5,400

          TELEPHONE                     250        250        250        250        250      250        250        250        250        250        250        250      3,000
          TELEPHONE                     250        250        250        250        250      250        250        250        250        250        250        250      3,000

          DEPRECIATION                 2,000      2,000      2,000      2,000      2,000    2,000      2,000      2,000      2,000      2,000      2,000      2,000    24,000
          DEPRECIATION                 2,000      2,000      2,000      2,000      2,000    2,000      2,000      2,000      2,000      2,000      2,000      2,000    24,000

          OTHER EXPENSE                2,350      2,350      2,350      2,350      2,350    2,350      2,350      2,350      2,350      2,350      2,350      2,350    28,200
          RENT EXPENSE                 1,000      1,000      1,000      1,000      1,000    1,000      1,000      1,000      1,000      1,000      1,000      1,000    12,000
          REPAIRS & MAINTENANCE            0          0          0          0          0        0          0          0          0          0          0          0         0
          OTHER OFFICE EXPENSE             0          0          0          0          0        0          0          0          0          0          0          0         0
          TAXES - MISC.                  250        250        250        250        250      250        250        250        250        250        250        250     3,000
          DONATIONS                      100        100        100        100        100      100        100        100        100        100        100        100     1,200
          BAD DEBTS                        0          0          0          0          0        0          0          0          0          0          0          0         0
          MISC                         1,000      1,000      1,000      1,000      1,000    1,000      1,000      1,000      1,000      1,000      1,000      1,000    12,000

TOTAL GENERAL                         15,725     15,725     15,725     15,725     15,725   15,725     15,725     15,725     15,725     15,725     15,725     15,725   188,700



TOTAL ADMIN EXPENSE                   42,744     39,397     42,142     38,885     42,575   40,863     39,385     40,953     38,920     39,937     39,937     39,420   485,160
    Key: Fields to Update/Change
         Calculated Fields

                                   Work Days/Holidays in Month:        22            20           23           20           23           22           21           23           21           22           22           21          260
                                                                      2006          2006         2006         2006         2006         2006         2006         2006         2006         2006         2006         2006         2006
                                                                      Jan           Feb          Mar          Apr          May          Jun           Jul         Aug          Sep           Oct         Nov          Dec          Year

SALARIES                                     Salary
           President                     $     165,000            $   13,962    $   12,692   $   14,596   $   12,692   $   14,596   $   13,962   $   13,327   $   14,596   $   13,327   $   13,962   $   13,962   $   13,327   $    165,000
           Accountant                    $      65,000            $    5,500    $    5,000   $    5,750   $    5,000   $    5,750   $    5,500   $    5,250   $    5,750   $    5,250   $    5,500   $    5,500   $    5,250   $     65,000
           Receptionist                  $      25,000            $    2,115    $    1,923   $    2,212   $    1,923   $    2,212   $    2,115   $    2,019   $    2,212   $    2,019   $    2,115   $    2,115   $    2,019   $     25,000
           Open                          $         -              $      -      $      -     $      -     $      -     $      -     $      -     $      -     $      -     $      -     $      -     $      -     $      -     $        -
                                                                  $   21,577    $   19,615   $   22,558   $   19,615   $   22,558   $   21,577   $   20,596   $   22,558   $   20,596   $   21,577   $   21,577   $   20,596   $    255,000




PAYROLL TAXES
        FICA-MED & SS                                             $    90,000 <-----FICA Maximum
           President                                              $    1,068    $      971   $    1,117   $      971   $    1,117   $    1,068   $      658   $      212   $      193   $      202   $      202   $      193   $      7,973
           Accountant                                             $      421    $      383   $      440   $      383   $      440   $      421   $      402   $      440   $      402   $      421   $      421   $      402   $      4,973
           Receptionist                                           $      162    $      147   $      169   $      147   $      169   $      162   $      154   $      169   $      154   $      162   $      162   $      154   $      1,913
           Open                                                   $      -      $      -     $      -     $      -     $      -     $      -     $      -     $      -     $      -     $      -     $      -     $      -     $        -
                                                                  $    1,651    $    1,501   $    1,726   $    1,501   $    1,726   $    1,651   $    1,214   $      821   $      749   $      785   $      785   $      749   $     14,858

           FEDERAL UC                                             $     7,000         0.8%   <-----FUTA Dollar Maximum and Tax Rate
           President                                              $       56    $      -      $       -   $        -   $      -     $      -     $      -     $      -     $      -     $      -     $      -     $      -     $           56
           Accountant                                             $       44    $       12    $       -   $        -   $      -     $      -     $      -     $      -     $      -     $      -     $      -     $      -     $           56
           Receptionist                                           $       17    $       15    $        18 $          6 $      -     $      -     $      -     $      -     $      -     $      -     $      -     $      -     $           56
           Open                                                   $      -      $      -      $       -   $        -   $      -     $      -     $      -     $      -     $      -     $      -     $      -     $      -     $          -
                                                                  $      117    $       27    $        18 $          6 $      -     $      -     $      -     $      -     $      -     $      -     $      -     $      -     $          168


           STATE UC                                               $    11,000         9.8%   <-----SUTA Dollar Maximum and Tax Rate
           President                                              $    1,078    $      -      $       -   $        -   $      -     $      -     $      -     $      -     $      -     $      -     $      -     $      -     $      1,078
           Accountant                                             $      539    $     490     $        49 $        -   $      -     $      -     $      -     $      -     $      -     $      -     $      -     $      -     $      1,078
           Receptionist                                           $      207    $     188     $      217 $        188 $      217 $          60   $      -     $      -     $      -     $      -     $      -     $      -     $      1,078
           Open                                                   $      -      $      -      $       -   $        -   $      -     $      -     $      -     $      -     $      -     $      -     $      -     $      -     $        -
                                                                       1,824          678            266          188        217            60          -            -            -            -            -            -            3,234




GROUP INSURANCE                                                       Monthly Medical
                                                                   Insurance Rates (after
                                                                   employee contribution)
                                                                    Choices      Rates
                                                                     NONE           $0.00
                                             Medical                  HMO     $ 250.00
                                              Plan                    PPO     $ 500.00
           Medical                           Choice               Medical
           President                           PPO                        500         500           500          500          500          500          500          500          500          500          500          500          6,000
           Accountant                         HMO                         250         250           250          250          250          250          250          250          250          250          250          250          3,000
           Receptionist                        PPO                        500         500           500          500          500          500          500          500          500          500          500          500          6,000
           Open                               NONE                        -            -            -            -            -            -            -            -            -            -            -            -              -
                                                                        1,250       1,250         1,250        1,250        1,250        1,250        1,250        1,250        1,250        1,250        1,250        1,250         15,000
                                                                Car Enhancers, LLC
                                                              Capital Spending Budget
                                                                        2006


                                       YEAR      Jan-06    Feb-06         Mar-06    Apr-06    May-06    Jun-06      Jul-06    Aug-06    Sep-06    Oct-06    Nov-06     Dec-06   Comment
DIES, TOOLS, ETC.
  Mold for New Plasma Unit         $    50,000             $ 15,000                                     $ 15,000                                            $ 20,000
  Mold for New LCD Unit            $    17,000                                                                     $ 17,000
                                   $       -
                                   $       -
MACHINERY & EQUIPMENT
  Automated Packaging Machine      $     5,000                                                $ 5,000
  Stockroom Shelving               $     3,500                                                                                                    $ 3,500
                                   $       -
                                   $       -
LEASEHOLD IMPROVEMENTS

                                   $       -
                                   $       -
                                   $       -
FURNITURE & FIXTURES

  Chairs for Manufacturing Floor   $     1,900                                      $ 1,900
                                   $       -
                                   $       -
COMPUTER HARDWARE

  Servers                          $     5,000                        $     2,500                                                       $ 2,500
  Laptops                          $     4,000   $ 2,000                                                           $ 2,000
                                   $       -
                                   $       -
COMPUTER SOFTWARE

  Internet Commerce Software       $     8,000                                                          $ 8,000
  Misc Network Software            $     6,000             $ 3,000                                                            $ 3,000


TOTAL - PLAN                       $   100,400   $ 2,000   $ 18,000   $     2,500   $ 1,900   $ 5,000   $ 23,000   $ 19,000   $ 3,000   $ 2,500   $ 3,500   $ 20,000   $    -
                                                                                                Car Enhancers, LLC
                                                                                            Forecasted Income Statement
                                                                                                        2006


                                        Jan-06      Feb-06      Mar-06      Apr-06       May-06       Jun-06       Jul-06           Aug-06     Sep-06      Oct-06      Nov-06     Dec-06     Total
Sales
Sales                                     81,750     101,275     122,670     149,958      324,657      354,575         488,010       354,705    204,675      81,885     327,600    682,625   3,274,385   100.0%
Discount & Allowances                        -           -           -           -            -            -               -             -          -           -           -          -           -       0.0%
Net Sales                                 81,750     101,275     122,670     149,958      324,657      354,575         488,010       354,705    204,675      81,885     327,600    682,625   3,274,385   100.0%

Cost of Goods Sold
Material                                  40,980      50,475      61,470      75,130      162,850      177,580         244,430       177,580    102,450      40,980     163,920    341,500   1,639,345   50.1%
Labor                                      3,837       3,654       4,020       3,654        4,020        4,020           3,654         4,203      3,654       4,020       3,654      3,289      45,680    1.4%
Burden                                    32,514      32,017      32,543      31,609       32,274       31,948          31,438        31,894     31,438      31,673      31,645     31,410     382,401   11.7%
Total Cost of Goods Sold                  77,331      86,146      98,033     110,393      199,143      213,548         279,522       213,676    137,542      76,672     199,219    376,199   2,067,426   63.1%

Gross Profit                               4,419      15,129      24,637      39,564      125,514      141,027         208,488       141,029     67,133       5,213     128,381    306,426   1,206,959   36.9%
   Gross Margin                             5.4%       14.9%       20.1%       26.4%        38.7%        39.8%           42.7%         39.8%      32.8%        6.4%       39.2%      44.9%       36.9%

Selling & Admin
Selling Expense                           34,900      31,899      43,971      31,487       33,971       33,143          32,315        33,971     32,082      32,487      32,487     31,689    404,400    12.4%
Administrative Expense                    42,744      39,397      42,142      38,885       42,575       40,863          39,385        40,953     38,920      39,937      39,937     39,420    485,160    14.8%
Total General, Selling & Admin            77,644      71,296      86,113      70,372       76,546       74,006          71,700        74,924     71,003      72,424      72,424     71,109    889,560    27.2%

Operating Profit (Loss)                  (73,225)    (56,167)    (61,476)    (30,808)      48,968       67,021         136,788        66,105     (3,870)    (67,211)     55,957    235,317    317,399     9.7%

Other Expenses (Income)
Interest Expense                           5,968       3,857       2,645       3,796        4,559        5,627           5,785         4,883      4,003       3,618       4,561      4,125     53,427     1.6%
Management Fee                             3,750       3,750       3,750       3,750        3,750        3,750           3,750         3,750      3,750       3,750       3,750      3,750     45,000     1.4%
Miscellaneous Expense (Income)               925         925         925         925          925          925             925           925        925         925         925        925     11,100     0.3%
Total Other Expenses (Income)             10,643       8,532       7,320       8,471        9,234       10,302          10,460         9,558      8,678       8,293       9,236      8,800    109,527     3.3%

Net Income (Loss)                        (83,868)    (64,699)    (68,796)    (39,278)      39,733       56,720         126,328        56,547    (12,548)    (75,505)     46,721    226,517    207,872     6.3%


                        Inerest Check      6,248       4,135       2,912       4,051        4,775        5,813           5,974         5,068      4,183       3,789       4,722      4,282     55,953




                                                                            d717a066-6e63-4b51-9dad-2082a0e4c286.xls    1/31/2013   7:04 PM
               Car Enhancers, LLC                                                                                                       Car Enhancers, LLC
            Forecasted Balance Sheet                                                                                                 Forecasted Balance Sheet
                      2005                                                                                                                     2006


                                       Dec-05                                        Jan-06       Feb-06       Mar-06       Apr-06        May-06        Jun-06      Jul-06       Aug-06       Sep-06       Oct-06       Nov-06       Dec-06

Assets                                              Assets

Current Assets                                      Current Assets
Cash                                      33,252    Cash                               30,000       30,000       30,000       30,000         30,000       30,000       30,000       30,000      30,000       30,000        30,000       30,000
Accounts Receivable-Trade                984,000    Accounts Receivable-Trade         805,088      192,176      235,142      286,259        498,345      713,194      884,714      884,851     587,349      300,888       429,959    1,060,736
Inventory                                218,192    Inventory                          90,855      110,646      135,234      293,130        319,644      439,974      319,644      184,410      73,764      295,056       614,700      250,000
Prepaid Computer Maintenance               5,000    Prepaid Computer Maintenance        4,750        4,500        4,250        4,000          6,750        6,500        6,250        6,000       5,750        5,500         5,250        5,000
Prepaid Property Insurance                 9,180    Prepaid Property Insurance          8,415        7,650        6,885        6,120          5,355        4,590        3,825        3,060       2,295        1,530           765        9,180
Prepaid Liability Insurance                4,380    Prepaid Liability Insurance         4,015        3,650        3,285        2,920          2,555        2,190        1,825        1,460       1,095          730           365        4,380
Prepaid Workers Comp Insur                 6,000    Prepaid Workers Comp Insur          5,500        5,000        4,500        4,000          3,500        3,000        2,500        2,000       1,500        1,000           500        6,000
Security Deposit                          12,257    Security Deposit                   12,257       12,257       12,257       12,257         12,257       12,257       12,257       12,257      12,257       12,257        12,257       12,257
Other Current Assets                         -      Other Current Assets                  -            -            -            -              -            -            -            -           -            -             -            -
Total Current Assets                   1,272,261    Total Current Assets              960,880      365,879      431,553      638,686        878,406    1,211,705    1,261,015    1,124,038     714,010      646,961     1,093,796    1,377,553

Fixed Assets                                        Fixed Assets
Gross Fixed Assets                     1,023,351    Gross Fixed Assets               1,025,351    1,043,351    1,045,851    1,047,751     1,052,751    1,075,751    1,094,751    1,097,751    1,100,251    1,103,751    1,123,751    1,123,751
Accumulated Depreciation                (727,293)   Accumulated Depreciation          (736,293)    (745,293)    (754,293)    (763,293)     (772,293)    (781,293)    (790,293)    (799,293)    (808,293)    (817,293)    (826,293)    (835,293)
Net Fixed Assets                         296,058    Net Fixed Assets                   289,058      298,058      291,558      284,458       280,458      294,458      304,458      298,458      291,958      286,458      297,458      288,458

Total Assets                           1,568,319    Total Assets                     1,249,938     663,937      723,111      923,144      1,158,864    1,506,163    1,565,473    1,422,496    1,005,968     933,419     1,391,254    1,666,011




Liabilities & Equity                                Liabilities & Equity

Current Liabilities                                 Current Liabilities
LaSalle - Revolver                       676,057    LaSalle - Revolver                585,798       42,057      219,186      427,310        436,585      738,479      528,576     466,937      262,978      392,520       542,960      260,530
Current Portion Long-Term Debt           100,000    Current Portion Long-Term Debt    100,000      100,000      100,000      100,000        100,000      100,000      100,000     100,000      100,000      100,000       100,000      100,000
Accounts Payable                         232,812    Accounts Payable                   86,058      105,998      129,087      157,773        341,985      372,918      513,303     372,918      215,145       86,058       344,232      717,150
Deposits Received                            -      Deposits Received                     -            -            -            -              -            -            -           -            -            -             -            -
Accrued Interest                             -      Accrued Interest                      -            -            -            -              -            -            -           -            -            -             -            -
Accrued Professional Fee                  18,000    Accrued Professional Fee           19,500       21,000        4,500        6,000          7,500        9,000       10,500      12,000       13,500       15,000        16,500       18,000
Accrued Warranty Reserve                     -      Accrued Warranty Reserve              -            -            -            -              -            -            -           -            -            -             -            -
Accrued Wages                              8,500    Accrued Wages                       8,500        8,500        8,500        8,500          8,500        8,500        8,500       8,500        8,500        8,500         8,500        8,500
Accrued Bonus                             12,000    Accrued Bonus                      13,000       14,000        3,000        4,000          5,000        6,000        7,000       8,000        9,000       10,000        11,000       12,000
Accrued Vacation-Office                    4,630    Accrued Vacation-Office             4,630        4,630        4,630        4,630          4,630        4,630        4,630       4,630        4,630        4,630         4,630        4,630
Accrued Vac/Sick-Hourly                      820    Accrued Vac/Sick-Hourly               820          820          820          820            820          820          820         820          820          820           820          820
Total Current Liabilities              1,052,819    Total Current Liabilities         818,306      297,005      469,723      709,033        905,020    1,240,347    1,173,329     973,805      614,573      617,528     1,028,642    1,121,630

Long-Term Liabilities                               Long-Term Liabilities
LaSalle - Term                          250,000     LaSalle - Term                    250,000      250,000      225,000      225,000        225,000      200,000     200,000      200,000      175,000      175,000      175,000      150,000
Total Long-Term Liabilities             250,000     Total Long-Term Liabilities       250,000      250,000      225,000      225,000        225,000      200,000     200,000      200,000      175,000      175,000      175,000      150,000

Equity                                              Equity
Capital                                  50,000     Capital                            50,000        50,000       50,000       50,000        50,000       50,000      50,000       50,000       50,000       50,000       50,000       50,000
Retained Earnings                       138,423     Retained Earnings                 215,500       215,500      215,500      215,500       215,500      215,500     215,500      215,500      215,500      215,500      215,500      215,500
Profit YTD                              124,318     Profit YTD                        (83,868)     (148,567)    (217,363)    (256,642)     (216,908)    (160,189)    (33,860)      22,687       10,139      (65,366)     (18,644)     207,872
Distributions                           (47,241)    Distributions                         -             -        (19,748)     (19,748)      (19,748)     (39,496)    (39,496)     (39,496)     (59,244)     (59,244)     (59,244)     (78,991)
Total Equity                            265,500     Total Equity                      181,632       116,933       28,389      (10,890)       28,844       65,816     192,144      248,691      216,395      140,891      187,612      394,381

Total Liabilities & Equity             1,568,319    Total Liabilities & Equity       1,249,938     663,937      723,111      923,144      1,158,864    1,506,163    1,565,473    1,422,496    1,005,968     933,419     1,391,254    1,666,011
                                                                                       Car Enhancers, LLC
                                                                                 Forecasted Cash Flow Statement
                                                                                              2006




                                           Jan-06      Feb-06       Mar-06       Apr-06       May-06      Jun-06       Jul-06       Aug-06       Sep-06       Oct-06       Nov-06       Dec-06       TOTAL

Cash Flow from Operations
Net Income (Loss)                           (83,868)    (64,699)     (68,796)     (39,278)     39,733      56,720      126,328       56,547       (12,548)     (75,505)      46,721      226,517     207,872

Depreciation                                  9,000       9,000        9,000        9,000        9,000       9,000        9,000        9,000        9,000        9,000        9,000        9,000     108,000

Accounts Receivable-Trade                   178,913    612,911       (42,966)     (51,117)    (212,086)   (214,848)    (171,521)        (137)     297,502      286,461     (129,071)    (630,777)    (76,736)
Inventory                                   127,337    (19,791)      (24,588)    (157,896)     (26,514)   (120,330)     120,330      135,234      110,646     (221,292)    (319,644)     364,700     (31,808)
Prepaid Computer Maintenance                    250        250           250          250       (2,750)        250          250          250          250          250          250          250           0
Prepaid Property Insurance                      765        765           765          765          765         765          765          765          765          765          765       (8,415)          0
Prepaid Liability Insurance-General             365        365           365          365          365         365          365          365          365          365          365       (4,015)          0
Prepaid Workers Comp Insur                      500        500           500          500          500         500          500          500          500          500          500       (5,500)          0
Security Deposit                                  0          0             0            0            0           0            0            0            0            0            0            0           0
Other Current Assets                              0          0             0            0            0           0            0            0            0            0            0            0           0
Accounts Payable                           (146,754)    19,940        23,090       28,686      184,212      30,933      140,385     (140,385)    (157,773)    (129,087)     258,174      372,918     484,338
Deposits Received                                 0          0             0            0            0           0            0            0            0            0            0            0           0
Accrued Interest                                  0          0             0            0            0           0            0            0            0            0            0            0           0
Accrued Professional Fee                      1,500      1,500       (16,500)       1,500        1,500       1,500        1,500        1,500        1,500        1,500        1,500        1,500           0
Accrued Wages                                     0          0             0            0            0           0            0            0            0            0            0            0           0
Accrued Bonus                                 1,000      1,000       (11,000)       1,000        1,000       1,000        1,000        1,000        1,000        1,000        1,000        1,000           0
Accrued Vacation-Office                           0          0             0            0            0           0            0            0            0            0            0            0           0
Accrued Vac/Sick-Hourly                           0          0             0            0            0           0            0            0            0            0            0            0           0
Net Cash Flow From Operations                89,007    561,741      (129,881)    (206,225)      (4,275)   (234,146)     228,903       64,640      251,207     (126,043)    (130,440)     327,178     691,666



Cash Flows from Investing Activities
Purchase of Fixed Assets                     (2,000)    (18,000)      (2,500)      (1,900)      (5,000)    (23,000)     (19,000)      (3,000)      (2,500)      (3,500)     (20,000)             0   (100,400)



Cash Flows from Financing Activities
Revolver                                    (90,259)   (543,741)     177,128     208,125         9,275    301,894      (209,903)     (61,640)    (203,959)    129,543       150,440     (282,430)    (415,527)
Term Loan                                         0           0      (25,000)          0             0    (25,000)            0            0      (25,000)          0             0      (25,000)    (100,000)
Capital                                           0           0            0           0             0          0             0            0            0           0             0            0            0
Distributions                                     0           0      (19,748)          0             0    (19,748)            0            0      (19,748)          0             0      (19,748)     (78,991)
Net Cash Flows from Financing Activities    (90,259)   (543,741)     132,381     208,125         9,275    257,146      (209,903)     (61,640)    (248,707)    129,543       150,440     (327,178)    (594,518)

Net Incr (Decr) in Cash                      (3,252)            0            0            0         (0)            0            0            0            0            0            0            0     (3,252)

Cash at Beginning of Month                  33,252      30,000        30,000      30,000       30,000      30,000       30,000       30,000       30,000       30,000        30,000       30,000      33,252
Cash at End of Month                        30,000      30,000        30,000      30,000       30,000      30,000       30,000       30,000       30,000       30,000        30,000       30,000      30,000




FYI…
   REVOLVER - BEG. OF PERIOD               676,057     585,798        42,057     219,186      427,310     436,585      738,479      528,576      466,937      262,978       392,520      542,960

   REVOLVER - END OF PERIOD                585,798      42,057       219,186     427,310      436,585     738,479      528,576      466,937      262,978      392,520       542,960      260,530
                                                                      Car Enhancers, LLC
                                                                Forecasted Availability Statement
                                                                             2006




                            Jan-06      Feb-06      Mar-06      Apr-06      May-06       Jun-06      Jul-06      Aug-06      Sep-06      Oct-06      Nov-06      Dec-06

INVENTORY
INVENTORY                     90,855     110,646     135,234     293,130      319,644      439,974    319,644     184,410      73,764     295,056     614,700     250,000
BORROWING BASE, VALUE 50%     45,428      55,323      67,617     146,565      159,822      219,987    159,822      92,205      36,882     147,528     307,350     125,000




ACCOUNTS RECEIVABLE
ACCOUNTS RECEIVABLE          805,088     192,176     235,142     286,259      498,345      713,194    884,714     884,851     587,349     300,888     429,959    1,060,736
BORROWING BASE, VALUE 85%    684,324     163,350     199,871     243,320      423,593      606,215    752,007     752,123     499,247     255,755     365,465      901,626




LOAN AVAILABILITY
MAXIMUM BORROWING LIMIT     1,000,000   1,000,000   1,000,000   1,000,000   1,000,000    1,000,000   1,000,000   1,000,000   1,000,000   1,000,000   1,000,000   1,000,000
AVAILABLE BORROWING LIMIT     729,752     218,673     267,488     389,885     583,415      826,202     911,829     844,328     536,129     403,283     672,815   1,000,000

LESS: LOAN BALANCE           585,798      42,057     219,186     427,310      436,585      738,479    528,576     466,937     262,978     392,520     542,960     260,530
AVAILABILITY                 143,954     176,616      48,302     (37,425)     146,830       87,723    383,253     377,391     273,151      10,763     129,855     739,470


BORROWING CAPACITY           729,752     218,673     267,488     389,885      583,415      826,202    911,829     844,328     536,129     403,283     672,815    1,026,626
                                                                                                                                   Car Enhancers, LLC
                                                                                                                                  Forecasted Covenants
                                                                                                                                       2005 - 2006


Covenants
                                                                                       2005                                                                                                                     2006
                                 3/31/2005                      6/30/2005                              9/30/2005                       12/31/2005                   3/31/2006                   6/30/2006                       9/30/2006                    12/31/2006
                             Qtr         4 Qtrs.            Qtr         4 Qtrs.                    Qtr         4 Qtrs.             Qtr         4 Qtrs.          Qtr          4 Qtrs.        Qtr         4 Qtrs.             Qtr         4 Qtrs.          Qtr         4 Qtrs.
Income                  $   (182,322)      N/A          $    54,321       N/A                 $   135,540        N/A          $   188,367 $ 195,906        $   (217,363) $ 160,865      $    57,175 $ 163,718          $   170,328 $ 198,506        $   197,733 $ 207,872
Depr & Amort            $     25,000       N/A          $    25,000       N/A                 $    25,000        N/A          $    25,000 $ 100,000        $     27,000       102,000   $    27,000 $ 104,000          $    27,000 $ 106,000        $    27,000 $ 108,000
Interest                $     12,000       N/A          $    12,900       N/A                 $    13,035        N/A          $    11,975 $       49,910   $     12,471 $ 50,381        $    13,982        51,462      $    14,670 $       53,097   $    12,305 $       53,427
Adjustments             $         -        N/A          $       -         N/A                 $        -         N/A          $        -     $       -     $         -     $      -     $       -     $       -        $        -    $        -     $        -     $       -
EBITDA                  $   (145,322) $        -        $    92,221 $         -               $   173,575 $          -        $   225,342 $ 345,816        $   (177,893) $ 313,245      $    98,156 $ 319,181          $   211,998 $ 357,603        $   237,038 $ 369,299


Interest                $    12,000          N/A        $    12,900          N/A              $    13,035          N/A        $    11,975   $    49,910    $    12,471    $  50,381     $    13,982   $    51,462      $    14,670   $    53,097    $    12,305   $     53,427
Principal Pymts         $    25,000          N/A        $    25,000          N/A              $    25,000          N/A        $    25,000   $ 100,000      $    25,000      100,000     $    25,000   $ 100,000        $    25,000   $   100,000    $    25,000   $    100,000
Senior Debt                             $          -                   $           -                         $           -                  $ 1,026,057                   $ 569,186                   $ 1,063,479                    $   537,978                  $    510,530

Covenants

Debt Service                #VALUE!     #VALUE!             #VALUE!        #VALUE!                #VALUE!        #VALUE!                            2.31                         2.08                         2.11                           2.34                          2.41
Covenant                                     1.50                               1.50                                  1.50                          1.50                         1.50                         1.50                           1.50                          1.50
EBITDA "cushion"                        #VALUE!                            #VALUE!                               #VALUE!                    $   120,951                   $   87,674                  $    91,987                    $   127,957                  $    139,159

Sr. Interest Coverage       #VALUE!     #VALUE!             #VALUE!        #VALUE!                #VALUE!        #VALUE!                            6.93                        6.22                          6.20                           6.73                          6.91
Covenant                                     4.00                               4.00                                  4.00                          4.00                        4.00                          4.00                           4.00                          4.00
EBITDA "cushion"                        #VALUE!                            #VALUE!                               #VALUE!                    $   146,176                   $ 111,723                   $   113,331                    $   145,214                  $    155,591

Sr. Debt / EBITDA             #DIV/0!       #DIV/0!          #DIV/0!       #DIV/0!                 #DIV/0!       #DIV/0!                            2.97                        1.82                          3.33                           1.50                          1.38
Covenant                                         3.50                            3.50                                  3.50                         3.50                        3.50                          3.50                           3.50                          3.50
EBITDA "cushion"                        $        -                     $         -                           $         -                    $    52,657                   $ 150,621                   $    15,329                    $   203,896                  $    223,434

Maximum Borrowing                       $          -                   $           -                         $           -                  $ 1,210,356                   $ 1,096,358                 $ 1,117,132                    $ 1,251,612                  $ 1,292,548
Borrowing "cushion"                     $          -                   $           -                         $           -                  $ 184,299                     $ 527,173                   $    53,653                    $ 713,635                    $ 782,018




                                                                                                                 d717a066-6e63-4b51-9dad-2082a0e4c286.xls1/31/20137:04 PM                                                                                         14

								
To top