IntactAuto.com - Free Automotive Excel Downloads

Showroom Management - Daily Sales Log & Gross Profit

These Automotive specific Excel spreadsheets are designed as a time-saving device for both the Sales Manager and Finance Manager to efficiently control the Variable Sales Department.

With the input of a minimal amount of customer information one can obtain access to crucial data to effectively manage their prospective customer sales and deliveries. While preparing the needed information to successfully control inventory, personnel, marketing budget and the Variable Sales department as a whole.

Listed below are some of the Easy to Use spreadsheets within this workbook, you will also find additional interesting & useful reports which are not mentioned.

Daily New & Used Vehicle Sales Log

* Simplified technique to manage your sales floor activity at a glance.
* Interacts as a medium between sales department and accounting department.

Vehicle Sales Gross Profit & Forecasting

* Compares actual, projected and pending sales gross profit to forecast.
* Displays near real-time gross profit totals and sales floor performance numbers.

Finance & Insurance Performance Reports

* Synchronize both front-end & back-end departments within Variable Sales.
* Tracks Finance department total gross profit, total up's and closing percentages.

Sales Lead Sourcing & Marketing Mix Cost Analysis

* Easily manages cost per lead and gross profit per lead source.
* Determine the results of each marketing media, calculating Return On Investment.

Used Vehicle Sales Analysis - Intense & In-depth

* Calculates gross profit per make, model, model year, and vehicle source.
* Tracks inventory age, profitability, plus calculates your real return on investment.

File Size: 5.40 MB, file size is relatively large, to download to desktop requires approximately 1 minute on a high-speed (100+) internet connection.

View Sample Worksheets - PDF View, 7 Pages, doesn't do it justice.

To download document to your desktop, right click on mouse and select,
"Save Target as". Download Worksheet in XLS format

Workbook Updated: May 18, 2008 - Get The Latest Free Excel Download

©Excel must be installed on your system to actively use worksheets.

Most Commonly Asked Questions:
Why after I download your worksheet, I'm not able to access the pages?
The reason is, Excel has within it's program a Security Setting for Macros.
You will need to adjust your setting. This is simply done by opening Excel and on your ToolBar click on "Tools", next click on "Macros", then click on "Security" and set your Security Level to Medium.

How do I use this spreadsheet?
Its a known fact, individuals do not like reading directions, but I've spent an extensive amount of time developing instructions and creating comment boxes throughout this program, please read them. If they don't answer your question it's my fault. E-mail me and I'll be happy to help and update the program to reflect your questions. The intent of this program is to simplify your day not complicate it.

Disclaimer of Warranty.
This software is provided "AS IS" and with all faults. With No expressed warranties, guarantees or conditions. You cannot recover any damages, including consequential, lost profits, special, indirect or incidental damages beyond $ 1.00 US. This software is provided free of charge and you may install and use an unlimited number of copies. You may copy and distribute the software, provided that each copy is complete and unmodified, including this agreement for each user's acceptance. By downloading the worksheet , You accept these terms. This agreement and any amendments require a written statement.

Need Help?
This program is so easy to use that I'll even setup your default page for free.
As always your feedback is important,
E-mail your comments to: ExcelHelp@IntactAuto.com