Used and New Car Dealership Projection Template

Develop in-depth financial projections for investor discussions and loan applications through this editable Excel template. It incorporates automatically generated 5-year financial statements, over 20 charts displaying vital metrics, and a video tutorial.

How it works?

Template price: $


  • 5 Year Projected Financial Statements
  • CPA Developed & Completely Customizable
  • Video Guide Included
  • Free Support & Projections Review
  • Compatible with Google Sheets

Made by the same team that has helped more than 50,000 founders create projections, this template built specifically for car dealerships will streamline the process

This simple but powerful auto dealership template will generate lender-ready projections in just a couple hours.

Our CPA developed template enables you to create professional projections based on your unique assumptions.

Create investor- and lender-ready projections in hours, not days.

This CPA built car dealership template will walk you through each section of using your information to generate professional grade financial pro formas that are necessary for business plans, business loans, floorplan financing, and investment.

How it works?

Watch a demo of the template

Save time & money - get organized with our template!

Get the car dealership financial projection template now for $99

The template price: $



100% money-back guarantee for 30 days!

 Revenue Projection Template Example

Step 1: Purchase and download the template

After purchase, you will download an unlocked Excel file with a ready-to-use financial projection template for your business model. You can also open the file to use in Google Sheets!

Download Now

Step 2: Enter your assumptions on the input tabs

Car Dealership Projected Revenue

  • Using this template you will be able to craft an accurate revenue projection based upon your customized line up of vehicles and floorplan. The template also allows you to plan income from more than one dealership location, online sales, and, a vehicle service department. Utilizing information like walk in traffic and close rate will allow you to identify your car dealership total revenue as well as cost of goods sold.

Estimate Operating Expenses for a Car Dealership

  • Next, you will be able to input your operating expenses to identify your typical monthly overhead. The first 3 months of the projections allow you to specify specific expenses so you can account for non-recurring expenses. The template comes pre-filled with some common car dealership expenses so you have a solid starting point.

Car Dealership General Assumptions

  • Starting the template you will provide some basic assumptions that will help form the projected balance sheet and other items. Things like fixed assets, loans, starting inventory, AP, AR and investments. Then the car dealership template will calculate more difficult things like amortization, interest expense, and depreciation so you don't have to.

Car Dealership Salaries And Distributions Spreadsheet

  • The salaries section will enable you to plan out all of the staff necessary to make your car dealership run smoothly including the ability to calculate employer taxes, benefits, and if you are planning dividends or owner draws as well.

Step 3: The model is automatically updated based on your assumptions

At a Glance Tab

The at-a-glance tab provides a nice summarized wrap up of the important car dealership financial highlights like break even analysis, 5 year P&L summary, use of funds break down and more.

Car Dealership Financial Pro Forma Statements

The Financial Statements tabs provide you with your financial statements in the following format: the annual formats of the income statement, cash flow statement, and balance sheet; and the monthly breakdowns of those same financial statements. You’ll find too, that our balance sheets automatically balance themselves.

Lender & Investor Friendly Reports

With this template, your basic inputs are utilized to create quality detailed car dealership financial pro-formas for your stakeholders.  The financial statements will be in a standard format that potential investors and lenders are accustomed to seeing.

 Income Projection Chart Example

Tables, charts, graphs and dashboards include:

Tables, charts, graphs and dashboards include:

  • Profit and loss table, at a glance
  • Startup costs graph
  • Industry ratios table
  • ​​Cash generation graph
  • ‍Monthly & Annual income statements, cash flow, and balance sheet reports for five years
  • Profit and loss at a glance table

  • Use of start-up funds graph

  • Key ratios table

  • ​Cash generated from operating activities graph

  • Investor dashboard

  • 5 years of monthly and annual income statement, cash flow and balance sheet reports

Step 4: If you need help, we're here

We can fill out or modify any of the templates we sell, and we’re always happy to answer questions.

When you call us, you can speak directly to the developers of the model, not a call center or customer service representative.

Contact us in the most convenient way for you. We're here to help you

Questions? Get in touch.
Contact Us

What ProjectionHub Customers Think

The cost of the template is estimated at $ 2000

If you hired a CPA to build this template from scratch it would take at least 20 hours of billable time to build a similar template. At an average hourly rate of $100 per hour it would cost you $2,000.

20 hours X $100 = $2,000 value

But we've already done all the work and you don't need to hire a CPA

Save time & money - get organized with our template!

Get the car dealership financial projection template now for $99

The template price: $



100% money-back guarantee for 30 days

Back to Top

Our Projection Protection Guarantee

Love it or Swap it
If the template you purchase is not the perfect fit, our team will help recommend the right template and swap your template for no extra charge. You can rest assured we'll make sure you are using the right template.
Expert Review
After you fill out your template, you can upload your projections to our team where we will do a complete review and then send you a custom video recording of us providing feedback so you can feel confident your projections are investor & lender ready.
See How
Help as You Go
Our team will be standing by so you can get help as you fill out your projection template. Through email and custom video recordings, we will make sure you understand how to complete your projections.
See How

You may also like these templates

The ProjectionHub Team

Grace Cisna, CPA

Before joining ProjectionHub, Grace served as an auditor for a public accounting firm in Indianapolis. There, she audited start-up tech companies, major regional hospitals, public manufacturers and everything in between.

As an auditor, she gained insight to the inner workings of all kinds of business models. Grace is a CPA, has a bachelor’s degrees in Accounting and French and a Master’s of Accountancy all from the University of Iowa, where she also taught introductory accounting classes to undergraduates.

Grace loves to use her accounting expertise to serve as an advisor to her clients, helping them understand what it takes to make a business succeed.

Adam Hoeksema — Co-founder ProjectionHub

Adam is the co-founder of ProjectionHub which is a SaaS web application that helps entrepreneurs create financial projections for their business.

Since 2012, over 40,000 entrepreneurs from around the world have used ProjectionHub to help create financial projections.

Adam also serves as the Executive Director of Bankable. Bankable is a Small Business Administration (SBA) lender that makes loans from $500 to $250,000 to Indiana small businesses that are unable to secure financing from a traditional bank.

Adam has managed the loan program since loan #1 in 2010. Since 2010, Bankable has closed over 1,200 loans totaling over $38,000,000. Adam is an entrepreneur at heart and loves working with entrepreneurs to launch and grow their business.

We are available to help you complete your projections


We'll answer your questions about how the template works


We can help you customize your template, add revenue models, expenses or custom charts, tables and graphs -> with our financial modeling services

Frequently Asked Questions

What type of car dealership should I open?

The two basic options of car dealership types are new car dealership franchises or user car dealerships. While new car dealership franchises will generate more in sales, they also have more red tape, higher expenses to start and maintain inventory, and often come with some confusion from customers that you are in fact a part of the dealer corporation. New car dealerships can also sell used cars. Used car dealerships however have lower startup costs and less ongoing regulation, but you will have to exclusively sell used cards which can impact your margins significantly.

How much does it cost to start a car dealership?

Starting costs for a car dealership will differ significantly depending on if you are an independent used dealership or new franchise dealership. To start an independent used car dealership the biggest expenses will be your property which is typically $0.50 to $4.00 per square foot to rent, your beginning inventory which will be between $25,000 and $100,000 and then the first 3 months of salary for necessary employees. New dealerships have those same cost categories but each will likely be higher including an additional franchise free that can range from $30,000 to $500,000 depending on the brands you will be affiliated with.

What type of licenses are required to open a car dealership?

It is often overlooked what licenses and legal requirements there area for a car dealership to open and continue to operate. Each state or provincial government will require you to apply for a business and dealer's license. You'll likely need to pass a criminal background check from a licensing authority. Go through a training course and inspection from specific brand dealers. Obtain several different dealer license plates and follow full disclosure agreements about your knowledge of mechanical issues of your inventory. You'll also need to acquire insurance which you'll have to provide as well as likely have an auto dealer surety bond agreement in place.

Should my car dealership have a service department?

Service departments can be an expensive addition to a car dealership, but they can prove to become one of the most valuable sources of income and building customer relationships. Most obviously, it is likely your existing customers would use your service department if it is priced reasonably and provides good service so you have a built in audience. Your service center can also generate new potential car purchasing customers by providing good service to non-customers. If done poorly, however, the service department could be costly to your reputation.