Used Car Dealership - 5 Year Pro-Forma Excel Financial Model
Originally published: 28/03/2018 10:31
Last version published: 23/08/2022 15:41
Publication number: ELQ-48722-10
View all versions & Certificate
certified

Used Car Dealership - 5 Year Pro-Forma Excel Financial Model

A bottom up financial model to forecast the revenue, expenses, and cash flows of a used car dealership startup. Includes 3-statement model and cap table.

Description
Recent Updates: Added a Monthly/Annual Income Statement, Balance Sheet, Cash Flow Statement.


Added new revenue logic to account for how long cars sit on the lot for and this flows through to inventory / sales accordingly. The logic makes for more accurate cash flow planning. Added a cap table as well as improved general formatting conventions and brand new visualizations.


The bottom up approach was used to drive revenues that are based on business logic specific to buying and selling used cars / vehicles. There are 3 different vehicle types and varying cost points on each type. The user is then able to adjust the % markup as well as the amount of vehicles sold per month for each type. You can change the monthly amount expected to be sold in each of the 5 years. Additionally, there is logic that lets you start selling certain car types in later months to improve scaling forecasts.


The startup costs and monthly running cost are determined by a start month and a $ amount per month that can change in each of the 5 years.


Special logic has been added to define how much up-front inventory you will have to purchase and that will run off of your cost of goods sold line item (driven by cost assumptions + the sales count assumptions).


The video and instructions within the model will explain further if needed. There is plenty of summary sheets and visuals to give you a high level look at what the monthly/annual P&L and key metrics look like per what you have modified in the assumptions.

This Best Practice includes
1 Excel template and 1 tutorial video

Acquire business license for $45.00

Add to cart

Add to bookmarks

Discuss

Further information

Provide a cash flow forecast and performance summaries to the user.

When doing projections for a used car dealership startup.

Non margin based business models.


5.0 / 5 (2 votes)

please wait...