Custom Google Sheets System for Car Business

I run a small car flipping business and need a custom Google Sheets system to track inventory, profits, and deal analysis.

The sheet should be clean, simple to use, and mostly plug-and-play so I only have to enter numbers.

Features I need:

1. Inventory Tracker
• VIN
• Vehicle
• Purchase Price
• Auction Fees
• Repair Cost
• Total Cost (auto calculated)
• Status (Bought / Repairing / Listed / Sold)

2. Sales Tracker
• Sold Price
• Profit (auto calculated)
• ROI % (auto calculated)

3. Deal Analyzer
I want to enter:
• Purchase price
• Fees
• Repairs
• Expected sale price

And it calculates:
• Total investment
• Expected profit
• ROI %

4. Partner Profit Split
Automatically calculate a 10% partner split from profit.

5. Dashboard
Show summary metrics:
• Cars purchased
• Cars sold
• Total profit
• Average ROI
• Capital invested in inventory

6. Inventory Turn Time
Track:
• Date purchased
• Date sold
• Days held

The sheet should be clean and easy to use since I will be entering data frequently.

Bonus if you can:
• Use dropdown menus
• Make a simple dashboard with charts
• Keep it organized and scalable

Budget: $100-$200 depending on complexity.

Please show examples of similar Google Sheets or dashboards you have built.