Docstoc

Profit and Loss Vehicle Excel

Document Sample
Profit and Loss Vehicle Excel Powered By Docstoc
					VEHICLE SALES - Detailed Analysis of Unit Sales & Gross Profit                                                                                                                                   January-08

MONTHLY RETAIL SALES SUMMARY

                          Pending Deliveries                    Delivered Units                            Total Reportable Sales                   Trend Analysis                      Forecasted Variance
New Vehicles            # Units       Gross Profit        # Units         Gross Profit           # Units         Gross Profit        PVR            PVR           PVR Gross   # Units     Gross Variance        PVR
 1st New Line             0       $             -           0         $              -             0         $             -    $          -    $         -   $           -     -10       $     (15,000.00) $   1,500.00
 2nd New Line             0       $             -           0         $              -             0         $             -    $          -    $         -   $           -     -45       $     (56,250.00) $   1,250.00
 Finance Income                   $             -                     $              -                       $             -    $          -    $         -   $           -               $     (19,250.00) $    350.00
        Total             0       $             -           0         $              -             0         $             -    $          -                  $           -     -55       $     (90,500.00) $   1,645.45




Used Vehicles           # Units       Gross Profit        # Units         Gross Profit           # Units         Gross Profit        PVR            PVR           PVR Gross   # Units     Gross Variance        PVR
 Cars                     0       $             -           0         $              -             0         $             -    $          -    $         -   $           -     -25       $     (37,500.00) $   1,500.00
 Trucks                   0       $             -           0         $              -             0         $             -    $          -    $         -   $           -     -20       $     (20,000.00) $   1,000.00
 Finance Income                   $             -                     $              -                       $             -    $          -    $         -   $           -               $     (18,000.00) $    400.00
        Total             0       $             -           0         $              -             0         $             -    $          -                  $           -     -45       $     (75,500.00) $   1,677.78


Total Variable Sales      0       $             -           0         $              -             0         $             -    $          -                  $           -     -100      $    (166,000.00) $   1,660.00




MONTHLY FORECASTED VALUES                                                     SALESPERSON PERFORMANCE

New Vehicles            # Units       Average PVR     Gross Profit                                                Total Ups         Cancelled   Write-Up          Call Back   Pending         Delivered     Delivery %
 1st New Line             10      $        1,500.00   $   15,000.00          House                                    0                                                                                         0.00%
 2nd New Line             45      $        1,250.00   $   56,250.00          Sales Person 1                           0                                                                                         0.00%
 Finance Income                   $          350.00   $   19,250.00          Sales Person 2                           0                                                                                         0.00%
        Total             55      $        1,645.45   $   90,500.00          Sales Person 3                           0                                                                                         0.00%
                                                                             Sales Person 4                           0                                                                                         0.00%
Used Vehicles           # Units       Average PVR     Gross Profit           Sales Person 5                           0                                                                                         0.00%
 Cars                     25      $        1,500.00   $   37,500.00          Sales Person 6                           0                                                                                         0.00%
 Trucks                   20      $        1,000.00   $   20,000.00          Sales Person 7                           0                                                                                         0.00%
 Finance Income                   $          400.00   $   18,000.00          Sales Person 8                           0                                                                                         0.00%
        Total             45      $        1,677.78   $   75,500.00          Sales Person 9                           0                                                                                         0.00%
                                                                             Sales Person 10                          0                                                                                         0.00%
Total Variable Sales     100                          $ 166,000.00           Sales Person 11                          0                                                                                         0.00%
                                                                             Sales Person 12                          0                                                                                         0.00%
                                                                             Sales Person 13                          0                                                                                         0.00%
                                                                             Sales Person 14                          0                                                                                         0.00%
                                                                             Sales Person 15                          0                                                                                         0.00%
                  Reports Designed By                                        Sales Person 16                          0                                                                                         0.00%
                    IntactAuto.com                                           Sales Person 17                          0                                                                                         0.00%
                                                                             Sales Person 18                          0                                                                                         0.00%
                                                                             Split Deal-Detail                        0                                                                                         0.00%
                                                                            Performance Totals                        0                0            0                 0          0               0              0.00%
Finance & Insurance Performance Analysis                                                                                               January-08                          Reports Designed By
                                                                                                                                                                                  IntactAuto.com

1st New Line                                                                                                              2nd New Line
                            Count                            Count                                                                                    Count                               Count
 Total Sales Leads            0          Deliveries            0                0.00%                                      Total Sales Leads            0            Deliveries             0                0.00%


 # of Turnovers               0            0.00%                                                                           # of Turnovers               0              0.00%
 # of W aiting or Denied      0            0.00%                                                                           # of W aiting or Denied      0              0.00%


 Pending Status             Count       Gross Profit       % of Sales                                                      Pending Status             Count         Gross Profit        % of Sales
 # Pending Transactions       0                        -     0.00%                                                         # Pending Transactions       0                           -     0.00%


 Delivered Status           Count       Gross Profit       Per Counter      % of Deliveries                                Delivered Status           Count         Gross Profit        Per Counter      % of Deliveries
 Finance Reserve              0                        -                -       0.00%                                      Finance Reserve              0                           -                -       0.00%
 Warranty Income              0                        -                -       0.00%                                      Warranty Income              0                           -                -       0.00%
 Insurance - L & D            0                        -                -       0.00%                                      Insurance - L & D            0                           -                -       0.00%
 Aftermarket Sales            0                        -                -       0.00%                                      Aftermarket Sales            0                           -                -       0.00%


Total Gross Profit - Delivered Units                   -      PVR                         -                               Total Gross Profit - Delivered Units                      -      PVR                         -




Used Vehicles                                                                                                             Department Summary
                            Count                            Count                                                                                    Count                               Count
 Total Sales Leads            0          Deliveries            0                0.00%                                      Total Sales Leads            0            Deliveries             0                0.00%


 # of Turnovers               0            0.00%                                                                           # of Turnovers               0              0.00%
 # of W aiting or Denied      0            0.00%                                                                           # of W aiting or Denied      0              0.00%


 Pending Status             Count       Gross Profit       % of Sales                                                      Pending Status             Count         Gross Profit        % of Sales
 # Pending Transactions       0                        -     0.00%                                                         # Pending Transactions       0                           -     0.00%


 Delivered Status           Count       Gross Profit       Per Counter      % of Deliveries                                Delivered Status           Count         Gross Profit        Per Counter      % of Deliveries
 Finance Reserve              0                        -                -       0.00%                                      Finance Reserve              0                           -                -       0.00%
 Warranty Income              0                        -                -       0.00%                                      Warranty Income              0                           -                -       0.00%
 Insurance - L & D            0                        -                -       0.00%                                      Insurance - L & D            0                           -                -       0.00%
 Aftermarket Sales            0                        -                -       0.00%                                      Aftermarket Sales            0                           -                -       0.00%


Total Gross Profit - Delivered Units                   -      PVR                         -                               Total Gross Profit - Delivered Units                      -      PVR                         -



Forecast Comparision
                                    Total Reportable Sales                                    Sales Trend Analysis                                               Forecasted Variance
                            Unit            Total                                                                                                      Unit       Total $ Variance
                            Sales       Gross Profit       PVR                                 PVR       $ Variance                                    Sales        Gross Profit           PVR
 New Vehicle Sales            0                        -                -                            -                -                                 -55                 (19,250)             350
 Used Vehicle Sales           0                        -                -                            -                -                                 -45                 (18,000)             400
   Grand Total                0                        -                -                                             -                                -100                 (37,250)             373
Marketing Mix & Lead Source Analysis                                                                        IntactAuto.com                                                           January-08

                                                                                                                                                     Gross
1st New Line                                                                                                     Marketing Cost Per                                       Gross Profit Analysis
                                                                                                                                                     Profit
                        Allocated Cost   # Leads   Write-Up   Call Back   Cancelled   Pending   Delivered        Lead Cost       Per-Delivery       Per-Delivery       Revenue            Profit/Loss   ROI
 Unknown                $          -       0          0          0           0          0          0         $           -   $             -    $             -    $             -    $             -     0.0%
 Walk-In                $          -       0          0          0           0          0          0         $           -   $             -    $             -    $             -    $             -     0.0%
 Referral               $          -       0          0          0           0          0          0         $           -   $             -    $             -    $             -    $             -     0.0%
 Newspaper              $          -       0          0          0           0          0          0         $           -   $             -    $             -    $             -    $             -     0.0%
 Other Print Ads        $          -       0          0          0           0          0          0         $           -   $             -    $             -    $             -    $             -     0.0%
 Radio                  $          -       0          0          0           0          0          0         $           -   $             -    $             -    $             -    $             -     0.0%
 Television             $          -       0          0          0           0          0          0         $           -   $             -    $             -    $             -    $             -     0.0%
 Internet Lead          $          -       0          0          0           0          0          0         $           -   $             -    $             -    $             -    $             -     0.0%
 Repeat Customer        $          -       0          0          0           0          0          0         $           -   $             -    $             -    $             -    $             -     0.0%
 Source 10              $          -       0          0          0           0          0          0         $           -   $             -    $             -    $             -    $             -     0.0%
 Source 11              $          -       0          0          0           0          0          0         $           -   $             -    $             -    $             -    $             -     0.0%
 Source 12              $          -       0          0          0           0          0          0         $           -   $             -    $             -    $             -    $             -     0.0%
 Source 13              $          -       0          0          0           0          0          0         $           -   $             -    $             -    $             -    $             -     0.0%
 Source 14              $          -       0          0          0           0          0          0         $           -   $             -    $             -    $             -    $             -     0.0%
 Source 15              $          -       0          0          0           0          0          0         $           -   $             -    $             -    $             -    $             -     0.0%
 Source 16              $          -       0          0          0           0          0          0         $           -   $             -    $             -    $             -    $             -     0.0%
 Source 17              $          -       0          0          0           0          0          0         $           -   $             -    $             -    $             -    $             -     0.0%
 Source 18              $          -       0          0          0           0          0          0         $           -   $             -    $             -    $             -    $             -     0.0%
 Source 19              $          -       0          0          0           0          0          0         $           -   $             -    $             -    $             -    $             -     0.0%
 Source 20              $          -       0          0          0           0          0          0         $           -   $             -    $             -    $             -    $             -     0.0%
 Total Allocated Cost   $          -       0          0          0           0          0          0         $           -   $             -    $             -    $             -    $             -     0.0%


2nd New Line
                        Allocated Cost   # Leads   Write-Up   Call Back   Cancelled   Pending   Delivered        Lead Cost       Per-Delivery       Per-Delivery       Revenue            Profit/Loss   ROI
 Unknown                $          -       0          0          0           0          0          0         $           -   $             -    $             -    $             -    $             -     0.0%
 Walk-In                $          -       0          0          0           0          0          0         $           -   $             -    $             -    $             -    $             -     0.0%
 Referral               $          -       0          0          0           0          0          0         $           -   $             -    $             -    $             -    $             -     0.0%
 Newspaper              $          -       0          0          0           0          0          0         $           -   $             -    $             -    $             -    $             -     0.0%
 Other Print Ads        $          -       0          0          0           0          0          0         $           -   $             -    $             -    $             -    $             -     0.0%
 Radio                  $          -       0          0          0           0          0          0         $           -   $             -    $             -    $             -    $             -     0.0%
 Television             $          -       0          0          0           0          0          0         $           -   $             -    $             -    $             -    $             -     0.0%
 Internet Lead          $          -       0          0          0           0          0          0         $           -   $             -    $             -    $             -    $             -     0.0%
 Repeat Customer        $          -       0          0          0           0          0          0         $           -   $             -    $             -    $             -    $             -     0.0%
 Source 10              $          -       0          0          0           0          0          0         $           -   $             -    $             -    $             -    $             -     0.0%
 Source 11              $          -       0          0          0           0          0          0         $           -   $             -    $             -    $             -    $             -     0.0%
 Source 12              $          -       0          0          0           0          0          0         $           -   $             -    $             -    $             -    $             -     0.0%
 Source 13              $          -       0          0          0           0          0          0         $           -   $             -    $             -    $             -    $             -     0.0%
 Source 14              $          -       0          0          0           0          0          0         $           -   $             -    $             -    $             -    $             -     0.0%
 Source 15              $          -       0          0          0           0          0          0         $           -   $             -    $             -    $             -    $             -     0.0%
 Source 16              $          -       0          0          0           0          0          0         $           -   $             -    $             -    $             -    $             -     0.0%
 Source 17              $          -       0          0          0           0          0          0         $           -   $             -    $             -    $             -    $             -     0.0%
 Source 18              $          -       0          0          0           0          0          0         $           -   $             -    $             -    $             -    $             -     0.0%
 Source 19              $          -       0          0          0           0          0          0         $           -   $             -    $             -    $             -    $             -     0.0%
 Source 20              $          -       0          0          0           0          0          0         $           -   $             -    $             -    $             -    $             -     0.0%
 Total Allocated Cost   $          -       0          0          0           0          0          0         $           -   $             -    $             -    $             -    $             -     0.0%
Variable Sales Departmental Projected Income                                                                                                                                     January-08


            IntactAuto.com                                  Total Variable Sales Department                         1st New Line                 2nd New Line                Used Vehicles Sales
                                                                                    Total Reportable Sales          Projection Values             Projection Values              Projected Income
Gross Profit - Vehicles & Finance                      Estimated Expenses                     0                                 0       0.0%                  0       0.0%                   0      0.0%
 Dealership Variable Expeditures                      Fixed Dollar       % Gross   Dollar Values       % Gross   Fixed Dollar       % Gross    Fixed Dollar       % Gross     Fixed Dollar       % Gross
  Sales Compensation & Other                                         -      0.0%                   -      0.0%                  -       0.0%                  -       0.0%                   -      0.0%
  Deliver Expenses                                                   -      0.0%                   -      0.0%                  -       0.0%                  -       0.0%                   -      0.0%
  Sold Vehicle Policy Work                                           -      0.0%                   -      0.0%                  -       0.0%                  -       0.0%                   -      0.0%
 Total Selling Variable Expenses                                                                   -      0.0%                  -       0.0%                  -       0.0%                   -      0.0%
  Salaries - Owner / Executive Officiers                             -      0.0%                   -      0.0%                  -       0.0%                  -       0.0%                   -      0.0%
  Salaries - Management & Supervision                                -      0.0%                   -      0.0%                  -       0.0%                  -       0.0%                   -      0.0%
  Salaries - Clerical Support Personnel                              -      0.0%                   -      0.0%                  -       0.0%                  -       0.0%                   -      0.0%
  Other - Salaries & Wages                                           -      0.0%                   -      0.0%                  -       0.0%                  -       0.0%                   -      0.0%
  Personnel Absentee Compensation                                    -      0.0%                   -      0.0%                  -       0.0%                  -       0.0%                   -      0.0%
  Supervision - Incentives & Bonuses                                 -      0.0%                   -      0.0%                  -       0.0%                  -       0.0%                   -      0.0%
  Payroll Taxes                                                      -      0.0%                   -      0.0%                  -       0.0%                  -       0.0%                   -      0.0%
  Employee Benefits                                                  -      0.0%                   -      0.0%                  -       0.0%                  -       0.0%                   -      0.0%
  Employee Retirement Benefits                                       -      0.0%                   -      0.0%                  -       0.0%                  -       0.0%                   -      0.0%
 Total Personnel Variable Expenses                                                                 -      0.0%                  -       0.0%                  -       0.0%                   -      0.0%
  Company Vehicle Expenditures                                       -      0.0%                   -      0.0%                  -       0.0%                  -       0.0%                   -      0.0%
  Office Supplies & Forms Expenses                                   -      0.0%                   -      0.0%                  -       0.0%                  -       0.0%                   -      0.0%
  Other Miscellaneous Supplies                                       -      0.0%                   -      0.0%                  -       0.0%                  -       0.0%                   -      0.0%
  E-Commerce/Internet Advertising                                    -      0.0%                   -      0.0%                  -       0.0%                  -       0.0%                   -      0.0%
  Advertisng - Non-Internet Related                                  -      0.0%                   -      0.0%                  -       0.0%                  -       0.0%                   -      0.0%
  Factory Advertising Rebates & Credits                              -      0.0%                   -      0.0%                  -       0.0%                  -       0.0%                   -      0.0%
  Dealership Contributions                                           -      0.0%                   -      0.0%                  -       0.0%                  -       0.0%                   -      0.0%
  Technology Service - Information                                   -      0.0%                   -      0.0%                  -       0.0%                  -       0.0%                   -      0.0%
  Other - Outside Services                                           -      0.0%                   -      0.0%                  -       0.0%                  -       0.0%                   -      0.0%
  Travel and Entertainment                                           -      0.0%                   -      0.0%                  -       0.0%                  -       0.0%                   -      0.0%
  Publications & Membership Dues                                     -      0.0%                   -      0.0%                  -       0.0%                  -       0.0%                   -      0.0%
  Legal & Accounting Expenses                                        -      0.0%                   -      0.0%                  -       0.0%                  -       0.0%                   -      0.0%
  Telephone Expenses                                                 -      0.0%                   -      0.0%                  -       0.0%                  -       0.0%                   -      0.0%
  Dealership Training Expenses                                       -      0.0%                   -      0.0%                  -       0.0%                  -       0.0%                   -      0.0%
  Vehicle Floorplan Interest                                         -      0.0%                   -      0.0%                  -       0.0%                  -       0.0%                   -      0.0%
  Factory Interest Credit - Floorplan                                -      0.0%                   -      0.0%                  -       0.0%                  -       0.0%                   -      0.0%
  Notes Payable - Interest                                           -      0.0%                   -      0.0%                  -       0.0%                  -       0.0%                   -      0.0%
  Inventory Insurance Expense                                        -      0.0%                   -      0.0%                  -       0.0%                  -       0.0%                   -      0.0%
  Bad Debt & Uncollectables                                          -      0.0%                   -      0.0%                  -       0.0%                  -       0.0%                   -      0.0%
  Postage, Shipping & Freight                                        -      0.0%                   -      0.0%                  -       0.0%                  -       0.0%                   -      0.0%
  Miscellaneous Expenses                                             -      0.0%                   -      0.0%                  -       0.0%                  -       0.0%                   -      0.0%
 Total Semi-Fixed Expenditures                                                                     -      0.0%                  -       0.0%                  -       0.0%                   -      0.0%
  Rent                                                               -      0.0%                   -      0.0%                  -       0.0%                  -       0.0%                   -      0.0%
  Leaseholds - Amortization                                          -      0.0%                   -      0.0%                  -       0.0%                  -       0.0%                   -      0.0%
  Real Estate Repairs & Maintenance                                  -      0.0%                   -      0.0%                  -       0.0%                  -       0.0%                   -      0.0%
  Depreciation - Building & Improvements                             -      0.0%                   -      0.0%                  -       0.0%                  -       0.0%                   -      0.0%
  Real Estate - Taxes                                                -      0.0%                   -      0.0%                  -       0.0%                  -       0.0%                   -      0.0%
  Insurance - Building & Improvements                                -      0.0%                   -      0.0%                  -       0.0%                  -       0.0%                   -      0.0%
  Mortgage Interest Expense                                          -      0.0%                   -      0.0%                  -       0.0%                  -       0.0%                   -      0.0%
  Utilities, Gas - Electric, & Water                                 -      0.0%                   -      0.0%                  -       0.0%                  -       0.0%                   -      0.0%
 Sub-Total Real Estate & Rent                                                                      -      0.0%                  -       0.0%                  -       0.0%                   -      0.0%
  Insurance - Other                                                  -      0.0%                   -      0.0%                  -       0.0%                  -       0.0%                   -      0.0%
  Taxes - Federal, State, Local, & Other                             -      0.0%                   -      0.0%                  -       0.0%                  -       0.0%                   -      0.0%
  Equipment Repairs                                                  -      0.0%                   -      0.0%                  -       0.0%                  -       0.0%                   -      0.0%
  Depreciation - Equipment                                           -      0.0%                   -      0.0%                  -       0.0%                  -       0.0%                   -      0.0%
  Equipment Rental Expense                                           -      0.0%                   -      0.0%                  -       0.0%                  -       0.0%                   -      0.0%
 Total Fixed Expenses                                                                              -      0.0%                  -       0.0%                  -       0.0%                   -      0.0%
                               Total Fixed Overhead                                                -      0.0%                  -       0.0%                  -       0.0%                   -      0.0%
                               Total Expenditures
                                                                                                   -      0.0%                  -       0.0%                  -       0.0%                   -      0.0%
                               Department Profit or Loss                                           -    100.0%                  -    100.0%                   -    100.0%                    -    100.0%
Used Vehicle Sales Analysis                                                                                                       January-08

                                                Used Vehicle Age & Gross Profit Analysis
                                             Vehicle Gross            Finance Gross       Total Vehicle       Average Gross
Age of Units Sold       Unit Sales Count
                                                 Profit                  Income           Gross Profit            Profit
       <= 30 Days              0                             -                        -                   -                   -
       31-45 Days              0                             -                        -                   -                   -
       46-60 Days              0                             -                        -                   -                   -
       61-90 Days              0                             -                        -                   -                   -
       90+ Days                0                             -                        -                   -                   -
       Undefined               0                             -                        -                   -                   -


                                                     Vehicle Acquisition Source Analysis
                                   Purchased Units                              New Trade Units               Misc. Units          Department
                           Purchase              Cycle                    New                Cycle                Other              Totals
# of Units Sold                0                     0                      0                     0                 0                    0
Average Age - Days             0                     0                      0                     0                 0                    0

Total Cost & Gross
 Acquisition Cost                      -                     -                        -                   -                   -                    -
 Vehicle Gross Profit                  -                     -                        -                   -                   -                    -
 Total Gross Profit                    -                     -                        -                   -                   -                    -

Average Per Unit
 Acquisition Cost                      -                     -                        -                   -                   -                    -
 Vehicle Gross                         -                     -                        -                   -                   -                    -
 Total Gross Profit                    -                     -                        -                   -                   -                    -

Return On Asset - ROA        0.0%                0.0%                     0.0%               0.0%                 0.0%                 0.0%


                                                                 Used Vehicle Model Year Sales Analysis
                                             % Of Total Unit         Average # of Days    Total Vehicle        Avg. Vehicle         % Of Total $
Model Year Sales          Unit Count
                                                Count                    In-Stock         Gross Profit         Gross Profit         Gross Profit
       2009                    0                 0.0%                       0                             -                   -        0.0%
       2008                    0                 0.0%                       0                             -                   -        0.0%
       2007                    0                 0.0%                       0                             -                   -        0.0%
       2006                    0                 0.0%                       0                             -                   -        0.0%
       2005                    0                 0.0%                       0                             -                   -        0.0%
       2004                    0                 0.0%                       0                             -                   -        0.0%
       2003                    0                 0.0%                       0                             -                   -        0.0%
       <=2002                  0                 0.0%                       0                             -                   -        0.0%


                                                                 Used Vehicle Make - Inventory Sales Mix
                                             % Of Total Unit         Average # of Days    Total Vehicle        Avg. Vehicle         % Of Total $
Sold Used Unit Makes      Unit Count
                                                Count                    In-Stock         Gross Profit            Gross             Gross Profit
       Other                   0                 0.0%                       0                             -                   -        0.0%
       Chevrolet               0                 0.0%                       0                             -                   -        0.0%
       Ford                    0                 0.0%                       0                             -                   -        0.0%
       Toyota                  0                 0.0%                       0                             -                   -        0.0%
       Saturn                  0                 0.0%                       0                             -                   -        0.0%
       Pontiac                 0                 0.0%                       0                             -                   -        0.0%
       Cadillac                0                 0.0%                       0                             -                   -        0.0%
       Chrysler                0                 0.0%                       0                             -                   -        0.0%
       Hyundai                 0                 0.0%                       0                             -                   -        0.0%
       Volkswagen              0                 0.0%                       0                             -                   -        0.0%
       Infiniti                0                 0.0%                       0                             -                   -        0.0%
       Mercury                 0                 0.0%                       0                             -                   -        0.0%
       Mercedes                0                 0.0%                       0                             -                   -        0.0%
       Isuzu                   0                 0.0%                       0                             -                   -        0.0%
       Lincoln                 0                 0.0%                       0                             -                   -        0.0%
       Porsche                 0                 0.0%                       0                             -                   -        0.0%
       Jaguar                  0                 0.0%                       0                             -                   -        0.0%
       Lexus                   0                 0.0%                       0                             -                   -        0.0%
       Jeep                    0                 0.0%                       0                             -                   -        0.0%
       Volvo                   0                 0.0%                       0                             -                   -        0.0%

                                                                    IntactAuto.com
                                                                                                                                                                                                                                1




                                                                                                                                                                                                              Accounting
1st New Line




                                                                                                                                                                                                   Trade-In
                                                                                                                                                                                         Finance
     Contact                     Vehicle Stock                                            Model                       Age of Unit In   Vehicle Gross                       Transaction                                     Total Vehicle
 #                                                                                                Model Description
      Date     Prospect Status          #        Customer - Prospect Name   Salesperson   Year                           Days              Profit      Sales Lead Source   Sub Screen                                      Gross Profit

 1                                                                                                                                              0.00                                                                                0.00
 2                                                                                                                                              0.00                                                                                0.00
 3                                                                                                                                              0.00                                                                                0.00
 4                                                                                                                                              0.00                                                                                0.00
 5                                                                                                                                              0.00                                                                                0.00
 6                                                                                                                                              0.00                                                                                0.00
 7                                                                                                                                              0.00                                                                                0.00
 8                                                                                                                                              0.00                                                                                0.00
 9                                                                                                                                              0.00                                                                                0.00
10                                                                                                                                              0.00                                                                                0.00
11                                                                                                                                              0.00                                                                                0.00
12                                                                                                                                              0.00                                                                                0.00
13                                                                                                                                              0.00                                                                                0.00
14                                                                                                                                              0.00                                                                                0.00
15                                                                                                                                              0.00                                                                                0.00
16                                                                                                                                              0.00                                                                                0.00
17                                                                                                                                              0.00                                                                                0.00
18                                                                                                                                              0.00                                                                                0.00
19                                                                                                                                              0.00                                                                                0.00
20                                                                                                                                              0.00                                                                                0.00
21                                                                                                                                              0.00                                                                                0.00
22                                                                                                                                              0.00                                                                                0.00
23                                                                                                                                              0.00                                                                                0.00
24                                                                                                                                              0.00                                                                                0.00
25                                                                                                                                              0.00                                                                                0.00
26                                                                                                                                              0.00                                                                                0.00
27                                                                                                                                              0.00                                                                                0.00
28                                                                                                                                              0.00                                                                                0.00
29                                                                                                                                              0.00                                                                                0.00
30                                                                                                                                              0.00                                                                                0.00
31                                                                                                                                              0.00                                                                                0.00
32                                                                                                                                              0.00                                                                                0.00
33                                                                                                                                              0.00                                                                                0.00
34                                                                                                                                              0.00                                                                                0.00
35                                                                                                                                              0.00                                                                                0.00
36                                                                                                                                              0.00                                                                                0.00
37                                                                                                                                              0.00                                                                                0.00
38                                                                                                                                              0.00                                                                                0.00
39                                                                                                                                              0.00                                                                                0.00
40                                                                                                                                              0.00                                                                                0.00
41                                                                                                                                              0.00                                                                                0.00
                                                                                                         Reports Designed by IntactAuto.com
Transaction Detail Information
                                                                                               Record #                 0
                 Customer Information                                                          Status
  Name
  Street                                                                                       Contact Date
  City                                                                                         Follow-Up
                                                 State            Zip                          * Projected Delivery                05/13/08
  Phone #                                                                                      Sales
  E-mail
                                                                                               Stock #
* Sale Type                                                                                    * Unit Type

                                                   Finance Department - Revenue Stream

                                  Finance       Warranty        Life &        Aftermarket                         Total Finance                * Financing
* Turnover        Turnover Date
                                  Reserve       Income         Disability        Sales                               Income                       Status
                                        0.00         0.00             0.00             0.00                                 0.00

                                               Monthly $      Term # of
                  Contract Type
                                               Payment         Months        Expiration Date
                                                     0.00         0


                                                           Vehicle Trade-In Information
                                                                                                                  Assigned Stock
     Year               Make       Model                         ACV                             Retail Unit            #                        Status
                                                                      0.00

Trade Comments




                                                 Transaction & Documentation Management



    Trade Title-Release                                       Call Office - Detail
    Insurance Document                                        Document 6
    Incentive Forms                                           Document 7
    DMV Documentation                                         Document 8

Transaction Comments




                                               Gross Profit Analysis & Accounting Verification


Gross Profit Variance Analysis                                                                 Sales Commission
                                  Projected    Accounting                                      Commissionable      $ Commission
                                    Gross        Gross         Variance                           Gross               Payable
  Vehicle Gross Profit                  0.00         0.00             0.00                                 0.00             0.00
  Finance Reserve Income                0.00         0.00             0.00
  Warranty Income                       0.00         0.00             0.00                     Used Vehicle Sales Analysis - Required if Used Vehicle Sale
  Insurances - L & D                    0.00         0.00             0.00                     Vehicle Source          Franchise Source

  Aftermarket Sales                     0.00         0.00             0.00
                                                                                                Inventory Cost      Vehicle Acquisition Date
      Total Gross Profit                0.00         0.00             0.00                          0.00

Gross Profit Comments

				
DOCUMENT INFO
Description: Profit and Loss Vehicle Excel document sample