Prompt:
Generate a 5-year projected revenue vs. internal cost line graph for a startup called AeroVital. Here's the data model:
📊 Assumptions:
Each new client buys 10 drones.
Sale price per drone: $10,000
Manufacturing cost per drone: $4,000
Insurance cost per drone per year: $1,000
Maintenance revenue per client: $24,000/year
Operating overhead (non-manufacturing): $282,000/year
Net revenue per client per year: $124,000
Net profit per client per year: $74,000
📈 Year-by-Year Breakdown:
Year 1:
8 clients
Revenue: 8 × $124,000 = $992,000
Internal costs: 8 × (10 × $5,000) + $282,000 = $682,000
Profit: $310,000
Year 2:
Add 16 new clients
Cumulative: 24 clients
Revenue: 24 × $124,000 = $2,976,000
Internal costs: 24 × (10 × $5,000) + $282,000 = $1,482,000
Profit: $1,494,000
Year 3:
Add 34 new clients
Cumulative: 58 clients
Revenue: 58 × $124,000 = $7,192,000
Internal costs: 58 × (10 × $5,000) + $282,000 = $3,182,000
Profit: $4,010,000
Year 4:
Scale to Boston + Philly
Add 15 clients in BOS, 15 in PHL
Cumulative: 38 (NYC) + 15 (BOS) + 15 (PHL) = 68 clients
Revenue: 68 × $124,000 = $8,432,000
Internal costs: 68 × (10 × $5,000) + $282,000 = $3,682,000
Profit: $4,750,000
Year 5:
Scale to LA + Seattle
Add 30 clients in BOS, 30 in PHL
Cumulative: 40 (NYC) + 30 (BOS) + 30 (PHL) = 100 clients
Revenue: 100 × $124,000 = $12,400,000
Internal costs: 100 × (10 × $5,000) + $282,000 = $5,282,000
Profit: $7,118,000
🧠 Generate this Graph:
X-axis: Year (1 to 5)
Y-axis: Dollars ($)
3 Lines:
Revenue (green)
Internal Cost (red)
Profit (blue)
Label axes, show data points, and include a legend.
Put the actual numbers slightly above each dot